Learn Data Skills
Beta
Rashmi Balasubramanya Ayas

Rashmi Balasubramanya Ayas

Data Analyst II

Fidelity Investments | Providence

Technologies

My Portfolio Highlights

My New Course

Introduction to Data Science in Python

Analytical luminary, illuminating the path to data-driven enlightenment.

My Work

Take a look at my latest work.

course

Introduction to Data Science in Python

github

Amazon Shipping Analytics [PowerBI]

PythonSpreadsheetsExcel
github

Bank Customer Churn Prediction [Python]

PythonGitSpreadsheets
github

FIFA Player Worth Prediction [Pandas, NumPy, Seaborn, Scikit-Learn, Python]

PythonSpreadsheetsExcel

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

DataCamp Introduction to Data Science using Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Amazon | Oct 2021 - Mar 2024

Business Analyst

1. Collaborated with 4+ internal Candidate Hiring teams to compile and refine data from 10+ sources, leveraging SQL, PowerQuery, and advanced Excel for identifying potential hiring gaps. 2. Created 3 comprehensive Excel-based tools integrating 6 key metrics and business logic to streamline decision-making for stakeholders and senior leadership teams in the candidate hiring process. 3. Engaged stakeholders to capture requirements for data visualization, developing 5 Quick Sight dashboards delivering actionable insights for swift decision-making. 4. Shared multiple analytical insights with Directors and VPs, significantly impacting the North American and European candidate hiring process. 5. Utilized Python scripts for data analysis, identifying high-risk markets and prioritizing job postings based on market risk assessment, enhancing 30+ candidate hiring experiences. 6. Documented & tracked action items from risk management, ensuring diligent follow-up through Asana project management tool. 7. Spearheading the automation and scalability of the Excel-based risk tool to Beacon, simplifying the barrier identification process for each flagged risk site. 8. Developed and maintained 15+ ad-hoc Excel reports, providing valuable insights to internal stakeholders across diverse business use-cases.
Show More

Sony Interactive Environment - PlayStation | Apr 2021 - Aug 2021

Business Intelligence Analyst

• Interacted with cross functional teams to identify potential solutions for analytical requirements and business challenges • Written complex SQL queries in Snowflake environment for data analysis and derived KPIs and metrics for 3 projects • Implemented ETL operations using SQL queries in MySQL and MicroStrategy to effectively track the team’s process performance • Constructed data-driven business intelligence dashboards in Tableau to quantify process improvement & complex business scenarios • Automated Tableau server dashboards & reports to improve the dashboard loading time in real-time for cohort analysis and insights • Participated in Agile scrum meetings to create and maintain tickets in JIRA for tracking the process workflows • Proposed a conclusive solution to senior management and suggested a future path for process improvement with strategies

KPIT Technologies | Aug 2017 - Aug 2019

Quality Business Analyst

• Built a large-scale database in Microsoft Excel to document test defects and procedures to boost testing time by 20% • Conducted requirement gathering and design review with customer to gather and analyze data with business insights • Drafted project plan, milestones, proposal, user manuals, technical plus cloud-based solution architecture diagrams • Developed comprehensive test strategies, plans, and reports in manual and automated QA testing for 10+ projects • Optimized data collection procedures by creating data reports, Pivot tables, and generated business insights with Tableau • Monitored accuracy of release folders to ensure efficient product delivery to 10+ customers on schedule without any slippage • Coordinated with project managers to define metrics and KPI’s for 5+ projects within a Service Level Agreement using MPP

My Education

Take a look at my formal education

Master of Professional Studies in AnalyticsNortheastern University | 2021
Bachelor's in Computer Science and EngineeringNite Meenakshi Institute of Technology | 2017

About Me

Rashmi Balasubramanya Ayas

My passion is to solve problems using data. I truly believe that data is the future. Currently seeking Business Analyst/ Data Analyst Positions. 4+ years of experience working with Amazon and PlayStation. Connect with me at [email protected].

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free