Vivek Srivastava
Noida
Summary
Data Analyst with hands-on experience in SQL, Power BI, Python, and Advanced Excel, specializing in data validation, automation, and business reporting within the financial and asset management domain. Proven ability to improve data accuracy, automate manual processes, and deliver actionable insights through dashboards and reports. Experienced in working with multiple clients, managing end-to-end data pipelines, and collaborating with stakeholders to support data-driven decision-making.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst
Equipped Analytical Intelligence
Noida
06.2024 - Current
- Performed data standardization, reconciliation, and mapping by validating cash and bank balances and implementing subtype changes across multiple service providers.
- Ensured data quality and integrity through validation checks, business logic controls, and reconciliation processes before loading data into the Data Warehouse.
- Designed and owned interactive dashboards and reports using Power BI, SQL, and Advanced Excel for asset and fund management, weekly business reporting, KPI tracking, revaluation analysis, and tail sale analysis.
- Automated manual data ingestion and benchmark rate processing using Python, significantly reducing operational effort and risk of missed updates.
- Developed and scheduled Python automation scripts to fetch benchmark and market rates (including SONIA) via web scraping and cron jobs.
- Implemented Azure Functions (Timer and Blob Triggers) to automate rate refreshes and file-based data processing workflows.
- Designed database schemas and tables across Base, Stage, and Client layers to support scalable ETL pipelines.
- Built and optimized SQL Server stored procedures for Minerva CRM, improving query performance and enabling efficient execution of business processes.
- Developed end-to-end pipelines to process client files from Azure Blob Storage, execute transformations, and trigger automated email notifications.
- Conducted end-to-end and integration testing to ensure reliability and accuracy of data pipelines.
- Created comprehensive technical documentation and user manuals, including stored procedure mappings, process flows, and CRM usage guides.
- Collaborated directly with clients to analyze requirements, resolve production issues, and deliver timely enhancements.
Data Analyst Intern
Equipped Analytical Intelligence
Noida
12.2023 - 06.2024
- Performed data reconciliation and validation by cross-checking source and target files and correcting discrepancies in SQL Server databases.
- Automated BOD pack generation and manual reporting tasks using Python and Excel.
- Developed Power BI dashboards and reports for asset and fund management analysis, enabling stakeholders to track KPIs and business performance.
Executive – Customer Support
Indica Industries Private Limited
Noida
03.2019 - 12.2023
- Managed automotive and medical clients, handling customer queries and issue resolution via email and chat.
- Supported New Product Development (NPD) activities and coordinated with cross-functional teams.
- Participated in ISO 9001:2015 and IATF 16949:2016 audits, ensuring process compliance and documentation readiness.
Education
B.Tech - Mechanical Engineering
Inderprastha Engineering College
Ghaziabad01.2017
12th (Science & Mathematics) -
New Way School
Lucknow01.2013
10th -
New Way School
Lucknow01.2011
Skills
- Data validation and quality
- Data reconciliation and reporting
- Business intelligence and analysis
- SQL Server and MySQL
- Stored procedures and joins
- CTEs and window functions
- Power BI
- Advanced Excel techniques
- Pivot tables and lookups
- Python programming and Pandas
- Automation and web scraping
- Cron jobs and Azure functions
- Azure Blob Storage management
- Data warehousing strategies
- Requirement gathering and stakeholder communication
- Problem solving and documentation
Certification
- Microsoft Azure Fundamentals (AZ-900), https://learn.microsoft.com/api/credentials/share/en-gb/viveksrivastava-8025/CE5A36E6293FF0AB?sharingId=9F0D84D2B510C667
- Microsoft Data Fundamentals (DP-900), https://learn.microsoft.com/api/credentials/share/en-gb/VivekSrivastava-1754/4BEFF4546C05ADBA?sharingId=81E2E6D86DCCB99F
Timeline
Data Analyst
Equipped Analytical Intelligence
06.2024 - Current
Data Analyst Intern
Equipped Analytical Intelligence
12.2023 - 06.2024
Executive – Customer Support
Indica Industries Private Limited
03.2019 - 12.2023
B.Tech - Mechanical Engineering
Inderprastha Engineering College
12th (Science & Mathematics) -
New Way School
10th -
New Way School