Sign in

Business Intelligence Analyst

Richardson, TX
November 27, 2018

Contact this candidate


Rohit Kumar Sinha***1

469-***-****, Dallas, TX Summary

Experience in business intelligence & data analysis with the ability to leverage business knowledge to create BI solutions for competitive advantage, finding new business opportunities & making smarter decisions. Education

M.S. in Management Information Systems, University of Texas at Dallas, Dallas, TX 3.5/4.0 May 2018 B.E. in Civil Engineering – Ramaiah Institute of Technology, India 3.6/4.0 May 2013 Skills

Languages: Python, R, SQL

Machine Learning: Random Forest, Decision Tree, SVM, K-Means, Regression, Bootstrapping Analytics: Clustering, Predictive Analytic, Data Preprocessing, EDA Visualization & Reporting: Tableau, PowerBI, Google Sheets Tools: MS Excel, RStudio, Jupyter Notebook, MS Project, SSMS, SAS Miner ETL: SAP HANA, SAP Netweaver, SSIS

RDBMS: MySQL, MS SQL Server, Oracle, MS Access


Business Intelligence Analyst, Arthur J Gallagher & Co. Jun 2018 – Present

• Create and analyze weekly, monthly, and quarterly key reports and dashboards that track agency, territory, region, product, niche, and/or state level performance to ensure business runs as per plan

• Operate as SME in quantitative analysis and data visualization, providing both reactive and proactive consultative guidance for internal business partners and clients

• Automated monthly agency growth reports using tableau, thereby saving 70 manhours every month

• Manage and execute sales team leaderboards, standings, and commission and bonus statements monthly

• Build & maintain tableau dashboards to facilitate business decisions & ensure successful business impact Data Analyst, Infosys Limited Sep 2013 – Jun 2016

• Collaborated with data scientists in performance evaluation which increased employee performance by 21%

• Analyzed key components of staffing cycle to optimize performance for hiring and internal mobility

• Assisted HR Dept to reduce employee turnover by 12%

• Utilized Python and R to cleanse unstructured data of employee base of 150,000 across the globe

• Automated reports using v/h lookup, Index Match, & pivot tables in MS Excel/Google Sheets to meet performance measurements

• Ran multiple SQL queries to cater to the data needs of multiple department for report generation Projects

• Ensemble Learning - Random Forest on Titanic Dataset to Predict a Passenger’s Survival Used python for data preprocessing and making it ready for machine to understand, trained 5 different machine learning models, Selected Random Forest and applied cross validation on it and applied hyperparameter tuning. Used the test set to predict survival of a passenger

• Digit Recognition and Manipulation using Python PIL, Pandas, Numpy, and Matplotlib library to recognize digits with 99% accuracy, also converts image from b&w to color and vice-versa

• IMDB/Movie Lens – Earning Prediction using R performed data preprocessing and built multivariate regression model to discover dependencies between earnings and genre

• Analysis of Minnesota high school graduates using R & Tableau Created a predictive model to solve the issue of decreased enrollment of students of color in Colleges in Minnesota utilizing 10 years’ worth of data

• Food Desert Stores using tableau, R, D3, and Powerbi, visualized the food desert across United States. Utilized data by US Dept. of Agriculture to strategically open grocery stores at such location

Contact this candidate