Senior Data Analyst with 7+ years of experience leveraging SQL, Power BI, Tableau, and Excel to deliver actionable insights, streamline reporting, and optimize decision-making. Skilled in building scalable dashboards, automating workflows, and ensuring data integrity across transportation, energy, automotive, and insurance sectors. Adept at collaborating with cross-functional teams, aligning analytics with business goals, and driving efficiency through data governance, QA, and reporting best practices.
· Collected, validated, and managed transportation data to ensure accuracy in vehicle scheduling, route planning, and driver assignments.
· Developed Power BI dashboards tracking budget forecasts, procurement activities, and operational KPIs to support executive reporting.
· Partnered with leadership to define departmental KPIs and built reporting pipelines that improved decision-making.
· Streamlined cross-departmental data collection and QA processes, reducing reporting discrepancies by 30%.
· Conducted cost analysis and performance tracking, providing actionable recommendations for resource optimization.
· Collaborated with vendors and stakeholders to improve workflows and implement reporting automation.
· Processed and validated large volumes of energy rebate applications, ensuring compliance with program criteria.
· Built SQL-driven summary reports for leadership on application timelines and program effectiveness.
· Designed Excel-based tracking models and automated workflows to enhance data quality checks.
· Performed QA audits that reduced customer data errors by 25%.
· Developed dashboards highlighting rebate application trends and customer eligibility.
· Designed reports and dashboards using SQL queries and BI tools to track claim volumes, rebate trends, and campaign ROI.
· Managed high-volume rebate and incentive claims, ensuring accuracy and compliance with internal controls.
· Conducted eligibility analysis on incentive programs with advanced SQL joins and aggregations.
· Partnered with finance teams to align incentive reporting with budget forecasts.
· Improved claims processing speed by standardizing documentation workflows.
· Processed and audited complex insurance claims and policies to ensure compliance with underwriting standards.
· Validated large datasets, identifying anomalies and correcting data entry errors.
· Developed monthly reporting templates to track claims processing efficiency.
· Collaborated with actuarial teams to support risk analysis and premium modeling.
· Determined policy terms and calculated premiums based on actuarial, statistical, and background information.
· Analyzed risk in insurance proposals to ensure sound underwriting decisions.
· Prepared insurance policy terms and conditions in compliance with regulatory standards.
· Liaised with insurance brokers and customers to clarify requirements and resolve inquiries.
Languages & Tools: SQL, Python, Excel (PivotTables, Power Query, VLOOKUP), Postman
Visualization & BI: Tableau, Power BI, Looker
Data Integration & Modeling: Fivetran, AWS Glue, dbt, Airflow, Data Modeling
Cloud Platforms: Azure, Snowflake Data Cloud, AWS
Systems & Platforms: SAP, Maximo, BearBuy, Box, WebNow
Workflow & Project Support: Jira, Application Lifecycle Support, KPI Development, Budget Forecasting, Project Support
Data Ops & Management: Data Quality Assurance, Procurement & Vendor Management
Version Control: Git, GitHub, GitLab, Bitbucket