Carlos G Email & Phone Number

Toronto, Ontario, Ca

Las Vegas, Nv, Us

Reno, Nevada, Us

Alpharetta, Georgia, Us

 Oakland Police Department – PRIME Plus Project ETL / SSIS Creation of ETL/SSIS for various legacy systems San Mateo Country – PIMS Project ETL SSIS Creation of ETL/SSIS/Stored Procedures/SQL Scripting Troubleshooting of SQL Scripts Legacy database conversion to SQL Server Optimization of SQL Scripts Data cleansing/data mapping Created SSRS reports and Powershell Scripts to automatically generate historical reports Oakland Police Department – PRIME Project ETL / SSIS Creation of ETL/SSIS/Stored Procedures/SQL Scripting Troubleshooting of SQL Scripts Legacy database conversion to SQL Server Optimization of SQL Scripts Data cleansing/data mapping Stanislaus County – Odyssey Implementation Support Created stored procedure to create output for a Calendar Web Service Provided onsite Go-Live support Los Angeles Supreme Court – Integration and Reporting / Business Intelligence Creation of ETL/SSIS for Staging and Data Warehouse environments on Azure for Cases and Events Created various SSRS reports for the following Superior Court departments: Tested eCitations interface with various Red Light Camera providers Deployment of custom reports (ECRs) in Odyssey Case Management Configuration of Tyler Batch Jobs in Odyssey Case Management PowerBI Data Modelling Napa County – Integration and Reporting / Business Intelligence Created various SSRS reports for the following Superior Court departments:Family Law, Juvenile, Probate, Traffic, MRU Research Reports Tested eCitations interface with various Red Light Camera providers Deployment of custom reports (ECRs) in Odyssey Case Management Created Automated Courtesy Notice SQL scripts that provides flat files for 3rdParty Servicer. Tyler Technology Odyssey Legacy Data Conversion Projects (Judicial Systems) (February 2016 to Dec 2016) Creation of ETL/SSIS /Stored Procedures/SQL Scripting Legacy database conversion to SQL Server using in house ETL Conversion Tool

Managed the technology upgrade of the IT InfrastructureImplementation of policies and procedures governing IT Changes and ReleasesEstablished Help Desk ticketing system using JIRAMonitoring of trouble ticket SLAs on a regular basisInterview users and create documentation of requirements utilizing use cases for processes on logistics, purchasing, and sales.Manage and assist in the design and development of Morgan Fabrics and Michael Jon Designs websites.Managed the training and implementation of the AS400 production module.Design of Architecture for Data Warehouse/BI applications and reportsCreate SSIS packages to transfer and aggregate information from AS400 DB2 to SQL Server 2014.Created initial Dashboards on Excel Pivot tables directly connected to AS400 DB2 through ODBCImplemented Sharepoint 2012 as the company's collaboration tools and central repository for documents and reports.Created various sales and logistics reports for management using SSRSCreated stored procedures, views and functions on SQL Server 2014 for the management reporting database.Created a powershell script to monitor the health of all servers on a daily basis

Monitoring of application systems utilizing Appdynamics, Spectrum, and CA Cloud Monitor, plus some SQL scripts set-up to send out notifications and alerts. Systems supported are both COTS and custom-developed systems written in C#/.NET and Java.Monitored incident tickets and ensured that we are within SLA at all times using Remedy.Coordinated the transfer of trouble tickets to problem tickets (bugs) and escalated to L3 Development supportCoordinated activities performed by the offshore team Application Support for VIP Reservations, Loyalty Management Engine systems and BoomerAssist in troubleshooting of applications during Strike Team callsRegular meetings with offshore team and MGM managementCreated database alerts for the Aprimo Marketing System.Created Unix scripts for log analysis report for ICEEnsured acquisition of KT between MGM/Vendors on supported applications and maintained documentations on sharepoint.Created notification and alert sql scripts for Aprimo Marketing Studio

Developed and maintained a project plan for the RRFS Technology replacement project using MS Project.Established the project teamAdopted both Waterfall and Agile/Scrum SDLC methodologiesConducted daily scrum meetings and sprint review/restrospectivePrepared project budgets and presented it to the stakeholdersHeld weekly project status updates with the stakeholders, SMEs and management.Designed User Story/Use Case template Created system specifications based on use cases and business rules.Led JAD sessions with SMEs to “walk-through” mock-up (wire-frame) of screensEstablished Software Development process of a small development team.Implemented Software Change ControlEstablished Quality Assurance process and documentation requirementsReorganized and reconfigured their JIRA bug ticketing system and added workflows to adapt to the new software development processReorganized the development team, establishing accountabilities and responsibilitiesCurrently heading a project to replace legacy systems with web based systems that are fully integrated with the VOIP PBX, Fax Servers, Docuware Document Imaging SystemsRedesign of the real-time interfaces with the client systemCreated an Attorney Portal using DocuwareBuilt the SSIS/ETL data migration from Legacy systems to the new SQL Server 2008 R2 database.Developed Powershell scripts to automate the fetching of data from an external FTP site, parse, map, and upload data into SQL Server R2Developed numerous complex stored procedures, views, functions, triggers for the new system.Set-up and managed full database replication on SQL Server 2008 R2Set-up and managed maintenance plans for index health and backups.Managed business analysts, architects, software developers, and QA.Managed the JIRA defect log and issues.Managed the ONTRACK technology replacement project from thick client to web based technologies C#.net on SQL Server 2008 R2Tested web services using SOAPUI

Us

Conducted regular meetings with Vendor (SCC) to monitor progress vs established timelines of the GEDI projectConducted JAD sessions with subject matter experts to present and discuss modules and functionalityConducted regular meetings with stakeholders, SMEs, and business users to update them on the status of development and testing and to clarify requirementsDeveloped and implemented Quality Assurance policies and proceduresDeveloped and implemented templates for test cases and test scripts utilizing agile methodologyPrepared User Acceptance Test Plans and QA Test Plans,Developed test cases/scenarios for custom software developed in VB/C# .NET on an Oracle 10g db backend.Managed and mentored 7 .NET and VB programmers in order to ensure that appropriate pragmatic solutions to complex system functionality issues are resolved in a timely manner.Managed the development and QA activities on the laboratory management system for biochem, cytogenetics, fish, and oncologySupervised the Oracle Developers on the creation of database triggers, stored procedures, and functionsCoordinated with the Release Engineering team on production releases.Reviewed and approved software versions for release into production.Reviewed and approved HL7 interfaces to the client’s systemReviewed and approved in-house system interfaces to laboratory equipmentResourced, trained and monitor the activities of off-shore QA resourcesConducted triage meetings to discuss priorities of issues and ensure timely resolutionReviewed and tested Rule based protocols (RBS Manager) on workflow processes, routing, and conditionsPrepared Plans for data cleansing and testing strategies for quick releases / scrum cyclesWrote automated SQL test scripts for testing lab test interpretations and interfaces to background processes such as automatic approval and report generation and auto-fax

Management of software development for medical collections on C#/.NET on a MS SQL Server 2005 database running on Windows 2000/2003.

overall management of family business in Las Vegas

Quezon City, Metro Manila, Ph

Managed the LTO-IT Project for the Philippines DMV. Project involved building a state-of-the-art data center, network infrastructure, custom software development of various applications on powerbuilder / sybase on a Unix backend.

Quezon City, Ph

Management of Software Development and Systems Integration using Oracle in a Unix environment.

Regional Software Development using Progress 4GL on Progress SQL and IS/IT Coordination in the South East Asian region.

Switzerland 🇨🇭 , Ch

Software development for Accounting / MRP II / Distribution / TMS on 4GL/SQL in a Unix environment

Bachelors, Business Administration, Accounting Major

Client-Server Systems Integration, Software Development

Bs, Psychology

High School