Data Analyst

Tejaswi Prabhala

DATA ANALYST

New Jersey, USA M.no: +1-973-***-**** Email: ******************@*****.*** LinkedIn SUMMARY

• Data Analyst with 5+ years of experience applying SQL and Python to integrate clinical and trading datasets, delivering analytics outputs supporting healthcare optimization and capital markets insights through data processing practices.

• Leveraged Apache NiFi pipelines integrating diverse data sources, producing reliable ingestion flows and applied Azure Data Factory automating processing, supporting reporting across healthcare and trading operations.

• Built Scikit-learn and TensorFlow models analyzing patient-risk and trading behaviors, generating predictions and applied statistical testing, validating patterns driving improved decisions across clinical and capital markets functions.

• Developed Tableau and Power BI dashboards visualizing key metrics for healthcare and trading domains, delivering insights and applying Advanced Excel structuring analyses supporting decisions across teams.

• Implemented RBAC governance, securing datasets across PostgreSQL and Redshift environments, ensuring access, and applied Visio documentation mapping data flows, enhancing clarity, supporting analytics for clinical-trading teams.

SKILLS

Methodologies: SDLC, Agile, Waterfall

Languages: Python, R, SQL

IDEs: Visual Studio Code, PyCharm, Jupyter Notebook Packages: NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, TensorFlow, Seaborn, dplyr, ggplot2, Keras Visualization Tools: Tableau, Power BI, Advanced Excel (Pivot Tables, XLOOKUP) Cloud Technology: Amazon Web Services (AWS), Azure, GCP Database: MySQL, SQL Server, PostgreSQL, MongoDB, Apache NiFi Other Skills:

EXPERINECE

SSIS, SSRS, Machine Learning Algorithms, Probability distributions, Confidence Intervals, ANOVA, Hypothesis Testing, Regression Analysis, Linear Algebra, Advanced Analytics, A/B Testing, Data Mining, Data Visualization, Data warehousing, Data transformation, Data Storytelling, Association rules, Clustering, Classification, Regression, Forecasting & Modelling, Data Cleaning, Data Wrangling, Jira, Git, GitHub

The Valley Hospital Data Analyst USA Jan 2024 – Present

• Optimized SQL integration, consolidating EHR datasets, delivering 40% faster ingestion, improving readiness, and applied Python cleaning standardizing fields, enhancing accuracy for downstream analytics across clinical operations.

• Engineered Azure Data Factory pipelines extracting from SQL Server, automating clinical ETL loads, improving data freshness, and structuring semi-structured feeds through Blob Storage supporting enterprise healthcare reporting.

• Expanded Scikit-learn models grouping patient-risk cohorts, improving targeting accuracy using a 12,000-member population, advancing interventions, and applied NumPy transformations, adjusting distributions and stability.

• Designed Tableau dashboards visualizing adherence, utilization, and outcome metrics, improving decision velocity, enabling KPI clarity, and performing hypothesis testing, verifying observed trend significance for clinical monitoring.

• Executed Excel Power Query cleansing clinical datasets, improving reporting accuracy, increasing reliability, and applied PivotTables structuring workload and trend analyses, enhancing visibility for leadership evaluations.

• Strengthened governance by applying RBAC controls, improving compliance by 37%, ensuring secure access, and using Visio documentation mapping flows, enhancing clarity for regulated analytical environments. Accenture Data Analyst India Sep 2020 – Nov 2023

• Engineered Apache NiFi pipelines integrating trading feeds, contributing 54%, improving reliability, and applied Python transformations, cleaning datasets, boosting accuracy, and supporting downstream analytics processes.

• Developed AWS Redshift and PostgreSQL models aggregating risk metrics, delivering processing efficiency, improving query speed, and using Amazon S3 storage to organize data, supporting scalable access for teams.

• Executed Statsmodels analysis applying ANOVA and forecasting on market indicators, revealing drivers, and leveraged statistical testing validating patterns, enhancing robustness for upstream modeling and assessments.

• Applied TensorFlow clustering to detect anomalous trading flows, achieving a 340 review reduction, improving surveillance precision, and utilized Isolation Forest modeling to detect irregularities, boosting monitoring capabilities.

• Created Power BI dashboards visualizing exposures and anomalies, delivering 21% insight improvement, and applied Advanced Excel drilldowns, structuring metrics to enhance transparency across trading desks overall.

• Automated AWS Lambda workflows deploying analytical outputs, accelerating delivery by 24%, and leveraging Redshift storage, optimizing retrieval, enhancing scalability and supporting continuous processing.

• Coordinated Jira sprint planning, structured analytics tasks, contributed to 26 process efficiency, improving delivery cadence, and used Confluence to document workflows, enhancing collaboration and aligning requirements groups.

• Conducted Pandas analysis evaluating trading-signal datasets, contributing 17% accuracy improvement, enhancing cohort insights, and applied A/B testing, validating performance gaps, strengthening decision-support outcomes. EDUCATION

Master of Science in Digital Marketing Analytics Major Digital Marketing & Minors Business Analytics Montclair State University, Montclair, New Jersey, USA

Bachelor of Technology in Electronics and Communication Engineering CMR Engineering College, Medchal, Hyderabad, India

CERTIFICATIONS

• Digital Marketing Certification: Hootsuite Media Marketing

• Media Marketing: HubSpot Inbound Certification, HubSpot SEO Certification, HubSpot Digital Advertising

Contact this candidate