Weili Sun

Weili Sun Email and Phone Number

Senior Staff Data and Information Architect @ GE Capital
Arlington Heights, IL, US
Weili Sun's Location
Arlington Heights, Illinois, United States, United States
Weili Sun's Contact Details

Weili Sun personal email

About Weili Sun

Senior Data Architect with over 20 years of experience in data modeling, enterprise data model management, data warehouse architecture, business intelligence and enterprise data architecture. Extensive data management and architecture experience in a wide variety of industries including Credit Card Issuing, Payments and Merchant Network, Mortgage Lending, Corporate Lending and Leasing, Insurances, Airlines, and Manufacturing. Excellent project management, team leadership, mentoring and communication skills. Familiar with the IBM IAA Industry Models for Insurance and the Teradata Financial Services Data Model (FSLDM).• Entity Relationship & Dimensional Modeling • Conceptual, Logical and Physical Data Modeling• Enterprise Data Model Management • Metadata Management• Mentoring, Coaching and Team Building • Master Data and Reference Data Management

Weili Sun's Current Company Details
GE Capital

Ge Capital

View
Senior Staff Data and Information Architect
Arlington Heights, IL, US
Website:
gecapital.com
Weili Sun Work Experience Details
  • Ge Capital
    Senior Staff Data And Information Architect
    Ge Capital
    Arlington Heights, Il, Us
  • Ge Capital
    Senior Staff Data & Information Architect
    Ge Capital Jul 2013 - Present
    Norwalk, Ct, Us
    • Led a team of onshore and offshore DA, ETL and Reporting developers to develop and implement Business Intelligence applications for the GE Capital Americas Commercial team serving 10 businesses of over $90B commercial portfolio and 1,500 sales and marketing professionals. • Successfully implemented a large, complex project that integrated commercial, risk, portfolio and 3rd party firmographic data in the Enterprise Data Warehouse and using the Data Virtualization technology to provide a 360-degree view of the customer to the Sales Representatives. • Provided design guidance and approval to the operational support team on BI enhancement requests and production fixes submitted by the business users, improved the change request turnaround time and reduced reworks. Interviewed, mentored and coached new DA and ETL team members.• Worked with the Big Data Architect to ingest the Marketing and 3rd party data from the Enterprise Data Warehouse to the Pivotal Hadoop Data Lake.• Provided ER/Studio Data Model and Repository management support to the BI Data Architect team.• Led a team of BI data architects and worked with the Archival and Decommission CoE to archive and decommission all the data warehouses and BI applications for GE Capital’s divested businesses.
  • Ge Capital
    Senior Architect - Data Management
    Ge Capital May 2012 - Jul 2013
    Norwalk, Ct, Us
    • Participated in the Enterprise Architecture’s Database Firewall project to rollout Imperva to the Oracle and SQL Server platforms.• Participated in the Leasing Source application data retention and archival project using the Informatica ILM software. Worked with the ETL developers to review and approve the data archival and retrieval SQL Queries used in the Informatica ILM software.• Provided data modeling and database design consultation to the application teams. Assisted the Oracle DBA team to review the database designs proposed by the application teams.
  • Rr Donnelley
    Data Architect
    Rr Donnelley 2006 - 2012
    Chicago, Illinois, Us
    Primary Data Architect for a customer facing Data Mart • Provided data architecture, data modeling and database design support to RRD’s Data Warehouse projects. Created and maintained Logical and Physical Data Models in ERwin/Model Manager. Led the data sourcing effort and create the Source to Target Mapping and Transformation Rule documents for the ETL team. • Conducted data model walkthroughs to both technical teams and business users for each project. • Performed DBA tasks to create and maintain the data warehouse table structures in the Development Database Environment. As each project progresses to implementation, the physical data model in ERwin is used to prepare and deliver the full DDL or change DDL scripts to the DBA to create/change the tables and other DB objects in the QA and Production Environments.• Worked with business users on defining and prioritizing high level BI requirements and translated them into detailed business requirements and data requirements.• Mentored and coached new data architects on dimension data modeling techniques.
  • United Airlines
    Information Architect
    United Airlines Feb 2006 - Dec 2006
    Chicago, Il, Us
  • Caremark
    Data Architect
    Caremark Sep 2005 - Feb 2006
    Woonsocket, Ri, Us
  • Discover Financial Services
    Consultant Data Analyst
    Discover Financial Services 1998 - 2005
    Riverwoods, Il, Us
    • Provided logical and physical data modeling and database design support to Discover’s Business Rules, Cardmember, Customer Services, Marketing, Accounting, Internet and Merchant Network Operational systems.• As the primary data modeler, performed logical and physical data modeling using the dimension modeling techniques (Star Schema) for the Cardmember, Merchant and Customer Contact Strategy Data Warehouse and Reporting systems. Worked with the DBA’s to implement these data warehouse models on Oracle, UDB and Teradata databases. Assisted the Data Warehousing ETL team in defining the data source-to-target mapping and transformation rules.• Worked with business users during the project proposal and business requirements gathering phases to define the detail data requirements. Conducted data model walkthrough sessions to both business users and technical teams (DBA, ETL and programmers) to validate the database designs.• Provided training and mentoring to new and junior data modelers on both data modeling and data warehouse designs. Documented advanced data warehouse modeling techniques for cross training within the Data Analysis and Modeling team.• Led internal data analysis infrastructure projects such as Data Modeling Tool Conversion, Major ERwin Releases Testing and Data Analyst Handbook Development. As a key contributor, participated in setting the Data Modeling and Data Administration standards.• Provided Data Architecture consultation and made Data Architecture recommendation to application teams.• Participated in the company’s Data Dictionary Repository project to provide Meta Data Management requirements and performed User Acceptance tests. Worked with clients, IT management and IT staffs to establish and maintained consistent data element definitions across computing environments.
  • Kemper Insurance
    Data Modeler
    Kemper Insurance Jan 1996 - Mar 1997
    Chicago , Il , Us
  • National Steel Corporation
    Data Modeler/Data Administrator
    National Steel Corporation Feb 1993 - Dec 1995
    Detroit, Michigan, Us
  • Data-Link Systems Inc
    Data Administrator
    Data-Link Systems Inc Jan 1991 - Feb 1993
  • University Of Wyoming
    Instructor, Computer Science Department
    University Of Wyoming 1988 - 1989
    Laramie, Wy, Us

Weili Sun Skills

Data Modeling Data Warehousing Business Intelligence Database Design Etl Databases Business Analysis Dimensional Modeling Oracle Data Analysis Data Management Data Marts Data Warehouse Architecture Db2 Logical Data Modeling Erwin Sdlc Physical Data Modeling Er/studio Data Profiling Web Services Data Integration Sql Informatica Mentoring Team Building Team Leadership Coaching Teaching Data Mapping Teradata Metadata Management Spotfire Enterprise Data Modeling Enterprise Data Architecture

Weili Sun Education Details

  • Southern Methodist University
    Southern Methodist University
    Computer Science And Engineering
  • National Taipei College Of Business
    National Taipei College Of Business
    Computer Science

Frequently Asked Questions about Weili Sun

What company does Weili Sun work for?

Weili Sun works for Ge Capital

What is Weili Sun's role at the current company?

Weili Sun's current role is Senior Staff Data and Information Architect.

What is Weili Sun's email address?

Weili Sun's email address is wl****@****ail.com

What schools did Weili Sun attend?

Weili Sun attended Southern Methodist University, National Taipei College Of Business.

What skills is Weili Sun known for?

Weili Sun has skills like Data Modeling, Data Warehousing, Business Intelligence, Database Design, Etl, Databases, Business Analysis, Dimensional Modeling, Oracle, Data Analysis, Data Management, Data Marts.

Who are Weili Sun's colleagues?

Weili Sun's colleagues are Nigel Swyer, Leila Morales, Sergio Ivan Araiza Eguia Liz, Derek Wood, Kameela Mcclinton, Alex Fagnano, Deborah C Vargas.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.