Professional Summary:

• Over 5 years' experience as a Business Analyst with understanding of Business Requirements gathering, Business Process Flow, Business Process Modeling
• Diverse experience working with various domains which includes Healthcare, Banking, Retail and E-commerce
• Experienced with Microsoft SharePoint 2010, Business Intelligence Analytics SQL Server Integration services SSIS , SQL Server Analysis services, Performance Point Services , Reporting Tools, Salesforce.com, Siebel CRM and other business applications
• Experience in Data Analysis concepts like Data Mining, Process Mining Statistical Analysis.
• Experienced in all phases of the Software Development Life Cycle SDLC including requirements gathering, design, development, testing and deployment
• Adept with different software development methods like Agile SCRUM Method, Waterfall and Rational Unified Process RUP
• Expertise in conducting Stakeholder Analysis to define process stakeholders, and their roles responsibilities towards the project
• Good Understanding of the HIPAA standards, EDI Electronic data interchange , HL-7, working experience with ANSI X12, CPT coding, ICD-9 coding, CMS-1500 claims forms and reimbursement forms, healthcare plans and managed care concepts Medicaid, Medicare
• Provided analysis of HIPAA compliance and took part in discussions for designing the healthcare transactions to be HIPAA compliant 837/835, 270/271, 276/277, 278, 820 .
• Proficient in analyzing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio
• In-depth working experience implementing various elicitation techniques - Document analysis,

Interface analysis, Prototyping, Brainstorming, Requirement workshop.

• Excellent skills in facilitating Joint Application Development JAD for eliciting functional requirements that support the High Level business requirements
• Experience in writing Business Requirements Document BRD , Functional Requirements Document FRD , Statement of Work SOW
• Expert in writing detail system use cases, developing business test cases, use cases and working with QA teams during testing phase thereby facilitating acceptance testing with stakeholders and business users
• Strong experience facilitating Triage meetings

Technical Skills:

WORK EXPERIENCE

Confidential

Position: Business Analyst

Responsibilities:

• Facilitate JAD Sessions with the State of Tennessee to elicit requirements.
• SME for four main functional areas of the TEDS application.
• Owned the Security Matrix of the TEDS application by performing as-is/to-be analysis from the inherited Core Avance Security Matrix to match requirements of the TEDS application.
• Responsible for the correspondence portion of the system which will allow more than 1 million members to receive notices such as approval, renewal and termination notices by print or electronic mail.
• Utilized HP Exstream to modify existing notice templates, as well as create new notices templates to meet correspondence requirements of the State of Tennessee.
• Organized and facilitated daily and weekly meetings with the testing team to assist in translating notice triggers/requirements and creating Test Verification Procedures TVP
• Took the lead on 3 contingency projects to allow TN to receive and process Medicaid and CHIP Account Transfers from the FFM due to the delayed Go-live date of the TEDS application.
• As a part of the contingency project I created an Interface Control Document ICD based on regulations set by CMS to outline the Account Transfer Process between TEDS and the FFM by way of the Federal Data Services Hub.
• Created an Interface Control Document ICD for the TEDS interface with the Tennessee Department of Corrections
• Used Contour to log requirements, conduct impact analysis, as well as create/run test cases.
• Used JIRA as a tool to triage defects and log/work system change requests.

ENVIRONMENT:

Windows 7, MS Office 2010, MS Visio 2010, MS Access 2010, MS Project Professional 2010, SharePoint 2010, HP Exstream 7.0, Waterfall Methodology

Confidential

Position: Business Analyst

Responsibilities:

• Created use-case narratives and process walk-through narratives in association with the business model diagrams to avoid any functional discrepancy
• Creating functional, non-functional, regression and security test cases from business requirement for testing Kaiser Permanente CRM which was migrated from Siebel CRM to Salesforce.com
• Analyzed the system setup and configurations in Siebel CRMOD in order to accommodate the Sales and Service processes migrating from Siebel CRMOD to SFDC.
• Analyzed the existing gaps and risks in the current Sales process and created Gap Analysis document for business review.
• Designed current state and future state Sales process flows and mapped it to the Business requirements.
• Configured and customized various Standard objects, Custom objects, Page layouts, Validation rules, Workflow rules, Email Templates, Reports for the Sales application.
• Analyzed and Created Custom Profiles as required for the business needs and implemented Object level, Field level and Record level security.
• Performing User Acceptance Testing of Kaiser Permanente CRM platform
• Analyzing the current user account management process for Kaiser Permanente Revenue Cycle reporting platform and recommending and improving on that process
• Utilizing Microsoft Visio to create process and work flow diagrams
• Utilizing Microsoft Access to design and create queries for the purpose of data analysis
• Creating and maintaining support documentation for Kaiser Permanente Sales Cycle reporting platform
• Organized and facilitate meetings with management and development teams
• Actively participated in unit testing, system testing and regression testing. Also provided test cases for User Acceptance Testing.

ENVIRONMENT:

Windows, MS Office, MS Visio, MS Access, MS Project Professional, ASP.NET, Agile, SharePoint, Salesforce

Confidential

Position: Business Analyst

Responsibilities:

• Gathered Requirements, Developed Process Models and detailed Business Policies and modified the business requirement document
• Facilitated JAD sessions to collect requirements from system users and prepared business requirements that provided appropriate scope of work for technical team to develop a prototypes
• Responsible for requirements for overall BI Implementation including integration of SharePoint Performance Point Services and analytics platform of Verde Advisor
• The ad-hoc reporting was done using PowerPivot and Performance Point Services. Various features like Dashboard, Drill downs, Query Filters, Rollups were used. Also involved in designing of data cubes for SSAS which was used as data warehouse. Dimensions and filters were set to allow power users to generate and mine their own reports.
• Also created InfoPath based forms and workflows based on SharePoint Designer.
• Involved in defining of Information Architecture, Site Content Types, Taxonomy, Termstore, Permissions and Feature Sets
• Develop and support executive metrics dashboard reports, analyzed business data flows and create PowerPoint presentations to communicate conclusions to senior management
• Performed Gap Analysis to identify insufficiencies of the current system and identify the requirements for the proposed system
• Participated in various development and Up-gradation projects for the Existing Core Banking Solutions
• Worked on functional and non-functional requirements for system enhancements, upgrades and new features
• Worked directly with development team identify gaps and facilitated functional changes required by change requests
• Worked directly with QA team to review test plans and test scripts during UAT

ENVIRONMENT

Windows, MS Office, MS Access, MS Project, MS Visio, SQL, ClearCase, Agile.

Confidential

Position: Business Analyst

Responsibilities:

• Act as liaison between the business and the technical teams. Interface with vendors. Act as facilitator where required

• Worked directly with senior management to define project scope using feasibility studies, cost benefit analysis, and risk management planning
• Facilitate meetings with business process owners, end-users and other key business members to flush-out business requirements
• Created concise, clear, chaseable business requirement based on stakeholder expectations and business requirements and process design documents
• Develop in-depth knowledge of the structure and content of the information flow across the organization - including tables, views, aggregates, attributes, metrics, indexes, primary and foreign keys, and joins to answer data-related questions
• Developed dashboards and KPI reports that benchmarked and tracked trends in suppliers and customers
• Implemented ETL for data integration between the billing systems and Oracle BI via monthly extracts using T-SQL procedures, DTS and SSIS.
• Implemented complex reports using Crystal Reports and SSRS relied heavily on parameterized T-SQL procedures to generate datasets for the reports.
• Involved in system enhancements and integration with legacy systems and applications
• Build Table Matrix reports using SSRS as per the business specifications and involved in rolling out the reports after UAT signoff.
• Worked with developers to create the functional design specification based on the business requirements and process design documents
• Participated in user acceptance testing with the business users including training documentation and issue tracking log
• Participate in project status meetings throughout the project with stakeholder and business process owner
• Developed training documentation to support the system rollouts and facilitated end-user training in coordination with the company training staff

ENVIRONMENT

Windows, MS Office, MS Access, MS Project, Rational Rose, Quality Center, Waterfall Methodology

Confidential

Position: Business Analyst

Responsibilities:

• Designed, developed and distributed external client facing reports on a monthly, quarterly and annual basis to support the company's performance and cost savings value to the customer
• Conducted JAD sessions for business requirements elicitation
• Wrote' SQL queries tables and joins for data consolidation.
• Analyzed, designed and developed internal departmental reporting to monitor performance against departmental goals as well as client and state regulations
• Management of system tables for cost of drugs, client discounting and future client savings analysis
• Assisted in analyzing future client claims data to rationalize the potential cost savings to be realized by utilizing Express Scripts services

ENVIRONMENT

Windows, MS Office, MS Access, MS Project, MS Visio, UML, JAVA, MS Project Professional, Rational Clear Case, RUP