SUMMARY:

• Engaged in analysis, design and programming since 1980. Excellent communications and organizational skills.
• Highly skilled in data development, data architecture and data archaeology, systems analysis, systems design, UI design, database, data mart, data warehouse and Internet systems.
• Roles have included Database Architect, Application System Architect, System Designer, Project Leader, SQL Developer, Programmer/Analyst, Systems Analyst and Programmer.
• Experienced in designing and building batch, online and Internet - based systems with a proven track record of quickly becoming familiar with the problem at hand and able to accomplish tasks in a variety of environments. Data Mart/Data Warehouse design/development & ETL (12 years), Corporate programming experience with PC (24 years), Mainframe (16 years), Internet e-Commerce and Search Engine Marketing (10 years), Systems Conversions (14 years) and Corporate Mergers (10 years).
• Applications experience includes Professional Organization, Fund Management, Health Care Insurance, Pharma, Online Software Distribution, e-Commerce, Search Engine Placement, Marketing Systems, Sales Systems, Sales/Order Entry, Banking, Manufacturing, Direct-Mail, Project Accounting, Trust Accounting, Inventory, Publishing (Yellow Pages) and Online systems.

TECHNICAL SKILLS:

• SQL
• DB/2, SQL Server, Sybase, MySQL
• DB/2
• MVS, CICS, OS/2 (Light DBA skills)
• SQL Server / T-SQL
• Development DBA skills, Data Mart, Data Warehouse, Performance Tuning, DTS, SSIS, SSRS, Procs
• T-SQL, Development DBA, Performance Tuning
• VSAM
• MVS
• IMS - DL/1
• MVS
• Basic
• VB, PowerBasic, VMS Basic
• Expert
• COBOL
• Both COBOL and COBOL II
• Average
• CICS (Command)
• MVS
• Basic
• VB 6
• Windows
• Strong
• VB.net
• Windows
• Basic
• PL/1
• MVS, VMS
• Strong
• PowerShell
• Windows
• Average
• VBScript
• ASP/HTA/DTS/Stand-alone
• Expert
• VBA
• Excel, Access, Word
• Strong
• ASP
• Windows (IIS)
• Expert
• JavaScript
• ASP, PHP
• Average
• REXX
• OS/2, VM, TSO, Windows
• Expert
• ISPF/CLIST
• Strong
• JCL
• MVS

EXPERIENCE:

Confidential, Newtown Square, PA

Responsibilities:

• Analysis and development of data migration from legacy systems and Great Plains into Microsoft Dynamics CRM for the migration of 2/3 TB of legacy data.
• Design and development of synchronization processes between remaining legacy databases and Microsoft Dynamics CRM.
• Migration of SSRS 2005 & 2008 legacy reports to SSRS 2008 R2 server along with implementing SDLC and source control.
• Analysis, mapping, flowcharting and documentation of existing DataWarehouse, legacy systems and Month End processing in preparation for systems conversion
• SSRS Reports QC and Performance tuning.
• Mapping of entire data architecture from SQL Servers thru databases to applications.
• Implemented SDLC and source control across all main production databases.
• Developed a self-maintaining Data Dictionary app which maintains column notes across schema changes.

Skills: T- SQL(SQL Server), SSIS, CozyRoc, T-SQL Stored Procedures, SSRS, Performance Tuning, Index Tuning, SQL Server 2000/2005/2008/2012 , Visio, PowerShell

SQL Developer, Data Architect, Development DBA, Team Lead, Data Archaeologist

Confidential, Chadds Ford, PA

Responsibilities:

• Developed a dependent DataMart from the corporate Netezza DataWarehouse to support internal QC needs of the SalesOps department.
• Developed SSIS processes and stored procedures in support of QC of the customer ETL/Data Cleansing/Data Refinement process matching AMS and IMS customer data to internal source systems.
• Developed a rules-based, multi-level Customer Matching engine (T-SQL store procedure) to support the integration of multiple departmental customer masters and for AdHoc reporting.
• Developed a process (SSIS/Stored Procedures) for data enhancement of State License number from MedPro data.
• Developed an enhanced version of the Jaro-Winkler string distance matching function to support address matching that significantly lowered false-positives while significantly raising the number of real matches.
• SSRS Performance tuning.
• SSRS Reports QC.

Skills: T- SQL(SQL Server/Netezza), SSIS, T-SQL Stored Procedures, SSRS, Performance Tuning, Index Tuning, SQL Server 2005/2008, Visio

SQL Developer, Data Architect, Database modeler/Developer, Development DBA

Confidential, Blue Bell, PA

Responsibilities:

• Developed the final ETL, data cleansing, data selection and output processing for a Yellow Pages publishing system. Syndication was by Polygon, NPA/NXX and postal code.
• Developed DB2 stored procedure in PL/1 to support the address-handling / GeoCoding of listings data and enhance the addresses by enriching them using distribution data. Achieved an 86% GeoCoding/Polygon association rate with Canadian data (AB/BC/ON).
• Found, examined, researched and proposed an alternate use of the underlying data (marketing call lists to compete with D&B, Reuters, etc.) that should drive additional revenues of $ 1.5 Billion for the company.
• Wrote a VBA macro to support the network group in reorganizing 2 TB of shared storage.
• Taught the staff how to use DB2 Temporary tables and Common Table expressions.
• Wrote SQL reports to show efficacy of GeoCoding, Address enhancement & Polygon association.

Skills: SQL (DB2), PL/1, Stored Procedures, z/OS batch programming & JCL, Excel VBA

SQL Developer, PL/1 Programmer, Database modeler/Developer, App Developer

Confidential, Philadelphia, PA

Responsibilities:

• Designed/developed a data dictionary and data warehouse to support the funds management business covering 20K+ columns across 175 tables. The first phase was to develop 74 denormalized views to cover the data requirements of 80% of current reporting. Analysis, data archeology and heavy tuning was required to achieve sub-second response times across 45 separate application databases. Developed an analysis database and tools to map data usage from application source and integrate this information in a search engine along with parsed SQL source (views/procedures/functions) as well as source-code embedded SQL. These tools enabled us to target the development effort and research data relationships across 45 separate databases.
• Phase two included integrating the data dictionary with a flex-grid UI and the development of an additional 30 denormalized views which will eventually become the basis for a separate data mart to support the reporting needs of the organization.

Skills: T-SQL (Sybase), SQL Server 2008, Sybase 15.0, ASP, Visio

Data Warehouse Architect, SQL Developer, Database modeler, Data Archaeologist

Confidential, Philadelphia, PA

Responsibilities:

• Designed/developed a systems/application inventory in support of the separation of Confidential from Lincoln Financial.
• The application was used to organize the separation and merger activities across 750 servers and 500 applications.
• Developed the data model, converted from a VBA Excel-based app to SQL Server database with an ASP.net front end.
• Mapped relationships between Applications/Database/File Feeds/Servers/Storage Systems/Generic Account/Users (Logins and security) and Contracts.
• Developed a group of SSRS reports to replace an old CICS system to complete the separation of Delaware from Lincoln. Also developed a series of dashboards to report on and manage the B2B new batch ETL infrastructure.

Skills: T-SQL, SQL Server 2008, Sybase 15.0, SSRS, ASP, Excel VBA, Visio

SQL Developer, Database modeler, ETL Developer, Data Archaeologist

Confidential, Haverford, PA

Responsibilities:

• Designed/developed institutional funds database for a boutique investment bank to enable the creation of tiered call lists of funds qualified by deal and fund investment parameters.
• Developed web-bot to data-mine, load, cleanse and blend data (ETL) into the institutional funds database.
• Developed HTA-based search engine to enable fund research and selection by deal parameters and fund investment type/criteria. One of the interesting features of the app is that it interfaced with an Excel spreadsheet that the investment bankers use to load and update data from the funds database for their use.
• Developed complex data cleansing and blending SQL queries to hone the mined data into an operational tool for developing deal call lists.
• Pulled successful call lists for deals totaling $ 450 MM in transactional value.
• Built a system to extract new fund information (and AUM) from the EDGAR Form D filings.

Skills: T-SQL, SQL Server 2005, HTA, VBScript, ASP, DHTML, XML, Excel VBA, Visio

SQL Developer, Business Analyst, Database modeler/Developer, ETL Developer

Confidential, Valley Forge, PA

Responsibilities:

• Designed/developed prospecting data mart, including ETL, standard reporting and yearly load process for five (5) yearly data sources plus daily telemarketing response updates. Included eMail error notification using xp SendMail to increase the reliability of the process.
• Data Warehouse re-design and subsequent ETL from Data Warehouse to Marketing Data Mart.
• Developed a self-service extract and reporting app for prospecting data mart.
• Maintenance/development of an independent marketing data mart including ETL, blending and cleansing from source systems (Oracle Sales Online + homegrown systems).
• Documented/rationalized myriad collected databases and applications that had been only intermittently managed across the previous five years cutting their number by 40% while increasing end-user customer satisfaction with the resulting output.
• Developed a Virtual Landing system that allows for the redirection/logging of campaign-based landing page traffic by source media and region (DMA). Included database infrastructure, specification of ASPX redirector (hooked off the IIS 404 message) and full interactive reporting.
• Integrated of IfByPhone toll-free call tracking and Google AdWords into campaign-based traffic logging/reporting. Also developed various HTA-based tools for the ETL, database process reporting and web developer utilities.
• Various ad-hoc reporting on marketing data to serve the information needs of the marketing department.
• SQL Query performance tuning for existing reporting queries; on average was able to lower the runtime by 90% or more.
• Campaign support for numerous marketing campaigns, including integration into the corporate intranet (Oracle), various ASP apps including apps for salesreps allowing access to campaign facilities such as direct mail for their prospects and existing customers.

Skills: T-SQL, SQL Server 2000/2005, DTS, HTA, VBScript, ASP, CSS, DHTML, Visio

SQL Developer, DataMart Designer/Developer, Database modeler, ETL Developer, Systems Analyst

Confidential, Valley Forge, PA

Responsibilities:

• Developed a Medicare Part D Rx Pricing Model with actuarial to project the pricing Medicare Rx benefits and create bid-sheets for Confidential .
• Developed ETL/Blending/Data Manipulations process to handle the processing of multiple scenario’s across a 1TB database in close-to-realtime.
• Required heavy SQL development and performance tuning of stored procedures.
• Interfaced the output of the actuarial model to complex Excel spreadsheets for presentation.
• Developed dashboard application for scheduling and concurrent launch of model projections and review/reporting of the results.

Skills: T-SQL, SQL Server 2000/2005, ASP, DHTML, Excel VBA

SQL Developer, ETL Developer, Systems Analyst, Database Modler

Confidential, Valley Forge, PA

Responsibilities:

• Maintained/developed data mart ETL for a 4 Tb data mart/warehouse in DTS and T-SQL.
• Designed/implemented departmental operating procedures (Change Control, Development standards, etc.).
• Worked as part of the Data Warehouse data modeling group to design new subject areas
• Various systems analysis tasks including NPI, PBM in-sourcing, and Lab results (HIPAA X12N 837).
• Developed a Q/A system to monitor data quality in the data mart.
• Query, stored procedure and DTS batch process performance tuning
• Heavy development of stored procedures and DTS.
• As project lead managed 10 developers and QA/Production Control analysts.
• Developed a security audit system to audit access to sensitive data in database and the underlying raw data on disk with both Intra-net and e-Mail reporting.
• Developed various HTA-based tools for the ETL developers including a copybook converter, database comparison utility and file viewer w/ copybook support.
• Organized project planning for Outbound Data feeds department.

Skills: T-SQL, SQL Server 2000, DTS, HTA, VBScript, ASP, DHTML, DataStage (light), Visio

SQL Developer, ETL Developer, Systems Analyst, Project Lead, Database Modler

Confidential

Responsibilities:

• Additional follow-on product development/maintenance work including enhancement of database copy functionality, development of test databases and user interface design for copy facility.

Skill(s): z/OS, TSO, ISPF Panels, DB2, REXX, JCL