Summary
Overview
Work History
Education
Skills
Websites
Projects
References
Timeline
Generic

Nitin Singh Rana

Windsor,ON

Summary

Dedicated and results-oriented Business Data Analytics professional with a Master's degree in Business Data Analytics and a proven track record in Marketing Data Analysis and Business Analysis. Seeking a challenging role where I can leverage my strong analytical skills, programming expertise, and proficiency in data analysis tools to contribute to data-driven decision-making processes and enhance business efficiency.

Overview

2
2
years of professional experience

Work History

Business Analyst

EdMission
Windsor, CA
06.2022 - 12.2023
  • Implemented DAX language and advanced Power BI features such as row-level security, calculated tables, and Power BI Service features to enhance report performance and user experience, resulting in a 20% improvement in report loading time
  • Composed and edited impactful marketing content including compelling blog posts, thought leadership articles and result-driven email campaigns
  • Model new processes to gather accurate data and generate monthly/quarterly reports using PowerBI comparing delivered consultants per client portfolio requirements, making analysis easier for upper management
  • Built effective Flow Automation strategies to enhance the customer journey and engagement efficiency by 40%
  • Produced and distributed weekly/monthly/annual reports, including available-to-sell inventory reports, KPI dashboards and ad-hoc reports to support data-driven decision-making for upper management
  • Supported the Operations/Process team to develop reporting tools, documenting and analyzed campaign performance data, identified trends, and recommended optimizations, leading to a 25% improvement in overall email marketing effectiveness
  • Collaborated closely with the Marketing team to ensure seamless project execution, maintaining alignment and meeting project timelines resulting in a 20% increase in open rates and a 15% boost in click-through rates
  • Generated Power BI reports for Walmart’s Supply Chain department highlighting core business KPIs (E.g., Total batch production per shift), saving 20 hours of manual work per week.

Education

Master of Science in Business Data Analytics -

St Clair College

Master’s in Computer Science -

Chicago State University

Skills

  • Python
  • R
  • Requirements Gathering
  • Campaign Performance Tracking
  • Technical Writing
  • Data Analysis
  • Business Process Improvement
  • Data Mining
  • Quality Assurance
  • Data Mapping
  • Cost-Benefit Analysis
  • Workflow Analysis
  • Gap Analysis
  • Competitive Analysis
  • KPI Tracking
  • Operational Reporting

Projects

Energy Demand Forecasting on Fossil Fuels, Python and Tableau, Demonstrated and researched the main cause for global warning by exhibiting the most widely used fuels across the world by analyzing the Dataset to extract new innovations. Customer Segmentation and Market Analysis, Tableau, Created interactive data visualizations development using tools like Tableau, presenting insights to stakeholders, and facilitating data-driven decision-making also by using accounting software. Forecasting Callback Demand for the OTIS Elevator Company, Python, Tableau, SAS Enterprises, Developed Time Series Model to predict the number of callbacks for OTIS and improve maintenance operations efficiency. Studied historical data, identified patterns, and shared insights and findings via dashboards to stakeholders.

References

References available upon request.

Timeline

Business Analyst

EdMission
06.2022 - 12.2023

Master of Science in Business Data Analytics -

St Clair College

Master’s in Computer Science -

Chicago State University
Nitin Singh Rana