SUMMARY:

• Determined strategic vision and implemented various Big Data and Cloud - based projects, including No SQL, New SQL, RESTful, microservices, and AWS technologies.
• Managed the design and construction of numerous Data Warehouse /Data Mining applications managing billions of dollars of inventory and transactional volumes with sizes of up to 50 Terabytes and over 500 tables.
• Provided oversight and direction to Data Quality and MDM initiatives.
• Hired and managed teams of developers, database administrators, and business analysts with annual budgets of up to four million dollars.
• Served as development lead, gathering requirements from senior corporate stakeholders and key customers and vendors while communicating with and managing development teams.
• Delivered high-level executive presentations and strategic recommendations, comprehensive information architecture designs, detailed functional specifications, fully elaborated conceptual, logical and physical data models, and sophisticated managed metadata environments.
• Experienced with a large range of Big Data and Data Science technologies and Predictive Analytics, including development of sophisticated statistical models to predict customer behavior by increasing marketing lift and improving customer Lifetime Value, and performed Multivariate (AB) Testing to maximize the revenues from customer interactions.
• Created Search Engine Optimization (SEO) internet advertising campaign which dramatically increased click rates and significantly improved search engine rankings.
• Extensive experience in Technology Strategy, including the evaluation of potential purchases, application architectures, business partnerships, outsourcing relationships and “build or buy” decisions.
• Performed management consulting services, which included interviews, white papers, development of service offerings, and presentations.
• Provided competitive analysis of Big Data industry for Wall Street investment banks/
• Command of accounting systems, analytical forecast methods, balance sheet analysis and capital budgeting techniques.
• Responsible for the successful launch of new newspapers, magazines, newsletters and television shows as an author, editor and producer.
• Collaborated on several business plans for proposed start-up ventures.

TECHNICAL SKILLS:

TOOLS: Designer by Oracle, Erwin by Computer Associates, Corporate Modeler by CASEwise, E/R Studio and DBArtisan by Embarcadero Technologies, Aginity Workbench, Power Center by Informatica, SSIS, SSAS and SSRS by Microsoft, Hadoop, Volt DB, Dynamo and Red Shift by Amazon. Mongo DB, Cassandra. Toad by Quest, Prospero by Oberon, Power Designer by Powersoft, Google Analytics, SAS, R, Site Catalyst by Omniture, Crystal Reports by Seagate, Business Objects by Business Objects, Siebel Analytics by Siebel, OBIEE by Oracle, IBM Cognos and Data Stage, Informatica Power Mart, Pentaho Kettle Data Integration Tool, Harte Hanks Trillium, Information Builders IWay and Web Focus, and Hyperion. Visual Studio, Enterprise Manager and Project by Microsoft; Rational XDE and Rational Rose by IBM.

DATA ENVIRONMENTS, OPERATING SYSTEMS, AND ERP PACKAGES: Oracle 11g, Oracle Exadata, IBM DB/2, Sybase System 9, Hadoop, Netezza PureData System for Analytics, Informix Dynamic Server, MySQL, Microsoft SQL Server 2014 and Azure SQL Data Warehouse, Teradata Warehouse, and Enterprise DB. AWS (Amazon Web Services), IBM Bluemix and MS Azure IaaS technologies. Windows, Linux and UNIX operating systems. Oracle Retail, Oracle Financials, PeopleSoft, JD Edwards, IBM Information Server QualityStage, IBM InfoSphere MDM Server, Initiate and Collaborate Server.

PROFESSIONAL EXPERIENCE:

Confidential

Enterprise Data Architect

Responsibilities:

• Worked on several projects involving the use of the Netezza data warehouse appliance: provided technology assessment, system architecture analysis, and purchase recommendations; developed data warehouse applications; and advised Wall Street hedge funds with competitive analysis of the Data Warehouse Appliance market, especially as regards to Netezza, Vertica and Red Shift.
• Advised several startup clients on Big Data and Cloud-based technologies issues, especially regarding technology selection and recommendations for potential hires. These included NO SQL and New SQL technologies such MySQL, Hadoop, MS HD Insight, Spark, Dynamo, Red Shift, SciDB, Volt DB, AWS (Amazon Web Services), data mining algorithms, and the “R” programming language. Assisted in the design and development of highly scalable web services-driven, cloud-based, applications using Big Data technologies, including using the Python language, RESTful architectures, JSON, and cloud-based web hosting services such as Microsoft Azure VM and RackSpace.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for overall design, development and delivery of NextGen, a Software as a Service (SaaS) application deployed on the Microsoft Azure virtual machine, which enables health care payers to quickly and inexpensively manage Medicare Advantage health care member plans. Data Architecture included a “legacy uplift” data lake environment to move all operational capability to a common code base and a data warehouse application to distribute such key subject areas as Member, Provider, Claims, and Finance to Business Intelligence analysts and Data Scientists. The application was deployed on the MS Azure VM using MS Azure Data Warehouse and SQL Server 2014. Embarcadero ER/Studio was the database design tool, Informatica Intelligent Cloud Services was the data integration environment, with MS Power BI for self-service data exploration and SSAS for analytical reporting.
• Worked with top management from Visiant, Confidential of Michigan, Accenture and W3R Consulting to develop strategy and approach for NextGen, including overall database design, MS Azure technology stack, ETL development approach, Data Lake strategy, and framework for Business Intelligence. Requirements were gathered using Agile methodologies, including data modeling sessions, interviews with key stakeholders, source system analysis and profiling, white papers, and project documentation as part of an Agile project management approach. Managed a team of database developers, database administrators, business intelligence analysts and a MS Azure Dev Ops group.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for overall design, development and delivery of EPIC BILL, a Big Data project integrating EPIC Clarity clinical and financial data, PeopleSoft compensation data, and industry data sources. This data warehouse application focused on measuring efficiencies in the hospital environment, including subject areas such as claims, payments, procedure service mix, and physician compensation calculation. The project was delivered on IBM Netezza PureData System for Analytics appliance, with SSIS as the ETL tool. Over 50 stored procedures were migrated from SQL Server 2012 and refactored to run on Netezza. Standardized reports and self-service data discovery was provided via Cognos. Prototyped a private cloud solution which included Hadoop, Hive and Spark. CA Erwin was the database design tool and development was done via bash command line scripts and the use of the Aginity Workbench tool.
• Worked with top company management from the MGH Physicians Billing Office, eCare ( the Partners EPIC delivery team), and the DevOps group to devise strategy for overall enterprise data warehouse design, technology evaluation and vendor/tool selection, formulation of enterprise data standards and best practices approach, MDM strategy, and database design and development, including data integration strategy .Worked extensively with IBM pre-sales engineering team to insure that Netezza best practices were observed and that implementation was customized for the specific MGH environment. Gathered requirements though data modeling interviews, source system analysis and profiling, white papers, and project documentation as part of an Agile project management approach. Managed a team of database developers, database administrators, business intelligence analysts and systems engineering DevOps team.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for overall design of V10, a Computer-assisted Mass Appraisal (CAMA) next generation SaaS platform, using RESTful services, Web API, JSON, HTML 5, ESRI ArcGIS, and SQL Server 2012. Prototyped public cloud SaaS solution with MS Azure SQL Server 2014 database and .Net Framework. Data model was generated using ER/Studio by Embarcadero. Key focus included creating an Information Architecture to capture the appraisal generation process, including definition of parcels, geospatial characteristics, capture of building and property structures, generation of appraisals, assessments, and handling of abatement requests and exemptions. Queries were generated which mapped ESRI attributes to existing parcels and provided a multi-layered special analysis of applicable demographic, environmental, and economic characteristics.
• Worked with key customers, top management, including product management group, internal assessors, technical architecture team, and information architecture group. Determined overall approach, standards and best practices, tool selection, architecture framework, product requirements, development approach, and product roadmap. Requirements were gathered using Agile methodologies, including Sprints, data modeling sessions, and interviews with key stakeholders, and methods for migrating from legacy platform were developed. Managed a team of database developers and database administrators, information architects, system engineers, project managers and business analysts.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for development, design and data transformation for Transition Manager, a SaaS workflow management application which manages data center migrations. The tool was both used internally, and licensed as an application used by most of the largest IT consulting firms in the world. Key focus included areas such as asset inventory management, move plans based on dependency analyses, and determination of differences between new and existing assets. This application was initially deployed in a LAMP (Linux, Apache, MySQL, and Python) environment and then repurposed to AWS (Amazon Web Services) using RDS (Relational Database Services) with MySQL and Red Shift for analytical reporting. Database design was developed using CA Erwin. Difference analysis and incremental loads were implemented via Pentaho Data Integration (aka “Kettle”) transformations and jobs. Salesforce was the CRM tool.
• Worked with top management from TDS, senior IT management from clients and license holders, including executive sponsors, chief architects, and product management group, to determine define TM application functionality, tool selection, database design, data movement strategies, Master Data Management strategy and implementation, and change management approach. Managed a team of developers, database administrators, DevOps system managers, project managers and business analysts. Development was managed using agile methodologies, facilitated by architectural discussions, white papers and specifications, data modeling sessions and ETL design reviews.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for overall development and database design for GEM, a cloud-based SaaS hotel reservation and property management system. GEM used partitioned database technologies to support ecommerce web services, which was compliant with Payment Card Industry Data Security Standard (PCI DSS). Development involved integrating new functionality to an existing reservation system, including Master Data Management functionality. The application was deployed via Oracle Exadata 12c database instances for OLTP and PostgreSQL for reporting.
• Worked with top management from parent Sabre organization and Confidential team, including executive sponsors, chief architects, and product management group, to determine standards and best practices, development approach and methods, and data requirements. Development was managed using agile methodologies, including use of epics, stories and tasks. Data requirements were determined via analysis of user interface, profiling of existing databases, and data modeling sessions with key stakeholders. Managed a team of developers, database administrators, business analysts and coordinated releases with project management team. Application was deployed via Web Services using IBM’s Infrastructure as a Service (IaaS) Bluemix cloud technologies, restful methods, Tableau for reporting, and a partitioned database strategy. CA Erwin was the modeling tool.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for overall scope, methods, standards and development approach for the Enterprise Information Services SaaS application, an enterprise master data hub which delivered, via an enterprise service bus, unified messaging across all state departments and business units, as well as for individual residents and businesses. EIS is a technology independent model of key enterprise data, and the first stages included generating messages for the Confidential and Registry of Motor Vehicles, whose applications included client-server and mainframe applications. These messages allow for quick response to questions such as “Is an individual or organization current in all its taxes?”, and “Does an individual have outstanding driving tickets?” The database model was created in CA Erwin, the database target was Oracle 11g, OBIEE was the reporting tool, and message application was TIBCO Rendezvous.
• Worked with top management from Confidential, Registry of Motor Vehicles, and enterprise modeling group to create an approach to gather key enterprise information. Collaborated to create a standards and best practices specification, devised approaches to applying business rule constraints, and came up with database application design, including Data Model, SOA messaging specifications, MDM approach, ETL Strategy, Source to Target Mappings and creation of an Enterprise Metadata Repository.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for delivery for Periscope's SaaS solution, BuySpeed, for the Commonwealth of Massachusetts, especially regarding migration of legacy procurement system. Devised canonical messages, authored source to target mappings, ETL coding and MDM implementation via PL/SQL, and coordinated with testing and validation and verification. Used CA Erwin as the modeling tool, Oracle 11g as the source database and SQL Server 2012 as the target database, ETL was performed via views in Oracle developed using Toad for Oracle.
• Worked with top management from the Commonwealth or Massachusetts Operational Services Division, Confidential, Accenture and Periscope to develop approach for delivery of the BuySpeed application, including phased releases, functional mapping, and data integration and MDM strategy. Managed a team of developers, database administrators, business analysts and coordinated releases with project management team.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for a series of initiatives to implement sound Data Management capabilities for Confidential, which manages a $30 billion endowment for Harvard University. These included Big Data initiatives and Predictive Analytics solutions. Created a series of applications to increase effectiveness in measuring and improving Risk Management. Used Bitemporal Data methods to optimize trading desk activities and provide greater insight into Portfolio Manager performance relative to benchmarks for a series of financial products including Hedge Funds, Private Equity, Property, Agriculture, Venture Capital, Stocks, Bonds and Derivatives. PostgreSQL as the target database, Salesforce as the CRM tool, SSAS as the reporting too, Kettle as the ETL tool, reporting via Microsoft SSAS and SSIS, and R was the Big Data analytical tool.
• Worked with top company management to devise strategy for overall enterprise data warehouse design, technology evaluation and vendor/tool selection, formulation of enterprise data standards and best practices approach, MDM strategy, and database design and development, including data integration strategy. Created a consensus around best approach to Bitemporal Data, via presentations, development of specifications and creation of use cases. Worked with Data Scientists to use Big Data techniques to support Risk Management, including Predictive Analytics capabilities, Performance Measurement relative to selected benchmarks, Value at Risk measurement, and Monte Carlo Simulations of likely scenarios.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for overall enterprise data architecture, technology evaluation and recommendation, standards and practices, and database design and development. Implemented overall MDM Strategy, using IBM InfoSphere Master Data Management and IBM Information Server QualityStage. Evaluated technologies for Big Data initiatives, including commercial versions of Hadoop, use of industry models, and data warehouse appliances such as Netezza and Teradata. Oversaw development of Intelligent Confidential t Initiative, a Big Data dashboard, designed using Cognos and SPSS, which provided insight into clinical quality, Confidential t outcomes and quality adjusted cost metrics.
• Lead on Sales Reporting database which integrates data from multiple business units producing medical devises and pharmaceuticals, with JD Edwards and Salesforce as the primary data sources. Created MDM Hub and Data Warehouse databases delivered via Microsoft SQL Server 2008. Responsible for database design and metadata capture using CA Erwin, ETL source to target mappings, MDM processing and report design. Reported to senior Product Management and technology executives

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for design and delivery of Business Intelligence solution which provided analytical insight into Accounts Payable, Accounts Receivable and Purchase Order financial domains, with Oracle Financials and PeopleSoft 9.0 as source systems. Worked with senior members of the Harvard Data Warehouse Group to evaluate potential options, including packaged solutions, third party development proposals, and in-house development, and used this to recommended best approach.
• Captured business requirements, determined reporting needs, profiled source systems, and worked with business users to create an Enterprise Data Warehouse (EDW) application using Kimball Star Schema methods. Created consensus on database design with 15 star schemas and 30 dimensions, modeled using CA Erwin. Authored source to target mappings, designed semantic layer and determined reporting needs. Additionally, defined physical characteristics such as storage, indexing strategy, partitioning and tablespaces. Created project plan and determined resource requirements. The system architecture involved Oracle 11g database, Oracle Financials R12, PeopleSoft 9, Informatica Power Center 9, and Business Objects.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for system architecture and database design for a Pay for Performance (P4P) data warehouse which analyzed clinical records, claims, prescription data and electronic health records (EHR) to assess the quality of Confidential t care using metrics as defined in HEDIS specifications. Worked with senior members of the Confidential t quality group to determine Business Intelligence requirements, which were delivered via an Enterprise Data Warehouse (EDW) application (based on Kimball Star Schema methods), which used sophisticated metadata strategies and complex, modular procedural logic to satisfy the complex reporting requirements using reusable software components. CA Erwin was used as the database design tool.
• Defined optimal system architecture, created database design, devised Data Quality strategy, created Data Governance processes, devised indexing strategy, and physical storage allocation. Determined ETL strategy, created source to target mappings (supplemented by process flow design), defined reporting requirements and reporting metadata layer definitions. The application was delivered on SQL Server 2008, ETL was performed using Microsoft SSIS, and reports were delivered using Cognos. Managed team of developers, business analysts, ETL developers, report writers, and DBAs.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for overall data modeling efforts, including maintenance and upgrades to a 300 table Master Data Management (MDM) Hub and design of canonical messages in a Service Oriented Architecture (SOA) which used an Enterprise Service Bus (ESB) to integrate an Oracle Retail implementation with over 150 existing enterprise applications covering a wide range of business functionality, including product lifecycle management, demand forecasting, and supply chain integration which was compliant with Payment Card Industry Data Security Standard (PCI DSS). CA Erwin was the database design tool. Created overall strategy for data cleansing, including the use of Siperian and the design of foundation data structures to capture and distribute cleansed Master Data throughout the enterprise. Worked with senior members of implementation team (Wipro), key business representatives, and enterprise architecture group, to ensure successful application integration, and to support Business Intelligence requirements. Created Data Governance processes to ensure data quality and correct representation of business concepts.
• Created enterprise data model, captured detailed business requirements, including definition of different product types, identified and remedied data gaps, designed source to target mappings, and created set of canonical messages to implement real-time data integration. The application was delivered on Oracle 11g, ETL was performed via Informatica, reporting was done with Cognos, cleansing was done using Siperian, messages were distributed via Tibco, Salesforce was the CRM tool, and Oracle Retail was the ERP product which was being implemented contemporaneously.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for delivery of Enterprise Data Warehouse (EDW) enhancements to provide supply chain reporting to manage field engineers’ repair jobs for Confidential storage hardware at customer sites. These supply chain tasks were implemented via a third party workforce MDM hub application from Servigistics. Worked with senior members of supply chain team to determine reporting requirements which were delivered via an Executive Dashboard Business Intelligence application (using Kimball Star Schema methods) which integrated results from Servigistics with data from Oracle ERP 11i and Oracle CRM 11i and Salesforce. CA Erwin was the database design tool.
• Created star schema database design, source to target mappings, ETL Process flow diagrams, reporting specifications and metadata layer definitions, and database scripts which included indexing, tablespace creation, and physical storage allocation.. The application was delivered on Oracle 11g, ETL was developed using Informatica Power Mart, and reporting was done via OBIEE. Managed team of developers, business analysts, ETL developers, report writers, and DBAs.

Confidential

Enterprise Data Architect

Responsibilities:

• Worked with C-level executives to provide business intelligence capabilities via Executive Dashboards delivered from an Enterprise Data Warehouse. Provided actionable insights into operational efficiencies, including call center metrics, service level agreement management, and coordination between revenue forecasts, head count projections, and productivity measurements.

Confidential

Enterprise Data Architect

Responsibilities:

• Business Intelligence application (using Kimball Star Schema methods) which is used to monitor the risks of the bank, especially relating to assessing the creditworthiness of financial counterparties. State Street bank has over $200 billion assets under management. Provided measurement on detailed and aggregated exposures, data quality metrics, market risk, regulatory and analytic capital amounts, and counterparty ratings for 14 categories of equity, fixed income and derivative products. Involved understanding sophisticated risk analytic models (including Value At Risk models) and capturing and presenting this information in an optimized dimensional data warehouse model.
• Performed gap analysis against IBM M1 metadata model for financial services. The application was delivered in Oracle 10g with 75 tables, and included physical optimizations such as allocation across tablespaces, partitioning strategy, and index optimization. CA Erwin was the database design tool. ETL was performed by Data Stage and Cognos was the reporting tool. It was integrated with a Siperian-based Master Data Management (MDM) hub which utilized a service-oriented architecture (SOA) and canonical data models for messages.

Confidential

Enterprise Data Architect and Predictive Analytics Analyst

Responsibilities:

• Responsible for overall Data Architecture and Business Intelligence (using Kimball Star Schema methods) initiatives. Created an Enterprise Data Hub to implement Master Data Management (MDM) Strategy. CA Erwin was the database design tool. Created data mart designs to support marketing, product management and finance as well as overall Data Quality initiatives via a Data Governance process, which was compliant with
• Payment Card Industry Data Security Standard (PCI DSS). Gathered requirements, created models, and managed overall data management initiatives. Databases included Netezza, Oracle 10g, Informix and MYSQL, and included over 150 tables. Developed canonical data models for messages and implemented using a services-oriented architecture (SOA) via a Business Rules Engine. Reporting tool was Business Objects and Salesforce was the CRM tool.