SUMMARY

• Have more than six years of experience in development and implementation of software applications in Data Warehousing and BI Reporting, Application Design & Architecture, Dimensional Data Modeling, Database Development.
• Extensive experience working in end to end Data Warehousing projects and Business Intelligence tools including more than 4 years of experience wif Ascential DataStage 8.1/7.5.2/7.5.1 (Administrator, Manager, Designer, Director), Parallel Extender, Sunopsis V3/ODI, Informatica PowerCenter 7.1, Crystal Reports XI.
• Experience in Data Migration projects in various domains namely Banking and Finance, Insurance.
• Extensive experience in Data base Development wif 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 10g, Oracle 9i, SQL Server Version 2000/2005, DB2 Version 8.2.
• Proficient in Design and performance tuning of database applications and ETL jobs. Also have experience in Data profiling and data quality analysis.
• Extensively written Unix Shell Scripts and Batch Scripts for teh automation of various ETL jobs.
• 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.
• Experience in providing estimations, project plan, code reviews and mentoring of team members.
• Strong analytical, presentation, problem solving and excellent inter - personal skills.

TECHNICAL SKILLS

Languages: PL/SQL Programming, UNIX scripting, Knowledge of C, C++, Java, .NET, HTML

Databases: Oracle 8i, Oracle 9i, Oracle 10g, SQL Server 2000/2005, DB2 Versions 7.2, 8.2

Data Modeling Tools: ERstudio, Erwin 3.5.2

ETL Tools: Datastage 7.5, Informatica PowerCenter 7.1, Sunopsis V3/ODI, SCRIBE

Reporting Tools: Crystal Reports XI

User interfaces: TOAD 8.0, PL/SQL Developer, Forms (6i, 9i), Reports (6i, 9i) D2K

Operating Systems: Windows 98/XP/NT/2000/Vista, UNIX

Domain Knowledge: Banking & Finance, Insurance, Automotive, Airline

PROFESSIONAL EXPERIENCE

Confidential

ETL Senior Developer

Responsibilities:

• Provide estimations for teh business requirements.
• 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.
• Design, develop and test complex DataStage jobs for extract, transform and load
• Worked extensively on Datastage PX jobs tuning and building reusable components for teh project.
• Was involved independently in developing teh main master sequencer monthly and weekly sequence job which invoked teh sequences to load data of all teh 40 source systems. It incorporated complexities including error handling, restart ability, holiday checks.
• Developed stored procedures and UNIX shell scripts independently.
• Conduct code reviews/approvals and played a module lead role.
• Mentoring team members.

Environment: Datastage Version 7.5.2, DB2 Version 8.2, UNIX.

Confidential, NJ

ETL Lead

Responsibilities:

• Analyzing and understanding business requirements.
• Provide Estimation for teh requirements.
• Interacting wif teh Client for collecting teh requirements and documenting teh 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.
• PL/SQL Procedures, UNIX Scripting.
• Database tuning.
• Provide production support for teh 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 teh team to generate teh effort and schedule variance.
• Review code of team members.
• Mentor juniors in teh team.
• Worked Onsite for a period of Three months for analysis and knowledge transition.

Environment: Datastage Version 7.5.1, Oracle 10g, BOXI, UNIX, Crystal Reports XI, SQL Developer.

Confidential

Offshore Lead

Responsibilities:

• Requirements gathering for teh project by constant Client Interactions and come up wif a suitable design.
• Independently provided teh ETL design strategy for teh data migration.
• 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 Confidential DW projects namely Data Quality Template, Audit Reports.
• Involved in complete Design and Development of teh Data Migration project.
• Data Modeling and database tuning for teh project.
• Independently involved in teh complete Data Quality Analysis of teh existing system.
• Development of Complex Datastage Jobs.
• Develop test plans and test cases.
• Performance Tuning of teh ETL Jobs and database.
• Assign tasks to team members.
• Review teh code developed by team.
• Generate Audit Reports.
• Worked Onsite for a period of three months for Requirement gathering and Data Quality analysis.

Environment: DB2 Version 7.2, SQL Server, Datastage Version 7.5, RUMBA.

Confidential

ETL and Oracle Senior Developer

Responsibilities:

• Independently built teh data model for teh system.
• Independently involved in teh Design and Development of VAT Engine driven by PL/SQL which is teh heart of teh application that handles teh invoice generation, Tax calculation, Currency Conversions.
• Tuning of SQL queries and database as when required.
• Independently involved in development of ETL jobs using Sunopsis V3/ODI.

Environment: PL/SQL Programming, Oracle 10g, SUNOPSIS V3/ ODI, JDK 1.4, JBoss Version 4.0.0 RC1, Version Name: Zion, JBoss Eclipse IDE Version: 3.1.0, Client, Hibernate 2.1, Ant-contrib 0.6, Tomcat 4.1, EAP, Windows XP Professional.

Confidential

Developer

Responsibilities:

• Involved in Design and Development of teh Allocation Engine done for teh system using Oracle 9i, PL/SQL programming.
• Involved in building teh data Model for teh Allocation Engine.
• Development of PL-SQL procedures (Like teh generic Matview refresh Layer, used to sequentially refresh all teh matviews), views, functions and matviews.
• Database tuning.
• Involved in development of ETL jobs using Informatica PowerCenter 7.1.

Environment: PL/SQL Programming, Informatica PowerCenter 7.1, Oracle 9i, Informatica PowerAnalyzer 4.1, Erwin 3.5.2, TOAD 7.6.