Business Analyst

GAURAV GUPTA

+91-884******* ******.*********@*****.***

Professional Summary

1.5 years of cross functional experience in Business Analytics, IT and Operational consulting (working extensively on Advanced Excel and SQL) with expertise in business re engineering, across different industries in Riyadh, Saudi Arabia and Bangalore, India Skills Tools

• Business Problem Solving • Enterprise Resource Planning Application

• Standard Operating Procedure Development • SQL, Advanced Excel, PowerPoint

• IT and Operational consulting • Qlikview

Experience

Sunday Mattresses

Associate – Business Analytics Dec 2017 to Mar 2018

• Predictive modelling of data for demand forecasting to streamline the processes of supply chain and thereby increasing customer adoption as well as retention rate

• Defined KPIs and developed automated BI dashboards using MS Excel and its advanced functionalities which helped in deriving meaningful insights from raw data of various departments of the firm

• Played a significant role in the management team, where I was responsible for raw material sourcing, production and warehousing

i3 Consulting Pvt. Ltd.

Business Analyst June 2016 to Mar 2017

• Remodelled the order execution and product procurement process to streamline operations (for Healthcare firm)

• Streamlining the data of all the departments and developing automated business intelligence dashboards over the same using advanced excel skills and techniques (for Healthcare firm)

• ERP audit and management for a Real Estate management firm in Saudi Arabia

• Confer with personnel concerned to ensure successful functioning of newly implemented systems or procedures

• Working on data visualization tools and creating reports using Qlikview to derive meaningful business insights

• Helped a commercial real estate company in the Middle East to grow from 32 to 42 projects in 8 months by streamlining operational processes and adopting improved Enterprise Resource Planning (ERP) system across the company

• Responsibilities included collecting user requirements, scheduling workshop and tutorial material, giving training to the users and ensuring to follow the best practices in the ERP systems

• Root cause analysis of the system related issues in the ERP from both front end and back end of the system using advanced SQL queries

• Administered business requirement gathering for ERP adoption based on short and long term goals of the company; oversaw functional proposal evaluation, vendor negotiation, and implementation planning

• Part of a team in process mapping, workflow setup, data migration, and user training on ERP modules Project Intern Jan 2016 to May 2016

• IT and PMO support for a healthcare firm in Saudi Arabia

• Working on business strategy and growth implementation by performing business analytics, reading market characteristics and identifying trends

• Responsibilities included developing KPIs and creating business intelligence dashboards over the same, removing ERP data inconsistencies, proper documentation and developing or re-creating SOPs

• Managing the project of setting up of customer care centre and reporting directly to CEO of the firm Education

Indian Institute of Information Technology, Allahabad Aug 2012 to Jul 2016 Bachelor of Technology, Information Technology

Extra-Curricular Activities

• As the vice-president of Music club, organized various major musical events in EFFERVESENCE, the annual cultural fest of IIIT Allahabad

• As the lead guitarist of our rock band, performed and won at various rock/metal events

• Volunteered and worked in an NGO called ‘Prayas’(an initiative taken by an IIIT alumnus) and taught under- privileged children in rural areas

• POC of employees working in Riyadh in my previous firm

Contact this candidate