Data Analyst Sql Server

Sri Sannihitha Gangina

+1-508-***-**** *****************@*****.*** linkedin.com/in/sannihitha-gangina/ github.com/srisannihitha Education

University at Buffalo, The State University of Buffalo Buffalo, NY Master Degree, Computer Science and Information Systems Aug 2022 - May 2024 Gandhi Institute of Technology Visakhapatnam, India Bachelor Degree, Computer Science and Engineering Jul 2016 - May 2020 Technical Skills

Core Expertise : Data Mining, Data Cleaning, Data Processing, Reporting, Data Visualization Programming : Python, R, SQL, Scala, MATLAB, Java, SAS, NoSQL Databases : PostgreSQL, MySQL, MS SQL Server, OracleSQL, Cassandra, Microsoft SQL Server, MongoDB Big Data : Hadoop, MapReduce, Pig, Hive, Spark, Flume, Kafka, Docker, Kubernetes Tools : Power BI, Tableau, SSIS, Excel, RStudio, Qlik, Airflow, Flask, Zoho CRM, SAP ERP, Jira, Git, Agile, CI/CD Cloud : Azure Synapse, Azure Databricks, Azure Data Factory, S3, EC2, Glue, Redshift, GCP, Snowflake Libraries : Pandas, NumPy, PySpark, Scikit-Learn, Keras, TensorFlow, Matplotlib, PyTorch, Statistical Modeling Experience

Data Analyst/Engineer Jan 2023 – May 2023

University at Buffalo Buffalo, NY

• Innovated a multilingual exam preparation platform utilizing MySQL, VBA applications, creating 36 dashboards and 24 ad hoc reports, which provided recommendations that boosted landing page conversion by 38%.

• Compiled precise management reports and 24 ad hoc reports with data visualizations driven by Power Query, SAS, and DAX, leading to a 34% increase in project delivery speed through Agile methodologies.

• Transformed and compressed large-scale datasets across multiple formats using Azure Synapse ETL processes; enhanced data integrity and consistency, leading to a 35% improvement in storage optimization and retrieval speed. Data Analyst Aug 2021 – Jul 2022

Amazon Hyderabad, India

• Detected and addressed financial fraud through SQL, pivot tables, SAS, and Tableau, partnering with cross-functional teams; achieved a 35% improvement in service delivery quality and increased customer satisfaction.

• Engineered AWS-based data processing, achieving 30% latency and throughput improvements. Leveraged AWS Glue serverless architecture for automated data ingestion and transformation, boosting operational efficiency.

• Employed Python and R for advanced time series analysis, forecasting trends, and identifying outliers, adhering to SOPs and Six Sigma methodologies for manual audits to uphold data integrity and precision.

• Improved data retrieval efficiency on Amazon RDS, Amazon S3, and AWS DynamoDB by crafting SQL procedures, scripts, and functions, and implementing indexing strategies, achieving a 20% performance boost and scalability.

• Directed in planning and execution of UAT testing and retested UAT defects and updated comments in JIRA on delivery feedbacks resulting in cost reduction of $1,11,000. Junior Data Analyst/Engineer Jul 2019 – Apr 2021

DeMenew Tech Pvt Ltd Hyderabad, India

• Established real-time data and reporting infrastructure with Power BI and HiveQL; defined KPIs to measure business decision effectiveness, enhancing product and marketing funnel analysis, resulting in a 25% increase in actionable insights.

• Orchestrated a real-time ETL pipeline for integrating, ingesting, storing, and analyzing 110 terabytes of raw restaurant data. Utilized Apache Airflow and Hadoop for efficient data processing and storage.

• Streamlined and optimized data transformations and cleansing processes using Azure Data Factory and Azure Databricks; leveraged Apache Spark to improve large-scale data processing efficiency by 40%, reducing operational costs by 25%.

• Designed and monitored AI solutions, executing A/B experiments for POS AI software to enhance conversion rates by 19 basis points and reduce churn by 12 basis points, integrating CI/CD practices for seamless deployment. Projects

Heart Disease Prediction Python, Flask, HTML, CSS, Prediction models, Classification models Jan 2024 – May 2024

• Processed data for 80,000 patients in the health care industry, including data profiling, cleaning, preprocessing, transformation, and exploratory data analysis.

• Implemented 7 regression, classification, and prediction models to predict heart disease, utilizing feature extraction, statistical analysis, and neural networks.

Superstore Data Analysis Tableau Jan 2023 – May 2023

• Analyzed superstore supply chain data focusing on sub-category profit and regional sales using Tableau and Excel macros; optimized inventory management, resulting in a 20% reduction in stockouts and 15% increase in profitability.

• Applied statistical analysis and data mining techniques to derive insights and support strategic planning and forecasting. Certifications

Azure Data Engineer Associate- Microsoft

Issued Jun 2024 - Expires Jun 2025

Contact this candidate