SUMMARY:

• 21+ years of full life cycle systems applications development, including analysis, design, requirements gathering, development, software quality, and maintenance in a variety of industries, including manufacturing, logistics, finance, banking, and education.
• Deep level of experience with Oracle, MS - SQL, and MySQL in creating both RDBMS structures and ETL type data structures and data islands.

TECHNICAL SKILLS:

Databases: Oracle, SQL Server, DB2, MS-Access/VBA, MySQL

Programming Languages: Visual Basic, PL/SQL, ASP, VB.Net, SAS, R

Tools: TOAD, Mercury QuickTestPro, Visual Studio 6.0, Visual Studio.Net, MS-SQL Server, SSIS, SSAS, SSRS Excel/VBA, Enterprise Manager

Operating Systems: Windows, UNIX

Applications: Crystal Reports, WebFocus, Cognos Powerhouse

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer

Responsibilities:

• Worked hand-in-glove with the Director of Finance and Finance and Marketing Analysts
• Data Warehousing (ETL through SQL extract, transform, load, scripts, Oracle and My SQL client scripts, Korn Shell, and PHP scripting). This entailed doing analysis with Confidential staff and research with banking partners such as Confidential .
• Handled audits/compares with existing system reports to assure accuracy - and created documentation for incorporating this data into Finance and Marketing reporting
• BI Reporting and Analysis (PowerPivot / SQL Reporting used DAX / MDX and Excel VBA extensively). These models implemented within Confidential intranet.
• Proof-of-concept for creation of SharePoint server: SSAS, SSIS, and SSRS.
• The intention - How the Microsoft Stack might augment the best practices of XL and PowerPivot. Also had training in SSIS, SSAS, SharePoint, and Microsoft PowerPivot.
• Create data islands. Took the bank transactions that drove Confidential LLC business and to create processes to extract Oracle posted debit, chargeback, refund transactions in MySQL structures. Assisted in the creation, exploration and implementation of PowerPivot models to present this info in a variety of reports and dashboards to upper management.
• Worked with Finance and network staff to do a Proof-of-concept for implementing a SharePoint server to present/deliver PowerPivot reporting.
• Worked with Finance and IT Staff to do a Proof-of-concept to use R for data mining of loan / address information looking for correlations.

Confidential

Report / SQL Programming

Responsibilities:

• Redesigned their medical billing from manual ~ spreadsheet processes into an MS-Access - used VBA to load ~ export ~ process data. Then MS-SQL database. Had begun converting the MS-Access interface to LightSwitch
• Did investigative queries - traces against the HR system to locate additional report items not directly available from the system.
• Learned basics of Cognos connection event, query, and report studios

Confidential

Reporting / SQL Programming

Responsibilities:

• Participated in database and report design discussions, was a primary SQL Report developer in the systems noted.
• Extensive work with MS-SQL Server 2005, Query Analyzer
• Used VBA and Excel to automate - prove out Financial Data Mart reports
• Used DTS to load Excel date into the Teacher Testing System

Confidential

Responsibilities:

• FDM ~ Financial Profiles & Consolidate Financial Statements
• Create FNS Oracle Package to wrap/re-use existing procedures for Crystal Reporting
• Develop DIRS System (a disciplinary system for juveniles)
• Analyze and resolve Crystal Report Variances in the DIRS III System
• Create new Crystal Reports for DIRS~MARSS interactions
• Designed/developed Oracle package to implement Crystal Report logging. Logging is implemented via a stored procedure called from a Crystal sub report.
• Developed/enhanced Crystal Reports for MActive system
• Invoice Print reports
• Sales Executive Reports
• Sales Team reports
• Developed and enhanced the Thomson-West/Royalties system
• Developed VB6 archive of DB2 data

Confidential

Senior Analyst

Responsibilities:

• Developed requirements against the user interface (UI)
• Developed QA and user acceptance program for the CARRS System using Mercury QuickTestPro
• Developed regression/load tests for the CARRS System using AWSTATS
• Developed SQL Server load/refresh of testing environments
• Developed .NET Operations Loss system to capture enterprise wide losses and for Confidential .
• Served as deployment manager, shut down/restarted IIS servers, copied in new database instances via SQL Enterprise Manager, and deployed .NET apps and configured WEBCONFIG files for our several instances of CARRS system.
• Developed proto-type/tracer bullet system to capture and report Operations Losses - this was a three month effort using Visual Studio 7 .net. 2003
• Assisted in development proto-type system to capture and report Credit Losses - this was a 1-1/2 year effort in ASP and MS-Access
• Developed a SAS / Oracle / Desktop interface for Visual Studio 6
• Developed Oracle/F&T Custom Queries to validate risk statistics Seller Risk Rating Oracle
• Provided ongoing support for Oracle export/import test environments
• Developed MS-Access/VBA procedures to do auto-relink of oracle tables
• Developed ASP/ADO based watch list system
• Developed VB6 desktop components for Market Value-at-Risk system
• While working for Confidential - I was recognized by the business and my colleagues with the RFC Celebrate Leadership award.

Confidential

Senior Analyst

Responsibilities:

• Developed data tier Functions for cross-instance access to Oracle Data
• Warehouse
• Developed Base report SQL
• Developed/Enhanced Crystal Reports to accommodate Crystal upgrades to
• Developed/Enhanced Off Balance Sheet Funding VB6/doc screens
• Developed mailing application for mortgage documents to manage the $4b pipeline at month/quarter end securitization
• Developed REPO loan processing to allow alternate loan funding saving the company $1mm/month
• Analyzed, developed and shepherded this n-tier VB application (OBSF) to production
• Maintained this n-tier VB application (OBSF) for 2-1/2 years
• Coordinated with database and middleware teams for promotions
• Completed required documentation and conformed to corporate standards for technology and practice
• At the time, this system was fed from main mortgage pipeline, placing, and as much as possible, new loans off company balance sheet and with other big capital concerns. At time of securitization - the system then allowed the transfer back to RFC to banks to complete the securitization deals.

Staff Programmer Analyst

Confidential

Responsibilities:

• Rewrote HPRapid/3000 billing print component Warehouse Lending system
• General maintenance/support HPRapid/3000 Warehouse lending system
• While working for Corporate IT - I was recognized for significant contributions to the business with their Above and Beyond Award

Confidential

Consultant

Responsibilities:

• Maintained HP3000 Cobol, Cognos for Canadian QMS system for GRAND-MET/PLC

Confidential

Consultant

Responsibilities:

• Maintained COGNOS Confidential /Industrial Minerals Shipping system
• Developed VB / Access Confidential / OH&SD Mask Fit test lab system, (passing exposure to SPSS in the project, but primarily an attempt to move them from Apple 2 computers to PC.
• Developed COBOL Confidential /Logistics / warehouse picking system
• Developed SCO-Unix / system main shell scripts
• Developed COBOL Grand Met PLC/RFGI Warehouse picking

Confidential

Programmer

Responsibilities:

• Developed HP/COBOL/IMAGE/View Enrollment Processing systems reports/updates
• Developed HP/COBOL/IMAGE Claims Processing systems reports/updates
• Developed HP/COGNOS/IMAGE/View IBNR systems reports/updates
• Developed HP/Pascal Archive for Claims Processing system
• Maintained/updated HP/OS