SUMMARY:

• Application Developer/Programmer/Software Engineer with over 30 years of experience, in designing, coding, implementing, troubleshooting, maintaining database administration and supporting applications in a multitude of software languages. An experienced, versatile, self - starter with the ability to learn, adapt to and implement new technologies.
• Development of applications in multiple languages
• Developed and managed projects thru all phases of life cycle development.
• Managed multiple projects simultaneously.
• Experience in writing SQL statements, PL/SQL programming, including Packages, Stored Procedures, Complex Views using tools like SQL*Plus, Toad
• Experience in SQL Server programming, including, Stored Procedures, Complex Views using SQL Server Management Studio
• Data Conversion between multiple software platforms using Oracle tools, Informatica, SAP, SSIS and ODBC’s
• Able to learn and apply new technologies quickly
• Excellent presentation, analytical and problem solving skill
• Database Administrator in the installation and maintenance of Oracle databases

TECHNICAL SKILLS:

• Oracle Database 9i/10g/11g/12c
• Toad
• Microsoft Visual Confidential
• Crystal Reports
• SQL Server Database
• Oracle Forms 6i
• Microsoft Visual Studio
• Microsoft-Access
• PL/SQL
• Oracle Reports 6i
• .NET
• Microsoft Excel
• SQL Loader
• SSIS
• C#
• UNIX Shell Scripting
• SQL Developer
• SAP Business Objects
• Java Script
• Tidal
• ODBC’s
• SAP Data Services
• HTML
• Eclipse SVN
• Oracle Import/Export Utility
• Informatica
• Atlassian Jira

EXPERIENCE:

Confidential

Responsibilities:

• Providing contract database development/programming for Fidelity’s temporary staffing partner.
• Modified various Oracle 11i objects including packages, procedures, functions In support of their .Net based timekeeping app.
• Development of SAP Data Services Jobs to import data from tables in SQL Server database to tables in Oracle database
• Developed process to import data from external source to SQL Server and export same to other external sources using SAP Data Services and creation of new database, including tables, views and stored procedures.
• Development of jobs to export data files to external sources, using SSIS.
• Creation of reports from SAP Data Warehouse using SAP Business Objects
• Performed technical analysis and documented requirements for assigned projects.
• Documented Test Plans and performed unit testing for assigned projects.

Confidential

Responsibilities:

• Modified various Oracle 11i objects including packages, procedures, functions In support of their Java based accounting application using PL/SQL and TOAD.
• Created Overload Package allowing treasury department to submit files for loading into the accounting system with or without adding operating agency parameter using PL/SQL and TOAD.
• Development of various procedures to automatically resend ftp files to customers if originally failed. All development was done using PL/SQL, TOAD and UNIX shell scripts. Job was schedule to kick off at various times using the ORACLE JOB SCHEDULER
• Developed DDL scripts to generate creation of new tables, indexes, constraints, triggers and sequences
• Performed technical analysis and documented requirements for assigned projects.
• Documented Test Plans and performed unit testing for assigned projects.
• Conducting peer reviews for other developer’s assigned projects prior to release into the production environment.

Confidential, Providence, RI

Consultant

Responsibilities:

• Providing contract programming for a leading dental insurance provider in Providence RI.
• Migrated various Microsoft Confidential 2.5 applications to Oracle11g packages
• Developed the procedures, functions, and tables associated with new packages using PL/SQL And TOAD
• Converted 3 claims reporting Microsoft Confidential 2.5 applications to one Oracle11g package created using PL/SQL and TOAD
• Successfully cutting process time from over 3hrs to 25 minutes.
• Created Excel spreadsheets from Oracle using PL/SQL and the Oracle UTL FILE package.
• Successfully created batch script to process extract data from Confidential 2.5 and import into Oracle
• Database run Confidential programs, call the Oracle SQL LOADER and process Oracle scripts to manipulate the extracted data.
• Modified .Excel Spreadsheets and Access Databases extracting data from SQL Server and
• Oracle databases for monthly claims reporting, policy rating and broker information.
• Responsible for creating procedural documentation used for QA testing and deployment to production

Confidential, Philadelphia, PA

Consultant

Responsibilities:

• Providing contract programming for a leading health care provider.
• Successfully converted Oracle10g custom packages in Oracle Data Warehouse running on an UNIX server to Oracle11g packages in Enterprise Data Warehouse running on an UNIX server. Updated UNIX batch scripts to process applications in Oracle11G Tuning and modifying Oracle packages and UNIX batch jobs processing 40000 - 100,000 claims per batch Modified .Net applications used to import, export and format data in various file formats used to send and retrieve medical claims data to state agencies.
• Responsible for creating procedural documentation used for QA testing and deployment to production

Confidential, Westborough MA

Programmer

Responsibilities:

• Providing programming and analytical solutions for a leading provider of money market fund news information and analysis; serving institutional, offshore, and retail clients worldwide.
• Assist in the ongoing conversion of Visual Confidential 9.0 to .Net Development of .Net applications using C# in Visual Studio 2010 Development of applications in allowing data from EXCEL, FTP and SFTP attachments in
• Microsoft Outlook to download into Visual Confidential tables automatically.
• Data Integration between Visual Confidential and SQL Server Database using SQL Server using DML and SSIS
• Table and View creation using SQL Management Studio

Confidential, Pleasanton, CA

DBA//Sr. Programmer

Responsibilities:

• Providing database administration, programming and analytical solutions to the clinical department of a leading medical manufacturing company, enabling them to better capture and report data from various clinical studies throughout the country including,
• Programming and Development of all new clinical applications and clinical study database using
• Visual Confidential, Oracle Forms 6i and PL/SQL
• 100% Design and programming of all Tables, Views, Stored Procedures used in Oracle 9i/10g
• Using PL/SQL and various tools
• Implantation and Development of all databases in Oracle 9i and 10g Creation of all user, their roles and privileges Development of Backup and Procedures
• Creation of Informatica jobs including connection, field mapping, filtering and scheduling to extract data from Salesforce and import into in Oracle and vice versa. Development of packages, procedures, tables and indexes in Oracle to process data extracted from Salesforce.
• Development of search engine and device tracking system in Visual Confidential 6.0
• Reprogramming and development of same app in Oracle using PL/SQL and Oracle Forms 6i enabling the company to follow and locate when needed all devices used in all clinical studies and patients.
• Development of specialize and ad-hoc reports using Visual Confidential, Oracle Reports 6i, Microsoft
• Excel and Crystal Reports
• Development of an international application between 8 separate VFP9 databases in
• Europe and Asia and a central Oracle database in US allowing the receipt of data instantly.
• Upgrading all applications from Confidential 2.6 for Windows to Visual Confidential 9.0 Assisted in writing of software procedures and validation requirements.
• Work with users on logical and physical data models In full knowledge of 21 CRF Part 11. Involved in FDA audits.

Confidential

Computer Consultant

Responsibilities:

• Provided consulting services to a healthcare agency client by working closely with users and management suggesting and providing time saving and cost effective ways to meet their every day needs including,
• Developing Visual Confidential database programs including patient billing for rehabilitation services, admissions and census tracking system for the nursing facilities. Automating data conversions between various financial software packages. Upgrading workstations to Windows 95. Troubleshooting and user support for over 60 facilities.