Worked on information designs for a retail assortment planning process using a Domain Driven Design framework

The initial scope of this position was the design and construction of an enterprise-class data warehouse to serve two purposes: consolidate disparate reporting data sources to arrive at a "single version of truth", and establish a direct link between customers and sales data in order to provide insights into customer behavior. This latter aspect led to the design and implementation of a campaign management system to manage direct- and e-mail campaigns - the CMS was designed to work with data warehouse data to support the customer segmentation that determined campaign effort recipients. This also involved creating analytical work product (models, charts and graphs, and full-blown analysis reports) used by client departments to evaluate the contact pool and to measure campaign response.• Designed the data warehouse using dimensional modeling techniques and installed physical schema in PostgreSQL• Implemented ETL to populate data warehouse (both initial load and daily updates) using Pentaho Data Integration• Designed and implemented Campaign Management System schema and installed in PostgreSQL. Operated the ``headless'' version while waiting on application development• Wrote specification for the CMS application, directed Armenian engineering team during buildout• Performed analysis of customer behavior mainly for direct/email marketing; developed RFM, Markov-chain-based LTV, and customer/donor cluster models in R• Provided technical and project direction to Armenian team (4 engineers); tutored all BI team members in various techniques (Pentaho, SQL, R); spearheaded the establishment of a Big Data practice in our Armenian office, specified demo/training projects in Spark, Mahout, Kafka and Neo4J that later evolved into production applications.• Developed SQL functions and type structures in PostgreSQL / PostGIS to facilitate standardizing and geocoding of mailing addresses

Responsible for design integrating the enterprise data warehouse with the Unica CampaignManagement System to support the Expedia Rewards customer loyalty program. Also designed two “customer dashboards” (customer-level summaries of transaction behavior), and specified the ETL that was implemented by an off-shore organization.

Identified data sources for the data warehouse, validated the data, designed warehouse schema elements and specified the ETL necessary to move the data from source to data warehouse. Assisted members of other teams with analytical modeling problems. Examined new technologies for possible use. Explored the potential use of MapReduce in our Data Warehouse environment both as an ETL tool and as a possible delivery solution Assisted UX manager setting up Social Network Analysis software (Pajek) to explore connections between people and user contributed content; obtained data for the analysis Assisted UX manager in obtaining metrics and BI reporting to produce a “user experience quotient” for the website

Supervised a team of 2 data engineers, 1 database administrator, and up to 4 contract data engineers to construct the enterprise data warehouse Delivered first phase of the data warehouse within 6 months of accepting delivery of DW hardware and ETL software. Instituted data warehouse standards including naming conventions and design guidelines and coverage for DW operations; specified operations manual content and format Managed transition from Microsoft SQL Server to Netezza for data servers, Microsoft DTS, to Informatica for ETL, and stand-alone, per-report data structures to dimensionally modeled data structures. Introduced the Located-Content modeling technique as a key BI design tool Improved relations between Reporting and Analytics and the IT systems and network administra-tion team Key member of the data mining software selection team

Built and maintained the marketing / business intelligence data warehouse and OLAP environments. Designed multi-dimensional cube (MDC/OLAP) structures and the backing store that fed them, and developed the ETL processes that supplied the structures with data. Maintenance included substantial system administration work as well. Analyzed impact of major site software re-architecture on legacy reporting and OLAP environment, focusing on customer-oriented data. Analysis led to improved data warehouse and OLAP structures Re-engineered legacy ETL software to enhance data integrity and quality Established documentation procedures, and documented previously undocumented OLAP and datawarehouse data structures Re-engineered database platform to provide for better separation between production warehouse,ad-hoc and development databases which resulted in less potential for data loss.

Responsible for the architecture and implementation of the data warehouse, designed to support corporate, marketing and technical decision making. Designed and implemented the sales transaction data mart. Designed the web page-view data mart. Implemented metadata repository Implemented extract, transformation and load (ETL) support software in Perl.

Responsible for the analysis of client customer data to support marketing needs, and for the development of data warehousing solutions for the client. Member of the management team responsible for the development of the department’s infrastructure Performed segmentation studies of client data utilizing data mining software – authored written client reports and presented oral reports to clients Developed custom dimensional data marts to house client data in preparation for data mining to support direct marketing – one such mart consisted of 3 years of raw, point-of-sale detail data Member of unit management team that evaluated selected and implemented mission-criticalhardware and software infrastructure for the department, including data quality, analytical and campaign management software

Responsible for data architecture of client CRM databases and applications as well as the development of data stewardship and quality standards that were applied to the databases. Worked closely with the Software Development Manager and senior marketing team on the architecture of unified CRM software framework Researched and recommended adoption of Party-Relationship database pattern that resulted in cost savings by eliminating need to perform completely custom modeling of common client situations Developed data standards for databases and client data transfers; trained account team on how to communicate the standards to clients. Assisted Vice-President of Database / Internet Development with development process methodologies and software evaluation

Responsible for the analysis of client’s customer data to support the client’s marketing situations. Also responsible for developing database schemas to store data for continuing analysis and other operations. Clients included Kaiser-Permanente, Premier Resorts, Toto-USA, and the Minnesota Wild National Hockey League franchise. Performed data mining analysis of client customer data, including segmentation and predictive modeling as well as ROI / Lift Analysis of post-model deployment results. Presented oral and written reports to Gage internal teams and outside clients Developed a direct response / campaign management database to support direct marketing efforts Developed several applications with SPSS, evaluated case-by-case feasibility of replacing certainreports with SPSS implementations

Responsible for the development of database schemas, object-oriented client-server applications, ETL software and SQL queries for analysis, reporting and debugging. Specialized in migration of data from legacy or external systems to re-engineered databases. Clients included Polaris Industries, Canon-USA (printer group), Canandaigua Wines, Meredith Publishing, Trus Joist Macmillan, Carrier Heating and Air Conditioning, VCA Veterinary Hospitals.

Developed software in NeXTStep / OpenStep and Perl

Desktop microcomputer administration.

Roasted coffee; coordinated all wholesale deliveries and managed customer billing.

Responsible for admistering administrative data processing batch jobs, printing and forms handling of reports; performed various systems maintenance activities such as backups and preventative maintenance testing.