Donny Lo

Architect Application Architecture & BI Solution Architecture

Relevant Experience

An experienced Technology Professional with over 19+ years of software development experience and seven years of application architect and business systems design. Strategic planning within application architecture and infrastructure. Effectively collaborates with global customers, application teams, business and product owners, subject matter experts, and program managers.

Bring expertise with experience in BI working in enterprise environment within applications & data solutions in the area of enterprise databases using MS-BI, Business Objects (SAP), Crystal, Microsoft SQL Server and Oracle as well as implementing e-commerce software, analytics and workflow solutions, enterprise reporting using SAP and Reporting services, dimensional modeling pivots/tabular models/semantics solving business system complexity to provide a scalable solution that fits with an organization business process and BI strategy.

Provide technical leadership for planning and direction of complex business systems, enterprise applications and integrations for web, client/server, Object Oriented Architecture .Net/Java and tier distributed technology project, strategic planning of business application architecture and infrastructure, business collaboration. Install and configure enterprise app-server-environment, Application & Data Security, Recovery, and planning of business systems.

Full-stack software design process working independently and part of development teams using dot.net/Java-OO Service-Oriented Architecture, Micro (w) services, Web API (SAP/BO, C # / ASP.NET/MVC, IIS/EAP-WildFly, T/SQL for Client/Server, Integration service/ETL, Web and Windows applications), ), Active Directory-LDAP, Cloud/Web Hosting-VM, Classic ASP, Sequel Server Integration Service, SSAS, and Microsoft Sequel Server Reporting Services, SAP/BO-DS & enterprise sup-with an ODS/EDW and Analysis Databases.

Manage designs and project implementations by working with business partner(s) to solutions applications, data &reporting strategy developing proof-of-concepts, prototypes, and sales and product ideas. System Analysis- transforming business requirements and writing technical designs, defining schemas, database models/Object Relational Mapping-ADO.NET/IDA Entity Framework, creating test plans and executing business system test providing operational delivery/prod support.

Proficiency in application and data solutions and solving business process within data and application complexity using Advance Architectural principals (SQL Server, Oracle, UDB2, Sybase, etc..) and PL/T- SQL stored procedures: Developed/Maintained T-SQL & optimized complex data procedures and views for web-user interface, transact-processing (OLTP, OLAP), client server-windows, and enterprise report delivery system, architectural complexity and operational simplicity.

Develop ETL/Flow or custom applications providing operational data processing using operational data store and data support for decision system using SAP/BO Data services, Sequel Server Integration Services (SSIS), Analysis Service (SSAS), Sequel Server Reporting Services (SSRS), VB.NET/C# using SQL Server, Oracle, and DB2, MySQL environment.

Multiple full life cycle project implementation utilizing distributed computing, micro services, web services, service oriented architecture, soap/rest, web security, Threading, Windows Forms, GUI, User Interface, Multi-Tier Development/Modular, Service Oriented methodology. Messaging platform, MDM, Business Intelligence & Enterprise Data warehouse.

Expertise in operational delivery and deploying BI /ETL data transformation processes, business system, application conversion, and enterprise report- install and configure enterprise app-servers and SAP/business object Crystal technologies and Reporting Service environment. Establishes corporate standards and procedures for information technology including architecture, security, and designs for enterprise application system.

Architect, Technical Leads, business process and partnership and participate in presentation of product sale, strategies, and solution design, technology business-products and program directions. Accomplishments

Accomplishment(s) and domain expertise include production implementation of distributed technologies service orient applications and-micro services, business intelligence and data/system architecture which includes scaling of central-master edw/database within the area of business applications, report delivery solutions, data integrations and analytics

Successfully develop distribute-system architecture(multi-3tier) using COM/DCOM/SOAP- RESTFUL/Remoting/MQ/Middleware integration and report scheduler/graph delivery solution, 250+financial reports conversion at wright technologies, banker trust & principal financial

Successfully develop consumer experience and analytics applications, and microservices in the area of data integration ETL/and event campaigning, broadcast email and predictive trends/analytics at relationship marketing and Pf/Harte-Hanks.

Successfully develop microservices application and data dynamics to transform entity data to central- enterprise-dB metadata and workflow automation using MQ/ XAML/Interfaces to process promotion and consumer experiences, vendor, queue management, and implementing centralize application logging and secure-email gateway for all applications for companies such as First American, Wright Technologies, Wells Fargo, and Harte-Hanks

Successfully develop business-commercial applications for area inspections of power and transformers using SolarWinds, ArcGIS, Google Map API, and NASA World Wind. The solutions uses microservices to create geospatial mapping and GPS. An application that uses WS-API at Terra-Spectrum, A Wright Technology services company

Successfully develop a report portal for SAP/BO-RS, BRIO, Actuate reports & conversion of 100+ Crystal reports to be integrated with corporate website using role-base security, Active Directory/LDAP at the members group and water works

Successfully develop microservices application to balance financial accounts between business entities data provider and 3rd party-off the shelve/box systems by developing financial etl/data imports and interactive web-response system that communicates with business partners to resolve discrepancies- interactive resolution/balancing automation at bankers trust

Additional implementations and solution architect roles are outline and describe under the project assignments within the organizations list below

Projects

SOLOGIX Consulting 01/2016 to Present

Solutions Architect/Application Architect/Software Engineer

Freelance Consultant; Business Strategy ;( Jan 2016 - Present)

Internet Marketing, Link Building, Marketing, search engine strategies/optimization (SEO)

Develop event management and social network solution for startup(s) and commercial software application, e-commerce, iOS & Android(s), API/AWS, Azure & Cloud Hosting-VM/deployments

SAP BI 4.x Server/Clients, Worked with Crystal Decisions as of 2001

Cross Platform Development using dotnet/Java IDE Platform

Conference Training & Development

CHS, INC. 03/2015 to 01/2016

Sr. Application Architect/Technical Lead/Business System Consultant (Consultant) Provided architectural data & application development support within SAP /BO-Business Object and MS BI, analysis, and application architecture, legacy & modern system(s) integration using SAP and Microsoft Technologies. Enterprise databases, reporting, and operational delivery and support.

Designed BI applications using Microsoft BI and SAP stack. Developed and solve complexity within the solution data model and design to support new enterprise-technologies that align with project united business and reporting strategy.

Led the Enterprise Database Management – Corporate BI team efforts to improve production operational data processing environment within analysis server and primary CHS DW. This included data maintenance and operational process for database specific projects, ETL/ELT and data processing operational improvements by improving and simplify Enterprise support.

Apply architecture and integration strategy in how application and data will transform into operational data-store EDW/CRM/ERP/Legacy DB by transforming business logic from legacy system develop in classic and DOTNET applications and implementing ETL flows using SSIS-DT/Data services and components to stream data from difference business entities and developing the data-processes into business systems using third-party-API components or data providers with technologies such as WCF/API, SOA/XML or Web API and BI-toolset. Developing using MS Application/BI &SAP Stack with SQL Server 2012 and Visual Studio 2013. Collaborate with business partners to define strategic business systems and planning.

Provided enterprise level support for software, business intelligence, and ODS/DW including operational data store, networking, and enterprise reporting, SAP Enterprise/Web-Intelligence/Info view/RS/workflows and develop ETL application/flows for CRM/legacy-data system migration.

Facilitated JAD sessions with business focus groups for project migration efforts offering technical and resource planning expertise to ensure solution aligned with future technology landscapes. Offered business system support within current legacy/BI and New SAP BI environment, optimal design and implementation of new business system. This include integration and migration strategies.

Project and Production BI support to different line-of-business providing operational system support and business application system to different areas of the business/global 24x7 production support.

Assisted in defining user security group access to CHS DW and operational reporting using info view and reporting services-advance query-analysis cube/mdx development.

Migrated existing projects to VS2013 integrated deployment and TFS to deploy application data-tier

(ISPAC, DACPAC, BIML, XLMA) for database and integration services and data migration xrm20/20 projects.

Utilized Visual Studio 2013, SAP-Universe, BI 4.x Server/Clients, Enterprise Library 5, ADO.NET MVC/Classic, Business Object/Info view, Crystal, Data Integration (SSDT-BI), SSRS, T-SQL, MS-Dynamic CRM 2011, Entity Framework /LINQ, SQL Server 2014, 2012-2008(r2), SAP HANA, HADOOP, Mongo DB, Operational/Ent DW, SAP Data Services-Universe, Cubes-Analysis server. Wells Fargo 07/2013 to 02/2014

Application System Engineer/Business System Consultant (Consultant) Consulted with Project Manager; offered technical and resource planning expertise to ensure optimal design and implementation of new business system.

Performed system upgrade using enterprise library to stabilize application and thread management for business applications and project enhancements to expand business program features with existing applications and new project development.

Worked with data experts to define data model and architecture to support new software engineering or program features with new project development and recovery planning within distributed-environment.

Developed network deployment features to automate and tie to new project enhancements and program management system and provide support in data management and integration service-ETL and scheduler process.

Utilized Visual Studio 2010, Enterprise Library 5, Unity, ADO.NET MVC, Data Integration (SSIS), SSRS, Entity Framework /LINQ, T-SQL, SQL Server 2012, 2008r2, Oracle, DB2, MySQL. State of Iowa 12/2011 to 06/2012

Senior Technology Engineer (Consultant)

Collaborated with internal consultants and project lead to develop enhancements and provide system conversion support migrating Visual Studio 2008 to 2010 business application.

Architected data solution to integrate with external business website and third party applications.

Collaborated with project managers, business, and program assistant to gather and define program features and requirements.

Contributed to project proposal on system upgrade, database and system design, and test plan

Utilized ASP.NET, C#, T/SQL Server, Data Integration (SSIS), T-SQL, JQuery, Oracle, Subversion, Flickr, Entity Framework, NHibernate/NUnit, NAnt, and Business Objects Crystal Reports. Des Moines Water Works 01/2010 to 11/2011

Senior Application Engineer/Architect (Consultant) Developed architecture for web portal and new report engine. Designed a new web-integrated feature/SDK using business objects for both web and windows application Business object conversion to Crystal Studio 2008

(12) dashboard.

Performed system upgrade and conversion of current internal CRM-APPS crystal report engine design to new version of Crystal.

Migrated over seventy business object report views to current runtime environment and successfully deploy on windows 2008 server.

Worked as system integrator using ASP.NET/C#, SSIS, SSRS, Business Object Crystal /BI development with current and legacy classic asp environment e-commerce, account service registration, integration, data transformation, data management, web account administration, entity model/framework, and new development.

Design Role-Level Security principal for dashboard and data-views for report via SAP Crystal Reports and Sequel Server reporting services and develop integration for Single-Sign On for the new corporate website re-design program initiatives.

Assisted in the new business system design developing new data models DBA support for existing and new corporate business website conversions and project definition with the redesign of Des Moines.

Engineered the Water Works "My Web Account" portfolio application and integrated with new design of waterworks corporate website redesign using central login for both corporate and new account management website.

Implemented business project and design features to integrate with project server.

Identified project requirements and program definition to establish system migration plans.

Developed integrated ecommerce/module with new website.

Designed process integrated service to synchronize meter reading into new business website from 3rd party applications.

Supported current water work system and SSRS applications.

Created program enhancements to performance management system to develop accuracy in employee bonus calculations, and work on new business system development.

Provided recommendation and collaborated with project team and system admin to define client/server and web infrastructure for corporate business website and business object portal and new database environment software, hardware, and server requirements.

Developed test plans with business and project analyst to ensure business functionality.

Provided application and system support on footprints and project-program enhancements.

Integrated new security model for website redesign and integration with business systems. Jacobson Companies 09/2009 to 12/2009

Senior Technology Engineer (Consultant)

Developed an in-house custom Logistics VB.NET application for commercial trucking and contributions.

Collaborated with project manager and sponsors to define deliverables.

Mentored and coached junior resources on technology that integrated with new logistic design and enterprise report delivery system.

Presented Proof-of-Concept to Project Sponsors, Project Manager, and Business Analysts.

Utilized ASP.NET, VB.NET, SSRS, LINQ to SQL-EX, SQL 205, T-SQL and TFS. Wells Fargo Home Mortgage 10/2008 to 08/2009

Senior Application Engineer (Consultant)

Led multiple concurrent projects including a legacy migration to VB.NET, a .NET and Oracle integration, and enterprise report project using SQL Reporting Services and SAP Business Object. Led portal integration of SharePoint and content management system.

Migrated and converted Microsoft Access/Excel management reports (14CMO) to SQL Reporting Services 2008 environment; integrated crystal into corporate portal.

Provided recommendations and proposed solutions on new project integration strategy.

Defined business system interaction with different business channels using corporate policies and development standards.

Worked with data experts to develop process to provide business data to support new business applications. Developed and designed data-marts or data replication and new schema from enterprise- corporate database.

Consulted with Project Manager, offering technical and resource planning expertise to ensure optimal design and implementation of new system.

Provided proposal and conducted system and new design walkthroughs, and presented prototypes to business partners and project sponsors.

Migrated and converted VBA Extra Basic Mainframe Macro applications to Microsoft VB.NET. Developed central Email SOA applications and Exception Handling, established Extra/VBA and .NET coding standards.

Worked on SMTP migration to a new email channel and develop centralize SMTP support application for use with Microsoft .NET and VBA applications and development.

Proposed, recommended, and developed computer systems and automation using Microsoft Visual Studio and Windows Service Development.

Developed windows service C#.NET application to integrate with Oracle ETL/Replicated database environment. Designed a centralized email support and exception logging application. Integrated Microsoft .NET applications with different Wells Fargo MIS support channels to utilize external or internal supported software packages.

Worked with Enterprise Hosting Service to define a New PTP to assist in defining new hardware and OS environment for application, database, and analytics to support new development using Microsoft

.NET/C#. The analytics environment primarily consisted of Business Objects, Crystal, XI/X-Celsius and Microsoft Reporting Services.

Utilized Team Foundation Server for project and version control on new system & team build, item tracking, mentor staff new to visual studio, and assist in providing technology project management to assist in defining new migration work plan on new project and system conversion. Terra Spectrum Technology a Wright Tree Service Co. 01/2008 to 10/2009 Senior Application Engineer (Consultant)

Developed the roadmap and architecture plans to managed project solution for the development and the successful design of an aerial patrol application and tree risk assessment programs that integrate with GPS/GIS and field devices.

Engineered an integrated Aerial Patrol-Internal External Field applications, Tree Risk assessment Program, and Pre-Planner commercial software application and install program using SQL server desktop edition.

Developed GPS/GIS Integration using asp.net web applications, web-services, asp.net, windows client to centralize aerial and ground inspections of powers lines for WTS and MidAmerican Energy Company.

Implemented mapping solution, route and print delivery integrated with GPS application using windows, client/server, and web development.

Developed field database-analytics-web admin application and dashboard for client, project sponsor, entity-field data analysis, analytic using Microsoft Reporting Services. Provided technical support to applications and database modeling and system development.

Provide architectural designs to Implemented web and windows service to synchronize data from field- devices to the central wright CRM database. Develop reusable service api/assembly-components to be utilized across applications and databases.

Created a central service to synchronize real-time data from commercial applications and aerial- field inspection using WS/Web API enabling real-time field support.

Developed central web-based Dashboard to view inspections and aerial assessments.

Implemented admin solution to allow customers to manage entity specific data.

Presented prototypes to business stakeholders, and established development standards.

Utilized team foundation for project, ASP.NET, C#, ADO.NET/ORM, web services, web/client-server, SQL server, and version control on new system product build, software product setup, field deployment, and installation.

Relationship Marketing 10/2007 to 12/2007

Senior Software Developer /Technology Consultant

The Members Group 2007

Senior Software Developer /Technology Consultant

Harte-Hanks/Post future 2007

Senior Software Engineer /Technology Consultant

First American 2006

Senior Software Engineer

Bankers Trust 2005 to 2006

Software Engineer /Technology Consultant

Relationship Marketing 2005

Senior .NET Developer /Technology Consultant

Wells Fargo 2003 to 2004

Software Developer for Wells Fargo

Principal Financial Group 2001 to 2003

Technical Analyst Lead for Principal Financial Group Skills and Expertise

Technical: Windows 7 ++, ASP.NET, Universe /Cubes, DOTNET, ADO.NET, Entity Framework, Metadata Mgmt./ORM, OWIN/CORS, Entity Framework-NH, AngularJs/Bootstrap, Ajax/Dynamic GP ERP/Salesforce, PeopleSoft/CRM20, Perl, C#, C++, VB.NET, XSLT, Crystal Enterprise, Visio Data Architect, Microsoft SharePoint, SAP Business Object Data service-BI, OLTP OLAP-BI /ETL, Enterprise Library, JavaScript/VB Script, T-SQL, PL/SQL, MVC-PRISM, Sale-Force, MQ Series, CICS/Middleware, MS Office, Crystal Clear/XP, IIS75, EAP7-WildFly, SOA, Silver light, TFS/Subversion, LINQ/JQuery, Lodash, VB5-7, SSRS, SSIS, SSAS DTS, SAP-BI, COGNOS, Erwin/Data Architect, Clear Case PVCS, XAML/XML, C#.NET, XML/SOAP-REST/Web-Win Services, WPF .NET Framework 3.5/4.0, JQuery/Perl, BizTalk Classic ASP, VBA, HTML/CSS, Remoting, SSDT-BI, BODS-Data Integrator, Business Object Crystal, Erwin, Power Designer, Visio Architect, MS SQL 201*-****-****(R2), Oracle, UDB2Univeral, In-Memory and Cache Databases, MySQL, SQL/LTE Compact Functional: Strategic Planning, Solution Design, Technology Integration, Cloud Applications, Network Infrastructure, Requirements Analysis, Business Process, Application Architecture, Integration Planning, Infrastructure Design, Portal/Content and Event management, Document Management/Laser fiche, System Integration, Road Maps, Security, System/Process Work Flows, Business Intelligence, Data Warehouse, Data Marts, Data Lakes, GUI, User Interface, Software Engineering Specialties: BI, business intelligence, reporting, open source, reports, analysis, system architecture & data integration, data mining, OLAP, ETL, business analytics, big data, visualization, and predictive analytics Methodologies: Agile-Scrum, Waterfall

Industry: Financial Services, Logistics, Government, Public Works, Marketing Education

University of Minnesota, Bachelor of Science, Computer Science Professional Development

Certifications, Training and Development

Workshops for Tech Leaders, VSLIVE CONF-5, SAP-BO, iOS & Android(s), Network, Novell Organizations

Organizations/Memberships

Asian American Alliance, IAA – Diversity, Unity, Prosperity.

Contact this candidate