Michael Piede

*** ******* ***** ****, ******, FL 34113 • 610-***-**** • ady31s@r.postjobfree.com

Data Architect

Data & Systems Architecture • Strategy Development • Client Satisfaction

Profile

Adept at developing and implementing centralized data warehouses, operational data stores, and industry leading e-commerce sites.

Strong business background in healthcare, pharmaceuticals, marketing and clinical trials.

Adept at developing analytical frameworks to achieve demonstrable business results

Extensive background in software development, technical architecture and infrastructure, IT operations, and implementation of cutting-edge enterprise-wide solutions.

Substantial project management experience and excel at interfacing with stakeholders to propel forward-moving efforts and drive continuous improvement.

Skilled at strategic planning, vendor management, executive relations, and leveraging appropriate project and delivery methodologies to optimize outcomes.

Demonstrated strengths in leading teams throughout complete SDLC for highly visible initiatives.

Skilled at standardizing procedures and best practices to eliminate unproductive processes.

Professional Experience

CleanCustomers Consulting LLC, Naples FL, 2007 – Current

Lead Data Architect

Designed and implemented central master data management for an over $1B financial firm. This consolidated and cleansed data from 5 different source system which included both MongoDB and SQL-Server Azure Databases. It was integrated using Kafka and provided the definitive individual and account information to a centralized Databricks Lakehouse.

Designed and implemented the Central CRM and Campaign management database for major hospital chain comprising over 50 hospitals; seamlessly consolidated patient records from EHR systems such as Epic, Cerner, Siemens, McKesson, Meditech, etc.

Formulated central warehouse model and ESB signatures for operational data store for one of the largest specialty pharmacies nationwide.

Designed data warehouse to enhance patient communications via web, email, and phone methods.

Created analytical mechanism which saved cancer treatment firm $40M annually by using cluster analysis techniques to distinguish treatment patterns for optimal modalities.

Analyzed claims reimbursement for RTA (independent radiation therapy association) which persuaded U.S. Senate to change proposed reduction of benefits from 38% to 3% for radiation oncology treatments.

Steered implementation of Workman’s Compensation analytical tool to merge compensation claims from two states, reducing labor expenses by $200K annually by lowering headcount by two staff members.

Installed MDM system and revamped internal data infrastructure for major healthcare websites to earn project nomination for Colorado Apex award as project of the year; system was used to develop new business model which now represents 50% of company’s revenue.

Installed MDM system into major pharmaceutical marketing company and integrated with Siebel CRM.

Created database to feed MOLAP system, enhancing claims analysis from 25+ insurance carriers.

Developed central data model for Master Data Management (MDM) and Data Warehouse Offering which played an integral role in producing $6M in revenues.

Standardized software development methodology for company to pass audits from pharmaceutical vendors with excellent results.

Continued …

Michael Piede -- Page 2 of 2

ePharmaSolutions Conshohocken, PA, 2005 – 2007

Director of Information Technology

Designed an online system to facilitate collection of clinical trial start-up documents and generate $1M in additional revenues.

Designed a central testing and scoring system to support training of physicians for clinical trials, and successfully reduced turnaround of scoring from days to seconds, translating to nearly $1M in revenue.

Built data model to track all entities involved in clinical trial as well as work products and milestones.

Developed and established a software development methodology to pass audits from pharmaceutical vendors with minimum findings.

WebMD, Inc., Elmwood Park, NJ, 2003 – 2005

Senior Manager, Corporate Informatics

Lowered labor costs by two FTEs by implementing systems which allow sales representatives to size marketing initiatives independently.

Streamlined outbound fax IT process to expand marketing initiatives by 50% with zero increase in IT headcount.

Formulated and developed a system which Boosted sales of fax services by 50% while increasing customer satisfaction.

Saved WebMD $100K+ in annual service fee contracts and $140K in vendor fees by orchestrating innovative process to validate registered physicians on Medscape portal which accelerated site access from five days to four hours.

Merck & Company, Inc., West Point, PA, 1993 – 2003

Senior Manager, Clinical Development Programs (2003)

Directed, coached, motivated, and evaluated 23 business analysts and clinical development managers.

Technical Manager, Merck Vaccine Division (1993-2003)

Shepherded team of 13 in new technology initiatives and earned numerous awards for exceptional performance and contributions:

o2002 Finalist, Merck Vaccine Division ‘Best Customer Initiative’ (MerckImpact.com).

o2001 Finalist, Merck Vaccine Division ‘Presidents Award’ for best support to marketing.

o2000 Project Manager for ‘Merck-IS Team of the Year Award’ (MerckVaccines.com).

o2000 Merck Vaccine Division ‘Award for Best Divisional Program’ (MerckVaccines.com).

o2000 Finalist, Merck Vaccine Division ‘Best Analytical Support to Marketing.’

o1999 Merck Vaccine Division ‘Marketing Award’ for best analytical support to marketing (development of Merck Vaccine Division’s core customer list).

Education

Electronic Engineering & Computer Science

Princeton University, Princeton, NJ

Technology

MS SQL Server, Oracle, Salesforce, Postgres, MongoDB, SQL, Oracle PL/SQL, Amazon Web Services, .Net, HL7, Analysis Services, Transact-SQL, MapInfo, Maptitude, C#, Visual Basic, C, C++, Java, JSP, HTML, JSON, XML/XSLT/XSD, HTML, Microsoft Project, Microsoft Project Server, ADO, Linux, Microsoft Office (Word, Excel, Access), UML (Rational Rose, Enterprise Architect), Visio, Erwin, Cognos Analytics, Essbase

Contact this candidate