SUMMARY

• Seven (7) years of SAP Portal experience in providing consulting to implement SAP NetWeaver solutions. Sixteen(16) Years of SAP experience in the IT industry
• Experienced in installation, configuration, administration, testing, troubleshooting/monitoring, and performance optimization of SAP WAS, SAP NetWeaver Portal, TREX, and Internet Transaction Server (ITS) on variety of platforms
• Experienced in customizing/developing the SAP Portal components using JSP, NWDS, WebPage Composer, Visual Composer, WebDynpro Java
• Worked on various versions of Enterprise Portal: Enterprise Portal 6.0, Enterprise Portal 7.0, Enterprise Portal EHP1
• Worked on Netweaver Portals.
• Strong Experience in Migration of SAP Enterprise Portal.
• Knowledge in SAP BPC 5.0, BPC 7.0, SAP BW, WebDynpro ABAP and HR ABAP programming
• Experience in various phases of the Project Lifecycle, which includes Project Preparation, Business Blueprint, Realization, testing and maintenance to production support
• Highly motivated person with strong management, administration, problem solving, decision making, and analytical, good interpersonal and communication skills
• SAP - BI, SEM-BPS, BPC, IP, Bex, SAP R/3, Business Objects (Webi, Xcelsius, Crystal, Universe Creation), IDD, ISU/CCS, ECC 6.0, BI-7.0, ABAP, UNIX, UC4, DATASTAGE.

PROFESSIONAL EXPERIENCE

Confidential

SAP-BI, BPC Architect Consultant

Responsibilities:

• Architected, designed and developed planning and consolidation using BPC. Following are the salient points of my projects.
• Blue printing, design, developing, testing and supporting the Business, planning, and consolidation requirements.
• Creation and maintenance of planning application for revenue planning, cost planning.
• Creation and maintenance of Dimensions, Members, Script Logic and Configuring BPF for revenue planning, cost planning.
• Loading of master data and transaction data to BPC using the DM.
• Documentation, training users and supported the BPC system System maintenance and support: Resolution of help tickets created in REMEDY.

Confidential, Lowell, MA

SAP-BI, BPC Architect/Developer

Responsibilities:

• Interact with users to formulate the business requirements and design and develop the planning, forecasting, budgeting requirements.
• Prepare Planning and consolidation design documents and BPFs.
• Prepare functional, technical specification for Planning, consolidation reports.
• Exchange rate Maintenance
• Defining and Creating Input schedules, output reports using EVDRE and other EV functions.
• Worked on dimension management such as creation, maintenance and members additions and deletions.
• Script Logic to arrive at net profit and other calculations.
• User Security such as team, task, member access profile creation, maintenance. Also restricting user access by activity, for reports only and specific to region.
• Developed dynamic Report templates, Layout, input schedules templates, Expansion Functions, Formulas, Filtering, Conditional Formatting and comment sheets.
• Developed Input Schedule for planning application such As Budget Input Template, Forecast Input Template, Actual Adjustment Templates Etc.
• Develop Reports for Planning Application such as Budget Analysis Report, Forecast Analysis Report, Performance Reports, Budget Report by Cost Center, Work Status Report etc.
• Data management and loading of transaction data to BPC using the data transformation, conversion logic, Master Data loaded to a BPC Dimensions. Validation of data loaded.
• Develop Custom Menu For Budgeting And Forecasting Cycle.
• Trained and supported end users for BPC system related issues/requests.

Confidential, hiladelphia, PA.

BI Architect/Project Lead

Responsibilities:

• Successfully set up SAP BPC 7.5 NW for detailed Planning, Budgeting, and forecasting for leveraging the existing data warehousing infrastructure
• Prepared process Definition Document (PDD), Report definition Document (RDD) for the planning, budgeting and forecast processes
• Prepared project blue print, road map & standards for implementing BPC platform.
• Actively involved in gathering the requirements, technical & functional specifications for the business process for Financial Planning
• Developed Applications for Financial Planning, Revenue Planning
• Carefully analyzed the data and developed Dimensions and its properties to suit the complete operations of the planning process at the Client site
• Developed Financial Planning and Forecasting models, involving multiple sets of Input scheduling templates, including Inventory adjustment, Warranty Costs, Cash Flow, Employee Grades template, Employee Salary Caps template and Employee hiring Input schedules
• Created Income and Balance Sheet reports in BPC using EVDRE functionality incorporating best practices of BPC to get efficient reports.
• Developed Script logic for currency conversions
• Created default logic for calculating revenue from sales unit prices in BPC
• Configured the currency translation logic, maintain rate application, rate dimension, business rules, Account Dimension, Rounding functions for the report
• Designed transformation and conversion files for synchronizing incoming data from SAP BI/ ECC systems into BPC.
• Set up security network for Financial Planning through developing member and task assignment profiles and assigning them to members and teams.
• Developed many reports including Trend, Variance, Drill down and Rank templates
• Configured data manager extraction from ECC and BI system for the actual, plan data
• Executed the optimization tool for lite and full optimization
• Prepared the documentation on the input template and data extraction of consolidation and planning requirements
• Extensively worked on Query Designer, BEX Analyzer 7.0 and Web application designer (WAD)to create Queries for all actual reports
• Designed test scenarios while Unit testing; Functional & Integrated testing is done and sign off obtained from the Business Owners
• Prepared the documentation on the input template and data extraction of planning requirements
• Detailed Training Guide is prepared and hands-on training provided to the Super Users and Star Users

Confidential, Chicago, IL

Lead BW/BPS Architect

Responsibilities:

• Involved in gathering requirements from client, Understanding the Business process in EPDW and developing Functional and Technical Specifications.
• Estimation and GAP Analysis for the Project and presented those to Client and successfully started the project.
• Working on Design of project based on GAP Analysis done and Functional Spec prepared.
• Estimation and GAP Analysis for the design to be modified.
• Analyzed and converted all the EPDW Logic for whole of Actual data of all Applications.
• Created Conversion files and Transformation files for extraction of data from BI system to load using DM packages.
• Transformed the source data incorporating various transformations and conversions into stage tables.
• Consolidate all cash flow, balance sheet, profit and loss, OPEX, CAPEX and OPSTAT data into datamart layer.
• Developed the Reconciliation reports using EVDRE to accomplish reconciliation of data between BPC and BI
• Perform regression testing to validate the accuracy of the actual data.

Confidential

BW Analyst/Programmer

Responsibilities:

• Extracted CO data to incorporate overhead Cost controlling and Cost Center Accounting data in BW reports. Developed reports for Business profitability analysis, Profitability summary by product hierarchy, customer purchase summary, Profitability detail by product hierarchy,
• Profitability summary by customer, actual price realization comparison, Profitability summary by geography, Profitability summary by customer and product .
• Responsible for the evaluation of the current system and defining the scope of the BW project for cost controlling and developing extractors and reports.
• Worked on the design, development and maintenance of the BW solution. Having analyzed the requirements, worked on gap analysis and identified existing business content as well as areas for enhancements.
• In-charge of loading and monitoring data in to the cubes for the sales, delivery and invoicing as Part of Order to Cash implementation. During this time, improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs as well as through ABAP tuning. As a result of these efforts data loads were conducted successfully within half the time.
• Modified both generic SAP R/3 extractors as well as LIS and LO-Cockpit extractors. During the upgrade from SAP BW 2.0B to 3.0A, responsible for quality assurance on the extraction side and for implementing required modifications. Implemented reporting requirements by developing BEx-queries for the areas mentioned.
• Developed reports using ALV grid technology for accounts payable department for cost controlling and reconciliation.