Rutuja Kengale Email & Phone Number

San Jose, California, United States

• Spearheaded the development of two robust Power Apps aimed at streamlining sub-contractor budget management and employee weekly hours tracking, significantly boosting efficiency and accuracy within the payroll system.• Crafted user-friendly canvas app interfaces, integrating a variety of data sources seamlessly to elevate user experience and ensure data integrity.• Leveraged Power Automate to orchestrate approval workflows, notifications, and data consolidation, effectively streamlining operational processes.• Engineered interactive controls and implemented validation rules to enhance user experience and minimize input errors, elevating the overall usability of the applications.• Provided comprehensive user training sessions and ongoing technical support, ensuring a smooth adoption process and addressing user concerns promptly and effectively.• Implemented stringent role-based security protocols to safeguard sensitive data, ensuring compliance with stringent data protection regulations.

Sacramento, California, United States

• Gathered & documented data-specific requirements from stakeholders & department heads using Notion to create reports and build strategies.• Analyzed and prioritized requirements to efficiently generate reports daily, weekly, and monthly, using SQL queries in SSMS, thus shortening the feedback loop, and ensuring better analysis of data.• Worked on High Priority Power BI Dashboard to provide insights into the current trends and deliverables to the California State Govt. The authority impacted highly and clearly on the milestones achieved.• Built dynamic Power BI dashboards using DAX functions to represent graphs & trends and communicate the current progress of critical milestones.• Enhanced Power BI dashboards to provide time-critical metrics which doubled the delivery rate of parcels.• Major achievement – Increased processing speed and data accuracy of ad-hoc reports for cross-functional teams by 17%.• Tools: SSMS, Tableau, Microsoft Power BI, AWS

Little Rock, Arkansas

• Compiled and validated data from relational databases using SQL to meet business requirements.• Performed statistical & geographical analysis to study the distribution & concentration of KPIs worldwide. Improved the KPI rate by 10% by streamlining the efforts on key geographical locations.• Conducted GAP Analysis using activity/process diagrams to describe the current system and estimate the required efforts, resources, and potential risks in implementing the proposed changes.• Major achievement – Increased the number of student registrations by 36% in the following semester.• Tools: SSMS, MySQL Workbench, Tableau, Qlikview, Informatica

Little Rock, Arkansas Area

• Collected huge data sets from various sources to remove redundancies and potential errors.• Performed data validation for its correctness and accuracy using SQL queries.• Demonstrated deep analysis on key attributes to address data inconsistency challenges.• Mastered the ability to report trends and analyze the data pattern by using the Tableau dashboard.• Performed KPI analysis and designed dynamic dashboards to identify critical changes and represent rich graphic visualization.

Little Rock, Arkansas, United States

• Troubleshooted complex stored procedures, indexes, and views using SSMS to automate tedious tasks of daily updates.• Created alerts to regularly notify the team about errors that occurred during the database update process.• Developed SQL query templates to simplify the querying process and increase the efficiency of team members.• Enhanced daily manual update process by scheduling auto-backup database procedures in SQL Server Management Studio.• Major achievement – Improved team efficiency by 19% by automating the system to alert the team of the failed procedures.• Tools: SSMS, Google Docs

Pune Area, India

• Worked with various stakeholders to elicit and document requirements and produce relevant reports.• Converted vague, ambiguous requirements into well-defined artifacts like Stories, features, and Epics.• Owned and managed product backlog, feature prioritization, and decision-making process to successfully balance business impact, technology, and user needs.• Closely collaborated with cross-functional teams to communicate requirements, set Sprint goals, deliver new features, and remove roadblocks. Communicated insights and plans to management for transparency.• Used Agile SCRUM methodology for planning, development, and testing of the project for result based solution.

Hyderabad Area, India

• Combined data from multiple sources and wrote SQL queries to extract and validate it from the legacy system.• Deployed visualization techniques using Tableau/QlikView to build comprehensive dashboards.

Master'S Degree, Information Science/Studies, 3.80

Graduate Certificate, Business Analystics, 4.00

Graduate Certificate, Data Science, 3.84

Bachelor'S Degree, Electrical, Electronic And Communications Engineering Technology/Technician

12Th, Science

10Th, Maharashtra Board