Address: Tanjong Ria,
#**-**, ********* – 436914
Data Quality Manager with a demonstrated history of working in the Telecomm, Financial, Travel/Hotel and Retail domains.
Gained diversified experience in implementation and delivery of a wide range of data projects
- Analytical Data Marts, data migration & data integration projects.
Delivered seven large-scale analytics data marts, for a leading Property & Casualty Insurance provider in the USA market, specific to each line of business including Property, General Liability and Small Business. Thus, improving the overall profitability of the client’s underwriting book of business by close to 15% in a span of 3 years.
Successfully analysed & interpreted underlying data using database queries from multiple sources & presented low-level information in business reports for end users to improvise strategies and operations.
Experience of 8+ years in Software Quality Assurance and Automation Testing.
Adept in leading teams of various sizes and mentored team members to deliver tasks on time and groomed them to achieve their goals.
Strong understanding of SDLC/STLC & Defect Life Cycle with experience in both V-Model and Agile Methodologies, performing range of testing types - Integration, System, UAT, Regression, ETL and Risk based Testing.
Responsible for defining Test Strategy/Approach, preparing and managing test cases, maintaining Traceability Matrix and QA Metrics, identifying and analysing defects, estimating costs, creating resource plans, managing teams and leading testing efforts.
Skilled in Test Automation Tool HP QTP/UFT and Test Management Tool HP QC/ALM, Oracle/SQL/MySql/Mongodb Databases, Requirements Analysis, Quality Assurance and Quality Control aspects.
Acquired substantial business acumen with experience in catering to a diverse clientele ranging from Insurance to Accounting, Investment management & across Ecommerce.
Excellent in problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
Tools: SQL Developer, Informatica, HP QTP/UFT, HP QC/ALM, Toad, Control M, MS Excel
Languages: SQL, PL/SQL, Unix
Databases: Oracle 11g/10g/9i, MS SQL Server, MS Access, Mongodb, MySQL
Applications: Oracle Apps, PeopleSoft, Guidewire - Enterprise Policy Center, SalesForce Achievements
Received ‘Pinnacle’ Award in FY-11 for contribution to Process improvement through automation scheduling sets for multiple applications
Received ‘Accenture Ace’ Award twice in FY-14 and FY-15 for contribution to Productivity Improvement through Automation
Received ‘212’ Award from client for successful deployment of a Project
Completed HP ALM 11 certification in March 2013 with distinction Work Experience Organization : eClerx Services Ltd.
Duration : April 2018 – Dec 2018
Process Manager SW DMS – Pricing Apr 2018 – Dec 2018 Project Name: Pricing CI(Competitive Intelligence) is a data harvesting and management team having developed tool which deals with data crawling/scraping on websites for Travel and Retail domains to provide metrics and reports to client for analytics & decision making purposes.
Responsible for defining test strategies, test plans, creation and execution of test cases for UT, Functional, Database and Load/Stress testing.
Defined standard test packs (test cases and supporting expected results mapped to core functionalities) to enable recurring core component functional regression as part of the global quarterly testing and release cycles.
Continuous maintenance of regression testing approach and standardized test packs to accommodate additional functional changes delivered as part of each quarterly global test and release cycle.
Ensured that all the plans and relevant changes are communicated to all the relevant stake holders.
Managing and co-ordinating between development, QA and Operations team.
Creating SQL queries/procedures to investigate and troubleshoot data discrepancies and correct software bugs and deficiencies - thus improving system efficiencies and reducing post go-live expenses.
Organization : Accenture Services Pvt. Ltd.
Duration : May 2010 – Jan 2018 (7.7 years)
BI Test Lead MFS – GDM Mar 2017 - Jan 2018
Project Name: Global data mart(GDM) is a data management team working data marts to create Organization and Contacts data from multiple sources using informatica and data is brought into the Salesforce application.
Lead GDM QA team of 9 members.
Understood the data flow, functionalities & dependencies for different SCRs/workflows and implemented them on testing.
Raised queries/issues regarding mappings/conditions to the onshore/offshore dev team on time and followed up on the same.
Coordinated the tasks well to meet project timelines.
Lead the automation drive of GDM SCRs using DB Unit, ensuring maximum of the SCRs are automated to save efforts and to be utilized for further phases in the project. ETL BI Test Lead CNA Insurance – IMCC Jan 2014 - Feb 2017 Project Name: Integrated management competency center (IMCC) comprises of a data management team which has successfully deployed more than 10 data marts. Using the ETL process data is brought into the Merlin environment needed for reporting and analytics purposes.
Lead the System and ETL testing team of 7 members.
Delivered 7 successful Data marts.
Used my Database & SQL knowledge learnt working on previous projects onto the datamart test execution.
Implemented reusable testing framework in projects which improved Testing efficiency.
Transitioned my knowledge on Insurance and Data marts project and trained all the newcomers in the team to deliver all tasks on time.
BI Test Engineer CNA Insurance - Project Costing July 2013 - Dec 2013 Project Name: Project Costing (PC) is a sub-module within PeopleSoft which is installed in the PeopleSoft Trans Finance Environment as the integration point between Actuals collected in PeopleSoft and the Projects data collected in Primavera, which became the new source for generating Project Financial reports replacing the earlier manual process. We were involved in the integration and system test of the PC module.
Was part of Integration and System test team.
Worked on PeopleSoft and ETL testing for the PC module.
Delivered project releases within timelines thereby meeting Client’s SLA. Software Engineer Aristos OFI Test December 2010 - July 2013 Project Name: The OFI Test Project is the Functional Regression Testing project of AT&T’s Financial Applications. It ensures intact performance of AT&T's Financial system post mergers. We were involved into functional regression testing and performance testing of AT&T systems.
Was part of regression and automation test team.
Worked on projects accounting module of Oracle Apps.
Created automation scheduling sets for multiple applications which resulted in successful nightly batch run of 119 automated scenarios, which saved 7 man days efforts per release for next releases.
Mentored new resources in the team.
Associate Software Engineer NI CONVERSION July 2010 - October 2010 Project Name: Level 3 Communications is an international communications company headquartered in Broomfield, Colorado. The company operates one of the largest communications and Internet backbones in the world. The Network services used in level3 are Internet Protocol (IP) services, broadband transport, collocation services, and patented Soft switch-based managed modem and voice services.
Was part of the functional testing team.
Worked on the Migration of the topology circuits and segment data and design of circuits. Education B.E Information Technology
S.I.E.S Graduate School of
Mumbai 2009 64.56%
H.S.C. (Science) Vani Vidyalaya, Mulund Maharashtra 2005 85.00% S.S.C.
St Mary's English High
Maharashtra 2003 82.66%
Personal Details Date of Birth: 16 December 1987 Languages known: English, Hindi, Tulu, Marathi