Learn Data Skills
Beta
ANKAM PRANAV

ANKAM PRANAV

Business Analyst

Capital One Financial

Technologies

My Portfolio Highlights

My New Project

Introduction to Notebook Projects

My New Course

Introduction to SQL

My New Project

Introduction to Notebook Projects

Insightful puzzle solver, piecing together data fragments to reveal the big picture.

My Work

Take a look at my latest work.

DataLab

Project: Analyzing Students' Mental Health

project

Introduction to Notebook Projects

course

Introduction to SQL

course

Intermediate SQL

DataLab

Project: Analyzing Students' Mental Health

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Understanding Data Science
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

Capital One Financial | May 2024 - Present

Business Data Analyst

• Designed and deployed over 15 interactive Tableau dashboards and reports, enhancing data-driven decision-making across departments, reduced reporting time and increased report accuracy. • Leveraged Python libraries such as Pandas and NumPy for data cleaning and analysis, automating financial reporting workflows and enhancing dashboard accuracy with Matplotlib and Seaborn visualizations. • Automated data cleaning, ETL processes, and query optimizations using Python and SQL, managing datasets of over 2M records cut manual processing time, improving database efficiency and data integrity. Optimized data processing workflows by automating ETL processes and performance using Python, SQL and Alteryx. • Led the development of advanced Power BI dashboards to visualize critical financial performance metrics, improving dashboard usability by 40% based on stakeholder feedback. Facilitated a smooth transition from legacy SQL and Excel-based reporting to a modern, integrated analytics environment. • Collaborated closely with finance stakeholders to understand complex reporting needs, successfully delivering end-to-end financial reports and dashboard enhancements. Ensured high data accuracy and relevance across diverse financial functions. • Conducted in-depth data analysis, built dynamic client databases, and leveraged Tableau for strategic reporting to uncover key trends. Enhanced CRM data accuracy and implemented lead generation strategies via HubSpot and Slack, increasing conversion rates by 25%.
Show More

Version 1 | Aug 2021 - Dec 2022

Business Data Analyst

● Partnered with diverse teams to conduct thorough data analysis and business intelligence reporting, transforming raw data into actionable insights that enhanced cost management, streamlined operations, and improved patient care outcomes. ● Engineered and deployed dynamic Power BI dashboards, revolutionizing the visualization of key healthcare and financial metrics, enabling faster, more informed decision-making. ● Overhauled reporting workflows by replacing outdated SQL and Excel-based processes with automated, scalable analytics solutions—boosting operational efficiency by 35%.  Applied sophisticated data modeling techniques and predictive analytics to anticipate financial trends, optimize resource utilization, and drive strategic initiatives. ● Crafted compelling, data-rich presentations in Microsoft PowerPoint, simplifying complex analytics into clear narratives that influenced executive decisions and corporate strategy. ● Built and maintained rigorous data pipelines and governance frameworks, ensuring data integrity, accuracy, and adherence to regulatory compliance across all analytics operations.

Sigma InfoSolutions | Jul 2019 - Jul 2021

Business Analyst

● Led in-depth stakeholder discussions and conducted extensive market analysis to identify business requirements, resulting in the development of precise Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs) using Microsoft Teams, Word, and JIRA.  Played an instrumental role in aligning cross-functional teams, shaping product roadmaps, and prioritizing features. Authored detailed user stories tailored for agile development, ensuring seamless execution of projects in line with business goals and timelines. ● Orchestrated User Acceptance Testing (UAT) and facilitated structured feedback loops that drove product refinement. These efforts led to a post- release user satisfaction rate of 95%, solidifying the product’s alignment with business expectations. ● Engineered dynamic dashboards and intricate reporting solutions with Tableau and Power BI, empowering real-time insights and accelerating response to market shifts by 25%, ultimately transforming decision-making efficiency. ● Pioneered a customer-first approach to requirement gathering and project execution, optimizing reporting solutions and slashing project timelines by an impressive 80%, setting new benchmarks for operational efficiency.

My Education

Take a look at my formal education

Master of Business Administration - MBA, Business Analytics  · (JanuaryIndiana Institute of Technology | 2024
Bachelor of Science - BS, StatisticsKeshav Memorial Degree & P.G. College | 2019
High School Diploma, MathematicsSt. Mary's College, Yousufguda | 2015

About Me

ANKAM PRANAV

Open to Work | Business Intelligence & Data Analytics | Power BI | SQL | Python | Transforming Data into Actionable Insights.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free