We provide IT Staff Augmentation Services!

Bi/bo Architect Resume

Evansville, IN

Summary:

Self-motivated, challenge-driven, and solution-oriented SAP BW consultant with 12+ years of IT experience, including 10 years of in depth industry expertise in SAP BW/BO for the ERP modules SD, MM, FI/CO, PM, CO-PA, QM, SCM,TM,APO and CRM. Well versed in latest technologies including HANA, SLT, BODS, and BOBJ reporting. Instrumental performer in multiple IT initiatives; including but not limited to server sizing, system refreshes, vendor selections, SOW reviews, ROI and impact analyses, requirements gathering, landscape design and architecture, integration, implementation, and post production support. Very much attuned to organizational values, culture, mission, policies and processes at all times.

  • Defined templates, process flows, models, coding standards and implemented industry best practices for ERP systems.
  • Excellent interpersonal, presentation, communication, negotiation skills and capacity to drive win-win outcomes.
  • Mentored and directed over two dozen development and team lead resources in a mixed onshore and offshore delivery model.
  • Worked closely with PMO for project and resource prioritization guidelines, change control and incident management.
  • Highly customer oriented, going the extra mile to find solutions, and communicating effectively to peers and executives.
  • Unparalleled problem-solving capabilities, able to identify alternative solutions to complex problems to benefit all stakeholders.
  • Extremely productive work habits and multi-tasking capabilities, able to juggle multiple projects and successfully follow through
  • Achieved 100% client satisfaction in over 5 SAP implementation projects with proven success in conducting CRPs, requirement gathering, design, project build, configuration, setup, system test and implementation, user support and training.
  • Experienced in SAP HANA implementation including programming Scripting, data modeling, security design, and application administration.
  • Implemented SAP HANA for a large American multinational communications company.
  • Completed 3 full-life cycle implementations of SAP BW which includes Data-Modeling (Star-Schema), Data Extraction, and Data Loading (Full/Delta Up-Load), including Business Explorer Query Analytics and Reporting Design.
  • Proficient in translating reporting key requirements as well as design and build the necessary data modeling, BW structures and reports, workbooks using Excel/macros.
  • Expert in BI Net Weaver 2004s, Transformation Rules, DTPS and DSO in BI 7.0 NetWaver2004s.
  • Expertise in BW components and functions like Design of Data Warehouse system, Data Marts, Data Modeling, Extraction from SAP and non-SAP systems, Performance Tuning, Complex Query reporting key Scenarios, bi-Portal Integration, and use of Business Content Objects.
  • Proficient in Extraction, Transformation & Loading (ETL) – Experienced in extracting data from Logistics (SD, MM, IM, PUR), FI, COPA, PM & generic data sources, Flat File source systems, Legacy Systems and finance modules (Non SAP R/3).
  • In-depth technical experience in SAP BW with good functional knowledge in FI/CO, SD, MM, SRM and HCM modules.
  • Set up of DB connect and UD connect for data extraction from non-SAP (Oracle, ODBC, and VSAM) systems.
  • Design and creation of budget planning modules in bi-IP
  • BW-Integrated Planning, Public Sector -> Financial Planning - Forecasting, Budgeting, Change management Support.
  • BW-Integrated Planning Consultant - SAP Retail Planning (Merchandising), Promotions Planning.
  • BW-IP, Managed CCA Planning Environment & models, Income Statement & Operational KPI's, IP -Upload Migration for Finance processes.
  • Worked on BW - Business Planning Applications for UPIE
  • BW-BPS/IP Implementation, and Integration with BCS, supporting as a SAP Business Consultant on BCS, BPS and BW/BI systems.
  • Conducting Workshops, Gathering Requirements, Creating Blueprints, Creating Specifications, Development, Testing, and documentation as per SAP Standards, End user Training.
    Worked as a Business Consultant and as a team member as per SAP requests.

TOOLS AND TECHNOLOGIES:

  • HANA Modeling Studio, Data provisioning (BODS and SLT), Security Authorizations, BOBJ Reporting.
  • SAP bi/BW, WAD, BEx Queries, ETL process (SAP and non-SAP data sources), SAP Data Services, BODS and SAP Lumira.
  • SAP FI/CO, SD, MM, IM, WM, SCM, Vistex and CRM across industries.
  • SAP Technical - SolMan, CTS, Net Weaver, ABAP, WSDL, CATT, BAPI, RFCs, ALE, EDI, IDOC, and tRFC.
  • ETL / EAI tools – BODS, Informatica and LSMW.
  • Service desk and batch automation tools – ServiceNow, Remedy, Autosys, Sharepoint, Impact, and Tivoli.
  • Business process improvement methodologies – Six Sigma, ITIL, Lean, DMAIC, UML diagrams.
  • Project management tools – MS Visio, MS TFS, Visio, Word, Excel, Powerpoint, and Project.

PROFESSIONAL EXPERIENCE:

Client: Confidential, Evansville, IN

BI/BO Architect

Environment: SAP BW 7.3, SAP bi 4.1, ECC 6.0, SAP HANA 1.0 SPS7

Responsibilities:

  • Responsible for managing scope, planning, tracking, change control, aspects of the project.
  • Developed the Technical Documents, Unit Test scripts and deployed them in to the document repository.
  • Responsible for efforts estimation and get these estimates approved by the Business.
  • Writing Functional Specification based on the Business Requirement document.
  • Designed highly optimized data models to cater the reports for different Business Processes such Sales, Inventory, Purchasing and Finance Users.
  • Responsible to communicate with other SAP Teams and Non-SAP teams as when it is required thru Tele conferences.
  • Guiding the team to Build, Test and Deploy the objects within the delivery times lines as agreed.
  • Integrated data in the BW system by extracting data from ECC to BW by using new data models, for applications like Logistic, Manufacturing, Finance and Controlling.
  • Developed Info Objects, Info cubes, DSO, Multi Providers & Process chains as per design and the documents.
  • Setting-up of the extraction processes for the Finance Modules (FI-GL/AP/AR) using the standard as well as Generic extractors.
  • Setting-up of the data extraction procedures for Sales and Service process flows from SAP CRM system
  • Designing the Data Flows (Master Data & Transaction Data) in SAP BW to get the Data from different source System.
  • Writing Start Routines, End Routines with the help of ABAP for data manipulation and validating the data from different business tables.
  • Worked extensively on all the BEX Query development components like Structure’s, Restricted, Calculated Key figures, and Variables…etc.
  • Created reports in BEX and WAD and publishing and testing in Portal.
  • Created BICS connection using Information Designer Tool (IDT) to enable BEx Queries for BOBJ Reports.
  • Worked with Webi to build adhoc Queries for Sales, Inventory and Finance Users.
  • Created formatted reports using Crystal Reports 2011 to cater Finance users reporting requirements.
  • Worked with Sales and Finance Managers to gather the requirements to create POCs to show case the capabilities of SAP HANA
  • Involved in creating FDS and TDS for SAP HANA.
  • Involved in creating HLDs for SAP HANA.
  • Worked with SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
  • Performed Development tasks with SAP HANA programming including SQL, SQL Script.
  • Designed with SAP HANA Administration including managing schemas, data model objects.
  • Established SAP HANA Security including User Management, Roles.
  • Designed and created Universe based on Info Provider in BW.
  • Designed and created Universe based OLAP Queries in BW.
  • Designed and created reports using Web Intelligence in Business objects.
  • Designed and created reports using Desktop Intelligence in Business objects.
  • Worked with Business objects Administrator to configure Info View for different roles.
  • Formatted reports in Business objects and published.
  • Created calculated value fields in Business objects based bi key figures.
  • Published reports in dashboards
  • Developed HANA data modeling scenarios and activities such as adding a system, creating schemas, importing table definitions, adding connections setting preferences for the modeler
  • Loaded data into table definitions, suspended and resumed data loads, copied contents delivered by SAP, created information objects (packages, attribute views, analytic views etc.)
  • Gathered experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins
  • Gathered User Requirements, analyzed reporting requirements, performed Gap Analysis, evaluated Standard Business Content, designed and developed Information Catalogs – Data Mapping, Design of Functional and Technical specifications.
  • Involved in Migrating Infocubes and DSO into Optimized HANA Objcts

Client: Confidential, Houston, TX

BI/BO Solution Architect

Environment: SAP ECC 6.0, SAP bi 7.0 & SAP BO 3.1 XI

Responsibilities:

  • Involved in requirement gathering from the business users. Worked in estimating the efforts and get these approved by the business.
  • Involved in preparing technical specifications and functional description specifications.
  • Involved in design and developing Equipment Utilization Report (PM),Quality Notification Report (QM)
  • Involved in the design and development of workflow report, Report on Project Versions (PS), Involved in design and development of On Time Delivery report.
  • Worked in enhancement of standard Master Data Sources and Standard Transaction Data Sources
  • Involved extensively in currency conversions. Involved in development of reports for QM, PM, PS and Purchasing. In design of Info objects, DSO’s.
  • Info Cubes and Multi Providers as in the process of delivering the reports.
  • Involved partially in writing the code in BADI’s and EXIT’s for enhancing the standard and Generic Data Sources. As a member in writing variable Exit’s for reports. Involved in Start, End and Field level routines.
  • Involved in creation of Generic Data Sources using function Modules and views
  • Created Process chains to automate the process of loading data into data targets.
  • Extensively worked in publishing of Purchase and Inventory reports to EP using WAD. Involved in training the business users and preparing the user documentation.
  • SAP BO Consultant
  • Designed Universes on BEX Queries and Info Cubes as Data sources of SAP BW as backend. Developed Webi Reports for Logistics CRM and Finance Modules.
  • Worked on to enable end users to view the reports through Info View.
  • Created Dashboards using Xcelsius 2008 for Sales, Inventory and Finance Processes.
  • Worked with SAP Live Office to bring BW data into Xcelsius 2008 to design dashboard for Sales Revenue Vs Sales Organization.
  • Worked with SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
  • Performed Development tasks with SAP HANA programming including SQL, SQL Script.
  • Designed with SAP HANA Administration including managing schemas, data model objects.
  • Established SAP HANA Security including User Management, Roles.
  • Designed and created Universe based on Info Provider in BW.
  • Designed and created Universe based OLAP Queries in BW.
  • Designed and created reports using Web Intelligence in Business objects.
  • Designed and created reports using Desktop Intelligence in Business objects.
  • Worked with Business objects Administrator to configure Info View for different roles.
  • Formatted reports in Business objects and published.
  • Created calculated value fields in Business objects based bi key figures.
  • Published reports in dashboards
  • Developed HANA data modeling scenarios and activities such as adding a system, creating schemas, importing table definitions, adding connections setting preferences for the modeler
  • Loaded data into table definitions, suspended and resumed data loads, copied contents delivered by SAP, created information objects (packages, attribute views, analytic views etc.)
  • Gathered experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins
  • Gathered User Requirements, analyzed reporting requirements, performed Gap Analysis, evaluated Standard Business Content, designed and developed Information Catalogs – Data Mapping, Design of Functional and Technical specifications.

Client: Confidential, NJ

SAP BW Consultant

Environment: SAP ECC 6.0, SAP bi 7.0, SAP BO 3.1XI, XCELSIUS 2008

Responsibilities:

  • Responsible for delivering the Business Intelligence solutions to the end user with in a structured framework based around the SAP Business objects bi platform.
  • Gathered requirements from functional users in Sales and Finance for cross functional analysis.
  • Review and validate data loaded into the data warehouse for accuracy and at the same time, interacts with user community to produce reporting requirements.
  • Involved in the meetings with BP team to gather requirements for the enhancements.
  • Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
  • Responsible for Identifying Business Requirements from end-users. Installed Business Content, Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object.
  • Created custom info objects with master data attributes and texts. Enhanced delivered master data attributes and by enhancing the delivered master data extractors using both 7.0 and 3.5 paradigms.
  • Transfer rules, Transfer Structures, Update Rules, DSO, Cubes, Aggregates, queries and workbooks Perform unit testing and integration testing before moving the objects into quality system for UAT.
  • Monitoring Data Loads and Trouble shooting. Worked on the fixes for the frequently occurring issues.
  • Customized and maintained Data Sources for extracting data from Sales, Finance and Vistex modules.
  • Worked with the users for defining the reporting needs and helped design/develop.
  • Flexible queries using BEX reporting features like variables, exceptions and conditions in Sales and Finance areas.
  • Worked on back end development in order to meet the new reporting requirements.
  • Optimized queries run time by creating queries with Variables. Worked extensively on Logistics Cockpit and extracted data. The data included Sales Order, Delivery, Shipment, billing, Purchase, Goods Movement, and Stock Revaluation. Designed and developed open hub solutions for extracts to external systems.
  • Design and creation of query elements including restricted and calculated key figures, Demonstrated expertise in all areas of transformations including ABAP coding start routines and end routine.
  • Data cleansing and Error handling of PSA data and loading PSA data to ODS objects. Staged Data in the ODS before transferring to the Info cubes.

Client: Confidential, NJ

SAP BW consultant

SAP BI 7.0

Responsibilities:

  • Gathered requirements from functional users in Sales and Finance for cross functional analysis.
  • Involved in the meetings with BP team to gather requirements for the enhancements.
  • Helping the team in understanding the requirements and deploy the requirements within the timelines
  • Defined work packages and technical specifications for design, development and testing.
  • Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
  • The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, DSO, Cubes, Aggregates, queries and workbooks.
  • Worked with the users for defining the reporting needs and helped design/develop
  • Flexible queries using BEX reporting features like variables, exceptions and conditions in Sales and Finance areas. Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives.
  • Perform unit testing and integration testing before moving the objects into quality system for UAT.
  • Monitoring Data Loads and Trouble shooting. Worked on the fixes for the frequently occurring issues. Worked on back end development in order to meet the new reporting requirements.
  • Worked on continuous improvements such as tuning the performances of the data sources, PSA and Change log cleanup activities.

Client: Confidential

SAP BW Consultant

SAP BI 7.0

Implementation Responsibilities:

  • Developing new reports in FI-AR, FI-AP, FI-GL and SD based on the functional specs.
  • Involved in review the objects developed by team before deploying to the customers.
  • Participated in weekly review meetings to discuss the progress of the developments and the issues during developments.

Support Responsibilities:

  • Monitoring Data Loads and Involved in resolving critical issues.
  • Worked on Transports for moving new developments and Enhancements into quality system for user testing.
  • Build test environment in the QA system for end-users to test the reports
  • Automate the BEX Reports using BEX Broadcaster.
  • Creating support messages to track the support issues in Solution Manager.
  • Worked on lookups and customer exit variables. Worked with Transformations and DTPs.
  • Working on tickets that are reported by the business users.

Client: Confidential

SAP BW Consultant

SAP BW 3.5, BW Implementation and Support

Implementation Responsibilities:

  • Leading 6 members STBC Team.
  • Designing Technical Specifications based on Functional Specifications.
  • GAP Analysis.
  • Responsible for all the Deliverables with in the process area.
  • Guiding junior resources in their regular activities.
  • Interacting with onsite counter parts during issue resolutions.
  • Worked on activating the standard delivered Business Content in the form of Info Objects, Info Sources, ODS, Info Cubes.
  • Worked on data extraction of SAP R/3 (LO-Cockpit) system using various extractors.
  • Activated Data sources in SAP R/3.
  • Loaded Data into the ODS Object before populate the data into the Info Cube.
  • Created Generic Data Sources Using Function Modules.
  • Created Transfer Rules & Update Rules using ABAP routines wherever those required.

Hire Now