Sr. Business Systems Analyst Resume
New, YorK
SUMMARY:
- Over around 7 years of extensive experience as a Business Analyst in Software Development Life Cycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process), business and functional requirement gathering, analyzing requirements, business process design and software validation
- Highly experienced in broad range of technologies including business process tools such as MS Project, MS Office Suite, MS Visio, Data Warehousing concepts.
- Strong experience in client interaction, understanding business applications and business data flow.
- Experienced in conducting and facilitating JAD and Work Sessions, Interviews and client meetings, to gather requirements.
- Extensive experience in documenting Business Requirements (BRS), Use Case, Functional and Nonfunctional requirements, Systems Design Specifications, Systems Requirements Specifications (SRS).
- Excellent in performing Gap Analysis to check the compatibility of the existing system infrastructure with new Business Requirements, SWOT analysis, forecasting and traceability matrix.
- Proficient in developing Use Cases, Behavior & Structural diagrams, Business Process Flow based on UML using MS Visio.
- Adept in translating business requirements, reporting requirements and user expectations into detailed system specifications employing Unified Modeling Language (UML).
- Proficient in using Agile Scrum methodologies, performed roles of Scrum Master following sprint/standup sessions and used Excel extensively to write user stories, analyzed the Iteration Burndown charts and reviewed defects.
- Good knowledge in developing and designing reports through SSRS and Excel.
- Experienced in conducting User Acceptance Testing and coordinating with the UAT participants to get the change requirements.
- Adept in deploying the projects by involving in go - live processes and getting client feedback timely.
- Experience in preparing documents for training purposes.
- Experience in working independently with minimal supervision and a great team player.
- Strong customer/user advocate, apt negotiator with excellent analytical, communication, decision-making and organization skills.
- Excellent communication, analytical, interpersonal, presentation and troubleshooting skills.
- Expert at managing multiple projects simultaneously with excellent time management skill and meeting deadlines.
PROFESSIONAL EXPERIENCE:
Confidential, New York
Sr. Business Systems Analyst
Responsibilities:
- Worked closely with the business owners; conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
- Conducted and controlled brainstorming sessions with project focus groups.
- Conducted analysis on business needs, critical success factor.
- Worked with the systems architects in designing the system, flows etc.
- Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
- Documented High Level Design (HLD) and Low Level Design (LLD) Documents to define the system rules by creating Use cases, interface designs etc.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
- Designed wireframes and screen mockups to explain in details the business implication.
- Created ad hoc reports for the business, management.
- Created gap analysis and specified all required business data for XML messages to place facultative reinsurance submissions, quotations and binder information
- Created Use Case diagram, activity diagrams, sequence diagram in MS Visio.
- Analyzed and prioritized user and business requirements as system requirement that must be included while developing the software.
- Involved in creating the Project templates, Use case specifications, Change request form.
- Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, Object Oriented models using MS Visio.
- Worked with the database design team to assist them in designing the database and also created data dictionary.
- Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
- Worked with testing team in developing the test plan, test conditions, test cases based on business requirements and technical specifications.
- Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
Environment: Microsoft Office Suite 2007, MS Visio, MS Excel (Macro), HP Quality Center, SQL Server Management Studio 2005/2008, Reporting Services (SSRS) MS SharePoint.
Confidential,Wisconsin
Business Systems Analyst
Responsibilities:- Worked extensively with the business owners (Front desk and UI users); conducted formal interviews, live Meetings and JAD sessions to identify requirements and functional specifications.
- Conducted and controlled brainstorming sessions with project focus groups which included folks from leadership and management.
- Interacted with the QA team and involved in End to End testing of the interfaces with various scenarios to make sure that the Interface Integration is complete and accurate for different kind of data and protocols (xml data and DB tables via HTTP protocols).
- Created Use Case diagram, activity diagrams, sequence diagram in MS Visio for scenarios including Parole and sentence term scenarios.
- Participate in Daily Agile Scrum "Stand-up", Bi Weekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
- Prepared functional requirements to define the system rules by creating Use cases, interface design and data dictionaries.
- Analyzed and prioritized user and business requirements as system requirement that must be included while developing the software.
- Involved in creating the Project templates, Use case specifications, Change request form.
- Actively participated in CAB meetings and overnight deployments
- Worked with cross-functional teams for building use cases, demonstrating the business requirements, developing business models; Designed and developed business flow diagrams, Object Oriented models using MS Visio.
- Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Tableau.
- Worked with the database design team to assist them in designing the database and also created data dictionary.
- Conducted Model reviews with project team members; Publish and communicate models to various IT and business-based teams.
- Worked with testing team in developing the test plan, test conditions, test cases based on business requirements and technical specifications.
- Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
Environment: MS Visio, MS Office Suite, Agile/Scrum, Rational Requisite Pro, UML, Windows XP, SOAP, XML, MS Project, Quality center, .NET, Tableau, SQL Server.
Confidential,NJ
Sr. Business System Analyst
Responsibilities:- Analyzed the existing claims process and specific business rule logic to be applied in the Enterprise Data Model (EDM).
- Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
- Experience in multiple EDI transactions 835 (Payment), 837 (Healthcare Claim), 834 (Benefit enrollment), 270/271 (inquire/response healthcare benefits), 276/277 (Claim Status)
- Involved in forward mapping from ICD 9 to ICD 10.
- Performed gap analysis for HIPAA 4010 837P and 835 transactions and HIPAA 5010 837P
- Knowledge of Institutional and Professional claim submission.
- Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
- Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
- Developed schemas for extraction, transformation, and loading (ETL) into EDW with developers and data modelers.
- Conducted current state study, which included data collection methodologies, data quality and data integration problems, and data storage issues.
- Experienced in data mapping, metadata management, gap analysis ETL.
- Elicit, document and Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
- Developed and provided formal training and presentations/lectures to all EDW users ensuring an understanding of the data available and effective usage.
- Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Teradata, Data Warehousing, and Cognos.
- Wrote detailed specifications for various reports generated using Cognos.
- Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
- Managed Scope and change throughout the SDLC process of the product.
- Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisitepro - RUP
- Documented the requirements such as BRD and FRD.
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- Involved in Logical & Physical Data Modeling. Database Schema design with data architects and modelers.
- Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
- Created the test cases for all the Use Cases using EA tool.
- Vendor management and Resource management.
- Created test scripts with QA team for all the test cases.
- Documented and evaluated test cases/test results/feasibility study of various ETL tools like Informatica.
Environment: RUP, UML, UAT, SDLC, Rational Rose, SAP, Rational Test Manager, Informatica, Rational Requisite Pro, Rational Clear Case, Rational Rose, UNIX, Oracle 8i, PL/SQL, Mercury Test Director Agile, Waterfall, MS Access, CSV Files, XML File
Confidential,New Jersey
Sr. Business System Analyst
Responsibilities:- Gathered user requirements and directed developers for practical deliverables.
- Analyzed complex financial products and system architectures, including accounting business processes including financial and management reporting (e.g. IFRS and US GAAP), month-end closing process, regulatory reporting, entity consolidations and multi-currency accounting.
- Created and revised reporting templates based on industry standards and project requirements.
- Worked through the complete SDLC, elicit, analyze and define requirements.
- Conducted JAD sessions between the end users and the development team. Worked with the software architects / developers to ensure that the applications conform to customer requirements.
- Used Rational Unified Process (RUP) for streamlining the team’s development activities.
- Created project documentation such as BRD and FRD.
- Analyzed current formats for reporting Accounts Payable,Accounts Receivable and Reconciliation towards using some of the necessary fields in the new format too.
- Utilized Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices.
- Reverse-engineer several databases, such as research, business, and clinical to extract metadata to leverage it for ETL design and reporting.
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
- Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
- Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
- Experienced in developing Object Oriented Analysis and Design Models; Use Case Model and UML.
- Well versed in project management tools like MS Project for project planning, Project scheduling.
- Prepared documents to conduct user acceptance testing.
- Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
- Participated Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
- Documented the dimensional models of ETL system.
- Used SQL to test various reports and ETL load jobs in development, QA and production environment
- Tracked UAT issues/bugs and prepared reports.
- Performed job of contact point for all stakeholders (business, legal, compliance, development)
- Took approvals from business owners for business requirements
- Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project
Environment: UNIX, DB2 UDB, MS PowerPoint, MS Excel, Cognos, RUP, UML, Rational Rose, System Analysis, Testing Strategies.
Confidential,Ohio
Business Analyst
Responsibilities:
- Involved in working with a team of developers and partially responsible for allocation of work.
- Involved in project management activities including project planning, development and execution.
- Analyzed Client requirements and generated workflow process and necessary documents for the project.
- Managed Requirements and communication with user groups and team members using UML diagrams in Rational Rose and Rational Requisitepro.
- Involved in Development of Sale and Profit Reporting and various other interfaces utilizing and importing XML based SOAP messages between various interfaces and services.
- Created Business Required Document (BRD) detailing the solution of the project and the needs of client.
- Assisted Project Teams in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), User Interface Design, designing of Application Architecture & Database Modeling.
- Defined project milestones, schedules by monitoring progress using and updating plans as required using MS project.
- Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships, and allowed maximum software reuse.
- Documented User Requirements with MS Word as the editing tool.
- Conducted highly interactive JAD sessions with project's stakeholders including users, QA analysts, and project management team to identify and resolve issues.
Environment: Windows, MS Project, MS Visio, UML, SOAP, XML.