Business Intelligence Analyst Intern

SAI SUBASH RAVICHANDRAN

Dallas, Texas +1-469-***-**** admswo@r.postjobfree.com https://www.linkedin.com/in/saisubash/ EDUCATION:

The University of Texas at Dallas – M.S., Business Analytics; May 2021 Dean’s Excellence Scholarship

SRM Institute of Science and Technology, India – B.Tech., Mechatronics Engineering; May 2019 Founder’s Scholarship

TECHNICAL SKILLS:

Analytical Tools: Python (Pandas, Ski-Kit learn), R, MS Excel, Alteryx, Google Analytics, DAX Visualization Tools: Tableau, Microsoft PowerBI, SAP Lumira, Qlik Sense Big Data Tools: Hadoop, Spark, Hive, Sqoop, Flume

Competencies: Regression Analysis, K-Means Clustering, KNN, Descriptive & Inferential Statistics, A/B Testing, Hypothesis Testing, Data Visualization, T-SQL, SSIS, SSRS and SSAS. Databases: MySQL Server, SQL Server Management Studio Certifications: Tableau Desktop Specialist

BUSINESS EXPERIENCE:

American College of Emergency Physicians, TX, USA Oct 2020 – April 2021 Business Intelligence Analyst Intern

• Processed the complete data life cycle, from data strategy to data acquisition, along with the steps for extract, transform, and load (ETL) as well as quality check, Data analysis, and gap mitigation to support the team in building and documenting end-to-end processes for CEDR, the world’s largest Emergency Medicine data registry.

• Worked directly with the executive team to formulate and report on KPI’s, building Interactive Dashboards to give insights on weekly performance metrics using PowerBI and Python.

• Data Pipelining for updating data in Asana (Team's workspace) from different data sources using Python and API’s. Achieved complete automation of this process using Python.

• Modeled and created a database from scratch containing over a million row of data for the CEDR using SQL. Improved data management efficiency by 85%.

Mercedes Benz, India Jan 2018 – Dec 2018

Data Analyst Intern

• Collaborated with the Analytics team and successfully expedited performing data pre-processing, developed dashboards and ad-hoc reports using MS PowerBI and SSRS for senior management team for analysis.

• Created complex SQL Queries, User Functions, stored procedures, CTE’s, Views, Indexes also created schema and Tables Using SSMS 2018.

• Developed a sales forecast model for predicting sales of this branch using Time series analysis and exponential smoothing technique based on R. The model yielded a 3% error rate. ACADEMIC PROJECTS:

Predictive Analytics on Fast Food - Tableau Sep 2020 – Nov 2020

• Used Groups, hierarchies, sets to create detail level summary report and complex calculations like Row - level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines to create dashboard of Fast-food items in USA using Tableau’s Advanced Capabilities.

• ETL of data directly from different source systems like flat files, Excel, Oracle and SQL Server to devise an accurate predictive model with an accuracy of 97.9% in predicting fast food choice of consumer. Cluster Analysis on NBC-FOX Tweets Dec 2019 – Feb 2020

• Studied the association of commonly used words in the Tweets of NBC-FOX by implementing Hierarchical Clustering on the data using R.

• Analyzed data with Text mining and executed classification models using Logistic Regression, KNN and Decision Tree, identifying words that are most likely to occur together.

Contact this candidate