| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
DATA ANALYST
Location: KS | Phone: PHONE NUMBER AVAILABLE | Email: EMAIL AVAILABLE | LinkedIn
PROFESSIONAL SUMMARY
Results-oriented Data Analyst with 3+ years of experience in data analytics, ETL, SQL, Python (Pandas, NumPy, Matplotlib), and cloud
technologies (Azure) to drive data-driven decision-making and improve business outcomes.
Developed advanced SQL queries and constructed Tableau dashboards to optimize data visualization and A/B testing for improving data
insights.
Proficient in developing Python frameworks (Flask) and utilizing libraries (Pandas, NumPy, Matplotlib, Scikit-Learn, Seaborn) for
performing data analysis and visualization.
Executed MongoDB operations, including ad-hoc queries, indexing, replication, load balancing, and aggregation, ensuring reliable data
management.
Skilled in constructing data pipelines using Azure Data Factory, Azure Databricks, and managing data in Azure Data Lake, Azure SQL
Database, and Azure SQL Data Warehouse.
Experienced in managing and optimizing databases, including MySQL and SQL Server, Oracle, ensuring high-performance, data
integrity, and efficient data retrieval.
Created Power BI dashboards by using line charts, pie charts, bar charts, and scatter plots to identify the hidden points and track all the metrics
and extract insights, understood the Strengths and weaknesses, and proposed solutions, leading to improved KPI performance.
Applied advanced data mining and cleansing techniques to preprocess and refine raw data, ensuring the quality and accuracy of inputs for
analytical models. This meticulous approach facilitated the generation of meaningful insights and actionable recommendations.
Leveraged Azure Databricks for scalable data processing and analytics, driving innovation and delivering actionable insights.
Regularly collaborated with business, production support, and engineering teams for data analysis, decision-making support, and analytics
platform enhancement.
Competent in data warehousing and data governance, ensuring reliable and high-quality data for analysis and reporting.
Comprehensive knowledge in ETL processes, data cleaning, data wrangling, data warehousing, data transformation and data governance
including star schema and snowflake schema.
Administered projects following SDLC methodologies (Agile, Waterfall), ensuring systematic project execution.
Utilized Jira and Remedy for bug tracking and ticketing, and Git for version control.
SKILLS
Programming Languages: Python, SQL, T-SQL
Databases: MySQL, SQL Server, Mongo DB, PostgreSQL, Oracle, Snowflake
Cloud Technologies: Azure (Blob Storage, Data Factory, Data Lake, Monitor, Log Analysis, and SQL database)
Libraries: NumPy, Pandas, Scikit-Learn, Matplotlib, Seaborn
Data Visualization Tools: Power BI, Tableau, MS Excel (formulas, macros, lookups, pivot tables and graphs)
Methodologies: Agile, Waterfall
Version Control Tools: Git, GitHub
Analytical Skills: Data Cleaning, Data Wrangling, Data Warehousing, Data Mining, Testing, Time
Series Analysis, Critical Thinking, Communication Skills, Presentation Skills,
Problem-Solving
Other Skills: Microsoft Office (Word, Excel, PowerPoint, Access), Jira, Linux, Jupyter notebook
EDUCATION
University of Central Missouri, MO, USA Jan 2023 - May 2024
Master of Science, Computer Science
Acharya Institute of Technology, Bangalore, India Aug 2017 - Jul 2021
Bachelor of Engineering, Information Science Engineering
WORK EXPERIENCE
Blue Cross Blue Shield, KS
Data Analyst Sep 2024 - Current
Managed and ensured compliance of complex healthcare datasets, utilizing AWS to enhance data accessibility and security, supporting essential
healthcare operations.
Redesigned and optimized data infrastructure for greater scalability. Automated manual processes using AWS Lambda and AWS Glue,
reducing bottlenecks and improving data delivery efficiency.
Developed and maintained ETL pipelines using AWS technologies, facilitating efficient data integration and transformation from various
healthcare sources to support analytics.
Utilized Tableau to create interactive dashboards that display critical healthcare metrics, enabling stakeholders to make informed decisions
based on real-time data insights.
Worked closely with technology and executive teams to address and resolve data-related challenges. Utilized AWS CloudFormation for
deploying infrastructure updates swiftly and consistently.
Applied AWS RDS and DynamoDB to enhance data storage and retrieval processes, significantly cutting down on data processing times and
improving the scalability of data handling systems.
Global Soft Systems Inc. KS, US Jan 2024 - May 2024
Data Analyst
Utilized Python and SQL to conduct comprehensive data analyses, resulting in a 15% increase in decision-making efficiency by employing data
mining, A/B testing, and time series analysis techniques to derive actionable insights.
Executed data analysis tasks proficiently using MySQL and SQL Server databases, adeptly manipulating and querying data to generate reports
and provide valuable insights for business stakeholders.
Created insightful visualizations using Matplotlib, developed interactive dashboards in Tableau that improved user engagement by 30%, and
used MS Excel for detailed data representation, leading to a 25% improvement in stakeholder understanding of complex data sets.
Engaged in performance optimization projects within Snowflake, reducing query execution times through strategic adjustments and learning
about automatic data clustering techniques to manage large-scale data efficiently.
Engaged in the Waterfall methodology for project management, participating in structured planning, requirement analysis, design, development,
testing, and deployment phases of data analysis projects to ensure successful outcomes.
Utilized Git as a version control tool and JIRA as a project tracking tool for team collaboration.
Spearheaded data mining initiatives, employing advanced algorithms to uncover hidden patterns and trends, resulting in actionable insights for
strategic decision-making.
Assisted in utilizing Azure Functions for serverless computing, enabling automatic data processing and transformation in response to
events, which contributed to reducing operational overhead and improving scalability across multiple workflows.
Implemented Azure Data Factory pipelines to orchestrate and automate data integration processes across various Azure services, enhancing
scalability and reliability by reducing manual intervention.
Infosys Ltd. - India Sep 2021 - Oct 2022
Data Analyst/Systems Engineer
Created complex stored procedures, triggers, functions, indexes, and views using T-SQL in SQL Server Management Studio (SSMS). Also
managed and maintained the integrity of schema objects such as tables and views.
Processed and optimized ETL workflows using SSIS to transfer data from remote to local data centers, enhancing data cleansing and
transformation processes that improved local database integrity and relevance, reducing data load times by 30% and increasing data accuracy by
15%.
Designed and implemented an ETL strategy to efficiently move data through landing, staging, and destination phases in the data warehouse
using SSIS and DTS, aligning with the data governance framework.
Developed and automated SSIS packages to export data from Excel and Access to SQL Server, reducing manual data entry errors by 50% and
increasing processing speed by 40%.
Employed complex Excel formulas and functions like VLOOKUP, INDEX-MATCH, and nested IF statements to manage and analyze data on
costs, resources, and scheduling, enhancing data processing speed by 25% and reducing errors in financial and project reporting by 15%.
Optimized data storage and retrieval processes by implementing Snowflake's cloud data platform, resulting in a 30% reduction in query
execution time and improved data accessibility for the analytics team.
Conducted Waterfall analysis to track resource flow and identify project bottlenecks, contributing to efficient resource allocation and project
management decisions.
Cipla, India Feb 2020 - Aug 2021
Data Analyst
Followed agile methodology to plan, execute, and manage data analysis projects, ensuring timely delivery and successful project completion
while adhering to agile principles.
Worked extensively with Python and SQL to conduct comprehensive data analysis through Power BI and MS Excel to create
visualizations and reports.
Used SQL to clean and preprocess data, including handling missing values, removing duplicates, and transforming data into a suitable format
for analysis.
Used Python to update content in database and manipulate files.
Worked with various databases such as MongoDB and PostgreSQL to access, retrieve, and manage data for analysis and reporting.
Performed data analysis based on project specifications.
Assisted with automating reporting functionality using Power BI tools, including Power BI reporting, Dashboards & Scorecards (KPI), and
MySQL, Data warehouse data sources, streamlining reporting processes.
Developed various solution-driven views and dashboards by creating different chart types, including Pie Charts, Bar Charts, Tree Maps, Circle
Views, Line Charts, Area Charts, and Scatter Plots in Power BI, fulfilling the reporting requirements for projects. Performed data analysis based
on project specifications.
Designed and developed Power BI graphical and visualization solutions for projects with business requirement documents, ensuring the creation
of interactive dashboards that align with project goals and objectives.
Using Python's data visualization libraries such as Matplotlib, Seaborn, and Plotly, created informative and visually appealing graphs, charts,
and plots, effectively communicating data insights to stakeholders.
Managed Git version control to maintain codebase integrity and facilitate cross-functional collaboration, while spearheading data cleaning,
wrangling, and warehousing initiatives that ensured a 40% data integrity rate and streamlined data availability for analytics projects.
Implemented Azure cloud services such as Blob Storage and Data Factory for efficient data storage, processing, and orchestration, ensuring
seamless data accessibility and enhancing scalability.
PROJECTS
Atliq Sales Insights - Power BI
Addressed declining sales for Atliq Hardware by creating a dynamic Power BI dashboard with advanced DAX calculations, visualizations
(line charts, bar charts), and real-time sales insights. Improved data-driven decision-making and sales performance tracking by 20%.
HR Data Analysis Power BI
Analyzed HR dataset to understand employee preferences and delivered insights on WFH vs. WFO trends and sick leave percentages.
CERTIFICATIONS
Microsoft certified: Power BI Data Analyst Associate
Microsoft Excel: Excel from beginner to advance
|
