Xiu Li Huang

** ***** *** ****: 917-***-****

Belmont, MA 02478 Email: advi3m@r.postjobfree.com

OBJECTIVE:

To obtain a challenging position in a high-quality environment where my resourceful business experience and technical skills will add value to organizational operations.

PROFESSIONAL SUMMARY

Over 10 years’ data analysis and Data Loading experience in banking, insurance, and financial industries with advanced SQL, SAS and other Reporting tools

SKILLS

Languages: SQL, Python, SAS, C#, MDX(SSAS), HTML, VBA, shell-scripting,

Database: Teradata, SQL Server, Oracle, MS Access, MySQL, DW

Reporting: SSRS, Tableau, Power BI, Crystal Report, SAP BO BI, Advanced Excel

Operating System: Unix, Linux, Windows 98/2000/NT/XP

WORK EXPERIENCE

Santander Bank (Boston, MA 10/2016 – Current)

Senior Analyst, Business Intelligence and Reporting

Achievements:

Work with business stakeholder, IT, Project Managers and QA Team to develop and manage offer projects to CRM service, improving the cash offer function and reducing the number of manually care case to 20%

Responsibilities:

Served as liaison between development, business, and product team successfully to bring internal applications, systems to market, directly test, deploy, and deliver software.

Responsible for parsing complex consumer and business data to deliver meaningful, actionable business insights and strategic guidance to business partners.

Assist Digital Marketing and Business Insights Manager by extracting and manipulating data to create quantitative analysis, reporting and presentation that visualizes the data into actionable insights that inform and provide recommendations on high-level decision-making and strategy.

Perform Credit, debit card and lending Consumer Data investigation, analysis, reconciliation, consolidation, and migration.

Provide analyses and build dashboards to identify trends/insights and formulate recommendations that will influence business decisions.

Create, synthesize, and present customized data requests, transforming data into a story that informs both high level strategy and tactical decision-making.

Conduct Acquisition/Engagement Marketing email/onsite lead generation (A/B testing, etc.) based on available consumer behavioral data.

Database Analyst

Achievements

Successfully fixed SSIS package issues, reducing the loading time from over 1 hours to 8 minutes for customers data from SAS to SQL Server

Responsibilities

Develop, modify, debug, and execute SSIS Package to extract data from SAS and load it into SQL Server Database for further data analysis and Reporting. (SQL, SSIS)

Participate in establishing an operating structure that supports all reporting needs (weekly, quarterly, ad hoc) and maximizes the effectiveness of analytics enablement, delivery, and governance. (SQL, SAS)

Provided daily DSC reports to District Sales Coordinators about the updated branch network team member assignments in P&M system.

VISION Government Solutions (Northborough, MA 07/2013-08/2015)

Senior BI Developer/SSRS Reporting Developer

Achievements

Work with IT, business stakeholder and Project manager to develop data warehouse involved more than 10 programs and >100 analytical SSRS reports on a monthly base.

Training co-workers to use SSIS package and create SSRS reports.

Initiated and completed automation for more than 6 projects with SSIS package, reducing average monthly production run time from 1 week to 2 hours per month.

Participated in sizing, coding, testing and final deal closure for The Acquisition Florida project – a $2.5 million contract.

Responsibilities

Created Logical & Physical Data Modeling on Relational (OLTP), Dimensional Data Modeling (OLAP) on Star schema for Fact & Dimension tables using Erwin.

Developed SSIS Packages to extract data and load into Data Warehouse (DW) for further Data Analysis and Reporting

Responsible for SSRS Report Server and entitle users and groups to view and download reports in Report Server, Web Server, and Team Foundation Server (TFS)

Created all kinds of ad hot reports based on clients’ requirements using SSRS and Power View

Provide SSRS/SSIS related tech support.

Performed custom bidirectional data mapping based on client requirements and business documents and translated into technical specifications.

Morgan Stanley White Plains (White Plains, NY 04/2012-05/2013)

Financial Data Analyst Consultant

Achievements:

Modularizing production programs with advanced SQL coding for easy change-making and maintenance

Created monthly/quarterly QMPR reporting automation version for Sr. Management, reduced running time from 2-3 weeks to 2-3 hours.

Identified the weaker parts of the current data system and provided a most efficient, cost-effective method toward the best interest of the company.

Responsibilities:

Participated in developing, monitoring, and implementation of Marketing data warehouse modules, data retrieval and reports creation to serve multiple marketing channels.

Created monthly/quarterly QMPR reports using SSRS.

Generated monthly ADI/PWM/PM/ reports using Tableau.

Created daily/weekly/monthly sales reports using SAP BO BI, Crystal Reports.

Developed SSIS Packages to extract data and load into sales data warehouse and pursued data cleansing and auditing.

Utilize VBA script to update customer information.

Responsible for departmental mainframe user entitlement to enable users and groups to view reports and set up automatic delivery.

CERTIFICATES AND TRAINING

SAS Advanced Training (SQL and Macro) 06/2016

SAP BO BI training in 05/12

Crystal Reports training 07/06

Oracle SQL training in 10/05

SQL Server training in 09/04

SAS Base Programming Certificate (10/2018)

LOMA Certificate (2005)

EDUCATION

Master of Management Science, University of Hamburg Germany 2004

Master of Management Science, Tong Ji University Shanghai, China 2003

B.A. German Literature, Beijing International Studies University, Beijing, China 2000

LANGUAGES

English, German, Chinese

Contact this candidate