We provide IT Staff Augmentation Services!

Database Developer Resume Profile

Objective:

  • A team player with excellent analytical and communication skills looking to
  • expand my career as an Information Technology Professional.
  • Software Knowledge
  • Oracle 7.3,- 12c Oracle Enterprise Manager 12 Subversion PowerBuilder 6.5 11.1
  • PL/SQL Oracle SQL Developer TeamForge COM / Active X
  • Relational DB Design UNIX Shell Scripting Java script Visual Basic
  • Tidal IBM Clear Case / Quest DB Artisan Crystal Reports . 11
  • Scrum Works Eclipse Sybase EA Server 12.5

Experience

Confidential

Database Developer

  • Coordinated and performed database changes for development teams as needed for production releases.
  • Created triggers, procedures, packages, tables, public synonyms, grants, materialized views and etc.
  • Implementation of semi-annual releases of new database functionality for the CCISites.
  • Implemented database functionality using Agile and Scrum methodologies.
  • Created data and object backups and created back-out procedures for new functionality implementations.
  • Tuned query statements using SQL Tuning Advisor in OEM, Oracle Enterprise Manager.
  • Implemented profiles for queries using OEM to enhance query performance.
  • Packed and unpacked SQL profiles for moving profiles between Oracle db environments DEV, UAT, QA, PRD
  • Performed database schema comparisons using OEM to ensure objects and code matched.
  • Used Oracle Flashback table for recovery of data on specific tables.
  • Wrote queries using Oracle Hierarchy functionality such as Pivot, Over Partition By and Connect by Leaf.
  • Performed on call operations for database issues sent via the Help Desk ticketing system.
  • Created change controls and coordinated with the on call DBA specific changes for QA and Production.
  • Sought out high CPU usage or long running queries for tuning using OEM.
  • Set up meetings between Customers and or other developers as needed for completing projects.
  • Consistently used Subversion for Versioning of Database objects.

Confidential

Consultant

  • Created Oracle PL/SQL packages providing new functionality for the SYSTEM ONE and OPUS databases.
  • Completed the New Business Estimated Annual Premium Process using Oracle PL/SQL
  • Completed the VW Claims Paid To Date Process using Oracle PL/SQL
  • Created before and after triggers in an Oracle 11g environment.
  • Created and modified reports using Crystal Reports 11.
  • Implemented new and existing Crystal Reports in Business Objects using Central Management Consol.
  • Completed the Eservices Email Project using Oracle PL/SQL.
  • Created Views for Cincom Letter creation via trigger and ADHOC generation.
  • Documented new processes complete with Source code, Unit Testing / Results, Charts and Details of Process Flow.
  • Tuned existing report queries for optimal performance.

Confidential

Consultant

  • Client/Server Application Programming in Powerbuilder and PL/SQL for Oracle 10g.
  • Created reports that populate Excel spread sheets for the ICE Project using PL/SQL, Powerbuilder and VBA.
  • Created Oracle PL/SQL packages, stored procedures and functions for the HIPS application.
  • Communicated with actuarial underwriters in gathering requirements for the ICE Project.
  • Created Proxy objects in Powerbuilder that call java routines.
  • Modified and tuned existing Powerbuilder and Oracle PL/SQL code for optimal performance.
  • Corrected production issues and change requests related to the application and database.
  • Continued usage of strong development methodology and documentation skills.

Confidential

Senior Programmer

  • Client/Server Application Programming in Powerbuilder and PL/SQL for Oracle 8i and 10g.
  • Rewrote the month end Oracle stored procedure into a package to reduce execution time and apply flexibility for the Accounting application.
  • Responsible for the design, development, testing and implementation of PL/SQL for the Accounting application.
  • Created adhoc reports from business specifications using PL/SQL and or Powerbuilder.
  • Created Indexes where needed to enhance query performance.
  • Programmed enhancements and maintenance using J2EE and Java script.
  • Successfully setup Rational Application Developer RAD for each version of the Vision application.
  • Created Stored Procedures, Packages, Triggers and Functions for the Accounting application.
  • Corrected Bugs and production issues for both the J2EE and PowerBuider applications.
  • Migrated the Accounting and EBilling applications from PowerBuilder 6.5 to PowerBuilder 11.1.
  • Compiled new releases of the Accounting and E-Billing applications into DLL files.
  • Document work flow and test plans for both the database and the application.
  • Provided estimates for programming enhancements and defects.
  • Provided the Change Management group with the proper documentation for new releases to Staging and Production.

Confidential

Senior Systems Analyst

  • Client/Server Application Programming in Powerbuilder and PL/SQL for Oracle 8i and 10g
  • POC Point of Contact in Pittsburgh for the CDC to IDC Kenan Billing system migration.
  • Subject Matter Expert for the OEOM application.
  • API programming with PL/SQL Stored Procedures for KMC Order rebuilds in Oracle 8.i.
  • Creation of stored procedures with PL/SQL that removed orders from the entire OEOM system.
  • Provided Adhoc query reports using PL/SQL for the Pricing Department upon request.
  • Data modeled the transfer of data from OEOM database to the Data Warehouse.
  • Wrote SQL Loader scripts for migration of data from one Oracle Database to another.
  • Programmed the EVPL Quoting Tool using VBA for Excel based on specs defined from the customer.
  • Rewrote the EVPL Quoting Tool using JSP Java Server Pages .
  • Setup of TomCat Server on my machine for JSP development.
  • Modified the Java Script APIs for the Legacy Conversion project.
  • Maintained the PL/SQL stored procedure for the OEOM application.
  • Wrote APIs in Java script to access the existing Kenan APIs for the IXPlus Conversion of Oracle data.
  • Successfully migrated Sybase data to Oracle using JDBC.
  • Decompiled existing Java Class files to get missing source code to enhance the E-Billing system.
  • Created reporting and backup tools in Powerbuilder as needed for the Business.
  • Wrote proposals for new enhancements to the OEOM application Aurora based on business requests.
  • Programmed enhancements in PowerBuilder 6.5 for the OEOM application Aurora.
  • Maintenance of external customer accounts for the E-Billing system via Java Scripts in an UNIX environment.
  • Provided information concerning the Powerbuilder application Aurora for various API Projects.
  • Provided daily maintenance of operations for our Business partners including 3rd level application support.
  • Created Methods and Procedure documents and mentored co/workers on how to properly correct issues.
  • Analyzed, programmed and implemented new functionality in Powerbuilder for the Price Change Tool
  • Created CRs Change Requests as needed when Production issues were found.
  • Maintenance of production Service Order data for Monthly Billing cycle.

Confidential

Consultant.

  • Client/Server Application Programming in Powerbuilder 7 9 and MS SQL Server
  • Provided application support for client's customers.
  • Investigate and corrected issues raised about the applications OFS and STPS.
  • Created XML files for passing data between systems.
  • Responsible for all DDL changes in the MS-SQL Server database for the Republic Project.
  • Enforced corporate policies concerning data integrity, normalization, functionality and naming standards.
  • Programmed new functionality in Powerbuilder 9 for the Republic Project.
  • Wrote new enhancement proposals for the existing customer applications.
  • Programmed new enhancements in Powerbuilder 7 9 for the existing customer applications.
  • Created COM DLL objects in Powerbuilder 9 to work with .NET DLLs .
  • Proposed Bar Coding Solutions for the client to meet their Customers' needs.
  • Researched, compared and reported on 3rd party email software for use in OFS and SPTS.
  • Responsible for the build process of the correct Merant versions for the applications OFS and SPTS.
  • Standardized and documented procedures

Confidential

Consultant.

  • Provided support for the MBS Passthru, CMO, Allocation, and Prime Brokerage groups.
  • Standardized and documented procedures in the role of Operate for the Mortgage Back Securities Group in Delaware.
  • Investigate reconciliation breaks and manually modified production data using sql scripts.
  • Performed various other production updates on request from the business community.
  • Read through stored procedures and Unix shell scripts to correct production bugs.
  • Wrote and maintained reports using VBA for Excel for the Prime Brokerage Group.
  • Wrote Adhoc reports using Unix shell and Sybase SQL for users as per request for the MBS Group.
  • Responsibly on call via pager for correcting issue with the nightly batch jobs running in Unix.
  • Traveled to client office in Jersey City for on site support during Class A 48 hour day.
  • Provided release management of in house applications from development to user acceptance testing to production.
  • Completed the Resilience Project for the North America Fixed Income Department
  • Maintained the Service Level Agreement for Stars MBS.

Confidential

Consultant.

  • At Information Solutions.
  • Client/Server Application Programming in Powerbuilder 8 and Oracle 9.i
  • Maintained and added new functionality to the application Envision while maintaining PFC standards using PowerBuilder 8.
  • Developed and implemented emailing of reports with out user interaction.
  • Developed a maintenance interface for emailing reports.
  • Designed an engine in PowerBuilder 8 to evaluate shipment routing rules.
  • Created stored Packages, Procedures, Functions and Triggers in Oracle 9.i.
  • Tuned existing Packages, Procedures, Functions and Triggers for optimal performance.
  • Imported and massaged data using SQL Loader.
  • Troubleshoot existing data flows and re-engineered them.
  • Data Modeled new tables and the logic flows between the tables.
  • Developed an interface for scanning barcodes using PowerBuilder
  • Created packing slips to resemble existing packing slip forms using PowerBuilder 7.

Confidential

Systems Specialist.

Trade Support System

  • Promoted to Systems Specialist. One step above Sr. Programmer / Analyst.
  • Dynamically built datawindows in PowerBuilder.
  • Data modeled the new database for the Trade Support System.
  • Re-built the Trade Support System in PowerBuilder 7.0 utilizing PFC Standards.
  • Created and re-designed stored procedures, packages and triggers in Oracle 8.i
  • Project Manager for the Trade Support System.
  • Maintained and re-scheduled release dates for the Trade Support System.
  • Coordinated release of internal software upgrades for the Trade Support System.
  • Managed version control of all files needed for scheduled release in PVCS.
  • Incorporated the CAMBASE security model into the Trade Support System.
  • Redesigned the Optimal Delivery Model using PowerBuilder.
  • Migrated the Trade Support System from PowerBuilder 6.5 to PowerBuilder 7.0
  • Built a plug in tool in PowerBuilder that loads multiple files at one time and also tracks already loaded files
  • Consistently met with the Trade support information owners to write specs for new enhancements and processes.
  • Designed and released new reports for the Trade Support System as needed.

Time Track

  • Took initiative and built an automated tool in PowerBuilder 6.5 for Manual Timesheet Tracking for all of the Market Risk Department.
  • Designed and Data modeled the database for the Time Track application.
  • Migrated the Time Track application from PowerBuilder 6.5 to 7.0.
  • Added a Resource Forecasting System using PowerBuilder 7.0 into the Time Track Application.

Hire Now