Rpa Developer Resume
Tulsa, OK
SUMMARY
- Around 8 years of constructive experience in IT which includes around 3 years of experience with full project development, implementation and deployment using Automation Anywhere and UiPath as Robotic Process Automation (RPA) developer.
- Hands on Experience in end to end automation process as per business requirement which involves feasibility study, designing architecture, development, testing and deployment ofautomation.
- Expert in developing applications using Object Oriented programming concepts.
- Expert in designing the Business process diagrams and process flow charts with RPA tools.
- Identified opportunity to Automate manual tasks using Robotics ProcessAutomation(RPA) technology and established Commercial - wide RPA program to deliver the first software bot in production.
- Experience with different tasks withAutomationAnywherelike PDF Task, Excel Task, loops, Variable Operations and Meta bots.
- Experience in using various types of connectors like Excel, Outlook in automation events and procedures.
- Good experience in testing web services of SOAP and REST.
- Knowledge on disaster recovery, cluster environment and bot analytics.
- Experience in Robotic Process AutomationTools like UiPath and Automation Anywhere to automate web applications, desktop application, maintaining excel using Object Cloning, Image Recognition, PDF integration, OCR etc.
- Working knowledge on UiPath studio concepts like debugging workflow, managing the packages, creating variables, arguments and workflows.
- Worked on UI elements, data scraping, selectors, PDF, image and text automation, mainframe and terminal automations in UiPath studio.
- Familiar with UiPath Components, features and methods of automating the business processes.
- Worked with mainframe, windows, web application andCITRIXautomation end-to-end process automation usingUiPath.
- Have hands-on experience to maintain the several RPA bots as batch processes on daily basis and ensure quality and high performance to the internal and vendor applications of the organization.
- Expert in solving issues that arises in day to day running of robotic processes and providing timely responses and solutions as required.
- Experience with Process SME's to prepare Process Definition Document (PDD) & Solution Design Document (SDD).
- Involved in Process Management, Defining, Designing, Development and Testing.
- Hand-on experience in Robotic ProcessAutomation(RPA) across different platforms and successful implementation in Production environment.
- Experience in Agile, Waterfall Methodologies with clear understanding of Iterative and Evolutionary principles.
TECHNICAL SKILLS
RPA Tools: AutomationAnywhere, UiPath, Kryon
Programming Languages: .Net Framework, C#.Net, VB.NET
Web Technologies: ASP.Net, XML Web Services, ADO.Net, SOAP, REST, HTML, CSS
Databases: SQL Server 2012/2008, Oracle 9i, Informatica
Operating Systems: Windows and Linux
Scripting Markup Languages: HTML, XML, CSS, Python
Business Modeling Tools: MS Visio
Design and Process: Waterfall, Agile Scrum, RPA Methodology
Packages: MS Office (MS Word, MS Excel, PowerPoint)
PROFESSIONAL EXPERIENCE
Confidential, Tulsa, OK
RPA Developer
Responsibilities:
- Working with SME’s to create PDD (Process Definition Document) and developed separate SDD (Solution Design Document).
- Worked on the task migration process from development to production systems through UiPath Orchestrator.
- Automated text in PDF's using screen scraping to calculate the invoices and store them into a data table using UiPath.
- Created process model for windows-based application usingUiPathand testing it in the inbuilt controller provided byUiPath Studio
- Validating the selectors for the click, type, and screenshot activities using UI explorer.
- Scheduling the BOT's through Orchestrator and managed robot's workloads.
- Design workflows in EXCEL APPLICATION SCOPE to automate all the manual tasks in the business which used MS Excel.
- Implemented various logics in the Bot using IF, While, Do While, and For Each loop.
- RPA Log verification for all the process that was run and prepared User guide documentation.
- Making use of customized RE Framework to leverage the state machines to evenly distribute and compartmentalize the workflows to ensure efficiency.
- Used Regular Expressions to scrape specific data from invoices of a company like a customer number, stock price, purchase order details, etc.
- Supported business development activities, responding to the proposals as RPA subject matter expert, by coordinating with key stakeholders in the company.
- Responsible for automating multiple data acquiring, data entry and maintain them which reduced human effort.
- Strong understanding of product capability, structure, protocols, application integration, technology, and deployment-related to Robotic Process Automation.
- Brokedown processes into reusable objects using Object studio and utilized them to build processes in Process Studio efficiently. Made sure every small step is documented to remove ambiguity.
- Working closely with Solution Design team and Subject Matter Experts to integrate the business process to the RPA end solution.
- Supported business and technical teams during robotic projects and mitigate/Resolve risks and issues that may impact project schedule, cost, scope, quality, etc.
- Designing and developing multiple workflows to automate multiple business processes and web applications and desktop applications using standard UiPath workflow principles.
Environment: UiPath, C#, VB.Net, JavaScript, Html, Oracle, SAP, SQL Server, MS Office, JIRA, Confluence.
Confidential, Mount Laurel, NJ
RPA Developer
Responsibilities:
- Well versed with UiPath Studio, UiPath Robots and UiPath Orchestrator.
- Used UiPath Orchestrator for deployment, monitoring, and management of UiPath bots' automation activity.
- Involved in fixing Business Process Production issues using UiPath.
- Worked on task migration process from development to production systems through UiPath Orchestrator.
- Experience in staging and deploying the automation solution into test and live environments.
- Implemented UiPath features such as Optical character recognition (OCR), Image Recognition,
- Text Analysis, Citrix Screen Scrapping for remote machines, PDF processing, Excel integration, Email automation etc.
- Automated text in PDF's using screen scraping to calculate the invoices and store them into a data table using UiPath.
- Designing E-mail automation through SMTP, POP3, Exchange, IMAP and outlook techniques according to the requirements.
- Accessing data from multiple file formats like .CSV, .PDF, excel sheets, web pages etc., using multiple scraping techniques like full text, Native and OCR.
- Developed and configuredautomationprocesses as per the technical design document (TDD) to meet the defined requirements.
- Involved in the designing solutions utilizing RPA (Robotic ProcessAutomation) software, maintain technical responsibility for project delivery as the technical resource on a project.
- Created Functional Requirements Documents (FRDs) for a Robotic ProcessAutomationproject, based on business process design discussions with business stakeholders.
- Involved in all phases of Software Development Life Cycle including design, development and creating test cases.
- Generated custom reports of Task Run, Task Timeline, Workflow Run, Workflow Timeline, ROI and Visual Logs reports using Report designer activity.
- Used Controller in Queue management to handle the Exceptions both System and process giving insight of the automated process.
- Maintain and configured several RPA bots as batch processes on daily basis and ensure quality and high performance to the internal and vendor applications of the organization
- Formulated and executed agile processes for enhancing performance.
- Experience in staging and deploying theAutomationsolution into test and live environments.
- Experience of using UiPath. (core, credential, database, excel, ftp, mail, web, pdf). activities.
Environment: UiPath Studio, UiPath robots, UiPath orchestrator, Web Services, MS SQL Server 2008, Xml, Windows 20007/2010.
Confidential, Princeton, NJ
RPA Developer
Responsibilities:
- Implemented End to EndRobotic Process Automation(RPA) usingUiPath.
- UsedUiPath automationelements such asMouse,KeyboardandAttributeto automate thedesktop sequence activities.
- Implementedselectorsfor interacting withwindowandweb browsersfor continuous navigation of applications.
- Image-basedtexts in applications are also automated withmouse clicks.
- UsedScreen Scrapingmethod toextract textfromrunning windowapplication by appropriate output methods such asnative, Full textandOCR.
- ImplementedWeb Recorderforautomating loggingandinserting dataactions into browser applications using differentInput methodssuch asSend window messages andSimulate.
- Configuring new processes and activities using core workflow principles that are efficient, well-structured, and manageable.
- UsedData Scrapingmethod forextracting structureddata frombrowser applicationsor documents into aCSV fileor Excel Spread sheet.
- Usedimage activitieswithwait conditionsto ensure proper website orapplication loading, to perform certain actions in a loop.
- UsedExcel automationfor repetitiveExcel data entry, appending and for comparing columns.
- Interacted with different mail services such asPOP3, OUTLOOKandIMAPto get the mail messages into folder.
- Interacted with the different send services of mail tosend automatic mailsandaudit logsregarding the task completion.
- HandledexceptionsusingTry-Catchactivity.
- Image based,andText automationare used inVirtual Environments, for interacting with the application
- Handled theExecutionof project inUiPath Robot.
- Deployedthe process inUiPath Orchestratorandscheduledtheir execution.
- UsedQueuesto collect information fromorchestratorto perform additional tasks.
- Configured the Bots and deploying processes and scheduled the jobs inUiPath Orchestrator.
- Participated with test teams during theProduct testandUAT phasesto fix assigned bugs.
Environment: UiPath, C#, VB.Net, JavaScript, Html, Oracle, SAP, SQL Server, MS Office.
Confidential
SQL Developer
Responsibilities:
- Involved in documenting user requirements, technical specifications and Reporting manuals.
- Involved in PL/SQL code review and modification for the development of new requirements.
- Developing functional, technical documents, advanced coding and bug fixation.
- Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing.
- Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Created indexes on the tables for faster retrieval of the data to enhance database performance.
- Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Partitioned the fact tables and materialized views to enhance the performance.
- Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Implemented using Forms, Reports, PL/SQL, Flex fields and Workflow.
- Customized, created, and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL.
- Analyzed, designed, and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
Environment: Oracle 10g/11g SQL, PL/SQL, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.
Confidential
SQL Developer
Responsibilities:
- Extracted data from Oracle, SFDC and Flat files and loaded data into Oracle Data warehouse
- Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate daily weekly and monthly loading of Data
- Used Informatica features to implement Type I, II changes in slowly changing dimension tables
- Participated in reconciling data drawn from multiple systems across the company like Oracle, flat files into Oracle data warehouse
- Generated Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
- Developed reusable transformations to load data from various data sources to the DW.
- Designed the procedures for getting data from all systems, like IMS to Data Warehousing system. The data was standardized to store various Business Units in tables.
- Worked closely with Business Analysts to Design & Develop SQL Statements, Data Conversions, and Data Cleansing, Data Quality Analysis to determine cleansing requirements.
- Used Oracle, Sql server, DB2 and Flat Files as sources and Sql server 2005 as target.
- Coding and Debugging, Sorting out their time-to-time technical problems.
- Written simple and complex SQL-overrides in source qualifier as well as look-up transformations according to the Business Requirements.
- Developed Informatica mappings and tuned them for Better Performance and validate the data.
- Involved in Batch processing & Scheduling Informatica jobs on weekly/monthly basis using Maestro.
Environment: Informatica Power Center, Toad, SQL Server 2005, Oracle 9i/10g, UNIX, Shell Scripts, SQL.