Data Sap
Resume:
Yun Fee
*******@*****.***
PROFESSIONAL SUMMARY:
Senior SAP BPC Consultant with 8+ years of experience in BPC and adept at designing, implementing, customizing, supporting, upgrading, and migrating reports, input schedules and environments.
Well versed in Planning, Budgeting, Forecasting, and Consolidation (both Legal and Management Reporting) for SAP BPC 10.1 Standard and Embedded models.
Experienced SAP consultant with the ability to lead a team of BPC consultants.
Technical expertise of SAP: BPC, HANA, BW, and Security.
SAP BPC:
Experience with BPC 10.1, BW 7.5 and HANA connectivity including definition and Configuration of Dimensions, Dimension Members, Properties, and Models.
Working knowledge of Logic Script development, Member Formulas, Local members, Data Manager Packages, Package Links, as well as transformation and conversion files for data loads.
Hands on experience in developing functional models like CAPEX, Head Count planning, Sales planning, and Forecast Planning.
Automation of Master data and transactional data uploads from BW/ECC to BPC using standard DM packages.
Expert experience in developing Reports, Input Schedules, custom logic scripts, Excel VBA/Macros, correct usage of BPC EPM functions.
Supporting month, quarter, and year end process automation by using Business Process Flows to facilitate users' closing and reporting activities.
Configured work status for locking/unlocking of transaction data after business has approved the plan/forecast version.
Script logic programming for currency conversions, inter-company eliminations, security set up (task profile, data access profiles, users, and teams), work status settings, Business Process Flows (BPFs).
Executing the optimization tool including light and full optimization on a given model.
Creation of dynamic & static reports, nested reports to optimize the reporting capabilities, input schedules for entering data and reports. Experience in user authorizations.
SAP HANA:
Working knowledge on SAP HANA project implementations with both Native HANA and SAP BW on HANA landscapes.
Worked on Data Modeling, Data Provisioning, Reporting, Security, and Authorization aspects of SAP HANA 1.0.
Experience on HANA Modeling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, and Analytical Privileges.
Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and Info Cubes.
Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical views.
Experience in Data-Provisioning techniques using SLT (SAP Landscape).
Transformation to perform real-time data replication into SAP HANA and real-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.
SAP BW:
Experienced in designing and maintaining data targets such as; Info Objects, DSO, Info cubes, Virtual Provider, Hybrid Providers, and Multi Providers.
Strong experience in BW 3.x and BI 7.x versions upgrades (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 their failures).
Experience in system maintenance tasks (Delta queue cleaning, Setup table deletion & validation).
BW loads automation through process chains.
Worked extensively in SD, MM, PP, and FICO Modules.
Strong in performance tuning (Data loading and BEX reports) and job failure reduction activities.
BW Modeling – Requirement gathering, translating the requirements into BW specific mapping, analyzing existing business processes, and specifying design.
Strong experience in Info Cube (Real-Time Cubes, Basic cubes, Multi-cubes) design, InfoSources, InfoObject maintenance.
Experience in creation of master data and transaction data sources by using views/tables & SAP Queries, Data source Enhancements, variable exits for BEx reports & routines in update rules and transfer rules as per client requirement.
Reporting authorizations, authorization objects & roles. Skills to write routines as per design & debug the ABAP routines.
Customizing using of variables, various planning functions. Process chain maintenance for day today schedules.
SAP Security:
SAP BPC creation of Task Profiles, Member Access Profiles, and assigning write/ read access to Users and Teams.
Working knowledge of SAP BPC Work Status settings and Business Process Flow templates creation.
SAP HANA experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users.
Maintenance and set up of Security roles and objects, as well as, the creation of transports and collection of objects from BW to BPC.
TECHNICAL SKILLS
ERP Packages: SAP Net Weaver 2004s, SAP R/3 4.6,4.7, ECC 6.0
SAP Modules: SAP BI 7.0, BW 3.X, SAP BPC NW, BW-IP, BI related ABAP SAP Business Objects XI R 3.1 & 4.0, SAP HANA Studio
Reporting Tools: BPC EPM ADD-in, FIORI, BEx Query Designer, BEx Analyzer, Workbooks, Web Application Designer, Crystal Reports, XCelsius, WEBI
Functional Module: Logistics (SD, MM), FI (AP, AR, GL)
Programming Languages/Scripts: ABAP, Script Logic, FOX Code, VBA, PL/SQL, C++, Java, .NET, HTML
Databases: SAP HANA DB, HANA STUDIO, HANA LIVE, FIORI, SAP BI/BW Workbench, SQL Server, MS Analysis Services, SSIS, SSRS, Oracle, TERADATA, SYBASE, ESSBASE, TM1
PROFESSIONAL EXPERIENCE
Allison Transmission - Indianapolis, IN Jan 2019 – Current
Sr. SAP BPC Consultant
Allison Transmission is the world’s largest manufacturer of fully automatic transmissions for medium- and heavy-duty commercial vehicles and is a leader in hybrid-propulsion systems for city buses. Unlike manual and automated manual transmissions (AMTs), Allison Automatics have no power interrupts during shift changes. They make the best use of the engine’s horsepower and torque by delivering more of it to the wheels. Allison is also the preferred transmission for alternative fuel applications. With the ever-increasing appeal of natural gas, more fleet owners are specifying Allison Automatics for their natural gas-powered vehicles to reduce emissions and lower noise.
The SAP BPC project had two parallel tracks which on the one hand focused on the optimization of the current BPC system and on the other deliver and retro-fit a 4-release build to meet the reporting needs of the FP&A team. The complex Daily Manufacturing process involved supporting user tickets by meeting strict SLAs and enhancements were made to the existing BPC solution by creating a demand/change, estimating the efforts and the actual build/test/deployment. The project team aimed to deliver the new environment within the project deadlines.
Responsibilities:
Working directly with internal IT SAP Business Analysts, Solution Architects and key business users from FP&A, Finance and Accounting in order to design, implement and support critical business solutions.
Model development for the financial planning with due consideration of the upstream data from ECC to BW cubes and downstream data flow to dashboard and BI reports.
Complex Input Schedule and Report design using multi-model reporting and a host of EPM Functions like EPMRetrieveData, EPMDimensionOverride, EPMSaveData and enabled users to select multiple members.
Used local member formulas extensively to display variances in different layouts.
Implemented the Comments functionality in BPC input forms.
Created Datasources, DTPs, InfoPackages and Transformations for data extractions/loading and processing from/to SAP ECC system.
Written Functional/Technical specification documents for ETL and calculations based on interaction with business.
Build mock-ups of input templates and reports for user sign-off before actual development.
Use of multiple EPM Formatting sheets to meet the reporting needs.
Enhancement to the current system through transport of BPC objects and further test in Quality system.
Built Reconciliation reports to compare the system calculations through BADIs and script logic with manual calculations.
Transformation File, Conversation File and Data Manager Package and Package links management and scheduling.
Wrote Script Logic to calculate Direct/Indirect Actual Hours per Unit based on a matrix of parameters like Equivalent Service Unit of cost center/ Plant, Labor Hours and Absent Hours.
Assisted in the debug of ABAP BADIs (custom logic and write back) using UJKT t-code.
Technology of business warehouse (SAP BW), data extraction/retraction from SAP-system and non-SAP system, process chains, data model development, integration.
Programming skills ABAP, SQL, VBA.
Experience in Planning and Budgeting, Management Consolidation, Legal Consolidation System Development, and Implementation.
Customizing the Reports, Input Schedules, Logic to meet the specific needs of the client using supported functions with BPC.
Integrated Workday data to the BPC system to calculate Labor Hours and Labor Dollars by different Tiers.
City of New York - DOITT - Brooklyn, NY Jan 2017 – Dec 2018
Sr. SAP BPC Consultant
The New York City Department of Information Technology and Telecommunications (DoITT) is the department of the government of New York City that oversees the City's use of existing and emerging technologies in government operations, and its delivery of services to the public. The New York City Department of Information Technology and Telecommunications (DoITT) is a Mayoral agency charged to modernize the City's IT infrastructure, make City government more transparent and accountable to taxpayers, and use innovative solutions to improve the delivery of City services. DoITT operates from five locations across two boroughs.
The objective of implementing SAP BPC was to improve the current Planning, Budgeting, and Forecasting process and reducing the time and effort to create planned financial statements and reports. This was possible through the removal of duplication of common assumptions and drivers across the project, which reduced the number of operational errors in processing of data. This resulted in better control and assurance in the integrity of data.
Responsibilities:
Business Requirement gathering, and Blueprint preparation and presentation.
Model development for the financial planning process with respect to blue print and requirement analysis.
Input Schedule and Report design with the use of EPM Functions.
Data extractions/loading and processing from/to SAP ECC system.
Build EPM Reports as per user requirements (building complex reports with Macros to perform EPM functions, Copy range Functions).
Formatting of the Reports using the standard EPM formatting sheet.
Enhancement to the current system (Reports, Input templates, Distribution of reports), Maintaining properties and hierarchies within Dimensions.
Reconciliation of the Headcount Data with BO reports and BPC reports.
Script Logic writing, member formula, dimension aggregation customization for calculations at Model level for reporting requirements.
Business Process Flow and Business Process Instance Management.
Task Profile creating and Instance management for Access and Process Initiations.
Technology of business warehouse (SAP BW), data extraction/retraction from SAP-system and non-SAP system, process chains, data model development, integration.
Reporting system with SAP BEx Analyzer, BO Web Intelligence.
Building web application (SAP BEx Web Application Designer).
Programming skills ABAP, SQL, VBA.
Experience in Planning and Budgeting, Management Consolidation, Legal Consolidation System Development, and Implementation.
Customizing the Reports, Input Schedules, Logic to meet the specific needs of the client using supported functions with BPC.
Transformation File, Conversation File and Data Manager Package management and scheduling.
Data extractions and Processing from BI system.
Data Loading and Process Testing for Data from BI to BPC.
Loading transactional data from Info Provider in BW to the BPC Environment using the Data Manager in BPC for Validating and Previewing Data.
Configuration of Business Rules, Script Logic, and Member Formulas for calculations.
Vertex Pharmaceuticals – King of Prussia, PA Aug 2015 – Dec 2016
Sr. SAP BPC Developer
Vertex Pharmaceuticals Inc. is an American pharmaceutical company headquartered in Boston, MA, and is ranked among the top 15 best performing companies on the Standard & Poor’s 500. Its annual revenue is over $17 billion.
Pharmaceutical industry decommissioning their BPC 10 MS version of Planning & Consolidation system and focusing to implement Embedded BPC on AWS cloud to align with the future migration strategy of S4HANA and Strategic Reporting system for Vertex.
The Enterprise Business Intelligence team implemented a unique solution to help expediate the consolidation process. Using a variety of different technologies Accounting and Finance users could access a single dashboard that provides insight to the consolidation process – helping to understand gaps and areas for review. Data is sourced from a combination of different systems, including SAP BPC for dashboard reporting.
Responsibilities:
Conducted brainstorming sessions to align Planning and consolidation implementation with future S4 Finance system.
Designed HANA views of ACDOCA & ACDOCC structures and integrate data layer from ECC.
Built real time info providers and aggregation levels for Exchange rates, Ownership rates and Consolidation data.
Built Composite providers to consume Historic & ACDOCA data for consolidation.
Constructed multiple composite providers to ease business user reporting requirements.
Built reconciliation reports for Currency rates & Master data maintained in ECC tables through virtual providers.
Designed data flow architecture from source systems JDE/EDW/Work day.
Structural mapping and conversions of master to BPC.
Designed scripts to handle Currency conversion without business rules.
Achieved elaborated reporting capabilities on total number of product units sold based by different packet size through conversion of Product units to Single units.
Designed script logic - Copy tax account data from No channel to Distributor Entities.
Automate adjustments for OCNIS (Other Costs not in standard) to the departmental expenses on Quality Assurance/Check.
Provided EPM Add-in Input schedules/Forms for data collection related to Adjustments/Tax/Depreciations.
Supported Financial closure cycles. Maintained integration points. Scheduling planning areas to automate closure activities.
Prepared Functional and technical specification documents for BCF, Currency translations, IC Eliminations & Consolidation of Investments, Work status, Security & BPF.
Built business rules and task sequences for Carry forward, Currency translations, Eliminations.
Achieved retained earnings calculation through account transformation rules.
Designed logics for computing P&L to RE via Journal Entries by planning functions - FOX scripts.
30%-time reduction in closure cycle through simpler, faster, automated controls and validations to check and enforce data consistency at entity level.
Designed Journal templates, allowing Group Accountants and Controllers to enter adjustments at entity/group level through journals at site.
Delivered seamless integration of business teams and processes through Business process flows and work status, providing data locks after each financial process.
Designed input queries in BEX and templates for reporting financial statements - Balance sheet, Income statements, Statement of Equity, Cash flows with drill down at PC.
Built calculated key figures for management reporting.
Captured consolidation team structure and implemented analysis authorization to restrict users based on their role in reporting system.
Designed data access profiles and teams to provide User community with right data set and execution authorization level.
Conducted workshops to demonstrate the reporting features and flexibility for Excel based add-in Analysis for Office.
Consumed functions, calculations, cell-based formatting, variable passing, filters, conditional formatting to enhance User experience with AO reports and input forms.
Support work status and reporting issues.
Capital One - Dallas, TX May 2013 – Aug 2015
SAP BPC Consultant
Capital One Financial Corporation is a bank holding company specializing in credit cards, auto loans, banking and savings products headquartered in McLean, Virginia. Capital One is the eighth-largest commercial bank in the United States when ranked by assets and deposits and is ranked 11th on the list of largest banks in the United States by total assets. It is ranked #100 on the Fortune 500, #17 on Fortune's 100 Best Companies to work for list, and conducts business in the United States, Canada, and the United Kingdom. The company helped pioneer the mass marketing of credit cards in the 1990s, and it is one of the largest customers of the United States Postal Service due to its direct mail credit card solicitations. It is also the 5th largest credit card issuer by purchase volume, after American Express, JP Morgan Chase, Bank of America, and Citigroup.
Based on decisions to centralize accounting and reporting for Finance, and due to the limited growth and scalability of the current system, the decision was made to replace the current system and all necessary interfaces with SAP’s integrated finance and risk platform, which will support the finance and risk processes/reporting requirements.
Responsibilities:
Deployed as SAP BPC Consultant for the Capital One BPC 10.1 Consolidation project.
Responsible for creating, documenting, and implementing a scalable solution design and implementation plan.
Provided technical expertise and hands on implementation work during critical project milestones.
Assisted and/or lead pre-sales activities as needed to develop solution offerings and presentations, and to demonstrate, present and explain services offerings to prospective clients.
Led the onshore and offshore team to build a consolidated reporting model in BPC 10.1. Configured and implemented Inter-company Eliminations for Revenue, Receivables Payables, Investments, and Capital Accounts.
Performed hands-on configuration of top-sided adjustments to provide reclassifications and reconciliations across all levels including summary as a separate ledger or category.
Prepare Consolidated Financial Statements in USGAAP and IFRS.
Perform SAP BPC 10.1 Planning, Budgeting, and Forecasting with Logic Scripts.
Perform Intercompany Matching, Booking and Eliminations.
Create SAP Business Objects Dashboards for clients.
Monitor and Report Project information.
Prepare Earned Value Analysis Reports.
Calculate Cost Variance and Schedule Variances of Projects.
Preparing training materials and videos.
Create Analytic, Calculation and Attribute views and Decision tables in SAP HANA and use the views to create interactive SAP Business Objects Dashboards and in SAP Lumira.
Gather and Review Business Requirements.
Understand Business Needs and Pain Points with the existing systems.
Perform GAP Analysis and ensure Business needs are covered.
Create functional and technical specification documents.
Propose several alternate Design Solutions.
Troubleshoot existing configurations.
Streamline Business Processes with SAP BPC BPFs.
Design the BI systems while ensuring optimal integration between the enterprise systems like ECC, BW, HANA, BPC & BOBJ.
Co-ordinate Design & Build Workshops.
Create Dimensions and Models for Budget, Planning, Forecasting & Consolidation functionality.
Create and Maintain BPC Master Data & Hierarchies.
Create Reports and Input Schedule Templates.
Provide application security and maintenance of user profiles and privileges.
Provide system documentation and end-user trainings.
Manage Project & ensure deliverables are met as per plan.
Set up project review meetings with Business and IT teams.
Recommend SAP Financial and BI solutions as per client future requirements.
Ensure SAP Best practices are followed.
Define SAP HANA Tables and loading data into the tables.
Create BEX Queries with Formulas, Restricted Key Figure, Calculated Key Figure, Exceptions, Replacement path variables, OLAP Variables and Conditions.
Create Info cubes and Data store objects after extracting ECC Data -into SAP BW.
Designed and implemented currency conversion business rule to use appropriate rates for Actuals and to plan all reporting allows for home and local currency.
Nissan – Middle East Nov 2012 – Mar 2013
SAP BPC Consultant
Nissan Motor Company Ltd, usually shortened to Nissan is a Japanese multinational automobile manufacturer headquartered in Nishi-ku, Yokohama. The company sells its cars under the Nissan, Infiniti, and Datsun brands with in-house performance tuning products labelled Nismo. Nissan provides unique and innovative automotive products and services that deliver superior measurable values to all stakeholders in alliance with Renault.
The objective of implementation of SAP BPC 10.1 was to replace the legacy system for Planning, Budgeting, and Forecasting and Reporting and mapping the processes to SAP BPC Planning scenarios. A single system that caters to business requirements and reduces reliance on legacy applications and improve internal controls through a single database repository for all the data.
Responsibilities:
Reviewed the different Planning and Forecasting scenarios – Inventory, Manpower, CapEx, OpEx & Revenue planning.
Analyzed the logic scripts, BADIs, input templates and reports used in rolling forecasts and what-if simulations.
Observed the data flow within the models, master data maintenance and flat file load of transaction data.
Maintained dynamic formatting in reports and input templates along with the use of Macros to trigger data manager packages.
Lead the design, development and support of the enterprise-wide ERP BI/BPC solution as well as providing technical leadership to the SAP BI/BPC development team.
Shepard intake items that come into the intake process; providing guidance and input to individuals as they move their items through the process.
Implemented enterprise architecture artifacts, such as target and current state architecture, referential patterns, roadmaps, and technology standards.
Provide practical knowledge of technical design and solution architecture alternatives and the implications of each approach.
Provided overall leadership for the technology solution architecture, design, and delivery of the BI/BPC environment including both onshore and offshore.
Involved in business requirement gathering for Legal and Management consolidation and defining chart of accounts.
Involved in integration and conversion from Hyperion Planning to SAP BPC.
Configured the dimension properties sourced from various modules like PS, SD, CRM, HR, and FICO.
Configured applications for Planning and Budgeting like Projects, Opportunities, Risk Reserves, and Summary.
Designed templates for G&A planning for employee and cost center based for salaried and non- salaried.
Used BADI to summarize data from Cost center to Profit center from various applications to summary application.
Worked with Hyperion Planning templates to perform reconciliation activities with SAP BPC.
Involved in setting up the process for both Transactional and Master data from ECC to BI to BPC.
Developed Custom Input Schedules for spreading Cost and Revenue based on Project and calculate Earnings.
Fauji Fertilizer Company Feb 2011 – Nov 2012
SAP BPC/BW Consultant
The initial share capital of the company was 813.9 million. The present share capital of the company stands above 8.48 billion. The facility is designed with an annual capacity of 551,000 metric tons of urea and 445,500 metric tons of DAP.
The primary objective of the project was to integrate all business processes across the organization, under a single SAP platform with minimum interfaces. The elimination of duplication of activities across business processes by capturing data at source point, which resulted in improved responsiveness to changing business scenarios. The development of history of various types of data for statistical analysis and decision-making systems.
Responsibilities:
Gathered the requirement for blueprint, build, the consolidation, planning, budgeting, and forecasting functionalities. Maintain connectivity between R/3, BI & BPC systems, extract data from data sources, replicate the Meta data in BI as well as create transformations and data transfer processes to the BI targets and finally load data to data targets.
Prepared the documentation on the input template and data extraction of consolidation and planning requirement.
Designed and Developed Dimensions, Applications, Script Logic, and Business Rules required for Budgeting and forecasting solution.
Created and modified Applications by adding new members and updated dimension properties in applications.
Optimized various data storage types to compress database improving system responsiveness and performance.
Worked extensively on Worksheet Logic, Script Logic, Dimension Formulae, and Dynamic scripting.
Designed and developed Reports using EVDRE and other EV functions.
Designed and developed Input Schedules using EVDRE and other EV Functions.
Data management and loading of transaction data to BPC using the data transformation, conversion logic, Master Data loaded to a BPC Dimensions. Validation of data loaded.
Designed and developed Transformation Files, Conversion Files and Packages required for loading data from Flat files, External systems, and BW system.
Worked on BPC application architecture, performance enhancement using Light and full optimizations.
Process chain development to support master data loads from BW to BPC.
Develop the planning and consolidation reports using the BPC reporting services and EVDRE.
Developed Macros using VB script in reports & input schedules to trigger BPC functions using MNU commands.
Developed reports using functionalities like page key range, col key range, Expand range table in EVDRE function.
Participated in the daily meetings with the on-site coordinator to discuss the deliverables. Involved in workshops for requirement gathering and prepared the design document.
Prepared the business user training manual.
Environment: SAP BW7.3, SAP BPC 7.5 Net Weaver, ECC 6.0, ABAP Development workbench, BEX analyzer/Browser.
Teletech - Sky Broadband Apr 2008 – Feb 2011
SAP BW Consultant
Sky Broadband is broadband service offered by Sky UK in the United Kingdom. With the introduction of Sky Fibre, Sky Broadband refers to ADSL broadband products. In October 2007, Sky reached the 1 million mark in terms of customer numbers. By July 2012 Sky had reached 4 million customers and unbundled exchanges covering over 70% of the United Kingdom.
The SAP data warehousing deployment for corporate BI reporting was a vanilla implementation, SAP BW queries were BI content standard queries and 10% custom development was part of the user requirement. SAP BI application tools read the data through SAP BW queries connected through direct access method. The accessibility of reports and dashboard and their formatted result values were based on assigned roles and authorization.
Responsibilities:
Involved in gathering user requirements, design, and development and testing of data models for Logistics.
Worked on administrator workbench, and customized Info Objects, Info Sources and created Info Cubes by loading data based on Transformations.
Involved in performance tuning while reporting and data loading.
Involved in modeling the dimensions of cubes.
Involved in Business Content installation of Data Sources and Info Cubes and all related objects.
Involved in query performance tuning using tools such as RSRT (Query Performance Monitor), RSRTRACE etc. and other transactions such as ST03.
Developed Multi providers to enhance reporting performance and flexibility.
Performed Enhancements to SAP delivered data sources using SMOD transaction.
Extracted user defined Database tables, Views on Sales, Delivery, and Customer tables from R/3 system using Generic Extraction.
Involved in Logistics Extraction and COPA Extraction for profitability analysis.
Implemented Generic Extraction for user defined tables.
Loading data from the flat files on daily basis.
Populated DSO Objects Info Cubes and Info Objects with Master and Transactional data from SAP R/3 via Data Staging area (PSA).
Increased performance tuning by maintaining aggregates and Info cube partitioning.
Developed process chains to automate the data loading process.
Developed Logistics reports for Sales, Open orders, Order Fulfilment, Incoming orders etc.
Environment: SAP BI 7.0 Net Weaver, ECC 6.0, ABAP, BEX analyzer/Browser, SD & MM.
EDUCATION
MBA, Finance, Samata College, Visakhapatnam, 2003.
Bachelor of Commerce, B.V.K. College, Visakhapatnam, 2001.
Timpany School, Visakhapatnam, 1998.
Certified in SAP BPC.
Contact this candidate