EXPERIENCE SUMMARY:

• Confidential has 10+ years of experience in the Information technology Industry of which, most of the time was spent as Architect, Tech Lead & Sr. Developer for ETL and Data Quality.
• During this tenure he was involved in various stages of software development life cycle including - requirement analysis, design, development, testing.
• Confidential is focused; result oriented IT professional with strong relationship building and communication skills.
• He is highly proficient in ETL and his understanding of the Pharmaceutical Object Model based architecture has contributed in providing solution architecture for many clients.
• Worked as ETL Architect/Tech Lead in various Banking, Life Science, Healthcare and Telecom Domain Projects
• Possesses extensive experience in IBM Datastage 11.5/11.7, IBM Information Analyzer, Oracle SQL, PL/SQL, Unix Shell Scripting, Perl Scripting
• Worked on Design and Development using IBM ETL Suite.
• Experience in all phases of the Software life cycle, Project management.
• Has extensive knowledge on Operational model of Change Request, Incident management as he worked on Operation support
• Proven ability to capture requirements from customers, work with a team towards common objectives on or before schedule
• Excellent Verbal & Written Communication, Presentation, Analytical, & Problem Solving Skills and willing to learn and adapt to new challenges.

TECHNICAL SKILLS:

Tools: IBM Datastage, IBM Information Analyzer, Informatica Power Center, Stonebranch scheduling tool, JIRA

Operating Systems: Unix, Linux, Windows 10, Windows 7

Languages: SQL, PL/SQL Scripting, Unix Script, Perl Scripting

RDBMS: Oracle 11g, Oracle 10g, Oracle 9i (SQL/PLSQL), Teradata, IBM DB2

Tool: Informatica Power Center Integration 9.x: Developer Specialist

RELEVANT PROJECT EXPERIENCE:

Confidential

Technology: IBM Information Analyzer 11.5, IBM Datastage 11.5,, Sql server, Oracle 11g, Unix shell scripting

Onshore Architect and Tech Lead

Responsibilities:

• Responsible for understanding the Business requirement from the Business team/Client/Onshore.
• Responsible for implementing the design and overall solution for integrating Source to IBM ETL Suite.
• Responsible for reviewing design and all project related deliverables with team to ensure adherence to standards and best practices.
• Responsible for writing complex Business Rules in Information Analyzer and Datastage.
• Responsible for ensuring the final application meets the defined functional and non-functional requirements
• Manage change requests related to technology changes and design deviations
• Review of ETL codes developed by Team Members to ensure both Business and Best practices have been followed.
• Performance Tuning of the ETL codes developed.

Confidential

Technology: IBM Datastage 11, IBM Information Analyzer, IBM MDM, Oracle 11g, Unix

Onshore Tech Lead

Responsibilities:

• Responsible for understanding the Business requirement from the Business team/Client/Onshore.
• Responsible for implementing the design and overall solution for integrating Source to MDM using ETL tool.
• Responsible for reviewing design and all project related deliverables with team to ensure adherence to standards and best practices
• Responsible for ensuring the final application meets the defined functional and non-functional requirements
• Manage change requests related to technology changes and design deviations
• Review of ETL codes developed by Team Members to ensure both Business and Best practices have been followed.
• Performance Tuning of the ETL codes developed.

Confidential

Technology: IBM Datastage 8.5, Informatica MDM 9.7, Oracle 11g, Unix, Java

Offshore Tech Lead

Responsibilities:

• Responsible for understanding the Business requirement from the Business team/Client/Onshore.
• Responsible for implementing the design and overall solution for integrating Source to MDM using ETL tool.
• Responsible for reviewing design and all project related deliverables with team to ensure adherence to standards and best practices
• Responsible for ensuring the final application meets the defined functional and non-functional requirements
• Manage change requests related to technology changes and design deviations
• Review of ETL codes developed by Team Members to ensure both Business and Best practices have been followed.
• Performance Tuning of the ETL codes developed.

Confidential

Technology: IBM Datastage, Unix Shell Scripting, PL/SQL, Database, IBM MDM

Offshore Tech Lead

Responsibilities:

• Interact with the Business Team, understand the BI system landscape functionality and participate in Feasibility Study discussion along with the Business & Solution Design Team from client’s IT team
• Functional Requirement Analysis
• Creation of Technical Design Document, Reviewing Unit Test Case etc.
• Developed Datastage components for processing different attribute level files received from Source System
• Review ETL, PL/SQL and Shell script components developed by other Team Members
• Ensure best practices have been followed in code developed by Team members
• Developed Shell scripts
• Solving the adhoc requests on demand that are raised to the team.
• Coordinating with SIT team for timely delivery of the testing phase
• Fixing for Bugs (if any) after SIT phase.
• UAT Support
• Deployment and Hyper care Support

Confidential

Technology: IBM Datastage 8.5,IBM MDM, Oracle 11g, Unix, Java

Offshore ETL Lead/Tech Lead

Responsibilities:

• Responsible for implementing the design and overall solution for integrating Source to MDM using ETL tool.
• Responsible for reviewing design and all project related deliverables with team to ensure adherence to standards and best practices
• Responsible for ensuring the final application meets the defined functional and non-functional requirements
• Manage change requests related to technology changes and design deviations
• Review of ETL codes developed by Team Members to ensure both Business and Best practices have been followed.
• Performance Tuning of the ETL codes developed.

Confidential

Technology: Oracle PL/SQL, Unix Shell Scripting, Power Center 9.1

PL/SQL Tech Lead and ETL Sr. Developer

Responsibilities:

• DB / ETL Lead for this project
• Functional Requirement Analysis
• Creation of Technical Design Document
• Developed ETL mappings and workflows for batch process through Informatica Powercenter and UNIX
• Worked on Oracle, Teradata, DB2 and flat file (.csv,.dat,.txt) as source and flat file (.csv,.dat,.txt,.xml) and Oracle and Teradata as target.
• Have worked on creating reusable components of mappings, sessions and workflows.
• Creation of Oracle Views and Mviews
• Impact Analysis and Design of Batch integration through Informatica Power Centre.
• Solving the adhoc requests on demand that are raised to the team.
• Coordinating with SIT team for timely delivery of the testing phase
• Fixing for Bugs (if any) after SIT phase.
• Deployment Support

Confidential

Technology: Perl Scripting, Shell Scripting, Oracle PL/SQL, SQL Scripting

Offshore Developer

Responsibilities:

• Designing the smaller & medium projects and preparing the Technical Specification documents.
• Coding for the Model, View and Controller components.
• Coordinating with dependent system teams to resolve the issues/defects
• Interacting directly with onsite/client side technical leads for the project related communications.
• Have identified the regression areas, supported QA in System, Regression and User Acceptance Testing and participated in Defect Review Board.
• Have successfully mentored new comers into the project.