Kejian Wu
Lisle,USA
Summary
Dynamic Software Architect with extensive experience at CareerBuilder, LLC, enhancing CRM systems and driving revenue growth by 260%. Proficient in .NET and MS SQL, I excel in leading teams and delivering innovative solutions that meet complex business needs. Strong analytical skills complement my technical expertise, ensuring successful project outcomes.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Software Architect / Lead Business Consultant
CSCI Consulting, Inc.
, AZ
04.2023 - Current
- Enhanced Infor CloudSuite Industrial (CSI) / Syteline Purchase Order Form using VB.NET (with MS .NET DLL and Mongoose Library), and MS SQL
- Improved 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. (Multi Tenant: Chicago, Phoenix, Windsor-Canada)
- Managed a project to convert QA Excel Reports to MS Reporting Service Reports (Infor SyteLine ERP).
- Managed a team with 3 developers.
- Fulfilled requirements from multiple users in various departments (e.g., finance, accounting, manufacturing, engineering, HR, marketing, and more)
- Enhanced _HELG_MRR Serial Form using Infor BIRST, and MS SQL Store Procedure.
- Redesigned and rewrote _HELG_Order Shipped Cost report using MS Reporting Service, and MS Azure SQL.
- Redesigned and enhanced Infor CloudSuite Industrial/Syteline APS (Advanced Planning and Scheduling) Forms using VB.NET, and MS SQL.
- Developed strong expertise in supply chain technology-related systems and solutions (both internally and externally).
- 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.
- Improved NSA User permissions view.
- Wrote requirements, collaborated with business and project teams to capture and document requirements and expected functionality of the proposed solution.
- Enhanced MRR Problem serial query Form in 3 sites (Chicago, Windsor, Phoenix) VB.NET, and MS SQL.
- Researched Project Manager Forms.
- Developed finance reports using MS Power BI and VSTO.
- Resolved tickets for Factory Track.
- Enhanced the data upload program using Java and Oracle.
- Researched EDI (Electronic Data Interchange), which will be integrated with Boeing Company (Sikorsky) and Northstar Aerospace.
- Enhanced Infor LN Accounting and Finance Forms Windsor-Canada)
- Resolved Infor LN tickets
- Worked as an Infor LN Administrator
- Enhanced QC_Quality Control Form using IDO, MS SQL, and MS Reporting Service.
- Enhanced Follett 'Course Track' Web Application using MS SQL, XML, SSIS, and ASP.NET Core / C#.
- Enhanced Follett 'SAM' enrollment Web application using MS SQL, Window Service, Web Servicer, and ASP.NET / C#.
- Converted FTP (File Transfer Protocol) EDI to SFTP (Secure File Transfer Protocol - to add a layer of security) EDI using SSH.NET Library.
- Enhanced Sales Forms using Infor M3 and MS SQL.
- Supported and resolved tickets for 'Course Track' and 'SAM'.
- Added Log File reports using MS Power BI.
- Supported Defense Finance and Accounting Service (Army and Navy) Payroll Software using Oracle / PL SQL.
- Involved in agile methodology process for scrum, sprint planning and retrospective meetings for better sprint results.
- Downloaded Oracle code from the H0068 branch to my local computer and set up in Beyond Compare.
- Completed testing for all Oracle database access that work for Sqlplus.
- Completed testing for all Oracle database access that work for Toad.
- Synchronized Oracle Branch.
- Completed coding for 3 Materialized Views and moved to repo for review.
- Wrote the unit test script for 'STRY0224130 H0068: P_
- _Idx Conditional Drop/Create'.
- Used test-driven development (TDD) to do the testing for many store procedures.
- Conducted codes reviews for other developers.
- Modified and enhanced the payroll programming use Java, and Oracle.
- Wrote store procedures in IBM DB2 and added index to improve the performance.
- Worked as an Oracle DBA to back up Database, create new test Database for new developers, and create indexes.
- Northstar Aerospace/Defense(DOD) Finance & Accounting/TurbineAero
Programmer Analyst / MS SQL Administrator
Tangent Technologies (Tangent Materials), LLC
Aurora, IL
08.2020 - 03.2023
- 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.
- Led and coached a junior developer.
- Obtained requirements from users.
- Reviewed business requirement documents.
- Led ERP projects.
- Enhanced multiple supply chain reports using crystal reports and MS SQL.
- Worked for stakeholders to reduce ERP cost and save money by introducing new technologies.
- Communicated with Vendors and the consultant company; managed the projects and consultants.
- Enhanced Infor CloudSuite Industrial/Syteline ERP Accounting and Financial Forms using MS SQL, VB.NET, and Infor Form Design tool (Winstudio).
- Obtained requirements from multiple users in multiple departments (e.g., finance, accounting, manufacturing, engineering, HR, marketing, and more).
- Enhanced Infor CloudSuite Industrial/Syteline ERP Manufacture Forms using VB.NET, MS SQL, MS SQL Reporting Service, and Infor Form Design tool (Winstudio).
- Collaborated with business teams to understand project requirements, shape the initial project request, and provide a high-level estimate of the project effort and costs used in cost-benefit analysis.
- 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 and MS Azure SQL.
- 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', Also, Call 'Application Studio').
- 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, MRP group, Enterprise Asset Management (EAM) Group, Tax Interface Group, CPQ, 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, Epicor, and CloudSuite Industrial/Syteline ERP.
- Designed Tangent Training Tracker Software (Database Design, Business Flow Chart) and coded and tested the software using WPF, C#, 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.
- Enhanced QA reports using MS Power BI.
- 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 Syteline 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 provide this support for about 2 months per year).
Sr. Technical Engineer
Little Caesars (Pizza) Enterprise, Inc.
Detroit, MI
02.2018 - 07.2020
- 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, Angular 10, 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 Java, MS SQL, Transact-SQL, and MySQL.
- Provided technical support to CloudSuite Industrial/Syteline ERP (CSI).
- Wrote C# (.NET Core) programs in Docker Container 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.
- Using CI/CD (Continuous integration, Continuous delivery, and Continuous deployment).
- Provided technical support to Infor CPQ ERP.
- 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 (AWS) using .NET Core run in Google Cloud Platform (GCP).
- Consumed 'Azure App Configuration' using .NET Core run in Microsoft Azure cloud.
IT Consultant
Roman, Inc.
Bloomingdale, IL
01.2017 - 11.2017
- 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.
- Provided technical support to Infor SmartStream.
- 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 6, 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.
- Worked with client stakeholders that helps them save money by introducing new technologies.
- Worked with IBM iSeries to enhance the Warehouse.
- Obtained requirements, designed and developed Roman-Chase bank orbital hosted payment using Java and Oracle database.
Application Analyst
The Bartech Group, Inc.
Melrose Park, IL
05.2016 - 12.2016
- 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.
.NET Developer
Sterling Engineering, Inc.
Westchester, IL
08.2015 - 03.2016
- 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 multithread, C/C++, Java in Linux.
- Supported and resolved tickets for the Electro-Motive Diesel Microsoft Dynamics CRM.
Senior Technical Specialist
Optomi, LLC.
Downers Grove, IL
12.2014 - 05.2015
- 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.
Software Engineer
United States Government - Department of Veterans Affairs
Hines, IL
08.2013 - 12.2014
- 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 Java, 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.
Lead E-Commerce Developer / Sr. Systems Analyst
American Hotel Register Company, Inc.
Vernon Hills, IL
06.2008 - 07.2013
- 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 and managed many large projects.
- 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.
Software Architect
CareerBuilder, LLC.
Chicago, IL
08.2006 - 06.2008
- 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 and managed many projects.
- 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.
Education
Cybersecurity Certificate -
U.S Department of Defense
02.2024
M.S. - Computer Science
Illinois Institute of Technology
Chicago, Illinois12.1996
B.S. - Electrical Engineering
University of Illinois at Chicago
Chicago, IllinoisSkills
- Java
- JavaScript
- JQuery
- Ajax
- Angular JS
- Angular 2
- Angular 6
- Angular 10
- Typescript
- React
- Bootstrap
- HTML
- NET
- C#
- ASPNET
- VBNET
- ASPNET MVC
- ASPNET Core
- Blazor
- ADONET
- Microsoft Dynamics CRM
- Pivotal
- Salesforce
- Infor CRM
- SharePoint
- MS SQL Server
- SSIS
- WCF
- Web API
- ElectronNET
- XML
- JSON
- NET Web services
- NET Windows Form
- WPF
- UWP
- Window Services
- NET Remoting
- Object-Oriented development
- Reports
- Crystal Reports
- Brio Reports
- Oracle Reports
- SAP Business Object Reports
- VBA Reports
- MS Power BI
- ComponentOne C1Report Designer
- Oracle
- Oracle APEX
- Oracle Project Accounting
- Oracle Financials
- Ruby
- Ruby on Rails
- Perl
- Python
- PHP
- Visual Basic 6
- VB Script
- VBA
- ASP
- Manufacturing Experience
- ERP
- Infor CloudSuite Industrial
- Syteline
- Mongoose Framework
- Infor CPQ
- Infor LN
- Infor M3
- Infor SmartStream
- Infor BIRST
- Infor ION
- Oracle Receivables
- Quick Book
- Epicor
- Shop-Track
- Factory Track
- American Hotel Billing Management System
- Roman Argus
- Marketing Order Management
- MS Dynamics 365
- NET Framework
Certification
Cybersecurity Certificate, U.S Department of Defense, 2024-02-15
Technical Skills
Java, 12, .NET, 19, CRM Systems, 6, MS SQL Server, 13, WCF, 3, .NET Web development, 5, Object-Oriented development, 20, Reports, 5, Oracle, 9, Ruby, 2, Visual Basic, 5, Manufacturing Experience, 10, Infor CloudSuite Industrial (CSI), Syteline, Mongoose Framework, Infor CPQ, Infor LN, Infor M3, Infor SmartStream, Infor BIRST, Infor ION, Oracle Project Accounting, Oracle Receivables, Quick Book, Epicor, Shop-Track, Factory Track, American Hotel Billing Management System - Custom ERP, Roman Argus - Custom ERP, Marketing Order Management - Custom ERP, MS Dynamics 365, 10
Security Clearance
- Secret Clearance, Active
- Federal Security Clearance, BI Level, Inactive
Residence
900 McKenzie Station Dr., Lisle, IL, 60532, Gibert, AZ
Timeline
Software Architect / Lead Business Consultant
CSCI Consulting, Inc.
04.2023 - Current
Programmer Analyst / MS SQL Administrator
Tangent Technologies (Tangent Materials), LLC
08.2020 - 03.2023
Sr. Technical Engineer
Little Caesars (Pizza) Enterprise, Inc.
02.2018 - 07.2020
IT Consultant
Roman, Inc.
01.2017 - 11.2017
Application Analyst
The Bartech Group, Inc.
05.2016 - 12.2016
.NET Developer
Sterling Engineering, Inc.
08.2015 - 03.2016
Senior Technical Specialist
Optomi, LLC.
12.2014 - 05.2015
Software Engineer
United States Government - Department of Veterans Affairs
08.2013 - 12.2014
Lead E-Commerce Developer / Sr. Systems Analyst
American Hotel Register Company, Inc.
06.2008 - 07.2013
Software Architect
CareerBuilder, LLC.
08.2006 - 06.2008
Cybersecurity Certificate -
U.S Department of Defense
M.S. - Computer Science
Illinois Institute of Technology
B.S. - Electrical Engineering
University of Illinois at Chicago