Sumit Nehra
Mumbai
Summary
Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities.
Overview
2
2
years of professional experience
Work History
Data Analyst
HDFC Bank
Mumbai
01.2023 - Current
- Work as a SQL/SSIS developer, preparing MIS reports as per the business requirements on Power BI, Tableau.
- Developed and Handled BEU/VIRM/VST/VRM channel scorecard from scratch, to view the business performance of the RMs working under HDFC Bank. The automated scorecard involves, creating stored procedures and several ETL tools to save time in generating scorecard.
- Developed daily scorecard for Virtual and HNW channel for daily tracking of the business.
- Optimization and creating checkpoints for existing channel scorecard for reduction in time & ensure correct scorecard deliver to RM's/Fincon .
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Prepared detailed reports by collecting, analyzing, and summarizing information and trends.
- Created data visualizations and reports for management, showcasing findings and recommendations.
- Worked closely with management to prioritize business and information needs.
- Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Created stored procedures for automating periodic tasks in SQL Server.
- Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
- Automated reporting and data processing, significantly reducing manual effort and improving data accuracy across various functions.
- AD-HOC/RM's Query support.
Education
Bachelor of Science - Computer Science
Maharshi Dayanand University
Rohtak08-2021
Skills
- SQL development
- Data visualization
- ETL processes
- Business intelligence
- Database optimization
- Data analysis
- Automation techniques
- SSIS expertise
- Python
- Azure
Languages
Hindi
First Language
English
Proficient (C2)
C2
Accomplishments
- Received Silver Star award for successful project.
Timeline
Data Analyst
HDFC Bank
01.2023 - Current
Bachelor of Science - Computer Science
Maharshi Dayanand University
Similar Profiles
KAMALA SUBRAMANIANKAMALA SUBRAMANIAN
Senior Vice President and Unit Head at HDFC Bank Limited, HDFC BankSenior Vice President and Unit Head at HDFC Bank Limited, HDFC Bank
Vignesh HanglurVignesh Hanglur
Deputy Manager at HDFC LTD/ HDFC BANK LTDDeputy Manager at HDFC LTD/ HDFC BANK LTD
Ramesh GollaRamesh Golla
Sr. Corporate Agency Manager at HDFC Life Insurance Company Limited (HDFC BANK)Sr. Corporate Agency Manager at HDFC Life Insurance Company Limited (HDFC BANK)