Jesse McLain

Baltimore, MD

(443) 802-5789

jesse@jessemclain.com

 

 

PROFILE

Strongly positioned as an ETL/BI Developer in SQL Server data warehousing environment. More than ten years diverse IT experience working within industries such as healthcare, real estate financing, marketing, education, government, and sales. Adds value as domain expert by thoroughly understanding business goals and working closely with both internal and external clients to achieve them. Core technologies include SQL Server database/BI development (T-SQL, SSRS, SSIS), Informatica PowerCenter, and Visual Foxpro.

 

 

SUMMARY OF TECHNOLOGICAL EXPERIENCE

·         SQL Server/T-SQL: 10 years

·         SSIS/SSRS: less than one year

·         Informatica ETL Development: one year

·         Visual Foxpro: 7 years

 

 

PROFESSIONAL EXPERIENCE

 

Peart-Hannon Consulting

Senior Database Consultant

January 2007 – December 2009

Glen Burnie, MD

Technologies used: SQL Server, T-SQL, Informatica PowerCenter/Workflow Manager, SSIS, SSRS

·         Worked on-site at Toyota developing and maintaining ETL for staging of data to reporting ODS

·         Led team effort to convert almost 100 SQL Server-based ETL procedures to Informatica mappings using PowerCenter 7/8

·         Developed and maintained SQL ETL code during transition phase using SQL Server 2000/2005

·         Designed and developed data marts and corresponding ETL for reporting financial and transactional information from data warehouse

·         Developed reports and report models off of data marts in SSRS (SQL Server Reporting Services)

·         Developed SSIS packages to import and manipulate Excel data sources into data warehouse

 

 

NeighborCare, Inc.

Software EngineerJune 2003 – December 2006

Baltimore, MD

Technologies used: Visual Foxpro, SQL Server, T-SQL, Crystal Reports

·         Maintained and upgraded application for home healthcare market (infusion therapy)

·         Occupied senior-level position in the ongoing full lifecycle of VFP 7 – based home healthcare application, including design, coding, testing, and implementation of upgrades

·         Application previously sold to third party pharmacies; now used solely in-house by NeighborCare Pharmacies for maintaining post-acute care pharmacies (specifically the home-infusion business). Subsystems included financial, clinical, and medical histories of patient care

·         Developed and maintained existing stored procedures and queries using T-SQL (application uses SQL-Server backend). Created complex SQL queries for aggregating and summarizing complicated financial data (for example, balancing credits/debits for patient invoices, and grouping outstanding balances in 30 day buckets by original invoice date)

·         Assisted DBA in maintenance and performance of production databases, including tracking and tuning sources of sub-optimal queries

 

VisualSoft Inc.

Senior Developer

August 2002 – January 2003

Rockville, MD

Technologies used: Visual Foxpro, SQL Server, T-SQL

·         Co-Developed Visual Foxpro 7 application helping industrial plants track employee proficiency with internal processes. Development done for Primedia Workplace Learning

·         Developed testing system to create, maintain, administer, and track employee performance in electronic courseware

·         Helped Primedia’s software engineers complete their respective project tasks by providing technical advice, strategy sessions, and business-rule discussions.

                                      

Merkle Database Marketing

Senior Applications Developer

January 1999 – March 2002

Lanham, MD

Technologies used: SQL Server, T-SQL, DTS, Visual Foxpro, Visual Basic

·         Used SQL Server 7.0/2000, Visual Basic 6.0, Visual Foxpro 6.0, ADO, COM, and VBA to design and develop comprehensive client/server solutions to clients marketing needs

·         Technical Lead for Phillips Publishing data warehouse, developed ETL for populating data warehouse, created data marts for client analysis.

·         Designed, developed, and maintained an application for Philip Morris to consult with vendors on ways to improve retail environments. Application written in visual basic using Active-X data objects to interface with a SQL server 7.0 database for data import, export, and reporting. Also interfaces with DTS packages, VBA for excel reports, and stored procedure calls

·         Solely developed and maintained an automated application that collects, distributes, and reports upon candidates for recruitment into the US Air Force. Application uses PGP encryption, automated scheduled FTP transfers, and VBA for Excel and Outlook automation, and generated $30,000/month in revenue for the department

·         Consulted on a similar project for the US Marine Corps, and created an application to distribute leads to USMC recruiters from a SQL-Server database to Excel, Word, and text files

·         Developed a “matchcode” algorithm for matching name/address data used department-wide for such clients as The US Marine Corps, Marriott Vacation Club, Phillips Publishing, and UnionCare. Implemented as both Visual Foxpro DLL and SQL Server 2000 Function

·         Received multiple outstanding performance awards throughout tenure

·         Worked part-time from March 2002 until December 2002

               

Olwen International Direct Mail

Senior Programmer

September 1995 – October 1997

Baltimore, MD

Technologies used: Foxpro 2.6, DBase 5.0, and Turbo-Pascal

·         Developed data processing and reporting tools in the reformatting and merge/purge of international addresses

·         Independently created programs to report Recency-Frequency-Monetary (RFM) analyses of client/order/line-item relational database

·         Designed comprehensive address enhancement program to parse Japanese addresses and correct, verify, and append town, state and postal code elements

·         Consulted for Olwen after October 1997

 

EDUCATION/TRAINING

·         B.S. Mathematics, UMBC, Minor in history, member of Honors College and Pi Mu Epsilon (national mathematics honor society). Extensive coursework in computer science.

·         SQL Server Business Intelligence Application Development training, April 2009

·         Informatica PowerCenter 8.1 Developer training, May 2007

 

MEMBERSHIPS/PUBLICATIONS

·         Mensa International

·         Baltimore SQL Server Users Group

·         Contributor to SQLServerCentral.com

·         SQL-focused weblog at http://jessesql.blogspot.com

 

REFERENCES AVAILABLE UPON REQUEST