OBJECTIVE:

• I am seeking a position as a SQL Database/Business Intelligence Developer that will allow me to utilize my database knowledge and skills including, but not limited to architecting and re - architecting SQL Server databases, optimizing and performance tuning SQL Server databases and stored procedures, as well as performing various reporting, ETL and other data management tasks utilizing SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services to assist you in leveraging your data to increase business efficiency and employee productivity.

TECHNICAL SKILLS:

Database Skills: SQL, T-SQL, PL/SQL, SQL Server, SQL Server Express, MSDE, Oracle, Access, SQL Server Management Studio, SQL Server Enterprise Manager, SQL Query Analyzer, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Programming Skills: C#, Visual Basic.NET, JavaScript, HTML/XHTML, XML, XSLT, XPath, .NET Framework, ASP.NET, WinForms, ADO.NET, Visual Studio, Microsoft Enterprise Library, Microsoft Team Foundation Server Client

PROFESSIONAL EXPERIENCE:

Confidential

Independent Database /.NET Consultant

Responsibilities:

• Experience working on projects for small businesses, Non-Profit, State Government and Fortune 500 companies.
• Experience working with end users to identify database requirements based on business, application and reporting needs.
• Experience designing SQL Server databases, based on application and reporting requirements using SQL Server Management Studio.
• Experience re-architecting SQL Server databases, to improve efficiency and overall performance of queries and reports, or accommodate changes in user requirements that the original design didn’t allow for.
• Experience optimizing and tuning SQL stored procedures to improve data accuracy and performance.
• Experience performing complex analysis on SQL Server databases to identify and isolate incorrect or missing data and correcting the problems, using T-SQL and SQL Server Management Studio.
• Experience performing analysis to identify how data is received and prepared for processing in order to identify process improvements and track data as it moves through the system.
• Experience creating ETL processes using both Stored Procedures and SQL Server Integration Services (SSIS).
• Experience developing static and dynamic reports using SQL Server Reporting Services, SQL Server and Visual Studio 2005.
• Experience developing static and dynamic stored procedures for use in various .NET applications and reports, using T-SQL and SQL Server Management Studio.
• Experience analyzing reports to determine if the problems identified where due to errors in the report file or errors in the data the report was based on and corrected the problem.
• Experience designing and building tools and processes to perform QA monitoring on the SQL Server database tables to insure that the data conforms to established business rules.
• Experience analyzing existing applications, reports and processes to determine how existing database resources can be utilized more efficiently.
• Experience developing and maintaining both Web (ASP.NET) and Windows (WinForms) based .NET applications using Visual Studio and the .NET Framework in object oriented and service oriented environments.

Software Developer

Confidential

Responsibilities:

• Assisted in the development of the Automated Deployed Record and Reporting System (ADRRS) for the US Air Force, using Visual Basic 6, ADO, Visual Studio 6 and SQL Server 2000.
• Developed methods to store and retrieve XML documents from SQL Server databases using Visual Basic, ADO and SQL.
• Developed methods to encrypt and decrypt XML documents using AES encryption, Visual Basic, ADO and SQL.
• Developed methods to automate the installation and configuration of Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) using Visual Basic, T-SQL and SQL-DMO.
• Developed methods to automate the installation and configuration of SQL Server 2000 databases using Visual Basic, ADO, T-SQL and SQL-DMO.
• Developed tools and methods to automate the process of adding NT users to multiple instances of SQL Server 2000 databases across workgroups and NT domains using Visual Basic, ADO, T-SQL and SQL-DMO.
• Developed methods to automate the installation and configuration of Application Roles on multiple instances of SQL Server 2000 across workgroups and NT domains using Visual Basic, ADO, T-SQL and SQL-DMO.

Technical Reports Analyst

Confidential

Responsibilities:

• Utilized my knowledge of business and technology to assist the VP of Quality Assurance for Service Operations in identifying inefficiencies in the quality assurance process and developing solutions, with an emphasis on leveraging database technology to maximize system efficiency and employee productivity.
• Utilized my knowledge of business and SQL to develop methods to analyze thousands of claims in order to identify duplicate and mispaid claims prior to payment, resulting in a potential savings of millions of dollars annually.
• Developed a plan to combine multiple Access and SQL Server databases into one integrated SQL Server database.
• Utilized my knowledge of business, relational databases and SQL to identify multiple problems in databases utilized by most departments in the company to produce critical reports, which had previously gone undetected.
• Utilized my knowledge of Access, SQL and Visual Basic to develop enhancements to a database application, utilized by the Quality Assurance department of a major insurance carrier to track the results of insurance claims audits.
• Developed a plan to convert multiple Access applications into one integrated ASP.NET application.
• Developed an ASP.NET application for managing and distributing reports using 2 ASP.NET pages to replace dozens of HTML documents and Excel spreadsheets.
• Utilized my knowledge of Visual Basic to develop enhancements to a database application, utilized by the National Call Center of a major insurance carrier to track document requests from members and physicians.

Programmer/Analyst (Short Term Contract)

Confidential

Responsibilities:

• Revised and optimized several hundred Stored Procedures for a SQL Server 2000 database using T-SQL.
• Performed analysis to identify and develop solutions for deficiencies in the user interface of a Visual Basic database application.
• Revised several forms in a Visual Basic database application, to improve user interaction.
• Revised and optimized code to improve functionality of several Active-X components using Visual Basic.

Computer Programming Student

Confidential

Responsibilities:

• Used PL/SQL and T-SQL to write stored procedures for Oracle and SQL Server databases.
• Used SQL DDL to created and modified Access, Oracle and SQL Server database tables, views, functions, procedures, and triggers.
• Used SQL DML to insert, update and delete data from Access, Oracle and SQL Server databases.
• Used SQL DQL to write static, dynamic and nested SQL select statements to query Access, Oracle and SQL Server databases.
• Developed applications using C/C++, Java and Visual Basic.
• Developed web pages using HTML/XHTML, CSS and JavaScript.

Clinical Program Manager

Confidential

Responsibilities:

• Developed digital versions of all forms (timesheets, mileage, etc.) and other documents utilized by personnel in the field to allow the forms to be filled out on a laptop computer and then e-mailed or faxed to the home office.
• Performed ongoing analysis to identify ways to enhance system efficiency and productivity of employees working in the field.
• Developed algorithms to determine strength impairment, as part of a project to develop enhanced software for a computerized strength testing system.
• Developed a solution prototype, to demonstrate proposed enhancements to a computerized strength testing system.
• Developed algorithms and conducted a study to determine the feasibility of a computer driven exercise protocol to increase aerobic capacity.
• Performed ongoing analysis to identify ways to enhance system efficiency and employee productivity.

Instructor

Confidential

Responsibilities:

• Developed multimedia versions of lecture presentations utilizing MS PowerPoint
• Developed an automated grading system utilizing MS Excel
• Designed and co-developed a FoxPro database application to collect and analyze data on subject's undergoing testing for Carpal Tunnel Syndrome.
• Developed algorithms to determine body composition in humans, as part of a proposed project to develop software to analyze human body composition.
• Performed systems analysis at various client facilities to identify ways to enhance system efficiency and employee productivity.
• Conducted feasibility studies at various client facilities to demonstrate how conversion from manual to computerized systems would enhance the client's ability to acquire and analyze data in a more efficient manner.
• Developed prototype solutions to demonstrate the benefits of converting from manual to computerized systems.

Physical Therapist

Confidential

Responsibilities:

• Conducted data analysis and developed methods to track the utilization of services and Confidential t progress within the facility.
• Developed rehab protocol utilizing a computerized strength testing system.
• Conducted feasibility studies to demonstrate how conversion from manual to computerized systems would enhance the ability to acquire and analyze data in a more efficient and useful manner.
• Performed ongoing systems analysis to identify ways to enhance system efficiency and employee productivity.
• Developed prototype solutions to demonstrate the benefits of converting from manual to computerized systems.

Manager

Confidential

Responsibilities:

• Established the first commercial facility in Virginia to utilize a computerized biomechanical model to test functional strength in injured workers.
• Provided consultation to Confidential , Inc. to develop enhancements to their Biomechanical Model software.
• Developed algorithms, to determine the effects of weight loss on functional strength.
• Performed ongoing systems analysis to identify ways to enhance system efficiency and employee productivity.
• Developed methods for tracking daily revenue, productivity, and utilization of services.