SUMMARY

• A Lead developer/Sr. Programmer profile over 14 years of experience of total IT experience in application software analysis, design, development & implementation of n - tier applications primarily in the windows and web environment with very strong knowledge of commercial application development environment.
• Extensive experience in architecture and development of applications in .NET Framework 4.0/3.5, ASP.NET, MVC, VB.Net, C#, CSLA, WCF, Web services, Visual Basic 6.0, ASP, Soap, Crystal Reports, XML, XSL, MS SQL Server, SSIS and Oracle.
• Participated in all stages of Software life cycle, starting from requirements gathering to realization of the system and end-user support.
• Strong experience in the analysis, design, development and implementation of multi tier web based applications and distributed applications using web services and WCF, SOA.
• Good experience in CSLA business object and rules engine.
• 6 years of extensive experience with Oracle 11g including PL/SQL programming.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Extensive experience in Data modeling, Relational database logical and Physical design using Erwin.
• Around 2 years of ETL process implementation experience in Data Transformation Services (DTS).
• Expertise in working with relational databases such as Oracle 10g, SQL Server 2000/2005/2008 , MS Access.
• Proficiency in T-SQL programming stored procedures, functions and triggers in database Level.
• Broad experience on Database Performance tuning and Query Optimization.
• Extensive experience in writing UNIX shell scripts and automation of the FTP processes using UNIX shell scripting.
• Experience in writing SFTP scripts and FTP process implementation.
• Experience in translating cell formulas in Excel into VBA.
• Extensive experience in Configuration Management Tools like Visual SourceSafe and Serena Dimensions.
• Good business knowledge in Auto Insurance, Healthcare and Accounts.
• Experience with all the phases of project development life cycle and working in Agile Development process in current project
• Good experience in Project Management, Change Management and Project Proposal activities.
• Excellent communication and interpersonal skills, quick learner, self-motivated, ability to work individually and as well as in a team environment with good team spirit.
• Excellent in envisioning and adapting to upcoming and latest technologies.
• Good working experience in Onshore and Offshore model.

TECHNICAL SKILLS

ETL Tools: Informatica 8.6/8.1, SSIS 2008, DTS

Data Modeling: ERwin R8.

Databases: MS SQL Server 2000/2005/2008 , Oracle 10g/11g, MS-Access

Programming Languages: C#, Visual Basic 6.0, XSL, SFTP script, UNIX Shell scripting

.Net Technologies: ASP.Net, MVC, VB.Net, ADO.Net, Web Services and WCF

Web Skills: Ajax, ASP 3.0, HTML, XML, IIS, jQuery, Java Script, VBscript

Operating Systems: Windows NT/2003/XP

Reporting Tools: Crystal Reports 2008, SSRS 2008

Configuration Tools: TFS, Visual SourceSafe, MKS, Serena Dimensions, Clear Case

Other Tools: Visual Studio 2012/2010, Toad, SQL Developer, MS Visio, MS Project, Changepoint, JIRA, HP ALM

PROFESSIONAL EXPERIENCE

Sr Consultant

Confidential

Responsibilities:

• Worked with Business Analyst on analysis and logical design.
• Developed complex SQL queries, PL/SQL procedures to develop the Interfaces to extract the data in regular intervals to meet the business requirements.
• Extensively involved in Query performance tuning.
• Designed and worked on business and data layer using C#.
• Built a AJAX dynamic front end using jQuery/HTML/CSS on top of .Net MVC.
• Experienced and actively worked in CSLA business object and rules engine.
• Implemented and managed Data persistence (CRUD) using CSLA data access object.
• Created .Net MVC helper method to implement customized Spell check feature in JJIS.
• CSLA data access object connected with database using Windows Communication Foundation (WCF) service.
• Worked on DSM V and Uniform Working Directory (UWD) implementation in JJIS.
• Created project specific customized jQuery plug-in for UI validations.
• Used Microsoft Team Foundation Server (TFS) for project task, defect tracking and source code repository.
• Performed Unit testing, and defect fixes.
• Worked on user control in the project with Partial view and HTML helper methods.
• Worked on Juvenile Justice Information (JJIS) enhancement.
• Worked on Juvenile Detention Automation (JDAS) enhancement.

Environment: IIS 7.0/6.0, .Net Framework 4.0/3.5, Visual Studio 2012 / 2010, ASP.Net 4.0, Web form, MVC 4, CSLA, jQuery, HTML 4, CSS, C#, Vb.net, WCF, SOA, Oracle 11g, PL/SQL, TFS, Microsoft Enterprise Library, Toad, Infragistic Control Library, ASPNetSpellCheck.

Sr. Application Consultant

Confidential, Albany, NY

Responsibilities:

• Involved in Business requirements gathering, creating Design and functional document.
• Implementing Oracle PL/SQL queries and functions as per the design and development related requirements of the project.
• Participate in requirement elicitation to identify requirement gaps/issues (both functional and non-functional) in order to come up with a comprehensive requirement document.
• Implemented Materialized view for Data Analytical process.
• Identified the granularity level of the data required for analysis.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements.
• Extensively involved in Query performance tuning and partitions.
• Worked complex SQL Quires, Stored procedures for Report development.
• Working on report generation using Crystal report.
• Used JIRA for Issue tracking and Project planning system.
• Used Tortoise SVN for Repository.
• Used JAMA for Specification documents upload.
• Configured Crystal Reports from Report Manger Implementation using Confidential AUTOMATION system.

Environment: Oracle 11g, PL/SQL, SQL Developer, Crystal Report 2008, SVN, JIRA.

Project Lead/Lead Developer

Confidential, Schenectady, NY

Responsibilities:

• Architect the application platform, including the backend, messaging, and UI layers
• Involved in Estimation, Detail design, development and Implementation of web application and web service.
• Reviewed physical architectures to ensure compliance with original designs and standards, as well as gap analysis and resolution.
• Responsible for various phases of Deployment from Development to QA to Staging and finally into Production.
• Worked closely with business team, vendor, and environment management team to ensure the reliable implementation and stable infrastructure.
• Designed User Interface Presentation layer using ASP.Net 4.0 with MVC pattern, and Visual Studio 2010, C# .Net.
• Implementation of client side validations using JQuery andASP.NETMVC Validation implemented at Controller level.
• Involved in end to end project deliverables in creating Design document, Functional document, Traceability Matrix and run book notes.
• Used JSON results on MVC controllers for bringing the data on the web pages.
• Incorporated business logic in C#.NET and handled transactions from and to database using ADO.NET.
• Incorporated application authentication/authorization reading LDAP.
• Implemented ADO.NET objects like Command, Data Adapter, Dataset, and Data Reader for database connection.
• Developed SQL server stored procedures, Functions, SQL scripts to facilitate the functionality for various business rules.
• Experienced in Behavior Driven Development.
• Involved in Bug fixing, Code Reviews, UAT and Configuration Management.
• Leading of 7 member development team.
• Worked as the onsite and offshore coordinator, managed a diverse team, provided technical direction and functional assistance to team members and maintained project status reporting
• Provided leadership for the team, develop priorities and meet deadlines.
• Worked on agile implementation methodology.

Environment: IIS 7.0, .Net Framework 4.0, Visual Studio 2010, ASP.Net 4.0, MVC 4, Web API, REST, jQuery, HTML, CSS, C#, SQL Server 2008, MKS, HP ALM, Windows Server 2003.

Technical Lead

Confidential, Durham, NC

Responsibilities:

• Involved in Estimation, Detail design, development and Implementation of this SOAP based WCF service.
• Designing ofWCFbased Service, Data, Message and Service Contracts.
• Binding configuration.
• Design and development of building infrastructure service, Business layer, and Data access layer components, and unit testing frame work for the WCF web service using Visual Studio 2008, .Net framework 3.5 and C#..
• Designed User Interface Presentation layer for the web application to develop in Visual Studio 2010, VB.Net.
• Development of WS-Security header digests capabilities.
• Working with business analysts, project managers, and other developers to help design, develop technical design, specs, and coding as part of SDLC.
• Involved In end to end project deliverables in creating Design document, Functional document, Traceability Matrix and Release notes.
• Used 3 - tier architecture (data access layer, business layer, and presentation layer) to develop the application.
• Designed and developed UI using ASP. NET, Infragistic controls, CSS, JQuery.
• Implemented client side functionality using JQuery.
• Incorporated business logic in C#.NET and handled transactions from and to database using ADO.NET.
• Implemented ADO.NET objects like Command, Data Adapter, Dataset, and Data Reader for database connection.
• Used .NET Framework Class Libraries containing the business logic for each module to provide desired functionalities to make presentation layer more interactive and flexible.
• Involved in Performance tuning of SQL.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various business rules.
• Used Bulk Collect feature to improve performance.
• Leading of 7 member development team.
• Preparing weekly status report to Project Managers, Monthly report to stake holders.

Environment: IIS 6.0, .Net Framework 4.0/3.5, Visual Studio 2008/2010, ASP.Net 2.0, 3.5, VB.Net, C#, web form. Oracle 10g, WCF, SOA, SOAP, SoapUI 4.5, Ajax, Javascript/jQuery, HTML, CSS, iBatis, Infragistics controls, log4Net, VSS, TFS, MS Project, Windows Server 2003.

Technical Lead

Confidential, Winston Salem, NC

Responsibilities:

• Analysis of requirement
• Designed and developed Multi-tire Winforms and ASP.NET applications using VB.NET, C#, Infragistic controls.
• Designed and developed Web services using Service Oriented Architecture.
• Developed Stored Procedures/Designed DTS packages in SQL Server.
• Move the changes to the production by various Dev, stage and Production.
• Unit Testing & Business User Acceptance testing support.
• Production Support activities.
• Designed and developed Client server and web application deployment tool.
• As a Technical Lead was responsible for interaction with business users and writing technical design document and in designing and documentation of application flows.
• Lead of 10 member team for development and support activities.

Environment: IIS 6.0, ASP.NET, VB.NET, ADO.NET, SQL SERVER, Web Form, Win Form, XML, Microsoft Visual Studio .NET, .NET 3.5, SOA, Web Services, Java script, HTML, CSS, Infragistics controls, XSLT, Windows 2000, Windows XP, Visual Basic, ASP, SQL server, Serena Dimensions, HP ALM.

Module Leader

Confidential

Responsibilities:

• Requirement analysis, Design and estimation.
• Define the Business Components, Utilities, Exception Handling and Data Layer.
• Developed stored procedures and complex packages extensively using PL/SQL
• Involved in DB design, performance tuning, table partition and query optimization.
• Involved in Database up gradation from SQL server 2000 to 2005.
• Documented all PL/SQL procedures and user guide for different processes followed.
• Created the Excel Macros to generate Reinsurance Renewal report, Claim summary report, Monthly Status Report,Cancellation report, usingVB6 & Excel VBA.
• Reviewed HLD, LLD and code.
• Project Resource Planning and work allocation.
• Involved in Project proposal activities.
• Lead 7 Members team.

Environment: VB6.0, VBA, Oracle 9i, PL/SQL, SQL Server 2005/2000, DTS, MS Visio, MS Visual SourceSafe

Technical Consultant

Confidential

Responsibilities:

• Implementation of DTS package for Data Migration between Panels.
• Generated Spread sheet reports using DTS package.
• SQL-Server support for ADT Panels and TCP/IP Support for Panel Communication.

Environment: VB 6.0, MS Access, SQL Server 2000, DTS, Clear Case

Software Engineer

Confidential

Responsibilities:

• Requirement Understanding from the client
• Analysis and design.
• Writing Stored Procedures in SQL Server.
• Business Logics in VB and Presentation Layer in the ASP/HTML.
• Documentation, Code Review and Test case execution.
• Performance Improvement in stored procedures across application.

Environment: SQL Server 2000, ADO, Crystal Reports, ASP, ActiveX, IIS, VB 6.0, MS Visual SourceSafe

Software Engineer

Confidential

Responsibilities:

• Coding and Unit Testing
• Defect Fixing

Environment: MS Access, VB 6.0, ActiveX, MS Visual SourceSafe