Data Engineer
Resume:
Tony Lew
Los Angeles, CA *0013
****.***@**************.***
https://github.com/TonyLew/
https://www.kaggle.com/TonyLew
SUMMARY
Creative solutions-oriented database professional with 10+ years of IT experience in all aspects of data driven solutions.
Highly accomplished, creative and curiosity-driven professional, offering great level of competence in applying advanced optimization and machine learning methods in the analysis of data.
PROFESSIONAL EXPERIENCE
Deep Anchor Data Inc
Data Artist
Mar 2013 to Present
Design solutions to use data to answer questions
Implemented phrase predictor by training an algorithm to identify commonly used words and phrases (NGram) using T-SQL and R.
http://rpubs.com/tone_lew/PhrasePrediction
Illustrate data with interactive reports and graphs along with traditional reporting packages like SSRS and Tableau.
http://rpubs.com/tone_lew/GlobalPopulationDemographics
Enabled historical insight of activities by designing and creating a database event log platform to unify the tracing of events and their classification relating to ETL, data warehousing, reporting and accomodate any future events/functions.
Position ETL solutions to increase the volume and diversity of data sources by strategically using SSIS dynamic packages as well as T-SQL and stored procedures.
Positioned an ETL system for volume and throughput scalability by designing and creating an ETL solution to import data from N separate computer systems in any time zone and in parallel on an automated and regularly scheduled interval using stored procedures. This was a completely T-SQL programmed system using self-discovery in order to simplify the ongoing management and maintenance and SQL Server table partitioning to isolate contention.
Seamless integration of an ETL solution by programmatically using existing SQL Server push and pull replication to retrieve the data of an existing production system, populate a data warehouse, and provide a means for a real time reporting system using stored procedures. This was a completely T-SQL programmed system using self-discovery in order to simplify the ongoing management and maintenance
Designed and facilitated the management and incremental deployment of database code and data using Git repositories and sqlcmd.
Designed and deployed a PaaS solution for development and production environment on AWS EC2 using PostgreSQL and GoLang.
Technologies involved: SQL Server (TSQL, table partitioning, push and pull replication, CLR integration, sqlcmd), SSIS, AWS (EC2, RDS), PostgreSQL, R, GoLang, Tableau, GitHub.
American Standard Television
Data Artist
Nov 2011 to Feb 2013
Designed solutions to flexibly and powerfully deploy set top boxes for optimal control and reporting
Researched and programmed an algorithm to dynamically fill vacant content schedule slots for all times of a day selecting from different pools of content (0-1 Knapsack problem).
Implemented an algorithm to make content recommendations to viewers (K nearest neighbors).
Augmented library of content meta-data by creating an ETL system to assimilate movie and television content meta-data from freely distributed sources (TMdb-JSON).
Designed database with internationalization in mind by storing time zone offsets, use of Unicode, ISO standards of country codes, currencies, and Geo-IP mapping.
Created search engine for set top box as well as back end database system.
Facilitated independent parallel development among team members by scripting entire database along with data, stored procedures, functions, and all objects.
Extensive use of Tortoise SVN to collaborate and facilitate project deployment cycles within an Agile software development framework.
Data modeling and database design of content management system, ETL procedures, analytical reporting database, and set top box.
Collaborated with technical and business leads within the company to forge solutions and manage goals and expectations.
Proactive research and development of database concepts and products along with evolving challenges.
Technologies involved: SQL Server 2012, T-SQL, SSIS, MySQL 5.5, Tortoise SVN, Agile.
EdgeCast Networks
Database Architect
Nov 2009 to Nov 2011
Designed solutions to commercialize the ETL and reporting functions
Designed SSIS packages for rapid deployment to anonymous environments by employing dynamic database driven packages and deployment by SQL scripts.
Created an ETL reporting system in order to quickly and easily identify data flow.
Frequently worked closely within teams in an Agile framework to complete projects.
Optimized DML queries by aligning with table schema and indices.
Contributed to a SQL development best practices guide for non-database personnel.
Ongoing maintenance and monitoring of database operations.
Implemented SSRS interface for company facing site and using production DB.
Introduced a real time component using Python to read Lighttpd web logs in Hadoop and GeoIP data to find geographic location.
Technologies involved: SQL Server 2008, SSIS, SSRS, Hadoop, Python, Agile.
eWorkForce
Database Architect
Sept 2007 to Nov 2009
Designed solutions to leverage data as an asset for clients
Position client OLAP designs to capilize on key facts and dimensions.
Design and optimize ETL processes to capture key data sources in order to fulfill reporting goals.
Redesigned schemas to optimally enable business goals.
(e.g. change current billing process to accommodate multiple billing plans with different business rules)
Monitored and managed resource usage issues, backups, and recommended schema changes where appropriate.
Technologies involved: SQL Server 2005, 2008
MySpace
Database Developer
Sept 2005 to Sept 2007
Ensured optimal database access for performance and scalability
Designed data models and database access strategies to optimize data manipulation and storage.
Managed the stored procedure and T-SQL development to ensure the highest volume of concurrent data access.
Innovated to develop strategies to define best practices for the MySpace environment.
Interacted with developers and project managers to align goals, expectations, and responsibilities.
Solved database query performance problems.
Collaborated on projects within teams using an Agile framework.
Technologies involved: SQL Server 2005, Full Text search, SSIS, Agile.
eWorkForce
Software Architect
Oct 2000 to Sept 2005
Created solutions to address and resolve business obstacles for clients
Architected and created commercial software for clients.
Interacted within teams to ensure successful product usability.
Created a Flash demo for BSS (a fire and life safety company) to be used within the realm of building safety. Extensive use of Actionscript to enable a higher level of interactivity. (November 2003 to December 2004).
Created a Flash scheduling component (version 2) for Custody Calculations (a custody scheduling software company), which interacts with a MySQL database using PHP and Actionscript 2.0 (January 2005 to July 2005).
ASP/VB/TSQL web enhancements and support for Mercury Commerce (April 2001 to December 2002).
Technologies involved: PHP, Apache, MySQL, Flash MX, Actionscript, Flash Components, Flash Remoting, Visual Basic, SQL Server 2000, ASP, SonicWall, Javascript, Java, OLTP and OLAP design.
CarParts Corporation
System Integrator
Dec 1999 to Oct 2000
Commercialized the order fulfillment process
Collaborated with key business executives to reassess and realign IT order fulfillment with business objectives.
Interacted with IT staff of vendors and CarParts in order to successfully plan and design solutions.
Increased the size of virtual inventory in both quantity and depth by automating interfaces to participating vendor inventory systems.
Increased the volume and geography of orders fulfilled by automating interfaces to participating vendor fulfillment systems (B2C and B2B).
Technologies involved: Windows 2000 Server, SQL Server (ETL, stored procedures, jobs, TSQL, OLTP and OLAP design), Visual Basic (COM/DCOM, MTS), ASP (VBScript), Access, XML.
EDUCATION
Coursera Data Science Certificate
May 2016
Citrix Metaframe Certified
Sept 1998
Microsoft Certified Professional
Dec 1995
Bachelor of Science in Applied
Mathematics with Specialization in Computers
University of California, Los Angeles
Jun 1991
Contact this candidate