Mandeep Singh's resume summarizes his experience and skills in data science and analytics consulting roles at companies like Fractal and as an intern at the University of South Florida, where he developed data pipelines, designed data models, built automated analysis and reporting dashboards using tools like SQL, Python, Tableau and Power BI to provide insights for strategic decision making. He has skills in programming, data visualization, database programming, ETL, cloud computing and project management and education includes a Master's degree in Business Analytics and Information Systems from the University of South Florida.
Mandeep Singh's resume summarizes his experience and skills in data science and analytics consulting roles at companies like Fractal and as an intern at the University of South Florida, where he developed data pipelines, designed data models, built automated analysis and reporting dashboards using tools like SQL, Python, Tableau and Power BI to provide insights for strategic decision making. He has skills in programming, data visualization, database programming, ETL, cloud computing and project management and education includes a Master's degree in Business Analytics and Information Systems from the University of South Florida.
Mandeep Singh's resume summarizes his experience and skills in data science and analytics consulting roles at companies like Fractal and as an intern at the University of South Florida, where he developed data pipelines, designed data models, built automated analysis and reporting dashboards using tools like SQL, Python, Tableau and Power BI to provide insights for strategic decision making. He has skills in programming, data visualization, database programming, ETL, cloud computing and project management and education includes a Master's degree in Business Analytics and Information Systems from the University of South Florida.
Mandeep Singh's resume summarizes his experience and skills in data science and analytics consulting roles at companies like Fractal and as an intern at the University of South Florida, where he developed data pipelines, designed data models, built automated analysis and reporting dashboards using tools like SQL, Python, Tableau and Power BI to provide insights for strategic decision making. He has skills in programming, data visualization, database programming, ETL, cloud computing and project management and education includes a Master's degree in Business Analytics and Information Systems from the University of South Florida.
com | (857)540-8355 | LinkedIn | Portfolio | Tableau
Professional Experience
Data Science and Analytics Consultant - Fractal July 2021 – July 2023 Google: • Developed a consistent data pipeline, starting from SQL (Big Query) script development to data modeling, to create and support self-service dashboards for Google cloud marketing stakeholders. • Designed and implemented a streamlined process to extract, transform, and load data for analysis with SQL and visualizations. • Led the development and implementation of data models, translating business requirements into comprehensive data-based objectives to facilitate analysis and predictive modeling. • Built automated analysis in Google Colab using Python for cloud product adoptions to gauge product usage patterns and target marketing campaigns to appropriate users. • Generated recurring analysis solutions with reporting dashboards to gain insights to save 50% of time in ad-hoc analysis. USAA: • Developed guided self-serve analytics solutions and visual packages in Tableau to provide insights to P&C insurance. • Designed SQL queries in Snowflake data warehouse to consolidate data cubes from multiple environments leading to reporting for cloud migration of cubes. • Utilized advanced data analysis techniques to extract meaningful insights using SQL and Tableau from complex datasets, informing strategic decision-making, and optimizing operational efficiency. • Implemented reports and consumption solutions using Dremio, Snowflake and Tableau. Data Analyst Intern (Research) – University of South Florida (Healthcare) June 2020 – May 2021 • Integrated high volume healthcare, geographic, mobility and demographic metrics data from 4 sources using Python to create a robust pipeline for data modelling and creating dashboards. • Implemented data models and developed a Power BI dashboard to report KPIs and enable actionable insights. • Transformed time series predictive models with Python to support logistical planning for the 52 Floridian hospitals for COVID 19 hospitalization cases which optimized resource capacity management. • Earned media coverage for predictive model outputs and trends from the dashboard. Graduate Assistant - University of South Florida (Academia) December 2019 - May 2020 • Executed Curricular Analytics scripts using curriculum data in Excel and investigated trends to define pathways for students. • Designed Microsoft Power BI dashboards to gain curricular insights of all the colleges of USF. • Transformed complex data into a comprehensible story and communicated recommendations and insights to stakeholders. Business Analyst Intern - CommerceX, India (E-commerce) Feb 2018 - June 2018 • Cleaned and analyzed web analytics data using Alteryx, identified relevant trends, conducted ad hoc analysis, and prepared visualizations in Tableau to accelerate sales by 30% during Q2 of 2018. • Established data extraction and pre-processing structured data from different sources using MS SQL server and SSIS. • Formulated reporting on key business metrics, including Sales, Marketing, and Operations to examine business impacts. • Played a pivotal role in driving business growth by providing data-driven insights and recommendations, enabling informed decision-making, and fostering revenue generation strategies. • Proposed actionable insights and recommended promotions to optimize channel performance, customer segmentation. Skills • Programming: Python (Pandas, NumPy, Matplotlib, Seaborn), R, PySpark • Data Visualization: Tableau, Power BI (Data modelling, DAX, Power Query), Looker • Database Programming: SQL (MS SQL Server, MY SQL, Access, Google Big Query) • ETL and Data Integration: Alteryx, Dremio, Snowflake, Pentaho • Cloud Computing: Amazon Web Services (AWS), Google Cloud platform (GCP) • Project Management: Agile Methodology, Jira, Microsoft Project, Confluence, Scrum • Tools: Pentaho, Elastic Search, Microsoft Office (Excel - Functions, VLOOKUP, Pivot tables), SAS, Google Analytics, Jupyter, Databricks Education • Master of Science in Business Analytics and Information Systems August 2019 - May 2021 University of South Florida, Tampa FL • Bachelor of Technology (Computer Science) August 2014 - May 2018 Dronacharya College of Engineering, MDU, India Certifications Tableau Desktop Specialist, Tableau Analyst, Udacity Business Analytics Nanodegree
