Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Pawan Lohumi

Pawan Lohumi

Bengaluru

Summary

Strategic Data Leader with over 11 years of experience in data management, reporting, analytics, and Data Science. Demonstrated expertise in driving operational excellence and delivering impactful solutions. Proficient in SQL, Excel, Power BI, Tableau, with hands-on experience in machine learning, statistical analysis, and predictive modeling. Skilled in developing comprehensive reporting solutions and leveraging advanced techniques to extract actionable insights. Passionate about employing data-driven approaches to address complex business challenges and foster growth. Actively mentors aspiring professionals in the Data Analytics and Data Science domains.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Lead Technology Business Services Consultant(VP)

Wells Fargo
08.2020 - Current
  • Drive key business decision-making by delivering strategic and tactical analytics and reporting, ensuring insights are actioned through internal customers.
  • Identify scope and manage projects based on strategic outcomes, available data, and desired analytical approaches.
  • Prioritize and manage workflow to meet project deadlines and escalate issues to relevant stakeholders.
  • Explore and identify new data sources to improve understanding of products and customers.
  • Champion strategic, tactical, and ad hoc analytics to support internal customer outcomes using appropriate analytic techniques.
  • Translate analytics into meaningful business insights to integrate into decision-making and business strategy.
  • Develop and maintain partnerships with stakeholders, becoming a trusted advisor to maximize the effectiveness of analytics services.
  • Lead projects and cross-functional teams to achieve business outcomes.
  • Mentor and coach team members to develop technical knowledge in analytics and build commercial/business acumen.
  • Developed and implemented "Insight Hub," a comprehensive reporting and data insight solution, resulting in significant operational savings.
  • Created and automated an EI tracking and approval workflow using Power Apps and Power Automate, adopted organization-wide for tracking dollar-saving efficiencies.

Senior Executive PMO

Amadeus Software Labs
07.2018 - 07.2020
  • Set up the PMO governance framework for the Infrastructure Innovation Program.
  • Developed Power BI reports for project and program performance tracking.
  • Managed program budgeting and financial tracking.
  • Automated the Hardware Planning intake process using VBA, resulting in significant operational savings.
  • Traveled Onsite to plan budget forecasts and action items.
  • Cross-trained team members across the globe to effectively manage the program.
  • Developed governance structures in Confluence using functionalities like Hierarchy, Excerpt, Pivot Macro, Filter, and Excel Macro.

Business System Consultant 3

Wells Fargo
07.2013 - 07.2018
  • Prepared customized reports for management using Oracle Discoverer and advanced Excel functions.
  • Ensured data sanity in BMC Remedy PAC2K for Technology Assets reports.
  • Migrated all reports from Oracle Discoverer, earning the Innovation Champion Award.
  • Wrote SQL queries for data extraction from SQL Studio.

Education

Post Graduate Diploma - Data Science & Business Analytics

University of Texas & Great Lakes
Bengaluru, India
10.2022

Bachelor of Engineering Technology - Mechanical Engineering Technology

BMS Institute of Technology
Bengaluru, India
08.2012

Skills

  • Data Analysis Tools: SQL, Excel, Power BI, Tableau, Python
  • Business Analytics and Commercial Acumen
  • Data Management and Data Science
  • Project Management and Leadership
  • Statistical Analysis and Predictive Modeling
  • Graphic Visualization and Dashboard Design
  • Problem Solving and Critical Thinking
  • Risk Management and Decision Making
  • Programming Languages and Quantitative Techniques
  • Power Apps and Power Automate

Certification

  • Microsoft Azure Fundamentals (AZ-900), Microsoft Azure
    Oct 2023
  • Project Management Professional, Project Management Institute
    Dec 2022 - Dec 2025

Timeline

Lead Technology Business Services Consultant(VP)

Wells Fargo
08.2020 - Current

Senior Executive PMO

Amadeus Software Labs
07.2018 - 07.2020

Business System Consultant 3

Wells Fargo
07.2013 - 07.2018

Post Graduate Diploma - Data Science & Business Analytics

University of Texas & Great Lakes

Bachelor of Engineering Technology - Mechanical Engineering Technology

BMS Institute of Technology
Pawan Lohumi