Mahendra Singh Bhati
Mahendra Singh Bhati
Master of Science in Business Intelligence | Saint Joseph�s University | Philadelphia, PA Dec 2020
Bachelor of Business Administration in Marketing | DAVV University | IndiaJuly 2016
TECHNICAL SKILLS
Programming Languages:Python, R, SQL
Database:MySQL, Oracle, SQL Server
Analysis & Visualization:Advanced Excel, Tableau, Power BI, Google Analytics, Qlik View
Machine Learning:JMP, SAS, Regression analysis, Classification Methods, Tree-Based Models, Neural Networks
Statistics/ML:Agile, Waterflow, NumPy, Pandas, Jira
CERTIFICATE
? Tableau Analyst and Tableau Author Certificate, Tableau ? Managing Big Data with My SQL Certificate, Coursera
? Data Analytics Consulting Virtual Internship, InsideSherpa, KPMG? Python Data Structures
? Fundamentals of Visualization with Tableau Certificate, Coursera
PROFESSIONAL EXPERIENCE
Graduate Assistant | Saint Joseph university Philadelphia, Aug 2019 � Dec 2020
? Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
? Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.
? Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
? Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.
Data Analyst | Pixit Solution MP, India Dec 2016 � Nov 2018
? Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
? Knowledge of Oracle PL/SQL and ability to write complex logic to manipulate data, create Functional specifications for ETL mapping, mockup for Dashboard and Visualization frames.
? Proposed vital dashboards utilizing Tableau for a serious investigation venture by dissecting the chronicled information and distinguishing KPI's which improved the business by 9.6%
? Created Power BI/tableau dashboards to track new mortgage applications from different lenders.
? Improved efficiency of the sales team by optimizing time and performance matrices monthly sales report presentation, by executing a customized sales dashboard system to and record a 15% growth in sales.
? Wrote code as needed for development of reports, analytics and visualization using NO SQL/SQL tunning, data models.
Data Analyst | Tanisha Buildcon Pvt. Ltd MP, India July 2015 � Nov 2016
? Developed interactive visualization with Tableau for performance analysis to monitors customer satisfaction based on feedback
? Increased overall productivity of client targeting by 30% by conducting extensive data management and technical decision making.
? Selected customer contacts from database by SQL and sent out marketing emails.
? Structure and perform Quality Assurance. Deliver recurring reports and dashboards accurately and on-time.
? Provided primary SQL Server support and monitored performance for all databases instances and the Business Objects/Crystal Reports server.
? Collection and analyzed customers data to make better decisions will be in extremely high demand.
ACADEMIC AND SELF PROJECTS
Website Tracking and Optimization Jan 2020 � May 2020
? Collected data from multiple movie databases and ranked movies, actors, and directors based on the cumulative average.
? Created multiple dashboards to analyze user activity and time over particular pages, in time it improved the time.
? Analyzed the user behavior to make changes on the website, after calculated changes it increased the website traffic by 56%.
Database solution for Bravita Training Jan 2020 � Apr 2020
? Created database for Bravita Pvt (BT) Training. Ltd and implemented views and triggers on top of the tables
? Build an inventory database in Oracle SQL developer by following the normalization technique.
? Created logical and physical data models and Developed database objects, including tables, views, stored procedures, and SQL triggers.
Exploratory and Predictive AnalysisSep 2019 � Dec 2019
? Performed exploratory and predictive analysis on the car service dataset.
? Developed predictive models to estimate future value based on historical data using time series analysis and linear regression in R.
? Analyze�records�to predict�subsequent�service�date, patterns,�discover�traits�in�complex�data�sets�using�R, RStudio, and achieved 94.3 % accuracy of the model using Root Mean Square Error (RMSE).
Mahendra Singh Bhati
Master of Science in Business Intelligence | Saint Joseph�s University | Philadelphia, PA Dec 2020
Bachelor of Business Administration in Marketing | DAVV University | IndiaJuly 2016
TECHNICAL SKILLS
Programming Languages:Python, R, SQL
Database:MySQL, Oracle, SQL Server
Analysis & Visualization:Advanced Excel, Tableau, Power BI, Google Analytics, Qlik View
Machine Learning:JMP, SAS, Regression analysis, Classification Methods, Tree-Based Models, Neural Networks
Statistics/ML:Agile, Waterflow, NumPy, Pandas, Jira
CERTIFICATE
? Tableau Analyst and Tableau Author Certificate, Tableau ? Managing Big Data with My SQL Certificate, Coursera
? Data Analytics Consulting Virtual Internship, InsideSherpa, KPMG? Python Data Structures
? Fundamentals of Visualization with Tableau Certificate, Coursera
PROFESSIONAL EXPERIENCE
Graduate Assistant | Saint Joseph university Philadelphia, Aug 2019 � Dec 2020
? Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
? Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.
? Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
? Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.
Data Analyst | Pixit Solution MP, India Dec 2016 � Nov 2018
? Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
? Knowledge of Oracle PL/SQL and ability to write complex logic to manipulate data, create Functional specifications for ETL mapping, mockup for Dashboard and Visualization frames.
? Proposed vital dashboards utilizing Tableau for a serious investigation venture by dissecting the chronicled information and distinguishing KPI's which improved the business by 9.6%
? Created Power BI/tableau dashboards to track new mortgage applications from different lenders.
? Improved efficiency of the sales team by optimizing time and performance matrices monthly sales report presentation, by executing a customized sales dashboard system to and record a 15% growth in sales.
? Wrote code as needed for development of reports, analytics and visualization using NO SQL/SQL tunning, data models.
Data Analyst | Tanisha Buildcon Pvt. Ltd MP, India July 2015 � Nov 2016
? Developed interactive visualization with Tableau for performance analysis to monitors customer satisfaction based on feedback
? Increased overall productivity of client targeting by 30% by conducting extensive data management and technical decision making.
? Selected customer contacts from database by SQL and sent out marketing emails.
? Structure and perform Quality Assurance. Deliver recurring reports and dashboards accurately and on-time.
? Provided primary SQL Server support and monitored performance for all databases instances and the Business Objects/Crystal Reports server.
? Collection and analyzed customers data to make better decisions will be in extremely high demand.
ACADEMIC AND SELF PROJECTS
Website Tracking and Optimization Jan 2020 � May 2020
? Collected data from multiple movie databases and ranked movies, actors, and directors based on the cumulative average.
? Created multiple dashboards to analyze user activity and time over particular pages, in time it improved the time.
? Analyzed the user behavior to make changes on the website, after calculated changes it increased the website traffic by 56%.
Database solution for Bravita Training Jan 2020 � Apr 2020
? Created database for Bravita Pvt (BT) Training. Ltd and implemented views and triggers on top of the tables
? Build an inventory database in Oracle SQL developer by following the normalization technique.
? Created logical and physical data models and Developed database objects, including tables, views, stored procedures, and SQL triggers.
Exploratory and Predictive AnalysisSep 2019 � Dec 2019
? Performed exploratory and predictive analysis on the car service dataset.
? Developed predictive models to estimate future value based on historical data using time series analysis and linear regression in R.
? Analyze�records�to predict�subsequent�service�date, patterns,�discover�traits�in�complex�data�sets�using�R, RStudio, and achieved 94.3 % accuracy of the model using Root Mean Square Error (RMSE).