SUMMARY:

• Confidential is a hands on Technical leader with experience in .NET Framework 2.0/3.5/4.0/4.5 and technologies such as C# .NET, ASP.NET, MVC4, XML, HTML, VB and Java Scripting. Expertise in using ADO.NET objects as well as Entity Framework.
• Over 12 years of experience in Analysis, Design, Development, Unit & System testing, Leading and Management of various commercial applications with involvement in all stages of Software Development Life Cycle (SDLC).
• Has 6 years of solid experience in Leading/Managing Offshore and Onshore projects and resources. Managed overall 40 Offshore resources & 15 Onshore resources.
• Experience in enterprise level application design with multi - threading (background workers, background data caching) and memory management under Windows OS.
• Expert in MS SQL Server 2000/2005/2008 R2 with Business Intelligence (Reporting Services, Analysis & Integration Services).
• Experience working with various databases like MS Access, Sybase 9.1, Oracle 10g and MS-SQL Server 2000/2005/2008 R2.
• Worked extensively on Entity Framework and LINQ.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions and Views.
• Having Strong knowledge on System Testing, Integration testing and used HP QTP & QC tool.
• Experience in both development and 24/7 Production Support environments.
• MCTS, Function Point Champion and appearing in PMP.

TECHNICAL SKILLS

Databases: SQL Server 7.0/2000/2005/2008 R2, Sybase 9.1, Oracle 10g.

Business Intelligence: MS SQL Server 2000/2005, SSAS (Analysis Services), SSIS (Integration Services), DTS, SSRS(Reporting Services).

Web Technologies: ASP.NET 2.0, 3.5 & 4.0 WCF, WPF, Smart Client, ASP, JavaScript, VBScript, HTML, XML, Entity Framework, LINQ, MVC 4.

Languages: C# and JAVA.

Tools & Utilities: Visual Source Safe, Team Foundation Server, Nunit, FXCop, CruiseControl, TortoiseSVN, OpenProj, Rational Clear Case and Clear Quest, TIDAL ES, SQL Developer, SQL Advantage, Microsoft Visio 2010, MS Project 2010, Visual Studio 2005/2008 and MS Office 2010.

GUI: Adobe Photoshop 7.0 & CS, Illustrator 8.0, Director 8.0, Dreamweaver MX, MS FrontPage.Operating Systems: DOS, Windows NT/98/2000/XP/2003/Vista/7/08/2008 and Linux.

PROFESSIONAL EXPERIENCE

Confidential,

Sr. Consultant/Lead Developer

Responsibilities:

• A Senior consultant responsible for Leading (managing offshore and onshore developers), development, support and delivery, reporting to Business Lead
• Leading a team of 7 offshore developers.
• Conducting the daily stand-up and technical design meetings.
• Identifying technical and operational challenges to avoid delay in deliverables.
• Involved in all the phases of the project’s life cycle Requirements gathering, Designing phase, Implementation and Unit Testing, IST and UAT.
• Used ASP.Net MVC 4 to create payment module to create payment manifest and payment XML to send to their centralized payment processing system.
• Worked on UI and business logic layer for their Core, Nutrition and EPS systems to process and manage complex data management and fund allocation.
• Worked on Admin modules to improve the more than 700 Districts Annual budgeting and Claim settlement modules.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Writing ComplexT-SQLQueries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Performeddata conversionfrom flat file into a normalized database structure.
• Worked extensively on Entity framework and LINQ.

Environment: ASP.NET MVC 4, JQuery, Razor, SQL Server 2008 R2, SSIS, SSRS, C#,, Visual Studio.NET 2013, Visual Studio Online (formerly Team Foundation Service- TFS) 2013, O/S: Windows 7 & 2008 Server etc.

Confidential

Technical Lead

Responsibilities:

• Technical Lead & Hands on, managing a team of 5-7 resources both onshore and offshore in all aspects of design, development, production support and delivery.
• Responsible for Project planning for different phases of the application, Development, Production Support & Project status reporting
• Identifying technical and operational challenges to avoid delay in deliverables.
• Involved in all the phases of the project’s life cycle Requirements gathering, Designing phase, Implementation and unit Testing.
• Actively participated in interaction with users, DBA and technical manager to fully understand the requirements of the system.
• Developed web application for reporting portal using .NET, ASP.NET, C#, TFS.
• Developed SSIS package for source to staging and/or staging to DW data mappings.
• Used Multi-threading while generating forecasting cost analysis to handle real time changes.
• Integrated running SSIS packages in C#. NET.
• Designed and Developed WinForms to Ad-hoc SQL Query builder for on-demand reporting.
• Writing queries to createstored procedures, User Defined Functions, Views and Triggers.
• Used SQL ServerConstraints(Primary Keys, Foreign Keys, Defaults, Check and Unique).
• Writing ComplexT-SQLQueries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Performance tuningof Stored Procedures and T-SQL Queries.
• Integrated running SSIS packages in C#. NET.

Environment: SQL Server 2008, SSIS, SSRS, C#, ASP.NET, .NET Framework 3.5, Visual Studio.NET 2008, O/S: Windows 2008 Server, Linux, Lotus Notes etc.

Confidential

Technical Lead

Responsibilities:

• Technical lead/Hands-on, managing a team of 10-15 resources both onshore and offshore in all aspects of Project planning for different phases, Development, Production Support & Project status reporting.
• Identifying technical and operational challenges to avoid delay in deliverables.
• Contributed in architecture design in areas like use case view, logical view, process view and deployment view.
• Involved in all the phases of the project’s life cycle Requirements gathering, Designing phase, Implementation and unit Testing.
• Developed the application for Trade processing in INTACT (ADP) using C# .Net and SQL Server and SSIS.
• Developed web application for reporting portal using .NET, ASP.NET, C#, TFS
• Wrote complexT-SQLQueries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Performance tuningof Stored Procedures and T-SQL Queries.
• Created SSRS financial reports using Report Parameters,Drop-DownParameters, Multi-Valued Parameters and Charts.
• Developed windows services for Trade extract from heterogeneous sources.
• Scheduled Jobs using Cisco TIDAL.
• Developed assemblies to extend SSRS & SSIS features using CLR.
• Developed SSIS package for source to staging and/or staging to DW data mappings
• Part of Production support team till zero critical defects.

Environment: SQL Server 2005, Sybase 9.1, Oracle 10g, SSIS, SSRS, C#, ASP.NET, .NET Framework 3.0 & 3.5, Rational Clear Case, Visual Studio.NET 2008, Netik integration studio, TFS, Clear Quest, Windows 2003 Server, Linux.

Confidential

Manager, DB & Code Review Team

Responsibilities:

• Managed a team of 40-45 resources.
• Onsite/Offshore status reporting to Client and communication point of contact.
• Involved in all the phases of the project’s life cycle Requirements gathering, Designing phase, Implementation and unit Testing.
• Managing the teams to do the following activities and involved in some of the technical activities.
• Part of the SQL and .NET Code optimization and performance enhancement team.
• Maintenance of various Database Scripts and Data Models for different deliveries.
• Design and coding the WinForms to do analysis on existing xml files.
• Monitoring and tracking difference and database changes between Development and Delivery environments.
• Developing web application for reporting portal using .NET, ASP.NET, C#, TFS.
• Developing and implemented appropriate exception handlers in C#. NET
• Maintaining of various Database Scripts and Models for different deliveries.
• Monitoring and tracking difference and changes between Development and Delivery environments.

Environment: ASP.NET, C#. NET, XML Web Services, .NET Framework 2.0, TFS, Visual Studio.NET 2005,Windows 2003 Server, SQL Server 2005, SSIS and SSRS.

Confidential

Sr. eCommerce Leader

Responsibilities:

• Client communication for requirement gathering and writing Technical Specs for customization requirements and brainstorming on technical designs.
• Developed different ecommerce portal features like 1. Recently viewed, 2. Multi-Store Order Management Desk, 3. Multi-Level Product/Service Catalog and 4. Integrated Shipping and Fulfillment manager panel and SQL reports (all sales based reports).
• In Advanced Customer Management, I was involved in activities like Powerful Tools for managing customer database, Update Customer Information (Bill To/ Ship To information), Place Orders for Customers via a Sales Desk, View Customer History across multiple stores.
• In ERP Integration, I was involved in activities like integration for Sales Order, Inventory (including item, price, and quantity), customers, customer addresses, invoices and payments with several ERP products including Microsoft Axapta, Microsoft Great Plains and Microsoft Solomon.
• In Real-Time Reporting(SSRS), I was involved creating reports like Sales by Item, Sales by Department, Sales by Section, Sales by Category, Sales by Payment Method, Top N Selling Items, Top Customers and Average, Median size of Order for each report.

Environment: SQL Server 2000, SQL Server Reporting Services, VSS, Java Script, XML, ASP.NET (C#).

Confidential

eCommerce Leader

Responsibilities:

• Client communication for requirement gathering and writing Technical Specs for customization requirements and brainstorming on technical designs.
• Developed different ecommerce portal features like 1. Integrated Shipping and Fulfillment, 2. Multi-Level Product/Service Catalog and 3. RMA & Returns Management.
• In Integrated Shipping and Fulfillment, I was involved in activities like Real-time Tracking Information for Customers, Automated Shipping Notification to Customers, Support for Fedex, UPS, DHL and United States Postal Service, Auto-Packaging Functionality (Best Box Selector), Support for Drop Ship Orders
• In RMA & Returns Management, I was involved in activities like Setup multiple Return Policies - Replace, Refund (Full, Partial), Returns Policy Editor, Automated RMA generation (Manual option available), Return Period Expiration tracking, Returns reporting, Return Life Cycle Management
• In Real-Time Reporting(SSRS), I was involved creating reports like Sales by Item, Sales by Department, Sales by Section, Sales by Category, Sales by Payment Method, Top N Selling Items, Top Customers and Average, Median size of Order for each report.

Environment: SQL Server 2000, SQL Server Reporting Services, VSS, Java Script, XML, ASP.NET (C#).

Confidential

Web Programmer

Responsibilities:

• Drawing ER diagram, writing stored procedure, Trigger and function. Class designs, sequence diagram, ISO related documents. SRS Documentation, Database Design review. Worked mainly on admin control panel and Payment gateway. Created a payment gateway for a different payment service provider. Worked on features like Processing receipts, in which gateway receives notification that a payment has been made, the gateway will need to load the associated order details and process the order. Developed a Control Base to provide properties including the transaction’s information such as billing address, shipping address and order details. And also worked on configuration fields for the Store Admin to fill out during the configuration of the app and a panel control for gateway-specific data entry fields to the customer during the checkout process, such as credit card information or account information.

Environment: SQL Server 2000, SQL Server Reporting Services, ASP, Java Script, XML, ASP.NET(C#).