PROFESSIONAL SUMMARY

• 8 Years of experience in analyzing, designing, development and maintenance of web, windows applications with good exposure to full Software Development Life Cycle SDLC
• Experience in developing Applications using Visual Studio 2010/2005/2003, .NET Framework 4.0/3.5/2.0, C , VB.NET, ASP.NET along with Telerik Controls
• Hands on experience in developing applications using WCF, ADO.NET, LINQ, XML, XSLT, JavaScript, JQuery, JSON, CSS, Visual Source Safe, SQL Server 2008/2005/2000, Windows Services and IIS
• Experience in using Microsoft Business Intelligence Development Studio BIDS for developing SQL Server Integration Services SSIS packages for data-management applications, Multidimensional cubes using SQL Server Analytical Services SSAS and also for creating reports using SQL Server Reporting Service SSRS
• Experience in developing Web Applications, Web services, Windows Services and Windows Applications using different Microsoft based technologies.
• Experience in designing tables and Normalization using SQL Server 2000/2005/2008
• Hands on experience in SQL Server Database Design and Development, Writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers, and User Defined Functions using T-SQL and PL/SQL
• Good knowledge in Performance tuning applications from front end and back end
• Experience in setting up Production environment for applications on Win 2003/2008/2008 R2 and in configuring, hosting web applications on IIS 6.0/7.0/7.5
• Experience in working as SCM coordinator and attended CMMI audits for different projects
• Experience in working various Commercial and General Insurance projects
• Strong experience in Leadership, Schedule Management, Client Interaction and understanding Business Application, Business Data Flow and Data Relations from them
• Strong verbal and written communication skills along with good Analytical and problem solving skills. Strengths include Quick learning, positive attitude, trustworthiness, Self-Motivation and hard work.

SKILLS / TECHNOLOGIES

WORK EXPERIENCE

Confidential

Business Intelligence Development

It is highly configurable system designed to handle the client customized insurance business portfolio. GENIUS runs on predefined business rule that streamline the business operations for a global insurance organization. Core GENIUS system comprises of separate subsystem like Underwriting, Claims and Accounts. Additional Sub systems Name Address, Diary, Enquiry, Reporting and statistics complement the core functionalities.

Confidential

• Production support and Maintenance activities.
• Maintenance of source code configuration
• Preparation of weekly status report to update the status of the project to the stake holders.
• Planning and Scheduling of development projects.
• Involves in Business requirement meetings with clients, requirements gathering and preparation of business requirement document.
• project is a suite of applications that include Underwriting Portal UWP and Claims Portal. UWP is a commercial property and casualty underwriter system that runs in Dot Net platform. UWP supports end to end policy life cycle for four Major Commercial P C products Commercial Auto Programs, Casualty Risk, Directors and Officers and Errors and Omissions E O . UWP interacts with GENIUS through GGI Interfaces. Genius interacts with multiple external interfaces, both Upstream Input Feeds and Downstream Output Extracts . There are Mainframe and other applications on both the upstream and downstream of Genius.
• Underwriting Portal is a web based Graphical User Interface which acts as a frontend for GENIUS database. This includes clearance, the recording of submission and quotation information, policy and premium registration, document processing and reinsurance. Underwriting Portal application covers the Underwriting and Rating, Policy Maintenance, Claims and Reinsurance. Claim Portal is used to register a new claim and maintain the details of existing claims. A Claim is a demand made by the insured, insured's beneficiary or a third party to cover the property, personal or business losses incurred by claimant. Through this portal, users will able to register a claim for a policy and they will have diary items where they will be able to check the items assigned to the particular user.
• Peer review of Analysis, Technical specification and unit test documents and code review to ensure the quality of deliverables.
• Coordination between client and offshore team from requirement phase to Analysis, design and development phases.
• Provides supports for System testing, User acceptance testing and initial production checkouts.
• Deployment of development and enhancements in Test and Production environment.
• Knowledge sharing sessions and guided the team in providing optimal solutions for the customer

Environment: Microsoft .NET Framework 4.0, AS400, Microsoft Visual Studio 2010, TFS, IIS 7.0, Windows Server 2008

Confidential

Description

Confidential is a tracking system to track the activities of a transaction under each policy and supports Worker compensation business. Generates reports for users with the list of policies and transactions mapped under each policy. Key purpose of the application is to track the activities logged by each user under a policy and support Workers compensation Business.

Responsibilities

• Designed and Implemented Rich Input screens using Telerik and .Net 4.0, C , Visual Studio 2010, HMTL Helpers and templates and automated unit testing of Presentation logic in Controllers
• Up gradation of Enterprise Library to 5.0 from 1.0 and implemented the same for logging and caching
• Implemented User Interface logic and validations using JQuery, JavaScript, Knockout and HTML controls
• Involved in consuming WCF services in Controllers and passing the View Models to views
• Developed WCF Services using WCF API and IIS and unit tested with MS Unit Testing Framework
• Developed Data Access Library using Entity Framework and LINQ based on the Repository design pattern
• Part of Migrating SQL Server 2005 to SQL Server 2008 and created additional tables , views, stored procedures and functions
• Researched and developed POC for utilizing Microsoft BI Features for Ad-hoc reporting with Power Pivot, SSAS, SharePoint 2010 and Office 2010

Environment: Microsoft .NET Framework 4.0, WebAPI, ASP.NET MVC4, MS SQL Server 2008, Office 2010, Microsoft Visual Studio 2010, TFS, IIS 7.0, Windows Server 2008

Description: The package is used to load the construction and Ace group data available in the server to the database available in US server. Generates reports according to the Business needs. Loads the data parallel for both the process in chunks and truncates particular chunk. Upon failure in the execution, the data transactions are rolled back and original database structure is restored from the snapshot DB created at the beginning at the start of execution

Responsibilities

• Involved in the entire life cycle of the project including requirement gathering, Analysis, Design, Coding and Testing pages
• Responsible for the design of the package in SQL Server Integration services 2008 using Business Intelligence Development Studio
• Designed the recovery process of data from the packages using Snapshot creation
• Designed tasks for creation of snapshot and recovery of data from the snapshot DB
• Redesigned packages for better error handling and improved maintainability
• Tested the packages from end to end in Development, Test and acceptance region
• Implemented stored procedures, functions, triggers, SQL jobs for the reporting capabilities from front end
• Deployed packages in Test, Acceptance and Production environment

Environment: MS SQL Server 2008, SQL Server Integration services 2008

Confidential

Description: The purpose of the interface is to send the completed audit files for a policy from FASTPAT to Apollo where the audited information are maintained with the unique MD5Chesk Sum code through FTP. The package processes the acknowledgement from Apollo, process the codes in Confidential and process files according to the type of codes received in the acknowledgement file.

Responsibilities

• Involved in the entire life cycle of the project including requirement gathering, Analysis, Design, Coding and Testing pages
• Designed SQL Service Integration Packages SSIS 2008 for upload process, download process and Reporting process using Business Intelligence Development Studio BIDS
• Designed tasks in SSIS for interaction with FTP and web service
• Included Error handling for improved maintainability and scalability
• Deployed the packages in TEST and acceptance region
• Supported deployment in Production region
• Designed Database with Normalization and created objects such as tables, views, Stored Procedures, functions using SQL Server 2008

Environment: Microsoft .NET Framework 4.0, Microsoft Visual Studio 2008, SSIS, SQL Server 2008

Confidential

Description

Confidential application is an actuarial system to help underwriters for underwriting rules for involving Confidential in an insurance contract for workers compensation. Before the application has built up in the production there was more manual and email communication between the users of the business. Currently, ARMCAT helps users to get the actuarial data from the application itself based upon some predefined formulae implemented in the Excel Template with the help of VBA code and Excel Assemblies.

Responsibilities

• Worked on Requirements gathering, coding and testing in WCCAT application - Backward Compatibility, a major enhancement in the application.
• Upgraded Microsoft MapPoint Geocoding service to Microsoft Bing Maps Services REST API which is the core of WCCAT business.
• Automated the manual activities of generating the reports using SSIS packages.
• Worked on Major upgrades of servers from SQL Server 2005 to 2008 for this application.

Environment: Visual Studio 2005, .NET Framework 2.0, ASP.NET Web Forms, Java script, IIS, C , SQL Server 2008, XML, ADO.NET, IIS 6.0, VSS

Confidential

Description

The application gathers the true actual exposure and reports the gathered information to Worker Compensation Bureau along with losses and historical premium. Mainly deals with audit assignment to internal and external Third party vendors manage audit and reports back the audited information to Bureau.

Responsibilities

• Involved in the entire life cycle of the project including Requirements gathering, Analysis, design, coding and testing phases
• Responsible for re -structuring the batch process windows service according to the Business needs
• Implemented stored procedures, functions, triggers, SQL jobs for the reporting capabilities from front end
• Developed SQL Server Reporting services SSRS for generating reports according to the Business need using Business Intelligence Development Studio BIDS
• Automated manual monitoring of the batch process using Web application
• Deployed application on Production and Testing servers on Windows server 2008/IIS6

Environment: Microsoft .NET Framework 2.0,Visual Studio 2005, IIS 6.0, C , XML, Microsoft Visual SourceSafe, WINDOWS Server 2003, XSLT, HTML, CSS, SSRS, Abstract design pattern, MVC, layered architecture

Confidential are tracking systems to track the activities of a transaction under each policy and supports 2 different user groups of Worker compensation business. Generates reports for users with the list of policies and transactions mapped under each policy. Key purpose of the application is to track the activities logged by each user under a policy and support Workers compensation Business

Responsibilities

• New requirement gathering from the Business Clients and involved in the development of new enhancements
• Unit testing of new enhancements in development, Test and Acceptance region
• Involved in defect fixing in Production environment
• Re structured the base logic of the entire application according to the Business needs
• Creating MSI packages for deploying the application changes into Production environment
• Migrated the excel components available in application from 2003 to 2010
• Developed SQL service Integration services SSIS for generating reports and mailing the same to users using Business Intelligence Development Studio BIDS

Environment: Visual studio 2003, .NET framework 1.1, ASP.NET web forms, JavaScript, C , Sql server 2005, VSS, ADO.NET, Enterprise Library 1

Confidential

Description

It is a common platform for reporting all types of market research projects within a single tool. The platform's functionality is well suited to customer surveys and brand studies, as well as internal project follow-up and employee surveys. Manager is a very strong reporting tool that provides the user option of creating templates for reporting, and also provides them with a wide range of visualization reporting options.The result of the survey is presented through charts, and the results can also be viewed in Excel and PowerPoint's. The results can be drilled down to make in-depth analysis and there are several types of charts provided for the user's efficient decision making. Manager helps to gain control and increase motivation within an organization, while it also dramatically reduces the total cost of internal and external surveys.

Responsibilities

• Involved in Requirement Analysis and DB Design
• Extensive Prototype Design along with coding
• Unit testing of new enhancements in development, Test and Acceptance region
• Involved in defect fixes

Environment: Visual Studio 2005, .Net framework 2.0, C , SQL Server 2005, Dundas Charting, Dot Net Charting, Infragistics