Learn Data Skills
Beta

David Milillo

VP, Data Engineering

Marketsmith Inc

Technologies

My Portfolio Highlights

My New Track

R Programming

My New Course

Introduction to Python

My New Track

R Programming

Data philosopher, pondering the mysteries of existence through statistical analysis.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to R

course

Introduction to Python

course

Introduction to SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Understanding Artificial Intelligence
Understanding ChatGPT

My Work Experience

Where I've interned and worked during my career.

Marketsmith, Inc. | Jan 2019 - Present

VP of Data and Development

N/A

Marketsmith, Inc. | Jan 2017 - Present

Director Of Development

• Lead team of database developers in creation of data models, database/ data storage architecture, and Extraction/Transformation/Load and ELT processes to enable data feeds and data quality assurance processes to support proprietary data analytics platform • Manage development team queue and communicate with VP/EVP level in order to establish team goals/priorities and monitor progress • Research leading edge technologies and evaluate vendors in order to identify innovation opportunities • Design and development of data models, data layer objects (tables, views, stored procedures, and functions) and ETL/ELT processes (SSIS) to support analytics and reporting (OLAP), and application development (OLTP) using Microsoft SQL Server (2012) and Azure SQL DB/DW • Administration of Azure and Amazon Windows Services cloud environment • Peer Review of Code, provide estimates of work assigned, and assist data analyst in on boarding client and resolving complex data issues
Show More

i.Predictus | Oct 2015 - Jan 2017

BI Developer

• Troubleshoot performance issues with i.Predictus platform • ETL Modifications (Change Existing or New Development) • Peer Review of Code • Provide estimates of work assigned • Assist data analyst in on boarding client • Assist data analyst in complex data issues • Design database objects • Modify Pre-ETL definitions

RevSite.com | Mar 2015 - Oct 2015

Director Data Management

Evaluation and implementation of IT infrastructure and data solutions. Design and development of OLAP model/cube within Microsoft SQL Server Analysis Services along with the design and development of Snowflake relational database within Microsoft SQL Server to support the OLAP model along with associated ETL packages using SQL Server Integration Services Administration of cloud based infrastructure: Microsoft Azure web apps, virtual machines, storage accounts, Azure databases and severs, DriveHQ, Office365 and Exchange online Report creation and maintenance within SQL server reporting services Data integration with Salesforce, Stripe and Authorize.Net billing, Google Analytics into SQL server databases and SQL server analysis services using SQL server integration services and Jitterbit Deployment of web sites across multiple Kentico CMS environments. And configuration of DNS records and purchase of custom domains within GoDaddy and Wix

RCG Global Services | Aug 2014 - Mar 2015

SQL Server Developer

Responsible for the maintenance and enhancement of a SQL Server data warehouse via the development of Extractor ETL SQL applications.

Wellness Corporate Solutions, LLC | Nov 2013 - Jun 2014

VP, Enterprise Information Technology

N/A

Gain Capital | Feb 2009 - Oct 2013

Manager, Business Intelligence and Information Support

Working from within the Data Services team I provide business intelligence and reporting solutions to senior management and the heads of operations from within every business unit, providing both hands-on development and support with leadership over junior members of the business intelligence and information support sub-teams.

Pinpoint Solutions | Nov 2003 - Oct 2008

Senior Analyst and Database Developer

Performed as project lead and account lead for analysis, development, and support on multiple concurrent projects for clients and platforms through the full project life cycle including requirements and scope analysis, development, testing, performance tuning, and implementation. Supported projects including large account policy pricing systems with complex calculations and large data volumes and data warehouses with hundreds of millions of transactions. Designed, developed, and supported extremely multidimensional ROLAP/OLAP Business Intelligence and reporting solutions with hundreds of measures and over 120 dimensions. Responsible for transaction data sets related to submissions, quoting, pricing, binding, issuing, registering, and ETL into data warehouse/data mart for actuarial, claims, financial, marketing, underwriting, and pricing insurance functions. P&T

JPMorganChase | Apr 2000 - Aug 2003

Lead Developer - Associate

Responsible for support/maintenance of highly customized PeopleSoft 7 system. Administer system life cycle for all issue resolution and enhancements. Analyze user requirements. Utilize PeopleTools. Modify/ create reports. Create Sybase stored procedures, tables, views, and triggers. Build and schedule UNIX shell scripts. Evaluate and utilize non-standard tools like: Actuate, Access, and Excel. Maintain operation of process scheduler/application server in all three environments. Administer security for development/testing environments.

Sybase Inc | Jun 1997 - Mar 2000

Staff Consultant

Responsible for database change control between application versions and creation of release scripts. Evaluated DataStage for usefulness for extraction from TP database into IQ. Prepared data for extraction into IQ. Ran and maintained extraction C programs and shell scripts. Prepared data in IQ for Whitelight (PowerDimensions) reporting. Worked with SQL Server System 11.0, performing Transact-SQL programming. Performed data conversion using stored procedures and cursors. HP-UX Korn Shell and PERL scripting used heavily. Responsible for redesign and implementation of payment sub- model. Teamed with application developer on redesign and implementation of accountant sub-system. Utilized P&T skills in tuning queries and index analysis. Participated in extensive training involving classes in Sybase SQL Server, Adaptive Server, IQ, and Open Client/Server programming. Received CSP DBA and Performance and Tuning Specialist certifications on System 11.

HOLON Inc., Kyoto, Japan | Sep 1995 - Mar 1996

Programmer Trainee

Drexel Co-Op program assignment. Developed C programs for testing hardware designed by company. Created demonstration programs for hardware to be used by customers. Performed document translation and wrote new user manuals in Japanese.

Ishikawajima-Harima Heavy Industries Inc., Tokyo, Japan | Oct 1994 - Mar 1995

System Development Trainee

Drexel Co-Op program assignment. Developed an Inventory Accounting System using COBOL on IBM Mainframe to examine amounts spent on projects in progress. Produced applications to run on my division's local area network. Wrote specifications and user manual for new applications.

My Education

Take a look at my formal education

B.S., Information SystemsDrexel University | 1997

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free