Siddhartha (Sid) Shankar

Dallas, TX ***** 469-***-**** adgwm7@r.postjobfree.com

www.linkedin.com/in/siddhartha-shankar https://public.tableau.com/profile/sid.business#!/ SUMMARY

Result-driven professional with 5+ years of Data Analyst and Business Intelligence Engineer experience, working collaboratively with business users and senior-level management to determine information needs and effective delivery methods across Construction, Oil and Gas, Operations, Manufacturing, IT and Supply Chain domains with M.S. in Business Analytics. Having hands-on experience using Reporting and Business Intelligence Solutions (Metrics, Reports, and Dashboards), SQL, SAP ( BusinessObjects, Crystal Reports), Data Integration, Python, ETL Pipelines, Data Mining, Statistical modeling, Machine learning and Visualization techniques. Seeking a Business Intelligence Engineer role with a drive to enable data-driven solutions that would help businesses gain a competitive edge. TECHNICAL SKILLS

Certification: Alteryx, Google Analytics (IQ), Tableau Desktop Associate (In Progress), AWS Cloud Practitioner(In Progress) Languages: Python, R, SQL, SAS, SQL, NoSQL

Python Libraries: Pandas, Numpy, Scikit Learn, Statsmodels, Tensorflow, Keras, matplotlib, NLTK, genism, seaborn Databases: MySQL, SQL Server, Oracle RDBMS, PostgreSQL, MongoDB (NoSQL Database) Visualization: Tableau, PowerBI, QlikSense, SAP (Crystal Reports, Lumira), AWS QuickSight, Adobe Analytics Statistical Techniques: Hypothesis Testing, A/B Testing, Panel data, 2SLS method, (Time Series, Conjoint, Survival, Factor, Cluster) Analysis, Natural Language Processing, Linear and Integer Optimization Machine Learning: Regression, Classification, SVM, PCA, KNN, Clustering, Ensemble methods, NLP(Topic Modeling, LDA) Data Engineering: Data Marts, Enterprise Data Warehouse, Data Pipelines, SQL Scripts, ETL, Star Schema Cloud Tools: AWS Cloud services (EC2, SageMaker, S3, EMR, RedShift, Athena) Web Analytics : Adobe Analytics (Omniture), Google Analytics SAP : SAP BusinessObjects, SAP (Web I, Predictive Analytics, Crystal Reports, Dashboard, Lumira) Big Data Tools: Apache Spark, HDFS, Scala, MapReduce BUSINESS EXPERIENCE

Child Poverty Action Lab (CPAL), Dallas, Texas Jan. 2020 – May 2020 Business Intelligence Developer (Practicum)

• Designed python scripts to scrape census tract-level data from the US Census website for data mapping and profiling with high school educational data

• Ensured data quality, identifying and eliminating inaccuracies and duplicates using SQL and Excel

• Calculated education index for four counties nearby Dallas, assigning weights based on the correlation and regression coefficients and plotting on the geographical map using Tableau Reliance Industries Limited, Gujarat, India Jan. 2014 – Jan. 2018 Business Intelligence Engineer (Operations)

• Analyzed past data using data mining techniques to estimate the scope of work, bill of quantities, budget and project-duration using SQL, Excel, Tableau and SAP BOBJ, producing ‘Paraxylene’ 11% globally

• Implemented customized ETL pipelines from diverse sources for higher data availability and to create a unified view of quality data for analytics and reporting leveraging Big Data Tools and Enterprise Data warehouse

• Initiated and led the development of operations analytics department, standardizing operation procedures and training 4 teams of 25 members, reducing operation timeframe by 16%

• Designed, experimented and Conducted hazard analysis on research findings to evaluate lifetime value of paraxylene plant using SAS and presented to business leaders and investors, boosting investments by 17%

• Transformed data to build quality reports/dashboards in Tableau and SAP crystal reports, publishing progress reports, briefing 5 teams and management to manage a $40B project using Six Sigma methodology

• Developed ad-hoc reports using SQL, automated reports using macros and VBAs in excel, achieving 25% efficiency by reducing manual cleaning and structuring of data

• Monitored KPIs for large scale logistics of outsourcing components using interactive Tableau dashboards to minimize work-front constraints

• Defined frequently asked questions (FAQs) based on customer chat logs using Latent Dirichlet Allocations (LDA) for topic modeling

• Defined digital services metrics (KPIs) for Reliance JIO telecommunication to evaluate market expectancy

• Optimized resources using Excel-solver, assessing timelines to identify and prioritize sequential/ critical activities using Primavera, contributing to $4.6B net annual profit

• Managed the development and enhancement of reporting solutions using Agile development methodologies Larsen and Toubro Ltd., Uttar Pradesh, India Nov. 2013 – Dec. 2013 Planning and Scheduling Engineer

• Examined client’s business requirements and collaborated with cross-functional teams in Agile flow

• Planned and allocated resources for piping fabrication as per material availability and erection priority

• Monitored the project progress and published daily, weekly and monthly planning reports Petron Engineering Construction Ltd., Chhattisgarh, India July 2012 – Oct. 2013 Graduate Trainee Engineer

• Migrated data from multiple excel backend data to SQL database and supported ad-hoc requests by extracting data using MySQL workbench

• Determined factors affecting progress and allocated optimum resources using Excel (linear regression, solver)

• Designed VBAs and Macros in excel for automating reports, optimizing cost and time ACADEMIC PROJECTS

Sales Forecast for an E-Commerce Company (R, MySQL, Tableau)

• Performed data cleaning in R by deleting duplicate records, updating the missing values with Null, removed special characters, and formulated a database design normalized to 3NF

• Imported the cleaned data into MySQL database for predicting revenue, forecasting sales and designing report components of demographical data using Tableau

Consumer behavior perception using text mining on Amazon Fine Food Reviews ( Hadoop, Pyspark, Tableau)

• Worked on text mining using Big Data modeling techniques to classify half million reviews of customers to understand consumer behavior

• Analyzed product performance trend by creating dashboards in Tableau Predicting the factors affecting the success of a campaign & whether the client will subscribe a term deposit(Python)

• Implemented supervised learning models to come up with the best classification model based on low FPR at TPR

= 0.99, AUC and achieved an accuracy of 93% with Random Forest Classifier

• Experimented for optimal parameters for different machine learning techniques to determine best classification model and significant features responsible for subscription of a term deposit Predictive Marketing Analytics - Procter & Gamble -Oral-B Sales Dataset - Using SAS, Data Analysis, RFM, Statistics

• Analyzed the US store level and Household level data on Toothbrush products to boost the Sales and Market shares of Oral-B.

• Studied the effect of different types of promotions, displays and price reduction flag on the sales.

• Devised customer segmentation to recommend strategies for valuables customer segments using RFM model. EDUCATION

The University of Texas at Dallas, Dallas, Texas May 2020 M.S., Business Analytics (Concentration on Data Science) GPA: 3.8/4.0

(2018 Dean's Excellence Scholarship)

Dr. M.G.R. University, Chennai, India May 2012

Bachelor of Technology in Mechanical Engineering GPA: 3.7/ 4.0