Power Platform Developer
Resume:
Ruchi Aggarwal
*******.********@*****.***
https://www.linkedin.com/in/ruchiaggarwal26/
Profile
A highly motivated, experienced, and certified Microsoft 365 platform (PowerApps, Power Automate, Power BI, Dataverse) Developer with a proven track record of success in the software development industry. I am passionate about using my skills and experience to create innovative and user-friendly solutions that meet the needs of my clients.
My work authorization status is Legal Permanent Resident (Green Card holder), and I possess a Public Trust security clearance.
Skills and Experience:
• 12+ Years of experience in software development, maintenance, and support.
• 5+ Years of experience designing and developing complex applications with Power platform using Power Apps, Power Automate and Power BI, Dataverse and SharePoint.
• Hands on experience on CI/CD pipelines, PowerApps ALM, Custom connectors.
• End to end application design involves requirement gathering from business SME’s, designing prototypes, developing applications, testing, and exporting across different environments.
• Very good learning and implementation skills of new technologies and solutions.
• Excellent code reviews and code debugging skills.
• Prior Experience in developing .NET applications using ASP.NET, C#.Net, ADO.NET & Object- Oriented Programming.
• Good SQL programming skills including Stored Procedures, Functions, and Triggers.
• Worked with clients CDC, TD Bank, GE, DLL, Eli Lilly, and Renault Group.
• Understanding Customer Business Requirements with help of functional and business owners. Study Business Requirement Document, which includes Business Description, Functional Requirements, Technical Modifications, DB Requirement, Impact analysis etc.
• Communicate Daily/Weekly on Calls/Emails with functional, business and end users of Customer to understand application requirement, development, and implementation logic.
• Lean Trained: Learned the concepts of Lean as a part of Organization Quality training. Technical Skills
Office 365
PowerApps (Canvas), Power Automate, Power BI, Data Verse, Share Point, Web Api, Custom Connector, Azure
Languages Dot NET Technology (ASP.NET, C#)
RDBMS MS-SQL Server 2005/2008
Others Java Script, HTML
• Certifications:
o PL - 100: Microsoft Certified: Power Platform App Maker Associate o PL – 300: Microsoft Certified: Power BI Data Analyst Associate o PL - 900: Microsoft Certified: Power Platform Fundamentals o AZ – 900: Microsoft Certified: Azure Fundamentals o Certified ScrumMaster (CSM)
• Work Experience
o Cherokee Nation Businesses (October 2023 – Present) Currently working for their client CDC.
Project 1 Enhanced Staffing Management Solution for CDC Type Staffing Application (Canvas App)
Technologies: PowerApps, Power Automate, Power BI, Dataverse, Share Point Client Center for Disease and Control (CDC)
This project delivers a robust and modernized staffing application for the Centers for Disease Control and Prevention (CDC), leveraging the full potential of the Microsoft Power Platform. This solution provides a secure, scalable, and efficient platform for managing the entire employee lifecycle, from onboarding to offboarding, for both full-time and contract personnel. All the in and out-processing activities are completed through the IO Processing checklist. Staffing data refreshes daily with their HR system data.
Key Features and Benefits:
Dataverse Backend:
Centralized data management within Dataverse ensures data consistency and integrity, eliminating reliance on disparate systems.
Role-Based Security: Implemented a granular role-based security model to control access and maintain data confidentiality, adhering to strict compliance standards. Streamlined Processes with Power Apps:
Intuitive Power Apps interface for seamless employee management, including onboarding, transfers, promotions, and terminations.
Automated in/out processing and activity tracking to improve efficiency and reduce manual errors.
Automated Workflows with Power Automate:
Data Integration: Power Automate data flows facilitate daily data synchronization from the existing HR database, ensuring real-time accuracy. Automated Notifications: Configured automated email and in-app notifications to alert relevant stakeholders about critical events and pending actions, improving responsiveness. Time-sensitive activity reminders: Implemented flows to notify users when activities are not completed within a given time frame.
Data-Driven Insights with Power BI:
Interactive Power BI Dashboard: Created a dynamic dashboard for operational managers to know how many In and Out-processing activities needs to be completed, employee status, and other indicators like how many staff is coming in or going out of the NCIPC. Paginated Reports: Developed various paginated reports using Power BI Report Builder, providing detailed and printable reports for in-depth analysis and compliance purposes. Comprehensive Employee Lifecycle Management: Supports all employee types, including full-time and contract personnel.
Manages all stages of the employee lifecycle, from recruitment and onboarding to offboarding. Impact:
This solution enhances operational efficiency, improves data accuracy, and empowers CDC managers with actionable insights, ultimately contributing to better workforce management and organizational effectiveness.
Project 2 NPATS: Automating Vacancy Management and Approval Processes Type Approval management Application
Technologies: PowerApps, Power Automate, Dataverse, Power Bi, Canvas App Client Center for Disease and Control (CDC)
NPATS (NCIPC Personnel Action Tracking System) is a comprehensive Power Platform application that digitizes and optimizes the vacancy creation and approval workflow. This solution empowers different divisions to create vacancy requests within a structured Power Apps interface. Leveraging Dataverse as its data backbone, NPATS ensures data integrity and security. Power Automate automates the multi-stage approval process, routing requests to designated approvers based on predefined rules. Power BI Report Builder enables the generation of detailed reports, providing valuable insights into vacancy trends and approval timelines. Project 3 Wire Intake Tool
Type Business Application
Technologies: PowerApps, Power Automate, Dataverse, Canvas App Client TD Bank Canada
Description TD Bank finance teams need to process wires via emails from multiple partners. These wires need to be actioned by different teams of the bank. This process requires several business checks to avoid duplicate processing, non-compliant requests, and invalid critical fields such as IBAN validators for European banks or Routing numbers for US banks. The Wire Intake Tool: The Wire Intake Tool addresses all these issues. It is a centralized tool that is customized to the process requirements. The Wire Intake Tool is a valuable tool that helps TD Bank finance teams process wires more effectively.
Avoids duplicate processing: The tool checks for duplicate wires before processing them. This ensures that wires are only processed once, which saves time and money.
Avoids non-compliant requests: The tool checks for compliance issues before processing wires. This ensures that wires are processed in accordance with the bank's policies and procedures. Validates critical fields: The tool validates critical fields in wires before processing them. This ensures that wires are processed accurately and efficiently.
Responsibilities: Collaborate with Business Owners, SMEs, and Client Managers to Implement End-to-End Solution.
The Solution: The solution included the following features: Different levels of approval: Power Automate trigger flows were used to achieve different levels of approval.
SLA emails: Schedule flows were used to send SLA emails. Different teams: The application needed to be used by different teams, such as submitters, approvers, processors, and super users. Different AD groups and database filters were used for added security.
Customer IBAN validator: A customer IBAN validator was used to validate IBAN codes across the world.
Benefits
The solution had the following benefits:
Added security: Microsoft Dataverse was used to provide added security for banking and personal information.
Efficient workflows: Power Automate trigger flows and schedule flows were used to create SLA emails and Rush Wire emails to multiple teams.
User-friendly interface: Multiscreen forms and template forms were used to give users a neat and clean view.
Overall, the solution was a success and met the needs of all stakeholders. Project 4 Rewards & Recognition App
Type Business Application
Technologies PowerApps, Power Automate, Share Point, Canvas App Client Genpact (www.genpact.com )
Description Genpact Employee Rewards: Genpact has a rewards program to recognize employees who perform excellent work. The program includes quarterly and yearly team awards.
The R&R application was developed using Microsoft Power Apps and Power Automate to automate the process. The application enables the Human Resources department to open the rewards, and once opened, all eligible managers are automatically informed by email with all the details. Managers can then provide their nominations in the app. The app also requires managers to attach an employee/team picture based on the award category. Finally, on the day of the award announcement, HR publishes the selected nominations on the application. The app also generates an Excel file that HR needs to use for their records. Responsibilities: Coordinate with the Human Resource department as well as operation teams to understand their requirements and developed the app accordingly by understanding each department's needs. The app was developed using Microsoft Power Apps and SharePoint. It was used to store app data, maintain Excel files, and employee images on a shared location. Responsive design: The app was built as a responsive app so that it supports multiple devices and screen sizes.
SharePoint integration: The app was integrated with SharePoint to store app data and maintain Excel files and employee images on a shared location. Power Automate Flow: A Power Automate Flow was created to store the pictures on a shared SharePoint folder as soon as a nomination is made. Benefits of the R&R Application: The R&R application has several benefits, including: Automated process: The application automates the rewards process, which saves time and effort for HR.
Efficient communication: The application automatically sends emails to eligible managers with all the details about the rewards. This ensures that managers are aware of the rewards and can provide their nominations on time.
Easy to use: The application is easy to use for both HR and managers. This makes it easy to nominate employees for rewards and to track the progress of the rewards process. Transparent process: The application makes the rewards process transparent for employees. Employees can see the criteria for each award and track the progress of their nominations. Overall, the R&R application is a valuable tool that helps Genpact recognize and reward employees for their excellent work.
Prior Experience:
Genpact LLC, USA (November 2022 – July 2023)
Worked as Power Platform developer for their client TD Bank.
Leading the project and interacting with the business stake holders.
Successfully delivered the project with in the given time frame. Genpact LLC USA (Nov 2019 - Mar 2020)
Worked as a software engineer on a project to maintain and support a legacy software system.
Successfully implemented new features and functionality in the software system. Genpact LLC USA (July 2016 - September 2019)
Worked as a software engineer on a project to maintain and support a legacy software system.
Successfully implemented new features and functionality in the software system. Genpact India Pvt. Ltd. (March 2007 - October 2014)
Worked as a software engineer on a variety of projects, including the development of new software applications, the maintenance and support of legacy software systems, and the implementation of new technologies.
Successfully delivered projects on time and under budget.
The software applications and systems that I worked on have been used by a variety of clients, including Fortune 500 companies. Education
Master of Computer Applications
Personal Details
Marital Status: Married
Phone No: +1-404-***-****
Email Id: *******.********@*****.***
Address: 4390 Mossbrook Cir, Alpharetta, GA, 30004 Work Authorization: Green Card holder
References: Available on request
Contact this candidate