Mrinal Gupta Email & Phone Number

Union, Nj, Us

Austin, Texas, Us

New York, New York, Us

New York, New York, Us

• Awarded Manager of the Second Quarter in 2018• Influence executive management’s decisions, through adhoc initiatives, comprising of reporting and advanced analytics• Identify and structure problems, plan and execute analysis by translating data into insights and present recommendations using Power BI, Tableau, and advanced Excel dashboards• Work as a “connector” across teams in managing a program/project against KPIs through to completion• Analyze complex business problems using data from internal and external sources• Always on the lookout for new ways to evaluate data and follow trends to discover actionable opportunities to increase efficiencies and generate revenue• Create specifications, generate reports and map analysis to business needs• Use DataVision to work with the reporting and analytics team, to assist in building and implementing additional reporting/analysis capabilities• Build advanced Excel Dashboards, Models and Macros to improve efficiencies and generate dynamic reports

Orlando, Florida, Us

Financial Planning, Reporting and Analysis -- May'16 - July'17• Developed competent Excel models for FPR&A to recognize the business growth and opportunities• Forecasted financial metrics, P&L, asset management for 11 business units and developed a long term plan• Key contributor in the decision making process through special project initiativesPredictive Analytics -- May'15 - Apr'16• Performed strategic analyses to determine profitability of proposed new business developments• Assisted in Developing ways to visualize data using Tableau and produce a storyboard to the Executive Board• Automated the processes using tools like SPSS and Visual Basic for Applications to improve turn around time of deliverables• Conducted research to expand customer program offerings and performed valuation modeling to maximize revenue

Winter Park, Florida, Us

• Generated dynamic dashboards using Advanced Excel VBA Macros for businesses to institutionalize the process• Automated the Financial Report of amaZulu Inc. to optimize the monthly reporting timeline• Collaborated closely with the business development team to conduct financial audits

In

Dashboards:• Created Excel dashboards using VBA Macros to effectively view Consumer Behaviors and the Key Performance Indicators (KPI's) to measure success• Involved in the designing and embellishing the look and feel of various dashboards and executing them• Involved in automations and creating macros thus facilitating efficient working• Client base includes Nestle, Danone, Pepsi, Disney etc.Data Processing:• Designed and executed quantitative attitude of usage, brand awareness, brand image for different tracking, ad-hoc projects (consists of FMCG, Food products etc)• Consulted with clients on project objective, research methodology & specific requirements on data delivery• Assured the integrity of project, including data validation, storage and processing• Collected data from field agencies, cleaned the data using appropriate Data Validation program, analyzed data for evaluating quantitative information to support and review new and existing marketing and sales strategies• Analyzed data with standard statistical methods, observing patterns in data, interpreting the results, and providing different types of data tables as required by client on a timely basis• Hands on knowledge of Statistical analysis including Jaccards, Quadrants, Correspondence Maps etc.• Worked closely with colleagues to conceptualize the research objectives, data analysis and sharing this knowledge through effective presentation of the data output

Mumbai, Maharashtra, In

Configuration Utility (B.E. Final Year Project), July ‘10-April ’11.-Facilitate the work done at L&T Integrated Engineering Services, Mumbai.-This utility is used by the employees to interact with each other using different modules. They can upload or download different files of the various projects on the LAN server.-Employees can also interact with the customers using this utility over the internet. Customers can ask various queries and see new projects.

Master Of Business Administration (Mba), Operations Management And Finance

Bachelor'S Degree, Computer Engineering

Passed Xii, Science Vocational

High School

Secondary School, Junior High/Intermediate/Middle School Education And Teaching