Data Analyst Power Bi

Vinay Kajipally

***************@*****.*** +1-612-***-**** Eden Prairie, MN 55344 LinkedIn

PROFILE SUMMARY

Detail-driven Data Analyst with around 3 years of hands-on experience across supply chain, sales, and enterprise analytics domains, supporting global teams at Kinaxis, Dell, and HCL. Proficient in SQL (Snowflake, Redshift), Power BI, Tableau, and Python, with proven success in building automated dashboards, optimizing ETL workflows, and delivering predictive insights in cloud-first (AWS, Azure) environments. Adept at translating data into strategic action through cross-functional collaboration, Agile execution, and regulatory-aware (GDPR/HIPAA) practices.

TECHNICAL SKILLS

Data Querying & Management: SQL (PostgreSQL, MySQL, T-SQL), Oracle, Microsoft SQL Server, Snowflake, BigQuery, Amazon Redshift, MongoDB, NoSQL, DBT.

Data Wrangling & ETL Tools: Alteryx, Talend, Informatica, Apache Nifi, SSIS, Python (Pandas, NumPy), Power Query. Business Intelligence & Reporting: Power BI, Tableau, Looker, Qlik Sense, Google Data Studio, Domo, ThoughtSpot. Statistical Analysis & Programming: Python (Pandas, SciPy, Matplotlib, Seaborn, Statsmodels), R, Excel (Pivot Tables, Power Pivot, Solver), SAS.

Cloud Platforms & Data Warehousing: AWS (S3, Redshift, Glue, QuickSight), Microsoft Azure (Data Factory, Synapse Analytics), Google Cloud Platform (BigQuery, Looker Studio).

Data Modeling & Visualization: ER Diagrams, Dimensional Modeling (Star & Snowflake Schema), DAX, LOD Expressions (Tableau), Custom Visuals (Power BI).

Version Control & Collaboration: Git, GitHub, Bitbucket, Azure DevOps, Jira, Confluence, Trello.

Machine Learning & Predictive Analytics (Basic–Intermediate): Scikit-learn, XGBoost, Time Series Forecasting, A/B Testing, Hypothesis Testing, Regression Analysis, Clustering, Classification.

Automation & Scripting: Python, R, VBA, Shell Scripting, Bash, Cron Jobs, Power Automate, Macros.

Data Governance & Compliance: Data Quality Checks, GDPR, HIPAA Compliance, Data Cataloging (Collibra, Alation), Metadata Management.

Soft Skills & Methodologies: Stakeholder Communication, Requirement Gathering, Agile/Scrum, SDLC, Storytelling with Data, Documentation, Cross-functional Collaboration.

PROFESSIONAL EXPERIENCE

Data Analyst, Kinaxis Oct 2024 – present US

&Architected integrated dashboards in Power BI and Tableau, visualizing end-to-end supply chain metrics including inventory turnover, order cycle times, and demand variance, which enhanced visibility for over 5 global planning teams.

&Queried and transformed multi-source supply chain datasets using Snowflake SQL and Common Data Service (CDS) to support predictive scenario modeling, reducing demand-supply mismatch by 18%.

&Modeled constraint-based planning KPIs by leveraging DAX calculations and custom slicers in Power BI, enabling real-time alerting for capacity bottlenecks and production delays across multiple SKUs.

&Collaborated with solution consultants and business stakeholders to extract insights from Kinaxis RapidResponse® data layers, contributing to the optimization of S&OP processes across client manufacturing ecosystems.

&Executed root cause analyses for recurring forecasting errors using Python (Pandas, Seaborn) and cross-referencing historical demand signals with supplier lead time data, enabling corrective automation for future runs.

&Documented analytics workflows and metadata lineage in Confluence, and tracked iterative enhancements via Jira, increasing transparency and reproducibility across distributed analytics teams.

Data Analyst (Capstone Internship), Dell Technologies Aug 2024 – Oct 2024 US

&Constructed interactive dashboards in Power BI by integrating data from Salesforce, Excel, and Snowflake to track lead conversion metrics and regional sales trends across Dellʼs U.S. business units.

&Engineered SQL queries and stored procedures in Amazon Redshift to optimize reporting pipelines, reducing query runtime by 40% and enhancing real-time data availability for executive reporting.

&Collaborated with senior data scientists and BI analysts to clean and standardize 1M+ rows of marketing and financial data using Python (Pandas, NumPy), enabling high-quality input for forecasting models.

&Synthesized exploratory data analyses (EDA) to identify bottlenecks in customer onboarding workflows, contributing to a 12% increase in operational efficiency through data-backed process improvements.

&Leveraged DAX and Power Query in Power BI to implement dynamic filters and calculated KPIs, facilitating department-wise performance benchmarking across North America operations.

&Documented all analytical workflows, assumptions, and results using Confluence and Jira, ensuring reproducibility and cross- functional accessibility for ongoing dashboard enhancements.

Junior Business Analyst, HCL Technologies Sep 2021 – Jun 2023 India

&Designed and deployed scalable Power BI dashboards using DAX measures and Power Query to visualize KPIs across global client delivery units, reducing manual reporting overhead by 45% and enabling near real-time performance monitoring.

&Developed complex SQL queries and CTEs on MS SQL Server to extract, cleanse, and join large datasets across HR, finance, and service management domains, improving data accuracy for business insights by 30%.

&Orchestrated weekly automated data refresh pipelines integrating Excel macros, Python scripts (Pandas), and SharePoint feeds, minimizing dependency on manual data inputs and improving reporting cycle speed.

&Partnered with cross-functional business units to gather reporting requirements and translated them into BRDs and FRDs, enabling seamless configuration of analytics workflows and alignment with evolving SLAs.

&Evaluated data quality using statistical profiling techniques and Alteryx workflows, flagging anomalies, duplicates, and outliers

—contributing to a 25% enhancement in data governance compliance.

&Constructed predictive trend reports using Python (Matplotlib, NumPy) for quarterly SLA deviations and headcount utilization forecasts, equipping managers with strategic inputs for resourcing decisions.

&Presented findings and insights to client stakeholders and delivery leaders using dynamic visualizations and Tableau Story Points, fostering data-driven decision-making across 3 major enterprise accounts.

Data & Reporting (Intern), HCL Technologies Jun 2021 – Aug 2021 India

&Automated repetitive Excel-based reporting workflows using Power Query and advanced Excel functions (INDEX-MATCH, VLOOKUP, nested IFs), reducing manual data preparation time by 40%.

&Transformed raw transactional data into clean and structured formats using SQL joins, filters, and CTEs to support the creation of ad hoc reports for cross-functional business units.

&Collaborated with business analysts to design and implement data validation scripts in Python (Pandas) for verifying report accuracy, contributing to a 25% decrease in reporting discrepancies.

&Built daily, weekly, and monthly operational dashboards in Power BI by querying structured data via SQL Server, enabling team leads to monitor project KPIs, SLAs, and compliance metrics more efficiently.

&Integrated live data feeds from internal SharePoint sources into Power BI dashboards using REST connectors and DAX measures to ensure real-time visibility of workforce utilization and delivery performance.

&Documented data flow processes and report structures in Confluence, improving report reproducibility and facilitating knowledge transfer across teams.

&Supported the Data Governance team in standardizing master data for internal tools, performing rule-based cleansing and metadata tagging to align with HCLʼs global reporting standards.

EDUCATION

Masters in Information Technology Management,

Concordia University St. Paul

(B.S.) Bachelor of Science in Mathematics and Computer Science,

Vivekananda Degree College

Dec 2024 Minnesota, US May 2022 Telangana, India

Contact this candidate