Tony Lew

*** * ***** ***** ***

Los Angeles, CA *0013

acwlp5@r.postjobfree.com

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