Antonio G Diogo

Fallbrook CA *****

858-***-****

adxuc4@r.postjobfree.com

PROFESSIONAL PROFILE

Over 20 years of experience in many areas of information technology -- as a manager, developer, analyst, and systems administrator, mostly as a developer and database administrator.

Expertise is in Microsoft SQL’s suite of technologies - MSBI stack and database architecture, including design, development, performance tuning, maintenance, security, backup, and recovery.

Experience in gathering business requirements, research, developing customized applications, designing, evaluating, and deploying enterprise-wide ERP solutions, and project management.

Experience in managing computer operations, maintaining mission-critical systems, incorporate the

latest technologies; and providing recommendations and ROI to all stakeholders.

TECHNICAL SKILLS

Databases: MSSQL Server 2000-2019, DB2, MS Access, Oracle

Languages: T-SQL, .NET: (ASP, C#, VB); XML, IBM COBOL, JavaScript

IDE: Visual Studio, SQL Server Management Studio

MSBI: SSIS, SSRS, SSAS, PowerBI, Business Objects

Cloud/Web: Azure, AWS, Web Services, API, Microservices

ETL/Other Pervasive Data Integrator, Actian, JSON, Replication

EXPERIENCE

Carter Hospitality, Inc., Santa Ana CA Dec 2020 – Apr 2023

Sr SQL DBA

Develop and manage reporting services for Carter Hospitality’s wine and spa resorts and hospitality locations across the country.

Created ERP reporting structure for South Coast and Carter Creek Wineries and Spas using SSRS

and Power BI, producing detailed reporting on the resorts’ wine club sales and memberships, wine shipments, restaurant sales.

Confidential, Bethesda, MD (80% remote) Aug 2019 – Oct 2020

SQL Architect

Developed an in-house application for a medium-sized company of all client data. Consolidated multiple data sources (Excel, MS Access), of all client information data to a centralized repository – MSSQL Server.

Developed data models of company’s client data. With SSIS and Pervasive, transformed all client and corporate information into SQL Server.

Converted existing reports into a real time, menu-driven solution. SSRS reporting server menu allows for ad hoc client requests, along with scheduled monthly and quarterly reporting to managing partners.

Established a repository for case research, with API’s and links to relevant, historical cases.

Conduent, Irvine, CA February 2019 – April 2019

Senior SQL Developer

Short-term contract to move all ETL processes from a retiring system (Pervasive). Created stored procedures to replace all DJ maps. Analyzed and converted Pervasive map transformations to SQL stored procedures. Mostly moving incoming workers compensation information to healthcare clients’ hosted platform. Also worked with B2B workflow for job scheduling.

nGAP, Inc., Bonsall, CA May 2015 – March 2018

Senior SQL Developer

Created stand-alone vendor application using C#.NET, .NET Core, and SQL Server. The vendor portal interacts directly with the main, propriety government acquisition software solution. Designed and developed database schema and SQL backend including creation of database schema and design, table architecture – indexes and keys, user security, SQL replication, fail-over clustering, integration with OAS application, and reporting services.

Created ETL processes to integrate data into OAS and Vendor Portal applications from client platforms with stored procedures, functions, and triggers; and implemented web services and API’s.

Responsible for all SQL database administration. Created maintenance plans for all databases – production,

stage and test environments, backups, re-indexing, and ad hoc reporting with SQL jobs via SQL agent.

One Call Care Management, Irvine, CA November 2014 – May 2015

Senior SQL Developer

Created and successfully implemented ETL processes using Actian data transformation software, to move worker’s compensation information from providers within large health care networks: Anthem, Prudential, Sedgewick, Aetna, and several others.

Introduced/created reporting functionality (SSRS), in compliance with business guidelines and heath care metrics.

Victory Team Apparel, San Diego, CA October 2013 – September 2014

Senior SQL Developer

Created and implemented daily, weekly, monthly sales and inventory reports using SSRS.

Responsible for all SQL database development and administration on company’s ERP system.

Streamlined data replication from production to multiple web site environments.

Chevron Corp., San Ramon, CA March 2012 – August 2013

SQL Developer (Contract)

Created and implemented interfaces from MS Access to SQL Server with stored procedures, triggers, and produced SSIS packages to consolidate data from over four hundred service stations nationwide.

Successfully streamlined and consolidated daily processing of various financial systems (SSIS) – working funds, cash receipts, lottery in linked MS Access databases to master SQL Server environment.

Developed project plan for migrating MS Access systems architecture to .NET/SQL Server environment.

Alion Science & Technology, McLean, VA February 2010 - February 2012

Senior Programmer Analyst

Created SSIS packages to extract and archive data from enterprise-wide timecard system (PeopleSoft).

Developed and implanted financial/payroll reports and dashboards with SSRS, SSAS.

Created incremental interfaces from COBOL/UNIX host platform to data warehouse and budget systems with SSIS, stored procs, job scheduling via Cron command line utilities, moving data out to staging area.

Streamlined employee data flow from Peoplesoft HR/Payroll to and from the financial and timecard systems, to and from Oracle to/from SQL Server-based time and budget expense systems with SSIS and data modeling.

City of Rockville, Rockville, MD July 2000 - February 2010

Programmer Analyst

Successfully implemented software/hardware upgrades of both Financial and HR/Payroll systems, from COBOL legacy mainframe to a web-based, dot Net/SQL Server database environment.

Automated the City’s internal/external forms, including time and attendance, purchase orders, and vendor inquiries with ASP, ASP.NET, and Crystal Reports.

Developed front-end online application with ASP; created DTS packages to export expense and revenue budget VSAM files from mainframe to SQL Server staging area. Created easier access to financial, HR/Payroll data throughout the City.

Developed SQL data warehouse environments, universes with Business Objects for financial and HR/payroll modules. Managed the City’s water billing system - C# application, integration into City’s financial system.

Responsible for the City’s financial and HR/payroll systems: applications and databases, interfaces,

nightly cycle and payroll processes; application of new releases/sub-releases and patches; database maintenance, backups, optimizations, integrity checks with maintenance plans implementation and SQL agent job scheduling.

EDUCATION & LANGUAGES

The George Washington University, Washington, DC Computer Science, Business

Montgomery College, Rockville, MD AS Computer Science, Business Administration

Fluent in Portuguese, Spanish, Italian

Contact this candidate