Oct 2016 – Mar 2019 · 2 yrs 5 mos · USA

• Role: ETL and Tableau, SAP BO Reports Testing
• Recreational Equipment Inc is an American retail and outdoor recreation services corporation headquartered in Kent, WA.
• Responsibilities:
• ● Handling importing of data from various data sources into Netezza and validated data transformations.
• ● Analyzing the data by performing Netzza queries.
• ● Validation of loading and transformation process of large sets of structured, semi structured and unstructured data.
• ● Creating ETL validation scripts to validate the data loaded from multiple data sources into Netezza Data warehouse.
• ● Creating multiple SQL scripts to validate the SAP BO Reports and Tableau reports.
• ● Performing data migration testing from SAP BW to Netezza database.
• ● Data comparisons between legacy and new data warehouse.
• ● Leading the team of ETL testers in validating the ETL and Reports data.
• Environment: Netezza, SQL, Tidal, SAP Business Objects, Tableau and UNIX Shell Scripting.

Nov 2014 – Sep 2016 · 1 yr 10 mos · USA

• Role: ETL and Reports Testing Lead
• Neiman Marcus is an American luxury specialty department store owned by the Neiman Marcus Group, headquartered in Dallas, TX.
• Responsibilities:
• ● Participated in designing the ETL Mappings for source database like Oracle to target data warehouse Vertica.
• ● Analyzing the Data Mart loading process for Analytical Reports.
• ● Prepared the Test Plan and Testing Strategies for Data Warehouse Application.
• ● Conducted system testing, integration testing, functional testing and integration testing.
• ● Developed complex SQL queries for querying data against different database for data verification process.
• ● Developed ETL test scripts based on technical specifications & Data design documents and Source to Target mappings.
• ● Writing test scenarios for various SAP BO and Oracle BI reports and validating the same.
• ● Extensively interacted with developers, business & management teams to understand the ETL project business requirements and design document specifications.
• ● Participated in regular project status meetings and QA status meetings.
• ● Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• ● Tested a number of complex ETL mappings and reusable transformations for daily/weekly/monthly data loads.
• ● Validated the data in the various formats loaded from different data sources into Veritca data warehouse and HDFS file systems.
• ● Analyzed the data by performing Vertica, Hive and Solr queries
• ● Created multiple ETL validation scripts to validate the data loaded from multiple data sources into Data warehouse and Data Mart.
• ● Validated the load mechanism tools like Kafka, Storm and other open source technologies.
• ● Developed Hive queries for the analysts.
• ● Performed data migration testing from Netezza to Vertica database.
• ● Extensively analyzed the existing shell scripts for ongoing data loads and provided recommendations.

Jan 2013 – Oct 2014 · 1 yr 9 mos

• Role: ETL and Reports Testing Lead
• Nordstrom is an American chain of retail stores headquarters in Seattle, WA.
• Responsibilities:
• Developed ETL validation scripts to analyze the data between source to target Tera Data data warehouse system.
• Reconciliation tools are developed to compare data from sources to targets
• Created updated and maintained ETL technical documentation.
• Played the lead role at onshore for all EI systems that includes Informatica MDM, AeDW/CA (TeraData) and MSTR reporting tool.
• Mentored the team members with an automation in-house tool like PerfaWare and Auto ETL Tester.
• Daily interaction with the clients for gathering the requirements from various teams and assessing the requirements and assigning it to offshore.
• Preparation of daily tasks to offshore team and generating weekly status reports to the client managers.
• Lead the team of ETL and Reports testing team. Preparing test plan and estimations
• Provided the work demo to the clients with the required updates.
• Environment: Informatica, Tera Data, Micro Strategy Reports, DB2, PL/SQL, Control-M, UNIX Shell Scripting, SQL Plus, TOAD.

Oct 2010 – Dec 2012 · 2 yrs 2 mos

• Wal-Mart stores Inc is an American multinational retail corporation that operates a chain hypermarkets, discount department stores and grocery stores.
• Responsibilities:
• Reviewed testing artifacts such as test requirements/test scenarios/test cases/test data.
• Automation using QTP 10.
• Co-ordination with functional experts to automate the regression scenarios.
• Prepared the daily tasks to the team members. Generation of Daily and Weekly reports.
• Client meetings and calls to give an update of the project.
• Weekly discussion with team members.
• Prepared the project related documents like Project profiles, Review checklists, Metrices reporting to client, etc. Preparing estimation guidelines.
• Prepared the knowledge sharing sessions. Mentoring of Team members.
• Conducted the trainings on QTP and QC.
• Prepared Monthly Status Reports and Metrics.
• Software Development Life Cycle (SDLC) including analysis, design, implementation, support and maintenance.
• Environment: Quick Test Professional, Quality Center, SQL Plus.

May 2008 – Aug 2010 · 2 yrs 3 mos

• Agilent Technologies is an American public research, development and manufacturing company.
• Responsibilities:
• Gathered the requirements, analyzed them thoroughly and wrote the test cases.
• Co-ordination with functional experts of all 3ERP teams to automate the regression scenarios of each ERP.
• Prepared the daily tasks to the team members. Generation of Daily and Weekly reports. Client meetings and calls to give an update of the project.
• Played the lead role in Agilent all towers SAP, Oracle, Siebel and Matrix application Automation Test Suite Preparation.
• Extensively worked on QTP to create an automation integration test suite to test 3 ERP systems at one go.
• Reviewed testing artifacts such as test cases/test data. Weekly discussion with team members.
• Prepared the project related documents like Project profiles, Review checklists, Metrices reporting to client, etc. Preparing estimation guidelines.
• Prepared the knowledge sharing sessions, mentored the Team members. Automation using QTP 9.5/10.
• As a HP-QC admin, Involved in Create and manage QC Projects, Manage users and their roles.
• Environment: QTP 10.0, Quality Center, Siebel, Oracle Apps and SAP

Jul 2006 – Feb 2008 · 1 yr 7 mos

• Morgan Stanley is an American multinational financial services corporation.
• Responsibilities:
• Automation test scripts creation using QTP 9.0.
• Prepared Test Strategy, Test Plan for the project.
• Conducted load tests for 5,000+ simultaneous users.
• Prepared the daily tasks to the team members.
• Generated the Daily and Weekly reports.
• Daily Interaction with the Client to give an update of the project.
• Weekly discussion with team members.
• Prepared the project related documents like Project profiles, Review checklists, Rotation plan of associates, Metrices reporting to client, etc..
• Prepared the estimation guidelines and resource utilization metrics.
• Environment: QTP9.0, Quality Center, Load Runner, Test Center, Sybase, C# and Java.

Feb 2004 – Jun 2006 · 2 yrs 4 mos

• P&O Nedlloyd Container Line Limited was an Anglo-Dutch worldwide ocean-going container shipping line.
• Responsibilities:
• Prepared the release notes.
• Release installation, co-ordination all the involved teams.
• Analysis, solution implementation of reported problems.
• Generation of PL/SQL scripts.
• Wrote shell scripts for automating existing Env.
• Release Management activities in PRODUCTION/UT For various products including FF4, ADA, DRS and GECS
• Fixing existing versions of the product and developing new features as desired.
• Handled Change management Procedures.
• Analysis & Troubleshooting.
• Interaction with the various teams to get fix installed.
• Devolvement of D2K Forms/Reports as Required.
• Change modification of existing code for new requirements.
• Setting up of the mailbox scripts.
• Reduced errors through preventive maintenance.
• Environment: Pro* C, PL/SQL, Oracle and UNIX Shell Scripting.

Jul 2003 – Jan 2004 · 6 mos

• State Bank of India is an Indian multinational, public sector banking and financial services company.
• Responsibilities:
• Implemented the Trade Finance module of EximBills at several branches of SBI.
• Installed Application software and created database at branch level.
• Testing of validation scripts provided for data file validation in various aspects like Validation of headers of input files, blank rows, blank columns, duplicate rows and duplicate columns.
• Data migration: Prepared staging area for data migration. Prepared extraction templates. Ran validations on extract files prior to upload and generating exception reports till no exception is observed. Uploading data in staging area and generating Financial Recon Reports. Update Customer Records in Eximbills with customer specific charges tables where special rates exist (as per list provided). Verifying Financial Recon Reports. Transferring migrated data from staging area to live database. Ran sample checks on the live data for migrated items.
• Environment: Visual Basic, Oracle 8.0, HP-UNIX, Eximbills Toolkit.

Sep 2002 – Jun 2003 · 9 mos

• ISBS is a banking software product developed by TCS for Total Branch Automation.
• Responsibilities:
• Implemented ISBS Package at several branches of Punjab National Bank, Bank Of Baroda and Lord Krishna Banks.
• Tested and Modified TDS (Tax Deduction at Source) module for PNB Branches.
• Involved in understanding the client’s change requests, studying the existing system, preparing time estimation report, an impact analysis report, writing program specifications and Code for the change request.
• Responsible for Telephonic, on-site support on Oracle as Well as application level to various clients.
• Carried out client specific customization and maintaining documentation for the same.
• Prepared test plans for the changes and unit testing of various modules involved.
• Environment: C, Pro*C, PL/SQL, Shell Scripting and Oracle.