Summary

• Involved extensively in organizational activities like conducting technical training, participating in submitting technical papers.
• Experience in gathering business requirements, working closely with the clients, identifying their needs and challenges. Translating them to technical specifications. Provide support to the team to understand and resolve queries in the specification.
• Experience in providing estimations, project plan, code reviews and mentoring of team members.
• Knowledge of working on Teradata, Metadata.
• Played variety of roles namely Technical Lead, Module Lead, ETL Architect/Developer, Data Architect, Database Developer, Data Modeler, Data Quality Analyst. Also have exposure to playing Client facing roles in various projects.
• Extensively written Unix Shell Scripts and Batch Scripts for the automation of various ETL jobs.
• Proficient in Design and performance tuning of database applications and ETL jobs. Also have experience in Data profiling and data quality analysis. Knowledge on quality stage.
• Extensive experience in Data base Development with over 6 years of experience in PL/SQL programming In Oracle 9i, Oracle 10g, Data Modeling using tools including ErStudio, Erwin 3.5/3.x Physical and Logical Modeling and Dimensional Modeling Dimensional Tables and Fact Tables and strong understanding of Star schema modeling, Snowflake modeling. Also have worked on ER modeling. Have worked on databases including Oracle 11g,10g,9i, SQL Server Version 2000/2005, DB2 Version 8.2.
• Experience in Data Migration projects in various domains namely Banking and Finance, Insurance.
• Extensive experience working in end to end Data Warehousing projects and Business Intelligence tools including more than 4 years of experience with Ascential DataStage 8.1/7.5.2/7.5.1 Administrator, Manager, Designer, Director , Parallel Extender, Sunopsis V3/ODI, Informatica PowerCenter, Crystal Reports XI.
• Around 7 years of experience in development and implementation of software applications in Data Warehousing and BI Reporting, Application Design Architecture, Dimensional Data Modeling, Database Development.
• Strong analytical, presentation, problem solving and excellent inter-personal skills.

Professional Experience:

Confidential

Role: ETL Architect

Responsibilities:

• Requirements gathering for the project by constant Client Interactions and come up with a suitable design.
• Have meeting with clients to understand requirements and effectively identify data needs and challenges
• Translate the requirements to Technical Specification documents.
• Independently involved in the complete Data Quality Analysis of the existing system.
• Was involved in Data Modeling and database tuning for the project.
• Did Extensive fine-tuning on ETL jobs and SQL queries for improving performance.
• Involved in complete Design and Development of the Data Migration project.
• Documenting standard project design documents, ETL and database high and low level design documents, mapping documents, Project Plans and Metrics Reports. Also created various re-usable standard templates which were used for various DW projects namely Data Quality Template, Audit Reports.
• Independently provided the ETL design strategy for the data migration.
• Provide estimations for the business requirements.
• Development of Complex Datastage Jobs.
• Develop test plans and test cases.
• Performance Tuning of the ETL Jobs and database.
• Assign tasks to team members.
• Review the code developed by team.
• Worked on Metadata to Generate Audit Reports.

Environment: DB2 Version 7.2, SQL Server, Datastage Version 8.1, RUMBA, Microsoft Office tools.

Confidential

Role: ETL Senior Developer

Responsibilities

• Provide estimations for the business requirements.
• Involved in Gathering and analyzing business requirements, High Level Estimates, Technical Design Documents.
• Design, develop and test complex DataStage jobs.
• Worked extensively on Datastage PX jobs tuning and building reusable components for the project.
• Unit testing of individual modules and their integration testing.
• Used parameters and variables to facilitate smooth transition between the development and production environments.
• Conduct code reviews/approvals.
• Created Oracle stored procedures, functions and triggers using PL/SQL.
• Did Extensive fine-tuning on Oracle Stored Procedures for improving performance.
• Responsible for the designing and development of Oracle PL/SQL queries.
• Built various reusable components mainly routines and jobs.
• Developed UNIX shell scripts for scheduling and in complex ETL jobs.
• Was involved independently in developing the main master sequencer monthly and weekly sequence job which invoked the sequences to load data of all the 40 source systems. It incorporated complexities including error handling, restart ability, holiday checks.
• Debug and provide production support for the ETL jobs.
• Mentoring team members.

Environment: Datastage Version 8.1, Oracle 10g, UNIX shell scripting, SQL Server 2000, DTS, PL/SQL, SQL Loader, Microsoft Office tools.

Confidential

Role: ETL Senior Developer

Responsibilities

• Involved in different SDLC phases including, Gathering and analyzing business requirements, technical feasibility studies, Work break Down Structures and High Level Estimates, Technical Design Documents.
• Have meeting with clients to understand requirements and effectively identify data needs and challenges
• Translate the requirements to Technical Specification documents.
• Provide estimations for the business requirements.
• Design, develop and test complex DataStage jobs for extract, transform and load
• Worked extensively on Datastage PX jobs tuning and building reusable components for the project.
• Was involved independently in developing the main master sequencer monthly and weekly sequence job which invoked the sequences to load data of all the 40 source systems. It incorporated complexities including error handling, restart ability, holiday checks.
• Code to perform Job Monitoring of Jobs running.
• Developed complex stored procedures and UNIX shell scripts independently.
• Testing and production support of the ETL jobs and scripts.
• Conduct code reviews/approvals, tracking the progress, provide metrics while I played a module lead role.
• Mentoring team members.

Environment: Datastage Version 8.1, DB2 Version 8.2, UNIX, Microsoft Office tools.

Confidential

Role: ETL Lead

Responsibilities

• Analyzing and understanding business requirements.
• Support offshore team with the queries on the specifications.
• Provide Estimation for the requirements.
• Interacting with the Client for collecting the requirements and documenting the same.
• Create source to target mappings, ETL specifications, workflows and jobs schedules
• Data Modeling and Design of Minor End to End enhancements.
• Design and Develop Complex ETL jobs.
• Design and Developed complex PL/SQL Procedures.
• UNIX Scripting like scheduling jobs using crontab.
• SQL and Database tuning.
• Provide production support for the existing ETL jobs under three different Business units, ensuring that load processes are completed and data is reconciled and correct.
• Independently involved in design, develop and release.
• Created different types of reports including Master/Detail, Cross Tab and Charts Crystal Reports XI.
• Prepare Metrics report for each member of the team to generate the effort and schedule variance.s
• Developed jobs using SFDC as source using SCRIBE.
• Review code of team members.
• Mentor juniors in the team.
• Worked Onsite for a period of Three months for analysis and knowledge transition.

Environment: Datastage Version 7.5.2, Oracle 11g/10g, BOXI, UNIX, Crystal Reports XI, SQL Developer, Control-M, TOAD, SCRIBE, Microsoft Office Tools, Erwin.