T E C H N I C A L S K I L L S

Mainframe Experience:

• TSO, PANVALET, CLIST, IBM Utilities, MVS JCL, SQL, COBOL, COBOLII, CICS, Telon, IEF Composer, IEF CoolGen, SAR Sysout Archive Resource, Endeavor, Roscoe, RDS, MQ Series, DYL280, Easytrieve, FileAid
• PC Experience:
• Microsoft Access, Word, Excel, PowerPoint, Visio, FTP, C/C , Java, Java Script, XML, Crimson Editor, UltraEdit, PFEdit, Toad, SQL Developer, SQLLoader, IEF CoolGen, IEF Composer, DB2 Command Center, HTML, SafeSource, PVCS, JavaScript, Textpad, Filezilla, WinScp, Putty
• PeopleSoft Experience: Version 6.0, 7.0, 7.5, 8.12, 8.14, 8.17, 8.4, 8.8, 8.9, 9.1
• Human Resources, Benefits, Financials, N A Payroll, CRM, Time Labor, ePerformance, Absence Management, Competency Management, Enterprise Learning, Position Management, Talent Acquisition, PeopleTools, PeopleCode, Work Flow, App Messaging, App Packages, App Engine, SQR
• Testing Tools:
• CEDF, Xpediter, Intertest, BMC, Winrunner2000, Loadrunner2000, TestDirector2000, QMF, SPUFI, Queryman, SQLPlus, WinDiff, Beyond Compare, SQRW, STAT.
• Database Experience:
• DB2 4,5,6,7 , ORACLE 7,8,8i,9, 10g,11 , ADABASE, IMS, VSAM, Teradata, SQLBase

Operating System Experience:

OS390 MVS, OS2, Windows 95/98/2000, NT, Linux Debian, CentOs , Unix HP, Sun Solaris, IBM AIX

P R O F E S S I O N A L E X P E R I E N C E

Bureau of Land Management

Confidential

PeopleSoft Software Developer

Responsibilities include, but are not limited to, support and enhancement of core HR, Competency Management, Enterprise Learning, Self Service and Manager Self Service, and a custom Responder Qualification sub-system. Designed, or made design changes to, delivered SQR program logic, as well as creating custom application packages and classes to support various business requirements. Created functional and technical design documents for all customizations, or enhancements made to the system. Provided flow charts and process flows for all customizations, or enhancements, made to the system. Designed, or made design changes to, custom and delivered SQR's and Application Engine programs as needed. Performed security administration activities by modifying permission lists and roles, as needed. Created component interfaces for batch processes to load various PeopleSoft tables using Application Engines, as well as Excel. Created new Components, Pages, and records or views, to develop new business objects need to support changing business rules. Performed compare report reviews for project migrations when moving PeopleSoft objects from a Development to Production environment.

Confidential

PeopleSoft Software Developer

Responsibilities included, but not limited to, providing technical support for a PeopleSoft Payroll conversion. I was the primary developer responsible for importing Ceridian Payroll data for over 19,000 employees from an acquired company acquisition and loading their information into PeopleSoft Payroll tables. I was tasked to write new SQR's and Application Engines, or modify existing programs, to load converted Payroll data into Fed, State and Local Tax data, Direct Deposit and General Deduction tables. I created custom application packages and classes to support various business and conversion requirements. I wrote an XML parser, using Application Engine, to consume a Kronos time entry file and load the data into PeopleSoft. I created functional and technical design documents for all customizations, or enhancements made to the system. I developed flow charts and process flows for all customizations, or enhancements, made to the system. I updated roles and permission lists for new, or modified, components and pages, as needed. I also created component interfaces for batch processes to load PeopleSoft Payroll tables using Application Engines, as well as Excel-to-PeopleSoft data loads. I created new Components, Pages, and records or views to support the conversion process. I worked with third party, off-shore, group to handle STAT synchronizations and software project migrations to other environments, and held group code reviews, and knowledge transfer sessions, to ensure my work was acceptable.

Confidential

PeopleSoft Software Developer

Responsibilities included, but were not limited to, mainframe DB2 production support and enhancement of the PeopleSoft HCM software Batch and Online and HCM upgrade support as the client moves from PeopleSoft V8.9 Mainframe DB2 to PeopleSoft V 9.1 Unix Oracle . Responsibilities also include support and enhancement of core HR, Benefits, Payroll, Self Service, and Manager Self Service modules. Designed, or made design changes to, delivered program logic as well as creating custom application packages and classes to support various business requirements. Created functional and technical design documents for all customizations, or enhancements, made to these systems. Modify approval emails and workflows. Designed, or made design changes to, custom and delivered SQR's and Application Engine programs as needed. Designed, or made modifications to, custom and delivered application classes used in batch and online processes as needed. Performed security administration in all environments as needed.

Confidential

PeopleSoft Software Developer

Responsibilities included, but were not limited to, support and enhancement of core HR, Benefits, Payroll, Talent Acquisition, Self Service, and Manager Self Service modules. Designed, or made design changes to, delivered program logic as well as creating custom application packages and classes to support various business requirements. Created functional and technical design documents for all customizations, or enhancements, made to these systems. Modify approval emails and workflows. Provided flow charts and process flows for all customizations, or enhancements, made to the system. Designed, or made design changes to, custom and delivered SQR's and Application Engine programs as needed. Designed, or made modifications to, custom and delivered application classes used in batch and online processes as needed. Performed security administration in development, test and quality assurance environments as needed.

Confidential

PeopleSoft Software Developer

Responsibilities included, but were not limited to, support and enhancement of HR, Benefits, Self Service, and Manager Self Service modules. Designed, or made design changes to, delivered program logic as well as creating custom application packages and classes to support various business requirements. Created functional and technical design documents for all customizations, or enhancements, made to these systems. Provided flow charts and process flows for all customizations, or enhancements, made to the system. Designed, or made design changes to, custom and delivered SQR's and Application Engine programs as needed. Designed, or made modifications to, custom and delivered application classes used in batch and online processes as needed Performed security administration in development, test and quality assurance environments as needed. I also participated in the HRMS upgrade from 8.8 to 9.1. Responsibilities included creating inventory lists, retro-fitting online and batch customizations. Reorganized the 9.1 portal structure as needed. Create custom security roles and permission lists. Retrofitted custom code into applications engines, SQR's, application packages, and component interfaces. I composed technical documents describing new enhancements, retrofitted changes, and proof of concept descriptions for the end users and other developers to review.

Confidential

PeopleSoft Software Developer

Responsibilities included, but were not limited to, support and enhancement of Absence Management and Time and Labor as they apply to all Self Service, Manager Self Service, and Administrative areas. Designed, or made design changes to, delivered program logic as well as creating custom application packages and classes to support various business requirements. Created functional and technical design documents for all customizations, or enhancements, made to these systems. Provided flow charts and process flows for all customizations, or enhancements, made to the system. Designed, or made design changes to, custom and delivered SQR's and Application Engine programs as needed. Designed, or made modifications to, custom and delivered application classes used in batch and online processes as needed Performed security administration in development, test and quality assurance environments as needed.

Confidential

PeopleSoft Software Developer

Responsibilities included, but were not limited to, production and enhancement support of HR, Benefits, Base Benefits, Benefits Administration, ePerformance, Absence Management and North American Payroll areas. Designed and developed custom Self Service plug-ins for Merit and Bonus distribution, Pension Calculation, and Commuter programs. Responsibilities also included supporting all Self Service and Manager Self Service areas. Designed, or made design changes to, delivered program logic as well as creating custom application packages and classes to support various business requirements. Created functional and technical design documents for all customizations, or enhancements, made to these systems. Provided flow charts and process flows for all customizations, or enhancements, made to the system. Designed, or made design changes to, custom and delivered SQRs and Application Engine programs as needed. Designed, or made modifications to, component interfaces executed in batch processes or from online program logic as needed. Designed, or made modifications to, application classes used in batch and online processes as needed. Migrated custom program logic from function libraries to application classes to improve performance and maintainability. Performed security administration in development, test and quality assurance environments as needed.

Confidential

PeopleSoft Software Developer

Participating on a team responsible for upgrading PeopleSoft HRMS, Payroll and Time Labor from version 7.5 to version 8.8, PeopleTools set 8.4. To date, responsibilities include writing SQR programs to convert low volume data tables from legacy to new system formats and cleaning data not properly converted. Composed a number of conversion analysis documents outlining data mapping structures, fit gap analysis, table changes, SQRs identified for retro-fitting and new program development, and on-line page customizations as well as new page development. Modified over 20 SQRs and developed 15 new customized SQRs needed for various reporting needs. Customized over 10 delivered PeopleSoft pages used for HR and Time and Labor functionality. Created a number of new user-defined on-line pages. Developed and modified PeopleCode in a number of record, page, and component level objects to retrofit, enhance or fix delivered on-line functionality. Worked intimately with the end user to ensure online customizations were implemented in PeopleSoft version 8 as described in technical and functional specifications. Created run control records for new SQRs as needed. Responsible for reviewing all Employee Self Service and Management Self Service components and pages to identify customizations and to unit test each area of functionality to ensure the self-service portion of the system is stable. Performed security administration in development, test and quality assurance environments as needed.

Confidential

PeopleSoft Software Developer

Participating on a team responsible for upgrading PeopleSoft Financials Asset Management module from version 7.5 to version 8.8 PeopleTools set 8.4 . To date, responsibilities included writing SQR programs to create ad hoc reports. Composed a number of conversion analysis documents outlining data mapping structures, fit gap analysis, table changes, SQRs identified for retro-fitting and new program development, and on-line page customizations as well as new page development. Modified SQR programs and developed a number of new customized SQRs to fulfill various reporting needs. Assisted in mentoring employees in customizing delivered PeopleSoft pages used for AM. Modified delivered PeopleCode in a number of record, page, and component level objects and added program logic to enhance editing and validation functionality. Worked intimately with the end user to ensure online customizations were implemented in PeopleSoft version 8.4 as described in technical and functional specifications. Performed security administration in development, test and quality assurance environments as needed.

Confidential

PeopleSoft Software Developer

Participated on a team responsible for converting a legacy HRMS system to PeopleSoft V8 and implementing a new version of PeopleSoft Benefits and Payroll System version 8. Provided customizations to various HR, Payroll, and Benefits pages. Created new PeopleSoft record and view definitions. Created new menus, components and PeopleSoft web pages as requested by the end user. Developed a complete system from scratch using PeopleTools that contained various portions of functionality cloned from PeopleSoft Employee Self Service ESS and Management Self Service MSS modules. Assisted in implementing and testing of PeopleSoft CRM help desk module. Performed migrations moving PeopleSoft objects from development to peripheral environments. Performed security services by creating and attaching permission lists and role assignments to Operator ID's to use new pages, components, and menus. Developed or enhanced a number of SQR modules used for the upgrade to run on an OS390 or Unix System Services platform. Worked closely with end user to develop specifications to write new SQR's for various HR, Benefits, and Payroll reporting and maintenance needs. Develop COBOLII utility programs to handle comp-3 data needs, read PeopleSoft DB2 tables, and generate various ad hoc reports. Modified COBOL CICS programs to read various PeopleSoft DB2 tables. Wrote SQR programs to extract PeopleSoft HR, Payroll, and Benefits data from DB2 tables and load it to a Teradata data warehousing system using FASTLOAD and MLOAD utilities and Queryman to create tables, views, and for unit testing. Developed JCL procedures to execute COBOLII and SQR programs, sort utilities, and MQ Series modules. Provided post implementation support for the PeopleSoft systems for both batch and on-line processes. Performed security administration in development, test and quality assurance environments as needed.

Confidential

PeopleSoft Software Developer

Participated on a team that was responsible for implementing PeopleSoft Accounts Payable and General Ledger version 8. Performed analysis on the KMART legacy Accounts Payable and General Ledger systems. Produced process matrixes, legacy on-line and batch functionality documentation. Assisted in developing migration and reporting strategies for high volume data conversion. Developed new PeopleSoft web pages for ad hoc purposes. Developed SQRs to load summary General Ledger tables. Developed SQR programs to send data to systems interfacing with PeopleSoft Accounts Payable and General Ledger systems. Wrote SQRs to implement a management hierarchy reporting utility. Created DB2 table DCLGENs, SQL queries and COBOL copy lib members, tables, and views as needed. Constructed JCL procedures that executed COBOLII or SQR programs, IBM utilities, and synch sort programs.

Confidential

PeopleSoft Software Developer

Participated on a team responsible for upgrading PeopleSoft HRMS and Payroll from version 7.5 to version 8. Wrote COBOLII conversion modules to read HR and Payroll data to create extract files used to load Oracle tables in development and production environments. Created SQL scripts to load Oracle tables using SQLLOADER. Modified PeopleSoft HR and Payroll panels as requested by end user. Customized HR and Payroll web pages using PeopleCode as needed. Modified record definitions, field attributes, and translate values as needed. Created SQL scripts to build or alter PeopleSoft tables. Developed SQR's to run on Unix for reporting or maintenance purposes. Worked intimately with the end user to ensure PeopleSoft customized version 7.5 on-line capabilities were implemented in PeopleSoft version 8. Provided technical support to help implement PeopleSoft Canadian payroll and benefits functionality. Unit tested portions of Canadian payroll functionality to ensure it met end user requirements. Wrote JCL PROC's needed to execute conversion modules.

Confidential

Software Engineer

Primary developer responsible for all tasks involved in developing and maintaining IEF/COOlGEN block mode on-line systems for SBC's billing, products, and assessment divisions. Developed new batch programs and online screens using IEF/COOLGEN and COBOLII modules. Responsible for ensuring testing and production systems were setup properly. Debugged batch and online programs program problems. Responsible for migrating PRADs, CABs, external action blocks, DBRMs and COBOL programs to remote locations. Created views and tables in development and production environments to satisfy end user requests. Made sure batch JCL procedures PROCS written using IEF/COMPOSER where constructed properly. Used QMF or SPUFI SQL queries to extract and validate data from DB2 tables for testing purposes as well as for end users.

Confidential

PeopleSoft Software Developer

Participated on a team that was responsible for implementing PeopleSoft Asset Management that was to run on an OS390 platform. Responsibilities included producing process matrixes, documenting existing on-line functionality, documenting batch job functionality, gathering report samples, and gap analysis. Reviewed legacy modules written in COBOLII, IEF/COOLGEN, and TELON to produce SQR specifications. Gathered DB2 table declarations, SQL queries and COBOL copylib members from the Legacy Asset Management system manual for analysis and PeopleSoft table design. Documented and developed all new and existing SQR feeder file interfaces. Developed SQR's used for data conversion and reporting purposes. Developed online panel customizations using PeopleCode as needed. Provided maintenance support to legacy batch or on-line modules.

Confidential

PeopleSoft Software Developer Team Lead/Application Developer

Participated on a team responsible for upgrading PeopleSoft Financials module from version 6.0 to 7.5. Provided technical leadership support responsible for making enhancements to various SQRs and PeopleSoft panels. Wrote SQRs programs for conversion and migration purposes. Wrote SQRs to create various reports as requested by the end user. Developed new fields, records, and panels based on end user specifications. Modified various panels by adding or hiding fields, or changing grids. Developed Winrunner and Loadrunner scripts to load and stress test portions of the PeopleSoft system. Wrote and modified Unix scripts needed to migrate data to new Oracle instances. Assisted in troubleshooting in SQR and online problems. Developed program specifications and test plans for Subject Matter Experts review during testing of upgrade. Designed project plans, test plans, and team activity matrices for project management.

Confidential

Senior Software Engineer

Primary developer responsible for all tasks involved in developing block mode CICS on-line and batch programs for the FBI's National Criminal Information Center 2000 System NCIC . Developed three complete 3270 on-line systems: Undercover Agent Tracking System, Communication Line Maintenance System and Edit Code Validation System that consisted of over 300 modules written using IEF/Composer, COBOLII running in CICS. The on-line system, as well as batch jobs, maintained and reported on data stored in DB2 and VSAM data stores. Also responsible for ensuring development CICS testing regions were setup properly, debugging program problems, migrating modules from one region to another, and to ensuring batch JCL procedures where constructed properly. Developed COBOLII batch programs that utilized the External Customer Service Interface EXCI module to link and submit JCL from an online process. Enhanced and maintained the primary message transaction processor written in COBOL CICS for the entire NCIC2000 system. Acted as a liaison between project lead and systems programming group to help debug environmental problems and recommend corrective action as needed. Mentored junior level application programmers.

PeopleSoft Software Developer

Participated on a team responsible for upgrading PeopleSoft HRMS from version 6.0 to 7.0. Responsibilities included the analysis and design of SQR programs for data conversion purposes. Developed new SQRs for HR and Payroll reporting purposes. Enhanced existing SQRs by changing SQL, table names, or program logic as requested by end user. Modified PeopleSoft panels by adding or hiding objects, or changing grid definitions. Added PeopleCode to panel objects based on end user requirements. Developed new record and field definitions. Provided production support by troubleshooting SQR and online programming errors.

Confidential

Software Engineer

Provided technical programming support to the Network Capabilities NETCAP Department. Maintained existing COBOL CICS programs that maintained data stored in ADABASE databases. Wrote adhoc COBOL batch reports that extracted data from VSAM files and ADABASE databases to create new reports or fix problems as needed. Successfully implementing the '888' Order Entry System for Toll Free Calling enhancements. Successfully redesigned and implemented a new COBOL process to replace a legacy transaction processor module that received and processed all new and phone order change requests for the entire company. Worked closely with corporate Database Administrators to setup new tables or modify characteristics of existing tables. Troubleshoot on-line and batch program problems and implement fixes as needed.

Confidential

Senior Software Engineer

Provided technical programming support to the Accounts Payable, Accounts Receivable, and Group Billing and Revenue Departments. Held fact-finding meets to gather system requirements and user input for new projects or system enhancements. Participated on a team tasked to design and implement a new Membership System using IEF/COMPOSER client server technology. Performed data model analysis, developed documentation, developed PRADs, CABs, EABs, and PADs for both the client and the server implementation. Designed new and maintained existing COBOL, CICS, IEF/Composer programs written for batch and online systems. Developed batch programs that extracted data from VSAM files and DB2 databases to fulfill various reporting needs using IEF/Composer and COBOL. Developed new JCL procedures, or enhanced existing JCL procedures as needed. Mentored junior level application programmers.

Confidential

Software Engineer

Provided technical programming support to the Purchase Order Processing and Marketing Departments. Held fact finding meets to gather system requirements and client input for new projects and system enhancements. Performed analysis and design tasks to develop COBOL batch programs that ran against VSAM and IMS data stores. Developed COBOL programs to retrieve and process point-of-sale transactions from AS400 systems. Developed programs to maintain the various databases, or created reports for the Accounts Payable, Accounts Receivable, Inventory and other Departments. Designed and implemented COBOL CICS on-line program fixes as needed. Provided production support to nightly batch program abends. Developed new JCL procedures, or enhanced existing JCL procedures as needed.

Confidential

Systems Analyst

Provided technical programming support for the Accounts Payable, Accounts Receivable and Inventory Merchandise Information Systems. Involved in many fact-finding meets to gather requirements for new projects or system enhancements. Performed analysis and design tasks to develop COBOL batch programs that ran against VSAM and IMS data stores. Developed programs to maintain the various databases, or created reports for the Accounts Payable, Accounts Receivable, Inventory and other Departments. Designed and implemented COBOL CICS on-line program fixes as needed. Provided production support to nightly batch program failures. Developed new JCL procedures, or enhanced existing JCL procedures as needed.

Operations Analyst

Primary responsibility was to ensure a nightly batch schedule completed within a specific time frame and to ensure all CICS regions started on time. Also, resolved batch job abends, monitored telecommunications equipment and other mainframe related equipment, made sure reports were produced in a timely manner, delegated various tasks to other team members, reported hardware problems to the appropriate vendors, and provided technical training to the Computer Operations staff.