Kejian (Ken) Wu

*** ******** ******* **. **** Phone: 630-***-****

Lisle, Illinois 60532 adx2r1@r.postjobfree.com

Active Federal Security Clearance – BI Level

(High Background Investigation Level)

EDUCATION

M.S., Computer Science – Illinois Institute of Technology, Chicago, Illinois – Dec. 1996, GPA 3.8 / 4.0

Computer Science Graduate Courses at DePaul University and Arkansas State University

B.S., Electrical Engineering – University of Illinois at Chicago, Chicago, Illinois

Professional Certifications – see last page.

PROFESSIONAL SUMMARY

27 years (17 years as a permanent employee and 10 years as a consultant) of demonstrated experience in the use of C#, C/C++, Visual C++, Java, Perl, XML, HTML, DHTML, Visual Basic .NET, ASP.NET, ASP.NET MVC, ASP.NET Core, ASP, VBA, Visual Basic, Oracle, MS SQL Server, Informix, Sybase, DB2, MySQL, Unix/Linux, Server2003/Windows 7/Windows 8/ Windows 10 and a broad range of applications including CRM, ERP, accounting, finance, banking, database administration, web development, and specialized tools for networking and wireless communications. Worked with .NET framework since April 2002. Key attributes and skills include analytical abilities, skilled at fulfilling deadlines, and experienced in the implementation of OOD/OOA/OOP coding solutions.

TECHNICAL SKILLS & EXPERIENCE

.NET (C#, ASP.NET, VB.NET, MVC, ASP.NET Core, ADO.NET, .NET 2010/2013/2017/2019) – 15 years

Customer Relationship Management (CRM) System (Microsoft Dynamics CRM 2013, Pivotal 5.9, Pivotal 6.0, Salesforce, Infor CRM, SharePoint) – 6 years

MS SQL Server 2000/2005/2008/2012/2014/2017, SSIS – 8 years

WCF, Web API, ASP.NET MVC, .NET Core, Electron.NET with .NET Core – 3 years

.NET Web development, XML, and .NET Web services – 5 years

.NET Windows Form, WPF, UWP, Window Services, and .NET Remoting – 4 years

Object-Oriented (OO) development – 10 years

Reports (MS SQL Server Reporting Services, Crystal Reports, Brio Reports, Oracle Reports and Forms, SAP Business Object Reports, VBA Reports, MS Power BI, ComponentOne C1Report Designer) – 5 years

Oracle, Oracle APEX, Oracle Project Accounting, and Oracle Financials – 8 years

Ruby, Ruby on Rails, Perl, Python, PHP – 2 years

Visual Basic 6, VB Script, VBA, and ASP – 5 years

Java, JavaScript, JQuery, Ajax, Angular JS, Angular 2, Typescript, React, Bootstrap, and HTML – 6 years.

ERP (Infor CloudSuite Industrial/Syteline 9.0 and 10.0, Oracle Project Accounting, Oracle Receivables) – 8 years

Languages, Tools, and Systems:

C#, C, C++, Visual C++, Perl, Pascal, FORTRAN, COBOL, RBG, VBA, Visual Basic, Visual Basic .NET, ASP.NET, ASP, Ruby, Ruby on Rails, PHP, ADO.NET, ADO, Linux / Unix (C Shell, Korn Shell, Bourns Shell), J#, Java, Java Script, Coffee Scripts, JQuery, Java Servlets, JSP, MC68000 assembly, HTML, XHTML, DHTML, CSS, XML, XSLT, VB Script, COM/COM+, OOP/OOD, MS Word, Excel, Access, Ajax, SharePoint, Telerik RadGrid and Controls, Infragistics Controls, Pivotal CRM 5.9 and 6.0, IBM iSeries AS/400, JetBrians RubyMine 3.2.3, Visio, Resharper

Database Systems, Tools, Systems, and Networking:

MS SQL Server 2005/2012/2014/2017/2019, Oracle (including Oracle 7/8/8i/9i/10g/11g/12c), Oracle Forms 5.0/6i, Oracle Reports 6i, Data Warehouse, Oracle Receivables 10.7/11 and Oracle Project Accounting 10.7/11; Informix, Sybase, DB2, MySQL, ODBC, SAP, AS/400, ERWIN, TOAD, SQL Server Developer, DTS, MDX, MS Analysis Services / OLAP, DreamWeaverMX, Macromedia FLASH, COLDFUSION, Photoshop, MS Visual SourceSafe, MS Team Foundation, SmartCVS 4, ClearCase, Perforce, Git (GitLab, GitHub), Aldon LM 5.3, Serena Dimensions CM, TCP/IP, Simple Network Management Protocol, BizTalk, DTS 2000, SQL Server Integration Services, SQL Server Analysis Services 2000, MDX, and Microsoft SQL Server Reporting Services, SAP Business Objects, Crystal Reports 9 and 11, Azure DevOps, Heidi SQL, Docker Container, VM, NoSQL(MongoDB)

PROFESSIONAL EXPERIENCE

Northstar Aerospace, Inc., Bedford Park, IL 04/2023 – Present

Business System Analyst (Contractor)

Enhanced Infor CloudSuite Industrial/Syteline Purchase Order Form using VB.NET, and MS SQL

Enhanced Infor CloudSuite Industrial/Syteline Purchase Order Report Form using VB.NET, and MS SQL

Enhanced Infor CloudSuite Industrial/Syteline Purchase Order Detail Viewer using VB.NET, and MS SQL

Used Events, Event Handles, Event Action, Event Trigger and Event Global Constant to schedule and run different Forms

Enhanced _HELG_MRR Serial Form using MS SQL Reporting Service, and MS SQL Store Procedure

Redesigned and rewrote _HELG_Order Shipped Cost report using MS Reporting Service, and MS SQL

Redesigned and enhanced Infor CloudSuite Industrial/Syteline APS (Advanced Planning and Scheduling) Forms using VB.NET, and MS SQL

Created different, new views using DataViewSetUp.

Enhanced Customer Orders and Customer Order Lines Forms using VB.NET, and MS SQL

Rewrote NSA packing Slip Form in both user mode and site default mode using VB.NET, and MS SQL

Enhanced NSA Accounts Payable Aging Report using IDO, MS SQL, and rewrote the Store Procedure

Enhanced _NS_User permissions view

Enhanced MRR Problem serial query Form in 3 sites (Chicago, Windsor, Phoenix) VB.NET, and MS SQL

Researched Project Manager Forms

Resolved tickets for Factory Track

Researched EDI (Electronic Data Interchange) which will be integrated with Boeing Company (Sikorsky) and Northstar Areospace

Enhanced QC_Quality Control Form using IDO, MS SQL, and MS Reporting Service

Tangent Technologies, LLC, Aurora, IL 08/2020 – 3/2023

Programmer Analyst / MS SQL Administrator (Permanent Employee)

Worked as both a developer and an administrator (sa User) for Infor CloudSuite Industrial/Syteline ERP.

Led the development and roll-out of ERP system training to end-user base with coordination from department leads and business process owners.

Enhanced Infor CloudSuite Industrial/Syteline ERP Accounting and Financial Forms using MS SQL, VB.NET, and Infor Form Design tool (Winstudio).

Enhanced Infor CloudSuite Industrial/Syteline ERP Manufacture Forms using VB.NET, MS SQL, MS SQL Reporting Service, and Infor Form Design tool (Winstudio).

Improved Infor CloudSuite Industrial/Syteline Customer Service Forms using MS SQL, MS SQL Reporting Service, and Infor Form Design tool (Winstudio).

Enhanced Infor CloudSuite Industrial/Syteline Sales Forms using MS SQL, MS SQL Reporting Service, and Infor Form Design tool (Winstudio).

Enhanced Infor CloudSuite Industrial/Syteline Human Resource and Payroll Forms using, MS SQL, MS SQL Reporting Service, VB.NET and Infor Form Design tool (Winstudio).

Improved Infor CloudSuite Industrial/Syteline Tax Interface using VB.NET.

Enhanced Infor CloudSuite Industrial/Syteline Inventory Control and Material Planning Forms using VB.NET, MS SQL, MS SQL Reporting Service, and Infor Form Design tool (Winstudio).

The enhanced and modified Syteline ERP FORMS are in these groups: Accounts Payable Group, Accounts Receivable Group, Advanced Manufacturing Group, Auditor Group, Analysis Group, Credit Card Group, Customer Portal Group, Data Collection Group, Electronic Data Interchange (EDI) Group, Employee Hourly Group, Employee Salaries Group, Employee Self Service Manager Group, Engineering Change Notice Group, General Ledger Group, Human Resources Group, Inventory Group, Order Entry Group, Payroll Group, Purchasing Group, Point of Sale Group, Projects Costs Group. Purchase Requisitions Group, Service Group, Standard Forms Group, System Administration Group, Tax Interface Group, and more.

Enhanced SPD (Schedule Planning Database) Manufacture software using Access and Forms and linked Access Database to MS SQL.

Designed and improved a new data upload program using ASP.NET / C#, T-SQL, and MS SQL.

Provided technical support to Salesforce, QuickBooks, EPAC, and CloudSuite Industrial/Syteline ERP.

Designed Tangent Training Tracker Software (Database Design, Business Flow Chart) and coded and tested software using WPF, C#, Oracle, MS SQL and linked MS SQL to Access database.

Backed up and restored MS SQL Server Database.

Scheduled to backup MS SQL Server Database.

Shrank MS SQL Database Log files.

Installed Lake Companies Shop-Trak to Syteline and support shop-Trak Forms and Reports (MS SQL, MS SQL Reporting Service, and VB.NET).

Supported Vector Solution Learning Management System.

Wrote BCP (Bulk Copy Program) scripts to extract Tangent financials data using Views and MS SQL store procedures from Infor Syteline and schedule run the batch files to automatically upload the data to the Vena, Inc. Database.

Wrote MS Reporting Service Reports and call from inside Info Syteline Forms and outside of Syteline.

Redesigned and developed the logistics billing Form so that instead of manually filling in the data and information, the data is pulled from Syteline9 database automatically using MS SQL, MS SQL Reporting Service, and Infor Form Design tool.

Provided Level 1 (24 Hours Support) technical support for ERP, Database, Network, and Server issues (Each IT person will do it about 2 month per year).

Little Caesars (Pizza) Enterprise, Inc., Detroit, MI 02/2018 – 07/2020

Sr. Technical Engineer (Permanent Employee)

Enhanced Little Caesar’s (pizza chain) Point of Sale System using C# in WPF, MS SQL, and MySQL.

Worked with teams to deploy Caesars Point of Sale System to 1800+ stores before the stores’ opening.

Enhanced Little Caesar’s Command Line Screen (Production Management) using WPF / C# and MS SQL.

Redesigned and improved Caesars Altametric (HR, Forecast, Money, Reports) using ASP.NET Core (MVC), MS SQL, T-SQL, and MS Window Service (with Jason Data), Microservices.

Provided Level 3 technical support (Service Now tickets) for multiple systems.

Conducted code review for the development team.

Developed .NET version program using WPF / C#.

Designed and developed command line screen log file tool using WPF / C#.

Designed and developed universal bar code and QR code label using Telerik control and WPF / C#.

Worked with the team to redesign and develop the new Little Caesars Point of Sale System using C# in WPF and MS SQL, T-SQL.

Tested multiple projects using MSTest with C#.

Converted the command line screen log file tool from WPF / C# to UWP / C#.

Wrote a HTML iframe program to test performance of the HP register, Touch Dynamic register, and elo register.

Rewrote Little Caesars Make Line (for making pizzas) using C#, Electron.NET (.NET Core) with the MS Visual Studio Code 2019 tool.

Rewrote Little Caesars Landing (for completed pizzas) using C#, Electron.NET (.NET Core) with the MS Visual Studio Code 2019 tool.

Enhanced reports (Sales Daily Summary, Waste Summary, Time Clock, Pay Roll etc.) using PHP, MS SQL, Transact-SQL, and MySQL.

Wrote C# (.NET Core) programs to run in Linux for HP register, Touch Dynamic register, and elo register to compare the performance differences between Linux and Windows.

Compiled C# codes using MS Build and testing in a new server.

Provided level 3 technical support to Little Caesars Point of Sale System for the company’s many restaurants.

Consumed “LaunchDarkly” which runs in Amazon Web Service using .NET Core run in Google Cloud Platform.

Consumed “Azure App Configuration” using .NET Core run in Azure cloud.

Consultant from 2013 to 2017 (see below)

V

Roman, Inc., Bloomingdale, Illinois 01/2017 – 11/2017

IT Consultant (Contractor)

Developed reports for the Warehouse and Supply Chain using Oracle Application Express 5 (Oracle APEX).

Loaded data from Roman’s oracle database system to IBM Sterling Gentran EDI (Electronic Data Interchange for Retail Industry), then to Customer’s Database.

Developed purchase, order, invoice, and shipping reports using Oracle Forms 6 and Oracle Report 10g tools.

Utilized a wide array of Oracle and associated tools by using database triggers, stored procedures, functions, materialized views, external table, packages, static and dynamic SQL, and PL/SQL.

Loaded Data from Roman Oracle database system to Retailers.com database.

Loaded Data from Brandwise.com to Roman’s Database (Argus).

Enhanced Roman Warehouse.com website using C# / ASP.NET, Angular 2, Bootstrap, Ajax, and Oracle database.

Enhanced Roman Retailer.com website using Oracle APEX, C# / ASP.NET, JavaScript, and Oracle database.

Enhanced Roman.com website using PHP, C# / ASP.NET, JavaScript, HTML, CSS, and Oracle database.

Designed and developed Roman-Chase bank orbital hosted payment using ASP.NET and Oracle database.

The Bartech Group, Inc., Melrose Park, Illinois 05/2016 – 12/2016

Application Analyst (Contractor)

Navistar International Corporation Contractor

Redesigned and rewrote the Truck Engine Test Cells E-mail Client using VB.NET, MS SQL 2014, and DevExpress.

Developed test cell reports using VB.NET 2012, MS SQL 2014 Server, and ComponentOne C1Report Designer 8.

Enhanced Excel Test Cells reports using Excel 2013, VBA 2013, and Access 2013 Database.

Retrieved data from Test Cells dlls using VB.NET 2012 and Control-M.

Enhanced Access reports using VBA 2013 and Access 2013 Database.

Converted multiple Visual Basic 6 programs to VB.NET programs in Windows Forms.

Worked with vendors to support third party Engine Truck Test Software (e.g., STARS R1.5, DSP, iTest, PC Cells, and DEC) for Engine Lab computer systems.

Supported multiple systems and resolved many tickets.

Converted multiple ASP programs to ASP.NET with SQL Server 2014 and react.

Replaced STARS Hard Drive and Fan to fix the test cell hardware issues.

Created a VB.NET program to back up, retrieve, and archive STARS Data to or from Hard Drive automatically.

Used VMS commands and programs to back up and retrieve test cells data.

Sterling Engineering, Inc., Westchester, Illinois 08/2015 – 03/2016

.NET Developer (Contractor)

Electro-Motive Diesel, Inc. (One of Caterpillar Inc. Division) Contractor (LaGrage, IL)

Designed, developed, and enhanced real-time server and web-based applications on the Electro-Motive Diesel Intellitrain System – a remove diagnostics system that wirelessly connects to over 2000 locomotives worldwide using C# / MVC5, LINQ, Entity Framework, Bootstrap, Angular 2, Kendo UI, Web API, and MS SQL Server.

Worked with team on all phases of the software development life cycle.

Performed system integrated testing for multiple departments.

Synchronized Tables from Oracle (Oracle 11g) to MS SQL Server tables, using SQL Server Integration Sevices (SSIS).

Responsible for CR (Change Request) for the Electro-Motive EM2000 Control System on the locomotives using multi-thread, C/C++, Java in Linux.

Supported and resolved tickets for the Electro-Motive Diesel Microsoft Dynamics CRM.

Optomi, LLC. Downers Grove, Illinois 12/2014 – 05/2015

Senior Technical Specialist (Contractor)

BMO Harris Bank Contractor (Naperville, IL)

Redesigned and rewrote the BMO Harris Bank Account Review Regulation 9 Oversight (ARRO) System using ASP.NET / C# and Microsoft SQL Server database.

Enhanced BMO Harris Bank Account Review Regulation 9 Oversight (ARRO) System using ASP.NET / C# and Microsoft SQL Server database.

Enhanced BMO Harris Bank Account Synoptic Review (ASR) System using C# / MVC4, AngularJS, and Microsoft SQL database.

Reviewed business requirement documents.

Reviewed technical design documents.

Used IBM AppScan tool to scan .NET projects, then rewrote .NET codes to increase the security for BMO Harris Bank.

Resolved tickets and supported multiple systems.

United States Government – Department of Veterans Affairs Contractor 08/2013 – 12/2014

Hines, Illinois

Software Engineer (VA Contractor)

Redesigned and rewrote the VA Web Automated Folder Processing Web Sites (Web AFPS) from ASP to ASP.NET / VB.NET with Oracle database.

Converted the Web AFPS jobs (for Veterans retirement and relocation) from Visual Basic 6 (VB6) to VB.NET in Window Forms with Oracle Database.

Provided technical support and resolved helpdesk tickets for the Modern Award Processing (MAP-D) Veterans Benefit System using Oracle 11g in UNIX and Linux.

Provided technical support for the Veterans Rating Board Automation (RBA2000) System (Trace and Review Class Modules Codes, Forms Codes, and Modules Codes) using Visual Basic 6 (VB6) and MS Access.

Provided technical support for the VETSNET Suite Systems.

Completed over 580 tickets with less than 1% production errors. Supported multiple systems with very high customer satisfaction.

Converted the DOD (Department of Defense) Transportation Benefits Web Application (ASP.NET / VB.NET 2005 with MS SQL Server 2005) to VA Transportation Benefits Web Application using ASP.NET (.NET 2013) and MS SQL Server 2014.

Enhanced the VA (Veterans Affairs) Transportation Benefits Web Application using ASP.NET (.NET 2013), MS SQL Server 2014, Active Directory, and Crystal Reports.

^

American Hotel Register Company, Inc., Vernon Hills, Illinois 06/2008 – 07/2013 (5+ years)

Lead E-Commerce Developer / Sr. Systems Analyst (Permanent Employee)

Enhanced the Customer Relationship Management (CRM) System (Pivotal 5.9) by using Oracle 10g, ASP.NET / C#, ADO.NET, Visual Basic 6 (VB6), VB Script, and Crystal Report 11.

Redesigned/Converted Pivotal 5.9 CRM from Oracle 10g Database to MS SQL Server 2008 Database.

Redesigned and enhanced the OPAL (Order and Billing Management System) System using VB.NET and MS SQL Server 2012 in Window Forms.

Managed a team with 6 developers

Designed and developed Pivotal BlackBerry Web Applications (Pivotal 5.9, C# .NET DLLs).

Created and enhanced Pivotal CRM Forms (Search abilities) and reports using C# and WPF.

Provided technical support to Pivotal 5.9 CRM system for 600+ users.

Designed and developed the EventTracker system using ASP.NET, Python, and MS SQL Server 2012 Database.

Designed and developed the “Sale and Marketing Reports” system using ASP.NET 3.0 / C#, Oracle 10g, and Crystal Reports 11.

Worked with Pivotal 5.9 CRM Administrator (Back up BM and ED) to support the system.

Worked with IBM iSeries AS/400 developers, Web developers to enhance Pivotal 5.9 system.

Enhanced the Pivotal CRM via customization, modified Database, and developed new client scripts.

Loaded Data (using Oracle PL/SQL) from company Website and ASW (ERP that runs iSeries AS/400, using DB2 and coded in RPG) to Pivotal Oracle Database.

Created/enhanced VBA reports (Oracle & MS SQL Server Databases) for Sales and Finance Departments.

Created/enhanced SAP Business Object reports (DB2 & MS Access Databases) for Sales and Finance Departments.

Designed/enhanced Design Point (company graphical/pictorial FF&E Web applications) using Ruby on Rails (Models, Views, and Controllers Architecture), JQuery, Ajax, and Coffee Script.

Added Design and FF&E Applications to the main website developed via ASP.NET 4.0 / C# and MVC.

Redesigned/Converted Pivotal 5.9 CRM to Pivotal 6.0 CRM (SharePoint, MS SQL Server 2012, C# .NET DLLs).

Worked with Pivotal Consultants to design and develop Pivotal iPad Web Applications (Pivotal 6.0, C#, LINQ, WCF, and Entity Framework).

Involved in agile methodology process for scrum, sprint planning and retrospective meetings for better sprint results.

CareerBuilder, LLC. (CareerBuilder.com), Chicago, Illinois 08/2006 – 06/2008

Software Architect (Permanent Employee)

Enhanced Customer Relationship Management (CRM) System (Pivotal 5.9), increasing revenues by 260%, using SQL Server 2005, ASP.NET 2.0, Web Service, and MS Reporting Service 2005.

Managed a team with 3 developers

Designed/developed CRM tools (IM upload tool, Account DID with Lead and Company tool, Territory Violation

Tool, etc.) Using Dun & BradStreet Integrated Manager, D & B database, DTS 2000, MS SQL Server Integration Services (SSIS), MS SQL Server 2000 and 2005, and Visual Studio .NET 2005.

Designed and developed the “Organization Lead Company Tracking” system using ASP.NET / VB.NET, Photoshop, Java Script, Telerik RadGrid and Controls, Ajax, and SQL Server 2000.

Provided technical support to Pivotal 5.9 CRM system with 1300+ users.

Enhanced/changed Pivotal CRM data using Pivotal Agents and Pivotal Queue Processor.

Consultant from 2000 to 2006 (see below)

V

Horizon Technology Partners, Inc., Palatine, Illinois 02/2006 – 06/2006

Computer Consultant (Contractor)

Enhanced SurveyGold software using HTML and JavaScript.

Designed and developed the Clinician Forum software using C# / ASP.NET and SQL Server 2005.

Designed and developed VMAP Website using C# / ASP.NET and SQL Server 2005.

Developed EmailMissingDayReport program using C# .NET and SQL Server 2000.

Enhanced TimeTracker system using ASP and MS SQL Server 2000 / MS Access.

Designed and developed Web Registration system using netForum, ASP.NET, leverage software Web service integration, and SQL Server 2000.

Enhanced ISI program using Visual Basic .NET, Infragistics controls, and SQL Server 2000.

Monster / TMP (Monster.com), Inc., Milwaukee, Wisconsin 01/2005 – 11/2005

Software Engineer Consultant (Contractor)

Designed, developed, and enhanced the Monster “Directional Marketing Order Management System” (Order and Billing for Yellow Pages and White Pages) software using C# .NET and SQL Server 2000.

Developed extensive system with n-tier architecture (3 Horizontal layers and 2 Vertical layers) with large team of developers.

Utilized a wide range of applications and tools including .NET Remoting and WinForms, OOP, OOD, XML, SOAP, ADO.NET (Data Reader, Data Set, Typed Data Set), Oracle Financials, Data Grid, Janus Grid, DataView Manager, CurrencyManager, AdRotator Control (using advertisements data located in an XML file, e.g. U.S. map), Transaction Control, ASP.NET, ASP, T-SQL, Stored Procedure, UML, load balance, Smart Client, MSMQ, TCP/IP, Web Services, Web Farm, Window Services, Nunit, WinRuner, LoadRuner, test drive development, Perforce, Microsoft SQL Server 2000 Reporting Services, and PDF Reports.

Metavante (M&I Bank) Corporation, Willowbrook, Illinois 08/2004 – 01/2005

Senior Computer Consultant (Contractor)

Developed/modified “Metavante Inventory” software using Visual Basic .NET, SQL Server 2000, and Microsoft SQL Server 2000 Reporting Services in Window Forms.

Developed “Credit Card Image Picture” download program using Web Service, XML, and VB.NET.

Developed Auto File Mover software (including Auto Zip files and UnZip files (VB.NET)) using Window Service, FileSystem Watcher, and Visual Basic .NET.

Enhanced U-PASS (Chicago CTA Bus PASS) software using Visual Basic 6 (VB6), and SQL Server 2000.

ITT Industries (ITT Defense), Inc., Fort Wayne, Indiana 04/2004 – 07/2004

IT Consultant (Contractor)

Converted Paradox 9 TRAX system to company Intranet using C# / ASP.NET (Visual Studio .NET 2003, DreamWeaverMX 2004, J# Component).

Redesigned/implemented SQL Server 2000 database using stored procedures, Transact-SQL, database triggers, and static and dynamic SQL for application.

Developed “TRAX Asset Management Software – Intranet (Web)” using C# / ASP.NET, SQL Server 2000, T-SQL, ADO.NET, Crystal Reports, MS SQL Server Reporting Services, HTML, and JavaScript.

Talent Technology, Inc., Lisle, Illinois 11/2001 – 03/2004

Computer Consultant (Contractor)

Developed “Accounting” software using C# / ASP.NET, SQL Server 2000, BizTalk, RUP, and LLBL Gen Pro.

Developed car insurance software using Visual Basic .NET, SQL Server 2000, SharePoint, ACT, Globalization, XML, XSLT, HTML, CSS, and ASP.NET. (Also, converted ASP to ASP .NET.)

Developed “Movie Admin” software using Visual Basic .NET, ASP.NET, ADO.NET, XML, HTML, Cascading Style Sheets, Crystal Reports, SQL Server 2000, IIS, T-SQL, and VB Script (Intranet, and also Window Forms).

Worked with Oracle DBA to migrate an Oracle project accounting system.

Developed restaurant help database system using Windows Forms on Oracle and Visual Basic .NET.

Developed “WebReports” using C#, ASP.NET, Oracle 9i, PL/SQL, SQL Server 2000, IIS, Transact SQL, Java Script, DHTML, XML, COM, COM+, Microsoft SQL Server 2000 Reporting Services, Web Services, MDX, MS Analysis Services / OLAP, Data Warehouse, and Business Intelligence.

Tellabs Operations, Inc., Lisle, Illinois 12/2000 – 11/2001

Sr. Software Engineer (Contractor)

Performed system software load builds and improved load building process using C, C++, Korn Shell (Unix Shell Script), C Shell, ClearCase, DDTS, ClearQuest, Perl, and Makefiles.

Implemented defect tracking system with ClearCase, Oracle, and Pro*C.

Supported custom workflow tools and developed new tools using Perl and ClearCase, as well as Java.

^

Motorola, Inc., Schaumburg, Illinois 01/1997 – 11/2000 (4 years)

Sr. Programmer Analyst / Software Engineer (Permanent Employee)

Cellular Infrastructure Group, Computer Information Department

Developed, as a member of small and large teams, Cellular Infrastructure Group Business System for finance and manufacturing, including requirements drafting, design, coding, debugging and maintenance.

Utilized a wide array of Oracle and associated tools in support of the group effort, including Oracle Receivables 10.7, Oracle Project Accounting 10.7, Pro*C, Oracle Developer/2000 Forms 5.0 and Reports 2.5, Oracle Data Warehouse, database triggers, stored procedures, static and dynamic SQL, PL/SQL, SQL *Plus, Brio Query Reports, C, C++, Unix, Korn Shell, Bourne Shell, Views, ERP, and ActiveWorks.

Managed an Oracle team with five developers and received Exceptional Contribution Award.

Integrated Dispatch Enhanced Network Group, an organization responsible for the Motorola Integrated Dispatch Enhanced Cellular Network, a system combining wireless voice, paging, data, and messaging technology.

Coded in C, C++ and Korn Shell in a UNIX environment (Source Control using ClearCase).

Developed Graphical User Interfaces (GUI’s) with Motif and Java

Designed/developed Motorola IDEN wireless system using Informix, TCP/IP, Simple Network Management Protocol, Frame Relay, Inter-Process Communication, semaphores, simulators, event management, and mobile data gateway fault management. Reduced development interval by 60%.

CERTIFICATIONS / PROFESSIONAL DEVELOPMENT

Oracle 8, 9i for Application Developers

Oracle Developer/2000 Forms 5.0, 6i

Oracle Developer/2000 Reports 2.5, 6i

Oracle Projects Accounting Advanced Topics Release 11

Oracle 8 PL/SQL, 9i PL/SQL

Oracle 11 g

Oracle 12 c

Oracle Define Flexfields Release 11

Oracle 7 Database Administration

Oracle 9i Database Administration, Backup & Recovery, Performance & Tuning, and Network Administration

Oracle Application Express 5 (Oracle APEX)

Oracle Personal Time and Expense 2 (Oracle PTE)

Microsoft SQL Server 2008 for Application Developers

Java Programming

Advanced Programming in Unix and Korn Shell

Microsoft .NET (Visual Basic .NET, C#, J#, ASP.NET, IIS, ADO.NET, XML, XSLT, SOAP, and Web Services)

Visual Basic 6 Programming

Object Oriented Analysis and Design

C++ Programming

ASP Programming

Data Warehouse / Business Intelligence (ETL Using SQL Server DTS, OLAP With SQL Server Analysis Services, MDX), and Microsoft SQL Server 2000 Reporting Services

SAP Business Objects

Crystal Report 11

Microsoft Visual Studio .NET 2010

Microsoft C# .NET 2013

Microsoft Visual Studio .NET MVC 4

MS LINQ to objects, LINQ to SQL, Entity Framework

Microsoft Dynamics CRM for developer

Microsoft Dynamics CRM 365

ASP.NET Core

Electron.NET

Ruby on Rails, Ruby Programming

SharePoint 2013 for developers

MS SQL Server 2012 Database Administration

Azure SQL Database for the MS SQL Server DBA

Getting Started with Power BI

React

MicroServices Architecture

Residence Status: U.S. Citizen

Trilingual (English / Mandarin Chinese / Cantonese Chinese)

H-Phone: 630-***-****

Contact this candidate