Yun Fee

732-***-****

ac69ex@r.postjobfree.com

PROFESSIONAL SUMMARY:

Senior SAP BPC Consultant with 12+ 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.4 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, 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

City of New York - DOITT - Brooklyn, NY Jan 2017 – Current

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.

Input Schedule and Report design with the use of EPM Functions.

Design of application model and development.

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 BPC formatting.

Enhancement to the current system (Reports, Input templates, Distribution of reports) Maintaining 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.

Creating OLAP Universe (*.UNV, *.UNX). Development of analytical reporting BO WEB.

Experience in Planning and Budgeting, Management Consolidation, Legal Consolidation System Development, and Implementation.

Model Design with respect to blue print and requirement analysis.

Input Schedule and Report design with use of EPM Functions.

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.

Enhanced User experience on EPM reports for P&L, BS and standard comparative reports through VBA based APIs.

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 skull 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 S4 HANA 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.0 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.

HSBC – Hyderabad, India Oct 2005 – Apr 2008

SAP BW Consultant

HSBC Holdings plc is a British multinational banking and financial services holding company, tracing its origin to Hong Kong. It is the world's seventh-largest bank by total assets and the largest in Europe, with total assets of US$2.374 trillion. In India, the Bank offers comprehensive suite of world-class products and services to its corporate and commercial banking clients as also to a fast-growing personal banking customer base.

The SAP BW system was configured primarily to stage information from various data sources in various forms including personalized reports, freely definable queries, and predefined reports. Recipients could use these reporting and analysis functions to analyze the data for deviations and significant facts.

Responsibilities:

Designed and Created estimation model for BW implementation based on the scope of the requirements and prepared technical specification documents.

Performed requirement gathering, data modeling, plan/scheduling data input from source systems, interface with users for standard reports, gap analysis, and associated solutions.

Worked with Business Users and Functional teams during JAD sessions and assessing the work based on SAP best practices.

Lead the process and developed flows in the areas of OTC for service metrics, open orders, and overall sales view reports.

Was involved in upgrade from BW 3.5 to 7.0 and solving the issues that arise during upgrade.

Designed and Developed Inventory Management report by integrating data from MM, SD, P2P and APO.

Designed and developed the Global spend application to manage category of spend using Purchasing and accounts payable (AP).

Designed and developed Freight payment application as business need to track freight invoice detail information for analytics using Accounts Payable (AP) and Transportation.

Designed the flow for calculating the average selling price based on the sales view of customer/material and consensus demand, Forecast Accuracy, Dollarized Forecast, VMI Performance, etc. from APO.

Creating business blueprint for the financial planning and forecasting for the different brands.

Assistance in the installation of SEM 3.2B on an existing BW 3.1C system.

Design, configure and develop expense, sales, inventory, and P&L planning cubes (transactional cubes).

Develop Planning areas using the SEM cubes for Plan and BW basic cubes for Actuals.

BCS to consolidate financial data for statutory and management reports.

Responsible for support and enhancing BCS module.

Create multi-planning area to integrate expense, sales, and P&L planning areas.

Create multiple planning levels and packages in both single and multi planning areas to suit the Business requirements.

Provided training and user acceptance sessions as well as training documentation.

Created Custom Universe objects using Business Objects (BO) based on reporting requirements.

Created Live Office Document based on WebI document and importing to Xcelsius.

Created dashboards using Xcelsius for PNL report to provide overall sales by division.

Developed complex queries and formatted them in Crystal Report and published then in CMC.

Involved mainly in design phase of the project for implementing SAP BW FI module & BPS.

Responsible for SEM BPS development for custom developed Planning Areas for Sales Merchandize. Used FOX and ABAP for complex planning functions involved.

Proficiency in the areas of data modeling, extractions gathering requirements from the users, creating reports with BEx, Web Reporting, Performance issues, data loads, process chains, support, and user training.

Used standard and created generic data sources for building Cubes/ODS for GL, Cost Center Accounting (CCA), Special Purpose Ledger and Profit Center Accounting (PCA).

Created complex BEx queries based on the user requirements showing the Balance sheet and Income Statement by using advanced features of the query development.

Build complex Crystal

Contact this candidate