PROFESSIONAL SUMMARY:

I have 10 + years of experience and 5 years of experience in Digital Process Automation which includes Business Process Management (BPM) and Robotics Process Automation (RPA). In my career I have worked on end - to-end project life cycles starting from requirements gathering to implementation, and to finally project roll out. My scope of work includes project management of Process Automation of Legacy Applications, OCR Integration, Image Processing, User Activity Replication, BPM Integration, Orchestrated Automation, and Webservice integration though APIs etc.

EXPERIENCE:

Confidential

Responsibilities:

• Created bots to interact with office 365 and read emails.
• Save the mail message and convert mail messages to pdf and combine with email attached global letter.
• Save the final pdf file with proper naming convention and reduce the file size by using pdf optimizer.
• Copy the file Confidential HUB location for EMDS push.

Confidential

Responsibilities:

• Created bots to download documents from secure SFTP servers.
• Automated bot to upload documents into Hub Loader and clear the old document from the SFTP server.
• Created CIT events for each document uploaded to HUB Loader.

Confidential

Responsibilities:

• Created bot to download documents from EDMS system.
• Removed duplicate copy inside the document
• Uploaded documents to S3 bucket for data extraction
• Downloaded .csv files from the S3 bucket and deconstructed the data.
• Updated the audit table by using a REST API call.

Confidential

Responsibilities:

• Created bot to download documents from EDMS system.
• Identify the legal description page from the legal document and extracted as a page.
• Remove the footer from the image by using python script.
• Extracted the legal description from the document.
• Trigger the exception process based on confidence level.
• Uploaded exception documents to S3 bucket for exception process UI to make the correction.
• Updated the audit table and data extraction table by using a REST API call.
• Upload the legal description into Sagent application by running Sagent script.

Confidential

Responsibilities:

• Created bots to download documents from the Amazon S3 bucket.
• Calculated the size of the PDF file package.
• If the file size is greater than the threshold limit, then reduced the size by using PDF optimizer and GhostScript.
• Uploaded the document to the EDMS application.

Confidential

Responsibilities:

• Created bots to download documents from the EDMS system.
• Removed the document noise by running the Python Script.
• Extracted the Late fee percentage from the Document along with the minimum and maximum charge
• Updated the Lakewood application by using the REST API call.

Confidential

Business /Data Analyst

Responsibilities:

• Read and processed emails received by the mitigation inbox.
• Validated the email addresses against tracker sheets. Based on results, divided emails between successful paths or exception paths.
• Filtered emails based on requirements and processed them by downloading all required attachments and uploaded them into the appropriate hub loader locations.
• Prepared an appropriate dashboard to provide the business with insight about each email status.

Confidential

Responsibilities:

• The primary objective of this project is to eliminate the manual effort of downloading the title report from the EDMS system for a loan and extracted the commitment number or order number field from PDF and enter the value into the Lakewood application.
• Downloaded reports from the EMDS system and Extracted the value from unstructured PDF by using intelligent OCR.
• Enter the extracted value into Lakewood Application.

Confidential

Responsibilities:

• The primary objective of this project is to automate the manual effort to update the closing trustee information into the old legacy application “Lakewood”.
• Extracted title information and update under trustee information into Lakewood application for each loan number base on the US state.

Confidential

Business /Data Analyst

Responsibilities:

• The primary objective of this project is to automate the manual process involved in downloading Freddie Mac, Fannie, and Ginnie reports and process them and send reports to the end-user.
• Developed process to download new reports uploaded Confidential Freddie Mac, Ginnie, and Finnie Mae portals and send it to the end user.

Confidential

Responsibilities:

• Address validation
• Intent to Proceed Date validation
• Update HOI Fee
• Update closing trustee info
• Responsibilities as RPA developer:
• Developed Intend to proceed date validation, Update hoi fee, and update closing trustee info.
• Reviewed requirements and checked feasible ways to implement use cases using different functionalities of UI Path.
• Implemented end to end mainframe system navigation of the process with error handling and retry mechanism.

Confidential

Responsibilities:

• RPA process logged in into the IBM BPM portal to extract all the loans and reset the status of each loan one by one.
• Study requirements and check feasible ways to implement use case using different functionalities of UI Path
• Implement end to end application navigation of the process by using robotic reframe work with error handling and retry mechanism.
• Extracted data table of loan and change the loan status.

Confidential

Responsibilities:

• Created a data mapping business process diagram by using Bizagi Modeler.
• Performed requirements analysis and documented the business requirement.
• Gathered reporting requirements and created RRZ’s reports related to Exception, Demand deposit, Commercial Lending.
• Accurately mapped Data elements of more than 600 reports for development handover in the Excel sheet.
• Created Pivot tables for reports mapping documents to find inconsistencies in the data.
• Performed data validation from TCS BaNCS to the Operational Database store (ODS).
• Performed Screen Scraping for 55 plus Data Migration Documents which were related to deposit and commercial lending.
• Created BDS documents, process flow diagrams and worked with Uipath developers team.

Confidential

Responsibilities:

• Gathered and analyzed business requirements and wrote the Business Rules Document.
• Performed data analysis for the existing system and identified changes for the internal schema for performance.
• Performed data mapping from source to target.
• Participated in Design walk-through with SMEs to baseline the business architecture.
• Worked closely with the QA team and developers to clarify/understand issues. Resolved and provided feedback to identify and close the bugs.
• Worked with the project team to ensure that logical and physical data models were developed in line with key standards and guidelines.
• Defined the key identifiers for each mapping/interface.
• Documented all data mapping and transformation processes in the Functional Design documents based on the requirements
• Created Technical Specification documents based on the Functional Design document.

Confidential

Responsibilities:

• Responsible for analyticdataneeds of the business unit. Handle complexdataprojects and act as a lead for otherDataAnalysts.
• Provided advanced analytical support for business operations in all or some of the following areas: claims, providerdata, member data, clinicaldata, HEDIS, pharmacy, external reporting.
• Extracted, loaded, modeled, and reconciled large amounts ofdataacross multiple system platforms and sources
• Revieweddatato determine operational impacts and needed actions; elevated issues, trends, areas for improvement and opportunities to management.
• Developed reports and deliverables and made recommendations to management.
• Modeleddatausing MS Excel, Access, SQL, and/or otherdatawarehouse analytical tools.
• Assisted management in driving business decisions based ondata
• Ensured compliance with federal and state deliverable reporting requirements by performingdataquality audits and analysis.
• Assisted with training and mentoring otherDataAnalysts.
• Assisted with determining workload and related activities for otherDataAnalysts

Confidential

Responsibilities:

• Support and utilize databases developed for data analytics to optimize data quality and analysis (Fleet Tracker, Ops Tracker, Training Tracker, FUZE).
• Acquire data from primary or secondary data sources and maintain databases/data systems (Fleet Tracker, Ops Tracker, Training Tracker, FUZE)
• Identify, analyze, and interpret trends or patterns in complex data sets (MOM, Quarterly, YOY trends)
• Filter and “clean” data by reviewing reports and performance indicators to locate and correct problems
• Work with management to prioritize business and information needs
• Visually translate analyzed date into executive style PowerPoint presentations (quarterly Fleet report/review, monthly Director Calls and KPI reporting, weekly Training Status Updates