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.
• Monitor terms built in CDS to ensure DRA's & management of CSA Expirations using salesforce.com to resolves implementation of Quick Start programs issues. Performed standard maintenance for fare filing systems by Identifying/Updating ATPCO data issues and provided recommendations for QC pricing bulletin/Pricing Programs to ensure optimal performance
• 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, NY, NY

Business Analyst

Responsibilities:

• Served as an intricate team member in preparing Scope and Vision document. Helped manage scope and identify risks throughout the project life cycle.
• Led requirements elicitation meeting to obtain consensus and feedback on functional requirements and business rules.
• Responsible for requirement gathering from the Business Analyst’s and for preparing the Requirement Specification Document using Agile Methodology (SCRUM).
• Developed programs providing software development, maintenance and technical support to various airline companies utilizing the IBM Transaction Processing Facility (TPF) operating system.
• Performed detailed data analysis and assisted in building business process analysis model.
• Documented current and proposed process flow and conducted detailed gap analysis.
• Worked in conjunction with other team members, technical architects and developers to understand system integration and interface requirements.
• E-marketing experience through extranets (Expedia, Bookings.com, Sapphire and Open Hospitality) including the implementation and management of the global distribution system known as GDS for automated interfaces with websites such as Orbitz.com, Travelocity and many travel agencies around the world.
• Monthly and quarterly management meetings with travel liaison for consistent communication.
• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Used the Agile methodology to build the different phases of Software development life cycle. (SDLC)
• Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access
• Co-authored detailed Business Requirements Document and Functional Specification Document.
• Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams using Object Oriented Design (OOD) concepts and UML using Rational Requisite Pro.
• Mentored junior Analysts and programmers in the TPF programming design concepts.
• Assisted the technical team in writing high-level design document.
• Conducted highly interactive JAD sessions with project stakeholders to identify and resolve issues. Ensured consensus between Line of Business and IT Teams.
• Wrote specifications for various reports. Generated canned reports using Business Objects.
• Determined a testing strategy in conjunction with the QA team. Assisted in writing detailed Test Plan, Test Cases and Test Case Scenarios for system testing, integration testing and functional testing.
• Assisted in performing and coordinating unit, performance and functional testing.
• Presented reports and analysis to management.
• Coordinated User Acceptance Testing (UAT), developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director.

Confidential, Costa Mesa, CA

Business systems 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).
• Work closely with business stakeholders to prioritize the product backlog using JIRA in order to deliver the highest valued features quickly.
• Created Stored Procedures using Sql Server 2000 (T-SQL) to extract the data from one database and upload into another database and created script using Perl to verify if the data is loaded in the database tables.
• Performed System testing and Regression testing for a very large nationwide award-winning Social services Case management system named Financial Assistance and Social Service (FASS-CMS) System using HP Quality Center
• Assisted in developing a technical publication browser for a major aircraft engine company. Led the hands-on development of customized scripts for an SGML/XML-based authoring system, primarily for use within the defense and aerospace industries.
• Managed and coordinated one or more large requirements research efforts; performed specified data analysis and studied as requested, and developed and presented reports in support of various initiatives.
• Coordinated and supported the development and implementation of special research initiatives related to specific research goals.
• Documented business workflows textually as well as in UML diagrams (Activity diagrams) according to for the stakeholder review.
• 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.
• Define a road map to attain supply chain optimization
• Performed miscellaneous job-related duties as assigned.
• Conducted User Acceptance Testing.

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.
• Developed Visio diagram of application infrastructure findings in support of multiple ecommerce application decommissioning initiatives. Ensured SharePoint portfolio was updated with progress, milestones and agile / scrum methodologies.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
• Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the internal systems.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Responsible for providing customer service and hospital hospitality to patients and visitors in all areas of the facility
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Facilitated JAD sessions with the management, developers and analysts from all the dependent systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
• Responsible for capital projects, development cost for both hotel and commercial sections of the property.
• Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
• 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.
• Worked with the networking team with the integration of Spire Team with Jira
• Actively monitored requirements through Spire Team and Jira
• Created Testing Requirements Document (TRDs) and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
• Used XML to look up for the specific attributes and parameters needed for testing the web application in the QAT 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.