YASWANTH B
************@*****.*** +1-813-***-**** Open to Relocate
Summary
HRIS Business Systems Analyst with 5+ years of experience translating HR technology requirements into governed system workflows, using SQL, Power BI, Workday reporting concepts, and UAT evidence to support HR and payroll stakeholders. Skilled at documenting BRD and FSD artifacts, mapping source-to-target fields, and running RCA on integration defects across regulated environments. Applies AI prompt workflows and Power Query automation to shorten recurring reporting cycles while keeping audit trails intact.
Skills
HR Systems & Reporting: Workday reporting, Workday business processes, EIB loads, HRIS data validation, benefits and payroll reporting, HCM field mapping
Analytics & BI: Power BI, DAX, Power Query, Tableau, Excel, KPI dashboards Databases & Query: SQL, SQL Server, PostgreSQL, joins and CTEs, window functions, reconciliation queries Business Analysis: BRD, FSD, requirements gathering, process mapping, UAT test plans, requirements traceability matrix Governance & Controls: ITIL change management, SOX-style control evidence, audit documentation, RCA, data governance AI & Automation: AI prompt workflows, Copilot Studio concepts, prompt engineering, Airflow orchestration, Git Delivery & Collaboration: Agile, Scrum, JIRA, Confluence, stakeholder facilitation, vendor coordination Experience
Business Systems Analyst May 2025 – Present
JPMorgan Chase USA
– Documented BRD and FSD artifacts for a treasury services reporting workstream, mapping SQL source fields to downstream Tableau views reviewed by operations managers each sprint.
– Built Power Query routines that consolidated recurring deposit-account extracts into one validation workbook, cutting manual reconciliation steps for the commercial banking reporting team across weekly cycles.
– Analyzed credit card exception trends in SQL and Tableau, traced a recurring break to one account-servicing review step, and recommended a targeted process revision over a full report rebuild that operations adopted.
– Reduced ad hoc reporting requests by 22% by standardizing reusable SQL query templates and Tableau dashboard filters for retail banking stakeholders, closing repeat questions at the monthly review.
– Coordinated UAT evidence for a reporting change tied to ITIL change management, logging defects in JIRA and confirming audit-ready sign-off before release.
Business Systems Analyst Aug 2022 – Jul 2024
Capgemini India
– Developed Power BI dashboards with DAX measures for a manufacturing client, tracking production downtime and work-order KPIs that plant supervisors reviewed in weekly operations meetings.
– Validated Azure Data Factory pipeline outputs feeding a quality-metrics reporting mart for an industrial operations client, documenting source-to-target mappings and flagging mismatched fields before release.
– Chose a staged Power Query refresh over a live connection for an automotive client’s supplier report because the source system locked during business hours, keeping the overnight load stable.
– Consolidated 6 data sources into one Power BI reporting view for a manufacturing client, replacing separate spreadsheets and giving the delivery team a single KPI reference across recurring reports. Business Systems Analyst Sep 2020 – Jul 2022
Accenture India
– Gathered reporting requirements from a retail client’s merchandising team, translating inventory and POS questions into SQL queries and Tableau views that supported recurring category reviews.
– Documented BRD sections and process maps for a consumer goods client’s reporting intake, giving the delivery lead a traceable record of scope changes raised during sprint reviews.
– Kept a manual Excel reconciliation alongside the automated SQL check for a retail client’s weekly feed because the source file arrived late, preserving accuracy until the upstream fix shipped.
– Improved data accuracy by 18% on a consumer goods client’s recurring sales report by adding SQL validation checks and UAT scenarios that caught field mismatches before distribution. Projects
HR Reporting Validation Workbook SQL, Power BI, Excel
– Built a SQL validation workbook comparing employee headcount extracts against a Power BI summary, flagging mismatched department codes before monthly HR reporting closed.
– Documented the reconciliation steps and exception rules in Excel, giving reviewers a repeatable checklist that cut repeat questions during the reporting handoff.
Benefits Integration Defect Tracker SQL, JIRA, UAT
– Modeled a benefits eligibility feed in SQL and logged field-level mismatches in JIRA, producing a defect tracker that mirrored a carrier integration review cycle.
– Wrote UAT scenarios covering enrollment and termination cases, then mapped each test back to its source field so reviewers could confirm coverage before sign-off.
Education
University of South Florida Tampa, FL
Master of Science in Computer Science GPA: 4.0 / 4.0