Data Analyst Test Engineer

Dhivya Saravanan

Email: *********@*****.***

Mobile No: 803-***-****

**** ********* ****, ****** ****, SC-29707

SUMMARY

A Certified Enthusiastic Software Engineer with 4+ years of working experience in an Agile environment implementing the SAFE framework across different roles, including Senior Business Data Analyst, Software Data and Testing Engineer. An innovative IT enthusiast with overall experience of 4+ years in analysis & testing solutions to build products and features to meet business vision. Extensive experience in software testing, system analysis, and leading cross- functional teams in Agile/Scrum methodology across multiple applications in geographically distributed locations.

PROFESSIONAL SUMMARY

● Overall 4+ years of IT experience in Software Data Analysis, Data Discovery, Data Profiling, Data Modeling, Application Development and Testing supporting various Enterprise applications.

● Extensive experience in different phases of Software Testing Life Cycle, Software Defect Life Cycle and Software Development Life Cycle (SDLC) including Agile Methodology, Waterfall.

● Extensive experience in Understanding, Analyzing and Streamlining Functional Specification, Testing and Reporting Requirements.

● Experience in preparation of functional/technical requirement documents, ETL Source to Target mapping (STTM) documents, functional/technical test cases based on SRS documents.

● Well versed with Test Documentation (Test Plan, Test Scenario, Test Case, Test Data, Defect Report, and Test Metrics).

● Experience in various levels of testing like Smoke Testing, Integration Testing, System Testing, System Integration testing, Functional testing, Regression, Performance Testing and User Acceptance Testing.

● Expertise in Bug Reporting & Tracking Process using tracking tools.

● Demonstrable experience in testing for RDBMS (DB2/Oracle) and BigData (Hadoop/Hive & Google Cloud BigQuery) environments that leverages CI/CD best practices.

● Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend Database Testing. Design Test Scripts using SQL for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.

● Write, execute and troubleshoot SQL queries in any database (SQL Server, Oracle, Teradata)

● Knowledge on Test Automation Tools like QTP and Selenium.

● Good knowledge of Insurance, Finance and Banking domain.

● Coordinated with Project Managers, Development Team, Business Analysts, and End-Users for better quality testing. Worked closely with business team to understand the Requirement Document in creating Test Plan for QA & UAT environments.

● Designed and built Test Cases, developed, maintained and troubleshot Test Scripts, and co- ordinate with team members in debugging effort and assisted developers in Root Cause Analysis and clarified them the results.

● Experience in Regression test of automation scripts within the Data driven Automation framework.

EXPERIENCES

● Worked with Mastek Ltd, Mumbai, India as a Senior Test Engineer.

● Currently working for Sinesoft Business Solutions, USA as a Technical Consultant. Sinesoft Business Solutions, Atlanta

Senior Data Analyst/Test Engineer Jan, 2023 – Feb, 2023

● Lead and guided a small team of 5 members and involved in the requirement/data analysis, ETL processing, reporting and testing.

● Expertise in creating Functional requirement documents and ETL data mapping documents

(Source to Target - STTM).

● Evaluated various sources of information to determine any limitations, in terms of reliability or usability through data profiling activities and helped application team to clean, manipulate and analyze large sets of raw data.

● Created reports and dashboards and other visualizations to convey results leveraging Microsoft Power BI/ Tableau, SQL, ETL Tools (Informatica, Data Fusion) and recommended data-driven solutions to key stakeholders.

● Established KPIs to measure effectiveness of business decisions and/or management dashboards. Created presentations and reports based on recommendations and findings.

● Provided estimates for Hadoop Hive & GCP Data Lake (Big Query) testing. Prepared automation testing scripts, executed the test cases and updated the results.

● Assigning the test cases to team members and tracking it to completion. Involved in the preparing & Maintenance of Planned schedule and Defect log & Test Results review.

● Co-ordination with Function & Technical teams and defining the scope of Testing for each phase and environments (QA/UAT/PROD – Hadoop & GCP). Led efforts in identifying goals, defining scope and deliverables from internal and partner engineering and product teams.

● Drove communication, reporting, and planning; proactively called out risks, opportunities, and dependencies for individual projects, while maintaining a program level view across all projects.

● Worked with partners to build out a new Program Management Organization within the engineering and product side of Split. Developed processes, organizational structures, planning tools and resources, and communication best practices.

● Lead agile sprint planning, refinement, retrospective and coached teams on best practices for agile development.

One Beacon Insurance Company, Boston

Senior Data Analyst/Test Engineer May, 2014 – Jun, 2016

● OneBeacon Insurance Group, Ltd is a property and casualty insurance company in New York. They have provided Renaissance Billing solution product to One Beacon for automobile line of business.

● To lead and guide a small team of 3 members.

● Participated in requirement analysis and contributed to functional specification and ETL source to target mapping documents and application development design reviews etc.

● Involved in the preparation of Test Plan and Schedule based on the requirements.

● Provided estimates for GCP Data Lake (Big Query) testing. Prepared automation testing scripts (SQL), executed test cases (Tidal/Airflow jobs) & updated results.

● Assigning the test cases to team members and tracking it to completion.

● Involved in the preparing & Maintenance of Planned schedule and Defect log & Test Results review.

● Co-ordination with Function & Technical teams and defining the scope of Testing for each phase.

Interboro Insurance Company, NewYork April, 2013 – May, 2014 Senior Test Lead and Business Analyst

● Interboro Insurance company provides personal automobile and homeowners' insurance solutions for UK & USA clients. The products sell through brokers accessing POS, underwriting policy, billing, post claims and used for generating various State regulatory reports.

● Preparation of test cases based on Functional Requirement Specifications and submitted to the Client. Generation of Automation Test Scripts, running Test Scripts and analyzing results using QTP.

● Took the module ownership of the utilities and make sure the quality of the same.

● Involved in validating the Support documents. Logged issues in JIRA and Defect Tracking.

● Involved in various testing phases like Performance testing, Smoke testing and SIT testing.

● Performed Regression testing for various modules and ensured testing been performed with top quality.

Liberty Insurance Company, Boston Mar, 2012 – Apr, 2013 Test Engineer/Data Analyst

● Liberty is a multi-line insurance company offering auto, home, business and life insurance through a network of independent insurance Agents in New York State. Mastek has provided Renaissance billing solution product to Liberty for Automobile and Homeowner line of business.

● Preparation of test cases based on functional specifications.

● Responsible for setting up specific preconditions required during test case execution.

● Execution of Test Cases and updating the results.

● Raising defects and re-testing same after developer’s team installing new patches for resolving defects.

● Reporting to Seniors on Daily progress of test activities. Coordinating with team members for completion of testing.

ACCOMPLISHMENTS

● Received “Spot Recognition” award for Successful System Integration Testing for P&C domain.

● Contributed to project Teams in multiple aspects apart from Software Testing For instance: Ø Enterprise Architecture – Provided valuable recommendations to various solutions. Ø Application Development - Better implementation like optimized storage & I/O cost, HQLs etc.

Ø Business Analysis – Profiling data, structuring Table level rules/Transformations for STTM. Ø Quality Assurance – Enhancing QA’s test cases for better test coverage, add missing test cases.

TECHNICAL SKILLS

OS - Linux, Unix, Windows.

Languages - Java, Shell Scripting, Python.

DB - SQL, PL/SQL, Stored Procedures, Triggers, Cursors, Oracle, Teradata, MYSQL, MS SQL Server, BigQuery, Hive, DB2.

Reporting - Tableau, POWER BI, QlikView

Other Tools – Informatica, Toad, Mainframe, Autosys, Visio, Rally, JIRA, Confluence, Axiom, ePMO, HP ALM, Mercury Quality Center, QTP, Selenium, Rational ClearCase/Quest, GitHub, SubVersion (SVN), Beyond Compare, SharePoint, Notepad++, UltraEdit EDUCATION

● Masters in Data Analytics from Southern New Hampshire University, New Hampshire, USA, 2021.

● Bachelor in Information Technology from Anna University, Tamil Nadu, India, 2009. CERTIFICATION

● Software Testing and Automation Specialization by University of Minnesota on Coursera

● ISTQB Foundation Level Certified professional with 100% score.

● Micro Masters in Analytics by Georgia Institute of Technology on Edx

Contact this candidate