PROFESSIONAL BACKGROUND

• Over 18 years of SAP Project experience that includes 10 years of managing and leading SAP development teams. Managed all aspects of SAP solution design through technical and Functional implementation
• Recognized, dedicated solution - architect, with proven track record and notable success on various assignments including SAP Business Planning and Consolidation (Netweaver, Classic and Embedded) BW, SAP HANA, SAP R/3,design, development, implementation and project management.
• Dynamic leader and mentor who builds the state-of-art application and inspire individuals and customers
• Exceptional customer relationship and management skills
• Possess a solid background and qualification to perform the duties in best professional manner
• A results-driven consulting professional with success delivering finance transformations, business process improvements, performance management, and implementing customized and packaged solutions, including SAP Simple Finance, S4 HANA, BPC & BW at Fortune 100 clients.
• Strong skill set in SAP EPM 10.0, 10.1NW, BPC 7.5 NW-MS, 7.0NW with SAP BI 7.4, 7.3 & 7.0, SAP HANA.
• Extensive experience implementing SAP Netweaver BI 7.0, Enterprise Performance Management (EPM) SAP BW 7.x integration with SAP ECC (R/3) modules like SD, HR(HCM), MM,FI/CO, IS Retail, PoS DM, Integrated Planning, using ASAP methodologies.
• Involved in full life-cycle implementations of 7 SAP projects using ASAP methodology
• Strong skill set in SAP EPM 10.0NW, BPC 7.5 NW-MS, 7.0NW with SAP BI 7.3 & BI 7.0.
• Excellent Understanding on BW-BPC Integration process and a solid understanding and experience of BPC functionalities - both Planning and Consolidations (business rules, script logic, journals, input schedules, reports, BW integration for master & transactional data etc.)
• Expertise in SAP BPC includes - Creating new Environments, Models, Dimensions, BPC security set up, Script Logic, Loading and Validating data, DM Packages, BPC for Excel, Work Status, BPC process flows, Journals and Performance Tuning Best Practices.
• Hands on experience in setting up of all the business rules including - Account Transformation, Carry-Forward, IC Eliminations, Validations, Currency Translations, Allocations and IC Matching/Booking.
• Expert in ETL (Data Extraction), Data modeling, Report designing, Performance Tuning, Process chains, Transports.
• Documented Test Plans and complete Unit Testing of Developed Objects and Reports. Worked with QA business resources to complete System and Integration Testing. Troubleshoot issues and follow up with SAP (OSS-Notes)
• Involved in 2 SAP BW upgrade projects. Good hands on experience & knowledge of BI Technology.
• Excellent knowledge of what defines project scope, SLA, risks, quality, UAT & Change Request process.
• Ability to understand the existing process quickly, determine gaps and develop to-be processes to meet new requirements. Ability to suggest better processes if needed.
• Data warehousing knowledge, with hands on experience in ETL tools like Informatica 6.0.
• Excellent Communication, Organizational, and Interpersonal skills.
• Conducted trainings for end-users and project team members
• Experience in managing & working with onsite and offshore teams

TECHNICAL SKILLS:

ERP: SAP BW Versions: 7.3,7.0, 3.5, 3.1C, 3.0B, 2.1C, 2.0B SAP R/3 Release ECC 6.0 EHP3&4, 4.7, 4.6B, 4.6C

Language: ABAP/4, XML, PL SQL

Tools: Business Objects 5.0, Cognos 6.0, Informatica 6.0, ERWIN

Reporting Tools: Business Objects XI R2, 3.1 (SP2 & SP3), Xcelsius 2008 Enterprise, Crystal Reports, Web Intelligence, OLAP Universe, Connections - QaaWS & LiveOffice

Data Modeling: : SAP BW(RSA1), ERWIN

PROFESSIONAL EXPERIENCE:

SAP BPC Lead

Confidential

Responsibilities:

• involved in the Migration of SAP BPC system to Azure environment
• Conducted workshops to capture the New Companies data requirements after the Migration
• Work with stake holders to get sign off on BPC migration strategy
• Documented as is and to be consolidation processes based on the new company’s requirement
• Develop test scenarios and test scripts for testing after the migration

Environment: SAP BI 7.4, - BPC 10, SAP S4 HANA Financials, SAC

SAP BPC lead

Confidential, Madison, NJ

Responsibilities:

• Lead the project to build the Global template for FP&A G&A functions using the SAP BPC
• Conducted workshops to capture reporting requirements for G&A functions which include Global IT, Global Finance, Legal, Compliance, Corp Affairs, Compliance, BDL, Facilities, BDL and HR
• Work with the business owners to put the standard across all the G&A reporting
• Build the reports using SAP EPM functionality and created the workbooks for publishing
• Put the Standard operating procedure for the month end activity for report publish and entering commentary for executive board.

Environment: SAP R/3 ECC6.0 and SAP BI 7.4, - BPC 10

SAP BPC lead

Confidential

Responsibilities:

• involved in the implementation of SAP BPC for the UK JV rollout and post production support for SAP BPC planning and Consolidation system
• Successfully set up SAP EPM 10.0 NW for detailed Planning, Budgeting, leveraging the existing data warehousing infrastructure
• Performed the integration testing and prepared the test scripts
• Created Reports and Input Templates using Excel Interface of EPM add-in
• Created Drill Through reports from BPC Excel reports to BW Web Analyzer, to drill from Group accounts in BPC to G/L in BW reports
• Provided support to FP&A team during the month end close. Help the FP&A team to validate the plan data prior to execute the allocation process.
• Identify the inconsistency in the Actual and Plan data for international BPC model
• Worked on several Jira tickets to create the new reports and resolve the issues with the existing reports
• Daily house keeping of SAP BI/BPC system
• Supporting the global SAP BPC/BI system
• POC for the BPC Optimize for S4 HANA on Cloud for the Revenue Planning model
• Set up S4HANA optimize BPC model for Planning

Environment: SAP R/3 ECC6.0 and SAP BI 7.4, HANA - BPC 10,

S4/HANA Analytics Principal

Confidential

Responsibilities:

• Involved in the implementation of SAP S4 HANA, BPC Optimize for S4/HANA for Global Financial Transformation Project
• Conducting workshop to gather the business requirements
• Use BPC optimize for HANA to build the robust solution for Revenue Planning, Expenses Planning and Profit Center Planning set up the BPC system from scratch and configure IMG settings
• Created BPC Embedded Models, Aggregation Level, Planning Functions to full fill the business requirements
• Worked with business users to do the GL, Profit Center and Cost Center old to new Mapping from Hyperion system.
• Convert the Hyperion reports to SAP BI and BPC reports extensively used Macros in EPM Report Build
• Migrated the Hyperion work books to SAP EPM work books for users to perform planning
• Build the Global template using Analysis Office and EPM Add in to support planning Process
• Created several custom EPM Add in Reports and Input forms using EPM addin functionality
• Supported the BPC embedded consolidation project to define the data models and build the data flows from virtual providers to BPC Consolidation cube
• Work with the Global business owners to build the role based on Cost Center, Profit Center hierarchies
• Extensively work with the Business owners to finalize the EPM Security roles
• Created the Data Access profile, BPC teams, BPC roles to facilitate the Global reporting requirements
• Assign the users to Specific BPC teams and based on the user role grant them read write access to specific folder
• Fix several EPM reports production support issues after go live.
• Trained users to use the EPM Add in Reports and book publishing functionality

Environment: SAP S4 HANA 1610, Embedded BPC 10.1, EPM Addin SP 27, Analysis Office 2.4 and SAP BI 7.5

SAP BPC Planning

Confidential

Responsibilities:

• Involved in the upgrade of SAP landscape to SAP on HANA for BW/BPC
• Worked with the basis team and coordinate the upgrade effort to SAP BPC on HANA
• Involved in the implementation of SAP BPC 10.1 for cost allocation project
• Created DSO and Cubes to extract cost element data to support BPC10.1 Model
• Work with the developers to create custom BADI to move data from one LOB model to Other LOB Models
• Improve the existing data flow and storage in SAP BI to load data into SAP BPC
• Support the existing Consolidation Models and perform the enhancement for US GAAP
• Extensively worked on EPM report creation
• Architect the Data flows from SAP and Non SAP system into SAP BI and BPC
• Created new SPO to transform the data in SAP BI to accommodate the SAP BPC requirement’s and extensively work on the integration of SAP BI to BPC, which includes transformation, Conversion files, DMP links and BW Process chains
• Build interfaces from SAP and Non SAP system to support BPC 10.0
• Build the master data and transactional data objects in BW for BPC Models
• Build several Info providers in SAP BI to support the SAP BPC 10.0 for master and transactional data and crested process chain to automate the data loads from SAP BI to BPC system
• Automate the data loading process from SAP BI and SAP BPC

Environment: SAP R/3 ECC6.0 and SAP BI 7.4, HANA - BPC 10 and BPC 10.1

SAP BPC/BI Architect

Confidential, Atlanta

Responsibilities:

• Involved in migration of SAP BPC 7.5 to SAP EPM 10.0 on HANA.
• Created the Mini Project Plan to track all the objects and dependencies
• Lead the efforts to perform unit testing, regression testing and perform UAT with business
• Migrated the BPC 7.5 Objects to BPC 10.0
• Build the BW/BPC integration Objects and automate the data loading using the BW process chains and DMP package links
• Created BW Info Providers, data flows, to feed BPC Models
• Copy packages to copy the forecast, plan, and budget data.
• Configure data manager extraction from ECC and BI system for the actual, plan data.
• Highly usage of conversion, transformation files for the data management process.
• Created Drill Through reports from BPC Excel reports to BW Web Analyzer, to drill from Group accounts in BPC to G/L in BW reports
• Migrate several BPC report from 7.5 to 10.0. Extensively used BPC formatting sheet, local member formulas, and macros
• Configured Business Process Flow (BPF) to provide consistent process across organization
• Implemented Security and User access using Applications, Task Profiles and Member Access Profiles
• Conducted workshops to train the users on BPC 10.0

Environment: SAP R/3 ECC6.0 and SAP BI 7.4, HANA SP 9- BPC 10.0

SAP BI/HANA/BPC Managing Consultant

Confidential

Responsibilities:

• Successfully completed Product Line Planning Project as Lead in SAP BI/BW 7.3 with HANA and BPC 10.0 with EPM Add-in environment
• Conducted several workshops to gather business requirements
• Prepared project blue print, Documented and develop Integration of SAP BI to BPC system
• Created Technical Documents (TD) and Functional Documents (FD)
• Created data load automation for transaction data from SAP BI HANA system to SAP BPC
• Extensively developed data models in SAP HANA to support the BPC Models
• Created APL Model, Dimension, Members to support the planning process
• Created Finance application and Rate application in BPC for Financial Planning, Budgeting and Forecasting
• Designed Dimensions to capture the Financial Planning & Processes of the Client
• Work with the Developers to develop complex Write back BADI to do the calculation trigger from the EPM Input forms
• Tested the data validation with SAP BPC and SAP BI and created test script for testing and training purpose
• Identified the current state of the process, as well as improvements that need to be made
• Established process performance objectives
• Design the complex BW integration to BPC system
• Fix the issues BPC on HANA environment

Environment: SAP R/3 ECC6.0 and SAP BI 7.4, BPC 10.0, HANA SP 84

SAP BPC Managing Consultant

Confidential

Responsibilities:

• Finance Transformation initiative to deliver Two key Financial Planning & Analysis projects spanning Net Revenue Forecasting, and Headcount Planning Optimization, using SAP BPC as the reporting solution
• Responsible for the overall delivery of functional and technical components of SAP BPC implementation for Net revenue, and HCM for BPC 10.0
• Responsible for the implantation of Global template for Net Revenue forecasting model, Migrate the Excel Model to SAP BPC 10
• Responsible for standardize the forecasting process
• Define scalable process to be used starting in 2014 for future Net Revenue forecasts
• Develop Secure and Control process to provide appropriate data access and visibility by role around forecasting process
• Establish BPC as Single System of record for AHUS,PNH, and HPP forecasting Model
• Automate Revenue Forecast Process across organization
• Architect the SAP BPC Models, Dimensions, for complex revenue forecasting model for FP&A Globally
• Provide Ability to compare Actual vs. Forecast and Prior Forecast vs. Current Forecast
• Created complex input schedule and EPM reports using different EPM functions
• Managing the onsite and offshore resources, tracking the development activities, and updating the stake holders on weekly basis
• Managing the scope of the project and assisting the offshore team to provide technical solutions
• Successfully deployed working SAP BPC based Net Revenue Forecast Models across 56 countries

Environment: SAP R/3 ECC6.0 and SAP BI 7.3, BPC 10.0

SAP BI/BPC Senior Consultant

KPMG

Responsibilities:

• Responsible for preparing the “How-To” Documents for various activities the end-user performs in BPC and conducting training sessions to help them understand and explain the functionality of the new environment (BPC 10.0 NW) and the BPC Terminology such as Name space, Application sets, Applications, Dimensions, Dimension members, Properties, Hierarchies, Functionality of Data manager, Optimization process and BPC Front end such as BPC for Excel and BPC Web.
• Involved in the cutover activities for the go live and production support of the Global roll out of the SAP BI system
• Involved in to build the training and staging boxes for project support. Loaded data and assist users to perform test scripts
• Involved in a meeting to support SAP BPC implementation effort.
• Conducted workshop to gather requirement for Revenue planning and Cost planning.
• Developed Applications for Revenue Planning, and Expense Planning
• Carefully analyze 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
• Designed transformation and conversion files for synchronizing incoming data from SAP BI/ ECC systems into BPC
• Maintained and extracted Master Data from SAP BI system using data manager packages
• Prepared multiple complex static and expansion reports using EPM functions, and other functionalities as part of go live support for BPC 10.0 NW
• Client is rolling out the global template for the FI/CO, CRM and HCM module
• Involved in the cutover activities to support the go live activities for Canada
• After the go live support the business users
• Coordinated with the development team for the defects

Environment: SAP R/3 ECC6.0 and SAP BI 7.3, SAP CRM

SAP BI / BPC 10 Managing Consultant

Confidential

Responsibilities:

• Gather requirements for blue print, build, planning, budgeting and forecasting functionalities.
• Prepare Process Definition Document (PDD), Report Definition Document (RDD) for the finalized consolidation, planning, budgeting and forecast processes.
• Successfully set up SAP EPM 10.0 NW for detailed Planning, Budgeting, and forecasting for leveraging the existing data warehousing infrastructure
• Activated several Info Cubes, DSO and Master data to support SAP BI reporting requirements
• Interacted with the client & involved in enhancements and cut-over
• Extensively worked on designing process chains
• Activation of business content in SAP-R/3 and BW
• Created DM Packages to load Master and Transactional Data into BPC Dimensions and Applications respectively. Worked extensively with Copy, Move and Optimization Packages
• Set up security network for Financial Planning through developing member and task assignment profiles and assigning them to members and teams.
• Creating info providers (ODS objects, info cubes to support SAP BPC requirement
• Configure the currency translation logic, maintain rate application, business rules, Account Dimension, Rounding functions for the report.
• Copy packages to copy the forecast, plan, and budget data.
• Configure data manager extraction from ECC and BI system for the actual, plan data.
• Highly usage of conversion, transformation files for the data management process.
• Configure application set, application for legal and management consolidation.
• Created/maintained custom dimensions, dimension properties, dimension hierarchy for entity, account, product and time.
• BPC process chain development to the financial data to staging DSO and to the cube and to support master data loads from BW to BPC.
• Execute the optimization tool for lite and full optimization.
• Load the historical data, opening balances current year data to BPC application from Hyperion ESSBASE.
• Reconcile the data of BPC planning extracts with BI, ECC application.
• Developed many reports including Trend, Variance, Drill down and Rank templates
• Created standard input schedules for posting forecast data at entity level for all business users and power users for Expense, Revenue, Revenue Headcount and Quantity
• Develop the planning and consolidation reports using the BPC reporting services and EPM Functions.

Prepared documentation on the input template and data extraction of consolidation and planning

Environment: SAP R/3 ECC6.0 and SAP BI 7.3, EPM 10.0, BOBJ 4.0

SAP BI/BPC Managing Consultant

Confidential

Responsibilities:

• Involved in leading the support effort for complex SAP BI /BPC consolidation environment
• Responsible for preparing the “How-To” Documents for various activities the end-user performs in BPC and conducting training sessions to help them understand and explain the functionality of the new environment (BPC 7.5NW) and the BPC Terminology such as Name space, Application sets, Applications, Dimensions, Dimension members, Properties, Hierarchies, Functionality of Data manager, Optimization process and BPC Front end such as BPC for Excel and BPC Web.
• Developed Custom Script Logics to automate loading of Plan Data from the Planning (Financial) Application to Consolidation Application and to calculate various KPI’s.
• Created a Custom DSO in BW to hold Actual/Plan/Forecast Data for Management Reporting purposes.
• Developed a BPC/ECC interface that exports BPC Budgeting data into ECC via an Application Server with Query Extract using RSCRM BAPI.
• Configured Journals and troubleshot issues with templates and entries while Copying, Reopening Journals and while copying Application Set (SP5).
• Fixed several production support issues which include COP currency conversion issue and APD issue
• Investigate and fixed several production support performance and data load issue
• Lead the team of two onsite resources and 3 offshore resources.
• Support the Global reporting and roll out global template for GL reporting requirements
• Investigated and fixed several Master Data, Transactional data, query performance, data load performance issues
• Responsible for the daily production support issue, SDE tickets and distributing the work among team members
• Working on the POC BW/BPC integration project, created the staging GL Account balance cubes to accommodate BPC consolidation application. Setting up master data member, dimension for BPC
• Report to the higher management regards the BW issue, Fixes and ongoing effort to optimize the BW/BPC system

Environment: SAP R/3 ECC6.0 and SAP BI 7.1, MS BPC

SAP BI/BPC Lead

Fujitsu Consulting, Atlanta

Responsibilities:

• Designing and developing a financial reporting solution in BPC NW 7.5 (SP4)/BW (BI 7.0) by using EHP3 Business content.
• Conducted workshop to give high level overview of SAP BW and BPC system to different groups, gather user requirements, review existing reports, and prepare the business blue print document
• Designed & Developed BPC Applications - Legal, Rate & Ownership
• Created BW InfoProviders, data flows, to feed BPC applications
• Created Through reports from BPC Excel reports to BW Web Analyzer, to drill from Group accounts in BPC to G/L in BW 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
• Loading BPC dimensions from BW InfoObjects, using data manager
• Creating Conversion & Transformations files, to transform Legacy data, and load in BPC Application
• Configuring Dimension properties, that enable Consolidations, based on US eliminations
• Develop complex Input schedules using EVDRE and Excel manipulations
• Developed several Input Schedules and Reports using EVDRE functionality to forecast and Budget Income Statement and Balance Sheet, Cash flow
• Preparation of Technical documents based on the Business blue print.
• Modify the standard business content to meet the user requirement

Environment: SAP R/3 ECC6.0 EHP3 and SAP BI 7.0/BO 3.1 BPC 7.5

SAP BI Lead Consultant

Confidential

Responsibilities:

• Involved in implementing the standard business content for the Public Sector Management and HCM Module
• Analyze the existing Fund Management and Budget control process and activated the related Multi Providers, Info Cubes, DSO, Transformation, DTP Etc.
• Activated Business Content cubes for Financial Accounting (FI-AP, FI-GL and FI-AR) module
• Created Process chains for the Master Data load, Delta init and for the Delta loads
• Perform initial data loads and did the data validation.

SAP BI Lead Consultant

RAS GAS, Qatar

Responsibilities:

• Involved in implementing the reporting solution for the company operational expenses and Capital Expenditures
• Analyzed the existing process quickly, determine gaps and develop to-be processes to meet new requirements.
• Interacted with the Business User and the Functional team to fill the development gaps
• Worked on other report requirements from different stakeholders
• Activated the BW standard Business Content and modified it to fill the gap
• Created the custom BI objects to meet the business requirement

Environment: SAP R/3 ECC6 and SAP BI 7.0

SAP BW Consultant

Confidential, Detroit, MI.

Responsibilities:

• Involved in developing and assisting the business users of General Motors Acceptance Corporation to develop different finance related reports in SAP BW for EC-CS systems and doing the conversion of Hyperion reports to SAP BW reports
• Interact with end users and project members to gather the functional requirements.
• Have been involved in account mapping of Hyperion accounts to corresponding SAP accounts for the conversion, work with planning areas, planning levels planning functions
• Have developed different finance reports like Income Letter, Balance Sheet, Commercial Allowance Receivable reports, and Monthly Financials statement reports for the North American operations of Confidential
• Leveraged the BEX analyzer to create Hyperion formatted reports using different features of BEx like Drill Downs, Drill Across, Expand Hierarchy levels, design items like table display, navigation panel, variable screen, etc…
• Used the excel functions like VLOOKUP, IFERROR, CONCATENATE, to pull the Bex rows into Hyperion formatted sheets
• Environment: SAP EC-CS 6.0; SAP BI 7.0, Hyperion, BEx 7.0, Office 2003, etc

Confidential

SAP BI Manager

Responsibilities:

• Gathering Requirements from customers, Designing solution, prepare functional & technical specifications
• Managing 2 onsite consultants & 5 offshore consultants
• Client has recently upgraded to Bi 7.0 and taking a phased approach to replace BW functionality with BI
• Created test packages for checking the consistency of the objects before and after upgrade.
• Involved in the Pre & Post Upgrade Activities (3.5 to NW2004s)
• Involved in the Pre & Post Upgrade Activities (3.5 to NW2004s)
• Involved in the integration testing in quality of objects and Unit testing.
• Design, develop and test the objects with the new functionalities.
• Ensure successful production go-live & support hand over.
• Performed functional checks in order to test the new features of BI
• Testing of BI system with different systems (ECC 6.0, CRM, Crystal)
• Functional Upgrade to BI 7.0 system, Migration of WAD Templates to BI 7.0 templates
• Migration of BEX Queries to BI 7.0 Queries, New BEX Analyzer Workbooks
• Development work in BI 7.0 includes -- designing, developing, testing & implementation of Transformations, DTP’s
• Identifying the ETL, Design, Query and other areas where performance can be improved.
• Integrated Planning experience with Planning layouts, Aggregation levels, filters, Planning functions and Planning sequences.
• Attending top management meetings along with client, and communicating issues & performance improvements to top management
• Data Validation and Verification checking in BW HR Cubes against ECC 6.0 HR Data and CATS Database.

Confidential

SAP BI Architect

Responsibilities:

• Implemented Data warehouse in BW to have an analytical reporting environment to analyze their product attribute SAP and non-SAP data
• Create Data source from external Databases (TPI and CARS).
• Enable DB connect configuration to integrate data from TPI and CARS system.
• Build new Info providers (ODS) to store product attributes master data.
• Developed Transfer rules, update rules and Start routines to in corporate Business logic for data manipulation.
• Interacted with users for their feed back for creating reports
• Generated and manipulated data into Excel spreadsheets for reports using Micros.

Confidential

SAP BI Lead

Responsibilities:

• Provide the high level specification (information gathering) of the BW implementation project for the FI/CO, SD, MM and PP.
• Initiated requirement gathering meetings with stakeholders. Prepared Functional specs.
• Analyze the Existing UK reports for the SD, MM, PP and FI/CO Module
• Analyze the Confidential SAP BW 3.5 system for Europe, and review the technical contents.
• Identification of gaps between the systems in order to support North America business
• Interview functional business units to determine which analytical parts need to be reported in BW.
• Analyze the existing Business Object reports and purpose recommendation.
• Created several AR reports and modify the standard queries to meet the business requirements.

Confidential, Tyler, TX

BW Architecture

Responsibilities:

• Involved in implementation and analysis of business information warehouse for the FI/CO, HCM, And POS DM IS-Retail Module.
• AS BW architecture My Responsibilities are gathering user requirements and data modeling using ERM star schema concepts Data modeling.
• Customized PCA Cube add info objects for sales week and add week and write a routine to read add weeks from the ODS object.
• Enhance the extract structure for data source 0EC PCA 3 and add Statistical Key Figure Category, and Statistical key figure fields for reporting purpose.
• Responsible for customizing and activation the Business Content Objects for POS DM and Loading the data into ODS Object and Info Cubes from legacy Retail system.
• Post production support for FI/CO module. Monitor the process chain, daily data loads and aggregates performance and usage of the aggregates in the BWP system.
• Involved in the testing after applying the support packs in BW.
• Lead the BW upgrade project from 3.1 to Net weaver 2004.
• Worked on additional software components (e.g. SAP Web AS J2EE, SAP EP 6.0, etc) to upgrade SAP.
• Perform all the tests require before the upgrade and testing after the upgrade.
• Install the Standard business contents for the HCM Module in BW which include PA, OM, BN, and PT Info cubes, ODS Objects Etc.
• Convert the EDB Employee historical HR data into BW. Created and activated custom HR ODS objects and multi provider.
• Time Audit Report: Created an audit report that will be run each Payroll period to validate that the time data has been correctly entered for a person.
• Uploaded Master and Transactional data from flat files as the OLTP source.
• Created Aggregates to improve system query performance.
• Extensively worked on Bex Browser, Bex Analyzer and Info set queries.

Environment: SAP R/3 4.7c, SAP BW, 3.5, 3.1C, EP 6.0 BEX Analyzer/Browser, FI/CO.

Confidential, Edison, NJ

BW Consultant

Responsibilities:

• Involved in implementation and analysis of business information warehouse for the SD module.
• Created 2 ODS’s, 2 Info cubes’, a Multicube and an Info set for querying on the ODS’s.
• Captured sales order details at item line level where data is extracted from the data source 2LIS 11 VAITM.
• Captured billing order details at item level where data is extracted from the data source 2LIS 13 VDITM.
• Managed and monitored data loads with full upload and delta mechanism.
• Created and tested the aggregates in development environment to check the query performance.
• Worked on Remote Cubes to support real time data. Extracting required data from the Data Source of PSA to ODS. Worked with ODS object, ODS query, accessing ODS objects with RRI.
• Query design and development for sales order management.
• Created workbooks and views. Used web application designer to publish queries on web.
• Created Info set queries in 3.0B to do reporting on tabular info providers as join on master data and then published those queries to web.
• Used R/RI interfaces, filtering, conditions, variables, currency conversions, jump queries and navigational attributes for query building. Exception handling through SAP Mail, batch printing and alert monitor.

Environment: SAP R/3 4.6C, SAP BW 3.0B, BEX Analyzer/Browser, SD, Oracle 8i, WINNT.

Confidential, Edison, NJ

BW Consultant

Responsibilities:

• Involved in implementation of Business Information Warehouse for SD, PP and MM modules. Involved in Data Modeling, Extraction and Reporting.
• Managed ODS & Info-Cubes. Worked deleting requests, compressing requests, rollup of requests within Info-Cube.
• Experience With Business Content as well as Creating Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains

Environment: SAP BW 3.0B, SAP R/3 4.6C, BEX Analyzer/Browser, ABAP/4, SD, PP, MM, Oracle 8i, Windows 2000/NT.

Confidential,

BW Developer

Responsibilities:

• As a Team member involved in the pre and post implementation of SAP BW 2.1C for SD, MM modules.
• Scope of the Project is to enhance the current existing reporting system in SD, MM Modules.
• Involved in design and development of Info Cube’s for Customer related Business Information.
• Created Data Sources from Source Systems like Non-R/3 and Flat Files.
• Enhanced the Transfer Structure, Communication Structures and Update Rules.
• Enhanced the standard extractors, by adding fields and User Exits.
• Monitored the scheduled background jobs.
• Managed and Monitored data loads with full update and Delta mechanism.
• Activated Business Content.
• Worked extensively on BEX Analyzer (RRMX). Created queries using BW-Reporting Variables, Navigational attributes and Filters and also on the Multi Cubes.
• Used RRI jump queries using the transaction RSBBS for drilling down to other queries and R/3 transactions.

Environment: SAP R/3 4.6C, SAP BW 2.1C, BEX Analyzer/Browser, SD, MM, Oracle 8i, WINNT.

Confidential, New York NY

Web Developer

Responsibilities:

• Developed an interactive website for the Information Technology department to provide the means to input, track, escalate and monitor the requests coming from throughout the company.
• Scope of the Project was to develop an interactive website that would automate most of the internal processes that were manually handled.
• Involved in the complete life cycle development of the project.
• Designed the architecture of the system.
• Gathered requirements from the management and the users.
• Verification, clarification and sign-off of the functional requirements and specifications.
• Documented the project requirements using UML.
• Created ASP forms.
• Developed interactive web pages in ASP, HTML using Dream weaver.
• Front-end validations using JavaScript for the entire user entered fields.
• Created stored procedures and triggers.
• Provided security features using Session Handling.
• Created Tables, Indexes.
• ASP application implementation using SQL Server and ADO.

Environment: ASP2.0, JavaScript, VBScript, SQL6.5, Rational Rose, IIS 4.0, WIN 98