Skip to content

Prasanna Jaganadham

Junior Data Analyst • Grand Est, France • j*****************@gmail.com • +33******050 • linkedin.com/••••• • github.com/•••••

Professional Summary

Junior Data Analyst with an MSc in Data Science and 1.5 years of hands-on experience building SQL reporting pipelines, Power BI dashboards, and ETL processes for banking and non-profit clients. Proven record in SQL performance optimization (reduced a critical batch job runtime by 96%), data integration, and automated reporting. Seeking a Data Analyst or BI role in France where I can apply strong SQL, Python, and Power BI skills to deliver actionable insights and scalable reporting solutions.

Technical Skills

Programming Languages: Python,R,Bash
Frameworks and Libraries: Scikit-learn,Pandas,NumPy
Databases: SQL,Oracle Finacle,PostgreSQL
Cloud and DevOps: Docker
Data and Analytics: Power BI,DAX,Power Query,Tableau,Excel,ETL pipelines,Data modelling,Data warehousing,Exploratory data analysis,KPI reporting,Sales forecasting
Tools and Methodologies: Jupyter Notebook,Alteryx Designer,Bloomberg Terminal,Git,GitHub

Work Experience

Infosys Ltd.
Hyderabad, India
Software Engineer — Data & Analytics
Feb2022 – Jun2023
Tech Stack: Oracle SQL, Oracle Finacle, UNIX Shell, Git, ETL
  • Built and maintained 15+ production SQL reporting pipelines on Oracle Finacle to deliver daily Payments, CRM, and Treasury reports for three European banking clients, ensuring reliable SLA-driven report distribution.
  • Optimized SQL performance by redesigning indexing strategy and join logic and tuning execution plans, reducing a critical batch job runtime from 4 hours to under 8 minutes (96% improvement) with no change to output.
  • Automated daily EU reporting file delivery using UNIX shell scripts to remove approximately 2 hours of manual work per day (~40 hours/month) and improve on-time distribution.
  • Collaborated with Risk, Treasury, and Operations stakeholders to translate business requirements into report logic and queries, improving accuracy and reducing requirement rework.
  • Performed data validation and reconciliation between Oracle Finacle extracts and client deliverables, identifying and correcting data discrepancies before release.
  • Diagnosed and resolved batch processing and query performance issues by analyzing SQL execution plans and error logs, restoring timely processing and preventing recurrence.
YBI Foundation
Delhi, India (Remote)
Data Analyst Intern — BI & Analytics
May2024 – Aug2024
Tech Stack: Power BI, DAX, Power Query, Python, Pandas, Excel
  • Developed Power BI KPI dashboards using DAX and Power Query to track weekly business metrics; dashboards were adopted in leadership review meetings to support decision making.
  • Integrated and cleaned 200,000+ records from SQL exports, Excel, and CSV logs using Python and Pandas into a standardized dataset to support consistent reporting.
  • Built a sales forecasting model with Scikit-learn that achieved a 15% MAPE improvement over baseline on a 12-month holdout, informing planning and resource allocation.
  • Documented DAX measure definitions, data source mappings, and dataset transformations to enable maintainability and smoother handovers to the analytics team.
  • Implemented Power Query transformations and a dataset model to enable scheduled refreshes and reduce manual ETL effort required for weekly reporting.
  • Partnered with program leads and stakeholders to convert business questions into measurable KPIs and dashboard visualizations, improving metric clarity and alignment.

Projects

Automated E-Commerce Price Tracking Pipeline
Tools Used: Python, BeautifulSoup4, Pandas, ETL, Automation
  • Automated daily price tracking across 500+ product listings in three categories to eliminate manual monitoring.
  • Implemented scheduled scraping, data cleaning and structuring with Pandas, and 30-day rolling price trend calculations to surface pricing anomalies.
  • Deployed automated email alerts for significant price changes and published documented code on GitHub for reproducibility.
Spotify Listening Analytics Dashboard
Tools Used: Power BI, DAX, Power Query, Star schema
  • Analysed listening behaviour by artist, album and track using a star schema model and built a five-page Power BI dashboard with drill-through navigation.
  • Created custom DAX measures and optimized dataset load times while enabling CSV exports from detailed views for downstream analysis.
  • Validated model and measures to ensure accurate aggregations and facilitate actionable insights into user behaviour.
COVID-19 ICU & Mortality Analysis
Tools Used: PostgreSQL, Docker, CTEs, Window functions
  • Integrated 6+ datasets totaling 100,000+ patient records across ICU, Med/Surg, testing and mortality data using complex SQL queries with CTEs and window functions.
  • Developed an ICU-conversion ratio linking positive test counts to estimated ICU demand across three patient cohorts to support capacity planning.
  • Packaged analysis in Docker for reproducible query execution and simplified deployment of analytical queries.

Education

Burgundy School of Business (Grande École)
MSc Data Science & Organisational Behaviour | Master's in Management (MIM) • Dijon, France • Sep2023 – Aug2025
Krishna University
B.Sc. Theoretical & Mathematical Physics • Andhra Pradesh, India • 2018 – 2021

Certifications

Alteryx Designer — Triple Certified — Alteryx
Bloomberg Market Concepts (BMC) — Bloomberg
Microsoft Azure Fundamentals (AZ-900) — Microsoft

Powered by Drivetube · Create your own profile at drivetube.ai