ankur

ankur

Data Analyst | Senior VBA Developer | Team Leader | MIS Specialist | Immediate Joiner | Looking for Job | MIS Manager...
India
English, Hindi

About Me

Result-oriented Professional with over 8 years of experience in Data Analysis,Data Analytics,Data Management,Data Validation,Data Mining,VBA Macros,Power Query,Power Bi-Desktop,Google Scripting,Google Analytics,Google Da…

Experience

Sr. Data Analyst

Fortuna Retail Pvt Ltd, Gurugram [Internet (E-Commerce of Gems & Jewellery Company)]
Jan 2017 - Present · 9 years 5 months

 Experience in leading and managing teams (comprised more than 15 people) across different areas, including
Reporting, Catalogue, Designing and Testing.
 Collaborated with cross-functional departments to understand the problems, and came up with systematic solutions
leveraging IT systems and technology.
 Streamlined processes and improved efficiency within organization by implementing VBA Macros and Apps Script
for multiple teams that saved 70-80 hours on monthly basis, for example- developed VBA-enabled HR System for
attendance record and automated reports for marketing team which saved their time 60% time weekly.
 Conducted Data Analysis as per business needs (like Competitor Analysis) and find trends, exceptions for reporting.
 Created workflow systems, FMS systems, and other systems via Google forms and Google sheets that provide key
reports and data to ensure that business needs are met effectively.
 Used Advance Excel, VBA Macros, Google Apps Script and more to automate MIS reports.

Sr. Data Analyst

Fortuna Retail Pvt Ltd, Gurugram
Jan 2017 - Jul 2023 · 6 years 6 months

Leading and managing teams of more than 15 people across Reporting, Catalogue, Designing and Testing.
Collaborating with cross-functional departments to understand problems and come up with systematic solutions leveraging IT systems and technology.
Streamlining processes and improving efficiency by implementing VBA Macros and Apps Script for multiple teams.
Developing a VBA-enabled HR system for attendance record.
Automating reports for the marketing team.
Conducting data analysis as per business needs, including competitor analysis, and finding trends and exceptions for reporting.
Creating workflow systems, FMS systems, and other systems via Google Forms and Google Sheets to provide key reports and data.
Using Advanced Excel, VBA Macros, Google Apps Script and more to automate MIS reports.

MIS Officer

Triumph Auto Parts Distributors Pvt Ltd, Gurugram
May 2016 - Jan 2017 · 8 months

Made reports, templates using Advance Excel & VBA Macro-coding.
Created Reports related Sales (DSR, WSR & MSR), P&L, Import & export.
Result-oriented Professional with over 8 years of experience in Data Analysis,Data Analytics,Data Management,Data Validation,Data Mining,VBA Macros,Power Query,Power Bi-Desktop,Google Scripting,Google Analytics,Google Data Studio,Appsheet,Google Sites,MIS Reporting,Data Extraction

MIS Officer

Triumph Auto Parts Distributors Pvt Ltd, Gurugram
May 2016 - Jan 2017 · 8 months

Making reports and templates using Advanced Excel and VBA Macro-coding.
Creating reports related to Sales (DSR, WSR & MSR), P&L, Import & export.

MIS Executive

Tikona Infinet Ltd, Noida
Mar 2015 - Mar 2016 · 1 year

Worked on Excel, Outlook & PowerPoint.
Worked as Billing Executive, maintained Attendance of 25 outlets.
Worked as admin executive & MIS Executive.
Result-oriented Professional with over 8 years of experience in Data Analysis,Data Analytics,Data Management,Data Validation,Data Mining,VBA Macros,Power Query,Power Bi-Desktop,Google Scripting,Google Analytics,Google Data Studio,Appsheet,Google Sites,MIS Reporting,Data Extraction

MIS Executive

Tikona Infinet Ltd, Noida
Mar 2015 - Mar 2016 · 1 year

Working on Excel, Outlook and PowerPoint.
Working as Billing Executive and maintaining attendance of 25 outlets.
Working as admin executive and MIS Executive.

Skills

Advanced MS-Excel VBA Macros Visual Basic of Application Basic SQL Power Query Power BI Desktop DAX Google Forms Google Sheet Google Apps Script Google Analytics Strategic Planning Documentation Google Data Studio Google AppSheet Google Sites Written Communication Verbal Communication Presentation Skills Analytical Skills Story Telling Problem-Solving Innovative Thinking Decision Making
Report this Profile?