SUMMARY

• Data warehouse system architect with experience as a data warehouse and business intelligence project manager. Expert in conceptualizing and developing complex databases and data warehousing systems in diverse environments. Extensive experience with Oracle, MS SQL Server, IBM Cognos, Talend Data Integration Studio, and ERwin.

PROFESSIONAL EXPERIENCE

Confidential, Shady Grove, Pennsylvania

Staff Engineer / Data Warehouse Architect

• Implemented business intelligence program as part of Joint Technology Innovation Center. Result: Saved $150,000 in new license fees and $30,000 in annual maintenance fees. Reduced risk for both companies without adding additional personnel.
• Integrated IoT, warranty, and manufacturing data as Project Manager for ETL project with external data from National Oceanic and Atmospheric Administration (NOAA), and Google. Result: Made corrections to programming to allow for inaccuracies created by weather factors and documented environmental factors for root cause analysis.
• Partnered with team to develop remote diagnostic, predictive analytics program which integrated and analyzed operational telematics data with external data sources.
• Created location analytics models combining IoT data with text data using IBM SPSS Modeler. Result: Provided actionable information to engineering, support managers, dealers, and customers.
• Developed unique system to monitor telematics data for prototype equipment testing. Result: Saved $200,000 by discovering errors that were fixed before production began.
• Implemented data governance program, including data lineage, data quality, and master data management. Result: Reduced time to diagnose data errors and apply correction. Improved data quality enabled more accurate data analytics of IoT data.
• Created data modeling program using ERwin. Model types included 3rd Normal Form, DW 2.0 Data Warehouse, Data Vault, and Star Schema. Result: Reduced time for new application development while increasing data quality.
• Managed project for 3TB data warehouse implementation supporting remote diagnostics and warranty analyses. Result: Enabled accurate maintenance scheduling and new system design compliance. Reduced development time of future data mart deployments by 50%. Reduced operational costs and provided predictive maintenance information.
• Programmed multi - tier IoT application providing customers with operational information. Result: Produced accurate machine data to aid in tracking and planning of equipment.
• Designed CraneSTAR telematics SQL Server database. Result: Amassed an extensive database of field information to produce CraneSTAR telematics system.

Confidential, Shippensburg, Pennsylvania

IT Consultant

• Developed 2TB data warehousing system using Oracle and SQL Server providing comprehensive stock trading histories for U.S. and global exchanges. Result: Created daily financial data for customers replacing quickly-outdated monthly updates. Added international exchanges to expand customer base.
• Designed and developed custom application, connecting trading systems with financial exchanges to provide real-time business intelligence and trade execution.
• Created stock analysis tool linked to Oracle database back-end providing historical performance data. Result: Saved time and reduced data entry error enabling client to develop and test trading strategies using more data sources. Allowed client to expand research by integrating data for fundamental and technical analysis in a single platform.
• Concepted and developed GUI-based application using C++ that provided user-defined filtering tools for trade data. Result: Eliminated losses based on bad data since client filtered data in real-time and suspected bad data was not providing false trading signals.
• Constructed unique email tracking and compliance system designed for conformance to CAN-SPAM Act of 2003. Integrated data from client campaign management system, customer service system, and order fulfillment system. Result: Complied with all national regulations avoiding fines and complaints from FTC.
• Developed application to calculate insurance premiums linked to Oracle database. Transmitted insurance application from independent agencies to insurance company. Result: Eliminated need to mail paper application and reduced time to process policy. Rate changes automatically applied to agent workstations, eliminating errors based on out-of-date calculations.
• Conceived and built insurance policy payment ACH processing system in Delphi and Oracle. Result: Reduced collection time and errors in payment processing because payments were not being processed manually.
• Designed and developed application for quoting policy premium finance. Result: Allowed independent insurance agents to create premium finance agreements in office. Changes were automatically applied eliminating inaccurate applications based on old data.
• Created application to automate driving record and credit score ordering data collection. Result: Provided independent insurance agents with accurate real-time data, reducing errors in underwriting reducing manual input.