SUMMARY

• Over 10 plus Years of experience in Software Analysis, Design, ETL Architecture, Enhancement, Maintenance, Production support and Development in Client/Server systems, Data warehousing, Data governance, and Business Intelligence applications.
• Over 8 + years of solid experience in loading and maintaining large Data Warehouses and DataMart's using IBM/Ascential DataStage / IBM InfoSphere, (5.x/6.x/7.x/8.01,9.1,11.5), Informatica Power Center, Big Data, Hadoop.
• Implemented Type2 slowly changing dimensions and Fact tables using Kimball methodology
• Experience in Integration of various data sources like DB2 UDB, SQLServer, Informix, Oracle, Sybase, Teradata, MS Access and Mainframes, COBOL, JCL.
• Mid level experience working wif OLTP data models & OLAP (Star Schema, Snowflakes) data models using ERWIN Data Modeling tools.
• Experienced on project planning, issue/risks monitoring & control, estimations and status reporting.
• Lead a team of 6 - 8 data integration team members to successfully complete projects & tasks that were assigned.
• TEMPEffectively communicated wif business personals at onsite and offshore development teams.
• Very good experience on SDLC process using different methodologies including Agile, Waterfall and multiple business specific internal methodologies.
• Involved in development and implementation of Decision support system, Data-warehouse, Datamart, historical reporting system.
• Hands-on involvement at all levels, from project management and architecture design to code development/review, debug and test.
• Manages all development activity on a given project for Data Warehouse, made sure that teh project was completed on time & on budget using teh resources assigned to me.
• Involved in DataStage 9.1, 11.5Migration.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere Information Server 9.1,11.5,WebSphere DataStage 8.0.1,DataStage Enterprise /Parallel Extender) 7.5,7.1, 6.0.r1,Informatica Power center 8.11, Informatica Power center 9.x,IBM InfoSphere Information Server 9.1,Hadoop,BigData,Talend.

Operating Systems: MVS, OS-390, Windows 98/2000, Windows NT 4.0,Novell, HP-UX, and IBM AIX 4.0

Databases: TeraData, Oracle 7.x/8.0/8i/9i,10g,Informix DS 9.x, Sybase, SQL Server 2000, MS-Access, DB2UDB/EEE, IMS DB/DC, DB2,MDM,Netezza,Snowflake

Languages: PL/SQL, Universe Basic, Cobol, C++, SQL, Unix shell programming, C, JCL, Pro*C, HTML.

Database Tools: SQL Plus, SQL*Loader, Import, Export and TOAD,SQL developer

Other Tools: Business Objects XI, Designer 2000, Erwin,SQL server analysis services (OLAP).

PROFESSIONAL EXPERIENCE

Confidential

DataStage Developer

Responsibilities:

• Developed parallel jobs wif collection of all source stages, target stages and processing stages like Aggregator, Transformer, look-up, join, merge, funnel etc.
• Migrating teh Code to GitHub and PyCharm for production deployment
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
• Worked on Jira for creating tasks and updating teh work done to technical lead.
• Provide technical support to promptly resolve escalated incidents/outages
• Provided on call support to production incidents. Coordinated production incidents wif multiple teams for quick and TEMPeffective resolution of issues.
• Participate in design meetings and perform detail level design to satisfy requirements. Provided technical documentation, development work, etc.

Environment: IBM InfoSphere DataStage 11.7/11.5, Oracle 12c, Netezza, MySQL, Red Hat Enterprise Linux, SQL Server 2012, DB2, Snowflake, Hadoop, PyCharm GitHub.

Confidential, Columbus, OH

Sr InfoSphere Developer

Responsibilities:

• Developed parallel jobs between multiple source systems using DataStage.
• Actively involved in Analysis, Design and Development, Testing and review ETL code.
• Prepared Data mapping documents and design teh ETL jobs based on teh data mapping document wif required tables.
• Experience in creating required documentation for production support hand off, and training production support on commonly encountered problems, possible causes for problems and ways to debug them.
• Experience in all levels of Application/Production support (L1, L2, L3).
• Review on Exiting system to improve teh Performance and New ETL code (Performance tuning and Process improvements).
• Extensive experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.
• Help development and testing teams resolve data and technical issues.
• Assist wif testing related to implementation, upgrades, and patches.
• Provide technical support to promptly resolve escalated incidents/outages.
• Deliver TEMPeffective and efficient solutions by meeting milestones and ensuring project deliverables are on time (AGILE), wifin budget, and adhere to teh corporate quality and security standards.

Environment: IBM InfoSphere DataStage 11.7/11.5, Oracle 12c,Netezza, MySQL, Red Hat Enterprise Linux, SQL Server 2012, DB2, Snowflake, Hadoop, BigData.

Confidential, NC

Sr ETL Consultant

Responsibilities:

• Involved in Analyzing teh Business Requirements.
• Assessing teh source data and providing teh required transformations in teh mapping documents.
• Assisted wif solution review and validating production readiness for all ETL design phase deliverables in AGILE and waterfall model.
• Analyzing teh root cause for teh issues raised by teh Business users and find solutions.
• Attended daily scrum calls and Interacted wif teh Business Analyst and Scrum master to gather requirements in an agile environment.
• Developed parallel jobs wif collection of all source stages, target stages and processing stages like Aggregator, Transformer, look-up, join, merge, funnel etc.
• Participated in Design discussions wif teh Design board to finalize teh Interface design.
• Provide guidance/direction to developers on technical challenges.
• Provided on call support to production incidents. Coordinated production incidents wif multiple teams for quick and TEMPeffective resolution of issues.

Environment: IBM InfoSphere DataStage 9.1/9,5, Control-M, DB2, SQL Server 2005, AIX 6.1, Oracle,Sql server, Big Data, Hadoop.

Confidential, CT

ETL DataStage Consultant

Responsibilities:

• Developed ETL procedures to ensure conformity, compliance wif Confidential Health standards and to translate business rules and functionality requirements into ETL procedures.
• As an ETL Tech lead, lead teh ETL development team for new/enhancements in Insurance Data warehouse.
• Experience in all levels of Application/Production support (L1, L2, L3, Infrastructure etc).
• Implemented Type 2 dimensions (SCD) in dimensional Datamarts.
• Implemented Complex Designs using parallel Stages like Join, Lookup, Pivot, Change Capture and Surrogate Key.
• Designed Jobs involving Complex Flat File (CFF) Stage to extract Data from Mainframes (Cobol Copybooks) and load it to Oracle Tables.
• Developed teh datastage job sequencers to implement job execution logic.
• Extensive knowledge in performance tuning teh queries and development, built indexes as part of tuning and optimization.
• Performed data manipulations using various Informatica Transformations like Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Automation of ETL cycle and by setting teh process and its dependency in AUTOSYS scheduler, execution of teh same from AUTOSYS scheduler.
• Wrote Unit test plan documents, captured teh test logs and created teh test summary results.
• Assigning and prioritizing tasks and enforcing project processes and policies.
• Assisting developers wif design work, analysis and requirements gathering.
• Participate in peer code review to make sure that coding standard follow.
• Completing a weekly status report for teh project management.

Environment: IBM InfoSphere Information Server 9.1, IBM InfoSphere DataStage8.5/8.1, Mainframes, Informatica Power center 9.x, Erwin, Oracle 11g/10g,SQL Server, TOAD, AIX-UNIX 5.3,Linux, Ipswich WS FTP Professional, Shell Scripting, Autosys, HP Quality Center.

Confidential, NC

ETL Developer

Responsibilities:

• Involved in design and development of complex Parallel and Server Jobs.
• Actively participated in business meetings wif teh business users in order to gather teh business requirements.
• Understand business requirements and technical specifications of teh application.
• Participate in design meetings and perform detail level design to satisfy requirements. Provided technical documentation, development work, etc.
• Design of parallel Extender Job template which will serve as proto type model.
• Creation of Impact analysis document by analyzing teh impacted components.
• Automation of ETL cycle and by setting teh process and its dependency in TWS scheduler, execution of teh same from TWS scheduler.
• Performed Unit Testing and tuned for better performance wif updates on data warehouse tables.
• Coordinate wif team to understand teh requirements and delivering teh module on time and providing timely sign-off.
• Facilitate UAT and fix defects.
• Developed stored procedures to load historical data and to update, insert or deletion of data as per teh business rules for type 2 dimension tables.
• Used MCM to move mainframe SAS, COBOL and JCLs from Dev to Prod.
• Developed all teh jobs confirming to teh SOX specifications.
• Wrote Data Quality Jobs for doing teh source to target compare using SAS.
• Automated teh sending of data quality reports to teh management/business users
• Involved in creating UNIX shell scriptsfordatabase connectivity and executing queries in parallel job execution
• Involved in extracting teh data from different data sources like Oracle and flat files
• Experience in all levels of Application/Production support(L2,L3)
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to teh Data warehouse.
• Analyzed and implemented new Business rules for teh existing jobs.
• Prepared teh Technical design documents (TDD).

Environment: IBM Websphere DataStage8.0.1, MDM, Oracle 10g, TOAD, PL/SQL, MDM, XML,SQL Loader, AIX-UNIX 5.3, Autosys.