ETL Tester
Resume:
Divya Agarwal
*****.*******.*@*****.***
Experience Summary
Over 9 years of Software Quality Assurance (QA) experience in Data Warehouse (ETL & BI)
Experience in defining testing methodologies; Creating test plans and test cases, Verifying and validating application software and documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
In depth technical knowledge and understanding of Data Warehousing, Hadoop Ecosystems, UNIX, SQL, HDFS, HIVE, Hue, Oracle, XML, Teradata.
Solid Back End Testing experience by writing and executing SQL Queries.
Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, and Identifying Data Mismatch.
Involvement in all phases of STLC (Systems Testing Life Cycle).
Strong working experience on Extraction, Transformation, and Load (ETL) of data from Legacy systems using Informatica and Ab Initio.
Extensive experience with Analysis, Test case plan designing, Metadata designing, Designing Mapping sheet, ETL Designing, Testing, Bug Analysis, Bug Reporting and Re Testing and UAT.
Good experience in working with Onsite-Offshore team model projects.
Tested data, extracted from various sources like Oracle, Flat file, XML, SQL SERVER, and loaded into Flat File and Oracle database.
Work extensively with Slowly Changing Dimensions & Audit Table.
Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion, and loading
Well versed with Manual Testing Methodologies and Principles.
Application Data Warehousing experience in Healthcare, Telecom and Retail domain.
Worked on Agile Methodology.
Education Details:
Bachelors in Technology (Computer Science and Engineering) from Meerut University, India
Technical Proficiency:
Core Skills
Big Data, ETL and Data Warehouse Testing
ETL Tools
Ab Initio GDE 3.7, Informatica Power Center 9.x
Utility Tools
Hue, HIVE, HDFS, TOAD, PUTTY, Teradata SQL Assistant, SQL Developer, Control M Workload Automation, JIRA, Tortoise SVN
Databases
Teradata, Oracle 11g, SQL SERVER 2008, MS Access
Programming
SQL, PL/SQL
Environment
Windows, UNIX (AIX 5.2), MS DOS
Data Modeling
Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT, and Dimensions Tables, Physical and Logical Data Modeling
Microsoft Office
Word, PPT, Excel
Professional History
Client: Williams Sonoma, Inc. Jun 2017 to till now
Project: SCDW
Role: ETL Tester
Location: San Francisco, CA
Description: Current system does not have the track of Order events and business wants to track the order events. Sterling(source) will generate the messages for every order’s event with status in the form of XML and send those messages to TIBCO and then TIBCO will transmit the messages to Unify and Unify will collect the data from all channels, process it and store those files to HITactics staging area.
Data Travels from various source to TIBCO --> HDFS HIVE HITactics. The objective of this project is to develop an automated track of an order on daily/weekly/monthly basis.
The plan of this project is to provide AI based facility to business or user to track the order in Supply Chain System. User would be able to type in their own language and system would be able to generate the SQL query and provide the results to user.
Responsibilities:
Involved in XML validation against Source
XML validation in Hadoop system
Involved in creating dummy XML files
Involved in Data Quality testing
Bug Reporting and Retesting
Environment: Hadoop Ecosystem, Hue, HIVE, HDFS, Unify, Oracle, XML files
Client: Williams Sonoma, Inc. Jun 2017 to Apr 2018
Project: Order Management System Domestic/BORA/PAYPAL VENMO/MTL
Role: ETL Tester
Location: San Francisco, CA
Description: OMSD4 application is mainly designed to replace the current WSI mail order legacy DTCMO application which is mainly for DTC (Direct to customers) related accounts. WSI finance enters and manages journal entries (JE) monthly. These entries are indirectly sourced from the sales files from DTCMO. The sales and cost data from DTCMO is first used to generate multiple financial and operational reports. There are multiple Journal Entries for Refund Check, DTC Sales & COGS, Sales Tax, MO Sends, Royalty SKU COGS, REPRO Sales, Internet Sales
For OMSD4, WSI finance is aligned into two channels and have DTC related journal entries sourced from Sterling sales and cost data post on a weekly/monthly basis as required.
The requirements of generating the Journal Entry and making a file available for the upload into the Lawson General Ledger application on a weekly/monthly basis as required.
The objective of these Project is to develop a weekly/monthly analytic journal entry generation solution that supports the Williams-Sonoma business operations.
Responsibilities:
Involved in Requirement Analysis, Review, and Testing Strategy Preparation
Test plan and Test Case preparation on the scenario by business
Involved in creating dummy test data
Involved in running Jobs using ab initio graphs
Involved in functional testing and regression testing
Involved in Data Analysis and Data Validation
Bug Reporting and Retesting
Environment: Ab initio GDE 3.2.7.2, Oracle 11g/10g, Tera data, PUTTY, SQL
Client: Williams Sonoma, Inc. Sept 2017 to Oct 2017
Project: BOPIS (Buy Online and Pick up in Store)
Role: ETL Tester
Location: San Francisco, CA
Description: Buy Online Pick-Up in Store (BOPIS) provides a new way to service Williams Sonoma’s customer orders across channels. Historically, its eCommerce and retail channels have operated separately, with limited overlap in sales support. Customers who prefer to shop online have limited service options with days-long fulfillment periods. Customers located near Williams Sonoma’s stores have the option to call to check on item availability during store hours or drive to the store and hope for the best. BOPIS will provide a new service, allowing customers to shop on the website (desktop or mobile) and choose the option to pick up their items in a local store within a matter of hours. Orders will be fulfilled from store inventory on hand.
This project develops the technology to provide store inventory visibility to DTC systems, support the customer-facing order flows and notifications on the brand website, provide a workflow for store associates to service BOPIS orders and the reporting and financial controls to track, measure and account for BOPIS orders.
Responsibilities:
Involved in running jobs for the data created by upstream to SDM using Ab Initio
Involved in functional testing and regression testing
Involved in Data Analysis and Data Validation
Bug Reporting and Retesting
Environment: Ab initio GDE 3.2.7.2, Oracle 11g/10g, Tera data, PUTTY, SQL
Client: Williams Sonoma, Inc. JUL 2017 to DEC 2017
Project: MDMFT
Role: ETL Tester
Location: San Francisco, CA
Description: MDM team publishes Item Master data and Pricing data to down streams in stage table for different brands publishes. The work involves Smoke Testing and Regression Testing.
Responsibilities:
Involved in Requirement Analysis
Involved in creating Test plan and Test Case preparation on the scenario by business
Involved in running jobs for the data published to stage by upstream
Involved in Smoke Testing and Regression testing
Involved in Data Validation
Bug Reporting and Retesting
Environment: Ab initio GDE 3.2.7.2, Tera data, SQL, PUTTY
Client: Humana Inc. Jun 2011 to Apr 2017
Project: Medical Claims
Role: ETL Tester
Location: Louisville, KY
Description: Humana Inc. was founded in 1961 in Louisville, Kentucky. It is a Fortune 500 company that markets and administers health benefit consumer services. With a customer base of over 11.5 million in the United States, the company is the largest (by revenues) Fortune 500 company headquartered in the Commonwealth of Kentucky, and has a market cap of over US $13 billion, $25.2 billion in revenue, and over 26,000 employees nationwide. Humana markets its health benefit consumer services in all 50 states, D.C., Puerto Rico and has international business interests in Western Europe. Additionally, Humana offers health plans and some specialty products (group life and disability insurance, for example) to commercial employers and individuals.
Project Description: A Medical claim is a detailed invoice that health care provider (such as your doctor, clinic, or hospital) sends to the health insurer. This invoice shows exactly what services Payee received. Payee get a service from a health care provider. The healthcare provider submits a claim.
Humana Insurance policies in which the insured must first pay losses out-of-pocket and then seek reimbursement for any covered loss from the insurer, as opposed to policies in which the insurer is required to "pay losses on behalf of" an insured. I was involved in 837 and 835 Professional and Institutional claims.
I was involved in Medical Claims, Medicare, Medicaid Services and Acquisition in EDW -Humana.
Responsibilities:
Ensured processes are followed at all stages of Software Testing Life Cycle.
Involved in Requirement Gathering including Attribute Analysis which helps in Designing Data Model.
Designing Metadata including Table Doc and Table_Attribute Document.
Involved in Test Case Planning.
Involved in designing ETL Mapping Sheet.
Involved in Designing Dummy Test Data for 835 and 837 medical claims.
Involved in Source to Target Validation.
Responsible in Designing and Validating Mapping Sheet for data (Source XML)
Involved in Requirement Review and Testing Strategy Preparation.
Bug Reporting and Retesting.
Environment: Informatica Power Center 9.5, Oracle 11g/10g, TOAD, XML and SQL
Client: British Telecom Dec 2009 to Jan 2011
Location: Bangalore, India
Role: Quality Analyst
Description: An Intranet BTII (British Telecom Infosys Intranet) is designed for growing needs that is involved in automating the reports and viewing personal information anytime and anywhere at BT Floor. This site features rich content of latest happening around the BT Floor and around the world.
This Site is divided into 3 Sections:
Knowledge Management – Which includes all the team documents like huddle logs, query logs, FAQs and so on…
Communication Management – Which includes the Chat Application that enables an advisor to communicate with his/her Supervisor and vice versa.
Productivity Tracker – This application is used to track individual performance. It eliminates the use of notepad. It tracks day-to-day transactions and monitors break and down time online.
Career Micro site, Minutes of Meeting, Head Count Management, Attendance Tracker, Performance Investigation Period, Early Warning Indicator, CCH Tracker, Complaint Tracker, Roster, Work Plan, MIS reports, Skip Level Scheduler, Root Cause Analysis, Impact, Point of failure analysis and so on comes under this site.
Responsibilities:
Ensured processes are followed at all stages of Software Testing Life Cycle.
Involved in Designing Dummy Test Data.
Involved in Designing Test Cases.
Involved in Requirement Review and Testing Strategy Preparation.
Bug Reporting and Retesting
Environment: VB.Net, Web 2.0, SQL Server 2000/2005/2008, ASP.Net
Client: Court Master (Supreme Court of India ) Aug 2008 to Aug 2009
Location: New Delhi, India
Role: Quality Analyst
Description: This Project is developed to get the Judgment information of Supreme Court on daily basis. A tool is developed
Supporting this project where the details of the filed cases could be pulled under the respective Judges who are
Presiding over it. Further the filed cases are divided into three such as minor, major and critical. The
Judgment Information system (JUDIS) consists of the Judgments of the Supreme court of India and several High
Courts. People can file their own case in the Supreme Court. There are 12 sub courts in the Supreme Court.
The tool assigns the case to the corresponding bench system based on the status. There are 3 bench systems. If
Case status is minor then case assigns to 3 judge’s team. If it is major then 5 judge’s team and if case is critical then
It assigns to the 7 Judge’s team. Based on the filed case system, Judges Name and Dates User can pull the Different -2 reports.
Responsibilities:
Ensured processes are followed at all stages of Software Testing Life Cycle.
Involved in Designing Dummy Test Data.
Involved in Designing Test Cases.
Involved in Requirement Review and Testing Strategy Preparation.
Bug Reporting and Retesting
Environment: Oracle forms 6i
Contact this candidate