SUMMARY

• Over 7 years of Industry experience as a Systems/Business Analyst & QA Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
• Expert in the Property, Casualty, Annuities, Disability, Supplemental and Health Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• In depth knowledge, Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: SQL, Transact SQL, PL/SQL, C, C++, COBOL, Visual Basic 6.0, HTML 4.0, XML, JAVA, .NET framework 3.0, C#,ASP.NET

Database Systems: SQL Server 2008/2005/2000 , Oracle 10g/9i/8, DB2, and MS Access 2003/2000, Teradata

Modeling Tools: MS Visio, Rational Rose

Process Tools: Rational Rose Suite, RUP, MS Office Suite, MS Project, MS Visio, MS Share Point, SASV9.0., Version One, XML Spy, Pivot Tables, SSIS, Requisite Pro

Reporting Tools: Crystal Reports, Cognosv8.0., SSRS

Operating System: Windows NT 4.0/98/2000, XP, 2007, UNIX

Version Control System Tools: Harvest, Rational Clear Case

Testing Tools: Rational Enterprise Suite, QTP V9.5, Win Runner V9.2, Load Runner, HP Quality centre 10.0, Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

System Analyst

Responsibilities:

• Gathered requirements from stakeholders for provider management and member management.
• Identified and validated business rules and data elements.
• Developed the stakeholder list and created stakeholder assessment matrix to prioritize them.
• Developed and Maintained Requirements work plan and assessed the performance metrics of the team members.
• Worked on Property and causality insurance, maintaining database, handling client and stakeholders at the same time.
• Created and Analyzed Business Requirement (BR) and Functional Requirement, directed development team to developed Member Login Web Portal (Intranet).
• Worked on Personal Injury Protection (PIP), Analyzing Individuals Policies and Updating Web portal for their personal information and Data.
• Worked on HL7 including complete lifecycle of interoperability specification (Deployment, Adoption, utilization, Adherence etc), clinical decision support, exchange of clinical documents,
• HL7 testing included connectivity to the Database, validate inbound and outbound messages, validate ack and nack, generate values and test message from specification, repeat test plan and test scenarios and generate reports.
• Worked on Document Management, used Workflows to route documents from person to person so they can complete their document management tasks, such as Reviewing documents, approving their publication and managing their disposition.
• Worked as a Lead BA with Confidential Dedicated Team for Property and causality Insurance, Created Documents like Business Requirement Document (BRD) and Estimate for Development Team.
• Modeled the ‘as - is’ process flow and the ‘to-be’ process flow and analyzed the gap and developed the action steps to fill the gaps.
• Conducted Risk analysis and developed mitigation plans.
• Conducted Impact analysis when there is any change in the requirements and updated the Business Requirements Document (BRD) and Systems Requirements Specification (SRS).
• Facilitated meetings with the technical team and client team to analyze the current process and gather requirements for the proposed process.
• Proposed strategies to implement HIPAA 5010 in the new MMIS system and worked on planning and documentation.
• Worked extensively with ETL process, migrated data from old system to new one, make sure that data format match new system requirement.
• Designing Functional Specifications for the target physical database.
• Facilitated JAD sessions for Requirement Validation with Client Dept. of Health & Human Services (DHHS)
• Worked on Electronic Data Interchange (EDI), and Implementation knowledge of HIPAA code sets, ICD-9, ICD-10(Migration, Mapping, Verification of ICD).
• Developed UAT test cases associated with the functional requirements.
• Analyzed different Data cross-walks, complicated logic & look ups required by different fields for the source to target transformations.
• Analyzed EDI -X12 data elements captured by the existing system to validate it against the data elements required for new system.
• Broke down the services from the Confidential MMIS Logical Design into multiple layers of normalized functionality that correspond to utility services, general business services and Medicaid specific services.
• Participated in developing test plan, test scripts, and test scenarios and designed user documentation
• Worked with legacy team in developing BRD for multiple system change requests and participated in System Testing.
• Worked on SharePoint 2007, Browser based customizations, Business connectivity Services, Human Work Flows and Access are some composites I have been working on.

Environment: MS Office, Windows 2000, .NET, MS Visio, MS SharePoint, TFS, MS Project, MS Visio, SQL, Oracle, SOA, HTML, FMS/3

Confidential - Newport Beach, CA

Business Analyst

Responsibilities:

• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
• Conducted and Managed JAD sessions with SMEs and Business departments, for planning and requirement gathering
• Gathered Business Requirements, created Functional Requirements (FRD) and analyzed data/workflows to define the scope, project financials and progressed from problem statements to well documented designs.
• Documentation of the AS-IS and TO-BE process for current and future phases of the Claims Management System
• Created Requirements based on UI designs approved by the business
• Helped UI designer create mockup of the screen based on Business Requirement
• Partner with User Interface (UI) and User Experience (UX) teams to recommend improvements to site performance and prepare various ad hoc reports for multiple brands and analyze performance.
• Implemented third party Software similar to Rally with in-house application for better time management within Teams.
• Created wireframes/ mockup screens using MS Visio and MS Paint at the time of elicitation of requirements from the stakeholders
• Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
• Gathered requirements for Policy Admin, Claims and Billing module for Non-Standard Auto, Home Owners, and Worker’s Compensation policies.
• Created a file of ACORD Forms for both Personal and Commercial Lines of Business used as the standards in all Property and Casualty markets.
• Worked as a Personal Lines Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design
• Design application solutions, considering user functionality and user interface.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Assisted in the conduction of best support and high-level release testing
• Involved in the application and database design
• Participated in Gap analysis between stakeholders and user’s needs and proposed solutions.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
• Worked as a Single point of Contact for Offshore and Onsite Model.

Environment: s: Windows NT/2000, MS SQL Server, Rational Unified Process (RUP), Facets 4.21, UML, Rational Rose, Mercury Test Director and MS Office Tools.

Confidential, Sunrise, FL

Business Analyst

Responsibilities:

• Identified System Integration Requirements, and coordinated the collection and verification of business needs.
• Collected and documented business processes as well as business rules.
• Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
• Have been using these HL7 standards for integral for system integrations, inter-operability and compliance. I used them to support clinical practice and the management, delivery, and evaluation of health services.
• Worked on Healthcare Effectiveness Data and Information Set (HEDIS) to interpret its result to track year-to-year performance, Collecting HEDIS data for Medicare and Medicaid Services (CMS) requirements.
• Generated Report based on HEDIS data also interpreting its data to match requirement from client.
• Documented and delivered Functional Specification Document so that development team can be directed to develop Member Web Portal.
• Created and analyzed business requirement (BR) and Functional Requirement to the project Team.
• Responsible for multiple roles such as requirements gathering and solution development across the full insurance life cycle from CRM (marketing, sales, service) to underwriting & quoting, policy administration, commissions & broker management, claims, financial reporting and analytics for Property and Casualty division.
• Worked on Personal Injury Protection (PIP), Analyzing Individuals Policies and Updating Web portal for their personal information and Data.
• Participated in the logical and physical design sessions, developed design documents.
• Worked extensively with Oracle, SQL Server and ETL process.
• Worked FMS/3, Analyzing result and based on that created report to help making decisions
• Designed and developed the database for various projects.
• Helped the business units understand how Data warehousing and Data mining techniques can help them do their decision making in a more organized and easy manner.
• Helped the developer team understand the needs of the business environment using the programming terminology.
• Collaborated with development architect and the business to develop both high-level and detailed application architecture to meet the business needs.
• Conducted User Acceptance Testing (UAT) with the help of Test Director.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Developed Test scenarios and implemented Test plan, providing key input in working with users in defining project and system requirements.
• Conducted Project related Presentations.

Environment: Windows, MS Office, MS Visio, Lombardi, Oracle, SQL, Test Director, UML, MS Project, Rational Requisite Pro, Rational Clear Quest, FMS/3.

Confidential, Springfield IL

Business Analyst / Quality Analyst

Responsibilities:

• Responsible for implementing premium rate revisions on policies in different states.
• Involved in requirements gathering, business analysis and JAD sessions with Business customers.
• Coordinated all project related activities including creation of Project Life Cycle documents and getting approval from the Business customers
• Created business requirement documents and integrated the requirements and underlying platform functionality. Strong understanding of rating in Property and Causality.
• Created and executed test scripts.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Wrote detailed specifications and led the development for various reports generated using Cognos.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data and perform validation.
• Maintained Project plans for the various stages of the project cycle, including Quality assurance/management and Test management.
• Worked with a team of 15 testers through the Quality Assurance testing of the windows software for the new applications rewrite from DOS to Windows XP
• Implemented the Electronic Funds Transfer feature in the billing system based on client request. Implemented DB2 processing to the sub-system.
• Implemented CICS screen capture to transport to the web.

Environment: IBM 3090, COBOL II, DB2, CICS, VSAM, EZTRIEVE, Endeavor, COGNOS, MQ series, MS Project, Visio