Systems Integration Lead Resume
SUMMARY:
- Well - rounded database professional with proven experience designing and implementing technology initiatives in the areas of information architecture, database design, data warehousing, and metadata in the federal healthcare and financial verticals.
- Extensive background in Canonical Data Modeling leveraging XML Schemas, and Performance tuning for mission critical (extremely) large databases.
- Key participant in developing data models and database software employing the Agile Methodology for Confidential System ( Confidential ) initiatives.
- Extensive experience with Relational Database, Linux, Oracle RAC and J2EE server administration in vital Confidential environments such as Development Test Center (DTC), Developmental Test and Evaluation (DT&E), Confidential ’ Integration Lab, and DISA’s production environment.
- Well-versed in healthcare standards such as HL7, ICD-10, and the Nationwide Health Information Network ( Confidential ).
- Outstanding communication, presentation and inter-personal skills, thrive working with cross-functional Agile teams.
- My passion is to leverage the service-oriented architecture (SOA) capabilities of the MS SQL Server, Oracle database and J2EE middleware platforms, to architect and implement complex data-centric (Web-tier) applications.
SPECIALTIES
Data Skills: SQL Server 2012 Admin, Apache Hadoop 2.5.x Admin, Oracle 11GR2 & MYSQL 5.x Database Admin, Oracle Real Application Clusters (RAC) installation and configuration, Oracle 11G Data Guard technologies and Service based (SOA) Data Architecture.
Development experience with: Microsoft T-SQL, Oracle XML Schemas, Advanced PL/SQL, and Crystal Reports. Database lifecycle tools such as ERWIN, ER-Studio, OEM Grid Control, SQL Server Management Studio, TOAD, Rapid SQL, Oracle ADDM/AWR.
Software Change Management (CM) tools: Rational ClearQuest, ClearCase & JIRA; and commercial Extract, Transform, Load (ETL) tools like AbInitio 10.x & the Apache Hadoop framework.
Middleware Skills: Mirth V3, Pentaho V7, administration experience with deploying, maintaining, and tuning J2SE and J2EE applications, on JBOSS AS 6.x, MS IIS 7.x and Glassfish 3.1.x Application servers.
Software languages: Java (JDK 1.7.x), Advanced PL/SQL, PERL and UNIX Shell scripting, XML/XSLT & JavaScript. Extensive experience with load test tools such as SoapUI & LoadUI Pro to test REST/SOAP Web interfaces.
EXPERIENCE:
Systems Integration Lead
Confidential
Responsibilities:
- My role as the lead entails managing a team of Integration engineers, that build out Mirth and Pentaho Data Integration (Kettle) servers on cloud-based (AWS) Linux instances. We construct interfaces to process real time and batch HL7 (v2 and v3), CCR, CSV/fixed text, JSON, XML, Web Services, DIRECT messages, and CCLF clinical data feeds.
- Clinical, claims, and business data are integrated from more than 200 practices, dozens of EHR vendors, and several HIEs and Hospitals.
- I partner with, product owners, project managers, vendors and resellers to continuously improve our integration strategy and augment our data acquisition capabilities.
- This is a mission critical role to source real time practice and hospital clinical, appointment and billing data, in order to provide a comprehensive view of our patient care life-cycles.
- Leverage Agile methodology using JIRA to manage Scrum based project delivery.
Application Engineer/Data Architect
Confidential
Responsibilities:
- Lead team efforts to benchmark the performance of DoD healthcare applications to be integrated with the existing AHLTA application (HL7 messaging framework) suite.
- These are complex web-tier data provisioning applications that leverage the open source Confidential & HL7 framework protocols.
- Our customer is the DHCS’s (a DoD Agency) Capacity and Performance Management (CPM) team, the goal to identify performance issues with currently (and near future) deployed DoD healthcare applications.
- As a result of these efforts there has been an order of magnitude improvement in the throughput and response time of critical healthcare applications such as VLER, BHIE and TBI/BH, allowing them to meet target SLAs. Also participate occasionally as a key developer in an Agile Scrum Team to debug, develop & test several database defects logged against production CDR & the ICD databases that are deployed at Confidential facilities worldwide.
- Leverage tools such as SoapUI, LoadUI, LoadRunner, etc. to load/stress test the REST/SOAP Web interfaces of key applications.
- Also develop custom test tools for healthcare applications, using Linux shell scripting, Perl, Awk and PL/SQL.
Sr. Principal Database Engineer
Confidential
Responsibilities:
- Lead DBA/Data Architect in the design and implementation of Virtual Lifetime Electronic Record (VLER) solution, hosted on Oracle 11g R2 Real Application Cluster (RAC) databases.
- Lead the team that installed and configured from scratch Oracle RAC databases (for) in secured .MIL & .COM DTC environments using Oracle 11 R2 software on RHEL 6 LINUX. Lead the process of the installation from configuring the Linux kernel and shared raw drives, installing the Oracle Grid Cluster Infrastructure, installing the Oracle database software and creating/tuning the shared RAC databases across multiple nodes.
- Extensively documented the entire process, and trained other SA & DBA resources to administer and maintain the RAC Clusters on an on-going basis.
- Data Architect & Performance engineer for the BHIE product team, addressed architectural issues with relational data modelling to increase throughput, and enhance product functionality to include clinical data domains such as Allergies, Orders, Immunizations and (Inpatient) Notes.
- The BHIE Development team used the Agile methodology with Scrums usually lasting 3-4 weeks; leveraging team tools such as JIRA, SharePoint, & SVN to implement the Agile Scrums. Responsible for enhancing and maintaining the Local Database Repository (LDR) used by the BHIE product (implemented via MySQL), and the migration of clinical, patient and order data between the test, development and production database schemas. Extensively leveraged tools such as SQLPlus, TOAD, Oracle OEM & SQL Developer to administer the local LOR & CDR databases.
- Also responsible for load and regression testing the VLER & BHIE products, using tools such as SoapUI & LoadUI Pro to test their SOAP/REST interfaces.
- Lead DBA efforts to evaluate performance bottlenecks within the AHLTA CDR database (maintained by the DoD Agency DISA), & migrate the AHLTA database to a two node RAC configuration using Oracle’s Clustering solution.
- This is a 90TB mission critical (24*7) database (Oracle 11gR2) that is the system of record for healthcare information for all active duty US Military personnel worldwide. Architected & developed code patterns to deploy & maintain CITA Synch Manager Queues in the AHLTA CDR database; these queues leverage Oracle AQ and Streams technologies. These efforts helped resolve the top performance bottleneck within the AHLTA CDR database, thus increasing overall system performance and available processing capacity by an order of magnitude.
Data Architect
Confidential, Dulles, VA
Responsibilities:
- Lead (DBA) performance tuning efforts for mission critical systems, developed extensive stress tests using custom and open source database testing frameworks.
- Developed guidance on data architecture methods and practices, including alignment to development lifecycles and processes, in partnership with IT Architects.
- This position focused on cutting edge database software design and development projects at Confidential
- Confidential ’s systems maintain the authoritative naming registries of the .NET, .COM, .TV & .EDU domains of the worldwide (public) Internet.
- Lead extensive Canonical Data Modeling sessions, design and development for OLTP & and batch applications deployed on Linux-based platform using PL/SQL, T-SQL, Unix Shell Scripting, and Perl.
- Tuned very large Oracle and MS SQL Server 2008 databases using diagnostic tools such as ADDM, SQL Server Profiler, Oracle 11g OEM, Statspack & AWR reports.
Data Architect
Confidential
Responsibilities:
- Transitioned from a Lead DBA to a lead development and ETL Data Architect role for a suite of mission critical financial and accounting applications - Servicer & Investor Reporting (SIR).
- The application has replaced several legacy Fannie applications for Loan Processing & Pooling, Securities Servicing and Disclosures and GAAP and Tax Accounting.
- Responsible for the architecture, design, development, testing and production-izing of complex back-end debt market applications, implemented primarily in PL/SQL and PERL.
- Used advanced SQL Analytics and Oracle Collections, Oracle database Objects, built-in DBMS packages, XML, Triggers and Stored Packages to deploy these applications, using the JIRA based Agile methodology.
Lead Database Administrator
Confidential
Responsibilities:
- Functioned as a lead Application and Systems DBA for Oracle and Sybase databases, on various UNIX based platforms.
- Key member of a data architecture team that reviewed design and code artifacts periodically, to ensure that development standards are being adhered to.
- Responsible for capacity planning and prototyping physical design required for creating and maintaining various financial databases.
- Helped implement Oracle high availability (replication) solutions, using 10G Oracle Streams and Data Guard technologies.
- Controlled migrations of back-end code, database changes, and reference (metadata) data changes through the development life cycle.
Sr. Technology Consultant
Confidential
Responsibilities:
- Provide Oracle 9i and Sybase ASE 10.x technology expertise for code re-factoring and/or database re-organizations as required, to assist with the scalability and performance of database centric applications.
- Lead capacity planning and physical design efforts required for creating and maintaining various client databases (Oracle 9i and Sybase ASE).
- Lead design sessions in prototyping new systems for the purpose of enhancing existing business processes, operations, and information process flow.
- Administered various Oracle and Sybase ASE database entities, including tables, clusters, indexes, views, sequences, packages and procedures, leveraging tools such as Oracle OEM and Quest tools. Designed and implemented backup/recovery solutions for Oracle databases, using Oracle RMAN backup sets.
Database Administrator
Confidential
Responsibilities:
- First industry exposure to Informix, Sybase and Oracle production databases.
- Trained extensively in Informix and Oracle database administration fundamentals; and Unix host server administration. Initially apprenticed with Sr. Oracle and Informix DBAs to learn industry best practices.
- Helped administer Informix and Oracle database for major Confidential clients for the government agencies in the state of S.C; developed Oracle Forms based 2 tier applications. Developed excellent grasp of PL/SQL and SQL concepts.
- Also developed extensively in Embedded C/C++ (SQL) and Unix Perl/Shell scripting on the Confidential U-Series Unix platforms.