SUMMARY

• Over 15 Years of experience in System Analysis, Design, Development and Quality Analysis.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Performed Unit testing and System testing to validate data loads in the target.
• Designed Test case templates for Unit and Regression tests
• Over 5 Years of experience in the fields of Data warehouse and Data Mart applications using Talend Open Studio 6.5/7.x and IBM Information Server 8.x/9.x Data Stage, Oracle, PL/SQL, SQL Server, DB2, TOAD, Erwin, VISIO and Shell Scripts.
• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Designed and executed various Test scripts for Regression tests.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Validated data moving from different sources to target using Data Stage.
• Extensively interacted with developers, business& management teams to understand the Prime Analytics project business requirements and ETL design document specifications.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Extensive experience in Data warehousing tools like Talend Open Source, IBM Information server 9.x/8.x(Designer, Director and Administrator) and Ascential Datastage 7.5.2/7.5.1 (Manager, Designer,Director and Administrator) and Data Modeling Tools
• Extensive experience with Oracle, DB2, MS SQL,Red Shift databases.
• Extensive experience working with Oracle 8i/9i/10g including PL/SQL programming.
• Experience with Datastage Administration activities.
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Fact and Dimension Tables
• Extracted data from heterogeneous sources like SQL server, Oracle, DB2.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts using Ascential Datastage (Designer, Director and Manager).
• Experience in Shell Scripting (Korn Shell).
• Experience in BI Reporting tool (Business Objects).
• Experienced in using highly scalable parallel processing Infrastructure using Data Stage Parallel Extender (DS - PX)
• Experience in integration of various data source like Oracle, SQL Server, DB2.
• Ability to work with client to identify source-target data and their availability, data extraction, processing and testing skills, proficient with multiple extraction, transformation and load tools.
• Experience with Conceptual, Logical and Physical data modeling

TECHNICAL SKILLS

ETL: IBM Ascential DataStage 9.x/8.x Administrator, Designer, Director, Manager, Parallel Extender, IBM WebSphere IBM Info Sphere Information Server 8.x/9.x, TOS, Talend Bigdata and Talend Cloud Platform 7.2

Data Modeling: Dimensional, Logical & Physical Data Modeling, Star Schema, Snowflake Schema, ER-Win 7.x

RDBMS: Oracle 11g/10g, DB2 10.x/9.x, SQL Server 2010, AWS RedShift, Snowflake

Programming: PL/SQL, K-Shell Scripting,VB Script, C, SAS, R, Python

Reporting: Business Objects, Cognos Reports 9.x/8.x

Operating System: Unix, Linux, Windows NT/XP/7 server

Scheduling Tools: Control-M, Autosys, Crontab Utility, IBM Tivoli, Star Team, Robot Scheduler

PROFESSIONAL EXPERIENCE

Confidential

QA Analyst

Responsibilities:

• Created Talend jobs which convert Store Procedures into Talend native code.
• Developed Talend jobs based on technical specifications/Data design documents and Source to Target mappings.
• Developed POC Talend jobs on ELT design approach.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Developed Talend pre and post job templates as part of data orchestration using data ingestion plan, audit, log tables.
• Used Various Talend components Tmap, Tlogcatcher,Tjava, Tjavarow, TJavaflex etc extensively.

Environment: Talend Cloud Platform 7.2, Snowflake, Windows 10, Autosys.

Confidential, Reston, Virginia

QA Analyst

Responsibilities:

• Created Talend jobs so that they can consume data from 51 CSV files into Redshift databse tables.
• Developed Talend jobs based on technical specifications/Data design documents and Source to Target mappings.
• Updated the existing Talend jobs so that they can handle loading of multiple files at single run and supports history load for data as well.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Validated data moving from different sources to target using Informatic DQ tool.
• Worked with DBA team to refresh the DEV tables from PROD if necessary as part of Unit testing.
• Worked with Business Analysts and Subject-Matter Experts to fill up the GRAY AREA in the Business Requirements before implementing the comprehensive ETL solutions.
• Performed Unit testing and System testing to validate data loads in the target.
• Used Various Talend components Tmap, Tunite, Treplicate, Tlogcatcher,Tjava, Tjavarow, TJavaflex etc extensively.
• Tracked the User stories, tasks, product backlog and sprint backlog in Jira.
• Deplyed the code from Dev to Test environment.
• Worked with Parquet files and Json files.
• Participate in Agile planning, grooming retrospective meetings to achieve AHR (Agile Health Radar) and AMM (Agile Maturity Model) which are Confidential home grown tools.

Environment: Talend Bigdate Platform 7.1, AWS Red Shift, Windows 10, PL/SQL, Jira, Agile, Putty, WinSCP, Aginity Workbench 4.9.1, JSon, MS Excel, EMR cluster.

Confidential

QA Analyst

Responsibilities:

• Updated the existing Talend jobs so that they can start consuming the hour & day part information from the order and Online files in the Uber tables.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Updated the existing Talend jobs by adding logic to avoid job failure due to some extra columns added to Uber Source files.
• Designed and Implemented the ETL process using Talend Enterprise Big Data Edition to load the data from Source to Target Database.
• As uber sku 3day files are becoming too large for Uber to process and send each day. As a solution, Uber is recommending that the uber sku 3day file is separated into 2 daily files. So, I have modified the existing Talend jobs to handle 2 SKU files to process separately.
• Updated the existing Talend jobs so that they can consume data from 5 Star rating and Missing Item file into Order table.
• Performed Unit testing and System testing to validate data loads in the target.
• Designed Test case templates for Unit and Regression tests.
• Tracked the user stories, tasks, product backlog and sprint backlog in Jira.
• Also, involved in production support for some extent.
• Worked with Text positional files and Mainframe positional files.
• Used TSystem component to process EDI files to and from Mainframe system

Environment: Talend Cloud Platform 6.5, AWS Red Shift, UNIX, Windows 10, PL/SQL, Jira, Agile, Putty, WinSCP, MS SQL Workbench, SQL Server 2016 Management Studio, MS Excel

Confidential, Eagan, MN

ETL Tester

Responsibilities:

• Documented the business requirements, developed test plans, test cases created for the database backend testing and to test database functionality.
• Designed and executed various Test scripts for Regression tests.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Validated data moving from different sources to target using Data Stage.
• Extensively interacted with developers, business& management teams to understand the Prime Analytics project business requirements and ETL design document specifications.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tracked the user stories, tasks, product backlog and sprint backlog in Jira
• Worked on burned down chart and burned up chart in Jira
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Raised defects in HP Quality Center/ALM defect tracking system.
• Claims for Pharmacy paid through EFT and verified 835 file
• Validated Batch Claims for Pharmacy paid through EFT and verified 835 file
• Validated Electronic Claims for Pharmacy paid through check Paper Remit.
• Validated Manual Claims for Member paid through check, weekly EOB.
• Validated Batch Claims for Pharmacy paid through check, Monthly EOB

Environment: IBM InfoSphere Information Server DataStage 11.5, HP ALM, SQL SERVER, SQL, UNIX, Windows XP, Oracle 10g/11g Agile, PL/SQL, Jira, SOAP, SOAP UI, QTP, Agile, Unix, MS Office, Excel .

Confidential, Chicago, IL

Analyst / Developer

Responsibilities:

• Involved in implementing star schema for the data warehouse using Erwin for Logical/Physical data modeling and Dimensional Data Modeling.
• Developed various jobs using Aggregator, Sequential file, Transformer stages, Change Capture.
• Developed Parallel jobs using Stages, which includes Join, Transformer, Sort, Merge, Filter and Lookup.
• Used Shared Containers and created reusable components for local and shared use in the ETL process.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Used DataStage Director Runtime engine to schedule and execute developed jobs and job sequences, and use Log events to monitor job progress and performance.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.
• Involved in mapping team discussions to solve the issues in mapping document.
• Worked on troubleshooting, performance tuning and performance monitoring for enhancement of DataStage jobs.
• Participate in walkthroughs of business requirements and design specifications for the projects. Involved in detail understanding of Star Schema and Snowflake architecture. Involved in Extensive testing of Type I and Type II Dimension tables and Fact tables

Environment: IBM InfoSphere Information Server DataStage 9.x/11.x, HP ALM, SQL SERVER, SQL, UNIX, Windows XP, Oracle 10g/11g Agile.

Confidential, Chicago, IL

Analyst

Responsibilities:

• Learned and understood IC Plus and Pharmacy Renewal systems.
• Worked in the agile development environment with frequently changing requirements.
• Automated the ETL testing process using Talend tool to validate source and target systems as per test cases.
• Validated Mapping document between source and target systems.
• Validated record count between source and target systems using Talend ETL tool.
• Performed Null and Duplicate Validations using Talend ETL tool.
• Validated Incremental loading using Talend ETL tool.
• Performed Date validation (For example, From Date should not greater than To Date, Date values should not have any junk values or null values)
• Actively participated in Scrum meetings, reviews and test coordination activities.
• Work closely with the development, support team to resolve any client/consultant/system issues.
• Participate in design walk-through and review test scripts to ensure that they meet the business objectives.

Confidential

QA Analyst

Responsibilities:

• Extensively analyzed/tested various Confidential application modules (Agreements, Awards, Billbacks, Chargebacks, Deals, Sales Rebates, & Incentives, Royalties) to validate and verify their various functionalities.
• Participated in Business Requirement walkthroughs along with Business Analysts and development team to better understand the new features of application modules.
• Prepared Test Scenarios and Test Cases as per functional, Business requirements, Knowledge transfers given by developers.
• Successfully managed integration testing of Confidential applications with SAP HANA system.
• Learned and understood the application products developed by the business KTS prior to start writing any new test cases for every new release.
• Work closely with the development, support team to resolve any client/consultant/system issues.
• Participate in design walk-through and review test scripts to ensure that they meet the business objectives.
• Identified functionality and Performance issues, including: deadlock conditions, database connectivity problems and system crashes under load
• Involved in developing end to end test scenarios for various application modules.
• Involved in Premium Qualification testing and User Acceptance testing as well.
• Interacted with offshore team to resolve defects and functional issues of Confidential application modules.
• Responsible for reviewing functional specs design documents, test case writing, test execution, reporting and resolving issues, follow up, writing release notes and prepare documentation for knowledge transfer.
• Actively participated in the analysis, testing, deployment & production support phases of SAP Confidential release and support packs.
• Analyzed business requirements and processes in order to create test plan, configure the end to end business scenarios to test and minimize client issues.
• Managed Regression testing, Performance testing, User Acceptance (UAT) testing and Security testing to comply with SAP America's standard in each testing cycle to ensure the highest quality product.
• Worked with ALM/Quality Center to trace the requirements, write the Test Cases in the test plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.
• Generated daily test executions, defects tracking and RTM status report using tools like HP ALM/Quality Center.
• Designed test scenarios based on the use cases in HP Quality Center.
• Generated requirements traceability matrix (RTM) using HP Quality Center.
• Developed test plan for Order Management Service using HP Quality Center.

Confidential, San Antonio, IL

Analyst/ ETL Developer

Responsibilities:

• Created datastage jobs for purging daily snapshot tables which are older than 45 days of records.
• Involved in validation framework for reconciliation of jobs for meeting QCs such as performing data count, data comp between source and target data.
• Modified the existing datastage jobs to make reusable for other business functions such as publishing the data into target tables.
• Worked with DBA team to refresh the DEV tables from PROD if necessary as part of Unit testing.
• Used DataStage Director to monitor, analyze and debug Datastage jobs.
• Used Various Parallel Stages Lookup, CDC, Merge, Join, Modify, Funnel, Filter, Switch, Aggregator, Remove Duplicates and Transformer, Peek Stages etc extensively.
• Unit tested DataStage Jobs in development including creating the appropriate test data.
• Used Control M scheduler to automate the execution of all ETL Jobs.
• Used Datastage Director for Job Scheduling, monitoring performances and for troubleshooting from LOG files.
• Worked with Datastage Administrator to define the project properties etc.
• Designed Job sequences to control and execute the Datastage jobs using various Activity stages like
• Job Activity, User variable, Notification Activity, Exception Handler etc.
• Developed documents like Source to Target mapping for developing the ETL jobs.
• Designed and implemented slowly changing dimensions (SCD's) methodologies.
• Responsible for monitoring all the jobs that are running, scheduled, completed and failed. Troubleshooting the failed jobs is a primer in these situations.
• Involved in the deployment of DataStage jobs from Development to QA environment.
• Effectively and efficiently interacted with the client in gathering business requirements for the ETL module.
• Gathering the metadata definition of the source systems, preparing Transformation rules according to the business requirements for new enhancements.
• Actively involved in everyday job monitoring and resolved all the issues which are related to job aborts and job failures.
• Redesigned few jobs in Datastage Designer to meet the changes in new incoming feeds.
• Involved in importing and exporting jobs category wise and maintaining the backup regularly.
• Good experience in working as coordinator to offshore team from Onshore.
• Worked closely with the Data analyst and business analyst during the design and development of ETL technical specification document.
• Working on improving performances of the jobs to meet strict timelines.
• Worked with Squirrel to interact with Oracle and used the tool for testing.
• Used Change Data Capture (CDC) technique to capture inserts, deletes and updates and made changes to the target database. Created reusable components like parameter sets.

Environment: Info sphere Information Server DataStage 9.1, 8.7 and 8.5 versions, DB2-UDB 9.0, Win SCP 4.3.7, PUTTY 0.62, K-Shell Scripts, Squirrel Client, Control M, Star Team, HP UNIX, Windows 7.