Dynamic professional with extensive experience in Cloud and Data Architecture, leveraging tools such as TOGAF and MS SQL Server to drive innovative solutions. Proficient in data engineering and solution architecture, with a strong focus on application development, network management, and IT team leadership. Expertise in Robotic Process Automation (RPA) using UiPath, alongside a solid foundation in configuration management engineering and SharePoint. Committed to delivering high-quality technical documentation that enhances understanding and usability across diverse projects.
Overview
24
24
years of professional experience
1
1
Certification
Work History
Data Systems Architect | Engineer
McLane Advanced Technologies, LLC
08.2022 - 06.2024
Data Architect supports the NSWC. Experienced with structured and Unstructured data Experience with Microsoft SQL Server.
Designed an approach to migrate existing warehouses in MS SQL to elastic search.
Working experience designing and building relational and dimensional conceptional/logical data models, transforming
Identified data-use areas to improve organizational activities; proposed and implemented innovative data solutions to support applicable Surface Warfare Enterprise (SWE) stakeholders in reaching informed surface Navy training investment decisions.
Supported PMS 339 Surface Training Readiness Management Systems (STRMS) program in the planning, developing, and managing an automated tool enabling the collection and analysis of data supporting training effectiveness. Data Management – ingestion, processing, and analysis.
Identified data-use areas to improve organizational activities; proposed and implemented innovative data solutions to support applicable Surface Warfare Enterprise (SWE) stakeholders in reaching informed surface Navy training investment decisions.
I Supported Senior TYCOM Staff in implementing viable surface force training automated decision support systems. Recommended and implemented proper governance (policies)
Designed, built, and maintained data models, translating and visualizing data to meet operational needs; supported feature engineering development and cross-validation.
Supported the development of a Surface Training and Readiness Management System, ENABLING TOOL, that helped manage and collect ship-focused operator and data and supported training effectiveness assessments.
Through test review and analysis, I participated in testing, test witnessing, and certification.
Provided information assurance Subject Matter Expertise and recommended system enhancements to improve Information Security deficiencies.
It effectively translated and communicated technical details to senior leadership.
Worked with DevSecOps system utilizing Clouds Architecture (common design patterns for data integration are broadcast, bidirectional synchronization, aggregation, and correlation)
Assisted in integrating modern technology, design concepts, and systems to improve data sharing, collection, and analysis with Ready Relevant Learning program requirements.
Supported development and execution of overall STRMS objectives. Established and monitored standards for the quality of programs and documents and assisted in resolving project and program priorities. Assured quality control throughout all contract activities.
Solution Architect | Software Architect
Perspecta / Catapult, Inc.
12.2019 - 03.2020
Provided Solution Architecture in RPA (Robotic Process Automation) and architecture in tools for automation, such UiPath; emphasized in DevOps - Cloud Architect and Automation Engineering task. Supported Ansible platform for CM, intra-service orchestration (integrating two or more applications), and application deployment.
Experienced in enabling Windows Feature of Hyper-V and configuration, hosted hypervisor created and managed virtual machines running different operating systems per test applications simulations, providing data manipulation and results with log aggregation consolidation of data (to facilitate streamlined log analysis)
Provided Agile support for different projects and methodologies in which methodology was defined, designed, built, tested, and released, utilizing Bitbucket/Repository and JIRA.
Provided architecture to accelerate delivery through self-service application environments, Web API, and supported developer tools. Used Python editor "Jupyter" & "JupyterLab" and other apps: Jenkins, Ansible, AWS source for Clouds.
Utilized AWS Elastic Beanstalk (an orchestration service) offered by Amazon Web Services to deploy applications orchestrating various API designs, data services, platform services, cloud services, and infrastructure services to meet user requirements and align with strategic goals with AWS.
The Project required support for both MS SQL Server as a Data Solution Architect, DB Admin / SQL Developer, and Oracle 12c. MS SQL Server query strategies, analysis, session blocks, narrowing duplicates, and DB Admin/Developer project support.
Complex data transfer from different servers, defining and creating data structures, tables, views, and indexes; database objects maintenance and performance issues. Tasked with reading, understanding, and improving upon existing code.
Supported performance monitoring, always on high availability or availability group for distributed transactions.
Supported Cloud Architecture and Data Architecture, preliminary design in Azure Architecture, and assisted in managing DBA-related projects (MSSQL DBA Management). Created, developed packages, and supported existing Army web app projects supporting Army documentation and contracts called PCF (Paperless Contract Files).
Performed Power BI data analysis in business requirements to identify hidden patterns and make predictions.
Supported different configurations between Solaris, Linux, PuTTY/PuTTYGen, and Wintel operating systems.
Coordinated and provided support for storage, networking, and infrastructure cloud services (SaaS – used for remote access to app base dev; IaaS – used for subscription accounts like MS Azure Platform installation and account cloud computing services; PaaS – used for Web Developer Solution.
Sr. Software Data Architect | Engineer
KBRWyle | Strategic Data Systems
01.2017 - 06.2018
Provided support for Project MEASWEB in software design and data design using ER/Studio or ERWin / SQL Server 2017 (v14.x) DB Admin support (ETL, tuning, troubleshooting, and analysis).
Created-Build MOCC (METAL) DASHBOARD, MCMS Exchange Process Modernization for Cloud, SSRS Design Build from SQL Server and analysis; scheduler/job automation.
Developed Software Apps using Agile methods. Software configuration management (SCM or S/W CM) was tracking and controlling changes in the software, part of the larger cross-disciplinary field of configuration management.
Provided Cloud Architecture AWS & MS Azure / Cloud services platform configuration. Supported maintenance, sustainment, and modernization of existing infrastructures based on SQL Server 2017. It endorsed the PMI TRS Analysis.
Verified systems requirements and designed interface leveraging existing import-export web services using Business Intelligence (BI) as part of customer requirements.
Created Packages, Stored Procedures, and data mapping.
Supported overall web development, providing architect-design support on new and existing web-based applications written in ColdFusion-C#, JavaScript.
NIAPS Software Engineer Architect and DevOps
Valkyrie Enterprises (SPAWAR-San Diego)
12.2015 - 01.2017
Provided support in designing, developing, maintaining, and enhancing software solutions and reports; wrote technical specifications and user documentation for all programming work.
Azure Platform Installation | Configuration and DevOps - Met with customers to discuss specific software needs on required services as needed. Provided Cloud Architecture by design from Premise IaaS; PaaS to SaaS (Azure) utilizing automation services.
Analyzed, utilized discoveries, and investigated solutions to issues imposed by current schemas. Performed maintenance and corrected defects identified with solutions.
Perform DevOps Architecture infrastructure by design/processes; Provided Build & Release Pipeline Management (in Build, Release per Dev/QA/Production and Deployment) with DSC (Desired State Configuration), PowerShell; Utilizing VMWare and Visual Studio GitHub (Distributed Control Version).
Architect | Software Architect and Network Management Consultant
Physical Rehabilitation Center (PRC)
04.2014 - 12.2015
Database Provided consulting in design advisement in SOA and developed solutions built-in ASP.NET | MVC using routing and dynamic data masking using C# for doctors | patient's privacy and lawyers.
Supported Network Management (Network Design / Security Solutions, Domain Authentication, Active Directory, Network troubleshooting / Maintenance, and Others).
Software Architect | Data Architect
Camber Corporation | Joint Support Division (San Diego)
01.2014 - 03.2014
Provided support to SSDS (Ship Self-Defense System) MK2 Simulation Software Design-Development and configuration for data targeting in "Projects Loads" and configuration requirements.
Supported by data transfer through automation in Packaging SSIS data integration procedures.
Utilized Team Foundation Server (TFS), Web API; MVC features such as routing, controllers IOC or dependence injection, unit testing; stored procedure in SQL Server 2012 and CTE's and BI
In a simulation, use tactical intelligence for simulation effectiveness by using TDDS | Tactical Related Applications (TRAP) Data Dissemination System or (IBS-S) in utilizing the main objective, targeting accuracy (TRXIS); Tracking accuracy (TIBS) for simulation effectiveness.
Provided support in Tactical Related Program (TRAP) – known as Integrated Broadcast Services (IBS-S). Data Dissemination Systems-B (TADIXS-B) broadcast system provided worldwide high interest in Electronic Intelligence (ELINT) warfare solutions, contact reports, and parametric information at the SECRET level, based upon simulation requirements and managed simulation updates.
Provided support to Vulnerability Scans Team apps written into ASP.NET.
Provided (BIDS) in Designed / Development of several tools' apps interfaced with various scan team members manipulating data from ETL - SSIS, SSRS, and pending SSAS (Analyzing Data).
Provided acting DBA support in performance tuning, query optimizer by execution plans, statistics based on metrics (settings statistics I/O and Time), plus query plans on Graphical Showplan_xml and statistical XML.
Architect of Data Flow by Data Modeling in SQL 2008, SOA, and upgrade to MS SQL Server 2012; Supported SharePoint 2010 as admin and UI developed in WPF, C# and configured Microsoft – IIS.
Transferred one App from ASP to .NET Modern-View-Controller (MVC), utilizing its MVC patterns inside controllers and using Web Services or WCF.
Also used and configured TFS (Team Foundation Server) to better serve team coders and eliminate its current Source Safe in connection to various versioning and SharePoint projects.
Started to work with Cloud since TFS is converted to Azure.
Software Engineer Architect
Global System Technology (NAS Coronado)
01.2011 - 07.2011
Provided Oracle Development based on PL/SQL replications (using Materialized View); Supported all GST Technological Applications and Data Exchange Application-Web Services in C# and XML transaction data files processed in Oracle.
Supported legacy systems by converting VB6 to VB.Net consolidation apps. Including the support of VMware workstation and Hyper-V for Windows | Linux, two different Virtual machines
Provided Object Oriented Architecture and supported ColdFusion website and MS SQL Server 2008, writing complex stored procedures, cursors, and CTEs.
Data Architect
Northrop Grumman (San Diego) | Oaktree Software, Inc. (Tulsa, OK)
11.2009 - 05.2010
Provided support for NGSAMS Application and its life cycle for DoD, DLA to D043 (AF).
Created DSS data extraction or transaction. It’s not by its layer of nesting.
Assisted with Euro-NGSAMS Architecture and Enterprise Continuum Development/ITAR using TOGAF (The Open Group Architecture Framework). Supported MILSTRIP and MILSTRAP Requirements from PO, Requisition through Mod Retrofit, and DD250.
Provided Systems Integration | Open Architectures across multiple domains delivering advanced C4ISR capabilities. Development support consisted of web platforms, payloads, and sensors giving client/customers information needed.
TOGAF ; utilizing Architecture Development Method (ADM)by Preliminary Phase: Organization for successful Architecture Project; Phase A: Architecture Vision: Establish Project and obtain approval; Phase B: Business Architecture- includes such as Business strategy, Governance organization and key business processes; Phase C: Info Systems Architectures: Includes Data Architectures and Application Architectures; Phase D: Technology Architectures: Describes logical software and hardware capabilities required; Phase E: opportunities and solutions: Identifies delivery vehicles for the Architecture; Phase F:Migration Planning Develops Detail Implementation and Migration Plans; Phase G: Implementation Governance: Provides Architecture oversight for the implementation; Phase H: Architecture Change Management: ensures that the Architecture continues to provide the required value;
Enterprise Continuum: Part of the TOGAF – a way of classifying solutions and Architectures on a continuum from generic to specific;
Architecture Repository: I used this repository outputs created by executing the ADM cycle;
Reference Model: Technical Reference Model (TRM)- Provides a Model and generic platform Services. Including Architecture Framework -a detailed model of architectural work Products , deliverables, artifacts and building blocks.
Software Architecture | Engineer
L-3 COM / D.P. Associates, Inc. (San Diego)
09.2008 - 09.2009
Provided support in Design (Team Lead of five) for New-Old Architecture analysis on various project apps for MH-60 Romeo & Sierra Helicopters and designed/built new Windows apps for "DataTransfer" - Integrations engines on importing and exporting batch data. Converted Project HR in legacy VB6 (no longer supported by MS) into VB.Net, and c#
Provided DB Admin Support for MS SQL Server 2008, backup, data management, and Configuration Managements Engineering in support systems and Oracle backend configurations.
Security Apps on CD- Encryption / Decryption 256-bit AES on course Lessons by Auto-Viewing classified requirements for easy transfer but complex target development. Supported "SCORM Engines" (Shareable Content Object Reference Model) of its configuration and TDR (Training Discrepancies Reports) Reporting.
Worked with Data Engineers in Supporting and configuring the Cloud on-premises.
Supported "ONTRACK" (Online Training Assets Control), which provided a MILSTRIP requisition, Fleet Feed-Back (FFB) Re-Design Development used WCF for scope servicing Fleet-wide utilizations through ASP.NET XML consumption. Supported "CoDE" (Courseware Development Engines) and Built "DOMS" (DPA Online Management System v3.2.4.001) using ASP legacy.
Installed | Configured SharePoint Environment on-premises with prerequisites Installer.
Software Architecture | Engineer
Cytori Therapeutics (San Diego)
06.2007 - 11.2007
Provided Software Architecture Design and Software Engineering buildup of "Stem Cell Banking" Enterprise Apps for International (Japan) Hospitals and Doctors’ User Interfaces in Japan and Italy.
Developed complex interface apps for adipose data processing, its data, and accurate data storing in a complex database. Stem Cell structures using MS SQL Server 2008 on data management, complex queries, Stored Procedures, and doctors in charge of private protocol on patient stem-cell DNA and RNA. SQL Development of SSIS, SSRS, and design based on Pre-Screened Adipocytes data information. Used "SCRUM" Technologies implemented design patterns, database design, and barcoding. Also utilized subversion application and later managed a team of six (6) SE, and Admin
Systems Architecture and Cloud Engineer
Dr. Emery Chiropractor Care (National City / Bonita)
01.2007 - 05.2007
Develop customized billing with Dr. Emery's required proprietary Billing Application.
Created and managed database structures to automate and config infrastructures to handle auto-customized data transfer execution from third-party entities (Medical billing).
Identifying configurations, configuration items, and baselines.
Software Architecture | Engineer
Primary Management (San Diego)
10.2006 - 12.2006
Designed and developed websites for Internal and External Applications for administrations (Intranet and Windows Applications) and supported enterprise infrastructure development and configuration at security levels.
Identified arrangements configuration items and developed complex database infrastructure on ETL to support local and foreign Web Services using WCF.
Solution Architect | Engineer
Euro International Marketing (Carlsbad)
09.2006 - 10.2006
Designed and developed an Enterprise .NET Remoting / Web services / Intranet / Internet supporting private companies with products and services abroad using C#, asp.net 2.0, SQL server 2005, and Data Warehousing design CMI.
Developed wrap-around interfaces for an existing legacy application. An application consists of accounting, reporting, and third-party software XtraGrid and XtraNav
Responsible for designing and implementing many facets into API development, internal TMS (our client...), and Build and Release.
Software Engineer | SQL Developer
Ocean Systems Engineering Corporation (San Diego)
07.2005 - 08.2006
Provided support to CCB with definitive requirements per Navy commands and staff management decisions in Requisition Cycle, Lateral Distribution Processes in Inventory Control Point (ICP) or Integrated Material management (IMM) support to supply distributions activities; MRP – Material Return Program.
Interfaces: ship-to-ship, ship-to-shore, and land. MILSTRIP material obligation validation validates overage backorder reports by customer requisitions, reconciliation obligation records, and due-in records of customers.
Continuous Integration (CI) automated the build and testing of code every time a team member committed changes to version control. Designed and developed Project "Environmental Management Enterprise Systems (EMS)." Developed Project "SEPO" for Naval Training Management Application Systems in MS Access 2003 | VBA | VB.NET
Software Architecture | Engineer
San Diego Sheriff Data Center (San Diego) / Enforcement Support Agency
12.2004 - 01.2005
Designed and built Extranet/Intranet SDLaw-eSUN Administrative Security Enterprise Services in web services emphasizing SOA (Service Oriented Architecture) and supported Systems configurations.
Regional Information Technology Service Center CNRSW-PAC (at Coronado Naval Base San Diego) Software Application Engineer
Computer Science Corporation
11.2003 - 05.2004
Provided support to "The Naval Regional Information Technology Service Center (RITSC)" in Coronado - Naval Base to design and create an advanced search engine capable of searching any data fields with cross-linking remoting into multiple databases in total terabytes.
The application was developed in C#.NET, T-SQL, ASP.NET, OOD/OOP, and XML with New Centralize HR-Union Centralize Grievance Tracker Intranet, tracking, centralize grievance requests throughout Naval Base Community and other international bases. Supported Systems Configuration.
Adjunct Instructor
Community Colleges in California
07.2001 - 10.2003
Adjunct Instructor for various community colleges, teaching subjects such as - ASP.NET, C#, VB, VBScript, JavaScript, OOP, OOD, XML/XSLT/XHTML, ADO, COM-DLL, UML, Perl script, VB6 and relational database design, MS Excel 2000/2003, MS Access 2000/2003
Grossmont Community College
Southwestern College
DeVry & Keller Graduates University
San Jose State University Continuing Education Center [07/1999 – 09/1999]
Senior Software Engineer/Web Developer
WorldxChange Communication Corporation (San Diego)
11.2000 - 06.2001
Managed a team of ten (10) developers and 2-Db Administrators
Developed User Interactive Interface Commission Engine, VB-Pump, overall 2nd Phase of Commission Engine for Multi-Level Agents Hierarchy and developed Interactive Corporate Intranet and Extranet using ASP with Oracle and SQL Server database.
Education
Master of Science - Software Engineering
National University
10.2000
Bachelor of Science - Computer Science
National University
07.1999
Skills
Architecture Databases: IT Architecture; Database Architecture / Developer, Data Modeler ETL/ELT (VS SSIS, SSAS & SSRS) in MS SQL Server (v2016-5, 2016v13, 2017v14, 2022v16)T-SQL; Oracle (8i, 9i, 10g, 11i, 12c); SQL Developer and Oracle Developer; PL/SQL; Database Security; Data Warehouse; Data Lake - Data Lake House, ADO/ADONET; Power BI (Business Intelligence); Governance; Data Analytics
Language(s): C#NET, C, Windows Applications, Python 38 (JupyterLab) ASPNET, VBNET, HTML/5, XML, XSL/XSLT, Design Pattern, ColdFusion, VB6, VBA, VBScript, JavaScript, jQuery, Perl script, PowerShell and TFS-DSC (Desire State Configuration), SCALA
Applications: MS Visual Studio 2019-2022, SOA, NET Web Services, Workflow, Design Pattern, MS Application Block, ASPX, SOAP, WPF, ASP, HTML/5, DHTML, Data-Junction (VB), Acuity/ by Sage (VB), KAWA, Toad, Solaris, COM, Silverlight, USE CASE with Sequential or Collaboration Design, Camtasia, Subversion, SVN-Tortoise SCM, ColdFusion, MDX – Macromedia, TOGAF (The Open Group Architecture Frameworks – not certified) Jupyter JupyterLab, Robotic Process Automation (RPA), UiPath
O/S: Wintel, MS Windows (20102011), Windows Server (20192022) Advanced Server, UNIX, PuTTY / PuTTYGen, Solaris, Apache, SUN (Microsystems 5000 & 10000), Linux-Ubuntu for Windows, Windows TFS (Team Foundation Server – Release Management and Version Control) or known as MS Azure
Cloud: GIT (Global Integrated Technology), Bitbucket, Docker, and GitHub VS-Online; Azure Platform or Azure DevOps Server; DevSecOps AWS; Octopus; Network Management – Firewall and Load balancing; Azure Architecture (Cloud Design Pattern); MS Hyper-V and VMware Workstation desktop virtualization software Data Pipelines Orchestration in Azure
Other: DISA w/STIG, CMMI, IIS, Rational Rose (Reverse Engineering and UML), MS Visio-Design, UltraDev, MS InterDev, TOAD, ER/Studio, Erwin, Bitbucket/Repository; Atlassian JIRA (SCRUM, KANBAN, BUG TRACKING); IaaS; PaaS; SaaS; MANTIS Bug Tracking
Certification
IAT Level II Security+ Certified CE # COMPT00102496546 CompTIA Expires: 2028-12-15 Experienced in Cloud Architecture | Data Architecture (Tools: TOGAF, MS sql SERVER | Platforms – Storing | Development and analyzing - Data Representation), Data Engineering | Solution Architecture | Engineering, Application Development Network Management, Management of IT (Software Architects | Engineers | Developers and IT Departments), Robotic Process Automation (RPA - UiPath), Configuration Management Engineering, and SharePoint.
Youth Development Leader and Art Teacher at Boys & Girls Club of San ClementeYouth Development Leader and Art Teacher at Boys & Girls Club of San Clemente