Senior Programmer,resume Profile
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