QUICK SKILL SUMMARY

Business:

Methodologies: OOAD, RUP, Waterfall, SSD (Bank of America), SDM (MBNA)

Additional: Budgeting, Project Management, Performance Management, Process Mapping, Use Cases, JAD facilitation, Balanced Scorecard.

Technology:

Database: DB2, Access, SQL

Operating system: MVS, Windows, Unix

MS Task software: Microsoft Project, Visio, Word, Excel, PowerPoint, SharePoint

Data Warehousing: OLAP (Essbase), Business Objects, specialized coursework

ERP: SAP (FI/CO/MM/SD/PD), Clarity

Testing: Mercury Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

Project Coordinator

Responsibilities:

• Portfolio metrics in Excel, portfolio administration, project approvals.17.
• Program meeting coordination. MSPS updates.
• Timesheet approvals, invoicing, internal orders, budgeting, risks, problem solving.

Project Manager/Analyst, IT

Confidential, West Point, PA

Responsibilities:

• Capturing global IT portfolio financial variances over time for IT Director to use as talking points in status meetings.
• Variance reports to elicit explanation from Portfolio Leads and Project Managers.
• Strong use of Excel Vlookup formulas, pivot tables, graphing, and BISM Power Pivot Tables.

Sr. Project Coordinator

Confidential, Norristown, PA

Responsibilities:

• Manage issues, actions, risks and change process. SharePoint, key meeting minutes, executive presentations.
• Timely monthly, quarterly and semiannual regulatory reporting to DOE. Presenter at DOE annual site visits.
• Manage TO invoice and status report submission process.
• Facilitate data communication “go - lives” between PJM and TO’s.
• Set-up and progress projects using Clarity, MSP and some SAP.
• These tools were integrated.

Confidential, Philadelphia, PA

Program Coordinator, Information Technology

Responsibilities:

• Built-out MSP master schedule and progressed it weekly.
• Tracked issues/actions/risks/change requests in Quality Center (QC). With admin, tailored a QC environment for tracking issues/risks/actions. Educated IT and business on use of QC.
• Quality liaison to IT PMO. Maintained SharePoint site. Technology meeting facilitation.

Confidential, West Chester, PA

Project Officer

Responsibilities:

• Translated project’s scope to financial measures.
• Controlled spend against project budgets.
• Worked closely with PMs and Directors to determine needs then delivered a standard package; timely, regular reporting in intuitive, user friendly format.
• Utilized Business Objects to query work hour reporting’s then massaged data into variance reports via Excel Vlookup formulas and pivot tables.
• Tracked travel cost by creating a plan then managing to the plan.
• Captured status, risks, actions and minutes. WBS in MSP, Visio swim lanes, Excel dashboards.
• Worked effectively in global virtual team environment.

Program Coordinator

Confidential, Philadelphia, PA

Responsibilities:

• Maintained Master Plan in MSPS, updating schedule, task, and % complete.
• Administered Lotus Notes.
• Identified issues around 8+ work streams. Triggered appropriate action to adhere to timelines and budgets.
• Issues, actions, risks, status, changes, responsibility matrix, MSP schedule updates, contact lists, minutes, internal project audits, methodology advisor to project teams. Full project lifecycle coordination of concurrent large system projects.
• Meeting facilitation via video conferencing/WebEx. Organized video training for Specialists.
• Reduced project repository set-up time from 30 to 5 days. Received Above & Beyond Award.
• Development of FrontPage web portals. Use of Live Link and SharePoint.
• Facilitate JAD sessions. Assist with test scripts and defect tracking in Mercury Quality Center.
• Efforts paved way for Specialists to participate in all 5 phases of project lifecycle as opposed to only 3.

Confidential, Ft. Worth, TX

Sr. System Analyst, Data Warehouse Production Support

Responsibilities:

• Maintained Unix scripts. Responded to incidences in ETL process.
• Improved external data center reaction times by 8 minutes.
• Developed extensive customer documentation condensed from numerous technical texts, models and diagrams detailing how airline industry data sources enter the warehouse.
• Educated others on MS Project.

Confidential

Lead Information Specialist

Responsibilities:

• Strong metric work: Operational efficiency, benefits tracking, KPI’s, industry benchmarking, management information, transparency, due diligence, insight into financials.
• Heavy business/systems analysis, process documentation across Network Division legacy & ERP systems.
• Three dedicated IT resources for Oracle ETL & GUI processes around Metrics Datamart, later Network Controls Department.
• Divisional SME to SAP BW project. Prepared questionnaires, conducted interviews, gathered requirements, created textual use cases and logical models in anticipation of division’s dimension and fact tables.
• Cut financial control staff month-end processing time in half by fine-tuning process with better use of desktop tools.
• Performance Management Workshop for Business Analysts.
• Periodic presentations to management and peers.
• Marketing-IT liaison to deliver Sales Lead Lists targeting ‘right customers at right time’.
• Raw data manipulation (cleanse, sort, format, deliver) at mainframe (JCL sort) and desktop (Access/Excel) levels.
• Created billing system specifications and conducted system-wide verification testing.
• Automated delivery of Essbase dynamic OLAP Call Tracking Reports, to touch of a button with Excel macros.