EXECUTIVE SUMMARY:

• Over 15+ years in SAP HANA/BW4HANA/BW/BO/ABAP having worked with Confidential, Confidential, Confidential USA, IBM, HCL - AXON with excellent team leading skills
• SAP Certified in SAP HANA/BW/BO WebI 4.0
• Information Technology Infrastructure Library (ITIL) Certified
• Excellent ability to understand and transform complex business requirements into functional design document for solution development, delivered on time, scalable, performance optimized and maintainable.
• Ability to interact with end users to understand various business requirements.
• Worked on multiple life cycle implementations of SAP HANA, BW4/HANA BW on HANA, BW using SAP ASAP methodology right from conducting Workshops, Requirements Gathering, Creating Blueprints, Creating Specifications, Development, Testing, Documentation and End-user Trainings.
• Extensive experience in the Functional Modules such as General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Asset Accounting (AA), Cost Center Accounting (CO-CCA), Internal Orders (CO-IO) and Profitability Analysis (CO-PA); RTR, MM(SCM), SD(OTC), IS-U(Utilities), FRE(RE-FX), Public Sector Flows (FM and GM), HR, CRM and SRM.
• Worked on the new Data modeling techniques using BW on HANA methodologies such as ADSO, Composite Providers, Open ODS Views, ODP Extractors, SLT configuration and load monitoring using SLT.
• Created Open ODS views, ADSO’s, Composite providers with the new Eclipse editor.
• Data provisioning landscaping methods such as SAP Landscape Transformation (SLT), BO Data Services (BODS), for replication/ extraction of data from SAP/ non-SAP source systems and on HANA integration tools
• SAP HANA business requirements architecture on SAP & non-SAP source systems including SAP BW on HANA, SAP BOBJ in large and complex environments.
• Modeling of SAP HANA objects and developed Attribute Views, Analytic Views with various join conditions and Calculation Views using both Graphical and SQL script-based methods.
• Expertise in SAP ECC table data model and analysis. Proficient in creating Procedures, Calculated Columns, Restricted Columns, Filters, Hierarchy, etc.
• Proficient in SAP HANA Administration including managing schemas, data model objects, import/export content
• Worked on HANA SQL scripting and PL SQL
• Worked on SDI Flowgraphs, Transforms and Data cleansing/manipulating using the adapters like file adapter and HANA adapters. Hands on experience with HANA SDI for Batch, real-time and Virtual access of external system.
• Worked on Business Objects Data Services (BODS) Jobs, Work Flows, Data Flows, and Scripts using various Transforms to load data from ECC to SQL database and BW Open hubs to other databases.
• Expertise on using Optimized joins while building model to improve performance of models
• Expertise in Performance Optimization of information models and SQL scripts, involved in SAP HANA Administration including managing schemas, data model objects, import/export content.
• Very good experience in SAP Analytics Cloud (SAC) & S/4HANA Embedded Analytics
• Worked on S4/HANA for real time reporting and positioning BW with S4 HANA CDS Views based on SAP best practices.
• Exposure on Fiori Lauch Pad and Fiori applications S/4 HANA using Fiori Catalogs.
• Handled complete Architecture, Design and Integration with HANA, BW on HANA, BOBJ 4.x using layered scalable architecture++ (LSA++) with buildup of hybrid Analytic/BI application.
• Work experience in different kinds of projects like Implementation, Upgrade (BW 3.5 to BI 7.0) and Migration to HANA database and Production Support Projects in SAP BW 7.5, 7.4, BI 7.0, BW 3.5, 3.1C
• Strong End-to-End BW Configurations and Customization s from ETL process -Extraction, Staging, Loading, Performance, Transports, and Reporting
• Hands on Experience and Technical Proficiency in Data Extraction, Generic Extraction, Data Loading, Data Modeling, ODS/DSO Object, Info Cube, Multi-Providers, SPO, BEx Analyzer, BEx Browser and BEx WAD
• Excellent work experience in LOs (Logistics) Extractors for applications in SD and MM areas & Business Content DS of FI/CO Applications
• Good experience on COPA extraction of CO Module
• Extensive experience in extracting data from SAP ECC, CRM, SRM and external systems like Flat Files and non-ECC data sources and SAP Data Services 4.0 from relational databases
• Created customized InfoCubes, MultiProviders, Infosets, DSOs, InfoSource, Transformations and DTP
• Enhanced the Business Content for Data Modeling in Purchasing, Inventory, Sales, CRM and IS-U Utility Applications and PU (Public Sector) areas for Confidential .
• Worked extensively in BEx Analyzer and Query designer in building Queries and saving in Workbooks and created Custom Queries using Conditions, Exceptions, and Variables & Structures and created Aggregates for frequently used queries
• Expert in building Web Reports and Dash boards using BEx WAD Designer, BO Design Studio tools.
• Good experience of Post production activities like Monitoring Loads, Process Chains and Performance Tuning techniques.
• Expert in Transportation of Objects across landscapes using STMS
• Good experience in Open Hub Service using InfoSpoke, Information Broadcasting and Analysis Process Designer
• Published BW/ BI reports into SAP enterprise portals.
• Very good experience in Business Flows of MM, SD, FI, CO, IS U(Utilities), FRE(RE-FX), Public Sector Flows (FM and GM), HR and SAP CRM applications
• Have experience in ABAP to write custom codes for transformations (start routines, end routine and expert routines), enhancing DataSources and custom variables for reports using CMOD User exits.
• Strong experience in Upgrade of SAP BW 3.5 to BI 7.0(NetWeaver 2004s) which involves migration of 3.x to 7.0 data source, creating transformations, DTPs etc.…and migration of BW 7.0 to BW 7.4 and BW7.4 to BW 7.5 with SAP BW4HANA Add on functionality
• Exposure in SAP-SEM (BPS): Transactional Cube design, Planning Area, Planning Levels, Planning Packages, Planning folders, Manual Planning Function, User Defined and Predefined Planning Function, FOX formula extension.
• Trained in ETL tool Informatica PowerCenter 8.x Level I Developer and Big data Hadoop
• Developed various reports using SAP BO Tools such as IDT (Information Design Tool), Web Intelligence, Analysis for Office, Analysis for OLAP, SAP Lumira, Dashboards and Crystal reports.
• Configured and maintained single and multisource universes in Information Design Tool (IDT) as Business semantic layer to consume HANA Info models/Non-SAP applications using BI reporting clients.
• Developed various module applications Web intelligence reports on Bex reports using BICS connection
• Connected Tableau server to publish dashboard to a central location for portal integration
• Worked on ClickView reporting
• Extensively worked on BO Analysis for Office (AO) to convert existing BEx Workbooks.

TECHNICAL SKILLS:

Data Warehousing: SAP BW/4HANA, BW 7.5/7.4/7.3/7.0/3.5 SAP HANA2.0, SAP HANA1.0 & HANA STUDIO, Eclipse

ERP: SAP S4/HANA ECC 6.0/, CRM, SRM, SEM (BPS)

Programming Skills: SAP ABAP/4, PL SQL, SQL ScriptReporting Tools: SAP BO Tools: WEBI, IDT, UDT, Business Explorer, Analysis Office, SAP Lumira, Lumira Designer, Analysis for OLAP, Design Studio, SAP WAD

Dashboards: Dashboard Designer, Design Studio, Tableau, SAC, S/4HANA Embedded Analytics

Data Provisioning: SDI, SDA, SAP Landscape Transformation (SLT); SAP Data Services; and MS Excel flat file

Databases: HANA 2.0, HANA 1.0, Oracle 11g, DB2, SQL Server

ETL tools: SAP BODS 4.1/4.0, Informatica Power Center 8.x

Other tools: ChaRM, Remedy, Service Now, HP ALM, MQC

Internet Technologies: HTML, DHTML, JAVA SCRIPT, VB SCRIPT ASP, JSP, XML

PROFESSIONAL EXPERIENCE:

Confidential, Butte, MT

Environment: SAP HANA, BW 7.5, ECC 6.0, CRM

Business Areas: FI, CO, IS-U, HR, SD, MM

Sr. SAP HANA/BW Lead Consultant/Architect

Responsibilities:

• Responsible for the development and support of an existing SAP BW environment which comprises PRD, Quality and Development landscape.
• Provides support for enhancements to existing SAP BW Data Sources wrt S/4 HANA upgrade.
• Analyze the S/4 impact and its changes in existing flows
• Performed the required changes wrt Cost Elements and GL accounts in the existing reports due to S/4 HANA
• Reconciled the BW reports before and after migration
• Performed the refresh activities during the Project implementation
• Implemented the 0MATERIAL changes in SAP BW after S/4 HANA migration
• Fixed some of the issues during S/4 HANA migration
• Performed some analysis on CDS views for the existing BW reports i.e., feasibility of S/4 HANA embedded analytics.
• Corrected the existing ABAP code in S/4 HANA system for Z programs and custom data sources.

Confidential, Harrisburg, PA

Environment: SAP HANA, BW4/HANA, BW 7.5, ECC 6.0, CRM, SRM, SAP BO, SAP BODS, BPC 10.0

Business Areas: FI, CO, RE-FX (Real Estate), PU (Public Sector), HR, SD, MM

Sr. SAP HANA/BW Lead Consultant

Responsibilities:

• Responsible for the development and support of an existing SAP BW HANA environment which comprises PW1, A3Q and A3D systems corresponding to PRD, Quality and Development landscape.
• Provides support for enhancements to existing SAP BW Data Sources, DSOs, InfoCubes, Multi Providers, InfoObjects, InfoSets & APDs for the all the applications of Commonwealth of PA
• Create/modify transformations or convert existing update rules and/or transfer rules to transformations
• Update/Create SAP BW queries and workbooks using the Query Designer and BEx Analyzer tools.
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, Ranks. Debugging Views, HANA Modeling using SQL Script
• Worked on new report FM balances which involves creating Composite Providers and HANA Calculation
• Views on top of BW4HANA ADSOs on FM Commitments Actuals (0PU IS PS 31) and FM Budget flows.
• Created SAP native HANA Calculation Views for the Vendor Analysis report based on LFA1, LFB1 and LFBK tables
• Worked on two POCs for native HANA projects for eGrants
• Designed work authorizations with security according to priority of users from executive to user level
• User administration (Create/ Delete; User Groups / Type; Password Parameters; Generation of Role, Profile & Authorizations using PFCG); Locks (Clients / Transactions); Security Profile & Authorization maintenance.
• Expertise in SAP HANA Security including User Management, Roles, and Privileges
• Expertise on reading the BW models into HANA and creating the HANA view to achieve the complex reporting requirement.
• Worked on New GL, FI-AP, FI-AR, FRE and Public Sector flows involving Funds and Grants management (FM & GM) applications and EAM Assets applications.
• Identify, troubleshoot & resolve issues in development/configuration/reportingfor all CWOPA applications like New GL, CAFR, GASB87 etc.
• Develop and document test strategies & results for CAFR and Inventory applications
• Participate in the Functional meetings to get the new requirements for PA state CAFR Financial reporting purpose and GASB87 reporting.
• Analyze the requirements from the end-users and prepare a functional specificationin the areas of PCI (Pennsylvania Commissary Institute) and FRE (Flexible Real Estate).
• Prepare a Fit-Gap Analysis document based on the gaps identifiedfor GASB87 and CAFR projects.
• Match Functional requirements into SAP BW technical objects and prepare a Technical Design documentfor CAFR, GASB87, FRE and PCI applications.
• Worked on Procurement, Inventory, Purchasing Sales processes and BW Support for the State requirements
• Involved in implementing the data flows of Procurement, inventory management DataSource 2LIS 03 BF (Goods Movements from Inventory Management), Purchasing Data (Schedule Line Level) DataSource 2LIS 02 SCL, Production Orders: 2LIS 04 P MATNR (Material View from PP/PP-PI), 2LIS 04 P COMP (Component View from PP/PP-PI) etc.…using the LO Cockpit.
• Extensively worked on LO cockpit for the Purchasing Application which involved the Data Sources like 2LIS 02 HDR, 2LIS 02 ITEM and 2LIS 02 SCL and Customer Support Sales - Transaction data flow application which involved the Data Sources like 2LIS 11 VAHDR, 2LIS 11 VAITM for Sales; 2LIS 12 VCHDR, 2LIS 12 VCITM for Delivery; and 2LIS 13 VDHDR, 2LIS 13 VDITM for Billing.
• Filled the set-up tables using the tcode OLI*BW for the applications like Purchasing, Sales Order, Delivery and Billing Document in Sales and Distribution.
• Develop ALM support scripts for the BW objectslike FRE Cash flow and FRE Conditions data sources.
• Involved in BW on HANA migration project from Oracle database to HANA DB.
• Upgraded the systems from HANA 1.0 to HANA 2.0
• Worked on Upgrade from BW 7.4 to 7.5 with new Eclipse version
• Expertise in Improving performance issues by applying OSS notes as per SAP recommendation
• Expertise in resolving critical upgrade issues with help of SAP and implemented several OSS notes in resolving upgrade issues
• Developed the new requirements BW4/HANA objects like ADSO, Composite providers and BW Query for GASB87 project involves FRE Cashflow and FRE Contract Conditions using the new BW for HANA tool, Eclipse model.
• Involved in migration of New-GL and implemented the BW data models based on new data Sources 0FI GL 14, 3FI GL 0L TT
• Migrated all old FI-SL based workbooks into New GL based workbooks for CAFR Statewide & AG versions
• Heavily worked on CAFR Financial Balance Sheet reports, Revenue and Expenses Reports using New GL data objects
• Created Financial Reconciliation reports for NEW GL Totals and Details using the Remote Cube and Data source 0FI GL RECON
• Worked on GL Hierarchies to load to Quality and PRD systems from the Development systems using BODS loading mechanism by creating BO DS object and DS enabled Data Sources.
• Worked on PCI Consolidated Operating Statement Report which involves Costs and Allocations - Cost Elements flow and 0CO OM CCA 9 (Cost Centers: Actual Costs with Delta Extraction)
• Worked on AP and AR Aging reports and enhanced these reports with FRE Contracts.
• Worked on Business Partner extraction from CRM systems and ECC and working on Business Partner -Customer - Vendor integration project.
• Worked on eGrants project which involves SAP Lumira Designer / SAP BO Design Studio Dashboard on eGrants Dashboard Reporting based on KBLK (Document Header) and KNLP (Document Item) base tables with FMZ3 transactions at Source System for Earmarked Funds
• EGrants Enterprise Dashboard based on custom CSS functionality for Lumira Components and integrated ESRI maps for the county location wise Vendor Payments and allotted Grants in PA state
• Developed Business Objects Data Services (BODS) Jobs, Work Flows, Data Flows, and Scripts using various Transforms to load data from Open Hub Services Table into Oracle database and then consumed the data for BO Reporting tool
• Worked on FRE (Flexible Real Estate) Project which involves “Contract Overview” and FRE Lease Tracking work books with lots of tabs on different report views
• Developed data flows for FRE on Contract Conditions (0REFX 1), Contract Measurements, Differing Measurements (Contract) (0REFX 13) and Cashflow (0REFX 6)
• Extensively worked on RECN transactions at Source and resolved the issues related to measurement type mappings and non-cumulative KF like 0MEAS VALUE (Measurement Amount) & 0COND AMT (Condition Amount)
• Enhanced 0RECONTRACT(Contract) with a new End of Date field with a logic to replace it when Holdover Date exists
• Designed and developed new FRE Lease Tracking Report which displays the Total annual cost for all FRE contracts across Counties & Business areas using Analysis Office
• Enhanced the Revenue and Refund reports by adding Doc type exclusions SD, SU
• Converted many existing BEx Workbooks into BO AO Workbooks in the area of CAFR
• Extensively worked on APD and Information Broadcasting to export BW data to different outbound interfaces
• Extensively worked on ABAP coding during transformations in Start Routine, End Routine Expert Routine and in Data Source enhancements and in customer exits where needed.
• Involved in a new project of BW4/HANA migration in Shell Conversion with the current SAP BW 7.5 BW/4HANA Add on
• Worked on new ODP extractors and ABAP CDS view extractors for FI-GL flows in S/4 Embedded Analytics HANA landscape for CAFR Financial R eporting
• Extracted the data from Oracle legacy systems using SAP HANA SDI.
• Worked on a POC on SAP data intelligence tool to target the SAP and non SAP systems
• Resolved lots of issues during SAP systems migration to Linux OS
• Created annual budget reports using Power BI Desktop for analyzing the V&A revenue and expenses.
• Developed complex calculated measures using Data Analysis Expression Language (DAX) for efficient data visualization in Power BI.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Have experience in SAP SBP solution for the state’s budgeting requirements.
• Implemented Funds Management, Grants Management and worked on Budget execution reports based out of BCS and other planning tools.
• Implemented budget execution data flow models using the new composite providers and FM Budget ADSOs
• Got trained in SAP Analytics Cloud (SAC) and hands on experience in developing SAC applications using story canvas and well versed in visualizations and their usage charts, tables, filters. Drop down menus etc…
• Successfully created Dashboard story in SAC using Canvas, Responsive pages and Digital boardroom.
• Successfully optimized SAC Dashboard as per business requirements
• Tested and resolved data issues in SAC Dashboard stories.
• Very good understanding of S/4HANA Embedded Analytics content using CDS views and Fiori applications
• BPC tasks:
• Developed Custom process chains to load BW data into BPC applications for Finance and Funds management applications.
• Designed/modeled a data flow from ECC into BW then into summarized BW info cubes designed specifically for BPC implementations this facilitated the cube to cube load for BPC planning.
• Working on Embedded BPC project which involves lots of Input forms VB Custom Code changes to fit into AO
• Working on creating new ADSOs for BPC planning purposes using a new eclipse platform.

Confidential, Pittsburgh, PA

Environment: SAP BW 7.4, ECC 6.0, SAP BO, SAP HANA, SAP BODS

Business Areas: SD, FI, CO, MM, SRM

SAP HANA/BW Lead Consultant/Architect

Responsibilities:

• Responsible for daily monitoring of the BW system using the tools ST13(PC Monitoring Runtime Analysis), RSPCM and fix the BW PC load issues
• Responsible for complex fixes and change orders in the SAP NetWeaver BI environment-BW/HANA along with BOBJ
• Ability to talk to end users, understand the issues & change request based on the Incidents raised in eDesk system
• Ability to write very good programming, unit test and document the changes and provide smooth handover to different teams and end users
• Understand and follow religiously the process to migrate the change orders to production
• Extensively worked on ABAP coding during transformations in Start Routine, End Routine Expert Routine and in Data Source enhancements and in customer exits where needed.
• Worked on new GL (0FI GL 14), COPA, Sales, Billing data flows
• Resolved the long pending issue with Daily Sales Report (Global) which have the issue with two KPIs i.e., Open Orders (Volume) & Open Orders (Newt Weight).
• Resolved the issue on missing billing documents for CSS Commercial Sales report.
• Worked on COPA Income statement, FI Income statement and COPA-FI Reconciliation report changes as per the new organizational structures
• Extensively worked on Global Sales Analytical Reports and FI Profit & Loss Analytical reports
• Worked on Open hubs to distribute the COPA data to Essbase file
• Extensively worked on BW routines (start routines, end routine and expert routines) and BW data source enhancements
• Fixed the issues with BI Project systems report with ECC FAGLB03 report
• Resolved the issues related to GRNV SRM report
• Extracted PO data from SAP SRM systems
• Extensively worked on SAP BO Design Studio tool to create dash boards on sales analytics
• Work experience with BW 7.4 objects like Composite Providers, open ODS view and advanced DSO for the new data flows
• Developed SAP native HANA Views (Attribute and Analytical views) for Heinz Market Share Project
• Worked on the HANA Technical Spec which comprises all tables which were replicated to HANA
• Monitored SAP BODS jobs which are running on daily basis and fixed possible failures for Heinz ZBB data
• Worked on Power BI, Tableau and SAP Lumira dashboards for Analytics reporting
• Involved in running the SAP BO WebI reports on daily US time

Confidential, PA

Environment: SAP BW 7.3, ECC 6.0, SAP HANA 1.0, SAP BO (WebI, Design Studio, IDT)

Business Areas: FI, CO, CRM, HR, SD

Business Process Consultant/Architect

Responsibilities:

• Led the SAP BW/BI team for SAP IT projects ‘BI Report Factory’ (Development of Reports using BEx WAD and Query Designer tools).
• Delivered the SAP IT Finance & PRM Analytics reports, GSIM and T&E Projects.
• Converted the FS requirements into Technical Specifications.
• Responsible for the delivery of objects from entire realization phase till go Live.
• Worked on SAP BW 7.3 objects and HANA based information models and followed LSA 2.0 and extensively worked on HANA enabled InfoCubes and DSO
• Developed SAP native HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views to join the various Attribute and Analytic Views for GSIM (Global Security and Information Management) Project
• Created universe and developed BO WebI reports and dashboard using IDT tool on HANA views
• Developed Dash boards using SAP BO Design Studio on PRM analytics
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed Crystal Reports based on BEx query for T&E reports.
• Worked on HR data sources 0EMPLOYEE ATTR, 0HR PA 0, 0HR PA 1 for Head count and personal actions for the T&E and GSIM Project.
• Handled the Tickets during the testing phase of the reports
• Having the daily calls with SAP IT team to discuss on the status of the deliverables.
• Worked on COPA-Finance Analytical reports i.e., COPA Actual Analysis, FI Actual Analysis which are based on COPA data flow and FI leading ledger balances (0FI GL 10) data flows
• Designed Sale Analytics back end data flows which includes Sales Orders, Billing and invoices and Deliveries data flows

Confidential, CT

Environment: SAP BI 7.0, SAP ECC 6.0 SAP CRM 5.0

Business Areas: CRM, FI-CO, HR

Sr. SAP BW Lead Consultant

Responsibilities:

• Led the SAP BW team to deliver the ESAP release 1.1 objects
• Having status calls with onsite BW team to keep track of object status and updates by using the tools like PM SMART and APSE (Axon Program Standards of Execution).
• Involved in designing the RDDs (Report Design Documents) with the new reporting requirements by converting the business logic into BW solution and mapping the source system definitions into BW.
• Performed the BW Data Modeling Analysis on the existing BW InfoCubes of the Release 1.0 by using programs /SSA/BWT, SAP INFOCUBE DESIGNS and table RSRCUBE.
• Delivered the Confidential Direct and In-direct Business Analysis on the current data by classifying the business data across Sales Org, Distribution Channel and Division / Purchasing Org, Plant
• Involved in Z-filed Analysis for the existing CRM data sources like 0CRM SRV CONFIRM H, 0CRM SRV CONFIRM I,0CRM SRV PROCESS H,0CRM SRV PROCESS I CRM business processes Service Process and Service Confirmations etc.
• Involved in delivering the BW Phase 1 and Phase 2 objects as per the scheduled time lines.
• Delivered the BW CRM-CSO (Customer Service Organization) reports and database objects which based on Service Process and Service Confirmation data flows in SAP CRM area.
• Involved in developing the solutions for Finance-GTR reports using Asset Accounting (AA), New GL14, Cost Center Accounting (CCA) and CO-PA data flows.
• Worked on EAM Assets data flow objects 0FI AA 11 and 0FI AA 12 enhancements and master data objects 0ASSET ATTR TEXT and 0ASSET AFAB
• Enhanced the 0FI GL 14 extractors with Document Header Text BKTXT
• Designed and developed the data models on CCA, OPA and WBS data flows
• Enhanced 0CO OM CCA 9 to add COEP-EBELN and map to 0DOC NUM and to add COBK-USNAM and map to EGRNUSR.
• Enhanced 0CO OM WBS 6 with ZZCONTNO, ZZSERNOs
• Worked on HR data flows Actual Time and Labor Times (0HR PT 2)
• Performed QC10 steps for the BW back end and frond end reporting objects.
• Managed and handled BW Defects through MQC during Integration testing and regression test phases.
• Used RRI techniques for some of the CRM reports.

Confidential, Medford, OR

Environment: SAP BI 7.0, SAP ECC 6.0

Business Areas: MM, IM, PP, FI

Sr. SAP BW Lead Consultant

Responsibilities:

• Involved in Full Life Cycle Implementation of integrating the functional areas MM, PP and FI with BW. Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications.
• Involved in implementing the data flows of inventory management DataSource 2LIS 03 BF (Goods Movements from Inventory Management), Purchasing Data (Schedule Line Level) DataSource 2LIS 02 SCL, ProductionOrders: 2LIS 04 P MATNR (Material View from PP/PP-PI), 2LIS 04 P COMP (Component View from PP/PP-PI) etc.…using the LO Cockpit.
• Performed Statistical Setup for Purchase, Inventory Management (Non-Cumulative method) and extracted the data to BW.
• Used “Queued Delta” method to extract the delta records of MM application.
• Activated Purchase and Inventory InfoCubes and DSO objects from the Business Content and customized according to business needs.
• Implemented the dataflow for the G/L Details by activating the DataSource0FI GL 4(General Ledger: Line Items).
• Activated the Business Content master data sources for 0VENDOR ATTR (Vendor Number), 0MATERIAL ATTR (Material Number).
• Developed Generic Data Sources using RS02 for the Batch materials, data source for shelf life expiration by using views from the base tables MARD, MARA, MCH1.
• Created transformation, DTPs for the above dataflows.
• Developed Open Hub destinations to send the BI data to MS Sequel Sever for further reporting.
• Created process chains for the above dataflows and also created PC for purging the PSA requests periodically.
• Enhanced the purchasing dataflow (2LIS 02 SCL) with the new fields for PO Address details and enhanced the ABAP code to populate the data for the new fields using CMOD user exits.
• Participated in SAP BI system refreshes.
• Resolved multiple issues related to 0BATCH loads by using error DTPs and using RSKC transaction to allow extra permitted characteristics.
• Resolved data inconsistency issues related to ‘production-order’ dataflows which involved the datasource2LIS 04 P MATNR.
• Created Open Hubs for the purchasing and inventory DSOs.
• Worked on information broadcasting to broadcast the reports through emails.
• Extensively worked on BEx Query designer to create Purchasing reports.
• Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team

Confidential, TN

Environment: SAP BI 7.0, SAP ECC 6.0

Business Areas: IS-U, FICA, FI

SAP BW Lead Consultant

Responsibilities:

• Led the Confidential SAP BI team to support the clients like Confidential, NNWW and GRU.
• Worked on Utility dataflows like Open Items(0FC OP 01), Cleared Items(0FC CI 01), Sales Statistics(0UC SALES STATS 02) and FIGL etc.…
• Ran the transactions for FPBW and FPCIBW mass activities at R/3 for open items and, cleared items extracts monthly or weekly based on client requirements.
• Loaded data to open and cleared items InfoCubes based on run date and run identification.
• Worked on some enhancements for the standard extractors 0FC OP 01 and 0FC CI 01 for open and cleared Items dataflows like adding sub G/L account field (HKONT) and worked on CMOD for the code changes to populate the new data for the enhanced fields.
• Worked with the business users on the requirements of stopped meter analysis and participated Fit-Gap analysis meetings
• Involved with the Meter Reading Data Analysis by working on DataSource 0UC MTR DOC (Meter Reading Document)
• Activated the Technical Device master data i.e. Device, Device locations(0UC DEVICE ATTR)
• Extracted the data from the billing order using 0UC BILLORD.
• Worked extensively on Sale Statistics data source (0UC SALES STATS 02) to fix the missing data for certain posting periods using the tcode EBW DQ SS at R/3.
• Fixed the GL Details for missing posting periods which involves the DataSource 0FI GL 4(General Ledger: Line Items).
• Involved in QA refresh activities: Ran tcode BDLS to convert the source system changes etc., checked the RFC connections and did all the BW tasks to refresh data.
• Extensively worked on Transports using the transactions SE01, SE09 and STMS.
• Activated and made use of Technical content in BI system (SAP BI statistics) to gather the statistics required for performance analysis.
• Created and maintained aggregates, rollup of data using process chains, after the successful extraction of transaction data and compressed the InfoCubes as part Performance Tuning of the BI system.
• Developed TVA reports using BEx query designer extensively.
• Created workbooks by including a set of BEx reports.
• Developed Web reports corresponding to BEx queries using BEx WAD tool.
• Developed executive dashboards which consist of pie charts, graphs and tables.
• Published BEx reports in SAP portal.
• Used Information broadcasting to send reports though emails.
• As a part of upgrading SAP ECC 6.0, supported BI system activities like running BDLS to change the old source system to new source system, taking care of delta Q’s and scheduling the batch jobs and maintaining the Process chains after ECC upgrade. (ECC 6.0 Post upgrade steps)
• Provided on-going BI monitoring support such as troubleshooting and resolving issues using the transaction RSPC and RSMO.

Confidential, VA

Environment: SAP BI 7.0, SAP BW 3.5, SAP R/3 4.7E

Business Areas: FI, IS U, FICA

Sr. SAP BW Consultant

Responsibilities:

• Upgrade of BW 3.5 to BI 7.0(Net Weaver 2004s):
• Developed the strategy for the Upgrade project from BW 3.5 to BI 7.0
• Prepared the project plan for BI which involved the time lines and BI tasks.
• Involved in Migrating the classical 3.x DataSource to 7.0 DataSource for IS U and FI area for both master data and transactional data.
• Migrated transactional DataSources: Open Items(0FC OP 01), Cleared items(0FC CI 01), Sales Statistics (0UC SALES STATS 02) and 0FI GL 4(General Ledger: Line Items).
• Migrated the master data sources for the objects like Business Partner, Premise, Contact Number, Contract, Connection object etc.
• Used the new Transformation process in place of old Transfer and updated rules and created DTPs for the data targets according to the requirement.
• Modified the update routines and start routines using ABAP objects especially for the 0BUSINESS PARTNER and Sales Statistics dataflows.
• Resolved migration issues with the help of SAP OSS support.
• Included the newly created DTPs in the Process Chain for the automatic scheduling of data loads.
• Migrated all the BEx 3.5 reports into BI 7.0 reports.
• Worked on migrating work book which contains about 15 reports.
• Worked on migrating the Exception aggregation settings for the calculated Key Figures to BI 7.0 version.

Confidential, FL

Environment: SAP BW 3.5, SAP R/3 4.6 C

Business Areas: IS U, FICA, FI

Sr. SAP BW Consultant

Responsibilities:

• Monitoring the SAP BW PC loads daily using the transaction RSPC and RSMO.
• If any issue comes up with the data loads, we need to investigate the issue and fix it accordingly.
• Based on the Confidential Edge Tickets which are assigned under my name, I need to look into the ticket issue and need to resolve according to priority level.
• I need to update the status of each ticket in Confidential Edge Portal.
• Worked on Utility data flows like Open Items, Cleared items, Sales Statistics etc.…
• Run the transactions FPBW and FPCIBW at R/3 for open items and cleared items extracts monthly or weekly based on client requirements.
• Loaded data to Open and Cleared items InfoCubes based on Run Date and Run Identification.
• Worked on some enhancements to the existing dataflows for Open and Cleared Items dataflows like adding Sub G/L Account field.
• Worked with the standard extractors 0FC OP 01 and 0FC CI 01.
• Involved in QA refresh activities.
• Extensively worked on Transports using the transactions SE09 and STMS.