Highlights:

Skills:SQl, PYTHON

Lead Business Intelligence Analyst 01/2024 - current
Discover Financial Services, Chicago, IL United States
Industry: Financial Services
Lead Business Intelligence Analyst
• Designed and deployed scorecard dashboards to monitor vendor and witness performance, boosting settlement rates by 20% across loan and credit card line of business. • Built a data quality dashboard that flagged agent errors in loan delinquency processing, preventing losses of $215K through early discrepancy detection. • Analyzed 4,000+ garnishment accounts, identifying $600K in potential additional interest and recommending monthly interest accrual checks to maximize recovery. • Modernized 70% of legacy recovery reports into the analytical framework, driving 15% operational efficiency gains. • Authored SQL queries to generate time-series datasets from tags and consumer account tables, supporting the creation of daily and monthly recovery domain tables. • Partnered with business leaders to enhance risk analytics and compliance reporting, strengthening FDIC audit readiness.--
Senior Business Intelligence Analyst 01/2023 - 12/2023
Discover Financial Services, Chicago, IL United States
Industry: Financial Services
Senior Business Intelligence Analyst
• Designed DBT models and collaborated with engineering to orchestrate scalable ETL pipelines in Airflow, reducing data prep time by 60% for Snowflake ingestion. • Built Resolution Planning dashboard to automate key personnel identification across business units, building ETL flows for multi-year Workday data, consolidating weekly inputs with stakeholders, and implementing validation checks to meet FDIC requirements. • Consolidated 3 years of employee performance data into Capital One census, optimizing HR data integration with advanced SQL transformations. • Automated retro termination dashboard in Tableau for HR leaders, reducing reporting efforts by 60% and surfacing KPIs on retention, termination, and manager effectiveness. • Enhanced BI governance by administering Tableau Server for 500+ users, implementing row-level security, data quality controls, and standardized dashboard design practices.--
Data Analytics Engineer 01/2022 - 08/2022
Granite Telecommunication, Boston, MA United States
Industry: Telecommunication
Data Analytics Engineer
• Redesigned SSIS ETL pipeline to support One-Bill platform integration, increasing efficiency by 40% while reducing warehouse workload and monitored scheduled ETL jobs to ensure 100% SLA adherence during production migrations. • Implemented SQL stored procedure to handle duplicate/missing values in tickets application, mitigating compliance risks by 35%. • Performed billing erosion analysis in PySpark, reducing processing time by 25%, enabling proactive churn reduction. • Built Power BI dashboards to analyze tickets, customer accounts, and inventory, improving client retention by surfacing at-risk accounts, and partnered with finance team to optimize cost allocation dashboards, improving accuracy of revenue recovery reporting. • Served as a key liaison across IT, finance, and operations teams to streamline data workflows, enhance reporting accuracy, and support business intelligence initiatives with actionable insights.--
Data Analyst 11/2016 - 03/2020
Accenture, Bangalore, KA India
Industry: IT
Data Analyst
• Designed a real-time reporting solution aggregating data from 15+ databases, ranking product sales velocity across Canadian provinces, helping marketing realign campaigns. • Developed dashboards to monitor payment processing lags during holiday sales, averting potential $1.2M in revenue losses. • Built a supervised ML model for internet plan renewals, boosting subscription retention via targeted promotional offers. • Created ETL templates in Talend for CDC (Change Data Capture), reducing job build time by 80% across staging and BI schemas. • Developed parallel ETL orchestration jobs in Talend, reducing Postgres SQL load time by 90%. • Migrated data from SQL Server and Salesforce into BI schemas, supporting seamless reporting integration. • Spearheaded Alteryx remote engine setup, enabling automated scheduling and accelerating client reporting workflows. • Designed and presented data models in ER Studio for stakeholders, ensuring alignment between business requirements and technical delivery.--

Northeastern University, Boston, MA 01/2021 - 12/2022
Boston, MA, United States
Degree: Master's Degree
Major:Information Systems
Master of Science (MS), Information Systems – Northeastern University, Boston, MA | GPA: 3.7 (Jan 2021 – Dec 2022)

Login to view resume: Krishna Ravichandran_Resume -