Jennifer T. Email & Phone Number

London, Gb

• Provide business intelligence related services across multiple Epic modules to Epic business clients including new report and dashboard development, maintenance, troubleshooting, performance tuning, and client team mentorship; utilizing PL/SQL Developer for Oracle to access Epic Clarity database, Crystal Reports, Reporting Workbench, Radar, RW SQL, SQL Metrics, and Caboodle• Perform analysis, design, development, and validation of Epic-based reports, data extracts, and Radar dashboards in cooperation with key stakeholders to ensure that information is accurate and presented in the most effective way• Train stakeholders on how to effectively access, analyze, and interpret reports and dashboard metrics• Perform peer review of client reporting team’s build

Atlanta, Georgia, Us

• Developed and maintained Epic business intelligence (BI) reporting code, stored procedures, and views across a broad spectrum of Epic modules; utilized SQL server management studio and PL/SQL Developer for Oracle to access Epic Clarity database• Reported on various databases and sources using in house data warehouse to extract information for utilization in visual tools• Analyzed business workflows and translated company needs into technical requirements• Monitored projects throughout lifecycle and safeguarded accuracy from inception to rollout with end-users• Produced first drafts and validated each step down to final product• Created, scheduled, and rendered visually rich and intuitive data insights by utilizing SQL server reporting services and QlikView• Determined business intelligence solutions, such as dashboards and scorecards, by performing data and systems analysis; prepared competitive research on other hospitals in the health system

Brentwood, Tennessee, Us

• Translated business needs into technical code• Created ad hoc data queries using SQL Studio and Epic Clarity database• Designed and delivered business intelligence applications using Qlikview• Ensured reported output is accurate and matches user requirements• Communicated with and trained super users on business intelligence solutions

Marietta, Georgia, Us

• Responsible for the overall success of reporting and for coordinating reporting tasks across all applications• Coordinated the project team’s reporting analysis and validation process• Managed report development efforts• Determined reporting process workflows and implement them across the organization• Measured ongoing success of reporting after go-live and make necessary adjustments• Assisted reporting team with Clarity and Reporting Workbench reports and Radar dashboard creation, issues, and questions• Conducted Reporting Workbench training for project team and end users• Completed setup of Epic-Crystal integration processes including server processes, BOE scheduling, Hyperspace template configuration, and report creation• Serveed as liaison between leadership and project team regarding reporting matters• Led and mentored team of 9 Clarity report writers and 21 Reporting Application Coordinators• Created reports from Clarity 2012 database based on user specifications using Crystal Reports and SQL across different modules

Marietta, Georgia, Us

• Provided advanced system-level support of multi-user operating systems, hardware, and software tools, including installation, configuration, training, maintenance, and support of the following systems: Canopy, Datawatch ES/Monarch BI Enterprise Server, Monarch, Glucotec, Horizon Business Insight (HBI), and Mednet• Assisted in project management related tasks related to upgrades, update, maintenance, and installs• Researched specifications and plans, coordinated efforts, and led users through implementation including testing, training, and quality assurance• Assisted in development/modification of QlikView dashboards• Mentor and lead for the Enterprise Analytics team• Managed the successful implementation and move of an extremely difficult in-house system (Canopy) to an ASP model

Marietta, Georgia, Us

• Provided intermediate system-level support of multi-user operating systems, hardware, and software tools, which included installation, configuration, training, maintenance, and support of the following systems: Canopy, Datawatch ES/Monarch BI Enterprise Server, Monarch, Glucotec, Horizon Business Insight (HBI), and Mednet• Maintained existing Crystal Reports and diagnosed issues• Instituted a method using UNIX and scheduled tasks to correct a system issue that had been ongoing for many years• Developed, documented, and maintained problem resolution procedures and user processes• Collaborated with user departments to identify needs and gather requirements for system enhancements and reporting• Led monthly technical meetings between IT and business departments to gather requirements for projects/implementations and address technical issues

Marietta, Georgia, Us

• Maintained Human Resources Metrics databases using SQL Server 2005, Query Analyzer, Access, and Excel• Analyzed HR data using Access and Excel to identify emerging trends and communicated key insights to management on a monthly and quarterly basis• Designed and developed corporate scorecards• Managed the ePRISM survey application including survey data gathering and survey participation

Atlanta, Ga, Us

• Managed and administered all aspects of the SmartStream HR/Payroll system which included troubleshooting system support issues, software upgrades and updates, and yearend system testing• Conducted yearend processing by creating and modifying stored procedures using RapidSQL• Collaborated with user departments to identify needs and gather requirements for system enhancements• Developed customizations within the SmartStream application by modifying scripts and stored procedures on the backend using RapidSQL• Conducted thorough evaluation and testing of enhancements and upgrades• Provided end user support• Developed, documented, and maintained problem resolution procedures

Atlanta, Ga, Us

• Processed new hires, stock options, and 401k to be sent to external vendors using SQL scripts, MS Access, and UNIX• Performed testing for yearend programs, processes, and procedures• Performed testing for software upgrades• Audited employee information processed by SmartStream HR system for quality and integrity• Compiled statistical information and prepared reports relating to Payroll, Recruiting, Compensation, and EEOC by utilizing SmartStream Query and Crystal Reports 8.5• Developed standard and ad hoc reports for clients by utilizing SmartStream Query, Crystal Reports 8.5, and RapidSQL• Enhanced the current testing documentation by updating the testing procedures as well as adding testing procedures for new functionalities• Maintained and supported the Support Magic incident management application as well as the online manager reports• Created intranet accounts for new hires• Assisted with web development projects as needed which included design and testing

• Compiled and distributed statistical information regarding the various functional HR areas including required federal and state reporting by utilizing SmartStream Query• Developed standard and ad hoc reports for users by utilizing SmartStream Query• Researched and resolved issues related to SmartStream Query• Maintained company organization charts within SmartStream HR system• Created and updated training manuals and provided training on SmartStream HR system• Received, logged, and resolved helpdesk issues from users• Gathered information on the most common help desk issues and resolutions and devised a help desk support manual for help desk employees to use in diagnosing issues

Atlanta, Ga, Us

• Developed standard and ad hoc reports for managers and executives by utilizing ADP/ HR Profile, ReportSmith, and Excel• Compiled and distributed statistical information regarding the various functional HR areas including required federal and state reporting by utilizing ADP ReportSmith and Excel• Audited employee information processed by ADP/HR Payroll system for quality and integrity• Coordinated the content and design of the corporate Human Resources intranet site• Enrolled new hires in company benefits program and entered all employee information into ADP/HR Payroll system• Partnered with HR managers/generalists to create retention planning initiatives• Resolved benefits, pay, and other employee related issues including assisting employees in filing claims and benefit elections• Assisted in the new hire process while ensuring compliance with company policies• Maintained employment records and the processing of all changes in personnel status• Administered various HR plans and procedures for all company personnel and assisted in the development and implementation of personnel policies and procedures• Participated in developing departmental goals and objectives• Assisted in implementing and coordinating HR programs and projects approved by management• Maintained company organization charts and employee directory