Project Sql Server

VASUMATHY SRINIVASAN **********@*****.*** Phone: 920-***-****

PROFESSIONAL SUMMARY

V 15+ years of professional experience in Software Application Analysis,

Design, Development, architecting of Internet, Intranet, and

Implementation of Client/Server, N-tier architecture, Web applications

and Mainframe based solutions in various domains.

V Thorough knowledge of C#, VB.NET, ASP, ASP.NET, ADO.NET, XML, WPF,

WCF, Silverlight, MVVM, SOAP, Web services, Web forms, Win forms,

VS.NET 2003/2005/2008, IIS 5.0/6.0, UML, Design Patterns, SQL server

2000/05/08.

V Experience with different software development methodologies including

Agile (scrum) development methodology.

V Thorough knowledge of COBOL, JCL, DB2, IMS-DB, IMS-DC, DB2, VSAM and

IDMS.

V 4 years of experience in working on Database Conversion (Hierarchical

to Relational Database) projects.

V Highly motivated, successful IT professional with the extremely

valuable combination of technical and management skills, interpersonal

skills, and business acumen.

V Proven ability to learn and apply new systems, technologies, and

applications and share the knowledge with other team members.

TECHNICAL SKILLS

Microsoft .NET Framework 4.0/3.5/2.0, ASP.NET, C#, VB.NET,

Technologies ADO.NET, WPF, WCF, Silverlight, Visual Studio

2005/2008, Visual SourceSafe 6.0/7.0, IIS 5.0/6.0

Database SQL Server 2005, 2008, DB2, IMS, IDMS

Technologies

XML Technologies AJAX,XML, DOM, SOAP, WSDL, and Web Services, CICS

services (WSDL)

Markup Languages HTML, DHTML, XML, CSS

Scripting VBScript

Languages

Packages MS Office 2003/2007/2010, MS Visio, Version One,

Version Control TFS, SVN, Panvalet

tools

Operating Systems Windows 98/2000/XP/2003, Unix, OS/390, Z/OS

Mainframe COBOL, COBOL/VS, COBOL II, JCL, IMS, DB2, CICS, VSAM,

Technologies MVS, TSO, ISPF, ISPF, FILE-AID, QMF, XPEDITOR,

Easytrieve, MQ Series, IMS DB/DC, DB2.

Visa Status

Permanent Resident of US (Green-Card holder)

Education

Bachelor's degree in Chemical Engineering (4 years), INDIA

PROFESSIONAL TRAINING

VB programming, Illinois Central College, Peoria, IL

Advanced VB programming, Illinois Central College, Peoria, IL

Objected Oriented Programming Concepts

Server-side scripting/ SQL server

Developing ASP.Net Web Applications

Programming with C#

Professional Experience:

Apriso Corporation

Los Angeles, California Nov 2012 - till date

Migration Tool for MPI

Role/Job Title: Software Engineer

Description: Apriso's FlexNet is a manufacturing software-based platform

for Manufacturing Execution System(MES) that also offers warehouse

management, quality management, maintenance management and labor tracking

capabilities. FlexNet Manufacturing Process Intelligence (MPI) ensures

enterprise manufacturing intelligence is readily available to support

faster, better decision making.

Currently working on developing a Migration tool for MPI customers to

retain the customization done to their SQL server Analysis Services

(SSAS) cube while migrating from the older MPI version to the latest

version(Quality Intelligence Pack). This tool is developed in C#

/ASP.Net. This project is being implemented using the AGILE methodology.

Responsibilities:

Design and development of the tool

Environment: Net Framework 4.0, ASP.NET, C#, XML, SQL Server 2008 R2, NUnit

(for unit testing)

Humana

Green Bay, Wisconsin Jan 2007 - Oct 2012

Agent Contracting Electronically (ACE)

Role/Job Title: Analyst/Applications Consultant

Description: This is an automated web-based contract application process

that allows an agent to complete their contract electronically via

Humana's website. Eliminate need for Humana associates to key information

from contracts.

Provide a simplified process with on-line validations for external agents

to complete through a guided on-line interview. This application

functionality includes capturing contracting data electronically,

validating user entries to state/federal regulations and Humana rules.

Validation must accommodate different validation checks based upon

information the agent enters (validations vary based upon: states in

which the agent is licensed, segments for which the agent is applying,

etc.). Automate the feed of this process directly into the corporate

agent Licensing and Commission System (SOLAR). This project is part of

Human's modernization of solution

Responsibilities:

. Providing Support for the Production Maintenances and resolving the

issues as per the Defect Severity Level.

. Also working on a process enhancement for 'Producer Re-contracting' based

on business rules

Environment: Net Framework 3.5, ASP.NET, C#, ADO.NET, ASP.NET AJAX,

JavaScript, XML, HTML, DHTML, CSS, Web services, DB2, Visual Studio 2008

Team System, COBOL, JCL, DB2, IDMS,ISPF, XPEDITOR, PANVALET, FILE AID,

CICS, MQ series.

Producer Management tool (Silverlight Technology)

Jan 2011 - May 2012

Role/Job Title: Analyst/Applications Consultant

Description: This is modernization project in which current mainframe

application are converted to intranet web application. As part this

project a new web based system is developed to be used by Humana

Associates and Sales offices to manage producer's data. This data

includes from agents demographics, contracts, licenses, appointments and

compensation related information. With this application users can also

view/download their reports in formats like PDF, Excel and CSV. This

project is being implemented using the AGILE methodology

Responsibilities:

. Define and record detail project requirements, constraints and

assumptions with the business to establish the project deliverables.

. Conduct design walkthroughs to refine and clarify project requirements

. Analysis, design, development and implementation of solution.

. Ensure a common understanding and set expectations through communication

to align the business and development team members.

. Code to the technical specifications and quality standards and provide

support during UAT.

. Provide technical support and technical quality control throughout all

stages of the project.

. Improve team performance by building team cohesiveness, leading,

mentoring, training, and motivating in order to facilitate cooperation,

ensure project efficiency and boost morale

. Help developers with technical issues that arise during development phase

and ensure that all components of the technical architecture are properly

integrated and implemented.

. Conduct demos of product with business to bridge any gaps with the

requirements and final product.

. Ensure the project deliverables conform to quality standards established

in the project quality plan

. Provided Support for the Production Maintenances and resolved the issues

as per the Defect Severity Level.

Environment: .Net Framework 4.0, Silverlight 4.0, PRISM 4.0, C#, ADO.NET,

WCF, MVVM, XML, Web services, CICS services, DB2, Visual Studio 2010,

COBOL, JCL, DB2, IDMS,ISPF, XPEDITOR, PANVALET and FILE AID.

Premiere Agent Portal Aug 2009 -

Dec 2010

Role/Job Title: Analyst/Applications Consultant

Description: Premier Agent functionality entails an

administrative/management component available thru the "Premier Agent

Management" intranet link where the Large Group PMO is able to maintain

which Agencies are designated "PREMIER" over time. In addition to the

administrative component of Premier Agent functionality, there is also a

reporting component to Premier Agent that is available on both HSS and the

Agent Portal. Via the Premier Agent PVC Report option inside the Producer

Management Tool on intranet, Internal Associates are able to view Premium

Vs. Claims reports for their Large Group Block of Business.

Responsibilities:

. Define and record detail project requirements, constraints and

assumptions with the business to establish the project deliverables.

. Conduct design walkthroughs to refine and clarify project requirements

. Analysis, design, development and implementation of solution.

. Code to the technical specifications and quality standards and provide

support during UAT.

. Provide technical support and technical quality control throughout all

stages of the project.

. Conduct demos of product with business to bridge any gaps with the

requirements and final product. Support for the Production Maintenances

and resolved the issues as per the Defect Severity Level.

Environment: .Net Framework 4.0, C#, ADO.NET, XML, Web services, DB2,

Visual Studio 2010

GENCO (Supply Chain Management Consultants)

Green Bay, Wisconsin March 2004 - May 2004

Scheduling Tool

Role/Job Title: Analyst/Applications Consultant (New development and

Maintenance)

Description: This is a scheduling tool to schedule maintenance and repairs

of trucks for trucking companies. This tool will help a scheduler schedule

repairs and also preventive maintenance of trucks considering the urgency

of the situation. Also work would be assigned to the appropriate Foreman or

a Mechanic. List Views and Tree Views were used in this tool.

This tool was developed in VB.Net with SQL server as back-end.

Responsibilities:

. Define and record detail project requirements, constraints and

assumptions with the business to establish the project deliverables.

. Conduct architectural and design reviews and facilitate solution

delivery.

. Conduct design walkthroughs to refine and clarify project requirements

. Analysis, architecture, design, development and implementation of

solution.

. Code to the technical specifications and quality standards and provide

support during UAT.

Environment: VB.Net, SQL server 2005

Contact this candidate