Brian WU
Lead Data Engineer at Prudential Financial- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
AWS Certified Data Analytics Specialty
Amazon Web Services (AWS) -
SAS Certified Advanced Programmer for SAS9
SAS Institue -
SAS Certified Base Programmer for SAS9
SAS Insititue -
• AWS Certified Machine Learning Specialty
Amazon Web Services (AWS)
Experience
-
Prudential Financial
-
United States
-
Financial Services
-
700 & Above Employee
-
Lead Data Engineer
-
Mar 2015 - Present
Focused on both AWS cloud and SAS to build ETL pipelines, big data processing, reporting, data wrangling and led or worked on multiple projects. Data Engineer, USBIE Data Journey, Prudential (July 2017 to Date) Mapping raw-zone s3 source data ingested from mainframe to preload-zone s3 bucket. • Consulted with architects and product owners to discuss/design ETL solutions, data architectures, etc. • Worked on POCs and optimized ETL solutions. • Led and successfully launched USBIE first ETL project that used Spark Data Frame to replace Spark SQL for simplified coding and easy maintenance especially for hundreds even thousands of nested Json struct-fields. • Restructured pipeline config-file architecture to read in config-file as PARAMETER for both Spark SQL and DF. • Developed a new solution to resolve Glue job OOM issue. Provisioning preload-zone s3 bucket data to Redshift cluster warehouse tables. • Integrated boto3 and Python Psycopg2 into Glue ETL job Spark scripts to execute redshift COPY/UNLOD and SQL queries. • Built Glue ETL job pipelines to work on Redshift cluster tables and s3 bucket data to create redshift external tables or materialized views. Project Manager, Individual Life Insurance (ILI), Prudential (Mar. 2015 to Date) Performing data modeling and data delivery by extracting, exploring, wrangling, preprocessing, and loading for analytics, modeling and reporting teams. • Developed and maintained marketing reporting master pipeline on Hadoop. • Created and maintained monthly corporate sales reporting process using Hadoop/SAS. • Using Python, Spark and SAS to call Oracle Cloud Eloqua APIs to build PRU ILI email campaign data pipelines. • Developed a complicated SAS process to parse an Excel file containing 100 plus worksheets and 10000 plus of PRU ISG dynamic changeable online life policy underwriting rules and create Python scripts on the fly for online application API calls. Show less
-
-
-
Fannie Mae
-
United States
-
Financial Services
-
700 & Above Employee
-
Financial Data Engineer IV
-
Dec 2014 - Mar 2015
As a data engineering and programming lead, worked on ELRM data model restructuring (one of the several complicated FNMA models). • Used SAS SQL, Data Step, SAS macro and shell scripting to restructure and resemble 75 financial data pipelines to meet US SEC and Treasure new requirements and reduced execution time from 10 hours to 4 hours. • Led a contractor, worked with more than 20 business partners and PCAs, followed up SDLC to design, document, code, and test and validate all the processes and launched the pilot version in 3 months. Show less
-
-
-
JPMorgan Chase & Co.
-
United States
-
Financial Services
-
700 & Above Employee
-
VP/Sr. Data Engineer
-
Oct 2012 - Nov 2014
• Led on Master Reporting data warehousing ETL, QC and optimization and automation. • Consulted with LOB managers to define reporting and analytics data models. • Worked on development, optimization and recoding for 200+ daily reporting data pipelines. • Integrated complex SAS macros, SQL and shell scripting to optimize Mortgage Loan Service DASH reporting and PPT generation. • Developed production control system using AutoSys and Control-M including check points, data set lock and event email notice. Show less
-
-
-
American Express
-
United States
-
Financial Services
-
700 & Above Employee
-
Manager/Sr. Data Engineer
-
Jul 2011 - Oct 2012
• Led on Amex campaign system execution, restructuring, and MIS reporting development. • Restructured/automated 400+ data pipelines for Amex New Member Targeting which reduced monthly execution time from 160 hours to 50 hours. • Developed department data mart and Amex campaign MIS using complex SAS macros, windows batch scripts, SAS parallel processing, VB scripts. • Working with Finance team, Decision Science team daily to design, test and update risk and response models, conduct business impacts analysis, etc. • Worked on Expanding Targeting Base project using Discriminant Analysis to get FICO missing members into campaign. • Built capabilities for monthly campaign MIS reporting and PPT generation automation. Show less
-
-
-
OAKLEAF CONSULTANTS LTD
-
United Kingdom
-
Construction
-
Sr. Financial Data Engr. /SAS Consultant
-
Jan 2010 - Jul 2011
Worked with FDIC DRR Loss Share Data Analytics Team: • Developed Loss Share Certificate Data Warehouse ETL pipelines. Performed variety source data ingestion, cleansing, processing, aggregation, and dashboard/report design. The raw data ingestion could automatically sweep bank submitted Excel Certificates from share point, handle hundreds of different spreadsheet formats, create SAS data sets, perform data validation and de-dup, populate data to data warehouse and create ETL loading reports. • Designed single family and commercial loan level UPB and Assets aggregation and visual mapping system, which includes Short Sale, Loss Sale, Foreclosure, Re-structuring and Active loan value. These visual analytic maps are part of the monthly and quarterly FDIC CFO and Chairman Reports for failed banks. Worked with Fannie Mae BAnD Team on Home Price Forecasting Analysis (HPFA) Data model. • Worked with modelers on HPFA production system to automate model validation and reporting development. • Implemented National Local Market House Price Forecasting output validation, reporting and charting. Worked with Fannie Mae HAMP writing complex SAS macros and VBA macros to implement automated HAMP reporting based on US Treasury requirements. Finished reporting projects including: • HAMP CFO Report. It includes 25 sub-reports of HAMP high level CFO summary for Loan numbers, LTV, DTI, UPB, and the performance of contract servicer. • HAMP Incentive Accruals Report. Wrote SAS macro to report incentive accruals to US Treasury for all servicers, borrowers and investors. • HAMP Performance Monitoring Executive reporting (PME). This PME project has total 15 reports. Writing SAS code and VBA macro and using SAS/DDE to automatically validate system generated HAMP data and deliver to US Treasury. • Trial to Permanent Loan Conversion Access Database Dash-board design. Show less
-
-
-
American Express
-
United States
-
Financial Services
-
700 & Above Employee
-
Sr. SAS Data Engineer (CDI consultant))
-
Apr 2008 - Jan 2010
Worked with Amex Credit Score team, CCSG risk team, Web channel team and Campaign Delivery Team on following projects: • Worked on Balance Transfer (BT) risk score model and scoring management. Improved ETL time from 17-CPU-30-hours to 17-CPU-5-hours for 30 million customer base. • Restructured dynamic Card Member Segmentation and Aggregation Model for target analysis by using SAS Macro, SQL, and MS Access, VBA. • Performed CRM and Customer Acquisition Data Mart optimization. Predict card member behavior to execute cross-sell strategies; forecast the likelihood of card member attrition to identify customer retention strategies and actions, especially for high value card members; review credit score models to assure appropriate credit risk variables are included for acquisition; based on campaign target, identify and optimize mail list, campaign strategies and reduce campaign cost; develop automated target analysis tools from prototype to production system using SAS macro and VBA. • Worked on Amex Web Channel Offers CLIC Events Logistic Regression Analysis. Developed card member response score model. • Participated in Restaurant Recommend project. Through using induction rules, optimized algorithm, clustering and association analysis to recommend card members the best restaurants within his/her reachable distance. • Conducted Marginal Contribution (MC) models restructuring and optimization. • Worked on Contact Analysis project. Integrating multiple marketing channel information to find over or under contacted card members to explore potential profit opportunities and service improving strategies. • Worked on Amex Voice-of-Customer Dashboard and Modeling project. Two Phases project. Phase one designed a dashboard to integrate card member’s behavior data, risk information, call center data, and customer feedbacks of Amex survey mail. Phase two applied logistic regression analysis to quantify the main factors that drive customer satisfaction. Show less
-
-
Community
