SUMMARY:

• Sr. Business Analyst professional with around 8 years of work experience.
• Experienced in gathering user requirements, analyzing and preparing Project Deliverables such as Project Charter, Business Requirement Document (BRD) and Functional Requirement Document (FRD) and proposed changes for process improvement using Rational Requisite Pro.
• Demonstrated ability to work actively in different phases of Software Development Life Cycle (SDLC) using Waterfall & Agile.
• Proficient in transforming Business Requirements into Functional Specifications, focusing on workflow analysis and design, business process reengineering, user interface design, portal design, and process flow modeling.
• Highly proficient in working with Users and Stakeholders to elicit, analyze, communicate and validate requirements using JAD, JAR, and Brainstorming sessions.
• Comprehensive understanding of the Organizational Framework that help to map the AS - IS and TO-BE model using the GAP Analysis, and plan effective approach to build/buy solutions to the business problems/needs/opportunities.
• Skilled in Object Oriented Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, Object Diagrams, State Diagrams, Sequence Diagrams, Unified Modeling Language (UML) using MS Visio and Rational Rose.
• Expertise in Client Relationship Handling, Project and Release Management, Configuration and Change Management, Defect Tracking and Control.
• Solid experience in defect reporting using Test Director, Quality Center and JIRA.
• Excellent skills in Process Flows and Swim Lane Diagrams.
• Proficiency in writing SQL Queries to extract data from databases.
• Sound knowledge in conflict management and configuration management.

WORK EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Business Analyst

Responsibilities:

• Reconciled discrepancies efficiently and in a timely manner for customers. Tracked and maintained accounts to identify any discrepancies. Conducted research and investigation of all discrepancies.
• Facilitated Bloomberg Terminals to identify the key data needed to be analyzed, built out the interface/data repository and built out the reports.
• Analyzed, interpreted, updated & maintained various asset classes, i.e., Equity, Fixed Income, Funds, Derivatives, Money Markets, Corporate Action Events, etc. and effectively communicated with internal and external clients to deliver functional requirements like GUI, screens and interface designs.
• Coordinated JAD sessions with Stakeholders, End Users and SMEs to determine the critical business processes and identified key functional requirements.
• Interacted with the project team to define system objectives and scope, and identified constraints and the measures of success for the CRM system to be developed.
• Facilitated ITIL so that IT services were aligned to the needs of the business and supported its core processes.
• Gathered data requirements for the CRM system by interacting with the users and data administrators.
• Involved in GAP Analysis, Risk Analysis and Technical Feasibility study with the technical leads and other SME's.
• Created and managed all the requirement artifacts in CaliberRM.
• Performed Functional and UAT testing before the system went live. Managed change requests using JIRA.
• Defined the data sources, data loads and data transformation using ER Diagrams.
• Authored Data Flow Diagrams, Use Case Diagrams and Business Process Models with special detail to Sub-Processes.
• Designed message formats, queues, systems interfaces, and worked with the Business Users through interviews and JAD sessions.
• Performed review, preparations, CCAR validation and CCAR Quality Assurance and took key initiatives to identify data gaps and potential areas of improvement in report preparation process for Basel Compliance.
• Involved in the CCAR data analysis and reporting and designed packages with various complex transformations such as derived column, conditional split, lookup, aggregation, executing SQL task.
• Mapped business functions underlying data and data models, performed data reconciliations, GAP Analysis at function and data level for CCAR reporting.
• Facilitated the analysis and design phase, documented customizations, wrote test scripts for all processes and customizations, coordinated system test and tracking issues, and coordinated the cutover process to Production.
• Developed and integrated model strategy to support business initiatives and regulatory compliance.

Environment: Windows 8.1, MS SQL Server, MS Visio, MS Project, MS Office Suite, UML, HP AML, HPQC Mobile Web App, JIRA.

Lead Business Systems Analyst

Responsibilities:

• Held regular meetings with the business to provide project updates and to align on priorities.
• Conducted clarification meetings with the Business/Stakeholders for all projects.
• Conducted GAP Analysis on new business requirements to update existing functionality and identified pros/cons of the change.
• Extracted data from analytical tools for marketing and operations to assess pain points on the application.
• Partnered with Business Stakeholders to ensure their requirements and expectations for the project were met.
• Led daily calls with the tech team to ensure the requirements were properly clarified.
• Identified project risks and mitigation plans to overcome any risks identified.
• Partnered with the tech team to align on technical approach for business requirements.
• Documented the business requirements for the Dev and QA team so the handover was properly conducted.
• Managed, developed, and maintained a beta testing process to ensure quality of the product release to the public.
• Monitored Production Support to ensure customer satisfaction and quality of product by engaging with the customer service representatives.
• Documented customer services representative manuals for new products/features so the customers can be properly assisted.
• Provided training to the Customer Service Representatives for back end tools and products.
• Coordinated with the infrastructure team to set up proper environments for development, testing, and production.
• Partnered with Compliance and Legal to ensure KYC, BSA/AML, and legal regulation requirements were met on our public facing products.
• Partnered with ITRM to ensure security of customer information by establishing authentication process.
• Coordinated with third party vendors to ensure all service related queries were resolved.
• Involved in data migration project and platform consolidation project to implement replace legacy system.

Environment: CRM 2015, CRM 2011, .Net 3.5, TFS 2013, TFS 2015, JavaScript, JQuery, HTML, CSS, SQL 2012, Windows 7, MS Visio 2010, HUB, Omniture, Google Analytics.

Business Analyst

Responsibilities:

• Prepared Business Requirements Documentation (BRD). Facilitated Business/Technical JAD sessions and documented business requirements. Developed Business/IT current and future states.
• Documented Test Data and Capella mapping documents.
• Wrote complex SQL queries to populate data from different tables which can be used for other packages.
• Designed table using various SQL statements like joins (inner join, right join, left join and cross join) primary keys & foreign keys.
• Designed the flow of feeds into the Database and then into CMS and finally to Users.
• Documented Capella Light application functional specification document.
• Worked on Version One User Stories for business requirements and conducted UAT.
• Created Access database for manual file processing/member data load (Membership, Hospitalization, Lab Files etc.) to Capella.
• Conducted IT Impact Assessment. Worked with DEV, QA teams for effective Implementation.
• Conducted Conceptual Design Sessions and worked closely with the technical team for systems current and future state.
• Conducted BA/Data Warehouse Brainstorming Sessions.
• Created Database of Capella Premium -18 roles including every screen for re-write and enhancements.
• Performed analysis of pending enhancements/request for UI updates and prioritization with Team.
• Performed Gap Analysis and worked on BRD re-estimates.

Environment: MS Office, MS Visio, Rational Requisite Pro, Rational Rose, Rational Clear Case, Rational Clear Quest, RUP, UNIX, Windows.

Business Analyst

Responsibilities:

• Gathered Business Requirements by using HIPAA EDI guides and reviewing or interviewing business process owners and companion guides.
• Worked on medical and pharmacy claims data, eligibility and member enrollment process.
• Created and maintained HIX Compliance documentation and educated other team members about regulatory compliance with all government agencies (including HIPAA) involving the Obama Care.
• Prepared and updated the Business Process Flow, Functional Requirement Document (FRD) and Technical Specification Document (TSD) for enhancing the existing product.
• Worked with data warehousing team to create Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools.
• Worked on different EDI transactions like Claims (837), Premium Payment (820), Enrollment (834) and Eligibility (270) to send outbound file to external vendor.
• Responsible for calculating ROI and evaluated other financial aspects.
• Worked on FACETS modules such as pricing, payer, eligibility under claims processing system.
• Created Use Cases Diagrams and Business Process Workflows using Visio.
• Prepared and performed testing on Algorithm of PPO plans for large group exchange standard products.
• Conducted JAD sessions between the end users and the development team.
• Performed User Acceptance Testing (UAT) and reported the bugs to the development team.
• Conducted project related presentations and provided reports to the higher management.
• Created Test Cases using HP Quality Center.
• Worked with the testers and maintained the Test Plan document and Test Cases.

Environment: FACETS, SQL/Oracle/DB2, UML, Windows, MS SharePoint, MS Office, Soarian eCube Clinicals, ChairSide, Acumen, My eCube Rounder, MS Project, SharePoint, Outlook, HP ALM, MindMaps, MS Visio.

Business Analyst

Responsibilities:

• Utilized Agile software development methodology to manage and control software and product development.
• Documented business functionality requirements in User Stories.
• Collaborated with the Product Owner on project/roadmap planning, facilitated daily stand-up meetings, reviews, retrospectives, sprint and release planning, demos and other Scrum-related meetings.
• Performed Business process modeling, A/B testing to understand the shortcomings of the existing information system.
• Coordinated cross-functional process development and identified opportunities and improved process.
• Analyzed Business Requirements and created Use Cases, Use Case Diagrams, Navigation Flow, Business Flow Diagrams and Work Flow Diagrams for applications and created Activity Diagrams/State Chart Diagrams using MS Visio.
• Conducted many informal sessions to develop an architectural solution to confirm that the application met the business requirements, resolved open issues, and handled change management requests.
• Developed AS-IS and TO-BE Business Process Models for complex processes by analyzing the current processes, and gathering information from SME's.
• Arranged sprint grooming, planning, daily scrum, sprint demo, and sprint retrospectives.
• Managed the product backlog with User Stories through progressive refinement applying business prioritization, solution approach, and technical delivery considerations.
• Conducted walkthrough sessions to discuss certain issues with stakeholders, architectures and design & development teams and performed GAP Analysis.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Managed product backlog within JIRA, and project information and artifacts using Confluence.
• Regularly interacted with the Testing team for executing the Test Plans, providing Test Data, creating Test Cases, and resolving issues upon detection of bugs and collecting the Test Metrics.
• Assisted QA team with User Acceptance Testing, developed and maintained quality procedures ensuring that appropriate documentation was in place.

Environment: MS Word, MS Excel, MS PowerPoint, MS Outlook, MS Project, MS SharePoint, RUP, SQL.