We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Irvine, CA

SUMMARY:

  • Over 8 years of experience as a Business Analyst with extensive knowledge and experience across the project life cycle in Systems Development Life Cycle (SDLC)
  • SCRUM Master Certified
  • Expertise in Project Planning, Project Design, creating functional specifications and data flow diagrams.
  • Experience in working as liaison between stakeholders and scrum team.
  • Expertise in managing sprint backlog, product backlog, and managing Scrum Meetings to identify dependencies on other teams and features.
  • Experienced working with various teams and managing teams, time lines, mile stones, and resources.
  • Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise during the project.
  • Expertise in creating the user guides for pricing methodology for various financial products.
  • Optimum use of documentation to avoid any miscommunication or misinterpretation during the entire process.
  • Understanding and interpreting requirement specifications .
  • Experience in creating and maintaining the Requirements definition documents that included Business Requirements (BRDs) and Functional requirements (FRDs).
  • Skilled in creating Use Case, Activity, and Swim Lane Diagrams using UML.
  • Extensive use of UML/RUP for modeling views in Microsoft Visio.
  • Knowledge of fixed income
  • Strong knowledge of Project managemen t skills such as time estimation, task identification, and scope management.
  • Experience in customer/client interaction, deep understanding of business systems functionality and technicality.
  • Expertise in creating detailed mapping document highlighting the source applications & the target application.
  • Expertise in writing complex SQL queries for data mapping.
  • Hands on experience working on ETL, batch jobs, and data warehousing projects.
  • Conducted requirement analysis techniques such as Business Process Automation, Business Process Improvement, Business Process Modeling and Business Process Re - engineering.
  • Involved in maintaining Test Matrix and Traceability Matrix and performing GAP analysis.
  • Expertise with QA Methodology to ensure robust functionality.
  • Motivated self-starter with exceptional team building , leadership , and interpersonal skills.
  • Experience in conducting and participating in User Acceptance Testing (UAT).
  • Extensively used SharePoint for requirements and documents management.
  • Used SharePoint for defect tracking during UAT.

TECHNICAL SKILLS:

Microsoft Office Suite: Excel, PowerPoint, Project, Visio, Outlook, Access, SQL Server, SSRS, SSIS, SharePoint, BABOK, Agile Extension to BABOK,, SDLC, SCRUM, Agile, Waterfall, RUP, Quality Center (ALM), RTC, SWOT Analysis, Lean Management, Change Management, Process Improvement, GAP Analysis, Cost Analysis and Estimation, Project Management, Data Warehouse, Data Mapping

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Sr. Business Systems Analyst

Responsibilities:

  • Implemented Agile business analysis methodology throughout project phases. Worked in Scrum teams .
  • Analyzed business needs, created and developed wire frames and mock ups to meet display proposed UI to business users that facilitated decision making.
  • Organized and facilitated daily stand up meetings, sprint reviews, and sign off meetings.
  • Trained newly on boarded resources.
  • Provided input and feedback for story points to ensure stories with dependencies were aligned properly.
  • Worked on AdModify to manage and modify HR data in Active Directory .
  • Wrote requirements for TimeX (Time Sheet Management), HR, and Directory for SAP rollout.
  • Wrote requirements and created mapping document for HR data from multiple systems to HCM (Human Capital Management), which was part of SAP rollout .
  • Created detailed requirements to capture process for payroll data collection and benefit plans .
  • Wrote Technical Specification & Functional Specification documents for ETL process, outlining the delta calculation rules, business validation rules, SSIS package run rules, data model (ER Diagram) and field mapping .
  • Maintained Data Dictionary to capture attributes for all data points used in the HR & TimeX system.
  • Facilitated JAD sessions for requirement elicitation, review, and approval. Conducted requirement analysis and design walkthroughs with the designers, developers and management staff.
  • Conducted and facilitated Daily Standup meetings during the sprints.
  • Maintained Traceability Matrix & Test Matrix to ensure all teams had clarity on requirement prioritization & scope for each build.
  • Frequently wrote SQL queries for data validation during ETL process validation .
  • Worked with UAT Participants during UAT. Maintained UAT Test Plan and wrote UAT Test Scripts .
  • Provided feedback from UAT and facilitated UAT by reporting issues in SharePoint .
  • Frequently conducted Smoke Testing, Regression Testing, and System Testing .
  • Facilitated requirement gathering meetings and documented meeting minutes, coordinating all internal and external follow-ups to close issues in support of the project requirements and system approach.
  • Managed defects, UAT Test Cases and Requirements in Quality Center (ALM) .

Environment: SQL Server, Windows, Crystal Reports, Oracle, SharePoint, ALM (Quality Center), MS Office, MS Visio, RTC

Confidential, Washington, DC

Business Analyst

Responsibilities:

  • Interviewed client employees and application owners from different business lines to gather information, understand the user’s needs, define requirements, and develop specifications.
  • Worked in Scrum team and participated actively in Sprint Planning to ensure Sprint Backlog was properly managed.
  • Maintained sprint back log and prioritized user stories frequently.
  • Gathered Compliance requirements as per SOX compliance for reports.
  • Created proper mapping between stories based on story points.
  • Frequently participated in Sprint review meetings, daily stand up meetings, and release meetings.
  • Participated in Join Application Development (JAD) and Rapid Application Development (RAD) meetings with the domain and technology specialist to collect and define user requirements.
  • Created and updated BRD documents using Microsoft Word, Visio
  • Assisted in the development of quality assurance activities including Quality Assurance Plan, Product Acceptance Plan, Test Plan, and Test Cases.
  • Wrote User Stories to outline requirements and assign priority to requirements.
  • Maintained Requirement Traceability Matrix for requirement vision, impact analysis, and requirement prioritization.
  • Coordinated work plans between the project manager and clients using Microsoft Project.
  • Created activity diagrams, use case diagrams and sequence diagrams using MS Visio to view the system from different perspectives.
  • Created and maintained Data Quality Check & Process document for ETL batch jobs to ensure all rules were applied while extracting, transforming, and loading data.
  • Created data mapping document. Extracted data from different sources like flat file excel data sheet, SQL & Oracle relational databases and processed data to upload in to the target database.
  • Wrote SQL queries to extract data from multiple tables for data validation.
  • Involved in validation of created data model to make sure that all data objects provided by the functional team are completely and accurately represented.
  • Interfaced with the developers to provide all kinds of support and resources needed to resolve domain and technical issues.
  • Conducted functional walkthroughs and User Acceptance testing sessions and assisted the development of User Manuals for customers.
  • Trained Internal Users and their partner & management employees in the new web Based online applications.

Environment: Jira, MS Office Suite, SQL Server, MS SharePoint, Quality Center (ALM), Web Server, XML

Confidential, Morristown, NJ

Business Analyst

Responsibilities:

  • Participated in project planning, scheduling, budgeting, and resource allocation meetings.
  • Created and maintained requirement backlog and sprint backlog. Ensured proper priority was assigned to user stories for each sprint. Created process flows outlining the high level business rules .
  • Conducted individual and group (JAD) sessions with business stakeholders and technical units.
  • Established standards and guidelines for business process modeling and requirements specifications.
  • Gathered Application Requirements and Business Processes from Business Analysts and Developers.
  • Tagged user stories to business epics to create traceability.
  • Provided status reports to management and identified tasks in each status: on time, behind schedule, pending etc.
  • Responsible for defining the scope and business rules of the project, gathering business requirements, and documenting them textually or using models.
  • Supported Financial Transparency for HCP/HCO payments for Research for compliance with U.S. Physician Payments Sunshine Act.
  • Monitored and reviewed Sunshine Act reporting templates containing physician payment data from external and internal sources to ensure accuracy and completion.
  • Researched, identified and verified missing and/or incorrect information for accurate reporting of payments and/or transfers of value.
  • Tracked, logged, write-protected and filed reporting templates as they were received for audit purposes.
  • Researched and verified information by performing data look-ups in government and internal databases such as CMS Open Payments, NPPES-National Provider Database, ClinicalTrials.gov and BMS Customer Master Tool-CMEH.
  • Executed weekly tracking reports via Excel and Echo-Sign certification system.
  • Created and ran reports as necessary using Excel (Pivot tables, V-Look-ups).
  • Collaborated with internal departments regarding Sunshine Act reporting.
  • Updated and documented new procedures as necessary. Created mapping documents while working on data across multiple systems.
  • Organized and facilitated daily stand up meetings, sprint reviews, and sign off meetings.
  • Provided input and feedback for story points to ensure stories with dependencies were aligned properly.
  • Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts.
  • Conducted and participated in the JAD session with the SME’s. Developed testing steps using MS Visio for off shore team
  • Worked as a liaison between the supervisor and off shore testing team to make sure testing follows right procedures.
  • Reviewed testing process to be in alignment with the business flow
  • Interacted with cross functional teams to facilitate gathering of testing requirements.
  • Collaborative problem solving and to identify the key components of a problem and formulate a solution

Confidential, Jersey City, NJ

Business Analyst

Responsibilities:

  • Extensive use of Agile methodology during project life cycle.
  • Worked with account managers and business users to gather requirements.
  • Interacted with various teams to gather requirements for new ATM features.
  • Involved in requirement writing for pricing methodologies of new products.
  • Enhanced Functional Specification documents for various reports.
  • Created data mapping document and maintained data dictionary for all data points.
  • Documented rules for data extraction, transformation, and loading from multiple sources to a target data warehouse.
  • Assisted in creating Technical Specification documents for data extraction, data quality checks, and data validation.
  • Prepared & maintained analysis documents outlining enhancements & change requests for existing features. Prioritized change requests as per business needs.
  • Created Use Case, Data Flow, and Activity Diagrams.
  • Conducted JAD sessions for requirement gathering and approval.
  • Maintained Traceability Matrix for requirement mapping, requirement prioritization, gap analysis, and impact analysis.
  • Extensively used Quality Center for requirements and defects management.
  • Documented all the changes in the initial templates.
  • Updated existing process flow charts and elaborated on additional alternate flows.
  • Wrote SQL queries during data validation and data mapping.
  • Created User Guides to capture new features and functionalities.
  • Wrote requirements for report enhancements and prioritized enhancements. (System reports and Crystal Reports).
  • Created templates for new reports. Created mock ups to show report fields.
  • Tested the reports for content and format during UAT .
  • Used SharePoint for defects tracking and updates during UAT.

Environment: Agile, SQL Server, Windows, SSRS, Quality Center, MS Office

Hire Now