SUMMARY:

• Innovative, strategic thought leader who delivers actionable information for business analysis and decision making. Champions new initiatives and builds cross - functional relationships. Excels at transforming data into information and knowledge while evolving architectural capability to provide clear business insight.

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

Data Architect/Data Modeler

Responsibilities:

• Design and develop conceptual, logical and physical data models for Confidential ’s Intelligent Enterprise datamart and dashboard initiative.
• Design and develop stored procedures used for data integration.
• Research Microsoft Analytics Platform System (SQL Server PDW, HDInsight, Polybase), SAP HANA, Pivotal HD, Greenplum and HAWK.

Technology: Embarcadero ER/Studio, Microsoft SQL Server, SSIS, Informatica, Qlikview, Neo4J

Confidential, Parsippany, NJ

Data Architect, Data Warehouse Solution Architect

Responsibilities:

• Provided Data Architecture leadership and management for the design and development of a $15M Commercial Enterprise Data Warehouse & Business Intelligence journey that increased decision making capability and business time-to-insight 4-fold.
• Managed the design and development of Conceptual, Logical and Physical data models, data dictionaries, and semantic and canonical models. Industry methodologies included the Zachman framework, Inmon, Kimball, Silverston, Hammergren, and Linstedt. Direct reports included one data modeler.
• Provided Data Architecture leadership and management for the design and development of a $3.5M Data Integration Hub for the Federal Physician Payment Sunshine Act, that captured recipient aggregate spend, complied with federal and state legislation, mitigated risk and identified spending trends through Cegedim AggregateSpend360 (now IMS Health).
• Managed business transformation and improvement initiatives for Customer Relationship Management (CRM) using Cegedim Mobile Intelligence (now IMS Health). Epsilon Campaign Management, Thought Leader engagement with Steeprock and InfoMaestro, Master Data Management (MDM) using Cegedim OneKey and Nucleus360 (now IMS Health), Data Analysis and Reporting through Axtria, Concur Travel & Expense, and Revitas Contract Management and Reporting.
• Managed and implemented Customer Data Integration/MDM for Promotional Speaker Programs using Cegedim OneKey and Nucleus360 (now IMS Health). Applications included AHM/Centris (Salesforce), Cvent, SCS, Meetings Analytics and Physician’s World. After payment for services were made, the data was integrated into a commercial data warehouse, Campaign Management, and Sunshine Act/Aggregate Spend Reporting.
• Researched Big Data architecture and technologies from Teradata/Aster, ParAccel, Vertica, Cloudera, MarkLogic, Apache Cassandra, MongoDB, Spark, Attivio, Tamr, Composite Software, Denodo, MarkLogic, Cast Iron Systems, Talend, OKTA and Ping Identity
• Led reviews with other Architects to ensure compliance with Enterprise Architectural standards and best practices, and presented and communicated to project and functional leadership at all organizational levels. Became a certified Enterprise Architect in 2012.
• Provided technical leadership, management and guidance to development teams on architectural and design patterns for BI/Reporting projects. This included Metadata Management, Data Integration, Data Quality and Data Governance, “Big Data”, Business Intelligence, Analytics and Data Mining.
• Managed an R&D Data Architecture initiative to ensure global data, metadata and governance standards were consistent, integrated and linked and met industry and regulatory requirements.
• Standards included OpenCDISC (ODM, SDTM/SDTMIG, ADaM), DIA models for clinical study documents. Medidata Rave and Validator for study data collection and risk-based monitoring. CDISC SHARE/ SOASoftware metadata repository and Define-XML, and XML-Exchange for clinical study data submission to the FDA.

Technology: Confidential PureData for Analytics (formerly Netezza), Linux, SAP, Oracle, Microsoft SQL Server, SAP PowerDesigner, Informatica, SAP Business Objects, QlikView, Tableau, SAS, SPSS,Windows Server.

Confidential, East Hanover, NJ

Database Designer, Database Developer, DBA

Responsibilities:

• Optimized over 75 Oracle databases and queries. For each case, performance increased 2-30-fold avoiding costly hardware investments. Optimizations frequently led to some level of database redesign. Received over 35 business s and recognition for the s. Became an Oracle Certified Professional in 2005.
• Created efficient physical database designs in support of functional requirements. Resolved data integration and performance issues. Designed efficient indexes and fine-tuned physical database characteristics.
• Converted 10 Microsoft SQL Server eMarketing brand site databases to Oracle with minimal redesign. Received a business excellence team for the .
• Minimized DBA resource costs and increased Oracle and Microsoft SQL Server database efficiency and performance by automating installation, administration, trouble-shooting and proactive monitoring capability.
• Trained and mentored 3 Oracle DBAs on Microsoft SQL Server architecture to provide additional support coverage.

Technology: Oracle, Microsoft SQL Server, ERwin, Cognos, Microstrategy, Netgenesis, Peoplesoft, LIMS, Siebel, Ariba, SAP, iMany, Sun Solaris, AIX, Windows Server.

Confidential, NJ

Database Designer, Database Developer, DBA

Responsibilities:

• Designed and developed an international multi-language market research database.
• Increased performance 30-fold by implementing Sybase IQ and optimizing ad-hoc, low cardinality queries.
• Implemented Sybase Replication for warm standby.

Technology: Sybase, Microsoft SQL Server, Embarcadero ER/Studio, Sun Solaris, Windows Server.

Confidential, Secaucus, NJ

Database Designer, Database Developer, DBA

Responsibilities:

• Designed and developed a data mart that provided business information to the U.S. travel, tourism and meetings industries. By using a metadata driven design, the data mart, ETL and application development costs were reduced by 50%. Received recognition and s for database design s.
• Worked with Expedia's database team in 2000 to publish Cahners’ data mart business content on Expedia’s site

Technology: Microsoft SQL Server, ERwin, Windows Server.

Confidential, Oakbrook, IL

Database Designer, Database Developer, DBA

Responsibilities:

• Designed and developed new database objects for Sybase and Microsoft SQL Server.
• Replicated a product master in real time to 30 Sybase databases using Sybase Replication Server.
• Identified and resolved database contention by using several architectural features new to Sybase at the time, including page density, data caches, large I/O, table partitioning, fill factor and solid-state RAM to manage tempdb for sorting and other resource intensive operations.
• Increased Sybase performance 20-fold, and table locking became virtually non-existent through a combination of query tuning and database design. Received an Confidential employee of the year in 1997 for Sybase performance s.

Technology: Sybase, Microsoft SQL Server, ERwin, SDesignor (now PowerDesigner), Popkin Software (now Confidential Data Architect), Sun Solaris, AIX, Windows Server.