| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name
Data AnalystLocation: Ohio, USA || Mail: EMAIL AVAILABLE || Ph.: PHONE NUMBER AVAILABLEProfessional Summary: - Data Analyst with 4+ years of experience in leveraging advanced analytical techniques and data-driven solutions to drive business success. Proven expertise in optimizing SQL queries and developing interactive dashboards to enhance data accessibility and reporting efficiency. Adept at utilizing Python, AWS and Power BI to automate data analysis, implement scalable storage solutions, and create actionable insights. Proficient in SQL, specializing in extracting, transforming and analyzing large datasets within Azure SQL Database. Skilled in applying statistical methods and machine learning models to uncover trends, improve data accuracy, and support strategic decision-making. Demonstrated ability to collaborate with cross-functional teams, adhere to regulatory standards, and implement data validation protocols to ensure data integrity. Committed to delivering high-impact results in healthcare and marketing sectors through innovative data solutions and comprehensive analytics architectures.Technical Skills: -Methodologies:SDLC, Agile, Waterfall.Language:Python, SQL, R, Scala.Packages:Pandas, NumPy, Matplotlib, SciPy, Seaborn, Scikit-Learn, ggplot2, TensorFlow.Data Visualization Tools:Tableau, Power BI, Advanced Excel, Statistics.Database:MySQL, MongoDB, PostgreSQL, SQL Server.IDEs:Visual Studio Code, PyCharm, Jupyter Notebook.Cloud Technologies:AWS (Amazon Web Services), Microsoft Azure.Data Manipulation:Data Analysis, Data Mining, Data Preprocessing, Data Mapping, Data Cleaning, Data Visualization, Data Modeling, Data Warehousing, Data Storytelling, Data Wrangling, Data Acquisition, Data Integration, Data Transformation.Other Technical Skills:SSIS, SSRS, Machine Learning Algorithms, CI/CD, Probability distributions, Confidence Intervals, ANOVA, Data Mining, Data Visualization, Data warehousing, Data transformation, Data Storytelling, Association rules, Data Cleaning, Data Wrangling, Clustering, Advanced Analytics, ETL Processes, Clustering, Informatica, Report Generation, Regression, A/B Testing, Forecasting & Modeling, Hypothesis Testing, Time Series Analysis.Operating System:Windows, Linux, Mac OS.Professional Experience: -McKesson Ohio Jan 2023 CurrentData Analyst Improved analytics efficiency by 30% through optimizing SQL queries and reducing query processing time from 25 to 15 seconds in healthcare data systems. Reduced reporting time by 40% by developing interactive self-service Tableau dashboards used by over 100 healthcare professionals. Performed root cause analysis on healthcare data quality issues, resolving inconsistencies in multiple datasets. Created custom Python scripts for automated analysis of healthcare data, reducing manual work by 15 hours weekly. Implemented an AWS-based data storage solution, utilizing Amazon S3 for secure and scalable storage of healthcare data, improving data accessibility and retrieval times by 25% while ensuring compliance with HIPAA regulations. Enhanced anomaly detection rate by 20% by analyzing healthcare system behavior and implementing data models to identify irregularities. Increased data accuracy by 25% by implementing data validation protocols across the healthcare ETL pipeline. Curated comprehensive healthcare analytics architecture ensuring data accuracy, consistency and efficiency for improved evidence-based decision-making. Led regular data quality audits to ensure that all healthcare reporting systems adhered to the highest standards of accuracy. Worked with stakeholders to define healthcare KPIs, providing actionable insights that aligned with organizational goals. Collaborated with cross-functional teams to ensure that Matplotlib visualizations met specific healthcare reporting needs, including regulatory compliance and internal data analysis requirements. Applied statistical techniques such as hypothesis testing and regression modeling to identify relationships in healthcare data.Environment: - SQL Queries, Tableau, Python, AWS, Amazon S3, HIPAA, ETL and Matplotlib.Wipro India Oct 2019 Apr 2022Data Analyst Utilized Python libraries such as Pandas and NumPy to analyze over 50,000 customer records, successfully identifying five distinct customer segments based on purchasing behavior, which informed targeted marketing strategies. Designed and developed three interactive dashboards using Power BI, significantly enhancing the marketing team s access to real-time customer insights and performance metrics. Implemented data-driven marketing strategies derived from customer segmentation analysis, achieving a 15% increase in sales over six months. Automated data cleaning and preprocessing workflows, leading to a 40% reduction in time spent on data preparation, thereby increasing overall efficiency in data handling. Conducted exploratory data analysis (EDA) to uncover trends and patterns, providing actionable insights that guided strategic decision-making. Implemented machine learning models to forecast customer behavior and preferences, enhancing the organization's ability to tailor marketing strategies. Employed SQL for querying and manipulating large datasets within Azure SQL Database, enabling efficient data retrieval and analysis to support various business initiatives. Developed comprehensive customer profiles by analyzing demographic and behavioral data, facilitating personalized marketing approaches. Evaluated marketing campaign performance metrics to assess effectiveness and return on investment (ROI), providing recommendations for future campaigns. Monitored key performance indicators (KPIs) in Excel to evaluate the success of marketing initiatives, adjusting strategies as necessary to optimize results, and generating reports for stakeholders.Environment: - Python, Numpy, Pandas, Power BI, EDA, SQL, Azure, SQL and Excel.Education: -Master of Computer and Information Science - Cleveland State University, OH, USA.Bachelor of Computer Science - Jawaharlal Nehru Technological University, Telangana, India. |