SUMMARY:

• Over twenty years of experience in information technology developing client/server applications in both multiple operating systems and PC environments using C, Unix Shells, PL/SQL and fourth generation languages.
• My career included development, support and validation of financial management application, third party logistics application, trading application, marketing application, healthcare application and Clinical trials.

TECHNICAL SKILLS:

Development Tools and Programming Languages: C, Unix Shells, Perl, Visual Basic, SQL, SQL Loader, SQL*Forms, SQL*Plus, PL/SQL, Oracle Clinical, Clintrial, ClearCase, SQL Developer, SQL Navigator, TOAD, AutoSys, MS Office, Lotus Notes, Eclipse, Java, XML, Source Tree, SVN and GIT.

Hardware and Operating Systems: DEC VAX, MS Windows, Windows NT, Windows 2000, SUN - UNIX, SOLARIS-UNIX, HP-UNIX

Databases: Oracle, Sybase, MS Access, Watcom

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Oracle Analyst/Developer

Responsibilities:

• Analyze, develop, modify and test Oracle PL/SQL packages, functions, and procedures for issues reported in JIRA issue tracking during the sprint.
• Prepared DML and DDL SQL scripts used to create and modify objects and data as needed in the database.
• Migrated the changed scripts to the Git repository and completed the deployment documentation.
• Performed SQL tuning analysis of running queries using explain plan and provided solutions to reduce cost and cpu time.

Confidential, Malvern, PA

Oracle Analyst/Developer

Responsibilities:

• Analyze, develop, modify and test Oracle PL/SQL packages and stored procedures for issues reported in JIRA issue tracking during the sprint.
• Conduct unit testing and prepare testing scenario for the fix that can be used by QA.
• Migrated the changes to the Git repository using Source Tree and completed the deployment documentation.

Confidential, Malvern, PA

Oracle Analyst/Developer

Responsibilities:

• Analyze, develop, modify and test Oracle PL/SQL packages and stored procedures used by the form triggers for data retrieval and processing.
• Prepared DML and DDL SQL scripts used to create and modify objects and data seed used in database development for a specific product release.
• Modified and tested translated Java and XML files using Eclipse and Vagrants.
• Used TortoiseSVN and GIT for version control of all modified files for releases that were checked in/out of the repository.
• Ensure proper changes are executed for the planned release and that a formal process is followed regarding the tracking and management of application bugs in compliance with quality and IT requirements.

Confidential, Wilmington, DE

Oracle Analyst/Developer

Responsibilities:

• Analyze, develop, modify and test Oracle PL/SQL packages and stored procedures used for claim processing and new enhancements.
• Developed Unix scripts to process data from reports supplied by Confidential partners.
• Provided comprehensive consultation to business unit and IT management at the highest technical level on all phases.

Confidential, Ridley Park, PA

Oracle Developer

Responsibilities:

• Develop, validate, test, implement and document required packages used to process picking requests of components in Work Orders, Sales Orders, Transfers and Unplanned events for common sites.
• Performed migration of all newly developed and modified objects into Test and Production environments.
• Developed packages used to extract, transform and load (ETL) conversion data from source tables into staging tables before loading into target tables.

Confidential, Collegeville, PA

Oracle Developer/Support Analyst

Responsibilities:

• Develop, validate, test, implement and document validation and derivation procedures used to extract, validate and load data supplied by vendors into the data store.
• Developed scripts used to summarize data from multiple channels in the data store joined with remote data warehouses and loaded into files for efficient data migration.
• Develop, code, test, implement and document Best Address (BA) application that selected all available addresses from various databases and supplied the best address available based on evaluation and weight of collected facts data.
• Developed, installed and monitored automated schedules for various Unix jobs using AutoSys software.

Confidential, Fort Washington, PA

Integration Programmer/Support Analyst

Responsibilities:

• Analyzed reported issues and prepared required modifications, test plan and test results to present to Business area for approval to release into Production environment.
• Developed UNIX shell scripts and PL/SQL procedures for enhancements to load and validate shipment and forecast data feeds into database. The script maintained a status to be reported through email to the Business area.
• Monitored cron jobs that sync and load product, order and forecast data between all interfaces.

Confidential, West Point, PA

Oracle Developer/Analyst

Responsibilities:

• Analyzed Pathdata Oracle database structure and SADR Oracle database design to prepare a method of translating acquired scientific data from the PathData Oracle database into Oracle transmission tables that feed SADR.
• Wrote the system design specification for the interface.
• Developed two packages to reformat and move the data from Pathdata to SADR transmission tables.
• Conducted an integration testing for all the functions and procedures in the packages.
• Mapped Pathdata dictionary codes for translation to SADR dictionary codes.
• Prepared UNIX shell script triggered by a Cron job to execute multiple scripts used to generate and email Transmission and Errorlog reports to Business area admin.

Confidential, Collegeville, PA

Oracle Programmer/Support Analyst

Responsibilities:

• Plan and execute the rollout and communications plan for new systems and existing applications.
• Analyze, design, develop and implement small enhancements or work-arounds to systems to meet immediate business needs for specific applications.
• Design and develop tools for monitoring applications to ensure alignment with business benefits and service level agreements.
• Develop strong working relationship with other IT services providers (eg infrastructure, Applications Delivery, etc.) to ensure client issues are efficiently analyzed and resolved.

Confidential, King of Prussia, PA

Application Programmer/Analyst

Responsibilities:

• Completed the requirements specifications and design for Multi-Currency exchange rates enhancement to "APOLLO" Accounts Payable Online Operations. The application is three tiered with the front-end developed in Visual Basic, and the back-end developed in C, Perl, Sybase and third party OEC tool that managed the servers for data retrieval.

Confidential, Collegeville, PA

Oracle Programmer/Analyst

Responsibilities:

• Works directly with clients in Clinical Data Management to understand and fulfill data requests and analyses.
• Develops, tests, validates, implements, documents, and maintains data validation software used by Clinical Data Management (CDM) to ensure that the data is delivered to Biometrics with highest quality.
• Supports the analysis and QA/QC functions of Clinical Studies, if data cleansing is conducted by outside vendors.
• Resolves technical problems and provides guidance to users of clinical trial databases on all aspects of technical support application and related programs, ensuring that existing systems are utilized effectively.

Confidential, King of Prussia, PA

Application Programmer/Analyst

Responsibilities:

• Customized and maintained "APOLLO" Accounts Payable Online Operations. The application is three tiered with the front-end developed in Visual Basic, and the back-end developed in C, Perl, Sybase and third party OEC tool that managed the servers for data retrieval.

Confidential, Fairfax, VA

Mentor/Application Developer

Responsibilities:

• Provided consulting and mentoring expertise to project team while developing several applications as part of global trading, operations, and accounting system. Applicable technology includes ‘C’, Sybase, UNIX, and 4GL Passport GUI development on HP-700 series workstation platform.