Analytics Engineer & Data Insights Leader

Jayaramaraju Alluri

+1-689-***-**** ******************@*******.*** LinkedIn Tableau Portfolio SUMMARY

Data Analyst and Analytics Engineer with 3+ years delivering cloud-scale analytics end-to-end—from ingestion and transformation to KPI standardization, experimentation, & executive reporting. AWS Certified Solutions Architect & Microsoft Certified Power BI Data Analyst with hands-on expertise in SQL, Python, PySpark, Snowflake, Databricks, and Alteryx across AWS and Azure. Recent experience using AI-assisted analytics and automation to accelerate trend detection, anomaly identification, and decision-ready insights across multi-million-row datasets.

EXPERIENCE

Data Analyst McKinsey & Company USA February 2025 – Current

● Built & maintained analytics-ready datasets in Snowflake & Databricks using SQL, Python, and PySpark, processing 20M+ rows per refresh for cloud-scale analytics.

● Developed ETL/ELT pipelines for ingestion, cleansing, validation, and transformation across 15+ multi-source datasets, reducing refresh failures by ~30%.

● Designed and analyzed A/B tests to evaluate feature and operational changes, measuring lift, statistical significance, and KPI impact.

● Built statistical baselines and lightweight anomaly checks in Python to surface KPI deviations early and improve confidence in executive reporting.

● Delivered 25+ executive dashboards in Power BI and Tableau, with Looker exposure (semantic/metric layer concepts) to support scalable self-service analytics.

● Created reusable Alteryx workflows for data preparation, blending, and validation, reducing manual effort by 35–40%.

● Used AI/LLM-assisted workflows to accelerate insight summarization, trend explanations, improving reporting speed and consistency.

● Automated recurring analytics using Python, APIs, and scheduled jobs, saving 15–20 hours per month.

● Partnered with engineering, product, and analytics teams to standardize 30+ KPIs, align definitions, and improve data quality across platforms.

Application Development Analyst Accenture Hyderabad, India August 2021 – July 2023

● Delivered 50+ dashboards in Power BI, Tableau, QlikView, and Qlik Sense, supporting enterprise reporting across finance, operations, and supply chain with 10M+ records.

● Migrated 30+ dashboards from QlikView/Qlik Sense (SaaS) to Power BI, converting Set Analysis to DAX and standardizing KPI definitions.

● Wrote and optimized complex SQL on Microsoft SQL Server, improving query performance by 20–30% for high-volume reporting workloads.

● Built ETL pipelines using Python, SSIS, PowerShell, and Azure Data Factory, processing millions of rows daily for scheduled reporting.

● Streamlined reconciliation and recurring preparation using Alteryx and SQL, reducing reporting turnaround time by ~40%.

● Implemented Row-Level Security (RLS) and role-based access controls for region- and customer-level reporting governance.

● Managed ServiceNow incidents and requests, resolving production failures, access issues, and SLA-driven reporting escalations.

● Supported IBM On-Demand access by managing directory-based customer permissions for secure and compliant data visibility.

● Performed data validation, anomaly detection, and root-cause analysis to maintain trust in production dashboards and reporting pipelines.

● Worked in Agile delivery (Jira), coordinating parallel workstreams with engineering, QA, and business stakeholders. Technical Data Analyst Intern Trinity Technolabs India January 2021 – July 2021

● Analyzed 180K+ records with SQL, flagging discrepancies that improved audit accuracy and reporting quality across 20+ KPIs.

● Built Power BI dashboards with visuals and slicers to track departmental metrics, reducing reliance on manual Excel trackers.

● Automated recurring reporting with SQL scripts and Excel macros, saving 10+ analyst hours per week. TECHNICAL SKILLS

Data Analysis & Visualization: Power BI (DAX, Power Query), Tableau, Qlik Sense, QlikView, MS Excel, SSRS, Alteryx AI & ML: LLMs (OpenAI, Gemini, Claude), Fine-Tuning, LangChain, Hugging Face, Generative AI APIs. Programming Languages: Python (Pandas, NumPy, Seaborn), R, SQL (Joins, CTEs, Window Functions) Analytics & Modeling: A/B Testing, Hypothesis Testing, Regression, ARIMA Forecasting, Descriptive & Inferential Statistics ETL & Automation: SSIS, Python Scripts, Excel Macros, FastAPI, Flask Databases & Warehousing: Oracle, MySQL, PostgreSQL, AWS Redshift, Azure SQL Database, Firebase Cloud & Big Data: AWS (S3, Redshift), Azure (Data Factory), Google BigQuery Project Tools & Methodologies :Jira, Confluence, Agile (Scrum), BRD/FRD Documentation, User Stories, SDLC, UAT, Git, Docker. PROJECTS

Real Estate Data Analysis & Visualization(R):

● Analyzed 2001–2021 real estate data using R to uncover regional pricing patterns and build ARIMA forecasts over 240 monthly intervals, guiding simulated portfolio planning.

● Executed automatic data cleaning and ARIMA forecasting models in R, cutting preparation time by a third and enabling accurate 12-month sales forecasts for portfolio planning.

Tableau World Bank Economic Indicators Dashboard

● Built a Tableau dashboard using 20+ years of GDP, inflation, unemployment, and population data.

● Cleaned and transformed datasets using SQL + Excel; applied forecasting and trend analysis.

● Identified macroeconomic patterns and country-level insights. Real-Time Auction Application (Flutter + Firebase + GCP)

● Built a real-time auction app with Flutter and Firebase Firestore, enabling scalable live bidding.

● Implemented Firebase Auth, push notifications, and cloud functions for secure bidding workflows.

● Designed NoSQL data models optimized for real-time reads/writes. EDUCATION

Florida Institute of Technology Melbourne, FL August 2023 – December 2024 Master of Science in Computer Information Systems GPA: 3.9 CERTIFICATIONS July 2018 – July 2021

● AWS Certified Solutions Architect – Associate (SAA-C03)

● Microsoft Certified – Power BI Data Analyst Associate (PL-300)

● Microsoft Certified – Azure Fundamentals (AZ-900)

● Google Data Analytics – Foundations (Coursera)

● Python Programming – GUVI (IITM Research Park)

Contact this candidate