Seasoned Business Analyst Finance & Airlines Domain

SHEETALRATHOD

*************@*****.***

PROFESSIONAL SUMMARY:

• Over 12 years of Business Analysis expertise with a strong focus on Finance and Airlines domains.

• Proficient in Project Management, Business Process Analysis, Release Management, Requirements Gathering, Data and Process Modeling.

• Well-versed in Software Development Life Cycle methodologies, including Agile and Waterfall models, with a keen understanding of phases and gates.

• In-depth knowledge of Retirements contribution process, Payroll Related Service process, and extensive expertise in Mutual funds, bond funds, Company stock funds, short term reserve funds, Target retirement funds.

• Vast experience in the Airline domain, encompassing Ecommerce, Maintenance, Data warehouse, and Data Migration. Skilled in ETL (Extract, Transform, and Load) of data into data warehouses/datamarts.

• Expertise in UML for visualizing and documenting artifacts using Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams, and Sequence Diagrams using MS Visio.

• Proficient in query languages like SQL.

• Collaborated with QA teams to develop Feature files, Test plans, Test scenarios, Test procedures, and Test cases, ensuring thorough software testing pre and post-completion.

• Proficient in creating/modifying service WSDLs for SOAP services and WADLs for REST services (XML web service interface layouts).

• Facilitated User Acceptance Testing (UAT) with stakeholders and business users, providing system configuration training.

• Strong verbal/written communication skills and analytical abilities, excelling as both an independent contributor and a collaborative team player. Actively involved in supporting BAU (Business as Usual) Processes and participates in the On-call rotation schedule.

TECHNICAL SKILLS:

AREA

SKILLS

BUSINESS ANALYSIS

Requirements Elicitation, Process Mapping and Modeling, Stakeholder Management, Gap Analysis, Business Case Development, User Acceptance Testing (UAT)

SCRUM/AGILE

Scrum Framework, Sprint Planning and Backlog Refinement, Daily Stand-ups, Sprint Reviews and Retrospectives, Product Owner Collaboration, Agile Metrics, Continuous Improvement

UML TOOLS

MS Visio

REQUIREMENT MGMT. TOOLS

JIRA, TopTeam, Version One, Ignite Service Design Platform (ICS), WinSCP, Agility, KDA, Requisite Pro, Clear Case/Clear Quest, MS Word, MS Excel, PowerPoint, Confluence, Rally, Data Studio, GIT Bash

TESTING TOOLS

Quality Center, Test Director, Win Runner, Load Runner

METHODOLOGIES

SDLC, Waterfall, Agile, RUP

WEB TECHNOLOGY/LANGUAGES

SQL, Mainframe, XML, HTML, CSS

EXPERIENCE:

The Vanguard Group – Malvern, PA

September 2014 – Current

Technical Business Analyst

Project Description:

As a dedicated BSA/Scrum Master for Corporate System, I am actively involved in migrating Lotus Note Domino Applications to either Appian or Office 365 platform. Additionally, I have contributed to various essential projects, including the Institutional eSetup application, facilitating plan rule setup, the Release Manager for the Participant Experience website, enabling individual participants to access personal investment information, fund performance, and educational materials. I also played a key role in the My Plan Manager application, a rewrite of the existing Plan Sponsor Bridge application tailored for Institutional Investors, empowering them to administer their plans efficiently. Additionally, I collaborated with a third-party vendor to streamline print mail processes, transitioning from in-house to external vendor printing.

Responsibilities:

Gathered requirements from functional designs, Decomp sessions, meetings, and business analysis, meticulously documenting them in Requirements documents stored on the project Confluence page.

Created Business Requirement specifications, Use Cases documents, and Error validation documents, ensuring clear project scope and alignment.

Identified and documented data sources and transaction format validation rules crucial for accurate validation of various transaction files.

As the Scrum Master, I effectively created business stories, development stories, analyzed story points, and prepared Business Capabilities Document, driving the successful delivery of projects.

Collaborated with multiple teams, including offshore teams and integration architects, to analyze and address validation, allowable file size, and UI components issues.

Conducted comprehensive training sessions for end users and CRAs, providing detailed training manuals and performance scenarios documentation.

Utilized mainframe XML strings to efficiently pass print files to third-party vendors for printing and delivery to participants.

Successfully managed release planning, pre-elevation meetings, deployment scheduling, communication plans, and elevation activities.

Provided functional, operational, and basic technical support for diverse applications, ensuring seamless operations and resolving issues promptly.

Delivered first-level technical support by triaging and resolving issues, escalating complex problems to appropriate teams, and maintaining detailed incident logs to analyze recurring issues.

Leveraged expertise in Oracle, SQL Server, and MySQL to support database-related tasks, including query optimization, data migration, and troubleshooting, ensuring data integrity and performance.

Implemented Agile development methodologies to manage project timelines, facilitate daily stand-ups, and ensure continuous delivery of stakeholder value, enhancing project transparency and adaptability.

Collaborated with DevOps teams to streamline deployment processes, implement CI/CD pipelines, and automate testing, resulting in faster and more reliable software releases.

TD Bank N.A. – Mount laurel, NJ

May 2014 – August 2014

Senior Business Analyst

Project Description:

The project focused on implementing a check processing system for the Check fraud detection tool called Enterprise Duplicate Detection (EDD) from IBM. EDD serves as a vital component in a multi-channel check deposit automation strategy, offering real-time duplicate item detection across multiple days and points of presentment. The system maintains a configurable check code line repository to store data for a specified timeframe, supporting bulk item uploads from EDD gateway or other applications via X.9.

Responsibilities:

Conducted brainstorming sessions on global calls to gather comprehensive Business Requirements, effectively communicating them to IBM for project alignment.

Assisted backend systems in defining web services (Java Components) to meet project requirements for the existing vendor (Symcor).

Determined necessary changes in web services to efficiently handle file loads.

Thoroughly documented the process for storing and implementing application upgrade patches (iFixes).

Successfully loaded ICRE files (Input Creation File from CPCS capture) to the EDD Landing Zone (source) using WinSCP.

Applied functional understanding of VB.Net, C#, Visual Basic, Classic ASP, and .Net Framework versions to align technical solutions with business requirements, enhancing communication and solution delivery.

Coordinated and managed multiple software releases, ensuring seamless deployments by working closely with development, QA, and operations teams, utilizing Azure DevOps for tracking and versioning changes.

Handled production support for essential applications, minimizing downtime and enhancing system reliability through effective incident triage and collaboration with technical teams.

Managed project lifecycles using Waterfall and Rapid Application Development methodologies, ensuring thorough completion of each phase from requirements gathering to deployment.

Conducted and coordinated manual testing, reviewed automated test scripts, and provided feedback to ensure comprehensive test coverage and high-quality software releases.

Capital One – Vienna, VA

January 2014 – May 2014

Business System Analyst/Scrum Master

Project Description:

During my tenure, I played a pivotal role in creating the real-time messaging (RTM) infrastructure, facilitating seamless communication between Bank Tellers, IVR front systems, and Backend systems to support Capital One's real-time middleware system. My responsibilities included managing the creation of Integration services and Business Layer Services, encompassing Business System Analyst activities from project intent through closure for RTM.

Responsibilities:

Collaborated with client systems and backend teams to define web services that fulfilled project requirements, ensuring efficient and seamless communication channels.

Proficiently created and modified service WSDLs (XML web service interface layouts) for SOAP services, optimizing service interactions.

Successfully developed and modified service WADLs for REST services, promoting effective data exchange within the RTM infrastructure.

Created Data Transform requirements for the development team to enable smooth API services development.

Thoroughly documented the scrum's day-to-day activities, procedures, policies, and limitations, utilizing Version One to identify process gaps and improvements effectively.

Skillfully crafted the Pulse Page for individual API and SOAP services, securing necessary approvals from the Governance board.

Created comprehensive High-Level Design documents for API services, ensuring clear and successful design implementation.

Demonstrated versatility by creating and maintaining services across various lines of business, with primary focus on Card and Bank (consumer and retail) Services.

Engaged stakeholders to gather and document business requirements, translate them into technical specifications, and ensure alignment with project goals, enhancing satisfaction and outcomes.

Developed and executed change management plans, identified potential risks, and created mitigation strategies, ensuring smooth transitions and minimal business disruptions.

United Airlines – Houston, TX

December 2012 – December 2013

Senior Business Analyst/PM

Project Description:

My involvement in the United Airlines Integration program aimed to seamlessly integrate IT applications between United Airlines and the earlier Continental Airlines. As part of this program, I focused on the TRAX and CAMPS applications (Maintenance System Compliance), extensively utilized by field engineers, inspectors, and mechanics to assess aircraft maintenance performance and conditions. My efforts included ETL processes, transferring data from the TRAX application (a third-party maintenance program) to the CAMPS system (formerly owned by Continental). The project encompassed the development, enhancement, support, maintenance, and overhaul of related IT applications, ensuring seamless integration. Additionally, I took on the role of a Project Manager for developing a web-based application from a client base application for maintenance work packages and managed Ab-Initio tools/licenses for Data mapping.

Responsibilities:

Meticulously identified and documented data sources and transformation rules essential for populating and maintaining data warehouse content.

Conducted comprehensive training sessions for end users, while meticulously documenting various training manuals.

Collaborated closely with multiple teams and integration architects, conducting in-depth analyses to address issues related to speed and stability.

Proficiently handled data mapping, logical data modeling, and effectively utilized SQL queries to efficiently filter data within the database. Created Data Mapping Documents and successfully performed Data Extraction and Data Compilation using SQL queries.

Actively participated in system workflow analysis and contributed to the overall workflow diagram for the website.

Created and maintained detailed technical and user documentation, ensuring stakeholders had access to up-to-date information and resources for effective application use and support.

Identified process improvement areas and implemented changes to enhance efficiency, reduce costs, and improve service quality, demonstrating a commitment to continuous improvement.

Demonstrated excellent verbal and written communication skills by preparing detailed reports, presenting findings to stakeholders, and facilitating workshops to ensure clear understanding and alignment across teams.

Delta Air Lines, Atlanta, GA

June 2011 - November 2012

Business Analysts/PM

Project Description:

During my tenure as a BA/PM for the Polaris project, I played a crucial role in rewriting Delta.com web applications. My responsibilities included handling three modules significantly impacted in the SkyMiles system due to changes in web-facing applications on delta.com. These modules encompassed Login changes for Delta External Vendors, SkyMiles Enrollment, and Email transactions for Enrollment and Profile Updates. Delta continuously sought to add functionality for these partners and upgrade existing applications to support seamless changes. The project also entailed modifying non-air accrual and redemption processes, establishing new partner setups, and maintaining existing applications on Delta.com web and mobile platforms.

I contributed to the enhancement of Skymiles enrollment, focusing on the optimization of profile information management. My primary responsibility involved developing and maintaining API integrations between ticketing systems and profile databases. By ensuring seamless communication between these platforms, I facilitated efficient retrieval of customer profiles during ticket booking processes. I was responsible for developing and maintaining API integrations to facilitate seamless communication between ticketing systems and profile databases.

Responsibilities:

• Conducted an in-depth study of the current SkyMiles application and SkyMiles program's customer-specific business rules, practices, and user requirements. Prepared comprehensive requirements for necessary changes in accrual and redemption processes for new and existing partners.

• Collaborated closely with the on-site technical lead and the offshore team for functional enhancements and application interface development and delivery, ensuring successful project execution.

• Utilized mainframe to efficiently communicate with third-party vendors and facilitate the seamless passing of login data for Single Sign-On.

• Assisted in test plan preparation, reviewing test plans, and providing support for unit and integration testing, ensuring comprehensive quality assurance.

• Performed meticulous System Testing to ensure compiled software components adhered to Project Standards, Performance Criteria, and Functional specifications.

• Played a key role in User Acceptance Testing (UAT), system testing, integration testing, and build verification testing, working closely with stakeholders for successful user acceptance.

• Acted as a Subject Matter Expert (SME) in loyalty, collaborating with Delta External Vendors to support the successful introduction of new functionalities through web applications.

EDUCATION

MBA – 2010

Goldey Beacom College, USA

Contact this candidate