PROFESSIONAL SUMMARY:

• Experienced Project Coordinator / PMO Coordinator / Financial Reporting Analyst / Professional Writer with experience in corporate IT environment and entertainment industry
• 14 years IT experience as a Project Coordinator, Assistant Project Manager, Financial Reporting Analyst and PMO Coordinator.
• Experience with various project management methodologies: CAPM in PMBOK, some work in Agile environment where I helped to coordinate sprints, and user stories.
• Expert in Microsoft Office (2010, 2013), particularly Excel (macros, formulation, and some VBA), PowerPoint, Word, Visio.
• Expertise in designing sophisticated and custom Excel reports tailor - made for project needs, including status tracking documents, financial breakdowns and forecasting, labor analysis, software development life cycle (SDLC), metrics, SLAs and work order processing.
• Experience with online tools: SharePoint, Office 365, SAP, ServiceNow, SumTotal, Confidential ’s Request Management, Pulse Point, Performa, Yantra, Planview, Adobe, Acrobat. Self-taught MS Project and some SQL.
• Experienced in interfacing with high-level execs, project managers, app owners, SMEs, vendors and clients. Past IT experience includes assisting with an Imperva security system installation for Confidential, tracking global server upgrade project for Farmers Insurance, wireless upgrade for Confidential hospitals, various PMO departments, Farmers infrastructure department, redesigning reports for global compensation division of HR department for international construction company.
• Diversified writing background and experience including professional screenwriter, website writer and blogger, screenplay analyst and corporate proofreader. Extremely well-organized, with strong attention to detail; wealth of experience functioning on own with little to no supervision.
• Meticulous, versatile and a fast learner.
• A team player who thrives in a fast paced, pressurized environment.

WORK HISTORY:

Confidential, ANAHEIM, CA

Project Coordinator

Responsibilities:

• Coordinated for an enterprise-wide wireless upgrade project for Providence Confidential -affiliated hospitals.
• Duties included redesigning status reports, reorganizing file system within FileHub (Box), performing rack face elevations onsite on wireless equipment, and various ad hoc reporting for other departments.

Confidential, GLENDALE, CA

Project Coordinator

Responsibilities:

• Assisted PMO manager by redesigning project tracking documents, reconciling actual hours and dollars against forecast amounts via SAP.
• Worked with ServiceNow service management tool in reporting and data entry.
• Did data reconciliation of multiple data sources, managing the workflows, data management and billing.
• Responsible for capturing meeting minutes and preparing or helping to prepare presentations to project stakeholders.
• Created team sites in Sharepoint and used Office 365 for shared documentation.

Confidential, LOS ANGELES, CA

Reporting Analyst

Responsibilities:

• Designed and upgraded numerous Excel reports for Global Compensation division of multi-national design and management company during year-end rewards and merit increase cycle for resources.
• Reports generated via SumTotal application.
• Worked closely with executives to integrate the reporting to meet updated requirements and present to high level executives.

Confidential, GLENDALE, CA

Project Coordinator / Assistant Project Manager

Responsibilities:

• Designed a multi-functional Excel tracking document for project to install Imperva database activity monitoring (DAM) tool across the entire Confidential proprietary applications.
• Fixed data unreliability by designing the tracker to pull data straight from tool’s technical configuration documents rather than old manually-entered reports. Interfaced with application owners across various
• Confidential enterprises (theme parks, movie studio, corporate headquarters) and internationally to gather needed information for configuration of the tool to their apps’ needs.
• Created weekly progress reports to Director. Scheduled and ran technical configuration and tuning meetings with the app owners and Imperva SMEs.
• Also oversaw work distribution to the SMEs. Helped project manager design and implement process and documentation for transition of the oversight of the Imperva tool to Security Ops team. Performed post-project audit on and prepared a presentation for all past Imperva tickets as a value measurement of employing the tool to Confidential apps.

Confidential, LOS ANGELES

Project Coordinator / PMO Coordinator / Reporting Analyst

Responsibilities:

• Redesigned Excel tracking documents of software development life cycle (SDLC) of monthly releases of software package updates for Farmers proprietary applications in Farmers Personal Lines, Auto and Home departments.
• Responsible for financial reporting to high-level management for the general account, including forecasting and quarterly breakdowns of revenue. Regularly interfaced with project managers and client to maintain project health status reporting.
• Completely redesigned tracking document and reporting for a global server refresh project containing over 6,000 servers.
• Designed and maintained metrics tracking documents for account.
• Processed daily work orders for the account and developed worksheet that coordinated data from multiple sources used to track the work orders and contractor rates.
• Audited work of various resources pertaining to software development life cycle of monthly releases and also for a global server refresh.
• Created and maintained spreadsheet tracking rotation of incoming and outgoing offshore resources for the account and associated financial impacts.
• Maintained database and tracking sheet on PC refreshes and ordered equipment as needed.
• Developed any ad hoc reporting as needed for high-level presentations.