We provide IT Staff Augmentation Services!

Programmer Analyst Resume

SUMMARY:

Mature professional, with over 19 years of experience in software development and testing. Achieved Oracle Certified Professional (Internet Application Developer, Oracle Forms Developer Release 6/6i). Completed several projects through the complete software development life cycle. Specialized training for software testing. Strong mix of communication, technical excellence, and a proven ability to learn new skills and technologies. Updated skills in c#, .Net, Angular, git, and JavaScript.

TECHNICAL SKILLS:

  • Oracle
  • Oracle PL/SQL
  • Oracle TOAD
  • Oracle Forms
  • Oracle Reports
  • SQL
  • Apprworx
  • Word
  • Excel
  • SQL Developer
  • XML
  • Java
  • PVCS
  • Access
  • Visio
  • HTML
  • CSS
  • JavaScript
  • Unix
  • Outlook
  • CoreFTP
  • Asp.net
  • WinSCP
  • Zoom
  • Lotus Notes
  • Slack
  • Trello
  • Active Batch
  • Oracle BI Discoverer
  • TSQL
  • Microsoft SQL
  • Git
  • Agile
  • Balsamiq
  • C#
  • Crystal Reports
  • ASP.net
  • JavaScript
  • CSS
  • FormsAPI

WORK EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

  • Maintenance of existing retail application used for pricing, purchasing, and inventory of merchandise.
  • Research to determine the needed changes, make changes and then test changes and promote changes.
  • Two new Oracle PL/SQL packages, procedures, and functions for determining retail ROI calculations. Calculations have five different paths(sources) of finding data, combinations of sources included for store level, and company level, historical, projection using last week of sales, promotion or price change. Data was stored in 7 different tables with multiple conditions to check date ranges and flags. Additionally, calculations were done by promotion, department, product and season. The new Oracle PL/SQL package was then used by Oracle Forms and Oracle BI Discover.
  • Virtual column added to the table for maintaining the season code.
  • Created validation for the season code across application with over 100 Oracle Forms, Oracle Reports, and Oracle PL/SQL code using FormsAPI tool. Centralized the logic for validation by adding to an existing PL/SQL package.
  • Enhanced Oracle Report that is matrix style. The report is used for the summary of pricing information including the quantity and amount. Added additional range to be displayed vertical across page. In depth formatting of report to included header information and labels for summary information making report more readable. Modified Oracle form that was used to maintain ranges to include a message when the number of ranges was exceeded.
  • SQL Script for updating weekly data for company and store.
  • Modification CA Technologies Automic job scheduler.
  • Use QuikBase for assignments and project management.

Confidential

Senior Developer

Responsibilities:

  • Conduct back - end development utilizing Oracle technologies (SQL, PL/SQL, partitions, indexes, triggers, procedure, packages) HP ALM and ADR for documenting and requesting approvals for compliance. Health care, file handler Agile and Waterfall software development cycle.
  • Responsible for creating new and modify existing software application (file handler jobs). conduct unit testing, regression testing, test cases, and test plans.
  • Design, code, testing debugging and documenting claims encounters, HIPPA, and Health Care Information.

Confidential

Oracle Developer

Responsibilities:

  • Responsible for development around Oracle PL/SQL, SQL, Oracle Forms and Oracle Reports.
  • Perform code review/research of active batch jobs, shell scripts, SQL and PL/SQL Data analyst.
  • Upgrade from 6i to 11g Oracle Forms and Reports
  • System wide update of address and phone number change for Oracle Forms and Reports.
  • Modification to notices and letters.
  • Write standards document and design, create test plans, perform test plans Pharmacy Benefit Management,health care, HIPPA.

Confidential

Oracle Developer

Responsibilities:

  • Responsible for development around Oracle PL/SQL, SQL, Oracle Forms and Oracle Reports.
  • Perform code review/research of active batch jobs, shell scripts, SQL and PL/SQL Data analyst.
  • Upgrade from 6i to 11g Oracle Forms and Reports
  • System wide update of address and phone number change for Oracle Forms and Reports.
  • Modification to notices and letters that were generated by system using Oracle Reports.
  • Upgrade to of 6i to 11g Oracle Forms and Reports
  • Write standards document and design, create test plans, perform test plans Pharmacy Benefit Management,health care, HIPPA.

Confidential

Sr. Lead Application Developer

Responsibilities:

  • Identify and document current processes with technical and user documentation Excel file used for report weekly and monthly statistical data. Review and changes to scripts for auditing. Scripts to edit data.
  • CoreFTP, Putty, Weblogic Linux.
  • Oracle PL/SQL, SQL, Oracle Forms, Oracle Reports.
  • Worked on Heat Ticket's and SIR's, On Call Support for TAS (Tax Application System) Lead efforts in improving process TAS integration on call support of CMR.

Confidential, Phoenix, AZ

Sr. Lead Application Developer

Responsibilities:

  • Oracle PL/SQL, SQL, Oracle Forms, Oracle Reports and COBOL.
  • Work on Heat ticket's and SIR's, On Call Support for TAS (Tax Application System) Lead efforts in improving process for TAS integration on call support of CMR.
  • Identify and document current processes.
  • Excel file used for report weekly and monthly statistical data CoreFTP, Putty, Weblogic Linux.

Confidential, Lawrenceville, GA

Oracle Developer

Responsibilities:

  • Created and modifed existing Oracle Forms used for piece loading and storage topology. This included adding columns and functionality to forms that were requested by customer. Also, made changes to existing forms.
  • Managed Oracle PL/SQL, triggers, packages, procedures and functions.

Confidential, Grand Rapids, MI

Oracle Report Writer / PL/SQL

Responsibilities:

  • Wrote Oracle PL/SQL packages used to create files sent to external customers.
  • Worked with end user during the software development cycle.
  • Handled requirements, design, coding, troubleshoot, testing, user sign off.

Confidential, Madison, WI

PL/SQL Programmer

Responsibilities:

  • Handled enhanced existing Oracle PL/SQL packages to support new business needs. Wrote PL/SQL that is used with user interface and batch processes.
  • Responsible for preparing all technical documentation.
  • Created test plans and performed testing.

Confidential, Bridgeville, PA

Programmer / Oracle Report Writer

Responsibilities:

  • Managed PL/SQL package for analyzing and creating delinquent records for accounts receivable tables.
  • Responsible for PL/SQL for supporting existing packages for distribution and accounts receivables.
  • Also PL/SQL and SQL used for lead list and claim process. SQL used for various Oracle Reports.
  • Meet with department managers, office managers, vice president, DBA and other developers during all phases of software development including the following: requirements gathering, application design, coding, testing and user acceptance.
  • Production support of existing Oracle PL/SQL and Oracle Reports.
  • Maintained and created new Oracle reports used for collection of current and delinquent local taxes, real estate tax, business privilege and mercantile tax.
  • SQL and PL/SQL used for reporting of effectiveness of collection efforts, statistical data and error detection reporting.

Confidential, Winston Salem, NC

Programmer Analyst

Responsibilities:

  • Automated loading and processing of servicer provided Loss Mitigation data that was provided from servicer portal. Created new PL/SQL packages used to load file to loading tables and then process data to production tables.
  • Maintained PL/SQL packages used for loading and processing notice of default files. Prepare project plans and weekly status reports.
  • Prepared visual data mapping from file to loading tables, operational tables and display screens. Prepare Solution Design Document (Function Specification) and process flow charts for new business processes.
  • Created test plans and test cases, work with users and SQA during testing. Develop Appworx chains and modules for loading files and processing data.
  • Responsible for new Oracle reports for summarizing default status by states. Oracle Report for dynamic generation of first notice of default letter sent to borrower.
  • Worked with database triggers to automate the capture of data across department areas. This helped Claims and Quality Assurance departments be more informed about QA events, status, approval and denials.

Confidential, Farmington Hills, MI

Oracle Developer

Responsibilities:

  • Used SQL, PL/SQL, functions, procedures, packages, and database triggers for the Preferred Customer Application.
  • Maintained existing invoice marketing application that was in Oracle PL/SQL packages, Oracle Forms and Oracle Reports Worked on team of 8 for the conversion of invoice marketing application to a web based application using HTML, Cold
  • Fusion, JavaScript and Oracle SQL and PL/SQL.

Hire Now