Summary:

• 15 years of IT experience with 10 years in SAP BI 7.3, BOBJ 4.0., Net weaver 7.3, SEM, CRM, C A, Solution Manager 3.2, and SAP ABAP/4 in MM, SD, FICO modules, 2 years J2EE architect with complete project life cycle management and SDLC.
• Worked as Team-Lead positions completed 5 SAP BW 7.0, 3.5, 3.1/2.1C implementation projects, 3 BW upgrade projects and BW production support projects for FI/CO, COPA, AR, AP, SD, COPC, HR, PM, QM and MM as a BW Technical Consultant with extensive experience in SAP BW/BI 7.1, 7.0 3.5 3.1/2.1C OLTP Extraction and Reporting on ECC 6.0, 5.0 R/3 4.7, 4.6 4.0.
• Adept in mapping SAP Business scenarios, Best practices and case studies, FI, CO SPL, financial Management reporting, APO DP, SNP , SEM BPS, CPM, BCS , CRM, Industry solutions and mySAP Components portals, System integration central control with SAP Solution Manager.
• Knowledge in implementing EPM, Outlook soft Everest 4.1 BPC , SAP BPC 7.0, data load with Custom Extractors and Flat files Data stage, coded User Exit for BEx Variables and BADI's, Customizing HR content providers. Worked in critical situation like takeover acquisition affected the functional technical aspects of ERP. Expertise in BI 7.0 NW 2004s concepts like data transformation techniques, APD and visual composure. Expertise in BI Integrated planning, SEM-BPS SEM-BCS for planning layouts reporting needs, involved in the creation and maintenance of BW SEM Hierarchies.
• Adept in using Sap Netweaver Components: BEX Analyzer, Query Designer, Web Application Designer Enterprise Portal, experience in developing Formatted Reports using Business Objects, Celsius.
• Extensively used ABAP Start routines, BADI's, user exits, Conversion Routines in Transfer Rules and Update Rules for client specific business logic.
• Expertise in Front-End Business Warehouse Components, Analytics like Financial Analytics, Supply chain analytics, HR Analytics, CRM Analytics, Workbooks and Web Dashboard Reports, hands on exp. with Business Objects.
• Expertise in design and development of BI IP Integrated Planning ,Aggregation levels, FOX formula, planning sequences, BPS, BPC, BCS, backend BW components like Info Cubes, ODS, Info Objects, Info Sources, OLTP Extraction for optimized performance.
• Designed Internet Mobile applications, experienced in using Design Patterns and frameworks J2EE, J2ME, .Net , web services, OOAD, CRC, UML using Rational Rose , WSAD, UDDI, SOAP and EAI tools.
• Experience in working Multicultural work environment, handling multiple projects and leading offshore teams.
• Knowledge exposure in Facility management, Quality standards ISO-9000 , Environmental Standards ISO-14000 , cGMP, USFDA, Sarbanes Oxley, GAAP and IFRS etc.
• Worked as BI Architect, team lead onsite coordinator and lead offshore teams from BW, ABAP, Security and Basis consultants. Liaison with SAP- OSS, Basis teams helping them to improve performance of system by processing early watch sessions, applying SEM BW specific memory parameters.
• Defined SAP System Performance Goals, System Operating Level Agreements and system KPIs, applying fixes, OSS Notes , escalating issues to SAP liaison with OSS-SAP for resolving problems. Helped the customers in making tactical decisions provides input on strategic decisions to management as required to impact critical projects and processes to reduce significant financial costs.

Areas of Expertise:

SAP BI TEAM LEAD

• Trained in BPC Net weaver based planning applications, creating application sets, dimensions, export journal entries, allocations, copy transaction data, business rule setting validation.
• Knowledge of HANA integration , monitoring and reporting data.
• BOBJ XI 3.x 4.0: Hands on experience in installing, clustering, configuring SSO, BOBJ content security, troubleshoot and resolve complex BOBJ issues, like platform issues, configuration issues, migration issues, configuring dashboards Designer, Webi, Crystal Reports 2008 , Xcelsius dashboards using LiveOffice and QaaWS.
• SEM BPS, BCS, Business Scorecards, Dash Boards and SAP APO DP, SNP .
• BI-IP: Planning functions using enhancements FOX FOrmula eXtension tool, defining Aggregation Levels, Characteristics derivation and Planning Sequence.
• CRM Analytics, Trade promotion management, Campaign management, closed loop planning, BPS, Integrated planning, Outlook soft BPC, Business Objects XI, Voyager, Xcelsius and Crystal reports.
• Extensive knowledge in planning, forecasting tools in BPS, Worked on Planning area, level, package, profile, sequences, variables, data slice, and Characteristic relationships, cost center retractors, integrated BPS with Consolidation cubes.
• BPS web applications creating and maintaining of BSP apps for layouts and uploads
• Business Areas BW, SD, FI-CO, MM, PP, APO, SEM, mySAP components value ASAP methodology.
• Business content information modeling for strategy specific to the Client Business scenarios.
• Customizations - Data source enhancements, generic extractors, user Exits and customized delta built up for the data sources, Logistics Cockpit configuration and personalization, OLTP versions ECC 6.0, 5.0 R/3 4.X.
• SAP Security Expertise in analysis of Reporting Authorizations, user profiles maintenance, SAP Security Standards as per Net weaver 7.1 and BO CMC XI 3.1.
• BW Reporting - BEx Analyzer, RRI, Infoset Query, Web Reporting and integrated planning.
• Hands on Erwin tool for data modeling and strong understanding of database design, SQL queries, PL/SQL.
• BW modeling monitoring- Info Cubes, ODS design, Info Source, Info Object mtc, Open Hub.
• BW Optimization - ETL management, performance tuning, process chains and automations, CCMS, SSAA.
• Training Mentored functional teams in BW reporting, security, Info Cube design and extraction.
• EP portal integration's, DBA, system admin integrators.
• Implemented Plant Maintenance, PS QM with client specific reporting.

SAP R/3 ABAP/4 Implementations:

• FI/CO, MM, SD, PS PP configuration Integration experience, customized CO, ES-CS, ES-PC, and Profitability reporting to business process wise and management corporate periodic reporting, worked with ECC 6.0 Data sources for enhancements, Knowledge of FI/CO impact of SD, MM, PP processes
• Expertise includes ABAP/4 coding for developing new objects, Classical Reporting, Java web integration, BAPI's, BADI's, exits, Custom Objects such as Z-Tables, e-CATT's, BSP, web dynpro.

Work Experience:

Confidential

BI Solution Architect

Confidential financial shared services as BI architect supported the financial consolidation of the month end, quarterly and yearend statutory reporting needs planning applications. Also involved in the projects in pulling data from application areas GL, PCA, CCA, AP, P2P, and ARIBA, I2C and streamlining Inter Company activities and reporting. Supported BI IP applications for planning, BART, GPF on PCA and GL data from ECC.

Handled Strive, LSR application for sales, inventory data from MDD systems from sap, non sap sources maintain master data and enabled Business users able to plan the data as per their MRC, company legal entity sharing relationship.Currency conversions for new EMEA countries were designed for I2C application to report on AR and Day sales outstanding reporting. Participated in design ECC BI integration for MM, PP, SNP, GATP application area best practices and Custom reporting for OTC and P2P scenarios

Confidential

BI Lead Consultant

• Confidential largest and most respected construction and engineering organizations.
• Project: KieCore new SAP implementation with SAP tools BI 7.3, BPC, BOBJ, DS, CRM, ECC, and SRM for the corporate
• As BI team lead guiding the team for the applying best practices for their integration strategy for BI 7.3, BO 4.0 cluster, BPC and Data services tools for corporate reporting strategies both strategic and operational fronts, finalizing functional scope and technical design documents, standard templates for communication, security compliance with GRC. Extraction of data from ECC, Legacy ERP tools to BI, IP for forecasting and internal project expenditure reports, BPC for financial consolidation, data modeled using BI Objects DSO, Cube, Multi Provider, Open Hub and Process Chain for automation, Data services used as extractor and from multiple sources like BI 7.3 , ECC 6.0 and other system and merged the data for Reporting in BOBJ 4.0 Tool. Contacted with SAP OSS team and troubleshoot service pack issues connecting issues with BOBj cluster. Good command in managing CMS repositories.

Confidential

BI-IP Technical Lead

• Confidential particularly deals with Supply chain management perspective relating financial information from SAP FI , FM, GL, AP, AR to Sales , PS Procurement application for corporate reporting for the regions Check and finalizing the Technical Design Documents as per enhanced functional scope documents for the projects. Design and developing all financial, procurement, Order, Inventory management and supply chain planning projects.
• SAP integration testing for Stanley business with Black Decker business merger, facilitate sourcing information from SAP legacy system data for streamlining supply chain planning reporting applications.
• Created Integrated planning application for Vendor payments forecasting for yearly budget requirements, product and location wise as per the Payment terms, created complex aggregation levels, filters, planning function, sequences process chains and authorization, Locking concept for planners.
• Developed reports for BOBJ 4.0 on the legacy data warehouse of Stanley division and SAP BW merged data into Tera data and Data stage in custom Data store objects reporting on universe data. Maintained Universes for both Stanley and Black Decker namespaces for separate reporting through Webi and Dashboards.
• Experience in extraction of data from ECC 6.0 using the standard content and development of BI Objects like Data source, DSO, Cube, Multi Provider, Open Hub and Process Chain etc and custom extractors used data from multiple sources like BI, ECC and other system and merge the data for Reporting in BOBJ Tool.
• BO Data Services used for migrating data from different Oracle data bases with required cleansing and stored in the target database as per the template. Experience writing ABAP code for Function modules, Transformations, routines, exits . Ability to pull data from multiple sources like BI, ECC and other system and merge the data for Reporting in BOBJ dashboard tool. Created open hub data extraction from BW to legacy DWH to merge all vendor, projects, PS,FM, PO and invoice based reporting as per business requirement.

Confidential

SAP BI Lead

• First Solar, the leading manufacturer of photovoltaic modules, is providing sustainable energy solutions for energy needs.
• practices for their Net weaver BI reporting strategy supporting modal after recent implementation SAP phase 1 .
• As BI team lead guiding the team for the applying best practices for their support modal for BI, BO and BPC 7.5 tools for problem management and change management procedures, functional scope and technical design documents, standard templates for communication. Improved the performance of dataflow for NewGL, Product costing, Purchasing, logistic applications, EHS, PS and FM .
• Experience in extraction of data from ECC 6.0 using the standard content and development of BI Objects like Data source, DSO, Cube, Multi Provider, Open Hub and Process Chain etc and custom extractors used data from multiple sources like BI, ECC and other system and merge the data for Reporting in BOBJ 3.2 Tool. Supported the BI-IP planning application for Budget planning and Funds allocation, forecasting internal project expenditure.
• Experience writing ABAP code for Function modules, Transformations, routines, exits and extensively worked creating reports using Webi, Crystal, Universe, Information Design Tool, Xcelsius dashboards . Redesigned the Universes for enhanced reporting and data quality control.

Confidential

SAP BI TEAM LEAD

• 7.1, EPM BO ECC 6.0, completely revisit its custom practices to Re-plat forming with SAP delivered standard content by 2010.
• As a Team Lead and System Architect finalizing the Technical Design Documents and reviewing functional scope documents for the projects. Supporting all financial, procurement, Order and Inventory management projects migration from old versions to new net weaver based re-platform, lead onsite offshore teams of 4 each.
• Order to Cash project , Sales reporting and planning applications in BI with Integrated Planning on budgeting and receivables planning , forecasting for the Intel specific business scenarios on SD, contract management.
• Worked for SRM implementation and BI business content activation and customized to reporting requirement.
• Streamlined data requirements for Procure to Pay and OTC business scenarios, from MM,SRM, FI /AP/AR and SCM applications.
• Involved in extraction of data from planning cubes and creation of basic Multi cubes for Planning-BPS reporting for projects, cost center and profit center accounting, web interfaces reports for planning for automated and manual editing for input ready.
• Developed custom reports for HR metrics and Payroll applications in WAD ,using dashboards with visual composure and interactive reports published in portals with Web API's, command URLs, HTML, Java Script and Cascading Style Sheets.
• Supply chain planning applications like demand planning and supply network planning and GATP check for the order execution, delivery and IM WM and performance improvement of system.
• Supported SD ECC6.0 and WM business processes for production support issues.
• Proof of concept and comparative analysis of planning application to new BI-BObj BPC to old IP planning Expertise with webi, xcelsius, Universe, CMS XI 3.1 and crystal reports 2008 , Xcelsius dashboards using LiveOffice and QaaWS

Confidential

SAP BI IP ARCHITECT

• Confidential is the second-largest US personal lines insurer, behind rival State Farm. The company sells auto, homeowners, property/casualty, and life insurance products in Canada and the .
• Implemented Enterprise Planning using BI 7.0 Net weaver 7.1 Integrated planning application for Technology Finance department. It addresses Tech. Finances' business and functional, technical, and operational requirements in planning headcounts, Liquidity, expenses related employee, non-employee and non-person expenses.
• As Lead Consultant and Architect participated in the phases from requirement gathering, blueprint preparation, knowledge transfers and accomplished the deliverables and milestones set forth in the Implementation of Project Plan.

Responsibilities:

• Review/validate and provide additional inputs /recommendations to previous documentation Fit-Gap analysis current ETL process, data elements, cube analysis and design.
• Provide functional technical specifications/recommendation/build pertaining to the SAP BI IP application.
• Provide analysis/design/recommendations to end-user training documentation and train-the-trainer program and its' rollout.
• Provide analysis, design, recommendations, expertise, build, testing of Technology Finance Reports actual, plan, forecasting and Org.View, service and Client view reports via BEx and WAD published to Portal.
• Ensure/provide completion of required IP reports Input ready queries, planning forecasting process functions, screen development, high quality reporting dashboards and visuals.
• Headcount and payroll cubes customized the HR analytical reports from business content, responsible for the analysis, design, architecting, build and testing of IP planning cubes to address Technology Finance IP business/ Tax issues, adjustments reporting requirements.
• Created aggregation levels, filters, planning function, sequences and authorization concept for users.
• Provide and ensure Master Data Organizational Hierarchies are correct and optimal for Reporting Query requirements, validated Business Objects for analysis reporting requirements.
• Provide and ensure all interfaces / interfacing with BW environment and other SAP entities have been identified, integration build/streamlines and operational and documented.
• Consultant to assist in UAT Phase and Test Plans in a quality environment compared the Business dashboards using QaaWs.
• Head count Planning on data integrating HR cubes Cost cubes, Underwriting, Claims, F A, Reinsurance.
• Helped the client to Migrate to SAP BI 7.0Netweaver based Analysis Authorizations, worked with Security Teams and auditors for setting portal based GRC access and controls.
• Documented the development and transport procedure across system landscape and performance tuning activities on IBM UDB database for BI.

Confidential

SAP BW TEAM LEAD

Discovers, develops, and produces critical care treatments for people with life-threatening disorders in a variety of therapeutic areas, including immunology, pulmonology, and hemostasis.Confidential business warehouse and implementation of SAP BI 7.0 from earlier version BW 2.0 Configured enterprise reporting, planned and incorporated web-based dashboards and netweaver portal capabilities Customized business specific reporting from Plasma info area and aligned with customer needs Provided COPA configuration and reporting for plasma cost centre accounting, account receivables and sales deliveries cubes.

Responsibilities:

• Worked as Team lead and Onsite Coordinator and maintained offshore resources 18 in Siemens India.
• As Functional Consultant for BI 7.0 Configuration Development Reporting activities.
• Gathered end-user requirements in financial areas, mainly in Cost Center Accounting CCA , AR, SD and COPA, identified reports from std. content to customize to business.
• Created customized Cubes ODS for the Transaction data Delta process for Plasma info area.
• Extensively used ABAP Routines for Transformations and start routines.
• Involved in BW COPA Configuration R3 Configuration and extract of COPA transaction data into BW.
• Involved in designing COPA Cubes architecture to feed Planning BPS layouts.
• Created Process chains for the loading of Master Data Transaction data loads.
• Activated and customized HR headcount, payroll and services reports from custom HR cubes.
• Developed AR SD deliveries BEx Queries and using Web Application designer and Enterprise Portal published as web reports.
• Activated business content for HR analytics and payroll reports to customize to business requirement.
• IP implementation for sales planning, requirement gathering for Aggregation Levels Filters, Planning Layouts and Characteristics derivation for Planning Sequence written Planning functions using FOX the formula language model complex flow structures, dashboards with VC.
• Worked on Migrate to SAP BI 7.0Netweaver based Analysis Authorizations, worked with Security Team.

Confidential

SAP BW CONSULTANT

Managed projects for SEM Business planning, Cost Center and Profit Center planning, BW Workflows. Facilitated knowledge transfer from software application vendor, Confidential and maintained offshore team in Siemens India Mumbai. Provided post-production support, application and BW workflow management.

Responsibilities:

• Worked as Lead Functional Consultant for BW 3.5 SEM 4.0 Configuration, Development, Reporting activities lead offshore team setup with 8 head count to support.
• Worked with SEM-BPS team and involved in planning monitored the Transaction cubes for the Planning layouts for short, medium and long terms.
• Created ABAP Function modules for Variable value calculation in custom planning functions for BPS team.
• Involved in extraction of data from planning cubes and creation of basic Multitudes for Planning-BPS reporting for projects, cost center , profit center accounting and Balance sheet planning, investment planning.
• Involved in BW COPA monitoring R3 Configuration and extract of COPA transaction data into BW.
• Involved in designing COPA Cubes architecture to feed Planning BPS layouts, custom extraction from Hyperion Planning data and enhanced with SEM planning and worked with retractors back to R/3.
• Monitored Process chains for the loading of Master Data, Transaction data plan data for BPS, FIGL, AR, AP FA , also run programs for depreciation run data flow from R/3 to BW for period ends.
• Performance tuning of cubes for Compression, Partition, Indexing of info cubes and use of statistics for the same, improved performance of the planning levels, packages and planning functions.
• Developed BEx Queries, version comparison for planning, forecast and budgets and using Web Application designer and Enterprise Portal published as web reports, currency conversions tools.
• Reports customized Budget control expenditures, Funds accounting and understanding of the fund sub ledgers, balance sheet reporting, and project systems budget to actual WBS reporting.

Confidential

Role: BW Project Lead.

• Siemens proprietary integrated solution in SAP BW 3.5 release based on standard financials, controlling and logistical processes, and upgrade to BI Net weaver 7.0, SCM 4.0 and SEM 6.0.
• Prepared the up gradation and migration plan for the BW system and lead the BW Basis team.
• Impact analysis of the upgrade on the existing processes and interfaces, authorization migration to BI 7.0 functionality,
• Prepared the post-upgrade action plan for BW custom and standard objects optimization, Remodeled the process chains for data load optimization, Customized reports Cubes and staging for Cost center accounting application.
• Reports customized Budget control expenditures and project systems budget to actual WBS reporting, applications.
• As Team Lead coordinated liaison with offshore basis teams.

Confidential

Role: BW Projects Lead.

• Lead CTP Leader Design Transition programs of APO BW developments Integrations with legacy systems, SHC-LLC application Accenture, Germany Managed supply chain facility planning with APO, BW and R/3 systems Performed implementation quality audits, optimizations and performance enhancements. Facilitated the Business consolidation add-on B-plus for achieving automatic financial consolidation modelling in BW.
• Involved in SHC BENQ business split change management and separated the data warehouse requirements for the business.
• Projects:
• Mabert employee reporting to SHC
• APO-BW SHC-LLC integration
• SHC planning handbook -BPS
• Business performance Metrics at SHC.
• Application Regional stock- BSP application.
• Up-grade project to BI 7.0
• Worked as Team Lead Onsite coordinator to guide offshore team.
• Responsibilities:
• As Principal application consultant BI System Owner reporting to BSM and working with SHC stake holders.
• Gathered end-user requirements in logistics processes, source, delivery, stock, and financials mainly in Consolidations BCS Logistics-MM Procurement and created Reports using BSP Web Designer.
• Streamlined the BPS planning for material stocks, SHC managed and Vendor managed stocks.
• Created Customized Cubes ODS for the Transaction data Delta process to optimize extraction times.
• Used LO Cockpit process for activating the Extract structure Data sources 2LIS 11 V , 2LIS 12 V , 2LIS 13 VAHDR.
• Generic data sources created for SHC BENQ source delivery data r/3 table S503 S510.
• Extensively used ABAP Start Routines in Transfer Rules and Update rules, function modules for special data transformation relative to business.
• Created Process chains for the loading of Master Data Transaction data for Consolidations Profit Center Accounting, APO master, actual and planning data backup.
• Created Transactional cubes and Multi-providers for reporting purpose. Used data mart to transfer actual data for different data sets between the cubes.
• Performed various BEx Level calculations on MP reports for currency translations and unit conversions.
• Scheduled Process Chains for Periodic data loads using events and ABAP logic.
• Involved in creating the Aggregates for the Info cubes to improve reporting performance.
• Involved in Creating Custom Hierarchies in BW related to Organization, Human resources, custom HR content for employee reporting, Payroll and budget reporting.
• Developed Front-end queries using BEx Query Designer and Reports using BEx Analyzer and Web Application Designer BSP pages.
• Worked with budget, Cost center, profit center, balance sheet , profit-loss account and Sales planning, enhanced planning levels planning packages, planning functions with FOX coding.
• Involved in customizing Variables using the Enhancement RSR00001 and Customer User-Exit for ABAP for
• Planning functions automation, FOX formulas, currency conversions and global consolidations.
• Design and developed a custom application with layouts for regional stock s on product group basis using BSP and MDX technologies.
• Reports customized Budget control expenditures for HGB and GAAP standards, Funds accounting and understanding of the fund sub ledgers, balance sheet reporting, currency conversion for global consolidation and project systems budget to actual WBS reporting, HR analytics reports like benefit cost reporting, payroll wage type reporting, workforce diversity analysis, employee master data reporting.

Confidential

Role: BW Project Lead.

Facilitated and Maintained BW based Business Consolidation for Siemens Germany projects, data recorded on the level Profit-center-group, Segment or organization unit. Consdolidated CLplus FC-National data. Planned and Prepared simulations, forecasts and budgets using SEM 3.5 BPS, BCS Realized through 'Internal Business Volume Elimination' in BEx Reporting. Maintained internal business volume elimination, characteristics, attributes, hierarchy's depth structures and currency translations. Monitored the reporting team for VBA customizations of the workbooks for financial reports.

• Gathered end-user requirements in financial areas, mainly in Consolidations BCS , Profit Center Accounting PCA , Cost Center Accounting CCA and created Reports using VBA macros on workbooks Reports Web Designer, published in Portals.
• Involved in the creation of Custom Basic Multi cube for Consolidation using Sap Cube 0ECCS C01
• In BCS, 0PCA C01 in PCA, projects data from R/3 tables COEP and 2LIS 01 S946.
• Created Process chains for the loading of Master Data Transaction data for Consolidations Profit Center Accounting and synchronize the master data between BW and SEM systems.
• Created Transactional cubes and Multi-providers for reporting purpose. Used data mart to transfer actual data for different data sets between the cubes, Separate cubes for Consolidation and planning.
• Performed various BEx Level calculations on MP reports for currency translations and unit conversions.
• Used the Info Source 0EC CS 1 and Data source 3EC CS 1 for extracting the transaction data in BCS.
• Scheduled Process Chains for Periodic data loads for month end process.
• Involved in creating the Aggregates for the Info cubes, elimination of inter-unit variances.
• Involved in Creating Custom Hierarchies in BW, currency conversion for global consolidation.
• Developed Front-end queries using BEx Query Designer and Reports using BEx Analyzer and Web Application Designer VBA macros for reports of HGB GAAP standards.
• Involved in developing queries involving Hierarchies, Variables and Exceptions for fiscal reporting year wise.
• Involved in customizing Variables using the Enhancement RSR00001 and Customer User-Exit for planning functions, validations.

Confidential

• Covers network infrastructure and mobile applications over 89 countries, HQ. Munich, Germany.
• Implemented and supported BW-Portal integrations with Sales and Financial data SEM 3.2 for dynamic risk management Optimized Sunrise application for performance in data process flow monitoring and troubleshooting W3 inventory I2 reporting modules.
• Responsibility: Team lead for the offshore team of 12 consultants of Both BW ABAP resources.
• Gathered end-user requirements in GOAL-ACTION financial controlling areas, GOPCS Project controlling sheet , GoOCS Offer Controlling sheet , and created Reports using BEx and BSP web interface.
• Involved in the creation of Customized Basic Multi cube for reporting, projects data from R/3 tables COEP, COSP, COSB and 2LIS 01 S710.
• Created Process chains for the loading of Master Data Transaction data for the application wise.
• Performed various BEx Level calculations on MP reports for currency translations and unit conversions.
• Scheduled Process Chains for Periodic data loads for month end process using process chains and event trigger by UC4 mechanism.
• Involved in creating and monitored the Aggregates for the Info cubes, Custom Hierarchies in BW and reported on SRM procurement data sources, supply optimization and vendor analysis reports.
• Developed Front-end queries using BEx Query Designer and Reports using BEx Analyzer and Web Application Designer VBA macros.
• Streamlined the process of the SEM BPS application DRM Dynamic Risk Management .
• Involved in developing queries involving Hierarchies, Variables and Exceptions for fiscal reporting year wise.
• Involved in customizing Variables using the Enhancement RSR00001 and Customer User-Exit SAPLRRS0 001.
• Configured CRM and BW BPS integration for analytics on Trade promotion management, campaign management.
• Modeled the W3 world wide warehouse application using open hub interface to the web.
• Monitored the LCT Logistic controlling tool and sunrise application for performance optimization.
• Involved in the design of fiscal year changes 5-4-4 project after Nokia-Siemens business acquisition.
• Monitored financial sales applications SPCS and Fordrungen with projects.
• Reports customized Budget control expenditures, Funds accounting and understanding of the fund sub ledgers, balance sheet reporting, and project systems budget to actual WBS reporting, HR reports like benefit cost reporting, payroll wage type reporting, workforce diversity analysis, employee master data reporting.

Confidential

Role: BW Project Lead.

• Supplies and processes industry machinery and systems: Paper, Minerals, Automaton and Ventures.
• Supported BW reporting and special purpose ledgers with data coming from different R/3 sources Metso Oyj Metso Botanika and Metso Panel Bridge projects - FI-AP, FI-AR, FI-GL, FI-AA, Travel, SD, MM, PS
• Special ledgers designed for controlling data for ZZMETSOA Actual line item table , ZZMETSOT Summary table , and developed custom reports on the cubes.
• Maintained profit center and cost center hierarchies from R/3 to BW system.
• ODS maintained separately for global and local country specific special ledgers.
• Reports workbooks were modeled for Profit and loss statement Financial Accounting Profit and loss statement Management Accounting, Balance sheet Financial Accounting Balance sheet Management Accounting, Indirect expenses, Sales summary and project summary condensed reports.
• FIAR standard content utilized for custom cubes for customer credit management, receivable aging reports.
• Internal controlling and management reporting for BW the SAP modules CO-CCA, CO-IO, EC-PCA and FI-S/L were the source of the data.
• Remodeled process chains for improving the performance of master and transaction data loading.
• Implementation of the SEM 3.0 server created planning areas, planning packages, planning functions, user exits FOX functions to customize the planning logic for all financial planning.
• Transported BPS planning objects BW objects across landscape.

Confidential

Role: BW support Lead.

• India's famous 2 3 wheeler Automotive Company with wide network of retailers, and various products.
• Worked as support lead consultant in upgrade, performance tuning and portal integration of HR applications. Converted manufacture process from Discrete to Repetitive in R/3 BW development and management reports. Enabled web reporting on portal, customized warranty and dealer's management system, Process Chain configured for automate loads and alerts.
• LO cockpit maintenance for Repetitive manufacturing, sales and purchasing areas with enhancements on reports generation on corresponding cubes, procurement optimization, vendor analysis reports.
• Developed custom cubes for Dealer Management Systems, warranty custom cubes for reporting.
• Process chains created for automate data loading, Scheduled Daily/Weekly/Monthly data loads, and scheduled new jobs using process chains.
• Reports customized to Client business from Implementing HR, PM QM standard content.
• Customized HR extractor for employee photos from R/3 HR module and generated for employee wise in BW Payroll reports and publish them as iviews and Dashboards on portal Net weaver v 3.5.

Confidential

Role: BW Project Lead.

Siemens proprietary integrated solution in SAP BW R/3 on release 4.6C based on standard financials and logistical processes provides the technical platform for siemens shared services concept. Rollout for Europe Asia pacific.

• Facilitated rollout of Global Template called Spiridon in Siemens operating companies worldwide.
• Expertise in the business consolidation add-on tools B-plus specific to Siemens on SAP BW, other modules FI, CO, Sales, QM, PP, HR head count, HR Payroll and Warehouse Management.
• Configured BCS consolidation in BW to facilitate SEM BPS global planning applications.
• Extensively involved in the scheduling and monitoring of reports in Information Warehouse Using SAP BW Administrator Workbench.
• Worked closely with the corporate SAP BW technical consultants in providing technical specifications to enhance the current objects and developed new ODS and Info Cubes FI/CO, SD for Data warehousing.
• Activated, created, and worked on Extractors, Generic Extractors, Logistics Cockpit, R/3 Data Sources non r/3 data sources, Info sources, Transfer Rules, Update Rules, Info packages, Info package Groups, Info objects, ODS, Info cubes, ODS Structures, Queries, Variables, Calculated Key Figures, Info set Queries, Workbooks, Analyzer, Browser, ITS, 3rd party reporting tools, Roles and Transports.
• Performed data loading using SAP supplied Extractors in HR module for Pay roll, Headcount, compensation along with custom data through flat files.
• Performance tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of info cubes and use of statistics for the same.
• Used Routines Abap/4 for data Manipulation in transfer/update rules, custom-exits for Planning functions, currency conversions and validation for consolidations.
• Supported user inquiries on SAP BW BEx Analyzer, BEx browser and web reports for business intelligence and planning layouts with BSP. Assisted other team members in providing effective financial solutions for the customers and end-users using BW planning tools.

Role: BW Application Consultant.

• Implemented SAP R/3, BW, SD, and FICO and integrated with other non-SAP systems.
• Loading data via Flat files, PSA cleansing, data quality check, Info providers, Info packages, Schedule Data Targets. ODS performance tuning, Aggregates, key figures summarization. Built custom Info Cubes, BEx pre-designed Query Reporting, Generic extraction, Legacy to SAP and SAP BW Migration. Extensively involved in the scheduling and monitoring of reports in Information Warehouse Using SAP BW Administrator Workbench.
• Worked closely with the corporate SAP BW technical consultants in providing technical specifications to enhance the current objects and developed new ODS SD Order Details and Info Cubes FI/CO, SD for Data warehousing. Tested technical changes to the Info Cubes.
• Activated, created, and worked on a daily basis with Extractors, Generic Extractors, Logistics Cockpit, R/3 Data Sources non r/3 data sources, Info sources, Transfer Rules, Update Rules, Info packages, Info package Groups, Info objects, ODS, Info cubes, ODS Structures, Queries, Variables, Calculated Key Figures, Info set Queries, Workbooks, Analyzer, Browser, Roles and Transports.
• Performed data loading using SAP supplied Extractors and flat files.
• Performance tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of info cubes and use of statistics for the same.
• Used Routines Abap/4 for data Manipulation in transfer/update rules
• Business re-engineering of procurement planning, inventory management and material codification.
• Gathered and analyzed requirements for operational and strategic reporting.
• Reports customized like spend analysis, vendor performance delivery, quality and vendor diversity analysis.
• Designed Bex reports , workbooks for Financial Balance sheet, Profit loss and sales areas, and configured reports, graphs automation for Management.
• Scheduled Daily/Weekly/Monthly data loads, scheduled new jobs using process chains.
• Process chains created for automate data loading and planning backups in transactional cubes.
• Developed custom cubes for Dealer Management Systems.
• LO cockpit maintenance enhancement with reports generation on corresponding cubes.
• Implemented Integrated BW, SAP R/3 modules MM, PP FI/CO cross module integration automated data flows using process chain design.
• Developed and provided monthly reports using the databases to the management of the businesses. Responded to Ad-hoc requests with solutions that meet user needs in creative ways, utilizing technology. Supported user inquiries on SAP BW BEx Analyzer, BEx browser and Crystal reports for business intelligence. Assisted other team members in providing effective solutions for their customers utilizing Crystal Reports/BW tools.
• Configuration of Release strategy for purchase orders split valuation for batch managed valuated stocks, business process transactions with batch management
• Configuration Business process mapping of AP Down payment to vendor subsequent invoice booking upon goods receipt. Vendor payable interface development with CITI bank
• Development of simplified codification system for material masters
• Development of purchasing report Order details to payment status
• Development of custom transaction for automatic service entry sheet acceptance
• MCP certified in VB 6.0 distributed technologies.
• Certificate in Business German language.
• Trained in Outlook soft Everest 4.1 BPC , and Business Objects, Xcelsius.
• Trained in BIA configuration.