PROFESSIONAL SUMMARY

• Having 12+ years of experience in IT and Data warehousing.
• Experience in Data warehousing, ETL Process, methodology and loading Data Marts.
• Experience in all phases of Software Development Life Cycle(SDLC) with a strong emphasis on Analysis, Design, Development and Testing of applications.
• Experience in Agile, Kanban, Scrum development methods using Rally and JIRA tools.
• Strong working knowledge of Data Warehousing techniques and Concepts experience including ETL processes, Star Schema/Snowflake Schema
• Strong Data Warehousing ETL experience of using Informatica 10.X/9.X/8.X, Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Pentaho Kettle/PDI 4.2.1/4.3.0/7.0/7.1 . Strong experience creating the jobs/workflows to extract the data from different sources and loaded into target system.
• Strong experience in migration the Pentaho PDI jobs from 4.1 to 7.0/7.1 versions and worked on Pentaho kettle properties.
• Experience in SAP Business Objects Data Services. SAP BODS Designer, Central Management Console.
• Experience in Ab Initio GDE 3.x, 2.x, 1.x, EME, Conduct>IT, Co>operating system, Metadata management and developed the Graphs for different business requirements.
• Expertise in all components in the GDE of Ab Initio for creating, executing, testing and maintaining graphs in Ab Initio
• Hands-on experience in working with Hadoop Distribution platforms HortonWorks. Extensive knowledge Hive and Pig scripts.
• Experience in operating systems - MVS OS/390, z/OS, VOS, Windows 9X/2000/XP/7/8, or Unix AIX
• Extensive experience in Databases- IBM DB2, ORACLE 9i/10g/11g, SQL Server 2008/2012/2014 , Teradata 14.0, VSAM, GDG, IBM DB2 UDB
• Worked on the Automation of the ETL jobs using UC4, Control-M, Op-console, Autosys and Tivoli Work Schedulers and Unix Wrappers.
• Experience in Unix shell scripting (ksh,sh,bash), AWK, SED, etc.
• Experience in dealing with SQL (complex queries), PL/SQL (stored procedures, functions, packages, database application triggers, Collection).
• Extensive experience with Databases, Writing queries, Packages and Stored procedures using ORACLE 9I/10G (SQL AND PL/SQL) and SQL Server 2008/2012/2014 (TSQL).
• Extensive experience in programming- COBOL, JCL, CICS, DB2 Stored Procedures, UDB SQL Stored Procedures, and PL/SQL.
• Experience in doing the data analysis/validation on DB2 tables using SQL queries, QMF, and SPUFI.
• Experience on IBM DB2 UDB 8.1 Professional- Development Centre, UDB SQL, and Control Centre and Command editor and developed the UDB SQL Stored Procedures.
• Experience in Domains Life Sciences, Health Care and Banking Financial Services
• Experience in Detailed technical analysis on existing mainframe applications and interfaces.
• Experience in Development, Application Maintenance, and Troubleshooting, Bug-fixing, Production support and Unit Testing.
• Experience in System Integration Testing and Regression Testing
• Experience in creation of Test Plans, Test Cases and Test Logs in Mainframe batch environments.
• Ability to work with the Business Analysts closely to understand the system, gathering the requirements and doing the knowledge transfer to the team.
• Strong experience in reviewing ab initio graphs to assess impact and documenting the impact analysis.
• Worked as Lead role with on-site/offshore part and coordinating day to day solutions on project activities
• Excellent Analytical, Problem solving ability.
• Capable of leading teams, project management, work independently or as part of team
• Good written, verbal and interpersonal communication skills

TECHNICAL SKILLS

Skills: Informatica 10.x/8.x/9.x (Power Center Design, Power Center Repository, Workflow Manager, Workflow Monitor), Ab Initio 3.x, 2.x, 1.x (GDE, Co-operating system and EME), Data Stage 7.5.2 px(Designer, Director and Manager), SAP Business Objects Data Services 4.1, Pentaho PDI 4.2.1/4.3.0/7.0/7.1 , Java/Java script, HTML, Angular.

Databases: DB2, Oracle 9i/10g/11g, SQL Server 2008/2012/2014 , MS-ACCESS, Teradata 14.0, IMS DB, IDMS, VSAM, GDG, IBM DB2 UDBTools: Visio, VSS, Quest software, Clear Case, Subversion SVN 1.8.10, Rational Clear Quest, GitHub,SQL developer 3.2, SQL Modeler 3.3, Toad, Tableau 8.X/9.X/10.X,Rally, JIRA,UC4.

Operating Systems: MVS-OS/390, z/OS, Windows9X/2000/XP/7/8, Linux Red Hat or Unix AIX

IBM DB2 UDB Technologies: Development Center, Control Centre and Command Editor

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. ETL Developer

Responsibilities:

• Created the technical application and component design docs.
• Performed detail analysis on existing applications (Device Swap, EBDS,BILLER,HOME SECURITY,NDW)
• Prepared mapping documents between source and target tables.
• Involved in meetings with customer on mapping between legacy and target system.
• Constructing the ETL code using PDI(Pentaho Data Integration) designer which involved reading the oracle data base tables and applying complex transformations on them to load to the target tables.
• Strong experience in migration the Pentaho PDI jobs from 4.1 to 7.0/7.1 versions and worked on Pentaho kettle properties.
• Created the unix shell scripts and called through PDI jobs.
• Created the cosort/Fact process for huge data files and called through PDI jobs.
• Constructing the ETL code using Hadoop platform which involved reading the oracle data base tables and applying complex transformations on them to load to the target tables
• Designing, building, installing, configuring and supporting Hadoop platform. Creating and pre-processing hive and pig scripts.
• Involved in creating SQL statements with .sql extensions, which will be used in Database transformations to extract the data from different source tables and to load into the target table.
• Used various transformations like Case, Join, streamlookup,Merge, SQL script and validation to develop robust mappings in the PDI Designer.
• Used pentaho as ETL tool to pull data from source systems, cleanse, transform, and load data into database.
• Constructing the ETL code using the informatica which involved reading the different source data bases, Flat files and applying complex transformations on them to load to the target tables
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,Agregation, Joiner, Stored Procedure, and Union to developed mappings in the Informatica Designer.
• Involved in the Check in, Check out with CI/CD using TortoiseSVN, GitHub.
• Testing the developed applications at various stages Unit, Integration and System testing.
• Prepared Unit and Integration Test Plans, Test Cases and Test Script documents.
• Prepare all the quality and delivery documents and follows the clients programming standards in all phases.
• Extensively use SQL for Queries, Joining, Merging, and Concatenation of different tables for data extraction from different databases.
• Created PL/SQL stored procedures for some of the internal process.
• Worked on tableau reports and created dash boards as per business requests and published the reports in server
• Worked on Rally, JIRA tools for Agile, Scrum and Kanban development methods.
• Review the project documents and provided the guidance to team. Provided the training to team on project modules, execution process, and ETL.
• Validate the testing results and get the business approval to move the changes to production.
• Worked with Devops teams on deployment and make sure deployment is successful.
• Get the Business user sign-offs and participate in the Deployment process.

Technology Used: Pentaho PDI 4.2.1/4.3.0/7.0/7.1 , Informatica 10.x/9.x,Hadoop, Hive, Pig, Tableau 8.x/9.x.10.x, Unix shell scripting, Oracle 11g, Teradata 14.0, PL/SQL,TOAD, JSON,TSQL,SQL Server 2012/2014, SVN, Putty server client, Filezilla,Winscp,UC4 scheduler.

Confidential, Denver, CO

Sr. ETL/Lead Developer

Responsibilities:

• Gathering requirements, created the technical application and component design docs.
• Performed detail analysis in data conversion plan.
• Working as Lead role and coordinating with team day to day solutions on project activities
• Prepared mapping documents between source and target tables.
• Involved in meetings with customer on mapping between legacy and target system.
• Prepared E-R diagrams for each functional area in iGovern UI system
• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Constructing the ETL code using BODS designer which involved reading the flat files and applying complex transformations on them to load to the target tables
• Create a transform and load code in BODS and schedule those in central management console.
• Involved in creating SQL statements with .sql extensions, which will be used in Database transformations to extract the data from different source tables and to load into the target table.
• Used various transformations like Case, Merge, Query, SQL, Row Generation, map operation and validation to develop robust mappings in the BODS Designer.
• Used SAP BODS as ETL tool to pull data from source systems, cleanse, transform, and load data into database.
• Involved in the Check in, Check out, get operations with other local repositories from Central Repositories.
• Worked on SAP BODS tools- Designer, Repository Manager, and Central Management Console.
• Testing the developed applications at various stages Unit, Integration and System testing.
• Prepared Unit and Integration Test Plans, Test Cases and Test Script documents.
• Prepare all the quality and delivery documents and follows the clients programming standards in all phases.
• Extensively use SQL for Queries, Joining, Merging, and Concatenation of different tables for data extraction from different databases.
• Review the project documents and provided the guidance to team. Provided the training to team on project modules, execution process, and ETL.
• Validate the testing results and get the business approval to move the changes to production.
• Get the Business user sign-offs and participate in the Deployment process.

Technology Used: SAP BODS 4.2, Unix shell scripting, Oracle 11g, SQL Developer, SQL Data Modeler, SVN, Toad, Putty server client, Filezilla

Confidential, Aurora, CO

Sr ETL/Lead Analyst

Responsibilities:

• Gathering requirements, created the technical application and component design docs.
• Working as Lead role with on-site/offshore part and coordinating day to day solutions
• Prepared design documents using Microsoft Project and Microsoft Office Visio Flow Charts.
• Constructing the ETL code using the informatica which involved reading the EBCIDIC, Flat files and applying complex transformations on them to load to the target tables
• Create a transform and load code in informatica and Shell scripts & schedule those using Tivoli scheduler.
• Created Database Configuration files (.dbc) and involved in creating SQL statements with .sql extensions, which will be used in Database transformations to extract the data from different source tables and to load into the target table.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,Agregation, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Used Ab initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
• Written several UNIX control scripts, specific to application in order to pass the environment variables.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Testing the developed applications at various stages Unit, Integration and System testing.
• Prepared Unit and Integration Test Plans, Test Cases and Test Script documents.
• Prepare all the quality and delivery documents and follows the clients programming standards in all phases.
• Extensively use SQL for Queries, Joining, Merging, and Concatenation of different tables for data extraction from different databases.
• Validate the testing results and get the business approval to move the changes to production.
• Get the Business user sign-offs and participate in the Deployment process.
• Involved in production support activities in varies online/ batch applications.
• Involved in the production support activities as well as the analyzing & providing the solution to the day-to-day production issues.
• Working on project estimates and sending the metrics for every month.
• Also responsible for clarifying any QA defects and providing support during implementation and maintenance.

Technology Used: Informatica 9.x /8.x, Ab Initio GDE 3.x, 2.x, Unix shell scripting, Teradata, DB2, Oracle 10i, SQL Developer, VSAM, Winscp, TSO, ISPF, SPUFI, QMF, Putty server client.

Confidential, New York, NY

ETL Programmer

Responsibilities:

• Gathering requirements, created the technical application and component design docs.
• Performed detailed technical analysis on existing mainframe applications and interfaces.
• Prepared design documents using Microsoft Project and Microsoft Office Visio Flow Charts.
• Created new graphs, shell scripts and SQL scripts which were replacing and existing code.
• Created new graphs which had data manipulation logic for which join, aggregation, rank components were used.
• Designing and Coding the informatica flows
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,Agregation, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Used FTP component to transfer/receive the files from source/destination.
• Experience in understand the technical rules of the data and write/ configure business rule code.
• Testing the developed applications at various stages Unit, Integration and System testing.
• Prepared Unit and Integration Test Plans, Test Cases and Test Script documents.
• Prepare all the quality and delivery documents and follows the clients programming standards in all phases.
• Extensively use SQL for Queries, Joining, Merging, and Concatenation of different tables for data extraction from different databases.
• Get the Business user sign-offs and participate in the Deployment process.
• Also responsible for clarifying any QA defects and providing support during implementation and maintenance.
• Involved in the production support activities as well as the analyzing & providing the solution to the day-to-day production issues.

Technology Used: Informatica 8.x, Oracle 10i, DB2, DB2 Stored Procedures, VSAM, FTP, UNIX shell scripting

Confidential, Hartford, CT

Programmer Analyst

Responsibilities:

• Involved in requirement analysis, application and component designs.
• Prepared design documents using Microsoft Project and Microsoft Office Visio Flow Charts.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,Agregation, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Designing and Coding the informatica ETL
• Involved in writing scripts using UNIX Shell scripting (.Ksh, .Csh shells) to run the ETL jobs.
• Involved in development in Data Stage ETL jobs using designer, director, manager.
• Designed and developed applications in COBOL, DB2, CICS based on business requirements
• Designed and developed UDB SQL Stored Procedures based on business requirements to generate crystal reports
• Designed and developed new PROCS and JCLs.
• Developed and modified MQ Series programs.
• Played a major role in understanding requirements and business rules.
• Involved in DB2 performance tuning and optimization
• Testing the developed applications at various stages Unit, Integration testing.
• Prepared Unit and Integration Test Plans, Test Cases and Test Logs documents
• Working on project estimates and sending the metrics for every month.
• The responsibilities include Estimation of the Projects & SR’s (Service requests), Scheduling the various phases of development according to the deadlines, monitoring the progress of the current projects, SR’s and to ensure the on-time completion of the deliverables.
• Involved in the production support activities as well as the analyzing & providing the solution to the day-to-day production issues.
• Also responsible for clarifying any QA defects and providing support during implementation and maintenance.

Technology Used: Informatica 8.x, Mainframe, Data Stage ETL, Microsoft SQL Server 2008, TSO/ISPF, SPUFI, QMF, COBOL,JCL, CICS, DB2, Stored Procedures, UDB SQL Stored Procedures, File-aid, Endevor, Development Center, Command Editor, Control Center, Zeke Scheduler, VSS, Clear Case, IBM Rational Clear Quest, IPswitch, UNIX Shell script.

Confidential

Programmer Analyst

Responsibilities:

• Involved in Analysis, Development, Testing, Review and Post Implementation Support.
• Created new graphs which had data manipulation logic for which join, rollup, reformat components were used.
• Designing and Coding the Informatica 8.x
• Constructing the ETL code using the informatica which involved reading the EBCIDIC, Flat files and applying complex transformations on them to load to the target tables
• Prepared design documents using Microsoft Project and Microsoft Office Visio Flow Charts.
• Designed and developed many JCL, COBOL, and DB2, VSAM/PS/GDG batch programs, based on business requirements.
• Coded new JCLs and PROCS for programs.
• Given on call production support for different ETL applications.
• Used Rational Clear Quest Tool for Defect tracking.
• System Integration Testing (Executed Test scripts and Test condition and ensured whether system is working properly) and UAT.
• Executed Regression Testing and ensured Mainframe Functionality Working.
• Performing impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities.
• Responsible for clarifying any QA defects and providing support during implementation and maintenance.

Technology Used: Informatica 8.x, TSO, ISPF, COBOL, JCL, PL/1, CICS, DB2, VSAM, GDG, Xpeditor, SPUFI, CHANGEMAN, ENDEVOR, FILE-AID, REXX, SDSF, SDF II IBM Debugger, CA7, Eztrieve, SAS, Ice Tool, SAS, BETA92

Confidential

Programmer

Responsibilities:

• Involved in gathering Business requirements from client
• Converted data from VSAM to DB2 tables using Ab Initio Graphs
• Prepare program specifications, Design documents
• Worked on COBOL, VSAM Programs and JCL Modules
• Actively involved in the design of DB2 Tables
• Exposure to Credit/Debit Transactions, Demand Deposit accounts and savings accounts.
• Given On-call production support for applications.
• Worked on performance tuning of SQLs
• Sound knowledge on Mainframe related tools like Endevor, Expeditor, SPUFI, and QMF.
• Quality assurance (participated in peer reviews and make sure the code is delivered without any bugs).

Technology Used: - MVS OS/390, DB2, VSAM, SQL, TSO, ISPF, COBOL, JCL, File-Aid, Endevor, SPUFI, MQ Series, QMF, Stored Procedures, Sync sort Utilities.