Data Quality, MDM, BI Analyst

4/2015 – 12/2016

Projects:
Taxonomy: Data flow automation from raw excel files to Vertica database using SSIS (ETL Tool). Developed the scripts using SQL for data blending. Connecting Tableau to the database for reporting purpose. Created reports and Dashboards using Tableau for the end users.

Split of HP to HPE & HPI: Designing different databases for HPE and HPI using ER- Studio. Designing different data models to support Vertica Database from SQL Server and Oracle Database.

Roles & Responsibilities:
Work with teams sitting in different parts of the world and interact with them to get the data integrated according to the business requirement.
Validating the automated process and fixing the BUGS in the system.
Enhance the changes required with the existing processes for better and accurate results.
Modeling different data structures and migrating from SQL Server & Oracle databases to Vertica Database.
Validating the financial data with the financial systems and the marketing systems.

Tableau, Microsoft Business Intelligence (BI), Oracle Database, Informatica, SQL, Microsoft SQL-Server (MS SQL), PL/SQL