Ashutosh Kumar Mishra

Responsibilities:

• Created procedures for automation solutions and process optimization by developing a robust low code tool solution.
• Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions
• Orchestrated efficient large-scale software deployments.
• Worked with project managers, developers, quality assurance and customers to resolve technical issues.
• Evaluated project requirements and specifications and developed software applications that surpassed client expectations.

Data Migration Project ( US Telecom Giant )

Tools Used: Alteryx , SQL Server

• Creation of ETL process for loading data to Nakisa Migration Project system.

• Creation of Databases based on the different sets of transformation logics on SQL Server and by importing datasets from flat files.

• Extraction and Transformation of raw data from source SQL using Alteryx.

• Removing redundant data, NULL values, truncation of fields, date transformation and logic creation using Alteryx designer.

• Mapped field values by cleaning data, mapping keys and transformation logic based on business requirement.

• Creation of Validation workflows on top of normal workflows to secure data accuracy.

• Preparing reports for executive leadership that effectively communicates trends, patterns, and prediction of data.

Sampling Bot Process

Skills Used: Alteryx, UiPath, Web Automation ,Google Drive

• Worked on two internal databases to sample out records based on the requirement.

• Created a sampling workflow on Alteryx based on certain validation.

• Capturing details of those samples from portal using web automation (UiPath)

• Taking screenshot of products where items have some defect or out of stock or not available.

• Uploading the files and report along with screenshot attachment to drive for common use.

• Emailing the dashboard and summary to operation post completion of the process.

• Preparing reports for executive leadership that effectively communicates trends, patterns, and prediction of data

Scheduling and Rescheduling (Conagra)

Skillset: Web Automation, Control Room, VBScript, SQL, XML, Git, Queue

• Downloading Dataset from SAP System from a particular T-Code

• Validating certain conditions and utilizing concept of Workload Management System and Pushing Data to Queue.

• Scheduling the Purchase Order to Customer Portals by web automation.

• Responsible for creating locker, credentials, Queue and Device pool management including assigning roles to users.

• Updating Appointment details to SAP System

• Providing Summary Report for the Actions performed by the bot.

• Creation and configuring of bot using XML config file and error handling.

• Sending Emails according to the requirement and once the process completes.

PR TO PO below Clip (Unilever)

Skills Used: Web Automation, Automation Anywhere, VBScript, SQL ,XML, Git, Restful Webservices , executing .Net Code using DLL’s

Automation anywhere 11.3 using API Token authentication

● Allocation to operations team members by extraction of data from an application based on different countries.

●Reading the extracted through outlook using Metabots

● Validating certain conditions using API call and getting the information in XML.

● Doing VLOOKUP and other excel automation techniques using VB Script to allocate the requests in a round robin.

● Creating Excel sheets and Pivot tables and sending it back to agents their respective tasks on a daily basis.

● Uploading files and Folder creation on daily basis using Metabots (executing .Net Code using DLL’s )

●Approving and rejecting requests with comments and reasons with API.

● Creation and configuring of bot using XML config file and Source Code Management.

●Sending Emails according to the requirement and once the process completes.

● Creating a reusable for the other dependents Process and Regions

FM Invoice Processing ( CEVA)

Skills Used: Email Automation, OCR, Control Room

● Created Attended Bot for automation

● Downloading Email Outlook Attachments from bot configured mail.

● Conversion of PDFs into TIFF format files by python code

● Uploading the Invoice documents to IQ bot Instance.

● Extracting data to excel and populating the data to web portals

● Maintenance of source code and creation of reusable components

● Sending Emails according to the requirement and once the process completes.

HRO Automation (Unilever)

Skills Used: Outlook, SQL, XML, A2019

• Successfully Automated Hiring Process for finding Best Candidate for the Job.
• Shortlisting Employee based on online (web automation) and offline application by reading Outlook Mails
• Matching JD with Resume submitted by applicant using (OCR) to find the best candidate. Checking Employee DB incase applicant re-applied or under cooling period.
• Shortlisting Applicants on the basis of Test scores and Sending Status Application via Email to applicants