Principal Solution Architect
Resume:
DAVID HUANG
Allen, TX *****
*******@*******.***
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):
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