Data Migration Engineer
Resume:
Richard D. Garza
McAllen, TX
*******@*****.***
PROFESSIONAL PROFILE
oOver 20 years of experience in the Information Technology Industry working in various industries including Health Care, Financial Services, Retail, Entertainment and State & Local Government.
oProvided Onsite Client Consulting and Support Services.
oRelational Database Administration on Oracle/ SQL Server/ Informix Platforms
oDeveloped/Maintained OLAP Cube and Reporting Platform
oETL Development for OLAP and OLTP Databases
oApplication Development & Testing using Full Systems Life Cycle Methodology and maintenance in mainframe, client/server environments and N-Tier Environments
oMentored colleagues and provided cross training of technical staff.
TECHNICAL SUMMARY
Certifications: Oracle Certified Professional: Database Administration Oracle 8
Other OCP Exams Passed: Develop PL/SQL Programming Units
Tools & Languages: DataStage 8.7, Tableau, Visual Studio, VB.NET, SSRS, SSIS, SSAS, VISIO,
PL/SQL, Crystal Reports, Cognos 10.2, SQL Developer /Data Modeler, ERwin Data
Modeler, Oracle Forms & Reports Builder, SQL, XML, SQL*PLUS, JavaScript,
COBOL II, Natural, TFS, PVCS Version Manager
Database: Netezza, SQL Server 2022, Oracle 19/11g / 8.1.7.x, Informix 10.x, ADABAS
Operating Systems: Windows 2016 Server, Red Hat Linux, Sun Solaris, HP-UX, MVS-TSO
PROFESSIONAL EXPERIENCE
Senior ETL/Data Migration Engineer – VA EHRM Project Take2 IT Vienna, VA November 2021 – Current
oETL Developer with Veteran Admin Electronic Health Record Modernization Project.
oDevelop and Maintain Power BI ETL Dashboard which tracks/monitors various ETL jobs and metrics.
oResponsible for SSIS package Creation/Modification as new tables are introduced from Cerner(Oracle Health) Team
oWork with Data Syndication Team to Maintain Various Database Ingestion jobs Across Prod/Test/Dev Environments using SSIS.
oIntroduce New Tables/Views into various Reporting Environments.
oDevelop/Maintain Cerner Test Case Reporting Project which automates testing process to compare Database Integrity between Production and Syndicated Databases.
Database Administrator/ ETL Developer -Datalogic Inc. Harlingen, TX September 2020 - October 2021
oResponsible for Data Migration for Legacy Product into latest Web Schema(Vesta EVV) Using variety of Tools including SSIS and SQL Stored Procs.
oMigrate Oracle Backend Processes to SQL Server.
oProvide client Database Support:
oProduction Support Issues
oDatabase backups / archiving / Always On - HADR
oTransactional Replication
oPerformance Tuning
oAzure AZCopy to Blob storage
Senior BI Developer – Doctor’s Hospital Renaissance Edinburg, TX July 2015 – February 2017
oResponsible for Data Warehouse Development on IBM Netezza platform for various Data Sources including but not limited to Clinical, Accounting & HR systems.
oETL Development to populate Star Schema Databases w/ Type I,II SCD using DataStage 8.7
oDevelop / Maintain SSIS packages as required for reporting
oCreate Various Dashboards using Tableau 9.2
oReport Development with Cognos 10.2 and Framework Manager, Crystal Reports and SSRS
Database Administrator/ ETL Developer –CUC: TechShare Austin, TX Feb 2017 – Jan 2020
Jul 2014 – June 2015
oResponsible for Data Conversion from client Legacy Systems into Texas Court Case Management
OLTP Database utilizing both ETL SQL scripts and SSIS Toolkit.
oMaintain SSIS Conversion Toolkit and assist with SSIS Development as it relates to different versions of Case Management System
oUnit/System Test Data Conversion
oMaintain DEV/ACPT/QA DB Environments
oProvide client Database Support:
oProduction Support Issues
oDatabase backups / archiving / Always On - HADR
oTransactional Replication
oPerformance Tuning
oCreate/Maintain SSRS Reports, Stored Procedures & Views
oPerform Database Upgrades
oPerform 24x7 Support as needed
Database Administrator/ ETL Developer AMCAD LLC San Antonio, TX March 2012 – June 2014
oResponsible for Data Conversion from client Legacy Systems into Amcad Case Management
OLTP Database utilizing both ETL sql scripts and SSIS Toolkit.
oMaintain SSIS Conversion Toolkit and assist with SSIS Development as it relates to different versions of Case Management System
oUnit/ System Test Converted Data
oProvide onsite client Database Support:
oProduction Support Issues
oDatabase backups / restore
oTransactional Replication
oPerformance Tuning, Partitioning and Archiving, Failover Cluster
oCreate/Maintain SSRS Reports, Stored Procedures & Views
oPerform Database and Application Upgrades
oPerform onsite client training/mentoring of DBA staff as necessary
oPerform 24x7 Support as needed
Database Administrator / BI Developer IDEA PUBLIC SCHOOLS Weslaco, TX July 2009 - July2011
oMaintain Reporting Platform built on Microsoft Tech-Stack to track Student/Teacher Progress.
Platform is Based on Sharepoint,/ Sql-Server 2008 R2/ SSRS/SSIS/SSAS.
oCreate / Maintain Interfaces from Student Management System to Sharepoint Platform
oCreate Maintain Database Objects for Reporting Platform with Oracle, Sql Server, SSAS
oCreate SSAS Cube from Star Schema Database
oCreate and Deploy SSRS Reports to Sharepoint Reporting Platform
oSystem Administration for Pearson School Systems’ POWERSCHOOL Student Mgmnt System Enterprise Software. Student Information System reside on Windows Servers with Oracle 11g database
oPerform Database Backups.
oPerform Database/Application Upgrades
oMaintain User Security
oCreate Reports with iReports(Jaspersoft) and SSRS
oCreate/maintain interfaces with peripheral software that receives data from SMS nightly.
oCreate/maintain sql / stored procedures in support of Student Systems
oCreate audit reports to assist with data integrity for historical grades and PEIMS
oCreate Data extracts including but not limited to SRI, Civil Rights Data Survey, Public Information Requests, Assessment & Performance Management programs.
MIS/PEIMS Coordinator – Los Fresnos CISD Los Fresnos, TX March 2007 – 2009
oSystem Administration for Sungard Pentamation’s FINANCE / STUDENT PLUS series Enterprise Software. Finance/HR /Student Information Systems reside on Linux Servers with Informix IDS as backend.
oPerform Database Backups.
oMaintain Backup Strategy with SAN
oCreate Reports from FINANCE/STUDENT Dbase with COGNOS Impromptu
oCreate/maintain scripts for creating Active Directory users.
oCreate/maintain sql / stored procedures in support of Finance/Student Systems
oResponsible for coordinating and directing all PEIMS related issues within the district. Supervise 2 PEIMS specialists and 11PEIMS clerks.
oSupport/Maintain GradeSpeed.NET
oIn Cooperation with Others, drive Overall Technology Direction for the District including but not limited to: Technology Purchases regarding hardware/software development tools/database storage solutions/ educational software
Programmer/Systems Analyst – Region One Education Service Center November 2002 – March 2007
oResponsible for maintaining / modifying Internal Applications within the Service Center written in ASP.NET and Java.
oResponsible for Administration of SQL Server 2005 which is the back end for internal applications
oDeveloped a Reporting Tool in ASP for ESC’s that accepts a Regional PEIMS file and displays various metrics for the Special Ed Population.
oConvert reports written in Java PDFLIB API to Crystal Reports
oPerform Requirements analysis with different user groups of Staff Development Application to determine where new functionality is needed.
oDesigned and developed a stand-alone application that integrates seamlessly with current Staff Development Application in order to facilitate On-Site/On-Line Workshop Registrations
oResponsible for Desegregation of Data from Various Sources but not limited too – TAKS / PEIMS / SDAA / RPTE / TAAS
oMaintain Salary Survey / Tech Survey / Tech Assessment Survey applications and perform modifications as necessary
Software Engineer – PerformanceRetail Austin, TX November 2001 – November 2002
oCreate / Modify PL/SQL programs according to Specifications designed by Business Analyst for Retek RMS (Retail Management System) and RDW (Retek Data Warehouse).
oCreate / Modify iViews for TopTier (SAP) Portal.
oAssist with Configuration of Oracle Discover/OAS to provide ad-hoc reporting functionality
oPerform Unit and System Testing for server-side batch PL/SQL programs written
for RMS and RDW.
oPerform Code translation of Oracle Forms/Reports Client-Side PL/SQL to server-side
stored procedures.
oMaintain Testing Database Environment.
Technical Support Analyst - Oracle Corporation Colorado Springs, CO February 1999 - July 2001
Technical Support Analyst - Application Object Library
oAssist Applications DBA with technical issues regarding the installation and
upgrade to Oracle Financial Applications Release 11i/11.0.3.
oTroubleshoot technical issues regarding the initial configuration and setup of Oracle Applications Release 11i/11.0.3.
oAssist customers in the database upgrade process for clients on earlier releases of Oracle Applications.
oResolve technical issues regarding the application of product patches.
oAssist customers with utilization of the various AOL utilities such as ADPATCH, ADADMIN, ADAIMGR.
oContributed technical bulletins to global knowledge database explaining in detail the resolution of unique errors.
oInstalled Oracle Applications 11i/11.0.3 on Sun Solaris and Windows NT platform.
Technical Support Analyst - Fixed Assets/ General Ledger Modules
oResponsible for diagnosis and resolution of technical issues for customers using Oracle
Assets and General Ledger Modules – Including Utilities and Energy Extensions
oAssist Customers and Oracle consultants with issues regarding setup and configuration
of modules during implementations and conversions
oDeveloped scripts to assist in the data conversion process using SQL*Loader and PL/SQL.
oPresented Bugs to Development Team after identifying bug and preparing test cases.
oAnalyses of bugs include data corruption at table level, program logic on server side
PL/SQL, PRO*C and program logic in Report SQL and Forms PL/SQL
oMethods of resolution include examination of forms and database traces, duplication of code bugs and preparation of SQL and PL/SQL diagnostic scripts.
oCoordinated testing for remediation of program logic.
oDeveloped SQL and PL/SQL Data fixes for corrupted data in tables.
oContributed technical bulletins to global knowledge database explaining the resolution of errors.
oCompleted training in Oracle Developer/2000, Oracle 8.0 Server, SQL, PL/SQL
oCompleted training in 11i ERP Financial Suite
EDUCATION
University of Miami Coral Gables, FL
Master of Science Computer Information Systems, May 1996
Creighton University Omaha, NE
BSBA Accounting / Finance December 1993
The University of Texas Austin, TX
Graduate Taxation Program, 1994-1995
Contact this candidate