Skills Business Intelligence Architect and Developer with extensive experience creating metadata reporting objects and developing reports and analysis for finance, supply chain, marketing and sales. Excellent background in metadata design, disparate data integration, reporting, and analysis.

Experience

April 2011 to May 2012 Confidential Burlington, MA Lead Consultant

• Managed Business Intelligence metadata architecture creation and report development for Massachusetts Department of Education project using Cognos 10.
• Worked with stakeholders and business team for report design, development, testing and migration to production environment.

June 2010 to April 2011 Confidential Cambridge, MA Managing Consultant

• Managed onshore and offshore Business Intelligence development teams for sales integration project for Pfizer using Cognos 8. Managed onshore BI team for GM Cognos upgrade
• Maintained and enhanced metadata architecture for GM reporting during Peoplesoft upgrade.
• Worked with customer and internal team for report design, development, testing and migration to production environment.

August 2008 to February 2010 Confidential Woburn, MA Business Intelligence Consultant

• Designed, developed, implemented business intelligence projects for Raytheon using Cognos 8.
• Worked with customer to define design transformation criteria, ETL transformation and metadata models for manufacturing defect containment, job skill analysis and purchasing management.
• Developed several metadata models and reports for Engineering, HR and spare parts management.

October 2005 to August 2007 Confidential Waltham, MA Business Intelligence Practice Manager

• Designed, developed, implemented business intelligence projects for Pharmaceutical customers using Cognos ReportNet, PowerPlay & Cognos 8 and Business Objects.
• Managed customer relationships within corporate environments by interfacing between functional areas and IT for successful BI implementations.
• Worked with Maxiom customers to create layout, define design criteria, completed initial planning and cost estimates for marketing analysis including: Speaker program effectiveness, Discount analysis, Incentive compensation analysis.
• Negotiated consultant contracts with Maxiom customers.
• Worked with customer data warehouse teams to integrate financial, sales, call center, marketing and 3rd party data sources daily, weekly and monthly reporting.

July 2001-September 2005 Millennium Pharmaceuticals, Inc Cambridge, MA Senior Business Systems Analyst

• Manage Cognos environment for entire company.
• Develop business applications across functional areas
• Responsibilities included maintaining Impromptu/IWR, PowerPlay Web environment. Cognos Application Security.
• Designed and developed company's sales data warehouse and systems using NDC, ICS and third party sales data sources.
• Developed and implemented Oracle Financial reporting via Noetix Views.
• Developed report distribution applications using VB & Java for three sales forces
• Automated Cognos security to support over 100 G/L departments and 3 sales forces
• Took part in expanding the design and development of corporate data warehouse which included data from NDC, IMS, Oracle Financials, CRM and Peoplesoft, to provide a complete view of sales, financials, procurement and human resources.

June 1998-June 2001 Confidential Cambridge, MA Senior Business Systems Analyst

• Manage Cognos environment for entire company.
• Develop business intelligence applications sales and marketing and incentive compensation.
• Managed bulk outbound email communications for marketing, sales and security notification.
• Team contributor to data warehouse improvement project to integrate CRM, Sales Orders and customer communications.

May 1995-May 1998 Confidential Burlington, MA Senior Business Systems Analyst

• Pre and Post sales implementation of Cognos applications
• Developed and implemented Finance, Sales, Marketing and Human Resources reporting systems for Fortune 1000 Cognos customers.
• Sales and Marketing projects to the Medical Industry include: Rhone-Poulenc Rorer - field sales reporting; DuPont Merck - sales reporting system development and delivery; Boston Scientific - sales field and management reporting; Johnson & Johnson - financial management reporting; Harvard-Pilgrim Healthcare - financial management reporting.
• Managed third party consultants for large projects.
• Provided training to partners, customers and internal staff on Cognos Products.

July 1994-May 1995 Confidential Cambridge, MA Consultant

• Provided consulting to small business in the use of Dbase, Rbase, Foxpro and Excel databases.
• Provided training services to the Boston Computer Society.

February 1994-August 1994 Confidential Cambridge, MA IT Manager

• Provided support for migration of paper based clinical data management to computer based application.
• Provided application support for Macintosh and PC environment in three offices.

August 1987-January 1994 Confidential Cambridge, MA IT Manager

• Managed staff of two supporting outbound fund raising organization.
• Responsibilities included importing customer databases in to Dbase, analysis of customer giving information, telephone number verification of customer member information, developing scripts to select highest value members to call and deliver 10,000 names and phone number for call center to call per week. Follow up analysis of call performance and fulfillment management of donor giving.
• Developed applications in C, Dbase, Turbo Pascal to automate data processing of customer data.

September 1985-July 1987 Confidential Needham, MA Developer

• Migrated paper based project estimation, management and billing to computer based application.
• Developed applications using Rbase
• Applications developed reduced time to produce project estimates to 1 day from 5, billing from several days to hours and in the process improved accuracy of billing and warehouse management.
• Uncovered over $75,000 in unbilled deliveries to customers through automation of previous two years of business.

May 1983-August 1985 Confidential Marlborough, MA IT Manager

• Migrated users from: typewriters to word processors; manual based project estimation to Lotus 123; manual payroll to automation via ADP.
• Responsibilities included: installation of computers; software selection; installation and training.
• Provided technical support to sales and marketing as technical lead on marketing projects.

Education Bachelor of Science, Computer Science