Project Data

Harini ( Rini ) Kapadia

Wethersfield, CT 860-***-****

*********@*****.*** 860-***-****

summary

Information Technology Professional that provides creative and cost

effective solutions to support various business segments. Widespread

experience with analyzing and troubleshooting business applications,

including Life Insurance / Annuities (Vantage1 and other Life Systems),

Financial Systems (401K, Defined Contributions), Disability Insurance and

Property / Casualty (Auto, Home, Boat, Yacht, Other Personal Lines, Claim,

Reinsurance). Technologies used were both mainframe and distributed Object-

Oriented Concepts. Project work and experience involved all phases of the

Software Development Life Cycle (SDLC). Excellent communication skills in

working with internal business departments and external clients. A solid

team player involved in project coordination from beginning to end of

successful project implementation.

technical skills

Hardware: Internet, LAN, WEB Technology, IBM PC, IBM Mainframe

Software: Distributed: WEB Page Design, WEB Services, WEB Front-End User

Interface, WSDL, IE9, Chrome, JAVA, JavaScript, RAD, Stylus Studio, HTML,

XML, XSLT, DOM, TypeMock, JSP pages, Websphere, SoapSonar, SOAP for

CICS, .NET, C#, ASP, ASPX pages, JSON, AJAX, Visual Studio, Object-

Oriented Concepts, MVC Framework, SQL, ODBC, JDBC, OLE, MKS, SCM,

Subversion, Cruise Control Setup, Test Director, Quality Center, Windows 7,

NGD (Next Generation Desktop), Microsoft Suite of Products including

Word, Excel, PowerPoint, Visio and Outlook.

Host: Cobol, DB2, QMF, SPUFI, VSAM, OS/MVS, MVS/XA, TSO/ISPF,

Panvalet, Endevor, CICS, SDF2, Intertest, Xpeditor, JCL, CA7, PROC,

SDSF, OS2, CLISTS, Hourglass, FTP, IBM utilities including Easytrieve,

Syncsort, IEBGENER, IDCAMS, IEFBR14, IEBCOPY

professional experience

Cigna, Bloomfield, Windsor, CT

Senior Systems Analyst

2014 - Present

Work in OneView team with Medical/Dental/Pharmacy/Vision/Reimbursement

Membership Claim data.

. Work with Business, SA, QA, Developers on Enterprise projects

. Created Business and Functional Requirements, Business Rules, Mapping and

Error Message documents.

. Mockups were created for Screens, Reports, etc.

. Mapping for Service response documents were created along with Use Case

identifying each field.

. Database Schema and UI changes were identified and captured.

. Testing conditions were created for positive, negative, special

functionality, etc.

. Performed version/release activities such as script testing.

Worked in Individual Book of Record (IBoR) team with Healthcare Membership

data (Demographic and Coverage information) with IBM Initiate.

. Created Functional Requirements, Task Decomposition, Business Rules,

External Mapping documents.

. Mockups were created for Screens, Reports, etc.

. Designed File in Data Out (FIDO) documents for new source of data coming

in thru Extract/Transform/Load (ETL) process. Message Broker was used to

capture any error exception conditions and log them.

. Create JAVA Web Service Request/Response data analysis and mapping

document.

. Stored Procedures were created and documented. They were used by Web

Services. One shot SQL scripts were created for updates and inserts of

data.

. Software Development Life Cycle (SDLC) from beginning of data coming in,

processed in Operational Data Store (ODS)/Registry to creating Hyperion

Reports which uses Oracle.

. Facilitated Walk-thru of all documents with both internal and external

business partners. Update documents and track history of all changes by

date and color. Capture project issues and resolutions.

. Completed training for HP ALM (upgrade version of Test Director) and

Sharepoint 2010.

. Use Initiate tools such as Inspector and MDM (Master Data Management).

Worked in Enterprise Content Management (ECM) team on FileNet IBM Content

Navigator (ICN) Tool.

. Created Functional Requirement Document (FRD) from Business Requirement

Document (BRD).

. Conducted FRD Walk-thru with the project team.

. Created Application Design Specification (ADS) using BRD and FRD.

. Mockup's of ICN screens were created and any customization identified and

documented.

. Data consisted of Medical and Underwriting information.

. Follow-up and document questions/answers/takeaways/changes for Business.

. Create and Organize folder structure and documents in sharepoint.

Aetna, Hartford, CT

Senior Business Analyst 2013 - 2014

. Worked in Corporate Human Resource (HR) Domain.

. Proficient in Data Analysis, Systems Analysis, Business Analysis,

Requirement Analysis, Gap Analysis and Project Management.

. Quickly analyzed and learned current business functions, system and data

structures to identify and derive needs and facilitate the development of

new requirements.

. Analyzed and worked with internal and external Vendor Data such as ING.

. Live meetings used for facilitating Business Requirement Gathering for

Mobile Devices and Payroll.

. Experience in participating in JAD processes.

. Experience working in SDLC, Waterfall and Agile Project Methodology.

. Lead meetings on any outstanding Issues/Takeaways.

. Created Mockup/Use Cases/UI Wireframe/Data Flow Diagrams using Visio.

. Utilized tools such as RRC (RAD Rational Composer) for requirements and

ClearQuest for Defects.

. HR Data Warehouse/ETL Tools/Host Files/XML.

Travelers, Hartford, CT

Associate Information Engineer 2005 - 2013

. Worked in Personal Insurance (PI) supporting Home, Auto, Boat, Yacht and

other lines of Insurance for Distributed Object-Oriented Front-End UI WEB

Applications for business and presentation layers using ASP.NET, C#, MVC

Framework and Mainframe Host Legacy Systems.

. Gathered business requirements by analyzing business functionalities,

provided estimates, created Technical Design Specifications, coding,

testing and debugging for Batch Host and Online CICS on the Mainframe

side and distributed WEB Client/Server side Applications.

. Unit test and deploy the code to the appropriate environments (INT, SYS,

UAT, etc.) using Subversion and Cruise Control setup for distributed

projects and Endevor for Mainframe host applications.

. Problem solved and researched defects detected by the testing team

resolving them accordingly within the designated timeframe and

documenting the root cause in defect management tool like Quality Center.

. Modified existing and created new WEB Services as well as CICS WSDL's

based on business requirements for both Java and C# distributed object

oriented applications.

. Debugging of WEB applications included client and server side testing

tools - Nunit, Boundary Crossing, YUI (Yahoo User Interface), HTML,

JavaScript, JAVA and .NET, C# testing.

. Completed tasks within the deadlines, multi-tasking, solid contributor

and maintaining good relationships and encouraged others to do the same.

. As Project Technical Lead encouraged shared knowledge within PI and

across other teams along with business partners.

. Created XSLT state specific files to merge with different forms for the

Auto and Home Policies that used multiple ACORD forms such as ID cards,

Agent Proposal, Binder and state specific supplemental forms.

. Subject Matter Expert (SME) for the Print Select Application which

consisted of .NET front end UI, C#, references to consume other WEB

Services, XML and XSLT transformation technology to produce ACCORD forms

PDF.

. Mentored team members in the use of Print Select Application and its

functionality.

. Upgraded desktop to NGD using IE9 and Windows 7 Technology as part of

Pilot team identifying, documenting and resolving issues.

MassMutual Financial Group, Hartford, CT

Business Systems Analyst 2004

. Worked on the Guarantee Issue Process (GIP) System, which utilized EXCEL

(complex formulas), Word and VBA functionalities in the Disability

Insurance (DI) Department.

. Testing platforms included unit, system and QA (regression) using Test

Director to execute tests and log defects.

. The testing consisted of calculating DI benefits, risks, prior search,

premiums and output (reports, application forms, etc.).

. The creation of business requirements and technical specifications were

major part of the job.

CIGNA Retirement and Investment Services, Hartford, CT

(Division was sold to Prudential Financial, Inc. in 2004)

Systems Consultant 1996 - 2004

. Responsible for maintenance and enhancements of Defined Contribution (DC

Facts) System in the Retirement and Investment Division. Project

enhancements included contributions, loans, withdrawals, takeover,

terminations, transfers, discontinuance and reports.

. Worked with Business Analysts to create Technical Specifications from

business specs and requirements. Created the technical statement of work

to design and code programs in both batch and CICS COBOL.

. Created new DB2 tables and changed existing tables as per technical

function for application requirement.

. As an application developer, performed impact analysis to the system for

additions or changes to copybooks, dclgens, maps, programs, jcl, procs,

files or sysin.

. Downloaded participant data from production to unit or acceptance test

using existing clists.

. Provided on-going technical support to the business area to assure

successful implementation.

. Involved in design and code walk-thru of the changes that were being

implemented.

. Worked on the following system enhancements: ADP compliance Extract,

Negative contributions, Guaranteed Long Term (GLT) system rewrite for

Y2K, Guaranteed Investment Contract (GIC) and Participant Financial

Statements (PFS).

. Created the Endevor training manual and conducted the training classes

for the division and provided on-going technical support for the product.

. Worked on Y2K assignments as well as Client Server VB applications. Also,

took on the role as an Implementation Coordinator, responsibilities

included moving code, maps, mapsets, table changes thru each platform

within the specified timeline.

education

Associate of Science, Data Processing, Greater Hartford Community

College, Hartford, CT

professional development

Intro to Property and Casualty, Intro to Claims, Intro to Reinsurance,

LOMA part 1, SPARK (Society of Professional Administrative Record

Keeping), Internet I, Visual Basics 5.0, Economics, Javascript, Object

Oriented with focus on Java, Systems Analysis and Design with focus on

Object-Orientation, RAD, HTML, XML, XSLT, ASP .NET C#, Project

Management

Contact this candidate