Home

Lakshmi Durga Kathi - RPA Developer

[email protected]

Location: Palacios, Texas, USA

Relocation: yes

Visa: H1B

Name: Lakshmi Durga Kathi Email: [email protected] Ph no: +1(469)-634-1109 RPA Developer Professional Summary: An enthusiastic RPA professional with around 8+ years of IT experience including 5 Years of RPA Process implementation using UiPath, Blue Prism & Automation Anywhere and involved in COE (Centre of Excellence) & developing software bots. Extensively worked on Waterfall model, Agile/Scrum software development methodologies for requirement analysis, definition, prototyping, proof of concept, designing, coding, testing and implementation. Skilled at evaluating options, generating solutions and well-organized with good time-management skill to complete project on time. Hands-on experience in automating interfaces like Web, desktop, SAP. Proficient in all phases of SDLC such as Analysis, Design, Development, Integration, Implementation and Maintenance Designed, Developed and tested Bot tasks using RPA UiPath. Experience in staging and deploying the automation solution into test and live environments. Used UiPath Orchestrator for deployment, monitoring and management of UiPath Robot automation activity. Expertise in automating the process involving PowerApps, SharePoint online, azure. Expertise in automating the processes using Microsoft 365 activities and azure Devops activities. Efficiently handled monitoring and troubleshooting the studio environment through Orchestrator. Communicating with Blue Prism on software related issues, suggested improvements and participating with other users in the Blue Prism community. Experience in Automation tools UiPath, Blue Prism. Designing and implementation of RPA tasks using Blue Prism framework (Connectors, VBO, ACI, 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. Worked closely with solution architect to prepare Process Definition Document (PDD) and Solution Design Document (SDD) and educated SME's to work with BOTS in production. Strong knowledge and experience in .Net framework, C#.NET, VB.NET, ASP.NET, ADO.NET, MVC, HTML5, Bootstrap, JavaScript, JQuery, AngularJS, XML, Entity Framework, Visual Studio, IIS, Ajax. Extensive experience in writing complex stored Procedures, Triggers, Functions, Views, Indexes and Joins on SQL Server and Oracle. Reviewed & fixed Business Process Production issues using Automation Anywhere. Good understanding of Process Design documents, Technical Design documents and noledge of various automation components and features available in Automation Anywhere. Automated numerous routine tasks using Automation Anywhere theirby reducing manual intervention. Ability to understand the business requirement documents (BRD) and to automate accordingly Hands - on experience in software delivery lifecycle on RPA projects like process mapping, business requirement, functional and technical specification, coding, design test script, test plan. Utilized Automation Anywhere (AA) to use prebuilt functions, yet also allowed the creative freedom to in corporate specific scripts and code for a more personalized and accurate solution Proficiency in the implementation of Web applications, Windows Applications using .NET Framework Class Libraries Ability to code and In VBScript. Experience on Outlook, MS Excel, MS Access as a database Performed the role of system manager to audit logs and perform management tasks, monitor resource allocations in UiPath. Working with stakeholders and building PDD and SDD documents Strong noledge and experience in C#.Net, VB.NET, ASP.Net MVC, WCF, SQL Server, RPA Automated numerous routine tasks using UiPath, Blue Prism theirby reducing manual intervention. Experience in Robotics Process Automation Development with tool AUTOBOT, Automation Anywhere Blue Prism and UIPATH. Experienced in analyzing & Robotics automation development and also be a part of requirement gathering team in facilitating improvement in applications, planning and building effective environments. Highly skilled in RPA - Automation development with the tool AUTOBOT & UIPATH. Requirements Capture, Executing unit test with developed workflow Comprehensive exposure in project delivery management and the Development Life Cycle including design of the workflow Plans. Created POC's using Blue Prism and UiPath using tool comparison. Excellent communication, leadership and interpersonal skills with proven abilities in resolving complex software/ application related issues. Experience working on Waterfall and Agile Methodologies - Scrum. The delivery of projects for identified process improvements using RPA methodologies. Proactively identify scope and prepare business cases for opportunities to improve processes in conjunction with process owners/ managers. Working on Queue Configurations, Monitoring, Internal Blue Prism Work Queue Actions, Exception handling, efficient use of stages, blocks, data types, session and environmental variables for processing of Business Process diagrams and Process flow charts using RPA tools. Implemented Blue Prism User authentication by defining user roles, creating users and setting password policies. Comprehensive exposure in project delivery management and the Development Life Cycle including design of the workflow Plans. Prepared reports like Defect Statistics and Tracking for Weekly and daily status reports. Involved in managing the robot s workloads using Automation Anywhere Work Queues and to identifying and debugging the errors using Error Handlers. Knowledge on UiPath studio concepts like debugging a workflow, managing the packages, creating variables, Arguments, control flows. Experience with T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Highly Proficient in working with databases like SQL Server, MySQL Good experience in working on SOAP, REST Web services. Created Tableau Scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using Show me functionality. Good understanding of Machine learning algorithms like Logistic Regression, Linear Regression, KNN algorithm/Kmeans clustering, Decision Trees. Good knowledge of data base language like MySQL, SQL Server. Hands-on experience in Tableau & Python with knowledge of various libraries like NumPy, Pandas, Seaborn, Matplotlib, Scikit-learn with proven abilities in the Software Development Life Cycle (SDLC). Experienced in working with AA connectivity to Azure Blob Storage, Azure Scope Activities, Custom Activities, File Uploads/Downloads Experienced with modern activities and created custom activities in UiPath modules. Experience in Agile, Waterfall Methodologies with clear understanding of Iterative and Evolutionary principles. Strong experience in all phases of Software development Life Cycle with Analysis, Design, Development, implementation, Integration, Testing, Debugging, Production and Maintenance. Extensive experience in writing complex Stored Procedures, Triggers, Functions, Views, Indexes and Joins on SQL Server, MySQL and Oracle. Ability to work independently and to manage several assignments simultaneously to meet deadlines. Skill Set: RPA Tools: Blue Prism 5.0/6.2, UIPATH Programming Scripting Languages: Python 3.0(Jupyter Notebook), HTML5, CSS3, JavaScript, Jquery, Bootstrap, JavaScript, Angular JS, JSON, AJAX Reporting Tools : Tableau, ETL, Power BI, Microsoft excel (Pivot tables), vlookups, UiPath Insights XML Technologies: XML, SOAP, Web Services, SDLC, Agile, Scrum Methodologies, Waterfall Design and Development Tools: Eclipse, MS Visio and MS Testing Tools Version control tools: SVN, GIT, Source Tree Database Systems: SQL Server, MYSQL, Hive, Spark Platforms: Linux, Windows Certifications: - Certified Blue prism developer - AD01 Certified UiPath Associative Developer Professional Experience: Client: Speridian Technologies. Role: Robotic Process Automation Developer July 2023- Present Responsibilities: Working with 4 different end clients with different projects. Working in the team with RPA practice leader and the other Senior RPA Developer. Lead Initiative to build reusable assets and artifacts that can be leveraged across the other projects. Advanced certified UiPath developer track record that includes the design and release of high quality, high performance, and enterprise level software products/applications as a single RPA Developer. Worked with client members for requirement gathering, understanding processes. Assisting Development and support teams in resolving technical problems. Working with document understanding projects for numerous pdf forms Involved in identifying the opportunities to automate manual tasks using Robotics Process Automation (RPA) technology, and established Commercial-wide RPA program to deliver the first software bot in production. Technology research and tool selection (Automation Anywhere, Blue Prism, Work fusion, UiPath and others) Creating solution on process automation for different Business Applications (Windows based, Browser based, Java and Mainframe) Ensures reusable components are designed & developed where applicable. Configuring new Blue Prism processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand for further requirements. Feasibility study for RPA implementation by developing Proof of Concept (POC) and validating it with Proof of Value (POV) Involved in End to End development of Business Process using Robotic Process Automation. 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. Creating and maintaining solution documentation. Analyzing, understanding and documenting the business processes in detail where required. Developed and configured automation processes as per the technical design document (TDD) to meet the defined requirements. Involved in using all the mail activities with UI Path. Developed new processes/tasks/objects using core workflow principles that are efficient, well structured, maintainable and easy to understand. Identifying and communicating the technical infrastructure requirements. Supporting existing processes and implementing change requirements as part of a structured change control process. Designing & configuring automation (Automation Anywhere) process solutions. Supporting existing processes and implementing change requirements as part of a structured change control process. Automated the web documentum process using Automation Anywhere. Problem solving issues that arise in day to day running of automation processes and providing timely responses and solutions as required. Capture and reuse automated processes in a central repository. Working with QA to create and document test procedures and scenarios for the pre-UAT phases. Developed RPA's (i.e., Robotic Process Automation) to automate the Mainframe process using Terminal Emulator. Used Oracle and DB2 connections to retrieve data from DB using RPA Automation Anywhere Performed Quality and Analysis based on Quality Management System Manual and prepared quality check reports. Actively participating in test plan presentation, validating the client requirement and identifying the various scenarios for automation development. Handled all production issues with UiPath Orchestrator Automating data transfers, including importing/exporting data between applications or files. Implemented Automation Anywhere Studio User authentication by defining user roles, creating users and setting password policies. Identifying and debugging the errors using Error Handlers. Exposure to Automation Anywhere commands likes Excel, File management to take data from Excel file. Used Web Control Room for deployment, monitoring, and management of Automation Anywhere Robots automation activity. Experienced in using Send Email activity to Email reports and errors. Experience in arranging and sending the computerization arrangement into test and live situations. Created reusable automation framework with Meta Bots and reusable libraries with data externalization for RPA implementation. Expertise in working with application of RPA business processes at the enterprise level. Demonstrate work experience in using different activities in UI Path, mainly on Database, web and windows Applications, Excel, PDF etc. Experience in creating dashboards and reports using UiPath insights. Interacting more with the clients and gather business requirements. Responsible for code reviews, tracking defects, testing and end to end deployments. Integrated applications through Rest API s. Maintained Source code on GIT repositories. Efficiently followed best practices in the projects such as naming conventions Exception handling, log messages, assets etc. Hands on RPA Excel sheet options and String Operations. Environment: UiPath 2022.10.4, Rest API Services, SQL server, UiPath Insights, AI techniques such as machine learning, OCR techniques, Document Understanding, Action Center, GIT Hub, Email, Vizio Client: Merck sharp &Dohme corp., NJ Role: Sr.Robotic Process Automation Developer May 2022- June 2023 Responsibilities: - Proficient in all phases of SDLC such as analysis, design, Development, Integration, Implementation and Maintenance. Strong user Interface development experience using JAVASCRIPT, HTML, CSS, SWING API and ASP .NET FRAMEWORK. Good Understanding of SQL and Experience working with database, oracle, SQL Server and MYSQL. Hands-on experience with UiPath: Building bots, pushing to production, full software development lifecycle. Experience working with AWS and Python or machine learning (Python, Sage maker, Dataiku) Functional understanding and/or experience deploying/interacting with bots utilizing SAP. Strong interpersonal skills, both written and verbal. Identified and logged defects in Azure Devops VSTS and interacted with developers to priorities the issues. Created dashboards in VSTS for CI/CD pipelines, Work items and bugs. Making Solution Design Documents. Developing processes using UiPath Robotics automation tool. Impact analysis of different Project work request on UiPath processes. Extracted data from Web applications, Windows Applications, PDF, Images and Web pages and exported the output data to Database using database commands. Solid design, coding, testing and maintaining the RPA's (Robot's). Used Run Script command to run VB Scripts and Java Scripts by passing parameters at run time and specifying the return value. Responsible for the successful implementation and sustainment of the RPA Program. Developed PowerShell scripts to automate the project creation, setting permissions for users, groups in TFS. Integrated JIRA and GIT with Pre-commit hooks and also involved in setting up JIRA as defect tracking system alongside configured various workflows, customizations and plugins for the JIRA bug/issue tracker. Experienced in branching, tagging and versioning control using GitHub. Participate online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients Experience in Work queues configuration, monitoring and Internal UiPATH Work Queue Actions. Extensively worked on debugging application for fixing bugs and Production support. Involved in bulk mail sending as batch and developed RPA Proactively designed RPA Tasks as per application and business requirements Extensively tested the bots in UAT, Stage environments with the business users and stakeholders. Efficiently handled monitoring and troubleshooting the UiPATH environment through Orchestrator. Participated with test teams during the Product test and UAT phases to fix assigned bugs. Worked in automating processes interfacing Microsoft power apps, Microsoft 365 activities and Azure DevOps activities. Experienced creating bots using Azure Activities for connecting the platforms involved in the process and also for file search, uploads/downloads. Experience working with API calls and SAP activities. Good understanding and experience using Microsoft Office, including the ability to read Excel macros to translate them to RPA solutions and/or integrations. Involved in bulk mail sending as batch and developed RPA Identify and communicate the technical infrastructure requirements to design RPA process solutions in accordance with standard RPA design principles and conventions. Develop automation processes as per the Technical Design Document (TDD) to meet the defined requirements. Making Solution Design Documents. Developing processes using UiPath Robotics automation tool. Impact analysis of different Project work request on UiPath processes. Solid design, coding, testing and maintaining the RPA's (Robot's). Responsible for the successful implementation and sustainment of the RPA Program. Performed feasibility analysis for RPA automation for insurance claims process Used HTML, Java Script, CSS to make the view and VB script to perform the tasks. Developed MetaBots using automation anywhere to work like automation building blocks at different stages like front end, back end, API level and Image recognition. Used Microsoft Office, including the ability to read Excel macros to translate them to RPA solutions and/or integrations. Debugging the workflow/tasks, finding the bugs using error handlers and fixing them in minimal time. Used Filters (Normal Filter, Group by Window Filter, Visualize Filter) for quick error identification and debugging. Analyzing and troubleshooting of bots by implementing Error Handling command features such as Snap shot and Log Data into a file. Environment: UiPath 2020.10.6, Excel, Email, Rest API, SharePoint, SQL Server, Azure, Vizio Client: Fresenius Medical Care - North America, TX. Jun 2020 April 2022 Role: Robotic Process Automation Developer Responsibilities: - Implemented End to End Robotic Process Automation (RPA) using UiPath. Implemented selectors for interacting with window and web browsers for continuous navigation of applications. Designed different workflows to run several tasks using Workflow designer in automation anywhere. Used Data Scraping method for extracting structured data from browser applications or documents into a CSV file or Excel Spread sheet. Identified new process opportunities, quickly assessing feasibility conventions. Involved in SDLC Requirements gathering, Analysis, Design, Development and Testing of application developed using Agile Methodology. Participated in Business SME work sessions and identified the scope of feasibility for RPA. Developed scalable and efficient process automations and reusable components that can be leveraged across different lines of businesses. Designing the workflow documents and allocating the objects to automation developers. Explaining how UiPath will suit for the ongoing project and lessen the human involvement in repeated and time - consuming tasks and increase work efficiency. Extensively used commands like Keystrokes, Mouse clicks, Open program/files, Files/Folders, Window actions, Log to File, Loops, System, Delay and Interactive. Automating user actions using Browser, PDF, MS Excel, MS Word and other windows applications performed through interactions with thick clients. Used trigger actions like File Trigger and Folder Trigger. Connected to different clients using client manager of Automation Anywhere Server Management. Implemented Templets for Data Backups, File Operations, FTP tasks, Disk Cleaner and Super tasks. Used image activities with wait conditions to ensure proper website or application loading, to perform certain actions in a loop. Used Excel automation for repetitive Excel data entry, appending and for comparing columns. Handled exceptions using Try-Catch activity. Schedule, run and ensure the stability of processes in production. Configured the Bots and deploying processes and scheduled the jobs in UiPath Orchestrator. Understanding & analyzing project requirements and working on them to deliver timely results. Responsible for maintaining PDD and SDD. Develop and Design Automation Anywhere processes. Developing scalable and efficient process automation and reusable components that can be leveraged across different processes. Deployed the process in UiPath Orchestrator and scheduled their execution. Design solutions utilizing Robotic Process Automation software; maintain technical responsibility for project delivery as the sole technical resource on a project or the leader of a delivery team. Configured new processes and objects using core workflow principals that are efficient, maintainable and readable. Automated numerous routine tasks using UiPath, Blue Prism theirby reducing manual intervention. Created and maintained solution documentation, test procedures and scenarios for the pre - UAT phases. Supporting existing processes and implementing change requirements as part of a structured change control process. Implemented Azure Devops for Github repositories and for sprint s planning. Implemented Visio for designing the automations for the processes. Handled wide variety of projects that includes Document Understanding, Action center and API Callings Used Screen Scraping method to extract text from running window application by appropriate output methods such as native, Full text and OCR. Created Reports for the business and analytics for the automated processes using UiPath Insights Develop the object and workflow for client requirement. Designing the workflow documents and allocates the objects to automation developers. Actively participating in Test plan preparation, validating the Client requirements and identifying the various Scenarios for Automation Development. Developed and configured automation processes as per the technical design document (TDD) to meet the defined requirements. Strong skills in application of RPA business processes at the enterprise level. Developed robotic bots using automation anywhere to automate process which was done using manual interference Data Extraction using Automation Anywhere. Task scheduling using Automation Anywhere like Schedule Manager, Task Editor, Data Drive Tasking Develop robots using Automation Anywhere. Utilize the bot framework and contribute towards enhancing t. Code error handlers to catch and log errors. Extensively worked with commands like object cloning, web recorder; Terminal Emulator etc Setup bots in the Control room. Environment: UIPATH, AZURE DEVOPS, C# .NET, XML, MS Excel, MS Visio, MS SQL Server 2014, VBO, PowerBI, UiPath Insights Client: Texas A&M University-Commerce, TX. Sept 2019 May 2020 Role: Data Analyst/Python Developer (Graduate assistant) Responsibilities: - Developed visually impactful dashboards using Tableau that aided the faculty in making informed decisions. Responsible to build and maintain Tableau dashboards. Created action filters, parameters and calculated sets/combined fields/bins/hierarchies for preparing dashboards and Worksheets in Tableau. Restricted data for particular users using row level security and user filters. Responsible to aggregate data from various sources to construct streamlined data pipelines and integrate data from TAMU multiple systems. Gathering feature specific requirements and making infrastructure setup to handle feature data. Responsible to build MySQL queries to migrate large datasets and also conduct data analysis using academic databases to effectively portray the upcoming events. Assisted in development of university websites using web technologies like HTML5, CSS3, Bootstrap, JavaScript and JQuery. Experience in python, Jupyter, Scientific computing stack (numpy, scipy, pandas and matplotlib). Applied clustering algorithms i.e. Hierarchical, K-means with help of Scikit and Scipy. Developed and implemented predictive models using Natural Language Processing Techniques and machine learning algorithms such as linear regression, classification, multivariate regression, Naive Bayes, Random Forests, K-means clustering, KNN, PCA and regularization for data analysis. Built a database (MySQL) and front end to complement the PO request database standardizing construction project management. Aggregate the base level data for each type of device to various levels such as Divisions, Regions, Markets and Sites. Migrating data from MySQL to Mongo DB (No SQL). Communicating the feature specific requirements with UI/UX development teams. Presented data and generated reports to the design team using analytical tools like Power BI and Tableau in order to improve strategies and operations. Responsible for building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Responsible to aggregate data from various sources to construct streamlined data pipelines and integrate data from multiple systems. Worked extensively on advanced analysis actions, calculations, parameters, background images, dash boarding, trend lines, statistics and tableau calculations. Provide excel reports with daily router inventory information to various internal teams. Writing various scripts to query several networking devices, databases to gather information and store that data into MySQL, MemSQL and NoSQL databases Developed service group mapping information for highly valuable internal reports. Involved in infrastructure tasks such as installing and maintaining all the required packages for scripts to run on several servers including implemented Rabbit MQ for queuing tasks, Nagios and ELK stack. Designed My SQL database schema, Mongo Documents to store the required data. Working on Data Analytics using PyData Stack. Assisted with development of PHP5, ReactJS, Redux. Interacted with the existing database developers and DBA to understand the existing schema. Create and iterate on solutions and dashboards to empower operational and exploratory analysis. Collaborated with product, design, engineering, business groups to formulate innovative solutions to improve feature and content engagement. Environment: MySQL, Tableau, Python 3.0, HTML5, CSS3, Bootstrap, JavaScript and JQuery, MySQL, Tableau, Power BI, Python 3.0. Client: Puget Sound Energy, Bellevue, WA. Sep 2018 - Aug 2019 Role: RPA Analyst/ UiPath (Intern) Responsibilities: Worked on Robotic Process Automation using Blue Prism. Preparing demos based on the automation performed and showcase the same to potential internal/external customers. Identified opportunity to automate manual tasks using Robotics Process Automation (RPA) technology and established Commercial-wide RPA program to deliver the first software bot in production. Worked closely with Process SME's to translate process in to Process Definition Document (PDD) & Solution Design Document (SDD) and educated SME's to work with bots in production. Creating solution on process automation for different Business Applications (Windows based, Browser based, Java and Mainframe). Experienced in building Blue Prism Processes and Business Objects for various business models. Implemented Blue Prism User authentication by defining user roles, creating users and setting password policies. Executed SQL Queries to check the data table updates after test execution using MySQL. Experienced in Staging and Deploying the automation solutions into test and live environments and involved in End to End development of Business Process using Robotic Process Automation. Created and documented test procedures and scenarios for the pre-UAT phases and to supported the Operational teams during the UAT and rollout phases. Took business requirements, current and future state process designs and translated them into process flows and Visual Business Objects within the visual studio and UiPath Orchestrator. Good exposure on managing workloads using UiPath Work Queues, Queue Configuration and Internal Work Queue Actions. Used Data Scraping method for extracting structured data from browser applications or documents into a CSV file or Excel Spread sheet. Used image activities with wait conditions to ensure proper website or application loading, to perform certain actions in a loop. Created reports using PowerBI and also provided brief analysis for the processes through UiPath Insights Provided Exception handling at each & every possible scenario for a robust error-free development. Experience in staging and deploying the automation solution into test and live environments and efficiently handled monitoring the processes in Orchestrator. Environment: Blue Prism 6.4, C# .NET, XML, MS Excel, MS Visio, MS SQL Server 2014, VBO Client: JPMorgan Chase & Co., Hyderabad, India. Jun 2017 Aug 2018 Role: RPA developer Responsibilities: Worked with Business Analysts to Create Functional Requirements Documents (FRDs) for a Robotic Process Automation project (RPA), based on business process design discussions with business stakeholders. Experienced in building Blue Prism Processes and Business Objects for various business systems. Involved in End to End development of Business Process using Robotic Process Automation. Worked on Process Definition Document and Solution Design Document. Created and documented test procedures and scenarios for the pre-UAT phases. And supported operational teams during the UAT and rollout phases. Hands-on experience with visualization tools, such as MS Excel. Used Blue Prism Object Recorder to Create and manage solution on process automation for different Business Applications (Windows, Browser based). Broke down processes into reusable objects using Object Studio and utilized them to build processes in Process Studio efficiently. Designed, Developed and Tested Bots for Tasks using Blue Prism. Involved in the centralized infrastructure for maintaining several robots across the organization. Maintained and 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. Involved in Process Management, Defining, Designing, Development and Testing. Worked on Integrating applications like (Web, Services, MS Office, GUI, Outlook etc.) using workflow, automation tools (Blue Prism). Managed a team of developers in an agile environment. Efficiently handled monitoring and troubleshooting the Blue Prism environment through Control room. Provided Exception handling at every possible scenario for a robust error-free development. Involved in all phases of Software Development Life Cycle including design, development and creating test cases. Experience in staging and deploying the automation solution into test and live environments and efficiently handled monitoring and troubleshooting the Blue Prism environment through Control room. Interacted with window application and created an object and interacted all the objects in process studio and created work queue and ran the process in RPA. Responsible for identifying the automation opportunities and gathering the requirements Worked closely with Process SME s to translate process in to Process Definition Document (PDD) & Solution Design Document (SDD) and educated SME s to work with bots in production Responsible for viewing current state process maps to optimize future state process and wrapped the OID and FRQ content with in the PDD Involved in preparing demos based on the automation performed and showcase the same to potential internal/external customers Involved in phases of Software Development Life Cycle of design and development Actively Identified opportunity to automate manual tasks using Robotic Process Automation(RPA) technology Created solution on process automation for different Business Applications (Window based, Browser based) and managed a team of developers in an agile environment. Environment: Blue Prism 6.2, C# .NET, XML, MS Excel, MS Visio, MS SQL Server 2014, VBO Client: ADP, Hyderabad, India. Dec 2016 May 2017 Role: Jr. Software Engineer (Intern) Responsibilities: Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes Used SQL Server reporting services for creating, editing, and scheduling reports Created and maintained database objects, created complex Stored Procedures, Triggers, cursors, Tables, Views SQL Joins and Created stored procedures to use as the datasets for the Report Design by SQL Reporting services Created SSIS packages for different data loading operations for many applications Very extensively used SSIS Import/Export Wizard, for performing the ETL operations Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice- versa Developed complex reports, which are migrated from different reporting tools Analyzed the existing application programs and tuned SQL queries using execution plan, SQL performance Monitor, SQL profiler Interacted with developers on various aspects, ranging from usage of utilities to SQL performance, test data and general troubleshooting SQL performance tuning by modifying SQL queries or changing/adding indexes Created and automating the regular jobs Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML and XML Involved in designing and developing web pages using HTML 5, CSS3, JavaScript, JQuery Responsible to Style, look and feel of the web page with SASS that extends CSS with dynamic behaviours such as variable, mixing, operations and functions. Contributed in implemented jQuery component router for navigation and the services to connect the web application to back-end APIs. Created JQuery reusable components and services to consume REST API's using Component based architecture provided by jQuery. Worked on jQuery by consuming RESTful web services and used jQuery forms like template drive forms, modern driven forms to perform form validations both on server side and client side. For Responsive Web design used Bootstrap to build layouts and components like dropdown menus, navigation bar, alerts, tables and labels. Involved in handling of Wi-Fi statistics on application layers to provide interaction with UI and TR069. Implemented logging feature on CWMD module for interaction between CMS and RGW based on requirement using C programming on Linux platform. Provided delivery handling for multiple releases for Residential Gateways and interacted with clients directly, handling various issues Integrated Stored Procedures to generate the Reports. Guided LINQ and Lambda Expressions for information retrieval and manipulating Responsible for connecting Database SQL Server to MVC using ADO.Net Entity. Excellent analytical, problem solving skills and ability to handle multiple production issues in the project. Comprehensive exposure in project delivery management and the Development Life Cycle including design of the workflow Plans. Environment: MS SQL Server 2008, T-SQL, DTS, MS Access, Flat files, Windows XP Client: L&T Technology service Ltd, Chennai, India. April 2016 - Nov 2016 Role: Jr. Software Engineer (Intern) Responsibilities: Development of service tools for image ideal processing Development of cross-platform image processing solutions for automatic test systems Knowledge of image processing algorithms: encoding / decoding, feature detection and matching, image segmentation and transformation Participated in enhancement of Software Design and development for RLC/MAC protocol layer counters to keep track the statistics of PCU management and cell relocation. Was involved in Design and Development and testing of GPRS/EGPRS counters for Features - Extended Cell feature in PCU for supporting the GSM cells. Epsilon BTS can support GSM mode, EDGE mode or dual GSM/EDGE operation. Responsibilities: Involved in complete SDLC for implementation using C programming for operational and maintenance (O&M) RTC module and resolved the issues/bugs with successful delivery for BTS. Technical Analyses and Modelling Correlate and automate software for optimized image processing tuning in the areas of In-depth knowledge of and experience in subjective image quality evaluation Knowledgeable of image processing techniques Maintenance and documentation of the generated code Experience using computer simulation software MATLAB Experienced in Mathematical modeling, simulations and algorithm performance evaluation Environment: MATLAB, MS Excel, MS Access, Flat files, Windows XP Education Summary: Texas A & M University - Commerce, TX USA. Masters of Science in Business Analytics. GPA - 3.7/4.0 Course work: Database management, Data warehousing, Business Analytics, Statistical Methods, Advanced Analytics, Mobile Business, Quantitative Analysis for Managers, Environmental Marketing. Vellore institute of technology (VIT), Vellore, TN, INDIA. Bachelors of engineering, Electronics communication engineering. GPA 7.8/10.0 Keywords: cprogramm csharp continuous integration continuous deployment quality analyst artificial intelligence user interface user experience message queue javascript business intelligence database information technology purchase order trade national microsoft Colorado New Jersey Tennessee Texas Washington Wisconsin