MANOJ KUMAR N
adcgsl@r.postjobfree.com
Phone: 412-***-****.
PROFESSIONAL SUMMARY
Overall 7+ years of IT experience including three years in Automation Anywhere and UIpath.
Designed, Developed and tested Bot tasks using Automation Anywhere.
Performed Automation Anywhere control room installation with clustered approach along
Hands on coding experience of parsing large files in C#.
Writing custom code in C# and integrating in Metabots like getting data from different databases using SQLBulkcopy method and using the BOT Initialize method.
Integrating DLLs with Metabots and Skilled in RPA (Automation Anywhere), IQ Bot and Bot Insights
Experience in Developing with add data row, add data column, get Row Item and For each item in order to loop a Data Table.
Automated Invoices using AA.
Developed Bots that used tasks like PDF,Excel, Object Cloning,smart recorder, window actions, webservices in AA.
Integrated of Automation Anywhere with other internal Desktop based applications.
Writing custom macros and calling them from AA
Experience in using control room in order to schedule the bots in AA.
Developing UIpath code to interact with Excel Sheets using UIPath.Excel. Activities pack like using Append to CSV in order to append a Data Table to a CSV File, ReadCSV which reads all the entries of a CSV File and using various other activities like GetTableRange, Filter Table, Insert Column, Read Cell, Invoke VBA etc.
Used Automation Anywhere in salesforce, java, persistence and FTP and form Activities in order to build various Bots.
Experience in developing both assisted and backend bots in UIpath.
Deploying the Bots using UIpath Orchestrator.
Using Nu Get Feed Activity in the package so that each time you deploy a package to the Robot machine so that it has access to all the activities using web.config file.
Experience in publishing a package from studio to Orchestrator. The main.xaml is automatically created along with the rest of automation .xaml files.
Using queues and scaling the bots in UIpath.
Hands on database knowledge writing stored procedures and Triggers.
Extensively worked on Object Studio to create visual business object for each of the applications.
Proficient in automating the Web-Based, Windows Based and have a good knowledge on citric Applications.
TECHNICAL SKILLS
RPA Tools
Programming
Automation Anywhere 9.0,10.3, Blue Prism v5,UIpath 2017.x
Database
MS-SQL Server 2000, 2008, 2012, Database design, T-SQL, stored Procedures, Triggers, Functions, Views, Indexes, Joins
Reporting
Crystal Reports 7.0, XI, SSRS, SSIS, SSAS
Version Control
Visual Source Safe, Revision Control System, MKS, Version One
Other Tools and Technologies
UML, Microsoft Visio, MS Office
Operating Systems
Windows XP/2000/NT/7/8
Standards/Specifications
HL7 Standards, 270-271 standards, HIPAA, EDI
Education Qualifications:
1.Master’s in Finance Suffolk University, Boston, MA.USA.
2.Bachelor’s in Computer Science
PROFESSIONAL EXPERIENCE
Client: McKesson Mar 2019 – Till Date
Role: RPA Developer (AA)
Responsibilities:
•Ability to quickly convert business requirements to system requirements and built clear process workflows and documentation.
•Worked closely with Process SME's to translate process in to detailed design documents and educated SME's to work with Bots in production.
•Created external scripts using VBA and integrated with Automation Anywhere to achieve process automation
•Creating database connections to fetch the data and automated the process to arrange data with Automation Anywhere.
•Creating external scripts using Python, C# and integrated with Automation Anywhere to achieve process automation.
•Performed process assessment, deep dive, RPA feasibility for processes for process areas involving web, mainframe and windows based applications.
•Designed, Developed and tested Bot tasks using Automation Anywhere.
•Using string operation to compare and eliminate duplicates from the data.
•Created database connections to fetch the data and automated the process to arrange data with Automation Anywhere.
•Using Excel, CSV commands, Send Email Commands to Email reports and errors.
•Designing insightful reporting for business process improvement and benefit realization
•Ongoing contribution to the automation Practices and Frameworks in order to drive a culture of continuous improvement
•Provide development and testing support, and follow implementation of standards and best practices in alignment with our architecture patterns
•Conduct code and process reviews to ensure the highest level of quality
•Create reusable processes and/or extensions for the RPA tool-sets
•Created reusable automation framework with MetaBots and reusable libraries with data externalization for RPA implementation.
•Automating tasks using web recorder and Scheduled tasks in client machine to repeat as per requirements using Automation Anywhere.
•Using log file to handle the errors and maintained extracted data.
•Identifying and debugging the errors using Error Handlers.
•Performed stress test for bot Scripts to prove the scalability and stability of RPA code.
Automated tasks using web recorder and Scheduled tasks to repeat as per requirements.
Designed solutions utilizing RPA best practices and maintain technical responsibility for project delivery
Analyzing the user stories and breaking up the user stories into sub-task with estimation.
Project-1
Project Name : Care Centrix a Verification and Authorization
Client : MPCS
Team size : 1
Environment : RPA Suite – Automation Anywhere
Duration : 4 Months
Description: This process downloads worklist with Sales Order from Brightree, verify the patient’s eligibility for the item in the period and it get the approval from the Care Centrix portal. Update the information in the brightree and change the work in progress
Project-2
Project Name : Total Source Authorization and Bill back
Client : MPCS
Team size : 1
Environment : RPA Suite – Automation Anywhere
Duration : 4 Months
Description: This process downloads worklist from Brightree, one bot classifies the notes to three groups (Reviewed, Supply Manager orders(SMO), outbound) based on complex hierarchies of validations based on items, Insurance, ship to address etc. This classifies the notes to items that company provides by them, by third party, which they does not provide. other bot in this process work on placing the SMO orders to supply manager website.
Project-3
Project Name : Recreate Recertification
Client : MPCS
Team size : 1
Environment : RPA Suite – Automation Anywhere
Duration : 3 Months
Description: This process works on Recreating CMNs as initials that are not able to be logged because of initial CMN not logged. It recreates the CMN, transfer the valid Sales order- items to the new CMN, add Narratives to the Items, transfer documents to the items
Environment: Automation Anywhere, Excel, External and Internal applications, SAP, Brightree, Care Centrix, Supply Manager, workday.
Client: Silicon Valley Bank Jan 2018 to Mar 2019
Role: UIpath Developer
Responsibilities:
Actively participate in Process Discovery and assist customers prioritize process
Working with Citrix / Virtual environment with screen scrapping and OCR activities.
Implemented UIPath automation for web application, desktop application, mainframe applications and integrate with applications like Excel, CSV, and Email etc.
Worked closely with Six Sigma certified process analysts on process optimization and authoring PDDs.
Designed RPA process solutions in accordance with UI Path design principles and conventions.
Integrated UIPath with salesforce, SAP and ServiceNow.
Worked on webservices with UIpath.
Worked with Data Tables like adding data Column,row, Merge Data Table, Generate Data Table.
Experience working on UIAutomation, in getting a elements attribute or set a clipping region.
Calling the Orchestrator with HTTP Request from UIpath Studio.
Worked on queues in order to scale the automation.
Worked on Image comparison using Image recognition in UIpath studio.
Created both Attended and Unattended Robot resources, and provided centralized Robot logs, remote execution, monitoring, scheduling, and work queues using UIpath Orchestrator.
Identified and debugged the errors using Error Handlers.
Created process model for windows-based application using UI Path and testing it in the Orchestrator.
Environment: UIPath, Excel, UIpath Orchestrator, SQL Server, Citrix, PDF, Windows, VB.NET, Sharepoint.
Client: Verizon Mar 2016 – Apr 2017
Role: RPA Developer (AA)
Designed automation solutions and Involved in End to End development of Business Process using Robotic Process Automation Platform.
Worked as Business Analysts in identifying and defining the requirements.
Developed Solution design document (SDD) to meet the defined requirements.
Customized the existing automations and added the new business requirements for existing applications. Expertise in working on Proof of Concept of various new processes.
Participating in scrum calls on daily status and enhancements.
Debugging, Documentation and Implementation of Business Process Solutions.
Working with business for the Initial process analysis and feasibility of the process.
Involved in automation of master excel sheet which has business rules in it and save a local copy.
Used various actions like Conditions and Loops, Error Logging and commands like Object Cloning, OCR, Key Strokes etc., for coding the automation process.
Integrated Metabots with the Taskbots to scale automation efforts effectively.
Helped on scheduling the tasks through Control room.
Automated tasks using web recorder and Scheduled tasks to repeat as per requirements using Automation Anywhere.
Conducting Unit Testing and System testing. Facilitating Integration and User Acceptance Testing.
Extensively worked on debugging application for fixing bugs and Production support.
Run different batch files daily and weekly to capture up to date information.
Used the wait command along with the object cloning to avoid exceptions.
Worked with Terminal Emulator to automate mainframe applications.
Run different batch files daily and weekly to capture up to date information.
Environment: Automation Anywhere 10.3, SQL Server 2014, Excel, HTML, Java Script, CSS. Visual Studio.
Client: Hexaware Technologies Jun 2012 -Feb 2016
Role: SQL Server/.Net Developer
India
Responsibilities:
·Analyzed, Designed and developed the system to meet the requirements of business users.
·Implemented presentation tier using HTML, CSS by utilizing the mockups and prototypes resembles process requirements.
·Back-end stored procedures development with PL/SQL.
·Used jQuery library functions for the logical implementation part at client side for the application.
·Implemented user interface guidelines and standards throughout the development and maintenance of the website using JavaScript, jQuery, CSS and HTML.
·Involved in developing the webpage using HTML and JSP.
·Used AJAX as an implementing part of the functionality for Customer Registration and Customer information modules.
·Developed Page layouts, Custom navigation, Animation buttons and Icons.
·Developed browser code using CSS and JavaScript for Internet Explorer.
·Used CSS to create table free layout for user interface screen.
Environment: Java/J2EE, EJB, webservices, SpringBoot