SQL
Hi, I’m
Ipsita Padhy
Bangalore,bangalore
Summary
Seasoned Business Analyst offering 4+ years of BFSI industry success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making.
Overview
6
years of professional experience
5
years of post-secondary education
3
Certifications
Work History
Coface India Credit Management Services
Business Analyst
05.2023 - Current
Job overview
- Improved business direction by prioritizing customers and implementing changes based on collected feedback.
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Performed gap analysis to identify areas of improvement.
- Generated business intelligence reports to inform strategic decision-making.
- Provided technical support for troubleshooting analytics and reporting issues.
- Implemented business intelligence solutions to increase operational efficiency.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
SBI Life Insurance
Business Analyst
10.2019 - 03.2023
Job overview
- Analyzed open orders, backlog, and sales data to provide sales team with insights.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Delivered analysis of market, sales and consumer trend impact on long and short-term strategies.
- Drafted reports on company financial metrics to assess successes and account for deficiencies.
- Created dashboards to monitor and track key performance indicators.
- Generated standard and custom reports to provide insights into business performance.
- Designed and developed data pipelines to acquire, clean and process data.
HDFC Life
Senior Corporate Agency Manager
07.2018 - 09.2019
Job overview
- Handled10 branches of HDFC, developed strategies to selling insurance products
- Monitored KPIs and optimized parameters, achieved140%growth in sales of products
- Trained10+people to build high performance sales team for stakeholders
- Analyzed weekly, monthly trends for identifying the sales source, budget and optimized revenue analysis.
ICICI BANK LTD.
Branch Relation Officer
09.2013 - 11.2014
Job overview
- Handling day to day cash and cheqe clearing
- Handled promoters' management across new launched products
- Maximized sales across Mutual Funds, Demat Accounts, and health insurance
- Handling Retail loan (Personal loan, Gold Loan, Housing loan, Auto loan)
Education
Carlson School of management
PGP in Business Analytics, Data Analytics, Business Analytics with Excel, Business Analytics with SQL, Tableau and POWERBI
08.2022 - 05.2023
Berhampur University
Postgraduate in Banking Management, Macroeconomics, Advance Data Analysis, Financial Management, Forex Banking, Product and Brand Management
08.2012 - 05.2014
University Overview
GPA: 7/10
Berhampur University
Bachelor of Economics, Development Economics, Macro and Microeconomics, Statistics, Money and Financial Market, Monetary Economics
08.2009 - 05.2012
University Overview
GPA: 7.5/10
Skills
Customer Needs Assessment
Gap Analysis
Workflow Analysis
Quality Assurance
Business Process Mapping
Predictive Modeling
Requirements Gathering
Data Analysis
Business Process Improvement
Stakeholder Management
Project Management
Release Planning
Test Case Scenarios
Certification
Simplilearn SQL Certification(Oct2022-Nov2022) Learned Window functions,Views,Subquery,Stored Procedures, Fact and Dimensions table
Projects
Ecommerce Analytics and Dashboard Project, 10/01/22, Identified trend across monthly regional sales and performance
Analyzed Profit margin of the products and profit-loss distribution
Created Visualization across different metrics of data using Excel
projectlink-EcommerceDataAnalysis
Software
Power Bi
Tableau
Timeline
Business Analyst
Coface India Credit Management Services
05.2023 - Current
Carlson School of management
PGP in Business Analytics, Data Analytics, Business Analytics with Excel, Business Analytics with SQL, Tableau and POWERBI
08.2022 - 05.2023
Business Analyst
SBI Life Insurance
10.2019 - 03.2023
Senior Corporate Agency Manager
HDFC Life
07.2018 - 09.2019
Branch Relation Officer
ICICI BANK LTD.
09.2013 - 11.2014
Berhampur University
Postgraduate in Banking Management, Macroeconomics, Advance Data Analysis, Financial Management, Forex Banking, Product and Brand Management
08.2012 - 05.2014
Berhampur University
Bachelor of Economics, Development Economics, Macro and Microeconomics, Statistics, Money and Financial Market, Monetary Economics
08.2009 - 05.2012