PROFESSIONAL SUMMARY:

• 9 +years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Expertise in understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis.
• Experienced in working various domains such as Airline, Delivery Services, Hospitality Hotel etc. and Agile/Scrum and waterfall methodologies
• Products and services company specializing in enterprise application development, content management systems, and XML authoring.
• Create, maintain and distribute financial and operational reports in order to efficiently evaluate properties within the hospitality portfolio, while continuously updating reports to reflect current information
• Facilitated Joint Requirement Planning (JRP), Joint Application Development (JAD) and Rapid Application Development (RAD) sessions. Skilled in gathering user requirements by performing gap analysis.
• Experience in complex hotel and car central reservation systems. Vast knowledge of online transactions, highly experienced in IMS databases and applications.
• Experience in various domains including travel/hospitality (Sabre GDS, ATPCO, WWTE/Expedia, Orbitz etc), product development (SaaS) clients.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expert in user interface designing and creating screenshots using wire frames and comps, and expert in using tools like MS Project and MS Visio.
• Proficient in QA Automation process, HP - Quick Test Professional, HP-Quality center, JIRA, HP-Load Runner, Compuware Test Partner and Visual basic.
• Hands on experience with T-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity.
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, running Database Consistency Checks using DBCC commands.
• Experienced in Business Analysis, Data Mapping, Data Consolidation and Data Reconciliation
• Have good understanding with entire phases of Software Development Life Cycle SDLC .
• Expertise in Software Development Life Cycle (SDLC), Use Cases, Business Process Modeling Notation (BPMN), Object-oriented Analysis and Design, Rational Unified Process (RUP) and Rational tools used during all four phases of RUP: Inception, Elaboration, Construction, and Transition.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies and process mapping.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• 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.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes that span multiple projects
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCE:

Confidential, Egan, MN

Sr. Business Analyst

Responsibilities:

• Wrote business rules in source to target data mapping document to make it easy and clear for developers and testers
• Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding
• Functionally designed, tested, and implemented software for the Group Reservations organization.
• Charged with gathering management's informational requirements, developing the appropriate Cognos Business Intelligence reporting infrastructure
• Performed analysis of all data into, out of and within company in support of Data Warehousing efforts.
• Analyze the impacts of any new releases going into effect to minimize effects on corresponding systems.
• Work with the Business/Functional Architect and other planners to assess current capabilities and identify high-level requirements.
• Created Process Maps, Flow charts and Activity Diagrams for a detailed explanation of all the phases of the project
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Worked on data modeling and produced data mapping and data definition documentation.
• Created Use Case Models, Analysis Models, Design Models, Use Case Diagrams, Behavior Diagrams and Class Diagrams based on UML methodology using MS Visio 2003.
• Monitor and sort global distribution system (GDS) queues (or similar program) to maintain quality control.
• Created source to target mapping documents from staging area to Data Warehouse/Data Mart.
• Performed numerous SQL Statements to load and extract data to and from database for testing.
• Created multi set, set and volatile tables using Teradata.
• Used SQL within the target Teradata platform.
• Performed the Back-end testing manually by writing and executing SQL statements on Oracle Source Database and Teradata target.
• Performed in depth analysis of data and prepared weekly, biweekly, monthly reports using MS Excel and SQL.
• Participate in transitioning and to ensure a clear and complete understanding of requirements to the development team.
• Develops management reports, charts, graphs, and process maps and maintains data files
• Assist in translating requirements and use cases into test conditions and expected results for product, performance, and user acceptance testing.
• Work with the leadership, architects, and other team members to define metrics and performance goals.
• Review project deliverables for completeness and quality and compliance with established standards.
• Responsible for collaborating with Team Leads to coordinate project schedules, budgets, request management, and work authorization.

Confidential, Miramar, FL

Business Analyst

Responsibilities:

• Interpreted and analyzed passenger tariff, rules and routings. Prepared data for computer applications. Investigated complex problems determining solutions for accurate pricing.
• Worked in Revenue management handling analysis, review, and recommendations for competitive ticket pricing.
• Responsible for analyzing, testing, and distributing corporate pricing and sales contracts designed for revenue optimization.
• Maintained weekly meeting with Revenue Management (RM) to update work progress towards deadlines.
• As a Business Analyst for migration of the Inventory Management System to new vendor platform, gathered business requirements and mapped them to the vendor product offering, championed business and IT process changes to minimize customization costs, and created final product specifications
• Conducted JAD sessions with the management, different 3rd party vendors, users, and commercial and customer stakeholders for open and pending issues to develop specifications
• Documents business requirements, constructing workflow charts and diagrams, creates process documentation
• Gathered Business and Functional Requirements based on Agile Methodology.
• Documented cross functional requirements and walkthroughs for each system interface team
• Tracked and maintained the requirements to functionality traceability and use case traceability
• Documented current state of all identified processes through Subject Matter Expert (SME) interviews and consolidate findings into a unified Microsoft Visio mapping.
• Analyzed and evaluated the performance of the applications from various dimensions and conducted UATs for successful implementation to confirm and validate all the requirements was met
• Created Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Assisted Project Manager in setting realistic project expectations and evaluating the impact of changes on the organization and conducted project related presentations
• Extensively queried the SQL Server database using SQL to conduct data analysis.

Confidential, Costa Mesa, CA

Business Analyst

Responsibilities:

• Created with the project manager the project definition.
• Analyzed current Business Processes by gathering requirements, comparing requirements to commercial off-the-shelf applications, and then selected an application that fits the required business needs.
• Interpreted, evaluated, translated, analyzed and interrelated researched data, and developed integrated business analysis.
• Gather, understand and articulate Business Requirements from user interviews, surveys and observing general managers of each hotel property.
• Leveraged the Agile methodology to insure a fast, smooth, efficient delivery of work
• Lead meetings, collected and understood process-based requirements gathering, and can arranged end-user meetings based on objective facts.
• Summarized all of the research gathered and defining the scope of the solution, including what is not in scope.
• Develop B2B relationships with community developers, hospitality managements, property managers, leasing consultants and business owners to promote technological efficiency to their properties.
• Assess degree of alignment between business and supply chain strategy
• Wrote test scripts for User Acceptance Testing (UAT).
• Responsible for Direct Connect and Central Reservation System CRS Valhalla enhancements
• Work with the project manager and development team to create real cost estimates.
• Designed and developed Activity Diagrams, and Sequence Diagrams using UML.
• Performed ScrumMaster role and duties for Proof of Concept and maintenance cycles
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Worked closely with product development team, driving customer central reservation system product.
• Established a business Analysis methodology around the RUP (Rational Unified Process).
• Worked closely with Quality Assurance team to document the testing results in Quality Center for FASS- CMS
• Interacted with the testing team while developing the functional test cases and regression test cases.
• Provided consultative and technical support, as appropriate, to standing decision-making committees.

Confidential, Stamford, CT

Business Analyst

Responsibilities:

• Interacted with the business users and gathered requirements for the business definition.
• Created Functional Requirements Document (FRDs), Functional Specifications Document (FSDs) and Traceability Matrices for application development.
• Development and enhancement of Custom Application with Oracle Sales Analyzer
• Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply
• Chain.
• Gathered requirements for the integration of POS system with the supply chain system
• Worked on projects which used RUP and Waterfall methodologies.
• Created spreadsheets using MS EXCEL in data gathering stages for requirements mapping.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the specifications for the product.
• Performed GAP Analysis, designed new business process flows, and documented various business scenarios.
• Developed new relationships with vendors and negotiated special pricing and rates for hotel, travel and catering which resulting in company savings
• Prepared PowerPoint slides to effectively communicate with the business users and stake holders in the meetings.
• Used Quality Center tool for the purposes of Test Plan, Executing test cases in Test Lab.
• Knowledgeable of reservation procedures, including group blocks, Central Reservations System, and property management system
• Loaded hotel profiles into central reservation system for distribution to the global distribution systems.
• Served as a Business Liaison between the Business Users and the Developers helping them in understanding the Functional behavior of the Internal Systems.
• Conducted Cross-functional meetings to discuss the impacts from cross functional systems.
• Helped the Business Users while performing the UAT testing and helping them resolve the defects in the environment.
• Kept a track of all QAT and UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved and which were not using MS EXCEL.
• Facilitated Partner integration testing through triaging and routing the defects on a daily basis.
• Coordinated with the testing team while Smoke Testing at the time of deployment.

Confidential, Schaumburg, IL

Business Analyst

Responsibilities:

• Gathered user requirements and directed developers for practical deliverables.
• Projects were implemented on the Agile Framework - SCRUM.
• Conducted detailed analysis of business requirements and design of the high-level modules including creating a design document containing interactive diagram, sequence diagrams, screenshots of GUI and database mapping.
• Defined and documented business requirements with sufficient detail to enable customer sign-off
• Utilize JIRA Agile project tracking software to write and prioritize user requirements into stories and iterations for ongoing enhancements to internal demand management application.
• Collaborated closely with the technical team for solution development.
• Provided stub data (XML file) to developers at the start of the development phase.
• 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 in Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Performed job of contact point for all stakeholders (business, legal, compliance, development).
• 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