SUMMARY:

• Over 20 years working in Information Services in manufacturing, health care, and food industries.
• Worked with many facets of the Oracle database using PL/SQL and SQLPlus, Oracle Warehouse Builder, Oracle Framework, Oracle BI Publisher, Oracle Discoverer and Oracle reports.
• Created PL/SQL Programs and SQLPlus scripts.
• Created and maintained Oracle tables, views, indexes, triggers, functions, procedures, stored procedures and database links.
• Performed backend database in support for a system used to house documents sent to the FDA for approval and re - registration of healthcare products.
• Worked with Tableau as a system administrator and developer.
• Lead Tableau server upgrades from version 8.3 to 9.0 and 9.0 to 9.3.
• Team player with excellent communication and documentation skills.
• Adept at all stages of the Systems Development Life Cycle (SDLC) from planning, creating, testing, deploying, and maintenance.
• Enjoy being creative if solving problems.
• Enjoy learning and mastering new processes, systems and software.

TECHNICAL SKILLS:

• Oracle Applications (11.5.10.2)
• Oracle PL/SQL (11.2.0.1.0 )
• Oracle SQL*Plus (11.2.0.3.0 )
• Oracle Warehouse Builder (11.2.0.3.0 )
• Oracle BI Publisher (5.6.3) - Oracle EBS
• Oracle BI Publisher (10.1.3.4) - Oracle OBIEE
• Oracle JDeveloper (9.0.3)
• Oracle SQL Developer (4.1.3.20)
• Oracle Reports (6.1)
• Oracle Discoverer (10.1.2.3)
• Tableau Server 8.3, 9.0, and 9.3
• Tableau Desktop 8.3, 9.0, and 9.3
• MS Office (Word, Access, Excel, PowerPoint, Outlook, Visio)
• Microsoft PowerShell (4.0)

PROFESSIONAL EXPERIENCE:

Programmer Analyst II

Confidential

• Lead Tableau server upgrades from 8.3 to 9.0 and 9.0 to 9.3
• Created and updated Tableau data sources, workbooks, views, and dashboards
• Analyzed and documented an Oracle database system unknown to me or my colleagues and created two Tableau data sources and several workbooks and views.
• Created Microsoft PowerShell scripts that pull data from Oracle views that are used to refresh and increment Tableau data sources. Then once the data is ready, the script then launches and follows the data source refresh/increment on the Tableau server until it is complete. In one of the scripts, I broke the data down into years and processed the data for the earliest year and performed a refresh of the data source. For the remaining years, increments of the data source were performed.
• Created and updated tables in a data warehouse using Oracle Warehouse Builder
• Brought tables from a Baan system into the Oracle data warehouse. This required creating empty tables in the data warehouse, creating indexes for these tables, updating the data types in the tables, creating grants on these tables, appending data into the tables, and compressing the data in the tables.
• Performed database support for a custom-built franchisee servicing system.
• Created queries to produce pipe (|) delimited documents to be opened in Microsoft Excel for month end analysis by the Finance department.

Systems Programmer Analyst

Confidential

• Sole supporter of the Oracle 11g backend database for Abbott Diagnostic’s Content Server (Livelink) system. This system houses documentation submitted to the FDA for approval and re-registration of products, as well as international approval documentation.
• Troubleshot production issues and fulfilled requests for modifications to the system
• Created several Oracle SQL scripts to update the permissions for documents in the front-end application.
• Created and updated Oracle synonyms, views, tables, grants, indexes, functions, procedures, constraints, triggers, and packages.
• Prepared the necessary scripts to restore the database schema when it was radically changed after the application software was installed during the upgrade.
• Performed database analysis during a conversion from Latin-8 to UTF-8.
• Trained offshore personnel on performing database support for the Content Server (Livelink) applications, as well as support of stand-alone applications related to the application.

Systems Programmer Analyst

Confidential

• Performed user acceptance testing of Oracle views and character (comma, pipe, and semicolon) separated files during Abbott’s business separation into Abbott and AbbVie.
• Analyzed production issues, and recommended changes to correct the problems.
• Learned how to create and use command and batch files to process SQL scripts and PL/SQL programs.

Oracle BI Publisher Developer

Confidential

• Created reports for the Human Resources department using Oracle BI Publisher (10.1.3.4) and Oracle SQL Developer.
• Documented the procedure of creating a report using Oracle BI Publisher (10.1.3.4) for the support team and future users of BI Publisher at Confidential .

Senior Programmer/Analyst

Confidential

• Project lead in creating, designing and developing a new stand-alone Oracle framework application which allowed for the creation and maintenance of label material specifications in one area eliminating the need for duplicated efforts.
• Worked with a team to create a new system which automated the process of getting sales orders from various external sources (such as Lotus Notes) to be created as Oracle sales orders. This allowed for the tracking of orders from the creation of an external quote or estimate through shipment.
• Created a stored procedure that automatically prints various BI Publisher forms based on specific account and label specifications. This system improved the quality assurance department’s ability to locate and correct problems noted after production of new labels.
• As the sole Lotus Notes Administrator/Designer supported a company of over 300 employees designing and maintaining many Lotus Notes databases.
• Acted as the Sales Force Administrator for a sales force of over 70 representatives at its peak quickly reacting to and solving any problems.
• Based on internal requirements, created and maintained several PL/SQL programs which provided timely customer, die, invoice, label information and pricing, material information and pricing, and sales order information to the sales representatives in the field via Lotus Notes.
• Created and maintained Oracle Discoverer reports.
• Trained coworkers on the use of Oracle BI Publisher.
• Created and maintained reports using Oracle Reports.
• Developed, tested, and implemented efficient, cost effective application solutions.
• When I first started, I became the network administrator for a fledgling network when the current network administrator left the company for a new position.
• Updated COBOL programs for the “Year 2000” problem.