Carlos G

Carlos G Email and Phone Number

Business Intelligence | Data Warehousing | ETL | Data Integration | SQL Development | Data Governance @ Sierra Cybernetics Inc
Carlos G's Location
Las Vegas, Nevada, United States, United States
Carlos G's Contact Details

Carlos G personal email

n/a
About Carlos G

20+ years of IT experience in systems development and integration, Project Management, and Systems Integration. 20+ years of SQL Server Database Design/Stored Procedures/ Optimization, SSIS, ETL, Data Conversions, Data Cleansing, Data Mapping, 15+ years of SSRS, Report Development, Power BI, Dashboard3+ years of Azure DevOps, Azure SQL DWOther Skills: Product Life cycle Management, SDLC Waterfall/Agile, System Integration, Quality Assurance, Business Process Re-engineering, IT Policies and Procedures, Data Center Operations, Project Management, Business Requirement Gathering, Change Management, RFP Preparation, Vendor Management and Negotiation, Resource Management, , Functional realignment and reorganization, COTS Customizations, utilization of offshore resources.Industry Exposure: Healthcare, pharmaceutical, financial services, manufacturing/distribution, government, insurance, retail, hotel and casino, direct selling, education, and telecommunications

Carlos G's Current Company Details
Sierra Cybernetics Inc

Sierra Cybernetics Inc

View
Business Intelligence | Data Warehousing | ETL | Data Integration | SQL Development | Data Governance
Carlos G Work Experience Details
  • Sierra Cybernetics Inc
    It Consultant - Etl And Reporting
    Sierra Cybernetics Inc May 2020 - Present
    View
  • Barrick Gold Corporation
    Business Intelligence Consultant
    Barrick Gold Corporation May 2020 - Oct 2020
    Toronto, Ontario, Ca
    View
  • Warner Gaming
    Director Of Business Intelligence
    Warner Gaming Feb 2020 - Apr 2020
    Las Vegas, Nv, Us
    View
  • Eldorado Resorts, Inc.
    Senior Crm Analyst, Corporate Business Intelligence
    Eldorado Resorts, Inc. Jun 2019 - Feb 2020
    Reno, Nevada, Us
    View
  • Sierra-Cedar
    It Consultant - Etl And Reporting
    Sierra-Cedar Feb 2016 - Apr 2019
    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
    View
  • Morgan Fabrics Corporation
    It Project Manager
    Morgan Fabrics Corporation Sep 2014 - Mar 2015
    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
  • Igate
    Project Lead/L2 Support Manager - Mgm Resorts International
    Igate Aug 2013 - Apr 2014
    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
    View
  • Red Rock Financial Services
    Project Manager
    Red Rock Financial Services Jul 2011 - Jun 2013
    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
  • Genzyme Genetics
    Sqa Consultant
    Genzyme Genetics Oct 2007 - Dec 2010
    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
    View
  • Claims Servicing Of America
    Enterprise Architecture Manager
    Claims Servicing Of America 2005 - 2007
    Management of software development for medical collections on C#/.NET on a MS SQL Server 2005 database running on Windows 2000/2003.
  • Hands On, Inc.
    Project Manager
    Hands On, Inc. 2004 - 2005
  • Fongs Garden Restaurant / Bar
    Business Manager
    Fongs Garden Restaurant / Bar 2002 - 2005
    overall management of family business in Las Vegas
  • Stradcom Corporation
    Overall Program Manager
    Stradcom Corporation 1998 - 2001
    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.
    View
  • Bayan Telecommunications Corporation
    Asst. Vice President
    Bayan Telecommunications Corporation 1995 - 1997
    Quezon City, Ph
    Management of Software Development and Systems Integration using Oracle in a Unix environment.
    View
  • Sara Lee D.E.
    Regional Is Manager (Asean)
    Sara Lee D.E. 1993 - 1996
    Regional Software Development using Progress 4GL on Progress SQL and IS/IT Coordination in the South East Asian region.
  • Roche Pharmaceuticals
    Is Manager
    Roche Pharmaceuticals 1988 - 1993
    Switzerland 🇨🇭 , Ch
    Software development for Accounting / MRP II / Distribution / TMS on 4GL/SQL in a Unix environment
    View
  • Universal Reinsurance Corporation
    Mis Specialist
    Universal Reinsurance Corporation 1984 - 1988

Carlos G Skills

Team Building Jad Sql Server Consulting Planning Specifications Release Management Test Automation Suppliers Waterfall Ice Printing System Integration Infrastructure Insurance Family Business Vendors Misys Sales System Implementations Jira Novell Manufacturing Resource Planning Change Control Mentoring Progress 4gl Laserfiche Analysts Eis Product Life Cycle Utilities Protocol Pbx Geac Excel Pivot Data Center Management Healthcare Information Technology Sme Management Information Systems Facilitation Custom Software Development Frame Relay Database Modeling Database Triggers Replication Databases Release Engineering Requirements Gathering Technical Services Management Network Management Design Version Management General Ledger Aprimo Organizational Leadership Contractors Fish Shell Db2 Odbc Integration Version Control Mysql System Architecture Programmers Database Administration Routing Leadership Auditing Information Systems Use Case Requirements Analysis Sharepoint Accounting Vip Sdlc Hp Blade Reservations People Management Data Center Asp Networking 4gl Troubleshooting Telecommunications Crystal Reports Document Imaging Education Expense Budgeting Utilization Project Cost Map Tcp/ip Microcomputers Engineering Template Developers Oracle Sql Budgeting Enterprise Architecture Operations Management Online Backup Emr Testing Asset Management Oracle Designer Training Disaster Recovery Bookkeeping Enterprise Software Sla Ms Project Baan Data Center Operations Software Quality Assurance Business Management Documentation Project Management High Availability Reporting Accounts Payable Erp Implementations Software Project Management Custom Software Payroll Automation It Management Billing Systems Hardware Provisioning Systems Analysis Laboratory Information Technology .net Notification Etl Soapui Sap User Training Rfp Retail Management System Backbone.js Voip Spectrum Rehabilitation Logistics Data Analysis Business Analysis Collaboration Tools Negotiation Resource Management Laboratory Equipment Stored Procedures Erp Quality Assurance Design Specifications Decision Support Presentation Operations Casino Triage Data Architecture Subject Matter Experts Repository Maintenance Government Agencies Marketing Estimates Advantx Change Management Network Administration Document Management Timelines Business Intelligence Quickbooks Business Process Improvement Software Engineering Sql House Ssrs Ftp Training Programs Bar Database Design Fax Unix Data Migration Cleansing Servers Inventory Control Cloud Computing C# Accounts Receivable Presentations Confluence Log Analysis Mediation Packaging Architects Distribution Software Design Data Warehousing Internetworking Art Purchasing Contract Management Sybase Code Wire Cytogenetics Agile Project Management Pay Ssis Dba Resources Interfaces Microsoft Sql Server Reviews Government Investments Business Rules Collections Vendor Management Ontrack Commission Scrum Materials Software Financial Services Oracle Powershell Emc Test Scripts Java Program Management Test Cases Web Services Web Project Management Business Process Special Projects Interviews Telephony Financial Analysis Application Support Budgets Legacy Systems Optimization Remedy Software Development Mock Mrp Architecture Solution Architecture Deliveries Cots Dbms

Carlos G Education Details

  • University Of The East
    University Of The East
    Accounting Major
  • Aots
    Aots
    Software Development
  • University Of Santo Tomas
    University Of Santo Tomas
    Psychology
  • Angelicum High School
    Angelicum High School
    High School

Frequently Asked Questions about Carlos G

What company does Carlos G work for?

Carlos G works for Sierra Cybernetics Inc

What is Carlos G's role at the current company?

Carlos G's current role is Business Intelligence | Data Warehousing | ETL | Data Integration | SQL Development | Data Governance.

What is Carlos G's email address?

Carlos G's email address is cg****@****edia.es

What schools did Carlos G attend?

Carlos G attended University Of The East, Aots, University Of Santo Tomas, Angelicum High School.

What skills is Carlos G known for?

Carlos G has skills like Team Building, Jad, Sql Server, Consulting, Planning, Specifications, Release Management, Test Automation, Suppliers, Waterfall, Ice, Printing.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.