SUMMARY:

• Design strategic systems and solutions to address business needs, solve problems and crises, with a creative vision into future possibilities
• Infrastructure and Database Architect |Disaster Management | Crisis Intervention
• Security Management | Healthcare Information Management | Implementation Strategist
• Insightful and knowledgeable about business flows within several sectors, focused on Medical Healthcare and Claim adjudication for Pharmacy Benefit Management Systems.
• Design and direct crisis intervention preparedness programs, determine potential emergency - related needs, and step-in as technical resource for project implementation.
• Maximize potential of disaster response resources, systems, people and circumstances, in response to any crisis, while remaining calm under pressure.
• Build customized customer tool sets to automatically assist with daily operation, monitoring, problem identification and notification.
• Proficient in implementing CIS level2 security, performing CMS audits and ensuring HIPPA compliance across all enterprise cloud based environments.
• Expert in Database, Cloud based Database, Virtual Database, SQL statement tuning, Network, OS kernel, Web service based Medical and Pharmacy data communications, Application performance tuning and optimization of large OLTP and Data Warehouse / DSS systems for Service Level Agreement (SLA) compliance.

TECHNICAL SKILLS:

Database: SQL Server 2016, 11gR2 Oracle RAC, Oracle 12c, 11g, 9i, Oracle Database Cloud, Delphix Virtual Database, DB2, Sybase, Cache, Progress 11 and 12, MySQL

OS Platform: AIX 7.2 and 6.1, Solaris, OS/400, Linux, HP-UX, MS Windows 2012

Specialty Areas: OS / Database / Application Performance Tuning and Optimization, Complete OS / DBA Production and Development Support for OLTP and DSS systems, Security, Logical and Physical Database Design, Systems Analysis and Design, HL7 and SOAP XML

Technologies: RDBMS, ODBMS, ETL, Oracle Advanced Replication, Oracle Real Application Clusters (RAC), Oracle Database Cloud, Massive Parallel Processing (RS/6000 SP2), HACMP, Physical / Logical Oracle Data Guard technology, Oracle Gateway, Oracle Advanced Networking, Delphix Virtual Database, LDAP, Web Services, HL7 / SOAP XML, Schema

Development Tools: JDeveloper, SOAP UI, Power Builder, SQR, Unix Power Tools, Visio, Visual Studio

Web Infrastructure: IIS, WebSphere, Weblogic, Oracle XML Development Kit, Apache Jakarta Tomcat

Admin. Tools: SQL*plus, Extensive library of monitoring, tuning and administration scripts, Oracle DBMS Admin. Packages, SQL Server Management Studio, Embarcadero DBARTISAN, RMAN, SQL*loader, Quest Tools (SQLAB Xpert, SQLAB Vision, Spotlight, Space Manager, Toad), BMC Patrol, BMC SQL-programmer, DB2 Control Center

Languages: Java, PL/SQL, SQL, XML, HTML, JSON, Korn, Bourne and C Shell, PERL, AWK, SED

Applications: Integrity/Greenway Medical Manager, Sorian Invision, Cerner Millennium, LO INC, CoPath Lab, Novius Lab, Sunquest Lab, Catamaran RxClaim, Catamaran RxMax, Catamaran RxTrack, Confidential PBS, First Health FirstRx, Walgreen s WHI PBS, Catamaran / SXC Drug Information System

Methodologies: Oracle Designer, Microsoft Project

DataModeling Tools: Embarcadero ER / Studio Data Architect, CA Erwin, Sybase Power Designer, Oracle Designer, Toad Data modeler, DataDigger

PROFESSIONAL EXPERIENCE:

Confidential, New Orleans, LA

Technical Infrastructure Lead

Responsibilities:

• Experienced with AWS Management Console and Amazon IAM implemented in an AD environment. Experienced with AWS security rules to limit communications on a port range basis outside of predefined networking areas.
• Performed schema migrations of hospital patient data from Greenway/Progress and Cerner/Oracle databases to SQL Server databases to allow ETL to a centralized cloud based data repository. Created Sybase and Cache ODBC data connections to remote clinical lab database systems from AWS cloud based instances through VPN tunnels.
• Familiarity with Hl7 V2 and V3 Standards, LO INC and SNOMED Mapping, HL7 Message Validation, ICD 9 and 10, Electronic Health Records, Master Patient Index and Electronic Medical Records.
• Implemented CIS-CAT Pro Dashboard and CIS Workbench Server to perform penetration tests and monitor all cloud instances to assure continuing CIS level 2 security compliance.
• Experienced with IIS Manager for configuring Microsoft web services.

Confidential, Scottsdale, AZ

Lead Systems Architect

Responsibilities:

• Executed and directed high-traffic capacity, 3-tiered, OLTP, rules-based Pharmacy Claims Adjudication Systems on multiple platforms and databases. Serve as architect consultant for development teams and work with team members to design and support the next generation of applications.
• Define and lead architecture review and data governance initiatives.
• Originated implementation tool sets to assist automatic system monitoring and notification, benchmarking and performance analysis, acceptance testing, and configuration evaluation testing.
• Performed problem diagnosis and performance enhancement recommendations for Web service based applications communicating SOAP encapsulated medical and patient drug data transactions.
• Experience working in a multi-discipline environment. Communicating effectively with software/hardware development and test teams to convey engineering direction and receive implementation constraints and testability feedback.
• Was instrumental in performing a required CMS security audit for the development group.
• Ability to clearly explain technical issues and solutions to non-technical audience. Experience reading and coding from business functional specifications and ability to clearly and thoroughly document technical design.

Confidential, Phoenix, AZ

Senior Solutions Consultant

Responsibilities:

• Executed and directed high-traffic capacity, 3-tiered, OLTP, rules-based Pharmacy Claims Adjudication Systems on multiple platforms and databases.
• Enhanced coordination of benefits application, managing implementation and operational support of prescription claims.
• Analyzed completed work against plans, schedules and budgets, to ensure of milestones and project completion, by maintaining project controls.
• Originated implementation tool sets to assist automatic system monitoring and notification, benchmarking and performance analysis, acceptance testing, and configuration evaluation testing.
• Sustained problem diagnosis, performance enhancement recommendations, release installation and data migration assistance.
• Designed and taught internal AIX and Solaris operating systems, SXC customer system administration, Oracle 11gR2 server and client, application installation and migration courses.
• Generated Technical Architecture Documentation and Technical Implementation Plans, allowing customers to build operational support groups for Pharmacy Benefits Management systems implementations.
• Planned, implemented and supported initial Catamaran and SXC Drug Information System Development environment at Maximus, Victoria, BC and Telus, Toronto, ON.
• Delivered certified advanced IBM AIX and Sun Solaris technical support, problem diagnosis, release installation and data migration assistance to Catamaran / SXC Development.

Confidential, Phoenix, AZ

Data Management Supervisor, PBM Systems

Responsibilities:

• Improved hardware utilization by 40% to 50%, and reduced application and database failover timing to mere seconds, with first ever production implementation of Oracle RAC with ASM, providing model for future production roll-outs.
• Furthered 2 consecutive years of 100% up-time reliability and stability for all First Rx environments, with design of custom monitoring scripts and tools, notifying customer of impending problems.
• Led design and implementation of SXC PBS database and application on Oracle 10g RAC in active cluster configuration, replacing Oracle 9i - AIX HACMP, active and passive clustering technology.
• Implemented and managed high transactional volume, 3-tiered, rules-based Pharmacy Claims Adjudication Systems on multiple platforms and databases.
• Constructed HACMP failover scripts, automatically starting Oracle and SXC PBS pharmacy applications on First Rx and FHG systems.
• Conducted and designed new hire sessions and materials, leveraging new techniques for performance enhancement and reliability.

Confidential, Scottsdale, AZ

Senior Technical Consultant

Responsibilities:

• Boosted continuing daily installation efforts, supporting regular activities, such as transaction log file problem analysis, automatic notifications and archiving, with construction of administrative tool sets.
• Delivered detailed IBM equipment configurations to Medicaid clients and Walgreens IT departments, with advisement on network configuration strategies, troubleshooting, and hardware configuration and implementation strategies.
• Performed complex performance analysis evaluations and report on practical and cost effective methodologies for enhancing system, network and application operations.
• Built implementation tool sets to assist automatic system monitoring and notification, benchmarking, performance analysis, acceptance, and configuration evaluation testing.

Confidential, Tempe, AZ

Senior Platform Support Engineer

Responsibilities:

• Performed the alpha installations of new OS platforms, networking strategies, ICU electronic charting application releases and hardware environments at major medical institutions across the world Planned and executed complex application release updates and data migrations for major medical institutions such as Emory University, Johns Hopkins and New York Hospital. 10+ year’s of onsite customer crisis management for critical medical accounts. Received Motorola Presidents for excellence in customer satisfaction
• Implementation customization specialist providing pre and post sales technical advisement for new and existing clinical customers at over forty hospitals across North America.
• Performed top tier escalated problem troubleshooting. National and international technical support resource for Motorola systems engineers on four continents.
• Implemented and provided communications support for HL7 Lab and Monitor interfaces.
• Served on three-person team porting clinical electronic charting application to POSIX compliancy running on AIX version 4.
• Created customized network installation tools, scripts and documentation for customer base migration to AIX version 4 and Y2K compatibility.
• Instrumental in migrating electronic ICU charting application from desktop systems to larger IBM RS/ and SP class machines.
• Instrumental in migrating electronic ICU charting application from original Motorola proprietary computer hardware to Sun Microsystems platform.
• Hardware and software interoperability/interface qualification consultant