Keerthana Muthiah
4837 Lepinske Farm Pl, Clay NY-13041
Summary
Performance-driven Senior BI Developer with 8+ years of experience building scalable reporting and analytics solutions using MicroStrategy, Power BI, Tableau, SQL, Python, and Snowflake on Azure. Skilled in data modeling, data warehousing, and data profiling. Strong domain expertise across finance, pharma, and telecom, with hands-on experience in ETL, Automation, BitBucket, and CI/CD tools.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Software Engineer II - A - GBS Ind
Bank of America(Full Time)
Chennai, India
07.2022 - 10.2023
- Led Facility Risk Rating (FRR) project as Senior BI Architect/Developer, using Snowflake’s virtual warehouses and Oracle to deliver solutions with 30% improved reporting efficiency for Credit & Facility Risk teams.
- Managed SAG Automation and Climate Risk reports, ensuring 99.9% uptime for Credit Risk Reporting.
- Optimized ETL pipelines and data models with Oracle and Snowflake’s columnar storage, achieving 25% faster data retrieval.
- Built MicroStrategy FRR reports using MSTR Architect, advanced SQL, and Snowflake’s query optimization, integrated with Oracle for regulatory compliance.
- Tuned SQL in Snowflake and Oracle, boosting query performance by 40% and reducing dashboard load time.
- Partnered with business stakeholders to translate reporting needs into actionable insights, using Snowflake’s Time Travel to analyze historical data trends, increasing stakeholder satisfaction by 35% through proactive communication and timely delivery.
- Worked in Agile with JIRA, Confluence, GitLab, and BIRD, using Snowflake’s zero-copy cloning for testing and Oracle for data validation, streamlining releases.
- Led UAT cycles in Snowflake and Oracle, ensuring 100% first-release acceptance with validated data accuracy.
- Implemented Snowflake’s Row-Level and Object-Level Security with Oracle integrations, enhancing data access control by 30% and ensuring compliance.
Tech Engineer - Authorized Officer
UBS (Full Time)
Pune, India
12.2021 - 02.2022
- Architected and delivered end-to-end BI solutions for WCAT (Timeliness/Completeness metrics) as a Senior MicroStrategy/Power BI Developer, designing Reports, Documents, Dossiers, and Visualizations from the ground up using MicroStrategy and Power BI.
- Completed navigation of MicroStrategy to Power BI, resulting in a 40% improvement in performance and enhanced user experience through interactive, self-service dashboards.
- Designed scalable technical solutions and conducted POCs to validate feasibility, ensuring alignment between business needs and BI architecture.
- Played a pivotal role in the SLG Project, overseeing data modeling, complex SQL scripting, and Azure SQL operations, on MTDI cube refreshes.
- Operated within Agile frameworks using JIRA and Confluence for sprint planning and GitLab for version control, contributing to the on-time delivery of all project milestones.
- Demonstrated strong multitasking, stakeholder communication, and cross-functional collaboration, driving consistent and efficient project execution across global teams.
Assistant Manager
Citibank (Citi)(Full Time)
Chennai, India
10.2018 - 12.2021
- Worked as a Senior BI Architect/Developer with expertise in Risk Reporting, FP&A, and Data Lineage, leveraging Snowflake’s cloud platform for scalable analytics.
- Conducted feasibility checks to migrate 100+ MicroStrategy reports to Power BI/Tableau, using Snowflake’s virtual warehouses and Big Data Technologies to improve performance by 40% and delivery speed by 25%.
- Designed scalable data models in Snowflake and Oracle, reducing query time by 50% and improving visual accuracy by 30% using DAX, Power Query, and Tableau.
- Built secure, self-service dashboards with Snowflake’s Row-Level Security (RLS) and Object-Level Security (OLS), enhancing data access and refresh times by 45%.
- Proficient in SQL, Sybase, Oracle, Hive, Impala, and Snowflake, alongside MicroStrategy’s full suite (Developer, Architect, Integrity Manager).
- Ensured 100% data integrity through SQL-based reconciliations in Snowflake and Oracle, using Integrity Manager for report validation and UAT.
- Designed scalable data models in Snowflake to replace Intelligent Cubes, utilizing zero-copy cloning for testing, cutting query time by 50% and boosting reporting efficiency.
- Conducted advanced time-series analysis for forecasting KPIs and customer trends using Snowflake’s Time Travel, improving forecast accuracy by 30%.
Associate Engineer
AstraZeneca (Full Time)
Chennai, India
03.2018 - 09.2018
- Senior BI Developer on Clinical/Non-Clinical Case Studies, HR Analytics, and Global Medicines Development projects using MicroStrategy and Amazon Redshift as the primary database.
- Developed 10+ MicroStrategy reports and dashboards with multi-source data integration, supporting global scientific study analysis across clinical domains.
- Designed and maintained MicroStrategy semantic layer, including Schema, Attributes, Facts, Tables, Hierarchies, and Partitions, improving report performance by 35%.
- Supported DevOps and ITIL processes, including Change & Release Management, ensuring 100% compliance with enterprise delivery standards.
- Delivered 24/7 production support for business-critical reports (MicroStrategy and OBIEE), resolving issues with a less than 1-hour response time and maintaining 99.9% uptime.
- Collaborated with cross-functional teams for global report rollouts, ensuring timely delivery and seamless adoption across clinical and HR functions.
Programmer Analyst
Cognizant Technology Solutions(Full Time)
Chennai, India
02.2015 - 03.2018
- Delivered 200+ complex reports and dashboards, improving report generation efficiency by 30-40% through optimized metrics and prompts.
- Migrated legacy SAS reports to MicroStrategy, enhancing functionality and reducing report run time by 25%.
- Improved data model efficiency by redesigning Logical Tables, resulting in 20% faster data retrieval.
- Conducted POCs on Security Filters and dynamic Subscriptions, streamlining report distribution and reducing manual effort by 15%.
- Worked in a multi-source environment with SQL Server and Netezza, ensuring seamless data integration and improved query performance.
Education
Bachelor of Science - Information Technology
Tamilnadu College of Engineering(Anna University Chennai)
Coimbatore04.2014
Skills
- MicroStrategy
- Power BI
- Tableau
- Advanced SQL
- Python
- Snowflake
- Big Data Analytics
- Regulatory Reporting
- CI/CD
- Agile, JIRA, GIT, BitBucket
Certification
- Snowflake Platform Training-Data For Breakfast(Santa Clara, CA)
- MicroStrategy 10 Certified Analyst (MCA)
- MicroStrategy 10 Certified Platform Administrator (MCPA)
- Certified Report Developer (CRD)
Timeline
Software Engineer II - A - GBS Ind
Bank of America(Full Time)
07.2022 - 10.2023
Tech Engineer - Authorized Officer
UBS (Full Time)
12.2021 - 02.2022
Assistant Manager
Citibank (Citi)(Full Time)
10.2018 - 12.2021
Associate Engineer
AstraZeneca (Full Time)
03.2018 - 09.2018
Programmer Analyst
Cognizant Technology Solutions(Full Time)
02.2015 - 03.2018
Bachelor of Science - Information Technology
Tamilnadu College of Engineering(Anna University Chennai)
Similar Profiles
SAMUEL SISSONSAMUEL SISSON
Application Support Specialist - L3 at Bank of America (Full-time Since Oct 2024)Application Support Specialist - L3 at Bank of America (Full-time Since Oct 2024)
Sarita KumariSarita Kumari
Senior Analyst at HCL AMERICA (Full-Time)Senior Analyst at HCL AMERICA (Full-Time)
KHUSH TABAKHUSH TABA
Senior Operation Officer at Meezan Bank Ltd (Full Time)Senior Operation Officer at Meezan Bank Ltd (Full Time)
Reghan ConleyReghan Conley
Transportation Security Officer at Transportation Security Administration, TSATransportation Security Officer at Transportation Security Administration, TSA
Joelyn RoachJoelyn Roach
Registered Nurse at Upstate HospitalRegistered Nurse at Upstate Hospital