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 with 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 Confidential, Insurance.
• 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 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 the 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 the 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 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.
• 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 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.
• PL/SQL Procedures, UNIX Scripting.
• 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.
• 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.1, Oracle 10g, BOXI, UNIX, Crystal Reports XI, SQL Developer.

Confidential

Offshore Lead

Responsibilities:

• Requirements gathering for the project by constant Client Interactions and come up with a suitable design.
• Independently provided the ETL design strategy for the 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 Mindtree DW projects namely Data Quality Template, Audit Reports.
• Involved in complete Design and Development of the Data Migration project.
• Data Modeling and database tuning for the project.
• Independently involved in the complete Data Quality Analysis of the existing system.
• 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.
• 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 the data model for the system.
• Independently involved in the Design and Development of VAT Engine driven by PL/SQL which is the heart of the application that handles the 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 the Allocation Engine done for the system using Oracle 9i, PL/SQL programming.
• Involved in building the data Model for the Allocation Engine.
• Development of PL-SQL procedures (Like the generic Matview refresh Layer, used to sequentially refresh all the 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.

Confidential

Responsibilities:

• As a team member involved in coding backend PL/SQL programming (Packages, Views, Procedures, Functions).
• Development of reports using Oracle Reports 9i for the system.

Environment: J2EE, EJB, Servlets, Java, JSP, JDBC, XML, TOAD, UML, Web logic platform 8.1, ORACLE 9i v2, Reports 9i, PL/SQL. Programming.

Confidential

Responsibilities:

• As a team member involved in Development of reports using Reports 9i for the system.

Environment: J2EE, EJB, Servlets, Java, JSP, JDBC, XML, JAXP, WebSphere Studio 5.0, 9iAS Developer, TOAD, UML, WEB Sphere 5.0, 9iAS v2, ORACLE 9i, Windows 2000, Linux Advanced server, VSS6.0, Reports 9i, PL/SQL Programming.

Confidential

Responsibilities:

• As a team member involved in Development of Masters, Transactions for the system as per the specification using Forms 9i, PL/SQL Programming and Oracle 9i.
• Development of Reports for the system using Reports 9i and Oracle 9i.

Environment: Forms 9i, Reports 9i, Oracle9i, PL/SQL Programming, TOAD 7.0.

Confidential

Responsibilities:

• As a team member involved in Development of Masters, Transactions for the system as per the specification using Forms 6i, PL/SQL Programming and Oracle 8i.
• Development of Reports for the system as per the specification using Reports 6i and Oracle 8i.

Environment: Forms 6i, Reports 6i, PL/SQL Programming, Oracle 8i.

Confidential

Responsibilities:

• As a team member involved in Development of Masters, Transactions for the system as per the specification using Forms 6i, PL/SQL Programming and Oracle 8i.
• Development of Reports for the system as per Reports 6i and Oracle 8i.

Environment: Forms 6i, Reports 6i, PL/SQL Programming, Oracle 8i.