Barnali Borah
Summary
Barnali has over 15 Years of experience in designing, developing, and delivering quality and insightful Data Warehouse and Business Intelligence solutions for clients.
Experienced in high quality implementation and development of data models, Web Intelligence (WebI) Reports and BO Universe Designing, Crystal Reports and SAP Analytics Cloud (SAC) Reporting and SAP SAC Planning (SACP) reports.
Expert in working with SAP BusinessObjects BO 4.2, BI 4.3 including Information Design Tool (IDT), BI Launchpad, Web Intelligence & Analysis for Office; BOBJ Administration & Security setup/ maintenance tasks.
Rich experience in working with SAP Analytics Cloud Planning, Forecasting, Budgeting reports, critical business KPIs reports and dashboards. Experience with creating SAC data models, planning models, Importing and exporting data for different business requirements.
In-depth knowledge of creating data models, planning models, stories, analytical apps, digital boardroom with Live & Acquired/Import connections to S/4 HANA CDS Views, SAP HANA Views, and flat files.
Experience in developing S/4 HANA CDS Views, S/4 HANA Exposure to SAP ECC, SAP BW,SAP BusinessObjects Data Service, with rich experience in the data modeling process.
Have been part of many Implementation/ Migration projects for ECC to SAP HANA and SAP BO migration projects. Have successfully delivered end-to-end solutions. Involved in requirements gathering with business team, designing the solutions, deployment and UAT process.
Onshore Lead experience of managing a team of 20 members from different technologies across multiple locations. Ability to manage and deliver multiple priorities in a constrained timelines and worked effectively across various time zones with global teams .
Overview
16
16
years of professional experience
Work History
SAP Reporting Analytics Lead(SAC, SAP Analysis for Office, SAP BO and S4 HANA Cloud)
Walt Disney
Orlando
09.2024 - Current
- Company Overview: The client is American multinational mass media and entertainment conglomerate headquartered in Burbank, California
- Lead SAC and BO reporting team and interacting with the business and understanding their requirements for End-to-End implemention/enhancement of SAC Analytics and Planning FP&A Reports and Financial BO WebI reports
- Led pilot projects and initiated the creation of several Proof of Concepts (PoCs) from inception, actively participating until their approval and overseeing the end-to-end implementation of projects
- Successfully set up SAC in the system architecture by managing the SAC connections, setting up Cloud connectors, import/live data connections and resolving SAC connection issues
- Configured connections between SAP SAC, SAP BW, SAP Public Cloud system and non-SAP systems
- Successfully configured and optimized SAC connections, enhancing data accessibility and reporting efficiency
- Maintained Security Configuration at Model, Dimension, Story and File Structure Level
- Published and scheduled SAC jobs and monitoring the schedules and troubleshooting issues
- Hands on experience in driving the planning data models and working with categories actual, budget, planning, forecast, rolling forecast
- Provided Technical training to business users
- The client is American multinational mass media and entertainment conglomerate headquartered in Burbank, California
SAP Reporting Analytics Lead(SAC and SAP Technical Consultant)
Fortitude Re-insurance
Nashville
10.2023 - 08.2024
- Company Overview: The client is an American multinational corporation that provides Insurance, Investment & Retirement Solutions
- Interacting with the clients and understanding their requirements for the implemention/enhancement SAC Planning and Forecasting FP&A Reports, CRs for Consolidations process with S/4HANA Cloud
- Designed and implemented SAC Planning model for new budgeting and forecasting requirements
- Building ODATA services/ Custom CDS views/ custom analytical queries in SAP Public Cloud for ad hoc business SAC reports
- Helping the team with UAT testing of SAC Planning reports
- Support migration and deployement of SAC Planning reports to Production environment post UAT
- Post Go-Live support and part of Hypercare team to resolve any Production issues
- The client is an American multinational corporation that provides Insurance, Investment & Retirement Solutions
- Impact: Leading a team of 10 members from client and vendor side and managing timely delivery of objects from SAC, BO and S4 HANA Cloud
SAP Reporting Analytics Lead(SAC, BO, AO & Tableau)
Deloitte
Minnesota
05.2021 - 10.2023
- Company Overview: The client is an American multinational corporation that provides Insurance, Investment & Retirement Solutions
- Interacting with the clients and understanding their requirements for the implemention/enhancement of SAC Planning and Forecasting Reports and SAP HANA CRs
- Designed and implemented SAC planning models
- Helping the team to set up the HANA and SAC system coordinating with BASIS and SAP team to resolve any issues
- Training users on SAC reports
- The client is an American multinational corporation that provides Insurance, Investment & Retirement Solutions
- Impact: Leading a team of 10 members from client and vendor side and managing timely delivery of objects from SAP SAC
- Technical Environment: SAP BO 4.3, SAP Analytics Cloud, Power BI ,MS Office Suite, JIRA, HPQC
Reporting SME(BO, SAC)
Deloitte
Florida
03.2020 - 05.2021
- Company Overview: The client is an American telecommunications company which offers wireless products and services
- Onshore Lead SAP Analytics (BO, AO and SAC) SME
- Interacting with the clients and understanding their requirements for the implemention/enhancement of Web Intelligence reports , AO reports , SAC Analytics and Planning Reports
- Web Intelligence server and admin activities co-ordinator
- Development/testing of SAC planning models
- Collaborated with cross-functional teams to align BO WebI reports with business goals
- Data integration between SAC and ERP systems ensuring real time updates and consistency
- The client is an American telecommunications company which offers wireless products and services
- Impact: Leading a team of 10 members managing timely delivery of objects from HANA and BOBJ & SAC
- Technical Environment: Business Objects 4.3, SAC
Reporting Lead (BO, SAC, Tableau, BODS)
Deloitte
Palo Alto
12.2019 - 03.2020
- Company Overview: This is one of the world’s leading Hi-Tech companies
- The client provides cloud computing and platform virtualization software and services
- Onshore Lead leading team of 30 members
- Interacting with the clients and understanding their requirements for the implemention/enhancement of CRs for SAP BO and SAC reports
- Responsible for timely delivery of deliverables from the team
- Development of Workflows, Data flows based on the requirement specifications in BODI/BODS
- This is one of the world’s leading Hi-Tech companies
- The client provides cloud computing and platform virtualization software and services
- Impact: Leading a team of 30 members from client and vendor side and managing timely delivery of 2500 objects from migration from OBIEE system to BO 4.3 WebI reports
- Technical Environment: Business Objects 4.3, Business Objects 4.2, SAC
SAP BO Universe/WebI Developer
Deloitte
Cambridge
07.2018 - 11.2019
- Company Overview: This is one of the world’s leading biotechnology companies
- The client’s research efforts are built on understanding the underlying biology of complex diseases with a focus on developing therapies for patients with serious illnesses that currently have few, if any, treatment options
- Part of Business Objects WebI Reports Development team
- Interacting with the clients and understanding their requirements for the implemention/enhancement of US/France WebI Reports
- Enhanced the existing Universes as per Phase Design Development by adding Derived tables and Classes and Objects and involved in developing WebI reports from universe
- Analysing data mismatch or data missing in all US/France WebI reports and finding the root cause in Reports and backtracing to ETL process
- Involved in implementation of ETL process which includes Data Modeling, Data Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, and Process Flows
- Organized data in reports by using filters, sorting, ranking and highlighted data with Alerter
- Worked on Hierarchy Levels and Developed hierarchies to support drill down reports
- Also involved in the production support, fixing bugs and daily ETL Data load Monitoring of the ETL jobs
- This is one of the world’s leading biotechnology companies
- The client’s research efforts are built on understanding the underlying biology of complex diseases with a focus on developing therapies for patients with serious illnesses that currently have few, if any, treatment options
- Impact: Delivered 30 complex BO reports as a part of reporting and analytcs team for effectively handling yearly US Federal Reports submission
- Technical Environment: Business Objects 4.1, Business Objects 4.0, Oracle SQL Developer1.5.1, Oracle 11
Functional Unit Testing Lead
Deloitte
Minneapolis
11.2017 - 06.2018
- Company Overview: The client is a global leader in medical technology, services, and solutions
- They apply science and global resources to bring therapies to people that extend and significantly improve their lives
- Have lead the FUT offshore team comprising of 5 members for testing of Informatica, HANA views and BO Reports
- Responsible for creation of all the FUT test cases, user test cases, understanding and documenting the existing reports functionality for enchancing the reports
- Responsible for the complete delivery with respect to functional testing of the entire end to end business process from SAP ECC to SAP HANA to SAP BO
- The client is a global leader in medical technology, services, and solutions
- They apply science and global resources to bring therapies to people that extend and significantly improve their lives
- Technical Environment: Business Objects 4.0, SAP HANA Studio
SAP BO Universe/WebI Report Developer
Deloitte
Indianapolis
08.2013 - 11.2017
- Company Overview: The client is a centralized reporting system which has been built to cater to the operational reporting needs of Customer Operations, MIS, Marketing, Finance, Sales and Field Services departments of the client
- Interacted with the Business Users to analyze the business process and gathered the requirements
- Involved in implementation of ETL process which includes Data Modeling, Data Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, and Process Flows
- Extensively worked in developing transformations and mappings using OWB
- Designed and scheduled process flows with multiple parallel paths by understanding the criticality and dependency of all transformations
- Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI 3.1
- Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts
- Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc reports by accessing the Universe
- Designing, developing and deploying using Universe Designer, WebI, Info View and CMC
- Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports
- Worked on Hierarchy Levels and Developed hierarchies to support drill down reports
- Also involved in the production support, fixing bugs and daily ETL Data load Monitoring of the ETL jobs
- The client is a centralized reporting system which has been built to cater to the operational reporting needs of Customer Operations, MIS, Marketing, Finance, Sales and Field Services departments of the client
- Technical Environment: Business Objects XI 3.1
WebI /BODS Report Developer
Capgemini India Pvt. Ltd.
Chicago
10.2011 - 08.2013
- Company Overview: The client is one of the largest health benefits companies in the United States
- Part of Business Objects WebI Development team and ETL team
- Involved in developing WebI reports from universe
- Organized data in reports by using filters, sorting and applying drill down feature
- Involved in functional and unit testing of WebI reports
- Also involved in the production support, fixing bugs and daily Data load Monitoring of the BODS jobs
- The client is one of the largest health benefits companies in the United States
- Technical Environment: Business Objects 4.0, SAP BODS
WebI Developer
Tata Consulting Services (TCS)
India
04.2009 - 08.2011
- Company Overview: This is one of the world’s leading biotechnology companies
- They apply science and global resources to bring therapies to people that extend and significantly improve their lives
- Part of Business Objects WebI Reports creation and enchancement team
- Understanding the clients requirement for the implemention/enhancement of WebI Reports for US market to built same kind of reports for EU markets
- Creating documents for Functional Design Document,SIT test cases, User test case and understanding and documenting the existing reports functionality for enchancing the WebI reports as per the new requirement
- This is one of the world’s leading biotechnology companies
- They apply science and global resources to bring therapies to people that extend and significantly improve their lives
- Technical Environment: BOXI, Oracle 11g
Education
B.E. - Information Science and Technology
Visvesvaraya Technological University
01.2008
Skills
- SAP Analytics Cloud
- SAP SAC Planning
- SAC Predictive Analytics
- SAP Analysis for Office
- SAP S/4 HANA
- SAP BI/BO
- SAP BW
- SAP HANA
- SAP Datasphere
- Data Modeling
- Data Migration
- Team Management
Timeline
SAP Reporting Analytics Lead(SAC, SAP Analysis for Office, SAP BO and S4 HANA Cloud)
Walt Disney
09.2024 - Current
SAP Reporting Analytics Lead(SAC and SAP Technical Consultant)
Fortitude Re-insurance
10.2023 - 08.2024
SAP Reporting Analytics Lead(SAC, BO, AO & Tableau)
Deloitte
05.2021 - 10.2023
Reporting SME(BO, SAC)
Deloitte
03.2020 - 05.2021
Reporting Lead (BO, SAC, Tableau, BODS)
Deloitte
12.2019 - 03.2020
SAP BO Universe/WebI Developer
Deloitte
07.2018 - 11.2019
Functional Unit Testing Lead
Deloitte
11.2017 - 06.2018
SAP BO Universe/WebI Report Developer
Deloitte
08.2013 - 11.2017
WebI /BODS Report Developer
Capgemini India Pvt. Ltd.
10.2011 - 08.2013
WebI Developer
Tata Consulting Services (TCS)
04.2009 - 08.2011
B.E. - Information Science and Technology
Visvesvaraya Technological University