Post Job Free

Resume

Sign in

Principal Solution Architect

Location:
Allen, TX
Posted:
March 13, 2023

Contact this candidate

Resume:

Page * of *

DAVID HUANG

Allen, TX *****

advvx8@r.postjobfree.com

EXPERIENCE SUMMARY:

Over 25 years experience and master degree in information systems & Technology

Architectural and functional design of database and application systems for on-premise and cloud-based solutions

Object-oriented analysis with Business Process Model and Notation (BPMN) and UML

Enterprise integration systems (Azure Data Factory, MuleSoft, Datahub & IBM WebSphere ESB)

Software solutions in Salesforce CRM & sales/partner community cloud, etc.

Software solutions in financial/banking industry to cover retail, wholesale, and correspondent mortgage businesses.

Software solutions in health insurance, LMS learning industry

Integrating B2B and B2C e-commerce portals with back-end ERP systems for supply chain businesses.

Business analysis to create functional specifications for optimized business processes

Budget process & estimation and management of external & internal resources on projects.

Market basket analysis, strategic and tactical sourcing on supply chain.

Logistics and warehouse management systems for detail process of inventory, forecast, procurement, sales, receiving, staging, put away, storage, routing, picking, packing, shipping, etc.

Provisioning, confirmation distribution and billing systems for massive data and VoIP telecommunication networks.

Scheduling tasks, prioritizing deliverables, allocating resources and measuring performance

Certified solution architect and advanced scrum master for development of business solutions CERTIFICATION:

EDUCATION:

University of Michigan, USA

Degree: Master of Science - Specialized in Information Systems & Technology in Business Services 2007 North China University of Technology, China

Degree: Bachelor of Engineering - Specialized in Computer & Automation 1992 KNOWLODGES & SKILLS:

Cloud: AWS, Azure DevOps, JIRA, Confluence, Salesforce, DocuSign, MS Office 365, etc.

Databases: RDS (Aurora, SQL, Oracle, Sybase, MySQL), NoSQL/DynamoDB), In-Memory, etc.

Project: FAP, SDLC, Agile, Stage Gates, Budget/Cost, Scope, Timeline, Resources, DevOps, etc.

Agile: Scrum, Kanban, EPIC, Feature, User Story, Bug, Defect, Task, Sub-Task, etc.

Conference: Teams, WebEx, Zoom, UberConference, Skype, etc. SAFe Advanced Scrum Master Scaled Agile® Credential ID (2023): 421*****-****

AWS Certified Solutions Architect - Associate Amazon Web Services (AWS)

Credential ID (2020):

GVYLX46KP1B41X3K

DEVOPS200.9x: Architecting Distributed Cloud Applications Microsoft Credential ID (2018): 834f06961c0a439ebae47a18

d57845d8

Scrum Master Accredited Certification International Scrum Institute™

Credential ID (2016):

797***********

Page 2 of 4

EXPERIENCE:

TCS/Thomson Reuters, USA [ Aug 2018 ~ Present]

Solution Architect / Agile Coach

Responsibilities:

Act as a leader of cross-functional software development teams

Culture transformation of development teams from traditional waterfall SDLC to scaled agile framework

Product owner responsibilities for successful product delivery of Trust-tax and Tax information reporting

Monitor daily scrums, stand-ups, and meetings to ensure progress of projects and mitigation of issues

Create project outlines and timeline and distribute responsibilities to team members

Oversee design, implementation, QA, and validation of programming code and products

Provide detail guideline for the best practice under the scaled agile framework for enterprise (SAFe®)

Manage scaled agile release planning to match with milestones and deadlines

Dashboards and reports for supporting cases during tax season

Build strong relationships with stakeholders, application users, and program owners

Document progress and communicate to upper management and stakeholders

Perform reviews on software development team members

Tax forms volume program management

Project:

Lotus program transformation with Salesforce project teams from Lead to Support (Campaign, Lead, Opportunity, Quote, Contract, Order & Entitlement, Production & Shipping, Invoices & Accounts Receivable, Support & Services) with focusing on Professional Services Enterprise Technology Solution stack (Salesforce CRM Sales & Service Cloud, Financial Force PSA, Einstein, APTTUS CPQ, DocuSign, Contract Express, Eloqua, Microsoft Flow, Informatica, Dell Boomi, SAP Hana, etc.)

CheckPoint Learning LMS (Virtual Seminar, Self-registration, WebEx integration, Gear-up Repacking, CCPA, etc.)

LearnLive Migration to AWS Cloud Docebo LMS (Learning Management System)

Agile/scrum platform upgrade on TFS and migration to Azure DevOps (ADO)

Salesforce GTAX support cases management.Salesforce reports and dashboards for both classic and lightning experience

AWS auto scaling parallel processes for 1099 import, filing, and reporting

.

Pacific Union Financial LLC., USA [ Oct 2016 ~ Jul 2018] Solution Architect / SM

Responsibilities:

Architecture design to integrate mortgage systems in promises and cloud (AWS, Azure, Mule, etc.).

Produced architecture diagrams for data/process flows, sequence of processes crossing banking systems, etc.

Executed proof of concept (POC) with Azure as cloud solution for projects.

Customized functionalities in Salesforce and created POC in community cloud.

Modernization and integration of cloud solutions (Salesforce, AWS, Azure, Mule, etc.).

Ensured QA/QC and user acceptance testing for deliverables

Product owner of JIRA & Confluence to evaluate new plug-ins & products and manage subscriptions

Improved SDLC process with stage gates and agile development

Mentored and trained internal and external resources with agile framework in projects

Utilized Confluence for business and technical documentation, utilized JIRA to manage project scopes & activities, utilized Portfolio in JIRA to report and track high level initiatives.

Customized workflows, dashboards, and functionalities in JIRA for scrum and Kanban.

Organized and managed scrum ceremonies for multiple teams Projects:

TPO (Third Party Origination) portal on Salesforce partner community cloud for B2B wholesale brokers. (Azure container instance, API connector, Event grid subscriptions, Microservices, Angular framework and React library)

Documents routing to eDoc FileBound and Capsilon DocVelocity via API (MuleSoft) and SFTP. (Azure storage accounts, Key vaults)

Treasury tracking for warehouse funding of mortgage with Bank of America/Merrill Lynch, Barclays, UBS, Texas Captial Bank, EverBank, Santander, JPMorganChase, Western Alliance, etc. (.NET & TestExecute Automation)

Exceptional pricing approval process (SharePoint)

ClientXpress portal app for wholesale and correspondent client administration (.NET & Azure)

Migration of legacy client management systems to cloud (Salesforce & Azure Data Factory) Page 3 of 4

Rate sheet builder and Margin Management with integration with LOS (Loan Origination System) (.NET & AWS EC2)

Pricing calculation based on the 2nd market data feeds

CBS portal app for client billing system (.NET) and Power BI reporting

Uniform Closing Dataset (UCD) integration with Fannie Mae and Freddie Mac Lennox International Inc., USA (NYSE: LII) [ Sep 2013 ~ Sep 2016 ] Business Solution Lead Architect / PM

Responsibilities:

Architecture review with technical teams and functional solution review with business

Vendors selection/vetting processes and management

FAP Planning / budget estimation of projects & representing projects to committee for capital approval

Managing scopes, resources schedule, and budget of projects

Approving timesheet and review billings for both external and internal resources

Collaborating work crossing multiple functional groups/teams

Identifying operational issues and work out solution with vendors

Planning project financials with MS-Excel & Plainview

Agile transformation with JIRA (Scrum & Kanban). Projects:

eCommerce desktop and mobile app portal with Hybris in scrum (AWS EC2 Network Load Balancer, JAVA, Spring boot autoconfiguration)

eCommerce desktop and mobile app portal with SharePoint (Load balanced with F5, AWS EC2 SMTP).

Product & dealer review based on product & rebate registration (Azure storage accounts, Data Factory, No-SQL)

Mobile Applications for iOS, Android. (Xamarin, Azure notification hub)

Integration with SAP, WECO, WebTrends, Salesforce, etc.

User Management Engine (UME) & .NET Applications.

Commercial Quick Quote and Power BI reporting

SAP ECC Upgrade from EhP4 to EhP7

Atoptrade Inc., USA [ May 2010 ~ Sep 2013 ]

Solution Architect / PO

Collecting and analyzing business requirements and creating analysis reports

Writing function and technical specifications. Produced UML diagrams with Visio.

Managing projects using MS-Project and facilitating business user expectations.

Coordinating data feed related activities with domestic and international business and technology groups.

Daily interaction with systems users and application development teams supporting underlying technology.

Constructing Oracle and SQL server databases for projects

Reviewing architecture, business logic and programming code Client: MSC Industrial Supply Co (USA-NYSE: MSM)

Company is one of the nation's largest direct marketers of a broad range of industrial products to industrial customers, satisfying their maintenance, repair and operations (MRO) supply requirements. I created big picture of workflow and managed resources and progress of project. I analyzed material handling processes of inbound procurement & inventory management, receiving, putting away, outbound order, picking, packing, and shipping. I produced business flows, state charts, requirements, functional design, testing scenarios, operation guides, and training documents. I created analysis reports based on history sales data. I did BA work on project with scrum teams for agile software development. Some code review for RPG and CL.

Project: Hazardous Material Handling Process on AS400

Working with multiple departments of ESH (Environmental, Safety & Health), PSST (Product Sales Support Team), Logistics, Product Management, CFC (Customer Fulfillment Centers), QA (Quality Assurance), and IT development.

Map out current processes, states. Identify and introduce key functions to manage handling processes according to regulation (Compliance) with concerns of tracking, assignments, alerts, etc. to minimize the risk of operation. Project: Web-based Sales Operation Environment (WSOE)

This project is creating new e-commerce website to support sales team to handle complex ordering processes. I created diagrams to streamline entire order process. I wrote functional requirements with wireframes and detail business rules for back order, direct ship, blanket order, and campaign. Page 4 of 4

Global Crossing Inc. USA (NASDAQ: GLBC) [ Oct 2001 ~ Apr 2010 ] Technical Lead / Senior Software Analyst

Responsibilities:

Architecting distributed network/cloud applications for telecommunication systems including VoIP (Voice Over IP)

Worked through the SDLC as business analyst on multiple projects. Modeling UML/BPMN diagrams with Visio

Responsible as projects lead to create technical documentations on SharePoint.

Managed projects with MS-Project for network (data, voice, multimedia) provisioning and billing collection & analysis.

Developed architecture for backbone products and services as a telecommunication carrier's carrier.

Developed good working relationships at all levels and coordination of work processes between departments.

Produced technical architecture, developed and reviewed code in projects. Project: Billing collection systems

Pulling billing data off switches.

Transferring billing data back to central server securely before further processing.

Parse billing CDR (Call Detail Records) for tracing all call information over global telecommunication network

Upload billing information to mainframe (IBM DB2).

Update status of each billing batch on website using trigger and stored procedure to create dynamic tables on Sybase. There were cleanup processes to drop history tables and delete records. Computed columns were used for quick view on website.

Send alarm for missing CDR and other issues. Maintenance was scheduled on UNIX crontab. Most of common scripting languages (shell, ksh, csh, awk, nawk, perl, etc.) were used.

Loss of data, faulty of equipment, failure of network, eavesdrops, and unexpected events are key concerns of risk management process. Tracking, validation, repair, recovery, security processes were implemented. Project: Service Activation Manager (SAM)

Provisioning queuing system was programmed to manage data in priorities. It was equipped with interface to programs in C++ and Java (Spring Framework) for query, insert, update, and delete. It handles hundreds of millions of transactions on many systems daily.

Transaction transport systems transfer large data sets on network expressly and securely. Receiver was constructed for listening requests from network and dispatching events to multiple threads shared pool for dedicated communication channels. Sender gets provisioning data from priority queue and sends data to receiver on another network.

Sequence checking systems monitor each transaction and only valid transaction would be inserted onto queuing system with option of priority adjustment.

Provisioning distribution systems get data from queuing system. It parses pre-defined patterns based on definition on database. Master provision generates transactions for each type of network elements accordingly which includes time controlled multiple cascading loads. Stored procedures and triggers were used on database to minimize communication between front end and back end for better performance.

Confirmation distribution systems ensure acknowledgement from every network elements before notifying originator of master transaction.

Project: Billing IO Menu website (Massive data process)

Authorization by SAP system using API to check with SAP system for authentication of user privilege.

Track billing processing pipeline – Webpage was developed (in HTML, ColdFusion, PHP, JSP, JavaScript, CSS, etc.) for presenting status of each billing collectors on our network worldwide.

CDR search engine - It’s webpage for NOC (Network Operation Center) or customer service department.

Remote control of billing processing programs – Easily trigger billing process manually on webpage.

Reload billing from switch - Manually pull billing from switch without technical background.

Restore history billing and investigation process - Easily locate archived billing and restore data for detail information.

Created analysis reports based on data warehouse from CDR/billing history. Project: Pulsar web provisioning system

Validation systems and connection to SAP - Real time.

ColdFusion webpage checks live provisioning data on Sybase.

Provisioning transaction constructor manually generates transaction on webpage.

Activities reports provide information for tracking and auditing for operational risk management.

SharePoint was brought in to manage contents and documents. We developed intranet portals (homepage) for different teams, added organization structure, project sites, search functions, forms, and business processes.



Contact this candidate