Professional Summary

• Microsoft Certified Professional with 13 years of experience in the Information Technology industry with over 7.5 years of experience in programming using the SQL Server6.5/7/ 2000/ 2005,Visual Studio 2008/ 2005/ 2003, .NET Framework 3.5/ 3.0/ 2.0/ 1.1, .NET Compact Framework using C , VB.NET, WIN Forms, ASP.NET 3.0/ 2.0/ 1.1, IOS,Objective C,Team Foundation Server, Reporting Services SSRS , MS SQL Server CE, ADO.NET, IBM Clear Case, .NET Cruise Control, NANT, HTML, XHTML, XML, AJAX, and Web Services , WCF.
• Over 3.5 years of experience in programming with the Visual Basic 6.0, ASP 3.0, MS Access 7.0/ 2000, MS SQL Server 6.5/ 7.0, and Visual SourceSafe.
• 5 Years' Experience in SQL Server Performance Tuning, improvement, storage, index and configuration.
• Experience in Data Modeling Logical and Physical Design of Databases , Normalization and building Referential Integrity Constraints. Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions. Very good T-SQL Programming skills. Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands Experience in Database backup and disaster recovery procedures. Experience in Replication Snapshot, Merge and Transactional. Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to 2005.
• Very strong experience in database related work primarily using MS SQL Server and other RDBMS servers such as MS Access, Informix, and Paradox.
• Experience in SQL Agent such as job scheduling.
• Experience in DTS Packages, OLAP, Pivot for importing/ exporting data from CSV, Excel, and databases using OLE DB Providers, Smart Navigator, and ODBC Provider.
• Experience in creating .NET Packages/ ETL for Import/Export Wizards SSIS .
• Created Web/ Windows Application in .NET, ASP, Visual Basic, and Delphi for clients such as JP Morgan Chase Bank, Citibank, Nestle, Jacob H G, and Unistar International Ltd.
• Developed, configured, and deployed a variety of .NET Framework Applications.
• Over 4 years of extensive Windows experience in N-Tier Component based Windows DNA development using VB,COM, DCOM, ADO, ASP, and DHTML
• Developed applications using Web Client software factory with Presenter, Controller, and Viewer Architecture.
• Extensive knowledge of coding with good debugging and troubleshooting skills.
• Translated complicated enterprise specific business rules and procedures into appropriate business logic components such as code libraries, stored procedures, triggers, views, and functions.
• Experience in each phases of Software Development Life Cycle SDLC , concept to full implementation, and software design life cycle management implementation with Agile Methodologies.
• Experience in HP Quality Centre Mercury , issue tracking for defects tracking and issue management.
• Over 1 year experience in programming with the Delphi 3, Informix 7.22, Quick Report, PVCS, and Erwin 2.6.2.
• A keen Analyst and Team Player with thorough understanding of all aspects of the SDLC from understanding client requirements through direct client interaction, translating them into technical specifications and driving their execution

Technical Skills:

• Operating Systems: Pentium II/ III/ IV HP 9000-D200/ HP-UX Server , Pentium IV, Windows 95/ 98/ XP/ 2000/ 2003/ NT 4.0
• Tools: Erwin, BIDS, Mercury Quality Center, TFS, Issue Tracker.VSS, PVCS, IBM Clear Case, NUnit, Win Cruise, SQL Agent for Job Scheduling, Reporting Services 2003/2005, Crystal Report 7.0/ 8.5, Quick Reports, Data Reports, IIS 5.0/ 6.0, COM/ DCOM, COM
• Software: .NET Framework 1.1/ 2.0/ 3.5, Visual Studio 2008/ 2005, ASP.NET 2.0/ 3.5, C , VB.NET, ADO.NET, ADO, NANT, AJAX, Web Services with WCF, JavaScript, HTML, XHTML, MSMQ, Windows Services
• Databases: MS SQL Server 2005/ 2000/ 7.0/ 6.5, MS Access 2000/ 7.0, Informix 7.22

Professional Experience:

Confidential

Role: Sr .Net Developer

• CCC and CCCI to track project Change Requests and Ideas for Wells Fargo Home Mortgage.
• It enable Servicing Department to appropriately assess and control the risks and impacts associated with each change and Ideas and provides a universal risk based change control process that addresses process, technology, documentation and regulatory changes for mortgage servicing. It is used to implement user feedback which will improve usability, clarify information and streamline processes.

Responsibilities:

• Responsible for gathering CCCI and CCC Enhancements Support requirements from WFHM team.
• Developed enhancements for a website written in ASP.NET, C , AJAX, CSS, Java Script, Visual Studio 2010.
• Done optimization performance tuning in SQL Server 2008.
• Developed Incident specification for CCC and CCCI applications.
• Created SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Created prototype for concepts of BM and TSS modules.
• Responsible for creating CCC web application using ASP.NET, C , and NET Framework 3.5 and SOA implementation

Environment: VS2010 ,VB.NET,C ,MS SQL Server 2008, ASP.NET 3.5, C , ADO.NET, XML, TFS for Version Control, AJAX, WCF, JavaScript, HTML, XHTML, Windows Services, LINQ

Confidential

Role: Sr .Net Developer

Asurion, LLC is the largest global provider of wireless handset insurance and wireless roadside assistance programs. Asurion also offers data-backup services through wireless carriers in North America.

Responsibilities:

• Responsible for gathering Production Enhancements Support requirements from Asurion team.
• Pinpointed and solved several of our most widespread crashing bugs.
• Developed enhancements for a website written in ASP.NET, C , Ajax, CSS, Java Script, JQuery, Visual Studio 2008.
• Developed Customer Module in ASP.Net, C and SQL Server 2005.
• Constantly submitted new bug reports for Mobile Insurance Kit developed in IOS and Objective C.
• Created Monitoring design using PRTG tool.
• Created Threshold objects for Production Server.
• Done optimization performance tuning in SQL Server 2005.
• Developed Incident specification for Asurion applications.
• Handled Team for Sprint Migration.
• Developed estimation plan for Customer and Customer Payment module.

Environment: PRTG, Tibco, IOS, Objective C, SQL lite, MS SQL Server 2005,ERWinn,VS 2008, ASP.NET 3.5, C , ADO.NET, XML, TFS for Version Control, AJAX, WCF, JavaScript, HTML, XHTML, Windows Services

Confidential

Role: Sr .Net Developer

Trade Wind Accounts Payable system is an application used for clearing Invoice Payments. Payments are made to clients and customers via Check, Wire and Ach, Amex payment methods. The application allows the user to maintain vendor information, control the AFE expenditure process, print reports, auto check clearing and process paid files to Deutsche Bank. TradeWind Accounts payable has ability to transmit payments to Vendors electronically The Bank that manages our checking account Deutsche Bank has a product called Automated Clearing House ACH services which allow their clients to electronically transfer funds from a Deutsche Bank checking account, to an account in another bank. This resembles a wire transfer, similar to the disbursement of our payroll.

Jaywalk:

Jaywalk is an application used to create a marketplace for Independent Research Providers IRPs to distribute their unbiased research to institutional investors on the Internet. Jaywalk provides institutional investors with tools to streamline the search for new and applicable research. Researchers have a number of different ways to load their reports into Jaywalk. A researcher may want to post a single report on a single stock. Or they may want to post a single report that covers a number of different stocks Group Report . Or they may want upload an entire batch of reports at one time. Jaywalk provides custom capabilities that allow any of these options.

Responsibilities:

• Responsible for gathering business requirements from BNY team.
• Created database design using Erwin tool with SQL Server 2005.
• Created SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Done optimization performance tuning in SQL Server 2005.
• Developed requirement specification for Account Payable and Jaywalk applications.
• Developed estimation plan for Account Payable and Jaywalk applications.
• Created POC for Account Payable and Jaywalk applications.
• Created technical business solution plan for current system.
• Created proposal of system and technical architectures for above applications.
• Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.

Environment: MS SQL Server 2005, ERWinn, VS 2008, ASP.NET 3.5, C , ADO.NET, XML, TFS for Version Control, AJAX, WCF, JavaScript, HTML, XHTML, Windows Services

Confidential

Role: Lead Developer

Project: DFD Digital Flight Deck

Business aim of the project is automate global finance operations, which consisted of Investment Banking IB , Treasury Services TS , and Business Management BM . Project implemented using Web Client Software Factory and facilitates Excel formatted inputs.

Responsibilities:

• Responsible for gathering business requirements from GFO Team, and created design, requirement, and development specifications.
• Created SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0
• Created prototype for concepts of BM and TSS modules.
• Managed team of six resources from work allocation to execution of module over production.
• Responsible for creating GFO web application using ASP.NET, C , and NET Framework 3.5 and SSO implementation
• Developed business logic using WCF Services in C for validating Excel input and exporting data in SQL Server 2005.
• Developed business logic components for middle-tier using C collections and generics.
• Responsible for creating architecture using Web Client software factory and resolving resource's technical issues.
• Created complex stored procedure, views, triggers, functions, and performance tuning.
• Used SQL Profiler for performance of stored procedures.
• Used Mercury Quality Center/ Load Runner for performance and unit test cases

Environment: Agile Methodologies, VS 2008, ASP.NET 3.5, C , ADO.NET, XML, VSS for Version Control, Cruise Control, NANT, MS SQL Server 2005, DTS Packages SSIS , ETL, SQL Agent for Job Scheduling, AJAX, WCF, JavaScript, HTML, XHTML, Windows Services

Confidential

Role: Sr. .Net Developer

Retail Portal is centralized system for managing OWN and Franchise Center's Invoices/ Receipts, Academics, Exams, Performance, and students.

Responsibilities:

• Responsible for gathering business requirements from in-house clients and created design, requirements, and developed specifications for Center, Academics, Student, and Network modules.
• Responsible for project estimation, project resource planning, allocation, execution, and implementation.
• Analyzed business, and delivered IT solutions required for business process, and executed it from Technical team.
• Managed infrastructure required for IT technical resources, and interacted with client for requirements and one point contact for Retail Portal Project.
• Managed team of over 15 resources for technical implementation.
• Involved heavily on technical architecture, coding, and deployment.
• Responsible for creation of web applications using ASP.NET, SQL Server 2005, and C .
• Developed job schedulers such as student login creation using SQL Agents.
• Responsible for migrating E-CAS data from MS Access to SQL Server using SQL Server Integration Services.
• Developed business logic using Web Services/ WCF in C for deleting cache and retrieve data in portal through SOAP and FTP. Migrated existing Web Services to WCF services.
• Developed number of methods/ functions using collections and generics to retrieve and bind data from database to UI.
• Created number of static and dynamic user controls and custom controls for Retail Portal.
• Used Microsoft Application Blocks and SQL Broker for fast and efficient development.
• Created complex stored procedure, views, triggers, functions, and performance tuning.
• Implemented SharePoint for issue tracking for Retail Portal project.
• Implemented MSF Practices for Agile methodologies.

Environment: VS 2005, ASP.NET 2.0, C , ADO.NET, XML, VSS for Version Control, MSF, SharePoint, Load Runner, MS SQL Server 2005, DTS Packages SSIS , ETL, SQL Agent for Job Scheduling, AJAX, Web Services, WCF, JavaScript, HTML, XHTML, MSMQ, Windows Services

Confidential

Role: Senior Software Engineer

Loss Avoidance Database LAD is an application used primarily for reviewing high risk deposits by creating alerts for Electronic Money Movement EMM , Generic Department GD , Fraud Hot Line FHL , New Account Screening NAS , and Kite Department. The primary goal of the LAD project is to start loading data into LAD to minimize the inefficiencies of the current review process which is largely manual. All these alerts are scored on Prioritization Engine to calculate risk. This will allow Deposit Risk Operation DRO to have all of the LAD functionality during reviewing these alerts. Landing Pad is used for importing data and after manipulation sends this data to LAD.

Responsibilities:

• Responsible for gathering business requirements from clients and creating design, requirement, and development specifications.
• Responsible for creating DRA application using .NET Framework 3.5.
• Responsible for creation of web applications using ASP.NET, SQL Server 2008/ 2005/ 2000, VB.NET, and C .
• Developed 100 or more pages related to core LAD, GD, FHL, EMM, KITE, and NAS Departments.
• Used client/server-side validation controls in .NET.
• Used AJAX to show transaction history and account history in Kite department.
• Developed packages in .NET for loading and analyzing data into Landing Pad through MS Access, CSV, and Excel file.
• Created SSIS Packages using ETL to create import process and feeder process.
• Developed Job Schedulers such as import process and feeder process in SQL Agents.
• Responsible for migrating ATM Data from MS Access to SQL Server.
• Responsible for creation of SQL Server Integration Services for importing data.
• Developed business logic using Web Services/ WCF in C for deleting cache and retrieve data in MMS and Negative Accounts through SOAP and FTP.
• Migrated existing Web Services to WCF services.
• Developed and implemented environment in Agile Methodologies.
• Developed business logic components for middle-tier using C Collections.
• Developed number of methods/ functions using collections to retrieve and bind data from database to UI.
• Used paging concept on basis of ordered data.
• Developed caching logic for performance in web application.
• Developed FTP Client for loading and exporting account detail.
• Created number of static and dynamic user controls and custom controls for LAD.
• Developed delegates and events used in user controls, to handle runtime events in web pages.
• Used Microsoft Application Blocks and SQL Broker for fast and efficient development.
• Created complex Stored Procedure, Views, Triggers, Functions, and performance tuning.
• Used SQL Profiler for performance of stored procedures.

Environment: Agile Methodologies, VS 2005, ASP.NET, C , ADO.NET, XAML, IBM Clear Case for Version Control, SharePoint, Cruise Control, NANT, MS SQL Server 2005, DTS Packages SSIS , ETL, SQL Agent for Job Scheduling, AJAX, Web Services with WCF, WWF, JavaScript, HTML, XHTML, MSMQ, Windows Services

Confidential

Role: Senior Software Engineer

Mighty Dog is web-based application consisting of different types of flavors required for feeding doggies. It also keeps track of health and medical checkup of doggies.

Responsibilities:

• Responsible for creating stored procedure, views, functions, tables, and triggers.
• Responsible for building a Web-based and Windows-based C , ASP.NET, and ADO.NET application.
• Created business objects and data access object in VB.NET for retrieving data from MS SQL Server.
• Worked on ADO.NET that was the primary data access technology accessing SQL Server data. Database work involved, writing T-SQL statements and stored procedures, which were in turn called by the Data Access modules using ADO.NET.
• Performed both in-built ASP.NET server validation controls and custom server-side code validation against company database lookups.
• Responsible for creating stored procedure, business logic layers for accessing data from SQL Server and validation methods.
• Created DTS package for importing and exporting data from Excel sheet and MS Access.
• Developed .NET Remoting server for fetching product information.
• Used Team Foundation Server for SourceSafe versioning and document versioning.

Environment: VS 2005, ASP.NET 2.0, C with ADO.NET, XML, VSS, MS SQL Server 2005, Reporting Services 2003

Confidential

Role: Lead Software Engineer

Environment: VS 2005/2003, WIN Form, ASP.NET 2.00, C with ADO.NET, XML, VSS, MS SQL Server 2000/ 2005, Reporting Services 2003

JPCS is web-based application consist of six module Project Allocation, Budget and Forecast, Expenditure and Commitments, Change Management, Project Administration, and Utilities JPCS is mainly responsible for the Budget allocations, Estimation, Labor, Non-Labor Expenditure, and Commitment against projects.

Responsibilities:

• Responsible for building a web-based C , ASP.NET 2.00, and ADO.NET application.
• Responsible for gathering business information and implementation.
• Worked on ADO.NET that was the primary data access technology accessing SQL Server Data. Database work involved, writing T-SQL statements and stored procedures, which were in turn called by the Data Access modules using ADO.NET
• Performed both in-built ASP.NET server validation controls and custom server-side code validation against company database lookups.
• Developed over 15 reports in Reporting Services 2003.
• Developed .NET Remoting Client/Server for accessing WBS structure.
• Responsible for creating stored procedure, functions, and tables.
• Used Mercury Quality Center and Load Runner
• Responsible for creating business logic layers for accessing data from MS SQL Server and validation methods. Used Team Foundation Server for SourceSafe versioning and document versioning.

Confidential

Role: Group Leader

MS SQL Server CE will consist of a list of sales representatives, the sales opportunities that they are working on, and the current status of those sales opportunities meeting whether they are closed lost in progress.

Responsibilities:

• Responsible for coding application using C with ADO.NET Compact Framework , Windows CE, Pocket PC 2003, and SQL Server CE.
• Responsible for coding business logic layers for accessing data from MS SQL Server CE and Validation methods.

Environment: C with ADO.NET Compact Framework , XML, VSS 6.C

Confidential

Role: Software Developer/ Analyst

PMS system offers the ship staff a powerful tool to keep track of maintenance of every piece of machinery on the ship, including the ship itself.

Responsibilities:

• Created business logic layers for accessing data. Coded using VB.NET, ASP.NET, and ADO.NET.
• ADO.NET was the primary data access technology accessing SQL Server data. Database work involved, writing T-SQL statements and stored procedures, which were in turn called by the Data Access modules using ADO.NET
• Both in-built ASP.NET server validation controls and custom server-side code validation against company database lookups were performed
• Created stored procedure, functions, and tables.

Environment: VB.NET, ADO.NET, ASP.NET, XML, Crystal Report, VSS 6.0, MS SQL Server 200

Confidential

Role: Software Developer/ Analyst

A System is developed using 3-tier architecture. It is divided into Middleware, Database Server and the Clients. The Database Server MS SQL Server 2000 processes all the requests related to the Database. The Source Code and COM Objects are stored in middleware that serves the requests of the clients. All the requests from clients are made to the middleware that processes the requests and return the results to the clients. ActiveX Data Objects ADO is used for the Data Access. All the database manipulations are done using the stored procedure.

Responsibilities:

Participated in designing, coding and implementation. Performed coding and maintenance.

Environment: Visual Basic 6.0 with ADO 2.5, Crystal Reports 8.5, VSS, ASP, MS SQL Server 7.0

Confidential

Role: Software Developer/ Analyst

This project consists of five modules Air Export Clearance, Air Import Clearance, Sea Export Clearance, Sea Import Clearance, and FedEx Clearance.

Responsibilities:

Participated in designing, coding, and implementation.

Environment: Visual Basic 6.0 with ADO 2.5, Crystal Reports 8.5, VSS, ASP, Spread Control, MS SQL Server 7.0

Confidential

Role: Software Developer/ Analyst

A System is developed using 3-tier architecture. It is divided into Middleware, Database Server and the Clients. The Database Server MS SQL Server 2000 processes all the requests related to the Database. The Source Code and COM Objects are stored in middleware that serves the requests of the clients. All the requests from clients are made to the middleware that processes the requests and return the results to the clients. ActiveX Data Objects ADO is used for the Data Access. All the Database manipulations are done using the stored procedure.

Responsibilities:

• Participated in designing, coding, and implementation.
• Performed coding and maintenance. Participated in unit testing.

Environment: Visual Basic 6.0, Crystal Reports 8.5, MS SQL Server 2000, COM, and DCOM

Confidential

Role: Software Developer/ Analyst

The project involves design and development of ERP covering business areas such as Sales, Purchase, Financial Accounting and Costing, Production, and Materials Management. The application is designed using 3-Tier architecture of Delphi 3.0. The 3-tiers are the database tier, application tier and client tier. The connectivity between the application and the client tiers is established using the OLE enterprise. The application tier retrieves data from the database tier through Borland Database Engine BDE . The reports are generated using Quick Reports.

Responsibilities:

• Participated in coding and testing. Implemented reports using Quick-Reports.
• Have designed and developed some of the application servers like Accounts and Purchase including a few common services on the servers using Delphi-3.
• Created tables,views,store procedure using Informix 7.2
• On the client-side, coded many transactions including a few complex ones

Environment: Delphi 3.0, Erwin 2.6.2 OLE Broker, PVCS, Informix 7.22, HP 9000-D200, HP-UX Server , Pentium client , Windows 95/ NT 4.0