Data Analyst Power Bi

Archith V

+1-346-***-**** United States **********@*****.*** LinkedIn

SUMMARY

Results-driven Data Analyst & Business Intelligence (BI) Analyst with 5 years of experience in data analytics, business intelligence, and financial analysis across retail, finance, and healthcare industries. Proven expertise in SQL, Power BI (DAX, Power Query), Tableau, Python (Pandas, Matplotlib), and Alteryx to develop interactive dashboards and automate reporting solutions. Adept at ETL, data modeling, data pipeline optimization, cloud computing (Azure, Databricks, Snowflake), predictive analytics, hedge fund analytics, and financial modeling. Strong background in HIPAA, optimizing business processes, defining KPIs, financial analytics, artificial intelligence (AI), stakeholder management, and business decision-making. Certified Microsoft Power BI Data Analyst Associate and CFA Level 1.

TECHNICAL SKILLS

Programming Languages: Python, SQL, PL/SQL, DAX, Power Query, PySpark, Java

Data Warehousing: Snowflake, Fact and Dimension tables, Star and Snowflake schemas, Dimensional Modeling, OLAP

Cloud Platforms: Fabric, Azure (Data Lake Storage, Delta Lake, Synapse Analytics, Data Factory, Databricks), AWS, GCP

ERP & CRM: Workday, NetSuite, Salesforce, SAP, Oracle, JD Edwards

Databases: MySQL, SQL Server, PostgreSQL, Azure SQL DB, Teradata, MongoDB, IBM Netezza, DB2

ETL (Extract, Transform, and Load) & Data Integration: Azure Data Factory, Alteryx, Informatica, Data Pipeline Optimization, SSIS

Data Analytics & Visualization: Power BI, Tableau, Databricks, Matplotlib, Palantir Foundry, SSRS, EPIC, QlikView, Looker

Project Management & Version Control: JIRA, Agile, Git, Azure DevOps, ServiceNow, Stakeholder communication, Visual Studio

Finance: Financial Statements, Financial Analysis, Equity Valuation, Credit Risk, Options, Futures, Derivatives, Hedge Funds

Big Data, AI, Statistics, & Machine Learning: Correlation, Regression, Chi-squared test, Principal Component Analysis, ANOVA, A/B testing, Generative AI, Natural Language Processing (NLP), Kafka, Hadoop, Hive, Airflow

MS Office & Automation: MS PowerPoint, MS Access, Power Apps, Power Automate, SharePoint

Advanced Excel: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, Pivot Tables, Power Pivot, Power Query

WORK EXPERIENCE

Lowe’s Remote

Business Intelligence Analyst FEB 2024-PRESENT

Designed interactive sales dashboards using Power BI, leveraging advanced DAX and time intelligence functions to track YoY, MoM, and YTD revenue trends, sales growth, and regional performance. (Power BI, DAX, Power Query, SQL)

Optimized Power BI report performance by utilizing VAR statements in DAX to store intermediate calculations and replacing calculated columns with measures, reducing redundant computations, minimizing data model size, and improving query efficiency. (Power BI, DAX)

Developed Alteryx workflows to merge and transform 160K+ sales records from NetSuite and Salesforce, facilitating Power BI dashboards that track YTD retention performance across multiple global regions. (Alteryx, NetSuite, Salesforce, Power BI)

Collaborated with the Executive Board to deploy a unified KPI solution using Power Apps, SharePoint, Power BI, and Power Automate, streamlining 100+ KPIs and enabling informed decisions. (Power Apps, SharePoint, Power BI, Power Automate)

Facilitated ad hoc data cleaning and preprocessing using Python Pandas, ensuring datasets were structured, consistent, and ready for machine learning model training and predictive modeling to forecast customer demand trends. (Python, Pandas)

Collaborated with the sales and finance teams to define and visualize key performance metrics such as total revenue, sales pipeline health, number of deals closed, customer acquisition cost (CAC), and monthly recurring revenue (MRR), enabling data-driven decision-making. (Salesforce, Snowflake, Power BI, Advanced Excel, Pivot Tables)

Ensured data governance and compliance by implementing standardized reporting methodologies and data quality checks.

Led cross-functional collaboration to streamline business processes, improve forecasting accuracy, and enhance business strategy execution.

University of North Texas Denton, TX

Research Analyst MAY 2023-DEC 2023

Analyzed historical tuition revenue trends to forecast future income, assisting university leadership in strategic financial planning and budget allocation. (SQL, Tableau, Excel)

Performed cost analysis on operational expenses, grants, and departmental budgets, identifying cost-saving opportunities and enhancing financial efficiency at UNT. (Excel, PowerPivot)

Developed financial and performance dashboards using pivot tables and charts, providing leadership with real-time insights for budgeting and resource planning. (Excel)

Implemented time-series analysis to monitor changes in enrollment and retention over multiple semesters, helping inform long-term university planning.

HSBC India

Data Analyst II APR 2021-JUN 2022

Utilized advanced Excel functions, Python, and SQL queries to analyze and resolve data discrepancies in investment portfolios, ensuring data accuracy, integrity, and reconciliation across financial databases. (Excel, Python, SQL)

Managed and transformed large financial datasets, performing data cleansing, validation, and dashboard development to track key portfolio performance metrics, supporting fund managers in investment decision-making. (Python, Excel, VBA, Power BI)

Performed data manipulation, data management, and cleansing to create interactive dashboards that monitored investment portfolio performance, risk exposure, and asset allocation trends.

Developed financial models and interactive valuation dashboards using Capitaline (like Bloomberg), in collaboration with portfolio managers, to analyze market trends, company financials, and investment opportunities. (Excel)

Assisted portfolio managers in evaluating monthly/quarterly third-party market data by leveraging data mining techniques, enabling scalable and automated financial reporting through visual analytics. (Python, Power BI)

Assisted in business process modeling and financial risk analysis, supporting strategic decision-making for portfolio managers.

Abbott India

Data Analyst JUN 2019-MAR 2021

Developed interactive dashboards in Power BI to analyze sales performance, prescription trends, market share, and revenue data across multiple product categories, enabling data-driven decision-making for sales teams and senior management. (Power BI, DAX, Power Query, Azure)

Created inventory and demand forecasting dashboards to track stock levels, distributor fill rates, and pharmacy sales trends, helping the Supply Chain & Merchandising teams optimize procurement and prevent stockouts. (Power BI, Excel, Alteryx)

Built a Customer Lifetime Value (CLV) model for chronic and acute therapy drugs, leveraging patient prescription patterns and demographic insights to help the marketing team design targeted patient adherence programs, improving repeat purchase rates by 1.5%. (Power BI, DAX, Power Query, Excel)

Performed exploratory data analysis (EDA) on large pharmaceutical sales datasets to uncover seasonal demand patterns, top-performing drug categories, and regional sales variations, supporting strategic planning for new product launches and expansion into Tier-2 and Tier-3 cities. (Python, Pandas, Matplotlib)

Conducted 5+ A/B tests using Google Analytics to assess the impact of pricing adjustments, promotional offers, and physician engagement strategies, enabling data-backed decisions on marketing investments and product positioning.

Assisted in ensuring data accuracy and compliance with regulatory standards in pharmaceutical analytics.

PROJECTS

Azure Data Engineering Project – FMCG Supply Chain Analytics

Built Developed an Azure-based Extract, Transform, and Load (ETL) pipeline using Azure Data Factory (ADF), Databricks, and PySpark to ingest and transform MySQL and SFTP data into a structured Data Lake.

EDUCATION

University of North Texas Denton, TX

Master’s in Information Systems and Technology, GPA:4.0/4.0 AUG 2022-DEC 2023

Osmania University Hyderabad, India

Bachelor of Commerce, CGPA:8.77/10.0 MAY 2016-MAY 2019

CERTIFICATIONS & TRAINING

Microsoft Certified: Power BI Data Analyst Associate

CFA (Chartered Financial Analyst) Level 1 passed

SQL BI: Introducing DAX, DAX Tools, Data Modeling for Power BI

Palantir Technologies: Building Application, Building Pipeline, Creating Ontology, Data Analysis in Contour, Foundry & AIP Builder

Contact this candidate