Dana Horan Email & Phone Number

Plain City, Oh, Us

United States

Columbus, Ohio Area

Dublin, Oh

Derived data source capabilities from multiple business applications using data mining association, path analysis, and clarification. Translated business functional specifications into meaningful data analysis for architectural review, data modeling, and profiling. Applied advanced knowledge of data mining in an enterprise-wide project to provide client quality reporting and received a recognition award as subject matter expert (SME) within this data integration project.• Produced gap analysis and visual interpretations for impact on required decisions and directives.• Identified the required integration points and inter-dependencies across various data sources, objects and attributes to make the data usable for analysis, mapping and modeling. • Analyzed source system data to fulfill requirements for data integration, quality, and business reporting.• Generated data output findings and technical data source documentation for lead data architect, data governance, and global support development.• Collaborated with internal business to ensure data and reporting requirements were aligned and accurately reflected business needs.ACHIEVEMENT HIGHLIGHTS• Identified integration points and inter-dependencies across 24 diverse data sources with over 1,000,000 rows of combined data and 1,000-plus objects profiled and reviewed to render data usable for analysis, mapping, and modeling.• Provided leadership team data analysis findings, resulting in a 15% scope reduction as part of an enterprise-wide project.• Validated complex relational data warehouse for accurate mapping of 300-plus diverse data quality exception rules.• Awarded recognition for support of user acceptance testing validation of over 100 integration tables using data modeling and mapping rules.• Profiled and analyzed over 200 tables across multiple source systems and platforms to fulfill requirements for enterprise data integration, data quality, and business reporting.

Columbus, Ohio Area

REPORTING BUSINESS ANALYST CONSULTANTPerformed requirements gathering, documentation, development, implementation, reporting, and analysis of Service and Operations metrics. Reviewed/analyzed information, methods, schedules, systems, processes, and procedures to perform tasks relating to design, continuous improvement, and trend reporting proof of concepts. Successfully translated reporting business needs into solution requirements using elicitation and data analysis.• Conducted operations reporting reviews, and completed special assignments to ensure planning and coordination of requirements. • Led reporting business management requirements in partnership with process owners for metrics alignment on information management and workforce effectiveness. • Coordinated with senior managers to identify and resolve a variety of reporting and data analysis issues. • Compiled multiple data sources for analysis and reporting based on requirements gathering of business unit and company key performance indicators.• Maintained and developed data reconciliation and validation against established processes and ticketing systems for operational reporting requirements.ACHIEVEMENT HIGHLIGHTS• Planned, scheduled, and presented customized in-house training sessions to staff and clients. • Received recognition award for development of monthly workforce and metrics portfolio deliverable. • Developed understanding of 6 diverse internal department tools for data analysis and operational metrics requirements gathering and initiated reporting reviews within 30 days of hire. • Developed measures and methods to identify workforce productivity and forecast trends via calculation and analysis of data indicators. Discovered 80% of staff was not accurately submitting time, resulting in 100% turnaround in awareness for workforce effectiveness against project forecasting, employee availability, and actual time entry.

Dublin, Ohio

Translated reporting business requirements consisting of numerous service delivery towers (call center, help desk, desk side incidents, service requests, survey sourced information) through account transition setup to meet service level and operational goals. Managed 5-10 resources and development flow to successfully produce streamlined reporting solutions for over 12 projects ranging from $100K to $1M in services.• Planned, developed, and implemented cost-effective reporting solutions for collecting, compiling, and analyzing service data information to fulfill service level requirements. • Developed data coding and design for technical configuration based on requirements and processes received (SQL Where Clause, Excel Formulas–Database extracts of information).• Provided gap analysis within reporting deliverable, in and out of scope, to provide means and options for any customization and work effort as it pertained to best practice reporting applications.• Managed data reconciliation and validation against established processes for contractual and operational reporting requirements. ACHIEVEMENT HIGHLIGHTS• Created and delivered reporting project management activities, including defining, scheduling, budget, risk, change, opportunity, and resource management activities.• Performed complex analysis of reporting goals, objectives, and needs of the business environment and created complex functional and technical report specifications. • Developed reporting methodology to streamline processes, including process documentation, workbook documentation, data analysis, quality control, training documentation, account setup requirements, reporting practice project plan, and formal steady state hand-off to Project Management Office and Service Delivery.• Maintained budget 100% of the time pursuant to any gap requirements or add-on services.