Sachin Shah Data Analyst
******@********.*** +* (937)- 520 - 8831 Hicksville, NY LinkedIn
Summary
Dynamic and results-oriented Data Analyst with over 3+ years of wide experience in using advanced data analytics techniquesto drive business decisions and enhance operational efficiency. Adept at communicating complex analytical findings to non-technical stakeholders, fostering cross-functional collaboration, and constantly improving processes to support strategic business goals. Technical Skills
Programming Languages: Python, SQL, NoSQL, R
Cloud technology: AWS, Azure
Frameworks & Tools: NumPy, Pandas, Matplotlib, GitHub, Docker, CI/CD, Statistics, Agile, Hadoop, Hive, PySpark, Snowflake, Seaborn, Sci-kit Learn, Jira, KPI Analysis, Automation Power Query
Databases: MySQL, MS-SQL, Redshift, Big Query, PostgreSQL, MongoDB, SparkSQL
Data Analysis / Tools: Power BI, Tableau, Data Bricks, MS Excel, Google Analytics, Data (Modeling, Mapping, Mining, Extraction, Transformation), Salesforce, Zendesk, Confluence, Postman, SAP ERP Professional Experience
Data Analyst, IQVIA 06/2024 – Present Remote, USA
• Built an automated ETL pipeline using Python, SQL, and Apache Airflow to integrate fragmented healthcare datasets (EMR, claims, lab results), reducing data retrieval latency by 40% and enabling faster decision-making for care teams.
• Redesigned AWS Redshift architecture with Glue for ETL and Lambda for automation, cutting processing time by 50% and saving
$12K annually in compute costs.
• Improved dataset accuracy by 35% using Pandas and PySpark to clean missing/duplicate records and standardize formats across 200+ datasets.
• Developed a K-means clustering model with Scikit-Learn to segment 200,000+ patients into risk tiers (85% accuracy), reducing high-risk patient hospitalizations by 18% in 6 months.
• Applied Facebook’s Prophet library to forecast patient admissions (92% accuracy), optimizing bed allocation and reducing ER wait times by 25% at 5 partner hospitals.
• Designed Tableau dashboards tracking ICU resource utilization and treatment costs, reducing resource waste by 15% through real-time insights.
• Identified key drivers of patient attrition (e.g., insurance gaps) using logistic regression, informing interventions that boosted retention by 20% in Q3 2024.
Data Analyst Intern, Northwell Health 01/2024 – 04/2024 New York, USA
• Mined EHR data using SQL and Python to reduce average post-op discharge time by 2 hours across 10 clinics.
• Automated Tableau dashboards with parameterized filters to track readmission rates, saving 8 hours/month in manual reporting.
• Analyzed treatment efficacy using hypothesis testing, revealing a 15% improvement in outcomes for patients on tailored medication plans.
• Partnered with finance teams to standardize ER performance KPIs, reducing reporting discrepancies by 30%. Business Analyst, Vodafone Intelligent Solutions 09/2019 – 08/2022 Ahmedabad, India
• Used NLP (TextBlob) to analyze 5,000+ customer surveys, identifying billing delays as a top pain point and reducing complaints by 25% in 3 months.
• Migrated manual Excel reports to Power BI with automated Salesforce CRM integrations, cutting reporting time by 30%.
• Prioritized 3 app features by analyzing customer usage patterns, driving a 15% increase in satisfaction scores and 10% lower churn.
• Conducted data inquiries using SQL, applying methodologies such as joins, subqueries, and aggregation to extract insights from Salesforce CRM, ensuring accurate reporting on key performance indicators and operational metrics.
• Built a SARIMA model with Python and Statsmodels to forecast quarterly sales, reducing forecast error by 25% and stockouts by 18%.
Education
Master of Science, Hofstra University 08/2022 – 05/2024 New York, USA Business Analytics & Information System
Bachelors in Management, Gujarat University 03/ 2012 – 04/2015 Gujarat, India Business Management