Data Analysis and Reporting
Resume:
Dallas, Texas
Nidhi Munjal
*****.*********@*****.***
https://www.linkedin.com/in/munjal-nidhi
SUMMARY
Interned at Southwest Airlines as Reporting and Data Analyst under Safety and Security Department.
4 years’ experience as Business Analyst at Tata Consultancy Services
Strong Experience in advance SQL and programming in analytical tools SAS, R, Tableau, Alteryx
BUSINESS EXPERIENCE
REPORTING AND DATA ANALYSIS INTERN SOUTHWEST AIRLINES May 2017 – Aug 2017
Fetched Safety and Security KPI’s from Teradata(EDW), performed data blending in Alteryx for triggering and report generation.
Developed SQL queries to obtain complex data from tables in remote databases.
Performed root cause analysis for the Airplane damages, its correlation with Airport gates and other factors.
Researched and collected data from a variety of resources to meet standard and ad hoc analysis.
Provided trending reports and visualization of Safety, and operational data to leadership using Alteryx and Tableau
Developed Alteryx app to handle numerous ad-hoc queries and reports to collect and present information requested by customers
BUSINESS ANALYST TATA CONSULTANCY SERVICES Oct 2012 – Jul 2016
Utilized Tableau to create an interactive dashboard for an Investment client to examine the demographic breakdown of customers with different portfolio of products
Contributed to build business dashboards to conduct trend analysis on insurance metrics (KPI), especially relating to driving new business, underwriting speed and customer retention
Used SQL skills to procure customer transaction data from Bank’s database structures to report and analyzed the assimilated data to build customer behavior model.
Succeeded in providing evidence of business solution in the form of Analytics and Mobile application to the Business Requirements of Healthcare Startup company, leading to the award of $5 million contract to TCS
Gathered business requirements by liaising with business users, stakeholders, and Subject Matter Experts (SME’s) and converted Business Requirements into Functional Specifications
Performed research in payment technology on implementing new enhancements, competitor and market analysis for higher management using Gartner Reports, Forrester and Nielson tools
Demonstrated TCS Mobility products, prototypes at executive and technical levels and at pre- and post- sales meetings
TECHNICAL SKILLS
Statistical Tool: R-Programming, MATLAB, Advanced Excel, SAS, STATA, Alteryx Designer Reporting Tools: Tableau, PowerBI, Qlikview Operational: Analytical Solver, XL Miner DBMS: SQL Server, MS Access, Oracle 10g ETL Tools: SSIS, SSAS Programming: D3, C, Java
EDUCATION
M.S. Business Analytics University of Texas at Dallas, GPA 3.72 Aug 2016 – Dec 2017
B.E. Electronics Engineering Maharshi Dayanand University, GPA 3.6 Aug 2008 – May 2012
ACADEMIC PROJECTS
DATA VISUALIZATION OF CAR MANUFACTURER FIRM DATASET USING TABLEAU
Cleansed data by removing outliers and imputed missing values and divided single large data file into two
Visualized clusters in Tableau, hence found top selling car model and target customer segment for the company
DATABASE DESIGN AND IMPLEMENTATION FOR NGO USING MS ACCESS AND MS SQL SERVER
Designed user input forms with validation checks, summary reports and sub-reports using MS access
Stored data in SQL server database by establishing connections between MS access and SQL server
MARKETING PREDICTIVE ANALYTICS – VCA ANIMAL HOSPITALS
Accomplished data cleaning, data pre-processing and clustering on the data from VCA Animal Hospital
Implemented statistical analysis including linear regression, simultaneous equation, price elasticity and Panel Data Analysis
ADDITIONAL AWARDS AND EXPERIENCE
Dean’s Excellence Scholarship Graduate Student Aug 2016 – July 2017
Digital Content Officer The MIS Club Aug 2016 – Dec 2017
Contact this candidate