Sr. Sap Bi/bo/hana Lead Resume
Houston, TX
SUMMARY
- Over 18 years of experience in IT. Over 13 years of multi - national ERP industry experience in SAP BW/BI/BO, Integrated Planning, ECC, SAP S/4 HANA and BW/HANA involving major global implementation projects.
- Experience in the functional areas of SAP ECC SCM, SRM, CRM, TPM, PM, SD and FI
- Worked extensively on Integrated planning and using different modelling scenarios using aggregation levels
- Extensive Experience in Business Objects, Tableau and other reporting tools including self-analytics building Universe, Webi Reports and Dashboards by extracting data from SAP BEX query, Hyperion, Data services, SAP BW Cubes and HANA Views
- Experience working with Business Objects Lumira, Design Studio, Tableau and MS PowerBI reporting
- Extensive experience working with HANA Studio and HANA Views and latest modelling tools & Objects (Advance DSO, Composite Provider, Open ODS View & Mixed Scenarios)
- Extensive working knowledge on SAP BW4HANA modelling - Open ODS Views, Transient providers, LSA and LSA ++, ODP API (SLT, SDI and SLT)
- Extensive experience working with PowerBI, Microsoft Azure and SAP Analytic Cloud
- Experience in managing multiple BI teams (onsite & offshore) and demonstrated senior-level leadership skills and have experience in guiding the SAP teams to build a self-sustainable SAP platform and coordinated resource capacity, prioritizes and lead the scoping effort.
- Strong experience working with business teams and implementing Agile methodologies
TECHNICAL SKILLS
Languages: ABAP/4, Java, XML, SQL, PL/SQL, C, C++, VC++
Reporting: SAP BEX/WAD, Business Objects
ERP: SAP R/3 3.1, 4.X, mySAP (ECC 5.0, ECC 6.0),SRM,MOC,HANA
DW /ETL Tools: SAP BI 3.x, SAP BI 7.x,SAP HANA/BODS, SAC (SAP Analytics cloud)
OS: Windows 7/8/10/NT/2000, Sun Solaris, UNIX, AIX.
Data Visuazation: SAP Analytics Cloud, Tableau, Xcelcious, Lumira & Design Studio, Power BI
Data Base: SQL Server, MS Sql, HANA, Oracle, DB2
PROFESSIONAL EXPERIENCE
Confidential, Houston TX
Sr. SAP BI/BO/HANA Lead
Responsibilities:
- Involved in requirements gathering and managed the team to assign and support the projects in timely manner with documentation and user training
- Worked with senior level managers and directors for establishing project plans and assigning several team members into different area (BOBJ, BW, Data Lake, Teradata, BODS etc)
- Involved in hiring the individual resources from onsite and offshore depending on the project needs / timelines.
- Involved in change management including JIRA creation and assignment and worked with Solman team and Basis team for change movement (CR, CD and Service now requests)
- Involved in several teams including Business users, Basis, Offshore developers.
- Working with BW HANA data modelling including Native HANA, SQL scripts, R integration, Data Lake and Teradata integration for different reporting needs
- Worked with business stakeholders to gather the business requirements and created Scope / Functional Specification documents for several reporting needs.
- Redesigned the existing data models for better performance and more frequent updates from the source system for latest data updates.
- Responsible for conducting business workshops, and prepared business case for SAP BW/4HANA financial reporting at company, division, store level, department, article level reporting.
- Worked with several teams to coordinate SAP incident resolution and speed up ongoing support.
- Worked with Cloud Analytics including SAP Analytic Cloud & Azure for different reporting needs
- Extensively worked with SAP Security and BASIS teams to implement SAP notes and SP upgrades and worked with user Authorizations and roles.
- Worked with several reporting teams to update PowerBI reports and coordinated with the Basis team for user authorizations and report refresh.
- Worked with Data lake, Teradata, and R serv teams to implement several reporting solutions.
- Involved in user training and documenting the reporting navigation to ease the user access.
Environment: BW/ 4 HANA, SAP CRM / TPM, SAP ECC 6.0, S/4 HANA, SAP BO 4.2, Analysis for Office 2.X, Power BI, Tableau, R, Data Lake, Teradata, Siebel, Lumira, Alteryx, Tableau, PowerBI
Confidential, Sugar Land TX
Sr. SAP BI/BO/HANA Lead
Responsibilities:
- Involved in full life cycle implementation of BW, BO and BW/4HANA environments.
- Strong experience on enhancing all LO cockpit data sources using standard user Exits for SD and MM and imported them by locking the users and reloaded the data using setup transactions.
- Worked with business stakeholders to gather the business requirements and implement the Financial BO Reports including Webi, BO Explorer, Xcelcious Dashboards and Lumira
- Worked with several teams to coordinate SAP implementations including BW upgrades and Support pack implementations, BW on HANA and BW/4HANA
- Worked on SAP HANA Cloud and Azure cloud for several business needs.
- Extensively worked with SAP Security and BASIS team in the end to end installation and implementation of BO tools, HANA and Upgrades including BW 3.5 to BI 7.0, BI 7.5 on HANA and ECC Enhancement packages
- Worked on creation of calculation views on several SAP modules including Finance, Plant Maintenance, Supply Chain and enabled them for reporting (AO, PowerBI etc.)
- Extensive experience working on BO Webi, Crystal reports and Xcelcious dashboards. Worked on CMC for scheduling the jobs and creating events and promotion management.
- Worked with several ticketing systems (Footprints, Rally, nDivision) to resolve the production support tickets and worked with BI &Functional teams along with business users to sped up resolving critical issues on time.
- Extensive experience working with SQL queries and SQL scripting. Worked on several stored procedures for BO universe requirements.
- Worked with custom CDS views on SAP delivered data sources and exposed as webservice and OData service.
- Worked with all the ETL extraction mechanisms available in HANA e.g: SDA, SDI, SLT and Data services
- Worked with SAP teams to implement BW/4HANA data modelling needs and enhanced existing NetWeaver BW models to HANA.
- Worked with Basis team to implement HANA CTS for transporting the Calc Views.
- Worked extensively with Microsoft Power BI tool and integrated HANA views and pulled data (Direct Query & Import) to demo the users on performance and usage of the tool with different visualizations (Example Supply Chain, Plant Maintenance & FI etc.).
- Undergone training and worked with SSIS & SSRS to load data & Built and Published the PowerBI reports into different workspaces and worked on PowerBI Gateway to schedule and refresh the reports periodically
Environment: BW 3.x/7.x, BW on HANA, BW/4HANA, SAP ECC 5.0 /6.0, SAP BO 4.X (4.0/4.1/4.2), Analysis for Office 1.X / 2.X, Lumira 1.31, Design Studio & Data Services, Microsoft Azure & Power BI, Tableau, Visual Studio, MS Sql Server, R and Python
Confidential, Grand Rapids MI
SAP BW/BI Sr. Lead Developer
Responsibilities:
- Developed reports using BEx Analyzer and BEx Query Designer. Used Aggregates, Restricted Key Figures & Calculated Key Figures for filtering and formula as per the requirement of query.
- Extensively used RSRT and RSECADMIN transactions for query testing, debugging and analysis authorizations.
- Created aggregates and compressed the InfoCube data for better performance.
- Extensively used BEX Web Application designer and other query tools for different reporting requirements.
- Worked on and supported several BW Integrated Planning related queries and reports
- Created web templates and published in to portal as iViews.
- Trained end users on testing the BW environment and built test cases.
- Involved in production support and ticket resolution using Confidential Emu
- Worked with IP Planning cubes and built the Budgeting and Forecasting report as per the user needs
- Created multiple roles and restricted the access using authorization object S RS AUTH given to each role separately.
- Involved in documentation and trained End - user in using BEx analyzer and Web Portal.
Environment: SAP BI 7.0, BW - IP, SAP R/3 4.7, Windows, Flat Files and Legacy systems
Confidential, Houston
SAP BW/BI Team Lead
Responsibilities:
- Involved in development of full life cycle BI upgrade & reporting applications.
- Created Scheduling plans for data load to use Process Chains in order to load Master Data and Transactional Data from SD, MM, PM, FI into BW.
- Modified and Developed New Queries on various Info Cubes related to SD. Extensively worked with Query building, Filtering, Structures, Free Characteristics, Calculated Key Figures, Restricted Key Figures and Variables.
- Created one info cube to load SD Quotes, Bookings, Backlog and Billing information using SAP best practice document BBB.
- Periodically monitored the performance of the cubes using SAP INFOCUBE DESIGNS.
- Extensively used Bex WAD and Visual Composer Web reporting functionalities.
- Involve in Production support for Delta and Full upload of Transactional and Master Data.
- Involved in documentation and trained End - user in using BEx analyzer and Web Portal.
Environment: SAP BI 7.01, BW3.5, SEM4.0, Oracle, Windows, FlatFiles & Legacy systems
Confidential, Houston, TX
Onsite SAP BI Lead Developer
Responsibilities:
- Carried out the requirement analysis with users.
- Involved in development of full life cycle BI reporting applications.
- End to End testing of interfaces. Involved in the Business and Technical design.
- Prototyping of Entire Data Model (according to CF-Layered Architecture Concept in Shell) and Reports before being sent to Offshore.
- Worked with planning team and extracted planning data and created process chains for periodic delta loads.
- Created and maintained supply chain KPI reports in BW.
- Created Multiple Table Views and Generic Data Sources According to the business requirement.
- Extensively used ABAP Conversion Routines in Transformations. and worked on Currency Conversions and Exchange Rates.
- Extensively worked on Transformations & Data Transfer Packages (DTP).
- Extended Transaction data and Master data by appending new data elements using enhancement component.
- Extensively Visual Composer for Web reporting and trained end users.
- Built new Multi Providers, aggregates to suit the business and reporting needs.
- Loaded Hierarchies (created using Sets) using Custom Data Sources and loaded Hierarchies from Flat files.
- Extensively worked on Data Marts and Info Spokes to send the Master Data Objects, DSO Objects and Master Data Files to Other BI systems.
- Scheduled Process Chains. (Local Master and Transactional Process chains and Meta Chains).
Environment: SAP BI 7.0, BW3.5, BOXI R2/R3, SAP ECC 6.0, Flat Files, ABAP/4, Windows
Confidential, WI
SAP BW ETL / Report Developer
Responsibilities:
- End to End testing of interfaces. Involved in the Business and Technical design.
- Carried out the requirement analysis with users.
- Create and maintain the objects necessary for loading flat file Master and Transactional data staging to PSA, ODS and Info Cubes.
- Created Update Routines for the ODS object and testing the data of the ODS.
- Extensively used ABAP Conversion Routines in Transfer Rules and Update rules.
- Extended Transaction data and Master data by appending new data elements using enhancement component.
- Built new Multi Providers, aggregates to suit the business and reporting needs.
- Developed reports using BEx Analyzer and BEx Query Designer. Used Aggregates, Restricted Key Figures & Calculated Key Figures for filtering and formula as per the requirement of query.
- Worked extensively in BEX analyzer, Web Template and browser defining queries using variable for characteristics and hierarchies.
- Involved in documentation and trained End - user in using BEx analyzer and BEx Browser.
Environment: SAP BI (3.5), SAP R/3, Flat Files, Informatica, ABAP/4, Windows, Oracle.