Data Analyst

? Planning, scoping, and building company-wide Microsoft Azure data warehouse (DWH) that will house all the company's new and legacy data systems using automated data pipelines.
? Performed ETL source-to-target mapping for company's source systems (Healthcare, HRIS & Salesforce Systems)
to target (Azure Data Warehouse).
? Validated the data integrity from source systems pulled into the DWH in the staging environment.
? Created views in SQL by combining the different dimension and fact tables in DWH. Connected Tableau to the SQL views for BI reporting purposes.
? Met key stakeholders [Regional Directors (RDs) & Regional Vice-Presidents (RVPs)] and the executive team to understand their reporting requirements and to determine KPIs.
? Created insightful Tableau dashboards with compelling visualizations based on reporting requirements and enabled the stakeholders to make data driven decisions with the best interests of the organization in mind.
? Implemented row level dynamic security on Tableau dashboards using company's Active Directory to restrict
access to the dashboards based on job roles.
? Trained end users to enable them to be self-sufficient in their use of Tableau reporting software.
Achievements -
? Serving as the sole Tableau dashboard designer and developer. Deployed suite of Tableau dashboards on tableau
server to support 120+ facilities reporting needs that improved their operational, clinical, HR and compliance
efficiency.
? Serving as the tableau server administrator. Responsibilities include security for the dashboards, scheduling and monitoring daily extract refresh jobs and user account maintenance.

Consulted top management of a $33B telecom giant to provide strategic overview by a business
analytics program for procurement activities.
? Analyzed indirect spends of a $200 M pharmaceutical company, recommending savings worth
approximately $5M.
? Analyzed utility bills from Cass software against weather data for anomalies and presented findings worth $1.3M
for the Energy and Utilities department of the telecom giant.

Jr. Sourcing Analyst

Drafted a 22-question survey to collect information on the purchasing pattern and the demographics of people
who take supplements for a dietary supplement company called pHAlo.
? Collected 450 surveys by visiting numerous doctor clinics in Dallas area.
? Analyzed the data from the surveys and provided insights and recommendations by building interactive Tableau
dashboards and Excel Reports using XL Data Analyst that helped pHAlo to make key business decisions.

Market Research Analyst

Find out detailed information about Gautham Vinod, Data Analyst 

Gautham Vinod: Data Analyst

Gautham Vinod

Pinnacle Treatment Centers, Inc

Right Sourcing Solutions Ltd

pHAlo

The University of Texas at Dallas

Manipal Institute of Technology