PROFESSIONAL SUMMARY:

• Around 12 + years of experience in system design, development, testing support and production support Data Warehousing which involves ETL/ BI development in various domains such as Healthcare, Financial, Telecom and Retail applications.
• Experienced in complete life cycle Implementation of data warehouse.
• Experience in integration of various data sources definitions like Oracle,Mainframes, DB2 UDB, Flat Files, Netezza and Teradata.
• Experience in supporting multiple applications. Monitoring and Understanding the schedules in Control - M and Maestro.
• As part of Infra team, gained a great experience in setting up the environments, Code migrations and data loads for Devlopment/Test/UAT Teams.
• Have comprehensive knowledge in Incident Management, Change Management, and Release Management process.
• Involved in writing several UNIX shell scripts for writing automated scripts Worked as Onsite/Offshore co coordinator.
• Good Knowledge in SQL and UNIX operating system.
• Highly expertise in Data bases like Teradata, SQL Server-2008, and ORACLE.
• Extensively worked on Informatica and Snaplogic.
• Experience writing Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL).
• Experience in Business Intelligence testing in various reports using Cognos , Business Objects and Crystal Reports.
• Working knowledge on Abinito, datastage and SQL.
• Worked with ALM, HP Quality center for defect management.
• Worked on both methodologies Agile and Waterfall as well.
• Good Knowledge in SDLC process ( Analysis, Design, Testing, Implementation, Support ) and agile methodologies .
• Have good interpersonal, communicational skills, strong problem solving skills, explore/adopt to new technologies with ease and a good team member.

SOFTWARE PROFICIENCY:

DB: TERADATA, SQL Server, RedBrick and ORACLE

DW&BI Tools: Informatica, Datastage, Abnitio, Control-M, Maestro

Testing Management tools & Utilities: HP Quality Center, Test Director, HP Application Lifecycle Management 12 (ALM)

Operating System: Windows, Unix,Linux

Agile Tool: JIRA

Big Data Technology: HDFS, HIVE, Impala

PROFESSIONAL EXPERIENCE:

Confidential, Glen Allen, VA

ETL Test Lead

Tools: Informatica, Oracle, Teradata, Unix, Control M HPQC ALM 12.0. HIVE, HDFS

Responsibilities:

• Lead a team to provide overall direction for test planning, execution and did follow-up for QA activity.
• Extensively interacting with ETL architect, developers, Client and Business Analyst team to understand the business requirements and Hadoop design document specifications.
• Documentation of the QA documents (e.g. Test Strategy, Test Plan, Daily Status Report, Test Summary Report, Test Scenarios).
• Walkthrough to clients on the test cases for various releases.
• Conducted daily Defect triage call & ensured the defect life cycle is followed diligently and ALM is updated with correct RCA.
• Participated in daily project status meetings and QA status meetings along with the client, development managers, developers and testers.
• Verify the Data flow ( Data mapping, Counts) from source to target.
• Verify the data Transformation logic from source to target works as expected.
• Verify the Database structural changes if any, DB fields and field data is loaded without any truncation.
• Perform Data validation like - Valid values, null value check, duplicate check, and blank record checks.
• Have worked extensively on HIVE.
• Managing and reviewing Hadoop log files.
• Running Hadoop streaming jobs to process terabytes data.
• Involved in creating Hive tables loading data and writing hive queries to validate the data.
• Work closely with the development team to analyze, debug and resolve any issues.

Confidential

ETL Test Lead

Tools: Informatica, HDFS, HIVE, IMPALA, Teradata, Business Objects, Oracle, Putty (Unix), Maestro and HP Quality Center/ALM.

Responsibilities:

• Responsible for managing onshore/offshore team by assigning tasks, mentoring and reviewing the tasks.
• Responsible for test execution daily schedule.
• Responsible for sending the daily/weekly/Monthly status reports.
• Worked as POC/Test lead for all BSR’s/Heat Tickets and Incident CR’s related to DWH (EDW application).
• Responsible for doing the QAT estimation (Using BUG/BEG/LOE).
• Categorized bugs based on the severity and interfaced with developers to resolve them.
• Developed an integrated test plan covering the main functions of the designated parts of the project; designed test methods.
• Developed Test data request to cover the test scenario that needs data from 2 or more system that needs co-ordination.
• Worked on issues with migration of Data from development to QA-Test Environment
• Tested Map Reduce programs to parse the raw data, populate staging tables and store the data in HDFS.
• Involved in all over the quality controls (Hadoop & Teradata), data validations, Key business checks and Teradata landing/stage/target tables.
• Extensively tested several Business Objects Reports and Dashboards to validate the reports the data and cosmetics of the report.
• HP Quality Center tool is extensively used for defect-tracking.
• Involved in parameterize the tests in QC.
• Responsible for reviewing and approving the test plans and test results written and tested by onshore/offshore team.
• Self motivated and takes the responsibility of delivering a quality project.

Confidential, Dallas, TX

ETL Analyst

Responsibilities:

• Responsible to convert Business requirements and design documentation into test design products: Test Scenarios, Test Scripts and Test Cases.
• Developed an integrated test plan covering the main functions of the designated parts of the project; designed test methods.
• Developed Test data matrix for test cases.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Data Analysis and developed Data Mapping documents for ETL.
• Validated reports based on Functional Requirements and analyzed various reports generated by SSRS.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Categorized bugs based on the severity and interfaced with developers to resolve them.
• HP Quality Center tool is extensively used for defect-tracking.
• Responsible for test execution daily schedule.
• Involved in parameterize the tests in QC.
• Responsible for managing offshore team by assigning tasks, mentoring and reviewing the tasks.
• Responsible for sending the daily status report.
• Develop complex sql queries to automate the test process.
• Conducts analysis of organizational needs and goals for the development and implementation of application systems.
• Responsible for reviewing and approving the test plans and test results written and tested by offshore team.
• Extensively used Microsoft Office Suite of products for documentation and data interpretation.

Confidential

DW Test Lead/ Data Analyst

Tools: Informatica, Teradata, Cognos, Oracle(Toad), Unix, Maestro(Job Scheduling) and HP Quality Center.

Responsibilities:

• Managed several projects (BMG/CDL/Sustainment/DataPipe) within System Test Team as a Test Lead.
• Developed a good team in the offshore and reviewed several project deliverables.
• Worked with Teradata SQL Assistant and Used Teradata Fast Load to load the data into the empty tables in the Staging area
• Used Teradata Multiload Utility in order to load the Base tables and extensively worked with Error Tables associated with it.
• Expertise in troubleshooting the problems encountered due to failure of jobs that uses the loaders Mload Upsert, Mload Insert, Mload Update and Fast load.
• Worked on Numerous BTEQ scripts with Volatile and Derived tables.
• Responsible for setting up the environments for new and existing projects within the eCDW.
• Actively organized enhancement/status/defect meetings focused on making the product more effective in real time scenario.
• Responsible for preparing and sending the daily status reports.
• Responsible for conducting weekly release meetings.
• Responsible for providing estimates to the projects coming under Data Pipe and Commissions application area.
• Help team to convert Business requirements and design documentation into test design products: Test Scenarios, Test Scripts and Test Cases.
• Developed an integrated test plan covering the main functions of the designated parts of the project; designed test methods.
• Developed Test data matrix for test cases.
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Performed Acceptance, Unit, Integration, Usability, Cross-Platform, Regression, etc. testing during different stages of the project development.
• Categorized bugs based on the severity and interfaced with developers to resolve them.
• Responsible for performing various types of process evaluations during each phase of the software development life cycle. Including, audit, review, walk through and hands on system testing.
• Bugs were reported using defect-tracking tool (HP Quality Center).
• Created detailed test status reports, performance/capacity reports, web trend analysis reports, and graphical charts for upper management.
• Reviews, analyzes, and modifies programming systems, including encoding, testing, debugging and installing for a large-scale system. Maintains records to document program development and revisions.
• Extensively used SQL/Teradata to perform data integrity testing.
• Scheduled batch job execution for test cycles.
• Prepared test execution daily schedule.
• Responsible for managing a testing group the ETL business logic provided in the technical specifications.
• Involved in parameterize the tests in QC.
• Responsible for setting up the new/old environments and running the ET/load process using Maestro schedules.
• Responsible for managing offshore team.
• Conducts analysis of organizational needs and goals for the development and implementation of application systems.
• Responsible for reviewing and approving the test plans and test results written and tested by offshore team.
• Extensively used Microsoft Office Suite of products for documentation and data interpretation.

Confidential, Walnut Creek, CA

DW Developer

Tools: Informatica, Oracle, RedBrick, Benthic - Golden, Reflection and Mercury Quality Center.

Responsibilities:

• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data
• Designed the ETL processes using Informatica to extract the data from Oracle and Redbrick and load it to target database using Rb tmu Utilities.
• Created control files for the Rb tmu utilities.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator.
• Written SQL overrides in source Qualifier according to business requirements.
• Written pre session and post session scripts for mappings.
• Created sessions and workflow for designed mappings.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run Confidential specified time with required frequency.
• Developed Test Plans and Test Cases.
• Wrote Test Cases to test the Process and Data.
• Thoroughly performed Unit Testing, System Testing and Database Testing for all Informatica mappings and SQL Queries.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Involved in fixing Invalid Mappings, Testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica sessions, Batches and Target Data.
• Involved in code migration from Development to Test environment.