PL SQL Programmer Resume

SUMMARY

Efficient and organized hard worker finding most effective and least expensive way to solve problems.
Approachable and cooperative problem solver who enjoys working with internal and external customers, fixing problems, and ensuring client satisfaction.
Confident, courteous, flexible, resourceful, and responsible.
Maintained Crontab file and moved automated process to ControlM to allow monitoring.
Extracted data for data transfers for divestures, accommodating growing business.
Created and maintained VBA/C# apps to halp Sales and Finance departments receive reports timely.

TECHNICAL SKILLS

Oracle 11g, Oracle 10g, Oracle 9, Oracle 8i
PL/SQL, Vi, UNIX, Cognos, Power Bi, XML, HL7, Stored Procedures, Visual Basic
.NET, C#, Visual Studio 2015, Visual Studio 2010, Visual Studio 2008, Visual Studio 2005, Visual Studio 2000, Visual Basic 6.0
Business Object’s, Crystal Reports 11.5, Crystal Report 8.
SQL T - SQL, SQL SERVER 2016, SQL SERVER 2012, SQL SERVER 2005, SQL SERVER 2000
MS Access, SSIS, SSRS Reporting, ASP, SMTP, MAPI, SQL 7.0,
HTML, Java, Team Foundation Services, Clear Case, Visual Source Safe, Cobol, CICS
JCL, Cache, Power Builder, SQR, Oracle Reports

PROFESSIONAL EXPERIENCE

Confidential, Millington, TN

PL SQL Programmer

Responsibilities:

Supported Confidential of Engineers with conversion of Oracle Forms and SQR’s to PLSQL and Oracle BI Publisher.

Confidential, Matawan, NJ

SSRS SQL Programmer

Responsibilities:

Supported Confidential on teh TESS program with conversion of manual reports by making them into automated SSRS functions and reports.
Developed skills using EXP AG/DocXP/Omni Admin Web/Omni Plus

Confidential, Millington, TN

PL SQL Programmer

Responsibilities:

Supported Confidential of Engineers with conversion of Oracle Forms and SQR’s to PLSQL and Oracle BI Publisher.

Confidential, Memphis, TN

Data Warehouse / PL SQL Programmer

Responsibilities:

Maintained Crontab file and moved automated process to ControlM to allow monitoring.
Extracted data for data transfers for divestures, accommodating growing business.
Created and maintained VBA/C# apps to halp Sales and Finance departments receive reports timely.
Optimized month end process by taking UNIX calls that were run manually and moving to scripts enabling OPS to run and monitor process, saving several hours of running and monitoring processes during month end.

Confidential, Memphis, TN

Senior Programmer Analyst

Responsibilities:

Developed and deployed Visual Basic 6 and VB.Net applications with Oracle and Cache databases.
Resolved defect issues and enhancements to teh application which evaluates lab results and reports.
Created VB.net applications for importing and exporting data from XML and HL7 formats.
Created and maintained tables and stored procedures in Oracle and Cache Databases.
Converted VB6 apps to VB.net apps to update apps.

Confidential, Memphis, TN

Senior Programmer Analyst

Responsibilities:

Confidential, Memphis, TN

Senior Programmer Analyst

Responsibilities:

Designed Property Management System in Visual Basic, Visual Basic .NET and SQL Server 2005 environment.
Worked under variety of leads to resolve defect issues, enhance internationalization functionality of application, and provide new and specific reporting capabilities to support internationalization of application.
Created and maintained tables and stored procedures in SQL Server 2005.
Maintained and created reports in Crystal 8.5 reports.
Created new SSRS reports to run with new .NET code.

Confidential, Memphis, TN

Senior Programmer Analyst

Responsibilities:

Designed dynamic web reporting tool called Report Scheduler written in VB 6.0, PL/SQL and utilizes Crystal Reports, allowing customers to request email delivery of reports and / or view reports on-line via Clientline, crossing platforms to connect to 4 different databases.
Developed and managed 4 Oracle databases containing billions of transactions, entitlement, and merchant data.
Supported over 2k PL/SQL stored procedures that spanned multiple databases. Involved and supervised conversion of store procedures from Oracle 8i to Oracle 10g.
Managed several people during conversion of stored procedure and reports and adding of databases to system.
As Web Master and using Visual Basic 6.0, ASP’s, Access and Oracle designed, maintained, and supported customer information web site for EFS Transportation.
Used VB 6.0 and Crystal Reports to design reporting tool to collate reports and summaries for monthly reporting on residuals.
Wrote and managed over 2k Crystal Reports which utilized PL/SQL stored procedures from above. Supervised conversion of Crystal Reports from 8.5 to 11.5. for internationalization of reports. Used Business Object’s Repository to contain functions in reports.
Converted Visual Basic 3 application to Visual Basic 6.