PROFESSIONAL SUMMARY:

• Business Analyst with 7 years of diverse experience in Information Technology with focus on Business Analysis, Business Modeling, Requirement Gathering, Technical Documentation, Software Validation and Web Application Services. More than four years of successful, progressive experience in all phases of the iterative Software Development Life Cycle SDLC .
• Rich experience in gathering user functional requirements using various requirements modeling and UML tools including Rational Rose, Rational clear case and MS Visio.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Extensive experience with Cobol TSO and Mainframe platforms
• Experience with mainframe applications such as TSO, CICS, and familiar with SQL Query Management tools like Toad for Oracle and the Query Analyzer in Microsoft SQL Server.
• Knowledge of 837, 835, 277, 270, 271, NCPDP, 4010, 5010 and ICD-9/ICD-10.
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• 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.

TECHNICAL SKILLS:

Programming Languages : C, C , C , VC , VB, VB.NET, C .NET, COBOL, ASP.NET, Java, SQL, PLSQL

Operating Systems : UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases : MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers : IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet : HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools : MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro,

Documentum, Caliber RM, DOORS, Sharepoint

Bug Tracking Tools : Mercury TestDirector, Rational ClearQuest

Utility Tools : MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools : Crystal Reports, SQL Server Reports SSRS

Data warehousing Tools : Informatica, Business Objects, Cognos, Erwin

Testing Tools : Quick TestPro QTP , TestDirector, WinRunner, LoadRunner,

Niku Project WorkBench

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Confidential Technology is a dynamic company that provides hospitals and medical centers with world-class healthcare information solutions. The application was to enhance the feature which enables the clients to capture value-added service usage data for billing and accountability. The accounting information needed to be tracked at the transaction level, which supported the System called TREKS Transaction Exchange and Knowledge-based Services

Responsibilities

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits including Medicare .
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Worked extensively with MS Excel and MS Access
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables.
• Planned and defined business requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
• Involved in Testing by using SQL and work with QA together to develop test Scenarios and test cases.
• Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Followed solely RUP methodologies during the course of the project.
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Suggested measures and recommendations to improve the current application performance.

Environment: Rational Enterprise Suite Rose, RequisitePro, ClearCase, ClearQuest , Casewise modeler, IBM WebSphere, XML, Java, Unix, C , J2EE, JSP, Oracle, DB2, Informatica, MS Office, MS Visio, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential

Sr. Business Systems Analyst

This project is to provide a Reporting Tool for the Sales Department with which the Business could monitor the Sales and also the Activities of the Agents .The business used to previously get reports in the form of E mails as X TML format or as attachments in Email. This reporting too was is to be developed on Oracle Business Intelligence OBI . The OBI tool when used or reporting, facilitate the users with the flexibility of modifying reports, in terms or date range, attributes with which the Business could build they own reports if needed. The users can export the reports to excel, PPT and any other formats that they need using the tool. Also the tool gave the user the flexibility to view the report in any graphical format

Responsibilities

• Interacted with clients to gather all requirements to formulate business specifications and translate those into application functionality, decide when to advocate and when to compromise to arrive at a mutually acceptable solution
• Developed plan for data feeds and data mappings for integration between various systems, including XML, to follow ICD 10 Code set and ANSI X12 5010 formats.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Involved in analysing the claims on basis of Primary and Secondary Payers and performed Medicare subsidy eligibility check for employee group plans.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Worked on MS Excel Macros for creating automatic reports
• Documented workflows and results of business analysis and obtain sign-off from client on specifications
• Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations if any .
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Worked directly with business users to gather, document and implement requirements to improve Marketing campaign delivery capabilities including enhancement project management.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Used Rational Rose and MS Visio for Business Process Models for the AS-IS TO-BE Enterprise Architecture
• Performed validations on the Mainframe using DB2, CICS, TSO, ISPF, File Aid etc.
• Managed multiple Billing Coordinated System BCS / Third Party Recovery and Pharmacy BCS projects at the same time.
• Assist the technical team in translating application functionality into application architecture and the production of a System Functionality document
• Used MS-Visio for flow-charting, process model and architectural design of the application.
• Responsible for the Design and execution of test plans to ensure that business requirements and functional specifications are tested and fulfilled
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Complete Understanding of the long-term business objectives and suggest technical strategies to meet those objectives.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Created Use Case Diagrams, Activity Diagrams and Sequence Diagrams in MS Project.
• Used Usability studies to improve system flexibility and to pin point user problems.
• Corrected and Updated the Requirements Traceability Matrix after completion of the UAT testing phase.

Environment: Windows, Oracle, SQL, Informatica, MS Project, Microsoft Office suite, Microsoft Visio, Test Manager, TSO, Win-runner, Rational Unified Process RUP , Requisite Pro, Clear Case, Clear Quest, UML.

Confidential

Sr. Business Systems Analyst

My work included the delivery of Risk, Governance and Regulatory Compliance. Confidential and HIPAA2 naturally became the inclusive elements in the package to address the X12 4010A1 as well as 5010 transaction solutions. Appropriate Payment Modules were carefully chosen to be invoked once the Claim rationale was established. The package also had comprehensive built-in Eligibility, Benefit Enrollment, Claims NCPDP Pharmacy, Professional, Institutional and some Dental , Remittance Advices and ancillary claim transactions such as Status Inquiries, Prior Authorizations and so on.

Responsibilities

• Gathering Functional, Non functional and Technical requirements.
• Involved in testing the Pharmacy Claims adjudication and Billing processing is done through PBM Health Trans and Claims Accumulation and Adjudication is done through Diamond.
• Facilitated and conducted JAD Joint Application Design Sessions to determine business requirements
• Designed wireframes for the new website.
• Analyzed CMS comparison documentation highlighting changes of 5010 format and ICD10 diagnosis and procedure codes.
• Analyzed the changes made to different EDI ANSI X12 transactions 837 I and P, 278, 270 and 271 under HIPAA 5010.
• Created Data Stage jobs to extract, transform and load data into enterprise data warehouses EWD from various sources like relational databases, application systems, temp tables, flat files etc.
• Worked extensively with MS Publisher
• Responsible for architecting integrated HIPAA, Medicare solutions, Facets.
• Conducted business-impact assessment and the results were compared with the new HIPAA 5010 standards to determine the current level of compliance and developed an action plan for approval by the project steering committee.
• Translated Business processes into Informatica Mappings for building Data marts
• Developed prototype, prepared the test data and checked for the feasibility of the system.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Designed the online screens and reports for the Medicaid Online Electronic Claims Submission System.
• Used MS-Visio for flow-charting, process model and architectural design of the application.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Created Work flows, Screen shots, Use Cases and Power Point presentations for the Web Applications.
• Played a key role in the planning, designing, testing, and implementation of website enhancements and conversions.
• Designed and developed project document templates based on SDLC methodology.
• Designed and developed Activity Diagrams, Sequence Diagrams and OOD using UML, Conducted GAP analysis.

Environment: Windows XP/2000, Oracle, PL/SQL, SQL Server, SQL queries, Informatica, MS-Project, MS-Office Suite, MS Visio, MS Visual Source Safe, Cobol, Test Director 7.6, Quick Test Pro QTP

Confidential

Business Systems Analyst

Confidential through its operating group HCR Manor Care, is a leading provider of short-term post-acute medical care and rehabilitation and long-term skilled nursing care as well as leading in hospice and home health care. The project involved streamlining and enhancement of the legacy claim management system to meet the needs for the next decade by enhancing our ability to automate and streamline claims processing and other administrative functions and to provide access to quality health services to members and provide responsive services to network health care providers and reducing costs to state partners. The application under testing automates an Insurance and Pharmacy Claims Process from the time a customer enters a claim to the time when the claim is either approved or denied.

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Programmed conversion of a Pharmacy Benefit Management application from MS Access to VB/SQL.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Responsible for the implementation of pharmacy benefit management programs and services for clients from inception through to completion, executing both manual and full EDI implementations.
• Negotiated with teams from projects to decide if modules should be implemented independently, or Parallely
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Updated the impacted MS Access tables.
• Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design
• Conducted Requirement Validation through requirement reviews and use of prototyping and planned how requirements should be verified by establishing Acceptance tests.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Reviewed test results and coordinated with testing and development team to correct the issues.
• Developed timelines for project delivery, and managed projects/resources
• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.
• Responsible for preparing Business Requirement Document BRD and then translating into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Documented and delivered Functional Specification Document to the project team.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.

Environment: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C . DOORS, C , NET, ASP.NET, Business Objects, TestDirector, LoadRunner