Power BI & Analytics Product Analyst

James Cochrane

Sloatsburg, NY • *******@*********.*** • 845-***-**** LinkedIn: linkedin.com/in/jamescochranedataperson Analytics Product Analyst Power BI SQL Python AI-Enabled Analytics Technical Writer Analytics Product Analyst with expertise in Power BI, SQL, Python, semantic modeling, KPI development, and executive dashboards. Experienced translating ambiguous business questions into scalable analytics solutions that enable data-driven decision making. Skilled in developing reusable semantic models, designing governed reporting solutions, and communicating complex data through clear business narratives. Microsoft Certified Power BI Data Analyst (PL-300) with additional experience applying AI and automation to modern analytics workflows. Microsoft Certified: Power BI Data Analyst Associate (PL-300) Focused on semantic modeling, DAX optimization, KPI development, and enterprise analytics Core Skills

Analytics & Business Intelligence

• Power BI, DAX, Power Query

• Executive Dashboards, KPI Development

• Semantic Models, Semantic Layer Design

• Data Visualization, Storytelling with Data

Data & Analytics Engineering

• SQL (T-SQL)

• Data Modeling, Star Schema Design, ETL

• Power Query

• Excel Power Pivot

Python & AI

• Python, pandas, scikit-learn

• LLM APIs, LangChain

• Automation

• AI-assisted Analytics (Power BI MCP), Visual Studio Claude CLI (Python) Analytics Practices

• Business Requirements Gathering

• Stakeholder Collaboration

• Data Quality

• Technical Documentation and Data Governance Principles Professional Experience

Data Analyst & Power BI Specialist (Self-Employed) - 2013 – Present Designed and developed analytics solutions using Power BI, Python, SQL, and AI technologies to transform complex datasets into reusable analytics products supporting executive decision making. Selected Analytics Projects

• Developed reusable Power BI semantic models and executive dashboards supporting business analytics, KPI measurement, and comparative performance analysis.

• Designed Python data pipelines integrating SEC filings, FRED economic indicators, Yahoo Finance, and market datasets into scalable reporting models for Power BI.

• Built analytics products that combined multiple financial and economic data sources into standardized datasets for consistent reporting and decision support.

• Developed an HR analytics solution using star schema architecture, reusable DAX measures, drill-through reporting, and KPI dashboards that replaced manual reporting processes.

• Delivered a Power BI proof-of-concept demonstrating enterprise reporting architecture, semantic modeling, and executive dashboard capabilities for a consulting organization.

• Authored reusable DAX design patterns and technical documentation promoting consistency and maintainability across Power BI solutions.

• Applied LLM APIs to automate qualitative analysis of structured financial and economic datasets, accelerating insight generation while maintaining analyst oversight.

• Created machine learning models using Random Forest and Logistic Regression to identify key business drivers and support predictive analytics initiatives.

• Developed automated analytics notebooks integrating FRED data with AI-assisted narrative generation to improve interpretation of macroeconomic indicators. Technology Liaison Data Analyst Technical Writer – SAI360 - Aug 2021 – Jun 2025

• Led development of an AI-powered conflict-of-interest chatbot recognized with the Einstein Innovation Award.

• Partnered with business stakeholders to translate regulatory and operational requirements into structured decision logic and automated workflows.

• Designed analytics-focused learning solutions that simplified complex compliance requirements into actionable business processes.

• Developed Excel/VBA reporting and analytics tools that improved operational efficiency while supporting data quality and consistency.

• Produced technical documentation, business requirements, and training materials supporting enterprise software implementations.

Lead Programmer/Analyst – Fortis Bank - 2006 – 2012

• Developed enterprise analytics applications using C#, SQL Server, ASP.NET, VBA, and Bloomberg/Markit data feeds.

• Managed multi-source financial data pipelines integrating Bloomberg, Markit, SQL Server, and Excel into operational reporting systems.

• Produced and validated daily trading desk P&L supporting front-office decision making and financial controls.

• Designed workflow automation solutions that improved trade accuracy, reporting consistency, and operational efficiency.

• Collaborated with business users to translate trading and risk management requirements into scalable software solutions.

• Supported data quality and reporting accuracy across multiple financial systems through validation and reconciliation processes.

Education - State University of New York - B.A. Computer Science Minor: Mathematics Certifications - Microsoft Certified: Power BI Data Analyst (PL-300) Selected Projects (GitHub, Username: techhound)

• Composite Valuation SEC + market data (yfinance, custom third party) ingestion with Power BI integration

• ValuationX: AI-assisted equity valuation system

• Econ-FRED-AI Notebook: Automated macroeconomic analysis with LLM insights Additional Training

• SQL for Data Science (2025)

• Introduction to APIs in Python

• Retrieval Augmented Generation (RAG) with LangChain

• Developing LLM Applications with LangChain

• Intro to Machine Learning in Trading with $TSLA (2025)

• Intermediate Python (2018)

Contact this candidate