Li Lou

**** ******* ***** ******

Lone Tree, CO 80124

acujwt@r.postjobfree.com

303-***-****

SUMMARY:

20+ years of expertise in software development.

Expert in SQL development, including design, stored procedure, performance tuning and Reporting Services.

Extensive experience in Service Oriented Architecture (SOA) implementation.

Proficient in Microsoft .NET programming.

Participated in all aspects of the software development life cycle with specific focus on design, estimation, construction and testing.

Familiar with Agile development methodology.

Strong communication/interpersonal skills, a can-do attitude, flexibility and versatility. Ability to explain technical ideas to non-technical personnel.

TECHNICAL SKILLS:

Languages: C#, VB.NET, ASP.NET, C/C++, COBOL, XML, JSON, HTML, JavaScript

Tools: Visual Studio, TFS, IIS, SSMS, Reporting Services, JIRA, Confluence.

Databases: SQL Server, Oracle, MSMQ, Entity Framework, SSRS

Web Services: WCF, XSD, XSLT, NIEM, WS-Security, SOAP, X509, REST, Web API.

PROFESSIONAL EXPERIENCE:

URL Integration Inc., July 2008 - present

Project Lead / Lead Software Engineer

Iowa CJIS projects

Built statewide justice information sharing systems from ground-up. Implemented more than 10 data exchanges among 30+ agencies, using .NET and national standard NIEM data model. This project won national CJIS outstanding award from IJIS institution.

Led a team of 4 developers. Provided technical training to in-house developers as well as integration partners.

Facilitated discussions with business partners to determine needs and appropriate solutions.

Architected SOA solutions for the projects, including message patterns, sequence diagrams and interoperability with Oracle ESB.

Designed the integration database. Created complex stored procedures and triggers. Responsible for performance tuning. Developed business reports from SSRS.

Ownership of the full life cycle for the solution, from analysis and design through testing and delivery.

Implemented with Microsoft technologies including SQL Server, WCF, SOAP with WS-Security, Entity Framework and NIEM data model.

McHenry, IL CJIS projects

Built justice information sharing systems for McHenry County, IL. Implemented 7 data exchanges between 3 agencies. The CIO of McHenry County praised the systems as “bullet proof”.

Implemented SOA architecture with similar Microsoft technologies as the Iowa projects.

Interfaced with existing application using RESTful web services and JSON.

Designed and developed the message staging database in MS SQL Server. Responsible for most database related tasks, including stored procedure, tuning and daily maintenance.

Built a web application for end users to maintain code mapping tables using MVC, Entity Framework on IIS.

Colorado District Attorneys’ Council, July 1999 - 2008

Senior Programmer/Analyst,

Acted as a team member, providing case tracking applications (entry, query, and reporting, interagency integration) to the District Attorney’s offices throughout Colorado, serving approximately 400 entry and 1,200 query end users. Contributed significantly to the development of all IT solutions, including the migration of the new case tracking system (ACTION) from a mainframe/COBOL platform to a SQL Server/VB.Net platform. Responsible for historic data conversion services and inter-agency data exchange services.

Analyzed business requirements for the new case tracking application (ACTION).

Developed Windows form-based applications using .NET, SQL Server and Infragistics Controls.

Developed reports using SQL Server Reporting Services (SSRS).

Converted historic data into newly designed SQL Server database using .NET and IBM WebSphere MQ.

Developed web-based document generation system using ASP and Office automation.

Maintained legacy system (Blackstone) using COBOL on HP MPE.

J3 Software Inc., June 1998 – June 1999

Software Engineer,

Worked as a contractor at the client site to enhance and support COBOL-based systems. Successfully implemented a web based query system.

Developed and supported a web-based query system using ASP.NET.

Developed and supported COBOL applications used for day-to-day operations.

Bank of China, September 1994 – June 1998

Software Engineer,

Acted as a key member in developing software systems using object oriented programming and client-sever architecture. Systems are being used in major branch offices throughout the world.

Developed 3-tier based account management system using Borland C++, IBM DDCS and DB2.

Developed client-server based currency exchange system using Borland C++ and DB2.

Maintained bank accounting system using COBOL, CICS and JCL on IBM mainframe.

EDUCATION:

Bachelor in Computer Science, Zhejiang University, China, June 1994.

Contact this candidate