SUMMARY:

• Have 16 years of IT experience with 14+ years in SAP World. Gained very strong expertise and experience with ETL Data Warehousing, Business Intelligence Analytics, Planning and Consolidation tools of SAP i.e., SAP FICO, SFin, BW/BI/BOBJ/S4HANA, BPC, EPM Suite, SEM - BPS, BCS, BI-IP Outlooksoft.
• Has involved in 12 SAP End-End Full Life Cycle Implementations varying small, medium to highly complex environments experience with few being SAP Global Deployments. Has good understanding with different Business processes/ Data Flows from Transactional (SAP ECC, Other Legacy ERP Systems) Analytical (SAP BW ETL) to Planning, Budgeting and Consolidation Systems (SAP BPC, BPS, BCS, IP) on both regular Traditional/HANA Databases. Add on experience with ECCS, FI-CO, sin (SAP Simple Finance) Modules, with many diversified clients as such Utilities (IS-U), Automobiles, Entertainment, Media, Communications, Retail, Manufacturing, Consumers (CPG), Electronics, Legal/Financial/Medical Services and so on.
• Have decent Technical (ABAP, Script Logic, Fox Coding, MS SQL Scripting, VB Coding) Strong Functional (FICO, SD, MM, PP, PS, HR/HCM Modules) and Lead Managerial Skills with PMP Certified and Agile Scrum Methodologies.
• Has executed multiple roles ranging from Development, Testing, Design Architecture, Functional Configuration, End-User, Security, Project Lead and Solution Delivery Management
• Has conducted several workshops and developed many Business Blueprints as Business Analyst/Functional Consultant/SME interacting with Business Users, Technical Team and Top Management.
• 12 End-to-End Full Life Cycles SAP BW/BI/BPS/BCS/IP Implementations. Handful of BOBJ/BPC implementations with versions 7 NW/MS, 7.5 NW, EPM-BPC NW 10 NW 10.1, S4/HANA/BOBJ/sFIN 1.0 Add on experience with Outlooksoft BPC Version 5.1. Add on experience with SEM-BPS, BCS, CPM, BI-IP(Integrated Planning)
• Very Strong Experience with BPC-EPM 10 Suite and with Reporting tools EvDRE, WEBI. Extension to BOBJ dashboard Reports. Hands on with BI BEX, BI-Bex, WAD and Exposure to Crystal Reports, Notes Management/Disclosure Management for Financial Consolidations (Legal/Managerial) Process.
• Strong exposure towards versatile Non-SAP Financial Applications/ERP like Clarity, SAGE FAS, Hyperion, Peoplesoft- Pillar, GreatPlains, Essbase and so on.
• Hands on with IT applications like Citrix Metaframe, TimeTrackIT, MS Office Tools.
• Experience with ABAP, Fox, ScriptLogic, MS SQL along with implementation of complex BADI's
• Extensive BW-BI/FICO experience with 8 Lifecycle BW/BI-BPS/IP/BCS(FI-CO) implementations along with 2 Upgrade Projects experience involving CRM, SD, MM, EBP, SRM, PP, HR, ECCS and FI/CO modules.
• Good Understanding of different Financial Accounting Principles like GAAP, IFRS, FERC and also SOX Compliances.
• Develop/Prepare/Reconcile/Validate different Statutory/Legal Financial Statements, Audit Statements, Journals in SAP BPC Environment.
• Experienced in Unit Testing, integration testing, regression tests, functional Integration Testing using the HPQC, Data Migration &WRICEF requirements
• Production Support (Level 2 & 3 Issue handling, Problem Resolution, Recommendation on Required Enhancements.
• Big 5 Consulting experience SAP America, Accenture
• Industry experience - Legal/Financial/Medical Services, Energy, Communications, Chemicals, Brewery, Entertainment, Health care, Advertisement & Media
• Strong hold on Agile, Scrum, SAP RDS ASAP Methodologies with PMP Institute Trained and Certified.
• Strong Communication, Interpersonal and Documentation with strong PMO Skills.
• Ability to Deliver Solution with Optimal Usage of Specified Budget, Resources and Timelines.
• Shall Lead different Work Shops in Requirement Gatherings, Gap Analysis and BBP Sign-Off Process.
• Strong understanding of diversified Business Process helps propose best Solutions at times.
• Ability to Own Governance Model, Kickoff deck & meeting, Detailed project Plan
• Can Track, Manage Change Requests and Risks/Actions/Issues/Decision
• Ability to ensure projects staffed appropriately and can lead Resources in an Onsite and Off-Shore Models.
• Efficient Reporting to different Management Groups, Stakeholders, CFO per Project Needs.
• Can Efficiently Handles Team/Client Meetings, Scout Status Updates per work plan.
• Ability to meet deadlines and Open to Project Challenges.
• Ability to handle Risks/Critical Bottle Neck Situations with Do-Deliver Attitude.
• Well-versed with MS-Office, Project Reporting Tools

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. SAP S/4 HANA SFin BI/BW BPC Lead Solution Architect

Environment: SAP BI 7.5, ERP 6, S4/HANA 1610, BPC 10.1 /EPM 10, Clarity, SAGE FAS

Responsibilities:

• Responsible for installing all the BPC Embedded and BW related objects for the S/4 HANA POC project for the Portugal Business Unit
• Activated SAP delivered Technical content bundle for BPC Embedded in the /ERP/SFIN PLANING namespace including Info providers, Queries, Planning Functions, Planning Sequences and HANA information Models
• Worked on SAP Delivered Planning Templates for Cost Center, Internal Order, Profit Center, Cost of Sales and P&L Planning
• Activated and modified the SAP Delivered Analysis for Office workbooks
• Educate Users on versatile features of BPC Embedded for S/4 HANA
• Responsible for installing all the BPC Embedded and BW related objects for the S/4 HANA RDS project for the Global Business Units.
• Activated SAP delivered Technical content bundle for BPC Embedded in the /ERP/SFIN PLANING namespace including Info providers, Queries, Planning Functions, Planning Sequences and HANA information Models
• Worked on SAP Delivered Planning Templates for Cost Center, Internal Order, Profit Center, Cost of Sales and P&L Planning
• Activated and modified the SAP Delivered Analysis for Office workbooks
• Create Business Process Flows (BPF) as per business requirements
• Provide end user on BPC Embedded for S/4 HANA
• Responsible for all the Planning and Forecasting applications on BPC 10.1 Embedded system including OPEX Planning, CAPEX Planning, Sales Planning, HR Planning, P&L Planning, Balance Sheet and Cash flow planning
• Supporting the Business Process Flows (BPF) for both BPC Planning and Consolidation models
• Supporting Authorization via the DSO upload and RSECADMIN generation of authorization object
• Extensively working with Finance Team during the Close to Troubleshoot issues in BPC and BW
• Supporting the SAP BPC Data Manager Package, using Process Chains
• Supporting the Adjustments of Actual Data through Journals for Group G/L Account Data Mismatches
• Supporting the Web Based Flat File Upload program to load Consolidation data for the Non SAP entities
• Design, Configure Legal, Rates, Ownership Modules, Set Up Business Rules for Currency Conversions, IC Elim and Matching Rules, Validation Rules and so.
• Preparation of Legal Consolidation Reports deck - P&L, Balance Sheet, their schedules and Cash-flow Financial Reporting,
• Add on Audit Reports, Journal Reports, Validation Reports, User Reports and Trial Balance Reports, SOX Compliance Reports.
• Financial Statements leveraging the IFRS pre-built reports delivered by SAP BPC
• Building EPM Consolidated Statutory reports as per Confidential requirements as base.
• Monitoring important KPIS.

Confidential, Chicago, IL

Sr. SAP FI-CO/BI/BW BPC Lead Solution Architect

Environment: SAP BI 7.5, ERP 6, S4/HANA, BPC 10.x /EPM 10, Clarity, SAGE FAS

Responsibilities:

• Conducted User Work Shops part of Requirements Gathering,
• Business Blue Print Sign Off, Gap 5Analysis,
• Sandbox Prototype Design (Proof of Concept),
• Developing Functional and Technical Specs
• Documented Business Process Flows interacting with Business and Technical Team.
• This application is integrated with BPC to brings together product, sales, marketing, operations and finance to profitably balance supply and demand in real time. It includes embedded communication tools to align both people and processes, and what-if scenario capabilities to explore various business options at the level of granularity needed.
• Production Working Days Input Template by Title, Period part of HR Planning
• CAPEX Budget Templates Design Build, Data Model, Transformations
• HR Planning Rates Increase Calendar Template by Title, Period
• Exchanges Rate Templates for Consolidation and Planning
• Time Keeper Plan Hrs, Rates, FTE Template by Office/Period/Year
• SAGE Fixed Assets data into BPC towards Fixed Assets Depreciation Planning which aggregates into Consolidated Fee Income Template by Title/Office/GLAccount at SBU level.
• Local Office Budget and Fee Expense Templates by Office,TK, Account
• Local Office Capital Planning Budget by Office, LC, Time, Account
• Global Office Budget Expense by Office, TK, Account, LC, Period, Cost Center
• Global Office Capital Planning Budget Summary/Detailed by Cost Center, LC, Time, Account
• SBU Local Offices P/L Report by Office, Currency,
• Production FTE/Fees/Hours and different Variance Reports
• Work status settings, User Security definitions, Assign User Privileges in BPC and worked with BASIS Security team to set up this at BI Backend.
• Remote Connectivity to Confidential Network using CitrixXen Applications integrated with Junos Pulse for BPC Server Access
• Configured Models, Dimensions, Properties and Maintained Master Data.
• Developed Logic Scripts, BADI for disaggregation/Allocation of data or aggregation of data at different planning levels.
• Converted Fees Worked Report
• Detailed/Summary P&L with USD Conversion
• BOFC Transaction List Reconciliation Report
• Prior Year and Financial Account Summary

Confidential, Woodcliff Lake, NJ

Sr. SAP BI BPS BPC Lead Solution Architect (SME)

Environment: SAP CRM; SAP BI 7.5, ERP 7, HANA, BPC /EPM 10, BPS

Responsibilities:

• There is a strong integration required between CRM and BW/BPS/BPC to exchange Plan inputs.
• Had developed Custom Function Modules, BADI’s to exchange Plan inputs from CRM UI and BW-BPS/BPC Environments.
• Developed Custom Logic Script/BADI’s for complex allocations of Revenues across Planning Areas by Product, Business Partner and Account Plan ID.
• Revenue Plan data is supported by COPA Cubes, Backlog Data, Engagement Master Data, Jobs, Phase Master data.
• Had quickly resolved so many technical aspects as part of BPC Config Errors, EPM Add on Reports, BI Bex/Web Reports.
• Actively involved in testing of Business Planning Solution and has been a sharp trouble shooter for all complex Rev Trac Transport Issues.
• Currently handling Support issues of BW - BPS Planning Solutions and working on Enhancements.
• Conducting workshops for BPC 10 Upcoming Planning Phase 2 Implementation part of Global IBS Solution
• Extracted Data from CRM, ECC into BW-BPS(Business Planning Analytical System for Planning Templates.

Confidential, Waltham, MA

Sr. SAP BI BPC Consultant

Environment: SAP BI 7.5, ECC 6.0, BPC 7.5 NW/EPM 10,Hyperion

Responsibilities:

• Extensive Role in Freezing High Level Functional Specs and Sign Off
• Documented all developments in the form of Design Documents
• Involved in Requirement gathering, Conducting workshops, and Developing Functional Design Specs, Freeze Business Blue Print Design.
• Translating requirements into design specs.
• Creating BPC application architecture framework as a platforms for the developers
• Designed and configured Financial Planning Applications that covers Plan, Budget and Forecast needs of O&M, Labor, and CAPEX Modules.
• Developed custom Script Logic and Complex BADI's to achieve Burdening and Allocations at Cost Center, WBS Element Level rolling up to company code.
• Configured Security, Work Status Settings, Set Application Parameters for Planning and Consolidations
• Designed and Configure, maintained several Application Sets, Applications, Dimensions, Hierarchies, Key Properties
• Configured, Developed Prototype Models, test, train and define support procedures and implementation. Documented Interfaces and interacted with other teams to have Data Conversions, Interfaces in place.
• Designed and Created Business Process Flows for Financial Planning and Consolidation Processes.
• Support planning and consolidation processes for month end, quarter end and year end. Able to assess the client's current financial reporting strategy and improve the consolidation/planning processes with data quality and reporting
• Perform both legal and management consolidations for US GAAP, IFRS and FERC Consolidations in process for ACTUALS, PLAN, BUDGET and FORECAST Versions.
• Configured Intercompany Matching/Eliminations, Account Transformation, and Consolidation of Investments Business Rules as part of Consolidations.
• Developed custom BADI for posting Equitation Entries with a combination of Data Sources and Elam Entitles in a Group Scenario.
• Designed Ownership, RATE, USCONS Applications for Legal/Managerial Consolidations.
• Used Dynamic Hierarchies Templates as well as Input Schedules in maintaining Ownership Information. Addressed successfully MATRIX Consolidation at both Legal Entity (Company Code) as well as Segment/Profit Center Level) using Reporting Capabilities.
• Extracted BI Data Loads Closely worked with ECC, BI, UK Hyperion, and PeopleSoft Pillar Teams for an overall smooth Integration across the landscape.
• Configured several Data Manager Packages, Process Chains, with different Selection Parameters for executing Planning and Consolidations Functions/Jobs
• Developed handful of EVDRE Report/Input Schedules for Reconciliation of Financial Statements (B/S, P/L, and C/F) for Plan, Budget, Forecast, and Actual Categories for both Consolidating and Consolidated Versions.
• Developing Feasibility Document based on Prototype addressing Change Management Issues.
• Prepared Technical Upgrade Guidelines of BPC 7.5 to BPC 10 NW Migration tasks and key tasks listed below.

Confidential, Reston, VA

Sr. SAP BI BPC Lead Solution Architect

Environment: SAP BPC 7.5 NW SAP BI 7.5, ECC 6.0

Responsibilities:

• Played major role to get BPD Docs sign off
• Documented all developments in the form of Design Documents.
• Translating requirement into design specs.
• Freeze Business Blue Print Design.
• Creating BPC application architecture framework as a platforms for the developers
• Designed and Created Sales and Finance Application Sets, Planning Applications for Financial Statement Planning and as well as Consolidation Statement Planning both involves sub plans like P/L, B/S and Cash Flow Statements Planning, HR Salary Planning, CAPEX Planning
• Designed and Created Dimensions (Members and Properties )
• Designed, Created Work Status and Created Security features in BPC.
• Designed and Configure, maintained several Application Sets, Applications, Dimensions hierarchies
• Design and prototype, test, train and define support procedures and implementation.
• Designed and Created Business Process Flows for Sales and Finance Plans.
• Generated Journal Entry Reports
• Support planning and consolidation processes for month end, quarter end and year end. Able to assess the client's current financial reporting strategy and improve the consolidation/planning processes with data quality and reporting
• Perform both legal and management consolidations for US GAAP and local country based consolidations.
• Performed Intercompany Eliminations, Matching, Account Transformation, and Consolidation of Investments as part of Consolidations.
• Set Run Data Management Packages and Monitored BI Data Loads

Confidential, Waltham, MA

Sr. SAP BI SEM-BPC Solution Architect

Environment: SAP BI 7.5, ECC 6.0, BPC 7.5 NW

Responsibilities:

• Played major role to get BBP Docs sign off
• Documented all developments in the form of Design Documents
• As a Solution Architect/SME I was involved in Requirement gathering, Conducting workshops, and Developing Functional Design Specs.
• Translating requirement into design specs.
• Freeze Business Blue Print Design.
• Analyzing current BI/IP Planning Applications like Sales revenue Planning, SG & A Cost Center Planning
• Creating BPC application architecture framework as a platforms for the developers
• Designed and Created Sales and Finance Application Sets, Planning Applications for Financial Statement Planning and as well as Consolidation Statement Planning both involves sub plans like P/L, B/S and Cash Flow Statements Planning.
• Designed and Created Dimensions (Members and Properties )
• Designed, Created Work Status and Created Security features in BPC.
• Design and prototype, test, train and define support procedures and implementation.
• Performed accurate analysis and effective diagnosis of client issues and manage day-to-day client relationships at peer client levels.
• Designed and Created Business Process Flows for Sales and Finance Plans.
• Involved in Utilizing Server Manager Utility for backup and restore Utilizing SAP BI 7.0
• Configured Journal Entry Templates
• Support planning and consolidation processes for month end, quarter end and year end. Able to assess the client's current financial reporting strategy and improve the consolidation/planning processes with data quality and reporting
• Assist client on financial close and planning processes.
• Perform both legal and management consolidations for US GAAP and local country based consolidations.
• Support consolidations in future with discontinued operations in future, addition or restructuring of company codes, reclassifications and consolidation of investments
• Support operational planning processes with statistical key figures and allocations with different versions for cost centers and profit centers
• Designed financial planning processes by setup of key business drivers, target setting, and capital planning with consolidations
• Provide consolidation expertise related to processes such as minority interest, purchase accounting, joint venture accounting and legal and management consolidation
• Set Run Data Management Packages and Monitored BI Data Loads
• Configured Several BPC Process chains for Allocations
• Designed and Configure, maintained several Application Sets, Applications, Dimensions hierarchies Dimension properties
• Handling complex scenarios in BPC 7.5 NW implementation
• Account transformation and Logic guidelines to BPC Developers
• Resolved independently many User Reported Issues in BPC Applications

Confidential, Milwaukee, WI

Sr. SAP BI SEM/BPC Lead Solution Architect

Environment: SAP BI 7.5, ECC 6.0, BPC 7.5 NW Ramp-up

Responsibilities:

• US GAAP Legal Consolidations:
• Gather Requirements and conduct workshops
• Involved actively in BPC Product Feasibility analysis and Business Blue Print Sign-off,
• Configured BPC Apshells, Applications like Legal, IC Matching, Ownership and Rate
• Configured different Business Processes of Consolidation Tasks like balance Carry Forward, Data Collection, Local Currency, Retained Earnings, Journal Entries, Inter-unit Eliminations and so on.
• Developed Consolidated Financial Statements like P/L, C/F and B/S at Consolidation Group Level
• FMCI - (Future Material Cost Impact)
• HOG- (Harley Owners Group)
• PVP - (Production Volume Planning)
• HAM - Harley Accessories & Merchandise
• SG&A - Sales General /Admin Expenses
• HMC - Harley Motor Cycle Planning
• Configured Applications, Dimensions, and Reports for above Planning areas.
• Lead Development team for writing necessary Script Logic and business Rules
• Involved in Test Cycles from Sandbox to QA systems
• Played major role to get BBP Docs sign off
• Documented all developments in the form of Design Documents

Confidential, Chicago, IL

Sr. SAP BI SEM-BPS/BCS/CRM/TPM Consultant

Environment: SAP BPC 7.5 NW SAP BI 7.5, ECC 6.0, CRM, TPM, SEM-BPS BCS

Responsibilities:

• As part of Budget/Expenses Reporting & Planning Analysis,
• Involved in the Design of Pepsi Business Solution Group Prototype and Development systems for the following Layouts. This involves Project Systems Budget Planning
• Employee Hours/Rate Layout that calculates the Hourly Rates of Employees there by Total Cost of Employees can be planned.
• Developed different Reports both for Open/Contractor Employees and Regular Employees
• Designed a Procedure that gives AOP Upload File Process into BW for R5 Interim Solution
• 3 Layouts one for Plan, Forecast and Strategic are designed which can give Expenses by Cost Element, Project and WBS Element.
• As part of TPM-BPS Integration has developed Planning Areas, Planning Layout for Targeted Sales and Targeted Volume for incremental Volume/Sales as part of Opportunity Planning.
• Evaluated CY YTD Sales Amount, Sales Volume, PY Sales Volume, PY Sales Amount and Targeted Sales
• Created Custom Planning Profile to maintain Multi Planning Area with all its sub-ordinate objects.
• Linked BW BPS Planning Profiles to Transaction Types in CRM TPM
• Developed Plan vs Actual Analytical Reports for Tracking of Funds and Volume in TPM
• Designed Planned Layouts for several Trades spends part of TPM and for a particular planning account/ target group.
• Configured and Customized different Planning Areas, Planning Levels and Planning Functions part of Promotion Planning (TPM)
• Configured and Designed Several Multi-Planning Areas, Planning Levels, and Planning Functions.
• Developed Several Complex Fox Codes to achieve some Functionalities based on several restrictions and Calculations
• Also as part of Top line & Allocations BPS Architect has designed and developed Several Design Documents which gives Complete Solution for Integrated P/L Statement and Allocations at Planning Brand Level.
• Developed Several Copy Functions and Planning Levels, Packages, and Layouts for Allocations Release 5 Solution.
• Developed an Upload File Functionality in to BPS as part of feeding data into Allocation Grid which carries all Data by program Positions, Planning Brand and by Segment.
• Has complete understanding of overall R 5 Design Architecture which includes, Sales, revenues, COGS, A & M, D & A, Capital, Other Expenses & Income, Military, Joint Ventures (Lipton, Starbucks) and Canada business Process along with Media Plans and Layouts.
• Had given Presentations to Business users and Business Managers about the Design and Development.

Confidential, Paramus, NJ

Sr. SAP BI-IP/OutlookSoft BPC Lead Consultant

Environment: SAP BI 7.0, ECC 6.0

Responsibilities:

• Applied Performance tuning for BPC Administration, Layouts.
• Initial Budgeting along with Budget and Forecast Version Comparison Reports
• Interunit Eliminations in the process of Consolidation.
• Resolved Scalability Issues as part of BPC implementation.
• Designed and Created Logic (Excel, Dimension and Advanced)
• Designed and Configured Concurrent Locks, Data Manager Packages,
• Involved in configuration of Sales Plan (Whole Sales Plan, After Sales, and Retail Sales), Cost Center Plan, CAPEX Budget Plan, HR Salary Planning, and Gross Sales Margin Plan.
• Developed complex Rolling Forecast 12 - 18 months Layouts for Budget Plans
• Designed several complex Layouts some using WAD and few with Excel based.
• Published all Layouts on Web coordinating with EP team.
• Coordinate with BASIS Security team in setting up roles and authorizations.
• Designed Planning / Consolidation Layouts both for Units and Amount
• Have developed very complex Planning Functions such as Dynamic Variance, Complex Revaluations
• Written complex BPC Script Logic Formulas in P/L, Balance Sheet Consolidation Layouts
• Involved in development of Brand P & L reports based on Cost Center & Sales Plan.

Confidential

Sr. SAP BI NW Lead Consultant

Environment: SAP BW 3.5 / BI 7.0/R/3 4.6 C/ECC 5.0

Responsibilities:

• Conducting User Workshops
• Understanding their Business Process
• Lead BW team for realization
• Actively Co-coordinating with team in filling out Gap Analysis
• Finalized BBP Business Blue Print Doc
• Working under tight deadlines to take this Roll out Project Live soon
• Done high level custom Info Cubes, ODS's and Multi Providers
• Requirements gathering for Sales & Budget Plans and Forecasting.
• Designed complex Planning Layouts, Planning Areas for both Sales and Budget Forecasting.
• Used Fox Code for some complex Planning Functions.
• Validated Planning functions
• Configured Transactional Infocubes for Actual & Plan data
• Worked closely with the Basis Team in fixing many technical issues in several Phases like,
• Full Life cycle upgrade experience includes current system study, proposed the design of target database, Business requirement gathering, gap analysis, system design, configuration and upgrade, Regression testing, Go-Live and Production support for BI 7.0 system and to end users.
• Copy of 3.x Prod environment as new Dev. environment.
• Done performance testing in new DEV environment. Fixed the defects and done Re-testing all Objects
• Copy the new Dev. environment (Upgraded) as new Quality Environment
• Do detailed regression testing (Back end and front end.) in new Dev. environment and figured out defects.
• Fixed the defects in new Quality environment also, which we got in new Development environment.
• Helped users in their UAT test giving them some fruitful inputs.
• Implement the changes which we got in new Dev. and new Quality.
• Co-ordinate with SAP support through online support system (OSS) for solving the high priority problems.
• Documented the Gaps between SEM-BPS to BI - IP
• Container History Report

Confidential, Mission Viego, CA

SAP BW SEM Lead Architect

Environment: SAP SD FI BW 3.5 / ECC 5.0/ SEM 4.0/ BPS CRM-TPM/TCM/TFM

Responsibilities:

• Primary role is to design and implement BPS Planning Grids to support Trade Promotion Management related business requirements. Identifying application requirements.
• Worked as BW-BPS Backend Data Modeler Analyzing and Designing Business Blue Print, Architecture.
• Conducted Client Workshops (User Interaction Sessions)
• Played Crucial Role in getting BBP Sign off for BW-BPS.
• Responsible for analyzing the business requirements, functional design as part of Business Blue Print, convert requirements into Specs and Documentation.
• Develop, document, test and implement design with acceptance and support of business and audit controls leadership.
• Created planning areas & manual planning layouts in both GUI and Web versions for the business requirements in BPS module in SEM. Created data slices and variables for controlling of layouts.
• Creation and Maintaining Planning levels, planning packages, planning functions and planning layouts.
• Created Transactional Info cubes for BPS layouts.
• Worked on development of BPS layouts for the user to allow entry of data manually.
• Web Interface Builder has been extensively used to organize and display Plan Layouts, Planning Functions
• Fox Code has been used, to get custom Functions.
• Identifying Trade Discounts and Performance Requirements for Customer, Product and Time Period as part of TPM
• Configure application and write supporting functional enhancement design documents to meet identified requirements.
• Identify, document and conduct all unit testing, mock and system testing of mission critical scenarios; manage expected results versus actual results; track and resolve errors.
• Integrated SAP Trade Promotion Management, Trade Funds Management, Trade Claims Management and Field Planning/Forecast with to DP and Supply chain Management
• Actively involved in Unit and Integration Testing.
• Assisted Offshore Team of SAP India, Bangalore in developing Bex Reports.

Confidential, Minneapolis, MN

SAP BW Lead Architect

Environment: SAP ST BI 7.0 / ECC 5.0

Responsibilities:

• Worked as BI Backend Data Modeler
• Conducted Client Workshops (User Interaction Sessions)
• Mentor team of 4 members as a Team lead.
• Actively involved in designing BI data Model for a successful BW implementation
• Responsible for analyzing the business requirements, functional design as part of BPP, convert requirements into
• Documentation of Specs and Given KT to clients.
• Activated Standard Business Content and customized Infoproviders like Contract (0MEMAMC04), Schedule Lines
• Applied necessary update routines for the Info sources (0ME ISM AM ORDER 2), (0ME ISM AM ORDER 1)
• Developed complex queries for Financial, Sales and Logistics Modules as per Business Analytics needs.

Confidential, Brea, CA

Sr. SAP BW Consultant

Environment: BW 3.5 / ECC 5.0/SEM 4.0

Responsibilities:

• Conducted User Interaction sessions, to understand and collect Business requirements
• Involved in developing Business BW Data Model
• Performed several BW Development Tasks
• Trained End users on BW Back end related issues.
• Has involved in User Sessions and other such BW developments in different areas of Reporting, Modeling and Extraction.

Confidential, Fremont CA

SAP BW Lead Consultant

Environment: SAP BW Versions 3.5, BEx, R/3 4.7, 4.6C:

Responsibilities:

• This is a critical BW Implementation project with multiple source systems residing remotely in 3 different countries across the Globe.
• Interactions with clients across globally France, Italy and North America for Business requirements and Project Deliverables.
• Involved actively in review/provide inputs to both Functional/Technical Document Specifications.
• Shouldered responsibilities for the following technical activities within BW:
• Published queries on web.
• Worked on Business Explorer (BEx) and Web Browser.
• Worked on conditions, formulas, RRI interfaces, filters, drilldown methods.

Confidential, Morristown, NJ

SAP BW Lead ConsultantBy (SAP America)

Environment: SAP BW 3.1c, Oracle, NT

Responsibilities:

• As Sr. BW Architect for the SAP CFM BW Project, responsible for looking into Data Model Redesign where necessary, developed some quick customized reports, resolved many performance related issues in production support for building a homogeneous and consistent data warehousing by organizing and monitoring transfer of data from SAP OLTP (R/3-RMCA) system as well as from external systems. Also mentored a team, and trained Clients.
• Knowledge transfer to the Client and trained users in creating Ad-Hoc reports using Bex Analyzer
• Developed various templates for Cube Documentation, Unit Testing, Functional Unit Testing and Integration Testing. Developed various documents such as Naming Conventions, Transport strategy, Loading Strategy, End-User .

Confidential, Detroit, MI

SAP BW Programmer Analyst

Responsibilities:

• Worked as SAP BW Programmer Analyst with GIS Internal Project.
• Worked as IT Corporate BW Trainer

Confidential

SAP BW/ABAP Consultant

Responsibilities:

• Participated in all stages of SAP BW implementation starting from Project Kick-off through Realization (configuration) and Go-Live to Production Support for building a homogeneous and consistent data warehouse by organizing and monitoring transfer of data from SAP OLTP system as well as from external systems.
• Implemented ASAP Methodologies in implementation of SAP ECC- BW for FI/CO, SD and MM modules Installing business content and creating an R/3 source system in BW
• Enhanced query performance using BW Statistics, query read modes and aggregates
• Defined and modeled queries to satisfy business analysis. Developed web reports using Web Application designer.
• Used Process Chains to automate data load processes, maintaining BW statistics, rollup of BW aggregates.
• Knowledge transfer to the Client and trained users in creating Ad-Hoc reports using Bex Analyzer
• Developed various templates for Cube Documentation, Unit Testing, Functional Unit Testing and Integration Testing.
• Developed various documents such as Naming Conventions, Transport strategy, Loading Strategy, End-User
• Developed Classical and interactive reports for various shipment costs for the Shell Logistics Modules
• Trained users in creating Ad-Hoc reports using BEx Analyzer.
• Participated in post implementation Business Information Warehouse for SD and MM modules.
• A total of 3 custom cubes and 4 pre-delivered were developed as part of the Global Deployment
• Customized many Sales Information, Inventory, Annual Sales Plan InfoCubes and ODSs for supporting monthly & weekly extractions.
• Managed user authorization with the Profile Generator
• Involved in Data maintenance
• Involved in Performance tuning, including parallel query option and data packet sizing
• Extensively involved in customizing and enhancing SAP R/3 SD and MM modules for implementation
• Wrote many transfer rules and update rules to support the business logic and conditions.
• Involved in developing the technical specifications and Configuration/Customization.
• Performed several ABAP Development Tasks

Confidential

SAP ABAP Developer

Environment: SAP R/3 v4.6b/4.6c, ABAP/4, SD, MM, PP, FI, QM

Responsibilities:

• Extensively involved in customizing MM and SD (particularly Logistics) modules
• Also involved quite a bit in customizing the PP module
• Performed several ABAP Development Activities

Infobank

Software Developer

Environment: VB, Oracle

Responsibilities:

• Worked as Software Programmer in Banking Application Software.