SAS, SAS SQL, SAS MACROS (procedures including Univariate & Multivariate Analysis, Simple & Multiple Linear Regression, Logistic Regression, Anova, Post-Hoc Analysis, T-test, Correlation, PROC GLM, Graph and Plot, Tableau, Power BI, Excel

Key Skills

SAS
Tableau Visualization
Power BI
Excel

Professional Experience

Feb 2022
Present
Executive
InterGlobe Aviation Ltd Gurugram, IN
Aviation Industry
Capacity, Revenue & Budget planning of IndiGos resources for 70+ Airports & 250+ Aircrafts. 
 
 Liaison with multiple stakeholders like Airport managers, cargo, engineering, flight ops & FP&A.
 
 Performed analytics on complex network expansion data (new destinations, frequency change, up- gauging), connectivity analysis & Automation for efficient repetition of any analysis performed.
 
 Data Analytics to increase revenue, Customer Satisfaction & Identification of data-driven opportunities to drive business value through actionable insights, and engage in conversations with multiple stakeholders through Mathematical & Statistical approaches, Business Domain Context & Market research.
 
 Prepared story-telling dashboard on Power BI for Top management backed by ad-hoc analysis, research, projects and presentations.
 
 Managed multiple projects on Cost savings & increased passengers satisfaction.
Sep 2018
Mar 2022
Data Analyst
5One Analytics Pvt. Ltd. Gurugram, IN
Analytics Industry
  3 years of industry experience in analytics and developing Models.
 Extensive knowledge of advanced SAS/STAT procedures including Univariate & Multivariate Analysis, Simple & Multiple Linear Regression, Logistic Regression, Anova, Post-Hoc Analysis, T-test, Correlation, PROC GLM, Graph, and Plot.
 Data Analyst with total 3 years of experience in SAS Programming. Possess extensive data and statistical analytical skills experience.
 Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading, and reporting and for visualization used Tableau and Power BI.
 Developed new or modified existing SAS programs to load data from the source and create study-specific datasets.
 Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH and SAS/ACCESS in Windows environments.
 Strong ability to write SQL queries using PROC SQL.

Education

Jun 2015
Jul 2018
Bachelors of Science (B.Sc) in IEC University
IEC University

Certifications

2021
SAS Certified
SAS
2022
SQL for Data Analysis
Linkedin
2022
Power BI: Dashboard for beginners
Linkedin
2021
Tableau Desktop
PST Analytics

Hobbies & Interests

  • Traveling

Languages

English
(Fluent)
Hindi
(Native)

Get in touch with Karan