Kyra Solutions, Inc.
(Formely known as Kyra InfoTech, Inc.)
Naarasimharao Mahamkali
ETL Data analyst / QA
EXPERIENCE SUMMARY
IT Professional with 15+ years of experience in ETL/BI Process Development and testing.
Experience in ETL implementation using Informatica
Good Understanding on Reports Implementation and Validation.
Good understanding in Data Warehousing / ETL Testing Concepts.
Strong experience in creating E2E scenarios / SQL Queries for Data Validation.
Experience in Development, testing of New, conversion, migration and maintenance of Data warehousing Projects.
Experience in managing large teams on ETL Development / testing projects
6+ Years of Experience in P & C Insurance and have experience in Claims area and Guidewire CC
Experience in Tolls and Retail domains.
Experience in creating / reviewing Use cases / Test scenarios / Test cases and SQL queries to ensure that all the Business functionalities are covered w.r.t Business Requirements / Rules, Data model, S2TM and Visio Flows.
Experience in BVT / Smoke, Functional, Regression and End to End Testing.
Experience in Create/Review Test estimates / Strategy (E2E) based on the Testing scope and planning resources.
Experience in Data Quality analysis, Data Migration and Data mapping.
Knowledge on Data modeling and Data cleansing.
Experience in creating Development and Test Plan / Schedule based on the project plan.
Able to multitask, manage concurrent project efforts, and work under pressure situations.
Strong experience in Test management tool QC / ALM.
Experience in Liaising with Data Architects, Delivery leads, Business Analysts to identify high level scope and Development / test approach based on the requirement analysis.
Experience in working with different sources of data like XML, CSV, Excel, Main frame and Data bases.
Experience in identifying the re-useable components which can be used to automate the functional testing aspects, automate and reuse it for regression testing and implement it in other similar projects.
Worked on both SDLC and STLC.
Worked on both Waterfall and Agile methodologies.
EDUCATION
Bachelor of Technology (B. Tech), 70%, Andhra University, Andhra Pradesh, India, 2001-2005
Work Experience
Working as Sr. Data Analyst for Kyra Solutions, Inc., USA from 06/16 to till date.
Worked as Test Lead B3 for Wipro Technologies, USA from 03/14 to 06/16
Worked as a Sr. Associate for Cognizant Technology Solutions, Chennai and USA from 05/08 to 03/14
Worked as a Software Engineer for Nutech Software Solutions, Bangalore from 09/05 to 05/08
Certifications:
PCAP (Certified Associate in Python Programming
SAP Analytics Cloud
TECHNICAL SKILLS
OS
Windows XP, Vista, 7
Languages
SQL, PL/SQL
Databases
Oracle - Worked on DB testing(Tables Extraction, Processing and Mappings), SQL Server 2008 and Netezza
Tools & Utilities
HP Quality Center / ALM, SOAP UI, TCP MON, Informatica, Tableau, Data Stage, Toad and Autosys
Project Acquired Skills
Data Warehouse Testing, Data Quality Analysis, Data migration, Data Cleansing and Data modeling
Domain Knowledge
P&C Insurance, Retail related applications and Tolls
MS Office
MS Word, MS Excel, MS PowerPoint, MS Visio, MS Outlook, MS OneNote, MS Lync, MS Live meeting and MS Project
PROFESSIONAL EXPERIENCE
Date: 06/16 – Till date (54 Months)
Company: Kyra Solutions, Inc.
Client: Florida Department of Transportation Boca Raton FL
Project: EDW – Florida Turnpike Enterprise
Title: Sr. Data analyst
Environment: Informatica, Tableau, Cognos, CAWA, Oracle, Toad, SOAP UI, Quality center.
Responsibilities
Working on E2E tasks
Participating in Requirements gathering, Performing impact analysis, Creation of Development / Test Strategy
Creation of Design documents
Performing Data analysis, Data validation
Creation of ETL jobs, Automating and Maintaining the jobs.
Performing Unit testing, System integration testing (ETL validation and Reports data testing)
Providing the SQL’s for report implementation and Validation of report data
Work with Finance periodically to discuss the expectations and about current deliverables by Presenting the Data analysis reports.
Date: 04/14 – 06/16 (26 Months)
Company: Wipro Technologies
Client: The TJX Companies Inc., Marlborough, MA
Project: TJX Enterprise Data Warehouse
Title: Sr. Test Lead
Environment: Datastage, Quality center, Netezza, Toad, SSH Tectia BI
Responsibilities
Analyzed business requirements / rules, functional specifications documents and source to target mapping documents.
Responsible for preparing / reviewing test effort estimation, test strategy document, QA Business Scenarios in PPT & Visio flow format to review with the Business Stake Holders. This is additional to QA Technical Scenarios which we author as part of Testing Process.
Performed Data Quality analysis required for Data Migration, Data modeling, Data mapping, Data cleansing and for Test data preparation.
Prepared / reviewed test scenarios / cases / queries for Data validation.
Served as a primary point of contact from EQA team for all the modules of EDW Program.
Participated in design analysis & transition of subject knowledge to Onsite leads & offshore teams.
Responsible for authorizing complex SQL queries and help the teams by reviewing the Test Artifacts.
Performed functional (ETL Testing), regression testing and data validation of BI reports.
Conducted defect triage meetings and participated in root cause analysis.
Created status reports and reviewed with QA management team on regular basis.
Interacted with application team (Source), UAT and Business teams to identify the requirements, scenarios and data for E2E testing.
Responsible for actively participating in Data model and Source to Target mapping review meetings and identifying issues at earlier stage of Project.
Prepared test data requirements document and review with E2E team.
Worked on both Waterfall and Agile methodologies as per project requirement.
Coordinated activities between onsite and offshore testing team and other teams like development, upstream and downstream teams.
Worked on majority phases of SDLC.
Date: 05/08 - 03/14 (71 Months)
Company: Cognizant Technology Solutions, Chennai, India
Client: Hartford Financial Services Group, Hartford, CT
Date: 07/13 - 03/14 (10 Months)
Project 1: Mitchell DP - Auto Med bill
Title: Sr. Test Lead
Environment: Informatica, Quality Center, Oracle, Toad, Autosys.
Responsibilities
Responsible for preparing Test Plan (Functional, Conversion and E2E).
Prepared ETL Test Scenario's based on FSD.
Worked with front end and UAT teams to prepare E2E scenarios.
Worked with vendor in case of data issues. (Conversion and Functional)
Performed ETL test case execution.
Interacted with development and vendor team to fix the issues.
Involved in ETL Functional, Conversion, Regression and E2E Testing.
Prepared test summary report.
Provided estimation based on the assumptions.
Revised estimation in case of discrepancies in assumptions.
Assigned resources throughout the SDLC process based on the Test Estimates.
Prepared of daily, weekly status reports.
Date: 12/12 - 03/14 (16 Months)
Project 2: ECOS (Enterprise claims operating system)
Title: Sr. Test Lead
Environment: Informatica, Quality Center, Oracle, Toad, Autosys.
Description: Enterprise Claims Operating System has been initiated to consolidate the claims systems, Current Source and ClaimInkwovation’ applications would be replaced by Guidewire claim center Platform. The scope of DW team to build new strategic claims data warehouse and data mart with one-day lag.
Based on this DW team has to work on all impacted extracts, applications and reports.
This will be implemented for all the LOB’s (PP, PA, CA, CP, HL, GL and WC).
Lead the Following tracks
Application Conversion (Existing Claims applications into Guidewire CC)
Testing of Newly Implemented Claims system
Testing of Inbound and Outbound Extracts.
Reports implemented on New system
Responsibilities
Created test strategy for all the tracks (Conversion, Functional and E2E).
Identified E2E requirements, scenarios and test data requirements.
Monitored and mentored all the testing tracks.
Made sure that testing process is set for E2E testing.
Created E2E scenarios / SQL Queries for Data Validation.
Performed Functional (ETL Testing), Conversion, Regression testing, Data Validation of BI reports.
Conducted defect triage meetings and participated in root cause analysis.
Involved in business meetings to understand impacts to existing applications based on new initiative.
Provided estimation based on the assumptions.
Revised estimation in case of discrepancies in assumptions.
Conducted meetings to provide KT on Claims applications to the project members.
Involved in requirements review meetings.
Identified risks, issues, dependencies and mitigation plan.
Interacted with all the Third Party teams (GW, Inbound and Outbound) involved in Testing.
Coordinated activities between onsite and offshore testing team and other teams like Development, upstream and downstream teams.
Date: 12/11 - 11/12 (12 Months)
Project 3: STC - WC Med bill
Title: Sr. Test Lead
Environment: Informatica, Quality center, Oracle, Toad, Autosys.
Responsibilities
Prepared test strategy (Functional, Conversion and E2E).
Worked with vendor in case of data issues. (Conversion and Functional)
Performed ETL test case execution.
Interacted with development and vendor team to fix the issues.
Prepared ETL Test Scenario's Based on FSD.
Involved in ETL Functional, Conversion, Regression and E2E Testing.
Prepared test summary, daily and weekly status reports.
Involved in Business meetings to understand the assumptions of implementing new application.
Provided estimation based on the assumptions.
Revised estimation in case of discrepancies in assumptions.
Worked with front end and UAT teams to prepare E2E scenarios.
Date: 03/09 - 03/14 (61 Months)
Project 4: MTC – Claims and Web services
Title: Test Lead
Environment: Informatica, Quality Center, Oracle, Toad, Autosys.
Responsibilities
Led MTC - Personal Lines, Commercial Lines, Claims and Working on Claims and Web Service related Requests.
Prepared Use Cases / Test Scenario's based on MRD.
Identified test data for all the scenarios based on the requirements.
Performed test case execution.
Involved in functional and regression testing.
Prepared test plan and test estimations.
For ETL related requests used TOAD tool to run the SQL scripts and for all Web service related requests and used SOAP UI tool to run the Input requests and to view output request.
Understood the MRD.
Prepared test summary, daily and weekly status reports.
Date: 06/08 - 02/09 (09 Months)
Client: Abbott Laboratories, Chennai, India
Project: Abbott PPD Sample ordering interface and reports
Title: Sr. Test Engineer
Environment: Informatica, Quality Center, Oracle.
Responsibilities
Understood the FRS and HLD.
Prepared test strategy.
Prepared ETL Test Scenario's for Source to Target Mappings Based on ETL Mapping Document and FRS.
Prepared test data that covers all scenarios' for ETL Testing.
Involved in preparation and execution of ETL test cases and raised the defects in Quality Center.
Involved in functional and integration testing.
Date: 09/05 - 05/08 (33 Months)
Company: Nutech Software Solutions, Bangalore, India
Date: 02/07 - 05/08 (16 Months)
Client: Mellon Financial Corporation, Bangalore, India
Project: Mellon HR solutions
Title: Sr. Test Engineer
Environment: Informatica, Oracle, Quality Center, TOAD
Responsibilities
Prepared ETL test cases based on ETL Mapping Document and FRD.
Attended daily status calls with Onsite coordinator to evaluate the testing process and active interaction in monthly status calls with client.
Prepared test data that covers all scenarios' for ETL Testing.
Involved in preparation and execution of ETL test cases and raised the defects in Quality Center.
Involved in functional and regression testing.
Date: 08/06 - 01/07 (06 Months)
Client: OPC (Oman Petroleum Company), Bangalore, India
Project: Information System
Title: Test Engineer
Environment: Informatica, Test Director, Oracle9i, Toad
Responsibilities
Prepared ETL test cases based on ETL Mapping Document and FRS.
Attended daily status calls with Onsite coordinator to evaluate the testing process and active interaction in monthly status calls with client.
Prepared test data that covers all scenarios' for ETL Testing.
Involved in preparation and execution of ETL test cases and raised the defects in Quality Center.
Involved in functional and regression testing.
Date: 11/05 - 07/06 (09 Months)
Client: Siemens Corporation, Bangalore, India
Project: Siemens HR Data Mart
Title: Test Engineer
Environment: Informatica, Test Director, Oracle 9i, Windows NT
Responsibilities
Prepared ETL test cases based on ETL Mapping Document and FRS.
Attended daily status calls with Onsite coordinator to evaluate the testing process and active interaction in monthly status calls with client.
Prepared test data that covers all scenarios' for ETL Testing.
Involved in preparation and execution of ETL test cases and raised the defects in Quality Center.
Involved in functional and regression testing.