SUMMARY

• Business Analyst/ MBA with 11 plus years of hands - on experience with clear understanding of Business Process Flow, Business Analysis and retiring IT systems.
• A self starter, team player with excellent communication skills and ability to exhibit strong Analytical, problem solving and leadership skills.
• Extensive experience in all the stages of Software Development Life Cycle (SDLC).
• Experience in Project Management, Gathering, Analysis & Management of Requirements, Business Reengineering, Business and Functional Analysis, Systems Analysis and Design, Quality Assurance, Gap analysis, Use case analysis and design, end-user support and documentation.
• Over 11 years of experience as Business Analyst/Data analyst/ Business Intelligence Analyst in Finance, Telecom, E-commerce and Airlines.
• Expert Confidential documenting specifications for Advanced Data Visualization/ Reporting (Tableau, SSRS).
• Thorough experience in iterative life cycle methodologies such as Agile as well as traditional waterfall.
• Extensive expertise in SDLC (Software development life cycle), STLC (Software testing life cycle), RUP (Rational Unified Process) and UML (Unified Modeling Language).
• Adept with requirements engineering describing them in Hierarchical Task Analysis, Task Descriptions, Data Flow models & Data Diagrams (Class Diagrams).
• Efficient with scripting Business Requirement Documents (BRDs), Functional Specifications Documents (FSDs).
• Knowledge of Capital markets, securities valuation, derivatives (Options), futures, and Anti Money Laundering (AML).
• Proficient in creating Use Case diagrams, Class diagrams and Behavior Diagrams (Sequence diagrams, Collaboration Diagrams and Activity diagrams), with expertise in Object Oriented Analysis & Design (OOAD) methodology.
• Good knowledge of Business Process Modeling and Business Re-Engineering
• Created Dataflow analysis using use cases, dataflow diagrams, state diagrams, activity diagrams, class diagrams and collaboration diagrams.
• Extensive knowledge of financial statements, Derivatives, Capital Management, Portfolio Analysis, Amortization and Budgeting.
• Facilitating Joint Application Development (JAD) Sessions for requirements gathering and business area analysis to identify business needs and technological improvements.
• Understanding and Defining Business Process, Defining Project Scope, and Gathering and Understanding of User Requirements through extensive interactions with users, developers, and other stakeholders.
• Expertise in all Rational tools including Rational Rose, Rational Clear Quest, Rational RequisitePro, Rational Clear Case.
• Documented Business Requirement, Use Case Specification, Functional and Non-functional Specification, System Requirement Specification, UML diagrams (Use Case, Class and Sequence), Traceability Matrix, Project Estimate, Change-Version Control, Training and User Manuals, Master Test Plan Review (Integration, System and Acceptance).
• Extensive experience in Project Management Planning, Resource Allocation, Task Allocation and Monitoring of Tasks using MS Project.
• Expert in GAP Analysis and transformation planning from current AS-IS situations to target TO-BE situations.
• Expertise in tracking changing requirements using requirements management tools like Rational RequisitePro.

TECHNICAL SKILLS

Methodologies/ Visual Modeling / Software Development Tools: RAD, SDLC, Product Life Cycle, SWOT Analysis, GAP Analysis, Cost Benefit Analysis, Cost Effect Analysis, Unified Process, Agile Development and the employment of System Development Life Cycle Methodologies, SCRUM

Operating systems: Windows 95/98/NT/2000/XP

Confidential Tools: MS Project, MS Visio, MS Office, MS Outlook

Languages: SQL, T SQL, Java

Tools: Word, Excel, Rational Rose, RequisitePro, Clear Quest

Databases: Oracle, SQL Server 2012

Skills: OOAD, UML, RUP, SDLC, JAD

Version Control: Rational Clear Case

Testing Tools: ALM Quality Center

Reporting: SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Groomed and documented requirements for front-end screens with the Product teams. Extensively worked with the UX designers to design mock-ups. Broke down larger stories into smaller User stories based functionality (and after the team’s approval during Grooming sessions). Documented User Stories and Epics in Jira.
• Groomed and documented Technical Stories for the Back-end (for Rest APIs) including stories for back-end validations. The Technical Stories were focused on HTTP requests and responses for the APIs- GET, POST, PUT and DELETE.
• Documented Reporting Requirements for the all the offline and in-line reports in the EMTR application. Also documented Technical Stories for database changes to support reports including Data Mapping. Wrote test cases for testing reports.
• Documented requirements for Dashboards specific to Tableau’s environment.
• Participated in Sprint Planning sessions in prioritization of stories, capacity planning and preparing the Sprint Summary Report.
• Wrote more than 2000 UAT test cases for various modules in the EMTR application.
• Prepared source-to-target mapping for data migration efforts.

Confidential

Sr. Business Analyst

Responsibilities:

• Analyzed and documented business requirements for FOS changes to enhance existing processes in FOS for Flight Attendants. Wrote Business Requirement Documents (BRD) and also analyzed the Technical Specification documents with the development team. Used Sharepoint to store the documents.
• Translated business requirements to functional specifications. Also created GAP analysis documents.
• Wrote almost 700 test cases to test various processes in FOS (for example the sequence assignment process to test Duty Limitations and Rest alerts) and to validate the data coming into FOS from the Preferential Bidding System (data validation was based on XSD schemas generated by PBS). Documented test cases in ALM Quality Centre.
• Analyzed and documented requirements for Change Requests and also wrote test cases to test the CRs and also Regression tested related requirements for any possible impact.
• Documented the Data Requirements (including data mapping) for various schemas in FOS, such as for the Reserve Flight Attendant List, Flight Attendant Activity Report etc.
• Extensively participated in JAD sessions for requirement elicitation. Also participated in daily Stand-up meetings to discuss roadblocks and possible resolutions.
• Utilized ALM Quality Centre to generate the Requirements Traceability Matrix and also utilized it to track bugs.
• Created Business Process Modeling Notation (BPMN) diagrams, Use Case Diagrams and Component Diagrams. Used Confidential Visio to create the diagrams.
• Created many Wireframes to enhance the existing UIs in the Preferential Bidding System and the Reserve Open Time Assignment Application. Used Confidential Visio to create the Wireframes.
• Wrote Use Cases for web services for the Training Bidding System intended to be facing the users (Flight Attendants).
• Planned and facilitated meetings with the Application Managers, and Product Owners to estimate task complexity, timelines and project go-live dates. Monitored project progress with Scrum KPIs.
• Analyzed and documented business requirements and technical specifications for Data Migration from Legacy US to Legacy AA- Flight Attendant Personnel Data, Flight Attendant Qualification Data and Equipment Data was migrated. Wrote Data Interface specifications- specifications included data transformation logic and data mapping between the source and the target. Data Migration standards were aligned with the existing Legacy AA’s Data Standards.

Environment: UML, Java, XML, XSD, PL/SQL, TOAD, MS Office Suite, Jira, Mainframe, HTML, Oracle 11i, SharePoint, Visio.

Confidential, Dallas, TX

Sr. Business Analyst

Responsibilities:

• Created new, user-interface designs, mock-ups, and wireframes.
• Created data mapping to map data between source and destination including complex transformations.
• Extensively created API data mapping for the newly enhanced front-end data elements with the back-end schemas.
• Documented specifications for improvisations of existing dashboards (in Tableau) and conducted Gap Analysis for the same (including the Gap in data requirements). For e.g. leveraging Tableau’s Charts/ Maps, Funnel Charts (visualizing website statistics) etc.
• Documented business requirements for editing/ improving web pages (deleting content, adding content, dynamic blogging, changing graphics, improved data usage reports etc.).
• Extensively created API attribute mapping by analyzing request/ response for the new/ newly enhanced data elements for downstream and middleware applications.. Ability to read code from XML.
• Implemented Object oriented Analysis and design (OOAD) methodology to analyze the requirements.
• Analyzed business requirements into high level and low level Use Cases, Activity Diagrams using MS Visio following UML. Also incorporated wireframes in the BRD.
• Analyzed requirement document by identifying ambiguous, incomplete and incorrect requirements. Helped in developing attribute matrix and functionality traceability matrix.
• Used SharePoint/ Prism to store documents and Rally to document User Stories. Fully conversant with using Q and ATT Connect.
• Created Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagrams and Entity Relationship (ER Diagrams) in MS-Visio.
• Reviewed, analyzed and documented change requests arising from requirements-change/defects using Clear Quest.
• Analyzed requirements and worked closely with the project manager to prepare documents such as Business Requirements Document (BRD) and System Requirements Document (SRD).

Environment: UML, Java, XML, XSD, PL/SQL, TOAD, MS Office Suite, scrum (Agile) implementation, IBM Rational Software Modeler, HTML, Oracle 11i, SharePoint, Visio.

Confidential, Los Angeles, CA

Sr. Business Intelligence Analyst/ Scrum Master

Responsibilities:

• Confidential has implemented the MiSiS application from ground-up for its client Los Angeles Unified School District (LAUSD)- nation’s second largest school district with over half a million students and 30,000 teachers. My Integrated Student Information System (MiSiS) represents the next generation of the District’s solution for entering, managing, analyzing, and reporting all data connected to students and staff.
• Apart from everything else this project involved retiring more than 8 legacy systems (including the Learning Management Systems) that were serving the District’s needs. I was involved in writing business/technical specifications for data interfaces (ETL), reports/ dashboards, screens for web based application and data cleansing.
• Actively worked with business to define the requirements and to drive adoption of MDM solution. Coexistence Style Operational MDM was implemented.
• Gathered, analyzed and documented requirements for the ‘Golden Record’ in a multi-domain implementation- student domain, faculty domain, facilities domain etc.
• Performed initial Data Profiling on raw data to determine which ones to clear for downstream processes and which ones to reject for the business to rectify.
• Participated in keeping the Business Metadata Definitions updated.

.

Confidential, San Jose, CA

Sr. Business Analyst

Responsibilities:

• Process Flow analysis, Gap analysis, Solution definition.
• Presented enhancement requests to the Change Control Board (traced and logged changes using and Change Request logs). Also, re-baselined the requirements based on approved change requests.
• Worked with business teams and development team towards defining and developing front-end UI design and usability experience (UX).
• Used TFS and SharePoint to manage requirements and store documents. Linked Tasks (TFS) on daily basis.
• Served as the Scrum Master for many Sprints. Lead the daily Scrum meetings and also monitored Tasks enter by the Team (TFS) on daily basis.
• Used Visio to create detailed mockups to capture the usability requirement as defined by the business teams SME.
• Wrote complex SQL queries involving usage of joins, group by, functions (count, sum, row number, rank, date), Case statements, CTEs, Temp tables to sample the data.
• Adept Confidential Excel data analytics (Pivot Tables, Vlookup etc.).
• Conducted One on One requirement discovery interview sessions. Conducted JAD sessions with representative form Technical and business teams.
• Creating SRS (Writing presentational and functional Use Cases) documents from the BRD.
• Breaking Business requirement in to functional, non-functional and system requirements
• Created test scripts and coordinated SIT and UAT activities toward product acceptance and GO-Live
• Creating functional and presentational Use-Cases, Business Process modeling, Activity diagrams etc.
• Project Planning and timeline adherence and managing risks against triple constraints of scope, time and budget

Environment: UML, IBM Web sphere Modeler, T-SQL, MS Office Suite, scrum (Agile) implementation, IBM Rational Software Modeler, .Net, HTML, SQL Server 2000 (SSRS, SSIS), Oracle 11i, SharePoint, Confidential Access