Post Job Free

Resume

Sign in

Sql Server Life Cycle

Location:
Atlanta, GA
Posted:
November 28, 2023

Contact this candidate

Resume:

Ph no: 510-***-**** Subramanyam Email id: ad1i37@r.postjobfree.com

SUMMARY:

Overall 8 years of IT experience including 4 years of RPA process implementation using UI Path, Automation Anywhere.

Providing support for end to end life cycle to automation solution design.

Involved in different phases of SDLC Analysis, Design, Development, Testing, Integration, Implementation and Maintenance.

Automated PDF Integrations, Excel operations, Mainframe Applications, SAP Applications.

Worked as a POC for RPA developers and acted as a bridge between developing and testing.

Responsible for design and development of the web pages from mock- ups.

Good understanding of robotic recommendations to solve manufacturing issues.

Worked closely with Process SME's to prepare Process Definition Document (PDD).

Handling change request for enhancing as well as maintaining the current API System.

Working on Business process diagrams and process flow charts with RPA tools.

Automated numerous routine tasks using Automation Anywhere, UI Path thereby reducing manual intervention also helpful in Error Handling and maintenance of robots.

Worked under both Agile Methodology and Water Fall model during RPA Development.

Enthusiastic in learning new concepts and apply them effectively when needed; innovative problem-solving skills and expert trouble-shooter, effective in working independently and collaboratively in teams with excellent communication and written skills.

Develop the Robots using UIPath to process the insurance validation and submit the case for the future queue.

Responsible for the maintaining the design documents, Technical Design documents on Automation

Experience in developing software test approach, test plan, test case design, and test scripts based on user requirements/ specifications and system requirements documents.

Involved in the centralized infrastructure for maintaining several robots across the organization.

Proactively designed RPA Tasks as per application and business requirements

Experience in managing robot's workloads using Automation.

EDUCATION DETAILS

Master of science in Computer and Information Technology

-CAMPBELL’SVILLE University

Bachelor’s Degree in Computer Science Engineering

-BVRIT, HYDERABAD.

TECHNICAL SKILLS

Microsoft Technologies

Framework 4.5/3.0/2.0/1.1/1.0, Windows Service, SQL Server Integration, SQL Server Analysis Service SSAS, Services SSIS and Reporting Services SSRS, BIDS

Languages

C#, VB.Net, T-SQL, PL/SQL, C++

Web Technology

ASP.Net, Web Services, MVC, MVP, MVVM, jQuery, HTML, DHTML, CSS, XML, XSL, XSLT

Databases

SQL Server 2005, 2008, 2010, Oracle 9i/10g/11g, MySQL, MS SQL

Automation Tool

UI Path and Automation Anywhere.

Automated Technology

Windows OS, Citrix, Web, Java, Mainframe and Oracle & Sap Applications

Certifications

UI Path (Level 2 Certified Developer)

WORK EXPERIENCE:

Client: PAYCHEX,NY AUG 20 – Present

Role: RPA UI Path Developer

Roles & Responsibilities:

well-versed with UIPath Studio, UIPath Robot, UIPath Orchestrator.

Automated 51 Applications with a Team which includes 4 developers based on the inputs from respective teams using Agile Environment.

Used UIPath Orchestrator for deployment, monitoring and management of UIPath Robots Automation activity.

Used various UIPath Activities such as Foreach, Switch activity, Citrix Screen Scraping for Remote machines, Loops, User prompts, OCR, Key strokes, Error handling, Break, Try Catch.

Worked on PDF Processing, Excel Automation, SAP Applications and Mainframe Applications and various web-based Applications Automation.

Automated text in PDF’ using screen scraping and exported the data into excel for comparison.

Created process model for browse-based application and testing it by UIPath.

Analyzed the feasibility of Manual process suitable for Automation.

Worked with Business analyst in preparing the PDD and in identifying the requirements

Involved in Client meetings along with Business Analyst.

Extensively worked on debugging application for fixing bugs and Production support.

Implemented bots in UIPath Orchestrator to run on schedule and use transaction queues for transactional data.

Provided post Go-Live training to business stake holders on executing bots from UIPath Orchestrator.

Developed scalable and efficient process automation and reusable components that can be leveraged across different processes.

Environment: UI Path, OCR, VB.Net, C#, SQL Server 2014, XML, HTML

Client: USAA, TX DEC 2019 – AUG 2020

Role: RPA UI Path Developer

Roles & Responsibilities:

Configuring new UI Path processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand for further requirements.

Web Database and Main Frame data extraction.

Excel Operations and Mail Automation.

Creation, development and maintenance of automated MI Reporting of UI Path processes in MS Access and Excel, also looking in running this in MS SQL Server using MS Access front-end

Feasibility study for RPA implementation by developing Proof of Concept (POC) and validating it with Proof of Value (POV).

Developed the scripts using different UI elements and created Batch files to execute the Bots without any manual intervention.

Developed and implemented end to end processes including automation of Web Portal, MS-Excel Operation, MS-Out Look

Experienced in managing robot's workloads using UI Path Work Queues.

Worked on Basic, Desktop, Web and Citrix automations using UI Path studio

Worked with mainframe, windows, web application and surface automation.

End to end process automation using UI Path.

Implemented End to End Robotic Process Automation (RPA) for 6 processes.

Participated in regular meetings to demonstrate the capabilities of RPA for on-going projects and

potential clients.

Environment: UI Path, OCR, VB.Net, C#, SQL Server 2014, XML, HTML, Java Script, CS

Client: Kaiser Permanente, CA Nov 2017 – OCT 2019

Role: RPA Developer

Roles & Responsibilities:

Involved in automate the business requirement using Automation Anywhere by creating tasks using task recorder and task editor.

Developed robotic bots using Automation Anywhere to automate process which was done using manual interference.

Shadowing the client requirements and making the requirement specification Document.

Prepare Road Map for delivering Task bots into production pipeline.

Solid design, coding, testing and maintaining the RPA's (Robot's).

Excel Operations and Mail Automation.

Experience in managing robot's workloads using Automation Anywhere Work Queues.

Analyze the feasibility of existing process suitable for automation.

Identifying and debugging the errors using Error Handlers.

Strong logical and problem-solving skills.

Detailed oriented with strong organizational and communication skills.

Expert in Robotic process automation solutions such as Automation Anywhere.

Involved in developing robots using Automation Anywhere V9 and V10.

Exposure to UI Path, Single Sign-on implementation using Microsoft Active Directory.

Document changes pushed to all environments, ensure compliancy across all platforms

Strong in documentation, requirement gathering, and providing trainings.

Worked with the Business Analysts in identifying and defining the requirements.

Extensively worked on debugging application for fixing bugs and Production support.

Environment: Automation Anywhere, OCR, Java / J2ee, SQL Server 2014, XML, HTML, Java Script, CS

Client: Verizon,TX MAY 2016 – Oct 2017

Role: RPA Developer

Roles & Responsibilities:

Working on Robotic Process Automation using UI Path.

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.

Implemented new reporting techniques and facilitated the presentations to the clients.

Reviewed & fixed Business Process Production issues using UI Path.

Implemented new reporting techniques and facilitated the presentations to the clients.

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.

Developed and implemented various modules to extract information from various systems using UI Path components for the Grant Processing module.

Created solution on process automation for different Business Applications (Windows based, Browser based, Java and Mainframe).

Created the high level design towards meeting functional and non-functional requirements in conformance to the Use case document.

Feasibility study for RPA implementation.

Create architecture document for RPA

Worked on advanced Blue Prism technology for Web Service which has reduced 50% development & maintenance effort

Managing governance & adopting Blue Prism best practice approaches.

Environment: .Net 2.0, UI Path, ASP.Net, AJAX, C#, ADO.Net, HTML, CSS, JavaScript, Oracle 10g, Microsoft Visual Studio, Pix tools 7.5.

Client

ICICI Bank Limited Jun 2013 – NOV 2014

Role: Asp.Net Developer

Roles & Responsibilities:

Involved in requirements gathering.

Used vb.net in writing scripts for integration services. Converted the classic asp pages to asp.net 2.0 with c#.net as code behind.

Involved working on database scripts, Stored Procedures, Views, Indexes and Functions in SQL server 2014 and used ADO.NET for communication between the web services and Databases. Developed ASP pages to communicate with COM+ components as middle tier and MS SQL Server as database tier.

Database design, preparing entity relation diagrams, UML case diagrams using Visio tool.

Involved in creating the modules for Card Expenses Allocation, Maintaining of Account Codes, and Department Codes using Windows forms.

Implemented the Middle tier and Business logic using VB.NET, ODP.NET.

Created Custom Controls using ASP.NET.

Worked extensively with CSS in preparing the Master Pages for various Web Applications.

Developed XSL style sheets for Funds Transfer Module and transformed the XML files to XML and HTML.

Created the content using ASP.Net with the feature of Dynamic Paging capabilities.

Involved in creating UML Use Case Diagrams, Sequence Diagrams, and class diagrams using VISIO.

Environment: .Net, Accentual Data Stage Enterprise Edition, Teradata, Oracle 9i/8i, PL/SQL, UNIX, Rational Clear Quest, Micro strategy. Quality center 9.1.



Contact this candidate