Summary:

• Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
• Extensive knowledge of C and .net environment.
• Eighteen plus years of Client/Server development using a variety of environments.
• Extensive Knowledge of Ajax, HTML, JavaScript, and VB Script.
• 7 plus years in ASAP .net environment.
• Ten plus years of Web development using a variety of environments,
• Twenty plus years of IT experience which includes over fifteen plus years of experience in Development and Design experience with MS SQL Servers 2008, 2005, 2000 and 7.0 in Production, QA, and Development environments.
• Flexible and versatile to adapt to any new environment and work on multiple projects.
• Excellent knowledge in RDBMS concepts and constructs.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS and SSIS Packages, Integration using .Net Bulk Copy
• Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
• Transformed data from one server to other servers using Bulk Copy Program BCP and Data Transformation Services DTS , SQL Server Integration Services SSIS
• Extensive knowledge of Relational Database Management Systems.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Hands on experience in trouble shooting database issues.
• Experience in writing and debugging stored procedures and triggers.
• Extensive knowledge in Data Modeling using ERWIN and TOAD tools and normalization of tables.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box

.

Technical Skills:

• Operating Systems Microsoft Window 95/98, NT, 2000, 2003, XP, Vista, Windows 7, UNIX
• Languages C , Visual Basic 3.0 6.0, C , XML, T-SQL, JavaScript, VB Scripts, Pascal, COBOL
• RDBMS MS SQL Server 2008, 2005, 2000, 7.0 and 6.5, Sybase 10, 11, 12, MS-Access, MYSQL, Dbase, Paradox
• Front End .Net 2003-2010, MS Visual Basic, Dreamweaver, Delphi
• Internet Technologies Ajax, ASP, ASP.Net, JavaScript, VB Script, HTML, XHTML, E-Z Publish
• Version Control Tools Visual Source Safe, Microsoft Team Foundation Source Control
• Other Tools ERWIN Toad Data Modeling, Crystal Reports, SQL Backup, Infragistics grids client server and web
• Hardware Microsoft Environment
• SQL Server Tools Enterprise Manager, Profiler, Query Analyzer, Export Import DTS, SSIS , Visio, Database Connectivity
• Specialty Trizetto Facets

Work Experience:

Confidential

MCG Consulting is a software development firm specializing in software for the energy industry.

• Redesign of client web application to manage credentialing of energy system operator, including maintenance of provider courses and operator transcripts. Application was developed in .Net 2010 C 3.5 framework with asp.net, Microsoft AJAX and JavaScript/JQuery with Microsoft SQL Server backend. Web application made extensive use of user control design technique. Clustered environment.
• Development of new software to manage marketing of energy across the Energy Grid.
• Enhancement and maintenance of current Energy Accounting System per customer needs.
• Enhancement and maintenance of current Control Area Scheduling System per customer needs

Environment: Windows XP, Windows 7, MS SQL Server 2008 2005, T-SQL, C , Custom built frameworks. .net 2010 with 3.5 environment

Confidential

Programmer/Analyst, Web Development

• Harmon Solutions Group is a 3rd part vendor to the insurance industry, specializing in glass claims for 60 automobile insurance carriers.
• Design and development of various Client/Server and Web Applications for call center property and auto glass .
• Work included several custom web interfaces ASP.Net and C . Net . All applications were designed using object-oriented design and incorporated a large variety of the C classes, as well as JavaScript for web pages. Application work included database design modeling, stored procedures, testing, Microsoft SQL Server . JavaScript and style sheets.
• Custom DTS SSIS Packages and batch processes.
• Interface structures for client/server to Unisys mainframe.
• Design and Development of custom on-line customer billing application C .net 2005, SQL Server 2000
• Design and development of Ecommerce web site. Tools included C , ASP.Net and Microsoft SQL Server. Extensive use of JavaScript and style sheets.
• Conversion of Applications .net 2003 -> .net 2005
• Currently updating applications to .net 2008
• Environment: Windows XP, MS SQL Server 2008 2005, C , ASP.Net.

Confidential

Consultant

• Conversion of Microsoft Access database to SQL server stored procedures and database. DTS packages uses to extract data from a variety of sources.
• Amerigroup is a maintenance provider for Medicaid, WIC program
• Process to merge data from a variety of sources SQL, Oracle, Excel into a single user SQL Server database using a combination of DTS packages and stored procedures Performance tuning for existing stored procedures.
• Environment: MS SQL Server 2005, Windows XP.

Confidential

Consultant

Microsoft SQL Server Development to enhance existing Property and Casualty insurance program web app C . Task involved the addition of new stored procedures as well as changes to existing procedures to move from single user to multi-user environment. In addition, many other enhancements were added to the program, requiring updated or new stored procedures.

Environment: MS SQL Server 2005, .Net 2005

Confidential

Consultant

• PIA-USA is a private concern involved with helping the inventor community
• Telecommuting position - design and implementation of custom Web application using EZPublish web content management system. Partial overlap with M S/B Project . PHP and MYSQL database.

Environment: Windows, SQL Server 2005.

Confidential

Consultant

Development of specialized database for incoming Army Reserve and National Guard Units. Process required design and development of SQL Server database with approximately 50 tables and 70 stored procedures. Design and implementation of Web interface, using ASP pages, with extensive use of VB Scripting and Dynamic HTML. Reporting capabilities were included.

Environment: SQL Server 2000, Visual Basic.

Confidential

Consultant

• Davis Audio specializes in the sale and rental of audio/visual equipment.
• Telecommuting position - Access development. Position required updates to existing Microsoft Access program, including enhancements to existing screens and reports, as well as development of new screens and reports. Position required additional work done on the back-end Access database including additional fields and new tables

Environment: Windows, Access.

Confidential

Consultant

Development of SQL Server backend stored procedures to service Crystal reports Facets reporting data warehouse. Project involved mainframe conversion to Facets Client-Server involving approximately 120 reports and stored procedures. Work was performed completely telecommute via a VPN connection Virtual Private Network to the client-site. Creation of user-defined data types and functions. Stored procedure tuning speed indexing was the responsibility of the programmers.

Confidential

Consultant/DBA

• Design and development of custom database, including specifications and data modeling, SQL Server 2000, along with VB 6.0 front-end for access and edit of data. Database comprised of 160 tables and 200 stored procedures, and user-defined functions. Worked also included design of reports VB Print object and Microsoft Access and custom letters Microsoft Word and Access . As the sole programmer on-site, work also included DBA role, including stored procedure tuning, table indexing, triggers, database backups, DTS and Job Scheduling packages
• Custom applications to gather information from United States Patent Office web site, in order to develop company database for marketing.

Environment: SQL Server 2000, Windows.

Confidential

Consultant/Programmer

• Development of additional batch processes to work done in prior consulting role at the company. Additions included the auto loading of benefit and provider rows to Facets proprietary database. Process included the full analysis, table design and data modeling indexes, foreign key and triggers , development, all stored procedures, as well as enhancement of previous Visual Basic front-end application to handle maintenance of the auto loads. Work required extensive knowledge of both the benefit and provider subsystems within facets. Work included the communication with front-end users
• Worked with internal employees in a consulting role relative to issues on stored procedure implementation query analysis, writing, and tuning for performance .

Environment: SQL Server 2000, Visual Basic 6.0.

Confidential

Consultant

• Armed Forces Insurance is an insurance carrier specializing in Auto Liability for military members.
• Backend database work in Microsoft SQL Server 7.0 to support Multi-Tier, OOP Visual Basic application used in conjunction with larger system-wide application. Work involved design of relational database, including approximately 150 tables, user-defined data types and functions, using Erwin database modeler, coding of 200 stored procedures, including several batch processes to handle conversion of information from file to database tables. Project also included automated processes, using SQL Server Job Scheduler, through system-stored procedures. Process included extensive work with company DBA.

Environment: SQL Server 7.0, Visual Basic.

Confidential

Consultant

• Intertec is a specialty publisher of 50 magazines/periodicals.
• The conversion of Microsoft Access databases into a single SQL server 2000 database. Redesigned Access databases as interim step. Process involved development of database tables to handle a variety of topic matter covering 60 magazines, in addition to a Visual Basic front end for data access/ input, and all stored procedures for data access and update. Program used ADO data access and stored procedures exclusively for access to the database 20 screens .

Environment: SQL Server 2000, Visual Basic, Access.

Confidential

Consultant

• Traders Insurance specializes in high risk automobile insurance.
• The Design and development of Visual Basic application to handle a variety of inquiries for Automobile insurance company, against NT SQL Server database. Process included design and development of VB front-end application, using ADO data access, and extensive use of Microsoft flex-grid control, and writing of all stored procedures against existing database. Process included some refinement to back-end database to support front-end application,
• Design and Development of a variety of Company reports using both Crystal Reports and Visual Basic Print object. Work involved conversion of data and front end application from Fox Pro program.

Environment: SQL Server 2000, Visual Basic.

Confidential

Consultant/Programmer

• Design and development of broker commission batch process to replace Legacy system program. Extensive work on developing data model in conjunction with data analyst and DBA. Process included the addition of 30 tables and stored procedures to handle the batch processes.
• Design and development of VB 6.0 front-end application to handle specific Blue-Cross data relative to the above process. Included table design, stored procedure analysis and writing, and ADO database access for the front-end.
• Design and development of VB 6.0 front-end application to handle specific Blue-Cross data relative to the above process. Included table design, stored procedure analysis and writing, and ADO database access for the front-end. Life Cycle design, development, and implementation Visual Basic program to allow broker and provider access to database information. Group, claim, membership, and provider used with Citrix remote access. Visual Basic 6.0, ADO data access, TrueGrid data control 18 screens . Design of back-end database structures. Sybase stored procedures used in conjunction with Internet access.
• Sybase stored procedures used with system-wide phone inquiry system.
• Developed stored procedures used with company batch processes, including commission, customer explanation of benefits, provider remits reports, provider capitation, claims, subscribers and membership, membership benefit, product plan, customer service, and utilization management for Facets proprietary database. Process required modeling of new database tables, indexes, foreign keys, triggers etc.
• Designed and developed, in conjunction with Business analysts, DBAs, and end-users, custom batch processes to auto load benefit and provider rows to Facets database. Process included the design and development of new database, database tables and stored procedures, as well as Visual Basic front-end application to handle maintenance of the auto loads. Task included 5 provider batches network, out-of network, and covering provider, provider groups, and capitation and 4 benefit batches products, limits, variable components, and service prefixes ..
• Work with internal employees in a consulting role relative to issues on stored procedure query analysis, writing, and tuning for performance .
• The contract allowed for extensive use of tables across a variety of Facets subsystems, including the XP database, claims, customer service, finance, commission, benefit, providers, subscribers, and members.

Environment: SQL Server 7.0, 2000, Visual Basic 6.0.

Confidential

Consultant

• NCIS specializes in providing insurance to the farm community.
• Development, and implementation of Printer management system for large quantity of document flow, including text, GIF, and BMP formats for Xerox and Hewlett-Packard printers on Unix and Microsoft NT. Development included Visual Basic, several third party VBX and OCX controls Note: program was migrated from 16 bit to 32 bit, during development including Truegrid, WIN32SDK, and Microsoft SQL Server 6.5.
• Enhanced existing Visual Basic application to create print documents. Redesign of front-end to increase selection criteria for various print files, including additional tables and stored procedures.
• Enhanced existing Visual Basic application to download data to be stored in Microsoft SQL Server database. Changes included design and development of system to download GIF image files, converting to BMP, and through Windows API and Xerox and Hewlett-Packard print drivers, create spoolable JPL print files. Converted from VB 3.0 to VB 5.0.

Environment: SQL Server 6.5, Visual Basic 3.0 5.0.

Confidential

Consultant

• Additions to existing Borland C program to develop new front-end dialog boxes and new classes to be in existing class hierarchy design. The process included the creation of addition tables and stored procedures with Sybase System 10 database using DB-Lib database connectivity.
• Design, development, and implementation of Visual Basic 3.0 application to create accounting subsystem for USDA database. System included the development of all stored procedures.
• Design and development of Conference Room Scheduler for department of USDA using Visual Basic and SQL Server NT 6.5. Work included database design, writing of all stored procedures, and front-end.
• Design of program to automate conversion of documents from state departments of Agriculture into RTF for Microsoft Word and HTML documents for use on the Internet. Process included development of process to automate forwarding of such documents via Lotus CCMail, using DDE exchange.

Environment: SQL Server 4.5, Visual Basic 3.0, Borland C .