Prashant Iyer

Prashant Iyer Email and Phone Number

Business Analyst @ IndiGo | Excel, Power Query, Power BI @ IndiGo (InterGlobe Aviation Ltd)
gurgaon, haryana, india
Prashant Iyer's Location
Greater Delhi Area, India
Prashant Iyer's Contact Details

Prashant Iyer work email

Prashant Iyer personal email

n/a
About Prashant Iyer

A seasoned Business Analyst at IndiGo, my expertise lies in enhancing operational efficiency through the development of scalable data reports and insightful dashboards. With a focus on simplifying the operational lives of pilots, my work significantly contributes to the Corporate Policies and Projects department. My toolset includes advanced Excel, Power Query, and Power BI, enabling me to deliver comprehensive data analysis and reporting solutions. My role encompasses identifying problem areas and innovating solutions, underpinned by a robust knowledge of SQL. Harnessing data to drive actionable insights, I play a pivotal role in fostering meaningful advancements within the aviation sector. The dedication to my craft is evident through the meticulous design of reports that not only address immediate business challenges but also lay the groundwork for continued strategic improvements.

Prashant Iyer's Current Company Details
IndiGo (InterGlobe Aviation Ltd)

Indigo (Interglobe Aviation Ltd)

View
Business Analyst @ IndiGo | Excel, Power Query, Power BI
gurgaon, haryana, india
Website:
goindigo.in
Employees:
11248
Prashant Iyer Work Experience Details
  • Indigo (Interglobe Aviation Ltd)
    Assistant Manager Business Analyst
    Indigo (Interglobe Aviation Ltd) Feb 2020 - Present
    Gurugram, Haryana, India
    Worked in Corporate Policies and Projects department which aims at creating policies and working on projects centered on simplifying operational lives of pilots and identifying any problem areas and coming up with the solution to resolve them. My main areas of work include creating dashboards and reports in Excel, identifying the data sources, extracting data out of systems which helps address the business problem at hand. My job responsibilities predominantly involves creating various reports… Show more Worked in Corporate Policies and Projects department which aims at creating policies and working on projects centered on simplifying operational lives of pilots and identifying any problem areas and coming up with the solution to resolve them. My main areas of work include creating dashboards and reports in Excel, identifying the data sources, extracting data out of systems which helps address the business problem at hand. My job responsibilities predominantly involves creating various reports on excel, but given the problems at hand, I do also work with power Query and power BI to design reports that are scalable and insightful. Responsibilities include:- Simplifying existing reports and creating new reports on a requirement basis.- Commencing ETL process for the data extracted through ERP system, cleaning the data in a ready to process and analyze state through Power Query- Providing Quality assurance of imported Data sets- Identifying sources of data for analyzing data for the problems identified by the corporate team, and analyzing the data thereby providing them with the solutions.- Ad-hoc reportingAchievements- Helped in resolving business problems on two events where the Pilot's lives could be made easier which involved analyzing huge chunk of data consisting of multiple parameters and calculations involving multiple factors. - Created Dashboards using Power BI for other teams within the departments thereby reducing the need to refer to the monthly excel files, quick look at the analysis and diving deep into problem areas and addressing them. Skills Acquired:Transformation through Power QueryDesigning reports using Power BICreating calculated columns and Measures using DAX Show less
  • Praxis Services Pvt. Ltd.
    Senior Associate- Revenue Management
    Praxis Services Pvt. Ltd. May 2017 - Jul 2019
    Gurgaon, India
    Worked as a senior associate in the Revenue Management of an International resort chain called “Soneva”, which is one of the clients of Praxis and we are third party service providers to the Resort. We provide reservation and Revenue based services to all the resorts under Soneva.• Conducting competition analysis for the hotels managed by Praxis on regular basis• Creating MIS and productivity reports from various online channels• Responsible for making month end revenue report… Show more Worked as a senior associate in the Revenue Management of an International resort chain called “Soneva”, which is one of the clients of Praxis and we are third party service providers to the Resort. We provide reservation and Revenue based services to all the resorts under Soneva.• Conducting competition analysis for the hotels managed by Praxis on regular basis• Creating MIS and productivity reports from various online channels• Responsible for making month end revenue report to track the performance of the hotel in a business month and conducting Year on Year Analysis.• Creating Daily Pickup report, and other ad hoc reports for Sales and Marketing Report• Registration on hotels on various Online Travel Agents like booking.com, Expedia, Travelguru, Cleartrip, Makemytrip,Goibibo.com• Update rates and inventory on all online portals and the website as and when required• Creating and updating contents on OTAs.• Coordinating with the Market managers of online travel agents as and when required• Updating posts on various social media channels like facebook,Twitter ,Instagram as and when required• Coordinating with the hotel GM and front office with regards to rates and inventory• Keeping track of reviews on social networking sites• Ensure rate parity is maintained on various channels and rectifying the same on regular basis Show less
  • Openreach
    Associate
    Openreach Jul 2015 - Apr 2017
    + Validate and generate orders requested by Various SME’S (Small and Middle size enterprises) across UK for the ISDN30 telephone lines for their business requirements+ Dealing with providing new telephone connections, with two products under ISDN30 (Integral services Digital Network) ,viz., DASS and ETSI.+ Acting as per the Service Provider’s request if they want some calling network features to be added to their customer’s lines, or if they wanted to cease the telephone… Show more + Validate and generate orders requested by Various SME’S (Small and Middle size enterprises) across UK for the ISDN30 telephone lines for their business requirements+ Dealing with providing new telephone connections, with two products under ISDN30 (Integral services Digital Network) ,viz., DASS and ETSI.+ Acting as per the Service Provider’s request if they want some calling network features to be added to their customer’s lines, or if they wanted to cease the telephone lines so that their customers can chose a different technology other than ISDN30.+ Any minor modifications in the order raised by the Service Provider are also dealt with.+ Working with number management and migrations team, to assist them with their day to day requirements, like assigning a new range of numbers to a certain end customer’s business, or to convert DASS products to ETSI. + Keeping the Service provider informed regarding the status of the order, so that the end customers are informed on a real-time basis on what is happening to their orders. This way, we are accountable to our customers, i.e., in our case the Service providers are our customers.+ Inform the service provider if in case there is a delay in processing a certain order due to technical glitches or if engineers require some extra time to install whatever the customer has requested. Show less
  • Csav Liner Shipping
    Process Executive
    Csav Liner Shipping Feb 2014 - Jun 2015
    Gurgaon, Haryana, India
    Worked in Operations Support Department1) Reporting to the Regional Office; Updating the status of work done by the agencies operating at different ports.2) Co-operating with the Regional office and forward the instructions given by the regional heads to the agencies working at ports.3) Tracking the containers lying at port and daily reporting to the Regional heads and respective trade desks regarding the units waiting further for transhipment to other ports so that the… Show more Worked in Operations Support Department1) Reporting to the Regional Office; Updating the status of work done by the agencies operating at different ports.2) Co-operating with the Regional office and forward the instructions given by the regional heads to the agencies working at ports.3) Tracking the containers lying at port and daily reporting to the Regional heads and respective trade desks regarding the units waiting further for transhipment to other ports so that the storage costs for the containers at those ports can be avoided.4) Following up with the agencies to get the amount collected from the responsible third party for the damage of containers caused by them.5) Remit back the amount collected back to the Shipping Line’s Account, and get the invoices issued from the Headquarters against the specific agencies where such amounts have been collected. Show less

Prashant Iyer Skills

Java Core Java Oracle Html

Prashant Iyer Education Details

  • Kuvempu  University
    Kuvempu University
    Information Technology
  • Niit
    Niit
    Information Technology

Frequently Asked Questions about Prashant Iyer

What company does Prashant Iyer work for?

Prashant Iyer works for Indigo (Interglobe Aviation Ltd)

What is Prashant Iyer's role at the current company?

Prashant Iyer's current role is Business Analyst @ IndiGo | Excel, Power Query, Power BI.

What is Prashant Iyer's email address?

Prashant Iyer's email address is pi****@****sav.com

What schools did Prashant Iyer attend?

Prashant Iyer attended Kuvempu University, Niit.

What are some of Prashant Iyer's interests?

Prashant Iyer has interest in Payumoney, Nearbuy, Sports Promoter, 50 Nerds Of Grey, Humans Of Bombay, Sharan India, Windows, Media Agency, Trust Me, Community.

What skills is Prashant Iyer known for?

Prashant Iyer has skills like Java, Core Java, Oracle, Html.

Who are Prashant Iyer's colleagues?

Prashant Iyer's colleagues are Amritha Nair, Arunima Roy, Ronak Kabra, Ishwar Vaykos, Shreyas ., Sonia Malhotra, Rubi Bhattrai.

Not the Prashant Iyer you were looking for?

  • Prashant Iyer

    Capacity Planning - Amazon | Ex-Pwc Us Advisory | Spjimr | Msu | Nit Nagpur
    Mumbai
  • Prashant Iyer

    Senior Vice President At Hdfc Bank
    Mumbai
    1
    hdfcbank.com
  • Prashant Iyer

    Empowering Australian Cpa Firms With Comprehensive Business Solutions And Business Growth Through Strategic Smsf And Accounting Solutions.
    Ahmedabad
    1
    yahoo.com
  • Prashant Iyer

    Director, Marketing @ Netflix - Films & Series Lead | Growing Audiences And Innovating Constantly
    Maharashtra, India

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.