CURRICULUM VITAE of Frank Song (Page * of *)

Objective

Expertise

Frank Song

** ********* ********

Ottawa, Ontario Tel: +1-438-***-****/+1 (613) 909- 2060 Canada Email: adnecn@r.postjobfree.com

SAP ECC Payroll/SuccessFactors EC/SAP SuccessFactors ECP Consultant, SAP HCM System Analyst, SAP HCM Business Analyst, SAP HCM integration consultant, SAP HCM Solution Architect.

• SAP Certified Payroll/SuccessFactors EC/SAP SuccessFactors ECP Consultant with more than 10 years of professional experience in SAP HCM including project plan, scope, fit/gap analysis, blueprint, design, development, testing, end - user training, rollout, and post- implementation support for Public and Private Sector clients.

• Extensive technical skills in solution program design, PCR (personnel calculation rule) creation and changes, customized operation design and realization.

• A self-motivated professional working independently and in a team environment with extensive practical industrial experiences on various HCM projects, excellent communication and project management skills, strong leadership skills and problem-solving skills. SAP HCM Skills:

• Payroll Configuration/customization • Enhancement of SAP standard programs

• ABAP debug for customized codes • Idoc processes and enhancement

• Payroll and Time management integration • Payroll and 3rd party systems integration

• Query SQ01 • Payroll and FICO/BI integration

• HCM and Workforce and Ariba integration • SuccessFacts EC/ECP Technical Skill

• ECC/Database/BI ETL Environment: SAP R/3 4.7, ECC6.0, HANA 1.0, HP Quality Center, SAP Solution Manager (ChaRM), Excel, Flat file.

• SAP Cloud: OData, JSON, XML, CPI (SAP Cloud integration)

• HANA: CDS (core data service)

• Programming Languages: ABAP, SQL.

• Web Design & Applications: UI5 and Fiori.

• Platforms: Windows XP/Vista, Windows server 2000/2003, Linux/Unix.

• Office Productivity: PowerPoint, Word, Excel, LaTeX, Illustrator, Photoshop, and Lotus Notes.

• BI Reporting Tools: Query Designer, Web BEx Analyzer, Crystal Reports Career Profile

CURRICULUM VITAE of Frank Song (Page 2 of 4)

IBM SAP Senior Payroll Consultant

SAP Payroll support Halifax, NS, Canada 2019-Present

SAP payroll Control Center project, blueprint, realization

Support SAP Payroll systems for multiple PNS clients,

Core module modification with SAP standard function KAPRC for concurrent employee

Detail analysis for FICO posting, off cycle posting, union due issues

Created wage types and modified PCRs

Create absence valuation rules, mapping absence types with wage types

Cooperated with security team, resolved authorization issue Mondialric SAP Payroll Analyst

Project: SAP SuccessFactors ECP implementation Toronto, ON, Canada (2019.-2020)

Defining payroll project implementation and support strategy for business initiatives in a consultative approach providing expertise on a variety of payroll related subjects including preparation, blue printing, realization and going life design.

Implementing requirements gathering and analysis for the as is and to be processes. Participating in cross-functional focus groups targeted at creating consensus among disparate functional teams required to solve complex business problems and various business scenarios in payroll domain. Performing configuration, customization activities.

Communicating and collaborating with project teams and application owners to ensure that the ERP solutions being implemented are designed to facilitate the generation of proper metrics.

Actively participating in the development and implementation to design, build and implement solutions.

Leveraging SuccessFactors ECP implementation and existing HCM system, developing the optimal path for data extraction, cleanse, migration, new ECP system activation, configuration and enhancement strategy and timelines.

Canada Post/Innovapost SAP Payroll consultant/solution lead Project: Employee Collect Agreement changes Ottawa, ON, Canada (2012- 2019)

Participated in design, development and maintenance of SAP Payroll projects for Union Collect Agreement change projects, worked in full project life cycle and multiple releases which include requirements gathering, design, development, implementation, and production support.

Worked on functional/technical specifications with user community to understand and define business requirements. Conducted business analysis and functional design activities for system modification solutions.

Led successful project implementation and customized reports. Created knowledge transfer documents and trained users for new processes.

Worked in HP Quality Center to define defects fixing and testing priorities, identify changes, analyze technical impact, evaluate business risk, fine-tune test strategy and create test execution plan.

Documented test plans and complete Unit Test of developed reports. Created test methodology and criteria and implemented SAP Integration projects test in global environment.

Professional Experiences & Employments

CURRICULUM VITAE of Frank Song (Page 3 of 4)

Created wage types according to the requirements matrix, reviewed payroll schema, modified existing PCRs (personnel calculation rule) and created new PCRs, fully tested business scenarios, including FICO posting, 3rd party posting, T4, T4A and tax cross year outflow inflow.

Designed customized payroll operations, cooperated with ABAP, BASIS, EDB (enterprise data broker) and operation teams. Identified issues by debugging new programs and tested thoroughly.

Created new jobs, designed the dependency, modified the runbook and year-end checklist.

Created implementation plan, detailed tasks, dependency, resource, backup resource, time and date, monitored the implementation process, organized walk through and called meetings for emergency change and communicated with client the status.

Created/changed PCRs (personnel calculation rule) for vacation cumulation and payout, holiday calculation

Configured Payroll system according to the Canada legal, Canada Post unions and Canada Post requirements, such as configured many wage types, absences and attendances

Designed programs to integrate to payroll system with third party systems, such as integrated WorkForce System with SAP HCM/Payroll

Designed enhancements and led a team to realize the solutions, such as enhanced ROE program for STDP (short term disability program) employee ROEs

Designed Union reports

Worked with Organization management, Personnel administration, Time management and Benefit modules

Worked with SAP stack upgrades, SAP system data center move, run book changes, years end analysis, testing and run books

Created implementation plans, monitored the progress and adjusted steps and cooperated with different departments

Configured new garnishments and change benefit sale taxes.

Year–end, support stack notes analysis and implementation.

Outflow-inflow incidents analysis.

City of Edmonton SAP senior HCM/BI Consultant

Project: SAP HCM BI budget report Edmonton, Canada (2011-2012)

Designed queries in BEx Query Designer and created workbooks and BEx report in BEx Analyzer using Formulas, Selections, conditions, Structures, Calculated and Restricted Key Figure and Variables with User Entry/Default Value

Created Info object, ODS, Info cube, and Multipledataprovider, developed info package/transfer rule/update rule/transformation rule

Developed BI environment architecture with planning areas, planning levels, planning packages and planning functions/sequences, developed Transactional/Real-time Infocube for BI Planning, created SAP BI reports including Plan/Actual variance measures, revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency

Involved in the scheduling and monitoring using process chain in Administrative Workbench. Created Process chains and Scheduling of data loading with Full/Initialization/Delta upload method, developed Transformation Rules and ABAP user exits for transaction & master data in start/end and update routine, generate export Data Sources to transform data from one InfoCube to other Info Cubes, worked on custom cubes.

Involved in the postproduction support and user authorization, including Infocube management using Compression, Rollup, Reconstruction, Index and Partitioning and performance tuning using

Aggregate, pre-calculation and MultipleDataProvider. Tested the developed objects and participated in change control team for defect prevention/correction to approve CURRICULUM VITAE of Frank Song (Page 4 of 4)

Education

Language Ability

Qualification

changed/additional requirements. Defined phases for requirements that were not critical for initial go-live.

Open Text Inc SAP HCM/BI/SD/FICO Analyst

Project: Global acquisition employee migration Toronto, Canada (2006-2011)

Configured SAP HCM system, including organization structure, payroll areas, wage types, benefits, absences and attendances, PSAs (personnel Subareas) and ESGs (Employee Subgroups).

Working with PA dynamic action for different grouping employees to have different benefit and vacation entitlements.

Involved in BI system implementation project, worked as HCM SME, provided analysis of HCM system configuration and customization lists, organization structure and customized reports, Communicating and collaborating with project teams and application owners to ensure that the BI solutions being implemented are designed to facilitate the generation of proper metrics.

Supported BI and HCM system, including resolving incidents and delivered change requests

Worked on global employee acquisition projects, including extract data from original system, analyzed the quality of the data, cleansed the data and modeled the data, migrated data to HCM system, monitored BI system and verified the reports, adjusted or modified BI system objects, including cubes ODS and MultipleDataProviders and so on.

Worked for design, development and extraction of data from various source systems. Defined the initial sizing requirements based on source data volume estimates. Cleansed data and defined data selection for data modeling based on requirement analysis.

Designed BI data model for decision-making for financial data. Designed, built and maintained the daily reports for BI application to assist decision making.

Monitor the development of data model to satisfy the various functional requirements. Implemented explanatory and decision-making models for finance time series data and to realize decision-making strategies simultaneously.

Supported SD and FICO application systems.

JIT consulting Inc SAP HCM consultant

Project: various projects Changchun, China (1993-2006)

Responsible for the creation, implementation and maintenance of configuration, production support and documentation of different departmental and ERP application systems.

Designed solutions for change requests

Gathered business requirements, configured SAP HCM functionalities

Trained business users

M. Sc. in MBA Jilin University Changchun, P. R. China (2001) B. Sc. in Computer Science East-North University Changchun, P. R. China (1993) Chinese (native), English (fluent)

Certified in SAP SuccessFactors Employee Central Payroll 2019 (ID: S0003799768)

Certified in SAP SuccessFactors Employee Central 2019 (ID: S0003799768) CURRICULUM VITAE of Frank Song (Page 5 of 4)

Certified in SAP HCM Payroll, NetWeaver SAP HCM payroll 2016 (ID: S0003799768)

Contact this candidate