SUMMARY:

• 15 years of IT experience with 12 years in SAP HANA, BI, BOBJ., BODS, BPC 10.1, Net weaver 7.4, BI 7.4, SRM, CRM 7.0, C A, Solution Manager 3.2, and SAP ABAP/4 in MM, P2P,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.3,7.x, 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,HCM, 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.
• 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.
• Expertise in Front-End Business Warehouse Components, Analytics like Financial Analytics, Supply chain analytics, Product costing, HR Analytics, CRM Analytics, Workbooks and Web Dashboard Reports, hands on exp. with Business Objects.
• ABAP Start routines, BADI’s, user exits, Conversion Routines in Transfer Rules and Update Rules for client specific business logic.
• Adept in using Sap Netweaver Components:, BEX Analyzer, Query Designer, Web Application Designer & Enterprise Portal, experience in developing Formatted Reports using Business Objects, Xcelsius.
• Exposure in BI 7.3 functionality, knowledge of 7.3 upgrades activities, 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 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.
• 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.
• Hands on Architect for HANA 1.0 SP08, HANA Studio, XS engine, In-memory systems, Integrating Hadoop (SPARK), predictive analytics (PAL ), using R, RRE 7, SAS, PMML, HANA as per the business functional requirements, Perspective and text Analytics for operational business scenarios.
• HANA 1.0 SP 08 Conceptualization for Business needs, KPI modeling, creating information models for SAP content and Non-Sap systems, data governance, Data architecture, Cloud facilitation, data provisioning best practices ( SLT and BODS), mobility, SAP UI, RDL1.0, BRM and decision trees, information Views (attribute views, analytic views, calculation views), and analytic privileges, Processing models. SQL based scripts .
• Business Suit on HANA, CoPA accelerator, and CRM RDS solution, with Sybase Replication, Mobility.
• BOBJ 4.x: Hands on experience in installing, clustering, configuring SSO, BOBJ content security, content analytics, text data analysis, troubleshoot and resolve complex BOBJ issues, like platform issues, configuration issues, migration issues, configuring dashboards Designer, Webi, Crystal Reports, Xcelsius dashboards using LiveOffice and QaaWS.
• BPC 10.1 Net weaver based planning applications on HANA, creating application sets, dimensions, export journal entries, allocations, copy transaction data, business rule setting & validation, SAP BI, BOBJ, and Business Planning Agile implementations.
• ETL: SAP LT Replication, BO DS 4.2, Informatica 9.6, SQL . Adept with BO DS in creating views, Perform column profiling, Source System Configuration, address profiling, dependency profiling, redundancy profiling, uniqueness profiling, creating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing tasks with Information steward 4.0
• SEM (BPS, BCS, Business Scorecards, Dash Boards) and SAP APO (DP, SNP).
• Planning functions using enhancements FOX (Formula eXtension) tool, defining Aggregation Levels, Characteristics derivation and Planning Sequence..
• Business content information modeling for strategy specific to the Client Business scenarios like P2P, I2C, HCM .
• BW modeling & monitoring- Info Cubes, DSO/ ODS design, Info Source, Info Object mtc, Open Hub Service
• Hands on Erwin tool for data modeling and documentation, APD Data Mining tools like Association Analysis, Classification, trained power users with Visual composure (VC) .
• SAP Security - Expertise in analysis of Reporting Authorizations,HANA, BO 41 user profiles maintenance, SAP Security Standards as per Net weaver 7.1 and BO CMC XI 3.1.
• 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. cutover activities for golive.
• BW Optimization - ETL management, performance tuning, process chains and automations, CCMS.
• Training - Mentored functional teams in BW reporting, security, Info Cube design and extraction.
• EP portal integration’s, DBA, system admin & integrators.

WORK EXPERIENCE:

Confidential, NJ

BI Lead Developer

Responsibilities:

• Worked in ITGF 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.
• Procure to pay integration of ARIBA,SAP, AP modules, ebuyer and SRM data into BW to report on spend performance, supplier diversity and vendor analytics dashboards created using BO 4.1.
• Supported SEM BPS 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.
• HR Compensation, benefits configured from SAP HCM content and ESS, MSS enabled in portal for self-services.
• Involved in HANA (analytical and calculation views with HANA studio) and Predictive Analytics with R and PMML, Text- Analytics for POC for Confidential financial shared services business use case. Used Confidential for data migration to HANA, for Address Verification, maintaining data sources.
• Source Database and Target Database validations, checking the Central repository and Local repository Data store connections and transformations, sending the XML files to respective Destinations.

Confidential, Omaha, NE

BI Lead Developer

Responsibilities:

• As BI integration lead guiding the team for the applying best practices for their systems integration strategy for BI, BO and BPC tools for corporate reporting strategies both strategic and operational fronts, and security .
• Extraction of data from ECC, Legacy ERP tools to BI, CRM middleware performance tuning, Data services used as extractor and from multiple sources like BI, ECC and other file sources like XML, faltfiles and merged the data for Reporting in BOBJ Tool. HR Compensation, benefits configured from SAP HCM content and ESS, MSS enabled in portal for self-services.
• Confidential as main ETL for Legacy Data sources creating views, Perform column profiling, Source System Configuration, address profiling, dependency profiling, redundancy profiling, uniqueness profiling, creating complex validation rules, rule bindings, defining rules task and view results, scorecard setup and managing tasks with Information steward 4.0.

Confidential, Towson, MD

Business Intelligence Lead

Responsibilities:

• 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 & Confidential business merger, facilitate sourcing information from SAP & legacy system data for streamlining supply chain planning & reporting applications. APD used for XML file generation as per the changing reporting requirements. Streamlined the Inventory cubes for Material movement and valuation reporting.
• 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.
• 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. P2P integration AP modules with oracle procurement, ebuyer and SRM data into BW to report on spend performance, supplier diversity and vendor analytics dashboards created using BO Xcelcius.
• BO Data Services used for migrating data from different Oracle data basses with required cleansing and stored in the target database as per the template. Performed Mapping, Validations (Lookup, Mandatory, Format), Enrichments in AIO Jobs for Customer Master, Vendor Master, Material Master, PIR
• Experience writing ABAP code for Function modules, Transformations, routines, exits and extensively worked creating reports using Webi, Crystal, Universe, Information Design Tool, Xcelsius.
• 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 vendors, projects, PS, FM, PO and invoice based reporting as per business requirement.

Confidential, Perrysburg, OH

SAP BI Lead Developer

Responsibilities:

• 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, Inventory management 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 Tool.
• Experience writing ABAP code for Function modules, Transformations, routines, exits and extensively worked creating reports using Webi, Crystal, Universe, Information Design Tool, Xcelsius.
• Ability to pull data from multiple sources like BI, ECC and other system and merge the data for Reporting in BOBJ Tool.

Confidential, Folsom, CA

SAP BI TEAM LEAD

Responsibilities:

• As a Team Lead and System Architect finalizing the Technical Design Documents and reviewing functional scope documents for the projects. Supporting all financial, procurement, Orderand Inventory management projects migration from old versions to new net weaver based re-platform.
• Captured data from GL, AP, AR, CO-PC, PS, FM, overhead costing, BOM, routings and secondary costs from warehouses to report on actual and planned product costs. Trouble suited data issues from WM system to BW for reconciliation of inventory data.
• Order to Cash projectand planning applicationsin BI with Integrated Planning on budgeting and receivables planning, product cost planning for the Confidential specific business scenarios.
• Worked for SRM implementation and BI P2P business content activation and customized to reporting requirement.
• CRM 7.0 integration with BI and SD for pricing, condition types, master data and transaction loads and developed analytics with APD process for customer data mining applications and custom cubes & reports for Contract Management, HR metrics, HCM OM and Payroll applications. Extracted data from legacy and people soft applications using BO Data services.
• 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.
• Experience writing ABAP code for Function modules, Transformations, routines, exits and extensively worked creating reports using Webi, Crystal, Universe, Information Design Tool, Xcelsius.
• Ability to pull data from multiple sources like BI, ECC and other system using Informatica, Data Integrator, cleanse and merge the data for Reporting in BOBJ Tool. Using open hubs sent DP,SNP data to Teradata and reporting further with Micro strategy.
• Expertise with webi, Universe, CMS XI 3.1 and crystal reports, Xcelsius dashboards using LiveOffice and QaaWS, published reports and set authorizations for Enterprise Portal roles and ABAP roles

Confidential, Northbrook, IL

SAP BI ARCHITECT

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.
• Data extracted to Headcount, payroll cubes, GL, AP, AR 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.
• Consultant to assist in UAT Phase and Test Plans in a quality environment compared the Business objects & Xcelsius dashboards using LiveOffice and 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.

SAP Team Lead / BI lead

Confidential, RTP, NC

Responsibilities:

• Discovers, develops, and produces critical care treatments for people with life-threatening disorders in a variety of therapeutic areas, including immunology, pulmonology, and hemostasis.
• Migrated (upgraded) R/3 & Talecris’s 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 center accounting, account receivables and sales & deliveries cubes.
• Lead team and Onsite offshore coordination of teams,
• Gathered end-user requirements in financial areas GL, AP, AR, mainly in Cost Center Accounting (CCA), AR, SD and COPA, identified reports from std. content to customize to business.
• Defined inventory cube scenario for batch management reporting.
• Architected and Migrate to SAP BI 7.0Netweaver based Analysis Authorizations, worked with Security Team.
• Facilitated knowledge transfer from software application vendor, MEDAS, UK and maintained offshore team in Confidential India Mumbai. Provided post-production support, application and BW work flow management.
• Worked as Functional Consultant for BW 3.5 & SEM 4.0 Configuration, Development, Reporting activities and
• Involved in planning & monitored the Transaction cubes for the Planning layouts for short, medium and long terms.
• Created ABAP custom Function modules for Variable value calculation in custom planning functions for BPS team.
• Confidential proprietary integrated solution in SAP BW 3.5 release based on standard financial s, controlling and logistical processes, and upgrade to BI Net weaver 7.0, SCM 3.5 and SEM 4.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 functionalitySiemens Home and Office Communication Devices GmbH & Co. KG ( )
• Lead 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.
• Planned and Prepared simulations, forecasts and budgets using SEM 3.5
• 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.