Data Architect

Professional Summary

Experienced over ** years of IT experience with in-depth expertise in technology architecture and engineering. Jun has a proven track record in building and leading results driven architecture practices. Jun is specialized in working with the full lifecycle of APIs. Expert in working with API Gateways, Enterprise Service Busses and Service Orchestration using Mulesoft also specialized in the data architect of data systems, strategies and business processes operational data store and warehouse models for new reporting customer.

Experience

Inspire Brands

Enterprise Solution Architect/Mulesoft Architect Minneapolis, MN 03/2018 – present

As the team, integrated one single ERP system (Oracle Cloud), one Human Resource Information System (Workday), new business intelligent analytics platform, utilize the integration toolset with Mule4

Established the enterprise standardization, devops process

Worked as Mulesoft Architect, defined the project scope, strategy, designed the right pattern to reuse for multi brands, ensured the delivery satisfies business requirement and follows the enterprise standardization

Socialized various business teams to convince using right tool to business value and results

Mentor and lead the internal and vendors development team

Buffalo Wild Wings Minneapolis, MN 06/2016 – 03/2018

Integration Architect /Mulesoft Architect

Defined Integration Strategy and solution Architecture for Mulesoft CloudHub implementation

and AWS cloud environment.

C4E (Center for Enablement) implementation, creating C4E process, API standards, guidelines and best practices. Aligning roles and responsibilities for C4E process. Patterns for MuleSoft and Spring Boot. Providing training and guidelines to partners.

Working as a MuleSoft Subject Matter Expert (SME) for Architecture and Design of the project, utilize the integration toolset with Mule3

Developed integration implementation plan, integration inventory, API and ESB interfaces

Worked on setting up VPC and VPN between AWS cloud, Mulesoft Cloudhub and Buffalo Wild Wings Network

Delivered 20+ ESB interface / API using MuleSoft ESB, Amazon SQS/SNS Messaging platform and Common Integration framework on AWS Cloud

Technology Used - Mulesoft Anypoint Studio, Mulesoft Cloudhub, AWS SQS/SNS, AWS Cloud, TFS, Maven, Jenkins. Azure Devops

Buffalo Wilds Wings Minneapolis, MN 07/2014 – 06/2016

PDW Data warehouse Architect

Architect and design MS Big Data PDW data warehouse and Azure database, architect enterprise BI solution and involve the data analysis

Works with Business manager to establish BI roadmap

Architect and design PDW database to facilitate over 10 TB data warehouse

Engage in concept discussions, proposed technology solutions to meet business goal

Provide strategic influence across groups, projects and products to implement cost-effective technology solutions to solve complex business problems

Engage with senior leadership to articulate opportunities, costs, and risks associated with decisions made around the platform architecture and implementation

Hands-on experience of SSIS, SSAS,PDW administration work

Architect and design Azure SQL Server.

Architect and design visualization tool: power BI stack, Tableau, R studio.

Connextion Loyalty Travel Solution Minneapolis, MN 02/2012 –07/2014

Application DBA, Data warehouse Architect

I am a Data Architect responsible for all aspects of all transactional, warehouse; charge all the data migration and database design from phase to phase; database design upgrade, data migration and database deployment

Designed database objects for web application project

Responsible for Database configuration and upgrade in all environments

Participated SQL Server project management and deployment in TFS

Involved in data modeling and schema design for data warehouse project

Architected and hands-on complicated SSIS, SSRS, SSAS

Mentored team members on Data Warehousing concepts, best practices, and principles

Implemented processes performance bottlenecks and defining performance

Developed and tuned up complicated T-SQL stored procedures

Wrote Data retention and archiving project

Maintained SQL Server security, backup and restore, logging shipping, replication.

Wand Corp Minneapolis, MN Sep 2009 - Aug 2011

Senior Enterprise Data Warehouse Developer

Responsible for the design and development of an enterprise data warehouse among over 50 different databases, tuning the enterprise data warehouse including database tuning, query tuning, ETL tuning and re-modeling; developed end user report with Silverlight 4.0

Defined the overall data warehouse architecture (Data model, ETL process)

Collected technical requirements

Architected data model with Aquadata modeling tool

Designed and developed the ETL process, including data quality and testing

Defined metadata standards for the data warehouse

Architected, designed and implemented Reports management portal with SSRS

Equus Computer System Minneapolis, MN 2006-2009

Senior Database Developer and team lead

Responsible for the BI infrastructure in roles ranging from Data modeling, ETL Development and Report generation

Collected business requirements, architected data model

Designed ETL process (SSIS) to implement data modeling.

Customized ETL process with .NET program, migrate data from Access to SQL Server

Designed and developed SSRS report, running against data warehouse

Defined and designed from scratch the data warehouse architecture, database, ETL

Charter Solutions Minneapolis, MN 2005-2006

Java Program Consultant

Worked with Financial client closely to improve and upgrade billing system.

Designed, developed second phase of billing system using Java with Ideal tool;

Developed applications with Struts Framework, implemented JDO with Castor;

Designed and improved performance tuning SQL Server, SQL Scripts

Einsof Minneapolis, MN 2003-2005

Java Developer

Developed, implemented and deployed websites in various platforms. Responsibilities included:

Developed a Web Application project Using Java with JBuilder;

Designed XML for EJB development descriptors, Ant Build Scrip;

Designed and implemented AXIS web service cross various platform;

Configured load balancer to cluster parallel servers;

Deployed, and tested with JRun, Apache Tomcat server at Linux and IIS

Developed a Web Application project Using Java with JBuilder.

Technical Skills

Solution Architecture and Design with hands on experience using Mule Soft ESB/ API-led connectivity/ Microservices, WebMethods Suite (Webmethod developer, Modeler, Administration, Broker), AWS SQS/SNS

Microsoft PDW DBA (about 1 year)

Power BI, 2 years, Tableau (6 month)

Microsoft SSIS (10 years), SSRS (10 years), SSAS (8 yeas)

Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling. EDW, OLTP, MOLAP, ODS, Metadata Management

SQL (10 years), PL/SQL (2 years), Stored Procedures (10 years), Triggers (10 years), Packages (10 years), Transaction Processing (10 years),Access DB (3 years)

NET (10 years ) Java (3 years), R (about 1 year), Python (about 1 year)

MS Project (12 years), Visio (12 years)

Windows, Linux, UNIX (Sun, HP)

Visual Studio 2012/2010, Team System

Education:

1995 BS Tianjin Medicine College Tianjin China

2003 MS Software Engineer University of St Thomas St Paul MN

Contact this candidate