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 the 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 the 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 the 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 the Insurance Domain and delivered complete solutions having worked on CMMi3, CMMi5 processes.
• Worked on Component Object Model (COM), Distributed COM (DCOM) technology.
• Experience leading the team and responsible for the end-to-end delivery.
• Strengths being flexible with the environments besides excellent communication skills including team/work delegation, team development and the 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

Sr. .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 the design
• Work with business analysts to get the design sign off and provide inputs to the development team
• Worked on developing the Payer portal for Payers to administer and manage the incentive programs
• Developed WCF services and exposed to the other applications for consuming the services
• Responsible for developing the payer module using Agile Development Methodology
• Responsible for defining the scope of the release and delivering the release with the approved scope.
• Developed SSIS packages that extract, transform and Load the 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 the development process to minimize the 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 the application performance to meet the SLAs for peak usages
• Used Nunit for the unit testing
• Implemented Team Foundation Server TFS as part of version control.
• Responsible for providing the weekly status report on the 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 the ARCAR Solution using Rational Rose.
• Participated in requirement gathering sessions with the client and preparation/modifying of the 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 the data from various data sources using SQL Server Integration Services(SSIS)
• Developed WEBI Reports using Business Objects XI R2.
• Involved in Designing and Maintaining the Business Objects Enterprise (BOE) Universe.
• Used SAP XCELSIUSto create dashboards for the 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 the specifications of the clients.
• Created collaboration portal using Microsoft Office Share point Server (MOSS) for Managing Issues, Risks, Events, Announcements and WIKIs.
• Developed web-parts to meet the business requirements and deployed those using Application Pages.
• Used ADO.Net to have the 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 the work performed.
• Used Team Foundation server (TFS) as Version Control and for Configuration Management.
• Used Mercury Quality Center for the 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 the Burden Data, to simulate the Production scenario 1, 2 years in future.
• Developed C# tools to automate report generation in TPT COE.
• Analyze the Load Runner Reports under various loads for various Key Business Transactions and identify the Transactions which are breaching the SLAs. Diagnose the transactions, identifying the potential bottlenecks using the Framework Logging & Diagnostic & Event Processing Mechanisms.
• Propose a solution (Change of Design/Code) for the defects and ensure all the transactions meet SLAs.
• Propose & analyze various design changes to mitigate the foreseen risks in production. Series of tests conducted to include possible design changes to determine the optimal configuration for addressing the issues.
• Analyze the Oracle AWR Reports (Work Load Reports) and identify the long running and Resource consuming SQL queries and SQL activities under various load scenarios.
• Analyze the Oracle Trace Analysis reports (using Oracle 10gTraceAnalyzer), to identify the heavy SQL blocks/stmts for each page to optimize the database interaction for each page.
• Analyze the performance/response time of the NextGen Application Reports, in specific the Financial Reports which fetch the data from Mainframe and Oracle.
• Diagnose the defects, which address communication to various integration points accessed via TIBCO middleware. Perform the Root Cause Analysis of the issues and propose a possible solution.
• Code Profiling & Analysis is done using DevPartner tool for implementing the best practices.
• Debug various XML WebServices for the dataflow between NextGen, Mainframe systems & External systems.
• Performed various Proof of Concept to analyze the performance and scalability issues implementing new technologies like AJAX, WCF in the NextGen Application.
• Performed capacity planning and project planning for the entire project and acted as a Interim-project Manager for the project.
• Responsible for the delivery of the project with in the 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 the project.
• Worked on Requirement analysis, gathered all possible requirements from the client and involved in breaking the 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 the MVC Architecture
• Extensively used Data-binding, Event Handling features in ASP.Net to connect the Presentation Layer and the Business Layer.
• Use of Typed Datasets using XML Schema Definition (.XSD) to represent the various entities in the system.
• Involved in Data Modeling, system data analysis, design and optimizing various stored procedures using ERWIN, Visio, AWR Reports and Trace Analyzer
• Implemented the SOA architecture to share the data among the Confidential NA Applications using Webservices
• Developed the logging mechanism, Exception Handling in the application to log the various events/exceptions in the application, which are used for the analysis.
• Developed various Custom controls extending Data grid.
• Responsible for the Quality and Delivery of the Service Requests
• Ensure the Service Requests Closeouts and Pass the Quality Audits
• Preparing the Unit Test Cases & Executing and logging them into the Elementool.
• Involved in Studying the Database Performance using VERITAS tool and proposed various suggestions for the performance improvements
• Configuration Management using VSS
• Design & Development of Stored Procedures in PL/SQL
• Analyze and Review the Defects and prepare the 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 the 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 the data from SQL Server Analysis Cubes using Microsoft Office Web Components.
• Implemented various design patterns such as Abstract, Factory.
• Complete adherence to the MVC and SOA Architectures
• Implemented Role-based Security Model of the ASP.Net
• Design & Development of Stored Procedures and Scripts in SQL Server 2000
• Preparing the Unit Test Cases & Executing and logging them into the Elementool.
• Analyze and Review the Defects
• Design & Development of Stored Procedures and Scripts in SQL Server 2000 for the Surety Migration.
• Managing and Monitoring various SQL Jobs and DTS packages
• Configuration Management using VSS
• Ensure the Service Requests Closeouts and Pass the Quality Audits
• Involved in resolving the UAT and Production Issues.
• Responsible for providing the 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 the existing functionality, analyzing the new requirements and preparing the Technical Design Document.
• Design & Development of stored procedures, SQL Jobs, Replications.
• Responsible for preparing the installation scripts, Unit Test Cases and other deliverables
• Involved in tuning the performance of SPs, Managing Indexes.
• Configuration management using VSS
• Exercising Code Reviews and Code Walk Through
• Responsible for setting up the 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 the Database Connection and Common functionality
• Designed and Developed the User Interfaces Using Visual Basic
• Involved in writing the Stored procedures
• Involved in the Design and Development of Reports
• Reviewing bugs and fixing the 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 the User Interface Screens
• Involved in Design and development of Data Reports
• Involved in Reviewing bugs and fixing the bugs

Environment: Visual Basic 6.0, SQL Server, Crystal Reports