Sr. Business Analyst Resume
Tampa, FL
SUMMARY
- Around 8 years’ Experience as Business Analyst in IT, Project Management, Business Process.
- Strong business acumen, strategic thinking, verbal and written communication, interpersonal and presentation skills.
- Extensive experience in Banking/Financial, Insurance, Point of Sales (POS), Mortgage, Healthcare Domains with extensive exposure to gathering & analyzing end business user requirements.
- Design and review of various documents including the Software Requirement Specifications (SRS), Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and Testing Documents.
- Performed stakeholder analysis and assisted in interviews with the SMEs (Subject Matter Experts) to identify the key players for project success and gather requirements accordingly.
- Detailed knowledge of capital markets, commodities, derivatives and innovative financial instrument. In - depth knowledge of structured finance, securitization process, stock market and options trading strategies.
- Exposure to Master Data Management (MDM) while working on its various processes such as data collection, reference data, data storage, data analysis, data transformation.
- Experience with health care Systems: FACETS, NASCO. TPS, ITS (Interplan Teleprocessing Services), QNXT, Medicare Part A, B, C, D and Medicaid systems.
- Experience in using Facets support systems to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835 /271 transactions.
- Good experience in SDLC Methodology for developing HIPAA EDI applications used by hospitals to completely automate payments posting for Medicare, Medicaid and commercial payers electronic payments files
- Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center/ALM, Clear Quest, TFS - Team Foundation Server, Rally.
- Solid business Data Analysis, Data Mining, Data Migration, Data Mapping, Meta Data and Reconciliation experience.
- Experience in end-to-end testing, UAT (User Acceptance Test) and User Training for Customers.
- Experienced in developing Test Plans and Test Cases based upon business requirements.
- Experience with using Structured Query Language (SQL) in Databases like Oracle and SQL server
- Expertise in Maintenance/creation/updation of Rules in Business Rules Management System (BRMS) - ILOG, DROOLS
- Amendment on bank’s trading activities and capital requirements including Basel II, Basel III.
- Ability to organize, document and track changes and defects by Requirement Traceability Matrix, using Rational Requisite Pro, Clear Quest, Clear Case.
- Knowledge of Object Oriented Analysis and Design using UML, SDLC, Agile, Scrum, Rational Unified Process, Rational, Requisite Pro, Rational Clear Case, MS Office Suite, MS Project (for Project Plan), and MS Visio.
- Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, Architects, SME’s (Subject Matter Experts) and Managers of various Business Units.
- Participated in business and technical design sessions with DBAs and Developers.
TECHNICAL SKILLS
Requirement Management Tools: Rational Requisite Pro
Modeling Tools: Rational Rose, UML, MS Visio, Visual Paradigm
Technical Modeling Tools: MS Excel (Advanced including Macros), SQL, Markit WSO Portfolio Management, SPSS Analytics Tool
Project Management Tools: MS Project, Primavera
Content/Document Management Tools: SharePoint
Testing tools: WinRunner, Quick Test Pro, LoadRunner
Change Management/Defect Tracking tools: Rational ClearQuest, Clearcase, Flowcharting
Reporting Tools: Crystal Reports, Rational SoDA
Utilities: MS Office Suite, LotusNotes
Methodologies: SDLC(RUP, Spiral, Waterfall, Agile Scrum, Hybrid), SWOT, Gap Analysis, Cost/Benefit, Root-Cause, Stakeholder Analysis
Project Management Techniques: CPM, PERT
Databases: Oracle 11g, SQL Server 2005/2008, MS Access, DB2,MS-Excel
Languages: VBA, PL/SQL, VB, C++, HTML & XML, JAVA, MS.net
Operating System: Win 95/98/2000/2007/ XP/Vista/7/8
Source Version control: Subversion, client (tortoise SVN), CVS
PROFESSIONAL EXPERIENCE
Confidential, Tampa, FL
Sr. Business Analyst
Responsibilities:
- Interacting with SME’s and key stakeholders for understanding and gathering the business requirements.
- Analyze and Understanding the business model concepts, business systems development. business process re-engineering and,
- Involved in providing high level estimates on the project level and sprint team level and setting up meetings with different sprint teams for the BRD breakdowns and collecting high level estimates.
- Preparing the Impact Matrix (IM) by identifying the Application function, Impact Type, Dependencies, Priority and Application Impacted on requirement-by-requirement basis of each project.
- Played Key BA role in “Documents Sprint Team”.
- Worked as SME for a project, worked closely with various job families throughout the life cycle of the project (Requirements gathering to Production Release and Support).
- Worked as POC for a project Expere (50,000 hours). Responsible for communicating to vendors and Internal Job families for requirement elicitation and any impediments in the process of the project life cycle.
- Assisted in laying out the architect for cash and liquidity management models and cash flow & collateral models.
- Worked as SCRUM MASTER as on when required for sprint. Experienced in running scrum calls and gather information of impediments of the team and escalating them to S2 and S3 meetings.
- Had vast experience in interacting with vendors to meet the requirements on Time.
- Assisting Scrum Master in Task creation and assignment in the TFS system
- Used Agile software development methodology in defining the problem, gathering requirements, writing functional and technical specifications, business modeling and communicating with the technical team for development of the system.
- Provide Support and assistance to QA in testing functional requirements and DEV in unit testing and providing them directing during the code deployment.
- Review and approve the test scenarios of the QA team by paying attention to details.
- Defects triage by understanding issues and tenaciously seeking quick, creative solutions to meet business requirement.
- Interacting with different vendors and Third party application information owners to make sure the changes are correspondent with their expected inputs and keeping track of the delivery dates from both side (Vendor and Mortgage Express Team) to be in synchronization so that the existing functionality is not broken during the development phase.
- Assisting Backlog Owner (BO) in tracking and the keeping the work in backlog with their right priorities and considering the dependencies between different sprint teams, across different projects.
- Involved in preparing Logical Process Model, which help users understand/analyze the various business processes, pin drop.
- Performed integration testing to check that changes made in system reflect the actual ask and meeting the expectations of the key stakeholders.
- Uploading the functional requirements in ALM and tracing them back to business requirements, tracking the traceability reports to make sure that the tracing is 100% complete including the tracing of QA scripts to the functional requirement.
- Exposure to Drools components to support the Development team and Testing team to make configuration changes effectively using business rules and business logic management.
- Functioned as the primary POC between the Business/Finance team and the Technical team and Third Party Vendors.
- Conducted scenario review, and walkthrough the scenarios with SME’s and Business Owners.
- Performed User Acceptance Testing (UAT), experienced in Conducting Defect Triage Meeting with SME’s, Business Owners and compliance to walk through the defects raised.
- Wrote Test Scripts and executed them manually.
Environment: Windows 2000/XP, JIRA, Agile, Drools 5, MS Office, MS Project, MS Access, XML, X-Bert, Data Warehouse, WebEx, SharePoint, Progress.
Confidential, Minnetonka, MN
Sr. Business Analyst
Responsibilities:
- Gathered business requirements from the Business team and generating system workflows.
- Design Impact Analysis Documents (IADs) for GL- AP, GL-AR Summary - Reconciliation and other high level Business Reports Requests.
- Involved in creating the targeted questionnaire for SMEs and Business users for elaborating requirements.
- Initiated with a comparison report of migration of . 270 Eligibility, Coverage or Benefit Inquiry (V4010X092A1) vs. 270 Eligibility, Coverage or Benefit Inquiry (V5010X279), 278 Prior Authorizations
- Validated the EDI 837-claim billing (professional, institutional and dental claims) & 835 (remittance advice or payment) claims adjudications.
- Worked on the existing mainframe system to understand the code written in COBOL, documented the system requirements from the COBOL code and came up with
- Participated in JAD sessions / conducted interviews for analyzing business requirements and reviewing them with business and technical teams.
- Actively involved in creating/updating Work Breakdown Structure (WBS), preparing deliverable tasks in the project plan.
- Designed and developed Use Cases and UML models using Microsoft Visio.
- Developed current and future state workflows of Ambulatory practices in MS Visio.
- Prepared the cost estimate for the business analysis involvement of the project.
- Prepared the BRD and conducted reviews with the stake holders.
- Writing change requests & follow up with the respective teams on the impact and action.
- Reviewing the test cases and requirement traceability matrix along with the testing team.
- Tracked the project status in MPP, prepared the project status reports and represented the BA team in the PMO meetings.
- Wrote Test scenarios and test cases for testing the migration of EDI and the processing of member enrollment and benefits, batch jobs corresponding to the claims (837) and real time transactions like 270/271/276/277.
- Involved in forward mapping from ICD 9 to ICD10 and backward mapping from ICD10 to ICD9 using General equivalence Mappings (GEM).
- Involved in Customer UAT along with the Development & testing teams.
- Assisted the PM in setting up realistic expectations and in evaluating the impact of change requests and risks and conducted project related presentations.
Environment: MS Visio, MS Project, MS Office Suite, (Word, Excel, Access, Power Point, Outlook). Sybase, SQL Server, FACETS 4.41 & 4.51, Agile, DB2, .NET, SAS, Lotus Quickr, IBM Process Modeler, Windows XP, UML, Mercury Quality Center.
Confidential
Sr. Business Analyst
Responsibilities:
- Worked in an agile environment with daily scrum meetings, burn-down charts, presentations, project monitoring and reporting.
- Co-authored Business Requirements Specification (BRS), Use Case Specifications and Change Request documents to meet client’s requirements.
- Identifying and documenting Business Requirements on a more detailed level where developers can interpret, design and develop application with minimum guidance.
- Supporting the development team during implementation (e.g., clarifying issues related to the requirements, validating business rules )
- Supporting testers in preparing test cases at the business level and validating the resulting work products.
- Had watched over Web design GUI requirements and workflows.
- Designed screen mockups and navigation to ensure that the functionalities are captured and presented as per the requirement document.
- Generated new product ideas.
- Used XML to create Web-based tools for transactional analysis on SQL database.
- Analyzing and documenting change requests for the requirements
- Managing any required changes to the requirements resulting from detected defects, needs for new or extended functionality, etc .
- Verified the functional aspect as per the Business Process and validated the interfaces with the other systems.
- Communicated and interacted on a regular basis with the development team during different stages of the project.
- Created and maintained Product Backlog Items (PBI) and user stories to capture business requirements.
- Developed action plan to correct deficiencies within scope of requirement; developed and maintained documentation regarding system functionality.
- Trained new employees on basic skills of business application.
- Assist entry-level testers on reviewing requirements, preparing test cases and report software defects.
- Completed thorough testing for the entire SDLC process
- Created Maintenance Transition Document for future users
- Created documentation for training the end users.
- Documented Test plans, Test cases, Test execution, Test summery reports, Installation, troubleshooting and maintenance procedures.
- Supported User Acceptance Testing and performed Assembly, System Integration and User Acceptance testing. Dedicated a good portion of time with QA team in front-end and back-end performing Regression testing
- Worked on Visio to support requirement documentation with flow diagrams.
- Attending Team (Scrum) Meetings, Bi-weekly Product Meetings and technical discussions.
- Excellent soft skills; team spirit, leadership qualities, communication skills and interpersonal skills
Environment: MS-Word, MS-Excel, MS Visio, MS PowerPoint, MS Excel, XML, Quality Center 10, UML, Moqups.
Confidential, Greenwood Village, CO
Business Analyst
Responsibilities:
- Gathering requirements from Business Line Mangers and SME’s for the redesigned Confidential Financial Client Portal, Client Database and to Digitize the Transactions.
- Perform system and document analysis to understand the current systems.
- Develop Process Model and detailed Business Policies and documenting the same in Business Requirement Document.
- Prepare High Level Process Flow Diagrams and Business Process Flow diagrams for Confidential Financial Client Portal functionalities in Visio.
- Develop Use Case diagrams, Use case Narratives and User Stories.
- Administered Identity and Access Management (IAM) (including password management) controls for staff and vendors assigned to department-level projects.
- Prepare Wireframes, Prototypes and Mock up screens for different web pages.
- Develop Customer Database Mapping Document and Digital Transactions Mapping Document to map all Policy Administration Systems.
- Identify the required fields for Client Database from Client extracts and Contract extracts from different Policy Administration Systems.
- Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints, also created a Business Requirement Document for management.
- Created and Managed User Stories in Epics, Themes and Sprints; also calculated velocity and Story-points in TFS. (I was also part of the team that assessed and analyzed TFS, HP Agile Manager and Green Hopper as Agile ALM tool
- Coordinate with offshore team in documenting the gathered Requirements in to BRD’s and FRD’s.
- Interact with SOA architects for developing Integration Service Bus(ISB) & Enterprise Service(ESB
- Worked closely with System Architect to implement Service Oriented Architecture (SOA), Client side Validations, Server side Validations, Web Method definitions and data modeling.
- Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
- Develop Service Mapping Documents to map UI Literals to Administration Systems.
- Help developers understand Business Requirements and design for Graphical User Interface (GUI), Client Database and Digitize Transactions.
- Coordinate with QA team to determine and develop Test Plans, Test Cases and methods for Unit Testing, Integration and Functional Testing based on testing requirements.
- Participate in User Acceptance Testing (UAT) and developed Training Manuals.
- Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.
- Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
- Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
- Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.
- As part of MDM implementation, involved with validating and testing user accounts; validating the suspect and collapsed data; Created dummy accounts to validate against the back-end and the front-end data.
- Created new ETL process to extract, transform and load data from different sources to data ware house.
- Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data.
- Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.
- Perform data validation using SQL queries and run ad-hoc queries to show data to the business users.
Environment: Business Objects, Cognos 8.4, Informatica, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer, IBM Master Data Management (MDM)
Confidential - Newport Beach, CA
Business Analyst
Responsibilities:
- Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
- Conducted and Managed JAD sessions with SMEs and Business departments, for planning and requirement gathering
- Gathered Business Requirements, created Functional Requirements (FRD) and analyzed data/workflows to define the scope, project financials and progressed from problem statements to well documented designs.
- Documentation of the AS-IS and TO-BE process for current and future phases of the Claims Management System
- Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
- Gathered requirements for Policy Admin, Claims and Billing module for Non-Standard Auto, Home Owners, and Worker’s Compensation policies.
- Created a file of ACORD Forms for both Personal and Commercial Lines of Business used as the standards in all Property and Casualty markets.
- Worked as a Personal Lines Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design
- Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
- Documented and delivered Functional Specification Document, DD Documents and various other documents needed for the project team
- Conducted JAD sessions for communicating with Stakeholders and Project delivery heads.
- Developed business requirement specification documents as well as high-level project plan
- Developed timelines for Project delivery and Managed projects/resources
- Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
- Provided Training, UAT and Product support
- Involved in the creation for Manual Raters for Auto products
- Monitoring the Configuration and Customizations activities
- Change Management
- Worked as a Single point of Contact for Offshore and Onsite Model.
Environment: s: Windows NT/2000, MS SQL Server, Rational Unified Process (RUP), Facets 4.21, UML, Rational Rose, Mercury Test Director and MS Office Tools.
Confidential
In-tern/ Business Analyst
Responsibilities:
- Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
- Worked as Data Analyst, Involved in requirements gathering to study the existing system which will help in the designing process for the proposed systems.
- Involved in Requirement Analysis and understanding of business analysis and creating a design work flow.
- Designed ER diagrams and created level 3 Process models.
- Supply Chain modeling and advice on Planning Systems.
- Created Logical/Physical Data models, defining attributes and Relation using the ERWIN 3.5.
- Created database objects like tables, views, procedures, packages using Oracle tools like PL/SQL developer and SQL* Plus.
- Validating Data before the ETL Process and after the data are loaded to Data warehouse.
- Designed and developed a custom package which extracts supplies used by the customer, information about current stock in inventory.
- Created and worked with different database objects like Sequences, Synonyms Indexes.
- Provided programming and business analysis support for the design, development, and application testing.
- Developed Use Cases for all the External /Internal Trigger events.
- Administered and maintained Concord e-health, an enterprise NMS server
- IP address management as the network consisted of large no. of nodes, switches, L3 switches and routers.
- Performed risk analysis, feasibility analysis, and gap analysis
- Made monthly MIS reports that consisted of various network parameters like downtime, load, delay, bandwidth usage etc. using reporting features of Concord e-health NMS.
- Team member in various video conferencing events, worked on Polycom, RAD and Tandberg video conferencing endpoints.
- Designing, implementing and supporting networks, maintaining, updating the LAN diagrams of the site. Managing IP allocation and ensuring minimal downtime of machines.
- Responsible for client connectivity, ODC maintenance, LAN monitoring, LAN establishment.
Environment: OOAD, BPM, UML, Java J2ee, Windows XP, MS Visio, MS Project, MS Office, MS SQL Server, SharePoint 2007