Principal Architect Resume

SUMMARY

Strategic technology implementer and team leader, with 10+ years’ experience in enterprise technologies, entertainment and financial systems.
Leveraging deep architectural, database and cloud engineering capabilities, most recently at Universal Studios, driving business performance and value thru enterprise integration of Information Technology, solutions.
Continually - promoted at Universal to leverage big picture vision, exceptional analytical & problem-solving coding; delivered solutions from concept to full-stack cloud applications, often in under (1) day; leveraged easily-scalable frameworks delivering database systems, REST API integration, full UX design—on time, within budget, saving 100s of hours of development.
Solely architected, designed, data-modeled, launched enterprise IT application systems converting 100+ Excel data files with massive data quality issues into single cohesive, uniform, normalized database—with automation code replacing dozens of languages, and reducing outages 23%.
Regularly manage technology consultants, development teams—both in-person, and offshore; speak the language of technology & business, continually bridge gaps between the two, empowering enhanced decision-making.
Dedicated to continuous learning and thrive in challenging environments; excited about learning new tools / building own and creating simple solutions to complex problems.

TECHNICAL SKILLS

DBMS Models: OLTP, DSS, data warehouse enterprise modeling & development.

Cloud: AWS, Oracle OCI, Google, Azure, APEX.

DBMS: Oracle v7 - v19; SQL Server 6.5 - 2017; Mongo, PostgreSQL, MariaDB, MySQL, Teradata, Aurora, DynamoDB

OS: UNIX, Linux, AIX, HP-UX, Sun Solaris, Windows.

Languages: SQL, PL/SQL, T-SQL, shell scripts, C, Python, Java; JavaScript, jQuery, CSS, HTML, XML, REST API, JSON.

PROFESSIONAL EXPERIENCE

Confidential

Principal Architect

Responsibilities:

Created comprehensive instructions for total buildout and migration of Oracle DBMS to AWS cloud (RDS, VPC EC2). Planned, evolved, matured and executed cloud migration plans including roadmap, risk assessment alternatives.
Led research, evaluation, development of PoC (proof of concepts) for emerging technologies, app design, modeling, code interfaces for project development, creating “Centers of Excellence” (CoE), promoting consistent, repeatable REST API’s.
Accelerated automation, shortened project schedules in schema design, automatic data creation across dynamically-created entities, business rules, UX design and provided full deployment lifecycle support to off shore teams supporting multiple dbms’s including MariaDB, MongoDB, PostgreDB, MySQL, Oracle and Sql Server.
Specialized in Oracle Systems development and infrastructure, both on-premises and in the Oracle OCI/APEX cloud and AWS.
Focused on Oracle Application Express Framework (APEX), Oracle Restful Data Services (ORDS). Built integration into ServiceNow / LDAP for single sign on (SSO) enterprise authentication and customized authorization workflows.

Senior Database Architect

Confidential

Responsibilities:

Modeled and executed deep infrastructure API details and organizational dependencies, mapping platform ecosystems—driving massive cost reduction by workflow automation, improved accuracy, delivering real-time management reports.
Eliminated use of Excel by providing Database/Cloud based solutions that better managed the hundreds of XLS spreadsheets by creating a single database-driven website and management portal.
Delivered advanced security, authentication, audit, single-sign-on from enterprise LDAP and social login.
Provided natural, easy implementation of master-detail-detail data relationship management in DBMS, replacing Excel.

Senior Developer / Application DBA

Confidential

Responsibilities:

Led massive reorganization, tuning, total rewrite to correct massive failures in Audit Tracking System.
Created full reporting and audit capabilities to facilitate retroactive pay, as needed.
Used Erwin 4.0 to document system in Sybase; wrote documentation for developers migrating T-SQL to PL / SQL; custom-built new Oracle apps delivering seamless migration, simulating many Sybase internal components, abilities.
Transitioned global PL/SQL packages to Global API for Apache Web Server, Perl, MySQL; cleaned up, normalized all data from multiple 3rd-party sources, replacing functionality previously covered by multiple tools, 50+ entry-points and manual entry.