Jyoti Mathapati
Associate Manager, Delivery
Bengaluru,KA
Summary
BI & Analytics Leader with over 10 years of experience in designing and implementing enterprise-scale Business Intelligence solutions. Proficient in MicroStrategy architecture, ETL design, and data warehousing, with expertise in Apache Airflow for workflow orchestration. Demonstrated success in leading cross-functional teams and managing complete project lifecycles to align BI strategies with organizational objectives. Experienced in regulatory reporting, predictive analytics, and creating executive dashboards that enhance compliance and facilitate data-driven decision-making.
Overview
12
12
years of professional experience
4
4
Languages
Work History
Associate Manager, Delivery
Digital.ai
Bengaluru, India
10.2015 - Current
· Engineered enterprise and cloud-based data warehouse architectures with Snowflake to enable scalable analytical workloads.
· Applied dimensional modelling techniques, including star and snowflake schemas, for efficient analytical querying.
· Developed logical and physical data models to convert business requirements into optimized warehouse structures.
· Architected SQL-based ETL/ELT pipelines for effective data ingestion and transformation processes.
· Implemented SCD Type 1 and Type 2 strategies to accurately manage historical data changes.
· Established data validation rules and reconciliation check to ensure data reliability and consistency.
· Optimized query performance through partitioning, clustering, and SQL tuning for enhanced efficiency.
· Designed reporting-friendly data models and optimized datasets to facilitate BI and analytics consumption.
· Designed and implemented Medallion Architecture in Snowflake, leveraging the Gold/Curated layer to support BI consumption and ETL processes, and developed MicroStrategy (MSTR) Strategy Dashboards aligned with business requirements
Senior Software Engineer
Infosys Ltd.
Bengaluru, India
05.2014 - 10.2015
Education
Bachelor of Engineering - Computer Science
Bheemanna Khandre Institute of Technology
Bhalki, India 04.2001 -
Skills
Engineered enterprise and cloud-based data warehouse architectures with Snowflake to enable scalable analytical workloads
Applied dimensional modelling techniques, including star and snowflake schemas, for efficient analytical querying
Developed logical and physical data models to convert business requirements into optimized warehouse structures
Architected SQL-based ETL/ELT pipelines for effective data ingestion and transformation processes
Implemented SCD Type 1 and Type 2 strategies to accurately manage historical data changes
Established data validation rules and reconciliation check to ensure data reliability and consistency
Optimized query performance through partitioning, clustering, and SQL tuning for enhanced efficiency
Designed reporting-friendly data models and optimized datasets to facilitate BI and analytics consumption
Accomplishments
Orchestrated the implementation of new MicroStrategy reporting/Configuration packages, resulting in improvement in reporting efficiency.
Got appreciated by clients for successfully implementing the Change Risk Prediction and Change Credit Score solutions
Timeline
Associate Manager, Delivery
Digital.ai
10.2015 - Current
Senior Software Engineer
Infosys Ltd.
05.2014 - 10.2015
Bachelor of Engineering - Computer Science
Bheemanna Khandre Institute of Technology
04.2001 -