Technical Lead - Data Engineer Resume SAN FRANCISCO, CA - Hire IT People

PROFESSIONAL SUMMARY:

Over 15 years of technical experience working with financial, customer and marketing data.
5 years of experience using Big Data tools as a data engineer, data analyst and applications developer.
Successful track record and ability to design and build solutions using Big Data solution stack that includes Hortonworks, Python, AtScale, HiveQL, TEZ, Spark, and Tableau.

TECHNICAL EXPERIENCE:

Platforms: UNIX, Windows, IBM MVS

Databases: Hadoop: Hortonworks and Cloudera, HP Vertica, DB2, Teradata, MS SQL Server

Languages: Python, Shell, SQL, SAS, MatLab, R, VBA, Focus, JCL, Syncsort

Software: AtScale, Tableau Server, Tableau Desktop, Business Objects, Cognos

Data Vendors: IBM Clickstream, Bloomberg, DataStream, FactSet, Ibbotson, Thomson Reuters

PROFESSIONAL EXPERIENCE:

Confidential, SAN FRANCISCO, CA

Technical Lead - Data Engineer

Responsibilities:

Designed and build out Marketing Analytics Data Mart that provides an enriched data layer that supports numerous analytic and reporting processes across the Marketing organization; predictive analytics, customer segmentation, forecasting, planning, site merchandising, web analytics and Tableau development.
Data mart reduces the complexity for analysts to use the data providing easier and quicker turn around for custom analysis.
Managed Tableau Server Administration and upgrade analysis.
Managed POC engagement and presented proposal to acquire AtScale, BI Solution on Hadoop software.
Managed implementation, deployment and .
Improved accessibility to data for analyst community.
Enabled the use of BI tools; Tableau and Excel, using live connection and no data movement.
Built custom Digital Marketing Channel Attribution models that support numerous analytic and reporting processes.
Built Customer Segmentation and OmniChannel data models to support customer behavior analytics.

Confidential, SAN FRANCISCO, CA

Technical Business Analyst

Responsibilities:

Application support lead for Confidential Pharmacy Rebate Manage system and data mart.
Managed system enhancement projects, translating functional requirements to technical specifications.
Provided research and data analysis to identify customer rebate and campaign trends.

Confidential, CONCORD, CA

Technical Business Analyst

Responsibilities:

Developed worklow automation solutions and reporting to improve company expense management operations in US, APAC and EMEA.
Provided tier 1 - 3 application support for Market Data Platform.
Designed and built application to allocate, charge and track payment for Market Data Vendor invoice expenses to corresponding Domestic and International office cost centers.
Application processed an average of $60 Million in expense management monthly.
Improved processing time by 90% resulting in over 40 work hour reduction per month.

Confidential, Orinda, CA

Performance Analyst

Responsibilities:

Support Lead for global performance measurement system.
Identified and designed solutions to improve system processes for the Global Performance team.
Migrated Portfolio Account Net of Fee system from MVS to Windows platform.
Processing time improved 90%.
Centralized benchmark index return database procedures to Americas office.
Improved latency from 10th business day to 3rd business day each month.

Confidential, San Francisco, CA

Performance Measurement Analyst

Responsibilities:

Managed reporting composite and investment performance attribution processes for investment strategies: global tactical asset allocations, fixed income, global alpha, overlay and indexing strategies.
Developed automation to stream line index return validations and custom benchmark calculations.
Performance Reporting applications improved reporting time from 1 hour to 15 minutes.

Confidential, San Francisco, CA

Advice Performance Analyst

Responsibilities:

Managed the production and distribution of Executive Management dashboards and Investment Performance measurement reports.
Managed internal mutual fund database required for investment models and financial research.
Managed the production and scheduling of SAS and Matlab Programs to update research datamart and update Schwab research reports.

Technology Solutions Associate

Confidential

Responsibilities:

Managed and supported mainframe productions processes and mutual fund databases.
Developed new reporting production jobs using JCL, Syncsort and Focus.
Managed and delivered adhoc reporting and financial data analysis requests for mutual fund products.