SUMMARY:

• Over 16 years of SAP Project experience that includes 6 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) 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 on Cloud, BPC & BW at Fortune 100 clients.
• Strong skill set in SAP EPM 10.0NW, 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.)
• 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 s 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 Planning& Consolidations Lead

Confidential

Responsibilities:

• Involved in implementing the Financial reporting solution using SAP HANA, SAP BOBJ, SAP EPM, BPC
• Provided road-map for the successful implementation of multi-phased finance transformation reporting project
• Documented the BI Strategy & Data Architecture that comprises of high-level for several SAP instances
• Worked with the basis team and coordinate the upgrade effort to SAP HANA
• Conducting workshop to gather the business requirements
• Involved in the implementation of SAP BPC 10.1 for cost allocation project
• Managed the onshore and offshore team to do the development for ICA project.
• Set up Planning Functions, Planning Sequences, and Characteristic relationships.
• Set up BEx Input ready reports.
• Improve the existing data flow and storage in SAP BI to load data into BPC for Consolidation
• Support the existing Consolidation Models and perform the enhancement for US GAAP
• Created the ownership models and work with developers for custom BADI to perform elimination and incremental consolidation
• Extensively worked on EPM report creation
• Involved in the Migration of existing BW system to SAP HANA
• 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
• Build interfaces from SAP and Non-SAP system to support BPC 10.1

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

SAP BPC/BI Architect

Confidential, Atlanta

Responsibilities:

• Conducted workshops to train the users on BPC 10.1
• Work with basis to roll out 10.1 Embedded using Analysis for office
• Involved in migration of SAP BPC 7.5 to EPM 10.1 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
• Managed the team of onsite resources to do the upgrade for SAP BPC
• Work with the offshore team to fix the performance and reporting issues after upgrade
• Created new Bex input queries using BPC 10.1 functionality
• Work with Basis team to optimize the performance issues for BPC 10.1
• Created BW Info Providers, 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

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

SAP BI, EPM, HANA Consultant

Confidential

Responsibilities:

• Participated in scope validation workshops with key client stakeholders to validate understanding of project scope, key process areas, pain points, recommendations and overall project requirements outlined in the RFP document.
• Established and Conduct meeting to capture business requirements and identify gaps.
• Documented end-to-end future state business process flows showing planned interaction between Legacy EPM’s and SAP BI.
• Conduct meeting to capture business requirements and identify gaps.
• Implemented Simple Finance to replace SAP FICO and Legacy Financials system to utilize SAP EPM 10.1 on Cloud to support global reporting requirements.
• Defined KPI’s and designed POC for management reporting dashboards redesign and deployment in Simple Finance and S4 HANA contents.
• Worked with the Finance team to prepare Functional specification from as it to be process in SAP Simple Finance.
• Worked with different teams to establish the data integration design for SAP HANA and pull of data from SAP Simple finance for reporting layers
• Involved in the migration of old GL accounts to New GL accounts transformation on HANA
• This involved the new code block elements, change in Chart of Accounts & reporting using HANA live content and as well SFIN(Simple Finance) content from HANA.
• Used simple finance contents to support embedded BPC 10.1 Models
• Created Models, Dimensions and several input schedule and reports to support EPM
• Validation of Balance sheet and income statements reports for GAAP and STAT ledger
• Creation of HANA View, BW, and EPM Models to support development effort.
• Customized view to report on multiple currencies.
• Used and implemented best practice design principles in designing HANA views & consuming those views thru BW layer
• Created the reports and publish the workbooks on Analysis office to support self-service reporting.

Environment: SAP R/3 ECC6.0 and SAP BI 7.4, SAP Simple Finance,S4 HANA SP 9- BPC 10.1 on Cloud

SAP BI/HANA/BPC Managing Consultant

Confidential

Responsibilities:

• Planned and implemented roadmap to transform EDW to a SAP Business warehouse using SAP HANA, SAP BW,BOBJ,BPC
• Developed workshop sessions to architect a new BI platform utilizing Enterprise HANA (in-memory database) SAP BW,BOBJ and EPM 10.0
• 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, road map & standards for implementing BPC platform.
• 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
• Tested the data validation with SAP BPC and SAP BI and created test script for testing and purpose
• Identified the current state of the process, as well as improvements that need to be made
• Established process performance objectives
• Created KPIs to measure the success of the process
• 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
• Managed and develop Project Plan, assign task to the onsite and offshore team members.
• 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

Confidential

Responsibilities:

• Responsible for preparing the “How-To” Documents for various activities the end-user performs in BPC and conducting 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 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, NY

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 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 Feb 2011- October

Confidential, NJ

Responsibilities:

• Involved in implementing the SAP BPC 7.5/ BI 7.1 for financial forecasting, Planning and Budgeting.
• Conducted workshops, created Functional specification and technical Specification for the development objects
• Created Business Requirements Document (BRD) and Business Design Document (BDD) for Financial Planning, Budgeting and Forecasting
• 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, incorporating the performance
• Developed several Input Schedules and Reports using EVDRE functionality
• Created the drill through using BPC Admin, to Business Explorer Analyzer
• Executed the optimization tool for lite and full optimization
• Conducted workshops to execute Test Scripts with business Users
• Created custom hierarchies with complex logic in BI and used open hub to load into BPC through Data Manager Package
• Design & Developed custom Master Data, DSO, Info cubes to support BPC applications.
• Develop interfaces to extract APO volume data from EBW system to Planning BW system and loaded into SAP BPC Applications
• Develop custom data source to load List price data using Flat files
• Develop logic using code and formulas to convert the BW data into BPC format.
• Executed the DMP in BPC to ensure the data loading process is working accurately.
• Build the data model in PBW to load P&L Actual for FS items, APO volume, Cost component weighted average data in PBW and loaded into Financial Forecasting Application and Cost of Sales Application in BPC
• Implemented data loading solution to trigger BI process chain from BPC to load data into staging Data Models to Outbound Data models and output file on ECC to load Product Markup in ECC
• Design process chains to trigger data load after the Planning data is finalized in BPC and put this data back into ECC.
• Build the staging layers for BPC data inbound and outbound

Environment: SAP R/3 ECC6.0 and SAP BI 7.1/BO, APO, BPC 7.5

SAP BI/BPC Lead

Confidential, 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

Confidential

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 Confidential 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 BILead

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

Confidential, New York NY

Web Developer

Responsibilities:

• Involved in the complete life cycle development of the project.
• Created ASP forms.
• Developed interactive web pages using ASP, HTML.
• Uploaded scanned images to the database.
• Front-end validations using JavaScript for the entire user entered fields.
• Used ADO for database connection.

Environment: ASP2.0, JavaScript, VBScript, Oracle7.0, Win95