SUMMARY

Broad experience in Web Development and Database Design through a combination of independent contracting and salaried employment combined with excellent communication skills and the ability to translate business needs to IT realities.

PROFESSIONAL EXPERIENCE

Confidential, PA

Programmer/Analyst

Responsibilities:

• Developed SQL Server Stored Procedures for comparing a random sample of any two tables.
• Development of a C#/ASP.net solution extending the administrative functionality of Great Plains.
• Extensive regression testing of an SSIS ETL for a Data Warehouse of Great Plains info.

Confidential, PA

Data Analyst/Developer

Responsibilities:

• Assisted in troubleshooting day to day problems with Courion Account Management.
• Responsible for Javascript development of proprietary extensions to Courion product.
• Extensive modification to SSIS scripts to import account information to Courion product, some VB.Net scripting included in said SSIS packages.
• Data Analysis on SQL Server backend ad hoc queries and reporting on Courion product in Windows 2003 VM environment.
• Design of ETL processes moving data from Oracle account information databases to centralized SQL Server system.
• Some SSRS reporting for real time summary of data errors in user lists.
• Complex data loading T - SQL Stored Procedures utilizing system tables for linked server work.

Confidential, PA

SQL Server Developer/Data Analyst

Responsibilities:

• SSRS based reporting for large scale data warehouse for major pharmaceutical client.
• Extensive use of SSRS charting capabilities and complex settings of report parameters.
• SSIS based exporting from same data warehouse.
• Some T-SQL performance tuning tasks using Query Analyzer and SQL Profiler.
• Stored Procedure work as back end for complex reporting tasks.
• Some analysis of data exports to ensure the correct output of ETL processes.
• All work done on a Windows 2003 virtual server.

Confidential, PA

SQL Server Developer

Responsibilities:

• Design and creation of SQL Server based DB system via DDL T-SQL for tracking Parking violations.
• Creation of SSIS scripts to automate the upload legacy data from Access into this DB.
• Design and implementation of SSIS ETL interfacing with 3rd Party parking software with said DB.
• Work performed on Windows server 2008.

Confidential, PA

Reporting/Data Analyst

Responsibilities:

• Extensive ad hoc and regularized reporting on the efficacy of the application security management and help desk departments of a large publicly traded corporation.
• Utilization of SQL Server, T-SQL, SSIS, Oracle and Crystal Reports to deliver reports.
• Maintenance of ASP Classic based reporting page.
• Business and data analysis and interfacing with fellow employees to determine reporting needs.
• Work in depth with reporting on Oracle Identity Management, investigation of poorly documented proprietary table structure to return meaningful reporting data.
• Work interfacing with MS Active Directory.

Confidential, Jenkintown, PA

Programmer/Analyst

Responsibilities:

• Primary responsibility for table design, index and performance tuning, stored procedure and trigger design. Utilized T-SQL Stored Procedures extensively in communication with ASP front and Access administration system for the system on a Windows 2000 server.
• Utilized Triggers for complex default pricing calculations, handling emails for changes in Product Status and preparing data for indexing.
• Created and maintained UDFs for various business logic and data formatting tasks.
• Work in maintenance coding for existing VB 6 apps for parsing census data and interaction between QuickBooks and SQL Server.
• Designing an AJAX interface for the population of order recipient data based on a data mined index of 2,000,000 previous orders. (Hardcoded AJAX with ASP, not object based.)
• Access admin system and ASP or ASP.Net web pages for system.
• Extensive work creating and maintaining MS DTS packages for the applications, as well as maintaining automated ETL procedures in various formats for transmitting and receiving orders from clients and vendors.
• Project based work on several ASP.NET sites using VB.Net.
• Some exposure to SQL .NET Assemblies on these projects.
• Various work on internal reporting projects with exposure to SQL 2005.
• Assistance on small ASP classic projects, occasional work with Lasso.

Confidential, PA

Database Programmer/ Electronic Editor

Responsibilities:

• Designed and implemented complex CSS system for above websites to replicate data formatting of source material.
• Created VB 6 Application for the automation of electronic document conversions in a generic way using Regular Expressions as a kind of Scripting mechanism.
• Automated numerous document conversion processes using aforementioned scripting program. (For example, generated source code for E-Books from editor-friendly tagged text.)
• Worked extensively on additional scripting with Perl.
• Responsible for maintenance of underlying SQL Server DB system for confidential
• Edited HTML/SGML content extensively for Web and CD publications.
• Some web design work and extensive image work with Adobe Photoshop.

Independent Contractor

Confidential, PA

Responsibilities:

• Designed scoring algorithm in Access/VBA 97 for a 122-question research survey including eight distinct rules for both relative and absolute scoring, as well as questions that disqualified respondents altogether.
• Designed a simple front end facilitating the addition of new data from incoming surveys, and the re-weighting of scoring proportions for each question.
• Advised client on the feasibility of designing a general system to allow this to be done for any form of survey with any number questions using any variant scoring method or combination of methods.
• Tutored client in the use of ANSI and Access SQL as well as the design of ad hoc reports and simple VBA.

Confidential, VA

Programmer/Analyst -Consultant

Responsibilities:

• Developed Reporting System in Access/VBA for Inspection/Testing Database on Factory floor.
• Designed an encapsulated system for the translation of such reports into Excel Graphs using Excel VBA.
• Assisted in the troubleshooting and extension of Materials Cost Estimating System (MCES).
• Developed Middle Tier for Intranet Labor cost reporting system using ActiveReports/VB 6.

Confidential, VA

Access Developer

Responsibilities:

• Assisted in the design of Large Mainframe-extracted Access Tables and the Procedures for filling them.
• Designed Static and Dynamic Reports to End-User specifications. Wrote SQL queries for the both the Mainframe system and the Access Front End.
• Developed Front-End Interface for directing Users to existing Reports.
• Oversaw the last stages of conversion from Access 2.0 to Access 97.

TECHNICAL SKILLS

Applications: SQL Server 2000-2010, Office, Outlook..

Web technologies: VBScript, Java Script, ActiveX, ASP, HTML/DHTML

Development Tools: T-SQL, Visual Basic 6.0

Reporting Tools: SSRS, Access, Crystal Reports, Active Reports

Exposure to: .NET Framework, VB.NET, ASP.NET, C#, MTS, MS Com / DCOM, C++, Java