BHUSHAN BONAGIRI
Sr BI Developer
Carlsbad,CA
Summary
Experienced Business Intelligence Development Delivery Lead with a proven track record in the biotechnology, entertainment, auto insurance, consumer products, mortgage, and health insurance sectors. Skilled in analytics and reporting, requirements analysis, data analysis, ETL, data warehousing, and the software development life cycle (SDLC). Adept at consulting and delivering end-to-end BI solutions. Collaborating closely with client teams to understand their BI requirements, translating them into functional and technical specifications while actively contributing to hands-on development. Personable and analytical with a knack for translating complex data into actionable insights. Possessing advanced knowledge of SQL and data modeling, combined with strong proficiency in data visualization tools. Capable of driving data-informed decision-making to enhance business performance.
Overview
15
15
years of professional experience
3
3
Certifications
1
1
Language
Work History
Sr BI Developer
Thermo Fisher Scientific
Carlsbad, CA
07.2011 - Current
- Hands on development experience on analytics tools Power BI, Microsoft Fabric, AAS, Power Automate, SSAS, Cognos, At-Scale, SQL
- Worked on application development, system support, business support, BI project development, data integration and Cognos upgrades
- Worked as Developer, technical lead, business analyst, and Delivery lead
- Working experience in Informatica, Databricks, Oracle Warehouses, Redshift, AWS S3 data lake, Airflow, unity catalog, Atscale, and Athena
- Task execution through Jira and Confluence in Agile sprint model
- Worked with Finance, Commercial Sales, marketing and customer support teams gathered the requirement, create Business and Technical requirement documents, worked with all the stakeholders – application, DB, business, DevOps, Change Management teams for successful implementations
- Worked with several vendor teams onsite and offshore (India, Mexico, Budapest) and coordinated all development work with enterprise teams – almost since last 15 years
- Hosted tool training across the organization and train Power BI application to several business teams
- Designed and developed Sales, Finance, Audit Power BI dashboards to provide real-time insights to business stakeholders
- Built data models by integrating data from multiple sources (Redshift, AWS s3, Databricks Unity Catalog, Oracle, SQL, Excel, SharePoint, Azure Synapse, At Scale, Kyligence, AWS Athena)
- Created complex DAX measures and calculated columns to enhance reporting capabilities
- Implemented Row-Level Security (RLS) and Object-Level Security (OLS) for secure access control
- Optimized Power BI reports for performance and scalability using aggregations and indexing
- Accessed S3 files using Shortcuts in Fabric environment and integrate with redshift data
- Ingested data using Fabric mirroring for real time data
- Power Automate – Used it to automate csv files as email attachments and sourced it for Power BI feed
- Implemented Drill-Down, Drill Through, Conditional formatting, Scheduling, manage workspace access and custom visualizations
- Optimized report loading time by reducing dataset size and applying query folding
- Used Direct Query, Import, and Composite models to enhance performance
- Build Power BI dashboards using Cognos REST API
- Migrate several Cognos reports into Power BI models and created dashboards
- Develop, enhance, and maintain Cognos reports, dashboards based on business requirements
- Design metadata models using Framework Manager, creating packages for efficient report generation
- Monitored the ETL jobs in Databricks and airflow
- Define the Catalogs and schemas in Unity Catalog as per the business need and assign the UC roles based on each schema
- Worked with the development team for Airflow orchestration for several projects (depending on touch files from source data load completion)
- Built the finance cube semantic layer in At-scale and enabled dashboarding from power BI
Sr BI Consultant
The Walt Disney Company
Carlsbad, CA
11.2009 - 08.2011
- Lead Cognos BI team of 3 to 5 members
- Present Go-Office to larger scale audience in Disney; Develop scenarios for POC
- Support production issues; Report, FM model and cube fixes
- Troubleshoot report and cube performance issues and recommend the solutions; Ex: Reports and cubes are running longer than normal time
- Develop dashboards and reports against OLAP data sources (MDX query) and BW cubes for HR and finance modules:
- Map the composite client from Cognos to SAP R/3; To enable functioning Cognos Drill through from Cognos reports to SAP R/3 system
- Migrate Cognos objects from DEV –QA –PROD; Schedule reports and cubes
- Implement bursting process (400 users based on cost centers)
- Implement FM and cube-based securities (create user groups, create custom views)
Education
Master of Science - Master of Infrastructure Planning
University of Stuttgart
Stuttgart, GermanyBachelor of Science - Bachelor of Engineering
Osmania University
Hyderabad, IndiaSkills
- Power BI
- Microsoft Fabric
- Power Automate
- Cognos
- At-Scale
- AAS
- SSAS
- Cognos transformer cubes
- Amazon Redshift
- Amazon S3
- Amazon Athena
- Airflow
- AWS Databricks
- Databricks Unity Catalog
- Informatica
- Jira
- Confluence
- Data Engineering
- Analytics development
- Data Analysis
- Data integrations
- Data Migrations
- Oracle
- DB2
Certification
Microsoft Certified Power BI Data Analyst
Skills - Technical Expertise
Power BI, Microsoft Fabric, Power Automate, Cognos, At-Scale, AAS, SSAS, Cognos transformer cubes, Amazon Redshift, Amazon S3, Amazon Athena, Airflow, AWS Databricks, Databricks Unity Catalog, Informatica, Jira, Confluence, Data Engineering and Analytics development, Data Analysis, Data integrations, Data Migrations, Oracle, DB2
Accomplishments
- Automated the Cube security process and saved ~500 manual hours
- Migrated Siebel to Sales Force data in to AWS S3 platform for BI reporting
ETO Quarterly Golden Lever Awards
In 2023 Q2, I was honored with the Quarterly Golden Lever Award for transforming our BI data pipeline from redhsift to EDP platform, significantly improving reporting efficiency. Faced with slow data refresh times and inconsistent reporting, I led an optimization initiative that streamlined ETL processes, enhanced data models, and automated quality checks. These improvements reduced data refresh time from 4 hours to under 1 hour and boosted dashboard performance by 2x, enabling real-time decision-making for leadership. This recognition reinforces my passion for driving impactful BI solutions and leveraging data to unlock business value. 🚀
Timeline
Sr BI Developer
Thermo Fisher Scientific
07.2011 - Current
Sr BI Consultant
The Walt Disney Company
11.2009 - 08.2011
Master of Science - Master of Infrastructure Planning
University of Stuttgart
Bachelor of Science - Bachelor of Engineering
Osmania University
Similar Profiles
Emily RobinsonEmily Robinson
Pharmacy Technician II at Fisher Bioservices, Thermo Fisher ScientificPharmacy Technician II at Fisher Bioservices, Thermo Fisher Scientific
Jennifer VangJennifer Vang
Inventory Coordinator at Thermo fisher ScientificInventory Coordinator at Thermo fisher Scientific
Natalie C. TwineNatalie C. Twine
Instrument Sales Representative-Genetic Analysis at Thermo Fisher ScientificInstrument Sales Representative-Genetic Analysis at Thermo Fisher Scientific