Maury Guerra

**** ******** ******, ******, ******** 60543

Cell 630-***-**** • Home 630-***-**** • ac4jug@r.postjobfree.com

Application Development & Support Profile

Creative information technology specialist with 15+ years of practical experience devising cost-and labor-saving solutions. Resourceful problem solver with excellent project management skills. Exceptional communicator with a demonstrated talent for effectively conveying complex technical issues to peers and non-technical staff members alike.

Areas of Expertise:

Development & Implementation

High-Level Technical Support

Team Leadership

Vendor Relationship Management

Project Management

Business-Technology Alignment

Communications

Training / Coaching

Technical Proficiencies

Platforms:

Windows XP/7/10, Windows Server 2003/2008/2012

Languages:

C++, C++ with MFC, C#, SQL, ASP .NET

Development Tools:

Microsoft Visual Studio, Telerik, Microsoft SQL Server – SSIS and Management Studio, SSRS, Crystal Reports

Professional Experience

Sidley Austin, Chicago

Systems Developer Litigation and Practice Support Department, 4/2016 – 9/2017

Technical Scope: Windows 7/10, C#, SQL, ASP .NET Microsoft Visual Studio, Telerik, SSRS, PowerShell, Active Directory, IIS, BPM

Create or modify existing automation processes in support of document storage and management used in Litigation Support. Created console applications to be used within scripts to facilitate mass file deletions. Created ASP .NET application to allow users to control receipt of system generated email. Developed contract lawyer project management application. Assist operations personnel with share and portal access and other administrative duties when called upon.

Key Achievements:

Developed a data driven deletion method for LSPS file management

Designed Opt-In / Out application for message control

Leveraged BPM API to integrate with ASP .Net applications

Kirkland & Ellis, Chicago

Senior Financial Information Systems Specialist, 6/2015 – 4/2016

Technical Scope: Windows XP/7, C++, C#, SQL, ASP .NET Microsoft Visual Studio, Telerik, SSRS, IBM DB2, ARCS

Act as technical resource for finance department. Assisted with replacing legacy financial system with replacement and participated in selection process. Participated in vendor technical presentations to help finance personnel better understand new technologies. Used VS 2013 / C# to create replacements for legacy SSRS reports for automation. Designed prototype solutions for key inquiry as replacements for desktop ad hoc query from legacy vendor. Created and automated file exports for client requirements.

Key Achievements:

Designed and implemented a text parsing application to validate time entry detail against database reported hours.

Designed an application to automate the production of interoffice invoicing.

Wrote SQL and export procedure to validate ARCS comments against time entries in legacy financial system.

Participated in the evaluation and integration of collections system

Seyfarth Shaw, Chicago

Business Intelligence Developer, 4/2013 – 5/2015

Technical Scope: Windows XP/7, Windows Server 2003/2008, C++, C#, SQL, ASP .NET Microsoft Visual Studio, Telerik, SSRS, SSIS, IIS, Elite

Develop intranet applications for National Accounting Department. Automated Positive Pay file production and upload. Established first web servers for Accounting and developed report pages to replace legacy database applications and reports. Developed exception rate editing application to enable attorneys and assistants to directly enter proposed rate changes for the new year.

Key Achievements:

Completed the design and implementation of automated banking executables and scripting for Positive Pay.

Designed accounting department intranet site and applications.

Designed SSRS reports to integrate with intranet applications.

Completed certified Microsoft training for SSRS

Kaye Scholer, LLP, New York, New York ( fully remote from home )

Applications Support Specialist, 10/2007 – 4/2013

Technical Scope: Windows XP/7, Windows Server 2003/2008, C++, C#, SQL, ASP .NET Microsoft Visual Studio, Crystal Reports, Microsoft Office, Aderant Expert, Chrome River

Develop technology solutions to meet operational needs and advance corporate objectives of a large law firm with 450+ attorneys across nine offices worldwide. Drive all phases of software development related to numerous financial and billing applications and databases. Lead software upgrades and installations, and liaise with vendors to orchestrate implementation initiatives. Conduct customer support for end-users, resolving escalated issues. Research emerging technologies and issue purchasing recommendations.

Key Achievements:

Provided expertise on coding techniques and tools usage to peers and management.

Innovated automation for data transfer activities between locally-hosted applications including a newly-implemented, cloud-based expense tracking system.

Completed the design and implementation of automated banking executables and scripting for Positive Pay and BAI statement data.

Designed accounting department intranet site and applications.

Administered IIS and servers for accounting site

Lord Bissell & Brook, LLP, Chicago, Illinois

Project Leader and Senior Application Developer, 8/1999 – 9/2007

Technical Scope: C++, Microsoft SQL Server, CMS, CarpeDiem, ARCS, LegalKey, ADP Payroll, HR/Perspective, Crystal Reports, Microsoft Query Analyzer, Aderant Expert

Headed a team of three to drive application development projects to support law firm billing and financial management processes. Served as primary point-of-contact for technical consultants. Developed interfaces between a wide variety of data sources at the API level. Designed and managed data migration and conversion projects to HR and accounting systems. Provided real-time financial data for firm intranet sites.

Key Achievements:

Played a key role in application integrations, upgrades, and installations for networking, training, support and hardware departments.

Devised data migration applications and automated procedures for the import and export of external validation data in use by firm’s financial applications.

Managed firm’s financial software conversion and installation project as technical lead.

Served as principal technical point of contact for vendors and consultants, and as database administrator for accounting departments.

Land and Lakes Company, Park Ridge, Illinois

Programmer / IT Manager 6/1995 – 7/1999

Technical Scope: Windows, Windows Server, Novell Netware, C++, C++ with MFC, SQL, MS Access

Initiated and managed all technology projects, operations, and support for a mid-sized waste management company. Devised and implemented customized solutions to facilitate daily business transactions. Drove procurement of all hardware and software.

Key Achievements:

Achieved compliance with state EPA reporting and data management requirements.

Introduced and installed modern networking and database technology and trained office staff in its usage.

Established a dedicated network between multiple office locations.

Created and administered company’s first website.

Education & Credentials

Electronics and Computer Technology

DeVry University, Chicago, Illinois

Contact this candidate