We provide IT Staff Augmentation Services!

Business Analyst Resume

Portland, ME

SUMMARY

  • Over all 7+ years of Industry experience as a Business Systems Analyst in Airline and Logistics Industry in Business analysis, data modelling, process flow and quality assurance skills.
  • Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
  • Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
  • Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
  • Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, and Agile/Scrum.
  • Experience in Scrum Process and thorough understanding of Extreme Programming (XP), Agile Software Development Methodology and Object Oriented Analysis (OOA).
  • Experience managing the financial liabilities of a successful rewards program
  • Deep understanding the knowledge of Risk analysis, Securities (Stocks and corporate bonds) and their valuation, Portfolio Management (risks and returns) and analysis, Asset Allocations Bond pricing, etc.
  • Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
  • Experience in Agile and Scrum Methodologies and related terminology such as Daily Scrum, Product Backlog, Release Burndown, Scrum Master, Sprint Planning Meeting, Taskboard, To - do and Work in Process Charts.
  • Proficient in developing Use case scenarios to enable design and development of applications using tools like Rational Requisite Pro, JIRA and Version One based on the SDLC methodology.
  • Used Agile Software Development process viz. Scrum, as this was a time bound project.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
  • Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
  • Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
  • Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
  • In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
  • Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
  • Extensively worked on creating customer information, low fare search for one way, two way and multi segments and generating the PNRs, modifying, and deleting the itineraries and PNRs and also importing PNR from NGTS application.
  • Expertise in Conceptual Data Modelling, Enterprise Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design, Metadata, Data Quality, Master Data Management and Data Governance
  • Assigned tasks among development team monitored and tracked progress of project following agile methodology.
  • Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
  • Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: C,C++,C#,VC++,VB,VB.NET,C#.NET, ASP.NET, Java, SQL, PLSQL.

Operating Systems: UNIX, Windows, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase.

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum.

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest.

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner.

PROFESSIONAL EXPERIENCE

Confidential -Portland, ME

Business Analyst

Responsibilities:

  • Used Agile Software Development process viz. Scrum, as this was a time bound project.
  • Analyze business requirements and segregated them into Use Cases and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Developed and drove continuous improvement initiatives in Booking, Frequent Flyer, Elite Sky Club, Elite Reservations and Airport Services.
  • Worked with different teams like Travel Port, Tuxedo, SOA, ACS, and Reservations to discuss different projects.
  • Various versions of the documents generated during the project were maintained and managed using Rational ClearCase..
  • Worked on recognition program to earn points toward a reward such as Bluetooth speakers, gift cards, and airline miles
  • Assigned tasks among development team monitored and tracked progress of project following agile methodology
  • Facilitate daily scrum, sprint planning and sprint retrospectives meeting, analysis and reporting.
  • Wrote Test plan and Test cases for the Integration testing and system testing.
  • Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
  • Worked with QA team with the aid of ClearQuest for the bug tracking and Mercury Test Director for Test Case Management.
  • Initiated and tracked change request from end users for system upgrades, changes and enhancements using JIRA
  • Continuous communication with the team to track requirements on rally and discuss to fix defects with JIRA tools, and corrected lesson learnt from each sprint.
  • Conducted database analysis to assess product functionality and quality assurance, to supportagileproduct development.
  • Developing Draft Vision Document, Functional Specifications, Glossary and Use Case Specification Document using Rational Rose based on RUP Iteration models.
  • Write and execute positive and negative test cases to ensure the data originating from the data warehouse (Oracle dB) is accurate through to the SQL dB in the applications.
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
  • Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
  • 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.
  • Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
  • Wrote SQL statements to extract data from the Tables
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Bugs that would enhance the usability of the application were logged using Rational ClearQuest.
  • Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
  • Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
  • Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
  • Worked with developers to make sure that they understood the Use Cases.
  • Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
  • Conducted business and system analysis during an integration project to reduce duplicate processing and data storage of travel reservation system.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), RUP, Visual Basic, SQL, SQL Server, Agile, GUI, Oracle, ACCPAC, C#.Net, LoadRunner, WinRunner.

Confidential, Honolulu, HI

Sr.Business Analyst

Responsibilities:

  • Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Conducted a needs assessment and aGap Analysisto understand the shortcomings of the existing system and evaluated the benefits of the new system and generated workflows.
  • Facilitate risk management workshops, recording risk and assigning risk for mitigation. Research and resolve system issues and perform application testing as necessary. Produce metrics reports from data derived from database as necessary for the project.
  • Identified gaps and performed gap analysis with respect to CMS requirements.
  • Worked in cross-teams withBusinessand FunctionalAnalyststo identify process improvement opportunities.
  • Learned about E-Commerce and different types of payment methods for conducting the same.
  • Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
  • Complete logistical reports for the Executive department through tracking and reporting airline miles and hotel reward points.
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Understand and articulate business requirements from user interviews and then translate requirements into functional and technical specifications - Handling sub accounts, Invoicing for cargo and direct billing, Handling non premium bearing transactions, Data mapping and Reporting specifications.
  • Generated Statements of Work for the Design and Implementation of CRM solutions based on Salesforce.com Methodology.
  • Liaison between all website Agile development groups and EliteAirlinesmarketing. Managed effort to promote consistency and communication between teams including gap, risk and issue analysis/ mitigation.
  • Ensure we are consistently and effectively measuring our rewards points assets and liabilities by partnering with accounting and finance operations counterparts
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Participated inrevenueprojections, pricing strategies, regular contract audits, and budget recommendations.
  • Involve in analyzing defects that have been reported in the JIRA and sending them over to the developers for a fix.
  • As part of product backlog grooming sessions, created user-centeredagilespecifications (user stories).
  • Involved in Joint Application Development sessions with SMEs and development teams and documented functional business requirements as product backlogs using JIRA
  • Participated inSCRUMSand discussed the open issues and statues.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Created user stories and maintaining and tracking them using JIRA.
  • Created and explained theUser Storiesto the Scrum Team and helped them design the Tasks.
  • Facilitated interviewing and brainstorming sessions with the stakeholders and SMEs in understanding the requirements pertaining toloyaltyprogram process.
  • Help identify, define, and implement user-roles and create user stories during the transition from waterfall to agile methodologies.
  • Providing technical support to merchants to maintain the clients'loyaltyduring cooperation.
  • Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend the most efficient solution for system design.
  • Facilitating priority meetings with stakeholders to help business understand the impact of the JIRA in prioritizing them
  • Worked with Agile Craft to improve the tool for Agile/Scrum/SAFe Teams, Business and Management.
  • Updateddata dictionaryuser-defined attribute definitionsin the metadata repository.
  • PerformedBusinessProcess Analysisand documentedProcess Design Document (PDD)to capture the end-to-end flow of processes in Sales and Distribution.
  • Updated tickets with status and sent email notifications timely and accurately.

Environment: Microsoft Office Suite, Case wise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, J2EE, VBScript, C#. DOORS, C++, NET, ASP.NET, Agile, Business Objects, Test Director, Load Runner, JAD

Confidential -Seattle, WA

Business Analyst

Responsibilites:

  • Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).
  • Performed safety and security checks throughout the flight by consistently facilitating open communication with crew members.
  • PreparedBusinessRequirements Document (BRD) by gathering requirements from all the stakeholders; translated BRD to Functional Specifications Document (FSD) and created prototypes.
  • Worked with flight scheduling, crew scheduling, flight operations and reservation channel management.
  • Created database objects like tables, indexes, views, user defined functions and stored procedure for data migration using SQL server.
  • Filtered bad data using complex T-SQL statements, UDFs and implemented various constraint and triggers for data consistency.
  • Created and reviewed billing schedule for Airline customers in SAP to match contracted billing schedule. This ensures accurate revenue recognition.
  • Conducted research regarding existing and prospective airline and airport clients, competitor activity, and market trends/opportunities
  • Maintained different release versions of FRDs and BRDs in Confluence and linked them with JIRA epics
  • Coordinated with development team to conduct daily scrum meetings and Sprint planning meetings, which involved creating user stories and epics for chosen sprint backlogs.
  • Worked withbusinessto get information related to flight scheduling, crew scheduling, flight operations, gained experience and knowledge.
  • Conducted problem solving analysis and provide timely resolutions to High Priority Production Call Tickets, Root Causes for Travel Port Agents andAirlines.
  • Appliedbusinessmodelling techniques/tools and structured methodologies for documenting and communication user requirements and functional specifications.
  • Created or modified many ETL transformations such as, format revisions, look up, handing of null values, decoding fields, merging of data, character set conversion, deduplication and so on.
  • Used common table expressions and temporary tables in various stored procedures; created various scalar functions and table valued functions.
  • Experienced in managing the Scrum Process with the coordination of scrum team in Agile Methodology.
  • Conducted analysis of pricing problems as reported by Travelport customers to determine if cause is data or logic error and take corrective action.
  • Created user stories and maintaining and tracking them using JIRA.
  • PreparedBusinessRequirements Document (BRD) converted into Functional Requirements Specification (FRS).
  • Maintained financial control and accountability on capital and operating expenses for targeted areas of Crew Technology and Airline Operations.
  • ImplementingBusinessAnalysis methodology cantered on Agile Scrum and involved in the system analysis and member GDS searches.
  • Created or modified many ETL transformations such as, format revisions, look up, handing of null values, decoding fields, merging of data, character set conversion, deduplication and so on.
  • Managed Airline Operations projects to ensure positivebusinessvalue and meet committed scope, cost, schedule and high-qualitybusinessresults.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury Test Director, Mercury Load Runner.

Confidential, Riverview, FL

Business Analyst

Responsibilities:

  • Supported full traceability among all artifacts throughout the software development life cycle
  • Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements
  • Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, Architects, SME’s (Subject Matter Experts) and Managers of various Business Units
  • Reviewed queries that were automatically build by Tableau and edited them as and when needed along with writing basic custom SQL queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports
  • Developed a thorough and repeatable software requirements methodology utilizing the Rational Unified Process (RUP) and Unified Modeling language (UML)
  • Creation of Business Process specifications, application designing using RUP, database schema design and implementation methodology
  • Defined the project methodology from RUP. Analyzed and redefined the business processes with specific UML documentation
  • Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access
  • Elicited requirements and provided specific business and technical requirements guidance for the
  • Created dashboards and user stories usingTableauto visualize compelling trends and to deliver actionable insights. construction of the system. The requirements set comprised of Business Requirements Document (BRD), functional requirements, Business and System Use Cases.
  • Constructed and maintained UML models using Rational Rose, and created use case diagrams, class diagrams and sequence diagrams for all the use cases
  • Co-ordination with multiple teams and integration architects, in performing analysis for issues regarding speed and stability
  • Conducted manual testing by observing every step in the requirements and test cases.
  • Execute test scripts, coordinated & conducted UAT testing.
  • Tracked and documented defects and communicated them to the technical developers.
  • Used Test Director for bug and defect tracking.
  • Wrote SQL Queries in Oracle for data manipulations.
  • Scheduled batches backups process to maintain customers and clients database
  • Participated in UAT (User Acceptance Testing) with all levels of User Groups.

Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, Rational Unified Process (RUP), Windows, UML, UNIX, MS-Project, MS-Office Suite, Casewise Corporate Modeller, Win Runner, Test Director.

Hire Now