Objectives

• Seeking Sr. Data Analyst / Data Scientist / Sr. BI Developer experience in interpreting, forecasting and analyzing data for driving business solutions using data insights.
• Masters degree in Mathematics with minor in Statistics. Proficient knowledge in statistical & mathematical technical solutions and analytical processes.
• Excellent understanding of business operations and analytics tools using SQL, SAS Programming, R, Python, QlikView, Tableau, Excel, SAP HANA, IBM SPSS & SAS data extraction tools for effective analysis of data.

SUMMARY

• Overall 8+ years of experience; 4 years of experience in HealthCare, 3 years of experience in Sales and Manufacturing and 2 years of experience in Utilities products analysis.
• Excellent Skills in QlikView and Tableau Visualizations and Dashboards / Story Modes.
• Excellent Skills in R, SQL & SAS. Proficient in data extraction, data cleaning, data transformation, analysis of categorical and numerical variables, and creating statistical linear / multilinear regression models based on response variables, finding multicollinearity, and Causation.
• Proficient in MS Excel using Macros, Pivot Tables, Contingency Tables, Histograms, and Scatter Diagrams.
• Excellent skills in IBM SPSS to analyze categorical data and patterns.
• Great understanding in delivering Business Intelligence and data warehouse solution
• Ability to learn quickly and define BI strategy and roadmap to solve performance management issues
• Outstanding written and verbal communication skills
• Excellent problem solving and organizational skills

TECHNICAL SKILLS

• SQL (DML / DDL)
• Forecasting in R
• Python
• Tableau 9
• Tableau 10
• Tableau 2019.1
• SAS Visual Analytics
• SAS Data Explorer
• SAS Data Viewer
• SAS Data Designer
• SAS Report builder
• Windows Server Platform
• Statistical Computing Methods
• Regression Analysis
• Data Mining
• MS Word
• MS Excel
• MS SQL Server
• Pivot Tables
• Business Data Processing
• SAP Hana
• MS SharePoint
• QlikView
• Perl

PROFESSIONAL EXPERIENCE

Confidential, Cary, North Carolina

IT Data Analyst II

Responsibilities:

• Enhance product sales dashboards, pipeline analysis, forecasting in R (using both statistical linear and regression models) and book of business reporting with visualization to reshape the view and unlock insights that lead to new actions. My mathematics background rally helped on statistics arena in this project. Heavily used SQL Complex Queries with many JOINS, VIEWS, INDEXES, PROCEDURES to pull data across different Datawarehouse/EDW tables and optimized the performance for frequent use of data by many departments.
• For company’s largest sales department, developed and trained Forecasting Models in SAS and then presented through Tableau for Confidential future offering to customers. Also, presented results in form of presentation to 100+ staff division and answered their inquiries appropriately. This effort TEMPhas been very much appreciated by VP Product Sales in Confidential .
• Responsible to create, execute and maintain Reports in Excel using inline Perl & PowerShell automation scripts to upload to MS SharePoint.
• Responsible for creating QlikView Dashboards based on business needs.
• Assist in soliciting new technologies in optimization of current IT infrastructure.
• Used SAP Hana / SQL extensively to generate reports in Perl.
• Supported Sales targets with cohort analysis, helped product managers to look at all sales holistically to make informed decisions.
• Work with the IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions for internal and external use
• Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed to track and improve order worldwide shipment KPI by 5% within a quarter.
• Deployed over 10 Dashboard Stories and analytics projects for many departments using Tableau 2019.x within last 6 months. Received many appreciations from top management (VPs) for fast and accurate results for insights.
• Created, gathered and analyzed data dashboards from SAP HANA, ICS, and IBM DB2.
• Implement process improvements (Automation, Performance tuning, Optimize workflows)
• Assists with the development of the forecasting data model(s) for the data warehouse in R language. Provides recommendations for all data strategies and out of scope processes.

Confidential, Raleigh, North Carolina

Data Analyst

Responsibilities:

• Involved in data analysis of 12 different county locations’ usage of electricity in different households. This dataset contains millions of records.
• Different dimension of analysis included Community Solar projects, Utility Scale Solar Projects, Microgrid and Storage Projects and Energy Efficient Projects.
• Explored the trends in SAS for distributed energy resources, including community solar farms and batter storage.
• Satisfaction Surveys Analysis for all North Carolina and National Electric Cooperatives.

Confidential

Principal Data Analyst

Responsibilities:

• Worked for 3 years on CoagClinic and CholestrolClinic for Patients who suffered Cardiac problems. These projects involved working on backend in SQL Server and looking at different Patient Conditions and procedure codes and define Coumadin dosage.
• Worked on many data analytics projects especially related with CPT, ICD9 and claims extracts in different formats X.12/837/835.
• Leads daily operations of other members of the data team, delegating responsibility for troubleshooting customers' problems
• Singlehandedly created original Excel, VBA, and SQL scripts that automated the conversion for various competitor software, speeding up processing by from 7 - 10 days to 1-2 days
• The first employee in the company with the skills to convert data from several atypical or proprietary databases
• Oversees training for new and existing staff, which includes teaching advanced data extraction, analysis and formatting, also assessing the competition's practices to ensure we remain competitive
• Converts raw existing merchant data for new customers into our standard .csv format from SQL databases and other file formats
• Analyzes competitors' raw data to see wat we can learn and apply to improve our productivity and processes
• Improved complex backend SQL scripts so that data reporting could be read easily and quickly by merchants
• Wrote scripts to help merchants query their own databases, allowing them to gain unprecedented insight into their market, practices and sales trends

Environment: MS Excel, MS Access, SQL Server, My SQL, SAS Programming