Leo Rodriguez Email & Phone Number

Ch

- Data Analysis and Optimization Expertise: Leverage Python functions conducting in-depth analysis of claims processing data, identifying actionable patterns.Data modeling for performance and accuracy.- System Optimization Leadership: Developed and execute optimization strategies enhancing efficiency reporting the claims processing system. Implemented automated reporting methods and integration across systems. - Standardization and Integration Champion: Aligned and integrate multiple claim systems and regional standards into a cohesive framework, facilitating comprehensive analysis of global claims data.- Strategic Alignment and Collaboration: Ensured optimization strategies in sync with the company's overarching goals. Collaborated closely with stakeholders to drive efficiency and innovation in claims processing to measure operational outcomes.- Continuous Improvement Advocate: Monitored and rigorously tested the effectiveness of optimization strategies, consistently providing recommendations for system enhancements when necessary.- Team Leadership and Integration: Provided visionary leadership to guide the team in seamlessly integrating optimization strategies with other critical systems, fostering synergy across the organization.- Problem-Solver Extraordinaire: Demonstrated expertise troubleshooting and delivering effective solutions to issues related to claims processing, ensuring uninterrupted and efficient operations.

Bellevue, Washington, Us

• Develop and implement data analytics strategies with Snowflake, Power BI, Salesforce, NetSuite and house grown systems to support and measure business objectives and track sales goals.• Use advanced SQL for data analysis and construction of logical data models, optimizing SQL views to enhance data accuracy, deriving actionable insights, and facilitating informed decision-making for stakeholders. • Lead and mentor a team of data analysts, fostering data-driven storytelling and decision-making.• Address data anomalies, monitor OPS performance ensuring data integrity across business practices.• Collaborate with IT global stakeholder groups to optimize data systems, integrating Salesforce and NetSuite into Snowflake for comprehensive end to end reporting delivering high-quality results.• Design and maintain actionable dynamic data dashboards and reports with Power BI and Salesforce.• Partner and collaborate with cross-functional teams to identify data-driven opportunities and actinable reporting solutions.• Managed Power BI Premium capacity as ADMIN resolving performance issues, ensuring smooth workspace usage and refresh operations.• Proficient in DAX Studio for query performance and expression optimization, accelerating report data processing.• Uphold data privacy and security standards, adhering to regulations utilizing Power BI security features.

Boca Raton, Florida, Us

• Find analytical insights for Claims management, Severity and Ops performance, create/measure KPIs across departments and rollups for executive performance review.• Developed SQL queries in Oracle, Snowflake, and PostgreSQL for reporting using Tableau, Tableau Prep Flow, Power BI, Excel, MicroStrategy, Alteryx and Knime (Python/Pandas).• Analyzed and tested data across multiple systems and front-end GUI, diagnosing anomalies.• Worked with IT DBA and Architecture to correct data anomalies.• Led data governance, building and enhancing the Enterprise data dictionary and documentation.• Aligned sprints and report development roadmap within the enterprise with IT software releases.• Document and streamline existing reporting, consolidate processing simplifying redundancies.• Design data model implementation for reporting across a multi-functional team.

Miami, Us

• Leverage SQL for data extraction and loading to support analytics and decision-making processes.• Automate reporting for global sales operations using SAS, SQL, Excel, and Power BI.• Provide insights for drivers by area, market, channel, and revenue period, coordinate with business areas to measure initiatives.• Support onboard revenue analytics supplying global sales reports, KPIs and forecasting.• Analytical intelligence from forecast to actuals measuring performance of future sailings.• Model test and reconcile data for passenger sales reporting migration.• Modeling targets by revenue area, source market and year track to adjust performance.

Davie, Florida, Us

Contractor for Cross Country Home Services doing business reporting and analysis of operational data.

Norwalk, Ct, Us

• System integration, harmonizing data across multiple platforms/environments for analysis, supporting accounting and finance departments.• Created and ran SQL data audits and EDI operation invoice and revenue reports. Ensure accuracy and compliance in EDI processing for usage, billing, pricing, payments, and variance analysis. Skilled in SQL, ERP, and Dynamics 365 GP.• Manage multiple projects simultaneously in a fast-paced environment, prioritizing tasks effectively and ensuring timely completion.• Implemented automated tax exemption processes and reporting with Avalara's Certcapture to minimize tax liabilities.• Verified journal entry accuracy in the Financial ERP System, MS Dynamics GP, and support audit procedures with data and process reviews.• Oversaw sales bank reconciliation in A/R roll over, train junior analysts on variance reconciliation, and provide financial expertise for system conversion planning and analysis, including project management and documentation.

Miami, Fl, Us

• Analyze create and support sales, procurement & financial reports in Access, Excel and Qlik• Measure marketing strategies success and sales variations by region/promotion. • Design, develop and update the DB of special accounts affiliation by customer participation.• Market prospect identification & sales follow up reports.• Manage monthly DB updates and changes to the enrollment/price/discount base.• Design, develop and update all levels of the monthly price list report.• Domestic purchasing, replenishment analysis, Vendor/Price/Item sales analysis.• Create purchase orders, follow-up production and confirmations via spreadsheets and Purchasing ERP.• Develop & support spreadsheet-based tools to calculate and perfect shipping/receiving focused on cost savings.