Database Programmer Analyst Resume

SUMMARY

5+ years of experience as PL/SQL - ETL developer in sales and marketing wings of electronics manufacturing industry.
Skilled in Oracle, MySQL Databases, Version controlling tools, HTML, Web Applications, and Amazon Web Services (AWS).
Proficient in data migration, data analysis, data extraction and data loading for databases in distributed, cloud and data warehouse environments.
Hands on experience in Data Modeling, Schema Design and Data warehousing.
Expert in software development under Agile and Waterfall Methodologies.
Fluent in creating and maintaining User Stories, Use case Documents, Business Requirement Document (BRD) and Functional Requirement Document (FRD).
Experience in Java/J2EE web application development with Oracle DB as backbone.

TECHNICAL SKILLS

PL/SQL, ETL Developer
Data Analyst & Reports Specialist
PL/SQL
Java
Unix Scripting
DEVOPS
AWS (EC2, S3, RDS, EBS)
Database (Oracle, SQL Server, MySQL)
Dell - BoomiAtomsphere
JavaScript, Html5, CSS3

PROFESSIONAL EXPERIENCE

Confidential

Database Programmer Analyst

Responsibilities:

Developing back-end modules such as Packages, Functions, Procedures, Triggers, Object types, Collections, Views and Indexes for multi-tier business applications in SQL and PL/SQL.
Develop, Support Client/User requested enhancements for various Reporting / Dashboard environments.
Integrating HTML, CSS, JavaScript in PL/SQL Procedures to capture the activities and operations performed by users on internal sales web applications and browser-based enterprise software products.
Optimize SQL queries which act as backbone for performance of dashboards and tune them using various techniques such as Explain Plan, creating indexes, hints, temporary tables.
Working in co-ordination with frontend design team, Reporting and Analytics team for requirements gathering and providing n Functional Expertise
Build end to end process using Boomi
Oracle 11g, 12c
Build an optimized model to boost performance of dashboards
Agile project management tools like JIRA, Confluence

Confidential

Oracle PL/SQL Developer

Responsibilities:

Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application. Interacted with end users and developers to validate the data model.
Designed and developed the Packages, procedures, functions efficiently in loading, validating and cleansing the data.
Handled process to load data from flat files into huge database of 120 tables. Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
Created Cursors, Collections for maintaining complex integrity constraints and implementing the complex business rules. Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
Involved in the design and development of user interfaces and customization of Reports using Tableau. Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target and worked on Batch scripting, scheduling jobs and monitoring logs.
Worked on Production support for the back-end database and reporting applications. Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
Determined optimal business logic implementations, applying best design patterns. Provided technical support to the user with regard to operational aspects.
Involved in continuous enhancement, optimization and fixing of problems. Documented the design for intuitive understanding and future reference.

Environment: Oracle 10g/11g, PL/SQL, SQL Loader, SQL*Plus, Windows NT 4.0/2000/XP and UNIX Academic Projects College Management System - The system is an automation tool for schools to manage large data. It minimizes the challenges and provides the efficient management system for both staff members and students. Android Apps (Java): - Agram: A simple two player card gamePlayer plays against the computer.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship