Data Analyst - dashboards, ETL, AI-driven analytics

Amruta Aney

Aurora, CO +1-979-***-**** *************.****@*****.*** LinkedIn Portfolio

(Open to Relocate)

SUMMARY

Results-driven Data Analyst with 3+ years of experience in dashboarding, data analytics, and stakeholder management across finance, energy, and healthcare domains. Skilled in building automated ETL pipelines, Power-BI and Tableau dashboards, and predictive models that optimize business performance and accelerate decision-making. Adept at SQL, Python, and cloud technologies (AWS, Azure), with proven success in improving operational efficiency, uncovering financial insights, supporting sustainability initiatives and implementing AI-driven analytics. Actively seeking opportunities to leverage analytics expertise and deliver impactful, data-driven solutions in a growth-focused organization. CERTIFICATIONS

● Databricks: Gen AI Fundamentals

● Microsoft Certified: Azure Fundamentals

● Professional Scrum Master I

● Microsoft Certified: Introduction to Python Programming SKILLS

● Databases: MySQL, Microsoft SQL Server, MariaDB, SQLite, Oracle, Snowflake, MongoDB

● Programming Languages: SQL, Python (NumPy, Pandas, Matplotlib, Scikit-learn, PyTorch), Power Query, DAX

● Tools: Copilot, Alteryx, Excel, PowerPoint, Jira

● Data Visualization: Power BI, Tableau, Tableau Prep Builder

● Machine Learning: A/B testing, ANN, Linear Regression, Logistic Regression

● Cloud Technologies: AWS, Azure, GCP

WORK EXPERIENCE

TEXAS A&M UNIVERSITY Remote, US

Data Analyst Oct 2023 - Present

Department: Veterinary Medical Diagnostic Lab

Managing large-scale animal diagnostic testing data across the US to support financial and operational reporting. Building automated pipelines and AI-powered analytics tools that streamline reporting and enhance decision-making across departments

● Owned end-to-end development of 3 executive-level Power BI dashboards for monthly operating business review, cut reporting time by 25% & equipped directors with real-time insights for financial & operational decisions

● Partnered with finance leadership team, designed Accounts Receivables dashboard integrated with Copilot-powered insights, uncovering $100K+ in billing discrepancies and accelerating month-end close by 20%

● Built 2 automated ETL pipelines using AWS (S3, Lambda) to deliver monthly operational insights for the sales & operations teams, reduced manual reporting by 35% & accelerated data delivery by 30%

● Developed efficient ad-hoc reporting solutions using MySQL, CTEs, and window functions to streamline complex data analysis and deliver dynamic insights across 11+ departments

● Deployed Copilot-powered self-service analytics platform using Gen-AI to convert natural-language queries live data visualizations and insights, automating 70% of ad-hoc reporting and accelerating cross-department decision-making

● Utilized Julius AI for automated data cleaning and transformation, detecting anomalies and standardizing records across large-scale diagnostic and operational dataset, improving data accuracy by 35% and reducing manual preprocessing effort

● Implemented Agentic AI system to autonomously track, analyze, and summarize latest veterinary science updates, cutting manual research time via self-directed agents for data sourcing, reasoning, and voice-ready reporting

● Engineered end-to-end AI pipeline leveraging OpenAI LLM and MCP for contextual reasoning, API integrations for dynamic data ingestion, and intelligent scraping, delivering autonomous, adaptive systems for real-time R&D intelligence

Department: Utilities & Energy Services

Overseeing data integration and analytics for energy systems across campus to improve energy efficiency and reduce carbon emissions. Building automated reporting systems to track sustainability performance and identify energy-saving opportunities

● Transformed complex energy data into clear insights, enabling executives to improve efficiency initiatives and drive measurable progress toward campus sustainability goals

● Led data migration consolidating disparate sources into SQL Server via Alteryx; boosted operational efficiency by 30%

& improved data accuracy by 20%

● Built and deployed 4 Power BI dashboards visualizing energy usage, cost, and equipment performance data, aiding leadership to identify efficiency improvements that drove a 7% reduction in carbon emissions

● Automated carbon footprint reporting using SQL & Power Query, enabled real-time monitoring for sustainability KPIs TAMU- HEALTH SCIENCE CENTER College Station, TX

Graduate Researcher, Analytics Nov 2022 - May 2023 Evaluating clinical and patient data to streamline operations and improve resource allocation. Creating data-driven tools that enhance planning, reduce delays, and support better healthcare decisions

● Analyzed 100K+ patient records with Python and Tableau, identified process bottlenecks, and reduced data processing time by 20% while maintaining HIPAA compliance

● Designed interactive Tableau dashboards integrating patient and clinical data, driving administrators to track performance metrics and strengthen operational decision-making

● Built Python-based predictive models to forecast patient admissions, improving clinical planning and increasing resource allocation efficiency by 25%

TATA CONSULTANCY SERVICES Mumbai, India

Analyst Jun 2021 - Jun 2022

Client: Canadian Imperial Bank of Commerce

Project 1: Analyzing QA testing data for the credit card claims portal to improve performance tracking. Developing dashboards that replace manual Excel reports and help teams monitor progress and resolve issues faster

● Developed an interactive Power BI dashboard to track key QA metrics, test execution rates (pass/fail), and resolution times, enhanced accuracy, transparency, and visibility into testing progress

● Automated Power BI reporting pipeline to monitor employee test execution performance against daily and monthly targets, enabling data-driven workload assignment and improving team output efficiency by 20% Project 2: Improving the credit card claims portal to make it more intuitive and user-friendly for customers reporting theft, loss, and fraud. Analyzing user behavior to identify recurring issues and enhance navigation and usability

● Conducted A/B testing to compare UI versions of the claims portal, identified usability gaps, and reduced navigation-related support calls by 40%

● Performed root-cause analysis with Python on claims data to isolate high-error areas, recommended fixes that reduced repeat issues by 15%

Project 3: Analyzing AI chatbot interactions to ensure customers' queries are answered correctly, improving satisfaction and identifying issues that caused escalations to live agents to reduce support costs.

● Evaluated AI chatbot performance using SQL and Power BI, identified response gaps, and recommended improvements that reduced inquiry volume by 20%

● Tracked and analyzed escalations to live agents, uncovering common failure points and informing adjustments that improved automation reliability and first-contact resolution RELIANCE INDUSTRIES LTD Mumbai, India

Intern, Data Analyst Dec 2020 - Jan 2021

Analyzed customer purchase data to improve inventory planning, reduce overstocking, and support smarter distribution decisions across retail channels.

● Conducted analysis of customer purchase patterns using Tableau, identified demand trends, and provided data-backed recommendations to optimize inventory levels

● Built an automated notification system in Python for stock managers, reducing overstocking by 7% and improving efficiency across distribution channels

PROJECTS

Tableau - Shipment & Inventory Analytics

● Developed Tableau storyboard to analyze inventory distribution, shipment status, & delivery timelines across warehouses; enabled data-driven insights into order fulfillment & stock availability

● Integrated KPIs such as on-time delivery %, delayed shipments, & average delivery time; aiming to reduce stockouts & improve shipment efficiency by visualizing performance trends & bottlenecks Tableau - Churn Analytics

● Analyzed churn rates across gender, contract type & tenure segments using historic telecommunications data

● Enabled identification of high-risk cohorts & key churn drivers using dynamic filters, comparative bar charts & churn percentage indicators

Project Owner - Web Application

● Led an Agile Scrum team to deliver a full Software Requirements Specification (SRS) and product canvas, including wireframes, workflow diagrams, and prototypes, improving clarity and optimizing end-user experience for the Destination Bryan web application

● Managed the full project lifecycle as project owner, collaborating with 5 key stakeholders to capture requirements and applying Scrum methodology in Jira to ensure on-time delivery and alignment with business expectations POS Database Design with AWS

● Designed and deployed a peer-to-peer POS system database architecture on AWS EC2 using MariaDB with Galera Clustering, ensuring high availability and scalability

● Implemented indexing, views, transactions, and triggers that improved query performance by 40%, strengthening overall database reliability and efficiency

COVID-19 Detection & Case Visualization using Deep Learning and Python

● Developed an Artificial Neural Network (ANN) model in Python to analyze 3,000 chest X-rays, achieving 89% accuracy in detecting COVID-19 cases.

● Designed interactive Python Dash dashboards to track and visualize trends in confirmed cases, recoveries, and deaths, enabling data-driven insights into pandemic progression.

● Research published in the International Research Journal of Engineering and Technology (IRJET) (eISSN: 2395-0056) EDUCATION

TEXAS A&M UNIVERSITY College Station, TX

MS in Management Information Systems (GPA: 3.84/4) Jul 2022 - May 2024 MUMBAI UNIVERSITY Mumbai, India

B.E. in Electronics & Telecommunications Jun 2021

Contact this candidate