Summary of Qualifications:

• 8 years of business functional expertise inSAP HCM Time Pay and30 years IT experienceas a Systems Analyst/Data Scientist/Quality Assurance Analyst.
• Broad background of experience having years of experience supporting both Customer Service and Enterprise functions such as HR and Finance. Extensive experience in both Business Process Functional and Technical areas.
• Deep SAP integration experience in the HCM Time Pay module with Finance, Controlling, Enterprise Asset Management, Operation Support, Accounts Payable.
• Deep SAP HCM Time Payknowledge in Time Entry, Time Data Transfer, Time Data Evaluation, Payroll, Posting to Finance, Posting to Controlling CAT7 , Posting to Plan Maintenance CAT9 , Interfaces, Interface Controlling, Contract Interpretation Rules for Represented Time Entry , Vacation Quotas, Time Configuration, Month-end closing for Labor Accounting, and W-2 year-end reconciliations.
• Drive towards optimal solutionsutilizing extensive Process and Technical expertise while working together with operating unit clients.
• Re-engineer business processes to streamline and automate the Month-end, daily and bi-weekly processes for Time Pay. Incorporated SAP Process Models and job step optimization into Month-end. This resulted in an 80 reduction in run times and a 70 increase in accuracy for the Month-End, enabling timely completion by Accounting of their own Month-end process.
• Full SAP Life Cycle experiencein Blueprint, Gap analysis, Design, Build configuration/development , Testing, Organizational Readiness, Cutover, to Post Production Support.
• Leveraged MS Access and SQL Server skills to generate over/under payment statements/letters/packets for impacted employees as part of IBEW Contract Interpretation phases one and two. Worked with the business and the legal team to follow up on overpayments to employees. Testified at a trial involving an employee contesting their statement. Approximately 1million in overpayments was successfully recovered from employees.
• Update Disability design documents based on client requests and deep research into the current state ensuring that the requested changes will meet the business needs and be cost effective.
• Work with the business to identify gaps and solutions in current and proposed Time Pay processes.

Notable Skills and Competencies:

• Use excellentanalytical skillsto identify and resolve system issues in areas including Contract Interpretation, Vacation Quotas, Time Schema, Month-end closing, and W-2 year-end reconciliations.
• Demonstrate excellent interpersonal skills in written and oral communication and relationship building with peers, management and clients promoting effective solutions.
• Effectively analyze data using MS Access, Excel, SQL Server, Oracle, and Python to resolve data inconsistencies, validate retro-active under/overpayments, implement workarounds for system limitations andvalidate cutovers and mass data updates in production and system test.
• Perform thorough testing of changes ensuring high quality production software.

Professional Experience:

Confidential

SAP HCM, Time/Payroll Systems Analyst

• Manage the successful execution of HCM Time Pay jobs including CAT7, CAT9, ZHRCATSUP, CAT6, Time Evaluation, and Payroll.
• Perform Month-End Reconciliation between HCM and Finance.
• Implement configuration changes for Wage Type modifications especially related to the Time and Pay/Finance interfaces. Thoroughly test to ensure high quality.
• Data Analysis and troubleshooting in situations where data appears inconsistent using multiple tools for analysis including MS Access, SQL Server and Excel.
• Support Corporate Payroll in the W-2 and related year-end reconciliation activities.
• Work with the business to identify gaps and solutions in current and proposed processes.
• IT on-call support for time and payroll jobs for the bi-weekly payroll process and the month-end process.
• Maintain the Contract Interpretation SQL Server database and produce employee data packets when needed.
• Collaborate with different organizations including Corporate Payroll, T D, and Finance in resolving possible differences between Labor Accounting and posting to Finance.
• Perform thorough testing of changes insuring high quality production software
• Migrate and clone employee data between different SAP environments using Data Sync Manager DSM and LSMWs.
• Participate in technical training classes and technical events.

Conversion Architect HCM

• Individually handled 18 ETL Extract, Transform and Load Conversion objects for HCM Master Data from design to successful loading into SAP and BI. Extensively used AscentialDataStage and LSMW SAP tool to perform ETL and post-run analysis. Developed complex SQL queries for data profiling to analyze and evaluate data quality, consistency, and volume.
• Performed analysis of Functional Design Specifications FDS , and Technical Design Specifications TDS . Conducted technical reviews of code and unit test results to determine accuracy.
• Accurately analyzed testing output data from both a high level and detail perspective to identify differences with expected results. Accounted for all records in conversions and documented results in a method easily used by the process team. Madesound decisions under pressure.
• Created and recommended optimal strategies while ensuring that the application meets the enterprise level standards.
• Interfaced effectively and collaborated with clients, peers, and management to develop solutions, resolve problems and ensure stakeholder buy-in. Identification of cross-functional strategic impacts.
• Demonstrated the ability to take initiative and accountability for achieving optimal solutions.
• Extensive interfacing and coordinating with Process Team and Developers to quickly analyze and resolve all problems encountered in systems requirements, coding, testing and implementation.
• Used conflict management skills when disagreements arose.
• Produced quality results even with the fast pace of the ERP environment by prioritizing effectively. Demonstrated leadership and the ability to effectively organize and prioritize concurrent tasks. Knowledge of SCE business enables me to be customer focused and to respond to customers' business needs.
• Participated in SAP workshops in the HCM area.

Data Analyst, Enterprise Information Management EIM Team

• Performed Data Assessments for the EIM team.
• Developedqueries to extracting the data and produced output in the form most usable by the clients.
• Researched and produced reports in the Ad-hoc Reporting area based on requests from business clients, determining exactly which data they needed. Researched to determine the most useful source for the data.
• Provided decision support for CSBU.
• Trained in Ascential software.
• Used Erwin for data modeling.
• Completed Data Reconnaissance of data in the legacy systems, analyzing it and classifying it by type with special attention given to locating of Master Data.
• Utilized Oracle, DB2, SQL, Meta5, SAS, and MS Access to extract and formulate results.

Application Developer, CSBU Systems

• Designed, Coded, Tested, Maintained and Supported the FOD Field Order Dispatch system.
• FOD sends orders such as Turn On orders to laptops in the field and receives completion data for processing in billing.
• FOD's mainframe component is both on-line and batch in COBOL on IBM mainframes. The server software is proprietary from MDSI. The communication between the mainframe and the servers is via MQ.
• Software used includes DB2, COBOL, Oracle, SQL, and MQ.

Consultant

• Designed, Coded, Tested, Maintained and Supported systems involving Marketing, Client Set Up and Report Set Up at American Express.
• The systems were both on-line and batch in COBOL on IBM mainframes.
• Software used includes DB2, COBOL, COBOL-370, IMS DB/DC, Micro Focus Cobol, ChangeMan, Job Trac and Easytrieve.

Systems Analyst

• Performed Analysis, Design, Coding, Testing, Implementation, and Maintenance work on systems in the Meter Reading, Billing, Field Services, and Credit areas.
• Worked on both IBM mainframes and PCs.
• Mainframe work was in COBOL with DB2.
• 3 years on a multi-platform system consisting of mainframe, PC, and handheld components. Role was mainly in the PC area and in the troubleshooting of PC-mainframe communication.

Consultant

• Designed, Coded, Implemented, and Maintained systems involving Inventory, Credit Data, and Billing at several client sites that included TRW, Transamerica Finance, and Southern California Edison.
• Applications were both on-line and batch in COBOL on IBM mainframes. Software used included IMS DB/DC and VSAM.

Programmer/Analyst

• Designed, Coded, Implemented, and Maintained systems involving Inventory and Production Tracking.
• Batch and on-line in COBOL using VSAM and IMS DB/DC.

SOFTWARE / LANGUAGES / PLATFORMS: