Sean Wu, Software Developer in Cary, NC, United States
Sean Wu

Software Developer in Cary, NC, United States

Member since June 18, 2020
Sean is an expert in database design and development with a focus on in-house application development. He is ready to support executive decision making and production improvement processes for businesses of any size.
Sean is now available for hire

Portfolio

Experience

Location

Cary, NC, United States

Availability

Part-time

Preferred Environment

Microsoft SQL Server

The most amazing...

...database I've designed was for a high-secure organization requiring serial number production with no duplication.

Employment

  • Data Modeler

    2018 - PRESENT
    Blue Cross Blue Shield NC
    • Designed and created database models for enterprise-wide projects.
    • Created tables and views.
    • Performed data analysis.
    • Completed R&D for new technology.
    Technologies: Star Schema, Entity-relationships Model (ERM), Teradata, Excel 2016, Windows, C#, Tableau, Python, SQL
  • SQL Developer

    2019 - 2020
    McKeil Marine (via Toptal)
    • Developed a business oriented database on Microsoft Azure from scratch.
    • Created all tables based on business needs.
    • Created complex stored procedures to meet business requirements.
    • Created complex views.
    • Created triggers.
    Technologies: Entity-relationships Model (ERM), Azure SQL, Excel 2016, Windows, SQL
  • Database Developer and Administrator

    2010 - 2018
    CCL
    • Designed, created, and managed primary objects such as tables, triggers, database links, indexes, and privileges based on a logic design model.
    • Developed all the required stored procedures, user-defined functions, and dataset results in reporting services to reduce code complexity and optimize performance.
    • Developed applications for manufacturing efficiency improvement.
    • Created conceptual, logical, and physical data models for creating the schema using MS Visio and ER/star/snowflake schema for data marts.
    • Applied technical skills using SQL, Excel in data collection, data analysis, and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.
    • Contributed to building business dashboards to conduct trend analysis on sales metrics especially relating to driving sales revenue, customer retention, and production.
    • Tuned, troubleshot, evaluated, and recommended database hardware and software including support tools to increase performance.
    • Provided support to developers for integrating development environment (C#) into databases.
    Technologies: MacOS, Software Development, .NET, Microsoft Access, Excel 2016, Microsoft Visual Studio, C#.NET, SQL Server 2016, SQL Server 2014, SQL Server 2008, Windows, Snowflake, Star Schema, Entity-relationships Model (ERM), Visio, Data & Backup Management, Microsoft SQL Server

Experience

  • Production Control Portal

    This is a web-based internal portal for
    1) employees logging their working hours to work orders
    2) supervisors logging in to run reports and modify incorrect data entry
    3) executive team logging in to run production-related reports for decision making
    4) sales team logging in to enter new or potential sales opportunity
    5) viewing of production real-time dashboard

    It is made with ASP.NET, using C# on the front-end and Microsoft SQL Server on the back-end.

  • Business Oriented Database

    The client needed a website for trip planning. I created the database on the back end from scratch, including logical model design, physical model deployment, table and view creation, and complex stored procedures design and creation to meet all business needs.

  • Marine Voyage Tracking System

    I worked as a database developer to create the entire database, including tables, views, triggers, and stored procedures for a web-based marine voyage tracking system for a marine transportation company. The database is on Microsoft Azure.

Skills

  • Languages

    SQL, T-SQL, C#.NET, Snowflake, Python, C#, Java, Python 3
  • Platforms

    Windows, Amazon Web Services (AWS), MacOS
  • Storage

    SQL Server 2016, SQL Server 2008, SQL Server 2014, Microsoft SQL Server, Azure SQL, Azure SQL Databases, Teradata
  • Other

    Software Development, Entity-relationships Model (ERM), Star Schema, Data & Backup Management
  • Tools

    Microsoft Visual Studio, Excel 2016, Microsoft Access, Visio, Tableau
  • Frameworks

    .NET

Education

  • Master's Degree in Information System
    2007 - 2009
    University of North Carolina at Greensboro - North Carolina
  • Bachelor's Degree in Computer Science
    2002 - 2006
    Zhengzhou University - China

Certifications

  • AWS Certified Cloud Practitioner
    MARCH 2021 - MARCH 2024
    Amazon Web Services
  • Microsoft® Certified Solutions Expert: Data Platform
    MARCH 2017 - PRESENT
    Microsoft
  • Microsoft® Certified Solutions Expert: Business Intelligence
    FEBRUARY 2017 - PRESENT
    Microsoft
  • Microsoft® Certified Solutions Expert: Data Management and Analytics
    JANUARY 2017 - PRESENT
    Microsoft
  • Microsoft® Certified Solutions Associate: SQL Server 2012/2014
    DECEMBER 2016 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others