Guna Chandrasekaran
Troy,MI
Summary
- Guna has 25 years of Information technology experience and over 15 years of relevant experience in Data Ingestion, Analytics , Data Quality using SAP BW on HANA, SAP BW/4HANA, SAC with several end-to-end project implementation.
- Guna has successfully managed and delivered a Data Validation project for SDT migration for a Petro Chemical company S4 Migration.
- Guna has extensive experience implementing Data ingestion and can guide the team with industry best practices, cross-dependencies, and avoiding pitfalls.
- Guna guides the data modelers and the data engineers in producing optimized data models and leveraging the right data ingestion/processing patterns. He glues the Data and the Reporting team.
- Strong expertise in BW4HANA, BW on HANA, native HANA modeling, BW and Business Objects.
- Guna is SAP certified in BW4HANA and Explore Datasphere.
- Guna is certified in Azure Databricks.
- Guna is certified Engagement Manager.
- Guna has good exposure to Gen AI and Google Cloud Platform
- Guna has done SAP greenfield implementations in Albany international, British Petroleum, Cleco power, Southwire, Vought aerospace and BI migration projects in Beiersdorf and American water.
- Strong experience in data modelling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions and measures.
- Guna has domain experience and subject matter expertise in Life sciences, Aerospace, Industrial and distribution sector, Retail, Oil and Gas, Pharma and CPG. SAP Data and reporting experience in functional areas like record to report, SD, Inventory and Procure to pay, COPA, APO and TPM process knowledge. Knowledge of SCRUM framework/agile work methods & tools (Jira, Confluence).
Overview
30
30
years of professional experience
Work History
Managing Delivery Architect
Capgemini
- Guna has 25 years of Information technology experience and over 15 years of relevant experience in Data Ingestion, Analytics , Data Quality using SAP BW on HANA, SAP BW/4HANA, SAC with several end-to-end project implementation
- Guna has successfully managed and delivered a Data Validation project for SDT migration for a Petro Chemical company S4 Migration
- Guna has extensive experience implementing Data ingestion and can guide the team with industry best practices, cross-dependencies, and avoiding pitfalls
- Guna guides the data modelers and the data engineers in producing optimized data models and leveraging the right data ingestion/processing patterns
- He glues the Data and the Reporting team
- Strong expertise in BW4HANA, BW on HANA, native HANA modeling, BW and Business Objects
- Guna is SAP certified in BW4HANA and Explore Datasphere
- Guna is certified Engagement Manager
- Guna has done SAP greenfield implementations in Albany international, British Petroleum, Cleco power, Southwire, Vought aerospace and BI migration projects in Beiersdorf and American water
- Strong experience in data modelling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions and measures
- Guna has domain experience and subject matter expertise in Life sciences, Aerospace, Industrial and distribution sector, Retail, Oil and Gas, Pharma and CPG
- SAP Data and reporting experience in functional areas like record to report, SD, Inventory and Procure to pay, COPA, APO and TPM process knowledge
- Knowledge of SCRUM framework/agile work methods & tools (Jira, Confluence).
Data Validation lead for SDT Data Migration
Capgemini
07.2023 - 05.2024
- Guna led the Data validation activity for Selective data transition for Chevron PetroChemical S4 implementation
- Guna was responsible for following activities: Client management for scope and delivery excellence, Requirements gathering, Business requirements documentation, Functional specifications, Data Architecture and Data modeling, Create Data quality reports to identify count issues due to migration for all functional areas, Expertise in design and development of Attribute comparison reports to identify missed data, Automate validation of including and excluding critical master data before migration, Strong SQL knowledge and experience, Experience in handling large volumes of data by processing/transforming as per requirement in optimal way, Experience in mapping business requirements to the technical architecture design and data model, Technical specifications, Lead and manage 15+ team members on various implementation activities in this project, Change management and manage technical milestones for change Request, Use Agile methodology and best practices, Lead Testing, Cutover, Go live and Support.
BI Manager for Analytics implementation
Capgemini
04.2022 - 06.2023
- Guna lead the Reporting and Analytics domain for Boston Scientific Magellan S4 implementation
- Guna was responsible for following activities: Client management for scope and delivery excellence, Requirements gathering, Business requirements documentation, Functional specifications, Data Architecture and Data modeling, Expertise in Enterprise Native HANA Data Warehouse development projects, Expertise in design and development of SAP HANA models such as tables, Views (Attribute, Analytic, Calculation views and Native views), Experience in data model content objects creation and knowledge on DU handling, Strong SQL knowledge and experience, Experience in handling large volumes of data by processing/transforming as per requirement in optimal way, Strong Data Provisioning skills BODS/SDI/ SDA from various SAP and Non-SAP Source Systems to SAP HANA, Experience in mapping business requirements to the technical architecture design and data model, Technical specifications, Lead and manage 15+ team members on various implementation activities in this project, Change management and manage technical milestones for change Request, Use Agile methodology and best practices, Lead Testing, Cutover, Golive and Support.
Lead Techno Functional Architect in BW HANA, BPC
Capgemini
09.2019 - 02.2022
- Guna played a Project leader and Lead Functional Architect role in a Bard integration to Becton Dickinson for BW/BPC implementation
- As part of the implementation, he was responsible for the following activities: Requirements gathering, Business requirements documentation, Functional specifications, Data Architecture and Data modeling, SME in Enterprise data, Technical specifications, Design and Build backend objects and BPC enhancements, Lead offshore team of 10 on various implementation activities in this project, BW on HANA, BPC 10.0, Bex Reporting, NLS Modeling, Performance tuning of BI objects
- Guna played a Lead role in this project guiding the team in following the templates and do fit gap analysis, Design, development and implement for Bard integration project, S4 HANA integration for BW/BPC, BW 7.4 to 7.4 upgrade.
BW Lead
IBM
06.2019 - 09.2019
- Guna was the BW lead in this BPC implementation to support all data integration related to consolidation and planning
- Software / Languages: BW4HANA, BPC10.1
Lead Techno Functional Architect in BW HANA, BO
IBM
05.2016 - 05.2019
- Guna played a Senior Techno Functional Architect role in a BI implementation on HANA for a major Oil Company
- As part of the implementation, he performed the following activities using industry best practices: Requirements gathering, Business requirements documentation, Functional specifications, Data Architecture and Data modeling, SME in Enterprise data, Technical specifications, Design and Build backend objects and Dashboards in design studio, UAT, Cutover, Work effectively with remote and offshore teams, BW on HANA, WEBI, Dashboards, Lumira Analysis for Office, Bex Reporting
- Guna played a Lead role in this project guiding the team in following the templates and do fit gap analysis, Design, development and implement for America BI Implementation for Lubes division.
BW Lead
IBM
12.2015 - 04.2016
- Guna played a major role in a HANA side car implementation and worked on use cases for Production order variance and Forecast Accuracy
- Understand the use cases, identify the back end ECC tables and find the right virtual data model that fits the requirement and visualize the data in Lumira, and Microsoft Office analysis Used best practices for HANA modeling and naming conventions
- Successfully finished the POC on time and demonstrated it to the client
- Software / Languages: BW on HANA, ECC, Analysis for Office, Embedded analytics
BW Lead
IBM
09.2015 - 11.2015
- Guna played a major role in a BW on HANA migration for an industrial client
- He was responsible for the pre and post migration activities from BW 7.0 to BW 7.4 on HANA
- He provided best practices and guidance and worked closely with the client for a successful migration
- Software / Languages: BW on HANA, ECC, Analysis for Office
BW Lead
IBM
02.2015 - 09.2015
- Guna as the BI Lead took over the development from another resource who had to leave IBM in middle of development for Sales related BI architecture
- Guna was also scoped to do the development for Distribution related BI development and developing the reports
- Guna was responsible to guide the BI team in following best practices and trouble-free implementation
- Guna met the following objectives in Southwire project: Test and Complete development for Sales and Billing BI architecture and reports, Design, develop, and test distribution related BI architecture and reports, Performance Tuning of existing BI landscape, Provide guidance to best practices on BI and BOBJ development, Design and ensure the dashboard development was complete and to the expectations of the client, Create successful transition plan from offshore to Southwire support team, Manage the BI offshore resources
- Operating Systems: Windows, Software / Languages: BW 7.3, ECC, Analysis for Office, Business objects
BW/BI Solution Architect
Decision First
02.2015 - 09.2015
- Guna was responsible for creating custom solution for customer analytics in BW
- Different metrics related to customer were extracted from different areas of CRM and consolidated at a Customer level
- Software / Languages: BW 7.3, ECC, Analysis for Office, Business objects
BW Solution architect
IBM
03.2013 - 05.2013
- In this role, Guna designed and developed a solution for revenue analysis
- As an architect, he designed a solution for revenue recognition using BW as backend and Explorer and WEBI reports at front end.
BW/BO Lead architect
IBM
08.2012 - 02.2013
- Guna was responsible for designing and developing a solution for Capital and Spend Reporting implementation
- As an architect, he designed a solution for Capital and spend reporting using BW as backend and Xcelsius, Explorer and WEBI reports at front end.
BW Solution architect/Team Lead
IBM
01.2012 - 08.2012
- In this role, Guna gained valuable experience in creating a BW solution for Supervisor Reporting implementation
- As an architect, he designed a solution for Supervisor reporting using BW as backend and Xcelsius and WEBI reports at front end.
BW Architect
IBM
09.2008 - 12.2009
- Guna was responsible for upgrading Warehouse management, Inventory management related BW reporting from BW 3.5 to 7.0
- Responsibilities: Lead BW architect involved in providing strategic, functional and technical directions to the SAP Business Intelligence team that implemented the procure-to-pay data warehouse solutions that involved Warehouse management and Inventory management and External DB sources for complex web based reporting & analytics and data mart requirements
- Collaboration with BDF –Germany to follow BW standards set globally and build a WM and Inventory reporting for BDF –US
- Designed and developed custom architecture for BW reporting on Warehouse management module Challenges were to create function modules for generic data source to combine deliveries and handling units
- Challenges with transfer order view related deltas
- Was overcome by created info packages to have code to extract last 3 days data
- Defined the strategy for BI Back End and BEx transports and acted as the lead to oversee every BI transport migration.
BW Architect
Albany International
04.2007 - 09.2008
- Guna was responsible for providing functional and technical solutions in RTR, Consolidations streams that involved financial and controlling functional areas
- Responsibilities: Guna was a BW architect involved in providing strategic, functional and technical directions to the SAP Identify reporting requirements, manage, rationalize scope of FI,CO related BW reports for company
- Designed complex data models to deliver customized reporting solutions for data sourced from multiple sources including ECC, Oracle and flat file
- Derived scope, conceptualize architecture and identify base architecture based on scoped reporting requirements Followed methodology of Layered scalable architecture sourcing layer, staging layer and reporting layer architecture for scalability and storage
- Created unit testing, integration testing, load testing scripts and executed it
- Documented the results and applied it to change management based on priority
- Partnered with client and trained them over the course of development and made them successful after the completion of the project
- Created training documents for user training in BW reporting and conducted training sessions.
Datawarehouse Architect
Daimler Chrysler
11.1994 - 11.2006
- Lead analyst for the team that designed, configured, developed and implemented a complex multi-tier Business Intelligence model that provides reporting solutions for purchasing, inventory, Sales and finance areas
- Derived scope, conceptualize architecture and identify base architecture based on scoped reporting requirements Created custom architecture to load flat files for spend reporting using datamart layer
- Created Webi reports on spend analysis, Sales related reports Every possible performance tuning technique was utilized to accomplish the best performance on reporting as well as data loads Worked in different software tools related client server architecture, Business objects, Mainframes, Data modeling, databases.
Education
Bachelor of Science - Computer Science
Madras University
Chennai05.1991
Skills
- SDT migration and Data validation
- BW4HANA
- BW (35 to 75)
- HANA Modeling
- HANA Views (SQL and Calculation)
- HANA Performance tuning
- NLS IQ Implementation
- Datawarehouse Cloud/DataSphere
- SAC
- Analysis for Office
- BW integration with BPC/APO
- Solution Architect – Data and Analytics
- Business Analysis and Development
- Excellent Communication and Interpretation skills
- Solid presentation skills
- Strategic thinker with strong insight of finance, logistics, Project systems, Materials Management, Sales and distribution with respect to Business Intelligence Analytics
- Pro-active and accountable with the confidence to intervene when requirements are not clear, and complexities need to be directly addressed
- Open and team-oriented communication, providing a transparent view on what is being worked on, any risks and outlook
- Guna is solution orientated and be able to work independently Reporting
- Well versed in visualizations and their usage - charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures
- Good understanding in the handling of templates and design specifications
- Good overview for which requirements stories can be used and when applications
- Open and interested in the regular updates of SAP and the new features that come with it
- Design development
- Technical Architecture Design
- Motivated self-starter
Personal Information
Title: Managing Delivery Architect - Data and Analytics
Timeline
Data Validation lead for SDT Data Migration
Capgemini
07.2023 - 05.2024
BI Manager for Analytics implementation
Capgemini
04.2022 - 06.2023
Lead Techno Functional Architect in BW HANA, BPC
Capgemini
09.2019 - 02.2022
BW Lead
IBM
06.2019 - 09.2019
Lead Techno Functional Architect in BW HANA, BO
IBM
05.2016 - 05.2019
BW Lead
IBM
12.2015 - 04.2016
BW Lead
IBM
09.2015 - 11.2015
BW Lead
IBM
02.2015 - 09.2015
BW/BI Solution Architect
Decision First
02.2015 - 09.2015
BW Solution architect
IBM
03.2013 - 05.2013
BW/BO Lead architect
IBM
08.2012 - 02.2013
BW Solution architect/Team Lead
IBM
01.2012 - 08.2012
BW Architect
IBM
09.2008 - 12.2009
BW Architect
Albany International
04.2007 - 09.2008
Datawarehouse Architect
Daimler Chrysler
11.1994 - 11.2006
Managing Delivery Architect
Capgemini
Bachelor of Science - Computer Science
Madras University
Similar Profiles
Karan TalwarKaran Talwar
Associate Consultant | Cloud Infrastructure Services at CapgeminiAssociate Consultant | Cloud Infrastructure Services at Capgemini
Mithilesh KUMARMithilesh KUMAR
QA Leads – GE at CapgeminiQA Leads – GE at Capgemini
Richa SinghRicha Singh
People Manager & Solution Architect at CapgeminiPeople Manager & Solution Architect at Capgemini
Mani KalivarapuMani Kalivarapu
Oracle EDI Consultant (Implementation and Support) at CapgeminiOracle EDI Consultant (Implementation and Support) at Capgemini
JESSICA LEWISJESSICA LEWIS
Test Development Specialist at Independent ContractorTest Development Specialist at Independent Contractor