Supported multiple lines of business within retail and BankingDeveloped automated tools and dashboards to increase the visibility of core KPIs.• Facilitated the delivery of ad hoc analysis and data requests.• Told a story through data.• Ensured data quality, consistency, and security.• Used SQL for data processing/analysis.• Developed advanced SQL queries including views, stored procedures, and common table expressions (CTEs) with a strong background in T-SQL.• Processed data load requests, manually entered data, reconciled data conflicts, and created data extracts and reports.• Applied VLOOKUP to prepare routine and ad hoc status reports using Excel. Used a variety of software tools to standardize and optimize database management and design.• Managed multiple deliverables, projects, and associated team communication in a dynamic environment.• Collaborated with business owners to identify reporting and analysis needs.

• Supported multiple lines of business including collections and auto loan processing teams.• Monitored and approved weekly funding of auto loan financing; developed metrics to monitor and measure principal risk exposure and profitability timelines.• Collaborated with dealers to set up data analysis and reporting standards to improve visibility of key performance metrics and risk factors.• Performed financial analysis on new projects to forecast financial metrics such as cash flow and profitability.• Constructed SQL queries to gather large datasets on revenue and effectiveness history to create insights on future marketing strategies and generate forecasts on revenue.• Conducted analysis and reporting on revenue forecasts, trader performance, diligence team performance, etc., to evaluate and improve company efficiency, profitability, and business intelligence.• Designed and updated the company database using MSSQL.• Designed business processes to streamline and optimize daily business tasks.• Collaborated with software developers to implement proprietary business tools for daily diligence operations.• Designed and composed marketing campaigns to effectively reach out to prospective leads.• Experienced with VLOOKUP and data sorting and filtering.

• Established new scalable, efficient automated processes for compliance-related tracking and reporting.• Collaborated with stakeholders to define data requirements.• Documented department-wide and application-specific data/reporting requirements by analyzing existing reports, queries, and data.• Developed algorithms to optimize data analysis using Python.• Cleaned and prepared data for analysis.• Migrated data processes from multiple sources into SQL Server.• Developed data models to support decision-making.• Developed data pipelines to extract, transform, and load data.• Built new data views and optimized existing ones to empower teams across the department.• Developed data-driven solutions to business problems.• Created dashboards using Power BI and Tableau, providing stakeholders with actionable insights for decision-making.• Developed advanced SQL queries including views, stored procedures, and common table expressions (CTEs) with a strong background in T-SQL.• Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.• Created pivot tables and charts using worksheet data and external resources; modified pivot tables, sorted items, grouped data, and refreshed and formatted pivot tables.• Designed, recorded, and executed macros to automate data entry inputs.• Prepared routine and ad hoc status reports using Excel.

.Migrated and optimized data processes into SQL Server, improving data extraction, transformation, and reporting for more accurate client analysis and presentation..Created interactive dashboards in Power BI and and excel, providing stakeholders with actionable insights, improving client presentation, and aiding decision-making..Built scalable data models to support strategic decisions and enhanced written communication of client data..Designed and developed SQL queries, including views, CTEs, and stored procedures, facilitating better organization and presentation of client-specific data..Created and executed macros in Excel to automate data entry and reporting, streamlining routine data analysis and ensuring efficiency in preparing client reports..Worked with clients to define data requirements and develop efficient, automated processes that enhance both organization and data analysis for more effective client presentations.