Software developer having more than 10+ years of experience to analyze, design, develop, deploy and problem solving in the IT projects. Experiences in:

• Developing desktop, intranet, Internet applications using ASP.Net, C#, Visual Studio.Net, ASP, Visual Basic, Visual Interdev, and C++.
• Create and consume WCF, Web, and Windows Services using C#
• Design and monitor database, Create Stored Procedures, Views, Triggers, Functions and Indexes in SQL Server, Sybase and Oracle. Tools used SQL Query Analyzer, ISQL with Transact SQL (T-SQL), SQL Profiler, Embarcadero, PL/SQL, SQL *Plus and TOAD. DTS, SSIS in SQL Server and ETL.
• Design and develop reports in SQL Reporting Services (SSRS) and Crystal Reports. Deploy reports in Report Server and Crystal Enterprise.
• Create Universe, Class and Objects in Universe Builder and Design and develop reports in Web Intelligence Document in Business Objects.
• Share Point (WSS) for Document Management and Business process flow model using Bizflow.

Confidential, Edison, NJ May 2009 – April 2012

Projects: OmegaEMR, Pharmacy Interface, Point of Care & Billing (LinkRx)
It’s an EMR system which handles patient admission, orders, MDS, census, care plan, billing, reports, workflow, lab, diagnosis, monitoring, documentation, progress notes and patients point of care for facilities/nursing homes. Pharmacy Interface integrated with the facilities.

Responsibilities:

• Analyze and understand existing application.
• Enhance existing application and create new applications.
• Design and develop application using ASP.Net, C#, JavaScript, jQuery and Ajax.
• Design and enhance existing database.
• Create stored procedures, views, functions, triggers and indexes in SQL Server.
• Create reports and sub reports using Crystal Reports .Net and SSRS.
• Performance analyze and tuning in application, sql server and reports.
• Create application portal using SSO and shared application.
• Create components, services and controls using C#, services using WCF
• Design database layer using LINQ SQL and Datasets.
• Use CTE and Dynamic SQL in stored procedures for complex reports and sql jobs.
• Create package to Extract and load data using SSIS.
• Coordinate with offshore.
• Use third party tools Aspose and Dynamic TWAIN.
• Use Web Deployment Project to deploy application.
• Configure and Deploy application in test and production servers.
• Backup and restore database and monitor database in test server.
• Support for test and production issues.

Environments: Visual Studio .Net 2003 / 2005 / 2008, SQL Server 2005 / 2008, C#, ASP.Net, JavaScript, Ajax, Crystal Reports .Net, SSRS, SSIS, Aspose, Dynamic TWAIN, Team Foundation Server 2008

Confidential, Whippany, NJ Aug 2006 – April 2009

Project 3: Morpheus (Commercial Mortgage) (Jul 2008 – April 2009)
Convert BLAST (Loan application – Which is described below) into Morpheus with latest technology. Additionally, Share Point 2007 integrated using document management. Application developed using C#, .Net 3.0, SQL Server 2005, SSRS, SSIS and Web Services.
Project 2: COPA (Commercial Mortgage Operations Application) (Nov 2007 – Jun 2008)
The project will provide an interface for the Whole Loan Operations team to compare, correct, and adjust transactions associated with downstream processes, including manual journals and P&L deposits of residual reserve postings as well as reporting of all activities. Application developed using ASP.Net, C#, .Net 2.0, SQL Server 2005, SSRS, SSIS and Web Services. Initially created as web application and converted into windows application. Documents maintained using Share Point 2007.
Project 1: BLAST (Barclays Loan & Asset Securitization Tracker) (Aug 2006 – Oct 2007)
BLAST is used by the Commercial Mortgage-Backed Securities (CMBS) to track loans and assets from inception (Pre-quote) through securitization. Application developed using C#, .Net 1.1, SQL Server 2000, DTS and Crystal Reports 10 with Web Services and Widows Services. Documents maintained using Share Point 2003.

Responsibilities:

• Analyze and understand existing application.
• Enhance existing application and create new applications.
• Design and develop application using ASP.Net, C# and Infragistics.
• Design and enhance existing database.
• Create stored procedures, views, functions, triggers and indexes in SQL Server.
• Create reports and sub reports using Crystal Reports, Business Objects and SSRS.
• Performance analyze and tuning in application, sql server and reports.
• Create components, services and controls using C#.
• Design database layer using Datasets.
• Use CTE and Dynamic SQL in stored procedures for complex reports and sql jobs.
• Create package to Extract and load data using DTS and SSIS.
• Manage and configure document management in Share Point (WSS).
• Modify sizing spread sheet (Loan Model) using Excel / VBA.
• Support for test and production issues.

Environments: Visual Studio .Net 2003 / 2005 / 2008, SQL Server 2000 / 2005 / 2008, ASP.Net, C#, SSRS, SSIS, Share Point 2007 / 2003 (WSS), Business Objects 11.0, Crystal Reports 10, Infragistics, Excel / VBA, XML, Perforce 2007 (Morpheus), Rational Clear Case 6.0 (COPA), Visual Source Safe 6.0 (BLAST), MS Project

Confidential, Washington, DC Sep 2005 – Jul 2006

Project: EDTS (Economic Data Tracking System)
EDTS is the intranet application which is used to track all country data submission from data arrival to dissemination and to replace 4 different existing desktop applications to single application. This application mainly integrated with two different applications EDF (Visual Basic and SQL Server), ICS and two external databases for Country and Correspondence information.

Responsibilities:

• Gather requirements from Business Users.
• Create customer design review (CDR) and software design documentation (SDD).
• Analyze and understand existing applications and external applications.
• Design and develop application using ASP.Net, C# and Bizflow.
• Design and develop new database.
• Create stored procedures, views, functions, triggers and indexes in SQL Server.
• Create reports and sub reports using Crystal Reports .Net
• Performance analyze and tuning in application, sql server and reports.
• Create components, services and controls using C#.
• Create package to Extract and load data using DTS.
• Integrate with other applications using Bizflow.
• Query Bizflow database in Oracle using TOAD.
• Configure and Deploy application in test and production servers.
• Support for test and production issues.

Environments: Visual Studio .Net 2003, ASP.Net, C#, SQL Server 2000, Crystal Reports for .Net, Bizflow 9.0, Oracle 9i, TOAD, Visual Source Safe 6.0

Confidential, Washington, DC Sep 2004 – Sep 2005

Project 3: ODSAdmin (Jun 2005 – Sep 2005)
ODSAdmin is an intranet application which provide administrative task for ODS (Online Donation System). This system developed using ASP.Net, C#.
Project 2: FRN-OCRA 3.0.0 (Apr 2005 – Jun 2005)
FRN-OCRA system is an intranet application which is used to collect information about funds raised for the nationals. Data entry process developed using ASP.Net, and all report related process developed using ASP.Net, C#, Crystal Reports 10.0 and Crystal Enterprise 10.0

Component: CEReports (Feb 2005 – Apr 2005)
There are two parts which can be used in any ASP or ASP.Net application for reporting needs:
1) CEReports 2) CEReportsNET and CEBasePages
CEReports is the generic component that can be used by any ASP web application.
CEReportsNET and CEBasePages are generic component and dynamic web page which can be used by any ASP.Net web application. CEReports and CEReportsNET component provide common functionalities to generate report. CEBasePages is the dynamic ASP.NET web page.
Project 1: In-kind 2.0.0 (Sep 2004 – Feb 2005)
In-Kind system is an intranet application which is used to collect online donation information. This application is developed combination of both ASP and ASP.Net. Data entry process developed using ASP, COM and all report related process developed using ASP.Net, C#, Crystal Reports 10.0 and Crystal Enterprise 10.0

Responsibilities:

• Analyze and understand existing applications.
• Enhance existing applications.
• Design and develop application using ASP.Net, C#, Application Blocks, FreeTextBox and HttpHandler.
• Create stored procedures, views, functions, triggers and indexes in SQL Server.
• Create reports and sub reports using Crystal Reports.
• Configure and deploy reports in Crystal Enterprise.
• Performance analyze and tuning in application, sql server and reports.
• Create components, services and controls using C#.
• Create dynamic page using Crystal Enterprise SDK.
• Prepare installation instruction document (IID) to the Test and Production servers.
• Support for test and production issues.

Environments: Visual Studio .Net 2003 / 2002, ASP.Net, C#, ASP, Visual Basic 6.0, Visual Interdev 6.0, SQL Server 2000, Crystal Reports 10.0, Crystal Enterprise 10.0, , Visual Source Safe 6.0, MS Project, FreeTextBox, Test Director 8.0

Confidential, Paramus, NJ Mar 2004 – Jul 2004

Project: QuickPay
MedTrx is a System Integrator/Aggregator providing products/services to doctors and insurance companies. QuickPay system is a bridge between the doctors and insurance companies to automate the process of billing, invoicing, payments, tracking, generating reports and faxing reports automatically.
Responsibilities:

• Gather requirements from Business Users.
• Design and develop application using C# and Application Blocks.
• Design and develop new database.
• Create stored procedures, views, functions, triggers and indexes in SQL Server.
• Create reports and sub reports using Crystal Reports .Net
• Performance analyze and tuning in application, sql server and reports.
• Create package to Extract and load data using DTS.
• Automate report generation and send it by fax.
• Create package to be deployed to client machine
• Support for application issues.

Environments: C#, SQL Server 2000, Visual Studio .Net, Crystal Reports.Net, FoxPro, Visual Source Safe 6.0

Confidential, Mechanicsburg, PA Jul 2002 – Jan 2004

Project: CPCMS (Common Pleas Criminal Court Case Management System)
The purpose of the project is to automate the court systems of Common Pleas for state government of Pennsylvania.
Environments: Visual Studio .Net, C#, Crystal Reports 8.5, Crystal Enterprise 8.0, Sybase 12.5, Embarcadero, Access 2002, Visual Source Safe 6.0, JAVA, JDK 1.2 (Java Development Kit), Remedy Action Request System 5.0, Citrix

Confidential, Groveport, OH Feb 2002 – Jul 2002

Project: CSM (Clinical Study Management)
The CSM metrics project evolved from the Watson global Clinical Study Management initiatives. These initiatives highlighted the need to collect, track and regularly analyze key metrics in the life cycle of clinical studies. The harmonization of study design and management processes by the CSM teams enabled PPG to define common study milestones (dates) that then were built into Watson's Right rack system.
Environments: ASP, HTML, DHTML, XML, XSLT, VBA, Visual Basic 6.0, Visual Studio 6.0, Oracle 9i, SQL, PL-SQL, Visio 2000, Crystal Reports 8.5

Confidential, Dayton, OH Jun 2000 – Dec 2001

Project: Sales Commission (Trilogy)
The purpose of the project is everyday nightly engine process should run to receive data from legacy system and transfer into SQL Server. Based on the business requirements, sales commission compensation plan has to set up for the different titles using “Trilogy” which interfaces with Visual Basic and SQL Server. Finally data should be extracted from SQL Server database and generate reports using Crystal Reports.
Environments: Visual Basic 6.0, Visual Studio 6.0, SQL Server 7.0, Access 7.0, Crystal Reports 8.0 & 8.5, IIS 4.0, ASP 2.0, VB Script, Java Script, HTML, DHTML, FrontPage 3.0, Crystal Enterprise 8.0, Visual Source Safe 6.0, Excel, Windows NT 4.0

Confidential, Chennai, Tamil Nadu, India Jan 1999 – Mar 2000

Project: Consignment Tracking Business System and Financial Accounting System
The purpose of the project is to computerize the entire business processes of DTDC (Mailing Service) offices spread across the country.
Environments: Visual Basic 6.0, Visual Studio 6.0, IIS 4.0, MTS 2.0, ASP 2.0, VBScript, JavaScript, HTML, DHTML, FrontPage 3.0, VBA, Oracle 8i, Crystal Reports 4.5/7.0, Access 7.0, MS Office, and Windows 95/NT 4.0

Confidential, Tamil Nadu, India Sep 1997 – Dec 1998

Project: Enterprise wide Resource Planning (ERP)
This project like similar to ERP products, which have Login, Operation, Marketing, Material and Finance module to computerize two wheelers manufacturing company of TVS-Suzuki.
Environments: Visual Basic 5.0, SQL Server 6.5, Crystal Reports 4.5, Far Point Spread 2.5, C, Visio, Windows 95/NT 4.0

Confidential, Chennai, Tamil Nadu, India Jun 1996 – Sep 1997

Product: Mobilizer
This package automates the entire work done in a financial organization. It involves creation of Fixed Deposit Schemes and maintaining Fixed Deposit accounts. It also deals with the creation of Recurring Deposit, Savings Accounts and Loans. The system also has an in-built accounting system from which Trial Balance, Balance Sheet etc., could be generated.
Environments: C++, Sybase SQL Anywhere 5.0, Windows 95

Frameworks: .Net 1.1 / 2.0 / 3.0 / 4.0, Entity Framework
Web Tools: Visual Studio. NET 2008 / 2005 / 2003 / 2002, VS.NET, ASP.NET, IIS 4.0 / 5.0 / 6.0 / 7.0, MTS 2.0, ASP 2.0 / 3.0, VB Script, Java Script, HTML, DHTML, CSS, Visual Interdev 6.0
GUI: C#, Visual Basic 6.0 / 5.0 / 4.0
Databases: SQL Server 2008 / 2005 / 2000 / 7.0 / 6.5, Sybase 12.5 / 5.0, Oracle 9i / 8i, Access
Database Tools: SSRS, SSIS, DTS
Reporting Tools: Business Objects 11.0, Crystal Reports .Net / 10.0 / 8.5 / 8.0 / 4.5 /, Crystal Enterprise 10.0 / 8.0
Document Tools: Share Point 2007 / 2003 (WSS)
Other Tools: Bizflow 9.0, Infragistics, Excel/VBA, UML, Visual Source Safe 6.0, Citrix 6.3, Remedy Action Request System 5.0, Terminal Services Client 5.0, Remote Desktop Connection, Test Director 7.0 / 8.0 and Far Point Spread 2.5, DynamSoft SourceAnywhere 3.0, Outlook and Visio
Operating Systems: Windows 95/NT/2000/2003/2008/XP/7/Vista
Languages: C, C++, PASCAL, COBOL, FOXBASE, FORTRAN, BASIC

Certifications:

Brain Bench - Visual Basic 6.0, MS SQL Server, HTML, ASP
Hammerman Associates - Crystal Reports