SUMMARY

• Business Requirements gathering and definition
• User Acceptance Testing including PL/SQL Extract and Reporting Packages
• Process and Run Control documentation
• 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
• 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

TECHNICAL SKILLS

 PROFESSIONAL EXPERIENCE:

Oracle Developer

• Business Requirements gathering and definition
• User Acceptance Testing including PL/SQL Extract and Reporting Packages
• 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: PeopleTools 8.49, PeopleSoft HCM 9.0, Peoplecode, AE, CI, SQR, and PS Query; Oracle SQL Developer;

Confidential,

Oracle Developer/Senior Business Analyst/Technical Specialist

• 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
• 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, SQR, PS Query; Crystal reports; XML Publisher;  Oracle

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

ETL and Oracle Developer  / Senior Technology Consultant/Business Analyst

• 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.

Oracle and ETL Developer/Technical Project Leader

• 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.

SQL Developer/Senior Programmer Analyst

• 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.

Oracle Developer/Senior Programmer Analyst

• 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).

SQL Developer/Technical Project Leader/Systems Analyst

• 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.