SHILPI SHARMA

Email: ad474y@r.postjobfree.com

Contact Number: +1-469-***-****

Work Experience: 16+ Years

PROFESSIONAL SUMMARY:

• A versatile, goal-oriented Quality Assurance/ Software Testing Professional with over 16 years of diversified experience in IT.

• Well expertise knowledge in Commercial Banking Financial, Retail Banking, Retail business and e-commerce (B2B/B2C) domain.

Extensive 10+ experience in ETL Testing with Talend env using SQL and Unix using Scrum methodology in Oracle EDW.

Excellent understanding of various Software Development Life Cycle (SDLC) methodologies such as Waterfall and Agile (SCRUM)

• Good knowledge of Load runner, JMeter and other performance tools.

• More than 10 yrs. of experience in ETL/Data warehouse testing with the environment of PL/SQL developer and Oracle. Well versed in ETL processes, performance-based systems, and ETL process flows and standards, Autosys jobs, Ab Initio, Talend and Informatica tools.

• Experience in setting up the test environments, installations and configurations.

• Experience in developing a regression test suite using Automation Tool – iTKO LISA.

• Experience in manual testing – UAT Testing, Black box testing, white box testing, system testing, regression testing, performance testing, GUI testing, middleware testing, database testing and user acceptance testing.

• Experience testing ESB (Enterprise Service Bus) applications using test harness and SOAPUI involving XML.

• Strong expertise in establishing QA policies, procedures, strategies and developing appropriate process to ensure the quality of product.

• Strong expertise in leading and managing the testing team at both onsite and offshore simultaneously.

• Extensive experience in providing sizing for different projects and effectively managing resource Constraints due to deviations from estimated efforts.

• Experience in conducting POCs on new tools such as Itko Lisa, Ab Initio and proposing the usage of the same to management to better leverage existing /new projects.

• Excellent Analytical, Decision-Making and Organizational Skills coupled with good co-ordination, communication and interpersonal skills describing a committed Team Player with ability to handle/organize multiple projects simultaneously

• Strong experience in writing complex SQL Queries for Database Validation Testing.

• Exceptional analytical, trouble shooting and problem-solving skills.

TECHNICAL SKILLS:

Operating System

Windows95/98/00/XP

Test Management Tools

Quality Center 10, Jira.

Languages

Core Java, VB Script, PL/SQL, HTML, ISML (Intershop Markup Language),Unix, XML

Automation Tools

iTKO LISA – Automation & virtualization, Load Runner, Jmeter.

Project Management Tools/Methodology

Talend, MS Project, MS Office, RTC (Rational Team Concert), Agile/Scrum, Waterfall.

Databases

Oracle SQL developer, ETL Abinitio, SharePoint2.0, Tortoise SVN, Autosys, SOAP UI, Informatica,

MS OFFICE SUITE.,Oracle 9i/10g, DB2, Toad, PL\SQL Developer

WORK EXPERIENCE:

Client: - Citigroup

Project: GDR (Global Data Repository USA) May’20 – till date

Role: ETL Test Lead Houston, Texas

Citi, the leading global financial services company, has approximately 200 million customer accounts and does business in more than 140 countries. The project involves providing information through file types to various Commercial Card users as a part of Citibank in North America and across the globe.

Responsibilities:

Good knowledge in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) which includes Functional Testing, UAT testing, Production testing, Compatibility testing, Regression Testing, Smoke testing on waterfall and Agile Environments.

Worked on identifying high-level scenarios, test case creation, test case execution, bug logging and bug regression for ETL processes.

Writing test cases based on mapping documents for ETL Talend env using SQL and Unix.

Knowledge in testing back end applications - Database testing (Datawarehouse/ETL) by writing SQL statements.

Evaluated new software applications and coordinated with software developers and business analysts to discuss QA defects and concerns.

Involved in Test Plan, Test estimation and Test metrics.

Assisted team to understand the logics and transformation rules and data flow steps in mapping documents.

Worked on identifying high level scenarios, test case creation, test case execution, bug logging and bug regression.

Actively involved in handling bug triage calls, sending daily and weekly test execution reports to client.

Strong SQL skills and experience with databases like MySQL and Oracle.

Experience in one to one client interaction, handling client’s scrum/weekly calls, involved in team discussions like task allocation, KT, any other issues.

Knowledge in developing, documenting and executing test cases manually and guiding team to automate cases using Talend.

Handled the team of 20+ resources including both onsite and offshore.

Functional testing of Autosys jobs to ensure jobs runtime, job dependencies and scheduling logic.

Client: - Citigroup

Project: Inventory (TS2 Migration) May’18 – May’20

Role: ETL Test Lead Jersey City, New Jersey

The Project “TS2 Migration - Inventory” is involved in migrating CITI clients from North America to a new platform.

Responsibilities:

Work with management team to create a list of profiles based on regions to be migrated to new CITI system.

Designing test cases and executing them based on ETL methodology in Talend using SQL and Unix.

Define and deliver metrics, dashboards, reporting and analytical models vital for tracking and managing Profile movements using advanced MS excel and Powerpoint.

Perform data mining using various querying techniques of PL/SQL using SQL Developer and Unix in Putty, find out discrepancies and discuss with Technical teams.

Help Senior management to define business needs and develop technical requirements by establishing facts and drawing conclusions using different representational techniques like graphs or charts.

Identify, analyze and carry out complex analysis of datasets.

Help in automating File Mast by providing an insight to business requirements and converting them into technical logics using PL/SQL queries.

Conduct appropriate data validation to interpret trends or patterns to mitigate business problems using data driven insights.

Responsible for the accuracy and integrity of data to provide information on analytic results to functional leaders.

Resolve Technical queries from various business teams on Profile detailing using PL/SQL and Unix queries.

Use data to create models that depict User profiles already moved or pending to be migrated to new Java Platform systems.

Work with management team to create a list of profiles based on regions to be migrated to new CITI system.

Client: - Citigroup

Project: FDR (File Delivery Repository) Jan’15 – May’18

Role: ETL Test Lead Jersey City, New Jersey

The project “FDR (File Delivery Repository”) is involved in delivering files based on business user specifications and requirements. It also involves testing various functional changes in the file delivery system.

Responsibilities:

Understanding the business requirements and communicating with stakeholders for clarity.

Writing/Executing test cases for ETL based project using Talend extensively utilizing SQL and Unix knowledge.

Configuring system to delivery customized files in various file formats.

Generating files using unix scripts and validating and verifying the same before sending it to the clients.

Participating in design and documents reviews.

Working closely with QA teams and supported QA reviews.

Conducting various requirement clarification calls with business.

Actively involved in defect review meetings and provided solutions.

Managed and assigned defects to the respective teams for further actions using HP Quality Center.

Leading the team of 8 resources at onsite and offshore.

Client: - Citigroup

Project: GDR (Global Data Repository USA) May’14 – Dec’14

Role: ETL Test Lead Warren, New Jersey

Citi, the leading global financial services company, has approximately 200 million customer accounts and does business in more than 140 countries. The projects involve Commercial Cards system, which is being used as a part of Citibank in North America and across the globe.

Responsibilities:

Followed Agile Scrum methodology

Prepared Test Plan based on the requirements for ETL based Talend env project.

Developed and executed formal test plans to ensure the delivery of quality software applications.

Designing Test plan and conducting walkthrough for the same with stakeholders.

Extensively involved in Test Designing, Test Planning, Test Execution and Test Reporting.

Handle the tasks of reviewing testing documentation to ensure that it meets the software development and testing standards.

Assisted Application Developers, Business Analysts and technical support staff in identifying and resolving problems.

Enhanced the test scripts using Citrix 9.2 OEM,Web Http,ODBC,SAP Gui,JAVA protocol in Load runner.

Executed stress/load/rendezvous scenarios and regression testing for various operations and performed detailed test analysis reports and perform Disaster Recovery.

Added performance measurements for UNIX, Oracle, Web Logic server in Load Runner, controller and monitored online transaction response times, Web hits, TCP IP Connections, Throughput, CPU, Memory, Heap sizes, Various Http requests etc. Monitored Oracle database V$ session and system table stats.

Used Site Scope Performance monitors and LoadRunner graphs to analyze the results.

Conducted status calls internally within team as a Team Lead.

Communicated status to the Client through call, generated defect reports, and lead weekly Defect calls.

Client: - Citigroup

Project: RUSA (Rainbow USA) Oct ‘10- Feb ‘14

Role: QA/Performance Tester Irving, Texas

Citi, the leading global financial services company, has approximately 200 million customer accounts and does business in more than 140 countries. Through Citicorp and Citi Holdings, Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.

Responsibilities:

Analyzing the business and functional requirements to prepare test cases.

Worked with appropriate business and technology leads to determine the acceptable range for test results and performance

Participated in walk through and defect report meetings

Extensively creating scripts using Loadrunner v 9.0.

Extensively involved in Test Designing, Test Planning, Test Execution and Test Reporting.

Design and execute Test Cases, Generate Test Scripts and Test scenarios using Vugen component in Mercury Loadrunner.

Used Test director for tracking defects, enhancement requests, assign work activities, and assess the real status of project throughout the life cycle

Reviewed the Test cases & Providing Test cases to Team Lead with Test Results

Assisted Application Developers, Business Analysts and technical support staff in identifying and resolving problems

Logged defects based on their severity using Quality center.

Involved in the review of Test Cases with the Client.

Communicated status to the Client through call, generated defect reports, and lead weekly Defect Calls to analyze the defect.

Client: - Sears

Project: Sears BI (Business Intelligence) Mar’10- Sept’10

Role: QA Analyst Noida, India

This project has been implemented as a Business Performance Management Solution for Sears Holding Corporation. This involves migrating database Objects from Teradata to Netezza for performance improvement and developing Business Intelligence Reports using Micro strategy.

Also, the project involves the creation of reports and dashboards, which can be used by higher management and executives. These generally contain high level, aggregated company strategic data with comparisons and performance indicators.

Responsibilities:

Understanding business functionality of the reports and ETL Jobs

Wrote SQL Queries for Data migration as per the mapping document. Validated Target columns are correctly mapped from Source as per the Transformation Rules.

Managed the creation and execution of test cases in Quality Center 9.2

Logged defects based on their severity and generated Defect reports using Quality center

Executed test cases on Netezza (target database), Teradata (source database) using SQL queries

Manual Testing of the reports and dashboards

Conducted Daily calls with developers for Bug tracking.

Client: - Xerox Oct’07 – Feb’10

Project: - Sellsmart New Delhi, India

Role: - Test Lead

The project was to implement framework for back office Sales order process (Requisition to Order Completion Process) integrated with CRM and Inventory Management System to provide the Stock Information on runtime which is used to manage the order shipment and forecasting the products availability/need according to the demands to generate the Quotation and create the Purchase Order. These purchase orders transmitted to the ERP of the suppliers.

The modules included: -

Order Management System: - This module is designed and implemented to provide: -

Complete Order cycle management for both B2B and B2C with full power to accept and decline the order at any stage.

Order Search

Order Overview

Fraud Order Management

Responsibilities:

• Developed test plan adhering to specifications and business requirements

• Prepare UAT Test Plan and Test Estimation

• Designed & executed Test cases scenarios, Test Cases on the basis of Specifications.

• Bug Reporting and all the Bugs are tracked to closure.

• Ensured timely delivery of the software deliverables prior to their delivery to the customer.

EDUCATION:

2006: B.Tech. Information Technology. Sri Sukhmani Institute of Management and Technology, Chandigarh, Punjab [82.5%]

2001: 10+2, Kulachi HansRaj Model School, Delhi, CBSE Board [80.5%]

1999: 10th, Kulachi HansRaj Model School, Delhi, CBSE Board [86.6%]

CERTIFICATIONS:

Professional Society / Certification

Member Since / Date Certified

1Z0-007 Introduction to Oracle 9i:SQL

Aug 12th’ 2010

Certificate In Retail Management L1

Aug 3rd’ 2010

ISTQB Foundation – Certified Tester

Sept 26th, 2014

ACHIEVEMENTS:

• Given TCS “On the Spot” award for significant contribution to the team.

• Hold 8th position in University Merit list.

• Hold 2nd position in University in 6th semester.

• Overall college topper.

• Awarded merit certificate in 2nd and 3rd year.

Contact this candidate