Janaki E

Senior BI Analyst with 5+ years of experience in US Pharma Commercial Operations, specializing in brand performance tracking, patient journeys, forecasting, payer mix, and market access analytics. Skilled in developing scalable SQL and Snowflake queries, building reusable datasets, and designing interactive Power BI dashboards. Proven ability to optimize data models to reduce compute and storage costs, define KPIs and DAX measures, and translate complex business requirements into actionable insights.

Adept at validating dashboards against backend logic, troubleshooting pipelines, and collaborating with engineers to deliver accurate, high‑performance analytics solutions. Strong background in integrating data from multiple systems and continuously enhancing BI solutions for usability, scalability, and executive visibility.

Associate BI Analyst at MathCo. (2021-12 – 2026-03)

• Delivered enterprise-grade Power BI dashboards for a US pharmaceutical giant using optimized DAX, advanced data modeling, and semantic layer ingestion.
• Strong experience in US Healthcare domain, working with payer and insurance claims data, FFS measurement plans, copay, insurance, and market access analytics
• Monitored and troubleshot ETL workflows, minimizing downtime and ensuring compliance with SLAs.
• Developed scalable data pipelines using Python and PySpark to process data from multiple sources, including Snowflake.
• Collaborated with business stakeholders to incorporate UAT feedback and document ETL processes, data flows, and reporting logic for transparency and maintainability.

Power BI Developer (Remote) at BI Scope Inc. (2021-03 – 2021-11)

• Designed and managed data pipelines, ensuring timely updates of semantic models in Power BI.
• Analyzed large datasets to extract actionable trends and insights, supporting informed decision-making.
• Developed financial dashboards for clients in US and Middle East, enhancing visibility into key metrics.

Project Designer at Compose Architects And Solutions (2015-05 – 2020-03)

• Utilized visualization and design tools, including AutoCAD and SketchUp, for effective layouts, drafting, and concept visualization
• Collaborated with clients to define project requirements, design preferences & timelines for multiple architectural projects, ensuring successful end-to-end planning

Assistant System Engineer at Tata Consultancy Services (2008-12 – 2010-01)

• Executed SQL queries to support BI reporting and intelligence needs
• Optimized BI workflows using ETL tools like Informatica, Cognos

Post Graduate Diploma in Data Science & Business Analytics – Great Lakes Institute Of Management (2021-04)

Bachelor Of Engineering (B.E) in Electronics Technology & Instrumentation – St. Joseph's College Of Engineering, Anna University (2008-05)