SUMMARY

• Over 11 years of experience in Data Integration and Data Warehouse projects.
• End to End delivery of multi $ mission projects right from Scoping, Implementation, Deployment, Migration, Production Support by using different ETL tools.
• Extensive experience in designing and developing ETL/ELT solutions using market leading ETL/ELT tools like IBM Infosphere DataStage, Oracle Data Integrator and Pentaho.
• Extensive experience in data quality tools like Oracle Enterprise Data Quality.
• Extensive knowledge of SQL and PL/SQL along with UNIX Shell Scripting.
• Expertise in Performance Tuning the different ETL tools Application from end to end. Analyzing and optimizing design to the best.
• Ability to Tune Oracle Database by analyzing SQL query execution plan, AWR, ADDM reports and deep IO analysis.
• Understanding of the oracle table partition strategy for the utilization in business use case.
• Experience in DataStage, ODI Administration and Production Support Activities Root Cause Analysis, Performance
• Understanding of the different dimension model and very good experience of designing and developing start schema.
• Very rich experience of working in various relation data models.
• Knowledge of OBIEE reports, dashboards, segmentation and RPD.
• Knowledge of Confidential Customer Master implementation.
• Expertise in Research and Analysis based assignments of strategic importance that facilitates effective decision - making.
• Strong analytical and critical thinking skills, effective at prioritizing multiple-tasks and cross-department-cross-functional management.
• Trustworthy, discreet, ethical, committed to high quality, and eye for detail.
• Positive attitude, adaptable and resilient, strong interpersonal and leadership skills.
• Strong communication skills, self-motivated and ability to work independently as well as in Team.
• Have good experience with Review and Writing of Technical Documents.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere DataStage, Oracle Data Integrator, Pentaho Data Integration

Data Quality Tools: Oracle Enterprise Data Quality

Datawarehouse Design: Dimesional Modeling, Reporting, Optimization

OBIEE Tools: Dashboards, RPD

CRM: Customer Master UCM, Understanding of Confidential UI functionalities for Call Center & Marketing, SAP PI/ABAP

RDBMS: Oracle 8/9i/10g/11g/12c, Microsoft SQL server, PL/SQL

Web Technologies: XML, HTML, Java Script

OS: UNIX Shell scripting

B2B Tools: IBM Sterling Gentran Integrator

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Data Architect

Responsibilities:

• Involved in the analyzing and documenting all the existing process and coming up with the solution architecture for Confidential Customer Master.
• Involvement in designing the UCM architecture in Confidential .
• Complete interaction with the client there by doing all the requirement gatherings. Conducting all the technical session with IT team and functional sessions with business teams.
• Involved in the design and development of ODI and OEDQ interfaces and writing all the technical documents for the project.
• Oversee all the developments time to time and keep track of activities.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in performance testing of the ODI and EDQ jobs.
• Customization of out of the box code by understanding the functionalities and making the more feasible for project purpose.
• Design, develop and delivered the match merge process for the customer data.
• Design end to end functionalities of all batch jobs for ODI.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Oversee the development for ODI along with OEDQ.
• Design and develop all the UNIX shell script and involved in automation of ODI interfaces.
• Support the existing AMS team by providing time to time solutions for all the enhancements and bug fixes.
• Involved in lot of system knowledge session for team members as I had in depth knowledge of the existing system.

Technology Used: Oracle Enterprise Data Quality 12, Oracle Data Integrator 11g, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, Confidential Data Model, Salesforce Marketing Cloud.

Confidential, Irvine, CA

Team/Technical Lead

Responsibilities:

• Involved in the design and development of ODI interfaces and writing all the technical documents for the project.
• Complete interaction with the client there by doing all the requirement gatherings with regard to the data changes.
• Oversee all the developments time to time and keep track of activities.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in performance testing.
• Design end to end functionalities of all batch jobs for ODI.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Simultaneously involved in all the AMS enhancements and code fixes by providing solutions and design to the team.
• Design and develop all the UNIX shell scripts.
• Exposure to EIM interface batch files (IFB).

Technology Used: Data Warehouse, Oracle Data Integrator, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, Confidential Data Model, OBIEE.

Confidential, Irvine, CA

Team/Technical Lead

Responsibilities:

• Involved in the design and development of ODI interfaces and writing all the technical documents for the project.
• Design of the data warehouse model along with my project architect.
• Oversee all the developments time to time and keep track of activities.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in performance testing.
• Design end to end functionalities of all batch jobs for ODI.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Simultaneously involved in all the AMS enhancements and code fixes by providing solutions and design to the team.
• Design and develop all the UNIX shell scripts.
• Providing knowledge of the new star model to the OBIEE team member to complete the OBIEE model and also oversee the performance of the model queries.
• Writing custom knowledge modules to achieve certain project related requirements.

Technology Used: Data Warehouse, Oracle Data Integrator, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, Confidential Data Model, Microsoft SQL Server, OBIEE.

Confidential, Irvine, CA

Team/Technical Lead

Responsibilities:

• Involved in the design and development of ODI interfaces and writing all the technical documents for the project.
• Design of the data warehouse model along with my project architect.
• Oversee all the developments time to time and keep track of activities.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in performance testing.
• Customize the out of the box code to fit into project specific requirements.
• Design end to end functionalities of all batch jobs for ODI.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Simultaneously involved in all the AMS enhancements and code fixes by providing solutions and design to the team.
• Design and develop all the UNIX shell scripts.
• Writing custom knowledge modules to achieve certain project related requirements.
• Involved in various performance improvement testing there by writing performance optimized queries and designing optimized ODI interfaces.
• Involved in hot fix of previous release which needed immediate attention due to change in functionalities and performance deterioration of the out of the box code.
• Understanding of the out of the box SCD1, SCD2 type dimension design and customizing the same by customizing the ODI models for performance improvement.

Technology Used: Data Warehouse, Oracle Data Integrator, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, Confidential Data Model, OBIEE.

Confidential, Irvine, CA

Senior Developer

Responsibilities:

• Involved in the design and development of ODI interfaces and writing all the technical documents for the project.
• Complete end to end design of the project and doing the entire requirement gathering.
• Oversee all the developments time to time and keep track of activities.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in performance testing.
• Design end to end functionalities of all batch jobs for ODI.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Simultaneously involved in all the AMS enhancements and code fixes by providing solutions and design to the team.
• Design and develop all the UNIX shell scripts.
• Writing custom knowledge modules to achieve certain project related requirements.

Technology Used: Oracle Data Integrator, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, Confidential Data Model, Confidential UI knowledge.

Confidential, Irvine, CA

Senior Developer

Responsibilities:

• Involved in the design and development of ODI interfaces and writing all the technical documents for the project.
• Oversee all the developments time to time and keep track of activities.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in performance testing.
• Design end to end functionalities of all batch jobs for ODI.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Design and develop all the UNIX shell scripts.
• Involved in performance improvement of ODI interfaces.

Technology Used: Oracle Data Integrator, Oracle 11g, UNIX Shell Scripting, SQL, PL/SQL, Confidential Data Model, Confidential UI knowledge.

Confidential

Senior Developer

Responsibilities:

• Involved in the design and development of DataStage interfaces and writing all the technical documents for the project.
• Oversee all the developments time to time and keep track of activities.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in heavy performance testing.
• Design and develop all the UNIX shell scripts.
• Involved in performance improvement of DataStage interfaces.
• Involved in lot of hot fix of code as the project timelines were very challenging.
• Worked in lot of automation part in a quick turnaround time.
• Also oversee the development of the IBM gentran.

Technology Used: DataStage 9.1(Parallel Jobs), Oracle 11g, UNIX Shell Scripting, SQL, MS Office, IBM Sterling Gentran 5.2(Windows).

Confidential

Senior Developer

Responsibilities:

• Involved in the design and development of DataStage interfaces and writing all the technical documents for the project.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involvement in performance testing.
• Design end to end functionalities of all batch jobs for DataStage.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Design and develop complex UNIX shell scripts.
• Involved in performance improvement and designing optimized DataStage interfaces.
• Involved in all the interaction with the onshore team on a day to day basis.
• Involved in designing and testing of modules of other team members.

Technology Used: DataStage 7.5.3(Parallel Jobs), Oracle 10g, SAP ABAP Basics, UNIX Shell Scripting, SAP GUI Logon, SQL, MS Office and Mercury Quality Centre.

Confidential

Senior Developer

Responsibilities:

• Involved in the design and development of DataStage interfaces and writing all the technical documents for the project.
• Involvement in review of code and unit testing, system testing and regression testing.
• Involved in automated audit reporting design which was customized completely by the client.
• Involvement in performance testing.
• Design end to end functionalities of all batch jobs for DataStage.
• Write complex SQL and PL/SQL and work on performance improvement of queries.
• Design and develop complex UNIX shell scripts.
• Involved in performance improvement and designing optimized DataStage interfaces.
• Involved in all the interaction with the onshore team on a day to day basis.
• Involved in designing and testing of modules of other team members.

Technology Used: DataStage 7.5.3(Parallel Jobs), Oracle 11g, UNIX Shell Scripting, SQL, MS Office.

Confidential

Developer

Responsibilities:

• Involved in the design and development of DataStage interfaces and writing the entire unit test and system test cases.
• Involvement in peer review of code and unit testing, system testing and regression testing.
• Design all batch jobs for DataStage.
• Write complex SQL queries.
• Design and develop complex UNIX shell scripts.
• Involved in performance improvement and designing optimized DataStage interfaces.
• Involved in all the interaction with the onshore team on a day to day basis along with the client as well.
• Understood the entire system end to end and I owned a lot of critical modules which were business critical.
• The design of the DataStage jobs was optimized to such levels that the challenge of meeting 3-hour SLA was completely met.

Technology Used: DataStage 7.5.1(Parallel Jobs), Oracle 10g, UNIX Shell Scripting, SQL, MS Office, Mercury Quality Centre.

Confidential

Developer

Responsibilities:

• Involved in the design and development of DataStage interfaces and writing the entire unit test cases.
• Design the batch jobs for DataStage.
• Design and develop simple UNIX shell scripts.
• Involved in all the interaction with the onshore team on a day to day basis.
• Understood the DataStage tool by doing different POC’s for self-learning along with UNIX shell scripting.

Technology Used: DataStage 7.5.3(Parallel Jobs), Oracle 9i, UNIX Shell Scripting, SAP GUI Logon, SQL, MS Office.