Headline

Data Analyst | MBA Business Analytics | Python · SQL · Power BI | Risk & Financial Analytics

About

MBA candidate in Business Analytics (LPU, May 2026) | Data Analyst | Open to Full-Time Roles I build end-to-end analytics solutions — from automated ETL pipelines and PostgreSQL databases to real-time Power BI dashboards — that translate complex data into decisions stakeholders can act on. At IntelliDB Enterprise, I processed 50M+ patient records across 28 states, flagged 3,008 high-risk cardiac cases in real time, and saved 60+ analyst hours per month through automated reporting workflows. I also deployed a live PostgreSQL Knowledge Base with AI-powered search — demonstrating end-to-end ownership from data architecture to production. At the EY Data Xplore Hackathon 2024, I built a supply chain analytics solution identifying 272 stockout risks across 300+ SKUs using ABC/XYZ classification and predictive modelling — awarded 2nd Place. Technical Stack: Python (Pandas, NumPy) | SQL | PostgreSQL | Power BI | Tableau | Advanced Excel | ETL Pipelines | Predictive Modelling Domain Expertise: Supply Chain Analytics | Risk Analytics | Financial Analysis | Data Governance | Regulatory Compliance I am also a CS Executive Level Candidate at ICSI — bringing knowledge of corporate governance, financial regulations, and compliance frameworks that complement my analytics background for roles in financial services and consulting. Currently targeting Data Analyst, Business Analyst, and BI Analyst roles at firms like Barclays, Deloitte, Accenture, and AXA XL. 📩 pranavsinghal77@gmail.com 🔗 github.com/pranavsinghal77

Location

Jalandhar

Work experience

Data Analyst Intern at IntelliDB Enterprise, Jun 2025 - Aug 2025 · 3 mos, Gurugram, Haryana, India, • Built a PostgreSQL KnowledgeBase platform documenting 5,000 plus technical issues across 18 categories, improving findability of solutions and reducing support resolution time by 75 percent • Designed real time data pipelines using Python and SQL to automate reporting for healthcare operations • Developed Power BI and Tableau dashboards refreshing every 15 seconds for live clinical and operational monitoring • Reduced manual reporting effort by approximately 60 analyst hours per month through analytics automation • Collaborated with product and engineering teams to align analytics outputs with business objectives • Strengthened skills in data modeling, SQL analytics, dashboard design, problem solving, and cross functional teamwork

Business Development Executive at Apex Financial & Marketing Services, Jan 2024 - Jul 2024 · 7 mos, Jalandhar, Punjab, India, Analyzed client acquisition and conversion data to design and execute business development strategies, contributing to a 20% increase in client acquisition. Collaborated cross-functionally to streamline operational workflows, reducing lead conversion time by 15% through process optimization. Monitored market and competitor trends and presented insights to senior management to support strategic planning and decision-making.

Business Development Executive at Apex Financial and Marketing Services, Jan 2024 - Jul 2024 · 7 mos, Analysed 1,000+ financial records and 500+ transactions across insurance, loan, and NBFC portfolios – built automated Excel and Python dashboards, improving operational efficiency by 18% and eliminating 10+ hours of manual reporting monthly. Delivered client-facing analytical decks translating financial KPIs and performance data into strategic business recommendations for senior management; supported decision-making across banking and insurance product lines.

Finance Accounting Intern at Action Batteries Pvt. Ltd., Jun 2023 - Jul 2023 · 2 mos, Jalandhar, Punjab, India, Supported financial account management and reporting processes, gaining hands-on exposure to accounting practices and business operations. Participated in strategic business discussions, contributing financial inputs for national and international market operations. Streamlined financial reporting and reconciliation processes to improve accuracy, compliance, and internal controls. Analyzed financial and operational data to support data-driven decision-making for domestic and global business expansion.

Finance Intern at Action Batteries Pvt. Ltd., Jun 2023 - Jul 2023 · 2 mos, Performed variance analysis, reconciliation, and financial performance reporting for Rs. 25+ crore operations – improved reporting accuracy by 25% across 3 export cycles through structured data validation.

Digital Marketing Intern at TEACHNOOK (TEACHSCAPE ONLINE LEARNING SERVICES PRIVATE LIMITED), Jan 2023 - Feb 2023 · 2 mos, Bengaluru, Karnataka, India, Supported planning and execution of outreach initiatives by analyzing audience engagement and response patterns. Assisted fundraising efforts through coordinated outreach and digital channels to improve campaign reach. Created content and basic performance tracking for social awareness campaigns focused on children’s education.

Education

Master of Business Administration - MBA in Business Analytics, Business Analytics, Lovely Professional University (LPU)

Bachelor of Business Administration Honors - BBA Hons., Business Analytics, Lovely Professional University (LPU)