GAUTHAM BABU BOPPANA
London,ENG
Summary
Creative Analytics Manager keen to expand beyond traditional tools and techniques to advance both internal business goals and data analytics pursuits. Derives excellence from personnel by providing exemplary leadership and technical expertise. Skilled creator of cohesive, productive teams exploiting every bit of available data.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Power BI Manager
Metro Bank
03.2022 - Current
- As a hands-on Power BI Manager at Metro Bank, I lead and manage the development of business intelligence reporting, BI Architecture and the BI platform as part of the largest Power BI deployments in the world
- Working as part of the Enterprise Analytics and Data Science team, I am leading the bank to migrate away from an exclusively centralized BI model and towards the Data Excellence CoE setup
- Key Duties and Responsibilities:
- Leading the BI team responsible for enterprise reporting (2000+ users, 600+ BI Reports and Datasets)
- Managing all aspects of Power BI implementation and adoption (very fast-paced and dynamic environment)
- Creating new & improving existing Enterprise reporting including Financial, Mandatory and Regulatory reporting
- Designing and building interactive Power BI dashboards and reports to a high standard focusing on usability
- Design and implement data models to be used for analytics and reporting, working with Subject Matter Experts
- Building out robust and scalable Master Datasets that are efficiently modelled and support self-service BI
- Collaboration with C Level stakeholders, business areas and users on a variety of projects and requirements
- Aligned Snowflake data architecture with business requirements and implemented ETL pipelines
- Responsible for the data platform governance, administration of the power BI tenant, user access and security
- Monitored usage metrics and logs to ensure efficient performance and availability of the platform
- Implementing and adhering to data privacy, GDPR regulations and Metro Bank’s Data Policy guidelines
- Achievements:
- Established the Enterprise Reporting templates, Style-guide, Data modelling standards and Dataset documentation for standardising the reporting across the bank and support Self-Serve BI
- Developed the Route to Live process for the BI reports using Azure DevOps and Deployment pipelines
- Established Backlog prioritisation and Agile Development process for new BI / MI requests
- Improved the helpdesk process for BI / Data issues, and reduced the resolution time by 40%
- Promoted BI and Data culture through Citizen Developer program, User Training, and Lunch & Learn.
Reporting & Data Visualisation Developer
Peninsula Petroleum Ltd
03.2021 - 03.2022
- As the Power BI / Data ‘Evangelist', I was responsible for implementing Power BI as the BI tool, developing dashboards, reports and data models in Power BI, and overseeing the adoption & User training
- Key Duties and Responsibilities:
- Lead a team of 4 Developers, and responsible for designing, developing, and deploying BI solutions using technologies such as Azure SQL Server, SSIS, AAS, REST APIs and Power BI to meet business requirements
- Lead the implementation of the BI Strategy and Roadmap and delivery of key outcomes
- Collaborated with stakeholders to capture and translate requirements into effective and actionable BI Reports
- Worked with Data Architects & Data Engineers for data integration and centralised data warehouse development
- Developed several interactive dashboards and reports to create compelling and meaningful dashboards & reports
- Mentored and trained colleagues on Power BI, encouraging a culture of data literacy and self-service analytics
- Administered & governed the Power BI Tenant - security, User access, schedules, workspaces, and gateways
- Key Projects:
- Sales Unit Performance Dashboard for Executive Management and Commercial Teams
- Trader Performance Report for Trading Managers
- Supply Market Performance Dashboard for Executive Management and Commercial Teams
- Project Management MS Project, JIRA, GitHub
- Profit & Loss (P&L) Reports for Finance & Accounting Teams
Business Analyst
Moving Picture Company
09.2019 - 03.2021
- Responsible for designing and developing Business Intelligence Reporting solutions across multiple
- Business Units (Film, TV, Animation and Advertising) in Techicolor, Inc
- Lead the BI reporting as a greenfield project, established the BI / MI development standards and processes, incorporating Consultancy approach & Agile development
- Key Duties and Responsibilities:
- Led a global 6-member team of analysts, data architect and developers to create various BI applications, including
- MIS Reports, Dashboards and Operational reports
- Provided consulting services and worked with Executive Management and Key Stakeholders across business lines – Finance, Sales, Workforce Management, HR, and Talent teams to ensure their BI needs are met
- End-to-end BI Reporting solutions development incl
- Eliciting requirements, designing, developing and adoption
- Worked with Program Managers, Team leaders and Subject Matter Experts to gain a better sense of the current shortcomings in current reporting, and devised solutions to enhance reporting and data management
- Created proposals for the BI solutions, incl
- Data Architecture, Dashboard designs, Estimates and Project plans
- As part of the BI adoption process and Self-serve initiatives, provided trainings to the business users to create and manage their own reports and dashboards
- Key Projects:
- State of the Business and Compliance dashboards for Executive Management
- Profit & Loss (P&L) reports for Finance Team
- Business Development, Bidding Analytics and Sales simulation dashboards for Sales and Finance Teams
- Salary planning and Budgeting dashboard for HR and Finance Teams
- Workforce scenario planner for Finance and Workforce Planning Teams
- Seat capacity and Resource Utilization Dashboards for Workforce Management Team
Managing Analyst
Optimity Advisors
12.2013 - 08.2019
- Engaged with various clients to design, develop, and implement Business Intelligence Reporting solutions, enabling business intelligence reporting including benchmarking, metric identification, performance measurement, and target setting
- Key Duties and Responsibilities:
- Engaged with clients across industries on various Business Intelligence Reporting tools development projects
- Responsible for consulting with clients, documenting business/user requirements, analyzing the requirements and creating proposals, providing clear specification of the deliverables
- Engaged with C-level executives and Program managers to deliver the BI roadmap and strategy
- Worked closely with Senior Client stakeholders and Business Users to understand reporting and analytics requirements and to guide on best practice patterns
- Provided BI technical and architectural guidance to projects and teams, and assisted analysts in various data mining and reporting techniques
- Designed and developed various Dashboards, Scorecards, MIS Reports and Visualisations using technologies such as SQL Server, SSIS, Power BI, SSRS, Tableau, QlikView, Qlik Sense and SAP Business Objects etc
- Developed performant & scalable Data Sources, ETL pipelines using SQL Server, APIs, Azure Data Factory and
- SSIS packages, for extracting and loading data from multiple data sources into the Data Warehouse
- Developed SQL queries, SQL Stored Procedures and SQL views for importing data into BI Tools
- Ensured documentation is created and maintained for data integration processes, data mappings and data lineage
- Provided expert guidance, training, and demos to the client end users on using the BI reports for data decisions
- Key Projects:
- CQC Quality Dashboard for a Healthcare Trust to monitor Quality Performance across multiple hospitals
- Dashboard for a Healthcare Trust for benchmarking operational and infrastructure costs, staffing, and equipment usage costs across multiple hospitals
- Resource Management and Production Analytics Dashboards for a global VFX company
- HR Analytics and 360 Relationship Mapping Dashboards for a global Animation company
- BI Reporting suite for Medicaid Claims for a major Medicaid provider in the US
- Accidents and Emergencies Dashboard for an NHS healthcare provider
- Outcomes and Sentencing statistics Dashboard for a public policy consultancy
Analyst
British Oxygen Company
03.2012 - 12.2013
- Responsible for developing solid strategies to capture and report on the required data defined by the
- NHS, Home Oxygen Service contract and the Homecare business functions
- Key Duties and Responsibilities:
- Responsible for Homecare Reporting and Service Center Call Operations performance analysis
- Created reports based on NHS and Business requirements/design
- Administered reporting systems and databases (SAP Business Objects, MS Access Database)
- Responsible for the efficient maintenance of Homecare data managing a suite of reports
- Produced Weekly and Monthly reporting packs (KPI, Billing and other reports) for NHS
- Provided business Intelligence on modality turnover, trends and forecasting the demand
- Conducted Data Reconciliations of payments between SAP system and Financial Service Corporation
- Proactively created reports to maximize innovation payments and enhance the contract provision
- Analysed & reported on Volume trends, Service Levels, KPI trends, Failures, Advisors performance, Orders etc
- Provided Business Intelligence on Inbound Call volume forecasting, Resource scheduling and Performance.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Improved data collection methods by designing surveys, polls and other instruments.
- Identified opportunities for cost savings through thorough analysis of financial data, reducing operational expenses.
- Improved data-driven decision making by implementing advanced analytics techniques and tools.
- Automated reporting processes using visualization tools such as Tableau, increasing efficiency and enabling real-time insights for stakeholders.
- Standardized methodology for measuring KPIs across departments to provide consistent performance tracking and evaluation metrics.
- Presented in-depth analysis of business trends and opportunities to executive leadership, shaping strategic decisions and driving company growth.
- Collaborated with IT teams to develop scalable solutions for data storage and processing needs, supporting the growth of analytics capabilities within the organization.
- Evaluated the effectiveness of pricing strategies through rigorous market research and competitor benchmarking, informing strategic decisions.
- Streamlined data collection processes to enhance accuracy and reduce errors, ensuring high-quality datasets for analysis.
- Designed custom dashboards tailored to stakeholder needs, providing at-a-glance insights into key performance metrics.
- Managed vendor relationships to ensure the timely delivery of high-quality data and analytics services, enhancing the value provided by external partners.
- Championed a data-driven culture by training team members on best practices for data visualization and storytelling techniques, fostering effective communication of analytical findings.
- Enhanced customer segmentation by integrating demographic and behavioral data, improving targeted marketing efforts.
- Oversaw data visualization projects for [Type] clients, delivering comprehensible and invaluable visuals for presentation to audiences of different technical understanding.
- Organized [Number] simultaneous ongoing projects, delegating personnel and resources to optimally meet overarching business goals and minimize redundancies.
- Translated complex business objectives into actionable data management plans for individual clients and customer classes.
- Derived forward-looking insights from ongoing analytics projects to offer predictive intelligence for ongoing business decision-making.
- Led cross-functional teams in the design and implementation of company-wide analytics initiatives, fostering a data-driven culture.
Process Developer
GENPACT
09.2006 - 09.2010
- Responsible for Business Intelligence Reporting, KPI Metrics and Dashboards development
- Also, led various Data migration, Data Cleansing and Quality Projects
- Key Duties and Responsibilities:
- Developed Payroll Operations, Overpayments, Time & Accuracy, and HR Dashboards for GE
- Designed and developed Global InterPay metrics for GE which are now implemented in 21 countries
- ADP Tax Rejects Project for GE: Fixed the data sync issues between PeopleSoft tax table and ADP headers file - resulting in reduced compliance risk exposure of $700,000
- GE UK Data Alignment & Readiness Project for GE: Cleanup of inaccurate Employee data to facilitate data migration from ADP to PeopleSoft platform - improved data accuracy from 83% to 99%
- GBS India Project: Developed proper control mechanisms & automation to improve data quality for GE India.
Education
MSc - Financial Mathematics
Leeds University Business School, University of Leeds
Leeds, United Kingdom2011
Bachelor of Commerce (Honors) - Accounting And Finance
University of Delhi
Delhi, India2006
Skills
- TECHNICAL SKILLS
- Business Intelligence Reporting Tools Microsoft Fabric, Power BI, Power BI Paginated Reports, SQL Server
- Reporting Services (SSRS), Tableau, QlikView, Qlik Sense, and SAP
- Business Objects
- Databases and Database Tools MS SQL Server, MS Access, SQL Server Analysis Services (SSAS)
- Azure SQL, Azure Data Lake, Azure Analysis Services (AAS)
- ETL Tools Azure Synapse Analytics, Azure Data Factory (ADF), Snowflake, SQL
- Server Integration Services (SSIS)
- RPA / Low code tools Power Platform – Power Apps, Power Automate
- Programming T-SQL, DAX, Excel VBA, Python
- Complex Problem-Solving
- Verbal and written communication
- Team Leadership
- Team Leadership Qualities
- Data Modeling Techniques
- Business intelligence tools
- Project management abilities
- Cloud Computing Platforms
- Data Visualization Techniques
Accomplishments
· Established the Enterprise Reporting templates, Style-guide, Data modelling standardsand Dataset documentation for standardising the reporting across the bank and support Self-Serve BI.
· Developed the Route to Live process for the BI reports using Azure DevOps and Deployment pipelines.
· Established Backlog Prioritisation and Agile Development Process for new BI / MI requests.
· Improved the helpdesk process for BI / Data issues, and reduced the resolution time by 40%
· Promoted BI and Data culture through Citizen Developer program, User Training, and Lunch & Learn.
Certification
· DP-203: Azure Data Engineer Associate
· DP-500: Microsoft Azure Enterprise Data Analyst Associate
· PL-300: Microsoft Certified Data Analyst Associate
PL-900: Microsoft Power Platform Fundamentals
· AZ-900: Microsoft Azure Fundamentals
· DP-900: Microsoft Azure Data Fundamentals
· Tableau Desktop 9 Qualified Associate
Timeline
Power BI Manager
Metro Bank
03.2022 - Current
Reporting & Data Visualisation Developer
Peninsula Petroleum Ltd
03.2021 - 03.2022
Business Analyst
Moving Picture Company
09.2019 - 03.2021
Managing Analyst
Optimity Advisors
12.2013 - 08.2019
Analyst
British Oxygen Company
03.2012 - 12.2013
Process Developer
GENPACT
09.2006 - 09.2010
MSc - Financial Mathematics
Leeds University Business School, University of Leeds
Bachelor of Commerce (Honors) - Accounting And Finance
University of Delhi
Similar Profiles
Naj AyubiNaj Ayubi
Relevant Experience: Commercial Analyst at Metro BankRelevant Experience: Commercial Analyst at Metro Bank
Manasvini SundararajanManasvini Sundararajan
Personal Banking Representative at Metro BankPersonal Banking Representative at Metro Bank
Jagpreet SinghJagpreet Singh
Customer Service Representative at Metro BankCustomer Service Representative at Metro Bank