RICHARD S. ROSE
Saratoga Springs,UT
Summary
Professional, experienced, and ready to work. Skilled in team collaboration, adaptable to changing needs, and focused on achieving impactful results. Strong communication, organizational, and interpersonal skills, ensuring reliable support.
Overview
34
34
years of professional experience
Work History
Volunteer
Church Of Jesus Christ Of Latter Day Saints
07.2023 - Current
- Assisted with special events and programs.
- Maintained clean, neat, and operational facilities to serve program needs.
- Supported engaging, fun, and smooth-running events by helping with organization and planning.
- Used strong interpersonal communication skills to convey information to others.
- Communicated with staff members to stay informed about volunteer opportunities and events.
- Represented organization positively and professionally while providing community with much-needed services.
- Mentored new volunteers, fostering a supportive and inclusive team environment.
Assoc. Sr Data Engieer
FamilySearch.org
10.2015 - 02.2019
- Provided SQL support for Pre-Publications Operations (PPO) group in Family History Department
- Used existing tools to clean and transform data into more searchable format for FamilySearch web application users
- Designed and implemented bulk loading of XML formatted data into PPO ORACLE llgR2 transformation data mart
- Designed and implemented process to scan Data Shuttles from Imaging group and produce XML format content files for 3rd Party Partner organizations
ETL Consultant
ConsultNet
08.2014 - 09.2014
- Provided client on-site and remote consulting for major Insurance company extracting and loading large amounts of data from ORACLE into Netezza
- Worked in linux writing shell scripts as part of automated process to extract and transform data into a common structure defined by the client and used across the insurance industry
Professional Services Post-Sales Consultant
TERADATA
04.2011 - 06.2014
- Company Overview: US Americas
- Provided client on-site consulting at assignments from 1 - 9 months throughout US, using time-proven data migration solutions for clients in Finance, Insurance, Telecom, Manufacturing, Healthcare, and Retail industries with databases ranging from 100s Gb to 4 Pb in size
- Expanded existing Teradata Datamover system for global financial client by migrating 5650 / 6650 EDW to dual passive Unity Datamover 6700 system, utilizing SVN, managing changes in Datamover Perl scripts developed with Eclipse, EPIC and Active Perl
- Streamlined TPT development process for medium retail client by working with client IT lead designer, documenting complex approach, bringing new data sources into Teradata database, nesting PERL scripts based on existing staging tables, creating TPT scripts, loading all preformatted or converted data into required format, scheduling using CRON
- Enriched system procedures as ETL Consultant for large insurance client by partnering with client analysts and testers in AGILE development environment, modifying CRM stored procedures, ensuring all code version controlled, using SVN, synchronizing stored procedures in multiple development environments with production Data Mart
- Regenerated BTEQ scripts for 83% of tables by migrating Business Objects Reporting data IS Mart from ORACLE to Teradata EDW, using BTEQ ETL scripts and table driven methodology, converting ORACLE stored procedure to table driven SQL for calculating open claim lengths, tracking PDM Table/Column and Index changes daily, identifying subsequent re-work
- Remediated long running DML steps for large communications client by partnering with DBAs and CMEU Presale SR Consultant, using PDCR, analyzing existing production ETL process, making recommendations, reviewing overall ETL architecture and design, investigating opportunities, updating processes and using new features available in TD 13.10
- Amended TPT, BTEQ load and control scripts for Americas CDS by holding regular meetings with offshore counterparts, coordinating development efforts, testing unit load scripts with mocked up correlated data, analyzing complete load process, executing performance test on 100K record data file, extrapolating production load, creating run book for ACDS ETL load process
- Enhanced system performance by gathering statistics and Stage to Core processing, synchronizing PDMs across environments, creating Performance Testing Database via dynamic SQL, applying and defining masking rules to de-personalized sensitive information, creating external stored procedure, executing Business Objects whenever SAS users needed to extract > 50K rows
- Cloned and modified common Informatica Jobs as ETL Developer for large communications client by using Push-Down optimization for migrating Regional Data Marts to EDW, downloading and using Teradata Mapping Manager, loading Stage to Core mappings extracted from Erwin into TMM repository for Denver based Data Management group
- Improved system performance for regional retail outlet by using Dynamic SQL, creating, and executing scripts for production tables with no Partition Defined Indexes, analyzing potential use of TSET, replicating index and table statistics from production EDW to development environment
- US Americas
Sr. Systems Analyst, Data Warehouse Architect, Programmer
GLAXOSMITHKLINE
04.1995 - 12.2010
- Company Overview: US PHARMA IT
- Participated as technical lead, subject matter expert, and lead ETL developer during 500 Tb ORACLE 10g to Teradata v.2.6/v.12 OLAP database migration 2007 - 2010
- Earned Gold Impact Award for outstanding performance and significant contribution towards Sales Force Flexibility Program by reducing overall processing cycle time 60% and decreasing runtime of 400 Gb SP&P Parser from 11 days to 14 hours
- Streamlined ETL process from 4 days to 4 hours by creating highly flexible parameter driven program, parsing over 100K reports extracted from Teradata into 8K individual data files, thereby ensuring program usability for future not-yet-dreamed-of data
- Resolved issue in 12 hours of detection by diagnosing, designing, testing, and implementing ETL solution with territory aggregation program not identified during ORACLE 9i conversion
- Achieved 50% cycle time improvement with 1-week development to production timeframe by reusing standardized PL / SQL code, decreasing cycle time from 44 hours to 20 hours, allowing multiple re-runs without affecting full production schedule, providing full restart ability from any failure point, preventing future degradation by freezing execution path with ORACLE Outlines
- US PHARMA IT
Sys. Analyst, Database and UNIX Administrator
NORTHERN TELECOM
06.1993 - 07.1995
Senior Programmer / Engineer
JOHNS HOPKINS UNIVERSITY
10.1990 - 06.1993
- Company Overview: School of Medicine
Education
Bachelor of Science - Computer Engineering
Skills
- Teamwork and collaboration
- Organized and efficient
- Problem-solving
- Attention to detail
- Adaptability and dependability
- Computer skills
- Flexible schedule
- Customer service
Languages
Finnish
Limited Working
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Preference
Work Type
Part TimeFull TimeWork Location
HybridRemoteOn-SiteImportant To Me
Work-life balanceTimeline
Volunteer - Church Of Jesus Christ Of Latter Day Saints
07.2023 - Current
Assoc. Sr Data Engieer - FamilySearch.org
10.2015 - 02.2019
ETL Consultant - ConsultNet
08.2014 - 09.2014
Professional Services Post-Sales Consultant - TERADATA
04.2011 - 06.2014
Sr. Systems Analyst, Data Warehouse Architect, Programmer - GLAXOSMITHKLINE
04.1995 - 12.2010
Sys. Analyst, Database and UNIX Administrator - NORTHERN TELECOM
06.1993 - 07.1995
Senior Programmer / Engineer - JOHNS HOPKINS UNIVERSITY
10.1990 - 06.1993
Brigham Young University - Bachelor of Science, Computer Engineering
Similar Profiles
Vulori BalenaveikauVulori Balenaveikau
Volunteer Music Teacher at Church (The Church of Jesus Christ of Latter Day Saints)Volunteer Music Teacher at Church (The Church of Jesus Christ of Latter Day Saints)
Muirin FousheeMuirin Foushee
Missionary at The Church Of Jesus Christ Of Latter Day SaintsMissionary at The Church Of Jesus Christ Of Latter Day Saints
Kimberly ClaypoolKimberly Claypool
Substitute Teacher at Church Of Jesus Christ Of Latter Day SaintsSubstitute Teacher at Church Of Jesus Christ Of Latter Day Saints
Connor BelknapConnor Belknap
Volunteer at Church Of Jesus Christ Of Latter Day SaintsVolunteer at Church Of Jesus Christ Of Latter Day Saints
Lennox JacobsonLennox Jacobson
Operations Supervisor and Job Coach at Deseret IndustriesOperations Supervisor and Job Coach at Deseret Industries