Sql Server Quality Assurance

David JacobusDavid JacobusDavid Jacobus

** ********* ***. ************, ** 19426 Phone: 215-***-**** E Mail:

abhvro@r.postjobfree.com@abhvro@r.postjobfree.com http://www.linkedin.com/in/davidjacobus

Background Summary

Information Technology Director with Proven track record of implementing Process Guidance to facilitate efficient software

development lifecycles designed to improve inter department collaboration and quality. Possesses a strong ability to analyze business

processes and lead initiatives on process improvement both through system enhancements and utilizing systems already in place.

Outstanding interpersonal, training and presentation skills with all levels of audience. Related areas of expertise are:

1. Process Improvement

2. Systems Engineering

3. Quality Assurance

4. Change Control

5. Cost Reduction

Experience

The Keane Organization – Director of Application Development 2010 Present

Responsibilities

Lead System Architect.

•

Manage the Application Development Team as well as Application Support Team in an effort to support the business through

•

innovation and efficiency.

Introduced Team Foundation Server 2010 to streamline the Development Lifecycle and ensure proper documentation of

•

development.

Adhered to SAS70 compliance and client requirements revolving around client data (SSN’s).

•

Accomplishments

Designed and Developed in a 4 month period a system to determine properties due to be reported for escheatment to the

•

appropriate state based on business rules. System would work in real time environment on data in the millions providing detailed

reports to be provided to clients. Reduced processing time from 10 15 days per file to less than 10 minutes per file.

• Developed a new Secure Client Portal in which Keane staff could securely exchange data for processing/review with clients.

Leveraged the Dot Net Nuke system already in place while writing a custom component to track all transactions for SAS70

Compliance/Audits as required by our clients/industry.

• In the process of development a corporate Mail Merge solution leveraging the Abstract Factory Design Pattern and Entity

Framework 4.

• Successfully upgraded MS Dynamics CRM from version 3 to version 4. The CRM product has been heavily customized using

plugins and call outs as outlined by MS Best Practices for extension.

Complete Healthcare Communications – IT Manager 2009 2010

Responsibilities

Oversee Day to Day operations of IT

•

Acted as Lead Architect in the development of a clinical trial aggregator (PubsHub).

•

Worked with Parent Company (MediMedia) in the integration of systems post merger, including but not limited to

•

the conversion of physical systems to virtual clients using VMWare.

Managed phone system and worked closely with vendors to migrate to a Dynamic T1 Service in two facilities.

•

Accomplishments

• Introduced Team Foundation Server and the use of Source Control.

• Architected an aggregation tool (PubsHub) written in C# leveraging the MVC Design Pattern and nHibernate to ease development

time and future maintenance.

LA Weight Loss – IT Director 2006 2009

Responsibilities

•

• Lead a Team of 15 IT members supporting 350+ International locations

• Acted as Lead Architect on all Systems supporting the business

• CRM (Customer Relation Management) – Utilized in Direct Marketing, Electronic Marketing of clients in an effort to increase

revenue.

• POS (Point Of Sale) – Tracked Sales, Inventory, Taxes and Metrics used to drive Business & Marketing Plans.

• Ecommerce

• ERP (Enterprise Resource Planning) – Consolidation of all data captured in POS, E Commerce and CRM for use in training of

center staff and metrics utilized by Senior Management to validate Business & Marketing Plans Executed.

Accomplishments

• Trimmed IT Expenditures by $250,000 in first year by reducing third party dependence and increasing in house expertise.

• Reduced Telecommunications spending by $24,000 per month through rightsizing of systems across the company.

• Successfully consolidated sparse systems into an ERP application to allow better cross functional data analysis for Executive

Business Decisions.

• Implemented a Records Management Policy/Data Disposition plan in conjunction with a Disaster Recovery project to ensure all

critical systems will be available at the lowest cost possible.

• Completed the decoupling of Telecommunication services previously shared with Pure Weight Loss of over 1,000 independent

accounts.

• Created a Change Control Board to facilitate IT projects in alignment with Business goals. This provided confidence for both

internal business users and Franchise Ownership that goals set would be accomplished as set in Quarterly projections.

• Implemented Feature Driven Development Process Guidance for all projects written in house.

• Initiated Data Disposition & Record Management Policy based on industry best practices designed to meet organizational specific

needs.

2

McBee Associates – IT Supervisor 2005 2006

Responsibilities

• Manage IS/IT resources

•Worked with the Network Administrator in the design and completion of a new data center. Consolidating systems from 4

locations (PA, NY, MD, VA) into the main headquarters while implementing a DR plan housed in NY.

• Development of New Applications

•Collection/CRM (Customer Relation Management)

•McBee Collect was written as an ASP.NET application used by 4 offices (100+) users as a means to track collections made on

behalf of clients (Hospitals, Hospices, etc.) in an effort to recover lost/missing funds due by the Private Insurance sector as well

as Medicare/Medicaid.

•Claim Analysis System used to predict underpayment to providers

• Maintenance of existing systems

Aetna US Healthcare 1997 2005

Software Developer

• Application Development/Database Analysis, Design

• Maintenance/Development of Actuarial Systems used by the Financial Underwriting Departments (500+ users).

• System calculated rates based criteria developed in collaboration with the Actuaries, Corporate/Federal Governance of the

Insurance Industry.

• Maintenance/Development of Claim Systems used by the Overpayment Recovery Unit & Third Party Auditors.

• Data Mining of Claims Systems to find patterns of Overpayments in historic data (2yrs).

Automation Developer

• Converted Manual Test Scripts into Data Drive Regressions Tests run as part of a Continues Integration Process utilizing Rational

Robot & MS SQL Server.

Business Analyst

• Software Design & Implementation

• Functional testing and validation of developed programs.

• Requirements management, Rational Unified Process (RUP).

2

Education

Project management Certification, Penn State Great Valley, PA 2009 2010

Application Development Certification, Penn State Great Valley, PA 2004 2005

Information Systems – Bucks County Community College Newtown, PA 1994 1997

Skills

C#/VB.NET 1.1 4.0 Framework, ASP.NET, SQL Server 2000 2008, Team Foundation Server (TFS), Source Control, Visual

Source Safe, Quest Spotlight on SQL Server, SQL Server Management Studio, Business Intelligence Development

Studio (BIDS), SQL Server Integration Services (SSIS), MS Project, MS Visio, XCode, Objective C (iOS), javascript,

jquery, HTML, Search Engine Optimization.

Personal Accomplishments

Published iOS Developer: http://itunes.apple.com/us/app/spinandmatch/id409681942?mt=8

2

Contact this candidate