SUMMARY

• Over 15+ years of experience in the complete Data warehouse life cycle involving Analysis, Design, Development, Testing and maintenance of Software applications and implementing Data Warehouse applications and Data integration using ETL.
• Strong Knowledge of all phases of Software Development Life Cycle and have worked in large scale projects with incremental deliverables.
• Experience in implementing the simple business rules by creating Informatica transformations, re - usable transformations (Lookups - Connected & Unconnected, Joiner, Union, Sorter, Aggregator, Rank, Normalizer, Filter, Router and Update Strategy).
• Extensively worked on Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Experience in Integration of various data sources like SQL Server, Oracle, Sybase, ODBC connectors & Flat Files.
• Experience in Identifying and Resolving ETL production issues.
• Experience in Maintenance, Enhancements, Performance tuning of ETL Mappings.
• Experience with relational databases such as Oracle 9i/10g, SQL Server, MS Access.
• Strong skills in SQL, PL/SQL packages, functions, stored procedures & triggers.
• Experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Experience in XML parsing and loading tables.
• Designed data model for the data warehouse, business intelligence application.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Experience in External table concepts, SQL*Loader & UTL File concepts.
• Hands on experience in UNIX shell scripting for basic commands and some complex scripting as required.
• Experience in using the Informatica command line utility ‘pmcmd’ to schedule and control sessions and batches.
• Experience in working with various scheduling tools (ESP & CA Autosys).
• Experience in OBIEE tool to build Data model based on business requirements and generating reports to business / IT Customers.
• Documentation of projects for Functional Requirement Specifications (FRS), Use case Specifications, ER-Diagrams, Test Plans, and Test Scripts & Test Cases.
• Team Player; Excellent Interpersonal skills; Ability to work effectively with multiple stakeholders in a project

TECHNICAL SKILLS

Operating Systems: Windows NT, 2000, XP, UNIX

Programming Languages: PL/SQL, Shell Scripting

Databases: Oracle 11g, postgres

Tools: Pl/sql developer, FileZilla, Postico, iTERM Toad 11.6, SQL Navigator, Oracle Developer, OBIEE, Informatica (Power Center 9.1, 8.6.1, 8.1)

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Developer

Responsibilities:

• Developed and modified PL/SQL packages, functions, Procedures, Triggers as per requirement to make new enhancements or to resolve problems.
• Writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements. Performed Tuning and Optimization of SQL statements.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Creation of External Tables to read files from the database file systems.
• Working on Data Extraction, Data Mapping, Data Conversion, and Data Loading process using UNIX Shell scripting, SQL, PL/SQL, and SQL Loader.
• Set up automated system for data loading, tracking and monitoring and error reporting.
• Worked on writing shell scripts to generating files from the procedure in the database, ftp the file to the server, modified several scripts according to the changing needs of the project and client requirements, automate load process, scheduled batch jobs in crontab.
• Work on release calls for all ER and MR production releases to validate the database components.
• Work on ESP scheduling tool to include new or change of application jobs and involves database support for every 2 weeks rotation.
• Along with Code development working on impact analysis of fix, test case preparation and unit testing.
• Work with front end JAVA team to debug the issues and experience in writing Class file and functions which involve the DB calls.

Environment: Oracle 12c, TOAD, Windows 7, Linux, Pl/SQL, SQL, GIT, ESP

Confidential

Senior Database Developer

Responsibilities:

• Developed and modified PL/SQL packages, functions, Procedures, Triggers as per requirement to make new enhancements or to resolve problems.
• Writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements. Performed Tuning and Optimization of SQL statements.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Creation of External Tables to read files from the database file systems.
• Working on Data Extraction, Data Mapping, Data Conversion, and Data Loading process using UNIX Shell scripting, SQL, PL/SQL, and SQL Loader.
• Set up automated system for data loading, tracking and monitoring and error reporting.
• Worked on writing shell scripts to generating files from the procedure in the database, ftp the file to the server, modified several scripts according to the changing needs of the project and client requirements, automate load process, scheduled batch jobs in crontab.
• Work on extracting data from XML and insert into respective tables.
• Along with Code development working on impact analysis of fix, test case preparation and unit testing.
• Work with front end JAVA team to debug the issues and experience in writing Class file and functions which involve the DB calls.

Environment: Oracle 11g, SQL Developer, Windows 7, Linux, Pl/SQL, SQL, GIT.