PROFESSIONAL SUMMARY:

• Over 9 years professional IT experience in software design, analysis, development, testing, implementation and deployment of Web Applications and Windows Applications using Microsoft technologies.
• In hand production support experience of handling trading and marketing data
• Experienced in managing Onsite and Offshore team remotely
• Experience working with Oracle 8i/9i/10g and SQL Server 200/2005/2008 including PL/SQL programming
• Proficient in writing SQL, PL/SQL stored procedures, packages and triggers
• Experience with the .Net Framework 1.1/2.0/3.0/3.5 , Visual Studio 2003/2005/2008 , SQL Server 2008/2005/2000 , ASP.NET, C#.NET, ADO.NET, HTML, JavaScript, CSS, AJAX, XML, XSLT, IIS 6.0/5.1 and SSRS
• Extensively used ODBC, OLEDB, SQL Server Management Studio, Oracle 9i/10g, MySQL, MS Access, MS SQL Server 2005/2003, PL/SQL
• Sound understanding of Object Oriented analysis and design (OOAD) with UML Modeling
• Good experience in Analysis and Design in the RDBMS environment and creating databases in Oracle9i/SQL Server 2005
• Expertise in ADO.NET, development of Stored Procedures and Views using MS SQL Server
• Expertise in developing User Controls and Custom Controls
• Experience working in environments like MS WIN 9.x/XP/Vista, UNIX, LINUX, MS - DOS, Windows 2000/2003 Server, IIS, WebSphere servers
• Strong knowledge in Report development using Microsoft Reporting Services 2005
• Experienced in full SDLC (Software development life cycle) which includes System/Information Engineering, Software Requirements gathering, Systems Analysis and Design, Code Generation, Testing, implementation and Maintenance
• Executed software projects for Energy & Utilities, Telecom industry and Government sector
• Excellent work ethics, self-motivated, quick learner, team player and possess excellent technical and interpersonal skills

TECHNICAL SKILLS:

.NET Technologies: ASP.NET, ADO.NET, AJAX Control Toolkit, Web Services, Visual Studio 2008/2005/2003

Programming Languages: C#.NET, VB.NET, JAVA, PERL, VB 6.0, Shell script

Scripting Languages: JavaScript, VBScript, ASP, JSP, HTML, XML, CSS

Databases: Oracle 9i/10g, MS SQL Server 2000/2005/2008 , SQL, PL/SQL, ODBC, OLEDB, LINQ-to-SQL, MS Access

Web Servers: Microsoft IIS 5.1/6.0, IBM WebSphere 6.1/6.0

Methodologies/Tools: Dimensions, ChangeMan DS, SubVersion, PVCS, Visual Source Safe, CA Workload Automation tool, TOAD 9.7.2, Test Director, Remedy/PICCASO, Mercury IT Governance tool, Putty, FTP, Crontab

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Operating Systems: UNIX, Windows 2000/2003/2008 Servers

PROFESSIONAL EXPERIENCE:

Project Lead

Confidential, Houston, Texas

Responsibilities:

• Gathered requirements, wrote design documentation, prepared UML class diagrams, object diagrams
• Developed various custom web server controls derived from HtmlControls and WebControls and rendered as pure html to increase the site performance
• Implemented Master pages concept to keep the module consistent with the rest of the site
• Developed dynamic user interface screens in Ajax, Html and JavaScript
• Wrote the complete business logic and server-side validations in C#
• Used ADO.NET for database connections to the SQL server 2005
• Wrote Stored procedures to implement functionalities like insert, update, load and delete information from the SQL Server 2005 database for all modules
• Used Dimensions tool to manage and share source code among the team members
• Did unit and module testing of all modules
• Use PICCASO, ITG Mercury and Change Management for fixes, deployments and releases
• Prepare and deploy the solution after enhancement, bug/fix or regular maintenance work, verify the source code created or modified by other team members
• Create jobs using CA Workload Automation tool for creating the controls for next month and to send an reminder emails to the users for their pending check offs and attestation

Environment: Visual Studio 2008, .NET Framework 3.5, C#.NET, ASP.NET 3.5, HTML, CSS, JavaScript, AJAX, MS SQL Server 2005, IIS 6.0, SSRS 2008, Dimensions, CA Workload Automation tool

Confidential

Responsibilities:

• Developed web interface using ASP.NET 2.0, C#.NET, Javascript, Oracle 9i and SSRS 2005
• Wrote business logic in Oracle PL/SQL packages
• Extensively used Data Grid, DataTables and DataSets for data access and manipulation
• ChangeMan DS was used to get a latest copy of the project and checkout pages you wanted to work on
• Monitoring batch jobs and performs detail analysis & take remedial when they fail
• Wrote and enhanced Perl and Korn shell scripts for greater efficiencies
• Designed and developed reports for the end users containing Portfolio VaR & MTM information
• Participated during the preparation of Business continuity plan and performed Disaster Recovery exercise with Confidential IT on regular period
• Perform root cause analysis for any critical/high priority incident and log them in a file

Environment: Visual Studio 2005, .NET Framework 2.0, C#.NET, Java, ASP.NET, HTML, CSS, JavaScript, AJAX, Oracle 9i, ChangeMan DS, UNIX, PERL, KSH, CronTab

Confidential

Responsibilities:

• Involved in gathering initial requirements and wrote functional requirements
• Used C# for necessary business logic and to perform transaction processing, programmed exception handling and event handling
• Designed and implemented Data Access Layer (DAL) using ADO.NET objects
• Developed and implemented stored procedures, triggers, functions in SQL Server
• Extensively used Data Grid, DataTables and DataSets for data access and manipulation
• Done reporting using SQL Server Reporting Services
• ChangeMan DS was used to get a latest copy of the project and checkout pages you wanted to work on
• Handled post production support of ERS application

Environment: Visual Studio 2005, .NET Framework 2.0, C#.NET, HTML, SQL Server 2005, SQL Server Reporting Services, ChangeMan DS

Confidential

Responsibilities:

• Involved in gathering initial requirements and wrote functional requirements
• Designed and developed a N-tier architecture consisting of presentation, business, and data tiers having interfaces to common framework based components like exception handling, error login, session handlers, email support, and other utilities
• Developed web interface screens for various user options using JSP
• Used JavaScript for the client-side validations
• Used OOPs concepts while developing the business layer
• Wrote stored procedures, triggers and views in SQL Server 2005
• Used Hibernate for mapping the Java classes to database tables in SQL Server 2005
• Did Unit Testing and Integration testing for all the modules
• Used Dimensions tool to manage and share source code among the team members
• Use PICCASO, ITG Mercury and Change Management for fixes, deployments and releases
• Involved in writing the system user-manual for the application users
• Done reporting using SQL Server Reporting Services

Environment: Java, JSP, MS SQL 2005, Hibernate 3.0, Struts 1.2, SSRS 2005, WebSphere 6.1, Serena Dimensions tool

Confidential

Responsibilities:

• Analyzed the department’s critical support requirements, identified deficiencies and developed innovative solutions for increasing reliability and improving productivity
• Involved in detailed study of business logic layer, requirement analysis, identification and solving the technical issues
• Used C# for necessary business logic and to perform transaction processing, programmed exception handling and event handling
• Designed and implemented Data Access Layer (DAL) using ADO.NET objects
• Developed and implemented stored procedures, triggers, functions in SQL Server
• Extensively used Data Grid, DataTables and DataSets for data access and manipulation
• Developed various reports for the analysis of sales and service using Crystal Reports

Environment: Visual Studio 2003, C#.NET, ADO.NET, SQL Server 2000, Crystal Reports, Visual Source Safe

Programmer

Confidential

Responsibilities:

• Batch mode provision - Facility of transactions between district server and kiosks with minimum connectivity time for reducing cost of operations. All the information are later gathered on centralized database. The batch process keep tracks of the payments from various departments and perform calculations which are further by the business users.
• Perl and KSH shell were used for batch work processes.
• Designed and developed many Perl scripts for data processing
• Monitored batch job and take remedial action when they fail
• Database features are used to generate online forms resulting in ease of upgradation
• Designed in keeping long term objectives of state level integration - use of census codification pattern, database linkages across inter and intra departments

Confidential

Responsibilities:

• Key project implementations as team member. Developed part of the middle tier application using Perl and KSH script.
• Monitored batch jobs during the initial phase of the production support
• Wrote PL/SQL packages and perform database tuning, SQL query enhancements, code enhancements to achieve performance targets
• Designed the applications using ASP, VB.NET and VB 6.0
• Developed programs for accessing the database using DBI/DBD
• Developed library functions, UI screens, source code and performed table design changes.
• Continued support for production issues as 2 level production support specialist.
• Developed customized reports using Crystal Report 8.5 according to user need basis.
• XML has been used extensively for data transfer between two client locations in State pollution control board project.
• Participated in documentation and application testing

Environment: Visual Basic.NET, Visual Basic 6.0, ADO, ASP, JavaScript, Oracle, SQL Server 2000, MS Access 2000, XML, PERL, KSH, UNIX