Mayank Dwivedi

Operations Associate

Noida, Uttar Pradesh, India7 yrs 11 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

6+ years of experience in data analytics.
Expert in building interactive dashboards and reports.
Strong background in financial and business analysis.

Stackforce AI infers this person is a Data Analytics professional with expertise in Fintech and Business Intelligence.

Contact

mayankdwivedi526@gmail.com LinkedIn

Skills

Core Skills

Data AnalysisBusiness IntelligenceFinancial AnalysisBusiness AnalysisEtl

Other Skills

Amazon S3Analytical SkillsBasic PythonBigQueryCleverTapCore JavaDatabasesExcelGoogle Data StudioHiveMicrosoft ExcelOracle DatabaseRoot Cause AnalysisSASSAS Visual Analytics

About

Experienced Data science professional with demonstrated history of working in the Data Analytics industry | Masters in computer application | Having 6+ Years of experience in the data analytics industry. Bold Profile : https://bold.pro/my/mayank-dwivedi-240229170155

Experience

Paytm

3 roles

Data Analytics Manager

Promoted

Mar 2023 – Present · 3 yrs · Noida, Uttar Pradesh, India · Remote

Own end-to-end P&L analysis at a unit level to identify revenue leakages and drive cost optimization across multiple fintech products.
Lead strategic projects including RuPay Credit Card and UPI Credit Line, handling:
> Configure payment instruments on offline merchants.
> Set merchant-level pricing and rates.
> Create and manage merchant communication.
> Track product performance and own P&L for these offerings.
Build interactive dashboards and reports using Google Data Studio and BigQuery to deliver actionable insights to stakeholders.
Manage and transform master data using Hive and SQL including creation, updates, and cleanup to maintain data hygiene.
Use statistical techniques to interpret data and analyze trends for improving operational and business outcomes.
Work closely with leadership to prioritize business and information needs, aligning data analysis with organizational goals.
Monitor and optimize web analytics dashboards, identifying insights to improve product engagement and drive user growth.
Develop and maintain regular reports to track growth experiments, channel performance, and marketing efficiency.
Lead the tracking and evaluation of marketing campaigns, including KPI analysis using various Business Intelligence tools.
Translate complex data into clear, actionable insights to support data-driven decision-making across product, marketing, and finance teams.

Financial AnalysisBusiness AnalysisGoogle Data StudioBigQuerySQLHive+2

Lead Data Analyst

Aug 2021 – Nov 2021 · 3 mos

Data Analyst

Jun 2019 – Aug 2021 · 2 yrs 2 mos

Working on Google data studio to transform the data into appealing and informative reports for stakeholders.
Create impressive dashboard and reports using BigQuery on data google studio.
Managing master data, including creation, updates, and deletion on Hive and SQL.
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant
amounts of information with attention to detail and accuracy.
Interpreting data, analyzing results using statistical techniques.
Work with management to prioritize business and information needs.
Monitor and evaluate web analytics dashboards and reports, also recommend improvements in the
product for driving growth and better engagement.
Create regular reports to keep a track of growth experiments and channel performance.
Manage the procedure, implementation, tracking and measurement of marketing campaigns.
Deliver regular reports of marketing campaign results, including data analysis and evaluation of KPIs using multiple Business intelligence tools.

Google Data StudioBigQuerySQLData Analysis

Bank of america

Assistant Manager - Data Analytics

Nov 2021 – Mar 2023 · 1 yr 4 mos · Gurugram, Haryana, India

Develop and execute SQL 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.

SQLTrifactaGoogle Data StudioBigQueryData AnalysisETL

Airtel international llp-airtel africa

2 roles

Lead Data Analyst

Promoted

Mar 2019 – Jun 2019 · 3 mos

Lead the whole team of SAS and NRT verticals || Manage a team of data Analyst, SAS Analyst, NRT Specialists || Ensure data quality and integrity || Interpret and analyze data problems Conceive ||
|| Visualize data and create reports || Communicate with country's Revenue heads and close the escalations.

Data Analyst

Apr 2018 – Feb 2019 · 10 mos

Having strong analytical skills with the ability to collect, organised, analyse, and disseminate significant amounts of data information with attention to detail and accuracy, Technical expertise regarding data models, database Queries and data cleansing techniques.
Key Responsibilities & Skills :- SAS, Tableau, SQL, Excel.
Working with Air-tel FMS team as Data Analyst.
Handling multiple data domain at the same time for to support ETL process.
Liaising with offshore teams to provide better and accurate data result set.
Handling queries and analyzing various controls for monitoring fraudulent activities for airtel wallet.
Working on SQL platform where running daily SQL queries for various operational activities.
Working with Citrix software, which enables to access and use the programs which are available under window environment.
Performing various controls and analyzing the same for prevention against revenue leakage.
Sharing the observation/escalation with respective OP-CO(Africa Countries) to ensure the closure of the cases.