PINKI SAM
Delhi
Summary
Results-driven Data Analyst with a proven track record at E-Parisaraa Pvt Ltd, leveraging advanced Excel and data visualization skills to deliver actionable insights. Adept at managing financial documentation and enhancing operational efficiency, I excel in problem-solving and fostering strong stakeholder relationships to drive business success.
Overview
7
7
years of professional experience
Work History
Data Analyst
freelancer
01.2021 - Current
- Analyzed large datasets to identify trends and provide actionable insights.
- Created visual reports using data visualization tools for stakeholder presentations.
Accountant Assistant & Office Admin
E-Parisaraa Pvt Ltd
Gurugram
02.2013 - 10.2017
- Managed accounts for specific branch locations and oversaw Vendor Management.
- Served as Office Administrator and Coordinator to streamline daily operations.
- Provided direct assistance to the Chartered Accountant (CA) for financial reporting and audits.
Accountant cum Office Coordinator
Distributor of Ricoh
Rohtak
09.2009 - 01.2013
- Executed comprehensive accounting duties and maintained financial documentation.
- Developed and managed AMC (Annual Maintenance Contract) sheets for contract tracking.
- Generated detailed Job Sheets documenting engineer site visits and project descriptions.
LIC Advisor
LIC
Rohtak
04.2008 - 08.2009
- Analyzed customer needs to sell and recommend suited insurance policies.
Education
Master of Commerce - Finance
Kurukshetra University
Haryana04.2003
Bachelor of Commerce - Computer Vocational
I.B. College
Panipat04.2001
Senior Secondary School Certificate -
Kendriya Vidhalaya NFL Panipat
Panipat04.1998
Skills
- Data Analytics
- Data analysis
- Data visualization
- Power BI
- DAX
- Data Modeling
- SQL querying
- Statistical modeling
- Interactive Dashboards
- Advanced Excel
- Pivot Tables
- VLOOKUP
- Power Query
- Accounting
- Financial reporting
- Tally
- Vendor Management
- Assisting CA
- AMC Sheet Management
- Administration
- Office Coordination
- Staff Management Procedures
- Policy Development
- Software
- MS Office
- Basic HTML
- C
- Problem solving
- Time management
- Business management
- Project management
- Project management
Hobbies and Interests
- Reading
- Computer Surfing to learn new things
- Socializing
Personal Information
- Title: Accountant & Data Analyst
- Date of Birth: 01/31/81
- Gender: Female
- Nationality: India
- Marital Status: Single
Data Analytics Projects
- Finance: Accounts Receivable & Aging Dashboard, To reduce payment delays and visualize company liquidity., Total Outstanding, Overdue Amount, Aging Buckets (0-30, 31-60, 90+ days), Power BI, Excel Power Query, Automated the collection of data from Tally to identify high-risk accounts, improving cash flow forecasting.
- Sales: Revenue Growth & Performance Analysis, To track sales trends across different regions (Gurugram, Rohtak, Panipat)., Year-over-Year (YoY) Growth, Top 5 Clients, Product Margin, Power BI (DAX: CALCULATE, DIVIDE), Pivot Tables, Created an interactive map visual that allowed management to filter sales by 'Year' and 'Policy Type,' identifying a 12% growth opportunity in renewals.
- Operations: Staff Productivity & Job Sheet Tracker, To optimize engineer site visits and project completion rates., Average Response Time, Jobs Completed vs. Pending, Staff Utilization, Advanced Excel (Macros), Power BI, Converted manual 'Job Sheets' into a digital dashboard, reducing the time spent on administrative tracking by 20%.
Timeline
Data Analyst
freelancer
01.2021 - Current
Accountant Assistant & Office Admin
E-Parisaraa Pvt Ltd
02.2013 - 10.2017
Accountant cum Office Coordinator
Distributor of Ricoh
09.2009 - 01.2013
LIC Advisor
LIC
04.2008 - 08.2009
Master of Commerce - Finance
Kurukshetra University
Bachelor of Commerce - Computer Vocational
I.B. College
Senior Secondary School Certificate -
Kendriya Vidhalaya NFL Panipat