Marsha J. Coto

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

New Boston, MI *8164

734-***-****

ac2n20@r.postjobfree.com

CAREER SUMMARY:

Experienced Information Systems professional seeking Application Support or Systems Analyst position. 15 years of experience in PeopleSoft HRMS with over 24 years in the Information Technology industry. Master of Science in Computer Information Systems. Bachelors in Business Administration. Have been responsible for many aspects of the project lifecycle, including requirements gathering, analysis, data mapping, data conversion, application design and development, test plan development, system, integration and user acceptance testing, implementation, and production support.

Wide range of skills include:

PeopleSoft HRMS 7.5 through 9.1 analysis, design, development, testing, production support, implementation, and upgrade.

PeopleSoft 8.3 Base Benefits implementation

SQR and Peoplecode programming

ADP EV3 analysis, development, user support and implementation.

E-commerce development in ASP, HTML, JavaScript and VBScript with Informix database

Web development using Front Page, CGI/Perl on Oracle/Unix platform

Client server design and development in MS-Access, Visual Basic, Oracle

Mainframe programming in COBOL/IMS

Project Management

EXPERIENCE:

March 2005 to Sierra-Cedar

July 2017 Application Support Specialist

Provided remote production support and troubleshooting for functional and technical issues for over 30 PeopleSoft hosted clients. Created and executed queries and Data Mover scripts, performed project migrations, administered security, scheduled batch jobs in Process Scheduler, provided troubleshooting and resolved job failures. Created and updated documentation using Sharepoint.

Researched and developed SQR and PeopleCode modifications, and applied custom tax and other regulatory updates to various remote clients for PeopleSoft 7.0 through 9.0. Worked with tax agencies in formulating

functional and technical specifications for the developers. Provided test plans and conducted unit and regression testing.

Collected, documented, managed, and communicated business and technical requirements for custom development needs. Worked with clients to formulate functional specifications and test plans and translated into technical specifications. Created program design and assisted developers with complex programming issues. Conducted unit and regression testing, and provided support to clients for user acceptance testing.

April 2004 to iMiH Group, Wixom, MI

March 2005 Senior Programmer/Analyst

Assignment with Spencer Gifts, Egg Harbor, NJ

Functional lead for custom panels and SQR development for PeopleSoft 7.5 to ADP Enterprise HRMS version 3 conversion.

Imported HRMS history data using Import Manager and Data Mover.

Converted Canadian HRMS, Benefits, and Payroll data from PeopleSoft 7.5 Payroll to ADP Payroll.

Performed analysis, design, testing, and issue resolution for PeopleSoft to ADP customizations.

Worked directly with customers and vendors in gathering requirements for customizations.

Created functional and technical specifications for custom SQRs.

Performed analysis and coding changes to Aetna and Cobra outbound SQRs.

Assignment with DSM Nutritional Products, Parsippany, NJ

Created UAT Test Scenarios for PeopleSoft 8.3 to ADP Enterprise v3 conversion.

Coordinated and conducted UAT testing for PeopleSoft 8.3 to ADP Enterprise.

Set up foundation tables in ADP Enterprise using the Import Utility and SQL updates.

Assignment with Risk Management Alternatives, Atlanta, GA

Analyzed business processes and created UAT Test Scenarios.

Conducted UAT Testing for ADP Enterprise upgrade from Horizon version 9 to Enterprise version 3.

Feb 2001 to SYNOVA, Troy, MI

2004 Senior Programmer/Analyst

Assignment with Ford Motor Company – Human Resources Information Systems

Participated in PeopleSoft HRMS 7.5 to 8.3 Upgrade for large installation.

Participated in Benefits 8.3 Implementation.

Performed impact assessment, design specifications, Peoplecode and SQR modifications to support the integration of over 300,000 employees from legacy to existing PeopleSoft 8.3 system.

Planned, coordinated, and performed system integration testing for online transactions as well as over 100 batch interfaces to downstream systems.

Performed functional analysis, technical design, and custom development for PeopleSoft HRMS 7.5 and 8.3 global applications.

Performed functional analysis and technical design for Self Service tax withholdings customization.

Team lead and programmer/analyst supporting customized Payroll interfaces to four countries.

Responsible for delegating the workload, facilitating complex program design, driving the testing efforts, conducting code reviews, training, mentoring, and tracking project statuses for development team.

Provide effort estimates to complete customer service requests.

Ensure production issues are resolved and implement remedies to prevent future problems.

Proficient in PeopleTools, Application Designer, PeopleCode, Security, and Workflow.

Performance tuning using Oracle explain plan and test utilities.

April 2000 Decoratetoday.com, Plymouth, MI

to Feb 2001: Database/Web Programmer

Modifed e-commerce web application to add new products. Includes complete functionality from display to selection to cart to order processing system. Application written in ASP, Javascript, and VBScript with Informix database.

Supported Customer Service Message Center system which routes and processes customer orders and email messages.

Supported and troubleshooted Live Chat application.

Assisted DBA in performance tuning, troubleshooting, creating, dropping, and altering tables, fields, and indexes and other day-to-day DBA tasks.

Created Crystal Reports with SQL Server database.

Jan 2000 to Logica, Dearborn, MI

April 2000: Senior Analyst

Assignment with Ford Motor Company – Strategic Planning

Performed requirements analysis and design for enterprise project information collection system.

Created project charters, workplans, data and process models, design specifications and test plans.

Mar 1999 Logica, Dearborn, MI

to Jan 2000: Senior Analyst

Assignment with Ford Motor Company - Human Resources Information Systems

Participated in the implementation and support of PeopleSoft HRMS and Data Warehouse application for four countries (US, Canada, Brazil, and Argentina).

Administered security for PeopleSoft HRMS and Business Objects applications.

Performed batch scheduling, monitoring, troubleshooting, and metrics reporting for Unix, Oracle, and SQR programs using Autosys scheduling tool.

Coordinated Production moves to support new program releases.

Developed security and change request web-based forms using Perl/CGI and JavaScript.

Jan 1999 Logica, Dearborn, MI

to March 1999: In house Project with consulting firm

Supported the development of a skills requirements application written in Visual Basic and Crystal Reports with Access database.

July 1998 St. John Health System, Detroit, MI

to Jan 1999: Senior Programmer Analyst

Designed, developed and implemented Managed Care application which calculates capitation payments to be made to physicians. Application written in Access Basic with MS-Access queries, forms, procedures, functions, and macros.

Designed and created physical databases, tables, and indices using data normalization techniques.

Performed systems analysis, testing, coding, and data conversion.

Installed upgrades and supported externally written Health Care application.

Created custom reports for management.

Nov 1996 CDI, Troy, MI

to July 1998: Programmer Analyst

Assignment with Ford Motor Company – Office of the General Counsel

Led, designed, and participated in the development of a Web extranet database application which allows outside attorneys to access and update records in Legal Matters Management System. Application written in Perl, DBI, UNIX, HTML and Oracle.

Created Oracle views, roles and stored procedures.

Created Web reports in Developer 2000.

Designed, developed, set up security, and implemented new database applications and data conversion programs in MS-Access and Oracle.

Gathered requirements and mapped data from legacy systems to global Intellectual Property tracking system.

Wrote SQL scripts and performed Oracle database updates using SQL Plus.

Worked closely with customers and software vendors in defining requirements and resolving daily issues.

Performed Y2K analysis and program conversion changes.

Created ACR (Application Control Review) documentation for new and existing applications.

April 1993 Electronic Data Systems

to Nov 1996: Assignment with General Motors SPO-Sales, Service & Marketing, Detroit, MI

Systems Engineer

Graduated from Systems Engineer Development (SED) Training.

Developed and designed Price List Publication System and Parts Tracking and Reporting System in MS-Access.

Maintained and enhanced COBOL/IMS Part File Update and Price List and Catalog Publication systems.

Coded Easytrieve and FOCUS extract and report programs.

Created and modified JCL jobstreams.

Participated in the development of a life insurance automated correspondence and editing system using INCASE and SYBASE on a UNIX Sun workstation.

Assisted in the development of an enterprise data model.

Developed proficiency in TSO, ISPF, CLIST, CHAMP, SAM, WSF2, ACF2, Control-M, Panvalet, and File-Aid.

Utilized IBM utility programs: SYNCSORT, IDCAMS, IEBGENER, WAAPDSUT, WAAPSPLT, WAASDATE, and WAASABND.

Monitored job cycles and resolved abends.

Gathered and analyzed customer requirements, made recommendations, and provided detailed estimates.

Performed Year 2000 impact analysis on eleven COBOL systems.

Created project plans and tracked project status using MS-Project.

Developed and delivered presentations to peers, managers, and customers.

Led walkthroughs and facilitated team, customer, and account meetings.

Wrote user and system documentation.

Followed all phases of SLC methodology from definition to implementation.

Sept 1991 Wayne County Office of Management & Budget

to May 1992: Risk Management Division, Detroit, MI

Technical Services Intern

Designed and implemented automated letter generating applications for Workers Comp, COBRA, and Subrogation systems using Enable.

Automated state required MIOSHA reports.

Created and developed tables, programs, reports, macros, forms, and customized menus.

Trained and provided PC support to department staff.

Performed Novell Network administrator functions.

EDUCATION: The University of Phoenix - Livonia, MI Campus

Master of Science in Computer Information Systems

Graduation Date: October 2000

The University of Michigan - Dearborn, School of Management

Bachelor of Business Administration

Graduation Date: December 1992

Concentration: Management Information Systems

PROFESSIONAL TRAINING:

Amazon Web Services Business Professional

Amazon Web Services Technical Professional

People Tools I

PeopleTools I & II 8.4 Delta Overview

PeopleCode 8.4

Intro to HR and Benefits 8.0

PeopleSoft 8.8 Benefits Administration

Integration Tools 8.4

Internet Workflow 8.4

Basic Web Development

Microsoft Project

Oracle Developing Applications Using Database Procedures

Visual Basic Introductory and Intermediate

Advanced MS-Access

COBOL

CASE Tools

EDS SED Business and Technical Training

TECHNICAL SKILLS:

Operating Systems

Unix

Microsoft Windows

Microsoft NT

MVS TSO

Databases

Oracle

Microsoft SQL Server

Informix

Microsoft Access

IMS

Languages

Peoplecode

SQR

Visual Basic/Access Basic

HTML

ASP

Javascript

COBOL

Other Software, Tools, and Utilities

Microsoft Office (Excel, Word, Powerpoint, Outlook)

Microsoft Project

Microsoft Access

Sharepoint

SQL Plus

SQL Developer

Toad

ADP Enterprise HRMS

AutoSys

Peopletools

Process Scheduler

Remedy

Contact this candidate