SUMMARY

Reliable and efficient senior programmer with 20 years of experience in database development and implementation and support of Oracle ERP systems Payroll and Human resources . Motivated learner with proven track record in meeting and succeeding with new challenges. Team-leader with excellent communication skills to coordinate between business and IT. Experienced in multiple platforms resulting in excellent problem-solving skills.

COMPUTER SKILLS

• Languages:
• Oracle PL/SQL
• UNIX Shell Scripting
• MicroFocus/Mainframe COBOL
• Software:
• Oracle database up to 11g
• Oracle HR/Payroll/Benefits R11i 9i database
• LogiXML Report Writer
• PLSQL Developer
• Oracle Reports Builder
• Oracle Forms
• Oracle Designer
• Microsoft Windows
• Microsoft Excel
• Microsoft Access

EXPERIENCE

Confidential

Director of Operations / Billing

• Strong communication interface among insurance companies, therapists, and clients about mental health benefits and payments.
• Acquired oral comprehension in the verbal command of the Spanish language.
• Responsible for billing and scheduling for all clients. This includes ensuring all insurance reimbursements are completed.
• Maintain confidential records, financial, and statistical data for the counseling firm according to current HIPPA standards.
• Implementation and upkeep of software program for mental health professionals
• Responsible for all technical issues with the office computers and fax machine.
• Website re-design and maintenance.

Confidential

Oracle Developer 2 month contract

Responsible for creating a new process for budgeted positions. This involved creating new forms, reports, tables, triggers, and sequences.

Confidential

Oracle Developer

• Responsible for updating existing and creating new Oracle code. This includes packages, procedures, functions, triggers, tables, etc, all supporting the RezExpert application.
• Research issues noted by users to determine root cause.
• Share responsibility for converting new properties into RezExpert Oracle database. This is done via Microsoft Access, Oracle scripts, and trouble-shooting any issues that arise.
• Create Oracle reports in Excel. This allows users to run reports against the Oracle database without needing any reporting tool.

Confidential

Database Developer

• Responsible for running campaigns for team's client using Alterian.
• improve procedures in all aspects
• extract data from Oracle into Alterian via DOS and PL/SQL scripts
• obtain specifications from client
• create Unix scripts to help validate data
• set up tables for QC support
• assist BSAs with QC support
• create Engineered Fields as needed
• troubleshoot Load process
• assist client with Alterian issues
• train other team members in Alterian
• Maintain Oracle software for team.
• Create and update packages, procedures, tables, and other PL/SQL objects supporting company's Loyalty program application
• Create and update Unix scripts

Confidential

Oracle Team Lead / Senior Developer

• Team lead responsible for development and deployment of caroffer.com on an Oracle platform. An online application supporting millions of hits per month.
• Knowledge of automotive industry.
• Development of error handling routines to monitor exceptions
• Development of complex PL/SQL procedures and triggers.
• Involved in data modeling efforts to build new and enhance existing custom applications.
• Knowledge, understanding, and working experience in generating and parsing XML in oracle.
• Responsible for system performance tuning utilizing Explain plan and other tuning techniques.
• Responsible for designing and developing a Remarketing Portal which allowed the tracking and management of all vehicle inventory from transportation to the sale of the vehicle.

Confidential

Senior Programmer / Analyst

• Involved in major Oracle Applications enhancements and customizations that allowed DISD to be acknowledged as Innovator of the Year at OAUG 2005.
• Worked in many aspects of support in the Software Support department, Payroll/HR and Financials side.
• Created countless Oracle reports and Oracle forms to assist users in their everyday work.
• Created Element entries for Payroll.
• Lead developer for Oracle Workflow and Alerts.
• Managed full project life-cycle.
• Trained coworkers in different areas Oracle.
• Familiar with discoverer administrator tool.

Confidential

Programmer / Analyst

• Worked in all aspects of support in the Cyborg Technology Support department - including running pay runs, creating Cyborg screens and reports, creating Oracle reports and forms.
• Operated as Cyborg Security Officer.
• Maintained and enhanced the WestCorp System.
• Dealt with user support, correlating between Cyborg and oracle, shell scripting, W2 processing, and installations.
• Analyzed existing key Cyborg report, improving run-time by 10 .
• Successfully led W2 production project.
• Created new W2 process, allowing local production and control of all required forms.
• Re-vamped Cyborg security profiles, ensuring proper security to users.

Confidential

Programmer / Analyst

• Versatile member of the Dime Bank project, able to facilitate multiple projects.
• Designed and coded Cyborg programs for conversion.
• Administered project controls and scheduled coding problem resources.

Confidential

Programmer / Analyst

• Analyzed Payroll, Human Resources, and Benefits departments' systems for improvements.
• Improved design of and created reports for Payroll, Human Resources and Benefits by using Cyborg and MicroFocus COBOL.
• On-call programming support for weekly payroll runs.
• Upgraded PCs to Cyborg 2.5 and assisted users in problem solving due to the upgrade.
• Created new process for annual Equal Employment Opportunity Commission report, allowing data to be downloaded rather than manually transcribed.

Confidential

Applications Programmer

• Created, modified, and monitored team applications using COBOL. Received Programming Group of the Year award team effort .
• Functioned as Project Team Leader.
• Trained new employees.
• Created Electronic Forms System reducing paper trail by 35 .
• Created user-defined electronic forms, allowing e-forms to be created by user. Received Achievement award .
• Created Data-Based Advertising system, allowing clients to send revenue-creating mailers to their customers.