GV

Gautham Vinod

Data Analyst · Pinnacle Treatment Centers, Inc

Durham, NC

In My Own Words

I’m Gautham Vinod, a Fall 2018 Master’s graduate in Business Analytics from University of Texas of Dallas. Business inclined professional with specialization in Marketing Analytics. Highly skilled in using analytical tools and knowledge of statistical methodologies to arrive at data-driven solutions for challenging business problems. Accumulated 8 months of valuable experience as a Business Analyst over the course of 2 Internships at pHalo and Right Sourcing Solutions Ltd. here in the US.

Specialties: Machine Learning, Predictive Modeling, Statistical Modeling, Regression, Logistic Regression, Clustering, Decision Trees, Market Basket Analysis, Principal Component Analysis, R, SQL, Tableau, Python, SAS, Advanced Microsoft Excel.

Contact: 214-507-0479 | gautham.vinod@gmail.com

Work Experience

Data Analyst

Pinnacle Treatment Centers, Inc

2019 – Present

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

Jr. Sourcing Analyst

Right Sourcing Solutions Ltd

2018 – 2018

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.

Market Research Analyst

pHAlo

2018 – 2018

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.

Education

M.S.

The University of Texas at Dallas

2018

M.S.

B.Tech.

Manipal Institute of Technology

2016

B.Tech.