Hello! I'm Chetan
Numbers have an important story to tell.
They rely on you to give them a clear and convincing voice.
I'm a Data Analyst.
Chetan Katiyar
DATA ANALYST
Phone:
971-849-0228
956-099-9188
Email:
​
Address:
C-111, First Floor,
Sector-52, Noida, UP-201301
​
Date of Birth:
August 08th, 1984
​
EXPERIENCE
2010-Present
Assistant Manager
JAIPRAKASH ASSOCIATES LIMITED
HO, SECTOR-128, NOIDA
Asst. Manager - Operations/Sales & Marketing
-
Sales and Collection data reconciliation and validation of records.
-
Analyze the bottle necks in work process in Sales Support and provide the solutions.
-
Sound experience in inventory management.
-
Single handily managed records of total Inventory of 50000+ Units across 70+ Projects at 5 Locations.
-
Availability Status Reports - Project/Location wise​
-
Unit Status Reports (Volume and Collection wise)
-
Actual v/s Projected Collection Reports
-
Reports on Inventory and Collection for Board Meetings.
-
-
Various other reports and charts based on Data Analysis
-
Fresh booking inventory check and pre-PAL amendments.
2009-2010
Executive
MAX NEW YORK LIFE INSURANCE
HO-GURUGRAM
Executive - Refunds Team
-
In refund process against Policy cancellation.
-
Co-ordinate with other departments like commercial, accounts and retention team to initiate and complete the refund process within turnaround time.
KEY COMPETENCIES
Strategy, Vision and Mission Planning
Time Management
Strategy, Vision and Mission Planning
Strategy, Vision and Mission Planning
Strategy, Vision and Mission Planning
Creative Thinking
Results Oriented
Initiative
Team Management
Process Development / Management
Leadership
Risk Management & Assessment
Team Building
Data Management
PROJECTS
Project - Jaypee Insolvency Proceedings - Interim Resolution Professional
Duration - Aug 18th 2017 - Present
Responsibility - To supervise the process, analyze the Data and develop Reports for IRP, CoC Meetings
​
-
Supervised a team of 40 member approx from various background for capturing the data.
-
All the captured and clubbed data was checked and arranged in a proper format for further analysis.
-
Coordinated with SAP Support, Commercial and Accounts Department for data required for further analysis and sanitization.
-
After analyzing the data over various parameters like Home Buyers and Financial Creditors, Multiple Claims, FD Holders, Active/Inactive, Relevant v/s non-relevant Projects, Sub Lease Deed Executed; the cases were mapped under respective buckets. The Considered claims were financially analyzed and were distributed under variance bucketing.
-
Correspondence With Customers –
-
Via Letter - More than 1200 letters were sent to Non-relevant Projects and Sub Lease Deed Executed customers, 7000 letters to FD holders were compiled, printed and dispatched in one day.
-
Via Email – Email was sent to the customers whose claim was in variance of more than 10k. Approximately 1300 emails were sent, customers who didn’t responded on the first mail, Reminder 1 and reminder 2 was sent and the final mail was sent to the customers who didn’t responded. A total of approx. 2500 mails were sent. Customer feedback was captured and further analyzed.
-
Project - Impact Analysis of Traffic on Toll Collection, Since Inception, i.e. FY 2012-13 to FY 2017-18
Duration - June 30th 2017 - July 20th 2017
Responsibility - Toll Volume and Collection Analysis (Actual v/s Actual & Actual v/s Projections)
​
-
Growth in Toll collection is analysed and factors accounting for the said growth
-
Growth in volume of traffic across the vehicle categories
-
Combined effect of Revision in Toll Tariff and change in traffic mix captured in the form of average Toll Collection per vehicle for the respective period
-
-
Analysis - Average Toll Collection per Week-Day(Monday --> Sunday)​
-
Growth Analysis - Revenue Growth Analysis over the previous Year, broken-down under Growth due to Volume and Tariff/Mix
-
Quarter wise Revenue Growth Analysis of the FY
-
Revenue Growth analysis on average per day basis
Project - Running Cost Analysis and Projections for operating a Fuel Pump
Duration - May 03rd 2017 - June 02nd 2017
Responsibility - Projection of Fuel and Manpower Cost and Break-Even Point Calculation
​
-
Made few assumptions as Fuel Pump Capacity, Capacity Utilization, Number of Machines, Shift, Shift wise Capacity Distribution, Manpower etc.
-
Projection of Fuel and manpower vs Shift per day for the month.
-
Break-Even Point Calculation - For Volume
-
Manpower Cost Analysis
-
Working Capital Estimation
-
Loan repayment Assumptions and Schedule
-
Profitability
-
Cash Flow
Project - Reconciliation & Analysis of Company's Filed GST
Duration - June 22nd 2017 - July 20th 2017
Responsibility - Analyse and check for any under/over filed GSTR-1
​
-
Complied various System reports on Earned and Utilized GST for the period
-
Analysed the data based on available information
-
Compared the same with filed GSTR figures.
-
Any discrepancy found was reported to respective department for further analysis and correction if required.
Project - Party wise Bill & Revenue Analysis of Facility Vendors at Yamuna Express Way (FY 17-18)
Duration - June 30th 2017 - July 20th 2017
Responsibility - Analysis of Revenue of Vendors and effect of factors like Location and Segment (Food/Non-Food)
​
-
Complied Sale and Collection data of all the Vendors across Yamuna Express Way
-
Comparative Analysis :
-
Segment (Food/Non-Food) Wise,​ for the month and period.
-
Segment and Location Wise, for the month and period.
-
Percentage change in Sale for the month over previous months.
-
-
Effect of traffic at Express way on Facility Vendor Sales.
Project - SAP R/3 (Version ECC 6.0) Implementation
Duration - March 2011 - July 2011
Responsibility - Requirement Analysis, Perform gap analysis, Report Testing - Related to Sales Department
​
-
Requirement analysis and development of the application through interactions with business process owners in relation to legacy and current systems.
-
Involved from blueprint preparation stage of the project to realization and go live/support activities.
-
Testing: Carried out unit, systems, integration, user acceptance and regression testing. (T-Codes and Reports related to Sales Department)
-
Worked on data cleansing, data formatting and data upload activities.
-
Worked with ABAPers to generate customized reports and design Smart forms.
-
Involved in Core User and Super User Trainings
-
Experience in performing gap analysis.
Conducted training sessions on Spread Sheets, Pivots, Conditional Formatting, Data Validation, Reports creation and formatting to internal employees to enhance the work quality.
​
3 Days
2 Sessions a Day
Total of 85 Employees attended the Sessions
​
EDUCATION
2007-2009
Master's Degree
POST GRADUATE DIPLOMA IN BUSINESS MANAGEMENT - IMS, GHAZIABAD
Dual Specialization - Marketing and Operations
Aimed to stay a step ahead of companies’ current needs, and serving to optimize process implementation, but also fundamental support for company management to turn corporate strategy into reality.
2005-2007
Master's Degree
POST GRADUATE DIPLOMA IN COMPUTER APPLICATION - LUCKNOW UNIVERSITY
Visual Basics
Database Management Systems
Internet & Web Page Designing
Object Oriented Techniques with C++
2002-2005
Bachelor's Degree
BACHELOR OF SCIENCE - LUCKNOW UNIVERSITY
Physics and Maths
SKILLS
Microsoft Excel 2013 - Advanced
Microsoft Word 2013 - Advanced
Power Point 2013 - Advanced
Adobe Photo Elements 10 - Advanced
C++ - Advanced
Ubuntu 14.04.1
Python 3.6 - Beginner
Visual Basic - Advanced
EXPERTISE
DATA ANALYSIS
My job as a data analyst isn't just about data interpretations but an effective communication of findings to the management and decision makers so that they can make data-informed choices.
EXCEL - PIVOT CHARTS
Good Knowledge of the tool allows me to easily see comparisons, patterns, and trends and enables me to make informed decisions about critical data in my enterprise.
PHOTOGRAPHY & EDITING
Capture a Memory, Notice details, See the Beauty, Live in the Present, Forget your worries, Share it, Capture the amazing range of Love and Emotion, Make Art, Express Yourself, Tell a Story, Capture an Adventure, Learn more about yourself, capture a feeling not just an appearance
Yes, I Love it.
QUOTES
"Any powerful idea is absolutely fascinating and absolutely useless until we choose to use it."
-Richard Bach
Writer
"In the end you should only measure and look at the numbers that drive action, meaning that the data tells you what you should do next."
-Alex Peiniger
CEO at Quintly
”The path to any actionable insight doesn’t come in one single form. There are many different elements in play, and they are always changing - business goals, technologies, data types and sources, and then some are in a state of flux. Each path to analytics insight should be individually paved with an outcome-driven mindset.“
-Surjit Swain
Head of Advanced Analytics
The Coca Cola Company
"If we have data, let’s look at data. If all we have are opinions, let’s go with mine."
-Jim Barksdale
former Netscape CEO
"Everybody has certain red flags they want to keep an eye on, and big data tools enable you to do that in fairly close to real time."
-Brian Loughman
Leads the financial reporting investigations team of Ernst & Young’s Fraud Investigation & Dispute Services practice