Daniel Lopez Email & Phone Number

Greenwood Village, Colorado, Us

Greenwood Village, Colorado, Us

Los Angeles, California, Us

Leawood, Ks, Us

Manager of the Data Engineering team at Replica, a sophisticated data platform for urban planning.

Manager of the Community Growth Data Engineering team, focused on building analytical systems to optimize paid marketing, SEO, acquisition and user identity products.

Set up independent consultancy architecting and developing cloud-based analytical decision support systems, as well as ERP system infrastructure. Project highlights include:*Business Intelligence solution development using Amazon Redshift, MicroStrategy, Talend Studio, Java and Python.*ERP/CRM Platform selection, customization and deployment using ODOO, SugarCRM, Mendix and Python

San Francisco, California, Us

Responsible for developing a set of analytic and operational reporting capabilities for the Aria Cloud Billing and Active Monetization Platform, that provide insights and context via dashboards, analytic, operational and custom reports to accelerate growth while maximizing customer acquisition and retention. MicroStrategy Architect and Developer. Developed dashboards and complex reports and documented their installation, configuration and deployment. Developed a subset of ETL scripts for loading a data warehouse hosted on Amazon Redshift.

San Francisco, California, Us

Technical lead and manager for all Business Intelligence engagements across multiple platforms and verticals at Software Next Door, a provider of software development resources, servicing US organizations from Mexico, specialized in collaborative software development.Project highlights include building sales and marketing analytical solutions that integrate data from traditional OLTP systems, ERP systems, ecommerce platforms, direct marketing tools, ad server networks and third party web analytics solutions. Responsibilities included gathering and managing detailed user requirements, designing, developing and deploying modules across the entire Business Intelligence Lifecycle.Technologies leveraged included: MicroStrategy, SQL Server Reporting Services, Teradata, Oracle, MySQL, Neteeza, Talend Open Studio, SQL Server Data Services, Java and Python.

Sunnyvale, Ca, Us

Carried out analysis for optimizing both acquisition and retention creative media campaigns through the design of creative/audience tests as well as the overall media channel (SEM, Display, Email, etc.) portfolio ROI for the Yahoo! Connected life (Mobile and Broadband), Search, Personals and Flickr businesses by mining both detailed and summarized campaign and user behavior data.Spearheaded the development of a centralized marketing datamart for global Yahoo! marketing performance across all media channels. Drove the data and standard reporting business requirements gathering process, led all user acceptance testing, developed training materials and carried out regular training sessions for both business users and engineering personnel.Remotely managed a team of 4 analysts supporting custom report development and ad server/email database marketing list generation for all Yahoo! properties.Provided instrumentation subject matter expertise for global direct marketing teams.

Sunnyvale, Ca, Us

Set up successful independent consultancy: assignments at Gap, Visa and Yahoo! Helped architect and develop analytical decision support systems that enhanced clients’ ability to identify trends in the purchasing patterns of their client base, to measure the impact of customer loyalty programs on consumer spending and to determine the cost effectiveness of web-based promotional campaigns in attracting and retaining customers. A critical part of my work at all three clients was helping them select the right mix of technologies, technical skill sets and staffing levels that would help meet their project objectives.

Contributed heavily to the design, development, administration and periodic enhancement of an analytical decision support system that allowed senior business analysts at Hotwire to segment and target their consumer base more effectively, optimize pricing across hotel, air and car rental products on a daily basis and measure the impact of the company’s promotional campaigns on demand. Key responsibilities included the development and distribution of highly complex business reports and the training of business analysts in the use of the system.

Led Personify’s enterprise-class implementation team. Key responsibilities included developing deployment methodologies for Personify’s most strategically important products, providing the marketing organization with advice on how to price and approach potential customers, providing the engineering department with feedback on product functionality and performance and coordinating the efforts of consultants testing new products in the field.

Led multi-disciplinary teams in design and implementation of large-scale decision support systems throughout the US, while actively participating in internal initiatives such as business development, sales and training. Was promoted twice, first to Senior Consultant and then to Consulting Manager. Key responsibilities included identifying analytical business requirements, acting as subject matter expert on a number of technologies, mentoring more junior consultants and promoting the company's product and services at a number of industry trade shows and recruiting events in both the United States and Mexico.

Mba, Business Administration

Bsc, Management Information Systems