Download Resume Download Transcript

Summary

MIS Graduate with 2.5 years of experience in the field of information Technology. Comprehensive background in Data Analytics and Visualization, IT Consulting, Business Intelligence, Operations, Statistical Analysis, Financial Planning and Reporting. Currently seeking full-time opportunities in Data Analytics/Consulting starting December 2019.

Education

MS in Management Information Systems, University at Illinois at Chicago, GPA: 4.0/4.0, December 2019

• Coursework: Data Mining for Business, Applied Consulting, Business Data Visualization using Tableau, Advance Database Management, Enterprise Application Development, Systems Analysis and Design, Statistics for Management,Information System Strategy and Policy

B.Tech in Information Technology, JIIT (India), GPA: 3.7/4, May 2015

• Coursework: Machine Learning and Big Data Analytics, Database Systems, Data Mining, Information Systems, Web Analytics, Software Engineering

Technical Skills

Programming Languages & Databases

R, Python, SQL, HTML, CSS, JavaScript, Angular JS, JSON, SQL Server, SAP HANA, Oracle Server, Tableau Server

Tools

Tableau, R Studio, Microsoft Power BI, MS Excel, Rapid Miner, Automation Anywhere, SPSS, Google Analytics, SAS Studio, JIRA, HP Quality Center

Libraries and Packages

dplyr, tidyr, lubridate, caret, car, glmnet, randomForest, NumPy, Pandas, Matlplotlib, Scikit-learn, Seaborn, Keras, OpenCV, TensorFlow

Statistics

Data Wrangling, Exploratory Data Analysis, Hypothesis Testing, ANOVA, Descriptive Statistics, Probability Distribution, Sample Distribution

Machine Learning

Predictive Modeling using Classification, Logistic/Linear Regression, Clustering, Decision Trees, Random Forest, Association Rule Mining, Naive Bayes, K-Nearest Neighbors, Recommendation Systems, Support Vector Machines

Methodologies and Business Processes

Robotic Process Automation, Project Management, Process Improvement, Agile and Waterfall SDLC, Technical/Functional Documentation

Work Experience

• Developed and published dashboards on tableau server for visualizing Tier Room KPIs such as CaseFill, Schedule compliance and 15 others for 40+ different manufacturing plants at Pactiv across North America
• Blended data from HANA, SQL and Oracle data sources to streamline the ETL process, reducing load on tableau servers by 25%
• Created a robotic process for automating the invoice/BOL generation process for audit using RPA, lowering process time by 40%
• Provided operational insight by working cross-functionally with the operations and supply chain teams for extracting, loading and processing data using HANA and SQL servers

• Designed individual Client Schemas and Developed healthcare modules using Angular JS and Java for Clients such as Ford, Michelin and Verizon for managing DB, DC and HW data for its employees. Estimated task in Story and then tracked those tasks using hours in JIRA
• Devised Rapid M solution to automate data management process for each enrollment period, reducing manual processes by 20%
• Integrated Google Analytics on existing modules, reducing time to market individual client portals
• Interacted with clients to gather business requirements, modelled them into user stories and negotiated sprint plan for structured delivery process
• Responsible for replicating, researching, performing root cause analysis and providing solution to the data issues reported by clients
• Developed workflows using SharePoint InfoPath for early completion and notification of QA and PROD fixes, reducing time delays by 7-8%

• Involved in the prototyping, testing, requirement gathering, documentation and optimization of invoice application system
• Designed visualization to display revenue reports and product purchases for CVS pharmacies
• Involved in the documentation, prototyping, testing and optimization of Caremark invoice application system

Academic Projects

• Extracted social media data of top 10 Chicago area hospitals and performed content analysis to asses their marketing strategies
• Developed digital reports based on the usage of social media handles and implemented regression and vector scale model to analyze the trends for hospital’s Social media marketing using various analysis metrics.

Utilized: R studio, Tableau, Python and Excel

• Utilized Bureau of Transportation Statistics airline data set to prepare delay metrics that describe Delta Airlines On-time Performance
• Implemented Stories, Interactive Dashboards, Route Maps, LOD Expression for competitive analysis and operational insights
• Created network maps and recommended profitable routes for Delta Airlines for its business expansion and opportunity identification

Utilized: Tableau, Business Statistics, Advance MS Excel

• Extracted, cleaned and transformed the unstructured course data to structured data, enabling a wider understanding of customer reviews on price of a course at Udemy.
• Performed univariate/bivariate analysis, Hypothesis testing and Linear Regression to obtain segmented results for each course category

Utilized: R, Regressing Modelling, Machine Learning, Advance Statistics, Tableau

• Scrapped and Extracted information from a UK based E commerce website for statistical analysis of the product prices and its specifications.
• Developed hypothesis for brand value and performed linear and logistic regression on product data, used PCA for factor analysis.

Utilized: R studio, Tableau, MS Excel, Dimensionality Reduction

• Cleaned and analyzed 2 million data records for security breaches in financial sector and created dashboards for digital reporting
• • Forecasted number of breaches in future years and used clustering to identify breaches which resulted in losses greater than 5M

Utilized:Tableau, Excel, SAS

• Analyzed the volume/content on social media by competitors and recommended strategies, increasing engagement rate by 50%
• Implemented operational strategies to improve the value proposition of online stores in designer industry

Utilized:Tableau, Customer Segmentation, Catalogue Comparison