SUMMARY:

Creative solution - oriented data professional with more than 15 years experience in media and financial services. Deep skills in business intelligence, supply-chain, financial modeling, training, reporting, problem analysis/resolution and design. Strong leader and works well with diverse groups.

TECHNICAL SKILLS:

Basic Office: MS Excel, MS Word, MS Visio, MS PowerPoint, Lotus Notes, Outlook

Business Intelligence Tools: OBIEE, Business Objects, Toad, Aginity, Board, Mercury Quality Center, IBM Rational DOORS, HP-ALM, HP-UFT, VersionOne, Hyperion 9.2, SAS, Cognos 8, Crystal Reports, Tableau, QlikView, SQL Server Reporting, Salesforce.com, Remedy, Service Now, MS Sharepoint 2010/2013 (Power User/Designer), Microstrategy

Project Management: MS Project, Planview Portfolio Management, Planview Enterprise Development Management, Agile, JIRA, Rally, LeanKit

Databases: MS Access, eVMI, AS400, Operative/Dashboard, SPSS, Oracle Databases, SDLC process, JD Edwards/Enterprise One, SAP, MySQL, PeopleSoft Project Costing System, TIBCO

Design: Adobe Photoshop CS5.1; Illustrator CS5.1; Indesign CS5.5; Dreamweaver CS5.5; Flash CS5.5; Flash Catalyst CS5.5; Fireworks CS5.1, Adobe Captivate, Site Catalyst, Balsamiq, Google Analytics, Wordpress, XCode, SEO

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise Architecture, Business Analyst IV

Responsibilities:

• Developed a series of Tableau dashboards from existing Enterprise Architecture SharePoint lists, published out through Tableau Server to separate SharePoint pages into configured Javascript tabs enabling visualization, organization and high-level summarization of key data metrics.
• Developed Sharepoint workflows for Technical Debt tracker to update Portfolio Architects of missed Target Resolutions dates.
• Evaluated JIRA and LeanKit to replace existing SharePoint centric Technical Debt Tracker. Recommended to stay with SharePoint based on cost and functional requirements.
• Ad hoc data analysis on Technical Debt, Third Party Software registry, Mandatory Software Upgrade registry and other Enterprise Architecture areas.

Confidential

Senior Business Analyst/Technical Lead

Responsibilities:

• Change Coordinator facilitating EDM Maintenance releases for the Planview application.
• Managed two developers as acting Technical Lead in Agile framework where we delivered updates to the PEP (Project Engagement Portal) SharePoint application from the ITPMO requirements in four week sprints.
• Training Lead delivering weekly all day Project and Resource Manager training for the Planview Portfolio Management tool.
• Provide operational support through in person one-on-one training sessions and via Adobe Connect, Remedy/ ServiceNow ticketing system and email/IM.
• Developed interactive self-assessment online education modules via Adobe Captivate.
• Developed Computer Based Training modules via Adobe Captivate.
• Sharepoint Power User, optimizing team site and sub-sites through document management best practices, surveys, configured lists & libraries and functional Work Flows.

Planview Support Consultant

Confidential

Responsibilities:

• Part of team performing Resource Management roll out initiative for the Planview Portfolio Management tool, in 20 person classes within 3 months.
• Performed resource management training via Adobe Connect and one on one sessions.
• Created database of Organizational Leads, Resource Managers and Resources to manage changes in the resource management structure.
• Developed web based survey for the trainings via Jotform.
• Responded to support queries through Remedy.

Confidential

Sr. Analyst

Responsibilities:

• Developed standard and seasonal audiences for internal marketing customers and external advertising sales.
• Analyzed audience segment health, clean up of outlier keywords and domains.
• Maintenance and cleanup of taxonomy.
• Hands on familiarity with Google Analytics, including profile development, sales funnel creation, pivot table analysis, audience/traffic/content report configuration.

Business Intelligence, Data Steward Analyst

Confidential

Responsibilities:

• Delivered KPI Dashboard project implementing web-based coaching and reporting tool built in Oracle's Business Intelligence platform (Siebel Analytics / Siebel Answers) transitioned from Excel based reports for Collections business unit within Customer Service Center.
• Testing process included development of test plan, questions, data capture and analysis of results.
• Project Management responsibilities include development of Business Review Document, assessing vendors and procuring bids, managing vendor tasks and maintaining business side communication in an waterfall and Agile environment.
• Responsible for daily and monthly reporting tasks, ad hoc data queries utilizing OBIEE (11g), dating mining using SQL via TOAD and Aginity, Hyperion and project support.
• Launching new KPI project for Customer Service business unit within Customer Service Center in early 2012.
• Managed metric and ETL updates to the Customer Service Scorecard for FY13.
• Managed source-to-target mapping, data analysis and delivery of 12 missing fields in the Field Services DataMart.

Data Consultant

Confidential

Responsibilities:

• Produced custom call monitoring template in Excel, quantifying all channel types into summary tables and graphs, and output a score for each call to determine effectiveness as aligned with customer service standards.
• Developed data repository in Excel (from individual reports pulled from the third party data aggregator) to enable reporting functions for Confidential Bundles Program.
• Developed and implemented new web based reporting portal, integrated with third party data aggregator, enabling queries by date range, call type and channel.
• Authored RFP for new third party call center aggregator.
• Reported call metrics and sales data to senior executives, documented process flow of Call Center process with MS Visio.
• Documented and performed order reconciliation between Telcos, WildBlue DSL Satellite provider and Confidential to managed revenue leakage due to lack of system integration using SQL queries to pull data from the Business Objects (Oracle) Data Warehouse, matched in a series of MS Access databases and further manipulated in Excel.

Confidential

Finance Consultant

Responsibilities:

• Built financial models in Excel to determine revenue share and margin analysis for Music Sponsorships among the four major music labels, EMI, Sony, Universal and Warner.
• Built dynamic tracker in Excel for all music sponsorships that tracked booked, billed and shared revenue across all labels, pulling data from their Data Warehouse and porting into the tracker which enabled first time month over month reporting.
• Tracker used in conjunction with Omniture for ad placement web analytics.
• Reported sponsorship revenue to senior executives.
• Created media plans for pitches to clients.
• Coordinated internal and external parties to calculate sponsorship margins.
• Created and documented procedures for sponsorship reporting.

Senior Vendor Inventory Analyst

Confidential

Responsibilities:

• Managed the SBT (Scanned Based Trading) and Traditional business models, encompassing Kroger and Wegmans grocery chain and Costco.
• Under Costco, implemented a production calendar that helped all departments across the supply chain gain visibility to the product life cycle and enabled a 98% in-stock level and a drastic improvement in on time deliveries and order accuracy.
• Developed reporting through eVMI (Sony’s internal vendor manager inventory control system) and Business Objects (Oracle), and further enhanced in Excel to provide a clear data narrative to sales trends and opportunities.
• Managed over 700 stock keeping units (SKU) and maintained a 98% in-stock level for all accounts.
• Customized and developed reporting in JD Edwards Enterprise One version 8.11
• Assisted development of forecast model (Demantra) which helped smooth the inventory curve for seasonal promotions to better anticipate replenishment orders.
• Generated replenishment orders in eVMI and drove the operational aspects of assigned vendor managed accounts in the replenishment system.
• Developed, documented and delivered new hire training.
• Provided weekly reporting and analysis to senior sales staff.
• Assisted development of new Wiki-style knowledge bank application.

Account Manager

Confidential

Responsibilities:

• Managed deferred compensation plans for largest client, Siemens.
• Performed account analysis and maintained participant database.
• Provided customer service support, including phone and email trouble shooting.
• Coordinated activities of clients, plan participants, trustees and insurance company.
• Processed plan terminations and distributions, benefits and account change forms.

Consulting Services Assistant

Confidential

Responsibilities:

• Performed analysis for the Applied Asset Under Management reports and responded to RFI and RFP questionnaires.

Equity Trade Administrator

Confidential, New York City, NY

Responsibilities:

• Coordinated seamless execution of trades with brokers, traders and account administrators.
• Maintained and administered Depository Trust confirmations for trade settlement and reconciliation.
• Performed Repurchase Agreement trades and Fixed Income trading positions.