Gayatri Lakhanpal

**** ************* ****, *** ***, Miami, FL, 33172 352-***-**** adcoag@r.postjobfree.com linkedin.com/in/glakhanpal EDUCATION

Master of Science in Information Systems and Operations Management-BI August 2016-May 2018 University of Florida- Hough Graduate School of Business Gainesville, FL, USA Relevant Courses: Business Database System, Advanced Business Programming, Managerial Quantitative Analysis, Business Intelligence, Economics, Organizational Behavior, Finance, Marketing, E-commerce, Data Analysis and Decision Bachelor of Engineering in Electrical Engineering August 2010-May 2014 PEC University of Technology Chandigarh, India

Relevant Courses: Programming in C, Entrepreneurship and Project Management TECHNICAL SKILLS

Programming Languages: C, Java, C#, R, Python (basic) Databases: Microsoft Access, My-SQL Business Intelligence Tools: Tableau, Looker, SPSS, Stata, MS Office (Excel, Access) Big Data: Hive, Redshift (Amazon) Microsoft Office Packages: Word, PowerPoint Methodology: Agile, Scrum PROFESSIONAL EXPERIENCE

Business Intelligence Manager March 2020 - Present Brightline Trains/ Virgin Trains USA Miami, FL, USA

• Facilitate business intelligence processes, procedures, development, implementation, forecast and insights analysis for Marketing, Sales, Revenue Management, Operations and Food and Beverage teams

• Responsible for providing product and business insights and leading the strategic design and maintenance of business intelligence applications

• Identify researches and resolve complex analytical problems ensuring that the use of BI applications enhances business decision making capabilities with actionable insights on targeted audience, customer loyalty, retention patterns, revenue optimization and product promotions

• Ensure that project/department milestones/goals are met considering priorities and deadlines

• Supervise efficient working of projects and analyze requirements and perform appropriate tests on same

• Administer projects, prepare updates and implement all phases for product development to achieve all project objectives

• Perform assessment on all reporting requirements and develop long term strategy for various reporting solutions

• Look into ETL process and manage the Data Warehouse and the nuances of the data within the warehouse. Look into complex requests from various teams to build a systematic approach towards data collection and reporting Business Intelligence Analyst October 2018- February 2020 Brightline Trains/ Virgin Trains USA Miami, FL, USA

• Responsible for tracking, monitoring, and reporting sales activities, marketing, portfolio, web metrics, and operational efficiency over Tableau Dashboards and Excel

• Analyzing large datasets over SQL; Interpreting trends over R and Tableau; identifying actionable insights and opportunities

• Updating daily KPI and Forecasting reports for executive management

• Managing the Data Warehouse and the nuances of the data within the warehouse. Looking into complex requests from various teams to build a systematic approach towards data collection and reporting Research Assistant June 2018-September 2018

University of Florida Gainesville, FL, USA

• Researched on methodology of ranking system of middle school and high school in USA and impact of the rankings on real estate around school areas

• Collected school entrance test and demographics data; prepared data; cleaning, structuring and aggregating; analyzed the trends and conducted multivariable regression, correlation, one-way ANOVA and T-test based on trends observed Big Data Intern May 2017-August 2017

World Wide Technology New York, USA

• Analyzed large data sets from multiple sources to gain insights on sensor data gaps due to the mesh network transmission issues for various sites of a mining firm by querying over SQL and visualizing by creating heatmaps over R

• Developed Big Data strategy and use cases to solve the business challenges of a utility company, assessed the client’s OSISoft environment, considering the organization wide architect and data governance structure Data Analyst August 2014-June 2016

Absolutdata Research and Analytics Solution Pvt. Ltd Gurgaon, India

• Data exploration, Analysis and Visualization: Worked hands on data management and data reshaping on data that varied from per second data in TB’s of manually entered and unclean work order & maintenance data.

• Worked on haul truck optimization through analysis over Excel, R and SQL querying along with visualization over Tableau for a US based mining firm that led to cost saving of $5million (October 2014 - June 2015)

• Carried out segmentation on online research data of potential Fitbit users over Python(basic) and ran SQL queries for analysis using data packs for an advertisement firm which helped in market segmentation and sales increase of 25% (August 2015- April 2016)

• Assisted my team in developing an E-wallet Application integrating the SMS and Payment Gateway for transactional purposes which helped in increasing the customer base by 17% (April 2016-June 2016) Intern January 2013-June 2013

Schneider Electric India Gurgaon, India

• Conducted Energy Audits along with Auditors using various Energy measuring equipment’s and submitted proposals for energy savings of 10%

VOLUNTEER WORK AND INTERESTS

• Educator at Alzheimer’s Association (Southeast Florida Chapter)

• Fitness Enthusiast

Nutrition and Healthy Living Certificate – Cornell University

Yoga Teacher Training – Currently Enrolled at Yoga Alliance

Contact this candidate