SUMMARY

• 6 years of overall experience in IT involving in all phases of software Development Life Cycle in different projects.
• 3+ years’ experience in Robotics Process Automation (RPA), automated 80+ business processes into 35 bots serving multiple business domains using one of the top RPA products - Blue Prism, Ui Path.
• 2+ years’ experience in driving Digital and Automation solutions in Oil & Gas E&P organization.
• Strong knowledge in architecting or deploying Cloud/Virtualization solutions. Expert on Agile methodologies (Scrum), CI/CD, DevOps.
• Technologies and capabilities delivered include Digital technologies and Cloud.
• Experience in Automation tools Ui path, Blue Prism and Automation Anywhere.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with process owners, stake holders, and designing, Coding, Testing, Debugging, Documentation and Implementation of Business Process Solutions.
• Good experience of working as SME in collaborating, and influencing stakeholders to promote simplification, standardization, and innovation and to ensure risk estimated and minimization.
• Good understanding of Process Automation Life Cycle and developing technical documentation in various stages of the Process.
• Designing and implementation of RPA tasks using Blue Prism framework (Connectors, VBO, Process Studio, Control Room, and System Manager) to update the Provider directory from excel, website data through screen scraping and using OCR (Optical Character Recognition) from printed material.
• Designing and implementation of RPA tasks in Blue Prism with control room, OCR. Responsible in web interfaces, excel and database interfacing.
• Implemented best practices in deploying the designs.
• Skilled in inspecting the bot performance, debugging.
• RPA tool configuration (Blue Prism, Ui Path) in developing and evaluation environments.
• Experienced in using Ui Path Studio, Orchestrator, Screen, Data & Web scraping techniques.
• Worked closely with solution architect to prepare Process Definition Document (PDD) and Solution Design Document (SDD) and educated SME's to work with Meta bots and IQ bots in production
• Knowledge in automating the SAP process with Ui Path. Automating process of start/close a case, content migrating, comparing data fields on screen, keying or screen scraping data on screen.
• Knowledge in designing the automation models for Natural Language Processing (NLP) with Cognitive Automation tools, and Work Fusion AI, Classification and Pattern Recognition, Deep Learning Cognitive Computing etc.,
• Creative in automating Web and Windows applications using various Spying modes (Html, Win 32, AA modes).
• Strong working knowledge of Business Process Model and Notation (BPMN) and Decision Modeling Notation (DMN).
• Mastered in setup, installations and configuring with servers to the systems.
• Experienced in SDLC life cycle for Design, Development, and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Strong experience in all phases of Software Development Life Cycle with Analysis, Design, Development, implementation, Integration, Testing, Debugging, Production and Maintenance.
• Vibrant in conducting problem/risk analysis and root cause analysis (RCA).
• Good knowledge in analyzing cause-effect process and identifies the changes needed for systems.
• Excellent communication, leadership, and interpersonal skills with proven abilities in resolving complex software/ application related issues.
• ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL process.
• Extracting data from Oracle, DB2, CSV and Flat files.
• Exposure to Blue Prism, Single Sign-on implementation using Microsoft Active Directory.
• Ability to work independently and to manage several assignments simultaneously to meet deadlines without supervision.

TECHNICAL SKILLS

RPA Technologies: Blue Prism 5.0, UI Path 2016.2, Power Automate, SAP iRPA

Microsoft Technologies: ASP.NET 4.0/4.5, C# .NET, WinForms, ADO.NET, ASP.NET MVC 5, API, XML

Web Development: HTML5, CSS3, JavaScript, AJAX, jQuery, AngularJS, Bootstrap

Programming Languages: C#, C, Python, SAS, R, SQL queries

Databases/ reporting services: MS SQL Server (2012, 2008, 2005), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Tools: Visual Studio, SQL Server Management Studio, UI Path, SAS Studio, R Studio

SDLC Methodologies: Agile Scrum, Water Fall

Microsoft Packages: MS Excel, MS Visio, MS Share point.

PROFESSIONAL EXPERIENCE

Confidential - The Woodlands, TX

Sr. RPA /Digital Strategy Engineer

Responsibilities:

• Reviewing current systems and presenting upgrade design models for system improvements including cost proposals to ensure strong functionality and optimization.
• Creating system architectures and planning the software designs, developing documentation, flowcharts, layouts, diagrams, and programming to fulfill the organization needs.
• Integrating and setting connections between different systems and servers. Responsible in setup, installing and configuring software packages on servers and systems - SQL server, BP App Server to Virtual Machines/ Compute Engines.
• Integrating the complex and secured connections by enabling the WCF: SOAP with transport encryptions between the Application Server, Database, Cloud Services, and Virtual Machines (Windows, Linux Servers, Google Cloud, AWS, Computational Clusters, Kubernetes Engine).
• Implemented top class enterprise CoE and Governance.
• Strong experience in all phases of Software Development Life Cycle with Analysis, Design, Development, implementation, Integration, Testing, Debugging, Production deployment and Maintenance.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with process owners, stake holders, and designing, Coding, Testing, Debugging, Documentation and Implementation of Business Process Solutions.
• Designing and implementation of RPA tasks in Blue Prism with control room, OCR. Responsible in web interfaces, excel and database interfacing. Implemented best practices in deploying the designs.
• Skilled in inspecting the bot performance, debugging. Customizing the workflow using C# scripts or VB Code.
• By using Scheduler, scheduling a Bot to run 24/7 in the Control room.
• Designing and implementation of RPA tasks using Blue Prism framework (Connectors, VBO, Process Studio, Control Room, and System Manager) to update the Provider directory from excel, website data through screen scraping and using OCR (Optical Character Recognition) from printed material.
• Creating complex system architectures and implementing the software designs developed with deployment best practices.
• Developing the process automation software designs/scripts to automate the tedious back-end manual tasks. Modifying existing software for to correct errors, or to improve performance (Blue Prism or UiPath tools).
• Develop the software programs for the task handling and task failure back up (restoration) plans.
• Develop the software programs and algorithms to schedule the developed process automations.
• Design and Implementation of Robotic Process Automation tasks using Blue Prism framework (Connectors, VBO, Process Studio, Control room, and System manager).
• By using Scheduler, we will schedule a Bot to run 24/7 in the Control room.
• Hands on experience in managing robot's workloads using Blue Prism Work Queues.
• Interacting with windows application and created object and interacted all the objects in process studio and created work queues and running processes.
• Problem solving issues that arise in day to day running of Blue Prism processes and providing timely responses and solutions as required.
• Developing the SQL queries to update and refresh the database (TOAD Data Point).
• Developing/ modifying the existing software to adapt the new hardware systems.
• Scheduling and resource - planning software algorithms should be designed upon demand to provide the better task handling/ completion (Python, Jupyter notebook, SAS programs).
• Ensuring high availability and acceptable levels of performance for task critical host virtual machines and compute engines.
• Develop test programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or re-usability.
• Creating the centralized infrastructure for maintaining several bots across the industry.
• Setting up the bots in the control room, with the virtual machines/compute engines available.
• Troubleshooting and debug handling with Robots and Application Servers. Resource Management and Maintenance (Windows updates and Patches, Complex software installation, Network security compliances).
• Responsible in inspecting the bot performance, enhancing the bots performance, tools configurations in developing and evaluating the environments.
• Dealing with designing the Natural Language Processing automation models using the Cognitive RPA tools and Methodologies.
• Used process, objects, work queues while developing/performing logical operations in Blue Prism Software.
• Responsible for scheduling processes, using the bots to run anytime in the control room. Capable of handling in scheduling the heavy workloads.
• Creating the database connections to fetch the data from the SQL server/ Linux Server/ Cloud.
• Usage of various actions: Conditions and Loops, User prompts, OCR, Object cloning/ inheriting, Key strokes for coding the automation process.
• Supervising the operations team, upgrade the network infrastructures, and install servers, devices and firewalls.
• Identifying and debugging the errors using Error Handlers, Error log files, screen shots.
• Proactively designing the RPA tasks as per application and business requirements, enhancing it with the bot framework.
• Assigning and maintaining the Identity Access Management roles for the users across the project or organization using the compute engine resources.
• Create and execute the detailed test steps and procedures to manually validate system functionality, integration and conversion.
• Executing the agile methods to enhance performance. Staging and deploying the automated task software into test and live environments.
• Implemented single click or automated builds and release (CI/CD), Configuration Management (Git, SVN), Docker and Container management.
• Developing procedures, programs and documentation for backup and restoration of server, and automated tasks.
• Relatively working on existing SAS code, queries to maintain, and define strategies to improve the efficacy of SAS programs.
• Vibrant in conducting problem/risk analysis and root cause analysis (RCA).
• Good knowledge in analyzing cause-effect process and identifies the changes needed for systems.
• Excellent communication, leadership, and interpersonal skills with proven abilities in resolving complex software/ application related issues.
• Handled bot orchestration using Appian.
• Worked closely with business and process owners to prepare Process Definition Document (PDD) and Solution Design Document (SDD) and educated SME's to work with virtual assistants or other workflows than automation.
• Review software documentation to ensure technical accuracy, compliance.
• Exposure to Blue Prism, Single Sign-on implementation using Microsoft Active Directory.
• Create UAT test cases and to work in proximity with the business team during UAT phase.
• Deliver seamless communication & collaboration between people, process and technology.
• Implemented Key Strategies in migrating hardware maintenance applications to cloud infrastructure.
• Improving Observability, Reliability, Scalability and Supportability by executing business process using cloud serverless - Cloud Functions.

Environment : Blue Prism v5.0, Ui Path 2017, .net, SQL server 2012, Windows excel, Agile Scrum, HTML, CSS, SAS Software, PDF Converter, OCR, MS-Excel, GCP, Microsoft Azure, Dynatrace, CI/CD, Appian.

Confidential - San Antonio, TX

RPA Developer

Responsibilities:

• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with process owners, stake holders, and designing, Coding, Testing, Debugging, Documentation, and Implementation of Business Process Solutions.
• We recognized 36 processes to automate. Developed, deployed these processes into 10 bots.
• Achievements lead to 98% accuracy with expected ROI .
• As a Lead, Responsible for providing Techno-functional solution to Automate business and played as Lead initiative to standardize the Requirements gathering Process.
• Performed tool evaluation and feasibility to help in selecting suitable Automation tool for RPA implementation ( POC - Proof of Concept ).
• Well versed with the Blue Prism (Process Studio, Object Studio) as well BP Control and Release Mgt.
• Hands on experience in building and developing different types of Applications ( Browser, Windows, Citrix ) by using Blue Prism Tool.
• Using Excel VBO object to perform operations in excel sheet while taking excel sheet data as input.
• Used process, objects, work queues, calculations stages to perform logical operations in Blue Prism.
• By using Scheduler , we will schedule a Bot to run 24/7 in the Control room .
• Hands on experience in managing robot's workloads using Blue Prism Work Queues .
• Interacting with windows application and created object and interacted all the objects in process studio and created work queues and running processes.
• Problem solving issues that arise in day to day running of Blue Prism processes and providing timely responses and solutions as required.
• Experienced in using Ui Path Studio, Orchestrator, Screen, Data & Web scraping techniques.
• Charge Amount Capture: Automated process for charge checks and submittal of error-free claims and cash posting. Used one of the Screen Scraping methods i.e. Optical character recognition (OCR) ( Google OCR / Microsoft OCR engines ) to process JPEG images.
• Used various actions like Conditions and Loops, User prompts, Error Logging and commands like Object Cloning, OCR , Key Strokes etc, for coding the automation process.
• Working within project planning constraints, communicating any identified project risks and issues to the delivery/project manager accordingly and providing inputs to the change control process.
• Created database connections to fetch the data and automated the process to arrange data (Configure with servers).
• Proficient in installing , configuring , and activating Blue prism and Ui Path tools. Expertise in deploying and maintaining virtual machines .
• Creating solution on process automation for different Business Applications (Windows based, Browser based, and Surface Automation).
• Participated online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients.
• Worked on Integrating applications like (Web Services, MS Office, GUI, Outlook etc.) using workflow, automation tools ( Blue Prism ).
• Creating and documenting test procedures and scenarios for Pre-UAT phases supporting the operational teams during UAT and rollout phases.
• Analyzing the user stories and breaking up the user stories into sub-task with estimation.

Environment : Blue Prism v5.0, Ui Path 2016.2, .net, SQL server 2012, Windows excel, Agile Scrum, HTML, CSS, SAS Software, PDF Converter, OCR, MS-Excel.

Confidential

SQL Developer

Responsibilities:

• Worked closely with client to understand the business requirements, data analysis and identify final deliverables
• Designed packages and data mappings to load data from data source to destinations by SSIS
• Extensive work in SSRS, SSIS, MS SQL Server, SQL Programming and MS Access
• Created database objects like Tables, Stored Procedure, Functions, and Triggers etc.
• Created complex Stored Procedures using Linked Server, CTE, Temp Table, SQL Joins etc.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with SQL Server 2008/2012/2014
• Migrated requirements which exists on various tools into TFS work-items by mapping requirement field into TFS work-items
• Performed Data reconciliation and error handling after Extracting data into SQL Server
• Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008/2012/2014
• Expertise in Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load/Full load.
• Extensive knowledge in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL processes
• Developed custom data retrieval process from remote ETL site using SSIS 2008 R2
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Developed Tableau workbooks from multiple data source using data Blending
• Created materialized views in Oracle to migrate data from Oracle to SQL Server using SSIS
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS)
• Extensively designed the packages and data mapping using Control flow task, Sequence Container, For Each Loop, Sequence Container, Data flow Task, Execute SQL Task, File System Task and Script Task in SSIS Designer
• Built SSIS packages, to fetch file from remote location like FTP and SFTP, decrypt it, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Extensive use of Expressions, Variables, Row Count in SSIS packages.
• Data validation and cleansing of staged input records was performed before loading into Data Warehouse
• Developed email automation job.

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TSQL, Windows XP, Microsoft Office, Microsoft Outlook, Visual Source Safe, Quality Center, Team foundation server