Amit Agrawal

Ph: 770-***-****

Email: ac8z7b@r.postjobfree.com

ETL/Functional/Automation QA Lead with 12+ years of experience in IT industry including 2+ years of ETL and BI testing and 2+ years of Automation testing. A talented, detail oriented software professional, interested in working in a team atmosphere to create innovative and simple solutions that helps to solve client’s most complex issues. Looking for a career that is both challenging and rewarding.

PROFESSIONAL SUMMARY

Sound knowledge and understanding of Software Testing Life Cycle and Software Development Life Cycle

Hands on experience in Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium WebDriver, JAVA, Junit, TestNG.

Experience in creating Jenkins CI/CD pipelines and scheduling builds.

Experience with Behavior Driven Testing (BDT) for Behavior Driven Development (BDD) with Cucumber JVM to implement Test Driven Development (TDD).

Experience in testing the web services using SOAP UI, Postman and Rest Assured.

Extensive experience in EDW/BI, Bigdata testing which includes DB2, Oracle, SQL Server, Hadoop. Proficient knowledge on ETL tools like Informatica/SSIS.

Professional with experience in leading Testing efforts, including experience with all phases of testing: System/Functional, System Integration, User Acceptance, E2E and Performance Testing.

Understanding of Star and Snowflake Schemas, Facts and Dimensions table and DW concepts.

Experience overseeing the development of test plans, test scenarios, test cases, and execution of test cases and documentation of test results. Defining the testing strategy for large programs and ensuring requirements traceability throughout the project lifecycle.

Experience in BI reporting tool- Tableau, SSRS, OBIEE.

Expertise in SDLC right from requirements planning to architecture, testing to deployment, and support, to help link client’s IT programs to organizational goals.

Excellent working knowledge in Test Plan, Test Strategy, Test Estimates, Test Requirements and Test Case Design from the Business Requirement Document and Technical Design Document. Preparation and Execution of Business scenarios and Test Cases.

Proficient in writing complex SQL scripts based on the business logic using TOAD, Oracle SQL Developer, SQL Server.

Perform Functional Testing, Integration Testing, Regression Testing and Implementation Test on Web based & Mainframe platforms (CICS, TSO, FileAid, SPUFI)

Experience with SOA architecture that include Restful Web Service Testing.

Worked on automation suite for each Retail application to cut down the manual hours

Hands on experience in Test management & Defect management tools such as: HP ALM, Quality center 10.0

Coordination with multiple project stakeholders which includes Design review meetings, Defect meetings, Test case/results reviews, Daily/Weekly status reporting.

Experience in handling Onshore/Offshore team across a global model; which includes leading offshore testing team from client location in Canada and USA

Experience in Insurance, Retail, Banking (Cards and Payments) and Airline domains with fortune 100 clients.

Self-starter with Effective communication skills, Team player and excellent grasp of fundamentals combined with attention to detail and business process improvements with Quality and standards.

Experience as a SCRUM Master and facilitated the Daily standup meetings, Grooming Sessions, Acceptance meetings and Retrospective sessions for the SCRUM team.

Superior analytical and problem solving skills; strong verbal and written communication skills

Currently working as Test lead with responsibilities of Project execution, team handling and defect management.

Certified Scrum Master from INTERNATIONAL SCRUM INSTITUTE.

Demonstrated ability to work on Work Flow Diagrams, Entity Relationship Diagrams, and Data Flow Diagrams.

Excellent team leading capabilities with excellent written, verbal communication and interpersonal skills

Possesses excellent analytical, problem solving and learning skills as well as a keen interest in the emerging technologies Developed Strong Communication and interpersonal skills while working in diverse team environments

Ability to work in a fast paced environment with tight deadlines and keeping quality as preference.

Ability to work with various project stakeholders including BAs, developers, DBA, cross functional teams and project management team.

Expertise in using MS Office (Word, PowerPoint, Excel, Project, and Visio), can create dashboards and reports and pivot tables using MS excel.

PROFESSIONAL ACHIEVEMENTS

Received ‘Spot Recognition’ award for getting CSAT score 6/6 for 2015 Q3 project deliverables.

Received ‘Certificate of appreciation’ from THD lead for testing PM Online+ project in August 2015.

“Syntel Values Awards: SPEED, STRETCH, SYNERGY” a team award for Q3 2014 in Syntel Inc.

Received ‘Certificate of Appreciation’ from THD lead for excellence in job.

“Received excellent appraisal rating throughout 5 year tenure at Syntel Inc.

Selected as part of technical panel for campus recruitment Syntellect 2011 in Syntel Inc.

TECHNICAL SKILLS

ETL Tools

Informatica Power Center, SSIS, ODI

Defect Management

HP ALM, Quality Center 10.0, Bugzilla, JIRA

Operating System

MS-Windows, z/OS, UNIX

Technologies

EDW/BI Testing, Manual/Automation Testing, Bigdata testing

Database

DB2, Oracle, SQL Server, IMS

Tools

SQL server, TOAD for Oracle, Tableau, SSIS, SSRS, OBIEE, Oracle SQL Developer, MFT Mainframe Z/OS, SOAP UI, JIRA, Selenium.

Testing Techniques

White Box, Black Box, E2E, Regression, Interface Testing, Automation testing

Data Transfer Tools

FileZilla, Putty, WinSCP, MFT

Languages

COBOL, JCL, JAVA, Gherkins, Junit, TestNG, Cucumber

EMPLOYEMNT DETAILS

Client: Delta Airlines

Job Title : ETL/BI/Automation

June 2018– Till date

Project: ERMS Modernization

The Enterprise Reference Management System (ERMS) is a collection of processes that update enterprise reference data stored in the EDS. ERMS supports many Delta applications, including RevPipe, OCC Recovery Suite and Kiosk. Currently ERMS relies on older technology. The application runs on HP-UX servers and operating system, and most of the critical reference data is stored in DB2 database on MVS. Enterprise Architecture recommends moving to a modern and more reliable technology align with Organizational goals.

Contributions and Responsibilities:

As a part of this project helped team to create test plans and carried the defect triage meetings.

Wrote complex SQL queries to validate the ODI ETL conversion rules for data converted from legacy Db2 DB to oracle DB.

Worked on automation testing framework for the application using Jenkins and Unix shell scripts.

Created Test Plans and Test Strategy which describes the features and functions to be tested.

Supported solution designing activities and automated test scripts.

Designed and implemented test scripts and managed test automation processes.

Worked on Selenium Java based framework for automation.

API/Webservice test automation using Rest Assured and Postman.

Executed manual scripts and participated in UAT activities.

Modified automated test scripts as per system functionality and functional requirements.

Reviewed test results, issues and defects related to business units.

Prepared and implemented test scripts for unit and regression tests.

Participated in smoke testing, regression testing and user interface testing.

Manage daily interactions with client executives and PSC (Project Steering Committee).

Helped team on technical front to write SQLs to test the database part of the test effort.

Review project documentation for all assigned projects to ensure that the project requirements are clearly defined

Analyze project requirements and develop Test Plans and documented test cases that ensure that all functionality is performing as intended.

Report defects and escalate issues as needed.

Meeting with management and project steering committee on testing health and any show stoppers.

Generating reporting from ALM as per management needs.

Trained and mentored the test team on software testing processes and SQL scripting practices.

Set the standard test procedures to carry out the thorough testing of the new system.

Developed Requirements Traceability Matrix (RTM) to make sure the TCs are lined up against the requirements.

Conducted Daily standup meeting with test team on the issues/blockers/status on the work being done and planned.

Skills/Tools: Oracle SQL developer, HP ALM, DB2, Mainframes/TPF, MFT

Environment: Windows, UNIX, Mainframe, JAVA, SQL

Client: State of Georgia, Department of Labor

Job Title : Lead QA Analyst [ETL/BI/Automation]

June 2016 – June 2018

Project: SCUBI

State of GA DOL is currently working on modernizing their legacy applications. As a part of this effort they are working on migrating their UI part of the application from DB2 to Oracle and mf to JAVA web-based application.

Contributions and Responsibilities:

As a part of this project helped team to create test plans and carried the defect triage meetings.

Wrote complex SQL queries to validate the ODI ETL conversion rules for data converted from legacy Db2 DB to oracle DB.

Validated the ODI batch jobs as per the requirements against data in the tables.

Worked on automation testing framework for the application using Selenium.

Created Test Plans and Test Strategy which describes the features and functions to be tested.

Build cross platform testing with Selenium WebDriver and Cucumber JVM.

Developed and implement Keyword Driven, Selenium Page Object Model framework with Selenium WebDriver using Object Oriented Programing Java and open source unit test framework TestNG

Interface testing where ODI is used to send and receive data to and from external agencies.

Supported solution designing activities and automated test scripts.

Designed and implemented test scripts and managed Selenium test automation processes.

Executed manual scripts and participated in UAT activities.

Modified automated test scripts as per system functionality and functional requirements.

Reviewed test results, issues and defects related to business units.

Prepared and implemented test scripts for unit and regression tests.

Participated in smoke testing, regression testing and user interface testing.

Manage daily interactions with client executives and PSC (Project Steering Committee).

Helped team on technical front to write SQLs to test the database part of the test effort.

Review project documentation for all assigned projects to ensure that the project requirements are clearly defined

Analyze project requirements and develop Test Plans and documented test cases that ensure that all functionality is performing as intended.

Report defects and escalate issues as needed.

Meeting with management and project steering committee on testing health and any show stoppers.

Generating reporting from ALM as per management needs.

Trained and mentored the test team on software testing processes and SQL scripting practices.

Set the standard test procedures to carry out the thorough testing of the new system.

Developed Requirements Traceability Matrix (RTM) to make sure the TCs are lined up against the requirements.

Conducted Daily standup meeting with test team on the issues/blockers/status on the work being done and planned.

Skills/Tools: ETL ODI Testing, Oracle SQL developer, HP ALM, OBIEE, DB2, Mainframes, Selenium, JAVA, MFT

Environment: Windows, UNIX, Mainframe, JAVA, ODI

Client: State of Georgia, Department of Labor

Job Title: Lead QA Analyst [ETL/BI]

Nov 2015– June 2016

Project: MfRehost

State of GA Department of Labor (GDOL) is migrating their legacy system from mainframe to Linux. It was a huge effort as migrating the systems is always a big challenge both for development and testing teams considering the volume of work and number of teams and applications involved.

Contributions and Responsibilities:

Leading the team through the project.

Created the test strategy, test plan and test approach

Performed system, functional, integration, compatibility, availability, regression testing.

Performed negative testing to test the application for invalid data, verified and validated the error messages generated.

Conducted the defect triage from testing team to discuss on the defects.

Represented as a test lead from Client side (GDOL) and facilitate weekly Quality Assurance meetings with the project stake holders

Provide weekly QA status report to the Project Steering Committee (PSC).

Create Test report summary; metrics

Provide QA Sign-off

Perform quick smoke test post deployment.

Connecting with various stakeholders for blockers

Coordinating with DBA for database issues.

Coordinating with team members on the issues they are facing.

Co-ordinated the online, web-based, outside interface testing with numerous vendors that are GDOLs technology partner.

Analyzed the failures on prod and dev box and tracked them to closure.

Wrote UNIX scripts to automate the analysis of the failed jobs.

Prioritized the high-risk areas and raised flags time to time to the Project Steering Committee on the issues.

Tools Used: HP Quality Center 10, MS Project, MSWord, MS Excel, PL/SQL Developer, Mainframe, SharePoint, UNIX batch, Control-M & Selenium.

Environment: Windows, UNIX, Mainframe Z/OS.

Client: The Home Depot, Atlanta, GA

QA Lead/Scrum Master/Product SME

Sep 2013 – Nov 2015

Project: Assortment Execution Integration

A web-based assortment tool KIAPT (Key Item Assortment Tool) for assortment of all the items/products/SKUs and providing the planogram for each store.

Contributions and Responsibilities:

Leading the project with 20 members and mentoring newly joined engineers to optimum level of efficiency.

Implement quality software best practices to develop test strategy, test plan, test data, test case and test automation and actively participates in process improvements.

Designed automation testing framework for the application using BDD, Keyword Driven and Data Driven Approaches.

Implemented Continuous Integration using Jenkins and Maven.

Used JIRA for Project and Bug tracking tools. Followed Scrum process to implement Agile Software development method.

Implemented Parallel execution of scripts using SAUCE LABS.

Created Test Plans and Test Strategy which describes the features and functions to be tested.

Developed scripts using Selenium WebDriver and Selenium Grid for cross browser testing.

Implement wide range of functional testing by various QA Automation Test Framework like Key Word Driven, Data Driven and Behavioral Driven Testing concept to ensure the code reusability and code maintainability, which reduces the script development time.

Build cross platform testing with Selenium WebDriver and Cucumber JVM.

Developed and implement Keyword Driven, Selenium Page Object Model framework with Selenium WebDriver using Object Oriented Programing Java and open source unit test framework TestNG Developed automation scripts/framework using Selenium WebDriver to automate the testing process.

Worked as a SCRUM Master and Product Owner, depending on project needs.

Facilitated the Daily standup meetings, Grooming Sessions, Acceptance meetings and Retrospective sessions for the SCRUM team.

Backlog maintenance and tracking all the tasks logged in JIRA to closure with every sprint.

Making sure the various stakeholders are updated about the sprint deliverables and show stoppers.

Working with team on closure of the blocking issues.

Reviewing product backlog with Product Owners and other concerned parties.

Mae sure that the Product Owner and delivery team are in sync and agreement for expectations and product and timelines.

Writing the User Stories and presenting it to the SCRUM team.

Performed Demos of the application to business owners during the acceptance meetings.

Presented the ideas on how to make enhancements to the application to make it smooth for end users.

Analyzed system specifications and user stories to design and develop test cases

Creating Test estimations, Test strategies and Test Plans, writing and executing Test Cases.

Web testing of KIAPT tool by providing the pricing, facings, linear width, attributes of each item and the traits details of each stores.

Publishing the assortment plan from KIAPT for integration testing purpose and providing the assortment reports to Planogram team.

Troubleshooting of the back end database for the bad data in the KIAPT tool.

Creating the SQL queries and fetches the data from the DB2 using SQL developer.

Running java batch jobs of daily, weekly and monthly for the testing purpose.

Tested and Implemented the KIAPT tool using Agile testing methodology for monthly production release.

Performed the Functional, end-to-end, regression, performance, UAT and production support testing.

Performed intensive Black Box Testing and high level White Box Testing.

Defect reporting, daily, weekly and monthly testing reports using Quality Center

Perform System, Integration and Regression Testing and provide test data for User Acceptance Test.

QA Lead for the members at offshores and review their deliverables before sharing the results with the client.

Participated in writing High-level Test plans, Test Scenarios, Test cases Analysis and Presentation of Results.

Creating Traceability Matrix and executing test cases in Quality Centre and validating the results.

Creating and publishing the daily, weekly and Monthly project and defect reports to higher management.

Creating the management and financial reports for the project using MyCompass reporting tool.

Created various Excel reporting utilities in cooperation with quality center including the graphical and bar reports.

Performed feasibility study and automated the KIAPT tool with Selenium.

Tools Used: KIAPT Assortment and Planogram tool, HP Quality Center 10, MyCompass reporting tool, MS Project, MSWord, MS Excel, PL/SQL Developer, SharePoint & Selenium.

Environment: Windows, UNIX

Client: First Data Merchant Services, Baltimore, MD

Team Lead/Senior Developer

May 2010 – Sep 2013

Project: Merchant Backend Settlement and FMS (Financial Management System)

First Data offers a variety of credit card processing services, including an internet, retail and mobile version. First Data securely processes the transaction and harnesses the power of the data to deliver intelligence and insight for its customers.

Our application is related to Merchant Backend processing. Here we create settlements for Merchants on a daily, monthly and annual basis. All the transactions carried out by a merchant are being settled in our application. Projects completed 1) Keystone 2) Durbin Amendment 3) Pin Debit 4) Price Bundling 5) Migration.

The other application in Merchant Backend is FMG which is Finance Management group. Finance Management Group is an application designed to help the client in dealing with their financial concerns. Provide the accurate and timely reporting of merchant financial data. This includes the electronic delivery of reports and data files to both the FDMS Finance Group and Alliance’s. Technical Attributes: COBOL, Datacom, DB2, SAS, JCL, VSAM, CICS. We create the various reports which are transaction level & financial hierarchy level for credit & debit transactions for our customers. Reports like Sales & Transaction report, Interchange & Assessment report, Revenue report, Discount Interchange & Assessment report etc. We also create the reports for associations like MasterCard, Visa, Discover and Amex.

Contributions and Responsibilities:

Developing and maintaining the applications using COBOL, JCL, DB2, VSAM, CICS, SAS, File Master, CA7 Scheduler.

Preparing detailed design document for the project. Providing sizing and estimate.

Working on application enhancement. Working on production issues.

VSAM file handling. Using DB2 database for data fetching and updating. Working on complete SDLC for projects.

Onsite offshore co-ordination. Client interaction. Technical training to resources. Requirements gathering.

Working on roll out activities.

Used ENDEVOR as version management tool. Hand on expertise on CA7 Scheduler for scheduling of the jobs. Post implementation support.

Worked on a very niche technology “Stratus mainframe” for migrating the system to IBM mainframes environment Z/os. Responsibilities included creating elements (CODES, JCL, PROCS, JOB DOCS, SORT CARDS etc.) from scratch to create the same functionality on mainframe.

Tools Used: FileAid, XPeditor, QMF & SPUFI, Endeavor and Changeman, CA7, DB2, SCLM, MSWord, MS Excel & SharePoint.

Client: AT&T, CA

Team Lead/Senior Developer

June 2006 – May 2010

Project: Local Access Service Request (LASR) and Minimal Input and Automatic Order Generator (MI-AOG)

LASR is Local Access Service Request. LASR is part of AT&T Operational Support systems (OSSs). It is a software system designed to accept requests from Wholesale Customers for Unbundled Network Elements (UNEs) and Resale Services and then manage the information required to fulfill those requests, converting end users service to the ordering Competitive Local Exchange Carriers (CLECs).

Contributions and Responsibilities:

Developed the COBOL source code for the new and existing applications.

Fixing the code to resolve the production issues.

Writing and running COBOL Batch jobs (JCL).

Debugging the COBOL and CICS (Online Screen) codes for fixing the issues.

Performed Unit Testing for COBOL Codes and for CICS Online Screens.

Worked on hi-priority production issues which require quick turnaround time.

Excellent logical and analytical skills.

Hands on expertise in XPEDITOR for debugging the online CICS programs

Wrote JCL’s from scratch for newly developed applications

Hands on CA7 automatic scheduling of the mainframe jobs.

Hands on expertise on Endeavor and Changeman.

Tools Used: FileAid, XPeditor, QMF & SPUFI, Endeavor and Changeman, CA7, DB2, SCLM, MSWord, MS Excel & SharePoint.

ACADEMIC BACKGROUND

Bachelor of Engineering (Mechanical)

Institute of Engineering & Technology, Devi Ahilya University, Indore, India

Year Completed: 2006

Contact this candidate