Ankur Dhar Dwivedi
Bhopal
Summary
Business Analyst versed in data mapping and user acceptance testing, as well as solving complex problems in high-pressure environments. Excels at cultivating, managing, and leveraging client relationships. Solution-focused professional employs analytical mindset to evaluate and improve current systems. Proven success lowering costs and boosting efficiency. Detail-oriented while maintaining understanding of big picture. Detail-orientated Analyst adept at making critical decisions, managing deadlines, and conducting team reviews. With expertise in analysis and quantitative problem-solving skills, dedicated to company growth and improvements.
Overview
5
5
years of professional experience
1
1
Certification
Work History
MIS Executive
1digitalstack.ai
07.2023 - Current
- Creating reports, Pitching Dashboards for clients like HP, HAVAS & GLAMBIA Etc., By using POWERBI & EXCEL. Doing ETL in keystone Data Extraction from METABASE doing PFM with data.
- By using SQL writing queries and taking data from METABASE
- Preparing Data Quality Confirmation (DQC) to highlight the Average Price, Rating & Rating Count, SOV Organic & SOV Sponsored with Graphs.
- Preparing Category Analysis for New Clients who are enthusiastic to generate revenue with Ecommerce Channels.
- Preparing Forecast for Clients to know about past and current performance after doing analysis
- we suggest Clients to invest on such keywords and it helps to reduce advertising cost and to grow on revenue side
- By using Python with the help of ASIN we are crawling Brand Name and Categories.
- Conducted root cause analysis to formulate countermeasures to business mistakes and improve operations.
- Collected, tracked, and evaluated current business and data to stay abreast with market trends.
- Created dashboards and visualizations to present data insights in an easy-to-understand format.
- Maintained a database of customer information, including contact details, preferences and purchase histories.
Manager
Masitor Technology Company
Delhi
01.2019 - 01.2022
- Managed a comprehensive fluid system related to water fountains, both musical and stationary, from 2019-2022
- Designed and implemented new water fountain systems, both for indoor and outdoor installations, based on client specifications and budget constraints
- Conducted regular maintenance and servicing of existing water fountain systems to ensure optimal performance and safety
- Collaborated with contractors, vendors, and other stakeholders to ensure timely completion of projects and adherence to safety regulations and environmental standards
- Managed a team of technicians and support staff, including scheduling, training, and performance management.
Education
MTECH - Hydropower Engineering
NIT BHOPAL
01.2018
BE - Mechanical Engineering
UIT BU BHOPAL
01.2015
XII -
JAWAHARLAL NEHRU SCHOOL
01.2010
X -
AGARWAL PUBLIC SCHOOL
01.2008
Skills
- Strong technical knowledge in MS Excel
- Power BI
- SQL
- Python (Beginner)
- Experience in managing small to medium scale projects
- Dashboard creation
- Data Analytics
Certification
- AutoCAD - CRISP(2012)
- CATIA - CRISP(2013)
- Power BI (udemy currently pursuing)
Accomplishments
- Silver Medalist in Bhopal university batch 2015
- TCS - Assistant System Engineer 2015
- Qualified Madhya Pradesh Junior Engineer Exam 2016
- Qualified GATE for 4 years continuous - 2015, 2016, 2017, 2018
- Qualified Airport Authority of India Junior Assistant(Fire Service) - 2022
Areas Of Interest
- Automobiles
- Reading
- Travelling
- Current Affairs
Projects
- Project involvement in social media platforms like Facebook and Instagram for brands such as LOR and NESCAFE, analyzing ad numbers, traffic, and posts, and comparing them with competitors using tools like SEMRUSH and Google Analytics.
- Conducting root cause analysis to identify business mistakes and formulate countermeasures for operational improvements.
Languages
Hindi
First Language
English
Proficient (C2)
C2
Timeline
MIS Executive
1digitalstack.ai
07.2023 - Current
Manager
Masitor Technology Company
01.2019 - 01.2022
MTECH - Hydropower Engineering
NIT BHOPAL
BE - Mechanical Engineering
UIT BU BHOPAL
XII -
JAWAHARLAL NEHRU SCHOOL
X -
AGARWAL PUBLIC SCHOOL
- AutoCAD - CRISP(2012)
- CATIA - CRISP(2013)
- Power BI (udemy currently pursuing)
Similar Profiles
Karan SinghKaran Singh
Senior Account Lead at 1digitalstack.aiSenior Account Lead at 1digitalstack.ai
Ravindra KushwahaRavindra Kushwaha
Assistant Hospital Manager at Gandhi Medical College (Hamidia Hospital)Assistant Hospital Manager at Gandhi Medical College (Hamidia Hospital)
ANUKRITI SINGHANUKRITI SINGH
SOLUTIONS ARCHITECT at Amazon Web ServicesSOLUTIONS ARCHITECT at Amazon Web Services