Jyoti Kumar Email & Phone Number

Bengaluru, Karnataka, India

- Leading Analytics Projects for different brands under Travelopia- Building models to identity high quality leads, probable repeaters and in the market customers using data from various sources- Managing a team of Business Analysts- Provided repeated customer insights for different brands to redefine Marketing Strategy- Delivered dashboards in Power BI.

Gurugram, Haryana, India

- Developed Performance Marketing reports to identify best performing channels/campaigns and areas of improvement- Created reports in Salesforce for automation- Automated reports in google sheet using python- Reduced TAT for new dashboards by standardizing data sources and scripts- Reduced issues for concierge team by 50% using automated dashboards

Noida, Uttar Pradesh, India

- Created automated reports in Tableau to track performance at Business Level for CEO office - Optimized ETL process to reduce refresh time from 3 hours to 45 mins - Standardized ETL process and created documents- Reduced man hours involved in creating daily/monthly reports by automation using Tableau

Gurgaon, India

• Developed automated dashboards in Amazon Quicksight for operations and management team to reduce dependency on excel/ google sheets
• Developed statistical/ machine learning model for income estimation
• Managed personalized campaign to improve click percentage
• Developed working prototype for new product using Airtable and Stacker app

Gurugram

• Extensively used Power BI for creating Dashboard for CHRO
• Used Power BI for creating Dashboards for Revenue, Cost and Margins for CEO
• Expertise in using R for collecting data from SQL database for analysis
• Experience in using Power BI to collect data from various sources like Marketo and Google Analytics for creating Dashboards
• Exposure to Power BI, ggplot(R), plotly(R), shiny(R), matplotlib (Python) for Data Visualization
• Experience in Machine Learning Modelling for classification and Text Analytics

Gurgaon, India

• Prepared financial statements from trial balances in excel
• Used ratio analysis, horizontal analysis and vertical analysis on financial statements for predictive insights that can help shape business strategy
• Identified key performance indicators for Business Intelligence implementation

Asansol Area, India

• Planned and oversaw preventive electrical maintenance of coal and coke handling plant of Battery#10 and 11 at Coke Ovens
• Executed commissioning of PLC at coal handling plant of Battery#10 at Coke Ovens
• Coordinated in commissioning of coal and coke handling plant of Battery#11 at modernized plant
• Enhanced efficiency of plant by preventive maintenance of equipments following standard maintenance practices
• Reduced breakdown management time by proper spares and inventory management
• Prepared technical notes related to new system for training subordinates in handling breakdowns

1) Worked as Project Engineer in Glodyne Power Ltd. at Patna from 21st Dec, 2009 to 17th Aug, 2010i) Gained exposure to Distribution system of Patna.ii) Developed strategies to reduce Technical and Commercial losses in Distribution system.2) Handled SCMS (Smart Card Management Services) for Smaarftech Technology, Patna (A subsidiary of Glodyne Technoserve).

Pgdm, Mba In Analytics, 8.94/10

Coursework: Finance- Financial Reporting and Analysis, Management Accounting, Corporate Finance, Financial Derivatives, Financial Risk.

B.Tech, Electrical Power, 8.14/10

12Th, Pcm, 78.33%