PROFESSIONAL SUMMARY

• Total 13+ years of SAP exp which includes 3 years in SAP R/3 & ECC (PP, MM, SD, APO, CRM, FI/CO, HR, ISU - gas, power and oil)
• Over 9 years of BW/BI/BOBJ/BPC 7x and BPC10.0 experiencewhich includes fiveyears of planning environment like BPC/BOBJ planning using MS outlook soft and SEM-BPS/Integrated planning tools. Knowledge in HANA1.0 and in ABAP/4, BADI/BAPI/Fox and BPC Script logic functionalities. Extensively involved in BPS/IP/BPC/BOBJ along with char value combinations and Excellus
• Current project is on EPM10 to implement and provide solutions on planning, consolidation, budgeting(public budgeting formulation) and forecasting. Solutions provided to end client using Various BPC Applications on customer/Sales data, profit & Loss, Balance sheet,Capex/Treasury planning, SAP Business Objects Profitability and Cost Management (PCM) environments
• BPS/IP implemented Profit & Loss, Balance sheet, Capex, Manpower Headcount (direct & Indirect) Planning
• Experience in SAP BI7.3Data modeling, designing, development, upgrade, production support and QA along with various (ETL) extraction mechanisms within my SAP CRM,SCM(APO DP & SNP),SAP R/3 OLTP, ISU, Non - SAP systems, Data load processes and performance management tools
• Certified APO with SNP, DP and PP/DS modules

• Currently working as Solution Architecttoimplement and provide solutions on BPC Consolidation, planning, budgeting with public budgeting formulation and forecasting. BPC Applicationsfor the current projectusingsource data from ECC6.0CO-PA, Profit Center, cost Center, SAP Business Objects Profitability and Cost Management (PCM) environmentsusing material/customer data sources, and implemented Balance sheet/Profit & Loss, Capex/Cash Flow and Man Power Head Count planning
• Extensively worked in BI Security along with BPC work status area during implementations to deal global security functionalities like create users, user roles, assign roles to users based on regions and provide access accordingly based on user profile(PFCG & SU01). Security issues resolved based on the traces from SU53
• Added BPC users to domain, Task profiles, and member access profiles to make user as active member and validity periods set. Performed BPC admin tasks during design & Implementation phase
• Has knowledge in implementing HANA1.0 to improve existing planning, forecasting, budgeting and pricing performance by replacing BWA & Oracle DB
• Implemented CRM-R/3, ECC-BI7.X, BW-SEM BOBJ/BPS/BCS/IP,APO, PP,MM, SD, CRM, FI/CO & HR modules with multi country roll out
• Experience in BI7.3/BW with integration, development, upgrade and production support with modules like FI/CO, PP,QM, MM, SD & CRM-R/3-BI7.3/BW-SEM BPS/BCS,APO modules with global projects & organizations
• Business Area - my SAP CRM 4.0, SAP R/3, ECC 5.0/6.0 SEM-BPS,BI7.0 IP(Integrated Planning), Enterprise Portal 6.0, S & D, MM, FI-CO, CO-PA and involved in performance management software to manage the most critical financial and operational planning, budgeting, reporting, and analytic requirements
• Hands on experience on configure/customize BOBJ with Excelcius/BI upgrade/migrations, BI transformations, extractions, data store objects (DSO), data transfer process (DTP), performance optimization/tuning on data loads. Handled work plans to implement large multi continent roll outs having regions USA, EMEA, ASIA
• Expert in enhancing & extracting the data sources on FI-GL, FI-AR and FI-AP, extensively worked on pulling the data from profit & cost center accounting and strong in CO-PAwith Profitability and SAP Business Objects Profitability and Cost Management (PCM)via creating operating concern.
• Expert in designing sound data model in developing Business Objects integration(BO), info cubes, multi cubes( based on the reporting requirements), and DSO With different delta approaches
• Worked on data Extractions with delta to load the data from flat file, application & cross application specific extractors using views & table.
• Experience in optimizing the data load performance/tuning using SAP best practice methods via RSRV checks, optimizing Data base issues via traces, refreshing the cubes on regular intervals, deleting unused cubes/DSO/multi providers, transformations etc.
• Actively involved in define, execute and evaluate regression & integration tests on BI7.0/BW and R/3 using integrated CAT for the reporting, planning & OLAP technology application areas.
• Actively involved in user acceptance testing (UAT), SIT and stress test VTO for performance optimizations
• Strong consulting experience in corporate implementation experience in the SAP space, with depth experience implementing and configuring SAP BI7.x/BW & SEM-BPS
• Proven knowledge in defining systems strategy, developing systems requirements, and implementing practical business solutions under multiple deadlines
• Responsible for developing, maintaining, and growing client relationships, leading consultant and client project teams from project planning through execution
• Expert to implement & follow business rules governing the supplied data and its implications to consolidate the data with other businesses when create engineered solutions to suit business requirements
• Worked on complex Process & event chains and set up done to trigger jobs using UC4 & Control-M.
• Worked on info presentation layer like Bex-Analyzer, Bex-Browser, and Creation of workbooks
• Hands on experience on SAP BI7.x/BW objects like: info-presentation tools, Design & Analysis of Bex, Cube Maintenance, extraction & loading of data using different types of extractors, monitoring of data using UC4, Control-M and data Administration (i.e. types of extractors, Char/KF Info Objects, Data sources/ Info Sources, update rules, transfer rules, Info Cubes, Info Packages, process chains, queries, RKF, CKF, structures, etc,)

• BS in Engineering and MBA(FIN)

ERP : SAP R/3 Version ECC 5.0/6.0 4.7E,4.6C/4.0B, SAPGUI 7.X Data dictionary, Reports, Scripts, BDC, RFC, BAPI, ALE and IDOCs
SAP-BI/BPC : SAP BI(7.3)/BPC10 /7.5/MS versions, HANA1.0, IP, BW-SEM BPS/BCS,
Info cubes, Enterprise, Portal, multi providers, ODS, Info objects, Info sources, Data
Extraction, Transformation and Loading,Pocess Chains, CRM, APO,HR, PP
& MM, SD, CO-PA, LO-Cockpit, Queries, Workbooks, Bex-Analyzer, Bex-
Browser, Web reporting

Packages : Microsoft office suites like MS-word, MS-Excel, MS-Outlook
Languages : C, C++, Java, BSP and SQL
Operating : Unix, Windows NT, Windows 95/98, 2000
Systems

Independent Lead /Architect -SAP BI/BPC Oct'11-current
Client: Confidential, Racine WI

Roles and Responsibilities:

• Prepared design document for BPC V10to implementand provide solutions on BPC Consolidation, planning, budgeting with public budgeting formulation, forecastingusing of SCJ sales/customer data from its global operations, FP & A, PNL, Balance sheet, cash Flow Functional Budget, discount & Promotions based considering Intercompany Non-Competitive & Resale Minus Transactions, trading partner, budget, Monthly forecasting(SOP), Roll-Forward Logic, domestic and export net/cost of sales & distribution expenses
• Project scope was to change SAP BPS planning applications to SAP BPC V10 environment based on the client business for CCR, FP & A, Budget planning , SOP and Treasury subject areas
• BPC Consolidations done via reporting requirements like entity information, translate data to reporting currency using calculations, control settings, journal entries and validation, reconcile/eliminate intercompany matching
• Has strong back ground in SEM BPS on planning, Budget, consolidation and forecasting using CO-PA, Profit Center, cost Center, material/customer planning, Balance sheet planning, PNL, FP & A, Capex/Cash Flow(Treasury) and Man Power Head Count planning
• Prior experience in implementing SAP BPS Web Applications for Short Term Estimate, Long Term Plan, Customer/Site Level Business Plan, Petro Pass CCR Account Level Plan, Scorecarding, and RF Overhead Expenses (convert existing BPS tool); Integrate New BPS Applications with Supply Planning Tool based on APO DP
• Data model includes one Environment with multiple Applications based on continent/ regions (24 countries) Most data on company acquisition in actuals from different source systems.
• Implemented Data reconciliation and validation of data load and refresh of data loads during close periods
• Created planning dimensions on Account, company, Scenario, Time, Currency, Cost Center, Data Source, Product, Customer, R_account, R_entity, R_Currency and developed dimensional members & properties
• In BI defined reconciliation process, rollup via Hierarchies on customer/product/sales, customized BI data model for BPC Actuals. Data loads done by defining process chains and included BI processes like info providers, packages, data sources to extract data from ECC6.0 and other source systems
• Extensively worked in BI Security area during implementations to deal global security functionalities like create users, user roles, assign roles to users based on regions and provide access accordingly based on user profile(PFCG & SU01). Security issues resolved based on the traces from SU53
• Added BPC users to domain, Task profiles, and member access profiles to make user as active member and validity periods set. Performed BPC admin tasks during design & Implementation phase
• Data loads stream lined using process chain to extract data from source systems to SAP BI cubes/ODS, to consolidate, eliminations, Final data will be loaded into BPC cube with the help of Data Manager package
• Developed Input schedules on Gross Profit, cost of sales, rates, sales discounts, CCR/Memo Accounts, Advertising & Promotions, PNL, Balance sheet and sales forecast. Tested the Input Schedules by Input the values and noted the times how much time on EvDRE, execution/time to send and time to expand etc
• Designed and developed excel reports using EvDRE tool set capabilities and reporting templates.
• Reports developed for Rate Input/Lump Sum Amounts. Ran the packages for the Input schedules by selecting Input selections for the required input schedules by region/company code/product/customer
• Data loaded to BPC info provider, validations done, unit tested and transported to Quality then to production
• Integration testing, unit testing done and Volume/Stress test to optimize performance using HP Quality Center tools like HP Load Runner, BPC Tool Kit, VuGen, Fiddler and Load Generator/Controller scenarios. Load Generators are remote Load generator kept at multi continent Locations like Europe, Asia, and Canada.
• Developed Load Runner scripts when Input schedule/Reports executions and modified the Load runner scripts with user credentials, BPC control panel setting and BPC server details as parameters. Back end CPU, DB, SQL traces done by respective teams to finalize the volume test results. Response time observed about 90 seconds to execute and send data from Input schedule to back end DB using BPC dynamic selections
• End user Training, Technical documentation and Post implementation support completed
• Currently gathered requirements and preparing Functional/Technical specification documents for the second phase of implementation on SAP Business Objects Profitability and Cost Management (PCM),Revenue/CAPEX planning

System Landscape: ECC 6.0, BI 7.3 and BPC10

Lead/Architect-SAP BI/BPC Apr'11-Oct'11
Client: Confidential, NJ

Roles and Responsibilities:

• Requirements gatheredwith specification document to implement sales (trade promotions)Profit & Loss planning using client Market, distribution and Operator business. Designed data model for BPC considering FPM,Business objects planning and BPC consolidation
• Data model designed considering the client business future cast sales volume, sales trade promotions(TPM), coupons and other discounts based on, marketing, selling and supplementary data allocation to brand model in BPC. Captured Profitability and cost components using profit center, cost center, CO-PA tools and SAP Business Objects Profitability and Cost Management (PCM) by linking BOBJ to PCM and LSDAL explorer and RFC connections
• Sales cost linked to profit cost source data derived from R/3 customer, material, Profit center, cost center and CO-PA using business rules
• BPC Consolidation and reporting includes gather all Entity information, translate data to reporting currency using calculations, applied business rules, journal entries and validation, reconcile/eliminate intercompany matching
• Created planning dimensions for category, customer, Data source, Entity, Account, Reporting Currency and Time Loaded data using BPC mapping rules and verified data
• Created properties for Currency translation/verifying exchange rates, intercompany eliminations, reclassification and restatement
• In BI defined reconciliation process, rollup customer to planning customers, customized BI data model for BPC Actual and defined process chains to include BI process for developed info providers PCA & CO-PA extraction to pull the data from ECC6.0
• Extensively worked in BI Security area during implementations to deal global security functionalities like create users, user roles, assign roles to users based on regions and provide access accordingly based on user profile(PFCG & SU01). Security issues resolved based on the traces from SU53
• Added BPC users to domain, Task profiles, and member access profiles to make user as active member and validity periods set. Performed BPC admin tasks during design & Implementation phase
• In BI designed master data for planning customers via hierarchy and created variant to pull data from BI to BPC
• Via fox coding and developed function module to roll up the customer to top nodes
• In BI developed required Transactional data info providers (DSO, cubes) for BPC to pull the data from ECC6.0
• In BPC created Application Setusing BPC predefined ApShell and created Application
• In BPC created data manager package with the help of Application set,ApShellvia drivers, dimension library, source cube and source structures from SAP delivered applications (planning account, Entity, planning activity, category, data source, reporting currency and time
• In BPC Utilized planning applications, planning types and application functionalities for consolidations(rate type etc..) using BPC business rules like modifying specific dimension members, and using script logic, maintaining members and properties
• Assigned planning applications to dimensions and optimized applications as needed and Extensively used input schedules, Applications validations and Solves for calculations
• Data loaded to BPC info provider, validations done, unit tested and transported to Quality then to production
• Generated BPC reports on costs. Goods sold, customer summery via Level 1, Level2 etc.. With the help of planning reporting input schedules(via EvDRE workbook options using BPC functions like EvGET and EvSND), report templates, report variances, trend reporting, conditional formatting. Extensively used expansions, drill downs, filtering, work book options and indentations of reports
• Implemented security on Application administration via profiles and work status feature in BPC

System Landscape: ECC 6.0, BI 7.1 and BPC7.5

SAP BI/BPCLead/ArchitectAug'09-Mar'11
Client: Confidential, Beaverton OR

Roles and Responsibilities:

• Responsible to Design, development of FPM project using BPC standard functionalities for the NIKE apparel business which uses SAP BI7xBPC MS Versiontechnology for the data from different departments
• Business scenario of this client is GTM/TPM(go to market using trade promotions via trade campaign, marketing elements and market segments data sourced from CRM sales and some data from sales & distribution of ECC
• Integrate the data with integration for planning by integrating with other SAP modules like R/3-BI7.0/BPC, APO, PP,MM, SD, FI/CO Cost center/profit center and CO-PA with multi currency rate application environment
• BPC Consolidation and reporting includes gather all Entity information, translate data to reporting currency using calculations, applied business rules, journal entries and validation, reconcile/eliminate intercompany matching
• Upgrade, migrate the relevant BI transformations, extractions, data store objects, data transfer process, performance optimization, tuning on data loads. Extensively used BADI/IDOC and fox functionalities
• Enhance and extract the data sources on FI-GL/FI-AR/ FI-AP, pull the data from profit & cost center accounting
• Responsible in designing sound data model using Business Objects integration, info cubes, multi cubes based on the BPC reporting requirements and data store objects with different delta approaches
• Involved in data Extractions with delta to load the data from flat file, application & cross application specific extractors using views & table.
• Optimized the data load performance tuning using SAP BPC-Excel (modules include budgeting, forecasting, statutory consolidation, EvDRE reporting ) and other best practice methods via optimizing Data base issues via traces, refreshing the cubes on regular intervals, deleting unused cubes, DSO, multi providers, transformations
• Responsible to design & develop complex Process & event chains with set up trigger daily/weekly/monthly jobs to load data to BPC info providers at global level and to run applications like rate/currency exchanges

System Landscape: BI 7.1 and BPCMS Version

Confidential, NJ USA Jan'09-Aug'09
SAP BI Lead Consultant/Architect

Confidential, is world's premier consumer health & seventh-largest pharmaceutical and fourth-largest biologics company. Johnson is most diverse medical devices and Diagnostics Company having worldwide network and business operations worth of $64 billion.

Roles and Responsibilities:

• Requirements gathered to develop BI reports using dump of legacy sample report from Johnson's business process.
• Subject areas involved in Johnson business process are Finance, procurement, inventory and planning manufacturing.
• Reports disposition done and finalized the BI reports to be developed by subject areas.
• Given recommendations to get few reports directly from ECC 6.0 and rest to be developed in BI using SAP Business content data sources/SAP tables
• Enhanced the business content data sources to get all the fields based on BI report requirements using RSA5 & RSA6 transaction codes
• Extracted to data to BI via transformations and loaded data into data targets
• Developed the reports using business objects integration (BO) and validated the data.
• Given authorizations to uses based on their roles & regions.
• End support is in progress

System Landscapet: ECC 6.0, BI 7.0 PP, MM, FI

Confidential, USA Apr'08-Dec'08
Orlando, FL
Project Lead - BI

Confidential, is an equipment rental and leasing company based at Orlando FL. It is a global project having 44 locations across the globe. A CHEP information system is the part of it.

Roles and Responsibilities:

• Maintain the BI data loads, monitoring alerts and analyze/fixing the load failures with in SLA time
• project was to production support on-going issues, analyze the business processes in-order to offer suitable solutions to the problems
• Grab the production support failure tasks from Rev-track (3rd party tool) and assign the tasks to self & to the team, resolve the support issues with in the SLA time frames. Attend the change control meetings if have some major changes needed with the prior approvals.
• Coordinate and pass on the required issue information to the respective team to fix the issues
• Involved in during production issues like configuration of various Account Groups as per customer classification, partner functions, Maintaining Partner Determination Procedures in various objects such as Customer Masters, Sales Document Header & Item, delivery, billing docs, sales documents, billing, shipping, credit management, consignments, pricing, third party Order processing, Delivery and Billing, Pricing Procedure, Condition Type, Access Sequence and Condition tables
• Data load monitoring from the chains related to master data, stock & flows, sales invoices, operations & logistics, SRM, Financial management & controlling, Inventory audit and exchange management.
• Involved in design and development of new process chains as per the need from client
• Involved in enhancements via Remedy tool and enhanced structures moved to BWP using Rev-Track tool.
• Involved in design and development of small and medium projects with the client environment

System Landscape: SAP R/3(ECC 5.0), BI7.0, MM, FI, SD and CRM

Confidential, May'07-Apr'08
San Francisco, CA
Lead Consultant-BW/SEM-BPS

Confidential, plc is a neuroscience-based biotechnology company that is focused on discovering, developing, manufacturing and marketing advanced therapies in neurology, autoimmune diseases, and severe pain. Working in its SAP group to interact with business users to design, develop and implement the BW Objects in data management for the data from R/3 to BW & its planning systems.

Roles and Responsibilities:

• Involved in preparing the templates for the Functional specification documents, Technical specification documents and the Architecture documents.
• Designed & developed cubes to load budget data (ZSBP_T02) into asset cube (ZFIA_O11) and developed required report like plan Vs actual and other reports. Budget data is from BPS capex cube with value type, asset category and actual data from R/3 to BW data sources with asset class. Utilized ABAP/4 function modules, BADI and fox coding to populate the future year/prior year values
• And extracted data from Non R/3 systems like EBP, Oracle and Legacy systems
• Developed customized cubes on P & L (ZSFI_C02), IFP(ZSBP_C04) and planning cube for budgets and made multi-provider for management reporting purpose
• Designed and developed HR management & compensation and Head count cubes and developed reports for compensation & head count reports
• Set up done on compression & aggregates for the FI, HR cubes
• Created planning folders for web layouts and data managing using status & tracking system.
• Daily data management activities like taking care of data loads daily, weekly and monthly using process chains.
• Customized SAP BW components including: Presentation, Analysis, Data Storage and Management, Transformation and Loading, Extraction, Data Administration (i.e. Extractors, Info Objects, Info Sources, update rules, transfer rules, Info Cubes, Info Packages, process Chains, queries, AKF, CKF, structures, etc,)
• Involved in Data modeling, AWB, Info Objects, hierarchies, Info Sources, Data sources, Info cubes, Info providers, Multi providers and ODS

System Landscape: SAP R/3(ECC 5.0), BI7.0 BPS & IP, BCS, EDI, SD & MM

Confidential, Plano, TX Jun'06 - Apr'07
Cad bury Global Project
Lead Consultant-BI7.0/BW/BPS/BCS

Confidential, is a CPG group industry and is global project with all modules of SAP and involved in upgrade, implement, and enhance the BW objects for EMEA, APAC and US locations across the globe operations to give output on its Beverage & confectionery products.

Roles and Responsibilities:

• Ensuring all development processes and methodologies are followed to ensure quality deliverables that meet the customer\'s needs
• Expert in BW design, using CRM extractors where data is coming from CRM and worked on Planning area, planning layout and planning package development using different planning functions, Planned data loaded by using hierarchies
• Development of BW systems as it relates to change trade promotional data in CRM
• Working as a Business Re- Engineering Lead for a BW-CRM integration project
• Involved in preparing the Business Requirement Documents for the BW for all the Regions.
• Involved in preparing the BW capabilities document for this BW - CRM integration project and providing the SAP BW capabilities to the Business team so as to get clearer requirements to meet the global requirements.
• Worked with the IT team in defining the BW Architecture for this BW implementation. This includes modeling the Data Flow, Identifying the Standard Business Content Data Sources, Enhancements to the Standard Data Sources and the Generic Data sources to get data into the BW system for Interactions, Service Tickets, Service Orders, EMail Analytics, Quick close Etc.
• Involved in defining the SAP Standard practices.
• Worked with the IT team in reviewing the Reference Design Documents.
• Involved in defining the need for Reports and preparing a Report specification documents.
• Involved in identifying the various notes that are required for working with the Standard Business content Data Sources in the CRM system.
• Involved in preparing the Query Design Documentation and the End User Training Manual.
• Developing BW solutions related to change requests with support from functional teams by developing queries and/or infrastructure to support queries
• Providing feedback for training strategy to provide better support to the BI7.0 user community
• Expert in Bw design, development, implementation and support of technical specifications related to ODS, cube, multi-provider, and query design development within the established time frames as it relates to change requests. Utilized Fox coding extensively in planning packages to modify, revaluation, copy, delete, intercompany eliminations
• Worked with BPS planning work bench, created planning folders Customizations & execute planning folders by using UPSPL & UPSPM
• Worked with cross application interfaces in BPS and configured Web interface set up for the created planning folders, generated and tested for the output.
• Expertise with SAP BW components including: Presentation, Analysis, Data Storage and Management, Transformation and Loading, Extraction, Data Administration (i.e. Extractors, Info Objects, Info Sources, update rules, transfer rules, Info Cubes, Info Packages, process chains, queries, AKF, CKF, structures, etc,)
• Expertise in Data modeling, AWB, Info Objects, hierarchies, Info Sources, Data sources, Info cubes, Info providers, Multi providers and ODS for HR
• Data Extractions from flat file, Generic data source using application specific generic extractions on SD(BBB, bill, book, blog), MM(purchase, vendor & inventory) & PP(production order delivery ,order quantities capacity utilization) using application component types, and CO- PA using Operating Concern.
• Experience in working with the SD & MM customer generated cross-application specific generic data sources from the Table/Views
• BW Reporting - Business explorer, Web reporting, Query jumps, Exception reporting, Bex-Analyzer
• Actively involved in define, execute and evaluate regression & integration tests on BW and R/3 using integrated CAT for the reporting, planning & OLAP technology application areas.
• Actively involved in user acceptance testing (UAT)

System Landscape: SAP R/3, BW3.5/BI7.0, SEM-BPS, APO, CRM, SD, MM

Confidential, Austin TX Jul\'05 - Jun\'06
CRM-BW/SEM Implementation
Lead Consultant - BI/BW/SEM-BPS

Confidential, is global project with all modules of SAP and its output is to see its MSM operations via its Marketing plans across the globe operations.

Roles & Responsibilities

• Understand the client's existing business processes and data model(Data Modeling) in the SAP BW system
• Identifying business requirements and processes and implementing solutions to meet the client's needs
• Developed BW design and worked on Planning area, planning layout and planning package using different planning functions, Planned data loaded by using hierarchies
• Expert as BW Consultant for BW enable organizations to make best use of their enterprise data with the help of data mining, management information, performance management, financial reporting, MIS and performance management market
• Analysis done and gathered information to design, develop, prototype, implement CRM-SAP BW-SEM BPS system to meet the current and future customer business requirements work plan with user areas to analyze and optimize business processes, find and solve the problems with existing software, data & Procedures. Written specifications for business processes, subsystems, programs, reports and interfaces
• According to customer's needs Prepared Business blue print according to the gathered information based on Marketing plans in CRM-SEM-BPS Internal/External Business Planning Process to build planning layouts for current previous and future years
• Environment is to pull the marketing plan data from CRM transactional cube to BPS system. This data belongs to the Their marketing spend management (MSM), trade promotions(TPM) and to see the results via planning layouts (AMD Advantage, MDF, CMDF and XMF plans)
• Responsible for collaborate with BI Application Engineers and our business partners to develop high-level designs, including logical models and functional specifications that leverage SAP BPS Business Warehouse functionality for business solutions
• Extensively used Fox coding in planning packages on Balance sheet, budgeting and assets to modify, revaluation, copy, delete, intercompany eliminations
• Work with user areas to analyze and optimize business processes, find and solve problems with existing software, data and procedures. Write specifications for business processes, subsystems, programs, reports and interfaces according to customer's needs
• Responsible for collaborate with BI Application Engineers and our business partners to develop high-level designs, including logical models and functional specifications that leverage SAP Business Warehouse functionality for business solutions
• Worked with the team to ensure that the software that is developed meets the business requirements.
• Utilizing SAP BW Business Explorer and/or SAP BW Web Application Designer or other BI tools to develop reports for deployment to the business
• Worked with business and IT teams to transition these applications into our production environment by providing support and training through the release cycle
• Involved in developing applications in an integrated BI solution leveraging the Corporate Information Factory Reference architecture
• Participate in the deployment of our SAP BW infrastructure and re-engineering of the infrastructure
• Define, acquire, and load source data from multiple businesses and systems
• Understand business rules governing the supplied data and its implications as the data is consolidated with other businesses. Create engineered solutions to satisfy business requirements
• Engage with functional managers to identify needs, perform gap-analysis and design the system with detailed functional designs and technical specifications
• Responsibility for all configuration activities including build activities; system testing; and integration with other work streams and modules
• Experience with high-volume SAP BW environments and performance tuning analysis including indexes, aggregates, statistics, compression, code review, query design review, etc
• Work with Business Reporting manager to identify any aggregation or transformation requirements
• Work with Technology team to ensure effective BW architecture integration with core infrastructure
• Analyze and correct production problems as and when occur in the SAP BW systems

System Landscape:SAP R/3, BW 3.0/3.5, SEM-BPS, APO (DP), CRM, SD, MM, HR, FI/CO

Confidential, SingaporeJun\'04 - Jul\'05
Senior Consultant - R/3, BW SEM-BPS
It is an implementation of SEM-BPS on their transporting group of 17 companies and planning Layouts set for Balance sheet, profit & Loss, Manpower planning (direct and indirect), CAPEX and Cash Flow
Roles & Responsibilities

• Understanding SEM-BPS business process on Internal/External Business Process Planning for the current, previous and future years. Business process include power, oil and gas
• Established interface between BW and connectivity to R/3
• Used required Variable and Chars & KF, Hierarchies with the help of some planning functions & layouts and loaded data with the help of planning layouts
• Fox coding extensively used in planning packages to modify, revaluation, copy, delete, inter company eliminations
• Conducted Integration testing and UAT for Balance sheet, P & L, Man power costs
• Created planning folders for Balance sheet, P & L, Man power count costs
• Created data source ZSEMPOSIT and data loaded by using this by assigning related hierarchies
• Set web interfaces for the required folders by using UG00 and set status & tracking system
• Developed BeX Reports for Balance sheet, Profit & Loss, Manpower costs based on data loaded from Planning layouts.

System Landscape: SAP R/3, ISU & BW 3.5, SEM-BPS, FI/CO, BAPI, IDOC, Scripts

Confidential, US off-shore May\'03 - Jun\'04
CP SAP R/3-BW Enhancement Project
BW Techno-Functional Consultant
It is a global support project to get the output for the financial data which is extracted from R/3 and other non ERP third party tools
Roles & Responsibilities

• Data Extractions from flat file, Generic data source by using application specific generic extractions for LIS (SD, MM & PP by using application component types), and CO- PA using Operating Concern
• Developed generic data sources for Opportunities, Backlogs and Invoice details from the custom tables in R/3 Used Views, Info sets and Function modules to create these data sources
• Developed info sources, transfer rules and transfer routines.
• Developed ODS objects for Opportunities, Backlogs and Invoice details
• Developed update rules and the start Routines
• Developed Sales Hierarchies for the Sales Team
• Customized application Specific generic extractions for LIS (SD, MM & PP by using application component types), and CO- PA By using Operating Concern and submitted the reports

System Landscape: SAP R/3 Ver. 4.6B and BW 3.x, SD,MM,PP and FI/CO

Confidential, KualaLumpur Feb\'02 - Jan\'03
GM BW Implementation
BW Techno-Functional Consultant

Confidential, is the implementation partner for GM to implement the BW for their logistic modules and Co-PA to see profitability.

Roles & Responsibilities

• Modified Standard & created custom info sources, data sources, ODS & info cubes. Communication structures, transfer structures, transfer rules & update rules for the info cubes & the ODS
• Data Extractions from flat file, Generic data source by using application specific generic extractions for LIS (SD, MM & PP using application component types), and CO- PA by Operating Concern
• Developed views in R/3, Info sets and Function modules to create & use these data sources
• ETL- Data loads from R/3, flat files using PSA. The data loads for master data as well as transaction data (LIS)
• Design, Development of Standard SAP Delivered Delivery Info Cube and Billing Info Cube.
• Created a Customer analysis report gives detail purchase using Bex Analyzer.
• Sales lead Bex Analyzer report: - This report is used to monitor sales prospects for created daily sales analysis.
• Day billed Bex Analyzer report: - The Days billed report will monitor revenue for daily bill contracts.
• Performance report Bex Analyzer report - Sales order.

System Landscape: BW2.x, SAP R/3 4.0, FI, SD, MM

Confidential, Singapore un\'01 - Jan\'02 ST HR-BW implementation
BW HR-Techno Functional Consultant

• ST is an HR implementation having sub modules of PA, PD, PT, Singapore Payroll and the same extracted to BW to present the data via Bex

Roles & Responsibilities

• Responsible for writing classical and interactive reports
• Data source by Data Extractions from flat using application
• Data Extractions from flat file, Generic data source by using application specific generic extractions for LIS (SD, MM & PP by using application component types), CO- PA using Operating Concern.
• Extensive experience in creating application specific business content data sources from the HR info cubes 0HR_PA_0, 0HR_PA_PD_1, 0HR_PY_1, 0HR_PT_1 to BW
• Experience in working with the HR customer generated cross-application specific generic data sources from the Table/Views
• Created generic data sources for Opportunities, Backlogs and Invoice details
• From the custom tables in R/3 Used Views, Info sets and Function modules to create these data sources

System Landscape: SAP R/3 BW 2.x, PA,PD & PT,IDOC, BAPI,SCIPTS

SAP R/3 Experience Feb'98 - Jun'01

• All implementations are multi module projects under OAK brooke technologies

SAP Logistic Modules Experience with 4 different clients as:

• Confidential

Roles & Responsibilities

• Involved in Customization and configuration in SAP PP implementation. Actively involved in design, development of Material master, BOM, work center routing, MRP, Production order creating, PO confirmation, Goods issue/Goods posting, settle the costs and product costing.
• Data conversion and load from legacy systems for Material master, BOM and routing
• Production Order created, confirmed and costing done.
• Goods posting, goods received checked through MM after and before order Confirmation
• Worked in PP-PI on kanban, discreet manufacturing via recipes and resources
• Integration of PP with modules like MM and FI/CO.
• Scheduling MRP at planned order and converting to production Order with the help of lead-time scheduling and run MRP on lot for lot sizing
• Processed planned orders and cross checked availability check in MRP
• Capacity requirements calculated and evaluated.
• Was also involved in after implementation user support & PPPI related Reports
• development on Payroll configurations (driver and schema) with country specific and maintaining Payroll control record with status and period
• Configuration and time evaluation with respect to employee time clock in clock out, leave, illness, attendance /absence, work schedule, shift planning etc
• Configuration and maintaining compensation module with budgeting and pricing