Candidates About

Summary

·         Expertise in applying data science frameworks in sales, marketing, operations domains and development of statistical and machine learning models in Python.

·         Experience in extracting raw data from structured and unstructured data sources, transforming it using Python, R, SQL, regular expressions, and loading into an enterprise data warehouse (Extract-Transform-Load).

·         Wide array of experiences in interpreting and analyzing data using statistical techniques and systems.

·         Hands-on experience in data design and analysis using Machine Learning frameworks and algorithms.

·         Strong understanding of CRM databases/systems, to query and analyze customer data.

·         Experience with Google Analytics, Tableau, MS Excel, MS Access and SQL Server Reporting Services (SSRS).

·         Extensive experience in in-depth data analysis on different databases and structures.

·         Strong knowledge in writing advanced SQL queries, sub-queries, and joins.

·         Experience in designing stunning visualizations using Tableau, MicroStrategy, Spotfire, D3.js and publishing and presenting dashboards on web and desktop platforms.

Education

Masters in Industrial engineering | may 2017 | University of houston | GPA- 3.3

·         Relevant Course work: Probability & Statistics, Statistical Process Control, Enterprise Operations and Business Intelligence, Management in Information Systems, Advanced Linear Optimization.

bachelor of technology in mechanical engineering | may 2015 | jntuk | GPA- 3.5

Skills & Abilities

Experience

Python Developer | At&T | feb 2018 – april 2018

·         Evaluated data for distribution, classification and correlation.

·         Developed a Python tool that automates the manual conversion of specification file to Cloudify Blueprint.

·         Designed and developed interactive dashboards from real-time data using Tableau.

·         Performed Statistical Data validation using Python to ensure accuracy of findings.

·         Conducted sales and business analysis using multiple tools: Excel, Python and Tableau.

·         Developed reports with complex formulas/equations using Excel, Access and Tableau.

·         Clearly and effectively presented information to internal stakeholders.

·         Worked with Reporting team and created the required data visualization dash boards on Tableau with all the required filters. 

·         Working closely with internal clients in accumulating the metric definitions, data visualization requirements to design a dynamic process.

WORKFORCE analyst | sodexo | jun 2017 – jan 2018

·         The project consisted of three stages:

1) Initial workforce analysis and providing recommendations to improve productivity,

2) Conducting data analytics on labor metrics, and identifying critical issues like excessive overtime, absenteeism, ineffective scheduling, and improving efficient temp labor utilization,

3) Developing an on-demand Business Intelligence dashboard for visibility into cost and performance metrics, monitoring KPIs in MicroStrategy and Tableau.

Responsibilities:

·         Analyzed workforce data for 10,000 cost-centers and developed predictive linear regression model in Python with Scikit-learn to estimate labor utilization and expected annual labor costs per cost-center.

·         Developed Extract-Transform-Load program in Python to extract employee data from different data sources (MS SQL Server, Kronos, MS Access), completed denormalization and aggregation of data for subsequent statistical analysis.

·         Developed BI dashboard in MicroStrategy for real-time KPI monitoring: Overtime hours, scheduling effectiveness, clock punch %, absenteeism and accidental overtime.

·         Applied linear regression in Python to understand the relationship between different attributes of dataset and causal relationship between them, applied Ridge, Lasso regressions with L1 regularization and identified statistically significant factors influencing overtime.

·         Designed custom reports, charts, tables and data visualization dashboards using Tableau for business development teams to support decision-making process.

·         Involved in translating the business requirements into Data requirements mainly focusing on reducing temp labor costs by detail analysis on labor scheduling.

·         Created customized AD-HOC reports and processes for analysis purpose.

Projects | University of Houston | jan 2016 – may 2017

Advanced Linear Optimization

        Developed a model to maximize revenue for 36 product varieties that are manufactured at three different locations. Laid out a production and transportation plan that minimizes production costs and transportation costs using advanced Linear Optimization techniques (Microsoft Excel and Python)

`

ILLIUM INC. TRANSACTIONAL DATA ANALYSIS

·         Conducted Investigative analysis on the mass transaction data of Ilium Inc. used TIBCO-Spotfire & Python to identify root-causes for key problems.

·         Performed regression analysis to find the correlation between several KPI’s (factory efficiencies, lot sizes, etc.) and product costs.

·         Designed an interactive dashboard in Spotfire, that tracks products with most delivery issues, and calculate overall CSI (customer satisfaction Index) for selected region of focus.

STATISTICAL PROCESS CONTROL

·         Historical output power data of solar cells is analyzed to improve the process capability of the Manufacturing Plant.

·         Data Collection – Responsible for establishing the correct data exchange system by manual tables (Microsoft Excel, Access, Minitab). 

·         Responsible to review analysis in the forms of, but not limited to, Histograms, Pareto Charts, Time Series Trend Line, Statistical Process Control Charts, ANOVA, Six Sigma Score and Rates and Means.

·         Created Access database and built a dashboard in Tableau, as a temporary solution, to continuously monitor the control charts and the quality scores when new data is appended to database tables.

·         Improved process capability by 35% for a solar cell manufacturing plant by identifying and recommending corrective actions for the possible reasons for out of control outputs from the solar module.

SAP-ERP SIMULATION

·         Hands on experience on SAP predictive Analytics; created regression models, and conducted Hypothesis testing on forecasting the sales and production requirements for a Cereal company with 12 product varieties.

·         Co-ordinated with cross-functional team to plan, execute and strategically implement the decisions by observing key performance indicators from historical analysis.

·         Team was awarded 1^st place for methodology and 2^nd based on final revenue score.

junior Data Analyst | Vikas Technologies | jan 2015 – Dec 2015

·         Responsible for various daily reporting assignments summarizing sales activity for several business 
units. 

·         Responsible for data aggregation, data pre-processing, missing value imputation and descriptive and inferential analysis.

·         Used SQL, Minitab, MS Access and Excel for creating summaries, running summary statistics and result tables.

·         Created and presented impactful Tableau Dashboards and Excel visualizations to team members and clients to improve system efficiencies and reduce total expenses.

·         Participated in team projects and brainstorming sessions to assess various methodologies for study designs.

·         Communicated with technical and non-technical end users, providing clear explanation of procedures used and results obtained from data analysis tasks.