OBJECTIVE:

To obtain a leadership position in media Information Technology with a focus on relationship management, vendor relations and software development and life cycle management. Experience in Sales, Acquisitions, Financial and Business Intelligence systems for the cable television industry. Experience in data modeling and data warehouse management. Strong business analysis and communication skills.

SUMMARY:

• Extensive experience providing business intelligence for media industry Advertising Sales management teams.
• Full - scope expertise in information gathering, data modeling, project planning, technical architecture, development, coding, testing, deployment and documentation of reporting solutions. Intimate knowledge of television Ad Sales business process and experience communicating with and recommending solutions to senior management.
• Solid technology background in programming and application development.
• Strong knowledge and experience programming database solutions with expertise in Oracle and MS SQL Server products.
• Thorough understanding of RDBMS programming, including database design and business logic.
• Hundreds of stored procedures and ad-hoc queries. Experience with Data Warehousing design concepts (star schema, dimensional modeling, ETL) and implementations (Kalido DIW, Oracle Warehouse Builder). Business Intelligence packages such as Cognos, Tableau and Business Objects.

EXPERIENCE:

Confidential

Relationship Manager

Responsibilities:

• Project manager\business analyst for custom built content management system (ICMS) for the Sundance Channel Global unit. Duties included:
• Extensive analysis of business generating detailed flowcharts mapping sequential dependencies and interfaces for existing process.
• Identified gaps between existing process and current requirements. Worked with business to articulate gaps to development team. Responsible to ensure gaps properly addressed in new software.
• Created testing matrices for and monitored progress for several test phases (sandbox, UAT, post-deployment). Gathered requirements for Phase 2 enhancements.
• Developed and led product demos and sessions for both internal (IT) and client groups.
• Generated, maintained and reconciled plan for the project. Reviewed weekly with Area Relationship Manager for progress reporting to IT management/PMO.
• Coordinated change management process to ensure successful deployment of new software into a Production environment: prepare Change Advisory Board documents to secure authorization for change, prepare Run Book containing all essential technical information and variables about the Production environment.
• Project manager for application interface between content management system (IBMS) located in NYC and scheduling systems (Pilat’s IBMS) located in Amsterdam.
• SME and change management for xml-based system data synchronization (troubleshoot issues, recommend fixes) BUS-architecture integration system.
• Performed enterprise wide usage audit for cost-benefit analysis of cloud-based sharing software, specifically Box.
• Interviewed users across all departments (Marketing, Media Management, Legal, etc.) collecting usage trends, security concerns, administrative challenges, departmental dependency and investment, etc.
• Presented accumulated data in reports and spreadsheets to Senior IT management. Used in strategic decision making of corporate cloud file sharing and collaboration strategy
• Provide support services for users of mission-critical legacy systems, such as Gabriel sales and traffic software, e.g. debugging errors, unlocking accounts, manual batch job or report generation, etc.
• Generated business requirements documentation for various mid-sized software enhancements which were submitted for review and approved to drive IT development work, including:
• Account-unlock interface for Support Desk to unlock user accounts without database connection.
• Enhancements to the WE tv research data warehouse to enable greater flexibility when searching for comparative programming performance (Nielsen ratings data) when determining how to estimate the audience delivery for a title.

Confidential

Business Analyst / Consultant

Responsibilities:

• Application management of suite of custom Ad Sales business software providing Deal Planning, Deal Maintenance, Ratecard and Stewardship services for 2 cable networks handling over $2B in sales revenue.
• Respond and resolve end user issues
• Log bugs, develop and deploy application fixes and enhancement
• Author summary queries for management
• Developed data extract routine to capture planning and active contract sales data for departmental data warehouse.
• Defined technical specifications and provided coded procedures to capture data changes.
• Gather business requirements, technical specifications and draft statement of work for critical enhancement to Ratecard application to streamline Pricing and Planning annual inventory valuation process.
• Oversee development, testing and deployment of upgrade into production environment.
• Project management for Business Intelligence projects enhancing or utilizing an On Air advertising sales data warehouse. Deal planning, maintenance, traffic, finance and stewardship application data warehoused with Kalido Dynamic Information Warehouse software. Projects included implementing a ’snapshot’ architecture to report incremental gains, migration of new planning system into data warehouse, and various reports development projects.
• Arranged meetings for and gathered functional requirements from Business Intelligence dept. to translate into a business data model to guide data warehousing development. Created requirements documents and test cases. Drafted business model data entity schematic with Visio. Worked with applications development team to specify technical design, implementation, and data load.
• Managed development and testing effort of an offshore team located in India. Provided interface for 3 programmers and one QA tester to client management team.
• Transferred business domain knowledge, validated development efforts, clarified requirements, reviewed code, coordinated environmental access, led status meetings, etc.
• Generated documentation for existing reporting systems and mission-critical finance.
• Analyzed data warehouse system, including SQL code, from source to user-interface documenting each stage by purpose and encapsulated business logic.
• Reverse engineered major revenue summary reports and documented findings to provide authoritative user guide on function and contents of reports.
• Gathered and documented operational and design information for legacy MS-SQL (DTS packages) data warehouse for planning system prior to departure of subject matter expert.

Confidential

Programmer/Analyst

Responsibilities:

• Provide development work and support for the Advertising Sales department with a focus on reporting. Work directly with Ad Sales upper management to scope business-critical reporting solutions for improved business intelligence. Utilize working knowledge of television network Ad Sales business process to provide ad-hoc analysis and metrics directly to management.
• Develop and maintain complex reports for several departments, including Ad Sales Revenue (actuals, forecasts), Traffic (inventory, log scheduling), Marketing (scheduling, promos), and Network Operations. Revenue reports involve complex database side programming (Oracle 8.1.7/TOAD) and through understanding of revenue streams - 50+ pages of code.
• Applications development working on custom multi-tier Ad Sales deal tracking systems utilizing Microsoft Visual Studios.NET technology. Worked as part of development team, designing and building front-end and middle-tier controls and components with VB.NET. Responsible for defining business objectives, technical specifications, architectural solution decisions, development, quality liaison, and implementation.
• Monitor and manage server response and resources the Web Reports Portal serving USA Network and the Sci-Fi Channel staff. Author scripts to manage business-critical “overnight batch” report creation. Developer and primary administrative contact for in house web-based report delivery system. Manage custom reports distribution and user-access.

Confidential

Technical Specialist

Responsibilities:

• Design and construct test stands for performance testing and R&D testing of air filtration products.
• Develop Data Acquisition System application for automation of test stand using VB 4.0 and MS Excel 97.
• Work with staff scientists to author technical reports, data charts, and schematics.