•    Responsible for providing automated and self-service reporting solutions; and developing data visualizations for business users using MS Excel, MS Access, VBA and Power BI.
•    Ensure data quality by writing and executing procedures for cross checking totals and identifying data anomalies.
•    Develop triggers and stored procedures to manipulate data
•    Clean, transform and model data to ensure and improve accuracy of metrics calculations
•    Create, modify and troubleshoot SQL queries, stored procedures and jobs
•    Manage and co-ordinate the production and delivery of scheduled reporting to business stakeholders on a daily, monthly and yearly basis.

•    Data Sub-Setting, Data Masking, Data Generation, Data Archiving and Data Refresh
•    Provide complete Test Data Management solutions to derive data patterns and relations.
•    Design Database repository to capture Meta data of various test data and message structures from producer and consumer systems.
•    Develop Rules engine to capture rules specific to each data elements and attributes.
•    Create the Test Data Management approach/methodology documents as per request.
•    Metrics reporting to stakeholders through Operational reports and Tableau Dashboards. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information. 
 

•    Understanding and gathering the client requirements.
•    Design, develop, automates, and supports complex applications to extract, transform, and load data.
•    Develop Power Center Workflows and Sessions, and also sets up Power Exchange connections to database and mainframe files
•    Develop scripts to automate the execution of ETL using shell scripts under UNIX environment.
•    Extensive Data Validation-Data Quality checks, Data Integrity checks, Data Completeness checks and Data correctness checks covering different scenarios.
•    Design and Execute complex SQL queries according to test conditions to support unit testing and System testing.
•    Test case management in HP ALM. Including, Defect tracking and retesting.
•    Providing routine process/operational control reports in Advanced Excel by using pivot tables and VLOOKUP.
•    Responsible for preparation and review of testing artifacts such as Test Strategy, Test Plan, Requirement Traceability Matrix, Test Cases, and Defect Tracker.