SUMMARY

• Business Analyst with 11+ years extensive experience in all phases of SDLC (software development life cycle) processes and software development methodologies including RUP, RAD, Waterfall, and Agile.
• Experience in business requirements modeling and development of Web Based, and Client/Server applications in diverse business domains of Healthcare, Insurance and Financial Industry Sectors.
• Experienced in complete SDLC, Client /server architecture providing a well - balanced understanding of business relationships, business requirements, worked for financial and technical solutions and helped the team at all levels until final product release.
• Expertise in Business Process Modeling, Business Process Re-design and in designing Process Architecture.
• Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Technical Training, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
• Very well experienced using Microsoft Office Suite - Word, Excel, Access, and PowerPoint.
• Experienced in creating Business Requirement Documents, User Requirement Specifications, and Functional Requirement Specifications.
• Skilled in determining system requirements and specifications for application development projects with emphasis on User Requirements and Functional Requirements through user interviews.
• Excellent Project Management skills and Team Leading abilities.
• Conversant in a broad range of technologies and tools, including business process tools such as Erwin, Rational Rose, MS Visio, Data Analysis and Data Modeling.
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
• Experience with healthcare system, Medicaid and with prime focus on claims adjudication, provider, eligibility and prior authorization.
• Experienced in Quality Assurance and testing of Client Server and Web based Applications.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Good working knowledge of Claims processing, HIPAA Regulations and 270, 837P, 837I, 837D EDI Transactions for health care industries.
• Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions.
• Financial Reporting, Fund Services, Fund Accounting, Financial Accounting, Transfer Agency, Mutual Fund Administration, Position keeping and Margin & Limit Tracking.
• Conversant in doing P&L Calculations and NOP Calculations.

TECHNICAL SKILLS

Internet: HTML, XML, VBScript, ASP, JavaScript, Adobe

Automation Tools: MS Visio, Rational Rose, Rational Clear Case, Rational Requisite Pro, Documentum, SharePoint Site, SQL Server, TOAD, Erwin.

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

Application Servers: IBM Websphere, BEA WebLogic

Bug Tracking Tools: Clear Quest

Testing Tools: Quick Test Pro (QTP), Test Director, Win Runner, Load Runner, WorkBench

Development Methodologies: RUP, RAD, Agile, Waterfall, ESDM, STV

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data Warehousing Tools: Informatica, Business Objectives, Cognos, Erwin, SAS

PROFESSIONAL EXPERIENCE

Confidential, Columbia, SC

Business Analyst

Responsibilities:

• Worked in South Carolina Confidential to implement HIPAA X12 versions 5010 and NCPDP version D.0 which are new sets of standards that regulate the electronic transmission of specific healthcare transactions.
• Gathered, analyzed and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Worked extensively with the Project Management and QA Team for designing Test Plan and Test Cases. Interacted with the users and logged any defects or enhancements for UAT.
• Conduct meetings and workshops with Subject Matter Expert, Project Manager, Developers, and the end-users to discuss action item log and risk factors.

Confidential, CA

Business Analyst

Responsibilities:

• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Gathered requirements and modeled the data warehouse and the underlying transactional database.
• Performed Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Managed and traced requirements using Rational Requisite Pro.
• Executed project management activities and managed the project team for an initiative to provide end to end order and product traceability for the business.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Involved in designing the Web based application with the offshore team.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Produced Gap Analysis documents for HIPAA 5010 and ICD-10.
• Established questionnaires and resource leveling required for implementing HIPAA 5010 and upgrading ICD-9 diagnosis codes to ICD-10 codes.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Utilized agile project management techniques to increase team productivity and meet aggressive delivery dates.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.
• Analyzed, maintained and updated FAQ knowledge base in SharePoint for better data accuracy and better timely data availability.
• Developed business process models in RUP to document existing and future business processes.
• Established RUP (Rational Unified Process) methodology and provided assistance in developing Use cases and project plans.
• Interacted with the users and logged any defects, enhancements from the UAT and communicated them to the development team.

Confidential, Pittsburgh PA

Business Analyst

Responsibilities:

• Interacted with Users, Subject Matter Experts (SMEs) understand the business processes.
• Conducted Impact / GAP Analysis for close to 1000 cobol programs accessing group database as a part of the group migration project for in/out of scope determination.
• Performed analysis and identified areas that needed process improvements by defining “as is” state of the business process flows and reengineered them by defining “to be” ones for the purpose of increasing business performance.
• Developed change requests and worked with the developers to implement the changes required to meet the specific requirements.
• Worked extensively with downstream systems for analyzing requirements and documenting them using SharePoint.
• Wrote SAS syntax code for analytical purpose.
• Developed a traceability matrix in Rational Requisite Pro across the project elements.
• Provided weekly status to the Team Lead on the status of each tasks/deliverables assigned.
• Prepared / updated a Functional Requirements Document (FRD) for all the above projects.
• Communicated with the Quality Assurance (QA) TCoE team to track the test case results.
• Coordinated with the development team on various design related issues.
• Coordinated team review of documents using SharePoint for document management.
• On an ongoing basis, acted as liaison between testing team (TCoE) and the development team and ensured that issues were resolved within said time frames to meet the overall project objectives.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Enhanced existing work flow diagrams for the new service requirements.
• Performed and handled planning, testing, and training strategies efficiently for an industry standard QA process for greater system efficiency.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Analyzed the QA test results from various scenarios on a daily basis and managed the defect logging process using Rational Clear Quest.
• Worked with technical groups on defect cause and identifying issue resolutions.

Confidential, Troy, MI

Business Analyst

Responsibilities:

• Helped in defining Change Management Process for Release Management Team.
• Mapped process flow; assess as-is processes through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
• Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare).
• Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan).
• Teamed up with both internal and external software development groups to provide functional requirements specifications in form of use cases, business process flows, and prototypes and management reporting requirements.
• Extracted the data from SQL Server, Oracle, Files, and Access into Data warehouse.
• Conducted Functionality, Regression, Integration, performance, GUI and Back-End testing of Client/Server and Web based applications.
• Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Sound understanding of Object Oriented Analysis and Design OOAD and proficient in documentation of as-is and To-be business processes.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Designed and developed project document templates based on SDLC methodology.
• Established RUP (Rational Unified Process) methodology and provided assistance in developing Use cases and project plans.
• Queried database using SQL for backend testing.
• 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.

Confidential, Union, NJ

Business Analyst

Responsibilities:

• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Designed report templates based on the requests by account managers.
• Designed Functional Specification Documents for the reports.
• Extensive use of Excel to create Functional Specification Documents & Templates.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Defined ETL strategy to capture new data, store historical data and update data warehouse in the most efficient way.
• Designed the process flow diagrams for flow of information and report creation process.
• Conducted RAD sessions for the report users, requestors, and the developers.
• Experience in Creating wireframes Mockup and storyboards.
• Reviewed Requirements & deliverables for delivery timeline.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Created presentations explaining the entire report development process, while drawing a comparison between the legacy & the new report.
• Tested the report for its content.
• Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
• Worked on Report Re-engineering Project and made enhancements to the system flow.
• Modified System flow diagrams using SDLC.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).

Confidential, New York, NY

Business Analyst

Responsibilities:

• Provided support for Oracle EBS Financials including daily processing, end user support and new projects.
• Supported the ongoing maintenance of the Oracle EBS Supply Chain applications.
• Provided technical and business solutions that matched existing business needs to the new functionality in the existing 11i environment.
• Had extensive interactions with IT to ensure Oracle was functioning as expected and all requirements were met.
• Created test plans and supported test planning and execution
• Communicated to business partners the functional changes related to the assigned tasks.
• Identified and implemented process improvements.
• Provided end user support including resolution and training.