Susan Crawforth Email & Phone Number

Kansas City, Missouri Area

Design and develop ETL jobs using Pentaho and Diyotta.Maintain 200+ ETL designs and jobs.Process over 10 million rows of customer data monthly into Health Lumen’s multi-tenant analytic platform.Support a Teradata data warehouse containing over 700 million rows of data.Rearchitect and redesign current processes for performance and scalability.Standardize processes and procedures to standardize customer data loads.Transform current processes from traditional ETL processes to higher performing ELT architecture yielding up 50x improvements in some jobs.Technical team lead for conversion from ETL platform Pentaho to Diyotta.Analyze, troubleshoot and fix customer data issues.

ETL development using SAP Buisness Objects Data Services Data Integrator.Design/maintain 25+ ETL jobs from multiple sources such as Oracle, SQL Server, excel and text files.Provide oncall support for ETL jobs.Responsible for 10+ reporting datamart databases.SQL query development for views, stored procedures, and data troubleshooting.Database design using Embarcadero ER/Studio.Database creation and modifictions.Database backup, restore, archive and purge.

Provide tier 2 and on call support for transportation management software.Work with software developers to fix software bugs and do software enhancements.Write SQL scripts to extract data for end users, troubleshoot software issues, and to fix data problems.Update and maintain the software overview document.Test software fixes and enhancements before released to production.Work with developers and end users to gather requirements for bug fixes and software enhancements.Write scoping documents based on end users need for software enhancements.Setup new customer configurations and users on our transportation management software.Work with customers to establish and trouble shoot data integration between their internal systems and our transportation management software.Lead production support meetings and prioritize production support issues with the software developers.Administrator for Team Track issue management software.

Evaluate and respond to requests from users experiencing problems with hardware, software, networking, and other computer related technologies. Assist with high severity issues to ensure timely notification of customers and support personnel. Work with users to resolve wireless remote access issues.Log and track user's request for assistance in problem management system.Troubleshoot hardware and various software issues including Microsoft products, mainframe, and many proprietary applications.

Install SQL Server 2000, Great Plains Dynamics, and Accunet software.Train customers on use of Dynamics and Accunet software.Troubleshoot software problems and work with software engineers to solve problems.Provide help desk support for 10 companies on use and problems with the software.Convert Pervasive data to SQL 2000 data.

First line of support for PC help desk for 67 users.Upgraded all PCs to Windows 2000 and set up new users on the network.Assist in the planning and migrating network servers to Windows 2000.Troubleshoot and fix hardware problems.Create and maintain financial reports using Hyperion Retrieve and Enterprise accounting software.

Performed monthly journal entries and assisted with the monthly closing.Reconciled 15 corporate bank accounts and general ledger accounts.

Bachelor Of Science Telecommunications Management, Information Technology

Bachelor Of Science, Business Administration-Finance

Associate Of Applied Science, Business Administration Management