Summary of Qualifications

Ten plus years experience in the Information Technology Industry. Programmer/Business Analyst/Application Developer that has experience with extensive aspects of the business with special interest in developing solutions to technical issues as they may arise. This requires extensive testing and developing applications using primarily SQL and MS Suite, producing necessary documentation, collecting and analyzing data from multiple sources to deliver the desired solution. My technical experience includes statistical report development, application development and implementation, technical training, developing process procedures, and policies which included compliance with HIPAA requirements and guidelines .

Technical Skills

Professional Experience

Independent contractor

Confidential

• Provide support and maintenance for Microsoft applications.
• Develop databases and associated reporting.
• Build and support .Net applications on a fee for service basis.
• Supply documentation necessary for application maintenance.

Reporting/Application Developer Contract

Confidential

• Develop HIPAA compliant SQL queries, statements, and scripts necessary for applications and reporting solutions.
• Develop applications using C for use by claims and customer service personal.
• Build stored procedures, views, tables, and queries necessary for applications.
• TSQL development.
• Use of Business Intelligence Solutions to develop reports.
• Develop SQL Server Integrated Solutions.
• Build applications using Visual Studio 2008 and SQL Server 2008 R2.
• Meet project desired deadlines and provide current status reporting.
• Develop and modify existing SSIS packages.

Application Developer

Confidential

Develop HIPAA compliant SQL queries, statements, and scripts necessary for applications and reporting solutions.

• Analyze data using Microsoft Excel and Microsoft Access includes table look ups, queries, reports, and VBA application development .
• Develop applications using C for use by claims and customer service personal.
• Build stored procedures, views, tables, and queries necessary for applications.
• Build SQL Server Reporting Solutions SSRS needed for CRM and applications.
• Maintain CRM by adding new users, adjusting security settings, developing forms and reports, and creating mail merges.
• Trouble shoots and resolves any problems with existing applications.
• Provide current status updates using SharePoint server.
• Provide network support on an as needed basis configure email and phone settings, resolve network account issues, install applications, and trouble shoot any peripheral problems .
• TSQL development.

Reports Developer

Confidential

• Conversion of Crystal Reports 9.0 to SQL Server Reporting Solutions SSRS 2008.
• Use of SQL Server Report Builder 2.0 to assist in conversion of Crystal Reports.
• Use of Visual Source Safe to maintain backups of all file changes.
• Build necessary stored procedures for SQL Server reports.
• Provide project status updates to upper level management.
• Successful conversion of Crystal Reports using third party tool, and make necessary changes to XML to complete conversion process.
• Report formulas development using Visual Studio 2008.
• Use of Microsoft Excel 2007 for progress tracking and status updates.
• Develop Access applications.
• Use VBA for database, excel, and analysis.
• Maintenance of existing programs in Visual Basic 6.0 and VB.NET 2008.

Software Developer

Confidential

• Develop forensic case management software using VB.Net 2008.
• Use of SCRUM to facilitate software development process by breaking development into Sprint segments.
• Manage changes to program by use of Microsoft Team Foundation Server TFS there by allowing multiple developers to make changes to the program at the same time.
• Integrate reports into program using Crystal Reports 2008.
• Develop improved graphical user interface GUI using Windows Presentation Foundation WPF .
• Use of SharePoint to share relevant documentation related to project management and to manage tasks.
• Participate in all meetings related to software development, which included JAD sessions and goal planning.

Application Developer

Confidential

• Develop and maintain Microsoft Access database applications, Microsoft Excel spreadsheets for warehouse, transportation, and accounting operations.
• Use of Microsoft Access VBA for database maintenance and automation.
• Creation of Excel and Microsoft Access macros necessary for report automation.
• Supply support for end users in multiple locations, which involved working remote.
• Maintain documentation related to current and future applications.
• Participate in planning and development of current and future projects.
• Develop and maintain SQL Server 2000 tables linked to Access.

Database Analyst

Confidential

• Database Application Conversion to .Net
• Analyze current Microsoft Access applications for conversion to .Net 2005.
• Perform maintenance of Microsoft Access database applications during conversion process.
• Develop Crystal Reports necessary for on time reporting of transportation statistics.
• Participate in planning sessions necessary for conversion and joint application development.
• Meet project desired deadlines and provide current status reporting.

Reporting Analyst

Confidential

• Upgrade credit contracts from Crystal Reports Version 9.0 to Version 11 Business Objects .
• Verify data formats using XML Spy.
• Participate in planning and meetings associated with objective.
• Develop and maintain required documentation.
• Careful review of Crystal Report documents during all phases of project Development/Test, Model Office and Production to ensure attention to detail and quality of conversion.
• Redevelopment of documents to remove the extra logic that was required due to Crystal Enterprise 9.x product limitations.
• Meet project desired deadlines and report progress to upper management.
• Make necessary changes to documents to accommodate changes to XML data source.
• Web Developer QCI Consulting Contract
• Confidential
• Agricredit provides financial services to agricultural suppliers, manufacturers and distributors
• Involved in the conversion of the web site to French-Canadian for Canadian customers utilizing VB 6.0, ASP, Java Script and SQL Server.
• This site involves 3 tier architecture for Data, Business, and Presentation

Operations Analyst II Contract

Confidential

• Responsible for researching, compiling, analyzing and reporting various operational data from multiple sources, including unit production, productivity and/or quality statistics. Creating and maintaining databases using Microsoft Access and SQL Server, developing and executing queries both independently and with the direction of management. Defining user requirements, perform user acceptance testing and/or troubleshoot systems-related operational issues. Program documentation and procedures necessary for maintenance and user training.
• Development of Hazard Insurance program using Visual Basic 6.0 and Microsoft Access.
• Implementation of Mortgage Loan Reconciliation program using Microsoft Access as a collection management tool for loan analysis.
• Maintenance and modifications to Visual Basic check issuance program.
• Program changes involving use of VBA necessary for daily task automation Visual Basic, Access and Excel .

Developer / Business Analyst

Confidential

• Data extraction from MMIS Medicaid Management Information Systems to Microsoft Applications for further analysis and reporting. Compliance to HIPAA rules and regulations. Performed business/system analysis, detailed program design, coding, testing, deployment, technical documentation, and maintenance support. Additionally, conducted analysis necessary for state government reporting.
• Modifying existing reports using Crystal Reports versions 5 through 9 and including XML to match the criteria established by the users. Creating sub reports, using XML as a data source, setting new data sources, verifying database structures, and functions and formulas with string manipulation.
• Citrix administration for access to reports, queries, and for he ability of state users to access database, queries, reports, predefined queries, and security for Citrix users.
• Administration of Sybase tables and user access.
• Develop predefined queries, reports and set up access for internal and state users in STARS Statistical Tracking Analysis Reporting System . STARS uses Sybase as a primary data source for the software.
• Development and maintenance of all departmental Microsoft Access databases.
• Develop Microsoft Access VBA necessary for database automation.
• Develop Microsoft Access and Excel macros for automation of reporting.
• Development of telecommunication statistical tracking program using Visual Basic, Monarch, and Meridian Terminal Emulator to automatic monitoring departmental productivity necessary for state government program administration.
• Development of web based system using CSS, Excel, ASP, and SQL Sever 2000 to display reports critical for managerial decisions.
• Evolution of database application necessary for delivering accurate state Medicaid Fee Schedule.
• Development of statistical reports utilizing Crystal Reports, which involved the use of VB.NET, SQL Server 2000, and ADO.NET.
• Gather, define, and map business processes necessary for successful program implementation.
• Departmental support for applications and continual training necessary for successful implementation of program updates.