Jordan Ramirez Senior Business Analyst
Chicago, IL • jordan.ramirez@gmail.com • +1 312-555-0166
Profile Summary
- Senior Business Analyst with 8 years of experience on airline customer and operations systems at a major US airline and a global consulting firm, focused on requirements, process modeling and UAT for apps that travelers and airport staff use every day.
- Hands-on with requirements tools (Jira, Confluence), modeling (Visio, Lucidchart), data (SQL, Snowflake), BI (Tableau, Power BI) and API testing in Postman against REST and JSON services.
- Deep experience in stakeholder workshops, user stories with Gherkin acceptance criteria, current-state and future-state BPMN and source-to-target data mapping, using BABOK techniques and a traceability matrix on every release to ship releases that clear UAT on the first round.
- Works closely with product owners, developers, QA and airport operations in a SAFe release train with 2-week sprints, from discovery workshops and backlog refinement to the go or no-go call before release.
- Coaches newer BAs on user story writing and SQL for data checks, runs the monthly BA community of practice, and wrote the team’s requirements traceability playbook.
Technical Skills
- Requirements & Documentation:
- User stories, BRDs, Acceptance criteria (Gherkin), Functional specs, Use cases, Non-functional requirements, Traceability matrix
- Modeling & Diagramming:
- BPMN 2.0, Visio, Lucidchart, UML, Swimlane diagrams, Value stream mapping
- Data & SQL:
- SQL, Excel, Power Query, Snowflake, Python, Data profiling, Source-to-target mapping
- BI & Reporting:
- Tableau, Power BI, DAX, KPI dashboards
- Delivery & Collaboration Tools:
- Jira, Confluence, Miro, Figma, SharePoint
- Methods & Frameworks:
- Agile, Scrum, SAFe, Kanban, Waterfall, BABOK
- Systems, APIs & Testing:
- SDLC, REST APIs, Postman, JSON, Swagger, TestRail
Education
Work Experience
- Ran 24 discovery workshops and job shadowing sessions with airport agents and call center leads for the self-service rebooking flow in the United app, using Miro story maps to settle 61 open questions before design started.
- Wrote the BRD and functional specs for rebooking during irregular operations, plus API interface specs with the reservations team, and kept a traceability matrix in Confluence linking all 312 requirements to stories and test cases.
- Split the rebooking epic into 190 user stories with Gherkin acceptance criteria in Jira and ran weekly backlog refinement with the product owner and 3 scrum teams, cutting stories sent back mid-sprint from 22% to 6%.
- Mapped current-state and future-state delayed-bag reporting in BPMN 2.0 on Visio across 5 hubs, then ran a gap analysis against the WorldTracer integration that removed 9 of 23 manual handoffs at the counter.
- Wrote SQL in Snowflake to profile 2.4 million rebooking records and built the source-to-target mapping for the MileagePlus integration, catching 37 field mismatches before the first test load.
- Compared 3 vendors for self-service bag tag kiosks against 48 scored requirements and wrote the business case with a cost-benefit analysis, which won $3.2M in funding for the chosen option.
- Planned UAT for 9 app releases with TestRail scripts traced to requirements, coordinated 40 airport and call center testers and triaged defects with QA in Jira, cutting defects found after release from 11 to 2.
- Ran the change impact assessment and training for 6,000+ airport agents moving to the new rebooking screens, with quick reference guides and 2 weeks of hypercare, reaching 91% daily use within 60 days of go-live.
- Wrote the requirements and user stories for a Salesforce Service Cloud rollout at a regional bank client, running 14 workshops with contact center managers to get scope signed off 2 weeks ahead of plan.
- Built source-to-target mappings in Excel and SQL for an SAP S/4HANA migration at a manufacturing client, covering 1,800 fields and cutting failed records in test loads from 12% to under 1%.
- Wrote UAT scripts and user guides for a ServiceNow HR portal used by 3,200 employees at a hospital network client, which moved 88% of HR requests to self-service in the first quarter.