Resume for Data Analytics
no image
Resume for Data Analytics

Mayank Khare
------------/in/mayankhare
Atlanta, GA | ------------ | ------------
Summary
Data enthusiast with three years of professional experience as a Technical Analyst to designing complex software systems Delivered project based on Client-Server architecture using Oracle 11g, PL/SQL and Tableau. Achieved Ace Award at Accenture Inc. for developing optimized solution by increasing processing efficiency by 20%

Education
Pursuing Master of Science in Analytics from Robinson college of Business (GSU, Atlanta) Aug2018-Dec2019
• Courses: Statistics, Data Programming, Machine learning, Unstructured data, Database Management
Rajiv Gandhi Technical University, Bhopal, India Aug2010-June2014
Bachelor of Engineering (Computer Science Engineering) GPA of 3.3/4

Technical Skills
Analytical Techniques: Regression, Classification, Data Mining, Decision Tree, PCA, Time Series Forecasting
• Programming Languages: Python- NumPy Pandas, R, Statistics, UNIX Shell Scripting
• Query Languages: SQL, Procedural level SQL, MS-SQL, Mongo DB
• Tools: R Studio, Jupiter, Tableau, TOAD for Oracle, Oracle PL/SQL developer, Spyder, MS Excel(Advance)
• Other Skills: Web Scraping, Google Analytics, MS PowerPoint
Academic Project:
Sprint Project: Market analysis Aug2018-Dec2018
• Define business need of the client detailed specification and soliciting data through various sources.
• Work on the data extraction using Web scraping. Data cleaning and pre-processing to achieve relevant dataset
• Use of Topic modelling(LDA), Bag of Words, Sentiment analysis techniques for performing text analytics
• Preparing data visualization using stories, dashboards using Tableau and with predefined libraries in Python
• Future scope: building a model which takes a Facebook post as a raw data and returns an analysis before making the post public based on previous sentiment analysis.
Self-Project: Sentiment Analysis on Amazon Product Reviews Aug2018-Dec2018
Parsing and cleaning phone reviews using NLTK package and further classified them into positive and negative sentiments on the scale of [-1 to 1] using Bag of Words models to gauge consumers opinions and emotions expressed within an online mention as well as dealing with sarcasms.
Professional Experience:
Project: Analytics - Provider Enterprise Analytics (PEA) Experience: 1 year 5 months
Role: DB & Tableau developer
• Documented technical requirements in collaboration with Customer and Business Development team
• Developed the DB schema and built complex queries to determine employee efficiency factor for payroll calculations and annual package revisions
• Established the logic over employee performance dataset by building Views, packages and Stored Procedures
• Designed Dashboards and Summary Views with multi-level user interactivity on Tableau
Project: EFH Experience: 1 year 11 months
Role: Development Analyst
• Created and modified UNIX shell Scripts to control operational job runs for Financial transactions
• Developed Stored Procedures to provide efficient solution for data manipulation activities
• Effectively utilized concepts of Indexes, cursors, views, synonyms, Materialized Views for faster batch processing across the system
• Resolved high priority issues with turnaround time of 24 hours during project maintenance phase
Certifications:
• BCS-ISEB Business Analyst Foundation
• Utility_L1 industrial certificate