SUMMARY:

• Proven IT Portfolio Management,Analysis andReporting | Helping Companies Translate Their Business Goals to Reality
• Certified Microsoft Office Excel Expert building customized Microsoft Excel tools that automate manual processes to extract, transform, and load data, perform data analysis, dashboard visualization, generate output files and provide flexible reporting capabilities to support business analysis and decisions.
• Extensive experience in financial variation analysis (expense, budget, forecast), application portfolio management, PMO governance, project management, and process improvement coupled with Information Systems development, analysis, and management experience.
• In - depth skills in data analysis, problem-solving, testing, written and verbal communication, time management, leadership, and negotiation skills.
• Highly responsive individual and team player.

TECHNICAL EXPERIENCE:

PC Packages: Microsoft Excel (Pivot Tables Macros | Advanced Formulas and Algorithms), Microsoft Power BI| Tableau |Jira | Microsoft Word | Microsoft PowerPoint | Microsoft Project, Microsoft SharePoint|

Databases: TERADATA | ORACLE

Software Languages: SQL, VBA

PROFESSIONAL EXPERIENCE:

Confidential, New Providence, NJ

IT Portfolio Management, Analysis and Reporting

Responsibilities:

• Created various customized tools using Microsoft Excel that automated repetitive manual processes to produce financial analysis reports, eliminating manual procedures, improving source data integrity / output quality, and minimizing time to prepare outputs while enabling teams to focus on other critical activities, increasing organization productivity.
• Product Owner financial team member prioritizing requirements, preparing user stories, and coordinating testing for the implementation of a customized Microsoft Project Solution (utilizing Agile development methodology) to manage programs and projects from 1 centralized tool within company.
• Analyzed financials and presented findings to IT Delivery Partners and Business Partner organizations to highlight financial deviations Confidential program and project level which expedited business awareness of deviations, understanding reasons for deviations, and timely resolution of deviations that adhered to governance guidelines and expectations.
• Collected, tracked, managed, and improved accuracy of project cost postings in ERP by interacting with business partners to capture cost issues using Microsoft SharePoint 365 Technology and by following up with business owners to correct posting.

Corporate IT PMO Manager

Confidential

Responsibilities:

• Developed various tools utilizing Excel Macros, pivot tables advanced formulas and algorithms that automated extractions, translations, aggregations of high-volume data and provided flexible reporting and analysis capabilities via customized user interface enabling organization members to easily track, report and analyze program / project health.
• Increased percentage of Governance approvals for programs and projects by preparing IT project managers with guidance on governance presentations, reviewing program and project material for accuracy and completeness prior to gate.
• Initiated and presented Project Change Requests (PCRs) to expedite and obtain appropriate approvals for additional funding. Also, participated in identifying and implementing IT Governance process improvement activities.

Application Portfolio Manager

Confidential

Responsibilities:

• Eliminated number of redundant applications in portfolio, reducing system maintenance costs, while improving quality, accuracy and completeness of the company’s Application/Solution portfolio.
• Negotiated transfer of numerous applications maintained by business into the IT organization which resulted in improved efficiencies related to performance, maintenance and technical upgrades.

PMO Manager

Confidential

Responsibilities:

• Managed, planned, and directed PMO activities related to programs / projects, accelerating completion of programs within Marketing and Solutions, Services and Quality Assurance domains.
• Accelerated decisions and formal approvals from business and IT Management to move forward with programs / project by preparing and presenting PowerPoint presentations and communicating program and project scoping conclusions, value propositions, initial milestone plans and cost estimates, as well as initial budget and outlooks.
• Coordinated initial scoping activities based on high level requirements. Performed various user acceptance and regression testing activities to bring projects to completion.
• Created and managed large development team to implement companywide financial data extractions that transformed and loaded data from Lucent ERP SAP system and various legacy sub-ledger systems into Enterprise Data Warehouse Teradata platform resulting in decommissioning of several legacy applications and enabling $8.2M savings.
• Negotiated IT contract renewals and obtained reductions in cost for back maintenance, realizing 50% savings.
• Managed technology upgrades (Informatica ETL tool from 5.1 to 6.2.2, Teradata Database Upgrade from V2R4.1.3 to V2R5.1). Interfaced with vendors to ensure quality and timely support obtaining resolutions to 3rd party software bugs.
• Interviewed and hired several additional consultants to fill voids in required resources and skills needed to deliver enhancements and solutions within expected time frames.
• Managed Table Management Center (TMC) to maintain and update companywide master data to support monthly book closes and companywide reorganizations.

Confidential, Short Hills, NJ

Responsibilities:

• Developed sophisticated Microsoft Excel planning model to forecast asset transfers to plant, capital depreciation, Interest During Construction (IDC), and depreciation outlooks associated with Access Finance Local Infrastructure deployment. Improved forecast cycle time 50% and ensured consistency with capital submissions into local business planning process.
• Collected requirements, analyzed, designed, tested and implemented new procedures and new system to streamline monthly Access Financials forecasting and inter-entity cost assignment process. Improved process time 30% and decreased full time effort 25%.
• Coordinated cross functional team comprised of CFO, Tax, Customer Care and Collections professionals to streamline and implement operational and financial process changes to deliver long distance, local and wireless bundled service offers to Business Markets customer segments.
• Managed several development teams to enhance and maintain various applications that supported variety of critical business processes (Cost Accounting, Budgeting, Reporting, Tax Auditing, Government Billing, Table Maintenance and Project Tracking) which enabled continued technical support of daily operations within company.