Sql Server Process Automation

Rajendra Y

RPA-UiPath Developer

Email : **************@*****.***

Mobile: 978-***-****

Professional Summary:

Motivated and results-oriented professional with around 10 years of diverse industrial experience, specializing in Robotic Process Automation (RPA) using UiPath Studio and Orchestrator for over 5 years.

Skilled in designing and configuring UiPath virtual infrastructures across developmental stages—from Dev to QA and Prod—integrating Interactive clients, Resource PCs, Application Servers, and Database servers to optimize workflow efficiencies.

Proven ability in creating comprehensive documentation including Process Design Documents (PDD), Solution Design Documents (SDD), and Automation Plans, supported by experience in conducting RPA Assessments, ROI analyses, and delivering successful Proof of Concepts (POCs) to clients.

Expertise in automating data extraction using OCR tools (Microsoft Azure Vision API, ABBYY, Tesseract) and leveraging advanced techniques for document and data processing.

Implementing automation strategies with Sequence, Flowchart, and RE Framework methodologies.

Skilled in generating and presenting comprehensive test reports, collaborating closely with technical teams across Functional, Integration, Regression, and UAT phases.

Proficient in SQL Server for creating stored procedures, Views, Triggers, and Functions.

Expertise in writing System Test Plans, Test Design Specifications, defining Test Case Specifications and Test Procedures, developing, and maintaining Test Cases in Quality Center.

Education:

Master of Science in Computer Information Systems

Rivier University, NH

Certification

RPA UiPath Advanced Developer

UiPath Orchestrator certification

Technical Skills:

RPA Technologies

UiPath Studio (2018, 2019.10.5, 2021.4.4, 2023.10.3), UiPath Orchestrator

OCR Tools

ABBYY FlexiCapture, Microsoft Azure Computer Vision, UiPath OCR

Programming Languages

C#, .NET, Java, HTML, CSS, JavaScript

Automation Tools & Frameworks

UiPath Studio, Orchestrator, Kibana Dashboard

Databases& Tools

MS SQL Server, MS Access, Oracle

Environment

AWS, Virtual Machines, Windows (7/10), Linux

Business Applications

Bio4C ProcessPad, SAP, Salesforce, SharePoint, CASWEB

Professional Experience:

Client: Health Partners Minneapolis, MN Feb 2024 to Till Date

Sr. UiPath Developer

Responsibilities:

Implemented and customized RE Framework processes to optimize process efficiency and scalability.

Ensured robust process automation that met specific business requirements and enhanced operational efficiency.

Collaborated with business analysts to define and translate project requirements into actionable tasks for RPA implementation.

Executed End-to-End RPA using UiPath, from design to deployment and maintenance, integrating multiple applications to streamline workflows and achieve process optimization.

Created and maintained detailed documentation, including PDDs, SDDs, Process Maps, and Automation Plans, to ensure project transparency, scalability, and alignment with business goals.

Demonstrated strong troubleshooting skills by resolving production issues quickly and implementing strategies to minimize downtime and maintain system reliability.

Configured and optimized UiPath Orchestrator environments (DEV, UAT, and PROD) for seamless deployment, monitoring, and management of automation activities, ensuring performance and scalability.

Managed user credentials securely using UiPath's Credential Manager and implemented best practices for credential handling to protect sensitive information.

Provided training and support to teams on RPA tools, fostering knowledge sharing and skill development.

Monitored bot performance using triggers and metrics to identify bottlenecks and proactively enhance efficiency through iterative improvements and performance tuning.

Environment: UiPath studio 2023.10.3, UiPath Orchestrator, Kibana Dashboard, SAP, Salesforce, Bio4C, RE Framework, PDD, SDD.

Wells Fargo Hyderabad, India Sep 2020 to Jul 2022

UiPath Developer

Responsibilities:

Led end-to-end RPA processes, including requirements gathering, solution design, coding, testing, debugging, and implementation, to automate repetitive tasks and improve operational efficiency.

Ensured adherence to project timelines and quality standards while delivering efficient automation solutions.

Participated in daily meetings to showcase RPA capabilities for ongoing projects and potential stakeholders, effectively communicating benefits and functionalities.

Developed custom activities within UiPath to optimize bot performance, including PDF extraction, list mapping, and SharePoint upload activities.

Collaborated with project teams and business analysts to align RPA solutions with business needs, developing PDDs, SDDs, and educating SMEs on bot usage in production environments.

Managed the testing and maintenance of bots in live environments, including creating test procedures and supporting UAT and rollout phases to ensure seamless automation.

Demonstrated proficiency in debugging workflows using error handlers, Try-Catch blocks, and advanced automation logic, including conditions, loops, OCR, and object cloning.

Leveraged UiPath features like OCR, Image Recognition, Data Scraping, PDF extraction, Excel integration, and Email automation to implement advanced automation logic and optimize processes.

Solely responsible for delivering automation projects, ensuring operational efficiency and reducing manual efforts.

Environment: UiPath studio 2021.4.4, Orchestrator,SAP, SharePoint, Microsoft Visio, OCR.

Value Labs Hyderabad, India Jan 2018 to Aug 2020

UiPath Developer

Responsibilities:

Managed the entire lifecycle of RPA solutions, from identifying automation opportunities and gathering requirements to designing, deploying, testing, and implementing bots using UiPath to improve workflow efficiency.

Ensured seamless integration of RPA into existing business processes, optimizing efficiency and reducing operational costs.

Developed both attended and unattended bots for complex processes, enhancing productivity and accuracy across various business functions.

Supported business and technical teams throughout robotic projects, mitigating and resolving risks and issues that could impact project schedule, cost, scope, and quality.

Collaborated with stakeholders and business teams throughout the project lifecycle, from requirement gathering and design to addressing concerns during release phases, ensuring alignment with project objectives and successful delivery.

Implemented effective exception handling strategies using Try Catch and Retry Scope activities, continuously monitoring and refining automation workflows to optimize bot performance and ensure uninterrupted operations.

Utilized data scraping and OCR techniques (including AI Fabric) to extract structured data from applications and PDFs, enhancing automation capabilities and accuracy for reporting and analysis.

Leveraged and configured UiPath Orchestrator for efficient deployment, scheduling, monitoring, and management of bots, ensuring optimal performance and scalability.

Implemented Excel Application Scope and activities such as Read Cell, Read Range, and Append Range to automate data manipulation tasks and enhance data accuracy and reporting capabilities.

Managed testing and support throughout Product testing and User Acceptance Testing (UAT) phases, addressing identified bugs and ensuring smooth deployment of automation solutions.

Environment: UiPath2019.10.5,Orchestrator, MS Excel, SQL Server, GitHub, Attended Bots, Unattended Bots, Data Scraping, OCR.

MRF Chennai, India Jun 2013 to Dec 2017

.Net Developer

Responsibilities:

Built a user-friendly interface using the .NET Framework class library, separating application logic from presentation for easier maintenance.

Designed and implemented visually appealing and interactive web forms using ASP.NET Web controls and C#, ensuring efficient user interaction with the application.

Created a secure module for user validation, password changes, and information searches, enforcing access based on user privileges within the system using ASP.NET, C#.

Contributed to the design, review, and execution of comprehensive test cases to ensure application functionality.

Developed automation scripts for repetitive tasks and generated detailed log files using C# to report test results.

Implemented client-side and server-side validation strategies, including a secure module for user validation, password changes, and privilege-based access control using ASP.NET and C#.

Established connections between web applications and a Microsoft SQL Server database using ADO.NET with C# in Visual Studio 2012.

Actively participated in code reviews with team members, providing constructive feedback on designs, plans, documentation, and code.

Actively participated in meetings and teleconferences, contributing to problem-solving and leading technical solution discussions.

Environment: Visual Studio 2010/2012, C#.Net, Coded UI, ASP.NET 4.5, ADO.NET, SQL Server 2012.

Contact this candidate