Around 7 years of professional IT experience as QA ETL/MDM analyst/lead. Experience in working on medium to large complex projects under minimal direction. Efficient team player; managed the team both on-site and offshore. Strongly committed to deadlines, delivery, accuracy and quality of assignments. Solid domain knowledge in Life Sciences, Healthcare and Banking. Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process, and Agile Scrum methodology. Highly skilled with a different type of testing processes such as Functional, Integration, Backend, Regression, Black Box, GUI, UAT, ETL, XML and Reporting. Proficient in testing data warehousing, data migration and data integration environments. Expert in SQL queries/subqueries, stored procedures and all complex joining. Profuse experience with Informatica Customer and Product Master Data Management (MDM), report analysis activities for MDM and BI tools; experience with analysis/validation of large datasets. Experience in interacting with clients, business analysts, developers, technical support and help them to baseline the requirement specifications. Experience in validating XML, CSV and flat files according to the business rules defined. Exceptional understanding of data analysis and statistics, conceptual, physical data modelling and ER diagrams. Extensive experience with Reporting Tools like Cognos, Clearview, Tableau and Business Objects.
Areas of Expertise
Operating Systems WINDOWS/UNIX/MAC OS
Implemented user acceptance testing with a focus on documenting defects and executing test cases. Managed testing cycles, including test plan creation, development of scripts and co-ordination of user acceptance testing. Applied best practices of software development while staying abreast of advances in the practice. Consulted regularly with customers on project status, proposals and technical issues.
Associate June 2007 to December 2013Cognizant Technology Solutions
Master of Science : Information Systems, Dec. 2016Pennsylvania State University, Capital College － Middletown, PAGPA: 3.92/4.00Information Systems 3.92/4.00
Bachelor of Computer Science and Engineering : May 2007Government College of Engineering － Amravati, IndiaGPA: 7.10/10.007.10/10.00
Onsite Agile QA Analyst April 2013 to December 2013Ernst and Young － Alpharetta, GA
Worked with Cognizant Technology Solutions (CTS) India and the USA from Jun 2007- Dec 2013 for various clients.
ATF (Audit Tool for Future) Worked as onsite resource for agile (Scrum) integration team and managed a team of 5-6 members.
Worked extensively with the business user and business analysts during the requirement sessions and participated in HLD walkthroughs and brainstorming sessions between SME, Designer and development teams.
Analyzed functional requirements/user stories and translated requirements into written test plans, detailed test cases and test schedules by following Agile/Scrum process.
Conducted requirements walkthrough within the Testing team.
Created test cases to validate the Source and Target database systems data and mapping rules for data transformation.
Wrote complex SQL queries for data analysis.
Assisted in verification of user stories, suggested requirement changes which got accepted by POP/story authors.
Helped in writing user stories to fill the gap in requirements.
Involved in Regression, Functional, Integration, Smoke, Ad Hoc, End to End System Testing and UAT as a part of sprint cycles.
Analyzed and generated daily intelligence and business reports.
Integrated all the modules and presented a final prototype of the product using Visio tool.
Drafted proposed approaches, schedules, delivery milestones to project management.
Involved in all sprint ceremonies like sprint estimation, sprint planning, scrum calls.
Onsite BI QA Lead November 2011 to March 2013FIRM and LIFT Amgen Inc － Thousand Oaks, CA
Helped in end to end application validation, UAT, regression and database testing activities.
Worked with the ETL team to create views by combining tables and using the views in Tableau.
Performed data visualization and analysis using Tableau, Cognos and BI reports.
Helped with data migration related to clinical studies from an old system to new system.
Validated the data loaded into the target Teradata database which extracted from multiple operational data sources DB2, Oracle, SQL Server and flat files.
Verified data from various source systems against Teradata data warehouse.
Tested the report generation and written complex queries using different data providers in the same report.
Designed effective SQL queries for faster analysis and validation of data in different database systems.
Assisted with a development of project tracker to help the client keep track of study related activities.
Created a dummy production database environment for testing by creating tables and loading data through excel, text and XML files.
Worked on data analysis of Cash Management Module.
Helped create requirement traceability metrics (RTM), test reporting, defect resolution, results analysis and metrics.
Assisted business users to go through various scenarios during UAT sessions and logged UAT defects.
CM Account Cleansing.
Onsite MDM QA lead November 2010 to October 2011Boehringer Ingelheim － Danbury, CT
Conducted requirements gathering and elicitation, analysis of business scenarios, refining logic for each BI applications.
Developed QA project plan to keep track of MDM activities and deadlines as per IT strategy and planning.
Created high level matrix template for gap analysis to review, observe and find gaps of requirement vs.
test case, vs.
Defects cycles, which improved accuracy, clarity and adequateness of test cases.
Analyzed and managed business entities, hierarchies, and attributes, by mapping them across multiple systems in Master Data Management (MDM).
Validated data relationships and calculated attribute values using business rules.
Performed data analysis by verifying integrity and quality in the database according to the requirements in Customer Master (CM).
Verified the golden records/best version of data are as per the trust framework, validation rules and the defined match rules.
Documented high-level characteristics of data such as data volume per table, relationships between entities, missing values, missing referential records, extreme values, counts for each reference type value etc.
Validated data mapping from legacy systems to Customer Master data management (MDM) Helped with a new approach of creating datasets using flat files and extracting it through ETL for testing.
Tracked and reported various testing activities including test results, test case coverage, required resources, defects discovered and their statuses, performance baselines, etc.
Mentored new team members and helped them to acquire business knowledge as well as technical knowledge.
Interacted with the client in task/process and served with best suggestions to deliver quality products.
Organised project plan meeting, QA plan meeting, weekly status meetings and on board meetings.
Offshore MDM QA Lead June 2009 to October 2010Merck Inc. & Co － Pune, India
Performed end to end Customer and product master testing activities.
Validated the ETL flow from sources to the pre-landing tables and from the pre-landing tables to the MDM landing tables.
The sources consisted of relational databases, flat files, Excel files, XML files etc.
Helped with automation of test scripts using QTP.
Executed the stage jobs to verify the data flow via mappings from landing to staging is accurate in terms of the data cleansing requirements, and that the lookups are correctly applied.
Performed data validations, constraints check, record counts, Source to target mapping, random sampling and error processing on the ETL and MDM modules.
Performed detailed testing on cleansing functions to verify addresses are cleansed as per the business requirements.
Verified the IDD (then BDD) application has the correct validations as per the business requirements in the functional and low-level design documents, performed log analysis after data load.
Performed end to end IDD workflow integration testing by ensuring the approval workflow process can only be done by users with the required roles and permissions.
Identified improvement areas to enhance and streamline existing quality assurance (QA) practices Ensured the daily deliverable of the project and reviewing the task performed by the team members.
Addressed various performance issues which helped clients detect the problem in an early phase of the project.
Offshore PHP Developer August 2007 to May 2009E*TRADE Financial- IL&FS － Pune, India
Developed end-to-end user interface of a particular section in SugarCRM using PHP.
Enhanced the application based on the client requirements.
Updated design document based on changes in workflow for lead, account and opportunity.
Involved in functional, unit testing and prepared development summary and status report.
Participated in the promotion of best practices within the organization in collaboration with other IT personnel.
Presented demos to the team and business users.
Awards and Recognition: Received 'Spot Light' Award for excellent contribution to the project in February 2011.
Received 'Associate of the Month' award for overall performance in March 2010.
Team Recognition for 'Global Project of the Year', awarded for contributing to the innovations in August 2008.
Sun Certified Java Professional (SCJP 1.5)
*Foundation Level Testing Certification (ISTQB)