Summary
Overview
Work History
Education
Skills
Timeline
Generic

GIRIBABU GARIGALA

Mundelein,IL

Summary

• Highly motivated professional with 17 years of extensive experience in designing and delivering Business Intelligence (BI) solutions across a diverse range of sectors, including Supply Chain Management, Banking/Commercial, Life Sciences, Healthcare/Pharmaceutical/Pre-Clinical Data, and Media & Entertainment.

• Proficient in Data Warehouse, OLAP, OLTP, data modeling, and Extract, Transform, and Load (ETL) processes, with a proven track record of optimizing data-driven decision-making.

• Skilled in leading and coordinating cross-functional teams, both on-site and offshore, for support and application development, ensuring successful project outcomes and client satisfaction.

Overview

18
18
years of professional experience

Work History

Sr Power BI Architect

BMO
04.2024 - Current
  • Implemented robust security measures to protect sensitive data from unauthorized access or breaches.
  • Created project and application architecture deliverables consistent with architecture principles, standards, methodologies and best practices.
  • Developed innovative technical solutions requiring regular use of ingenuity and creativity to solve complex problems.
  • Developed customized reports for business stakeholders, improving decision-making capabilities.
  • Standardized dashboard designs to improve user experience and facilitate quick insight generation.
  • Enhanced BI system performance by optimizing data models and implementing efficient ETL processes.
  • Integrated disparate data sources into a centralized repository, enabling unified reporting and analytics capabilities.
  • Collaborated with cross-functional teams to identify key performance indicators and align data strategies accordingly.
  • Successfully optimized query response time by applying effective indexing techniques and strategically partitioning extensive data sets.
  • Created sophisticated data models tailored to meet specific analytical needs.

Sr Power BI Consultant - Expert

BMO Harris Bank NA
10.2021 - 12.2023
  • Identified areas for improvement in existing BI systems through regular system audits and evaluations.
  • Optimized data quality by conducting thorough data validation and cleansing procedures.
  • Implemented security measures to protect sensitive business intelligence data from unauthorized access or misuse.
  • Leveraged visualization techniques, making it easier for stakeholders to understand complex patterns within their data.
  • Designed and developed data pipelines to acquire, clean, and process data.
  • Deployed predictive analytics models to forecast future trends.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Handled massive quantities of business intelligence data, personally managing as much as 3 terabytes.

Sr BI Consultant

HCL Technologies
06.2020 - 09.2021
  • Designed, developed, and validated visualization tools in Power BI, and Tableau for business intelligence purposes.
  • Constructed data models in Power BI datasets and generated dashboards and reports in Power BI to replicate and enhance existing QlikView dashboards and reports.
  • Crafted dashboards and stories in Tableau specifically for Finance Teams, drawing data from various sources.
  • Developed Power BI applications as part of the Analytics Pathway, taking charge of portal publication, andPower BI Admin portal activities, including creating and managing gateways and workspaces, and controlling user access to Power BI applications.
  • Performed complex data analysis to identify trends, patterns, and business opportunities.
  • Designed customized data collection models for specific visualization tasks.

Sr QlikView Developer

Brightstar US
04.2017 - 03.2020
  • Managed change requests effectively while maintaining clear communication with stakeholders throughout project lifecycles, ultimately delivering solutions that met or exceeded expectations.
  • Enhanced data visualization by designing and implementing QlikView applications for various business units.
  • Maintained strong relationships with internal clients by providing exceptional support, understanding their needs, and consistently delivering high-quality solutions that addressed their challenges.
  • Assisted in the migration from legacy systems to the QlikView platform, ensuring minimal disruption to ongoing operations and maintaining accessibility to historical data.
  • Improved overall system performance by optimizing load times, reducing memory consumption, and enhancing dashboard responsiveness in the QlikView environment.

Senior BI Analyst

AIM Specialty Health, (Anthem, Inc)
10.2016 - 03.2017
  • Consolidated information from different spreadsheets across Case Pre-Auth Data systems like Symposium, NICE, and Umbrella to develop a single comprehensive dashboard for enhanced data visualization.
  • Contributed to roadmap discussions for the migration of existing Umbrella application dashboards to QlikSense.
  • Developed user-friendly QlikSense reports to enhance operational management capabilities. Extracted and integrated data from multiple sources like QVD files, SQL Server, Excel, and Sybase in order to design efficient QlikView data models.
  • Developed ad-hoc and standard reports using SAP BusinessObjects Web Intelligence (WebI) and Deski reports to facilitate client management user needs.

Sr BI Associate

Cognizant Technology Solutions, CTS
04.2012 - 11.2015
  • Increased customer satisfaction by resolving complex issues and providing exceptional service at all times.
  • Developed and implemented strategies to increase customer satisfaction and engagement.
  • Implemented QlikView's advanced capabilities, enabling business users to gain deep understanding of operational performance levels and identify opportunities for growth.
  • Developed unique customizations for clients within the SAP BusinessObjects platform.

SAP BO Developer

Igate Global Solutions
01.2010 - 12.2011
  • The Modified existing universe, imported tables, created joins, created new objects and measures.
  • Identified contexts and added newly created joins in the contexts.
  • Resolved loops in the universe using contexts and aliases and also Implemented aggregate awareness function.
  • Created a most complex report that shows the entire financial information of digital media weekly, monthly, quarterly.
  • Migrated SAP BO reports WebI, Desktop, QAAWS and Crystal) from BO XI R2 to BO XI 3.1 using the Import Wizard.
  • Created customized Audit report by using the default Audit universe to track the user activities in the CMC.

Programmer Analyst

Cognizant Technology Solutions, CTS
10.2006 - 12.2009
  • Analyzed the business requirements of the projects by studying the business requirements specification document.
  • Design, develop new Reports, Universe and modify existing reports based on defined requirements.
  • Created the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice & Down and Drill Down.
  • Authored code fixes and enhancements for inclusion in future code releases and patches.

Education

Master of Science - Geotechnical Engineering

Sri Venkateswara University
Tirupati, Andhra Pradesh, India
02.2006

Bachelor of Science - Civil Engineering

Sri Venkateswara University
Tirupati, Andhra Pradesh, India
04.2001

Skills

    • Power BI
    • Tableau
    • QlikView
    • QlikSense/N-Printing
    • MSBI Stack (SSRS,SSAS & SSIS)
      • SAP Business Objects Tools
      • SQL Proficiency
      • Data Quality Management
      • Data Modeling
      • SQL and Databases (SQL Server, Hadoop, Netezza)

Timeline

Sr Power BI Architect

BMO
04.2024 - Current

Sr Power BI Consultant - Expert

BMO Harris Bank NA
10.2021 - 12.2023

Sr BI Consultant

HCL Technologies
06.2020 - 09.2021

Sr QlikView Developer

Brightstar US
04.2017 - 03.2020

Senior BI Analyst

AIM Specialty Health, (Anthem, Inc)
10.2016 - 03.2017

Sr BI Associate

Cognizant Technology Solutions, CTS
04.2012 - 11.2015

SAP BO Developer

Igate Global Solutions
01.2010 - 12.2011

Programmer Analyst

Cognizant Technology Solutions, CTS
10.2006 - 12.2009

Master of Science - Geotechnical Engineering

Sri Venkateswara University

Bachelor of Science - Civil Engineering

Sri Venkateswara University
GIRIBABU GARIGALA