Samuel Prakash

Senior Power BI Data Analyst with over 11 years of experience driving analytics initiatives, dashboard development, and reporting automation across large-scale manufacturing, financial services, asset management, and information services. Proven track record of operating effectively in fully remote enterprise environments, partnering cross-functionally with Finance, Operations, IT, and Supply Chain teams to transform complex operational data into actionable insights. Deep expertise across the Microsoft BI Stack—including Power BI Desktop, Power BI Service, DAX, Power Query (M), and Microsoft Fabric—complemented by strong SQL capabilities, ERP/SAP data extraction experience, data lake ingestion familiarity, and data governance rigor.

Skilled at modernizing legacy reporting processes, improving operational visibility, and enabling data-driven decision-making.

Senior Power BI Data Analyst - Santander Bank

(2025-07)

Serve as a remote Senior Power BI Data Analyst across Finance, Risk, Operations, and IT, collaborating cross-functionally to gather analytics requirements and modernize enterprise reporting.

• Architect, design, and maintain enterprise Power BI dashboards and semantic models in Microsoft Fabric, converting large financial and operational datasets into real-time visual insights.
• Write, optimize, and execute complex T-SQL queries against Azure SQL Database and Snowflake data lakes to extract, aggregate, and validate reporting data.
• Build scalable star-schema data models using DAX and Power Query (M) while establishing strict data governance and Row-Level Security (RLS) protocols to maintain high data integrity.
• Identify data quality anomalies across enterprise reporting systems, partnering with data engineering teams to remediate upstream inconsistencies and automate manual workflows.
• Tune Power BI report performance by refactoring DAX logic, optimizing semantic model refresh schedules, and utilizing DAX Studio for query plan analysis.
• Support self-service analytics expansion by establishing standardized visual templates, administering workspace environments, and training business users on Power BI features.
• Maintain comprehensive technical specifications, KPI definitions, and data lineage documentation to uphold corporate governance standards.

Senior Power BI Data Analyst - Ford Motor Company (Epitec - Contract) - MI

(2017-10 - 2025-06)

Embedded within cross-functional manufacturing, plant operations, supply chain, and finance teams in a hybrid/remote setup to identify analytics gaps and deliver automated reporting solutions. Extracted and transformed complex operational data from SAP ERP, MES, warranty, and logistics databases using T-SQL, SSIS, and Alteryx to power manufacturing intelligence dashboards.

• Designed and built intuitive Power BI dashboards tracking plant throughput, downtime drivers, scrap rates, Overall Equipment Effectiveness (OEE), and vendor performance metrics.
• Established systematic data validation and source-to-report reconciliation processes, creating automated data quality tracking mechanisms that flagged operational errors in real time.
• Integrated automated Alteryx and data pipeline workflows with Power BI semantic models, streamlining spreadsheet-heavy reporting routines and saving hundreds of operational hours annually.
• Standardized manufacturing and operational KPIs across multi-site production facilities, ensuring uniform reporting standards during major data infrastructure upgrades.
• Optimized large relational queries and Power BI Import/DirectQuery models handling multi-million row datasets to maintain fast dashboard responsiveness for plant leadership.
• Championed data transparency by providing remote technical support, user guides, and training to plant analysts while maintaining version control via Git and Azure DevOps.

Senior BI Consultant - Point 72 Asset Management - CT

(2016-01 - 2017-09)

Partnered directly with portfolio managers, quantitative analysts, and financial controllers to gather reporting criteria, document business logic, and design interactive dashboards.

• Authored complex SQL and T-SQL queries against SQL Server and Oracle databases to retrieve and reconcile portfolio performance, asset exposure, and market benchmark data.
• Developed interactive Power BI dashboards and advanced Excel analytical models, enabling investment teams to drill into asset performance, portfolio risk, and historical trends.
• Built star-schema dimensional data models to organize financial datasets, ensuring consistent calculation logic across analytical tools.
• Executed rigorous source-to-dashboard data reconciliations to ensure 100% data integrity for executive performance reporting.
• Diagnosed and resolved reporting errors by debugging underlying data models, stored procedures, and DAX measures.
• Streamlined dashboard performance by tuning database queries, indexing target tables, and optimizing in-memory Power BI calculations.
• Created detailed technical documentation, metric mapping guides, and data dictionaries for ongoing system support.

Data Analyst / SQL Developer - LexisNexis - OH

(2015-06 - 2015-12)

Supported internal analytics initiatives by querying enterprise relational databases and building foundational Power BI operational reports.

• Authored and tuned T-SQL queries, views, and stored procedures to aggregate operational data for business performance tracking.
• Collaborated with cross-functional teams to define baseline performance indicators, translate findings into visual charts, and document business rules.
• Conducted systematic data auditing and source-to-report reconciliation to verify dataset integrity before deploying reports.
• Maintained technical documentation, data mapping references, and user guides to support reporting maintenance and team onboarding.

Master of Computer Sciences - Computer Sciences - Wilmington University (2015) DE

Bachelors - Computer Sciences - Osmania University (2010) Hyderabad