Summary

• 7 years of experience in Systems Analysis Design Development and Implementation of various applications including Web and Client/Server Application development using Microsoft .NET Framework C .NET VB.NET ASP.NET and Ajax.net
• Analyze the source map documents and creating packages to move the data from source to destination.
• Creation of work flows with Data flow Task Script Task Execute Sql Task and Containers.
• Used Transformations like Derived Column Conditional Split Aggregates Sort Data Conversion Merge join and Union all. .
• Experience error handling while moving the data.
• Created Configurations Checkpoints and Breakpoints in packages for better reusability.
• Experience in Creating jobs and Scheduling SSIS Packages.
• Created simple and complex reports by customizing look and feel by using various report models and pass the parameters according to business user s request.
• As per requirements developed the reports in the form of Table Matrix and Chart using SQL Server Reporting Services.
• Experience on VBA EXCEL .
• Extensive knowledge on SQL Server.
• Experience in IIS VB 6.0 CSS XML WSDL SOAP Classic ASP 3.0 JavaScript HTML and DHTML and MS Visio.
• Hands on experience in SQL Server and Oracle database design and development in writing Constraints Indexes Views Stored Procedures Cursors Triggers and User Defined Functions.
• Experience includes in Finance Insurance and Banking domains.
• Acquaintance using report generation tools like Crystal Reports and WinWord.
• Well versed in Object Oriented Design Development using .Net technologies.

Skills

Work Experience

Confidential

Role Senior .Net Developer

The main objective of the project is to specialize in providing short and long term international health international medical and international travel health that are designed for both US and non-US citizens including any student traveling or living abroad. It generates clinical indicators to describe the history of the patients entered into the system. The project takes advantages of using Smart card Storage and Touch Screen optimized user interface and which can provide data in a structured and well-defined format in the reporting services and to provide the managers the ability to analyze the data and make the business decisions.

Responsibilities

• Extensively worked on LINQ.
• Developed Technical Design Documentation using TDD.
• Migrating modules from Visual Basic 6.0 to Web forms and Windows .Net forms by using C .Net and ASP.Net 4.5
• Migrating reports from Visual Basic 6.0 to .net PDF reports.
• Involved in writing new stored procedures and modifying existing Stored Procedures using SQL Server.
• Modified the business logic from VB com components to WCF web services WSDL .
• Fixing the bugs and checking the modification into central repository system TFS
• Created tables views stored procedures and packages using oracle 10g.
• Extensively worked with VB 6.0 Web Forms and C .NET SQL Server 2008.
• Created unit Test cases using Visual Studio. Net.
• Developed Excel Files from Sql Server Packages SSIS and SSRS.
• Worked on Presentation Data Access and Business Logic layers of the application.
• Extensively worked with AJAX and JavaScript for Asynchronous communication.
• Worked on XML parsing.

.

Environment Visual Studio 2010 C .NET Framework 4.0 WCF ADO. Net ASP. Net. Web Services AJAX VB 6.0 CSS XML XSLT HTML DHTML Oracle 11g SQL Server 2008/2005 TFS and LINQ.

Confidential

Role .Net Developer

This project has involved building an enterprise-wide data Warehouse for All State Bank US. The main aim of this project is to collect the data from different parts of the organization to work together and data into modern database systems. The bank has many reporting systems where information flows from banks corporate and other financial intermediaries at various frequencies. The information resides in many different files and in database developed by different vendors. This project supports the decision-makers and analysts to take effective decisions.

Responsibilities

• Validation was done using validation control in ASP.NET
• Developed the data binding and Data Access with ADO.NET with SQL Server Using C . NET.
• Worked on MVC architecture using ASP. Net and C .Net.
• Participated in the whole life cycle of the project including design phase of the project which was designed using ASP.NET C and Web Services
• Transformed data from various data sources using OLE DB connection by creating SSIS Packages.
• Designed and developed the Data Flows and control flows and performed data cleansing and quality using Fuzzy lookups.
• Worked with Different data transformations like Aggregate Data conversion Union All Sort and Merge joins look up etc.
• Developed Excel Files from Sql Server Packages SSIS and SSRS.
• Created/ Updated the ETL Technical Documentations on Clients Repository Portals.
• Involved in creating and modifying the ETL jobs and monitoring the ETL Schedule

Environment C SQL Server 2008 SSIS SSRS ETL.

Confidential

Role .Net Developer

Responsibilities

• Developed the data binding and Data Access with ADO.NET with SQL Server Using C . NET.
• Wrote C . Net class modules for database connectivity and execution of stored procedures/ functions using ADO.NET.
• Developed WCF Web Service using SOA for Validating Users.
• Used Interops for communication of Unmanaged and managed code.
• Explicitly Created Log files Which Kept Record of the Communication of the Application and the Server Role Based Security was implemented in the application in which access was given to the user on Particular screens based on his/her login ID.
• Designed and developed dynamic on the fly web based reports using ASP.Net 4.5 C . Net ADO. Net
• Microsoft Application Blocks were used for Exception Handling.
• All the reports were web based and were developed using Active Reports.Net with features like sorting text search and exporting to PDF or Excel sheet
• Implemented SQL Server state table to maintain session state across Web servers.
• Actively involved in documentation test plans test cases testing and reviews.
• Created FAQ s pages using XML XSL JavaScript and HTML.

Environment C .Net Asp. Net CSS SQL Server 2000 IIS Visual Studio.NET 2010 CM Synergy Microsoft Exchange Server TFS Microsoft visio2000 RUP UML Windows 2000.

Confidential

Role .Net Developer

Responsibilities

• Wrote Stored Procedures in SQL Server for implementing business rules.
• Extensively used LINQ to XML to write and read XML data in the C language.
• Developed classes and methods and written codes in Data layer for retrieving Data from the Database using Data Access Application Blocks and ADO.NET in C .net.
• Worked on Presentation Data Access and Business Logic layers of the application
• Designed and Developed reports for user details like Details of failure logins User-locked out history.
• Used Dataset Data Table Data Adapter Data Reader and other ADO.NET connectivity controls
• Created triggers indexes views cursors in Oracle using PL/SQL.
• Extensively worked with SSIS Packages.
• Worked on MVC architecture using ASP. Net and C .Net.
• Used Multithreading to provide synchronization to the Application.
• Extensively worked with VB 6.0 Web Forms and AJAX JavaScript ADO.NET and C .NET SQL Server
• Preparing implementation plan for the requirements using MS Visio.

Environment VS.Net 2008 C .NET VB.NET ADO.NET HTML XML XSD XSLT and Web services User Controls JavaScript VB 6.0 SharePoint 2003 MS SQL Server 2000 .NET Framework 3.5 CSS LINQ T-SQL and Visual Source Safe 6.0

Confidential

. NET Developer

Responsibilities

Developed the data binding and Data Access with ADO.NET with SQL Server Using C .NET.

• Wrote C . Net class modules using web forms for database connectivity and execution of stored procedures/ functions using ADO.NET.
• Preparing/Updating Technical Specifications for Bug/Task identified by OCS team.
• Preparing/Updating Change Order for the Bug/Task identified by OCS team.
• Analyzing bugs preparing time lines and getting approval from the OCS team for the timelines.
• Preparing implementation plan for the requirements.
• Participating in implementation with the team members
• Designed and developed dynamic on the fly web based reports using ASP.Net C .Net JavaScript.
• Microsoft Application Blocks were used for Exception Handling.

Environment VisualBasic.NET C win forms Asp. Net CSS SQL Server 2000 IIS Visual Studio.NET 2003 CM Synergy Microsoft Exchange Server Microsoft visio2000 RUP UML Windows 2000.

Confidential

. NET Developer

This website provides Patient Administration Billing and Pharmacy Management functions for the hospital. The major functions are Allocating Registration and Recording Personal Details Handling Hospital Admissions and Assigning Insurance Details for Billing Recording Transfers within the hospital and Creation of Discharge Summary and Details. The Billing module allows Billing and receivables looks into multiple modes of Payment and Rates Definition for Services. Pharmacy and Consumables management includes Maintenance of Drug Composition Batch-wise Stock of Drugs and Drug Categorization for Reporting.

Responsibilities

• Developed the website to display on a web server using ASP.NET C with Oracle 9i as the backend
• Used Visual Studio. NET for html editor
• Designed the database developed stored procedures cursors and triggers using Oracle PL/SQL
• Developed object oriented design and framework by identifying classes and implemented object oriented programming using VB.Net
• Handled Run Time Errors Design Time Errors by implementing appropriate Error Handlers in VB.NET.
• Developed the GUI using Custom and WEB Controls
• Designed and Developed VB.NET windows applications
• Designed web forms for Address Book interface in ASP.NET using ADO.NET Data Grid and Data list controls
• Validation was done using validation control in ASP.NET
• Used Seagate Crystal Reports 9.0 to develop tool reports for performance management
• Participated in the whole life cycle of the project including design phase of the project which was designed using ASP.NET C and Web Services
• Developed the front-end screens using Web forms

Environment ASP.NET ADO.NET Web Forms Windows Forms VB.NET VisualStudio.NET Seagate Crystal Reports 9.0 Oracle 9i IIS VSS and Windows 2000