Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Recognition
Timeline
Generic
PREETAM KUMAR SHRIVASTAV

PREETAM KUMAR SHRIVASTAV

NOIDA

Summary

Dynamic Data Analytics Manager with a proven track record at Sindhuja Microcredit Pvt Ltd, excelling in SQL and data visualization. Expert in optimizing ETL processes and delivering actionable insights, enhancing data quality and efficiency. Strong analytical skills combined with effective communication foster collaboration and drive strategic decision-making.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Analytics Manager

Sindhuja Microcredit Pvt Ltd
Noida
03.2025 - Current
  • Developed stored procedures, functions and triggers to support application requirements.
  • Designed complex reports using SQL Server Reporting Services.
  • Conducted database tuning and performance monitoring to ensure optimal system functionality.
  • Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
  • Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Created data visualizations and reports for management, showcasing findings and recommendations.
  • Created automated reports to visualize financial performance metrics.

Data Analyst

PNB Housing Finance ltd.
NOIDA
12.2021 - 03.2025
  • Conducting in-depth analytics on sales and business data, Leveraged SQL queries to extract, transform and load data into databases.
  • Provide data-driven insights and recommendations to drive strategic across Business and products.
  • Created Stored Procedures for complex business process, SQL Agent jobs, and designed tables by following RDBMS rules.
  • Developed and worked with design, development, implementation JOBS through ETL process on Talend Application and SSIS Packages in SQL Server.
  • Writing Complex SQL queries and conducting data correlations analysis with spreadsheets and extract data from various database.
  • Deploy and Optimize ETL incremental loads, Master Data workflows, Sales & Business data work flows, Hierarchical data and resolving keys to maintain data integrity.
  • Day to day resolve Service Request and close Incident which are raised on Analyst Dashboard by users.
  • Analyze the Business Requirement Document (BRS) to design a conceptual model with SQL, PSQL, Oracle SQL, MS-SQL to develop a solution.
  • Created incremental data load from various sources into SQL Server Database Engine with ETL operation.
  • Developed 5 interactive dashboard visualizations on Tableau Desktop and Tableau Server, focusing on sales, collection, and profit & loss analysis.
  • Create and Publish monthly Business dashboard branch wise for Pan India through Power-Bi.

Senior Executive

Umang Services Pvt ltd. & N.G.T
New Delhi
04.2019 - 12.2021
  • All type MIS and data analysis on excel and extract data through SQL.
  • Involved in generating parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine.
  • Keep tracking record of Cases, support to provide cases details by using SQL query.
  • PPT on MS-office.
  • Provided customer and staff support by managing complaint resolution and ticket creation through the official website as an Application Support Analyst.
  • Email communication with team and client.

Business Associate

Bharti AXA General Insurance
12.2017 - 04.2019
  • Compiling daily reports, preparing MIS on Excel, and submitting them to H.O.
  • Using formula Vlookup, Pivot, Power pivot, sumif, countif, if condition, data validation, color formatting, index match, concatenate, trim, macro etc.
  • Personally visiting bankers and Block officers to gather business requirements and motivate them to insure farmers.
  • Meeting deadlines to successfully close business deals and achieve targets.
  • Supervising District Coordinator and Field Officers to guide and support them for boosting business growth.
  • Liaison with Banks, State Government Officials and Field Staffs, Field Visits, Claims processing.

Education

Data Science Program -

Jigsaw Learning Academy By Sikkim Manipal
Banglore
04.2022

MBA - Finance

Swami Vivekanand Subharatri University
Meerut, U.P
02.2021

Graduation - B.com

B.D College
Patna, Bihar
01.2015

Intermediate - Commerce

01.2012

Matriculation -

01.2010

Skills

  • SQL
  • Tableau
  • PowerBi
  • ETL Process
  • Excel
  • DATA WAREHOUSE
  • DATA ANALYSIS
  • DATA VISUALIZATION

Certification

  • SQL
  • Tableau
  • Data Analytics Overview
  • Stellar performer award for BIU

Personal Information

  • Gender: Male
  • Nationality: Indian
  • Marital Status: Unmarried

Recognition

The Stellar Performer (Most Consistent Performer), I am thrilled to share that I have been awarded by the Managing Director of PNB Housing Finance Ltd for my consistent performance and dedication in handling queries and resolving critical Business Intelligence Unit (BIU) issues. This recognition highlights my efforts in managing dashboards, SQL queries, and ad hoc queries effectively.

Timeline

Data Analytics Manager

Sindhuja Microcredit Pvt Ltd
03.2025 - Current

Data Analyst

PNB Housing Finance ltd.
12.2021 - 03.2025

Senior Executive

Umang Services Pvt ltd. & N.G.T
04.2019 - 12.2021

Business Associate

Bharti AXA General Insurance
12.2017 - 04.2019

Data Science Program -

Jigsaw Learning Academy By Sikkim Manipal

MBA - Finance

Swami Vivekanand Subharatri University

Graduation - B.com

B.D College

Intermediate - Commerce

Matriculation -

Similar Profiles

CREATE PROFILE
PREETAM KUMAR SHRIVASTAV