Vinodh Kumar Sivaperumal
Sun Prairie, WI-53590
*******@*****.***
Ph: +1-608-***-****
Experience Summary:
* ***** ** ** ********** in design and development of windows based, web based and n-tier application.
Expertise in developing windows, web applications and web services(WCF) in Microsoft visual studio IDE using VB.Net C#.Net,XML,ADO.Net, Oracle and SQL Server
Proficient in detailed analysis and design, development, Unit test plan preparation and execution,trouble shooting and implementation
Extensive experience in Database maintenance, developing T-SQL Queries, Stored procedures,functions and triggers
Expert in debugging an application using the debugging tools provided by the visual studio IDE
Good knowledge of Microsoft Visual Source Safe(VSS) and Team foundation Server(TFS) versioning tools
Good understanding of SDLC and primarily worked in projects executing Waterfall and agile development model
Domain experience in Insurance and Retirement Line of Business
Excellent team player and also capable of working as an individual Certificates
Insurance Domain Certification : LOMA 280, LOMA 290
MS SQL Server 2008 Microsoft certification (MCP 70-433) Technical Skills:
Operating systems : windows 7/XP, Windows Server 2003, UNIX Programming Languages : VB 6.0, VB.Net, C#, T-SQL
Scripting Language : JavaScript, VBScript
XML Technology : XML, XSL, XSLT, XPath, SOAP, WSDL Databases : SQL Server 2000, 2005, 2008, Oracle 11g Development IDE : VisualStudio.NET 2005/2008/2010/2012/2013 Reporting Services : MS SSRS Reports
Design Tools : Microsoft Visio
Versioning Tool : Microsoft VSS, Team Foundation Server Domain Knowledge : Insurance, Retirement
Professional experience:
1. Point of Sale for Auto/Home Insurance Client: Hanover Insurance Mar 2009 – May 2010 Hanover insurance is a publicly traded insurance company providing insurance in United States of America. Point of Sale is an insurance application for providing auto and home insurance quotes and policies for customers. This project focused on enhancing the existing system by replacing the hardcoded rules with PEGA Rule Engine. Rules are configured in the PEGA rule engine for easier maintenance. These rules were called Knock out Rules and used to validate the applicant information. This project also provides a seam less integration of Data flow from the POS application with the external replacement cost valuation application called MSB. This enabled the applicant to be redirected to the external website and calculate the cost. Role : Developer
Responsibility : Coding
Testing and Test plan creation
QA & UAT Support
Software : VB6, Oracle, JavaScript and IIS
2. OGC DMS Phase 2 Client: CUNA Mutual Group May 2010 – Dec 2010 CUNA Mutual Group is a mutual insurance company that provides financial services to credit unions and its members. This tool is a replication tool between Documentum and Team Connect, which enables documents
& folders created in the Team Connect to be replicated in the enterprise level content management system
(Documentum). Documentum is an enterprise content management tool. Team Connect is an internal system which is used for document creation. Team Connect exports the document creation information as a XML file. Replication tool will parse these XML files and create the corresponding folders & files using the DFS
(Documentum foundation services).
Role : Developer
Responsibility : Coding
Testing and Test plan creation
QA & UAT Support
Software : VB.Net 3.5, DFS, XML
3. ToDO iPhone Application Client: Cognizant technology Solutions Dec 2010 – Jan 2011 This application was developed as a training assignment .This iPhone application enables the users to create and maintain a list of tasks. User can create a task, set remainders and mark the tasks as completed .This application was developed using Xcode framework and Objective C language. Role : Designer and Developer
Responsibility : Requirement analysis
High level design
Low level design
Coding
Testing and Test plan creation
Software : Objective C, Xcode framework
4. IVPA Client: CUNA Mutual Group Feb 2011 – March 2012 CUNA Mutual Group is a mutual insurance company that provides financial services to credit unions and its members. AdminServer is insurance policy administration software owned by Oracle. IVPA is an insurance policy administration system which supports CUNA mutual group’s collateral protection product. IVPA is configured using AdminServer. This system is also used for Credit Union protection web application content management system using MOSS 2007 and SQL Server 2008. Various enhancements & maintenance activities are done in the IVPA application.
Role : Developer
Responsibility : Requirement analysis
Coding
Report creation
Testing and Test plan creation
QA support
Software : AdminServer, XML and SQL
5. Sales renewal notification Client: CUNA Mutual Group March 2012 – Apr 2012 CUNA Mutual Group is a mutual insurance company that provides financial services to credit unions and its members. Sales renewal notification application sends notification emails to sales representatives. This is a service which picks up the policies ready for renewal and sent notifications to the respective sales representatives before 2 months for renewal.
Role : Developer
Responsibility : Requirement analysis
Low level design
Coding
Testing and Test plan creation
QA & UAT Support
Software : C#.Net 4.0
6. Top Data Migration Client: CUNA Mutual Group Apr 2012 – Mar 2013 CUNA Mutual Group is a mutual insurance company that provides financial services to credit unions and its members. The TOP project is to manage and execute the data migration of all the CPI plans to Escape retirement system through an automated tool based mechanism, which could be extended for the future mergers and acquisitions (M&A) by CUNA Mutual.
Data migration for around 3500 plans from CPI systems to Escape system Data migration of the following information from Superbase/SRT systems at CPI to Escape database, in multiple iterations
o Employers, Funds, Contribution Sources
o Plans/Products, Provisions, Employees/Participants o Financial Transactions
Development of a tool based solution to enable automated data migration and extendable for future migrations due to other M&As.
Role : Senior Developer
Responsibility : Requirement analysis
Design
Development
Testing and Test plan creation
QA & UAT Support
Software : VB.Net 4.0, SQL Server and XML
7. Report Migration Client: CUNA Mutual Group Apr 2013 – Oct 2013 CUNA Mutual Group is a mutual insurance company that provides financial services to credit unions and its members. CUNA Mutual Group’s retirement area has reports for plan administers and business users. These reports were created by SSRS 2005 and those reports were migrated to SSRS 2008. Along with report migration, obsolete reports were identified and retired, new stored procedures are created with performance tuning to increase the report turnaround time.
Role : Senior Developer
Responsibility : Coding
Testing and Test plan creation
QA & UAT Support
Software : SSRS 2008 and SQL Server
8. Escape-Rewrite Client: CUNA Mutual Group Nov 2013 – May 2014 CUNA Mutual Group is a mutual insurance company that provides financial services to credit unions and its members. Retirement Plan Services (RPS) delivers high quality retirement asset management and services to mid-market consumers and small plan sponsors. Our primary systems are EScape and BFY (Benefits For You) - Beacon. The Escape/BFY applications support the administration and management of retirement products for the micro-plan (up to $1 mil) and small-plan ($1 mil to $10 mil) customers. RPS also supports several smaller in-house and vended systems outside of EScape and BFY. The project involved
Maintenance and Enhancements to add business functionalities to Escape application Rewrite of VB6/DB2 screens to VB.Net/SQL screens
Role : Senior Developer
Responsibility : Requirement gathering
Development
Testing and Test plan creation
QA & UAT Support
Software : VB.Net 4.0, SSRS Reports, SQL Server 2008 9. Takeover workstation Client: CUNA Mutual Group May 2014 – May 2015 CUNA Mutual Group is a mutual insurance company that provides financial services to credit unions and its members. CUNA Mutual group set to take over retirement plans along with the participant details into the existing retirement plan management ecosystem. This system formalized the set of incoming formats for the future takeover of retirements along with the technological infrastructure through the takeover workstation. Takeover workstation would enable importing retirement plans, participants, contribution sources, contribution funds and provisions to this ecosystem. This project executed in agile project execution model. Role : Senior Developer and Technical lead
Responsibility : Requirement gathering
Development
Testing and Test plan creation
QA & UAT Support
Software : VB.Net 4.0, Entity Framework and SQL Server 2008 10. Distributed Scanning & Indexing System Client : American Family Insurance May 2015 – till date American Family Insurance (aka AmFam) is a private mutual company that focuses on property, casualty and auto insurance, but also offers commercial insurance, life, health, and homeowners coverage, as well as investment and retirement-planning products. DSI is a Web based scanning & indexing system, which allows users to remotely index or scan documents using web browser. Works well with any TWAIN complaint scanner. DSI performs Bar-code detection, blank page separation, Image cleanup. DSI provides simplified interface for admins to create scan/index projects, view the summary of indexed batches and create reports on scanned/indexed batches. DSI is a .Net 4.0 Web application as the front end system along with dispatch windows service for uploading the documents into the P8 system in a distributed manner, This 2 tier feature allows the DSI to upload the documents to P8, even if P8 system is down and dispatch service would upload once the P8 is back online. Role : Senior Developer
Responsibility : Requirement gathering
Development
Testing and Test plan creation
QA & UAT Support
Software : C#.Net 4.0, Oracle and EZTwain
Education Qualifications:
Bachelor of Engineering in Computer science,
Thiagarajar College of engineering, Anna University, Tamil nadu, India Personal Information:
Date of Birth : Feb-12 1987
Marital Status : Married
Visa Details : H1B
Contact Address : 1280 Prospect CMNS, Apt # 122, Sun prairie, WI - 53590 Email Address : *******@*****.***
Phone : 608-***-****