Chris Mello Email & Phone Number

Waltham, Ma, Us

Brentford, Middlesex, Gb

Brentford, Middlesex, Gb

Managed day to day data operations for the oncology commercial data warehouse. Led analysis and business process design for the commercial oncology organization. Supported roll-out of sampling program for flagship product. Led integration for Tesaro commercial systems into GSK, which included Veeva, Tableau and the commercial data warehouse. Led mobile report training for field force teams. Trained and mentored junior commercial associates. Developed Tableau reports for senior field leadership and US market access teams. Coordinated multiple data integration work streams with outsourced IT vendors, data source providers and GSK IT across multiple projects. Managed data stewardship processes within commercial oncology. Supported data inquiries for the US oncology brand teams. Led commercial data and reporting readiness work streams for three concurrent product launches. Acted as an IT business partner for commercial oncology.

Tokyo, Jp

Managed a mixed team of employees and consultants supporting the commercial business functions at the Takeda Boston site. Lead day to day operations and project work for master data management, data warehousing, aggregate spend, BI reporting and analytic systems. Provided input into global strategy and operations planning for global commercial systems. Managed an annual budget of $3.5 million and sets departmental performance goals and metrics. Managed a team of up to thirty consultants and internal IT resources for the launch of a new product and supported the acquisition of an oncology company focused on solid tumor cancer treatments. Managed the upgrade of the MDM system for Oncology. Management the vendor transition from testing, development and operational support functions to new providers.

Tokyo, Jp

Led business analysis, design and support for Informatica MDM platform supporting the commercial organization. Supported Commercial Operations, Sales Analytics and Aggregate Spend Reporting from a master data standpoint. Managed mixed internal and external resourced project teams to support operations of MDM as well as major project initiatives while also continuing to develop ETL integrations between MDM, the data warehouse and Saleforce.com platforms. Provided enhanced reporting capabilities for the MDM solution.

Paris, France, Fr

Conducted business analysis, requirements gathering and design for reporting and analytic solutions. Built and tested business intelligence solutions to support financial planning and analysis, business unit sales, marketing and operations. Developed data warehouse processes using Informatica, Tidal, PL/SQL and UNIX shell scripts. Designed data architecture and process flows to transfer data between ERP, CRM and data mart systems. Developed data models, Cognos metadata models, reports and cubes. Led the technical team and developed the data architecture for two large scale data mart projects. Managed consultant resources. Developed internal cross IT team SLAs and business SLAs.

Washington, Dc, Us

Designed, built and tested enterprise data warehouse solutions for clients in the biotechnology and health insurance industries. Developed ETL processes in Informatica, PL/SQL and UNIX shell scripts. Developed data integrations for Hyperion Planning, Essbase, MDM and HFM projects. Led testing and documentation efforts on several projects. Developed OLAP cubes in Microsoft Analysis Services 2005. Managed project timelines, deliverables and client resources. Developed training materials for internal and external audiences. Managed practice area intranet portal.

Us

Led design and support for Business Warehouse and the enterprise wide data warehouse, while retaining development responsibilities. Developed enterprise-wide support, development and training processes. Managed two professionals, an annual budget of approximately $400,000, and the computer resources that supported 500 internal customers worldwide. Led global legacy data warehouse migration project.

Us

Oversaw the day-to-day operations of the data warehouse. Designed the data conversion process for the data warehouse as part of the SAP implementation project. Led the transition from Cognos to MS OLAP. Led training and support for the data warehouse. Integrated two new business units into the global data warehouse.

Us

Developed reporting capability across functional areas using Cognos, ProClarity and Microsoft reporting tools. Improved the data quality and the dependability of the data warehouse.

Conducted business analysis and requirements gathering. Designed data architecture, reports, and ETL for statewide student testing data warehouse. Supported Cognos, MS Access, and Open Base end-users.

In

Administered client’s Informatica 4.5 repositories. Improved data quality and reporting for an enterprise wide financial reporting system using Informatica 4.5 and PL/SQL. Test lead on Oracle based sales and distribution reporting systems. Developed and led end-user training. Conducted business analysis for a web based point of sale system.