Enterprise solution architecture for a leading healthcare origanzation. Azure, Snowflake, Google Cloud architecture and hybrid-cloud architecture for data and applications. Design and architect highly scalable proof-of-concept prototypes with machine learning and AI.

Working with one of the largest USPTO contract vendor in Phoenix AZ to architect a FedRAMP compliant environment with complex business processes and secure applications. Perform quarterly cyber security audits on systems, data and application to ensure all controls are in place and vulnerabilities are covered.Design and implemented a remote access application architecture to allow remote users to securely access documents and perform their daily works. Designed and implemented SaaS migration for all users that's working on the USPTO project to Office 365 SaaS environment.Designed and implemented a SIEM cyber security system to proactive protect the infrastructure and alerting any potential cyber threats.

Conduct full technology assessment for the hospital to analyze current technology spending and all hardware * software licensing cost. Completed a 18-month roadmap for technology cost reduction and performance enhancement.Designed new solutions for all hospital software to integrate around the new EHR software (MediTech & AthenaHealth)Designed new billing process for billing and reimbursement with ICD10Designed inventory management system to reduce inventory waste and redundant purchases

Work with C level executive team and technology stake holders to build an IT strategy and roadmap for technology transformation of various high profile applications and systems, including the LIMS system, legacy billing system, API and integration services for 50+ hospitals in the US. Establish baseline and maturity level of various IT and security processes in the organization, including data, application and infrastructure. Develop a cloud migration strategy to move infrastructure and critical applications to the cloud (IaaS and Saas).

Conduct security and architecture assessment review of the company in anticipation to the upcoming expansion of the new drugs. Analyze current security vulnerabilities, controls to prevent intrusion and hacking. Security assessment for the laboratory and research data repository to meet FDA regulations. Designed new security procedures and solutions with expanded infrastructure architecture. Designed a cloud solution and migration strategy for infrastructure, data and application to cost effectively scale the current technology footprint.

Principal solution architect to assess current technology and design future state solutions. Conduct current state analysis to build a technology roadmap for the hospital Design and deploy cloud strategy to reduce cost and deliver better technology services.Perform security analysis and remediation plan to meet HIPAA standardDesign and improve the medical billing process with upgrade to ICD-10Design training and certification management systems for hospital to train and onboard new staff

Design a brand new .NET based web application manage supply chain acquisitions and inventory managementDesign and deploy multiple API and RESTful services to integrate with Microsoft CRM and Great Plains ERPDesign new data model to accommodate complex data exchange between different automotive manufacturer, including GM, TOYOTA, HONDA, FORD, Chrysler Design ETL and data transformation solution to collect and process third party data used in a supply chain application. Design interactive SSRS reports and web based dashboard to replace the static, nightly generated PDF report

Principal solution architect, led a team of other architects to conduct a technology assessment, then build an enterprise wide technology roadmap with future state.Collaborate with senior c-level management team to understand organization’s pain point in technology as well business vision on technologyPerform deep dive with all aspects of architecture in data, application, infrastructure and systems to establish current state baselineBuild consensus with various teams for future state technology architectureCloud strategy and cost analysis comparison between cloud and on-premise designsPerform gap analysis and deliver detailed action plan with maturity level indicator on key organization structuresArchitect solutions for a scalable technology architecture for data storage and application transformations, which includes a mix of legacy POS systems, .Net applications, and REST APIs.

Lead the data and database architecture for CORE project - the next generate loan origination system for Wells Fargo. Working directly with VPs, SVPs and CIOs of Wells Fargo Home Mortgage team. System has been live since 2010.Design and implemented multiple iterations of prototypes which eventually scaled to handle over 300,000 transactions per secondDesign and implemented data warehouse systems with ETL and data transformation to stream data to over 100 other systemsDesign and implemented security and compliance of the system to meet all banking and government regulationsDesign and implemented disaster recovery sites and DLP policies (DLP = Data Loss Prevention)Managed the system implementation of over 50 consultants and 200+ FTE team members

Design and implemented the billing system for a MLM (Multi-level Marketing) system with over 3 million memberships. Design the data model and the underlaying database system using Oracle and Oracle ERP. Managed the development of the data team using PL/SQL and Microsoft SQL server (SSIS and SSRS).

Architect enterprise wide application structure, and working as a lead production DBA for high profile applications. Architect and implementing solutions for highly available, highly scalable and cost-effective enterprise database platform.Architect enterprise solutions for OLTP and OLAP applications, to manage financial, project and contract related dataArchitect multi-million dollars Oracle RAC and 10g iAS infrastructure to meet senior management’s need for a highly available and highly scalable platformCommunicate problem-solving solutions and provide technical guidance on numerous high profile projects involving teams of over 40 IT staffEffectively communicated processes and solutions through VISIO drawings, flow charts, MS Projects and data model diagramsManaged and directed a team of 10 senior DBAs and system administrators for supporting enterprise database applicationsHands-on experience with Sun Micro systems, IBM storage, Oracle 9i and 10g application server, oracle 10g database, Microsoft SQL server, J2EE and Single Sign On (SSO) on Solaris and Windows ServersArchitect solutions to implement clustered database applications with shared storage such as Sun Enterprise SAN, EMC Clarion and Hitachi NAS devices.Manage and track projects involving different departments and customers to consolidate redundant processes and databases across multiple environmentsDevelop thorough documentations and process diagrams for existing applications to senior management and team membersDevelop and maintain enterprise data models for production databasesIdentify applications bottlenecks and design step by step performance tuning solutionsDesign, develop and implement data strategies, including archiving, partitioning and life cycle data managementPropose equipment purchase from different vendors to senior management to meet budgetary requirements

Senior system and client server architect for the Enterprise Data Center Department of a fortune 100 financial company. Support, maintain and troubleshoot multi-terabyte Loan Origination Application and over 4,000 other production databases running on HP, IBM, EMC and Cisco platformsLead data Architect and data modeler for loan origination system at Countrywide Financial Services Architect, installed, configured and maintained infrastructure of Oracle 9i RAC (Real Application Cluster) database serversProvide solutions and supports for over 4000 production systems & applications on IBM AIX and HP platformsSupport multiple local, remote clustered with high availability & fail over designEMC Storage planning for multi-terabyte ORACLE 9i RAC databases using raw devicesArchitect and support database replications using SQL 2000 transactional replication and DataMirror Replication softwareProof of concept testing of multi-million dollar IBM and HP server infrastructure design for high performance applications & databasesArchitect, develop and deploy several terabyte ORACLE 9i RAC (Real Application Cluster) databases with EMC Symmetrix (DMX), using SRDF, SRDFA and BCV for data replication, disaster recovery and high availabilities.Install and configure disaster recovery, failover and high availability sitesWorking with application development team for automated loan file parsing, and to obtain maximum transaction volume per hourParticipated in data modeling and data transformation of existing loan origination schema into a normalized, oracle 9i database structure

Architected, developed and maintained multiple CRM, billing and credit card processing oracle databases for e-commerce applications.Lead developer for Oracle PL/SQL development Designing logical and physical database schemas using ERWinOracle DBA for Oracle 8i and 9i databases on Sun Solaris databases.Developed multi-threaded UNIX applications and complex PL/SQL packages to process over $35 million of transactions per month using C/C++, PERL, Python, and JAVA.Extensive ETL operations with customized scripts and Oracle SQL Loader, by loading external data into the databaseDeveloped n-tier rule based credit card processing model to communicate with various processors and banks.Developed standardized user interface for credit card processing.Developed backup and recovery routines and failover systems.Developed load balancing systems to handle over high-volume traffic (over 14 million visitors per day).