Priya Sinha
DATA ANALYST/BUSINESS ANALYST
Bengaluru,KA
Summary
Driven by a passion for financial analysis and a knack for strategic growth, I leveraged POWER BI and advanced Excel at HDFC Bank to enhance customer financial insights, boosting income by 400%. My adeptness in relationship management and technological proficiency, including SQL and TABLEAU, have consistently propelled business improvement and client satisfaction.
Overview
9
9
years of professional experience
Work History
Financial and Banking Analyst,Relationship Manager
HDFC Bank
09.2023 - Current
- I achieved my income by 400% by developing dashboard of POWER BI in order to get insight about financial behaviour of customer and target them accordingly to increase the revenue of bank.
- Kept huge database of customer by using Adanced EXcel tool and MY SQL.
- Increased client satisfaction, providing insightful recommendations based on comprehensive market research by using the tool of POWER BI
- Reviewed and analyzed project spending throughout project life cycle.
- Championed the adoption of cutting-edge financial analysis tools and technologies, elevating team''s capabilities and fostering a culture of continuous improvement.
- Led due diligence efforts for prospective investment opportunities, ensuring all transactions aligned with organizational risk tolerance levels and strategic objectives.
- Designed compelling sales presentations to showcase key benefits of banking products to prospective clients, leading to increased conversion rates.
- Developed and maintained dashboards of "TABLEAU" to monitor key performance indicators, providing insights to senior management.
ASSISTANT MANAGER
Canara Bank
05.2015 - 10.2020
- Collaborated with the management team to develop strategic plans for business growth and improvement.
- Maintained database of customer by using various MY SQL databases in order to target potential customer to increase revenue of bank.
- Worked in varuious projects of govt:-
- Demonetization
- Sukanya Yojana
- APY
- MUDRA Yojana
- created the dashboard by using power BI to develop the insight about financial behaviour of customer .
Education
DATA AND BUSINESS ANALYST CERTIFICATION -
EXCLER INSTITUTE
Bengaluru, India 05.2001 -
DATA AND BUSINESS ANALYST -
IBM CERTIFICATION
05.2001 -
DIGITAL MARKETING CERTIFICATION -
EXCLER INSTITUTE
Bengaluru, India 05.2001 -
DCA IN COMPUTER
B.COM /(HONS) - COMMERCE
PATNA UNIVERSITY
PATNA 05.2001 -
Skills
* SQL ( MY SQL) DBMS,PARAMETER,JOINTS,FUNCTION,OPERATOR,CONSTRAINTS,TRIGGERS,STORED OBJECTS,ERROR HANDLING)
*TABLEAU
Dashboard creation,Data combining technique,filtration,Action,Calculative fields,parameters,custom charts,LOD,Forecasting
*MICROSOFT POWER BI
Relationship modelling,Dashboard,conditional formatting,slicer,DAX,Tooltip,Drilldown,Bookmark,power query
*ADVANCED EXCEL
Functions,V lookup,H lookup,X lookup,X matchup ,Nested V lookup,Data cleaning,Gantt and waterfall chart,pivot,power pivot ,power query,Macros,VBA loops
Search Engine Optimization
Search Engine Marketing
Social Media Marketing
Lead Generation
Design Thinking
Campaign Management
*PROJECTS
CUSTOMER SALES ANALYSIS- personal project DEC 2023
Utilized SQL to extract data from 10 different related tables from customer sales databases using JOIN and VIEW
Transformed and filtered data by using aggregating and filtering function to improve reporting process
Loaded and visualized data with power BI to identify key business intelligence that can improve sales performance
BENEFIT PACKAGE BENCHMARKING DASHBOARD-Virtual client's project
Created a dashboard with Power Bi to help client compare between different employee benefit packages
Transformed and processed client's data by using DAX and Excel to ensure data completness and validity
Provide technical insights on how the client can fully utilize their data by introducing different technologies
Consulted with client to detemine the best metrics to be displayed on final product
PROJECT BY ABIN VARIANT COMPANY
INSIDE PROJECT OF HDFC BANK TO CREATE MORE SALES BY USING TABLEAU DASHBOARD
Languages
English
Hindi
Timeline
Financial and Banking Analyst,Relationship Manager
HDFC Bank
09.2023 - Current
ASSISTANT MANAGER
Canara Bank
05.2015 - 10.2020
DATA AND BUSINESS ANALYST CERTIFICATION -
EXCLER INSTITUTE
05.2001 -
DATA AND BUSINESS ANALYST -
IBM CERTIFICATION
05.2001 -
DIGITAL MARKETING CERTIFICATION -
EXCLER INSTITUTE
05.2001 -
B.COM /(HONS) - COMMERCE
PATNA UNIVERSITY
05.2001 -
DCA IN COMPUTER