PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft HCM/FSCM Functional/Technical Analyst

Responsibilities:

• Business Requirements Definition and Technical Solution Design
• UAT, SIT, and Unit/Regression Testing
• Process and Run Control documentation
• HCM Security Redesign
• SumTotal Learning Management System Interface Analysis, Design and HR extract script creation
• Ad Hoc reports for HR application and integration troubleshooting Finance Support
• Integration Broker Troubleshooting and defect resolution
• Expense Module support

Skill Set: PeopleTools 8.53, PeopleSoft HCM 9.1, PeopleSoft FSCM 9.1/9.2, PS SQR, PS Query, Application Designer, MSS SQL, SQL Server Management Studio, MS Office Suite

Confidential

PeopleSoft/Oracle HR Professional

Responsibilities:

• Business Requirements gathering and definition
• UAT, SIT, and Unit/Regression Testing
• Process and Run Control documentation
• PeopleSoft SQR Process design and coding of Benefits Administration conversion/plan enrollment for AXA New Company project

Skill Set: PeopleTools 8.52, PeopleSoft HCM 9.1, PS SQR, PS Query, SQL, PL/SQL, AQT Oracle Development tool, MS Office Suite

Confidential

PeopleSoft/Oracle HR Professional

Responsibilities:

• Design and maintenance of menu, component, query, and row - level security roles and permissions for all HCM application access
• Dynamic Role creation
• Functional analysis, design, testing, and documentation of Workforce Administration Reports and Interfaces and SunGard Business Continuity Interface
• Design, coding, and maintenance of Department, Job Code, Position, and Payroll Interface Configuration
• Administrator of PeopleSoft SOX Regulatory Compliance including report creation, access verification and inter-departmental coordination
• Process Scheduler Job and Recurrence creation and maintenance
• PeopleActions Job Action customization testing

Skill Set: PeopleTools 8.53, PeopleSoft HCM 9.2, PS Query, TOAD, MS Office Suite

Confidential

PeopleSoft Oracle Developer/ HCM Conversion Specialist /Business Analyst

Responsibilities:

• Business Requirements gathering and definition
• User Acceptance Testing
• Process and Run Control documentation
• PeopleSoft Application Designer online and batch AE and SQR process design and coding for Job and Benefits Administration conversion and processing
• PeopleSoft Security access modifications including Tree Structure and User Group creation and updates, and Role, Permission List, Operator Id maintenance
• PeopleSoft Internet Architecture Component, Page and Run Control creation for conversion processes
• Run Control Security, Process Permissions, and Parameter creation.

Skill Set: People Tools 8.49, PeopleSoft HCM 9.0, Peoplecode, AE, CI, SQR, and PS Query; Oracle SQL Developer, MS Office Suite.

Confidential

PeopleSoft Developer/Senior Business Analyst/Oracle Technical Specialist

Responsibilities:

• Heavy End User Interaction gathering business and technical requirements
• Writing technical specification and designing database schema and data system’s data flow
• Creation of Oracle PL/SQL multi-level Triggers to enable agency inventory interface table inserts and updates
• PeopleSoft Application Designer online and batch FIN and HR AE process enhancements
• PeopleSoft Security access modifications including Tree Structure and User Group creation and updates, and Role, Permission List, Operator Id maintenance
• Peoplecode Component Interface enhancements including embedded SQL event processing for FIN eProcurement online functions
• Design and coding of Inventory Interface ETL process via Peoplecode AE Processes and Informatica Mappings to capture client Inventory activity data
• Development of AE process for FIN AR Vendor processing including new Pages, Component Interface, and AR Menu update, Run Control Security, Process Permissions, and Parameter creation, LINUX FTP account setup
• Peoplecode Page enhancements for HR online Job Search function including component and page search criteria changes and Peoplecode Class object changes
• PeopleSoft SQR Program Development and enhancements for FIN AR, GL Project Cost Analysis, and HR reports including Time and Attendance reporting
• PS Query development and enhancements for FIN GL, AP, AR, Project Cost Analysis, HR Employee Benefits, HR Time and Attendance, HR Organization/Employee Reports
• PS Crystal Report enhancements included FIN GL Project and HR Organizational Summary reports
• PS XML Publisher Report development and enhancements for HR Benefits, FMLA Letters, Employee Status Change Notifications.

Skill Set: PeopleSoft 8.49/9.0, Peoplecode, AE, CI, Informatica, SQR, PS Query; Crystal reports; XML Publisher; Oracle

PL/SQL; LINUX ksh; Phire; TOAD; MS Office Suite.

Confidential

ETL Oracle Developer/Senior Technology Consultant/Business Analyst

Responsibilities:

• Analysis, design, coding and testing for PF ETL components
• Produced SOW utilizing standard project documentation requirement
• Designed and coded Data Stage source data extract mapping transformations
• Created batch Jobs and updated FDW nightly extract Job Sequence to include new PF load Job dependencies
• Updated FDW Oracle PL/SQL daily load package to include new PF procedure
• Modified existing package and procedures for inclusion of new PF data elements including load of FDW Data Mart
• Created new Oracle FDW staging table for PF data and modified existing Sub Project LE target table to include new PF data elements and additional referential constraints
• Performed analysis for Business Object universe enhancements and assisted in the creation of new Pegasus Universe for PF table and data elements
• Defined additional constraint relationships with existing FDW reference structures
• Performed UAT and documentation of FDW enhancement modifications

Skill Set: Oracle; UNIX ksh; PL/SQL, Data Pump, DataStage; Informatica, Business Objects; TOAD.

Confidential

ETL Oracle Developer/Technical Project Leader

Responsibilities:

• Analysis, design, coding, testing and implementation of Account Dimension table conversion programs and jobs for Piper Jaffray corporate account merger
• Analysis, design, coding, testing, and implementation of DB2 Extract, Transform, and Load process for the Legal and Compliance Account Classification and Approval Dimension table
• Functional Business Analysis for Retail Managed Account reporting and analytics requirements
• Informatica Extract, Transform, and Load process design, development
• User Acceptance Test Case development and execution

Skill Set: Oracle; UNIX ksh; SQL, Informatica PowerMart/PowerExchange; CA Autosys; PVCS; COBOL; Z/OS DB2; BMC Tools; StarTool; TWS/OPCA job scheduling tool; JCL; VSAM; SAS; Excel; Changeman; Visio; Project.

Confidential

SQL Developer/Senior Programmer Analyst

Responsibilities:

• Analysis, design, coding and implementation of performance and functional enhancements for ClientServ online Statement system
• Performance tuning of VSAM Index structures and extract Procedures for sorting and loading DB2 tables
• Creation of new job streams including OPCA schedule dependency updates for QA Environment
• Maintenance of extract/format program for Gain and Loss Statements changes
• Integration testing and analysis of monthly Statements enhancements through the ClientServ extract and load process
• Analysis and coding of special branch office request for yearly Statement data extract and reformat to Excel spreadsheets.

Skill Set: COBOL; DB2; MQ Series; Smarttest; FileAid; TWS/OPCA job scheduling tool; JCL; VSAM; Excel; Changeman.

Confidential

Oracle Developer/Senior Programmer Analyst

Responsibilities:

• Analysis, design, coding and implementation through UAT of performance and functional enhancements for Flat Fees database Extract and Reporting sub-system
• Creation/tuning of Oracle PL/SQL database extract function
• Design/coding of Flat Fees Incomplete Transaction Report including UAT of new modules and script modifications
• Design and coding of Client Loader Exception Report via AWK ksh including Infocenter Jobset modifications for new script
• Functional analysis and redesign of ATLAS II system-wide application error handling and reporting functions
• Creation of error handling template module
• Documentation of error message cases and new error handling implementation procedure
• Creation of standard error message copybooks
• Modifications to ATLAS II modules for inclusion of standardized error handling.

Skill Set: AIX UNIX/AWK/ksh /Microfocus/Animator/Oracle8i/UDB/PL/SQL/UNIKIKS (MFC CICS).

Confidential

SQL Developer/Technical Project Leader/Systems Analyst

Responsibilities:

• Rate Availability Database and System Conversion updates to CICS/DB2 programs and screens
• Budget Maestro Reservation Delivery System Conversion updates to CICS/DB2 MQSeries programs/CICS screens
• Avis Wizard Reservation/Rental System Conversion: Design, coding and implementation of IMS to DB2 database conversion processes
• Screen, Program, PSB, CICS Transaction, Procedure and Job creation for converted processes
• Performed Unit, Integration, and System testing of CICS transactions, MQSeries interfaces, DB2 queries and online system functionality
• Created UAT test cases for online system and MQSeries processing
• Created Functional system documentation, Technical specifications, Screen layouts, Job Run books, User guides.

Skill Set: Mainframe/UNIX: COBOL; Assembler; IMS, CICS, MQ Series, DB2, UDB, VSAM; Visio.