SUMMARY

• Over 8 years of experience as a Business/Systems Analyst with understanding of Business Requirements gathering, Business Process Flow, Business Process Modeling, Business Rule configuration with various domains which include Healthcare, Life Insurance, Annuities, Retail E - commerce and IT.
• Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Request for Proposal (RFP), Functional Requirement Document (FRD), Functional and Non-Functional Requirements (FNFR document, Software Requirement Specification (SRS) across the deliverables of a project.
• Experienced with Business Intelligence & Analytics (SQL Server Integration services (SSIS), SQL Server Analysis services, Reporting Tools and other business applications.
• Experienced in Data Analysis concepts like Data Mining, Process Mining & Statistical Analysis.
• Proven expertise in creating mapping documents for data feed using XML scripting.
• Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, design, development, testing and deployment and adept with different software development methods like Agile (SCRUM), Waterfall and Rational Unified Process (RUP).
• Experienced in application/product lifecycle management (ALM/PLM both SDLC & Agile) using tools Rational, JIRA and VISUAL STUDIO for tracking requirements, business needs, creating user stories, diagrams, test cases, tickets management.
• Experience is capturing business needs, functional requirements for anti-fraud and information risk, and compliance issues to ensure Information Security during interactions and transactions.
• Experienced in Data Warehouse Environment including Data Analysis, Data Modeling, Data Mapping, Data Integration and Data Migration using ETL tool- Informatica.
• Facilitated JAD sessions, conducted Interviews with users as well as Subject Matter Experts (SMEs) by asking detailed functionality aspect of business process, organizing workshops to drive out detailed business requirements and resolve any conflicting issues.
• Worked with project management tools like MS Project to map the work breakdown structure (WBS) to manage schedules, status reporting and plan resources in line with triple constraint.
• Expertise in conducting Stakeholder Analysis to define process stakeholders, and their roles & responsibilities towards the project.
• Extensive experience with Medicare/Medicaid processing as well as the Claims/Billing.
• Involved in maintaining performing GAP analysis, Requirement Analysis, Document Analysis.
• Good working knowledge of Claims processing, Excellent knowledge of HIPAA standards.
• Experience in developing safety metrics, analyzing warranty claims and claims processing.
• Proficient in analyzing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Sequence Diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio.
• Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users as well as trained users to use the system configured.
• Analytical, methodical and resourceful approach to problem solving, identifying root causes and corrective actions to meet short and long-term business, financial and system requirements.
• In-depth working experience implementing various elicitation techniques - Document analysis, Interface analysis, Prototyping, Brainstorming, Requirement workshops.
• Knowledge of software testing life cycle (STLC) and experienced in preparing test strategies and test plan.
• Conducted functional walkthrough, User Acceptance Testing (UAT) sessions and assisted the development of User Manuals for customers.
• Excellent skills in facilitating Joint Application Development (JAD) for eliciting functional requirements that support the high-level business requirements
• 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
• Experience in Object Oriented Design Technologies and maintain traceability of Requirements using Requirements Traceability Matrix (RTM).
• Strong experience facilitating Triage meetings.
• Experience in using SQL Queries and MS Excel (hlookup, vlookup, Macros, Pivot Tables, etc.) for Data Validation and Data Integration.
• Excellent verbal/written communication skills and strong analytical abilities and can perform well both independently and as a team player.
• Good working knowledge of Microsoft Office Suite including - Word, PowerPoint, Excel, Access, MS Visio, Rational Rose, Rational Requisite Pro.

TECHNICAL SKILLS

Methodologies: RUP, UML, Agile, Waterfall, Scrum.

Standards: HIPAA, EDI, CMM, ICD-9, CMS forms.

Tools: MS Project, MS Visio, MS Excel, MS Office, MS Access, SQL, SSIS, Rational Requisite Pro, Rational Rose, ASP.NET, C#, JIRA, ServiceNows.

ETL Tools: Informatica Power Center.

Testing Tools: TOAD, SQL* Plus, Rational Clear Quest, Rational Test Manager.

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Data Analysis, Data Modelling, Data mining.

PROFESSIONAL EXPERIENCE

Systems Analyst

Confidential, Eden Prairie, MN

Responsibilities:

• Conduct meetings involving business and tech resources to identify and resolve any issues.
• Create requirement documents, data flow documents, error reports, mapping documents, process documentation, DFDs, presentations, pivot charts, filter reports etc.
• Gather and involve resources from multiple teams to map the data flow in the process.
• Create data mapping and data flow documents to help resources track the data.
• Identify data format and structure using the layout documents from multiple systems to ensure successful data flow to implement Business rules.
• Conduct bi-weekly system synchronizing runs in multiple systems.
• Look into member details and generate ad-hoc reports that support an issue.
• Logically analyze data flow among internal systems to identify and understand the discrepancies.
• Make sure the file transfer is done in time and establish controls at various check points to ensure the data transferred has supported the format, logic, count, type and frequency.
• Also assist business to understand technical specs and translate business needs to technical resources.
• Compare demographic and eligibility Data between CDB & ORx and list out all the mismatches and errors. Do end-to-end testing by re-triggering the error records from source and keep track of the transactions.
• Make sure the records sent from source are being loaded on Confidential ’s internal system and list out errors from NRT exception reports.
• Facilitate meetings and participate in investigating reasons behind these errors.
• Assist technical support team to develop a plan for establishing controls to automate the process of compare and re-trigger.
• Make sure the proper controls are established fix the errors and eliminate any future discrepancies.
• Conduct GAP Analysis and created the GA document to perform paper prototyping for establishing controls by creating inventory and opportunities for controls to support rules and configuraiton.
• Project management and resource allocation from different time zones to ensure that the controls being developed meet the requirements of the client.
• Conduct user sessions and created user stories based on the requirements gathered in user sessions.
• Use MS Visio to create Workflow Diagrams, DFDs and Activity Diagrams.
• Fix errors in claims processing, perform data reconciliation and data clean-up.

Environment: Windows 7/2000/XP, Microsoft Office SharePoint 2007, Outlook, CDB, ServiceNow, Agile, Rational Requisite Pro, Excel, MS Office, SQL Server 2008, MS Access, MS VISIO.

Business Systems Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Performed document analysis and reverse engineering to understand legacy system.
• Conducted GAP Analysis and created the GA document to perform paper prototyping for the interface and usability purposes.
• Performed effective project management and resource allocation to ensure that the application being developed met the requirement of the customer in terms of quality and schedule.
• Created high level list of user requirements and prioritized them.
• Captured in creating Functional and Non Functional requirements.
• Successful creation of a mapping document for data feed automation.
• Data analysis and metrics study for reporting requirements.
• Conducted user sessions and created user stories based on the requirements gathered in user sessions.
• Organized and conducted product-planning meetings, sprint planning meetings, mid-week meetings.
• Capture Business needs and scenarios and create user stories for firewalls, intrusion detection and encryption using compliance and information security standards for safe transactions, secure payment and money settlement as per business rule configuration.
• Facilitated daily scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the accomplishments and issues.
• Used MS Visio to create GUI elements, Workflow Diagrams, Activity Diagrams.
• Facilitated JAD (Joint application development) sessions and walkthroughs between technical and regulatory teams for meeting requirements.
• Provided Data Mapping expertise and created Logical Data Models.
• Involved in System, Regression, Performance, Integration and UAT testing and documentation of the project life cycle.
• Conducted training sessions for users and also prepared user manuals for better understanding of the designed system.
• Derived the incremental extraction and load logic for each target table based on the source data.

Environment: Windows 2000/XP, Microsoft Office SharePoint 2007, Agile, Rational Requisite Pro, MS Office, SQL Server 2005, MS Project, MS FrontPage 2003, MS Access.

Senior Business Analyst

Confidential, St. Paul, MN

Responsibilities:

• Facilitated collection of functional requirements from system users, and prepared business and technical requirement specification documents.
• Interacted with the Subject Matter Experts (SMEs) and stakeholders at the JAR session, gathering business requirements to get a better understanding of client’s business processes.
• The Agile-scrum SDLC was used and I participated in writing user stories to track requirements and used SharePoint to share and maintain the document versions.
• Created Use Case Diagrams, and Use Case Specification document (USD). Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims Payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment from a health plan).
• Prioritized project efforts, developed project plans and process flows to support business process and rule configuration.
• Researched the existing client processes and guided the team in aligning with the HIPAA rules and regulations for the systems for all the EDI transaction sets.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Performed OLAP and ETL for storing analytical data in the database and helped the DB team in performing data analysis.
• Used Unified Modeling Language (UML) for process modeling and use cases.
• Generated daily, weekly, and monthly reports using MS Office Tools and submitted to the Team Leads and Manager for reporting, status reporting and analyzing purpose.
• Developed gap analysis document, logical and physical design and remediation plan.
• Captured, communicated, managed system requirements and maintained requirement tractability matrix to keep team members up to date with the latest testing results.
• Responsible for training and testing of transactions.
• Analyzed existing procedures and reported to management to improve productivity.
• Investigated faults within the application and interacted with the development team and testing team to resolve technical issues.

Environment: Agile-scrum, MS Project, MS Office Suite, SQL, UML, MS Visio, Requisite Pro, Clear Case, Rational Clear Quest, JIRA, Visual Studio, C#, ASP.Net, ETL.

Senior Business Analyst

Confidential, Reston, VA

Responsibilities:

• Involved in business analysis, coordinating between the team members, and was involved in each phase of SDLC (Agile-scrum) to ensure valid business requirements. Created full life-cycle documentation from product requirements in the developmental stage to functional specifications.
• Held JAR sessions with various groups including business owners, subject matter experts and marketing team, for effectively gathering requirements assuring that business objectives and priorities are aligned.
• Performed Gap analysis, designed new process flow, documented the business process, various business scenarios and activities of the business from the conceptual to procedural level.
• Expertise in creating safety reports, adverse event management and reporting, Protocol designing and regulatory requirements.
• Effectively understand the operations and business problems of the organizations and effectively gather requirements.
• Followed the Agile-scrum methodology for the entire SDLC.
• Created Use case scenarios according to business needs and specifications and Implemented UML methodologies to design Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Assure the Traceability of application functional, performance, and security requirements to the business process steps.
• Used SQL queries and Data Modeling Techniques to work on the databases and to find out their dependencies.
• Involved in the Data mapping and Data Modeling, and documented the data architecture of the databases to notify the SMEs’. Used ETL process in helping the DB team in data migration.
• Produced and managed documentation on release activities to support problem resolution.
• Reviewed and evaluated all the modules of the software before delivery to users to confirm meeting the standard criteria. Performed basic UAT with the different customers and different business modules. Interacted with developers and various members of my team to discuss and resolve defects and their priorities.

Environment: XML, MS Visio, SQL, MS Word, MS PowerPoint, MS Access, MS Visio, Rational Req Pro, Visual Studio, ETL.

Business Systems Analyst

Confidential, San Francisco, CA

Responsibilities:

• Performed document analysis and reverse engineering to understand legacy EMR system.
• Conducted GAP Analysis and created the GA document to perform paper prototyping for the interface and usability purposes.
• Performed effective project management and resource allocation to ensure that the application being developed met the requirement of the customer in terms of quality and schedule.
• Created high level list of user requirements (Product Backlogs) and prioritized the list of product backlog items (PBI’s).
• Conducted user sessions and created user stories based on the requirements gathered in user sessions.
• Organized and conducted product-planning meetings and mid-week meetings.
• Facilitated daily scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the accomplishments and issues.
• Used MS Visio to create GUI elements, Workflow Diagrams, Activity Diagrams.
• Facilitated JAD (Joint application development) sessions and walkthroughs between technical and regulatory teams for meeting requirements.
• Provided Data Mapping expertise and created Logical Data Models.
• Involved in System Regression, Performance, Integration and UAT testing and documentation of the project life cycle.
• Conducted training sessions for users and also prepared user manuals for better understanding of the designed system.
• Derived the incremental extraction and load logic for each target table based on the source data.

Environment: Windows 2000/XP, Microsoft Office SharePoint 2007, Agile, Rational Requisite Pro, MS Office, SQL Server 2005, MS Project, MS FrontPage 2003, MS Access

Business Analyst

Confidential, Plano, TX

Responsibilities:

• Successfully gathered requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications
• Managed the online Master Data Management request tool for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Completed large database cleanup projects to insure data integrity.
• Managed the team and tasks as well as schedule using Team Foundation Server.
• Conducted JAD sessions, communicated and maintained strong working relationship with various business groups and owners in preparing the user Story.
• Conducted technical training session regarding agile development methods.
• Identify and capture Information & Data risk and also functional requirements for firewalls, virus detection, intrusion detection and encryption using information security regulations and standards from internal discussions.
• Participated in meetings, technical discussion, reviews and release planning.
• Provided technical assistance during project planning and demonstrations.
• Formulated, implemented and maintained tools and practices.
• Prepared and coordinated project proposals and schedules.
• Generated periodic peer review reports for project managers.
• Prepared High Level and Detailed level requirements for Select Solutions.
• Worked with the cross functional teams in gathering the requirements.
• Scheduled meetings to review the Detailed Level Requirement with the cross functional team for approvals.
• Created Requirements Traceability Matrix to map the detail requirements, design and test cases to track the requirements.

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), AGILE, ETL, Rational ReqPro, SharePoint, UML.

Business Analyst

Confidential, Louisville, KY

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 Confidential services.

Environment: Windows, MS Office, MS Access, MS Project, MS Visio, UML, MS Project Professional, Rational Clear Case.

Business Analyst

Confidential

Responsibilities:

• Assisted in JAD sessions with stakeholders, business users at various phases of Software Development Life Cycle (SDLC) to discuss and resolve issues.
• Interacted with the Subject Matter Experts (SME's) and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Gathered Business Requirements and wrote Business Requirements Document (BRD).
• Assisted in developing Use Cases using MS Visio, and a detailed project plan with emphasis on deliverables.
• Worked with QA team to review Test Plans and Test Cases.
• Conducted User acceptance testing to make sure the final review of product.
• Worked on documentation for end user training and conducted end-user training.
• Designed screen layouts and navigational features.

Environment: Windows 2000, MS SQL, MS Visio, MS Project, MS outlook and MS Office Suite and Power Point.