MI & DATA ANALYTICS UPGRADE focus on supporting the upgrade of the current MI capabilities, maintenance and enhancement of existing data environment, data interfaces and extraction of data for MI reporting solutions.

• 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.

CPR Project involves Extraction of data from various source systems, Transformation and Loading to Netezza DB Data Mart and Report generation in OBIEE. This enables an accurate and systematic way of reporting and analyzing revenue from a Customer-Relationship perspective.