RICHARD S. ROSE

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

years of professional experience

Work History

Volunteer

Church Of Jesus Christ Of Latter Day Saints

Saratoga Springs, UT

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

Salt Lake City

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

Salt Lake City

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

US

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

Durham, US

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

Durham, US

06.1993 - 07.1995

Senior Programmer / Engineer

JOHNS HOPKINS UNIVERSITY

Baltimore, US

10.1990 - 06.1993

Company Overview: School of Medicine

Education

Bachelor of Science - Computer Engineering

Brigham Young University, Provo, UT

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 Time

Location Preference

HybridRemoteOn-Site

Important To Me

Work-life balance

Timeline

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