Sterling Cale
Sacramento,USA
Summary
Senior Professional Application Designer with experience in data modeling, SQL Tuning, creating, testing, modifying, packages, procedures, and functions, designing ETL workflow, using SSIS to code designed workflow, designing enhancements and bug fixes based on analysis, coding enhancements and bug fixes using COBOL in a mainframe environment.
Overview
27
27
years of professional experience
Work History
Application Designer
Gainwell Technologies
11.2023 - Current
- Designed ETL workflow based on requirements.
- Coded ETL workflow based on design.
- Used SQL Server Integration Services (SSIS) tool to code ETL workflow.
- Wrote ANSI standard SQL to perform extraction of data and perform lookups as part of the transform process.
Professional DBA
Gainwell Technologies
10.2020 - 10.2023
- Performed estimates of projects for my team
- Reviewed designs requirements from development team
- Performed data modeling
- Performed export and import tasks
- Created and tested implementation scripts
- Received training in Delphix data masking tool
- Took coursework on PostgreSQL
- Revised view creation DDL to get it to function in PostgreSQL
- Performed SQL Tuning activities for reporting SQL
- Performed troubleshooting, enhancement, and maintenance activities for account data copying tool
- Performed troubleshooting and maintenance activities on Oracle packages used to synchronize data between our maintenance environment and production for our proprietary correspondence generation functionality
- Project estimates for App DBA Team
- Design review for App DBA Team
- Data Modeling
- Used Oracle database masking tool
Data Engineering II
DXC Technologies
04.2017 - 09.2020
- Performed export and import tasks
- Created and tested implementation scripts
- Performed troubleshooting, enhancement, and maintenance activities for account data copying tool
- Performed troubleshooting and maintenance activities on Oracle packages used to synchronize data between our maintenance environment and production for our proprietary correspondence generation functionality
- Project estimates for App DBA Team
- Design review for App DBA Team
- Data Modeling
Application DBA
HP Enterprise
11.2015 - 03.2017
- Performed export and import tasks
- Created and tested implementation scripts
- Performed troubleshooting, enhancement, and maintenance activities for account data copying tool
- Performed troubleshooting and maintenance activities on Oracle packages used to synchronize data between our maintenance environment and production for our proprietary correspondence generation functionality
- Project estimates for App DBA Team
- Design review for App DBA Team
- Data Modeling
Application DBA
HP
08.2008 - 10.2015
- Worked on TSQL statements for execution on SQL Server to load data into SQL Server databases
- Performed export and import tasks
- Created and tested implementation scripts
- Performed troubleshooting, enhancement, and maintenance activities for account data copying tool
- Performed troubleshooting and maintenance activities on Oracle packages used to synchronize data between our maintenance environment and production for our proprietary correspondence generation functionality
- Assisted in database creation
- Assisted in database migration activities for upgrade of account databases from Oracle 8i to Oracle 11g
- Implemented Enhancements to databases
- Data Modeling
- Create and test implementation scripts
- Coded enhancements/bug fixes
- Created design documents per process
- Reviewed Designs as required
- Tested enhancements/bug fixes
- Performed level 1 help desk duties including researching technical problems
Information Analyst
EDS
06.1998 - 08.2008
- Implemented enhancements to databases.
- Data modeling.
- Create and test implementation scripts.
- Coded enhancements and bug fixes.
- Created design documents per process.
- Reviewed designs as required.
- Tested enhancements and bug fixes.
- Performed level 1 help desk duties including researching technical problems.
- Worked in a mainframe environment.
- Coded using COBOL and JCL.
Education
BS - Business Administration (MIS Concentration)
California State University, Sacramento
Sacramento, CA05.1998
BS - AE
Auburn University
Auburn, AL06.1992
Skills
- Oracle RDBMS
- PL/SQL
- SQL (DML, DCL, and DDL)
- COBOL
- Mainframe
- JCL
- C
- UNIX Shell scripting
- TSQL
- SSIS
- ETL Workflow Design
Projectsandachievements
- Performed estimates of projects for my team.
- Reviewed designs requirements from development team.
- Performed data modeling.
- Performed export and import tasks.
- Created and tested implementation scripts.
- Received training in Delphix data masking tool.
- Took coursework on PostgreSQL.
- Revised view creation DDL to get it to function in PostgreSQL.
- Performed SQL Tuning activities for reporting SQL.
- Performed troubleshooting, enhancement, and maintenance activities for account data copying tool.
- Performed troubleshooting and maintenance activities on Oracle packages used to synchronize data between our maintenance environment and production for our proprietary correspondence generation functionality.
- Assisted in database creation.
- Assisted in database migration activities for upgrade of account databases from Oracle 8i to Oracle 11g.
- Implemented Enhancements to databases.
- Created design documents per process.
- Reviewed Designs as required.
- Tested enhancements/bug fixes.
- Performed level 1 help desk duties including researching technical problems.
Timeline
Application Designer
Gainwell Technologies
11.2023 - Current
Professional DBA
Gainwell Technologies
10.2020 - 10.2023
Data Engineering II
DXC Technologies
04.2017 - 09.2020
Application DBA
HP Enterprise
11.2015 - 03.2017
Application DBA
HP
08.2008 - 10.2015
Information Analyst
EDS
06.1998 - 08.2008
BS - AE
Auburn University
BS - Business Administration (MIS Concentration)
California State University, Sacramento
Similar Profiles
Donna NorrisDonna Norris
Senior Billing Analyst at Gainwell Technologies (Formerly Hewlett Packard and DXC Technologies)Senior Billing Analyst at Gainwell Technologies (Formerly Hewlett Packard and DXC Technologies)
Deanna ClarkeDeanna Clarke
Account Manager at Gainwell TechnologiesAccount Manager at Gainwell Technologies
Jori MundyJori Mundy
Account Delivery Leader at Gainwell TechnologiesAccount Delivery Leader at Gainwell Technologies