Business Systems Analyst Resume
Arlington, VA
SUMMARY:
- 8 years of experience in Business Analysis for application development, working in the diversified domains such as Banking, E - commerce Retail, Healthcare (Trizetto Facets) and P&C Insurance clients.
- Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methods like Rational Unified Process (RUP), Agile and Waterfall Method.
- Proficient with Ecommerce Content Management System, Order Management, Supply Chain Management, Omni Channel, Oracle ATG and Point of Sales (POS).
- Solid knowledge of applications provided by wealth management trading platforms offered by major financial institutions.
- Skilled in preparing Business Cases, Business Requirements Documents, Use Cases, Functional and Technical Specification Documents, Requirement Traceability, Traceability matrices, Test plans, Test scripts and Software Development Plans.
- Extensive experience in Requirements Gathering, Surveys/Questionnaire Development, Business Requirement Documents (BRD), Functional Requirement Specifications/Documents (FRS/FRD).
- Experienced in UML and Use Case Analysis, identifying Key performance indicators (KPI), and Change Management.
- Well acquainted with Workflows and Unified Modeling Language (UML) diagrams such as, Use case diagrams, activity diagrams and Sequence diagrams.
- Excellent knowledge of Health Insurance Portability and Accountability Act (HIPAA) transaction and code set rules such as EDI 837, 270, 271, 276, 277, 834, 835.
- Proficient with creating Unified Modeling Language diagrams (UML) for Business Process Modeling which include Use Case Diagrams (UCD), Sequence Diagrams (SD), Activity Diagrams (AD), Flow Charts (FC), Data Flow Diagrams (DFD) and Wireframe Prototypes.
- Worked closely with project stakeholders, Subject Matter Experts (SMEs) to understand business requirements and analyze specifications for new applications, and to modify existing applications.
- Actively used Joint Requirement Planning (JRP), Joint Application Development (JAD) and Rapid Application Development (RAD) sessions for requirements gathering and brainstorming ideas.
- Experience in designing Test Strategies, Test Cases, and Test Scripts and conducting User Acceptance Testing (UAT).
- Knowledge of risk management, performance measure development, process development, and WBS development.
- Skillful GAP analysis, Risk assessment.
- Experienced in using different UML diagrams including Use Case Diagrams, Sequence Diagrams, Activity Diagrams and Collaboration Diagrams.
- Hands on experience with Data Warehousing, Dimensional Modeling, Data Analysis, Data loss prevention, Data Mapping, and Data profiling.
- Excellent Team Building and Problem Solving skills in conjunction with strong Technology and Engineering background
- Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
- Skilled in converting legacy reports to more contemporary programs such as Crystal Reports, IBM Cognos BI Reporting, SSRS, Business Objects, MS Excel, MS PowerPoint, MS Project, MS Access, and SQL, and condensing number of reports to simplify processes.
- Excellent communication and presentation skills along with strong interpersonal & analytical skills.
TECHNICAL SKILLS:
Operating Systems: Windows XP/Seven/Vista/10, Linux.
Business Modeling Tools: Microsoft Visio, UML, Rational Rose, Cognos.
Project Management: Microsoft Project, Microsoft Office, SPIRA
Testing Tools: Quality Center, QTP, Rational Clear Quest, HP ALM, Load runner.
Version Control Systems: Rational Clear Case, PVCS
Databases: MS Access, SQL Server, Oracle10g,11g
Requirement Management Tools: Rational Requisite Pro, JIRA, Blueprint, Visual Studio TFS, HP AGM
Reporting Tools: Rational SODA, Crystal Reports
Business Intelligence (BI) Tools: COGNOS, Tableau, SSRSProgramming Language SQL, PL/SQL, Visual Basic, Java, J2EE dBase
PROFESSIONAL EXPERIENCE:
Confidential, Arlington, VA
Business Systems Analyst
Responsibilities:
- Create Business requirements documents, software requirements specification documents, Business process flows, Data flow diagrams, Use cases and user stories.
- Conduct requirements elicitation sessions with business stake holders and technical stake holders.
- Develop SQL Queries to create tables, stored procedures, triggers and performed data analysis, data mapping, data reporting using Microsoft SQL Server Management Studio.
- Perform detailed data analysis to understand the existing system and work closely with the data analystsand propose changes to the Business requirements and ETL design to satisfy the end user/businessneeds.
- Translate business systems requirements into clear, precise and easy-to-read functional specifications, technical specifications and application process flows
- Worked under Agile/Scrum methodology (user story, product backlog, risk prioritization, sprint planning, poker sessions, product backlog grooming, daily stand ups, sprint retrospective, sprint demo).
- Providing development team with requirements and acceptance criteria within Product Backlog Items using TFS.
- Lead and facilitate Joint Application Development (JAD) sessions with the development team.
- Worked with FacetsTeam for HIPAA Claims Validation and Verification Process (Pre-Adjudication) and assisted in version upgrade and impact analysis on data warehouse tables.
- Analyzed current MMISand EDI claims and documented the requirements to implement new MMIS automated system.
- Develop Data mapping documents, logical data models, class diagrams and ER diagrams and used SQL queries to filter data.
- Extensive use of Facetsbackend tables and front end application system for data validation purposes.
- Create and manage Project Templates, Use Cases, Requirements and Traceability Relationships in RequisitePro.
- Create automated Test Scripts representing various transactions, Document the Load Testing Process and Methodology
- Create reports for analysis and integrate the Performance Testing in the SDLC.
- Used MS Visio for Process modeling and Business Process flow diagrams.
- Develop the Test plans for quality assurance based on functional requirements.
- Assist in gathering requirements for the source systems, the DW and applicable data marts.
- Work on data modelling and produced data mapping and data definition documentation.
- Develop and manage Project Plans and Schedules. Manage resolution of Project issues and conflicts.
- Conduct detailed requirements Walkthroughs to get sign-offs from the relevant stakeholders
- Help in User Acceptance Testing (UAT), and supervise the development of User Manuals for customers.
Environment: Agile, RUP, UML, SDLC, MS Office, MS Project, MS Visio-BPMN, SSRS, Visual Studio TFS, Trizetto Facets 5.01, Informatica.
Confidential, Waco, TX
Business Systems Analyst
Responsibilities:
- Gathered Business Requirements, analyzed data/workflows, defined the scope, and performed GAP analysis.
- Met with client groups to determine User Requirements and Goals, thus converting User Requirements and Business Requirements into Functional and Technical Requirements.
- Involved in designing and developing Data-Flow diagrams, E-R diagrams, and logical and physical database design.
- Functioned as the primary liaison between the business user, project sponsor, operations team, and the technical team throughout the project life cycle for Property & Casualty (P&C) commercial lines of Insurance businessunit.
- Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.
- Gathered requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using UML and Rational tools.
- Analyzed business and technical requirements, thus creating the Business Use Case (BUC) and Application Use Case (AUC) documents.
- Strong understanding of Underwriting and Claims business processes in Property and Casualty(P&C) Insurance. Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, and Commercial).
- Played the role of a Project lead (technical and functional) for stream: Correspondence. This covers various types of letters/mails/forms and checks that are dispatched from NL premises to its policyholders and claimants.
- Facilitated Joint Application Requirement (JAR) sessions to identify business rules and requirements with Business Teams.
- Followed Agileand Scrum methodologies for various project phases.
- Developed, documented and managed user stories, rules, requirements and other artifacts using TFS and other requirements management tools in an Agile software development environment.
- Worked extensively with SMEs and performed Gap analysis to arrive at the gaps between current and future systems and the modules to be impacted.
- Developed AS-IS and produced TO-BE documentation.
- Translated business functionality and opportunities into clear, precise and easy-to-read functional specifications, technical specifications with data mapping and application process flow and facilitated Joint Application Development (JAD) sessions with programmers.
- Identified risk sources and contributed in the risk mitigation process.
- Involved in creation of Data Dictionary describing data model of claim center database for WC Claims Integration and Reporting. Used Erwin to design conceptual, logical data model enforcing the data integrity and preventing use of redundant data within and between systems.
- Wrote SQL Queries to create tables, stored procedures, triggers and performed data analysis, data mapping, data reporting using Microsoft SQL Server Management Studio.
- Formulated integration test plans, test cases, test scripts and executed integration testing with assistance in UAT.
Environment: Agile, RUP, Rational Requisite Pro, SQL Server 2005, MS SQL Server Management Studio 9.0, VBA, SAS, Visual Studio TFS, MS Office, HP AGM, MS Visio.
Confidential, Bethesda, MD
Business System Analyst
Responsibilities:
- Supported the re-design of the Mortgage Asset Management System.
- Conducted interviews with key business users to collect requirements and business process information for the loan process including Account Information set-up, New Loan set-up, Escrow Analysis, the Appraisal, Credit, income and Title functionalities.
- Interacted with stakeholders, gathered requirements, rated them and assigned priorities.
- Participated in the brain storming sessions with SMEs for initial analysis of the requirements.
- Followed a hybrid of Waterfall, RUP and Agile approach of development throughout the project.
- Created, maintained & updated business, functional & technical requirement documents.
- Managed Agile SCRUM Life Cycle, Product backlog, Iterations/Sprint plan using Team Foundation Server (TFS), and used TFS for work item management, custom reporting to track sprint/release progress, Backlog Grooming and Defect tracking.
- Organized and provided training to Loan Officers on system use.
- Responsible for making sure procedures are observed for mortgageloan funding, loss mitigation or modification and QA/QC standards.
- Prepared and reviewed all mortgageapplications/commitment letters per Investor Credit Policies and guidelines.
- Performed extensive requirement analysis including data analysis and gap analysis.
- Prepared bank reconciliations for lockbox accounts, money market accounts, and AP checks.
- Comprehensively worked with requirement gathering for Enterprise reporting system using Requisite Pro.
- Prepared a Requirements Traceability Matrix for every Business requirement.
- Responsible for analysis & sizing of all Change requests for the point bank service.
- Utilized RUP to configure and develop process, standards, and procedures.
- Maintains knowledge of complex industry trends, current security issues and security technology and update management on risk and threat that could impact the business.
- Developed use cases to depict business module changes and created use case documentation.
- Conducted walkthroughs for Business and Technical stakeholders for new requirements.
- Maintained all system changes in the SharePoint document library.
- Reviewed test cases and provided support during system & integration testing.
- Helped to form a BA team offshore, prepared transition plan and trained new BA’s.
- Coordinated and supported a group of BA’s team offshore.
Environment: Agile, RUP, UML, Visio2003, Visual Studio TFS, MS Office Suite, DB2, Java, Oracle, SharePoint, SQL, MS Project, Test Director, QTP, Cognos, Windows.NET and UNIX.
Confidential, Baltimore, MD
Business System Analyst
Responsibilities:
- Gather and write functional/business requirements used by engineers and programmers on multiple ecommerce applications as well as collaborate with User Experience/Interface designers to develop wireframes/schematics that support such requirements.
- Coordinating workflow across ecommerce, IT, UI, retail and UAT teams.
- Used SDLC (System Development Life Cycle) methodology like Agile and Scrum.
- Performed the analysis of several websites like EBay, Amazon, Costco, Target, JC Penney, Macy, Levi's, Calvin Klein, US POLO etc. to identify competitive advantages and value addition to Walmart.
- Provide product support to Enterprise, Supply Chain, and Order management applications.
- Partner with continuous product engineering teams on investigating systemic issues.
- Create and execute SQL queries to find clues on what may be causing the opportunity.
- Also involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing.
- Exposure to Retail Business Processes - Broad knowledge of how a retail store/ecommerce operates, Sales audit, Inventory & accounting, payment card process
- Create internal monitoring alarms and reports by designing queries using SQL.
- Worked on Gathering and documenting PCI regulations and requirements for credit card payments.
- Work with key business stakeholders, engineering development, and PMO on developing system enhancements.
- Worked with Information Architects (IA) and other representatives from the User Experience (UX) team to design wireframes, mock ups, mobile app prototypes and process flows.
- Assisted IA in designing wireframes and mobile screens based on user interface design knowledge and expertise.
- Used IBM WebSphere for Mobile application in giving seamless shopping experience to guest in selecting products, shopping cart, check out, bill payments modes.
- Collaborate with the development team on designing clear and concise project requirements.
- Participate and provide signoff based on User Acceptance Testing results.
- Offer post implementation support on enhancements that have been introduced into production.
- Performed GUI testing and analyzed end to end functionality by testing the application manually.
- Track and report upon testing activities, including testing results, Mobile application testing, test case coverage, defects discovered and their status on a weekly basis.
Environment: Ecommerce, SQL Server 2008 R2, .NET 4.0, UAT, Google Apps for Business, Windows, Agile, JAD, TFS, Android, IOS, MS Visio, Clear Quest, Rational Requisite Pro.
Confidential
Business Analyst
Responsibilities:
- Involved in Business Process Management, Documentation, External and Internal Communications, Governance Processes, Program Issues and Risk, Risk Mitigation, Audit and Change Requests.
- Managed stakeholder's expectations and satisfaction issues ranging from process building, to services delivery, to support.
- Coordinated participation and sign-off various business partners and customers.
- Assisted the Product Owners/Scrum Master in managing and grooming the Product Backlog and Sprint Backlog.
- Ensured that all user stories are Created and Updated as per Standards before Daily Scrum meeting.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Followed solely RUP methodologies during the project.
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in Requisite Pro.
- Created business process diagram for processing of payment.
- Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
- Interviewed LOB analysts and marketing personnel to obtain enhancement requirements for reporting and inquiry upgrade needs in an existing data warehouse.
- Worked on moving system modules and LOB administration over to Guidewire.
- Worked on the Business Objects Data Insight to analyze and monitor the claims reports.
- Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Worked heavily with the users and technical team throughout the day to facilitate proper communication.
- Worked on tracking issues to maintain all the priority items for future sprints.
- Made sure the test cases and test process guarantee accountability to business and systems requirements.
- Involved in the testing phase right from the Unit testing to the User Acceptance testing.
- Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, Rational Clear Quest, Rational Clear Case, RUP, Business Objects, Mainframe, Microsoft Office Suite, Cognos 8.4, Guidewire Claim/Policy center.