Karen Miller

Experience

• 

  Contract

  Jan 2000 - Mar 2012

  MS Access Developer

  Experienced contractor with a strong background in developing and optimizing databases across various industries, including construction, marketing, IT, insurance, and more. Expertise in Access database creation, reporting, process automation, and data analysis to improve efficiency and support business objectives.Key Achievements Database Development & Process Improvement: Designed and implemented custom Access databases for tracking company contacts, project inventory, sales data, and employee information, ensuring smooth operations and reporting. Contract Management & Data Conversion: Created processes for managing contract bids, change orders, and converting Excel data to streamlined systems for improved workflow and accuracy. Sales & Marketing Reports: Worked with marketing teams to design Cube reports, created advanced Excel reports from the Sales Cube, and improved sales reporting processes. Performance Tracking & BI Integration: Reviewed and optimized performance tracking tools and sales databases, and documented processes for integrating sales data into BI systems. Workflow Automation & Reporting: Automated data transfer processes with SQL DTS packages, improved reporting efficiency, and streamlined communication with stakeholders by automating email report generation. Data Analysis & Custom Reporting: Enhanced data analysis tools, created custom reports, and tracked key metrics, leading to more actionable insights and better decision-making. Collaboration & User Support: Worked closely with internal teams to understand needs, provide real-time support, and develop solutions that improved data access and usability across departments. Client & Project Management: Assisted clients in improving daily processes, provided custom reports, and maintained data integrity through careful analysis and data validation. Show less

• 

  Comcast

  May 2012 - Apr 2017

  NED Division Finance - Sr. Analyst

  Experienced database and reporting specialist with expertise in managing large-scale promotional reporting and ensuring data accuracy for residential and business services.Key Achievements: Promo Roll-off Reporting: Managed Promo Roll-off Report for Residential (8.5M customers) & Business Services, ensuring accurate tracking of promotional codes and eligibility. Database Optimization: Updated and optimized Promo Roll-off Access Database, significantly improving processing speed and efficiency. Cross-System Mapping & Data Management: Mapped promotional codes across two billing systems, ensuring accurate tracking of rates, cycles, and eligibility, and provided data mapping to Minerva for other departments. Reporting & Collaboration: Provided comprehensive Campaign reports to MIS and Finance departments in user-friendly formats and partnered with MIS/CSG teams to update customer discount tracking codes. Data Accuracy & Auditing: Worked with conversion teams to audit promotional specifications and with EBI to reconcile the PRO database with current promo processes to ensure accuracy. Pre-Conversion Reporting: Delivered Frankenbundle reporting to regions for account clean-up prior to conversion and processed weekly files for BTV and RSN tax-exempt status.Proven ability to handle complex reporting tasks, collaborate with cross-functional teams, and maintain accurate, actionable data in fast-paced environments. Show less

• 

  Fidelity Investments

  Jan 2018 - Nov 2018

  Business Systems Analyst - Fund Reporting - Contractor

  Skilled database developer with expertise in updating and optimizing Access database structures, creating automated processes, and improving reporting features to support business needs.Key Achievements Database Structure & Process Optimization: Updated Access database to store funds, classes, documents, and related data, streamlining data management and access. Custom Development & Automation: Created forms and processes using VBA, T-SQL, and DAO record sets to enhance functionality and automation. Process Duplication & Validation: Developed processes in Access to replicate functions from external systems, including creating a True-Up Validation Process that replaced outdated document validation, improving efficiency and data accuracy. Reporting & Data Management: Built a centralized reporting feature to query and export data efficiently, meeting users' reporting needs and saving time. User Training & Documentation: Documented user processes and provided training to ensure effective utilization of the database and its functions.Adept at translating user requirements into efficient, scalable database solutions that enhance productivity and improve data integrity. Show less

• 

  Comcast Business

  Jun 2019 - now

  Experienced, results-oriented leader, data analyst, and reporting specialist with expertise in creating visualizations, analyzing complex data, and delivering actionable insights to drive business growth.Key Achievements: Interdepartmental Collaboration: Established and hosts recurring CB Data Series meeting to foster collaboration among regional and divisional analysts, aligning on logic, strategies, and upcoming business changes. Enterprise Sales: Engage with Enterprise Sales, Operations and Base Growth & Strategy Teams to develop detailed customer reporting using Orion billing and Singleview/Salesforce data, providing Account Owner level details for MetroE circuits. Reports include balance of accounts per rep title, contract status and revenue growth. Database Management: Developed and maintains marketing, sales, and finance data sources to support teams in tracking and understanding business performance. User Acceptance Testing: Assists Marketing and HQ teams by conducting user testing on corporate-led datasets: CDP (Customer Data Platform), SDM (Sales Data Mart), FDM (Finance Data Mart) and UC (Universal Customer), ensuring accuracy and alignment with divisional business goals. Team Leadership: Led a team of Marketing Data Analysts, providing key metrics and insights to drive sales and business growth. Mentorship & Career Development: Conducted regular one-on-one meetings with analysts to enhance their understanding of business operations, data structures, and advanced querying techniques. Talent Acquisition Spearheaded the recruitment process: Selected and onboarded analysts with the skills and qualities best suited to the team’s needs and organizational goalsProven ability to leverage data tools and reporting systems to deliver actionable insights and support strategic decision-making across teams. Show less  Field Sales: Partners with Field Sales Team to develop Scorecard metrics, enabling supervisors to track rep Opportunity and Sales performance and identify trends to support sales budget and goal initiatives. Outbound Telemarketing: Integrates business, firmographic, models, and product related data to create targeted lists for Outbound Telemarketing for customers and prospects. Manages Outbound call data to track dials, contacts, lead conversions, opportunities, and orders, providing insights into business trends. Product Management: Works closely with Product Management to track Small Business Bundle offers and promotions with Sales data, including orders, customers, sales channel, products, and MRC. Rate Event Strategy: Develops and assists with implementing rate event cohorts to support targeted marketing strategies, segmenting customers based on products, MRC, and bill increase aimed at maximizing revenue, improving retention, and reducing churn. Tableau Visualization & Reporting: Designs parameter-driven Tableau dashboards for interactive, self-serve reporting to support executive decision-making. Show less

  • NED CB Marketing - Manager, Data Engineering

    Feb 2022 - now

  • NED CB Marketing - BI Data Analyst/Engineer

    Mar 2021 - Feb 2022

  • NED CB Marketing - Marketing Analyst

    Jun 2019 - Mar 2021