Data Analyst - Python, SQL, AWS

RUPA SAMUDRALA

DATA ANALYST

Location: VA Phone: 913-***-**** Email: **************@*****.*** LinkedIn GitHub SUMMARY

• Results-oriented Data Analyst with 3 years of professional experience leveraging advanced technical skills to drive data-driven decision-making.

• Experienced in working with relational databases like MySQL for structured data storage and retrieval, and NoSQL databases like MongoDB for handling unstructured data, optimizing database queries for efficient data access.

• Skilled in deploying and managing cloud technologies using AWS services including IAM, EC2, S3, RDS, RedShift, and Cloud Watch.

• Expert in data visualization using Power BI, Tableau, and MS Excel, adept at creating compelling visualizations to communicate complex data insights effectively.

• Proficient in using analytical libraries such as NumPy, Pandas, Matplotlib, and Scikit-Learn for data manipulation and statistical analysis.

• Experienced in applying Agile and Waterfall methodologies to ensure efficient project execution and delivery.

• Strong background in data mining, data cleansing, statistical analysis, text mining, ETL, data wrangling, and data warehousing.

• Demonstrated ability to utilize Hadoop, Hive, Apache Spark, and Snowflake for large-scale data processing and storage solutions.

• Proven critical thinking, problem-solving, and communication skills, with a track record of delivering high-quality, data-driven insights that support strategic business decisions.

• Proficient in version control tools like Git and GitHub, ensuring collaborative and streamlined project management.

• Skilled in transforming raw, unstructured data into structured formats for analysis using Python scripting, employing data transformation techniques to prepare data for machine learning models and statistical analysis. PROFESSIONAL EXPERIENCE

Data Analyst Equity Bank, KS May 2025 – Current

• Leveraged Python and SQL to perform in-depth data analysis, utilizing libraries like pandas and NumPy for data cleaning, transformation, and manipulation. Processed over 10 million data points, resulting in a 25% improvement in actionable business insights.

• Designed and developed Tableau dashboards featuring diverse visualizations such as Pie Charts, Bar Charts, and Scatter Plots, delivering clear and impactful data insights to enhance decision-making in healthcare.

• Built solution-driven views and dashboards in Power BI, incorporating various chart types including Tree Maps, Circle Views, Line Charts, Area Charts, and more to effectively visualize key metrics and trends.

• Conducted exploratory data analysis (EDA) to uncover trends and relationships within data, collaborating with cross-functional teams to align analytical findings with business goals and drive strategic decision-making.

• Collaborated with healthcare providers to streamline Medicare and Medicaid reimbursement workflows through detailed audits and process optimization, improving efficiency and maximizing reimbursement rates.

• Developed a Power Apps-based document submission portal enabling sanctioned team members to securely upload files through a governed UI, eliminating manual handoffs and reducing data intake time by 30%.

• Designed Power Automate flows to trigger automated data ingestion pipelines upon document upload, routing files to the appropriate data lake storage and initiating transformation processes without manual intervention.

• Built real-time Power BI dashboards that dynamically refresh as new documents are ingested, providing stakeholders with live visualizations of updated metrics, KPIs, and trends immediately after each upload cycle.

• Implemented role-based access controls in Power Apps to ensure only authorized team members could upload documents, maintaining data governance and compliance standards across the end-to-end workflow.

• Coordinated end-to-end integration between Power Apps, Power Automate, and Power BI to create a seamless self-service analytics pipeline, reducing dependency on manual data entry and improving reporting accuracy. Data Analyst/Systems Engineer Infosys Ltd., India July 2022 – Dec 2023

• Programmed Python scripts using libraries like NumPy and Pandas to manipulate data, improving data processing efficiency. Implemented data cleansing procedures that enhanced dataset accuracy, reducing errors in subsequent analytics.

• Collaborated with a team of developers to design, develop, and implement a BI solution for tracking sales, product, and customer KPIs.

• Developed and maintained complex SQL queries and scripts for data analysis and extraction, utilizing both MySQL and Oracle databases to ensure data accuracy and integrity.

• Contributed to the implementation of AWS Lambda for serverless computing, automating data processing and transformation in response to events, which helped reduce operational overhead and enhance scalability across various workflows.

• Worked with management and team members to clarify visualization requirements and business strategic report requirements.

• Leveraged AWS services, including S3, EC2, and Lambda, to automate data workflows, reducing processing time, improving scalability, and enhancing data storage efficiency through serverless computing and event-driven automation.

• Supported the automation of reporting processes using Power BI tools such as Power BI reports, dashboards, scorecards (KPIs), and MySQL, along with data warehouse sources, resulting in more efficient reporting workflows.

• Created comprehensive reports and presentations to communicate complex data insights to stakeholders across various departments, fostering improved cross-functional collaboration and informed decision-making.

• Interpreted data to formulate managerial strategies and presented findings using MS PowerPoint and Power BI, resulting in increase in customer service usage.

• Created solution-focused views and dashboards by utilizing a variety of chart types, including bar charts, area charts, line charts, scatter plots, pie charts, and tree maps in Power BI, to meet specific project reporting needs.

• Designed and implemented Power BI visualizations and dashboards based on business requirement documents, ensuring interactive and goal-oriented visual solutions for project objectives.

• Utilized Python's data visualization libraries, including Matplotlib, Seaborn, and Plotly, to create visually compelling graphs, charts, and plots in presentations, effectively conveying data insights to stakeholders.

• Leveraged advanced Excel techniques such as complex formulas, pivot tables, and VBA scripting to streamline repetitive tasks, boosting data processing speed and decreasing manual data handling.

• Optimized data storage and processing by implementing Snowflake for data warehousing, which enhanced data accessibility and query performance by 35%, supporting more efficient and scalable data analysis.

• Conducted extensive data mining and statistical analysis to uncover hidden patterns and insights, directly influencing marketing strategies and operational efficiencies.

• Collaborated in an Agile (Scrum) environment, managing version control with Git and GitHub, which improved project delivery times, reduced overlapping efforts, and ensured better team coordination and documentation across multiple data analysis projects.

Data Analyst Intern Trigent software, India Jan 2022 – June 2022

• Cleaned, transformed, and loaded (ETL) healthcare member and claims data, improving data quality by 20%, resulting in more accurate analysis for cost-reduction initiatives and improved healthcare delivery.

• Optimized SQL queries and database performance to reduce response times and enhance data access, while developing queries to extract key metrics on member demographics, healthcare trends, and provider performance, supporting data-driven decisions for strategy.

• Created sophisticated Tableau dashboards with advanced features to enhance user engagement and deliver meaningful insights.

• Employed Git for version control and JIRA for project management to support effective team collaboration.

• Conducted statistical analysis and utilized Tableau for visualizing extensive datasets, uncovering patterns and trends in patient readmissions, which resulted in a 5% decrease in 30-day readmission rates for a targeted patient group.

• Supported the development of data-driven recommendations for optimizing healthcare programs, contributing to improved patient outcomes and cost efficiencies.

• Assisted in data manipulation and preprocessing using Python's Pandas and NumPy libraries, ensuring data accuracy and consistency for real-time analysis.

• Researched and stayed current on industry trends and best practices in healthcare data analytics, actively participating in knowledge-sharing sessions to enhance team expertise and ensure alignment with industry standards.

• Supported developing and maintaining SQL queries, scripts, stored procedures, and functions for efficient data extraction and manipulation for real-time analysis.

• Utilized Agile methodologies to break down complex data analysis projects into manageable sprints, facilitating efficient collaboration with the data science team and timely delivery of insights.

• Conducted extensive data mining and statistical analysis to uncover hidden patterns and insights, directly influencing marketing strategies and operational efficiencies.

• Collaborated in an Agile (Scrum) environment, managing version control with Git and GitHub, which improved project delivery times, reduced overlapping efforts, and ensured better team coordination and documentation across multiple data analysis projects.

TECHNICAL SKILLS

Programming Languages: Python, SQL

Databases: MySQL, Oracle, PostgreSQL, MongoDB

Cloud Technologies: AWS (IAM, EC2, S3, RDS, RedShift, Cloud Watch) Data Visualization: Power BI, Tableau, MS Excel

Power Platform: Power BI, Power Apps, Power Automate Libraries: NumPy, Pandas, Matplotlib, Scikit-Learn Methodologies: Agile, Waterfall

Version Control: Git, GitHub

Analytical Skills: Data Mining, Data Cleansing, Statistical Analysis, Data Visualization, Text Mining, ETL, Data Wrangling, Data Warehousing, Critical Thinking, Problem-solving, Communication Skills, Presentation Skills, Microsoft Office (Word, Excel, PowerPoint, Access), Jupyter Notebook

Other Skills: Hadoop, Hive, Apache Spark, Snowflake EDUCATION

University of Central Missouri Missouri, US

Master of Science in Computer Science Jan 2024 – Dec 2025 AVN Institute of Engineering and Technology Hyderabad, India Bachelor of Engineering in Electronics and Communication Engineering Aug 2019 – July 2023 CERTIFICATION

Microsoft Certified: Power BI Data Analyst Associate PROJECTS

AtliQ Mart Supply Chain Analysis

• AtliQ Mart, a burgeoning FMCG manufacturer. They provided their dataset on their products, target and orders as a collection of CSV files.

• Prepared data model for above database and ingested these CSV files into MySQL database and used MS Excel and SQL to write and run various queries.

• Used Power BI for plotting gauge charts to check if they met the target, line charts for 'On Time', 'In Full', 'Line Fill Rate',

'Volume Fill Rate' and bar graphs to check the number of Order Delays. Movie Dataset Analysis: Data Visualization and Reporting with Tableau

• Developed an interactive Tableau dashboard to analyze over 45,000 IMDb movies, facilitating trend identification and boosting user engagement by 25%.

• Leveraged Tableau visualizations and insights to collaborate with the team and implement strategies that increased viewer satisfaction by 30% and platform retention by 10%.

• Streamlined data workflows for movie analysis using Tableau, enabling faster updates, efficient data exploration, and ongoing insights.

Contact this candidate