Jerry Lagrou Email & Phone Number

Chicago, Il, Us

Michigan City, In

Architect Global Enterprise Service Orientated Solutions.Architect Global Enterprise Service Bus.Lead and Direct other developers locally and globally.Design and Implement Data Warehouse.Write C#, WCF, SQL Server, MVC ASP .NET, Telerik, ResharperWrite C# ETL tools

Team Leader, Agile Development, C# Dev, Senior Data Base Administrator, Data Warehouse Developer Architect. Design, Specify and Optimize Existing Servers, New Servers, Existing Applications and New Applications. Maintains close communications with the CTO and provides routine status reports. Coordinate Activities of Project Team. Programming support (Standards, Direct Junior Developers). Technologies used includes: C#, SQL SERVER 2005, SQL Server 2008, SQL Server 2008 R2, Visual Studio, SVN

Oversees the report writing of technical and non-technical staff. System administration (Active Directory, Group Policy, SQL Server). Programming support (Standards, Direct Junior Developers). Coordination of the implementation process when installing or upgrading systems. Maintains close communications with their Director and provides routine status reports. Design and Modify Data models for existing and new applications. Create and Implement standardized software documentation system. Create and Implement standardized code specification system. Create and Implement standard documents for designing system. Direct technical and non-technical staff in strategies and tactics in report design and writing.

Design and Modify Data models. Wrote post-development specs of code and scripts. Developed Reports to monitor completeness of hand done conversions of data. Developed conversion scripts to move data from Oracle to Custom SQLserver data model and Oracle AR data model. Fixed bugs in Oracle (AR,AP,HR) ETL scripts. Load and converted XLS spreadsheets. Write data validation routines. Made custom reports. Assisted in debugging of ASP .net apps. Assisted in debugging VB .net apps.

Write data validation routines. SQL DBA / Specifications. Design and Modify Data models. Data Conversion Scripts. Wrote post-development specs of code and scripts. Developed Reports to monitor completeness of hand done conversions of data. Developed conversion scripts to move data from Oracle to Custom SQLserver data model and Oracle AR data model. Fixed bugs in Oracle (AR,AP,HR) ETL scripts. Load and converted XLS spreadsheets. Made custom reports. Assisted in debugging of ASP .net apps. Assisted in debugging VB .net apps.

Wrote VB.net automated testing programs. Created Standards and Procedures of Coding for VB.net apps, Monitored Adherence to Standards, and supervised developers in correcting code to adhere to the standards. Designed and Implemented Data models. Experience with Tevron's CitraTest automated testing tool. Designed and Developed Host Communication Sequences for OFB and ALS. Worked with ALS green screens. Oracle repair scripts. Design and Modify Data models. Wrote OFB code. Wrote Sophisticated Code to access ALS via a CICS interface using DGMT middle ware. Wrote Oracle SQL Scripts. Designed and Redesigned and Wrote the Host Inquiry Methods. Designed and Developed the 'Ledger Card' and 'Ledger Card Reversal' system. Wrote adaptive code to reverse multi-part transactions through repeated scans and maintenance transactions. Activities included unit testing and integration Testing of Loan Making and Loan Servicing Applications. Also design and writing of Automated Test Scripts and Test Plans.

System Architect / Data Warehouse Design and Build / SQL Server Admin / Oracle. Designed and Developed SQL Server Data warehouse. Drawing data from over 20 different tables out of a Data Model of 50 tables. Produced a 2.5 table data warehouse with a SQL stored procedure interface to support 6 different reporting interfaces. Answers up to 9 queries on a 2.5 million row dataset, effectively over 20 different tables, with sub-1 second response time. Totals, Ranks, Averages, and all other calculations done in a nightly script. Built/modified Oracle scripts to bridge a test taking system to a test recording system.

Senior Programmer Delphi / System Architect / Data Model Design / SQL Server Admin. Designed and Developed complete copy protection system for all Pinnacle Software. Unified the old mySQL database with the new SQL Server Database to copy protect all the software made by a $12 Million per year firm. Built DTS packages for SQL Server. Prepared and brought through approval Project management documents for XML configuration interface. Converted and Depreciated old INI/DBF configuration interface into a modern XML/XSD configuration interface. Designed and Developed XML configuration interface for primary software product (PALM). Designed Configuration Management system to provide multi-location remote configuring of primary software product. Debugged and Developed item grouping applet for cash register software.

Made the primary customer facing website

Made websites and line of buisness applications

Made ASP websites

Made ASP website

Made ASP website

Made ASP website

Made Oracle ETL application

Made ASP website

Made Oracle ETL application.

Made Oracle ETL Application

Made Olivetti Financial Basic Customer Service Application

Made Olivetti Financial Basic Customer Service Application

Made Olivetti Financial Basic Customer Service Application

Made Olivetti Financial Basic Customer Service Application

Made Olivetti Financial Basic Customer Service Application

Made Olivetti Financial Basic Customer Service Application

Ms, Engineering

Developed a real time AI system using fuzzy logic. Tested on a real operating HVAC system. Discovered and repaired several faults.

Master'S Degree, Engineering

Graduated with a M.S. and a B.S. in Engineering.