Data Analytics Engineer - SQL, Python, AWS, Snowflake, Tableau

RAKSHYA PANDEY

+1-337-***-**** Lafayette, Louisiana, United States

*******.*********@*****.*** linkedin.com/in/rakshya-pandey/ github.com/rakshyaaa Education

Master of Science in Computer Science Aug 2024 – Dec 2025 (Expected) GPA: 4.00 University of Louisiana at Lafayette, USA

Bachelor of Science in Computer Science and Information Technology Oct 2017 – Dec 2021 Aggregate: 85.57% St. Xavier's College, Tribhuvan University, Nepal

Experience

Graduate Assistant – Advancement Operations Aug 2024 - Present University of Louisiana at Lafayette, USA

• Currently underway – Python automation framework to update 270K+ records in a CRM using Microsoft Web API, enabling authenticated, paginated API calls and efficient PATCH operations to streamline data entry workflows and enhance data integrity

• Self-initiated research project, worked on developing a SQL AI agent capable of answerring natural language questions by generating accurate SQL queries. The system was built using LLaMa 3 (via Ollama), followed by the RAG chain

• Maintained and enhanced the university foundation website for performance and WCAG 2.2 AA accessibility compliance using AngularJS, Java Spring Boot, and AWS EC2

• Migrated EC2 instance from Amazon Linux 2 to Amazon Linux 2023, improving performance and security

• Developed a responsive campaign landing page for the Alumni Loyalty Fund, integrating real-time donor statistics and improved interactivity

(Page Link)

• Optimized the website for WCAG 2.1 AA accessibility compliance, improving Lighthouse accessibility score from 85 to 100 by implementing semantic HTML, ARIA labels, and scalable viewport settings

• Implemented a word cloud visualization using Python wordcloud to display the donor last names for advancement team use

• Conducted exploratory data analysis (EDA) on OpenFEMA disaster data; developed Python scripts to extract and process impacted distribution areas using the OpenFEMA API, and visualized disaster impact locations in Power BI for response planning Software Engineer – Data & Business Intelligence Feb 2022 – Jul 2024 LIS Nepal Pvt. Ltd., Lalitpur, Nepal (Offshore for Logic, Part of Accenture, Minnesota, USA) Bluemercury, USA

• Designed and managed scalable BI data models in AtScale, enabling 10+ business-critical reports across sales, merchandising, and inventory

• Partnered with ETL teams to map KWI source data to EDW target tables and authored complex SQL views to fulfill reporting needs

• Developed new Business Reports (Aged Inventory, Replenishment) in Tableau and Excel (Merchandising Daily Sales Flash)

• Enhanced existing complex SQL pipelines, AtScale BI models and Tableau dashboards (Merchandising, Store Operations, Inventory) as per business requirements

• Implemented Row-Level Security in Tableau with AtScale to ensure secure, role-based data access

• Provided knowledge transfer and led training sessions on Tableau and AtScale for new interns and support teams Kayanee, Saudi Arabia

• Collaborated with the development of data extraction scripts by parsing Shopify API JSON responses using pandas

• Performed unit testing for data loading scripts and validated the data loaded into Data Vault (Oracle ADW)

• Contributed to the development of Data Mart tables, Data Mart views and Tableau business reports (Sales Performance, Merchant Deep Dive, Sales Returns)

• Optimized SQL pipelines by preaggregating key KPIs in Oracle ADW views instead of using calculated fields in Tableau, reducing report load time by 25% and standardizing performance metrics across dashboards

• Created an ad-hoc Tableau report to provide leadership with quick access to actionable merchant-level insights Belk, USA

• Built SQL-based customer data extraction pipelines for Acquia CDP feeds (Loyalty, Medallia, Ordergroove Orders, Subscription, Clienteling), enabling accurate customer insights; Conducted data profiling and validation using SQL to ensure data accuracy and integrity

• Designed secure SQL views with PII masking and performed data reconciliation from source (RESA) to destination (CDP)

• Reduced audited transactions data inconsistencies by 80% through root-cause analysis via end-to-end data reconciliation

• Automated data delivery using JAMS Scheduler and developed Python-based email alerting for daily job monitoring

• Enhanced extraction and loading scripts in the Robling ETL framework

• Served as offshore project lead, managing cross-functional communication, stakeholder reporting, and mentored 5 interns Ralph Lauren, USA

• Developed AWS Glue, S3, Lambda, and EventBridge ETL pipelines to move real-time inventory data from Google BigQuery to AWS Redshift

• Conducted end-to-end testing to ensure 99.9% data accuracy across the ingestion flow

• Authored TDDs for ETL architecture and service usage Skills

• Languages & Tools: SQL, Python, AngularJS, Java Spring Boot, HTML, CSS, JavaScript

• Data, BI and Visualization: Pandas, NumPy, Matplotlib, Seaborn, Tableau, Power BI, AtScale, SSRS, SSMS

• Databases: Snowflake, Oracle ADW, Microsoft SQL Server, Data Modeling (Star Schema, Snowflake Schema), Data Warehousing, ETL

• Cloud: AWS Services (EC2, CodeDeploy, CloudFront, Lambda, S3, Redshift, Glue, Kinesis, CloudFormation)

• Development and Version Control: VS Code, Bitbucket, GitHub, CI/CD, JAMS Scheduler, Jira, Confluence, SourceTree, MS Office, Agile

• Soft Skills: Communication, Stakeholder Collaboration, Process Optimization, Documentation Projects

• Heart Disease Prediction Python, scikit-learn, pandas Performed statistical feature selection (t-test & chi-square) and built a logistic regression model on the Cleveland dataset (82.4% accuracy)

GitHub Link

• Plantopedia Python, FastAI, CNN, Django

Built a deep learning web app using ResNet34 to classify fruit and flower images into 10 plant species with 96.86% accuracy; delivers species- specific details to users via a Django-powered interface GitHub Link

• Year-By-Year Sales Report Dashboard Power BI, DAX, SQL Developed an interactive Power BI dashboard to visualize sales performance by year, region, and product. Implemented dynamic filters, trend analysis, and KPI cards to support strategic decision-making GitHub Link Leadership and Involvements

• Executive Committee Member Nepalese Student Association - UL Lafayette 2024 – Present

- Supporting the Nepalese student community through cultural, academic, and social engagement

• Fellowship Graduate, Women Leaders in Technology, Nepal 2021 – 2022

- Completed intensive technical and leadership bootcamps, gaining hands-on experience in GitHub, JavaScript, goal setting, leadership, team building, time management, and public speaking

- Co-developed SheCrafts, a web platform built with HTML, CSS, JavaScript, and PHP to showcase the talents of marginalized women

- Actively participated in monthly tech meetups to stay engaged with the local tech community and expand professional skills

- Conducted an Hour of Code workshop at a community school, introducing fundamental programming concepts to over 40 Grade 8 students, fostering early interest in computer science and digital literacy

• Treasurer, KMC Alumni IT Sector 2020 – 2021

- Managed budgeting and financial operations for committee’s initiatives Awards

• Academic Excellence Award, University of Louisiana at Lafayette 2025

• The Fr. Marshall D. Morgan, S.J. Memorial Award for Excellence in Academics 2022

Contact this candidate