SUMMARY:

• Expert experience in developing Reports & Input Schedules, SAP BPC Scripting, and Excel VBA/Macros.
• Strong knowledge in Development of POC’s using BPC 7.5 NW, BPC 10.0 NW, BW 7.3 and HANA connectivity and defining and Configuring Dimensions, Dimension Members and their properties, AppSet and Applications, Logic Script development, Data transformation and Conversions during the loads.
• Expert Knowledge in understanding business requirements and translating customer requirements into blue print
• Hands on experience in developing functional models like CAPEX, Head
• Count planning, Sales planning, and Forecast Planning.
• Uploaded Master data and transactional data using standard DM packages.
• Expert working experience with BPC EvDRE’s and EPM Member formulas, and master data automation from BI to BPC.
• Solid experience in Building input schedules, Reports, Security Set up (Task Profile, Member Access Profiles, Users and Teams), Work Status Settings.
• Deep understanding of month end process automation using Business process flows to facilitate users to close the month end and provide reporting.
• Expert knowledge and experience in developing Input schedules, Reports, Script Logics, Business Rules, and Member Formulas.
• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology.
• Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0
• Experience working on HANA Enterprise - Modeling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO’s, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.
• Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical view.
• Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.
• Experience in Data-Provisioning techniques suing SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Predictive Analysis, Business Objects Explorer, and MS Excel.
• Implemented 5 end-to-end full-life cycles using ASAP methodology across various modules in SAP BI/BW projects.
• Experienced in designing and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.
• Strong experience in BW 3.x and BI 7.x version and upgrade (technical and functional).
• Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
• Worked on BW support project activities (data loading & monitoring and troubleshooting the failures).
• Experience in system maintenance tasks (Delta queue cleaning, Setup table deletion & validation)
• BW load/job automation through process chain and Control-M.
• Worked extensively in SD, MM, PP, and FI Modules.
• Strong in performance tuning (Data loading and BEX reports) and job failure reduction activities.

TECHNICAL SKILLS:

ERP Packages: SAP Net Weaver 2004s, SAP R/3 4.6,4.7, ECC 6.0

SAP: SAP BI 7.0, BW 3.5, SAP BPC 7.5/10/10.1 MS & NW, BI related ABAP SAP Business Objects XI R 3.1 & 4.0, Info View, SAP HANA Information Designer, HANA Modeler

Reporting Tools: BEx Query Designer, BEx Analyzer, Workbooks, Web Application Designer, Report Designer, Crystal Reports, XCelsius, WEBI.

Functional Module: Logistics (SD, MM), FI (AP, AR, GL)

Languages/Scripts: ABAP/4, PL/SQL, C, Java, .NET, HTML

Databases: HANA, Oracle 9i/10g, MS SQL Server, MS Access

Operating Systems: Windows 95/98/NT/2000/XP/Vista/7, Windows 2000/2003 Server

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

SAP BPC Consultant & Technical Report Expert

Responsibilities:

• Worked with business owners to understand requirements and design of financial reports to be supported by the SAP BPC 10.0 System using the EPM Add-in and
• Created and maintained financial reports in BPC using the EPM Excel Add-in.
• Performed unit testing, designed technical and functional documentation for newly designed of EPM Reports/Templates
• Supported the creation/maintenance of data input templates using the EPM Add-in 10.0
• Responsible for immediate resolution of BPC production issues logged in HP ALM
• Took charge of creating and executing test scripts using ALM/ HP Quality Center Administration
• Managed a small team consisting of application developers, technical business users and business analysts
• Recreated Crystal and BPC 7.5 critical financial reports using the new functionality of EPM Add-in 10.0
• Assisted during the process of collecting and release of transports in timely fashion manner using CHARM
• Automated the distribution of reports and input templates through Book Publication and the execution Data Package Manager by implementing API’s and customized VBA Macros

Confidential, Fort Collins, CO

SAP BPC Technology Consultant

Responsibilities:

• Defining systems strategy and developing systems requirements
• Designing, testing, and prototyping of BW design for BPC.
• End-users hands on and.
• Defining support procedures, and implementing practical business solutions.
• Resolved all issues from Migration of EPM10 and BW to HANA.
• Developed of Reports and Input Forms with wide use of EPM Functions and Formatting Sheet.
• Assisted in migrating the standard DSO’s and Info Cubes to HANA Optimized structures
• Collaborated in importing BW models (Info Cube, DSO) in HANA as Analytical view.

Confidential, Fort Collins, CO

SAP BPC Technology Consultant (version BPC 10)

Responsibilities:

• Handled Master data from BW to BPC dimensions, as well as CO-PA extractions into the Finance Model.
• Handled Transaction data from BW to BPC, which includes Exchange Rate Data.
• Handled transaction data from Flat File to BPC using data manager package, transformation and conversions files.
• Developed Script logic for Account-base Calculations.
• Developed of Reports and Input Forms with wide use of EPM Functions, Such as; Exchange rate report, Balance Sheet Report, Income Statement Report and IC elimination verification Report, and Segment Reporting With sales.
• BPC Architect for Cash Flow/Balance Sheet planning Application, and Income Statement.
• Worked as a Solution Architect on a highly complex Consolidation project initiative.
• Worked as a mentor/coach on the recreation of financial and managerial reports in EMP 10.
• Improved the performance of multiple folds by optimizing Input Schedules and logic calculations

Confidential, Houston, TX

SAP BW/HANA/BPC Technology Consultant (version BPC 10 NW, BW 7.4 SP07, HANA 1.0 SP08, BO)

Responsibilities:

• Identified the customer reporting pain points from BW and EPM10 reporting which needed to be optimized
• Developed Specifications and GAP analysis for the new reporting requirements.
• Prepared migration plan for BW and EPM10.
• Stress tested the production data for the performance check of the data model.
• Data modeling (Designing and building Attribute views, analytical views and calculation views) for BW and EPM10 on SAP HANA.
• Reviewed solution architecture and provided technical guidance on as-needed basis.
• Resolved all issues from Migration of EPM10 and BW to HANA.
• Worked closely with Database team in upgrading Hana Patch’s.
• Collaborated on designing Data Mart scenarios and modeling in HANA, as well as, reports using Excel/BI tools on HANA models.
• Replicated ECC tables and BW cubes into HANA by using STL replication.
• Performed BW on HANA migration from existing BW architecture.
• Worked on assigning and providing privileges to SYS BIC, SYS REPO, and SYS BI CP ALL Analytical privileges.
• After implementation, the performance of Logic script and Data loads were increased by 70%.

Confidential, Houston, TX

SAP BPC Consultant (ECC 6.0, BI 7.3 and BPC 7.5/BPC 10.0)

Responsibilities:

• Designing of BPC dimensions, properties and models required for legal consolidation
• Involved in configuring different business rules like -
• Currency Translation - To convert local data into reporting / group currency
• Analyzed the errors that occurred during the data loading and solved the issues for that occurred during the activation process of the objects.
• Account Based Calculation - Reclassification of data (Ex calculation of retained earnings)
• Carry Forward - To carry forward closing balances of last year as opening balance of the current year
• Intercompany Eliminations and Adjustments.
• Configuring Ownership Manager - Define organization structure giving details of investments.
• Journals - Setting up journal functionality
• Controls - Set Up Controls To validate the data integrity
• Handled Master data from BW to BPC dimensions
• Handled Transaction data from BW to BPC which includes Exchange Rate Data.
• Handled transaction data from Flat File to BPC using data manager package, transformation and conversions.
• Developed Script logic for Account-base Calculations.
• Developed of Reports and Input Forms with wide use of EPM and EVDRE functionalities such as; Exchange rate report, Trail Balance Report, Balance Sheet Report, Income Statement Report and IC elimination verification Report and Segment Reporting With sales.
• BPF-Defined sequence of steps for legal Consolidation.
• Managed transports betweenDevelopment, Quality and Production Environments.

Confidential, Houston, TX

SAP BPC Consultant (ECC 6.0, BI 7.0,7.3 and BPC 7.5)

Responsibilities:

• Created a New Environment and applied associated dimensions, defined its properties and managed dimension members.
• Designed and developed multiple Hierarchies in Account Dimension for Chart of accounts and financial statement versions.
• Created Models for Cash and Liquidity forecasting, Exchange rates.
• Developed Treasury forecast Input schedule and Reports using EPM .
• Incorporated Drill-through functionality to BI-BEX Reports.
• Designed and Developed Generic Extractors and BI InfoCubes to pull the Data from ECC system to BI Info Cube
• Handled Master data and Transaction data to Dimensions and BPC Models using data manager packages.
• Configured business rules currency translation and Wrote Functional module based Generic extractor to extract rate data from BW to BPC.
• Designed and developed security profiles, roles and teams.
• Worked with Finance users and provided and support in creating EPM 10.0 reports and input schedules, Maintenance of master data, loading actual, coping data from one category to another, setting environments, etc.

Confidential, Kansas

SAP BI/BO Developer (SAP BO 3.1)

Responsibilities:

• Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager.
• Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file Datasources.
• IntegratedSAP BWwith Business Objects and extracted data fromSAP Data sources.
• Provide reporting solutions using 2 OLAP Universes using BOE XI 3.1 Universe Designer on top of SAP BEx queries, (enabled OLE DB for OLAP) and InfoCubes / MultiProviders, created/modified classes, objects, dimensions, measures and details.

Confidential, Austin, TX

BI /BW Architect (SAP BW 7.3)

Responsibilities:

• Datamodel Design blueprinting based on the discussions with the business in war room with business leads.
• Regression testing strategy to ensure end-to-end application integrity
• SPOC for the BI delivery and key responsibility in addition to the BI architect from Global delivery.
• Created the project plan, quality plan, and resource plan for efficient delivery.
• Prepared staffing model to align with estimates and work plans for each team
• Worked in PRM (Partner relationship management) solution, which is based on CRM loyalty management functionality involving complete custom content development and enhancement.
• Managed unit testing and integration of the deliverables. Actively participated with "hands on" approach to analyze build quality with UAT and regression tests.
• Played lead role in the delivery of end-to-end solution, which was appreciated by business users and was handed over to support team after the business signoff and transition.
• Key complexity was to work to start in the project, which had stringent timelines and new solution; this involved a steep learning curve and adaptability to the completely new data model from functional perspective.
• This project was in deep red when I joined the team and managed to turnaround the same while delivering on time and expected quality standards.

Confidential, Lynchburg, VA

BW Analyst (SAP BW 7.0)

Responsibilities:

• SPOC for the the BI delivery which involved preparing the project plan,quality plan and resource plan for efficient delivery.
• Prepared Data model design based on the functional specifications from Business requierement.
• Created technical specifications for the offshore team to build the reports in onsite/offshore model
• Worked in SD (Billing, Purchasing,sales) and FI (GL,AP,AR,AM,PS) and MM involving complete custom content development and enhancement.
• Lead the offshore team for the build of the reports and Data model as per the specifications created.
• Ensured Quality assurance compliance and also defined UAT processes flow for testing.
• Provided the knowledge transfer to the customer’s team and handled the go-live support while ensuring a smooth transition.
• Key complexity was to work in sync with the already existing Data model built by third party and ensuring that there is no redundancy in design.

Confidential, Dallas, TX

BW Developer for HCM (SAP BW 7.0)

Responsibilities:

• Lead the BI Team at customer location for end to end solutions of the 70 Plus HCM reporting which also involved integration with a Project Systems Module .
• The key areas involved Data modeling for HCM in areas such as Personnel Administration (PA), Payroll (PY) and Management dashboards .
• Interacted with the business leads for the reporting requirements and took workshops to get business buying for the requirements and solution proposed.
• Project involved the SAP systems and non-SAP (third party database applications) for the dashboard reporting. The third party systems were connected with the SAP BW with UD connect.
• The HCM reporting supported the reporting of over 50,000 employees at employee level granularity, which involved huge data inflow daily. This was a big challenge and was managed by creating a pseudo delta mechanism for HCM PA extractors.
• Customizing of the HCM extractors to support the complex reporting requirements.

Confidential, Sunnyvale, CA

BI Developer

Responsibilities:

• Delivered BI 7.0 Technical Upgrade on time: Phase1
• Delivered BI frontend upgrade and BI Portal installation.
• Successfully executed the BI New Analysis Authorization security.

Confidential, Austin, TX

BI Lead

Responsibilities:

• Designed the BI security infrastructure per user requirements
• Provided SAP security expertise and best practice knowledge
• Created user testing script for analysis authorization
• Provided documentation and user
• Determined user authorization schema to control information access at their company
• Provided documentation and user .
• Delivered BI 7.0 Upgrade - Authorization Strategy
• Delivered BI 7.0 Implement - Role-Based Access Control (RBAC) methodology
• Trained the Secuirty Team with new BI Authorization concept

Confidential, Allendale, NJ

BW Developer

Responsibilities:

• Worked on Business Content an enhancement using ABAP as well as created custom Info Cube and ODS for the Client Requirements
• Info cubes used in the project
• SD Cubes: 0SD CO1 Customer Cube, 0SD CO2 Deliveries, 0SD CO3 Sales Overview
• MM cubes: 0PUR C01 Purchasing Data, 0PUR C02 Vendor evaluation, 0IC C03, Material movements, 0IC C01, Goods movements,
• FI cubes: Accounts Receivable: 0FIAR C05 Payment History, 0FIAR C02 Transactional Data. Accounts Payable: 0FIAP CO2 Transaction Data.
• Cost Center: 0CCA C11 Cost and Allocations
• Multi Provider: 0SD MCO1 Order and Billing Document,
• HRMS: 0PY CO2 Employee Specific Payroll Data
• Worked extensively with LO Cockpit structures (2LIS 02 HDR, 2LIS 02 ITM, 2LIS 03 BF) in terms of structure enhancement.
• Involved in Info Cube maintenance i.e., Compression, Roll-up. Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Extracting Master & Transaction Data using Generic Data Sources from OLTP.
• Uploaded Transaction Data from the Flat File as the Source System.
• Involved in writing update, Transfer and Start Routines using ABAP Routines at Communication Level in BW.
• Loaded Data into the ODS Object before loading the Data into the InfoCubes.
• Data loading was monitored and the failed data packets were analyzed and manually edited.
• Created multiple queries for sales/purchase stock figures reporting. Defining query in the BEx Analyzer and presenting the result in workbook and integrating the workbook with BEx Browser.
• Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.

Confidential, New York, NY

BI Upgrade Developer

Responsibilities:

• Successfully executed the BI Upgrade Strategy.
• Migrated Bex Reports (3.5) into New BI7.0 Tool Set.
• Resolved many issue around the Upgrade.
• Conducted the User on the New Bex Features.
• Installed and configred the BI Admin Cockpit.

Confidential, Houston, TX

Technical Consultant (BW 7.0)

Responsibilities:

• Blueprint design for the reports in Project Portfolio Management and C Project covering the technical design specifications and data modeling.
• Asistsed to migrate the management-reporting tool built onto the customer application to SAP BW reports. This involved studying the current KPI’s and matching these with backend configuration.
• Gathered requirements from functional Leads and business users in Project System for cross-functional reporting analysis.
• Took customer workshops and live system demos for the reporting possibilities in PPM and Finance to get customer buying for the business solution.
• Defined work packages and technical specifications for design, development, testing and rollout.
• Leading the team in the technical Implementation of the PPM and C-Project reports and integration of these with Enterprise Portals.
• Migration of the old 3.x data sources to BI 7.0 data sources.

Confidential, Houston, TX

SAP ABAP Consultant

Responsibilities:

• Develop programs for data migration from legacy using BDC, BAPI and LSMW
• Develop reports for logistics module for PR, PO, SO, GR
• Modifications of SAP-Scripts, Smart Forms, Print programs, User-Exits.