SUMMARY

• Experience in the complete life cycle of databases including design, analysis, development, testing and Implementation
• Experience with Open Connect Configure and NASCO with Confidential
• Extensive Experience in SQL Server, T - SQL, Oracle and Ms Access, object oriented programming using Microsoft technologies in Visual Studio .Net/1.1, 2.0 and 3.x/4.0 framework
• Expertise in
• Strong skills in .NET Framework 3.5/3.0/2.0/1.1, VB.NET,ASP.NET,AJAX,Web Services, ADO.NET, XML, Visual Basic 6.0/5.0,XHTML/CSS, JavaScript, Crystal Reports, Visual SourceSafe 2005 and Team foundation.
• Expertise in Visual studio 2010/2008.
• Internet technologies such as ASP.NET, Web Services, Web Login, HTML, DHTML, XHTML and CSS.
• Used MS Visual Source Safe for source code maintenance.
• Worked extensively with Data Adapter, Dataset, Data reader as part of ADO.NET to access and update database.
• Created Windows Application, Websites, Web Portals and business logic using VB.Net, Win Forms and VB6.
• Database design, analysis and development skills using MS SQL Server and Oracle DBMS. Writing and debugging stored procedures, creating tables, triggers, UDF, Views, and managing indexes.
• Excellent experience in creating, managing and deploying various types of reports using SQL Server Reporting Services and Report manager.
• Experience in developing reports using SQL Server Reporting Services (SSRS), Crystal Reports, Oracle Reports and MS Access reports.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert and Bulk Copy (BCP).
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Knowledge of WAN and LAN
• Can work independently and completes tasks with a minimum supervision.
• Possesses excellent analytical, problem solving and learning skills as well as a keen interest in the emerging technologies.

TECHNICAL SKILLS

Development: VB.Net, ASP.Net 2.0/3.0, VBA, VB6

Databases: MS SQL Server 2005/2008, MS-Access, Oracle 8i/10G.

Reporting Tools: MS SQL Reporting Services (SSRS), Crystal Reports 8/8.5/10/XI, VS ReportsETL Tools SSIS (SQL Server Integration Services).

OS: Windows NT/2000/2003 Server/XP and Centos 5.0

Markup Language: HTML, XML, XHTML, CSS, DHTML

Scripting: JavaScript, VBScript, AJAX

Technology: ADO.NET, Web Services, .Net Framework 1.1/2.0/3.0, MS Queue

Other Tools: MS Office, MS Visual Source Safe, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

Environment: Open Connect Configure, NASCO (HRBK, HEHK (EEC), HURK, HIQK), SQL PLUS, SQL Server, ASP.NET 2.0, Visual Studio.NET 2005, C#

Responsibilities:

• Developed Open Connect Robots to resolve different edits
• Worked extensively in HIQK, HEHK (EEC), HRBK modules of NASCO claims processing system.
• Designed and developed dot net interface to consume HIPAA 5010 web service to be used in OFP robots
• Responsible for implementation and testing of ICD 10 changes in the existing Open Connect Robots.
• Worked with business and development teams to develop System, End-to-End, and Regression test scenarios, plans, and scripts.
• Reviewed/Participated in the development and execution of quality assurance plans to ensure HIPAA 5010 modifications ability to meet business requirements.
• Experiences working in Database like MYSQL and SQL server.
• Involved in Production Support.

Confidential, Pittsurbh, PA

Application Developer

Environment: VB.NET 2005, ASP.NET, MS SQL Server 2008, SSIS, SSRS, ADO.NET, XML, HTML, DHTML, CSS, JavaScript, AJAX and .Net Framework.

Responsibilities:

• Involved in Designing and Coding of various modules including UI screens in application using VB.Net, XHMTL, JavaScript and AJAX.
• Involved in working with XML by displaying and retrieving the data using XML file.
• Validation of web pages using required field, range, validation summary and regular expression.
• Responsible for connectivity of database using ADO.NET Components.
• Extensively worked with VB.Net for creating classes for Data Access Layer of the application and integrated with ASP.Net pages.
• Created components in VB.NET that can be reused on several pages.
• Created Database Diagrams, Defined relationship between tables and enforced the referential integrity constraints.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and Functions.
• Used various tools to improve SQL Server performance like windows performance monitor, Profiler trace, index tuning wizard.
• Extracted, transformed, and / or loaded data (ETL).
• Implementation and release of database changes, testing and security review
• Create SSIS and used the task to import and export files.
• Create, modify, schedule, test, delete, and / or troubleshoot SQL Server Integration Services (SSIS) packages, stored procedures, tables, and views.
• Create ad hoc complex management reports as required. Handle distributed queries, distributed transactions.
• SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Involved in Unit Testing and System Testing of the application.

Confidential

Software Developer

Environment: VB.Net, ASP.NET, MS SQL Server 2008, SSIS, SSRS, ADO.NET, XML, HTML, DHTML, CSS, JavaScript,AJAX and .Net Framework 2.0/3.0

Responsibilities:

• Designed the Functional Specifications of the system.
• Designed and developed SQL Server database to responsively handle complex queries (T-SQL, triggers, stored procedures, functions, optimization)
• Prepared project schedule and monitored tasks assigned to team members to ensure all deadlines are met.
• Create SSIS and used the task to import and export files.
• Create, modify, schedule, test, delete, and / or troubleshoot SQL Server Integration Services (SSIS) packages, stored procedures, tables, and views.
• Create ad hoc complex management reports as required. Handle distributed queries, distributed transactions.
• Used SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Developed user Web Pages interfaces using ASP.NET, HTML, DHTML, CSS, XHTML, JavaScript and AJAX.
• Created components in VB.Net that can be reused on several pages.
• Responsible for connectivity of database using ADO.NET Components.
• Contribute procedures and functions for the application’s Web Services which includes database manipulation using ADO.Net.
• Provided technical support to other .Net Developers especially when working on MS SQL Server and ADO.Net.

Confidential

Application Developer

Environment: SQL Server 2005/2008, SSRS, VB.NET, and ADO.NET.

Responsibilities:

• Designed and created User interface in Visual Basic .Net Win Forms and control classes
• Updated classes in VB.NET to be reused in ADO.NET
• Used MS Visual SourceSafe .Net for source code management
• Created multiple tables for Sales, Marketing and Inventory System and accounts Receivable Systems that interact with data access objects for data retrieval using ADO.NET .Net
• Created MS Access Database (MDF) and revised sub queries
• Wrote numerous Stored Procedure
• Updated Win Controls and Functional Class Library (Active-X, COM, OCX, DLL)
• Design and implementation of Security Model, policies and procedures
• Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool
• Created Snapshot Replication for the Development and Testing Databases across different Servers
• Development of SSIS Packages, stored procedures, views, triggers, index and SQL Scripts
• Release of database changes and security reviews
• Designed and developed complex SSRS reports
• Involved in Unit testing and System Testing for the application

Confidential

Application Developer

Environment: VB.Net, Oracle 9i, MS Excel 2003/2007, MS Access 2003, Enterprise Manager

Responsibilities:

• Implemented the presentation layer in ASP.NET and VB.NET using Web forms.
• Extensively used Datagrid, Data Repeater web server controls.
• Extensively worked with VB.Net for creating classes for Data Access Layer of the application and integrated with the ASP.Net pages.
• Involved in designing of conceptual logical model and physical model.
• Created new database objects like procedures, functions, packages, triggers, indexes and views using Oracle in development and production environment.
• Fine-tuned the logic in procedures, functions and triggers for optimum performance.
• Developed database triggers to enforce data integrity and additional referential integrity.
• Wrote transact SQL utilities to generate table insert and update statements.
• Involved in performance tuning and monitoring of PL/SQL blocks.
• Wrote stored procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created stored procedures to transform the data and worked extensively in for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (cluster index, non cluster index) tables.