Looking for a job

Varahala Bharath Rajana

@varahalabharathrajan

Business Analyst at PennyMac Financial Services who automated financial reporting and built Domo dashboards for subscription funnel economics.

United States

Message

At PennyMac Financial Services, I developed Snowflake queries to analyze loan records and automated financial reporting with Excel workbooks and pivot tables. This reduced manual effort by 40% and improved reporting accuracy.

I also built Domo dashboards to track subscription funnel economics, including trial starts, churn, LTV, and ROAS. By combining Google Analytics (GA4) and UTM attribution with Recurly and Stripe data, I produced marketing performance reports.

At 10X Health System, I analyzed clinical and behavioral datasets and created Tableau dashboards for wellness program KPIs. My analysis of engagement trends supported an 18% improvement in program participation.

Earlier, as a Jr. business analyst at Certiview, I assisted with documenting functional requirements and supported UAT tracking in Jira. I also validated data in Excel and mapped processes to support workflow improvements.

Experience

Work history, roles, and key accomplishments

Current

Business Analyst

Current

PennyMac Financial Services

Feb 2025 - Present (1 year 7 months)

Developed complex SQL queries in Snowflake to aggregate and analyze over 1 million loan records weekly, improving reporting accuracy and stakeholder communication. Automated recurring financial reports using Excel multi-source workbooks and pivot tables, reducing manual effort by 40%.

SQL Snowflake Excel Pivot Tables Domo Google Analytics UTM tracking Recurly Stripe T SQL Data Visualization Report Automation

Business Analyst

10X Health System

Jun 2021 - Nov 2023 (2 years 5 months)

Analyzed SQL queries joining multiple clinical and behavioral datasets in Power BI to identify engagement trends that improved program participation by 18%. Created interactive Tableau dashboards tracking over 10 key performance indicators, enabling stakeholders to monitor wellness program effectiveness in real time.

SQL Power BI Tableau Domo A B Testing Cohort Analysis REST APIs Data Visualization Marketing Analytics

Jr. business analyst

Certiview

Apr 2018 - May 2021 (3 years 1 month)

Assisted in documenting functional requirements using Jira, collaborating with cross-functional teams to ensure 95% accuracy in translating business needs to technical specifications. Supported process optimization efforts by creating process flow diagrams that identified inefficiencies, contributing to a 20% reduction in manual workflow steps.

Jira Excel Pivot Tables Process Mapping Technical Documentation Data Validation Defect Tracking User Acceptance Testing