We provide IT Staff Augmentation Services!

Senior Programmer,resume Profile

5.00/5 (Submit Your Rating)

UsA

Professional Summary

Senior IS professional with extensive experience in software development and relational

database functionality specifically Oracle RDBMS and MySQL.

Possesses expert-level skills for business analysis application design and development industry

best practices and client relationship skills

An agile problem-solver capable of delivering business value by taking solutions from inception to

deployment in real time.

Ready for challenging opportunities to prove it.

Technical Summary

Relational Database and ETL Concepts Oracle RDBMS PL/SQL Informatica PowerCenter v8.6 Oracle Performance Tuning Unix shell Source Control Compliance SOX FDA GxP CMS

Professional Experience

confidential

Programmer/Analyst

Created report application for tracking sales commissions for Medicare sales agents featuring

integration between front-end application with sales information and Medicare CMS health insurance claim status information.

Created report application for tracking CMS compliance requirement for outbound verification to

applicant of Medicare enrollment submission.

Environment Oracle 11g PL/SQL Informatica PowerCenter Unix shell scripting

confidential

Programmer/Analyst

Created PL/SQL application populating OLAP environment with auction.com property asset data

via ETL PL/SQL application.

Directed offshore team regarding ETL application web-based user interface. Cross trained colleagues on design and operation of the interface.

confidential

confidential

Supported UMG Royalty Management OLAP environment by creating PL/SQL applications

performing ETL activities .

Designed and developed UNIX shell scripts for real-time ETL processing into OLAP environment. Provided production support and troubleshooting for ETL systems.

Environment Oracle 11g PL/SQL UNIX Shell Scripting ETL Data Warehouse

confidential

Senior Programmer/Analyst 2005 2009

Served as lead programmer / analyst for global mission-critical clinical trials logistics application supporting full packaging distribution quality assurance and reconciliation lifecycle for all drug products for several hundred users globally. Application built 100 in-house using Oracle database and Developer client delivered several major upgrades consistently meeting project deliverables under budget.

Saved 300K in contractor fees by delivering an external interface to ERP system for import of

manufactured inventory used in clinical trials.

Increased clinical drug inventory reconciliation efficiency 25 by developing an external web-

based solution for real-time data entry and report generation at remote locations replacing a manual system.

Participated in Clinical Trial Data OLAP activities coordinating with OLAP team and performing

ETL activities to prepare OLTP data for load into OLAP enivronment.

Established 100 in-house development delivering clinical trials application upgrades on

schedule and under budget saving 400K/year internal labor costs and contractor fees over the applications lifecycle.

Eliminated redundant clinical trials application through data migration to the current system. Ensured application stability and compliance with internal and external requirements by

partnering with DBAs UNIX administrators Quality Assurance and Computer Validation colleagues.

Saved 30 of my resource annually by cross-training colleagues on application support issues.

Programmer/Analyst

Served as primary technical resource for three applications previously assigned to support as a contractor

Saved 200K by eliminating a vendor solution for FDA 21 CFR Part 11 compliance by developing

a utility leveraging the Oracle data dictionary for DDL scripts applicable to any Oracle database. Established baseline of functionality full documentation and GxP compliance of clinical trials

application through analysis of application and data then upgrades to application software and RDBMS version.

Environment Oracle 9i PL/SQL ERP UNIX DDL Scripts RDBMS

We'd love your feedback!