Resume

Sign in

Data Analysis and Reporting

Location:
Dallas, Texas, United States
Posted:
January 12, 2018

Contact this candidate

Resume:

**** ******** ****

Dallas, Texas

Nidhi Munjal

+1-214-***-****;

ac30kp@r.postjobfree.com

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