Data Sap

Wei Qu

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

Lansdale, PA *****

267-***-**** (Mobile)

Email: adc18f@r.postjobfree.com

OBJECTIVE

Senior Technology Lead position in a challenging environment

SUMMARY

Solid experience in data warehouse design and development; Strong knowledge in ETL tool SAP BODS, Informatica, IBM Data Stage and SAP Business Objects BI tools including Central Manager Server, WEB Intelligence and Explorer; and highly skilled professional experience in SAP HANA modeling, CDS View, HANA ALM, SAP SCM, ECC, SAP BW, SLT, Oracle RDBMS and MSSQL Server.

LICENSES & CERTIFICATE

SAP BODS Certificate, 01/2012

SAP HANA Certificate, 12/2011

Certificate in Java Programming, 10/2011

INFORMATICA Certificate, 01/2009

Certificate in Data Warehouse Lifecycle, 08/2004

Oracle Certified Professional, 06/2000

Engineer-In-Training, 05/1994

EXPERIENCE

02/17 – 04/20 Sr. SAP HANA/Business Intelligence Developer, Dorman Products, Colmar, PA

Responsible for delivery and ongoing operation of an enterprise-wide data analytics platform

Build the core HANA data models for SAP Master Data, Supply Planning, Demand Planning, APO, Sales and Distribution, Customer Model for Salesforce.

Follow System Development Lifecycle (SDLC), quality and project management best practices, comply with internal processes related to regulatory or compliance requirements, and adhere to Change Control and Problem Management procedures.

Function as a resource for the development teams for analyzing data and work with the ETL development team for the ETL design and development using SAP BODS

Design and develop complex reports and KPI dashboard using SAP Business Object tools

01/11 – 02/17 Data Architect, Automotive Resource International (ARI), Mt. Laurel, NJ

Worked as a Lead Data Warehouse Architect for HANA EDW (Enterprise Data Warehouse) using SAP Big Data platform, SAP Data Services and SAP HANA Studio to design and develop enterprise data marts for various business areas including Vehicle Fleet Management, Vehicle Inventory, Vehicle Expenses, Vehicle Fuel Analytics Info spaces.

Worked as Lead Data Architect design and develop Dimension Model for Telematics worked with ETL team design the ETL strategy for the warehouse using SAP Data Services and Oracle PL/SQL package.

Worked on design and development of Multiple SAP Business Objects XI Universes for Reporting Team to create BI reporting for AP, AR, GL, Customer Service, Vehicle Acquisition and Remarketing on Data warehouse

Worked as Lead BI team member successfully completed installation and implementation of SAP Explorer; designed and developed Explorer Universe and created multiple Info spaces for different ARI major customers

Created Business Objects Macros to automate the bursting process of important Business Objects reports; and created java program to automatically email distribute the hundreds of BO report results in excel or pdf format to hundreds of corresponding users.

09/05 – 01/11 Senior Technical Analyst, Pfizer Pharmaceuticals, Collegeville, PA

Worked on IMPACT to Right track II Integration Project

Worked with BI team colleagues, successfully designed and implemented the Medical Enterprise Reporting & Logistical Intelligence Network (MERLIN)

Worked as lead developer successfully completed the project that allows system automatically load subject data from the ODS into International Management Package for the Administration of Clinical Trials (IMPACT) and eliminate the manual data entry currently performed by site monitors

Successfully interacted with diverse users/customer base and ensured delivery of top-quality products to meet business needs.

12/02 – 09/05 Senior Application System Analyst, GMAC Mortgage Corp., Fort Washington, PA

Worked on design and development of Proof of Concept, Whole Sale Rate and Price, Security and Administrative universes and reports with Business Object software for GMAC Mortgage sales department

Worked as a member of Data Warehouse team, used ETL tool DataStage created Data Stage Batch Run process, as part of EDAP Reporting Data Mart development for Wholesale Lending Business and for Retail Lending Business

Designed and implemented row-level security in the BO repository

As a member of EDAP Team, I was involved in building Enterprise Data Warehouse by integrating different Data Marts and other data sources.

09/02 - 12/02 Data Warehouse Specialist MasterCard International, O’Fallon, MO

Worked as an independent contractor to help build a Data Mart for MasterCard Marketing Team, and build a Business Objects universe connecting to the Data Mart.

Involved in building MarketScope Application using WEBI SDK

06/99 - 09/02 BO Administrator and Support Specialist, Gemalto, Montgomeryville, PA

Used Business Objects 5 to design and develop universes and reports to make Oracle Applications data available for management, Account Receivable, Account Payable, Sales, Purchasing and Manufacturing departments.

Worked in upgrading and migrating of Business Objects, Web Intelligence (WEBI) and Broadcast Agent Server (BCA), training end-users and planning and distributing reports and decision support tools over the web/intranet

Administrated BO repository including user accounts, universes and documents

12/97 – 06/99 Consultant for client Merck & Co Inc., Blue Bell, PA

Worked at Clinical Trial System Group for Worldwide Clinical Data System (WCDS) Oracle database design and development under VAX and UNIX systems

Created queries, views, stored procedures, functions, and triggers using Oracle SQL and PL/SQL for Clinical Data Management group

Responsible for Y2K remediation of the Oracle database and Clinical Trial System test

01/97 – 12/97 Computer Teaching Assistant, Department of Computer Science, Saint Joseph’s University, Philadelphia.

05/95 – 12/96 Programmer International Computing Group, Inc, Philadelphia.

Performed requirement analysis and completed programming requests for code, test, debug, and system support. Created queries, views, stored procedures, functions, and triggers using Oracle SQL and PL/SQL

08/88 – 06/91 Database Developer/DBA Zhenjiang Foreign Trade Corporation, China.

COMPUTER SKILLS

SAP BODS

SAP HANA

SAP ECC, SCM, SLT, ALM

Informatica Power Center 8.5

IBM DataStage

Oracle SQL and PL/SQL

Visual Basic, C, C++

Java, Java Script

MS SQL Server

TRAINING

Qlik 03/2017

SAP Data Services 01/2012

SAP HANA 12/2011

Java Programming 10/2011

Informatica Power Center 8.5 01/2009

Data Warehouse Life Cycle 08/2004

IBM DataStage 6 05/2003

Java Script 07/2001

Business Objects 5i 09/2000

Oracle Applications 11 07/2000

Oracle 8 DBA 06/2000

Visual Basic 5 09/1998

SQL Server 6.5 09/1998

EDUCATION

MS in Computer Science, December,1997; Saint Joseph’s University, Philadelphia

MS in Engineering, June,1994; Oregon State University, Corvallis, Oregon

BS in Engineering, June,1988; Shanghai Jiao Tong University, Shanghai, China

REFERENCE

Available upon Request

Contact this candidate