Data Management Project

Graylin R. Johnson

Phone: 602-***-****

E-mail address: **************@*******.***

S U M M A R Y

Possess excellent communication skills and interpersonal relations; bring with me an abundance of energy and enthusiasm; highly organized/detailed oriented. An excellent problem solver, with the ability to work well with others as well as independently. Effective at creating improvements that allow for more efficient workflow; exceptional at handling multiple tasks in a fast-paced environment. Have the ability to learn new concepts quickly; possess business savvy and project management experience, and excellent technical skills. Ability to assume significant responsibility; able to work well within a team.

W O R K H I S T O R Y

All Source PPS (Delta Airlines) 11/22-11/24

HR Program Specialist II (Contractor)

Provided oversight and implementation of SAP ECP payroll and SF HR interface management.

Collaborated with business stakeholders and IT infrastructure teams to define, gather, and document business processes and needs, and translate into detailed functional specifications for development.

Managed interactions with vendors and IT as it related to data security, data management, interface management, issues management and escalation.

Troubleshoot SAP applications and system interface issues and assisted in identifying concerns and finding solutions to business problems through configuration modifications and programming updates.

Responsible for manually updating Master Data records for corrections and maintained interface data repository on shared drive.

Utilized ServiceNow (SNOW) to create scheduled interface run jobs as per payroll processing schedule for all Payroll areas.

Managed interactions with vendors and Delta IT as it relates to data management, interface management, data security, issue management and escalation.

Facilitated the processing and timely close out of Pilot and FA Payroll prior to payroll execution.

Adhered to all Flight pay practices for active/inactive/terminated population for both Pilots, Flight Attendants and all Delta employee pay groups.

Collaborated between IT and Payroll business teams to ensure transmission of pay files, validation and processing.

Planet Technology Group/Newmont Mining Company 08/22-11/22

SAP SuccessFactors Compensation Integration Testing Lead (Contractor)

Developed test scripts – outlining key steps using the Newmont template(s) – for testing steps in the Compensation and Employee Central modules of CORE EC (SuccessFactors).

Used a test instance of SuccessFactors to become familiar with the configuration and intended design of the integration.

Established the testing hierarchy in Application Lifecycle Management (ALM).

Worked with offshore testing QA team to load and update test scripts.

Oversaw testing progress reporting, defect management and tester assignments.

Advised project team and developers on test strategy, approach, plan and schedules.

Participated in requirements reviews to ensure automation testability.

Provided guidance and support to project test team members.

Coordinated with stakeholders, the test objectives/policies/strategies/plans.

Prepared closure memos for each testing cycle and ensure quality assurance of the testing results.

Lead EC Compensation design, build, and unit test during planned iteration cycles.

Supported Systems Integration Testing for CORE SuccessFactors testing cycles.

Partnered with HR Integrations team to plan and execute SIT testing.

Enterprise Solutions Inc./Walmart 01/22-06/22

SAP Payroll Specialist HR Transformation (TCS Contractor)

Drove project plan and followed up with various teams on actionable items.

Strong organizational skills and the ability to adhere to strict deadlines.

Demonstrated strong verbal and written communication skills with the ability to leverage and influence others. Able to present summary information.

Proven trusted business advisor for payroll with other departments such as Talent (Human Resources), National Benefits Group, and those managing domestic assignments.

Demonstrated ability to liaise with business testing team in the development and testing of systems supporting User Acceptance Testing schedules, updates, and results.

Coordinated new HCM process documentation and US and Canadian payroll procedures.

Coordinated training for multiple payroll team testers.

Resourceful by navigating firm contacts throughout various groups ensuring the right people are engaged in the overall project plan.

Identified gaps, issues and find work-around/solutions.

Acted as liaison with client for troubleshooting: investigating, analyzing, and solve software problems.

Document functional designs, test cases and results.

Provide consulting services on both new implementations and existing support projects

Assisted testing team by running simulation payrolls

Explained US and Canadian SAP EC Payroll functionality to testing team and showed testers how/where to retrieve information in SAP

Assisted payroll testing team with Master Data validations

Assisted benefits team with benefit transaction processing and benefit data validations

Assisted testers with custom Z program execution and results validation

Acted as a single point of escalation for all testing activities in the release.

Executed testing steps in SuccessFactors and provided training to testing team for performing test steps in SuccessFactors

Alaska Federal Credit Union 08/20-12/21

Automation Programmer Analyst I (Contractor)

Created, updated, reviewed, and executed both manual and automated test cases and test suites in Azure DevOps for Symitar and ServiceNow test automation.

Utilized Git for version control

Experience with DevOps, Agile Product Engineer, and automated testing using Eggplant

Experienced with Azure DevOps pipelines, repositories, code wiki’s, and creating test plans

Provided productivity applications support for general service requests for ServiceNow

Designed and prepared test plans, and test artifacts for Symitar and ServiceNow test automation

Created development solutions for ServiceNow based on support tickets submitted by various member teams throughout the credit union

Performed risk assessment to ServiceNow system integrity based upon validation of ticket requests

Worked in collaborative efforts with multiple teams to perform assigned work

Identified test requirements from specifications, and designed test coverage plan as part of the automated testing team

Created tickets in ServiceNow based on customer issues reported to the Productivity Apps team

Created and monitored quality assurance related activities at the Symitar project level

Held and facilitated daily Automated Testing team standup meetings

Reviewed/verified functional and system requirements for Symitar to ensure QA deliverables adhere to QA compliance standards and comply with the requirements

Created bugs in Azure DevOps for issues discovered during iterations

Participated in user story writing sessions and created user stories for iterations as needed for work to be performed

Participated in bi-weekly team retro meetings to review work performed during iteration

Conducted and participated in bi-weekly automated testing team demos to present completed test automation story work to senior management and stakeholders

Contributed to, and facilitated the creation of the Testing Guild Newsletter as part of the IM Apps team for distribution to all members of the IM Apps team

Facilitated and participated in leading the Testing Guild meetings, and provided Testing Guild support to various member teams

American Airlines 06/16-08/20

Lead IT, Senior SAP HCM QA Engineer

Wrote test cases and test scripts, created/updated/reviewed/executed manual test cases/scripts

Extensive experience with DevOps, Agile Product Engineer, and automated testing using Selenium

Provided leadership and expertise on complex test projects to Project Spring EC Payroll HANA/HCM team, including: Planning, driving, managing, and coordinating testing activities through all phases of the software development lifecycle (Requirements gathering and analysis, design, implementation and coding, testing, deployment, enhancements, updates and maintenance)

Designed and prepared test strategy & approach, testing metrics and other testing artifacts as needed

Analyze the requirements and planning, creating and executing all test cases & test scripts for the payroll team and complete progress status reporting

Created a test Traceability Matrix (tracing the test-procedures to the test requirements) as needed

Assesses risk to quality of Project Spring program based upon results of verification and validation

Coordinated activities across multiple teams, including but not limited to development and project management

Identify test requirements from specifications and map test case requirements, and design test coverage plan

Reported testing defects, raised any issues or concerns that were potential risks to project timelines to senior management team and helped to mitigate any reported risks

Created and monitored quality assurance related activities at both the program and project level.

Provided support to our internal payroll business team ensuring that both internal and external customer needs are met

Held and facilitated test plan/case review meetings with cross-functional payroll team members (business and development)

Reviewed/verified functional and system requirements and ensured HCM/ECP Payroll IT QA deliverables adhere to QA compliance standards and comply with the requirements.

Managed defects from every testing cycle e.g. Unit, Functional, Integration, Mock, Negative, Stress, Performance, Regression, UAT, Cutover and Go Live/Support

Performed daily Payroll team defect triage and review with multiple process, functional and development teams

Performed daily SuccessFactors team defect triage and review with multiple process, functional and development teams

Ensured that there is a single payroll testing cycle standard entry and exit criteria as agreed to by the project team

Conducted and participated in payroll project defect review meetings with all individuals testing, and worked one on one with individual testers on my team to ensure timely defect resolution, proper documentation and test results were achieved

Conducted training and refresher sessions on Quality and Testing Management process, testing best practices, HP ALM tool, TFS tool, test execution, defect creation, workflow status update, ETA, resolution comments and test result documentation in support of any new hires or as needed

Set up HPQC ALM testing documentation tool with test requirements, test plan, test lab, defect management and dashboard reports environment as specified in the master test strategy and plan

Created QA Master Test Plan and QA Best Practice documentation as part of Payroll Production Support and SuccessFactors SharePoint Knowledge Database for company wide use

Utilized PCC (Payroll Control Center) for execution of payroll and payroll testing

Troubleshot PCC errors until resolved successfully.

Created and presented all test cycle kick-offs during all test phases.

Planned and estimated testing resource capacity for all test cycles for IT QA team.

Hosted the daily E2E Test Leads meeting; provided guidance and addressed roadblocks.

Drove and ensured the quality delivery of all test cycle closures for all testing activities.

Engaged in planning, issue resolution, and alignment with other release leaderships across the organization such as Payroll Business team and HR SuccessFactors teams

Performed interviews for new QA team members.

Defined metrics required for testing progress tracking.

Experienced with SAP S4 Hana Enterprise Cloud

Bechtel Corporation 10/11-03/16

GPS Application Support/Database Administrator

Primarily focused on Global Payroll System maintenance by identifying and resolving problems.

Analyzed, troubleshoot and resolved technical and software issues related to project US and Canadian Payroll Systems.

Document service requests in the Service Request Management application Front Range ITMS system for tracking and management.

Made code changes using C# to update/fix production environment payroll updates as needed.

Performed project configuration and setup to account for changes in remuneration and deductions including taxes, and benefits.

Provided application training.

Developed and maintained accurate documentation for related US and Canadian payroll support requirements.

Created and maintained application security via setup of new users and maintained access as authorized by data owners.

Setup and maintained application access requirements in Application Request Management System.

Supported and maintained other related Payroll systems as assigned.

Worked overtime as required to accommodate work level and international customers in different time zones.

Demonstrated ability to develop project plans and manage projects.

Provided strong communication and technical skills and the ability to communicate with multiple stakeholders on both entry and executive levels.

Provided guidance on requirements for system enhancements.

Updated Oracle database via SQL Server to resolve various payroll issues as needed.

Participated in PWC bi-annual company audit and provided security access request documentation, data gathering, and user role access lists for audit compliance.

Performed quarterly testing and verification of expat Payroll updates received from Payroll Tax and Compliance department in Staging/QA environment before implementing changes into Production environment.

SAP HCM Engineer/Business Analyst/QA Analyst

Reported to the SAP Development and Maintenance team and acted as a liaison between BBS HR, Payroll, Corporate Compensation and Corporate System Application Support.

Participated in detailed design, specification of customizations, interfaces, conversions and reports activities for SAP.

Worked with subject matter experts, process owners and developers to define and document SAP configuration requirements for enhancements and maintenance issues for the Employee Self-Service, Personnel Administration, Organization Management and Benefits modules of SAP.

Defined and documented SAP configuration requirements for enhancements and maintenance of US, UK, Canada and China payrolls implemented in SAP ECP.

Defined and documented SAP configuration to implement new functionality in SAP SuccessFactors and payroll in SAP ECP.

Worked directly with user team to ensure system deliverables meet work process requirements.

Worked with subject matter experts and process owners to ensure software compliance with Bechtel policies, programs and statutory legislation.

Analyzed and diagnosed application problems, gather requirements, recommend system solutions and enhancements to improve processes and systems and implement solution.

Developed and maintained Employee Self-Service, Personnel Administration, Organization Management and Benefits functional interfaces and report specifications.

Developed CATT scripts to assist in data conversions and mass data loads for users.

Developed functional specifications in accordance with IS&T standards and procedures.

Provided second level operation end user support.

Worked with training manager to ensure training materials and all documentation are updated with enhancements/changes to the SAP system.

Assisted in development of test cases and coordinated enhancements/changes through testing. Actively solicited subject matter expert involvement and participation in testing.

Experienced in implementation planning, gap fit analysis, testing, rollout and post-implementation support.

Ability to resolve configuration and functional business issues across the various SF EC and SAP EC Payroll modules in a hands-on manner.

Ability to use SAP debugger tool for problem analysis.

Ability to translate functional requirements for system changes into specifications which programmers can use to write code.

SAP Security Administrator

Security Admin for SAP ECC for ECP and EC system users

Strong knowledge of SAP Security tables and ability to identify authorization errors using SUIM, SU53, and ST01

Assigned and deleted roles from positions

Troubleshoot structural profiles for issues regarding user access

Utilized Profile Generator (PFCG) to assign roles to users

Identified user role access through running reports using function ZPD199

Documented procedures and provided end user training and clarification regarding user role access

Held regular meetings with senior management, internal and external auditors to convey findings identified through walkthroughs and testing, assess the risk and impact of deficiencies and made recommendations for remediation

Worked with business units and provided operational risk expertise and consulting for various projects and initiatives

Developed corrective action plans and change management processes. Identified training opportunities and designed/coordinated the development of training materials

Application Support Technician

Responsible for the technical support and maintenance of payroll and time collection systems with the primary focus being on maintenance and problem identification / resolution for eTrack, SAP ECP Payroll, SuccessFactors, GPS, Timberline, and PayCentrex.

Bridged the gap between functional experience and technical skills, and thus, utilized knowledge of Payroll processes, combined with solid understanding of system architecture and functionality.

Acted as one of the first points of contact for application support issues related to these applications. Analyzed, troubleshoot, debugged, and resolved technical and software issues related to eTrack, GPS, SAP ECP Payroll, SuccessFactors, and PayCentrex. Documented service requests in the SRM application HEAT/ServiceNow for tracking and management.

Performed payroll configuration and setup to account for changes in remuneration and deductions including taxes, union dues and benefits for eTrack, SAP ECP Payroll, and GPS. Provided application training and assisted with interface between other systems (Oracle Financials, Tax Gathering, etc.)

Performed time system configuration and setup for global projects including setting up costs codes, crews, shifts, companies, craft codes, and craft classes. Provided application training. Developed and maintained accurate documentation for upstream and downstream payroll support requirements.

Aided in the development of test cases and coordinated/provided thorough testing of new development using TeamTrack/JIRA software. Actively solicited functional users’ involvement and participation in testing.

Worked closely with data owners to ensure proper role access. Setup new users and maintain access as authorized by data owners. Periodically review access lists with data owners. Setup and maintain application access requirements in ARMS.

Worked with IT resources in the setup of hardware used by financial systems and to establish the automation plan for a job site, specifically related to payroll and time keeping. Translated functional requirements for system changes into specifications.

Demonstrated knowledge of software installation and configuration processes including, printer setup, ODBC setup, registry maintenance and active directory.

Experienced in working in a structured development environment utilizing a standard software development methodology.

Ability to analyze and diagnose system issues; worked with development team to provide solutions if programming change was required.

Utilized intermediate knowledge/experience of Microsoft Office, and Office365

Demonstrated ability to perform successfully in a service environment where meeting the customer's business needs and creating/maintaining positive customer relationships were as critical as technical competence.

Required to travel to projects to implement eTrack software for start of project as well as project maintenance and training during project length.

Deskside Support Technician

Designed, configured, installed, setup and maintained company laptops/desktop and other electronic media, assets, systems and devices in a complex network environment

Provided end user support in corporate environment with approximately 400 users.

Performed phone support, desktop and application support, troubleshooting and created and updated accurate documentation in electronic tracking system.

Experienced with imaging assets, backup software and asset inventory/tracking management, encrypting and SCCM

Excellent ability and experience troubleshooting Exchange (MS Outlook)/Office365.

Utilized ServiceNow for asset tracking, stockroom and conference room inventory, ticket creation and monitoring of customer issues through satisfactory resolution

Community Legal Services Contractor - 06/09-04/10

Grants Coordinator/Financial Analyst

Prepared grant billings and reports in accordance with grant contract provisions and agreements

Maintained Cash Receipt/Cash Disbursement journals

Handled accounts receivable and accounts payable duties

Analyzed and reconciled balance sheet accounts to general ledger

Prepared bank deposits

Reviewed and analyzed accounting records and fiscal activities to ensure accuracy and compliance with accounting/program/legal requirements

Gathered, compiled, and prepared financial and statistical reports to county, state, and federal agencies in accordance with grant requirements

Determined the level and appropriateness of year-end closing accruals, prepayments, deferrals, depreciation or adjustments.

Recorded journal entries utilizing CYMA accounting system

Assisted with budget preparation

Reconciled all bank statements

Prepared all grant reports, billings, and budgets

Performed tasks as assigned by the Finance and Information Systems Director

Assisted with Payroll processing

Provided accounting support for automated financial management system

Assisted with grant proposal preparation

Developed and maintained a positive business rapport with various funding agency employees to guarantee future grant opportunities, as well as to resolve any discrepancies quickly

Computer Guidance Corporation 02/06-05/09

Application Support Specialist/QA Tester

Handled incoming phone calls related to CMS and eCMS issues for over 500 customers.

Phone calls required analytical and problem-solving abilities. If necessary, created cases for customers so that issue could be tested in both CMS and eCMS. Able to troubleshoot and resolve most issues without needing to create a case.

Required to work with others in my department, as well as programming and implementation to communicate new issues, and resolutions as well any other new developments discovered in software functionality.

Specialized in resolving issues in all supported CMS and eCMS releases including 34.1, 34.3 SP2 through SP5, 35.0 SP1 and SP2, and 36.0. Issues ranged from removing locks, re-sequencing in Payroll and Accounts Payable, correcting mismatching header and detail records in A/P and A/R, identify Sales and Use Tax overpayments, researching specific sales and use tax issues or concerns, assist with audits and reduce future tax liabilities.

Required to learn and have a working knowledge of all CMS applications to provide support including Accounts Payable, Accounts Receivable, Job Costing, Payroll, General Ledger, Canadian Payroll, Order Processing, Plant Sales, Equipment Accounting, Equipment Maintenance, Human Resources and more.

Sound knowledge in QA processes and standards, Software Testing and Methodologies.

Proficient in preparing the Load test strategy, Load test Plan, Capacity planning and business workflow modeling based on requirements.

Working knowledge of manual and automation Testing, Black Box, White Box, System, Regression, Integration, Functionality, and User Acceptance Testing of both client-server and Web-based applications.

Proficient in preparing test plans, test case designs, test scripts and execution of various test scripts using Rational Testing Tools.

Working experience of multiple databases like Oracle, SQL server and MS Access.

Excellent knowledge of full Software Development Life Cycle (SDLC).

E D U C A T I O N

Northern Arizona University

Bachelor of Science, Information Technology Tech Management

C E R T I F I C AT I O N S

Certified SCRUM Master - SMC

S K I L L S

Proficient in the following systems and disciplines:

Waterfall Methodology Agile Methodology

SCRUM Methodology Accounts Receivable

Accounts Payable DevOps CI/CD Methodology

HP ALM Quality Center JIRA

SharePoint Selenium

SAP HCM SAP S4 HANA ECC 6.0

SAP Business One Forza Mobile App

Android Studio MS SQL Studio

SAP Payroll Control Center SuccessFactors

MS Teams Rally

WorkSoft Tosca

MS Office MS Access

MS Visual Studio Code MS Visio

Publisher Works Mac OS 9

Donovan Data Systems AS-400

Timberline Business Objects

CMS Release 34.3 SP5 Crystal Reports

CYMA PIKA Reports

Peachtree Hardware Imaging

Webex Webfacing

RPG HTML

Oracle XML

Toad for Oracle SQL Server

SQL Plus GAAP Accounting Methodologies

MS SQL Rational Testing Tool

Sarbanes Oxley Compliance SDLC

Image Scanning Twain Drivers

LAN/WAN Network setup TCP/IP Protocols

FTP uploads/downloads ODBC Setups and Connections

C# Git

`

I N D U S T R Y E X P E R I E N C E

Construction, Law, Information Technology, Banking/Finance, Digital Document Products, Manufacturing, Retail, Casino and Gaming, Airline, Mining, and Advertising.

I.T. K N O W L E D G E

Supplied technical and application support to customers via walk in and telephone

Provided support by identifying, researching, and resolving technical problems for desktop computers, laptops, network servers, wireless networks, and network printers.

Troubleshoot and corrected issues such as viruses, boot errors, data recovery and data migration on multiple operating systems such as Windows Vista, XP, NT and Mac’s OSX and Safari.

Performed full system backups and system restores on customers hardware and installed operating systems and other various software such as anti-virus programs.

Setup wireless networks, VoIP’s, network servers, network printers, and other systems as required.

Knowledge of ITIL service framework

Extensive experience with personal computer hardware, Windows OS, application support, networking, active directory, domain controllers, ping, DNS, and DHCP.

Contact this candidate