SUMMARY

• Over 7 years of experience as a Business Analyst wif a firm understanding of Business Requirement selection techniques and experience in visualizing, representing and translating teh product image from business to software development wif use of vital contributions in various domains.
• Professional domain noledge of Banking, Healthcare, Insurance and Finance.
• Strong noledge ofSoftware Development LifeCycles (SDLC) including Waterfall, RUP and Agile/SCRUM methodologies.
• Experience in gathering user requirements, preparing and analyzing bothBusiness Requirement Documents (BRD) and Functional Requirement Documents (FRD), and proposing changes for process improvement wif use of teh various internal and external requirements gatheird.
• Proficient in creating User Story, Use Cases, Use case diagrams, Sequence diagrams, and Activity diagrams.
• Worked closely wif teh system architect to facilitate teh design and development of Business Rule Engines to support SOA architecture and defining web services, web methods and orchestrations.
• Extensive experience in creating As - Is and To-Be process models, conducting Gap Analysis to understand areas of improvement and analyzing teh risks involved through SWOT, Value Stream Mapping, Feasibility Analysis and Impact Analysis.
• Experienced in using MS office applications for day to day activity, MS Visio for drawing flow diagrams and MS Project for prioritizing and managing individual tasks.
• Adequate noledge in EDI/HIPAA health information & health care services regulatory environment working noledge and compliance experience along wif proficiency in using ICD10/ CPT/ANSI/HL7 coding standards.
• Expertise in using Rational Requisite-Pro for Requirement Management and developed Requirement Traceability Matrix (RTM) to manage association between requirements and other project artifacts.
• Designed and implemented SQL Queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases like Oracle, SQL Server for timely reporting and validation.
• Experience wif building reports-SSRS, Crystal Reports, dashboards for analytics - Performance Point Services and collaborative team sites (using Microsoft SharePoint Server 2010).
• Experience in facilitating Joint Application development (JAD) and Joint Requirement Planning (JRP) sessions, Interviews, Workshops and Requirement Elicitation sessions, Rapid Application Development (RAD) sessions.
• Strong Experience in creating Test plans and Test Cases for User Acceptance Testing and overlooking test script execution for Integration, Regression, Performance, Functional and System Testing.
• Detail-Oriented Energetic Team Player, Motivated Wif Multi-Tasking Capabilities, Problem Solver, And Hands-On Leader Wif Exceptional Presentation And Client/Customer Relation Skills.
• Strong working experience of MS Visio, MS Projects and MS Office tools.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 8/7/XP, Unix, Linux (Ubuntu), Windows Server 2003

SDLC Methodologies: Agile/SCRUM, Waterfall, Spiral, RUP Process and Prototyping

Internet Languages/ Web Applications: UML, HTML, CSS, XML, Shell Scripting

Databases and Tools: SQL Server 2005/2008, My SQL, Distributed DB, PeopleSoft, Oracle 9i/10/11g, MS Access, PL/SQL, TOAD, DOORS

Quality Management: IBM Rational Manual Tester, HP Quality Center, QTP, JIRA, HP ALM, Test Director

Project Management: Microsoft Project Professional

Change Management: Rational Clear Quest 7.1, Requisite Pro v7.1

Languages: C/C++, Java/ J2EE, Python, VB.Net, JavaScript, VB6, PHP, Perl, ASP.NET, C#.NET

Version Control: Rational Clear Case, Rational Rose, Rational Requisite Pro

Business Intelligence / Reporting: SQL Server Reporting Services (SSRS), Performance Point Services

Content Management System: Microsoft SharePoint Server, SharePoint 2010, SharePoint Designer 2010

Others: MS Office Suite (Word, Excel, PowerPoint, Visio)

PROFESSIONAL EXPERIENCE

Confidential, Winter Park, FL

Sr. Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models dat contain Business Requirement Documents and supporting documents dat contain teh essential business elements and detailed definitions.
• Working wif clients to better understand their needs and present solutions using structured SDLC approach.
• Gatheird user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Documented teh user requirements Analyzed and prioritized them and converted them as system requirements dat must be included while developing teh software.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Performed extensive data modelling to differentiate between teh OLTP and Data Warehouse data models
• Captured requirements based on Basel II internal ratings based approach (IRB). Allowing certain extent on estimation of credit risk.
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance wif teh Basel II Accord.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using teh UML methodologies.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of teh software solution.
• Facilitated JAD sessions wif management, development team, users and other stakeholders to refine functional requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh Oracle database
• Scheduled meetings wif developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings wif project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Identified various frequently used modules wifin teh application as well as teh peak user volume for load testing purposes.
• Analyzed teh test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies wif Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Collaborated wif Quality Assurance Analyst in Automated and Manual Black box testing.
• Helped in creating end user manuals and procedure manuals.

Environment: Agile/SCRUM, SQL Server 2012, MY SQL, PL/SQL, Java, J2EE, JavaScript, Oracle 11g, HP Quality Center, Test Director, JIRA, UAT, UML, TOAD, MS Office, MS Project, SSRS, OLAP, QTP, MS Visio

Confidential, Phoenix, AZ

Sr. Business Analyst

Responsibilities:

• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Created use case scenarios and documented work flow and business process using MS Visio.
• Gatheird and documented business requirements for existing and future business systems.
• Analyzed and tested various Common Eligibility Outbound Interface Process and other Inbound/ Outbound Facets interfaces.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Analyzed current MMIS and EDI claims and documented teh requirements to implement new MMIS automated system.
• Defined Functional Test Cases, documented and executed manually using quality center.
• Analyzed trading partner specifications and created EDI mapping guidelines.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server.
• Helped wif building ICD 9 to ICD 10 crosswalk map by grouping thousands of codes and ranges in Clinical, Benefits, Financial, Medical policy waves.
• Working wifin a growing environment of X 12 4010/5010 HIPAA Transaction Processing 837 me, P, D, 835, 834, 820, 270, 271, 276, 277, 278, EDI, Privacy, Security, and Medicaid.
• Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts.
• Written test cases, test scenarios, and prepared test data to conduct teh manual testing of EDI files and teh mainframe screens.
• Involved in creation and execution of manual test cases in HP quality center and automated Test Cases in QTP and analyzed teh Test Results.
• Tested teh application manually by executing Test Cases in Quality Centre prior to Automation and Involved in automated testing.
• Performed functional testing wif teh development team as well as User Acceptance Testing and Regression Testing of teh application using Quality center and JIRA for prioritizing defects and assigned it to teh developer to fix teh bugs

Environment: Agile/SCRUM, SQL Server 2012, MY SQL, PL/SQL, Oracle 10g, JIRA, Java, J2EE, JavaScript, HP Quality Center, QTP, SSRS, UAT, DOORS, UML, MS Office, MS Project, MS Visio

Confidential, Newnan, GA

Sr. Business Analyst

Responsibilities:

• Established a Rational Unified Process (RUP) centric business analysis methodology.
• Collaborated in building abusiness analysis process modelusingRational Rose, Requisite Pro, and Visio.
• Provided key initiatives in working wif users in defining project and system requirements.
• Provided inputs in teh strategic development of detailed project plans, work assignments, target dates etc.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Conducted mass user interviews wif brokers, enterprise user representatives and SMEs.
• Provide customer service and support forProperty & Casualtyrisk management needs
• Processed annuitant transaction to move their payout investment from one separate account to another
• Developed teh workflow to produce teh output for teh user in Pega Systems using HTML.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict teh workflows to be incorporated into teh development of Pega Business Process Management (BPM) tool.
• Responsible for teh development of a Data Warehouse for personal lines property and casualty insurance.
• Meticulously assessed data from various sources and generated conceptual and logical database designs using ERwin data modeling tool.
• Experience in managing teh changes in requirements by Unified Change Management Tools (UCM) like Rational Clear Quest.
• Designed and developedUse Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all teh use cases and issue logs.
• Developed strategic partnerships wif teh business unit to prepare a solid noledge base of teh business line, including teh business plan, products, and process’and revenue streams aimed towards problem solving.
• Helped design scope documents and teh Request for Proposal (RFP) after extensive ROI analysis and coordinated wif top management for teh approval process.
• Played a key role in teh planning, testing and implementation of system enhancements and conversions.

Environment: RUP, SQL Server 2008, MY SQL, PL/SQL, Java, J2EE, JavaScript, HP ALM, Rational Clear Quest, Requisite Pro, Clear Quest, UML, UAT, TOAD, JIRA, MS Office, MS Project, MS Visio

Confidential, San Antonio, TX

Business Analyst

Responsibilities:

• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Actively participated in teh resolution of Production Report issues and also teh gathering and analysis of ever changing Reporting Requirements of users
• Involved in teh meeting wif business and marketing team for requirements gathering in definition stage.
• Utilized SharePoint and SharePoint Designer to create and manage team site, templates and workflows.
• Gatheird teh reporting requirements of teh Trade Position Reporting for various Secured and Unsecured Financial Products including derivatives like Equity Swaps, FX Forwards, Currency Swaps, Interest Rate Options, and Forward Rate Agreements (FRA) and formulated teh Business Rules for teh same in teh Oracle Data Warehouse wif Crystal Reports as teh front end reporting tool
• Ensured IT security and SOX Compliance requirements are implemented in New Systems, Enhancements and Upgrades
• Asset classes covered include Interest Rate Swaps, Credit Default Swaps, Foreign exchange swaps, and Equity options.
• Ability to organize, document and track changes and defects using teh Rational Clear Quest and archive change request in Clear Case.
• Worked as a Liaison between Trading and Debt Capital markets to execute Syndicated loans
• Created narrative Risk Manuals and flow charts identifying internal risks to Investors Bank and Trust for Global Treasury/Global Treasury Operations.
• Monitored compliance of Global Treasury/Global Treasury Operations desks (Asset Liability Management, Broker/Dealer, Foreign Exchange, Investment Portfolio, Money Desk, Securities Lending and Wire Room Operations) wif regulatory and internal requirements.
• Performed compliance projects as requested by Global Treasury/Global Treasury Operations Management.
• Assisted wif integration of former Investors Bank and Trust Institutional Custody Department into Wealth Management Services.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted wif preparation for internal audits, and Federal Reserve Board audits.
• Provided Anti-Money Laundering (AML) review of State Street/Investors Bank and Trust clients.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• Performed Data Validation of teh data flow from teh front-end to teh back-end using SQL to perform teh Back-end testing on teh database.
• Facilitated negotiations wif clients (other arrangers) for teh finalization of syndicated facilities (conditions, term sheet, covenants).
• Ensured dat relevant UML diagrams and Tools (Rose, Requisite Pro) were used in all requirement documents e.g. Business Requirements, Functional Specifications.
• Facilitated teh Customer in defining teh high-level Functional Requirements and needs.

Environment: Agile/SCRUM, SQL Server 2008, MY SQL, PL/SQL, Java, J2EE, Oracle 9i, JavaScript, SharePoint 2010, SharePoint Designer 2010, HP Quality Center, QTP, MS Office, MS Visio, MS Project

Confidential, Middletown, NY

Business / System Analyst

Responsibilities:

• Coordinated wif Business Owners, Application Vendor, Payers and Clearinghouses to bring all processes to a level of execution to mitigate any impact to current revenue flow under teh 5010-compliancy requirements.
• Gatheird and validated inventory of applications, interfaces, and reports dat will need to be modified to comply wif ICD-10 requirements.
• Implemented 837P, 835, 270, 271, 997 HIPPA documents
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Designed and developed Business Rules Document about teh Claim Component and HIPPA
• Developed and implemented weekly metrics management for availability management, capacity management and security management utilizing teh ITIL process framework.
• Helped wif building ICD 9 to ICD 10 crosswalk map by grouping thousands of codes and ranges in Clinical, Benefits, Financial, Medical policy waves
• Maintained and enhanced Next Gen Electronic Medical Records (EMR), Electronic Practice Management (EPM), and Imaging Control System (ICS) software.
• Prepared use cases and data flow diagrams to analyze teh impact of ICD 10 diagnosis codes, CPT and HCPCS codes embedded in different systems and applications
• Designed, test, and customized EMR templates, documents and crystal reports.
• Analyzed teh testing results to ensure dat teh results were in accordance wif teh Gap Analysis and expected results for 5010 compliance.
• Used UML for Specifications, Documentation and Construction of systems
• Used HL7 guidelines and dictionary for defining business rules associated wif pre-defined workflows according to business requirements.
• Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for837, 270/271, 276/277, 835, 834 EDI transactions.
• Involved in teh creation of UAT test plan, UAT test scenarios and UAT test cases

Environment: Agile/SCRUM, SQL Server 2008, MY SQL, PL/SQL, Oracle 9i, JIRA, Java, J2EE, JavaScript, HP Quality Center, QTP, SSRS, UAT, DOORS, UML, MS Office, MS Project, MS Visio