Ruta Joshi Email & Phone Number

Seattle, Washington, US

Redwood City, CA, US

• Owned, managed and maintained internal BI reporting tool of FP&A used to report company wide Financial reporting.
• Worked with cross-functional teams like Revenue, Accounting, Sales and IT to develop new features and reporting capabilities based on their data & integration needs on the data tool.
• Received ‘At as One Team’ & 'Think Customer First' awards for 2020 for successfully leading cross-functional collaboration for multi-team company-wide data integration projects.
• Gathered technical specifications related to analytics, data preparation and changing integrations across company that affected the reporting tool. Translated business needs into conceptual and logical data models.
• Worked with development teams to prioritize competing business needs and push changes to data structures, tables and reports in production.
• Facilitated data discovery and assisted in defining Program roadmaps, project priorities, and tracking progress of different Program initiatives.

Bowie, MD, US

• Managed & supported large scale agile projects for ePASS® tool starting from planning, requirements gathering to QA & UAT Testing.
• Collaborated with various stakeholders & Product teams to understand business challenges and streamline existing business processes.
• Performed complex analytics to identify root causes, patterns, trends to develop insights into usage of the tool & recommend solutions.
• Assembled data analytical inputs using data visualizations for executive level presentations and conducted demos of the new product functionalities for Clients.

Ann Arbor, MI, US

• Assisted with the design and delivery of data models & visualizations which powered BI initiatives of the Health System
• Collaborated with external and internal stakeholders for determining project objectives and gathering business requirements.
• Created detailed Use Cases and User Stories for the Enterprise Analytics Project and built & tested user acceptance test cases.
• Executed cross-functional duties in an Agile environment that included business & data analysis, reporting, requirements gathering & documentation and building dashboards & visualizations.

Chicago, IL, US

• Trained in HIPAA policies & developed analytical frameworks to generate key insights into performance of new products
• Collaborated with multiple stakeholders to gather customer and system requirements and created user stories and test cases.
• Analyzed process performance across entire SDLC life-cycle using Business Processing Mapping and developed workflow models.

Burbank, CA, US

• Performed SQL Server & SAS Reporting to create Analytics Reports to understand trends from product conversion funnel metrics.
• Used Omniture SiteCatalyst for analysis &reporting for website traffic to find accurate & actionable metrics for analytics reports.
• Streamlined internal processes and provided efficient ad-hoc reporting to give actionable insights by creating an all-inclusive analytics report for cross-functional teams like Marketing, Customer Insights, Web.
• Created reports for stakeholders, performed data extractions and data presentations and automated the weekly reports.
• Integrated disparate data sources to create comprehensive view of business & developed analytical models to support decision making.
• Recommended data-driven optimization tactics to improve site performance & manage the business rule optimization process.

Dallas, TX, US

• Project 1: Deferred Maintenance Items Review--------------------------------------------------------------------------------------------------------------------------------
• Responsible for raw data conversion and data modeling by writing SQL queries in MS Access.
• Performed gap analysis of DMI to analyze the performance measures for SWA fleets using MS Excel for identifying patterns and key performance metrics.
• Presented findings to executives at monthly CASS meetings.
• Implemented a new internal reporting process to reduce the time of feedback for the auditing inspectors. Resulted in decrease in number of inspection errors..
• Designed interactive dashboards through Power Pivot and Tableau to measure team performance.

Richardson, Texas, US

• Working to provide support for the Research Explorer application and assisting technical as well as administrative staff.
• Duties include Data Entry, Data Administration, Database Maintenance, Data Modeling and Open Source Web Development using extensive use of PHP, SQL and Bibtex importer on the CakePHP framework.

Master'S Degree, Information Technology And Management

Bachelor Of Engineering (B.E.), Computer Engineering