Business System Analyst Resume
Hartford, CT
SUMMARY
- Business Analyst professional with over 8 years of experience in Investment and Banking, Insurance, Mortgage and Healthcare industry
- Solid understanding of Software Development Life Cycle (SDLC) processes including requirements gathering, analysis and design, development tools and technologies, release and version control, contemporary testing methodologies and deployment management
- Experience working with various industry standards: Software Development Life Cycle (SDLC), Rational Unified Process (RUP), Agile Methodology, Capability Maturity Models (CMM), ISO 9001 Quality Management Systems and Six Sigma (DMAIC) Methodology
- In - depth understanding of Project Management Practices and Principles including Time Management, Budget Management, Resource Management, Risk Management and Change Management
- Experience in conducting GAP analysis, Impact analysis, SWOT analysis, Cost benefit analysis and ROI analysis
- Excellent analytical skills to understand the business process functionality and to translate them to Business Requirement Specification and System Requirement Specifications
- Experience in implementing Rational Unified Process Methodology using Rational tools, working with Agile Development methodology by implementing and delivering Business Processes in iterations
- Experience in leading successful JAD session for performing gap analysis, deriving functional/non-functional requirements and document decisions on the future state of the systems and processes
- Excellent knowledge of Incident Management and report generation in ServiceNow.
- Hands-on experience with process modeling using Unified Modeling Language (UML) including use case, sequence, activity and deployment diagram.
- Knowledge of Property and Casualty Insurance domain with hands on experience of Home, Auto and Life Insurance as well as Retirement Plans.
- Experience in Implementing IT solutions to Finance industry in Compliance with various security standards defined by SOX, SEC and BASEL II
- Working Knowledge of implementing solutions to meet HIPPA healthcare regulations compliance
- Successfully managed User Acceptance Testing (UAT)
- Excellent leadership, communication and presentation skills
- Experience working with business users, SME, offshore team and senior management
- Respected leader, known for mentoring and team building with excellent time management skills
TECHNICAL SKILLS
Methodologies: RUP, UML, CMM, ISO, DMAIC
Project Management Tools: Microsoft Project, MS-Office, Excel, Power Point
Content Management Tools: Microsoft Sharepoint, Documentum, ServiceNow
Document Design Tools: Rational SoDA, Rational Requisite Pro
Testing tools: Rational Suite, Test Director, HP ALM
Business modeling tools: Microsoft Visio 2007, Rational Rose
Version control tools: PVCS, Rational Clear Case
RDBMS/DBMS: Oracle 9i, Access 2003, Fox Pro 2.5
Environment: Sybase ASE 12.5.1/15, Microsoft SQL Server 2005, Windows Server 2003, C#, ASP.Net 2.0, XML, SQL, PL/SQL, Element Tool, MS-Project, MS-Visio 2005, MS-Excel
PROFESSIONAL EXPERIENCE
Confidential, Hartford, CT
Business System Analyst
Responsibilities:
- Worked on major Rebranding project across the company involving different applications across different teams.
- Worked on enhancement of client-facing application being used by customers to access their plans through the tool Genex.
- Facilitated JAD sessions with SMEs’, Product owner, and Development managers to understand the business process, gather Business Requirements and identify changes for the applications.
- Was involved in the planning of the RUP iterations anddocumenting of theartifacts throughout the various phases of thedevelopment process.
- Interacted with stakeholders and gathered requirements as per thebusinessneeds.
- While working with various members at the management levelto understand thebusinessprocess and decision models, was also involved in compilingthe Vision Documentand composingdetailed Use Case Specification Documents in Rational Requisite Pro.
- Developed Flowchart and process diagram using Microsoft Visio.
- Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule.
- Conducted GAP analysis byunderstanding the AS-IS system and the TO-BE system requirements by having discussions with the SME's.
- Wrote Application Functional Design Document (AFD) for various applications across different platforms to be used by developers for coding and did
- DocumentedRequirement Traceability Matrix inRequisite Profor traceability of requirements through test cases.
- Developed Test Plan and Test cases based on the Use cases and Functional specifications and also performed manual testing of the functionality of the application by inserting varying data on different test runs in Quality Center.
- Contributed in reviewing and editing of the test scripts.
- Was in regularcontact withBusinesspartners on the status of issues, action plans and timeframefor resolution throughout the development cycle.
- Helped Testers expedite the defect resolution by following up on the defects raised in Quality Center and setting up their priority level as per their impact.
Environment: RequisitePro, UML, Microsoft Office (Project, Publisher, Excel, Word, PowerPoint and Visio), Quality Center, Genex, VPN Client, HP ALM
Confidential, Columbus,OH
Business Analyst
Responsibilities:
- CoordinatedJAD sessionsto understand theuser requirements and also their system's implementation.
- Used both Agile/Scrum methodology for the web application used by Agents and Underwriters for providing new sale Insurance plans and Renewals of a group/company.
- Was Able to understandbusinessgoals andbusinesscontext and translated them into technical specifications
- Demonstrated experience defining impacts of conversions,businessrules, and configuration decisions on downstream systems and interfaces.
- Worked in Service Now incident management system as a member of production support team.
- Managed a team of offshore developers in Europe and a team of offshore testers in South Asia.
- Experienced in web services conceptsand support utilities, related database utilities. Demonstrated understanding and experience with ETL, Stored Procedures, and Queries.
- Involved in gathering requirements, identifying and preparing Use Case specification documents, creatingTrace-ability matrixand tagging it in the Rational Requisite Pro.
- DevelopedUse Casediagrams,businessflowdiagrams,Activity/Statediagrams andSequence diagramsusing Rational rose so that developers and other stakeholders can understand thebusinessprocess.
- Identified and documentedissues, riskandgaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements.
- Exposure toRational Clear Questto trackProject status,monitorworkloadanddetect issuesincluding defect submissions and enhancement requests.
- Synchronized and prioritized relevantdefectsandenhancement/systemrequests based onbusinessrequirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
- Wrote standard and complex SQL queries using MS SQL Server and also in Mainframe for data validation process.
- Wrote requirements for various reports to be generated and migrated.
- Maintain documentation related to difficulties, complexities and anomalies that may arise duringtheETL process.
- Regularlyfollowed up withDevelopment Teamto discussdiscrepancies identified duringtesting and act as a liaison between Project Manager and SME and development and testing team.
- Served as a liaison between the users, facilitators and the project team as a team lead.
- Involved in the development of Project Plan in conjunction with theBusinessand IT areas.
- Participated in User Acceptance Testing andBusiness-to-BusinessTransaction testing for the project.
- Supported forthe creation of test plans and the debugging of problems.
Environment: AS400, Service Now, Rational Rose, Rational Requisite Pro, Show Case SQL Query, UML, HP ALM, Java, MS Project, MS Office, MS SQL Server, Windows XP, Squish, Lean Six Sigma.
Confidential, Salt Lake City, UT/Minneapolis, MN
Business Analyst
Responsibilities:
- Work in partnership with Project Team, functional Team Leads and functional end-users to identify and document business process improvement opportunities and complete the definition of requirements for system design, implementation & training.
- Interacted with the “End-Users” by interviewing them, by preparing appropriate questionnaire to better understand end-user needs and the business process.
- Created test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review) in Agile environment.
- Responsible for gaining a good understanding of user needs and accurately representing them in a well-documented software functional specifications document.
- Worked with stakeholders to obtain deliverable sign-offs. Provided functional direction to other systems analysts and used the meta-data definition and workflow needs and how these functions map to business processes.
- Developed plan for data feeds and data mappings for integration between various systems, including XML, to followICD 10Code set andANSI X12 5010formats.
- Create flow diagrams illustrating the work flow of both ‘as is’ processes and ‘to be’ processes.
- Understand and Analyse the functionality and Impact on all the applications involved
- Documented the Use Cases and prepared the Use Case, Activity, Sequence diagrams and Logical views using MS Visio and MS Office for a clear understanding of the requirements by the development team.
- Facilitated Joint Application Development (JAD) sessions with all IT group members for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy.
- Created and maintained data mapping document(s) in reference to the HIPAA transaction: 837.
- Involved in developing Test plan and Test cases based on Use cases and Functional Specifications Documented, reviewed, and verified testing procedures for compliance to Interface Quality Assurance and Development standards and policies.
Environment: MS Office Excel, Word, PowerPoint, MS Project, MS Visio, MS Access,UML,.Net, MS Office, MS-Project, Windows 2000, Test Director, DB2
Confidential, Columbus,OH
Business System Analyst
Responsibilities:
- CoordinatedJAD sessionsto understand theuser requirements and also their system's implementation.
- Used both Agile/Scrum methodology as well as Waterfall methodology for the web application used by Agents and Underwriters for providing new sale Insurance plans and Renewals of a group/company.
- Demonstrated experience defining impacts of conversions,businessrules, and configuration decisions on downstream systems and interfaces.
- Involved in gathering requirements, identifying and preparing Use Case specification documents, creatingTrace-ability matrixand tagging it in the Rational Requisite Pro.
- DevelopedUse Casediagrams,businessflowdiagrams,Activity/Statediagrams andSequence diagramsusing Rational rose so that developers and other stakeholders can understand thebusinessprocess.
- Identified and documentedissues, riskandgaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements.
- Exposure toRational Clear Questto trackProject status,monitorworkloadanddetect issuesincluding defect submissions and enhancement requests.
- Synchronized and prioritized relevantdefectsandenhancement/systemrequests based onbusinessrequirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
- Worked on analysis, design and testing of Startschema implementationfor theFinancial Data Martimplementation.
- Performed extensivedata analysis and data integritytesting for loading and validation of the data set output.
- Wrote standard and complex SQL queries using MS SQL Server and also in Mainframe for data validation process.
- Regularlyfollowed up withDevelopment Teamto discussdiscrepancies identified duringtesting.
- Served as a liaison between the users, facilitators and the project team as a team lead.
- Participated in User Acceptance Testing andBusiness-to-BusinessTransaction testing for the project.
- Supported forthe creation of test plans and the debugging of problems.
Environment: Unix, Mainframe, Caliber, Rational Rose, Rational Requisite Pro, Rational Clear Case, UML, QTP, VB Script, MS Project, MS Office, DB2, MS SQL Server, Windows Server, Windows XP, XML, Agency Port
Confidential, Rochester, NY
Business Analyst
Responsibilities:
- Facilitated JAD sessions with SMEs’, Product owner, and Development managers to understand the business process, gather Business Requirements and identify enhancements for the application.
- Followed AGILE methodology viz. Scrum throughout the project.
- Prepared release plan and iteration plan for the project working with the stakeholders
- Re-factor Epics to Stories and maintain the prioritized Sprint backlogs
- Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
- Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
- Worked on FACET to terminate or reinstate health coverage for the subscriber.
- Documented requirement for HIPAA, EDI transaction 837 and for Medicare Part A, Part B, Part C and Part D.
- Researched/Analyzed the various steps involved in claims processing life cycle and then wrote the BRD in such way that developers could construct the system to identify riskier claims.
- Conducted requirement sessions, identifying business needs, getting sign-off on requirements and capturing requirements in CaliberRM and Rally.
- Facilitated pre-planning meetings, demos and daily stand ups.
- Wrote test cases and test scripts for the User Acceptance Testing (UAT).
- Worked with design team to prepare Project plan for User Interface documents.
- Tracked daily issues and dependencies and coordinated with common team to work on the impediment list.
- Conducted GAP analysis for fixed fee projects.
- Coordinated management of projects on MS SharePoint 2007.
- Used Rally and TFS for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
- Created traceability matrix to map requirements with test cases.
- Managed and assigned defects to the development team in Microsoft Team Foundation Server
- Created test plans for Test driven development (TDD)
Environment: Windows XP professional, MS Office suite, MS Excel, Google Spreadsheet, Documentum, MS Project, UNIX/Oracle Platform, XML, Oracle Application server, Oracle Pl/SQL, MS Visio, Bugzilla, Quality center, Clear quest, clear case, HP Service Manager
Confidential, Herndon, VA
Business Consultant
Responsibilities:
- Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
- Worked with Project manager, created Work flow diagrams, Activity Diagrams on MS Visio/MS Project using Program Evaluation and Review Technique (PERT) technique.
- Conducted Joint Application Development (JAD) sessions for requirements gathering with Business Stakeholders, SME’s, Users, refined it using Wireframes, Context Diagrams, Use Case Diagrams and made conceptual illustrations.
- Reconcile the tax information from generated reports, balance sheets, and general ledger accounts and post and prepare journal entries (J.E.).
- Coordinated with business users to prepare, update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD). Created Use Cases documents for requirements
- Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Involved in creating data models for the data warehouse and specify data mapping documents from specific data sources.
- Scheduled meetings with developers, SAs (System Analyst) and testers to collaborate resource allocation and project completion using MS Project.
- Conducted process improvements, status meetings, presided over the Changed Control Board meetings to discuss Defect and Enhancement.
- Conducted UAT and Coordinated with the QA Team for the sign-off process before deployment and assisted the Project Manager on creating the Lessons learned document.
- Created Ad-Hoc financial reports for the top management using Ms Excel.
Environment: MS visual Studio .NET, MS .NET Framework, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, RUP 2002, Rational Rose 2002, Rational Robot 2002, Rational Clear Quest 2002, Rational Clear Case 2002
Confidential, Richmond, Virginia
Business Analyst
Responsibilities:
- Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface)
- Organized, conducted JAD sessions for requirements gathered. Prepared Business Requirement Documents and Functional requirement Documents.
- Worked extensively on MS Project to develop Work Flow, Resource Planning, Activity Network diagrams, using PERT techniques.
- Worked with reconciliation system for the daily cash transactions checks between the Confidential and the financial institutions and prepared summary report on it
- Created Requirement Traceability Matrix to maintain all the requirements extracted from the Users, Stakeholders, made sure all the documents are being accounted for.
- Developed process flow diagrams Context Diagrams, Wireframes, Swim Lane Diagrams, which helped in Rapid prototyping and pinpointing potential problems early in the process.
- Coordinated with Project Managers, Developers, SME’s to design, create Work Flow Diagrams using MS VISIO.
- Reconcile daily transactions against generated reports, balance sheets, and general ledger accounts and post and prepare journal entries (J.E.).
- Process and apply loan payments (checks/wires) in the application and also provide information to the government-assigned and internal auditors.
- Calculate pay-offs and collect on delinquent accounts from financial institutions. And Provide vault custodians with instructions for securities that are being canceled and shipped.
- Generate ad hoc queries and monthly financial reports. And Distribute billing statements to borrowing institutions.
- Revise user guides, procedures, and checklists semi-annually to ensure methods and practices are in line with county, state, and federal regulations and conducted UAT.
- Attend and participate in conference calls, status meetings, planning sessions and provide recommendations
Environment: C#.NET, Java 1.6x, Oracle 10g, 6.0, MS Office Suite2007, MS Visio 2007, MS Project 2007, MS Outlook, HP Quality Center Enterprise Edition
Confidential
Business Consultant
Responsibilities:
- Prepared logical data model in the form of Business Context diagram to include various entities and attributes in order to facilitate the design of Data model in the form of ER Diagrams. Studied current information structures and data models of the current databases to better understand the design of target data source.
- Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident and administrative tracking. Performed all data field mappings.
- Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
- Used Rational Clear Quest to track required changes and Rational Clear Case to maintain different versions of the project documentation
- Reviewed administrative and clinical practices and procedures: point of care, scheduling, registration, clinical documentation, Confidential t care, and charge entry, medical coding and diagnostic testing procedures associated with multiple business units.
- Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
- Regular interaction with the core developers helped us in fixing the defects in less time.
- Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
- Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
- Created a prototype presentation in Visio for the SCAL region, thus showing a pictorial representation on the various drill downs from the report to the metrics to the database.
- Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
- Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
- Lead the effort of Data Migration from disparate data sources into normalized data to eliminate redundant information and organizing the tables to easily maintain the table structures.
- Prepared training materials in the form of User manuals by preparing step-by-step guide to all screen flows in CMS.
- Assisted in development of User Interfaces and prepared screenshots to get business’s buy-in on the requirements.
Environment: Windows XP Professional, Oracle9i, MS Access 2000, MS Excel, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.
