Ericka R. Dolan, Professional MBA (student), PMP

*** ****** *********, *******, ** 30349

Home Office: 678-***-****

URL: http://www.redcorpenterprises.com/erickadolan.htm

Email: ablcvs@r.postjobfree.com

Professional Highlights:

Technical Project Manager with over 14 years of comprehensive experience in

all aspects of Data Warehousing including ETL (source to target mappings)

and Business Intelligence. Expertise in multiple facets of project

management: Application Development (SDLC), Business Process Management

(BPM), and Infrastructure.

. Eleven (11) years data warehousing (end to end) experience from data

provisioning to report delivery, eight (8) years management

experience, and a combined fourteen (14) years in multiple industries

including: financial services, insurance, media & telecommunications

and manufacturing.

. Significant application development experience, focused primarily on

data warehousing, ETL, Enterprise Performance Management (EPM),

Oracle/PeopleSoft, Hyperion Essbase, and Microstrategy software

applications.

. Several years experience working with offshore development teams (such

as Infosys and Cognizant)

. Strong accounting & finance background with experience in: Budgeting,

Planning and Forecasting, Activity Based Costing / Activity Based

Management, and Product Profitability Reporting.

. Extensive accounting and consulting experience; Certified Public

Accountant Candidate (NJ-non-practicing); Big 4 Alumna (KPMG Peat

Marwick LLP)

. Professional MBA Candidate - Buckhead cohort, Georgia State University

(graduating January 2011)

. Six Sigma Green Belt

Detailed Professional Experience:

Novelis, Inc Atlanta, GA, June 2010 - September 2010

Novelis is a world leader in aluminum rolling and recycling. Novelis

produces premium sheet and foil for high-value markets.

Technical Project Manager

Lead Technical Project Manager for the "Hyperion Strengthening" fast-track

project. The role included implementing a global change control strategy,

streamlining the infrastructure to improve performance and reliability and

reviewing and improving the data mappings to their source ERP systems.

. Defined a Center of Excellence for Global PMO Change Control across the

company (not just Hyperion)

. Assessed current and future state financial and statistical reporting

needs of the business and recommended infrastructure improvement (server

structure, use licenses and setup of a SDLC environment)

. Recommended improvements to upload and retrieval process (via lock &

send, webforms, and Hyperion reports)

. Performed detailed analysis of the ETL source to target mappings of all

inputs into the Hyperion suite of apps: FM, HFM, and HFP.

. Managed multiple projects simultaneously directly or indirectly through

project teams.

. Developed project plans. Tracked progress according to time projections &

project budget.

. Assessed impact of changes and delays on project and analyze

options/outcomes. Built and managed relationships with external vendors,

while monitoring metrics and performance and identifying improvement

opportunities

Earthlink, Inc Atlanta, GA, November 2007 - June 2010

EarthLink, Inc. operates as an Internet service provider, providing

Internet access and related value-added services to individual and business

customers in the United States.

Technical Project Manager (Data Warehouse and Hyperion Essbase)

Role primarily is to employ business process management methodologies to

improve Earthlink's data warehouse, financial applications and reporting

processes in order to increase efficiency, reduce costs and drive business

strategy.

Saved a total of $1.2 mil USD from infrastructure and headcount reductions

for 2009. This was comprised of software license and storage cost avoidance

savings of $550k plus a headcount reduction of $680k.

. Responsible for managing full time, contract, and off-shore resources

supporting the Data Warehouse and Hyperion Application suite.

. Created, negotiated and managed Statement of Work for offshore teams to

handle the ETL development and Call Center operations.

. Managed the redesign and reduction of an existing 24 terabyte Oracle-

based enterprise-wide data warehouse to a 10 terabyte information

warehouse. This included infrastructure redesign and mang

. Responsible for the day-to-day support operations for all the Hyperion

Essbase financial systems such as collections, treasury, SEC and

budget/forecast modeling

. Created new HFM/Planning/Essbase applications (for testing or other

purposes). Monitored and reported system performance, availability, and

utilization. Created/Maintained/Enhanced/Troubleshoot business rules,

calc scripts, load rules, report scripts, server scripts

Ralcorp Holdings St. Louis, MO, September 2006 - June 2008

Ralcorp is a leader in private label, store brand foods. Ralcorp produces

a variety of foods sold under the individual labels of various grocery,

mass merchandise and drug store retailers throughout the United States and

Canada.

Project Manager / Team Lead, Redcorp Enterprises LLC

Multi-phased role included assisting in driving delivery and implementation

of the Oracle E-Business Financials Application (A/P, A/R, G/L) suite

through their different divisions. Subsequent phases included implementing

both an EPM Data Warehouse and configuring the PeopleSoft Activity Based

Modules for ten of their plant divisions.

. Acted as project manager and technical manager for a team of 10

developers. Responsible for staffing, budget estimation, tracking and

reporting to the executive staff.

. Constructed system integration plans to capture metadata and

transactional data from the Oracle Financials system to the EPM Data

Warehouse (specifically GL, AR & AP)

. Provided technical direction for staff consultants as well as hands-on

expertise.

. Re-configured and debugged the ABM Models for 10 Plants within two

divisions

Oracle USA, Inc Redwood, CA: October 2005 - September 2006

Oracle is the world's leading supplier of software for information

management, and the world's second largest independent software company.

Oracle technology can be found in nearly every industry, and in the data

centers of 98 of the Fortune 100 companies.

ATS Business Intelligence & Data Warehousing - Project Manager / Team Lead

. Development Lead for EPM Implementation - this assignment involved

building the metadata for the allocation processing for the EPM Warehouse

of various clients.

. Built over 1,000 metadata objects for several allocations processes. Also

built the metadata export definition for migration of the metadata in

multiple phases.

. Developed custom DMS to migrate the metadata objects not captured by the

delivered PeopleSoft Metadata export.

Turner Broadcasting Systems, Inc Atlanta, GA: September 2004 - October 2005

Turner Broadcasting System, Inc. (TBS, Inc.), a Time Warner company,

creates and programs branded news, entertainment, animation and young adult

media environments on television and other platforms for consumers around

the world.

Advanced Business Analyst (Data Warehouse and Hyperion Essbase)

1. Master Data Management Project. Lead Analyst responsible for

classifying data elements, considering data access and identifying

pertinent master data elements..Employed enterprise-wide Agile MDM

techniques and worked with the business, developers and architects in

order prioritize work items and methodologies. Lead in using agile

testing with developers to ensure quality, reliability and data

consistency.

. Proforma Essbase (via Hyperion Financial Planning) Project: Gathered and

analyzed functional requirements. Contributed in design team sessions

and determined data requirements to develop data marts for feeding

downstream financial Essbase applications. Provided accounting and

financial services expertise, analysis, development and delivery, project

planning, risk and issue management. Performed budget management,

developing project scope (budget, timelines and delivery dates), building

customer relationships and conducting status meetings and customer

reviews.

SunTrust Banks, Inc. SunTrust Plaza, Atlanta, GA: May 2000 - September 2004

SunTrust Banks, Inc., with total assets of $179.1 billion on March 31,

2009, is one of the nation's largest and strongest financial holding

companies

Financial Systems Manager, Assistant Vice President

Project activities included: Provided Data Warehousing and Enterprise

Performance Management expertise on a five (5) year project which

encompassed development and delivery, planning, engagement costing, budget

management, team staffing, risk and issue management, employee mentoring,

contractor management, and team performance reviews.

Noteworthy Contributions:

2. Assisted in the design of an PeopleSoft EPM Data Warehouse providing

the business with one look at customer and product profitability

information from sources including the General Ledger System and

various 3rd party data. Finance / Project Manager responsible for all

front-end interfaces of the data warehouse implementation.

. Provided day-to-day leadership and direction to a professional staff

of developers. Responsibilities also included design, creation and

maintenance of the dimensional model, ETL design, report design, and

user training. Used a star-schema data model. Used an Oracle

database and Cognos Series 7 front-end, automated quarterly reporting

process and designed and developed executive dashboard reports.

. Provided reporting analysis for management reports using Cognos and AB

Initio

. Defined and implemented tools and procedures to track and report Meta-

Data objects within the Enterprise Data Warehouse.

. Provided both technical and functional leadership on the

implementation of an Enterprise Performance Management application

(PeopleSoft EPM) sourcing from the Enterprise Data Warehouse. Assisted

on all components: analysis and design, application development,

application deployment and post production support. Functioned as both

a functional user and technical developer for various EPM modules.

. Engineered new functionality into the Enterprise Performance

Management application (such as a custom application engine and its

related tables that performed the company's Activity Based Cost

allocations).

. Designed and implemented a tool for the monthly Change Management and

Year-to-date Adjustments process (using MS Access / Visual Basic /

VBA).

Nomura Securities International World Financial Center, New York, NY:

October 1997 - May 2000

CoRE Program/Systems Developer

Noteworthy Contributions as a Developer:

Designated Programmer for the commercial real estate division designing and

implementing a Data Warehouse that supported general ledger data derived

from PeopleSoft Financials application.

1. Responsibilities included ETL design, data model design, report

design, and user training. Used a star-schema data model. Using an

Oracle database and Cognos Series 7 front-end, automated quarterly

reporting process and designed and developed executive dashboard

reports.

2. Performed analyst and data architecture role by performing a current

state analysis of the enterprise's data architecture, identified the

core data of the business where data quality, integrity, and

management were deemed critical to operation, constructed enterprise

conceptual, logical, and physical models for core data, and

constructed and executed the plan to implement the new data

infrastructure and re-point existing applications and data flows

accordingly

Noteworthy Contributions as a Functional User:

3. Determined and monitored credit risk for complex financing vehicles

for securitizing commercial real estate loans (i.e. FASIT Financial

Asset Securitization Trust).

4. Performed daily valuation and analysis of inventory consisting of

commercial whole loan derivatives, interest rate swaps, commercial

mortgage backed securities, and other real estate finance related

products

5. Assisted in building the infrastructure for the middle office of the

Capital Company of America - a spin-off company of Nomura Asset

Capital Corp

KPMG Peat Marwick, LLP Short Hills, New Jersey: May 1993 - October 1997

Senior Consultant

Noteworthy Contributions:

6. Recipient of the KPMG Spot Award (December 1996) for providing

exemplary client service in terms of speed, quality and outstanding,

sustained efforts over time that lead to exceptionally successful

results.

7. Recruited while still in college as a staff accountant intern.

Finished college course-work during the nights and worked full-time

throughout the day. This work subsidized part of my college tuition

expenses.

8. Promoted to project manager for a consulting engagement relating to

the merger of the corporate Accounting and Financial Reporting

divisions of two large financial institutions. Managed and supervised

10-12 project staff members, developed procedures manuals and

conducted training sessions.

9. Assisted in realigning the accounting department, implementing process

improvements, and streamlining the management reporting process.

10. Performed the planning and implementation of audits of twenty-seven

(27) branch offices, seven (7) of which required travel, and eleven

(11) departments, to ensure compliance with state and federal

regulations.

11. Formulated audit conclusions and issued recommendations to management

concerning audit findings.

12. Responsible for inventory, auditing, including observations, test

counts, and reconciliations on a monthly basis.

Education / Certifications:

Rutgers University - School of Management, New Brunswick, NJ

Bachelor of Science in Major Accounting

Inductee, Phi Theta Kappa

Member, National INROADS Alumni Association

Villanova University, Philadelphia, PA

Master Certificate in Project Management for IT/IS Professionals

Georgia State University, Robinson College of Business

Professional MBA - Buckhead Cohort Class of 2011

Member, Graduate Business Association

Project Management Professional (PMP)

PMP certification number: 1247339

Member, Project Management Institute (PMI)

Atlanta Chapter: Information Systems Special Interest Group

Certified Public Accountant (State of New Jersey

***Non-practicing

Six Sigma Green Belt

Technical Skills:

Skillset Level Yrs Tools

Methodologies Intermediate/Adva 6+ Agile Project Management

nced Waterfall (Traditional) Project

Management

Joint Application Development (JAD)

Rational Unified Process (RUP)

Systems Development Life Cycle (SDLC)

Data Advanced 13+ Dimensional Modeling

Warehousing/DBA Logical and Physical data model

design, Advanced Query and Analysis,

Enterprise Performance Management

(EPM)

Programming Advanced 10+ SQL, PL/SQL, TOAD, Visual Basic

Languages & Tools Peoplecode / Component Interface

PeopleSoft Application Engine

Business Intermediate/Adva 10+ Hyperion: ESSBASE (7.x, 9.0.x),

Intelligence, nced Integration Server (EIS), Analyzer

Applications & Hyperion Financial Planning

Packages Cognos OLAP Reporting

Business Objects (6.5, Webi,

Designer)

PeopleSoft EPM Activity Based

Management

PeopleSoft EPM Funds Transfer Pricing

Database Intermediate/Adva >6 Oracle 9i

Management Systems nced MS SQL Server 2005/2008

and Tools

ETL Tools Intermediate >6 Informatica 6.1

DataStage

Excel-to-CI

General Advanced 14 Microsoft Products (Word, Excel,

Project, PowerPoint, Access, Visio)

Contact this candidate