We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Washington, DC

SUMMARY:

  • Seasoned Business Analysis professional with 8 years of work experience in Banking, Healthcare, and Retail domains.
  • In - depth knowledge and experience with all phases and methodologies of Software Development Life Cycle including Waterfall, Agile/Scrum, and RUP.
  • Highly qualified in changing the needs of Business Users and Stakeholders to the Functional/Technical Requirements.
  • Served as a critical resource and liaised between Subject Matter Experts and Technologists throughout the project life cycle.
  • Define and document EDI business process requirements.
  • Monitor the flow of data through EDI applications to ensure all operational systems are functioning properly when needed .
  • Proficient in dealing with Standard Operating Procedures (SOPs ), Test plan , Laboratory information management system (LIMS).
  • Excellent conceptual and technical skills to create Business Requirements Document(BRD), Functional Specifications Document(FSD), Process Flow Diagram, and Detailed Design Document.
  • Experience conducting JAD (Joint Application Development) sessions with Stakeholders and Business Partners to resolve issues.
  • Expertise in creating project artifacts such as Business Requirements Document (BRD), Use Case Documentation, Requirements Traceability Matrix (RTM), Business Rules Spreadsheet (BRS), Functional Requirements Document (FRD), Data Mapping Document, and Systems Requirements Specification.
  • Strong experience in RUP Business Modeling process, complete UML artifacts related to Business Modeling, Requirement Elicitation, Analysis, Specification, Traceability, Validation, and Verification.
  • Performed GAP Analysis, SWOT Analysis, User Acceptance Testing (UAT) and Cost Benefit Analysis.
  • Proficient in design and execution of Test Strategy, Test Plan, Test Scenarios, and Test Cases based on the requirements for the applications.
  • Hands-on in using SQL queries to perform Data Analysis and Data Mapping on Oracle & Microsoft SQL Server Databases.

SKILL:

  • C, SQL, T-SQL, PL/SQL. SQL Server 2000/2005/2008
  • SQL Developer, SQL Navigator
  • Tableau
  • Shell Scripting
  • Informatica 9.1/8.6/7.x/6.x
  • DTS, DB2
  • Oracle 11g/10g/9i/8i
  • MS Access, MS Visio, MS excel, MS project
  • Tableau and Power BI
  • Share point
  • Microsoft PPM
  • SQL Server 2000/2005/2008
  • Teradata V2R4/R3
  • ERWIN 4.0/3.5
  • Oracle Designer
  • Oracle DML
  • Windows 95, 98, 00, NT
  • Windows XP, Vista, 7, 8
  • UNIX, MS-DOS
  • Oracle Data Integrator 10g

WORK EXPERIENCE:

Sr. Business Analyst

Confidential, Washington, DC

  • Led the resource planning effort and worked with Third Party Vendors (TPVs) for specialized services required for the project.
  • Identified potential cross-pillar dependencies, risks, and solutions for mitigation approaches.
  • Conducted all Scrum ceremonies (Backlog Grooming, Release/Sprint Planning, Estimations, Retrospectives).
  • Worked extensively with Quality Engineering to ensure Zero Defect Releases.
  • Coordinated with Senior Management modularize Coventry’s products to increase profits.
  • Facilitated Agile training sessions for team members.
  • Conducted various team building activities to increase morale and productivity.
  • Extensively gathered requirements from all users, experts, and key personnel to understand the functional requirements.
  • Developed and implemented SharePoint plan for organization-wide collaborative document sharing.
  • SharePoint Administration: User Setup, Security Permission, Site Configuration.
  • SharePoint Training: Trained all staff on tool features and business agreed upon usage.
  • Documenting: Change Release Process, Document Control Plan, Project Charter (Template) Process Definition (Template), SharePoint User and Admin Guide and Document (Template) Deliverables Log.
  • Responsible for creating UI mock ups using Balsamiq.
  • Performed Data Analysis and Data Validation by writing complex SQL queries using TOAD against the ORACLE database.
  • Led both internal peer review and external reviews of Use Case Specifications and in the process clarifying the finer details of the requirements.
  • Involved in developing Test Plans, Test Conditions, and Test Cases to be used in testing based on business requirements using Quality Center.
  • Worked closely with customers to understand their Vendor management system/technologies System (Fieldglass) and Gathered their integration requirement with our SaaS based applications and made recommendation for the custom solutions
  • Created and maintained the Requirement Traceability Matrix between the requirements and other products such as Design Documents and Test Plans.
  • Conducted User Acceptance Testing (UAT), System Testing, and Integration Testing.
  • Validated and helped verify defects to weed out cosmetic problems and kept the project on schedule.

Environment: OO Modeling, Web Sphere, Rational Requisite Pro, Rational Rose, DOORS, Rational SODA, RUP, UML, Load Runner, MS Project, MS Visio, SaaS, MS Office, Windows XP, JIRA.

Sr. Business Analyst

Confidential, Brooklyn, NY

  • Performed requirement analysis, design, and development of ETL mappings and processes on Informatica Power Center and Unix.
  • Worked with business analysts to identify the appropriate data elements for required capabilities.
  • Performed GAP Analysis between the current state and future for the business processes, data warehouse, and business intelligence/reporting environment.
  • Documented the requirements in Business Requirement Document (BRD) and converted them to Functional Requirement Documents (FRD) and Software Requirement Document (SRD) to User Stories for the understanding of the development team.
  • Assisted the Product Owner in compiling and prioritizing the Product Backlog on JIRA using prioritization technique MOSCOW.
  • Facilitated all the Sprint Ceremonies; Backlog Refinement, Sprint Planning, Daily SCRUM, and Sprint Review.
  • Time boxed Daily SCRUM meetings and resolved all impediments faced by development team.
  • Mentored and helped the team grow into a self-managing entity. Encouraged collaboration between the SCRUM team and product owner.
  • Maintained and monitored SCRUM Artifacts-Sprint Backlog, Sprint Tasks, and Sprint Burndown Charts using JIRA.
  • Analyzed and understood the business users' requirements for information and communicated them to the rest of the data warehouse team. Assisted Data Warehouse Data Analyst in analyzing existing reports.
  • Extensively worked in Data Requirement Analysis and Data Mapping for ETL process. Acted as consultant to the ETL and front-end programmers.
  • Also used designing tables in Hive, PIG, MYSQL using SQOOP and processing data like importing and exporting of databases to the HDFS.
  • Created Data Models, Data Flow Diagrams and ER diagrams using ERWIN to depict the Source-to-Target Mapping.
  • Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using RDMS MS SQL server queries for documenting and retrieving data from database.
  • Prepared Test Plans for Unit Test and System Integrated Testing of Informatica Session and Workflows.

Environment: Informatica Power Center 9.1/8.6, UNIX, Oracle 11g, SQL, PL/SQL, SQL Developer, Metadata Manager, Oracle Designer, MS Visio, JIRA, ERWIN, IBM Mainframe, Toad.

Sr. Business Analyst/Scrum Master

Confidential, Brooklyn, NY

  • Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support
  • Interacted with business representatives to understand the requirements and determined the best approach for timely delivery of information.
  • Ensured timely deliveries of work items to the Client.
  • Involved in Implementing ETL standards and best practices.
  • Reviewed Data Model and validated its feasibility to physical implementation.
  • Assisted the Product Owner in compiling and prioritizing the Product Backlog on JIRA using prioritization technique MOSCOW.
  • Facilitated all the Sprint Ceremonies: Backlog Refinement, Sprint Planning, Daily SCRUM, and Sprint Review.
  • Time boxed Daily SCRUM meetings and resolved all impediments faced by development team.
  • Mentored and helped the team grow into a self-managing entity. Encouraged collaboration between the SCRUM team and product owner.
  • Maintained and monitored SCRUM Artifacts - Sprint Backlog, Sprint Tasks, and Sprint Burndown Charts using JIRA.
  • Analyzed and understood the business users' requirements for information and communicated them to the rest of the data warehouse team. Assisted Data Warehouse Data analyst in analyzing existing reports.
  • Coordinated with the QA team in various testing phases by resolving the defects and ensuring smooth execution of Test Plans.
  • Created deployment documents and migrated the code to the production environment.
  • Investigated and fixed the bugs occurred in the production environment and provided on-call support.
  • Generated Reports and Dash Boards using Tableau for the Business Users and Senior Management.

Environment: Informatica Power Center 9.1/8.6, UNIX, Oracle 11g, SQL, PL/SQL, SQL Developer, Metadata Manager, Oracle Designer, MS Visio, JIRA, ERWIN, IBM Mainframe, Toad.

Business Analyst

Confidential, Long Beach, CA

  • Gathered the requirements from stakeholders and users by meeting them personally and by interviewing them. Utilized Requisite Pro to prepare a BRD by complying with the HIPAA regulations.
  • Profound understanding of insurance policies like HMO and PPO and Proven Experience with HIPPA 4010 EDI transaction codes and the new 5010 formats
  • Extensive HIPAA EDI 4010 transaction knowledge -835,837,277,278,270,271 and the new 5010 formats
  • Defined and clarified specifications for EDI Claim process through Multichannel communication with various departments.
  • Developed functional specs, gathered requirements and communicated with the developers.
  • Developed Use Case Diagrams, using ERD depicted clear relations associated with the entities.
  • Prepared Work Breakdown Structures (WBS) to comply with the triple constraint of time, cost and scope.
  • Conducted Lean Analysis throughout the project and conveyed team a message, “Think big, act small, fail fast; learn rapidly.”
  • Prepared a roadmap for a product that can exceed market and user expectations.
  • Followed Prototype model of SDLC in developing software.
  • Designed User Interfaces and mock up screens using HTML to validate the requirements.
  • Created and implemented a Test Plan and thereby assisted Quality Analysts to test the product in a timely manner.
  • Interfaced with Quality Analysts for Unit, Integration, System and User Acceptance Testing.
  • Interfaced with top management to ensure that IT initiatives and involvement were clearly communicated and understood.
  • Mitigated risks all the time; motivated all the team members to meet the deadlines since time was very limited.
  • Reviewed and analyzed the business environment and identical process improvements.
  • Evaluated alternative solutions and recommended solutions that best met the need of the business.
  • Defined and planned software releases in accordance with other software applications.

Environment: MS Visio, MS Office, .Net, VB.NET, ASP.NET, Java, PHP, XML, HTML, DHTML.

Business Analyst

Confidential, Menomonee Falls, WI

  • Worked with the business users to define business requirements and analyze the possible technical solutions.
  • Conducted Workflow, Process Diagrams, and Gap Analysis to derive requirements for existing systems enhancements.
  • Designed dashboard for decision making based on past sales trend and market research analysis.
  • Analyzed the Business and System Requirements of the application as well as Provide ad-hoc reporting and analysis.
  • Worked with front-end and back-end systems.
  • Successfully launched a Software-as-a-Service (SaaS) technology lead delivery service targeted to sales departments of enterprise technology sales departments
  • Performed User Acceptance Testing (UAT) for various web based and database related applications.
  • Interacted with the development and testing teams to improve overall quality of the software.
  • Developed Use Case, Functional, and Object Diagrams using Rational Rose.
  • Analyzed user problems including automated and manual business processes and identified, researched, investigated, defined and documented business processes.
  • Assisted the PM in performing Risk Assessment, Management, and Mitigation.
  • Worked extensively with Mercury Quality Center.
  • Worked extensively with the QA Team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: RUP, MS office 2003, MS Visio, MS Project, MS Share Point, Rational Test Manager,SaaS Data Stage, Mercury quality center, MS CRM.

Hire Now