Summary
Overview
Work History
Skills
Certification
Education Qualifications
Personal Information
Languages
Timeline
Generic
Mayank Dwivedi

Mayank Dwivedi

Noida

Summary

  • Highly skilled Data Analytics Professional with a proven track record of implementing data-driven strategies that drive business growth. Strong expertise in creating and analyzing large datasets. Lead cross-functional projects using advanced data techniques and analysis to discover insights that will guide strategic decisions and uncover optimization opportunities.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analytics Manager

One97 Communication Pvt Ltd
Noida
03.2023 - Current
  • Leading Chief business officer control office data analytics team.
  • Identifying trends in financial performance and provide recommendations for improvement. Coordinate with other members of the finance/business team to review financial information and forecasts for our business vertical.
  • Using statistical methods to analyze data and generate useful Business/Financial reports.
  • Having expertise to create informative, actionable financial dashboards that highlights relevant financial trends and opportunities for improvement.
  • Analyzing large datasets to identify trends and patterns using SQL.
  • Partner directly with the finance team and central FP&A groups to collaborate on data metrics, business goals, and business reviews.
  • Proficiency to create manual/Automated reports & dashboards using query languages such as SQL & Looker.
  • Dive deeply into financial data(P&L) and become a subject matter expert to provide additional insights.
  • Developing and implementing data analytics strategies to ensuring data accuracy and accessibility.

Lead Data Analyst

Bank of America
Gurugram
11.2021 - 03.2024
  • Develop and execute SQL & SAS scripts to support ETL activities and sampling under enterprise independent testing automation analytics team
  • Need to automate risk & compliance KPIs with the help of SQL and some automation tools
  • Need to perform data mining, cleaning, filtering and enrichment according to given procedures
  • Need to collect data from different sources and perform ETL processes on it
  • Using some Automation & visualization tools (Trifacta & GDS) to develop the sample flows and dashboards for multiple teams
  • Proficiency to create reports, dashboards & development logics using query languages such as SQL, Big-Query, SQL Server
  • Responsible for ongoing execution and delivery of testing data samples in respective work stream
  • Need to perform data extractions, scripting, data sampling and analysis using various data sources to support compliance testing across bank's enterprise.

Lead Data Analyst

One97 Communication Pvt Ltd (Paytm)
Noida
06.2019 - 11.2021
  • Create informative, actionable and repeatable reporting that highlights relevant business trends and opportunities for improvement
  • Managing master data including creation, updates and deletion
  • Use statistical methods to analyze data and generate useful business report
  • Analyze data and provide suggestion for business growth
  • Working on hive (SQL) to abstract the data to fulfill the business requirements
  • Proficiency to create reports, dashboards using query languages such as SQL, Big-Query
  • Build Business dashboards using visualization tools such as Google Data Studio
  • Manage the procedure, implementation, tracking and measurement of marketing campaigns
  • Deliver regular reports of marketing campaign & data analysis and evaluation of KPIs using many BI tools.

Data Analyst

Bharti Airtel - Africa Unit
Gurgaon
04.2018 - 06.2019
  • Working with Airtel Fraud Management System Team (Africa Unit) team as a Data Analyst.
  • Handling SQL queries and analyzing various controls for monitoring fraudulent activities for Airtel money wallet.
  • Monitoring NRT-Trend for fraudulent activities for Airtel wallet with the help visualizations tools like: - SAS, Tableau.
  • Creating Reports and Dashboard using visualizations tools for business growth & review teams.
  • Handling multiple data domain at the same time for to support ETL process.
  • Performing various controls using SQL Queries and analyzing the same for prevention against revenue leakage.
  • Working on SAS to analyzing the cases for various fraudulent activities over transaction.
  • Sharing the observations/escalations with respective OPCO (Africa Countries) to ensure the closure of the case.
  • Directly work with stakeholder and doing root cause analysis according to requirement and case

Skills

  • Data Analysis and Visualization
  • Statistical & Financial Analysis
  • Data Mining
  • SQL
  • Python
  • Google Data Studio & Looker
  • Data Quality Management
  • Dashboard Development

Certification

  • Professional Internship Done at Wipro technologies Pvt Ltd (Yr - 2017).
  • Certification done in Web Development from IIT-Bombay (Yr - 2016).
  • Certification done in Java Developer from Ducat India Pvt Ltd. (Yr - 2018).
  • Multiple Certification done in Data Analytics from Udemy. (Yr 2022-23).

Education Qualifications

  • Master in Computer Application (MCA) From Abdul Kalam Technical University Lucknow, July 2018.
  • Bachelor of Computer Application (BCA) From CSJM University Kanpur, June 2015.

Personal Information

Date of Birth: 05/05/96

Languages

  • English
  • Hindi

Timeline

Data Analytics Manager

One97 Communication Pvt Ltd
03.2023 - Current

Lead Data Analyst

Bank of America
11.2021 - 03.2024

Lead Data Analyst

One97 Communication Pvt Ltd (Paytm)
06.2019 - 11.2021

Data Analyst

Bharti Airtel - Africa Unit
04.2018 - 06.2019

Similar Profiles

CREATE PROFILE
Mayank Dwivedi