Data Analysis : Advance Excel MS-SQL Mixpanel R Statistics
Shubham Dey
Project Manager
Jamshedpur
Summary
Proactive working professional with 4.5 years of experience in Analytics, Project and Operations Management, People Management and Mechanical Maintenance. Excellent Data Reasoning, Guesstimating, Mathematical and Statistical skills to implement on complex sets of data to perform logic building, drawing insights and visualization work to extract hidden information. Currently, keen to implement the Project Management knowledge along with Analytical and Visualization skills in a data-driven environment.
Overview
7
7
years of professional experience
6
6
years of post-secondary education
4
4
Certifications
Work History
Project Manager
E-GMAT
3 2022 - Current
- Office of CEOs: Worked with CEOs to gather requirements, analyze data, and deliver business presentations on strategy updates. Implemented tasks using MS Planner and reported status using user behavioral data from tools like Customer.io, and Appcues.
- Increased overall efficiency by 15% by thorough bandwidth calculation and process modifications using tools such as MS Smartsheet and MS Excel .
- Led meetings to detail project milestones, brainstorm ideas and determine appropriate techniques to manage tasks using Mind-Manager, MS Smartsheet and MS Powerpoint.
- Collaborated across teams to define goals and commitment to timelines and deliverables using tools such as MS Teams, MS Outlook and MS SharePoint.
Business Analyst
E-GMAT
03.2022 - Current
- Analyzed business aspects to understand performance drivers, collaborated with teams and management to define project scope, and summarized data into presentations and dashboards using Power BI.
- Performed competitor bench-marking analysis to identify growth opportunities and potential product enhancements and with the help of this SEO Optimization process increased 100K+ blog-page views i.e., 8% increase
- Additionally, handled reports on company metrics to assess successes and account for deficiencies through which we managed to deliver 3% of growth margin using tools such as Mixpanel, SEMrush and Google Analytics.
Social Media Cum Product Manager
E-GMAT
3 2022 - Current
- Managed entire content lifecycle from Strategizing, Planning, Requirement and Collateral Creation, Publishing content across various Social media platforms including YouTube, LinkedIn, Reddit, e-GMAT Blogs, and GMAT Club.
- Leveraged insights from YouTube Analytics and data from all other Social media platforms to strategize, curate and develop engaging content tailored to specific audience preferences and behaviors.
- Managed and performed uploading, modification, maintenance of Thousands of questions into repositories for company platform while ensuring organization and accessibility of questions for efficient use by team members and students.
Operations and Maintenance Engineer
Vedanta Resources PLC
06.2017 - 08.2019
- Studied and established safer and more efficient mechanization of molten metal Ladle Handling System and its working which saved approx. INR. 5.6M and augmented safety level by 70% for smelting section.
- Drove improvement Projects at plant site by tracking all key performance indicators of project and organizing idea generation sessions by regular interaction with executives of HZL workforce alongside Business Excellence team.
- Ensured better Availability, Utilization and Productivity with cross-functional teams while optimizing maintenance activities of all mining equipment with Kaizen and 5S drives.
Education
Bachelor of Technology - Mechanical Engineering
National Institute of Technology
Warangal 08.2013 - 05.2017
Associate of Science - I.Sc.
Mrs. K.M.P.M. Inter College
Jamshedpur 07.2010 - 05.2012
Software
Data Visualization : Tableau Power BI Google Analytics
Project Management : Office 365 MS Smartsheet MindManager MS Planner
Interpersonal : Communication Punctuality Discipline Proactive Team Player
Languages : English Hindi Bengali
Certification
Project Management Foundations(2019) : LinkedIn Learning
Timeline
MS-SQL Basics - Business Analytics Masters Program : Learnbay
03-2024
Statistics & R - Business Analytics Masters Program : Learnbay
10-2023
Tableau & Power BI - Business Analytics Masters Program : Learnbay
08-2023
Project Management Foundations(2019) : LinkedIn Learning
11-2022
Business Analyst
E-GMAT
03.2022 - Current
Operations and Maintenance Engineer
Vedanta Resources PLC
06.2017 - 08.2019
Bachelor of Technology - Mechanical Engineering
National Institute of Technology
08.2013 - 05.2017
Associate of Science - I.Sc.
Mrs. K.M.P.M. Inter College
07.2010 - 05.2012
Project Manager
E-GMAT
3 2022 - Current
Social Media Cum Product Manager
E-GMAT
3 2022 - Current
Similar Profiles
Shweta KoshijaShweta Koshija
GMAT Quant Product Creator at E-GMATGMAT Quant Product Creator at E-GMAT
Atul SharmaAtul Sharma
Digital Marketing Manager at e-GMATDigital Marketing Manager at e-GMAT
Shikha HoraShikha Hora
Verbal Trainer and Administrator at GMAT MantraVerbal Trainer and Administrator at GMAT Mantra