SUMMARY

• 12+ Years of technical work experience in Software Engineering Application Development.
• 9 Years’ experience in ETL - IBM Infosphere Datastage Application Development and Teradata Application Development
• 4 Years’ Experience in Mainframe Application Development.
• Expert in the domain of Retail, Insurance and Healthcare.
• In depth knowledge of Software Development Life Cycle (SDLC) and Lean IT Methodology having thorough understanding of various phases like Requirements, Analysis, Design, Development, Testing and Implementation.
• Proficient in system analysis and design ensuring smart technical and business assessments of business requirements and designing system to achieve increased efficiency, cost, and quality.
• Experienced in Functional, Regression, Integration and User Acceptance testing with development, execution and maintenance of test plans, test cases, test scenarios and metrics.
• Experienced working in onsite-offshore model with emphasis on project delivery and maintenance.
• Managed and executed various phases of multiple projects simultaneously.
• Experienced in doing Root Cause Analysis, Feasibility studies and Risk Assessment studies.
• Exposure in Business Requirement Gathering by working with various levels of internal vs external customers.
• Trained resources in IBM Infosphere Datastage in development and testing.
• Exhibited Team leading and management skills with proven capability in goal-oriented communications.
• Demonstrated high capacity to learn new technologies rapidly with no formal training.

TECHNICAL SKILLS

ETL Tool: IBM Infosphere Datastage 8.0.1, 8.1, 8.5, 8.7, 11.5

Database: DB2, Teradata, Netezza, Informix, Oracle, Microsoft SQL Server, Sybase, AIX 6.1

Operating System: UNIX, Microsoft Windows XP, Microsoft Windows 2003 server

Secondary Technology: IBM MAINFRAME

Language: VS COBOL II, JCL

Back End: VSAM, DB2

Front End: TSO/ISPF, CICS

Operating System: MVS/ESA on IBM-3090

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Datastage Developer

Responsibilities:

• Analyzing the Hash file list and its types
• Migrating the hash files which includes both regular and distributed hash file from Datastage 8.5 to 11.5 server
• Created a Shell script to get the list the directory structure and the static file list from legacy server for migration
• Designed IBM info sphere parallel jobs using stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Lookup, Pivot, and Sort, Surrogate key Generator, Change Data Capture (CDC), Modify, Row Generator and Aggregator.
• Used both Pipeline and Partition Parallelism for improving performance.
• Involved in Jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc.
• Created a shell script to compare the directory structure and the file list from legacy Vs new Datastage version for completeness
• Developed a shell script to compare the Hash File List migration and comparison for completeness
• Handling of production DataStage jobs using ESP Scheduler.
• Migrated the jobs from legacy version to 11.5 version
• Converted the legacy/deprecated stages to 11.5 compatible stages for the parallel jobs
• Fixed the issues in the jobs while migrating from 8.5 to 11.5
• Developed a POST job for all newly built environment in 11.5 version
• Deploying the jobs to 11.5 Dev to QA to Stage to Production

Environment: IBM Infosphere Datastage 8.5/11.5, IBM DB2 10.5, Datastage 11.5, MS SQL Server, Sybase, AIX 6.1, MQ Series, Putty, FileZilla, Team Foundation Server, Zena, DB2, IBM Data Studio, Microsoft Team Foundation Server

Confidential

Responsibilities:

• Work with BCBS Business team in requirement gathering
• Developing Technical Solution to the project
• Develop the interfaces using the ETL tool IBM Infosphere Datastage 8.5 with DB2 as Data Source/target
• Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, Change Apply, Change Capture, MQ Stage, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Compare, Oracle Enterprise, Surrogate Key, Aggregator, Transformer stages.
• Developing Shell Scripts to automate file manipulation and data loading procedures.
• Coordination with other groups like Network, Infrastructure, Information Security, Architecture Governance etc.
• Coordination with different Track/Portfolio team in providing Technical support and development activities
• Design, Functional/Non-Functional test case and result reviews
• Conducting reviews with different stakeholders of the project
• Deployment to TST, Stage and Production environment

Environment: IBM Infosphere Datastage 8.5, IBM DB2 10.5, Putty, FileZilla, Team Foundation Server, Zena, DB2, IBM Data Studio, Visual Studio 2015

Confidential, Pleasanton, CA

Datastage Developer

Responsibilities:

• Work with Confidential Business team in requirement gathering
• Used Datastage Parallel Extender to load data, utilizing the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Developing Technical Solution to the project
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator from various database DB2 Enterprise, Oracle Enterprise.
• Develop Software architecture for the project
• Coordination with other groups like Network, Infrastructure, Information Security, Architecture Governance etc.
• Used Distributed Transaction Stage for treating the read, deleting messages and delivery of rows to a database.
• Coordination with different Track/Portfolio team in providing Technical support and development activities
• Design, Functional/Non Functional test case and result reviews
• Conducting reviews with different stakeholders of the project
• Coordination of Deployment and transition activities

Environment: Oracle 11g, UNIX Shell Script, Putty, FileZilla, Changeman DS, ESP, Oracle SQL Developer

Confidential

Responsibilities:

• Worked on the Design, Development, Unit testing, deployment and production monitoring.
• Coordinating with Software Architect, Business Analysts, Project Managers in collecting the Business requirements
• Preparing the estimates

Environment: Teradata 14, Unix Shell script, ESP, Designer Client, Director Client, Putty, FileZilla, Changeman DS, ESP, Oracle SQL Developer

Confidential

Responsibilities:

• Preparing the SAD - Software Architecture Document
• Analyzing the Jobs for DS 8.7 feasibility
• Assigning the tasks to Team Members
• Preparing the estimates
• Attending the Stage Gate Meetings

Environment: IBM Infosphere Datastage 8.1, Netezza, Teradata, Microsoft SQL Server, Unix Shell Script, Designer Client, Director Client, Aginity Netezza, Squirrel SQL client, Putty, FileZilla, Changeman DS, ESP

Confidential

Responsibilities:

• Involved in the creation of jobs using Datastage Designer and used Director to Validate, Schedule, Run and Monitor the Datastage jobs.
• Information is stored in table definitions in the repository and is entered using the Datastage manager.
• Worked with Orchestrate environment for parallel processing at Job & lookup stage.
• Analyzing the requirement and preparing Understanding Document
• Analyzing the System and preparing Low Level Design Document
• Developing the batch jobs in IBM Infosphere Datastage and Unix Shell Scripts to trigger these batch jobs.
• Involved in Unit Testing and preparing Unit Test Results
• Scheduling the Jobs in ESP
• Scheduled ETL processes to avoid Conflicts both at Resource utilization level, Database lock issues and to avoid Datastage contention issues.
• Deployment to QA
• Monitoring the jobs in QA

Environment: IBM Infosphere Datastage 8.0.1, Informix, Squirrel SQL Client, Changeman DS, ESP, FileZilla, Putty, Designer Client, Director Client

Confidential, Atlanta, Georgia

ETL Datastage Developer

Responsibilities:

• Involved with Business users and ETL Leads from different teams to implement ETL Frame Work using Server and Parallel jobs.
• Proficient in writing, implementation and testing of triggers, procedures and functions in PL/SQL and Oracle
• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Datastage to populate tables in Data Warehouse and Data marts.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Created shell script to run Datastage jobs from UNIX and then schedule this script to run Datastage jobs through scheduling tool.
• Implemented parallel extender jobs for better performance using stages like Join, Merge, Sort and Lookup, transformer with different source files complex flat files, XML files.
• Created Datastage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems like ODS, flat files, scheduled the same using Datastage Sequencer for SI testing
• Involved in creating UNIX shell scriptsfordatabase connectivity and executing queries in parallel job execution.
• Used the ETL Datastage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.

Environment: IBM WebSphere Datastage 8.0 (Designer, Director, Administrator), DB2, SQL Server, Oracle 9i, IBM AIX UNIX, VSS.

Confidential, Dallas TX

Datastage Developer

Responsibilities:

• Created Detail Design Documents and Mapping documents based on High Level Design and specifications given by business.
• Designed and developed Enterprise Edition DataStage jobs based on requirement specifications given by Business.
• Created various fact and dimension tables in data warehouse like Member Dimension, Provider Dimension, Assignment Fact, Enrollment Fact tables using SSIS 2008
• Designed and developed DataStage routines to simplify the design and improve the performance.
• Developed Shared Containers for reusability.
• Tuned PL/SQL procedure to improve the performance of ETL process.
• Developed jobs to read data from Flat Files received from external vendors.
• Developed Processes for ASGZena Scheduling.
• Extensively used Dataset, Aggregator, Sort, Join, Funnel, Lookup, Merge, Filter and other parallel stages in developing the solution.
• Extensively used Enterprise/ODBC stages to read data from Oracle, DB2 and SQL Server databases.
• Developed DataStage jobs using Lookup stage for Range Lookup.
• Created Job parameter sets for reusing the parameters.
• Extensively used Resource Estimation feature of DataStage to implement ETL solutions with good performance.
• Implemented restart ability in all DataStage sequencers
• Understood and updated existing DataStage jobs to accommodate changes requested by users.
• Worked closely with Business Analyst in providing efficient solution with good turnaround time.
• Created Unit test plans and updated the documents based on the testing.
• Supported Quality Analysts during System/Integration testing phase.
• Supported business users during User Acceptance Test (UAT) and Post Implementation Phase.

Environment: IBM Info Sphere Information Server 8.0.1 (DataStage, Information Analyzer), SQL, Teradata, Unix shell programming, Windows XP, IBM DB2,Toad,ASG Zena Scheduler, Test Director 8.0.

Confidential

Datastage Developer

Responsibilities:

• Specification analysis and designing the solution for the problem
• Analyzing the program and preparing specification document
• Involved in developing shell scripts
• Unit Testing & Integration testing

Environment: ETL - Korn Shell Script, DB2, SPUFI (in Mainframe TSO)

Confidential

Responsibilities:

• Specification analysis and designing the solution for the problem
• Analyzing the program and preparing specification document
• Involving in coding, debugging and testing of programs
• Unit Testing & Integration testing

Environment: COBOL, JCL, DB2, VSAM, CICS, INTERTEST, EXPEDITOR, ENDEVOR, FILE-AID, INSYNC, SPUFI, QUALITY CENTER