Page * of **

Bernard Apolinario

adzco0@r.postjobfree.com 949-***-****

SUMMARY: I am a seasoned technology leader and strategic thinker who has successfully designed/developed innovative solutions and built and managed high-performing teams to deliver high-quality results. I have hands-on experience as an Enterprise Architect, with expertise in software architecture, patterns & best practices, relational databases, cloud services, client/server, web application development and project management. I have over 25+ years of proven leadership experience in architecting, designing, and implementing enterprise-scale, high volume, high availability solutions. Strong experience in Service Oriented Architecture, Object Oriented Design and Enterprise Application Integration. Skilled in identifying potential areas of growth and improvement. Highly proficient relational database knowledge including data modeling and optimization. Expert at collaborating and building trusted partnerships across teams and partners. Strong communications skills. Highly adept at influencing executive leadership and stakeholders. Experienced in managing human resource assets globally. Promotes and fosters a culture of diversity.

EDUCATION: California Polytechnic University, Pomona Bachelor’s Degree in Business Administration

Major in Management Information Systems

Graduated in June 1991

CERTIFICATIONS:

Microsoft Certified Professional – Cloud Platform

• Architecting Microsoft Azure Solutions (AZ-534)

• Managing Microsoft Azure Infrastructure Solutions (AZ-533)

• Azure DevOps (AZ-400)

• Microsoft Azure Fundamentals (AZ-900)

• Microsoft Azure AI Fundamentals (AI-900)

BLOGS: • Custom AI Models with Azure Machine Learning Studio and ML.NET

• Blockchain in a nutshell

• GitHub Actions Overview

• Premier Support Helps Keep Santa Flying

EXPERIENCE: Avanade, Inc. 04/2022 - Present

Group Manager – Full Stack Development

Leads software development projects/teams for Avanade/Accenture customers.

• Deliver large scale initiatives on time, within budget and in accordance with specified levels of quality

• Creates solution architecture designs

• Provides architectural guidance on solutions modernization

• Manages project delivery and profitability

• Reports project status to stakeholders (CXO)

• Manages Human Capital Development

o Identifies and manages project resources

(Onshore/Offshore)

o Ensure effective development and delivery of

Performance Reviews and mid-year reviews for all

assigned and matrixed personnel

o Manages Sr. Managers / Managers / Architects /

Consultants / Developers

Page 2 of 10

• Re-architected & modernized a major metropolitan city’s Fire Department dispatch system

• Designed Enterprise DataOps and DevOps platform for a major health insurance provider using Oracle, MongoDB, Python, TriFacta, GitLab, Kubernetes, RedHat OpenShift & Helm

• Designed APIs and Microservices for Data Analytics consumption

• Assist in Sales Pursuit opportunities

Microsoft Corp. 04/2014 – 04/2022

Senior Application Development Manager

Manages Premier Support agreements by providing proactive & reactive services, advisory & best practices guidance to Fortune 500 companies. Performs role of a trusted advisor

• Provide guidance to customers in formulating multi-year IT strategies that are aligned with business goals

• Marshalls Microsoft resources in support of customer’s development efforts

• Envisions modern and proof -of-concept solutions for customers

• Conducts contract negotiations and reviews to ensure customers consumption is aligned with IT goals

• Advice customers moving their on-premises workloads to Azure Cloud Services

• Ensures that support resources are meeting the SLAs as defined

• Monitors customer’s IT health via assessments and workshops

• Formulates Major Incident Response Plan (MIRP) for disaster recovery

• Provides best practices guidance on high performance and high availability cloud solutions

• Coach development teams on agile methodologies, DevOps, and Application Lifecycle Management (ALM) best practices

• Manages Support Engineers to ensure prompt resolution and customer satisfaction

• Support Team Lead for NORAD Tracks Santa initiative

• Conducts employment interviews & provides hiring recommendations Korn/Ferry International 07/2011- 04/2014

Lead Developer / Architect

Managed a team of developers, analysts, and testers to design and implement leading-edge solutions in support of the executive recruitment business

• Design solutions to integrate LOB data with 3rd party partners such as LinkedIn, Avature and Aprimo

• Delegate tasks and plan optimum usage of available resources using Microsoft Project

• Design UML architectural diagrams using Microsoft Visio

• Refactor existing applications to enhance performance and exception handling & logging

• Created RESTful services to facilitate information exchange with partners using WCF, JSON, OpenID, and OAuth

• Develop project plans using TFS, Microsoft Project and Agile methodology

• Utilized Microsoft Extensibility Framework (MEF) for plug-in architecture

• Re-architected deployment strategy for custom CRM application by leveraging Amazon S3 and Microsoft ClickOnce technology

• Ensured adherence to Best Practice Application Lifecycle Management (ALM) using TFS

• Designed and implemented internal & customer facing web sites using AngularJS, jQuery, MVC, ASP.NET, & bootstrap

Wynn Resorts 09/2010- 07/2011

Lead Database / Application Architect

In partnership with the Application Architect, designed solutions that support and enhance the daily operations of the Hotel and Casino operations.

• Managed 2 production support DBAs and 1 development DBA

• Delegated tasks and conducted SCRUM meetings

Page 3 of 10

• Designed enterprise databases in SQL Server 2005/2008, Oracle 10G and MySQL

• Responsible for integration of Micros Opera and IGTs Player Management

• Designed and maintained Tibco BusinessWorks SOA processes

• Designed ETL processes to the Teradata Data Warehouse system using SQL Server Integration Services (SSIS)

• Developed tools in Microsoft .NET to monitor and optimize database performance

• Developed and enforced Database standards and best practices

• Implemented Master Data Management (MDM) methodology to increase the quality of the data and prevent data corruption

• Mentored the team on best practice use of TFS 2010 and agile methodologies

• Reduced database downtimes by creating pro-active reports to monitor critical database metrics

• Designed and developed Wynn Poker web services to allow third-party applications including iPhone apps to integrate with existing Hospitality (Opera) and Gaming systems

(IGT) systems

• Created project plan and sprint schedules using Microsoft Project and TFS 2010

• Performed systems downtime Root Cause Analysis and resolution Cantor Gaming 11/2009 – 09/2010

Senior Database Administrator

Designed database solutions for wireless gaming using SQL Server 2000/2008 and MySQL.

• Developed statistical algorithms for generating sports betting odds

• Maintained optimum database performance and reliability

• Assisted developers in creating highly optimized queries

• Optimized existing queries to reduce blockings/deadlocks and increase performance

• Created QA and Development database environments

• Created database standards and best practices

• Designed and setup high-availability SQL Server 2008 Cluster

• Developed database for risk management in-running sports betting

• Created ETL packages using SQL Server Integration Services (SSIS) Tech Results 06/2009 – 11/2009

Solutions Architect

Designed a solution for seamless integration of player data across multi-property casinos

(OneCard) using .NET 3.5, C#, SQL Server 2005 & 2008, WCF, WPF and MSMQ.

• Created fast, reliable, and recoverable messaging architecture using WCF and MSMQ

• Designed multi-layer architecture to promote scalability and ease of maintenance

• Introduced and integrated the Microsoft Enterprise Library 4.1 with existing and new applications

• Promoted and implemented Agile methodology

• Created base components and helper utilities to promote code reusability

• Optimized hardware resource utilization by distributing the processing load across several servers

• Migrated .NET 2.0 promotion web application to use .NET 3.5

• Created Business Intelligence analytical tools using Silverlight 3.0 RIA and WCF services Korn Ferry International (Contract) 03/2007 – 01/2009 Solutions Architect

Migrated VB 6.0 Searcher desktop application to .NET 3.5 Winform application using VB.NET, C#, WCF and WPF.

• Designed re-usable UI components

• Performed Object Oriented Analysis and Design with UML using Visio

• Created SOA Framework using .NET WCF

Page 4 of 10

• Created printing engine for XPS documents

• Created and optimized and T-SQL Stored Procedures and User-Defined Functions

• Created Exception Handling and Logging system using Microsoft Enterprise Library

• Promoted use of Software Development Patterns & Practices

• Prototyped new WPF/XAML UI designs using Expression Blend and Visual Studio 2008

• Optimized application performance by tuning memory and network bandwidth usage

• Created technical specifications from user requirements

• Reviewed and revised design specifications

• Performed code review

• Created multi-threaded asynchronous objects to mitigate delays in returning large query result sets

• Designed and implemented localized user interfaces Educational Testing Services (Contract) 03/2006 – 03/2007 Lead Application Architect

Responsible for overall application architecture for Integrated Data Management System (IDMS), a high volume ASP.NET educational assessment and guidance application used by K-12 educators.

• Supervised 3 architects, 4 team leads, and 16 developers

• Managed offshore development team

• Designed and implemented database migration plan from SQL 2000 to SQL 2005

• Created Request for Proposal (RFP) documents to solicit bids from hardware and software vendors

• Lead the technical design of new application features

• Optimized T-SQL stored procedure performance

• Assisted Database Administrator with server configurations and security

• Developed application and database Best Practices

• Documented existing and new requirements using UML (Visio)

• Implemented Microsoft Enterprise Library framework using the Configuration, Data, Exception, Logging, Security, and Cryptography blocks

• Assisted Business Analyst with requirements gathering and future solutions proposals

• Assisted Project Managers in Microsoft Project scheduling by categorizing and prioritizing tasks

• Allocated development resource to address software defects

• Performed code review and mentored developers in Microsoft Patterns & Practices

• Created multi-threaded test scoring system

• Increased the efficiency and reliability of the OMR test scoring system

• Migrated existing ASP pages to ASP.NET (VB.NET & C#) and AJAX

• Designed asynchronous (multi-threaded) document generation system using XML, XSLT, & XSL-FO

• Increased web application performance by implementing caching, pre-rendering techniques

• Created web services to facilitate data integration with client school districts

• Increased Scantron test read accuracy by redesigning the test templates to include multiple targets per answer box

Shea Homes Corp (Contract) 12/2005 – 3/2006

Senior Consultant

Migrated existing reports from Microsoft Access to ASP.NET utilizing VB.NET, ActiveReports, Web Services and SQL Server 2000.

• Created reports to satisfy new user requirements and new database schema

• Optimized query and report performance to return results within the requirements (under 5 seconds)

• Created indexes on tables and views to increase query performance Page 5 of 10

• Documented the reports so information will be available for future maintenance on the purpose of the report, the tables used, columns used, calculations, groupings, and summaries, as well as the parameters (required and optional)

• Created ETL tools to facilitate the integration of data from disparate systems

• Created DTS import/exports to synchronize databases on different platforms Nellson Nutraceutical (Contract) 2/2005 – 12/2005

Application Architect

Converted and enhanced Formulation Master (FM), an Excel based food product formulation system, into n-tier Winform VB.NET application with SQL Server 2000 backend

• Designed relational database using data modeling tool (PowerDesigner)

• Imported existing Excel based database into normalized relational database by creating a Visual Basic .Net application and SQL queries to transform and cleanse the data

• Designed application framework based on Microsoft Enterprise Library (Data Access, Configuration, Exception Handling, Logging, and Security Blocks)

• Designed and developed interfaces to ERP system (Ross)

• Aided the Project Manager in allocating development resources to ensure deliverables are completed on time

• Managed the resolution of reported issues and enhancements

• Created custom reports using ActiveReports and outputted to PDF

• Created formulation algorithms to facilitate what-if scenarios in product formulation Gap, Inc. (Contract) 10/2004 – 2/2005

Application Architect / Lead Developer

Designed and developed a Project Management tracking system for the Project Management Office

(PMO) using Microsoft Project Server and ASP.NET

Lead a team of 10 (2 Analyst, 1 DBA, 5 Developers, and 2 QA Testers)

• Created and optimized Project Plan using Microsoft Project

• Developed QA test scripts and test plans

• Created Dashboard report using SQL Server Reporting Services to profile the Top 20 High- Visibility projects

• Converted Excel-based Progress Reports to web-based application, eliminating the unreliable monthly excel file distribution and data import

• Developed SQL queries and XML extracts to facilitate the IT Finance departments monthly forecast

• Created ASP.NET application framework using the Microsoft Application Blocks (Data, Exception, and Caching)

• Trained IT staff to develop applications using Microsoft Patterns & Practices

• Created PDF reports that were sent out to store locations, via email, using ActiveReports

• Redesigned existing applications security by promoting the use of Stored Procedures instead of in-line SQL to prevent SQL injection attacks

• Created ETL utilities to transfer data from Oracle 9i to SQL Server 2000 Shea Homes So Cal (Contract) 9/2003 – 10/2004

Project Lead / Architect

Design and develop new web-based Community Management System (CMS) to keep track of the various resources, activities and events for several communities under development.

• Created application framework for .NET applications by using and extending several Microsoft Application Blocks (Data Access, Caching, Configuration Management, User Interface Process, and Exception Handling)

• Developed code generator to facilitate the creation and maintenance of set based stored procedures (CRUD methods) used by the Data Access Application Block

• Created base classes and business objects

• Developed and deployed .NET web services and remoting applications Page 6 of 10

• Designed and implemented user/group-based forms security infrastructure

• Optimized database design and SQL queries

• Created reports in ActiveReports (PDF) and Microsoft Excel City of Los Angeles Human Resources

(Contract)

5/2002 – 9/2003

Senior Programmer / Analyst

Migrated existing Human Resources legacy application (COBOL) to Winform VB.NET application with Oracle 9.1 database.

• Design and create database using Oracle 9.1. Create stored procedures and triggers

• Performed security audit/fixes to mitigate security lapses in existing code

• Converted in-line SQL to stored procedures

• Created User Defined Functions for commonly used SQL routines

• Optimize database performance for online real-time transactions

• Develop and modify Human Resources/Payroll application in Visual Basic, VB.NET and ASP.NET

• Gather user requirements

• Write formal user and technical requirements documents

• Create Statement of Work and Work Breakdown Structure charts

• Ensure the new processes and systems will integrate with existing legacy systems and other city, municipal, and state systems

• Develop prototype screens and report and present to stakeholders Union Bank of California (Contract) 4/2001 – 5/2002 Application Architect

Lead a team of developers in rewriting a Subpoena/Money Judgments tracking system (JASON) from an Access application to Client/Server desktop application.

• Designed and optimized the SQL Server 2000 database model using Erwin

• Developed database security architecture using SQL Server application role

• Created stored procedures for optimum performance over distributed network

• Developed application framework to promote code reuse and rapid development

• Re-engineered existing departmental workflow to optimize use of both human and computing resources

• Created interfaces to mainframe system using EHLLAPI to allow the application to scan banks systems for the required information

• Designed documents generation using Microsoft Word templates and information from stored procedures via a custom OLE object

• Created Best practices document for Database and Application Development

• Created technical document library in Lotus Notes (1200 pages)

• Created class diagrams using Visio

Deutsche Bank (Contract) 8/2000 - 4/2001

Senior Programmer / Analyst

Developed and maintained Asset Based Income Reporting System (ABIRS) using PowerBuilder 6.5.1 and SQL Server 6.5 and Oracle 8i.

• Created Risk Analysis reports from database information and exported to Excel

• Develop coding standards, documentation, and mentor other developers in the proper use of PowerBuilder Foundation Class (PFC)

• Develop Visual Basic COM/DCOM objects and interfaces to Microsoft Office products (Excel and Word)

• Optimized existing and create new reports to take advantage of stored procedures

• Eliminated SQL injection risks by converting dynamic SQL to Stored Procedures Page 7 of 10

• Maintained relational database (created new and maintained existing tables, views, stored procedures, and triggers) using Erwin

Experian (Contract) 10/1998 - 2/1999

Senior Programmer / Analyst

Senior Application Developer for project to define and process credit profiles for Experian clients. The application is an n-tier architecture with Visual basic used in the presentation layer, Visual C++ used in the business rules/data access layer, and IBM DB2 UDB used as the database server.

• Responsible for development, testing and implementation of Visual Basic applications in a Windows NT/95 LAN and mobile environment

• Design and develop Visual Basic classes to encapsulate the Visual C++ code

• Write and optimize SQL queries. Develop formal test scripts and procedures

• Created graphical tool for representing client requests Shea Homes So California (Contract) 2/1997 - 8/2000 Senior Programmer / Analyst

Project lead for the design and development of database interfaces across multiple hardware/applications/database platforms (DB2/400, SQL Server 6.5/7.0, FoxPro, & Access) using PowerBuilder 6.5 & PowerBuilder Foundation Class (PFC) and Visual Basic 6.0.

• Designed and developed a Data Copy Utility (DCU) to copy data from any ODBC database to another ODBC database

• Created complex SQL scripts using Dynamic SQL, stored procedures, and triggers

• Migrated JD Edwards Financial from version 5.2 to 6.2

• Designed enterprise-wide database architecture in SQL Server 6.5 used by all Shea Homes divisions

• Created in-process and out-of-process server and remote OLE automation applications using Visual Basic 5.0

• Implemented distributed data acquisition systems for sales system using Excelenet, Visual Basic, Access 97, and PowerBuilder

• Developed a document management system for Shea Contract System using PowerBuilder and OLE automation to Microsoft Word 97

Disney / Buena Vista Home Video (Contract) 10/1996 - 2/1997 Database Administrator / Senior Developer

As part of the DBA group, designed and developed data warehouse applications to extract, transform and load information from the transaction system (DB2) to the data warehouse system (Essbase).

• Developed DB2 journal processing application to extract record changes and adjust the data warehouse summary balances

• Developed server applications to monitor and control ODBC connections to the AS/400

• Created utility and maintenance applications to manage data warehouse jobs and queries

• Converted RPG applications to SQL/RPG IV

• Administered DB2/400 object creation and modifications and optimized SQL queries

• Reviewed and approved schema and query scripts before deployment to staging and production systems

• Created cubes/reports that broke down product sales by region, by day of the week, time of day, and in relation to a TV ad that was shown

• Created application to allow non-technical users (no SQL knowledge required) to build reports from existing cubes via a graphical user interface Universal Studios (Contract) 5/1996 - 10/1996

Senior Programmer / Analyst

Project lead for a three-tier client server system project. Designed and developed applications that integrated DOS Clipper based and windows-based applications to communicate with the AS/400 order & billing system.

Page 8 of 10

• Developed applications using PowerBuilder 5.0 and were partitioned to allow the servicing of requests from several clients at one time

• Created reports using RPG and SQL/400

• Created communications library to allow IPX messaging between DOS platforms and the AS/400 using IPX/SPX, SNA, & APPC

• Created and modified Software 2000 applications using RPG and CL J.F. Shea Corp. 12/1994 - 5/1996

Senior Programmer / Analyst

Responsible for the maintenance and performance of JD Edwards financial application.

• Created separate JDE environments on one AS/400 to enhance flexibility and performance.

• Designed and developed a JD Edwards financial consolidation system to summarize the divisional financial information to corporate

• Designed and developed PowerBuilder based application to manage sub-contractor bids and awards

• Developed links from PC based systems to JD Edwards to eliminate double entry and increase productivity using DCOM

• Developed Project tracking system in Visual Basic to enter and track IS projects and allocate available IS resource

• Created applications to allow Mortgage (Mortgageware) and Sales (CPS) system to share data thus eliminating double entry

NeitClem Wholesale Insurance Brokerage 6/1994 - 6/1995 Senior Programmer / Analyst

Full Life-Cycle development of an order processing system for insurance brokerage in PowerBuilder and SQL Server.

• Created 3NF database design using PowerDesigner

• Created and optimized SQL Server stored procedures, triggers and views

• Designed and implement the Local Area Network using Windows NT 3.1 and the server and Windows 3.1 for clients

• The system included order entry, premium quote management, billing, payroll, commission management and accounting

• Created application that allowed outbound document faxing from the desktop

• Created technical requirements from user requirements Blue Coral, Inc. 6/1993 - 12/1994

IT Manager

Converted PICK based system to an AS/400 based manufacturing and accounting system.

• Wrote SQL routines to extract, transform and load flat file PICK tables into DB2 relational database

• Developed bar coding and inventory tracking applications

• Made modifications to software to satisfy customized invoicing requirements

• Developed real-time applications to monitor storage containers & manufacturing equipment in Visual Basic

• Developed Materials Information System (MIS) to provide quick and accurate information about hazardous and non-hazardous materials in the facility

• Created Material Safety Data Sheet (MSDS) reports for the transportation of potentially hazardous materials

The Polo Club 3/1993 - 12/1993

Programmer

Designed and developed a Point-of-Sale and Billiard management system.

• Developed billiard management system using Visual Basic 3 and Microsoft Access

• Developed POS using PowerBuilder 3 and SQL Server Page 9 of 10

• Created tables, views, stored procedures, functions, triggers and indexes in SQL Server

• Created application to control Lighting using X10 protocol and Power Line Interface modules

• Designed management end-of-day reports using Crystal Reports Williamhouse of California 3/1990 - 6/1993

Data Center Manager

Responsible for the daily operations of AS/400 data center and remote sites.

• Managed staff of 4 (2 operators and 2 programmers)

• Migrated computer system from System 38 to AS/400

• Applied PTFs and performed operating system upgrades

• Designed and developed custom RPG manufacturing & distribution applications in RPG

• Developed and implemented payroll system interface with ADP payroll software using Visual Basic and Access

• Created reports using crystal reports and excel. Developed Telephone Call Accounting system using the AS/400, Visual basic and internal PBX

• Developed warehouse JIT supply chain management software to automate inventory replenishment with suppliers

SKILLS .NET Framework 15+ years

.NET Core 3.1, 5.0 4 years

ActiveReports 5 years

ADO.NET 10+ Years

Agile Development 15+ Years

AJAX 3 Years

ASP 7 years

ASP.NET 7 years

Azure IaaS/PaaS 9 years

Azure DevOps 5 years

Azure IoT 2 years

C# 10+ years

ClickOnce 4+ years

COM / DCOM 8 years

Crystal Reports 8 years

DTS 8+ Years

Erwin 5 years

IIS 8+ Years

Infragistics Controls (Web & Windows) 6 Years

JavaScript 6+ years

Kubernetes 2 years

Microservices/Containers 2 years

Microsoft Project 7+ Years

Oracle 4+ years

Power Builder 7 years

Power Designer 7 years

Project Management 15+ years

RPG/400 12 years

SharePoint 3 Years

SSIS 7+ Years

SQL Server (4.2 – 2017) 15+ years

Tibco BusinessWorks 5.2 1 year

Team Foundation Server 8 years

UML 10+ Years

Visual Basic 10+ years

VB.NET 8+ years

Page 10 of 10

Visio 12+ years

Visual Studio 10+ years

WCF 5+ Years

WPF 10+ Years

Contact this candidate