Customer Service Sales

BRENDAN J. MONAGHAN

* ***** ****** ( Concord, New Hampshire 03301 603-***-**** (

*********@*****.***

TECHNICAL SKILLS

Data Analysis ( Continuous Process Improvement ( Project Management (

Automation Processes

Trend Analysis ( Business Intelligence ( Finance Reporting Model ( Global

Implementations

Quest Analytics( Access Databases ( Cognos, SQL & Oracle ( Crystal

Reporting ( Visual Basic ( OLAP ( MS SSIS/BIDS

PROFESSIONAL EXPERIENCE

Cheshire Medical Center, Keene, New Hampshire ( 2009 to Present

Report Developer/Business Analyst, Finance Department

. Utilize OLAP cubes to provide in depth analysis on financial results for

specific departments

. Experience in Importing/Exporting Data from various data sources such as

Excel, Oracle, DB2 and Flat file

. Experience in writing/editing VB scripts to automate an SQL/Access

reporting application

. Create ad-hoc SQL queries to mine data from DB2 database.

. Collaborate with department leads to develop financial data into useful

reporting and trending to analyze performance

. Responsible for all aspects of data benchmarking tool, Solucient, which

includes data entry integrity, input deadlines, interpreting and

analyzing reports, and assisting leadership in utilizing reports

. Cultivate relationships with department leads and senior leadership to

gain understanding of individual organizational operations to create

reports and recommendations to meet the department needs.

PEP-DIRECT, Wilton, New Hampshire ( 2009

Data Analyst, Alexander Technology Group Consultant

. Provide consulting services to streamline and stabilize company finance

reporting model.

. Serve as key member of team assisting purchase and implementation of

large global reporting package.

. Develop project plan to stabilize current processes and implement new

products.

. Manage and control project costs while collaborating with multiple

managers leading different aspects of project.

WRR ENTERPRISES, L.L.C., Rochester, New Hampshire ( 2009

Access Developer, Alexander Technology Group Consultant

. Teamed with company ownership to design Access database for data storage

on SQL server as well as forms/reports to client specifications.

. Automated Access database creating a click button process to deliver

client invoices.

. Designed queries to support invoice reporting and calculations

COMCAST COMMUNICATIONS, Chelmsford, Massachusetts ( 2004 to 2009

Senior Business Intelligence Analyst/Business Intelligence Supervisor

. Originated automated reporting structure through Access Database and

trained all analysts on proper and efficient use.

. Experience in generating on-demand and automated reports for business

analysis or management decision using Cognos, Access, and SQL.

. Creating an automated reporting structure through Access Database and

training all analysts on its proper and efficient use.

. Created an ETL process to combine data from Excel, SQL and Access to

produce daily, weekly and monthly dashboards.

. Built VB scripts to mine data from oracle database for daily reports.

. Managed day-to-day actions of 4-person regional team of reporting

analysts and 3 sales/retention analysts.

. Devised fresh Sales Rewards model to maximize sales culture in service

function.

FIDELITY INVESTMENTS, Merrimack, New Hampshire ( 1998 to 2004

Operations Analyst I&II

. Created an ETL process to load data from flat files to an Access

database. Designed dimension style queries to deliver daily, weekly,

and monthly performance dashboards to all levels of the call center

organization

. Delivered timely and accurate key performance reporting indices for

assigned functional group.

. Developed ad-hoc reports for varies levels of management using Crystal,

Brio, Access, and Excel.

. Collaborated with functional management team to provide performance

reports for staff reviews and scheduling.

. Built an Excel database utilizing VBA to monitor customer service

representative performance.

. Trained analyst team on the technical functions of Excel and Access

databases created

EDUCATION:

Bachelor of Science, Business Management, Granite State College, Concord,

New Hampshire / Associate of Science, Business Management, New Hampshire

Technical Institute, Concord, New Hampshire

Contact this candidate