Harsha Perasani
Memphis,TN
Summary
Database Analyst with expertise in database design, ETL development, and business intelligence across retail, healthcare, and research environments. At Williams Sonoma, manage SQL databases (PostgreSQL, MySQL, SQL Server), automate ETL workflows, optimize query performance, and develop BI dashboards (Power BI, Tableau) to drive data-driven decision-making. Previous work in healthcare data analytics involved analyzing MIMIC-IV, CDC, and Epic EHR data. Skilled in data governance, role-based access control (RBAC), and scalable data solutions for both enterprise and research applications.
Overview
3
3
years of professional experience
Work History
Database Analyst
William Sonoma
Memphis, TN
01.2023 - Current
- Design and maintain relational databases (MySQL, PostgreSQL, SQL Server) to support inventory, sales, and supply chain operations.
- Develop structured data models to organize and optimize data for business intelligence.
- Create database schemas, tables, constraints, and indexing strategies to improve performance and data integrity.
- Implement stored procedures and triggers to automate data workflows and business rules.
- Monitor and enforce data governance policies for customer transactions and inventory records.
- Ensure compliance with GDPR and internal security protocols for handling sensitive business data.
- Develop and optimize ETL pipelines using Python (Pandas, SQLAlchemy) and SQL for automating data extraction, transformation, and loading.
- Integrate data from SAP, Salesforce, and internal systems into a centralized data warehouse.
- Write and optimize complex SQL queries, improving data retrieval efficiency.
- Analyze execution plans and implement indexing strategies to enhance performance.
- Collaborate with business analysts, IT teams, and data engineers to optimize data processes.
- Develop and maintain dashboards in Power BI/Tableau for real-time business analytics
Research Assistant
University of Memphis
Memphis, TN
05.2022 - 12.2022
- Designed and optimized relational databases (PostgreSQL, MySQL) to store and manage open-source healthcare datasets (MIMIC-IV, CDC, WHO) for research on patient trends and clinical outcomes.
- Developed ETL pipelines using SQL & Python (Pandas, SQLAlchemy) to transform and clean raw patient data, ensuring data integrity and compliance alignment with HIPAA & 21 CFR Part 11 principles.
- Performed SQL-based analysis on patient demographics, disease progression, and ICU treatment trends, leveraging structured EHR datasets for data-driven research insights.
- Implemented Role-Based Access Control (RBAC) within the database to restrict access to sensitive patient records, following best practices in healthcare data security.
- Created Power BI/Tableau dashboards to visualize hospital admission trends, ICU occupancy rates, and clinical study results, supporting data-driven decision-making in research.
Education
Master of Science - Data Science
University of Memphis
Memphis, TN05-2023
Bachelor of Science - Computer Science
Gitam University
Vizag06-2021
Skills
- Relational databases
- Database administration
- Normalization
- Indexing
- Query Optimization
- Stored Procedures
- ACID transactions
- ETL Pipeline Development & Automation
- Data Extraction
- Batch and real-time data processing
- Data Warehousing & OLAP
- SQL
- Python, R, Java
- TrialMaster, Redcap, Redcap Cloud
- Agile, Waterfall, CI/CD
- Data Governance & Role-Based Access Control (RBAC)
- Developing reports and data visualizations
- Clinical Research Data Processing
- Electronic Health Records (EHR)
Affiliations
Sales & Inventory Data Optimization (Williams Sonoma) Healthcare Data Analytics & Compliance (University of Memphis – Research Assistant) Customer Segmentation & Marketing Analytics (Williams Sonoma) Academic Research Data Management (University of Memphis – Graduate Assistant)
Designed and optimized SQL databases (PostgreSQL, SQL Server) for managing sales, inventory, and supply chain data.
Automated ETL pipelines using Python (Pandas, SQLAlchemy) to improve data processing efficiency.
Developed Power BI dashboards to provide real-time business insights for decision-making.
Tools Used: PostgreSQL, SQL Server, Python (Pandas, SQLAlchemy), Power BI, Tableau
Analyzed open-source clinical datasets (MIMIC-IV, CDC, WHO) using SQL and Python to track patient trends and ICU admissions.
Processed Epic EHR data and implemented RBAC-based security controls to align with HIPAA & 21 CFR Part 11.
Created BI reports in Power BI/Tableau for research insights on patient outcomes and hospital resource utilization.
Tools Used: PostgreSQL, Epic EHR, SQL, Python (Pandas, NumPy), Power BI, Tableau
Built a customer segmentation model using SQL & Python to identify purchasing trends and predict demand.
Integrated CRM and transaction data into a centralized SQL data warehouse for better marketing insights.
Developed Tableau dashboards to track customer engagement and retention patterns.
Tools Used: MySQL, SQL Server, Python (Pandas, Scikit-learn), Tableau, AWS Redshift
Designed structured databases to store and process academic research data.
Performed data extraction and transformation workflows (ETL) using SQL and Python.
Tools Used: PostgreSQL, MySQL, SQL, Python (Pandas, NumPy), Power BI
Timeline
Database Analyst
William Sonoma
01.2023 - Current
Research Assistant
University of Memphis
05.2022 - 12.2022
Master of Science - Data Science
University of Memphis
Bachelor of Science - Computer Science
Gitam University
Similar Profiles
Paul ThomasPaul Thomas
William Sonoma at William SonomaWilliam Sonoma at William Sonoma
JOSHUA PLACERJOSHUA PLACER
Head of STORES at Alshaya - Home Furnishings Division (Pottery Barn, Pottery Barn Kids, West Elm, & William Sonoma)Head of STORES at Alshaya - Home Furnishings Division (Pottery Barn, Pottery Barn Kids, West Elm, & William Sonoma)
Mason ButlerMason Butler
NA at William sonoma(UPS)NA at William sonoma(UPS)