Principal data architect supporting enterprise financial systems with adherence to scaled agile framework (SAFe). Responsible for all systems regarding asset management such as security master, cost basis, global clearance, managed asset repository (positions and balances). Supported regulatory systems providing CAT and EBS data to FINRA.Designed conceptual, logical, and physical data models supporting DB2, Oracle, And SQL Server databases. Wrote DDL command tasks wrapped in Python scripts to implement creation and updates to these databases. Developed stored procedures, packages and triggers. Prepared schema for cloud presence in Azure. Designed Tax Lot management database with RGL and UGL components serviced in Snowflake. Utilized Pentaho Data Integration as a primary ETL to convert data between platforms. Used to defend against schema drift by policing deltas between DEV, Test, QA, and Production.Designed, implemented and supported US cost basis database on Oracle 19c / Exadata platform. Extended architecture to Hadoop/Hive for reporting practices. Coordinated record change sequence to assist load balancing of Kafka queues. Compartmentalized deprecated data-sets for backward compatibility while foreseeing retirement.Developed Corporate Action database that integrated SWIFT protocols with company disbursement. Coded PL/SQL to manage audit and archiving operations over multiple partitions. Reverse engineered UK Trading/Clearance/Settlement system designed on SQL Server platform to integrate with US based counterpart on DB2 & Oracle platforms to adhere to a common corporate taxonomy. Identified data attributed that required encryption or obfuscation to satisfy GDPR. Prepared a concordance of like terms between Pershing US and Pershing UK.Designed Data Governance data store whose goal was to centralize naming conventions of data elements across data platforms and API. Introduced data quality rigor to replicated Oracle databases.

Lead DBA on an enterprise asset procurement system for the Department of Defense. • Responsible for database tuning, disaster recovery and data analysis. • Principal data modeler for re-factored database. • Participated in the refit of the application focusing on data legacy from entry point to reporting. • Hands-on involvement with Systems design and integration between layers.Designed and installed catalog search (Live Sourcing) database featuring Oracle text. Created materialized views to capture disjoint catalog data and store in de-normalized form. Made use of XML data types. Utilized domain indexes for rapid searching.Expanded the open source ERP system, OpenBravo, according to the needs of the Department of Defense MRO procurement system. • Ensured foreign keys were defined and properly indexed. • Re-engineered triggers and procedures to adhere to Oracle best practices such as the introduction of cursors. • Introduced bitmap indexing on high volume tables with low cardinality data columns. • Followed DevOps principles for automated release and regression testing.Created, implemented, and optimized data transformations from legacy SQL Server system into new Oracle data architecture. • Developed ETL transformations using Pentaho. • Executed SQL Server data operations to retrieve data that would be transformed into and Oracle database.

Maintain and improve the performance of the database layer of the mature N-Tier commercial TEM product. Enhanced core application via the utilization of hierarchical views and analytic functions and operations (OLAP/ROLAP). Developed text search and reference entities utilizing materialized views. Developed PL/SQL scripts to supplement load and transform of third-party source data (ETL).Provided means for data quality and cleansing. Created PL/SQL based audit application, identifying data discrepancies that could be attended to by Tier 1 support. Developed architecture to provide cross-customer enterprise level reporting.

Assumed development lead for CareCert medical software following delivery from outsourced development team. Wrote integration package in C++. Created views and dimensions to improve accuracy of reports. Established development environment by creating Oracle database instance, importing data from QA site, and configuring WebLogic. Normalized Authentidate Express database in concert with developers’ use of Hibernate. Maintained the Electronic Postmark database for the U.S Postal Service.Senior Data Manager responsible for all data products across the company's enterprise. Designed logical and physical models using ERWIN for the Authentidate CRM application. Implemented change control protocols while administering instances for development, QA, integration and production. Managed backup procedures using RMAN. Created report interface.Ported application from use of Oracle to Postgres.

For Corporate Travel Services, developed an Oracle 9i database that managed employees’ American Express Card data. Wrote PL/SQL that identified mismatches between Amex & Merck HR data. For Knowledge Management Services, developed web sites using JSP, Perl, DHTML for the Central Eng., Vaccine, and Chemical Tech departments. Implemented a business process model to support intra-divisional knowledge sharing. Utilized Documentum for web publishing. Designed an Oracle 9i database to store glossary information and to support the concept of terminology scope wherein terms could be promoted from project to department to division to corporate visibility.Supported the Enterprise Asset Management System (EAMS) in both North America and EMEA / AP versions. Designed and developed JDBC interface between MAXIMO and JDE One-World. Supported and re-factored exchange rate routines for MAXIMO’s ARIBA interface. Wrote and executed IQ/OQ and MTP according to standards set by 21 CFR Part 11.

Improved performance of the Packager Mailing System whose processing times approached 27 hours. Re-designed system completed in less than 30% of the original system’s baseline time. Re-designed HP-UX C++ application according to OO design incorporating inheritance, operator overloading, templates, and design patterns such as singletons. Made the application multi-threaded to enable parallel processing. Utilized bulk operations through an OCI interface. Tuned Oracle PL/SQL code to reduce redundant disk accesses. Modified indexes to eliminate full table scans when selecting and deleting records. Incorporated optimization hints to SELECT & UPDATE queries on Oracle RDBMS. Introduced scheduled commits reducing demand for rollback segments. Using Perl and KSH, developed build routine that extracted source code from PVCS.

Ported MS Visual C++ insurance illustrations “engine” and library source code to run on multiple UNIX platforms as the back-end server to a re-vitalized three-tier commercial solution.• Standardized source code and set up development environment for application team on both Solaris and AIX platforms. Simulated Windows functions so source code would build on both UNIX (GNU C++ 2.95) and MSVC++ 6.0 compilers.• Created permutation logic that parsed XML files and generated arrays used by JavaScript on the user-interface.• Developed load-balancing routine to facilitate performance.Supported front-end system development and worked as a resource to other groups in Product Development department.• Developed utility to automatically map data objects in previous versions of company PL/SQL to objects represented in the current release. Extended utility to work on Transact-SQL.• Synchronized middleware objects with Java tier and C++ database tier.

Client: Lucent TechnologiesProject: LMOSRe-designed a proprietary hierarchical customer service database system into a relational data model according to third normal form and implemented with Informix On-Line 7.3 (later Universal Server) running on HP-UX 10.20 (LMOS). Led the reverse engineering efforts and re-vitalized applications on the new system. Created automated routines that extracted records from legacy system, reformatted data, and loaded same into new RDBMS (ETL). Documented the database schema, re-designed processes, and all new functions. Key role in organizing the project plan according to SEI-CMM quality measures.