Prasad Yadav
Charlotte,NC
Summary
Dynamic and results-driven RPA Lead Developer with nearly 10 years of experience in automation, process optimization, and team leadership. Proven expertise in designing and implementing scalable robotic process automation (RPA) solutions using industry-leading tools like UiPath, Automation Anywhere. Skilled in leveraging AI and machine learning to solve complex business challenges, including predictive analytics, sentiment analysis, and intelligent document processing. Adept at leading cross-functional teams to deliver high-impact solutions that enhance operational efficiency and reduce costs.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Lead RPA Developer
Merck
01.2020 - Current
- Automated critical processes such as D-365 and Certificate of Analysis, scaling them across multiple divisions within the organization to enhance efficiency, standardization, and operational productivity
- Automated the SAP process "SWMS," optimizing workflow efficiency by eliminating 20 FTEs and enabling the processing of 2,000 transactions per day through UiPath, ensuring accuracy, scalability, and reduced operational costs
- Experienced in using CI/CD pipelines with Azure Devop’s for source code management and code migration
- Routed Pre-UAT and Post-UAT documents through the internal document routing system, MEDS, ensuring seamless approval workflows and compliance with organizational standards for efficient Pre-UAT and Post-UAT processing
- Developed and implemented an Adhoc Email Trigger Bot to initiate various email-driven processes dynamically, ensuring timely execution and improved automation flexibility
- Experience using UiPath Document Understanding and used Machine learning models for automating unstructured pdf’s
- Designed and developed Kibana visualizations and dashboards to monitor and analyze the performance of processes deployed in production
- Skilled in effective communication, with the ability to engage and collaborate with stakeholders across all organizational levels
- Integrated UiPath with AWS Textract to automate PDF processing by uploading files to an AWS S3 bucket, leveraging OCR capabilities to extract and retrieve structured data efficiently
- Implemented SharePoint activities in UiPath and extracted data using CAML (Collaborative Application Markup Language) queries to efficiently retrieve and manipulate SharePoint list data
- Developed multiple reusable components for automating SAP login, logout, and authentication processes for various internal websites, enhancing efficiency, scalability, and reusability across automation workflows
- Experienced in working within Agile sprints and participating in backlog refinement sessions to prioritize and plan tasks effectively worked on the process feasibility and the solution design of the new processes
- Expertise in planning, delegating, and mentoring team members to achieve project objectives efficiently
- Authored user stories outlining the test cases to be executed and thoroughly documented the corresponding test results
- Developed a universal dispatcher that automates email processing by reading emails, extracting relevant data, loading it into queues, and downloading attachments for further processing, enhancing workflow efficiency and scalability
- Experience in developing a test plan and outlining the test approach, scope and resources
- Report and document any defects or issues identified during testing and collaborate with development teams for resolution
- Extensive experience leading both offshore and onshore teams to deliver successful RPA projects
- Responsible for Code review, approving test case scenarios, white boarding sessions and code migrations
- Worked on the production support and monitored the jobs and coordinated with the business team in case of any exceptions
- Perform regression testing to ensure that new changes or updates do not negatively impact existing RPA processes
- Experience using API’s in UiPath for the Robust and exception free automation
- Implemented UiPath Action Center to automate a process requiring business input, enabling seamless collaboration between bots and human decision-making for improved efficiency
- Utilized Confluence to document process details throughout the lifecycle, ensuring centralized and accessible records for seamless collaboration and version control
- Developed UAT test cases and documented evidence to validate successful execution, ensuring alignment with user requirements and system functionality
- Automated ERP application SAP and SharePoint processes and generated reconciliation report for the business users
- Experienced in using Enhanced RE-frame work and implemented multiple processes
- Extracted JSON data from SharePoint and implemented complex logics to generated data into datasets and updated into SAP application
- Supported issue resolution that arise in day to day running of RPA processes and provided timely responses and solutions as required
- Developed and identified reusable automation components to enhance efficiency and streamline workflows
- Experienced in taking business requirements, current and future state process designs and translating them into robotic solution using core workflow principles that are efficient, well structured, maintainable, and easy to understand
- Coordinated and led the team through all project phases, ensuring timely delivery of milestones and objectives
- Created AS-IS and TO-BE process diagrams using tools such as Visio and Gliffy to visualize current workflows and future state improvements
- Proficient in working with the Enhanced Re-Framework and successfully implemented multiple automation processes using its capabilities
- Experienced in taking business requirements, current and future state process designs and translating them into robotic solution using core workflow principles that are efficient, well structured, maintainable and easy to understand
Senior RPA Developer
Hiscox
04.2019 - 12.2020
- Worked closely with business team conducting sessions on requirements review, prepare Process Design documents (PDD), Requirement traceability matrix, test results document
- Experienced with Reframe work and implemented multiple processes and generated reports, used exception handling techniques
- Automated mainframe applications using Terminal Activities
- Sent an automated Finance summary report at the end of the process
- Developed the Outlook Macros to trigger the bot without the use of Orchestrator and Studio
- Automated several under writer processes like RTQ crime, Tech Cyber, Cyber Auto renewal which had great ROI
- Automated internal Magic application and input the data into the application from the Excel rater file and PDF files
- Experience of using Visio and Draw.io for creating flow diagrams for PDD and SDD
- Created the Solution design document (SDD) for each process which explains the bot’s execution of a particular process
- Created deployment guide and Bot run books for the business user for easy bot handling
- Created the test cases for the UAT phases for the successful roll out of the processes
- Worked on Outlook mail activities for reading the emails and moving to the target folder
- Extensively worked on debugging application for fixing bugs and Production support
- Working with different logging levels, tracking and breakpoints in debugging of the process and applied exception handling mechanism as required, using try catch blocks
- Designing and implementing software robotics and process automation to deliver against business requirements, software and industry best practices
- Experience of using Orchestrator queues to handle bulk data between the bots
- Facilitating workshops, working with process owners/SMEs and technology teams to analyze and assess automation feasibility
- Review the test scenarios and map the traceability to the requirements, identify the gaps in requirements
Senior RPA Developer
British Petroleum
12.2018 - 04.2019
- Worked closely with business team conducting sessions on requirements review, prepare Process Design documents (PDD), bot user guide, Requirement traceability matrix, test results document
- Defines more specific development tasks, task dependencies, and provides time estimates to complete work
- Automated Finance- Well Work Over Process, OBO Daily Report, SAP Timberwolf Process
- Identify and communicate the technical infrastructure requirements to design RPA process solutions in accordance with standard RPA design principles and conventions
- Experienced in leading multiple process at a time and worked closely with other developers to identify technical blockers and its remedies
- Created and documented test procedures and scenarios for the pre-UAT phases and supported operational teams during the UAT and rollout phases
- Helped client in reducing the cost by 75% and reduced headcount by 40%, by deploying multiple ROBOTS into production
- Shadowing the client requirements and making the requirement specification Document
- Experience in staging and deploying the automation solution into test and live environments
- Develops scalable and efficient process automations and reusable components that can be leveraged across different lines of businesses
- Expert in implementing complex logic with string manipulations, Excel and various commands
- Worked on SAP Automation and running the transaction codes and getting the data and uploaded to SharePoint
RPA Developer (UiPath)
Hiscox
09.2018 - 12.2018
- Worked closely with business team conducting sessions on requirements review, prepare Process Design documents (PDD), bot user guide, Requirement traceability matrix, test results document
- Developed the Outlook Macros to trigger the bot without the use of Orchestrator and Studio
- Automated internal under writing Magic application and input the data into the application from the Excel rater file
- Worked on Outlook mail activities for reading the emails and moving to the target folder
- Extensively worked on debugging application for fixing bugs and Production support
- Working with different logging levels, tracking and breakpoints in debugging of the process and applied exception handling mechanism as required, using try catch blocks
- Designing and implementing software robotics and process automation to deliver against business requirements, software and industry best practices
- Facilitating workshops, working with process owners/SMEs and technology teams to analyze and assess automation feasibility
- Review the test scenarios and map the traceability to the requirements, identify the gaps in requirements
- Implemented exception handling techniques and setting alerts at every possible scenario for a robust error-free development
- Provide appropriate training to customer on new technologies and tool
- Working with different logging levels, tracking and breakpoints in debugging of the process and applied exception handling mechanism as required, using try catch blocks and State Machine’s
- Automating business process such as scraping the values for each PDF and entering in the web portal
- Created a bat file to run the attended bots in the target machine without the studio
- Experience in staging and deploying the automation solution into test and live environments
- Implemented the end to end execution for different processes using Attended and Un-Attended Bots
RPA Developer (UiPath)
McDonald’s Canada
05.2018 - 09.2018
- Developed SDD (Solution Design Document) and involved in End to End Robotic Process Automation (RPA) using UiPath Reframe work and involved closely with BA in analyzing the requirement
- Interacted with the multiple remote desktop and VNC application & Used Image based, Text and Hotkey activities in Virtual Environments
- Automated processes of MCD service desk – RFM Package Management, IBOS, Web Mail Password reset, WIP Management, Three Strike rule, Tech America, LRS, CDM
- Used Rest API calls for automating service now, which includes getting data and creating tickets and updating the information
- Deployed the process in UiPath Orchestrator, used Queues to get items from orchestrator to perform tasks and scheduled Process for execution
- Used Image based automation in order to automate the Remote desktop applications
- Scheduling the BOT's through Orchestrator and managed the robot's workloads
- Created process model for browser-based application and testing it by using UI Path
- Worked with implementation of Http Request activity for Get, Post, Put, Delete and Merge with in UiPath for API calls integration with various ticketing tools like Service Now
- Performed exception handling using Try-Catch activity and Proficient at using loops, iterative activities like while, do while and for each activity
- Designed and developed workflows for Web portal, Excel, PDF, TXT and Email automations
- Worked on screen scraping and Data scraping, full text, Native text and OCR
- Expert in analyzing the problems and implemented the processes to improve as per client requirements
- Used selectors for interacting with window and web browsers for continuous navigation of applications
- Image-based texts in applications are also automated with mouse clicks
- Implemented exception handling techniques and setting alerts at every possible scenario for a robust error-free development
RPA Developer (UiPath)
Mizuho Bank
07.2017 - 04.2018
- Involved in designing, developing and implementation of Robotic process automation using UI Path
- Worked with the client, Mizuho Bank and involved in evaluation, analysis & documentation
- Automated processes for IT Security department which involves the reconciliation of data
- Automated processes- Metro, Pegasys, EBS etc
- Working with solution architect to prepare Process Definition Document (PDD) and Solution Design Document (SDD) and trained SME’s to work with BOT’s in Production
- Developed Workflows to Interact with different mail services such as POP3, OUTLOOK and IMAP to get and send the mail messages into folder along with attachments
- Review the test scenarios and map the traceability to the requirements, identify the gaps in requirements
- Automated text in PDF’s using screen scraping to calculate the invoices and store them into a data table using UI Path
- Created process model for browser-based application and testing it by using UI Path
- Automated data transfers, including importing/exporting data between applications or files
- Worked on Excel for the reconciliation of the data and to find discrepancy between data
- Worked closely with business team conducting sessions on requirements review, prepare Process Design documents (PDD), bot user guide, Requirement traceability matrix, test results document
- Worked collaboratively with test teams during the Product test and UAT phases to fix assigned bugs with quality
- Experience in Robotic Process Automation to automate web application, desktop application, mainframe applications, UNIX and integrate with applications like Excel, CSV, PDF, Text etc
- Working with Citrix / Virtual environment with screen scrapping and OCR activities
- Designed and Implemented Standard and Generic Framework to automate the reconciliation of client applications using software robotics and process automation
- Carrying out end-to-end testing, troubleshooting of software robots
- Responsible for control management of automation bots by conducting periodic audits of existing code and provide inputs on exception handling, performance improvement and coding standards
- Prepared ROI model, project reports, performance specifications for BOTs and delivered presentations for the team
Jr .Net Developer
Micro Spark Software Solutions
07.2013 - 06.2015
- Developing the application using ASP.NET, C#.NET, AJAX, J-Query, JSON, HTML, JavaScript and CSS
- Designed and implemented C#.NET class libraries to implement the business logic and data access operations using ADO.NET
- Implemented both web and windows client/server-based applications
- Involved in various levels of the development life cycle by Gathering Requirements, Analyzing, Design and Development
- Developed SOAP and Restful WCF services in C#.NET
- Used ASP.NET Validation controls and JavaScript for validating user inputs
- Used LINQ queries to retrieve data from Arrays, Collections and Generics
- Coded and created Stored Procedures for performing repetitive tasks in updating related tables using SQL Server database
- Involved in source code back-up and maintenance
- Performed code reviews using TFS
- Developed scripts using VB which is part of SSIS package
- Used ASP.NET MVC 5.0 for building scalable standards-based web applications
- Performed unit testing, fixing bugs and maintenance of the product
- Worked with Agile Methodologies to segregate the development tasks into various sprints
- Worked on routing to load controller type using MVC 5.0 Web APIs for reaching appropriate action in the web application
- Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself
- Led the effort to build new test frameworks and or extend existing frameworks, which allowed us to perform end-to-end testing in multi-component environments
- Collaborated with the test engineers to design and develop a reusable architecture for the test automation
Education
Master of Science - Information Technology
California State University, Fresno
Fresno, CA05-2017
Skills
- Project management
- Team leadership
- Business process mapping
- System integration
- Robotic process automation
Certification
➢ UiPath Advanced Certified (UiARD)
➢ Automation Anywhere Certified
➢ Certified UiPath Solution Architect
➢ Certified in UiPath Document Understanding
➢ Certified in UiPath AI Center
➢ Certified Level 3 UiPath Advanced
➢ Certified UiPath SAP Automation
Timeline
Lead RPA Developer
Merck
01.2020 - Current
Senior RPA Developer
Hiscox
04.2019 - 12.2020
Senior RPA Developer
British Petroleum
12.2018 - 04.2019
RPA Developer (UiPath)
Hiscox
09.2018 - 12.2018
RPA Developer (UiPath)
McDonald’s Canada
05.2018 - 09.2018
RPA Developer (UiPath)
Mizuho Bank
07.2017 - 04.2018
Jr .Net Developer
Micro Spark Software Solutions
07.2013 - 06.2015
Master of Science - Information Technology
California State University, Fresno
Similar Profiles
Avery PruittAvery Pruitt
Operations Technician at MerckOperations Technician at Merck
Reginald Henderson IIReginald Henderson II
E- Discovery Analyst at MerckE- Discovery Analyst at Merck
Leland Foster LauryLeland Foster Laury
Director of Global Communications at MerckDirector of Global Communications at Merck