VIJAY KUMAR
DATA ANALYST
Summary
Highly motivated and detailed-oriented candidate passionate about using data to improve business performance and customer experience. Skilled at leveraging data to develop actionable solutions to business challenges and utilizing data mining and data visualization to create meaningful insights. Excellent technical aptitude and knowledge of programming languages, data analytics and data visualization.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst Intern
UNIFIED MENTORS
07.2024 - 08.2024
- Worked on Amazon Sales Analysis(Project) where we converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
- Assisted management in making informed decisions by presenting clear and concise reports detailing analytical findings.
- Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
- Identified trends and patterns in complex datasets through exploratory data analysis, leading to actionable insights.
- Optimized database queries, significantly speeding up data retrieval times for analysis.
Billing Manager
Professional Courier Networks Ltd.
12.2022 - 11.2023
- Handle the 12 members of my team.
- Oversee the preparation of statements and bills
- Flash sales each month by maintaining MIS Reports
- Maintain good business terms with our BA, FR, and DP clients
- Working with client's monthly project and close on time
- (ICAI, SILVERZONE AND DAINIK BHASKAR)
- Maintain and/or ensure maintenance of client records related to invoicing and bill payment
- Trained and mentored staff on procedures, compliance requirements, and collections techniques.
- Draft and distribute weekly reports of invoicing and billing metrics
- Advise staff on proper, legal parameters for collections practices
- Provide customer support to customers with disputes or inquiries concerning invoices or the billing process
Commercial & Billing Executive
DTDC Express Ltd.
08.2018 - 11.2022
- Developed comprehensive reports on billing activities for senior management, enabling informed decision-making regarding departmental goals and strategies.
- MIS Reports- Maintaining the Excel sheets
- Streamlined billing processes by implementing automated systems, reducing errors and improving efficiency.
- Create MIS report of Daily Sales of South Delhi & Gurgaon Region
- Creating new code for the client by detail correction
- Data Utilization report, Preparation of Billing Data
- Looking separately at the special product of DTDC PLUS which shipment updating mode type & rate in CTBS (billing Software) for billing
- Coordinate/Visit with clients on each and every issue to maintain business relations
- Bill submission through E-invoice and collect payments
Client Relation Executive
DTDC Express Ltd.
06.2017 - 07.2018
- Follow up with clients' package pick up and arrange delivery on time
- Arrange official business meetings regarding the review of clients and problems faced
- Enhanced customer satisfaction by resolving inquiries effectively and efficiently.
- Arrange to pick up of pan India Daily basis and arrange delivery
- Updating files and folders of under and new proposals
- Work on clients' monthly projects and closed my all project on time
- Share NDR and list of Pending Data to all clients on a daily basis
- Manage ODA or Sale tax file Report to share with Manager and Corporate team
- Attend weekly, monthly, and quarterly internal meetings to discuss and improve the working style
- Helped large volume of customers every day with positive attitude and focus on customer satisfaction.
- Reduced customer complaints with proactive issue identification and resolution strategies.
- Preparation of monthly report of production
- Sharing Monthly All Client Reports, KPI files, TAT failure Reports, and Fake & lost or damaged data files
- Review and report all fake or lost data to make penalties on a concerned branch
Education
The Complete SQL Bootcamp: Go From Zero To Hero - SQL
UDEMY
ONLINE 04.2001 -
BOOTCAMP FOR DATA ANALYTICS - Data Analytics
CODEBASICS
04.2001 -
MBA - Finance
HIMALAYAN UNIVERSITY
04.2001 -
Bachelor of Accounting - Finance
DELHI UNIVERSITY
DELHI 04.2001 -
Skills
Data cleaning
AdvExcel functions
Data Visualization
Power BI
ETL processes
Data storytelling
Data integration
SQL and databases
Problem-solving
Analytical skills
Decision-making
Problem-solving abilities
Active listening
Machine learning
Disclaimer
I hereby declare that the above-written particulars are true to the best of my knowledge and Belief.
Certification
Introduction to Career Skills in Data Analytics
Timeline
Data Analyst Intern
UNIFIED MENTORS
07.2024 - 08.2024
Introduction to Career Skills in Data Analytics
07-2024
Billing Manager
Professional Courier Networks Ltd.
12.2022 - 11.2023
Commercial & Billing Executive
DTDC Express Ltd.
08.2018 - 11.2022
Client Relation Executive
DTDC Express Ltd.
06.2017 - 07.2018
The Complete SQL Bootcamp: Go From Zero To Hero - SQL
UDEMY
04.2001 -
BOOTCAMP FOR DATA ANALYTICS - Data Analytics
CODEBASICS
04.2001 -
MBA - Finance
HIMALAYAN UNIVERSITY
04.2001 -
Bachelor of Accounting - Finance
DELHI UNIVERSITY
04.2001 -