Project Manager Oracle

Joy Bonds

Email: abpk7d@r.postjobfree.com

Address: * **** *****

City: Greenville

State: SC

Zip: 29609

Country: USA

Phone: 864-***-****

Skill Level: Experienced

Salary Range: $95,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

joy bonds

project software developer/analyst

Education

BS, Administrative Management, Clemson University, Clemson, SC

Other Professional Qualifications

Title (Software, Training, Distinguishing Qualifications)

Oracle SQL and PL/SQL

Oracle R11i Oracle HRMS Benefits Technical Foundation

Oracle R11i Oracle HRMS Technical Foundation Human Resource

Oracle Forms Development

Oracle Peopletools I

SQR for Peoplesoft

Systems and Tools

HP/Linux, Linux shell scripting, Oracle E-Business Suite 11i, Oracle 10g database, Toad, SQL, PL/SQL, Cobol, iSeries v3-v5, DB2, AS.400 CLP, Lawson 7.2 on iSeries, Microsoft Office, Microsoft Outlook, SubVersion, Service Now (IT Service Management portal), Sharepoint, SQR for Peoplesoft

Relevant Experience

Senior computer programmer/analyst with over 20 years experience working on small to large projects in the real estate (REIT), engineering, and textile industries. She has extensive knowledge and experience in entire development life cycle including analysis, design, development, testing, implementation and documentation.

Representative Work History

Aimco/Critigen: 1997 to present

Project Software Developer/Analyst, Critigen, Greenville, SC, 01/10-Present. Supported Aimco Oracle E-Business Suite 11i on HP Linux platform as primary developer/analyst. Created and maintained inbound and outbound Payroll, Benefits and Human Resources integrations using Oracle stored procedures, PL/SQL packages, Linux shell scripts, concurrent programs, executables, request sets, custom Oracle tables, database links, and Oracle common lookups; also provided troubleshooting and found solutions for Oracle OAB applications issues. Acted as IT liaison to (Aimco) Payroll, Benefits and HR business users while performing all roles in development life cycle. Major contributor to annual Aimco Benefits Open Enrollment via development of new benefits integrations which included full systems testing with QA, business users and vendor contacts. Supported Aimco Peoplesoft Financial Systems 9.1 on HP Unix platform through enhancements of custom SQRs in the areas of General Ledger, Billing and Accounts Payable.

Programmer/Analyst IV, Aimco, Inc. Greenville, SC, 01/08-12/09. Responsible for maintaining and enhancing newly implemented Oracle system, in particular, all custom Payroll, Benefits and HR integrations. Supported Oracle E-Business Suite 11i on HP Linux platform. Acted as developer, designer, business and technical analyst and technical writer while creating and modifying inbound and outbound integrations using PL/SQL packages, stored procedures, functions, Linux shell scripts, concurrent programs, executables, requests, custom Oracle tables, database links, and Oracle common lookups. Developed new benefits integrations for employee disability, life insurance, and 401k enrollments. Supervised contractor developers by providing technical direction and functional and technical analysis. Major contributor in the outsourcing of intranet time card system to ADP through the development, testing and technical documentation of major inbound and outbound Oracle integrations to ADP, including employee exports, time card imports and the supervisor hierarchy updates to Oracle person assignments via Oracle API.

Programmer/Analyst III, Aimco, Inc. Greenville, SC, 02/06-12/07. Programmer/Analyst for conversion to Oracle E-Business suite while acting as sole developer for Lawson HRMS legacy system on iSeries v5. Major contributor in migration of HRMS from Lawson iSeries v5 to Oracle E-Business 11i suite on HP Linux. Designed, developed, and tested all Lawson data conversions for Oracle import and collaborated with vendor to develop functional and technical specifications for over 30 custom integrations for Oracle. Worked closely with business leads as business analyst, designer, and developer to convert eight years of Lawson history data including person, assignment, salary, benefits and payroll to denormalized Oracle custom tables.

Application Development Manager, Aimco, Inc. Greenville, SC, 08/04-01/06. Application Development Manager for Lawson system. Acted in supervisory role over Lawson contractor/developer, providing technical leadership and direction for team. Responsibilities included the management of Lawson projects, such as annual Benefits Open Enrollment changes, the application of Lawson upgrades and patches, development of new integrations with other internal or external systems, quarterly and annual performance counseling and reviews, and collaboration with business user community and other IT/S teams. Acted as lead analyst, designer and developer for the team, performing troubleshooting of custom and Lawson proprietary code and the development of custom enhancements, such as 401k non-discrimination testing and new benefits integrations to health/dental and flexible spending third party providers.

Programmer/Analyst II III, Insignia Financial Group/Aimco, Inc. Greenville, SC, 02/97-07/04. Programmer/Analyst for Lawson Human Resource Management System (6.2, 7.1, 7.2), paying over 6000 employees in more than 40 states. Worked in liaison role with Payroll and HR business users to troubleshoot issues and develop new custom solutions for Lawson system using Cobol, CLP and AS.400 query languages. Solutions included: new custom interfaces to ancillary systems; inbound and outbound; internal and external; such as Aimco intranet time card system, Aimco performance management system, Peoplesoft financials system, and new third party benefits providers. Other projects included: original configuration of Aimco benefits plans (health, dental, vision, flexible spending, health savings and 401k) in Benefits module and original configuration of Aimco time accrual plans in the Time Accrual module. Also functioned as the project manager and technical lead for annual Benefits Open Enrollments making all configuration changes in Benefits module, modified Lawson employee self service web pages using Javascript, and coordinated all benefits plan year transition activities with business users and Computer Operations. Additional projects were: data conversions and code modifications for Lawson 6.2 to 7.1 upgrade; project manager and sole technician for two major BSI Tax upgrades; implementation of Aimco security policy on the iSeries through the remediation of object security, authorization lists, and security classes, and; documentation of all Lawson technical processes as requested by Security Officer.

PROPOSAL REFERENCE

Contact this candidate