Mary McCullar

South Euclid, Ohio

Home Phone 216-***-****

Cell Phone 216-***-****

Email: abiy3p@r.postjobfree.com

SUMMARY:

. Innovative IT professional with over ten years of progressive

expertise looking to use her analytical, communication and leadership

skills in a progressively challenging environment..

o Prior working knowledge in the following IT areas;

. Process engineering with over 8 years of experience.

. Data mapping experience as it relates to the project

process, or reporting needs.

. Experienced documentation specialist with over 6 years

direct Business Analyst experience

. Reporting: Compliance and statistical

. Mentoring and training of junior team members.

. Quality Assurance: Creation and maintenance of testing

data.

. Project Management: Resource planning, scheduling and risk

mitigation.

Accomplishments:

. Creation of enterprise wide release management process that increased

migration accuracy to over 95%.

. Established skills database for IT resources that resulted in

increased efficiency.

. Automated the procurement process using standardized workflow tools,

which resulted in improved turn time.

. Established code migration process that reduced the number of failed

migrations, and reduced downtime.

. Lead three successful IT governance implementations: Two Mercury ITG

implementations and One Clarity/Niku implementation.

. Led software selection team that saved over six million dollars by

replacing the following applications/tools; PVS, purchase order

application, travel and asset tracking.

. Gathered and submitted requirements to automate code deployment and

demand management processes for a fortune 500 company. These

requirements were used to build automated process workflows that

resulted in an increase in accountability as well as efficiency.

. Managed code releases and testing for a retail e-commerce website for

the number 3 office supplier in the marketplace.

. Facilitated user panels discussions to define user needs from Supply

Chain technology for a fortune 500 utility company, this feedback was

used to create requirements documents.

. Automated SAS batch job processing to create a monthly extract process

that was used in marketing analysis department This resulted in an 80%

decrease in request for ad-hoc reports.

Work Experience:

Brand Muscle

06/08 to present

Business Analyst

. Responsible for creation of Requirements gathering process to support

offshore development.

. Creation of metrics reports detailing resource usage, and total

development hours.

. Identified various tools to support company goal of becoming a

licensed software provider.

. Creation of templates to collect project data.

. Facilitate Requirement gathering meetings. Provide summary of all

meetings

. Create System requirements documents.

. Data mapping: Responsible for migration of previously collected data

in excel spreadsheets to access database. Designed input forms, and

reports.

. Created documentation database that is used to facilitate training of

new Business Analyst, also used to standardize requirement documents.

. Creation of metric dashboard reports - using Access database.

. Facilitate project prioritization meetings.

. Maintain updated project information.

. Build/establish release management report/schedule.

. Manage base system documentation such as implementation specification

documents.

. Creation of System Requirement Documents (Functional and Technical).

. Mentoring of junior analyst.

. Tool procurement: Responsible for researching and recommending outside

vendor applications that may be integrated with existing company

application. Additional perform the same function for the business

analyst group - research and recommend tools that support and enhance

the current development gathering and documenting process.

. Testing: Aid in the testing of newly developed projects. Provide base

line testing requirements.

Results Positive- Assigned to Accenture 12/07

to 06/08

IT Governance Analyst

. Responsible for all Support of government clients customizing

instances of HP PPM.

. Created requirement documents for government clients and obtain sign-

off.

. Conducted requirements sessions with lead stakeholders.

. Maintained all documentation for my clients.

. Obtained all sign off documents and approvals from clients on project

items

. Provided estimates to clients on their change request and projects.

. Created custom portlets, metric dashboards.

. Applied service packs/ perform upgrades as needed

. Started/Stopped of client instances as needed.

. Tested new customization

. Responsible for project management and leading meetings for current

and new clients

. For new government clients created project plans, managed plans and

resources.

. Designed, developed and executed test scripts

. Provided training to new hires.

. Addressed/resolved open helpdesk tickets.

Ohio Savings Bank

______________________________________________________10/06 - 12/07

Sr. Business Analyst

. Responsible for configuring Project, Portfolio, and Resource modules

within Clarity/Niku.

. Gathered and documented business requirements in relation to the

implementation of Project, Resource, Time tracking, and Portfolio

modules of clarity application.

. Researched all incident reports opened within Magic application

(incident reporting system) as they relate to Clarity.

. Provide after hour support for web based application.

. Managed the implementation of Clarity application: Estimates, Project

Charter, Scope documents, Project Risk, Change Request, and Issues.

. Created and maintained Sql queries used in Ad-hoc reporting.

. Provided testing for newly implemented changes.

. Created a resource skills, and availability tool, used in the

scheduling of projects and change request.

. Provide a metric dashboard of existing projects and programs for

senior level management.

. Implemented time tracking system that updated the actual project

hours.

. Provide training to the entire IT organization.

. Submitted and performed various types of system changes.

. Represented PMO office at change control meetings.

. Facilitated tool adoption by meeting with each team and incorporating

necessary systems to meet their needs.

. Team lead for all PMO tools - Managed four to five resources (PM,

Database Analyst, and System Administrator)

CDI Consulting: Placed at Cinergy Utilities

04/05 - 08/06

Lead Production Support Analyst (for Mercury ITGC)

. Created and revised business process documents, training documents and

templates for Business Process Design team using MS Word and Visio.

. Designed, developed, and implemented automated workflows (processes)

that utilized HP-PPM software.

. Facilitated JAD sessions that will streamlined existing information

technology department processes.

. Developed scripts for the helpdesk to assist with the opening and

resolution of user helpdesk tickets.

. Worked with multiple cross functional teams to define and implement

the integration for HP-PPM with other company software (ex., Remedy

and HP Openview)

. Provided monthly reports tracking system performance, identified

coding issues, and exception errors.

. Assisted Server operations in defining current outage alert procedures

using HP Openview.

. Provided training to new users and support personnel as needed.

. Performed application upgrade as prescribed by the vendor.

. Provided project management, development and testing (in conjunction

with user community and in-house programmers) to create automated

process flows that address auditing requirements.

. Provided first-level support to user and help desk communities.

. Owner of company knowledge database.

. Provided weekly reports to Dispatcher community.

KeyBank

12/04 - 04/05

Lead Business System Analyst (temp)

Responsibilities in this position are:

. Preformed data mapping of a DB2 database to produce monthly data

extracts.

. Created monthly production extracts that reduced the need for ad hoc

reports by 80 percent.

. Managed monthly batch job submissions used for tracking marketing

projections and reporting which met all SLA requirements every month.

. Created various SQL or SAS jobs to address end user ad hoc report

request.

. Migrated SAS jobs into production.

. Lead current end users group meetings, where we addresses any

outstanding business needs, new data request, or changes to the

existing procedures.

. Evaluated and prioritized all end user requests for feasibility and

business needs.

. Lead extract enhancement team capturing issues, gaps, key points,

deliverables and conclusions.

. Mediated any discrepancies that occurred during cross-functional team

discussions.

. For these sessions, I prepared an agenda and critical support

materials.

. Also created documentation to summarize session proceedings and

results: executive summary (high-level objectives and deliverables),

action items, issues log, agenda/minutes (from scribes

transcriptions), etc. using MS Word, Excel and Visio.

. Acted as a liaison between Data Governance team and end user.

. Responsible for incorporating Data Governance changes into the monthly

extract process by a given deliverable date.

. Responsible for scheduling ad hoc request based on resource

availability.

. Provided first-level support to user community.

Visium Resources Contracting Service (Placed at KeyBank)

4/04 -11/04

Mercury ITG consultant

Responsibilities in this position are:

. Facilitated IT cross-functional team sessions for an end-to-end design

review of IT Governance software, used the findings from these

sessions to develop an automated code deployment processes which

address the specific needs of various end user and corporate auditors.

. Developed business requirements for Automated Code Deployment projects

on the Development team of a bank-wide IT auditing project, defining

the impact on these areas.

. Created business process documents including process mapping Visio

flowcharts, Excel spreadsheets and PowerPoint presentations, and other

documentation as required by the project.

. Prepared information packages for key stakeholders, and communicated

with them and business unit representatives to clarify issues,

business processes and data analysis results, and to obtain

approval/signoff on corresponding documentation.

. Responsible for installation/maintenance of various Kintana (Mercury

ITG) modules.

. Developed workflows (processes) to address the specific needs of

various end user groups.

. Conducted server administration task migration of various domains to

new server.

. Maintenance and creation of objects within PVCS.

. Created and maintained user accounts.

. Metric reporting of license usage and project task completion.

. Lead discovery meetings and publish all findings. Use the information

from the discovery meeting to develop automated code migration

processes, which address the specific needs of various end user and

corporate auditors.

OfficeMax Corporation

9/00 - 04/04

Release Manager/Mercury ITG Administrator

Responsibilities for this position were:

. Preformed Administrator task for IT Governance Software modules and

for PVCS (Tracker).

. Facilitated IT cross-functional team sessions for an end-to-end design

review of IT Governance software, used the findings from these

sessions to develop automated work flow processes, which address the

specific needs of various end user and.

. Developed and implemented workflow processes for system request,

system enhancement, project life cycle management, travel, and asset

recovery.

. Managed all aspects of new code releases; managed QA environment,

preformed production code builds (used UNIX commands for Java and

JavaScript files for file migrations.), established installation date

and time, published corporate wide communication, provided after hour

support, and created back out plan.

. Preformed Project manager functions for all projects that I sponsored

or championed Ex. Software upgrades, enhancements, new workflows

installations (automation of manual processes).

. Tracked and documented all systems-defects, determined their causes

and implemented changes as necessary.

. Provided metric dashboard for senior management team.

. Worked with team project managers to analyze business requirements and

define business process.

FirstEnergy

3/00 - 9/00

Business Analyst

Responsibilities in the position were:

. Created and executed test cases and scripts for Oracle supply chain

software.

. Acted as liaison between developer and end user community.

. Assisted training in their development of training materials.

. Defined scope and effort required for end user and management request.

. Gathered and documented business requirements related to creation and

implementation of Oracle supply chain application.

. Created and presented monthly project status reported to senior

management,

. Provide project management, development, and testing of new supply

chain application (in conjunction with user community and in-house

programmers).

. Conducted problem analysis based upon user panel observations and

feedback.

. Preformed ROI analysis of system enhancements.

Progressive Insurance Company 01/1986

to 03/2000

FINANCIAL ANALYST

. Provided data compliance through the creation and maintenance of SAS

and JCL jobs.

. Balanced reporting data against general ledger postings ensuring

accuracy.

. Performed data analysis calling out data trends.

. Tested data and newly written programs for reasonability and accuracy.

. Verify state credits and assignments to data filings.

. Responsible for assimilating new data request into our current program

structure.

SKILL SETS & EDUCATION:

Applications and Platforms used:

Lotus Microsoft office Monarch

People-Soft Visio SAS

Table-Base Quattro Pro Paradox

GQL CICS JCL

CVS PVCS Load runner

Kintana/Mercury ITGC Clarity/Niku Vandyke

Microsoft office suite QMF MS Project

MS Power Point Java Script Primus

Remedy MS Access SQL

Toad BEC Metadata Scrubber Unix

Great Plains Axure

Platforms: Mainframe and Servers

Database: DB2 and Oracle.

Areas of Expertise:

Process Re-engineering Project Management

Change Management Operations Management

User and business requirements Process, procedure and technical

documentation documentation

Education:

Cleveland State University, BS 1998,

Majors; Marketing and Operations Management

*References Available Upon Request

Contact this candidate