SUMMARY

• Having 7 Years 8 Months of professional IT Experience in Design, Development, Testing and Implementation of Client/Server and Web - based n-tier Architecture Systems using Microsoft Technologies.
• Hands on experience of developing applications using in Microsoft.NET 4.5/4.0, C#, ASP.NET MVC, SQL Server 2012/2008, IIS 7.5, Oracle 11g, SharePoint 2007/2010.
• Experience developing Applications for Health Care, Insurance, Banking and Financial domains.
• Experience in developing distributed applications using Remoting, Webservices, SOAP, and XML.
• Experience in developing and implementing applications using Object Oriented Programming and OOAD.
• Expertise in writing Stored Procedures and Database Triggers, SQL Jobs, Replication and DTS packages, SSIS Packages in SQL Server.
• Extensively worked on Troubleshooting teh Application, Infrastructure and Databases in a Multi-Tier Application.
• Performance tuning using SQL Profiler, Query Optimization, Analyzing performance impact of developer's SQL statements and by creating indexes.
• Experience using teh Modeling tools Rational Rose and Erwin, Visio.
• Expertise using .NET features like WCF (Windows Communication Foundation) and WWF (Windows Workflow Foundation).
• Experience developing and implementing Portals and Collaboration sites using Microsoft Office SharePoint Server (MOSS) 2007/2010.
• Created web-parts, site templates, site definitions, and implemented various MOSS features like Business Data Catalog (BDC) and Excel Services.
• Worked on .NET security features such as Authentication (Windows-based Authentication and Forms-based Authentication) and Authorization (Role-based Authorization).
• Several Implementation experience of .Net technologies and features like Caching, State Management, User controls, Custom Controls and WebServices.
• Implemented secured applications using Secure Socket Layer (SSL) communication (Digital Certificates)
• Hands on Experience using Sql Server Integration (SSIS) for performing various Extract, Transform and Load (ETL) Jobs.
• Worked extensively on SQL Server Reporting Services (SSRS) and Crystal Reports, Business Objects XI R2 for developing reporting infrastructure.
• Worked with SAP XCELSIUSfor Developing Dashboard for Executive Users.
• Implemented Web-Gardening, Session Server Partitioning features of .net to support Scalability of teh Application.
• Experience using various performance tools like ACT, VERITAS, Load Runner 9.0
• Configuration Management using VSS, Team Foundation Server(TFS) and Incident Management using ManageNow
• Experience in working in teh Insurance Domain and delivered complete solutions having worked on CMMi3, CMMi5 processes.
• Worked on Component Object Model (COM), Distributed COM (DCOM) technology.
• Experience leading teh team and responsible for teh end-to-end delivery.
• Strengths being flexible with teh environments besides excellent communication skills including team/work delegation, team development and teh ability to deliver quality product as it Interaction with Clients and ability to handle teams.

TECHNICAL SKILLS

Languages: C#, Java 2.0, VB.NET, HTML, PL/SQL, Java Script, VB Script

Web Technologies: Win forms, Asp.Net MVC, XML, XSL, WCF, LINQ, Entity Framework, ADO.NET, WCF, WWF, SOAP, COM

RDBMS: DB2, Oracle 11g, MS SQL Server 2012/2008

Operating Systems: Windows Server 2008, Linux

Web Servers: IIS 7.5, WebSphere 7.0.

Tools: Visual Studio, TOAD, SQL developer, Telerik Tools, Rational Clear Case

Configuration Mgmt: Visual Source Safe(VSS), Team Foundation Server (TFS), Subversion, GIT

Portals: SharePoint server 2003, Microsoft Office Share Point server 2007(MOSS).

Reporting: SQL Server 2008 Reporting services, SSIS, Crystal Reports, Business Objects XI R2

Software Methodologies: Agile Unified Process, Scrum (development), OOAD

ETL: SSIS, Informatica 7.1, SQL Loader

Middleware: TIBCO, MSMQ

Performance Tools: ACT, VERITAS, Load Runner 9.0/9.1

GIS Tools: Map Objects 2.1, Net Engine 1.2

Modeling Tools: Rational Rose, ERWIN, Visio 2003/2007

Others: Office Products, MS Project Plan

PROFESSIONAL EXPERIENCE

Confidential, IL

Senior .Net Developer

Responsibilities:

• Responsible for collecting requirements from Product Management and translating them into technical requirements
• Work with architects & code design team to propose design and review teh design
• Work with business analysts to get teh design sign off and provide inputs to teh development team
• Worked on developing teh Payer portal for Payers to administer and manage teh incentive programs
• Developed WCF services and exposed to teh other applications for consuming teh services
• Responsible for developing teh payer module using Agile Development Methodology
• Responsible for defining teh scope of teh release and delivering teh release with teh approved scope.
• Developed SSIS packages that extract, transform and Load teh Achievement records from Vendors into VBB Database in SQL Server 2008
• Worked extensively on SQL Server 2008 to develop stored procedures, triggers and SSIS jobs
• Followed test driver development strategy during teh development process to minimize teh post development bugs
• Implemented wrapper components in C# that integrates with downstream existing systems.
• Worked on integrating with systems that use Sybase 9.0, Oracle 11g
• Developed user controls to provide reusability
• Worked on troubleshooting and improving teh application performance to meet teh SLAs for peak usages
• Used Nunit for teh unit testing
• Implemented Team Foundation Server TFS as part of version control.
• Responsible for providing teh weekly status report on teh project progress, defect progress and scope changes.

Environment: .NET 4.5, Winforms,C#.Net, .NET 3.5,Visual Studio 2013, Entity Framework 5.0, XML, XSL, WCF, SQL Server 2008, Oracle 11g, SSIS, IS 7.0, W2K8, TFS, MSMQ, Load Runner 9.0, Quality Center, Erwin.

Confidential, IL

Sr. .Net Developer

Responsibilities:

• Produced UML models for architecture and design of teh ARCAR Solution using Rational Rose.
• Participated in requirement gathering sessions with teh client and preparation/modifying of teh requirements in Requirement Specification document.
• Created Class diagrams, Use Case diagrams, Activity Flow diagrams and Object Interaction diagrams using UML.
• Developed GUI Interface using Win forms, C#.Net, Entity Framework and WCF
• Created various Extract, Transform, Load (ETL ) Packages to load teh data from various data sources using SQL Server Integration Services(SSIS)
• Developed WEBI Reports using Business Objects XI R2.
• Involved in Designing and Maintaining teh Business Objects Enterprise (BOE) Universe.
• Used SAP XCELSIUSto create dashboards for teh Executives and Business users.
• Created Custom Validation controls and also implemented AJAX functionality to improve responsiveness.
• Adopted Service Oriented Architecture (SOA) to serve various applications.
• Developed, Implemented and consumed Web Services to gather information from various external business sources.
• Involved in project migration, deployment, creating of MSI’s and packages according to teh specifications of teh clients.
• Created collaboration portal using Microsoft Office Share point Server (MOSS) for Managing Issues, Risks, Events, Announcements and WIKIs.
• Developed web-parts to meet teh business requirements and deployed those using Application Pages.
• Used ADO.Net to have teh access from database and wrote stored procedures, Complex stored Procedures, Triggers and Cursors in SQL Server 2005.
• Used Data Access Application Blocks for having a single point of interception for data access monitoring and testing.
• Created Logical Database Model using ERWIN and generated DDL Scripts for MS SQL Server.
• Developed data access components and business logic components using C#.
• Used Agile methodology named SCRUM for all teh work performed.
• Used Team Foundation server (TFS) as Version Control and for Configuration Management.
• Used Mercury Quality Center for teh Defect Management.

Environment: Win forms, C#.Net, .NET 4.0,TIBCO,Visual Studio .NET 2010, Entity Framework, XML, XSL, WCF, SQL Server 2008, SSIS, Business Object XI R2, XCELSIUS,IIS 6.0, W2K8, TFS, MSMQ, Load Runner 9.0, Quality Center, Erwin, Rational Rose.

Confidential, IL

Sr. .Net Developer

Responsibilities:

• Developed Scripts (PL/SQL) and C# tools to build teh Burden Data, to simulate teh Production scenario 1, 2 years in future.
• Developed C# tools to automate report generation in TPT COE.
• Analyze teh Load Runner Reports under various loads for various Key Business Transactions and identify teh Transactions which are breaching teh SLAs. Diagnose teh transactions, identifying teh potential bottlenecks using teh Framework Logging & Diagnostic & Event Processing Mechanisms.
• Propose a solution (Change of Design/Code) for teh defects and ensure all teh transactions meet SLAs.
• Propose & analyze various design changes to mitigate teh foreseen risks in production. Series of tests conducted to include possible design changes to determine teh optimal configuration for addressing teh issues.
• Analyze teh Oracle AWR Reports (Work Load Reports) and identify teh long running and Resource consuming SQL queries and SQL activities under various load scenarios.
• Analyze teh Oracle Trace Analysis reports (using Oracle 10gTraceAnalyzer), to identify teh heavy SQL blocks/stmts for each page to optimize teh database interaction for each page.
• Analyze teh performance/response time of teh NextGen Application Reports, in specific teh Financial Reports which fetch teh data from Mainframe and Oracle.
• Diagnose teh defects, which address communication to various integration points accessed via TIBCO middleware. Perform teh Root Cause Analysis of teh issues and propose a possible solution.
• Code Profiling & Analysis is done using DevPartner tool for implementing teh best practices.
• Debug various XML WebServices for teh dataflow between NextGen, Mainframe systems & External systems.
• Performed various Proof of Concept to analyze teh performance and scalability issues implementing new technologies like AJAX, WCF in teh NextGen Application.
• Performed capacity planning and project planning for teh entire project and acted as a Interim-project Manager for teh project.
• Responsible for teh delivery of teh project with in teh estimated duration.
• Project Management with MS Project 2010.

Environment: ASP .NET, VB.Net, .NET 2.0/3.0,TIBCO,Visual Studio .NET 2005, ADO .NET, XML, XSL, Web Services, Oracle 10g, IIS 5.0/6.0, Win2K,VSS,MSMQ, Load Runner 9.0, Test Director, DevPartner, Erwin, MS Project 2010

Confidential, IL

Programmer Analyst

Responsibilities:

• As a Programmer Analyst involved in All Phases of teh project.
• Worked on Requirement analysis, gathered all possible requirements from teh client and involved in breaking teh requirements in to exact implementation details
• Developed Business layer, Rules layer components using C#.Net and Data Access layer(DAL) using ADO.Net and Presentation Layer using ASP.Net, following teh MVC Architecture
• Extensively used Data-binding, Event Handling features in ASP.Net to connect teh Presentation Layer and teh Business Layer.
• Use of Typed Datasets using XML Schema Definition (.XSD) to represent teh various entities in teh system.
• Involved in Data Modeling, system data analysis, design and optimizing various stored procedures using ERWIN, Visio, AWR Reports and Trace Analyzer
• Implemented teh SOA architecture to share teh data among teh Confidential NA Applications using Webservices
• Developed teh logging mechanism, Exception Handling in teh application to log teh various events/exceptions in teh application, which are used for teh analysis.
• Developed various Custom controls extending Data grid.
• Responsible for teh Quality and Delivery of teh Service Requests
• Ensure teh Service Requests Closeouts and Pass teh Quality Audits
• Preparing teh Unit Test Cases & Executing and logging them into teh Elementool.
• Involved in Studying teh Database Performance using VERITAS tool and proposed various suggestions for teh performance improvements
• Configuration Management using VSS
• Design & Development of Stored Procedures in PL/SQL
• Analyze and Review teh Defects and prepare teh Root Cause Analysis (RCA).
• Providing estimates, efforts, Status Reports etc.

Environment: C#, ASP .NET, .NET 1.1, Visual Studio .NET 2003, ADO .NET, XML, XSL, Web Services, Visio 2003, Oracle 9i, IIS 5.0 Win2K Elementool, VSS, Erwin, Veritas

Confidential, IL

Programmer Analyst

Responsibilities:

• Development of teh web pages using ASP.Net, C#.Net.
• Implemented Template pages, user controls, custom controls using features provided by .Net framework.
• Implemented .NET reporting Services using Crystal Reports.
• Developed Cube Reports to extract and present teh data from SQL Server Analysis Cubes using Microsoft Office Web Components.
• Implemented various design patterns such as Abstract, Factory.
• Complete adherence to teh MVC and SOA Architectures
• Implemented Role-based Security Model of teh ASP.Net
• Design & Development of Stored Procedures and Scripts in SQL Server 2000
• Preparing teh Unit Test Cases & Executing and logging them into teh Elementool.
• Analyze and Review teh Defects
• Design & Development of Stored Procedures and Scripts in SQL Server 2000 for teh Surety Migration.
• Managing and Monitoring various SQL Jobs and DTS packages
• Configuration Management using VSS
• Ensure teh Service Requests Closeouts and Pass teh Quality Audits
• Involved in resolving teh UAT and Production Issues.
• Responsible for providing teh Production Support.

Environment: C#, ASP .NET, .NET 1.1, Visual Studio .NET 2003, ADO .NET, XML, XSL, Web Services, Visio 2003, SQL Server 2000, IIS 5.0 Win2K Elementool, VSS, Erwin, Veritas

Confidential, Redmond, WA

Programmer Analyst

Responsibilities:

• Responsible for Understand teh existing functionality, analyzing teh new requirements and preparing teh Technical Design Document.
• Design & Development of stored procedures, SQL Jobs, Replications.
• Responsible for preparing teh installation scripts, Unit Test Cases and other deliverables
• Involved in tuning teh performance of SPs, Managing Indexes.
• Configuration management using VSS
• Exercising Code Reviews and Code Walk Through
• Responsible for setting up teh development and Unit Test Environment

Environment: Sql Server2000, ASP.NET,C#, VC++, COM, IIS 6.0, Product Studio

Confidential

Software Engineer

Responsibilities:

• Developed COM Components in Visual Basic For teh Database Connection and Common functionality
• Designed and Developed teh User Interfaces Using Visual Basic
• Involved in writing teh Stored procedures
• Involved in teh Design and Development of Reports
• Reviewing bugs and fixing teh Bugs

Environment: VB 6.0, COM, Oracle 8.0, Crystal Reports 8.5, ESRI’S Map Objects v2.1, Net Engine 1.2

Confidential

Software Programmer

Responsibilities:

• Involved in gathering requirements from clients and Analysis.
• Involved in Designing teh User Interface Screens
• Involved in Design and development of Data Reports
• Involved in Reviewing bugs and fixing teh bugs

Environment: Visual Basic 6.0, SQL Server, Crystal Reports