Data Scientist Applicant with Cloud & Data Architecture
Resume:
VINCENT
R. CABRERA
*************@*****.***
San Diego, CA 92139
Personal Website
TECHNICAL SUMMARY
• 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/ADO.NET;
Power BI (Business Intelligence);
Governance; Data Analytics
• Language(s): C#.NET, C++, Windows
Applications, Python 3.8 (JupyterLab)
ASP.NET, VB.NET, 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 –
PROFESSIONAL SUMMARY
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. WEBSITES, PORTFOLIOS, PROFILES
Government ID: 870646
https://www.linkedin.com/in/vincent-r-cabrera-50954abb/ EMPLOYMENT HISTORY
McLane Advanced Technologies, LLC - Data Systems Architect Engineer
8484 Westpark Dr, 900, McLean, VA22102 • 08/2022 - 06/2023
• 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.
• Managed designing and building relational and dimensional conceptional/logical data models, transforming
• Identified data-use (analysis) 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. COMNAVSURFPAC SERCO-NA, Inc Smart-Synergies.com - Solution Architect Data Architect
1818 Library St., Reston, VA22102 • 07/2021 - 07/2022
• 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 Page 2 of 9
Macromedia, TOGAF (The Open Group
Architecture Frameworks – not
certified) Jupyter JupyterLab,
Robotic Process Automation (RPA),
UiPath
• O/S: Wintel, MS Windows
(2010 2011), Windows Server
(2019 2022) 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.
• DevOps DevSecOps Tools: Jenkins,
Octopus, Ansible, Bitbucket, Dockers
(Containerizations)
• 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
EDUCATION &
CERTIFICATIONS
National University
12555 North Torrey Pines Rd., San
Diego, CA 92423 • 10/2000
Master of Science: Software
Engineering
National University
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.
Perspecta, Inc Catapult, Inc. - Solution Architect Software Architect
15000 Conference Center Dr., #100, Chantilly, VA • 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 hypervisors 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)
• Agile support provided for different projects and methodologies in which methodology was defined, designed, built, tested, and released, utilizing Bitbucket/Repository and JIRA. Page 3 of 9
12555 North Torrey Pines Rd., San
Diego, CA 92423 • 07/1999
Bachelor of Science: Computer Science
EDUCATION &
CERTIFICATIONS
• 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.
• Software Engineering III: Software
Metrics, SAIC, SD
• Artificial Intelligence (AI Certificate)
• Top Secret: Active Top-Secret
Clearance - 2023-06-03 to (5-yrs) by
DoD CAF
• Secret: Active Secret Clearance -
2023-03-06 to (5-Yrs) by DoD CAF
• S D Sheriff Data Center: Security
Clearance, San Diego
ADDITIONAL INFORMATIONS
• DESIGN DATABASE:
CONCEPTIONAL & LOGICAL
MODELING AND PHYSICAL
SCHEMA DESIGN AND
PERORMANCE OPTIMIZATION
• 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.
Enterprise Architecture. SPAWAR / Intellect Solutions, LLC - Data Architect and Design/Developer
4301 Pacific Hwy,(formerly Air Force Plt#19) In OT • 06/2018 - 11/2019
• 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.
KBRWyle Technology Sol'n LLC Strategic Data Sys - Sr. Software Data Architect Engineer
601 Jefferson St., Houston TX 77002 • 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 Page 4 of 9
• DESIGN
ARCHITECTURE:
ABILITY TO DESIGN TECFHNICAL
DATA SYSTEMS WITH BUSINESS
• POSTGRESQL
ADMINISTRATION:
HIGH-LEVEL EXPERTISE IN
MAINTAINING DATABASE
PERFORMANCE, STABILITY, AND
SECURETY.
• DATA MODELING:
10+YRS OF EXPERIENCE
DESIGN, HIGH PERFORMANCE,
SCALABLE STRUCTURES FOR
BOTH (OLTP) ANDANALYTICAL
(OLAP) ENVIRONMENT.
• HA SETUP:
HIGH AVAILABILITY SETUPS IS
MY KEY RESPONSIBILITY; MY
EXPERIENCEDSHOULD REFELECT
MY UNDERSTANDING OF HOW
TO ELIMINATE A SINGLE POINT
OF FAILURE IN ANENTERPRISE
ENVIRNMENT.
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.
Valkyrie Enterprises SPAWAR-San Diego - NIAPS Software Engineer Architect and DevOps
4301 Pacific Highway (formerly The Old Air Force • 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).
Physical Rehabilitation Center (PRC) - Architect Software Architect and Network Management Consultant
Coronado Base, Coronado, CA • 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).
Camber Corporation Joint Support Division (San Diego) - Software Architect Data Architect
2448 Historic Decature, Ste#120, SD, CA 92106 • 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. Page 5 of 9
• 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. Hewlett Packard Enterprises Services, LLC (NAS Coronado) - Software Architect Engineer and SQL Developer
6280 America Center Dr., San Jose, CA 95002 • 07/2011 - 01/2013
• 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 with various versioning and SharePoint projects.
• I started to work with Cloud since TFS is converted to Azure. Global System Technology (NAS Coronado) - Software Engineer Architect
102 Floral Vale Blvd., Yardley, PA • 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 Page 6 of 9
• Provided Object Oriented Architecture and supported ColdFusion website and MS SQL Server 2008, writing complex stored procedures, cursors, and CTEs.
Cytori Therapeutics (San Diego) - Software Architecture Engineer, Consultant
8659 Production Avenue, SD CA 92121 • 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-cells 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
Dr. Emery Chiropractor Care (National City / Bonita) - Systems Architecture and Systems Engr., Consultant
National City • 01/2007 - 05/2007
• Develop customized billing with Dr. Emery's required proprietary Billing Application.
• Systems Created and managed database structures to automate and system configuration on infrastructures to handle auto- customized data transfer execution from third-party entities
(Medical billing).
• Identifying configurations, configuration items, and baselines. Primary Management (San Diego), Inc. - Software Architecture Engineer, Consultant
San Diego, CA • 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.
Euro International Marketing (Carlsbad) - Solution Architect Engineer
Carlsbad, CA • 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.
Page 7 of 9
• 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. Ocean Systems Engineering Corporation (San Diego) - Software Engineer SQL Developer; Tmp Consultant
2535 Camino Del Rio, Ste350, SD, CA 92108 • 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
San Diego Sheriff Data Center (San Diego) / Enforcement Support Agency - Software Architecture Engineer
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.
Computer Science Corporation - Regional Information Technology Service Center CNRSW-PAC (at Coronado Naval Base San Diego) Software Application Engineer
Coronado, CA • 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. in San Jose Community College, California - Adjunct Instructor San Jose, CA • 07/2001 - 10/2003
Page 8 of 9
• 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]
WorldxChange Communication Corporation (San Diego) - Senior Software Engineer/Web Developer
9999 Willow Creek RD., SD, CA. 92131 • 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. LANGUAGE(S)
C#.NET, C++, Windows
Applications, Python 3.8
(JupyterLab) ASP.NET,
VB.NET, HTML/5, XML,
XSL/XSLT, Design Pattern,
ColdFusion, VB6, VBA,
VBScript, JavaScript, jQuery,
Perl script, PowerShell and
TFS-DSC (Desire State
Configuration), SCALA
Page 9 of 9
. #HRJ#b631a8d2-0427-4896-82a2-53f37db2ed42#
Contact this candidate