SUMMARY

• SAP BI Consultant with 8+ years of extensive experience in IT industry, which includes SAP BW/BI functional and technical experience playing various key roles in Design, development and production support.
• Business Intelligence experience using SAP BO 4.0/4.1.
• Extensive experience in SAP BW - Extraction, Data Modeling, Report development and Performance tuning.
• Experience in ABAP programming in writing and debugging the custom Enhancements for Data sources, Transformation, Routines and customizing the front-end variables.
• Experience in full life cycle implementations in SAP BI/BW. Involved in all phases of implementations starting from Requirements gathering, Gap analysis, Blue Printing, Realization, Production Support, Documentation.
• Extensive experience in writing Functional Specification containing standard SAP operational processes, reporting business entities and facts, and mapping of transactional and operational processes.
• Proficient in Data Mappings, Conversion Logics and Data Extraction from SAP R/3 (FI, MM, SD, PM and QM), UD & DB, flat files and BW using extraction structures such as LIS, LO Cockpit, CO-PA, FI, APO and Generic Extractors.
• Extensive experience in working with and developing custom Info objects, Info Providers, Info Sources, Transformations, DTP’s, DSO’s, Start and End Routines, and Multi Providers.
• Extensive experience with BI Accelerator (BWA) setup and index creation.
• Expert in using Remodeling Toolbox, Open Hub Destination and Analysis Process Designer (APD’s).
• Expertise in BW Reporting Tools, BEx Query Designer, Analyzer, and Web Application Designer (WAD).
• Designed Complex and Ad-Hoc queries in BEx Query Designer and created workbooks using BEx Analyzer using Conditions, Exceptions, Variables, Structures, Restricted Key Figures, Calculated Key Figures and RRIs.
• Experience in the planning and simulation modules (SEM) PS and IP such as Sales Planning, Cost Center Planning, and Forecasting and Balance Scorecard with integration of SEM with BW Resolution of BW problems relating to data load and mismatch of data.
• Proficient in performance tuning techniques involving evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Expert in scheduling and monitoring daily and weekly data loads. Experience in automating data loads using Process chains and Meta chains.
• Experience in transporting the objects across the landscape and fixing the issues in transports.
• Proficient in analyzing and resolving the Production issues.
• Extensively worked on designing and developing complex universes, which has several hundreds of objects, contexts, and aliases, aggregate aware functions and cascading prompts.
• Excellent Experience inIDT, UDT, WEBI, Dashboard Designer.
• Working experience on new features like Business layer, Data foundation, BICS Connections inSAP BO 4.0.
• Very good knowledge on HANA and its architecture.
• Strong planner and organizer with demonstrated ability to develop business solutions that increase efficiency, productivity, and profitability.

TECHNICAL SKILLS

ETL Tools: SAP BI 7.3, 7.0, BW 3.5 Netwaver7.4

ERP Packages: SAP ECC 6.0, R/3 4.7

Programming Languages: ABAP/4, C, C++, SQL, T-SQL

Operating Systems: Windows, UNIX

Web Technologies: HTML, XMLReporting Tools BEx Reporting, BO 4.0/4.1 (WEBI, Dashboard designer, IDT, UDT), Tableau

Databases: Oracle 11g, SQL server 2012.

PROFESSIONAL EXPERIENCE

Confidential, Center Valley, PA

Sr. SAP BI/BO Developer

Environment: SAP BI 7.3, BO 4.1, ECC 6.0, SD, MM, PS, Inventory, FI-GL, BWA, BEx Analyzer, Query Designer, Webi

Responsibilities:

• Involved in the run, maintenance and support of the existing SAP BI system.
• Worked on Order Analysis designing, developing BI data models and built the reports.
• Worked on Actual inventory, Retail sales, Actual Open Orders and Wholesale shipment flows for Current and Historical data.
• Worked on Inventory redesign which involves addition of more fields with complete different flow.
• Build Transactional and Master Process Chains for periodic upload of data and used to send the Daily OTIF, Distribution Center reports to the Users.
• Developed the complex ABAP enhancements like User exit functions, ABAP enhancements in ECC-BI CMOD, and also in BI data modeling like start routine and End routine.
• Main point of contact for the current Global BI Project-Athena.
• Configured and customized applications for FI/GL, SD and MM modules. Global implementation experience migrating non-SAP systems into BW & flat file extracts.
• Extensively involved in creating InfoCubes in PS module.
• Designed Technical Specs for extractors, DSOs, Open hubs, Cubes and reports for the project.
• Created many Hierarchy, Text and Attribute data sources with the flow and did complex look-up from the master data tables.
• Created the Invoice Cube used to maintain the daily Invoice data coming from nine different sources.
• Created open hubs for capturing BW data and sending them to local Network drive.
• Created Rate Currency translation APD where the source is query built on a BPC cube to get the monthly conversion rates for different currencies, which eventually used in Athena to calculate different pricing objects.
• Worked on the daily loads of Orders, Inventory AP Invoice and AR Balance files from Non-US sources viz., Mexico, India etc. as a part of Project Athena.
• Created and refreshed the BWA indexes as well as DB stats.
• Created Bex queries for Manufacturing Backlog Report to show the number of materials that are in backlog.
• Utilized the features like filters and navigational attributes in Bex query to facilitate data analysis in a drill down or summarized way.
• Published the reports to the repository using broadcasting agent.
• Created OLAP Universes on SAP data (Info cubes / BEx queries) using the Information Design Tool.
• Involved in report design and provided BI report solution using IDT and WebI and Dashboards.
• Performance tuning of WebI reports and OLAP universes using optimization techniques.
• Build Universes and WebI reports for Cost Center Analysis Report, Purchase order Receipts, Item cost, Work Orders and Notification Data. Creating various Sales Analysis and other KPI's report used by business.
• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Assisted end users with reporting requirements gathering, designing and developing Webi reports along with resolving access related issues.
• Developed Pending Order Status Report to display pending Purchase Orders with drilldowns for material and vendor.
• Worked on day to day issues in production and resolved tickets to meet the SLAs.

Confidential, Foster City, CA

SAP BW/BO Developer

Environment: SAP BI 7.3, SAP ECC 6.0, FI, ABAP, BEx Analyzer, Query Designer, BO 4.0, Webi.

Responsibilities:

• Involved in a full Life Cycle Implementation Finance Business Intelligence Initiative which included current system study, business requirement gathering, gap analysis, system design, configuration, testing, cutover, go-live and production support.
• Installed Business Content for Financial and Profit Center Accounting Info Cubes and customized the FI-GL, FI-AR, and FI-AP business content cubes for meeting the business requirements.
• Extensively worked on with FI-GL, AR, AP, COPA data sources for extraction and loading of data from ECC to BI.
• Enhanced business content InfoObjects by adding new attributes and added code in User-exits to populate the data.
• Dealt with extractions involving standard FI-GL data source.
• Created Generic data source with Function module extraction method on ECC system.
• Worked on Enhancements of various InfoObjects depending on the requirement.
• Worked on Partitioning of Infocubes to meet the performance requirements.
• Designed and Developed a BADI for creating profit centers in the background whenever cost center is created through 'KS01' transaction.
• Extensively worked with FI - GL, AR, AP, New ledger data sources for extraction and loading of data from FI to BW.
• Worked on the Enhancement of Standard extractors 0FI GL 4, 0FI GL 10 and 0FI GL 14 and developed the custom data flow on the BW side.
• Customized existing financial Info cubes, ODS and Multi providers according to business needs in BI.
• Handled accounts payable cubes, accounts receivable cubes as a part of SAP BI implementation.
• Created the process model using APD to extract the data from General Ledger infocube into a flat file, this file eventually picked up by the datastage and loads the data into financial legacy system.
• Open Hub interface to transfer data from BI to Flat Files to load to an external system.
• Involved in troubleshooting the load failures and extensively used Error-DTP for correcting the loads.
• Created Process Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Designing the universe on BEx, Infocubes, DSO and Multiproviders and added custom objects like filters and calculated measures.
• Designed and Developed Complex Webi reports using Variables, Drill Downs, Sections, breaks, and Merged Dimensions etc. Worked on Designing & Developing several complexes interactive Dashboards on top of Webi reports built using Bex Queries on an OLAP Universe
• Design, Test and Validate Reports and Dashboards based on requirements.

Confidential, Boise, ID

SAP BI Developer

Environment: SAP BI 7.3, SAP ECC 6.0, SD, MM, Inventory, ABAP, APO.

Responsibilities:

• Worked primarily on the Production support and analyzing/developing/resolving the break fixes.
• Working on SAP Finance Technology Roadmap initiative where I am responsible for Analyzing, Developing, Testing and Supporting the SAP BW Applications.
• Designed and configured BI Content data sources, implemented the data flow, and validated data results.
• Coordinated weekly all -hands meetings, status reports and delegating BW activities to fellow team members onsite and offshore.
• Involved in technical and business analysis aspects of BW data warehouse project development, creation of test plans and scenarios, testing, and implementation; including significant hands-on work.
• Involved in analysis, design and development of Sales and Billing.
• Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration.
• Worked on Sales cubes such as Sales Overview (0SD C03), Delivery service (0SD C04) and Offers/Orders (0SD C05) etc.
• Developed Start Routines, Update Routines and Transfer Routines using ABAP.
• Extensively worked with ABAP Customer Exits and Custom Enhancement Projects for the BI reports to create Data Level security in the BEx Reports.
• Worked in upstream and downstream for sending data from BW to APO and APO to BW.
• Designed and developed interfaces for sending Actual data to APO for planning.
• Designed and developed Datasources to pull forecast data from APO to BW for reporting.
• Developed the custom BW transformations, DTP’s, DSO’s, Infocubes, SPO’s, OHD’s, APD’s and Multiproviders.
• Created the process chains and scheduled the data loads for master and transaction data loads.
• Worked with SolMan for transport requests management and fixed the issued resulting in transport process.

Confidential, Charlotte, NC

SAP BW Consultant

Environment: SAP BW 7.0, ECC, BEx Designer, FI-CO, Quality Center.

Responsibilities:

• Involved in the project from User requirements gathering, Business Blueprint, Realization and Testing Phases.
• Participated in teams and projects to understand business needs, design and recommend solutions, and provided support on the evolving BI environment.
• Responsible for design, development and extraction from ECC Source system and flat files to BW for FI & CO.
• Extensively involved in OLTP extraction of SAP (LIS, LO Cockpit, CO-PA and FI-L) and non-SAP data into SAP BW server and experience in Extraction from Flat files, SAP Data marts, SAP, Non SAP & DB Connect.
• Extensively worked with FI - GL, AR, AP data sources for extraction and loading of data from FI to BW.
• Customized existing financial Info cubes, ODS and Multi providers according to business needs in BI.
• Handled accounts payable cubes, accounts receivable cubes as a part of requirement.
• Worked with Project teams to develop new and evolve existing data warehouse subject areas by designing/modeling, developing, testing and implementing the appropriate data architecture (including PSAs, InfoCubes, InfoObjects, ODSs, InfoProviders, etc.) needed to meet business requirements and establish the Enterprise Data Warehouse.
• Improved query performance by creating aggregates on Infocubes.
• Extensively involved in the scheduling and monitoring process chain.
• Provided production support and administration of BW back-end operations to ensure data is successfully extracted from source systems, transformed, loaded into the warehouse and available for business use when needed.
• Worked on BEx Analyzer in generating reports like Promotional Reports, Production list, Planning File Entries using Exceptions, Filters and conditions, Structures, Variables, Restricted and Calculated Key Figures and RRI.
• Involved in Manual Testing of the application by developing Test Cases, Test Scripts using Quality Center by reviewing the business.

Confidential, Birmingham, AL

SAP BW Analyst

Environment: SAP BW 3.5, SAP ECC SD, Quality Center.

Responsibilities:

• Involved in understanding the business process, studying the application and interaction with the senior developers in terms of extraction, designing, modelling and reporting in SAP BW system.
• Designed best analytical strategies to achieve the client requirements.
• Participated in requirement review meetings, analyzing requirements and used developing
• Extensively involved in OLTP extraction of SAP (LO Cockpit) and non-SAP data into SAP BW server and experience in Extraction from Flat files, SAP Data marts, SAP, Non SAP & DB Connect.
• Provided production support and administration of BW back-end operations to ensure data is successfully extracted from source systems, transformed, loaded into the warehouse and available for business use when needed.
• Worked on BEx Analyzer in generating reports like Backlog Orders Reports, Production list, Sales Orders using Exceptions, Filters and conditions, Structures, Variables, Restricted and Calculated Key Figures and RRI.
• Involved in Manual Testing of the application by developing Test Cases, Test Scripts using Quality Center by reviewing the business.
• Created the Text generic extractor based on the table T052U to bring the text for the payment terms.
• Created the Process Chains for the transaction and master data loads and monitored them.