Sql Server C#
Resume:
Kevin Lou
**** ******* *** ****, **** Bloomfield, Michigan 48323
Phone: 248-***-**** Email: **********@*****.***
SUMMARY An experience IT and Software Development Professional with over 30 years of experience in development, implementation, testing and maintenance of software applications. Possesses solid full life cycle development and design patterns experience including requirements analysis, design, specifications, extensive coding, testing, and documentation. Highly skilled in .Net Core, Blazor, MVC, ASP.NET, C#, VB.NET, Web Services, ASP, AJAX, SQL Server, SSRS,SSIS, Web Based Applications, VB, ActiveX and COM components in Client/Server, and Highly skilled in developing data models and in writing complex stored procedures using T-SQL. Excellent analytical and interpersonal skills. Self-Starter with the ability to think fast and learn quickly. U.S. Citizen and Active Secret Security Clearance.
OBJECTIVE To obtain a Software Developer position with over ten years’ software developing experience DATABASE SQL Server, MySQL, Oracle, dBase, Access
SOFTWARE Visual Studio 2022, SQL Server 2012, SSRS, SSIS, Crystal Report2013, Android Studio, Visual Code Studio, Visual InterDev 6.0, Visual Basic 6, Telerik, DevExpress, Infragistics, Git, Azure Devop, Team Foundation Server, Visual SourceSafe, Visio, Photoshop, FrontPage, Word, Excel, PowerPoint, Projext, RoboCopy, PostMan LANGUAGES Blazor Server(4yr),Core MVC, MVC(8yr),ASP.NET(14+yr), C#(14+yr), VB.NT(14+yr), AJAX(14+yr), ASP(10+yr), Linq(10+yr), T-SQL(20+ yr), PHP, C++, C, Visual Basic(10+yr), JavaScript, TypeScript/Angular, JQuery, Json, VBScript, DHTML, XML, VBA, RPG IV, PL/SQL, SQL*PLUS, PRO*C, Pascal, Fortran, QBASIC, UML,TypeScript, Ionic, NodeJS
EXPERIENCE
03/15 – Present Sr. Software Developer, Lear Corporation, 21557 Telegraph Rd, Southfield, MI 48033 Responsibilities include: Develop, maintain and support Web, Windows Console applications and Database using C#/VB.Net/ASP.NET/Core/MVC/SQL Server/VB6/Classic ASP/SSIS/ETL/AS400/Crystal Report/Telerik/WCF/WebAPI, Xamarin, Ionic
• Developed and maintain MOS App from back end to front end using Blazor Server/Net 6.2/Telerik/C#/SQL server. It is a data repository for monthly, weekly and daily KPI’s for Corporation Financial Reporting
• Developed and maintain RAMP App from back end to front end using Blazor Server/Net 6.2/Telerik/C#/SQL server. It manages Recovery Action Management Plan documents; organize, store and shares these documents
• Developed and maintain GM PO App from back end to front end using Blazor Server.Net6.2/iText/Telerik/C#/SQL server. It stores GM contract pdf files in file system and stores extracted key items in DB for review
• Developed and maintain ISO Monitor App from back end to front end using Blazor Server.Net 6.2/Telerik/C#/SQL server. It allows linkage to plant ISO monitoring hardware so users can monitor ISO
• Developed and maintain Service Part Management App from back end to front end using Blazor Server.Net 6.0/Telerik /C#/SQL server. It manages service part shipment by both the Lear Service center and any plant engaged in the service part business
• Developed and maintain Lear Layer Process Audit mobile App using Ionic (front end) and MVC/C#/SQL server
(Web API back end). It supports 24 languages and is used in more than 300 plants and more 16000 users globally
• Developed and maintain Backup Scanning and Receiving mobile App for MC9XXX Zebra scanners using Xamarin/Android
• Enhanced and maintain Window based Measuring Bridge Window Based App developed using VB.Net/SAP.net/Zxing.Net 016.9/Net Connector 3.0/SQL server. The application connects to Measuring Bridge machines via serial port, reads data from the MB machine, and post average hide size, the number of hides in the lot and the areas of the complete lot to SAP or AS400/BPCS. It prints 1 X 2-inch QR labels
• Developed and maintain iNET Logistical Data App from back end to front end using Core MVC 2.1/SQL Server/Telerik. It houses up to 10 years of iNet logistical data and provides the user with an interface to search that data
• Developed and maintain Corporate Invoicing App from back end to front end using Core MVC 2.0/SQL Server/Telerik. The system does; corporate invoice I/C trading partners (ship to location) for the charges incurred on behalf for charge out
• Developed and maintain Global Audit Management App (GAMS) from back end to front end using MVC/C#4.5/SQL Server Server/Telerik. The system does; request an on-site audit of a Supplier manufacturing location, monitor the status of pending audit, and Review results of previous supplier audits.
• Developed and maintain Asset Management App from back end to front end using MVC/C#4.5/SQL Server/Telerik/Crystal Report. The system tracks assets in plants and is used to track equip availability to transfer
• Developed and maintain Project Status Report App from back end to front end using MVC/C#4.5/SQL Server Server/Telerik. It tracks monthly PAR Spending
• Developed and maintain Folder Administration App from back end to front end using MVC/C#4.5/SQL Server Server/Telerik. This system allows authorized users (folder administrators) to control the contents of their assigned folders. These folders may contain other folders, web-links, calendars, and documents 05/14 – 03/15 Sr. Software Developer, Henry Ford Health System/HAP, 4700 Schaefer Road, Dearborn, MI 48126 Responsibilities include: Develop, maintain and support Web, Windows Console applications and Database using C#/VB.Net/ASP.NET/MVC/SQL Server/VB6/Classic ASP/SSIS/ETL/AS400/Crystal Report/Telerik/EDIDev/WCF
• Developed and maintain Provider System from back end to front end using SQL Server&SSIS2012/C#&ASP.Net 4.5/Telerik 2014/GoogleMapAPI (http://www.midwesthealthplan.com/FindAProvider.aspx)
• Developed Provider Directory (PDF file) using Crystal Report 2013
• Developed Explanation of Benefits Report System using SQL Server&SSIS2012/Crystal Report 2013
• Developed and maintain IT Request System using MVC/C#/ASP.Net 4.5/Telerik/SQL server
• Developed EDI835 Processing System using SQL Server&SSIS2012/C#4.5/EDIDev 06/13 – 05/14 Sr. Software Developer, Takata, 2025 Harmon Road, Auburn Hills, MI 48326. Contracted through BCCI Responsibilities include: Develop, maintain and support Takata Intranet and TakataNet application using C#/VB.Net/ASP.NET/MVC/SQL Server/WCF/Web Service/VB6/Classic ASP. TakataNet is a web based application that allows users to share documents & messages. These documents can be routed for approval.
• Developed mobile website for TakataNet so users can use mobile devices to approve routing document
• Upgrade TakataNet site from .Net 2.0 to .Net 4.0
• Merge Brazil TakataNet site to NA TakataNet site
• Support several thousand TakataNet users.
01/12 – 06/13 Sr. Software Developer, Kuka, 6600 Center Drive, Sterling Heights, Michigan. Responsibilities include: Develop and maintain applications using C#/VB.Net/ASP.NET/SQL Server/WCF/Web Service/Windows Service/X++/SSRS 2008/DevExpress/Excel 2010
• Develop and maintain Window Based ProTrack application that tracks projects information, and is integrated with Microsoft Dynamics AX
• Develop and maintain Web Based Business Gateway application that is used by market people to create program, market, and RFQ.
• Develop Windows Services for processing EDI files and Agile BOM xml files
• Develop and customize Microsoft Dynamics AX 2012 forms & reports by using X++&SSRS 2008 07/08 – 01/12 Sr. Software Developer, DRS Technologies, 900 E Whitcomb,Madison Heights, Michigan 48071.Contracted through Right Angle Staffing
Responsibilities include: Design, develop and maintain applications using C#/ASP.NET/ADO.NET/AJAX/Linq and related Microsoft technologies with strong emphasis on accessing data from relational SQL server databases.
• As a core team member, developing and maintaining Web Based Tactical Vehicle Program Data Management Systems (TVPDMS https://tvpdms.army.mil/) for U.S. Army TACOM. This system tracked the issue and fielding of FMTV vehicles to US. Army units, and allowed government personnel to track the engineering change process to include assignment, review, approval and implementation of engineering changes. 09/98 – 07/08 Sr. Programmer/Administrator, Headquarter, Plastech Engineered Products Inc. 22000 Garrison, Dearborn, MI Responsibilities include: using Microsoft’s Enterprise Development Strategy to build modern, scalable business solutions that improve the flow of information and integrate with existing AS400 system (Future 3 and JBA), and maintaining existing systems.
• As a team member, developed web based Product Life Cycle Management System (PLM) by using VB.NET/ASP.NET/ADO.NET. This system has Customer Quoting, Supplier Quoting, Bill of material, Product Change and Program Management Modules.
• Developed web based Premium Material Planning & Logistics System (PMPL) by using C#/ASP.NET/ADO.NET. This system tracks all of company’s Premium Material Planning & Logistics disputes, sends alert email to top management, and provides premium material planning & logistics department with alerts to minimize premium material planning & logistics errors.
• Developed web based Plastech Request System by using C#/ASP.NET/ADO.NET. This system includes IT Request, Travel Request, and Expense Request, etc.
• As a team leader, developed web based Quality Customer Concern Management System (QM) by using ASP This system tracks customer concerns and automates all quality procedures, 8D Corrective Action and Lesson to Learn.
• As a team member, developed web based Purchase Order Requisition System by using ASP. This system manages purchase order requisitions. It is integrated with JBA System to generate PO.
• Developed Web Report System for Plastech’s Intranet Web Site that was integrated with JBA and Future 3 in AS 400, and SQL database to produce a variety of dynamic reports by using Crystal Report 8.5, SQL Reporting Services 2005, ASP, ADO, ODBC, and AS400/ RPG IV.
• Developed windows based ILVS (In line Vehicle System) software system for the assembly line in Plastech’s Louisville facility, that made plastics parts for Ford Motor’s 2002 Explorer and Mercury Mountaineer. It was integrated with Future 3 and JBA in AS400 using Visual Basic 6.0, windows client software and RSSidewinderX 2.0 to Interface with a PLC program run in SoftLogix5 2.0, which controls fixtures through DeviceNet network 2.0 and Flex I/O 1794.
05/94 – 09/98 Programmer/Administrator, Plastech Engineered Products Inc’s St. Claire Shores Facility, St. Shores, MI 48082 Responsibilities include: Developing and Maintaining Software & Database for manufacturing under DEC Alpha, DEC VAX and Windows NT, administrating a DECnet-VAX and Windows NT Networks which are across Seven Facilities in Michigan and Ohio states.
• Developed Scheduling Information System. The system was integrated with the existing Plastic’s Management System developed by DTR and EDI Sales Order System using Oracle 7.0, SQL*Forms SQL*Menu, SQL* ReportWriter, PL/SQL, PRO*C, under VAX 4700.
• Developed windows base Wage Reporter Application integrated with DTR payroll system in VAX. It generated a variety of W-2 and Quarterly wage reports (Federal, State, City) using Visual Basic 4.0/Access 4.0.
• Developed windows base Part Quotation Software which calculated part quotation using Visual Basic 3.0 and Access 2.0.
• Developed Time Clock System, which used a scanner to scan the bar codes to get check-in and check-out time for each person under different shifts and then generate a weekly report for payroll department using PC 486/MS C 7.0.
• Developed VOC software, which calculated VOC and generated a variety of VOC reports (volatile Organic compound) by using PC 486/Pascal.
01/93 -05/94 Research Assistant, Health, Physical Education and Recreation, Wayne State University, Detroit, MI 48202
(Part time) Responsibilities include: performing PC based sport test equipment and software package design for sport science research.
• Developed Computerized Wingate Bike Test Equipment by using {Quick Basic}/IBM PS/2 486.
• Developed Software Package for Sport Data Statistics by using {C/C++ 7.0}/IBM PS/2 486. 10/86 - 8/92 Programmer/Analyst, China Eastern Airlines Corporation. Shanghai 200031, China. Responsibilities include: performing software system design for business management.
• A member of developing group working on designing, developing, coding and testing Hotel Management System Software for Shanghai International Airport Hotel using {C & DBASE III}/IBM PS/2 286/NOVELL 286B.
• Designed, coded and tested Personnel Information Management System to manage employee's personal data, time card processing, wage, and benefit information using {C & DBASE III}/IBM PS/2 286. 5/82 - 10/86 Electronics Engineer, Product Developing Division, Shanghai No. 26 Radio Company. Shanghai 200450, China. Responsibilities include: Developing Microprocessor Embedded Microwave Measuring Instruments, IEEE-488
(GPIB) Interfaces and Automatic Microwave Measuring Systems using microprocessor (8015, 8086, and 6502 Microprocessor) and Apple II & HP 85.
EDUCATION • M.S in Computer Engineering, (9/92 -5/94), College of Engineering, Wayne State University, Detroit, MI 48202
• B.S in Computer Science, (09/79 - 05/82), Shanghai University of Science & Technology, Shanghai, China TRAINING
• Developing Cross-Platform Web Apps with Blazor Workshop (06/08/2020 – 06/11/2020) 4-Day Virtual Workshop. 21557 Telegraph Rd, Southfield MI 48033-4248
• .NET Core: Developing Cross-Platform Web Apps with Asp.NET Core (04/09/18 – 04/11/18) Building #400, 21557 Telegraph Rd, Southfield MI 48033-4248
• Programming in HTML5 with Javascript and CSS3 (10/16/17 - 10/20/17) ONLC Training Centers, 26677 W. Twelve Mile Road, Suite 147, Southfield, MI 48034,
• Core Web Application technologies with visual Studio 2005 (08/08/07 - 08/10/07) New Horizons computer Learning Centers, 14115 Farmington Road, Livonia, MI 48154
• Microsoft Business Intelligence Hands on Lab (04/1/06 - 04/1/06) New Horizons computer Learning Centers, 14115 Farmington Road, Livonia, MI 48154
• Mastering Web Application Development Using Microsoft Visual InterDev 6 (01/08/01 - 01/12/01) McGrath & Associates, Inc 24209 Northwestern Hwy, Southfield, MI 48075
• AS/400 RPG IV Programming Workshop (11/08/99 - 11/12/99), Marisa Industries Inc, Southfield, MI
• AS/400 Concepts and Facilities (10/03/99 - 10/07/99), Marisa Industries Inc, Southfield, MI
• AS/400 System Administration and Control (09/21/99 - 09/24/1999), Marisa Industries Inc, Southfield, MI
• Supporting Windows NT Server 4.0 Enterprise Technologies (4/13/98 - 4/17/98) Productivity Point International Technology Learning Solutions, Troy, MI 48098
Contact this candidate