Ruchika Mahapatra
Senior Consultant @Eli Lilly and Company
Signup · Get unlimited contacts
WORK HISTORY
Senior Consultant @Eli Lilly and Company
Bengaluru, IN
Designed and deployed dimensional data warehouse in Microsoft Fabric to create a centralized single source of truth, powering analytics for 50+ clinical trials across Operations, Product, and Finance. Built and optimized SQL-based ETL pipelines integrating 6+ sources, using DBT for maintainable, modular data workflows enabling 10+ executive reports and 40+ operational reports. Applied software engineering best practices — Git-based version control, unit testing for data pipelines, automated data validation scripts, and CI/CD deployment — ensuring reliability and scalability. Collaborated with cross-functional teams to define KPIs and standardize metrics across reporting platforms, improving business alignment using metric layer driving adoption across 90% of users and high metric accuracy of ~99% Delivered self-service 60+ Power BI dashboards connected to certified datasets & metrics layer reducing analyst dependency and enabling real-time decision-making.
EDUCATION
The University of Texas at Austin
Postgraduate Degree, Data Science and Business Analytics
IMI Delhi
PGDM, Finance & Marketing
Sri Chaitanya
Intermediate, Maths, Physics, Chemistry, Information Technology
De Paul School, Berhampur
10th, Mathematics, geography, science, Java
Roland Institute of Technology
Bachelor's degree, Information Technology
SKILLS
ABOUT RUCHIKA MAHAPATRA
Accomplished data and analytics professional with over nine years of experience in designing dimensional data warehouses, optimizing ETL processes, and implementing scalable data solutions. Currently contributing as a Senior Consultant at Eli Lilly and Company, utilizing expertise in Microsoft Fabric, DBT, and SQL to develop centralized data repositories that power analytics for clinical trials across multiple business units. Dedicated to applying software engineering best practices such as Git-based versioning, CI/CD deployment, and automated data validation to enhance data reliability and scalability. Passionate about enabling cross-functional teams with self-service BI tools and standardized KPIs to drive alignment and data-driven decision-making. Proficient in Python, PySpark, and Azure Service Fabric.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.