Ernesto Chavez
El Paso,Texas
Summary
Database Administrator and Accounts analyst with experience in SQL and Oracle databases general maintenance tasks and the migrations of Oracle databases to a SQL Server environment. Also, maintained credit card accounts, direct deposit accounts, and automated clearing house billing accounts on a mainframe platform and client server platform.
Overview
22
22
years of professional experience
Work History
Staff Technologist
Booz Allen Hamilton Inc.
11.2021 - 04.2024
- Maintained a variety of DEA SQL Server databases and DEA Oracle 11g instances
- Assisted Developers with migrations from Oracle database schemas to SQL Server 2017 platforms
- This included the conversions of database objects and data using SSMA and SSIS migration tools
- This effort was a cost reduction project
- Migrated SQL databases from SQL server 2012 to 2016 as version upgrades requested by management.
Database Administrator
OLH Technical Services LLC
11.2020 - 11.2021
- Maintained a variety of DEA SQL Server databases and DEA Oracle 11g instances
- Assisted Developers with migrations from Oracle database schemas to SQL Server 2017 platforms
- This included the conversions of database objects and data using SSMA and SSIS migration tools
- This effort was a cost reduction project
- Migrated SQL databases from SQL server 2012 to 2016 as version upgrades requested by management.
Programmer Analyst
TCS E-SERVE INTERNATIONAL
04.2018 - 11.2019
- Decreased mainframe production cycle run costs by eliminating obsolete processes no longer providing value to the company
- Removed obsolete processes from X-billing to Sequence Number Swap from Business Partner Interface processes and reduced the number of jobs not needing to run by 10%
- Using Visio, Excel, and Word, I documented Business Partner Interface (BPI) main environments for future enhancements to the current administration system.
Int Programmer Analyst
Transamerica Life Insurance Co.
04.2012 - 04.2018
- Collaborated and completed the largest conversion effort by the company, a mainframe insurance administration system into a server base insurance administration system
- This five-year effort took countless hours, involving a multitude of analysts, programmers, and business area experts to complete the massive project on time and on cost
- In the end this effort saved the company hundreds of thousands in mainframe usage costs
- Converted file transmission methods between business partners and our company
- Working with the business partners, file transmissions were updated to Secure Connect Direct, increasing transmission speed and security.
IT Analyst II
AEGON DIRECT MARKETING SERVICES INC
04.2002 - 03.2012
- Set up new business partner processes for a variety of company partners to exchange files to maintain customer data within our administration systems
- Delivered projects and tasks within cost and schedule tolerance and improved company bottom line by estimating project costs and effort within the company proposed target levels
- Maintained ASP/HTML web pages and Informatica maps for loading UNIX oracle tables.
Education
Bachelor of Business Administration - Computer Information Systems
The University of Texas at El Paso
El Paso, TexasAssociates of Applied Science - Data Processing/Computer Programming
El Paso Community College
El Paso, TexasSkills
- Agile
- Scrum
- SDLC
- Waterfall
- SSMS
- SSMA
- SQL Developer
- SSIS
- COBOL
- DB2
- JCL
- Informatica
- SQL
- HTML
- SFTP connections
Professional Development
LOMA Professional Designations: ACS Associate, Customer Service, ALMI Associate, Life Management Institute, FLMI Fellow, Life Management Institute
Timeline
Staff Technologist
Booz Allen Hamilton Inc.
11.2021 - 04.2024
Database Administrator
OLH Technical Services LLC
11.2020 - 11.2021
Programmer Analyst
TCS E-SERVE INTERNATIONAL
04.2018 - 11.2019
Int Programmer Analyst
Transamerica Life Insurance Co.
04.2012 - 04.2018
IT Analyst II
AEGON DIRECT MARKETING SERVICES INC
04.2002 - 03.2012
Bachelor of Business Administration - Computer Information Systems
The University of Texas at El Paso
Associates of Applied Science - Data Processing/Computer Programming
El Paso Community College
Similar Profiles
Randy BrownRandy Brown
Physical and Personnel Specialist at Booz Allen HamiltonPhysical and Personnel Specialist at Booz Allen Hamilton
Kimberly GrayKimberly Gray
Senior Executive Administrative Assistant at Booz Allen HamiltonSenior Executive Administrative Assistant at Booz Allen Hamilton
DIANA CUMMINSDIANA CUMMINS
Health Communications and Marketing Lead at BOOZ ALLEN HAMILTON, INC.Health Communications and Marketing Lead at BOOZ ALLEN HAMILTON, INC.
Charles ProctorCharles Proctor
Logistics Analyst / Project Manager at Booz Allen HamiltonLogistics Analyst / Project Manager at Booz Allen Hamilton
Francisco ZamoraFrancisco Zamora
Journeyman Diesel Mechanic at Liquid GoldJourneyman Diesel Mechanic at Liquid Gold