Experience

• 

  Veterans Health Administration

  • Program Analyst

    • Jun 2019 - Present

    Data analyst and developer utilizing SAS and SQL to wrangle medical records data and present insights to researchers. Solely provided data analysis and named co-author for veteran substance abuse disorder and treatment research article. Currently researching opioid use disorder and treatments; proposed new time period for definition of continuous treatment which are now being used in overall analsis.

• 

  West Virginia University

  • Morgantown, WV

  • Data Analyst

    • May 2019 - Jun 2019
    • Morgantown, WV

    Provided SAS reviews for epidemiology research into VA overdose and suicide event historical analysis.

• 

  KELLY OCG

  • United States

  • Senior Data Analyst

    • Oct 2017 - Feb 2019
    • United States

    Contractor to John Deere Financial ...Increased business insights by demonstrating dashboards to business leaders, discussing potential value added functionality and iteratively incorporating feedback into functional requirements.Identified areas of potential revenue improvement and cost management through business analytics.Facilitated quick delivery of incremental business insights by planning, designing and implementing data architecture change from a traditional data mart to a federated architecture.Developed complex sql extracting data from multiple data warehouses for Tableau and developed datamapping documents for etl processes.Positively impacted business data quality through data profiling for business to correct operational data.Worked remotely, influencing business leaders and delivering impactful results.

• 

  John Deere Financial

  • United States
  • Machinery Manufacturing
  • 700 & Above Employee

  • Manager, Data Warehouse Development / Systems Architecture / Data Management

    • Dec 2008 - Jun 2016

    While leading several teams and departments, I acted as the strategic data architect. I reviewed most major design enhancements related to expansion of the data warehouse environment and central customer databases to ensure alignment with original strategies and conformance to the data modeling principles.I managed a team of Informatica ETL developers, data analysts/modelers, testers and a project manager to move data from various source systems into our integrated operational data store, data warehouse and data mart environment. We were also responsible for Deere Financial’s centralized customer database environment for which I either created or assisted data designing and modeling.As a working manager, I managed a team of senior technology architects responsible for establishing architecture strategies and aligning projects with them. I personally provided direction on IT data architecture strategies and worked with data analysts/modelers across all projects to ensure data models align with subject area strategies and balanced long term business flexibility with technical difficulty in maintaining and using data.Provided leadership to a team of 11 data analysts/modelers. This team was responsible for the design of data structures within all developed systems and data consistency across all systems to facilitate improved efficiency in gaining information insights in managing business processes. Based on my many years of data modeling experience, I coached the team in data modeling to transform the team from theoretical focused design approaches to business value and flexibility approaches.

  • Data Architect / Data Warehouse Technical Lead / Senior Data Analyst

    • Feb 1999 - Dec 2008

    I began as the data analyst on the first data warehouse project. Using PowerDesigner, I designed and modeled the operational data store (ODS), data warehouse and data mart databases. The ODS consolidated data for various financial credit products; the data warehouse kept history; and the data mart invoked a star schema design to maximize query efficiency. I utilized the appropriate data design techniques in each data store for its purpose within the data architecture. I also wrote may of the data movement specifications for ETL. In support of designing the data mart appropriately, I communicated with the business users in understanding their reporting requirements. As a result of my leadership, I became responsible for the entire architecture and business requirements gathering. At a critical juncture, I convinced senior IT management of the benefits of an infrastructure containing the ODS. I provided the visionary work from which this effort established the view of customer across all credit products and became the key IT architecture piece allowing the company to become a customer focused organization.As I took on additional responsibilities, I personally developed information integration strategy that defined the strategic approach for managing data subjects to maximize business efficiency. The strategy was approved by IT leadership and used by business leaders in planning conversations.

• 

  Wells Fargo Home Mortgage

  • West Des Moines, IA

  • Senior Data Analyst

    • Mar 1997 - Feb 1999
    • West Des Moines, IA

    I conducted data analysis, logical data modeling in ERWin, and physical database design for a project bringing together client contract management from all mortgage business lines. I proactively worked to facilitate proper data integration between projects, designed overall user interface and assisted project manager in planning many project tasks. I received 5 nominations for service excellence and won two quarterly service awards for support of this project.

• 

  Consolidated Natural Gas Transmission Corp

  • Clarksburg, WV

  • IT Analyst

    • Jun 1988 - Mar 1997
    • Clarksburg, WV