Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ruchi Purna Sahoo

Sunnyvale,CA

Summary

Versatile and detail-oriented Business/Data Analyst with 9+ years of experience delivering insights across Retail, Finance, and Healthcare domains. Adept at using tools such as SQL, Python, Excel, Tableau, and Power BI to uncover trends, optimize operations, and support strategic decision-making. Skilled in sales and inventory analysis (retail), financial forecasting, risk analysis (finance), and claims data analysis and patient journey tracking (healthcare). Known for building scalable dashboards, automating reports, and collaborating with cross-functional teams to turn data into actionable business outcomes.

Overview

10
10
years of professional experience

Work History

Business/Data Analyst

Infosys Ltd.
01.2021 - Current
  • Identified and analyzed user requirements, procedures and processes to develop optimization strategies.
  • Facilitated design sessions with the implementation team to define the solution.
  • Created or reviewed technical design documentation to drive accuracy of reporting solutions.
  • Conducted detailed business analysis, outlining problems, opportunities, and solutions for a business.
  • Developed SQL scripts to extract, transform and load data from multiple sources into a single database.
  • Built ETL pipelines for automated extraction, transformation and loading of structured and unstructured data from different sources into centralized databases for further processing.
  • Created visualizations of complex data sets in Tableau to communicate findings with stakeholders.
  • Provided technical support to end-users on how to use the developed analytical tools.
  • Conducted A/B testing experiments to measure the effectiveness of different marketing campaigns.
  • Identified opportunities for process improvements through automation of manual tasks utilizing scripting languages such as Python or Bash.
  • Analyzed and tracked data to prepare forecasts and identify trends.
  • Delivered timely support by tracking issues and communicating resolutions to end users.
  • Performed daily, weekly, and monthly reviews and analyses of current processes using operational metrics and reports.
  • Identified needs of customers promptly and efficiently.
  • Created informative, actionable, and repeatable reporting that highlighted relevant business trends and opportunities for improvement.
  • Managed multiple projects simultaneously while maintaining high standards of quality control.
  • Identified and analyzed industry or geographic trends with business strategy implications.
  • Worked closely with cross-functional teams, including sales, marketing, finance, and operations, to understand their needs and requirements related to data analysis projects.

Data Engineer

GE Healthcare
04.2019 - 12.2020
  • Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
  • Developed and implemented data models, database designs, data access and table maintenance codes.
  • Created stored procedures for automating periodic tasks in SQL Server.
  • Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
  • Monitored data systems performance, identifying bottlenecks and implementing solutions to maintain system efficiency.
  • Implemented data visualization tools like Tableau and Power BI to create dashboards and reports for business stakeholders.
  • Created and implemented complex business intelligence solutions.
  • Optimized existing queries to improve query performance by creating indexes on tables.
  • Automated data quality checks and error handling processes to ensure the integrity and reliability of datasets.

Lead Software Engineer

Quest Global
04.2015 - 03.2019
  • Analyzed system requirements and created detailed specifications documents.
  • Documented software designs and architecture for future reference and maintenance.
  • Analyzed user needs and software requirements to determine design feasibility.
  • Ensured compliance with industry standards while developing software solutions.
  • Developed end-to-end regression test automation and unit and functional testing.
  • Implemented complex application development projects from beginning to end.
  • Optimized existing software systems for improved performance and scalability.
  • Implemented best practices for coding standards, testing and debugging procedures.
  • Resolved complex technical issues related to software development tasks.
  • Reviewed code changes and monitored application performance.
  • Provided technical guidance and mentorship to junior developers.
  • Mentored and advised others in software development lifecycle phases by applying and sharing company and industry methodologies, policies, standards and controls.

Education

Bachlore of Technology - Electronic And Telecommunication

Institute of Technical Education And Research
05-2013

Skills

  • Data formatting
  • Gap analysis
  • SQL programming
  • Data modeling
  • Business analysis
  • ETL processes
  • Python programming
  • Git
  • Data warehousing
  • Reporting tools
  • Snowflake and Teradata
  • Tableau software
  • Data visualization

Timeline

Business/Data Analyst

Infosys Ltd.
01.2021 - Current

Data Engineer

GE Healthcare
04.2019 - 12.2020

Lead Software Engineer

Quest Global
04.2015 - 03.2019

Bachlore of Technology - Electronic And Telecommunication

Institute of Technical Education And Research

Similar Profiles

CREATE PROFILE