PROFESSIONAL SUMMARY:

• Over all 12+ years of Experience in Information Technology
• 8+ Years of Experience in Data warehousing and ETL tools
• 8+ years of Experience in IBM Infosphere Datastage, Oracle, Db2, SQL
• 6+ years of Experience in UNIX and Control - M.
• 4+ Years of Experience in Informatica Power Center and Teradata
• 2+ years of Experience in Netezza
• 4+ years of Experience in Z/OS Mainframe skills.
• Expertise interacting with Business Analyst and Clients to understand the requirement. Create Technical Architectural design and ETL detailed design document
• Experienced working on agile methodology projects.
• Well versed on Data warehousing concepts, Dimensional modelling, Slowly changing dimension and good at designing Data warehouse architecture
• Extensive hands-on experience in building ETL interfaces to aggregate, cleanse and migrate data across enterprise-wide Data Warehousing systems using staged data processing techniques, patterns and best practices.
• Strong experience in full life cycle management of capturing, versioning and migrating various ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments using vendor platforms such as DataStage by establishing standards, guidelines and best practices
• Expertise on data profile of the business data to identify the data anomalies and define/create rules to identify the less quality of the business data using ETL data analysis and Developer tools
• Expertise in integration of various data sources with multiple relational databases like Oracle,Db2 and worked on integrating data from non-relational sources like flat files
• Experienced in debugging mappings. Identifying bugs in existing mapping by analyzing the data flow and evaluating transformations and emphasized on performance of mapping optimizations
• Strong technical and analytical skills with the ability to analyze information identify and formulate solutions to problems. Provides more in-depth analysis with a high-level view of goals and end deliverables

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere Datastage, Informatica Power Center

Databases: Oracle, DB2, Teradata and Netezza

Languages: SQL, UNIX and COBOL

Other Tools: SQL developer, Squirrel, Putty, MobaXterm, Beyond Compare and Control-M

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio,TX

ETL Lead /Consultant

Responsibilities:

• Work on agile methodology and attend the daily standups to update the status and impediments if any. Discuss the project clarifications on parking lots.
• Work closely with the Senior Business Analyst and understand the requirement. Create Technical Architectural design document and update the wiki pages of Confidential
• Have multiple meetings with modelers on designing the member experience Data warehouse using the Dimensional modelling techniques and ensure the tables comply SCD type I and II wherever necessary.
• Have Brainstorm sessions with multiple application owners to identify the source of the data to build member experience Data warehouse. Design the ETL architecture and come up with the different processes/modules needed to achieve the requirement
• Develop Datastage parallel jobs using different stages such as Join, Lookup, CDC, Transformer, Sort, ORACEL, DB2, NETEEZA, HIVE connectors, etc.
• Develop Datastage Sequence jobs using different activities such as execute command, Job activity, Nested Conditions, Start Loop, End loop, User Variables activity, etc. Create Reusable jobs for Extract and Load process for distinct source/target connections
• Write Complex SQL queries and configure it in Data warehouse table. Extract the Configured Queries and process it using the sequencer jobs by triggering the Reusable parallel job. Start and End loop activities are used to run the queries one by one against the different source connections such us DB2 UDB, ORACLE, NETEEZA and HADOOP.
• Transform the data using the required business logics and load it through the reusable load jobs to different target. Trouble shoot, rerun and Monitor the jobs using IBM Infosphere Datastage Director. Develop Configuration files, parameter files and UNIX scripts in E3 framework. Create Batch cycle folders and schedule it using Control-M
• Walkthrough the development in the Review meeting with Enterprise Production support team and get the comments from them. Move the project from DEV to TEST region, validate and get the sign off from Quality control team.

Environment: DB2 UDB, Oracle 11g, NETEEZZA, UNIX

Tools: Used: IBM Infosphere Data stage 11.5, Squirrel, Putty, MobaXterm and Control-M

Confidential, San Antonio,TX

ETL Developer

Responsibilities:

• Analyzed Business Requirements by working closely with Business Area and client
• Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM Infosphere Datastage.
• Developed parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage) and processing stages (Aggregator, Change Capture, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Analyzed source system feeds and designed ETL jobs accordingly
• Used Data Stage Designer for developing various jobs to extract data from different sources and loading data into Data warehouse tables and datasets for validation testing and Production run.
• Creating the sequences using DataStage Sequence activities (Job Activity, Execute Command, Set Variable, Start Loop, End Loop and Notification activities) for creating complex data process flows for loading the data into the Data Mart tables.
• Used the job properties to define the job level parameters, specifying the before/after job sub routines and to control the job execution.
• Execute the UNIX shell scripts from Control-M to execute the parallel and Sequencer jobs
• Analyzing the dependencies between the jobs and scheduling them accordingly using the Control-M

Environment: Oracle 11g, DB2, NETEEZZA, UNIX

Tools: Used: IBM Infosphere Data stage 9.5, SQL developer, Putty, winSCP, Beyond Compare and Control-M

Confidential, San Antonio,TX

ETL Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and requirements document reviews.
• Prepared Technical Specification Documents for the Jobs and their reviews.
• Building the SQL queries for Oracle to fetch the data from the Database as per the business requirement and use the SQL queries in the DataStage for further processing.
• Designed and developed Jobs by using the Designer that extract data from the Oracle database, cleanse it, transform it as per business requirement and populate the data into flat files.
• Used DataStage Director to Run and Monitor the Jobs performed, automation of Job Control using Batch logic to execute and schedule various DataStage jobs.
• Developed SQL Queries for implementing Complex business rules and transformations.
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data. Participated in UAT (User Acceptance Testing).
• Good on Fine tuning the jobs. Mentor development team on Data Stage.

Environment: Oracle 11g, NETEZZA, UNIX

Tools: Used: IBM Infosphere Data stage 9.5, SQuirrel, Putty, winSCP, Beyond Compare and Control-M

Confidential, Franklin, TN

ETL Lead

Responsibilities:

• Played a role as a solution consultant assisting with data modeler in the full development cycle of warranty data warehouse systems and responsible for creating project plans and executed them.
• Coordinated with the client managers, business analyst and data architects for various sign offs on ETL Architectural design docs, testing docs, migrations and end user review specs.
• Involved in business analysis and technical design sessions with business and technical staff to develop entity relationship/data models, requirements document and ETL specifications.
• Prepared data mapping documents and design the ETL jobs based on the BRD with required tables in the Dev environment.
• Gathered requirements of various external systems and provided effort estimates for the design and development.
• Analyzed the data using SQL and developed medium & complex SQL queries for data analysis and validation of data
• Extensively used SQL for building and running the queries for issue analysis and for the extracts requested by End Users and for Month end validation Process
• Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Column Generator and Row Generator etc.
• Analyzed the system performance and used both SQLs and ETL components as needed based on the job performance
• Maintained the data warehouse by loading Dimensions and Facts as part of the project.
• Involved in the implementation procedure to move the project into PRODUCTION environment

Environment: DB2, Teradata, UNIX

Tools: Used: IBM Infosphere Data stage 9.1, Informatica Power center, SQL Developer, Putty, winSCP, Control-M

Confidential

ETL Developer

Responsibilities:

• Involved in the troubleshooting, performance testing of the Datastage jobs & SQLs involved.
• Extensively used Datastage designer to design and develop ETL jobs for Extracting, Transforming and loading the data into different data marts.
• Performed import and export of the Datastage components and table definitions using Datastage manager.
• Created Sequencer jobs to sequentially execute the designed jobs.
• Used after/before job routines to perform specific tasks.
• Implemented enhancements to the current ETL programs based on the new requirements.
• Worked on improving the performance of the designed jobs by using various performance tuning strategies like Partition of Table, tuning the SQL as per the query plan.

Environment: DB2, Teradata, UNIX

Tools: Used: IBM Infosphere Data stage 8.1/9.1,Informatica Power center, SQL Developer, Putty, winSCP, Control-M

Confidential

ETL developer

Responsibilities:

• Prepared Technical specification documents like Low level and high level design documents.
• Extracted data from oracle database and transform it using the transformation and loaded further into Oracle Database.
• Used stage variables for source validations, to capture rejects and used Job parameters for Automation of jobs.
• Used lookup stage with reference to oracle tables for insert/update strategy and updating of slowly changing dimensions.
• Performed Unit testing of all monitoring jobs manually and monitored the data to see whether the data is matched.
• Involved in Trouble-shooting problems in DataStage.
• Involved in migrating the jobs from Dev, Test & Prod environments.
• Involved in unit, performance, Regression and Integration testing of data stage jobs and prepared documentation
• Support for SIT (System Integration Testing), UAT (User acceptance Testing) and production implementation.

Environment: Oracle, DB2, UNIX

Tools: Used: IBM Infosphere Data stage 8.1, SQL Developer, Putty, winSCP, Control-M

Confidential

ETL Developer

Responsibilities:

• Analyzing the business mapping rules and creating the equivalent low-level design
• Extracted data from oracle database and applied business logic to transform and load them back to oracle database
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Router, Lookup, etc.
• Create sessions and workflows in workflow manager to run the batches with the logic embedded in the mappings
• Documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document

Environment: IBM Infosphere Data stage 8.1, Oracle and UNIX

Confidential

System Analyst

Responsibilities:

• Responsible for applications OA, LISA, FADS and P-END
• Responsible for monitoring daily production cycles and fixing the production failures within SLA (Service Level Agreement)
• Interact with the customers and follow up the issues raised by them until it is resolved thus ensuring customer satisfaction
• Working through SDLC for any business changes and implement it into PROD
• Preparing Sox evidences, maintaining documentation for every incidents/Changes

Environment: COBOL,JCL,DB2,VSAM,IDMS,ADS/O

Tools: Used: Xpeditor, File aid, changman, QMF, SPUFI, DMLO, OLQ and Adsalive