Karen Roraff

Data Governance Analyst, Lead at Dycom Industries, Inc
  • Claim this Profile
Contact Information
Location
Jupiter, Florida, United States, US

Topline Score

Bio

Generated by
Topline AI

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content. Click here to join now

Experience

    • United States
    • Telecommunications
    • 300 - 400 Employee
    • Data Governance Analyst, Lead
      • Mar 2016 - Present

      • Responsible for building and implementing new data governance program. • Design, build and implement KPI dashboards and scorecards to monitor data quality. • Provide technical leadership to company’s data standardization initiatives. • Provide data analysis and support for implementation of new payroll system (UltiPro). • Provide analytics for legal, including geospatial data analysis. • Develop HR and recruiting data analytics. Notable achievements: Establish Data… Show more • Responsible for building and implementing new data governance program. • Design, build and implement KPI dashboards and scorecards to monitor data quality. • Provide technical leadership to company’s data standardization initiatives. • Provide data analysis and support for implementation of new payroll system (UltiPro). • Provide analytics for legal, including geospatial data analysis. • Develop HR and recruiting data analytics. Notable achievements: Establish Data Governance Framework for the company, including subject area on-boarding processes, Data Quality Dashboards, Data Governance Data Steward Training, and Executive Review Presentations. Using: Power BI, SQL, NoSQL (MongoDB), MySQL, Postgres Show less • Responsible for building and implementing new data governance program. • Design, build and implement KPI dashboards and scorecards to monitor data quality. • Provide technical leadership to company’s data standardization initiatives. • Provide data analysis and support for implementation of new payroll system (UltiPro). • Provide analytics for legal, including geospatial data analysis. • Develop HR and recruiting data analytics. Notable achievements: Establish Data… Show more • Responsible for building and implementing new data governance program. • Design, build and implement KPI dashboards and scorecards to monitor data quality. • Provide technical leadership to company’s data standardization initiatives. • Provide data analysis and support for implementation of new payroll system (UltiPro). • Provide analytics for legal, including geospatial data analysis. • Develop HR and recruiting data analytics. Notable achievements: Establish Data Governance Framework for the company, including subject area on-boarding processes, Data Quality Dashboards, Data Governance Data Steward Training, and Executive Review Presentations. Using: Power BI, SQL, NoSQL (MongoDB), MySQL, Postgres Show less

    • United States
    • 1 - 100 Employee
    • SQL Developer/Analyst
      • Apr 2007 - 2016

      Manager, Data Services SQL Developer / Analyst Production Manager Strong analytical abilities, leadership and partnership with business to select solutions, design, build, manage the development, integration and implementations of targeted marketing systems. Work with business to… Show more Manager, Data Services SQL Developer / Analyst Production Manager Strong analytical abilities, leadership and partnership with business to select solutions, design, build, manage the development, integration and implementations of targeted marketing systems. Work with business to identify key business metrics and develop the data warehousing capabilities to report on these metrics. Work with business units to select software and implement solutions to automate and streamline processes. Lead both SQL development teams and production teams. Responsible for the production and delivery of over 1 million emails daily. Notable achievements:  Marketing Stack and SAAS software integration and implementation to provide business with significant cost reduction and provide opportunity for revenue growth. MS Dynamics CRM systems and Marketing systems (MS SQL 2008/2012, Postgre SQL, Sparkpost, Iterable, Segment, Woopra, .NET webservices)  Sourced, transformed and loaded data from multiple resources to build data warehouse and data marts using Excel, MS SQL,, SSRS, SSIS.  Provide key business analytics and metrics ( examples: Profitability, Customer Retention, Sales Funnels) using MS SQL, SSRS, SSIS  Streamlined and automated business processes in marketing, production and accounting department (Marketing Stack, HTML/PHP web page development, WordPress, Sage)  Provide support and direction to business for leveraging CRM systems and Marketing systems (MS SQL 2008/2012, Postgre SQL, MS Dynamic CRM, Sparkpost, Iterable, Segment, Woopra, .NET webservices) Show less Manager, Data Services SQL Developer / Analyst Production Manager Strong analytical abilities, leadership and partnership with business to select solutions, design, build, manage the development, integration and implementations of targeted marketing systems. Work with business to… Show more Manager, Data Services SQL Developer / Analyst Production Manager Strong analytical abilities, leadership and partnership with business to select solutions, design, build, manage the development, integration and implementations of targeted marketing systems. Work with business to identify key business metrics and develop the data warehousing capabilities to report on these metrics. Work with business units to select software and implement solutions to automate and streamline processes. Lead both SQL development teams and production teams. Responsible for the production and delivery of over 1 million emails daily. Notable achievements:  Marketing Stack and SAAS software integration and implementation to provide business with significant cost reduction and provide opportunity for revenue growth. MS Dynamics CRM systems and Marketing systems (MS SQL 2008/2012, Postgre SQL, Sparkpost, Iterable, Segment, Woopra, .NET webservices)  Sourced, transformed and loaded data from multiple resources to build data warehouse and data marts using Excel, MS SQL,, SSRS, SSIS.  Provide key business analytics and metrics ( examples: Profitability, Customer Retention, Sales Funnels) using MS SQL, SSRS, SSIS  Streamlined and automated business processes in marketing, production and accounting department (Marketing Stack, HTML/PHP web page development, WordPress, Sage)  Provide support and direction to business for leveraging CRM systems and Marketing systems (MS SQL 2008/2012, Postgre SQL, MS Dynamic CRM, Sparkpost, Iterable, Segment, Woopra, .NET webservices) Show less

    • IT Project Manager
      • Jul 2005 - Apr 2007

      Major Accomplishments Managed the development of the IT projects for on-line retail company including: directing the development of ASP/SQL web site, interfacing with affiliates, enhancing distribution systems. Hands-on to provide project management, database design, analysis while leading a team of 4 outsourced developers, 3 marketing analysts and graphic designer resources. Developed customer specific marketing systems and managed execution of marketing plan. Worked with business… Show more Major Accomplishments Managed the development of the IT projects for on-line retail company including: directing the development of ASP/SQL web site, interfacing with affiliates, enhancing distribution systems. Hands-on to provide project management, database design, analysis while leading a team of 4 outsourced developers, 3 marketing analysts and graphic designer resources. Developed customer specific marketing systems and managed execution of marketing plan. Worked with business owners to determine enterprise system requirements and reporting tools to improve productivity and manage ROI. Karen Roraff Show less Major Accomplishments Managed the development of the IT projects for on-line retail company including: directing the development of ASP/SQL web site, interfacing with affiliates, enhancing distribution systems. Hands-on to provide project management, database design, analysis while leading a team of 4 outsourced developers, 3 marketing analysts and graphic designer resources. Developed customer specific marketing systems and managed execution of marketing plan. Worked with business… Show more Major Accomplishments Managed the development of the IT projects for on-line retail company including: directing the development of ASP/SQL web site, interfacing with affiliates, enhancing distribution systems. Hands-on to provide project management, database design, analysis while leading a team of 4 outsourced developers, 3 marketing analysts and graphic designer resources. Developed customer specific marketing systems and managed execution of marketing plan. Worked with business owners to determine enterprise system requirements and reporting tools to improve productivity and manage ROI. Karen Roraff Show less

    • United States
    • Accounting
    • 1 - 100 Employee
    • Contractor
      • Dec 2004 - Jul 2005

      Converted system from native AS/400 to DB2 database and .NET architecture Enhanced the functionality of and modernized a payroll processing system Converted system from native AS/400 to DB2 database and .NET architecture Enhanced the functionality of and modernized a payroll processing system

    • France
    • Retail Office Equipment
    • IT Applications Development Manager
      • Jan 1995 - Nov 2004

      Major Accomplishments Sales Force Automation: led the development, integration and rollout out of CRM system to large sales force. Customized purchased software to fit the existing sales processes and to provide data and tools to help achieve business goals by working closely with sales executive team. Contract Management System: managed the development of a browser-based system to effectively manage contracts, provide margin analysis and other sales related information.… Show more Major Accomplishments Sales Force Automation: led the development, integration and rollout out of CRM system to large sales force. Customized purchased software to fit the existing sales processes and to provide data and tools to help achieve business goals by working closely with sales executive team. Contract Management System: managed the development of a browser-based system to effectively manage contracts, provide margin analysis and other sales related information. Profitability: managed the development of a customer based profitability system with P&L report card metrics, calculations derived from several legacy systems and delivered to a simple, intuitive browser based system. Managed a team of IT developers responsible for the design, development and implementation of CRM related systems for large office supply retailer. Provided project management for the development and support for the operational customer databases used by order entry and marketing systems: design, development, integration, implementation and on-going support. Responsible for coordinating with and collaborating on projects across both IT and business organizations including senior management and PMO. Provided project management for the sales planning tools for a large contract sales force and 300,000 external (B2B) customers. Part of a small team that provided the technical leadership on IT systems for international retail start ups including POS, distribution and order entry software. Enhanced order entry systems per specific country requirements such as invoicing or tax. Provided on-site installation, documentation and user training before after and during start-ups. Countries supported; Warehousing Systems: Provided IT support of purchased software, added enhancements for both operations and stability to the software package, and provided on-site conversion from legacy systems to Office Depot systems during two year acquisition. Show less Major Accomplishments Sales Force Automation: led the development, integration and rollout out of CRM system to large sales force. Customized purchased software to fit the existing sales processes and to provide data and tools to help achieve business goals by working closely with sales executive team. Contract Management System: managed the development of a browser-based system to effectively manage contracts, provide margin analysis and other sales related information.… Show more Major Accomplishments Sales Force Automation: led the development, integration and rollout out of CRM system to large sales force. Customized purchased software to fit the existing sales processes and to provide data and tools to help achieve business goals by working closely with sales executive team. Contract Management System: managed the development of a browser-based system to effectively manage contracts, provide margin analysis and other sales related information. Profitability: managed the development of a customer based profitability system with P&L report card metrics, calculations derived from several legacy systems and delivered to a simple, intuitive browser based system. Managed a team of IT developers responsible for the design, development and implementation of CRM related systems for large office supply retailer. Provided project management for the development and support for the operational customer databases used by order entry and marketing systems: design, development, integration, implementation and on-going support. Responsible for coordinating with and collaborating on projects across both IT and business organizations including senior management and PMO. Provided project management for the sales planning tools for a large contract sales force and 300,000 external (B2B) customers. Part of a small team that provided the technical leadership on IT systems for international retail start ups including POS, distribution and order entry software. Enhanced order entry systems per specific country requirements such as invoicing or tax. Provided on-site installation, documentation and user training before after and during start-ups. Countries supported; Warehousing Systems: Provided IT support of purchased software, added enhancements for both operations and stability to the software package, and provided on-site conversion from legacy systems to Office Depot systems during two year acquisition. Show less

Education

  • University of Illinois Urbana-Champaign
    B.S, Computer Science and Math

Community

You need to have a working account to view this content. Click here to join now