SUMMARY

• Multifaceted problem solver with professional experience across multiple industries since 2003. Firmly established reputation with managers, coworkers and customers as a smart, hard worker.

TECHNICAL SKILLS

• Reporting
• SQL Server Reporting Services
• Microsoft Office (Excel, Word, Access)
• Business Objects Enterprise BIC 6.5
• Crystal Reports
• Logi Analytics
• MSSQL
• SELECT, UPDATE, INSERT, DELETE
• Complex queries
• Common Table Expressions
• Error - catching and transaction rollback
• Service Broker development
• Complex XML shredding, creation, storage, and querying, w/ namespaces
• Use of profiler and basic query tuning
• Database design
• Stored Procedures, Functions, Views, Tables, Triggers
• CREATE DATABASE, CREATE/ALTER TABLE, adding/altering columns to tables
• SQL Agent Jobs
• Backups, Restores
• Linked Servers
• Languages
• TSQL - expert level
• .NET - expert level
• Also… XML, HTML, JQUERY, Javascript, CSS, Powershell, Batch Scripts, VBA Macros, Regular Expressions, many more
• Tools
• Visual Studio - Data Tools/BIDS/SSRS/SSIS/VSTO
• SQL Server Management Studio
• Other Skills
• Solution Architect
• Business Analyst
• Diverse Database Technologies
• In depth MS Access development
• MySQL development experience
• SQLLite
• SQL Anywhere
• Basic Oracle PLSQL training
• ETL from other RDBMS systems to MSSQL using a variety of methods

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Developer

Responsibilities:

• Responsible for production releases, production and non-production support, new functional development
• Mary Kay utilizes and extensive network of ETL components using some very unique and impressive approaches in the industry. I was trained to function within this environment and came to greatly admire their approaches
• Jobs - Mary Kay trained me to use their 3rd party hosted job management, centrally administered across their multinational/multi-tier dev/QA/Prod network. Product: Control-M
• SSIS - Mary Kay trained me to develop against their custom system of dynamically generated SSIS packages
• Service Broker - SQL Server has included Service Broker as a feature since SQL Server 2005, but it has gone largely unnoticed in the development community. Mary Kay’s extensive implementation exposed me up close, and in depth this powerful and versatile technology. I would be excited to introduce this technology into any environment where applicable.

Confidential

Sr. SQL Developer

Responsibilities:

• Mentor junior developers
• Build SSRS reports, ad hoc reports, and SSIS packages to stage data, tune queries
• Helped DBA transition the team to project deployment method for SSIS packages

Confidential

Sr. SQL Developer

Responsibilities:

• Responsible for creating & monitoring ETL systems moving data to and from automotive listing systems, Dealership Management Systems, Customer Management Systems, etc. & Member of product support and enhancement team
• Provide Mentorship
• Mentor interns in TSQL
• Development methodologies and best practices
• Code reviews
• Mentor former Oracle engineers transitioning to SQL Server
• Orientated all new SQL employees including new management and administrators
• Key projects
• Build and support business critical ETL systems as a solo developer
• DMS import systems: reverse engineered script based import system and constructed new feeds using SSIS
• Listing feeds
• Photo feeds
• Direct pricing feeds
• Miscellaneous other SSIS feeds

Confidential

Sr. SQL Developer

Responsibilities:

• Loan Locator Web Application
• MVC 2 (and later upgraded to MVC 3)
• C# & Linq repository classes
• Javascript confirmation boxes and dynamic text in the UI
• Master page and CSS formatting throughout
• Entity Framework dbml file linked to SQL Server backend
• Cascading drop-downs utilizing jquery and ajax calls and JSONResult carrying custom mule objects between UI and server
• Search Functionality
• Inherited basic functionality and expanded searchable fields on request
• Cookies for remembering search settings
• Reconfigured data source from view to a table that is truncated and refilled to improve performance
• Servicing Functionality
• New loans
• Provides Excel template file for download to enable users to properly format data to be imported
• Copy/Paste from Excel template into textbox on web page as Tab Separated Values
• Pasted text is converted into .NET datatable
• Datatable object is passed to stored procedure utilizing the table-valued-parameter feature of SQL Server 2008
• Table valued parameter is inserted into SQL table as a set - no looping
• Internal numbering system applied to imported data
• SSRS Report Snapshots are generated and a URL to the snapshots is emailed to users specified in the user-maintained email list
• One report is in format specified by Document department for export to flat file and import into their 3rd party system, linked internal numbering system with paper documents
• Other report is in format specified by two accounting departments for export into flat file and import into SBO 2000 Accounting system
• Servicing transfer
• Cross reference is created between internal numbering and new external number
• SSRS Report snapshot generated, notification reports sent to Accounting, Document Control, and other departments
• Document Control Functionality
• User selects a loan and generates 2D-barcoded coversheet in PDF or printed format
• 2D Barcode is generated by DLL that I implemented into a subreport and then accessed using code embedded in that subreport
• ASI
• Document Imaging
• After purchasing another bank we discovered we had multiple collections of millions of document images that needed to be correlated with each other to prevent duplication, and then be matched up with their corresponding loans and after that to also identify what kind of document was in the image
• Data sources consisted of:
• Web based image management system that did not feature an export option
• The bank that we bought has begun downloading images with a team of developers and business analysts over the course of many months. We received their data on hard drives
• We also received CD-ROMs that were loaded onto a networked server
• The on-disk images were accompanied by text files containing meta data
• The web based images needed meta data to be screen scraped
• I built systems to screen scrape the website, parse the text files, OCR the images and correlate all of the information with our database of loan data in less than two months working with one business analyst
• Deposit Gathering Results reports & Campaign Tracking System
• Automated version of report for COO and other executives to use weekly serves as primary reference for tracking retail campaigns intranet website for tracking campaign activity gathering data from servicing system
• Discount Calculator application
• Console application
• Click Once deployment
• VB.NET & C#
• Created 2 ETL processes for transfer and storage of Microsoft Dynamics Great Plains general ledger data into local databases
• Created and support ETL processes to transfer deposit account activity into locally served accounting system interviewed accounting team to gather requirements for import and their consumption and storage needs created multiple reports using Business Objects BIC according to requirements specified by accounting department configured the servicing system’s Mass Exchange utility to extract the reports to flat file format saved on our DMZ server architected the production deposit system database objects and pushed them onto the production server architected the staging deposit database objects and the views and stored procedures related to inspecting and migrating only good data to production
• Excel footer application
• Visual Studio Tools for Office (VSTO)
• Compiled for both Windows 7 64 bit w/ Office 2010 and Windows XP Professional 32 bit w/ Office 2010
• OSI GL Import application
• Console application
• Inherited a mixture of VB.NET and C#
• Text parsing
• I implemented extensive use of Regular Expressions to achieve greater accuracy and stability in a constantly changing file
• The application would scan green-bar style accounting reports, recognize pertinent text, extract the recognized values, and insert them into a database
• Responsible for dozens of reports in multiple departments, constantly fielding change-requests on all of them
• Most are in SSRS, some are Access reports, Excel reports, one or two Crystal Reports, plus ad-hoc queries, Hummingbird, parsing flat files and Excel files for customers
• I built a report that displays a 2D barcode that is an image generated by a DLL I found a way to embed in the report project and call from code in the report. I used this report as a subreport, using a parameter as the value to encode into the 2D barcode image
• I built a report for a high ranking officer in the Accounting department that displayed a wide variety of information for him, merging the function of 3 Excel analysis tools he had constructed himself. I provided him the ability to drop open certain rows to display the same data in different ways. I like to refer to this project as my “Swiss Army report”, since it does different things depending on what you open in it

Confidential

Developer / Administrator

Responsibilities:

• Developed DTS packages for EDI partnerships with multiple customers and scripted FTP transfers using IIS via DOS Batch with .TXT configuration files
• Developed functions for use with reports to interpret product classifications by examining coding in the name of the product
• Developed Stored Procedures to perform tasks such as adding or removing data from the MRP system, emailing administrator, copying data from one record to another, and many other tasks
• Installed xp smtp open source component in the absence of Exchange Server and SQL Mail, then implemented jobs to email me reports of key status indicators
• Designed and created multiple solutions notifying various managers of production events utilizing xp smtp, triggers, jobs, T-SQL queries, and HTML
• Architected and built a system to allow the Director of Quality to electronically sign a Crystal Report by clicking on it
• Document would lose the signature if any data contained in the report were altered
• Utilized VB.NET, ASP.NET, Crystal Reports XI Developer, and T-SQL
• Created application in VB.NET 1.1 and Crystal Reports to give users ability to easily interact with data and run reports. This application became the backbone of Quality operations
• Redesigned existing source code (originally supplied by software consultant) for Pocket PC 2003 application powering barcode scanners to customer specifications
• Transitioned from Compact Framework (CF) v1 to CF v2
• Added threading to increase performance
• Created an easier to manipulate and more appealing UI experience
• Designed intranet accessible website
• Converted multiple page CSS template into .NET Master Page based website
• Webpage serving installable Pocket PC 2003 applications
• ASP.NET 2.0
• Architected and built Quality Control System
• Version 1: Automated Excel workbook using VBA
• Version 2: Client-Server VB.NET 1.1 Winforms application
• SQL Server 2000 backend (architected and built SQL Server tables/views/stored procedures)
• Crystal Reports Viewer control
• Version 3: VB.NET 2.0 Winforms application
• Multithreaded
• Implemented Tiered Architecture
• Changed Crystal Reports from receiving input via datasets to ODBC data sources
• Easy-to-use color coded, user configurable graphical interface
• Integrated with Manufacturing Resource Planning system to provide near seamless transition between commercial system and augmentations