Database Engineer

Ashish Maini

******.*******@*****.***

(C) 703-***-****

(H) 703-***-****

Summary

Well-rounded database and systems integration 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 Data Governance practices, Canonical Data Modeling and Performance tuning for mission critical (extremely) large databases. Key participant in developing data models and database software employing the Agile Methodology for Military Health System (MHS) initiatives such as AHLTA, Bi-directional Health Information Exchange

(BHIE), Virtual Lifetime Electronic Record (VLER), Traumatic Brain Injury/Behavioral Health

(TBI/BH) and Medical Evaluation Board (MEB).

Extensive experience with Relational Database, Linux, Oracle RAC and J2EE server administration in vital DoD MHS environments such as Development Test Center (DTC), Developmental Test and Evaluation (DT&E), Leidos’ Integration Lab, and DISA’s production environment. Well-versed in healthcare standards such as HL7, ICD-10, and the Nationwide Health Information Network (NwHIN).

Outstanding communication, presentation and inter-personal skills, thrive working with cross- functional Agile teams. My passion is to leverage the micro services architecture capabilities of the MS SQL Server, Oracle database and 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, MS SSIS, Oracle XML Schemas, Advanced PL/ SQL, and Tableau. 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 like Rational ClearQuest, ClearCase & JIRA; and commercial Extract, Transform, Load (ETL) tools like Pentaho 7 & 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/Data Architect (Oct 2016 – June 2018) Aledade Inc. Privately held; 100-200 employees, Healthcare Aledade partners with independent, primary care physicians to provide everything the doctors need to create and run an effective Accountable Care Organization (ACO). 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. Also participate in the Data Architecture team to roll out new OLTP and downstream Warehouse schema updates, servicing micro-services architecture based web applications. Application Engineer/Data Architect (Nov 2015 – Oct 2016) Leidos Inc. Publicly held; 100**-***** employees, Fed IT services 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 NwHIN & HL7 framework protocols. The 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 DoD healthcare applications such as VLER, BHIE and TBI/BH, allowing them to meet target SLAs. Also participated occasionally as a key developer in an Agile Scrum Team to debug, develop & test several database defects logged against production databases that are deployed at MHS facilities worldwide. Leveraged tools such as SoapUI, LoadUI, LoadRunner, etc. to load/stress test the REST/SOAP Web interfaces of key applications. Also developed custom test tools for healthcare applications, using Linux shell scripting, Perl, Awk and PL/SQL. Leveraged the Microsoft Integration Services platform for building data integration and data transformations solutions. Used Integration Services to solve business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

Sr. Principal Database Engineer (Dec 2009 – Nov 2015) Evolvent, A ManTech International Subsidiary Publicly held; 5000-10000 employees, Fed IT consulting

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 (April 2009 – Dec 2009)

EAI @ Verisign Inc, Dulles, VA Privately held Company; 50-100 employees; Internet infrastructure industry

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 Verisign Inc. VeriSign’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 (March 2006 – April 2009)

Fannie Mae Public Company; 5001-10,000 employees; FNM; Financial Services industry 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. Key participant in the architecture, design, development, testing and productionizing 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 (July 2001 – March 2006) Fannie Mae Public Company; 5001-10,000 employees; FNM; Financial Services industry Functioned as a lead Application and Systems DBA for Oracle and Sybase databases, on various UNIX based platforms. Lead 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.

Education

University of South Carolina-Columbia

M.S., Electrical and Computer Engineering

Masters dissertation in leveraging distributed cloud computing for rendering real time computer graphics

Activities and Societies: Alpha Phi Omega

University of Mumbai

B.E, Electrical and Computer Engineering

Major in VLSI Integrated Circuit design

Currently active DOD ADP-II Clearance.

Groups and Associations

International Oracle Users Groups (IOUG)

Institute of Electrical and Electronics Engineers (IEEE) Oracle University Workshops/Certifications

Oracle Database 9i: Administration Workshop I Release 2 Oracle Database 9i: Administration Workshop II Release 2 Oracle Database 9i: Backup and Recovery Workshop I Release 2 Oracle Enterprise Manager 9i (Database and Grids)

Oracle9i Forms Developer: Build Internet Applications (Development Tools) Oracle Database 9i: Java and XML (Development Tools) Oracle Database 10g: Parallelism and Scalability Overview Seminar (Database and Grids) Oracle Database 10g: Performance Tuning (Database and Grids) Oracle Database 10g: Data Guard Administration Release 2 (Database and Grids) Oracle Database 10g: Advanced PL/SQL (Development Tools) Oracle Database 11g: New Features for Administrators Oracle 11g: Standby Database Administration

Agile Scrum Master Certification Workshop

Honors and Awards

DMR Telecom Consultant of the Year (1999)

Fannie Mae Cool Rewards (2003)

Fannie Mae Hot Spot Employee (2007)

Contact this candidate