Jyosna V.
Director of Business Intelligence and Data Analytics @Northern Illinois University
Signup · Get unlimited contacts
WORK HISTORY
Director of Business Intelligence and Data Analytics @Northern Illinois University
DeKalb County, IL, US
Designed & developed interactive Power BI dashboards for Donor Management, Annual Giving, and Athletics—empowering executives with real-time insights into gift activity and campaign performance.2. Used DAX, Power Query (M), and SQL Server to integrate Salesforce CRM, Millennium, EverTrue, AlumniMagnet, and Excel into a centralized analytics mart—cutting report time by 50%.3. Automated daily data refreshes and exception reports via SSMS jobs and PowerShell scripts—delivering metrics each morning without manual effort.4. Implemented row-level security and incremental refresh in Power BI Service—boosting dashboard adoption by 30%.5. Reported key fundraising KPIs (year-over-year gift growth, donor retention, ROI) to the Executive Leadership Team—guiding strategic planning.6. Executed comprehensive Salesforce testing (unit, integration, system, UAT) and built automated suites with Salesforce DX and Selenium—reducing regression cycles by 40%.7. Led data-validation across Salesforce, Power BI, and ERP—authoring SQL scripts to achieve 99% accuracy.8. Managed Sandbox environments, coordinated org refresh schedules, and tracked defects in JIRA—providing weekly QA metrics (coverage, pass/fail, defect density).9. Optimized donor segmentation in EverTrue and AlumniMagnet—improving campaign response rates by 25%.10. Documented ETL processes and dashboard requirements; trained 25+ staff to foster a self-service analytics culture.11. Monitored 50+ dashboards in Power BI Service—tuning refresh schedules and queries to ensure sub-1-minute load times.12. Created and maintained a SharePoint site with integrated surveys to engage 10 departments in CRM update communications and transition feedback.13. Established data governance standards—defining 20+ policies to ensure FERPA and GDPR compliance.14. Facilitated monthly workshops with 30+ cross-functional stakeholders to iterate dashboards and drive continuous integration
EDUCATION
100x Engineers
Cohort, Artificial Intelligence
Northern Illinois University
Master's degree, Management Information Systems and Services
ABOUT JYOSNA V.
I’m a data and CRM enthusiast across Salesforce, Power BI, MuleSoft, Snowflake, API integrations, and client-focused CRM implementations. I turn raw data into powerful stories and scalable solutions that help organizations work smarter. At NIU Foundation, I’m leading the entire Salesforce CRM migration from a legacy system (Millennium), managing over 250K+ constituent records. From data validation to API mapping, I’ve built processes that ensure clean, usable, and real-time data flows. Integrated Salesforce with MuleSoft to streamline data exchange across enterprise systems, enabling a seamless flow of constituent and donor data. Leveraged Snowflake to optimize data warehousing for campaign analytics and reporting, reducing query time by 60% and improving scalability. Designed dynamic campaigns and automated journeys in Marketing Cloud, driving personalized donor engagement through email, SMS, and social channels. Developed and deployed Power BI dashboards for fundraising, alumni engagement, and athletics—empowering senior leadership with insight into giving trends, campaign impact, and donor pipelines. Managed API migration and testing from sandbox to production, ensuring zero data loss and 100% field-level accuracy across multiple systems. Designed and automated exception reports and scheduled PowerShell scripts to monitor data anomalies—saving 10+ hours/week in manual QA. As a former Lead Business Analyst at Zoho, I worked with 50+ enterprise clients across industries, gathering business requirements, deploying solutions, training end users, and ensuring long-term CRM success. I also represented SMS magic at Dreamforce 2024, showcasing product features and engaging with C-level executives. Known for strong cross-functional collaboration—I work comfortably with developers, business users, and leadership. Tools I use every day: Power BI, SQL Server, Salesforce, Snowflake, MuleSoft, Marketing Cloud, Power Query, DAX, Notion, Slack, Confluence, Excel, and SharePoint. I enjoy mentoring junior analysts and sharing what I’ve learned—whether it’s debugging a failed API call or designing a report that actually answers the right questions.Whether you need to integrate data, build actionable dashboards, or migrate CRMs, I bring energy, empathy, and execution to the table.Let’s connect if you’re working on something cool with data, CRM, or analytics.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.