SUMMARY:

• 13+ years of experience in IT with a broad range of computer expertise, ETL skills, analytical skills, database skills and proficient 10+ years of experience in Architecture and Business Intelligence applications.
• Hands on experience in IBM Data Stage 11.3/8.7/ 8.5 / 8.1 / 7.5, SSIS ETL, UNIX, and version controls GIT/PVCS/SVN.
• DataStage Architect experience in Data Integration and Implementation of Data Warehousing Systems involving heterogeneous source systems ranging from flat Files, XML. Oracle, DB2, Sybase, Teradata and SQL Server.
• Hands on experience in migrating DataStage jobs, Sequence and Connectors to DataStage 11.3 version.
• Good experience in Capital Market, Banking, Insurance, Manufacturing and Healthcare domain. Have worked in Pioneer, Confidential, Confidential, Confidential, CNH and UHG accounts.
• Experience in Data Integration and implementation of Data Warehousing Systems involving heterogeneous source systems ranging from flat Files, XML. Oracle, DB2, Sybase and SQL Server.
• Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.
• Leading data integration team members to achieve success in design, development and deployment activities.
• Provided technical leadership to project team by design the ETL architecture, gathering requirements, design ETL process and workflows and managing scope.
• Applied the DataStage run time column propagation (RCP) and created DataStage Parallel sync up the tables between environments.
• Created common Jobs with Multiple instance enabled for dependency check of the completion of the each layer extraction jobs and re-used throughout the project.
• Created DataStage server routines to re-use to achieve the DataStage Job status and DataStage jobs records counts to do reconciliation.
• Multiple project experiences with DataStage with the ability to communicate design considering using a combination of DataStage, databases where required.
• Experience in working with loading high volume data, Parallel jobs, Sequencer Jobs, Manager, CDC and dealing with production issues.
• Good working knowledge of performance tuning DataStage jobs.
• Understanding of the principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake Schema modeling.
• Practical experience in loading data, troubleshooting mapping, tuning applications, etc.
• Experienced in Data Warehousing techniques for Data Cleansing, RCP (Runtime column Propagation), Reusable Components and Schema Files.
• Worked in Waterfall, Agile, Scrum and Kanban methodology.

TECHNICAL SKILLS:

Hardware / Platforms: Windows 98/XP/2000, Window 7/10.

Technology/ Programming Languages: DataStage 7.5, 7.5.2, DataStage 11.3.1,9.x,8.1, 8.0.1, 8.5, 8.7, Informatica 8.0, Pentaho, Data Warehousing, ETL, Visual Basic.

Databases: Oracle 12, 11G, 9i, IBM DB2, SQL Server 2005.

Version Control Systems: GIT, Version Manger, Tortoise SVN, MS VSS.

Management Skills: Client Interaction, Critical Thinking, Problem Solving, Resourcing, Leading Offshore team, Proposing Solution, Project Management, Agile, Scrum, SDLC process.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

ETL Technical Architect

Responsibilities:

• Technical Architect, responsible for all the projects (EDM/Ecommerce/NFA/BRS) and delivery from onshore.
• Directly interacting with VP of client development team for any new coming projects and change requests.
• Provided technical leadership to project team by design the ETL architecture, gathering requirements, design ETL process and workflows and managing scope.
• Working in onsite & offshore model of project model, responsible in facilitating offshore team with all resources, business clarifications and technical challenges.
• Helping to formulate estimates and timelines for project activities and setting related goals.
• Addressing service-impacting issues quickly in order to proactively remediate the issues prior to escalation.
• Enforcing project standards, process and policies.
• Executed DataStage migration from 8.1 to 11.3 version.
• Introduced and implemented lot of value addition to the current ETL environment, which was of challenging and timeworn environment.
• Came up with the solution and recommendation in creating Parameter sets in current ETL DataStage environment that allowed in time saving and gave capability to point cross environments (reading data from UAT/QA and only writing to DEV), which enabled the developer to do their development work and fix the issue with the up to date data before moving to higher environments.
• Researched and came up with the recommendation to convert the OES to OCS which was really quick and enabled developers to concentrate more on their change request rather converting OES to OCS
• As an Architect, I also participated in development and knocked out the jobs effectively from pile, when there are adhoc request and change request comes in.
• Supporting the team members technically with performance based approach in DataStage jobs and sequences.
• Supporting the testing team, Integration Team and Reporting team after ETL data Load.
• Involved in performance tuning of the long running jobs to minimal time, resulting in quick batch completion.
• Contributed in helping the business team in fixing the technical issues and performance issues during their critical situations.
• Applied the DataStage run time column propagation (RCP) and created DataStage parallel sync up the tables between environments.
• Created Jobs with multiple instances enabled for dependency check of the completion of the each layer extraction jobs and re-used throughout the project.

Environment: DataStage 11.3.1, Oracle 11G, Putty, WinScp, Windows 7, UNIX, GIT, $U

Confidential, Phoenix, AZ

Senior DataStage Integration developer

Responsibilities:

• Developed the jobs very quickly and moved out from the backlog list.
• Created Jobs with Multiple instances enabled for dependency check of the completion of the each layer extraction jobs and re-used throughout the project.
• Supporting the testing team, Integration Team and Reporting team after ETL data Load.
• Involved in performance tuning of the long running jobs to minimal time, resulting in quick batch completion.
• Applied the DataStage run time column propagation (RCP) and created DataStage Parallel sync up the tables between environments.
• Supporting the team members technically with performance based approach in DataStage jobs and sequences.
• Contributed in helping the other team in fixing the technical issues and performance issues during their critical situations.
• Adopted agile methodology process to swarm and develop the jobs.
• Involved in daily standups on a regular basis.
• Involved as part of grooming and retrospective discussions.
• Applied few Kanban model approach for a few backlog list.

Environment: DataStage 8.7, Oracle 11G, Putty, WinScp, Windows 7, UNIX, AutoSys

Confidential, Phoenix, AZ

DataStage Lead developer

Responsibilities:

• Created common Jobs with Multiple instances enabled for dependency check of the completion of the each layer extraction jobs and re-used throughout the project.
• Supporting the testing team, Integration Team and Reporting team after ETL data Load.
• Involved in performance tuning of the long running jobs to very minimal time, resulting in quick batch completion.
• Applied the DataStage run time column propagation (RCP) and created DataStage Parallel sync up the tables between environments.
• Created a table mechanism to give the control process to the other applications once after the data load.
• Supporting the team members technically with performance based approach in DataStage jobs and sequences.
• Contributed in helping the other team in fixing the technical issues and performance issues during their critical situations.
• Worked with EDI cross-functional team to get the file placed into FTP server.
• Suggested the EDI mapping to be captured in a document.
• Implemented the web service setup in DataStage 8.5 and 8.7 to parse the data.

Environment: DataStage 8.5, Sybase, Tivoli scheduler, EDI, Putty, WinScp, Windows 7, UNIX

Confidential

ETL - DataStage Lead

Responsibilities:

• Created DataStage Parallel Jobs with Multiple instance enabled for dependency check of the completion of the each layer extraction jobs and re-used throughout the project.
• Using Join, Transformer, Sybase stage, Web service Input stage, Sequential File stage to Supporting the testing team, Integration Team and Reporting team after ETL data Load.
• Involved in performance tuning of the long running jobs to very minimal time, resulting in quick batch completion.
• Used Looping logic in Job sequencer to execute the jobs for multiple time until the condition is satisfied.
• Eliminated lots of warnings in the job and made the job to complete as error/warning free.
• Applied the DataStage run time column propagation (RCP) and created DataStage Parallel sync up the tables between environments.
• Created a table mechanism to give the control process to the other applications once after the data load.
• Supporting the team members technically with performance based approach in DataStage jobs and sequences.
• Designing DataStage jobs to the standards.
• Contributed in helping the other team in fixing the technical issues and performance issues during their critical situations.
• Implemented the web service setup in DataStage 8.5 and 8.7 to parse the data.

Environment: DataStage 8.7, Sybase, Tivoli scheduler, Putty, WinScp, Windows 7, UNIX

Confidential

Senior ETL Lead Developer

Responsibilities:

• Automated the ETL batch by building the control and audit tables in a frame work model, designing and developing complex and critical jobs.
• Created common Jobs with Multiple instance enabled for dependency check of the completion of the each layer extraction jobs and re-used throughout the project.
• Supporting the testing team, Integration Team and Reporting team after ETL data Load.
• Involved in performance tuning of the long running jobs to very minimal time, resulting in quick batch completion.
• Created DataStage server routines to re-use to achieve the DataStage Job status and DataStage jobs records counts to do reconciliation.
• Used Job parameters, stage variable and created parameter files for flexible runs of Job based on changing variable values
• Created a table mechanism to give the control process to the other applications once after the data load.
• Proposed for Code back up and Versioning process.
• Identifying source and target systems.
• Identifying Relationship between source and target system
• Supporting the team members technically with performance based approach in DataStage jobs and sequences.

Environment: DataStage 8.0.1, Oracle, SAP, Tivoli scheduler, Putty, WinScp

Confidential

Senior ETL Lead Developer

Responsibilities:

• Automated the ETL batch by building the control and audit tables in a frame work model, designing and developing complex and critical jobs.
• Created common Jobs with Multiple instance enabled for dependency check of the completion of the each layer extraction jobs and re-used throughout the project.
• Supporting the testing team, Integration Team and Reporting team after ETL data Load.
• Involved in performance tuning of the long running jobs to very minimal time, resulting in quick batch completion.
• Created DataStage server routines to re-use to achieve the DataStage Job status and DataStage jobs records counts to do reconciliation.
• Used Job parameters, stage variable and created parameter files for flexible runs of Job based on changing variable values
• Created a table mechanism to give the control process to the other applications once after the data load.
• Proposed for Code back up and Versioning process.
• Used SAP/R3 stage as source and configured to read the data and loaded into oracle table.
• Worked on creating and managing the partitions.
• Recommended to Install Teradata drivers for the teradata utilities for supporting new versions.
• Performed database health checks and suggested to tune the database using Teradata Manager.
• Identifying source and target systems.
• Identifying Relationship between source and target system
• Supporting the team members technically with performance based approach in DataStage jobs and sequences.

Environment: DataStage 8.0.1, Oracle, Teradata, Tivoli scheduler, Putty, WinScp

Confidential

Senior ETL Lead Developer

Responsibilities:

• Monitoring the Informatica jobs.
• Proposing for stream lining the data quality issue.
• Getting the change tasks to implement the changes.
• Preparing Functional specification and Mapping document.
• Designing Technical documents and Test cases.
• Designing of Unit Test Cases and Involved in Unit Testing
• Setting up con-call and status to the client on the daily basis.
• Supporting the team members technically with performance based approach in DataStage jobs and sequences.

Environment: Informatica 8.0, Oracle,Tivoli scheduler, Putty, WinScp

Confidential

Senior Data Integration Developer

Responsibilities:

• Designed and proposed the reporting screen for the end user view and got appreciation on the creative design.
• Proposing the best way of approach during the ETL design.
• Leading and supporting the ETL team.
• Proposed for Code back up and Versioning process.
• Supporting the team members.
• Identifying source and target systems.
• Identifying Relationship between source and target system
• Preparing Functional specification and Mapping document.

Environment: Pentaho Data Integrator, GreenPlum DB, Windows 7.

Confidential

Senior ETL Developer

Responsibilities:

• Migrated the DataStage 7.5.2 jobs to DataStage 8.1 jobs version.
• Supporting the team members.
• Identifying source and target systems.
• Identifying Relationship between source and target system
• Preparing Functional specification and Mapping document.
• Designing Technical documents and Test cases.
• Designing of Unit Test Cases and Involved in Unit Testing
• Designing DataStage jobs to the standards.

Environment: DataStage 7.5.3 and DataStage 8.1, Windows XP, AIX, JIRA tracking tool.

Confidential

ETL Module Lead Developer

Responsibilities:

• Migrated the DataStage 7.5.2 jobs to DataStage 8.1 jobs version.
• Supporting the team members.
• Identifying source and target systems.
• Identifying Relationship between source and target system
• Preparing Functional specification and Mapping document.
• Designing Technical documents and Test cases.
• Designing of Unit Test Cases and Involved in Unit Testing
• Designing DataStage jobs to the standards.

Environment: DataStage 7.5.3, Db2, Windows Server

Confidential

Data Integration Lead/Developer

Responsibilities:

• Designed the ETL architecture for this project.
• Proposing the best way of approach during the ETL design.
• Developed ETL SSIS Data Flow and Control Flow tasks.
• Scheduled the package using Job agent in SQL database server.
• Handled dependency check in the SQL to execute the order of the job.
• Travelled on-site to coordinate users during UAT phase.
• Regular con-call and updates with the client.
• Supporting the team members.

Environment: SSIS 2005, Sql Server 2005, Version Control, and Windows Server

Confidential

Senior ETL Module Developer

Responsibilities:

• Developed Jobs in DataStage server edition.
• Parsed the XML data using folder stage and converted into sequential file format.
• Scheduled the job using the Job sequencers.
• Preparing Functional specification and Mapping document.
• Designing Technical documents and Test cases.
• Designing of Unit Test Cases and Involved in Unit Testing
• Designing DataStage jobs to the industry standards.

Environment: DataStage 7.5.3, Oracle, Windows Xp, AIX

Confidential

Senior ETL Developer

Responsibilities:

• Designing of Impact Analysis.
• Designing of Technical Document.
• Developed DataStage Jobs using sequential file stage, Oracle OCI stage, transformer, hash file stage based on the design and Mapping provide by the business analyst.
• Designing of Unit Test Cases and Involved in Unit Testing.
• Solving the issues with SIT Team during SIT Phase.

Environment: Ascential DataStage 7.5, Oracle 9i, Putty, Windows 2000.

Confidential

ETL Developer

Responsibilities:

• Designing of Impact Analysis.
• Developed DataStage Jobs using sequential file stage, Oracle OCI stage, transformer, hash file stage based on the design and mapping provide by the business analyst.
• Designing of Unit Test Cases and Involved in Unit Testing.
• Solving the issues with SIT Team during SIT Phase.

Environment: Ascential DataStage 7.5, DB2, Putty, and Windows 2000.

Confidential

Programmer

Responsibilities:

• Designing of Screens using standard Tool.
• Designing of Technical Document.
• Developed coding in Vb.net using standard tool Visual Studio.
• Tested with Sample Inputs.
• Developed DB scripts.

Environment: Visual studio 2000, Vb.net, Sql server 2000, Windows Xp.