Business Data Analyst

Chinmay Jain 972-***-****

***************@*****.***

www.linkedin.com/in/chinmayjain91

SUMMARY

• Business Data Analyst with 3+ years of experience in interpreting and analyzing data to develop solutions and drive business growth. Proficient knowledge of Econometrics, Statistics and Data Analytics

• Strong knowledge of database management systems utilizing complex SQL queries, stored procedures, database tuning, query optimization and resolving performance issues

• Skilled in Statistical Analysis and inference using Hypothesis testing and Machine Learning algorithms with R and SAS

(Linear Regression, Logistic Regression, Random Forest, Decision Trees, Neural Networks, SVM, K-Means Clustering, PCA)

• Proficient in advanced Excel to extract the significance from datasets with pivot tables, VLOOKUP, Power Query and other Excel functions and in designing dynamic dashboards using Tableau and Power BI

• Experienced in Data Analysis, Reporting, Project Management, Requirement Gathering and Analysis, Quality Assurance and in implementing SDLC, STLC and Agile methodologies

EXPERIENCE

Business Data Analyst Tata Consultancy Services Jul 2013 - Jul 2016 Client - Thomson Reuters

• Managed implementation of SAP Finance modules and outlined requirements for ad-hoc reporting and data analysis

• Defined and built executive-level financial reports and dashboards for real-time insights to business stakeholders

• Utilized SQL and R for data extraction and analysis and developed ‘Quality Index’ to track project’s performance

• Predicted price for procuring products and services using regression analysis and reduced overspending by 10%

• Enhanced procurement, billing and project management systems by redesigning procedures and resolving issues

• Performed quality assurance, system integration and user acceptance testing facilitating on-time and on-budget implementations of enterprise applications for up to 10,000 global users

• Collaborated with stakeholder groups and cross-functional teams to resolve data issues, investigated system anomalies and ensure business and technology alignment

• Led a team of 5 in creating test strategy for SAP enhancements and achieved 92% defect detection Environment: R Studio, MS SQL, MS Excel, Tableau, SAP FICO (AP, GL, AM, SRM, PMDM), JIRA, HP QC, System 170 Business Intelligence Intern Apsidata Solutions Feb 2013 - Apr 2013 Client - Dish TV

• Predicted credit limit of customers for cable TV company to minimize payment defaults and reduced losses by 12%

• Conducted descriptive data analysis by plotting outliers, imputing missing values and covariance using ggplot in R

• Analyzed subscriber data using logistic regression to improve services and reduced churn by 15%

• Presented insights on ad network channels to restructure packages to increase sales and revenue Environment: R Studio, SAS, MS Excel, Tableau

TECHNICAL SKILLS

• Statistical Tool: R, SAS, Python, STATA, Advanced MS Excel

• Reporting Tools: Tableau, Power BI, QlikView, MicroStrategy

• DBMS: MySQL, MS SQL Server, Oracle 10g, MS Access, MS Visio, Erwin Data Modeler, Visual Paradigm

• ETL Tools: SAP Business Objects, Amazon Redshift, SSIS, SSAS, Informatica, Alteryx

• Big Data Analytics: UNIX, Hadoop, MapReduce, Hive, Sqoop, Flume, Pig

• Programming: SQL, VB Script, C++, Java

EDUCATION

M.S., Information Technology and Management University of Texas, Dallas, GPA 3.75 Aug 2016 - May 2018 B. Tech., Electronics and Communication SRM University, India, GPA 3.4 Aug 2009 - May 2013 INDEPENDENT CASE STUDIES

Marketing Analytics – Jo-Ann Fabrics using SAS

• Proposed strategy using marketing communication and product data to increase revenue

• Performed segmentation analysis using K-means clustering to define potential target segments

• Analyzed impact of price and communication channels, such as email, SMS on each segment using price Media Mix Modelling Marketing predictive analytics using SAS – VCA Animal hospitals

• Accomplished data cleaning, data pre-processing and clustering on the data provided by veterinary hospital

• Implemented statistical analysis including linear regression, Segmentation and Panel Data Analysis

• Recommended business strategies for potential segments and defined financial implications using price elasticity Business strategy for American restaurant chain using SAS, Tableau, MySQL

• Applied predictive modeling techniques like market basket analysis and elasticity modeling to analyze the impact of price change and other factors on revenue

• Expanded the purchase portfolio to improve revenue from current customers

• Proposed Test and Learn plan to analyze monthly revenue based on the recommendations ACADEMIC PROJECTS

Dashboard design and visualization using Tableau and R - Belfoods, Indonesia

• Created interactive dashboards and reports to analyze the market standing and areas for improvement

• Performed R integration to understand the customer behavior for predicting marketing outcomes

• Evaluated the product demands of competitor brands across Indonesia for product commercialization Dimensional modeling, reporting and data analysis - Airbnb.com

• Developed data warehouse from a relational database and performed dimensional modeling using CA Erwin

• Designed dashboards and reports to build strategies using SAP Information Design Tool and SAP Web Intelligence Statistical Analysis of UN human development indices using Advanced Excel

• Explored factors affecting HDI across continents using box plots, outlier analysis, and covariance

• Compared countries on human development using histograms, scattered plots, correlation plots and bar graphs Database design and implementation of a hospital using MS Access and MS SQL Server

• Designed user input forms with validation checks, summary reports, and sub-reports using MS Access

• Enhanced and updated the existing SQL server database and connected it to MS Access to store data System Analysis and Project Management - Home cleaning and repair service

• Proposed a new system to book house cleaning and repair service and performed system analysis

• Designed structural and behavioral UML diagrams: Class, Package, Use case, Activity, Object and Sequence diagrams

• Designed and implemented ER Model and Data Model using MS Visio and MS Access

• Built a working website and mobile app with the required features for the customer using Agile methodology CERTIFICATIONS

• Analyzing and Visualizing Data with Power BI

• Tableau 10 for Data Scientists

• Hands-on with Amazon Redshift

• Introduction to Data Analysis Using Excel

• Scrum Agile for Business Analysts

• Data Science and Machine Learning with R

• The Ultimate MySQL Bootcamp

• Python for Data Science and Machine Learning

• SAS-UTD certificate in Data Mining and Business Intelligence

• Programming with R for Data Science

LEADERSHIP EXPERIENCE and ORGANIZATIONS

• JSOM Graduate Scholar of Recognition - UT Dallas May 2018

• Recognized by Dell Software Security Acknowledgment Program for finding system vulnerability May 2017

• SRM Cricket Club - Captain May 2012

Contact this candidate