Ambesh Pandey
Data Analyst
Gorakhpur,Uttar Pradesh
Summary
Proficient in Data Analysis with 4 year plus experience, implementing statistical techniques and data visualization tools to extract outcomes.
Strong knowledge in Python programming, using Pandas and Numpy for data manipulation and analysis.
Exposure in PostgreSQL for querying and manipulating databases with complex queries.
Competent in Data Visualization using Tableau or Power BI to create visually appealing and informative charts.
Experience in Project Engineering, analyzing technical aspects, coordinating cross-functional teams, and ensuring delivery.
Expertise in developing project plans, setting goals, and managing schedules.
Hands-on Project Management methodologies knowledge along with monitoring progress, identifying risks, and
implementing mitigation strategies for outcomes.
Overview
4
4
years of professional experience
2
2
Certifications
Work History
Business Analyst
Infodrive India Pvt Ltd
8 2023 - 2 2024
- My work here include developing interactive Dashboards and reports , as well as conducting data analysis to support business decision-making
- Data Cleaning: Cleaning the Raw export-import data of across world on weekly basis with the help of the skills such as MS Excel,SQL and power BI
- Created Customer Discount Report on Excel so as to give clarity to sale s associate and sales manager in order to give clarity on giving discount to customer.
Operations Analyst
Extramarks Education Pvt Ltd
01.2023 - 04.2023
- Designed and conducted training programmes with employees in order to improve operations and increase profits.
- Tracked sales performance data and assessed client engagement to improve customer service operations.
- Created Dashboards for Sales Tracking and Talk Time tracking on basis of Associates and Manager
- Sales Forecasting: Directing every sales forecasting activities and making plans to achieve the target in the Region
- P & L Performance: Owning the assigned region's profit and Loss (P&L) performance and driving strategies and activities to maximize revenue, minimize loss and achieve (200%) Profitability targets.
Operation Analyst
Think and Learn Pvt Ltd
04.2019 - 11.2022
- Excel-commands Automation, Data sorting, Manipulation& Presentation.
- Created Sales Dashboard on Daily Tracking and Monthly Tracking for Uttar Pradesh and Bihar Region.
- Reports & Spreadsheet generation through Excel and Power BI.
- Tracking Daily SOP for Business Manager.
- Incentive Calculation, Travel Management & Order Verification of Sales Executives.
- Building & Implementing tracking process for sales team support.
- Collaborated with business and IT groups to establish short-term and long-term goals.
Education
BACHELOR OF ENGINEERING - B.E civil
University of Pune
PuneSkills
Technical Skills:
Database: SQL, PostgreSQL
Software: Excel, PostgreSQL,
Power BI,Python,Pandas,Numpy
Root Cause Analysis
SQL and Databases
Languages
English
Advanced
C1
English
Advanced (C1)
Hindi
Advanced (C1)
Certification
HackerRank SQL Advanced
Work Preference
Work Type
Full TimeLocation Preference
On-SiteAccomplishments
- Process Improvement - Achieved revenue objective by implementing cost-cutting measures.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Software
Postgresql
Power BI
Python
Quote
Every problem is a gift—without problems we would not grow.
Tony Robbins
Timeline
HackerRank SQL Advanced
07-2024
HackerRank SQL Intermediate
07-2024
Operations Analyst
Extramarks Education Pvt Ltd
01.2023 - 04.2023
Operation Analyst
Think and Learn Pvt Ltd
04.2019 - 11.2022
Business Analyst
Infodrive India Pvt Ltd
8 2023 - 2 2024
BACHELOR OF ENGINEERING - B.E civil
University of Pune