SUMMARY

• 10 years of Real - time experience in IT Industry (Data Warehouse, Business Intelligence and Databases) with extensive knowledge in Developing, Designing, and implementing using IBM Infosphere Information suite products, Ascential software, UNIX, SQL, PL/SQL, Mainframe, Cognos and windows in various industries such as Insurance, Banking, Finance .
• Strong Experience in Mainframe coding, testing and support using various tools such as File-Aid, Endeavor, OPC Scheduler, NDM, TSO/ISPF.
• Extensive Experience working in Data Warehouse (OLAP) using IBM InfoSphere Datastage, IBM InfoSphere Datastage versions 11.x/9.x/ 8.x/7.x Server Edition and Enterprise Edition using components like Administrator, Manager, Designer and Director
• Experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers & Packages .
• Strong Experience in Logical and Physical Data Modeling using Erwin tools using Star Schema and Snowflake Schema in designing of Data Marts, Fact and Dimension Tables.
• Excellent knowledge and experience in Data warehouse development life cycle in data profiling, data cleansing, data analysis and dimensional modeling and implementation of STAR, Snowflake schemas and slowly changing dimensions.
• Exposure to Reporting tools like Cognos, OBIEE and Tableau
• Knowledge on Big data technologies like Hadoop, HDFS, Hive, MapReduce, PIG, NoSQL, Sqoop
• Worked on DataStage Migrations from DS 7.5 /8.1 to DS 9.1 in Confidential and from DS 8.1 to DS 11.3 in Confidential -CREF Projects.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical design, code development, testing, implementation and maintenance of Business applications with Dimensional Data Warehouse/Data Marts
• Experience in design environment as well as production support group to monitor, support and quickly identify the issues and fix the process in the production environment.
• Good domain knowledge in Banking especially in Wealth Management and have good knowledge on Managed products within wealth management divison.
• Extensively worked with DataStage EE for parallel processing to improve job performance.
• Experience in integration of various data sources like Oracle Exadata, DB2/UDB Enterprise Stage, Teradata, SQL Server and Flat files into the Staging Area. Extensively worked with materialized views and TOAD
• Designed and implemented various Stages in Process using IBM WebSphere DataStage components like Sequential file, Data set, DB2, ODBC Enterprise, CDC, Lookup, Transformer, Sort, Aggregator, Join, Merge, Copy, Remove Duplicates, Funnel, Row Generator, Surrogate Key Generator for developing Parallel jobs.
• Worked with SAP IDOC Stages and ABAP extract stages for Extracting and Loading data in SAP
• Built test cases and constructed test-data from test cases in order to arrive at test-drivers .
• Performed Functional, Negative, Regression, System integration Testing (SIT), User Acceptance Testing (UAT), Performance testing and Unit testing using Inter test and compare the test results with Unit Test Plan & Jclsync and log the defects in IPMS Quality control tool for defect tracking, Casual analysis and Issue resolution.
• Extensively worked with DataStage EE and Quality Stages for parallel processing to improve job performance and cleanse the data to maintain Quality standards conducive for reporting .
• Utilized Serena Devops tools to migrate the code from Development environment to QA and then to Production Environments.
• Experience working with scheduling tools like Autosys, Robot and Tidal
• Have on Good Unix scripting skills needed to perform scheduling and file move functions in Linux Server.
• Developed enterprise, data architecture diagrams fulfilling business needs and improving technology functions
• Good knowledge on WINSCP3 and PUTTY to edit, move or copy files on the server.
• Working experience in interacting with Business Analysts and developers to analyze the user requirements, functional specifications and system specifications
• Worked with Business Users and have clear understanding of Business Procedures and ability to work as an individual and as a part of a team.
• Excellent Analytical and Logical programming skills with a good understanding at the Conceptual level and Possess Excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals.
• Possess excellent skills in dealing with the Customers and Business Users.
• Experience in creating the BRD’s, HLD and LLD for the project.

TECHNICAL SKILLS

Databases: Oracle Exadata, IBM DB2, SQL Server 2008/2014,Teradata

Programming Language: SQL, PL/SQL, UNIX shell scripting, Cobol, JCL,VSAM

ETL Tools: IBM Infosphere DataStage and Quality Stagee 11.x/9.x/ 8.x/7.x, Enterprise and Server Edition, Informatica 8.6.1, MS SSIS 2008

Data Modeling Tools: Erwin 6.0/5.5/4.0, MS Visio 2003/2000

RDBMS Tools: Oracle SQL Developer, TOAD 8.5, QTODBC, SQL*Loader (Oracle), SQL*Plus, Advanced Query Tool

Operating Systems: Windows Server, Windows XP, Windows 2000, UNIX, Red Hat LINUX, IBM MainFrame

Version Control: Endevor, TFS, IBM Rational Clear Case Explorer, Win CVS, Starteam

Scheduling Tools: Autosys, OPC Scheduler, Robot, Tidal

Other tools: WINSCP3, PUTTY, Cognos Report Studio, SPUFI, Endeavour, File Aid, NDM, TSO/ISPF, Serena DevOps, VSTS

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr ETL Developer

Environment: IBM WebSphere DataStage EE 11.5, MS-Visio, Red Hat Linux, Teradata, IBM DB2, Robot Scheduler, Tortoise SVN, Serena DevOps tool

Responsibilities:

• Involved in Analysis of the business requirements to draft functional and technical solutions that drives the analysis and technical designs that are aligned with business/IT strategies and comply with corporate architectural standards.
• Analyzed the Business Requirement Document and presented the database model and participated in investigation of data subject areas to document the data flows to determine the System Impacts in Integrated Applications.
• Design Logical Datawarehouse models and specific DataMarts to house the data from different applications that meet the reporting needs required from the Data warehouse.
• Prepared detailed Technical Specification documents and created test plans.
• Built test cases, constructing test-data from test cases, arriving at test-drivers from test-data.
• Integrated various sources and targets in to the staging area for Integrating and Cleansing data.
• Used IBM WebSphere DataStage QualityStage Enterprise Edition 11.3/8.1 and Websphere Director to build the ETL Applications.
• Designed various DataStage Jobs with QualityStage Stages, Transformer, DB2/UDB Enterprise Stage, and Dataset Stage, Merge, Sort, Aggregator Stage, Lookup Stage, and Output Stage with various other stages.
• Worked with SAP idoc Stages and ABAP extract stages for Extracting and Loading data in SAP
• Performed Functional, Negative, Regression, System integration Testing (SIT), User Acceptance Testing (UAT), Performance testing and Unit testing using Inter test and compare the test results with Unit Test Plan .
• Verified test results and have logged Test-results for reporting, Defect tracking, causal analysis, and resolution.
• Preparation of weekly status report to report day to day Activities to the Management team.
• Create Process to ensure Data Quality checks on the data that is processed in the ETL and loaded into the Datawarehouse prior to the hand-off of the reporting process.
• Scheduled jobs using UNIX Script in AutoSys.
• Involved in documentation to describe program development, logic, coding, testing, changes and corrections.
• Provide Process run time support and end user training.

Confidential, Charlotte NC

Datawarehouse Architect and ETL Technical Lead

Environment: IBM WebSphere DataStage EE 11.3/8.1, MS-Visio, Red Hat Linux, Oracle Exadata, Teradata, Apex, Autosys Scheduler, Starteam, Serena DevOps tool

Responsibilities:

• Involved in documentation to describe program development, logic, coding, testing, changes and corrections.
• Participated in Design, Testing, support and Documentation of SDLC including Client and business users Interaction
• Analyzed the Business Requirement Document and the present database model and participate in investigation of data subject areas to document the data flows to determine the System Impacts in Integrated Applications.
• Design Logical Datawarehouse models and specific DataMarts to house the data from different applications that meet the reporting needs required from the Financial Data warehouse.
• Create DDL’s and DML’s to create Physical tables in Oracle Data warehouse and provided the required grants to enable access to the user community and safeguard the security of the data by providing the optimized access based on the needs of the user community.
• Prepared detailed Technical Specification documents and created test plans.
• Design, Develop and Enhance ETL Processes to load the data from different source systems including Oracle, SQL Server, Teradata and Flat files into Data warehouse using DataStage.
• Built test cases, constructing test-data from test cases, arriving at test-drivers from test-data.
• Performed Functional, Negative, Regression, System integration Testing (SIT), User Acceptance Testing (UAT), Performance testing and Unit testing using Inter test and compare the test results with Unit Test Plan & Jclsync.
• Verified test results and have logged Test-results for reporting, Defect tracking, causal analysis, and resolution
• Integrated various sources and targets in to the staging area for Integrating and Cleansing data.
• Used IBM WebSphere DataStage QualityStage Enterprise Edition 11.3/8.1 and Websphere Director and Information Analyzer to test the ETL Applications.
• Performed Migration testing and data compatibility checks for applications migrated from Windows DataStage 8.1 applications to Data Stage 11.3 Applications.
• Managed the Production Support activities and have assisted in Production deployment Support in order to deliver the projects successfully.
• Preparation of weekly status report to report day to day Activities to the Management team.
• Create Process to ensure Data Quality checks on the data that is processed in the ETL and loaded into the Datawarehouse prior to the hand-off of the reporting process.
• Scheduled jobs using UNIX Script in AutoSys.
• Provide Process run time support and end user training.

Confidential, Pennington, NJ

ETL Technical Lead

Environment: IBM WebSphere DataStage EE 9.1/8.1/7.5.2 , MS-Visio, Red Hat Linux, IBM DB2 UDB, Cognos Report Studio, IBM MainFrame, JCL, VSAM, COBOL, DB2

Responsibilities:

• Involve in Analysis of the business requirements to draft functional and technical solutions that drives the analysis and technical designs that are aligned with business/IT strategies and comply with corporate architectural standards.
• Develop, enhance and maintain source to target mapping documentation based on the business requirement specifications.
• Using the IBM Information server 9.1, 8.1 and 7.5 versions extensively to transfer and load data into the staging area and into Warehouse to support intelligent reporting.
• Migrated the Data Stage 7.5/8.1 versions to 9.1 version including the Server jobs from the 7.5 Version.
• Design, Develop and Enhance ETL Processes to load the data from different source systems including Oracle, SQL Server, Teradata and Flat files into Data warehouse using DataStage.
• Developed ETL Processes to automate the Data Quality checks in order to ensure data completeness prior to it’s processing by the Data warehousing Applications.
• Analyze performance and technical capacity issues with systems/applications while monitoring daily production support and respond to issues as needed.
• Provide Process run time support and end user training.
• Involved in documentation to describe program development, logic, coding, testing, changes and corrections.

Confidential

Datawarehouse Developer

Environment: IBM WebSphere DataStage EE 8.1/7.5.2, MS-Visio, Red Hat Linux, IBM DB2 UDB, Mainframe, JCL,COBOL,DB2,VSAM

Responsibilities:

• Participated in Design, and Coding, Testing, support and Documentation of SDLC including Client Interaction.
• Used IBM WebSphere DataStage QualityStage Enterprise Edition 8.1/7.5
• Architecting IBM WebSphere DataStage ETL solution
• Created ETL mapping documents
• Responsible for Design and Developing ETL Jobs for processing inbound and outbound data and integrating that data into the clients back end solution
• Designed various DataStage Jobs with QualityStage Stages, Transformer, DB2/UDB Enterprise Stage, and Dataset Stage, Merge, Sort, Aggregator Stage, Lookup Stage, and Output Stage with various other stages.
• Used DB2 Stages to Read Data and Transformed into Target SQL tables using various Transformation Rules (Business Rules).
• Performed Functional, Negative, Regression, System integration Testing (SIT), User Acceptance Testing (UAT), Performance testing and Unit testing of the newly built Applications.
• Logged defects in Quality control tool for effective tracking and speedy resolution
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Designed and developed Job Sequences using various Components like StartLoop Activity, EndLoop Activity, Routine Activity, Job Activity, Notification Activity, and Wait for File Activity, Terminator Activity, and Exception Handler.
• Used Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Developed UNIX shell scripts to automate the Data Load processes to the target Data warehouse
• Scheduled jobs using UNIX Script in AutoSys.
• Involved in documentation to describe program development, logic, coding, testing, changes and corrections.

Confidential

Software Developer

Environment: IBM Mainframe, IBM WebSphere Datastage 7.5, IBM DB2, and Windows XP Professional, JCL,COBOL,DB2,VSAM

Responsibilities:

• Understand the new requirements, analyze the existing system.
• Preparing Low Level Design (LLD)
• Coding based on the design and coding standard
• Preparing Unit Test Plan (UTP), Unit Test Result (UTR).
• Fixing defects and updating test results.
• Involved in creating Mainframe Unload jobs and transmission jobs to send the data to ETL Server.
• Involved in developing the Data stage Jobs that source the data from Mainframe files and Oracle tables and transform them and load the data into the Datamart. .
• Involved in preparation of JIL for scheduling in Autosys.
• Involved in the support activities.
• Involved in the preparation of the deployments documents.