ABHI KARANAM
*********@*****.*** +1-203-***-**** Open to Relocate (USA)
Summary
Business Systems Analyst with 5+ years of experience translating HR and enterprise system requirements into governed reporting and integrations across healthcare and regulated operations. Skilled in Workday business processes, SQL and Power BI reporting, ITIL change management, and audit-ready controls, partnering with HR stakeholders and vendors from requirements elicitation through production deployment.
Skills
HR Systems & Business Processes: Workday (reporting, business processes, security, integrations), HCM data workflows, benefits carrier integration inputs, travel and expense reporting data, SAP Fieldglass reporting extracts Business Analysis & Delivery: requirements elicitation, BRD/FSD documentation, UAT test case design and execution, stakeholder workshops, defect logging and triage, vendor coordination Governance & Change Management: ITIL change management, SOX-style control documentation, audit evidence preparation, access and security review documentation, data reconciliation controls Analytics & BI: Power BI (DAX, Power Query), Tableau, Excel (advanced), KPI report design, executive and recurring MIS reporting
Programming & Query Languages: SQL (PostgreSQL, SQL Server, Snowflake, Redshift), Python (Pandas, NumPy) Data Integration & Cloud: ETL validation, source-to-target mapping, AWS (S3, Glue, Athena, Redshift), Azure Data Factory, dbt, Airflow
AI & Process Automation: generative AI tool usage for documentation and analysis, prompt engineering, Copilot Studio agent prototyping, AI-assisted requirements summarization Collaboration & Version Control: JIRA, Confluence, Git, Agile/Scrum Experience
Business Systems Analyst Jan 2025 – Present
Optum USA
– Gathered and documented business requirements for Workday-aligned HCM reporting workflows, producing functional specifications that guided payer operations and HR stakeholder sign-off.
– Designed SQL and Power BI reporting models consolidating workforce and operational datasets, establishing validation rules and reconciliation checks for recurring enterprise reporting.
– Analyzed claims denial trends across provider groups using SQL and Tableau, identifying a spike in authorization exceptions that prompted operations to revise the prior authorization review workflow.
– Standardized change request documentation for system configuration updates using JIRA and Confluence, reducing manual evidence-gathering effort by 24%.
– Leveraged generative AI tools and prompt engineering to draft and summarize requirements artifacts, accelerating stakeholder review cycles across HR and operations teams.
– Documented access and security review evidence aligned to SOX-style controls for reporting datasets supporting Optum Insight payer analytics.
Technical Business Analyst Aug 2021 – Jul 2023
Wipro Bangalore, India
– Elicited business requirements for an energy and utilities client using structured workshops, delivering a functional specification that scoped integration and reporting enhancements.
– Engineered a Tableau reporting layer incorporating SQL transformations, automating recurring operational reporting consumed by client program and HR support teams.
– Consolidated 7 disparate operational data feeds into a unified reporting model for an insurance client, standardizing reporting definitions across delivery teams.
– Coordinated UAT for a financial services client using JIRA, authoring test cases and defect logs that cleared release readiness across two delivery cycles.
– Prepared change management documentation for system releases using Confluence, aligning deployment records with client ITIL change control procedures.
– Partnered with vendor contacts on a healthcare payer engagement to resolve reporting data discrepancies and confirm integration input requirements.
Business Systems Analyst Mar 2020 – Jul 2021
Accenture Bangalore, India
– Documented requirements and process flows for a financial services client using Excel and SQL, supporting recurring operational and management reporting delivery.
– Conducted source-to-target data validation and reconciliation utilizing SQL queries, documenting test cases for employee and vendor data workflows.
– Supported data quality auditing across 14 recurring feeds for a retail and consumer goods client, improving reporting consistency by 18%.
– Executed ETL validation and QA defect workflows for a telecom client using JIRA, producing defect summaries that informed release decisions.
– Prepared audit-ready control documentation for a financial services client, capturing change records and evidence aligned to SOX-style review requirements.
– Maintained requirements traceability matrices for an insurance client, linking business needs to test coverage and delivery sign-off.
Projects
HR Workforce Analytics Dashboard Power BI, SQL, Excel
– Built a workforce KPI dashboard using Power BI and SQL against a simulated HCM dataset, covering headcount, attrition, and requisition metrics.
– Modeled business process stages and security role mappings to visualize approval cycle times and access review coverage. Change Control Audit Trail Reporting Mart SQL, Python, Tableau
– Developed a reporting mart using SQL and Python to consolidate change request records against configurable approval and evidence standards.
– Visualized control compliance status in Tableau to surface audit readiness gaps across recurring review cycles. Education
Sacred Heart University Fairfield, CT
Master of Science in Computer Science and Engineering Aug 2023 – Dec 2024