Customer Service Information Systems
Resume:
Marsha J. Coto
New Boston, MI *8164
*****@*******.***
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