Keith Elliott
Marne,IA
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Expertise include troubleshooting problem code and designing robust solutions that require a minimum of maintenence.
Overview
38
38
years of professional experience
Work History
Lead ETL Developer
Osaic
01.2019 - 05.2024
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Evaluated new technologies for their feasibility in enhancing current processes or addressing business requirements.
- Supported various ad hoc requests from end-users by delivering accurate datasets as per their requirements.
- Collaborated with business intelligence staff to produce customized ETL solutions for specific goals.
- Designed integration tools to combine data from multiple, varied data sources such as Files to Database and JSON through RESTFUL API.
- Deployed scalable solutions capable of handling large volumes of data while maintaining high standards of reliability and performance.
- Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
- Contributed significantly towards meeting project deadlines by maintaining a keen focus on task prioritization.
- Mentored junior developers on best practices in ETL development, fostering a culture of continuous learning within the team.
ETL Developer
Securities America (Later OSAIC)
03.2012 - 12.2019
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Evaluated new technologies for their feasibility in enhancing current processes or addressing business requirements.
- Streamlined data flow between multiple systems through the creation of efficient ETL pipelines and APIs.
Unix System Administrator
Securities America (Later OSAIC)
11.2011 - 03.2012
- Optimized resource allocation through virtualization technologies such as VMware for more cost-effective server management.
- Improved data security by conducting regular audits and implementing necessary updates to maintain compliance standards.
- Maintained high availability of services by configuring load balancing and failover mechanisms across multiple servers.
- Provided Tier-2 support for escalated issues, troubleshooting complex problems in a timely manner to minimize disruption to users'' productivity.
- Increased efficiency through the automation of routine tasks using shell scripting and cron jobs.
- Provisioned new software and hardware for use, following established security policies.
- Ensured smooth transitions during server migrations by collaboratively working on comprehensive migration plans.
- Oversaw file system and storage upgrades while safeguarding data integrity and redundancy.
- Diagnosed and resolved hardware and software issues.
- Established proactive monitoring tools, enabling early detection of potential issues and allowing for timely remediation efforts.
SAP Basis Administrator
CommScope
01.2001 - 08.2011
- Drafted database reorganization strategies to reduce hardware and operational waste.
- Participated in designing, scaling and implementing databases created to customer specifications.
- Applied necessary support packs to SAP and Oracle products, maintaining up-to-date and secure software installations.
- Maintained a secure environment for sensitive information through diligent monitoring of access logs and timely resolution of any unauthorized activity alerts.
- Installed kernel upgrades per technical documentation guidelines, adhering to SAP's best practices.
- Participated in disaster recovery planning and testing, ensuring a robust contingency plan was always in place for critical SAP systems.
- Multitasked and managed multiple deliverables and projects concurrently and facilitated use of SAP for enterprise resource planning.
Senior Unix Administrator
Lucent Technologies
01.1992 - 01.2001
- Managed complex storage solutions, providing reliable data access and backup capabilities for business continuity purposes.
- Provided Tier III support for escalated issues, troubleshooting complex problems quickly to minimize disruptions to business operations.
- Streamlined software deployment processes by automating tasks and standardizing procedures across multiple platforms.
- Evaluated and recommended new technologies for adoption, ensuring that the organization stayed at the forefront of industry advancements.
- Mentored junior administrators in advanced Unix concepts, increasing overall team expertise and efficiency.
- Developed custom scripts to automate routine tasks, significantly reducing manual effort and human error rates.
COBOL Developer
AT&T
06.1986 - 01.1992
- Assisted in the successful migration of critical business processes from legacy systems to modernized platforms, utilizing extensive COBOL knowledge.
- Streamlined data processing tasks by automating manual procedures using well-structured COBOL programs.
- Increased data accuracy within key business processes through diligent validation checks within COBOL programs.
- Enhanced system efficiency by optimizing COBOL code and implementing necessary updates.
- Ensured seamless integration between systems by designing and implementing efficient interfaces using COBOL.
Education
Bachelor of Science - Computer Science
Iowa State University
Ames, IA05.1986
Skills
- Database Design
- Data Transformation
- Data Migration
- Data Cleansing
- SQL development
- SQL Programming
- Data Validation
- Data Mapping
- Data Quality Management
- API Integration
- Scripting Languages
- Performance Tuning
Finra Licensces
Current Finra Series 7, Series 24, Series 66 and Nebraska Health and Life Insurance
Timeline
Lead ETL Developer
Osaic
01.2019 - 05.2024
ETL Developer
Securities America (Later OSAIC)
03.2012 - 12.2019
Unix System Administrator
Securities America (Later OSAIC)
11.2011 - 03.2012
SAP Basis Administrator
CommScope
01.2001 - 08.2011
Senior Unix Administrator
Lucent Technologies
01.1992 - 01.2001
COBOL Developer
AT&T
06.1986 - 01.1992
Bachelor of Science - Computer Science
Iowa State University
Similar Profiles
LEANNA HELMERLEANNA HELMER
Director, Transition Ops Processing at OsaicDirector, Transition Ops Processing at Osaic
Adam FreitagAdam Freitag
Operations Specialist II at OsaicOperations Specialist II at Osaic
Hugh DanielsHugh Daniels
VP, Business Development - Large Enterprise at OsaicVP, Business Development - Large Enterprise at Osaic