Mohan Krishna

RPA Developer

Email ID- ac2gew@r.postjobfree.com

Contact # 971-***-****

SUMMARY:

5+ Years of Experience in Software Development Field.

2+ Years of Experience in Robotic Process Automation (RPA). Worked on Automation Anywhere and Hands on Experience on robotics.

Experience in TABLEAU, SSIS, SSRS and SQL.

Worked on different application like windows application, web applications, Microsoft excel citric application and silver light.

Hands on Experience using. Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Used flow diagrams Water Fall model during RPA Development.

Fair Knowledge on using Autocad, Solid works

Good domain knowledge in WMS (Warehouse Management Systems).

Proficient in all phases of SDLC, Data Conversion, System Implementation, Maintenance, and Acceptance Testing.

Can rapidly absorb new concepts and apply them effectively; innovative problem solving skills and expert trouble-shooter, effective in working independently and collaboratively in teams with excellent communication and written skills.

Technical Skills:

Programming Languages: SQL, MSBI, Java scripting

RPA Tools: Automation Anywhere 10.3.0, Blue Prism

Databases: SQL Server, SAP Hana

Configuration Management: TFS.

IDE: Eclipse, Microsoft Visual Studio 2013, integration

OS: Windows XP/7/8/10/Ios

Methodologies: Agile,

Tools: Autocad

Professional Experience:

Client: Capital One, Richmond VA Jan17-Au17

Project: ESM Project

Description: Capital One - ESM technology infrastructure team has a vision of automating the current manual and mundane processes through Robotics. This processes in future needs to be carried out by the Robots so that current human strength can be utilized for other job requiring more decision making and human intellect.

Primary objective of this project would be:

1)Improve efficiency by running the process automatically and at optimum frequency

2)Improve Employee satisfaction by focusing human effort on more Value add work

3)Provide platform/used case for wider Capital One processes

Installed Automation Anywhere 10.3.0 in AWS server, configuration.

Configuring Control Room Settings, installing Control Room License, User Roles and Privileges, creating New Roles and Assigning Permissions.

Managing User Permissions, Roles and Permissions Matrix.

Automated creating invoices in coupa application,

Monitoring and administration of automation infrastructure using the web based control room.

Automated to void the invoices in coupa application process

Application level access managements in the respective applications, Test and development environment and the Development/Test cases for the same would be Created/managed/loaded by Capital One.

Communicating with Blue Prism on software related issues, suggested improvements and participating with other users in the Blue Prism community

Created the folder with the appropriate name in config files Exception will rise in bot to check the application URL and error captured in error log.

Accessing and managing tasks and Clients/Users from anywhere anytime.

Monitoring task progress and status to enforce internal compliance regulations, as well as to prevent tampering with mission-critical processes.

Facilitate an environment for increased collaboration to optimize productivity.

Accommodate scaling of multiple Users and Client environments (machines).

Environment: Automation Anywhere 10.3.0, SQL Server 2014, AWS, Blue prism 7.2, VB, VBA, ASP.NET, Oracle, XML, HTML, Java Script, CSS.

Client: Bank of America, Charlotte, NC Oct15 - Jan17

RPA Developer

Project: EIT Project

Description: Will apply and/or develop highly advanced data access routines to extract data from source systems for monitoring operations compliance to banking Laws, Rules and Regulations. Often acts independently to uncover and resolve issues associated with finding data that can be used by Compliance Testers to monitor operational compliance. Serves as a consultant to Test Designers to ensure appropriate data filters are applied based on business/product needs. Expert with Robotic Process Automation (RPA) Developer.

• Provides analytical support in EIT activities related to multiple Compliance Control Functions. Gathers and organizes data in order to track, report and monitor effectiveness of controls and tracking, monitoring, and escalation of risk related issues to management. Investigates data attributes within various operational and reporting databases. Builds logics for automated data extraction and validation for EIT testing. Acts as subject matter expert on data mining, code development, quantitative tools, and automated reporting.

• Works within the policies and standards regarding sampling methodologies. Thoroughly documents operating procedures for sampling execution.

Hands-on experience with PLC, Robotics & Simulation Programming, Robotic Line Commissioning.

Works within the policies, Process Description Documents and standards regarding sampling methodologies. Thoroughly documents operating procedures for Automation.

Generated Reports and monitoring effectiveness of Controls and Tracking, monitoring, and escalation of risk related issues to management. Investigates data attributes within various operational and reporting databases. Builds logics for automated data extraction and validation for Automation

Acted as subject matter expert on data mining, code development, quantitative tools, Solution Design Document for Automation

Gained experience in various robotic applications such as Spot welding, Arc welding, Handling, Gluing, Hemming, Tandem welding. Blue Prism, Work Fusion, Open Span

Worked on problem solving issues that arise in day to day running of Blue Prism processes and providing timely responses and solutions as required.

Communicating with Blue Prism on software related issues, suggested improvements and participating with other users in the Blue Prism community

Skilled in managing operations involving resource & materials planning, team building and coordination with internal departments

Adept in coordinating, planning & implementing changes to technology, equipment, control systems and reporting procedures

An effective communicator with good leadership, decision making, planning and team management skills

Gained significant exposure in working with industrial automation solutions incorporating robotic systems.

Expertise in managing all electrical, controls and robotic resources including the scheduling of service and installation personnel for on and offsite work

Environment: Automation Anywhere 10.2.0, VB, VBA, ASP.NET, Oracle, XML, HTML, Java Script, CSS.

Client: Apple Inc. Sunnyvale, CA Nov 14- Sep 15

Project: I Reserve

Description: Currently working on developing the reservation system for Apple, which allows apple customers to reserve the apple products (iPhone, apple watch and iPad) through online during the prelaunch and post launch. iReserve services are developed using REST web services with couch base backend running on tomcat server.

Roles & Responsibilities:

Worked as Engineer in Robotics & Automation department with team with activities related to Development, execution & commissioning of Robots & logic by using PLC, HMI & Autocad

Configuration & commissioning of network protocol on different networks

Configuration new Blue Prism processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.

Interacting with Customers for conceptualizing machine operations / process sequence and developing logic as per requirement & needs of Robots and ensuring their performance as per the pre-defined standards

Done project on Kuka robots for Arc welding application (Fronius & Lincon Electric), tandem welding Done project related to Robot initialization, Blue Prism, Work Fusion, Open Span

gun configuration, I/O configuration, and gripper configuration, ATC configuration for Kuka robots (VKRC) in Volkswagen

Have worked various applications like Arc welding, spot welding, Tandem welding, Handling application, and sealing application on Kuka and FANUC robots in Volkswagen

Lead the team as Technical Lead Engineer in a system integration project on ABB robot and Allen Bradley PLC for spot welding application in Volkswagen,

Soft hands on various simulations software's like Rob cad and Robot Studio.

Environment: Automation Anywhere 9.0, VB, VBA, SAS Software, C# .Net, ASP.NET, SQL Server 2014, XML, HTML, Java Script, CSS.

Client: Image Hospitals India Feb 11- Dec 13

Role: SQL Server Developer

Doctor’s staff credentials are maintained in this intranet system. It is one of the most important and critical systems in the healthcare industry. Medical Staff Credentials System is used for verifying and determining the credentials of the doctors. The system stores information like Doctor’s licenses, license expiry dates, credentials, specialization, surgery records, etc.

Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)

Created packages in SSIS with error handling.

Had a great hands in parallel data ware housing

Worked with different methods of logging inSSIS.

Experience in creating complexSSIS packages using proper control and data flow elements.

Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.

Designed and developed SQLSSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLserver 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.

Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.

Experience in upgrading SQLServer software to new versions and applying service packs and hot fixes and unattended Installations.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.

Building UAT and Test environments using Production back ups.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Created dashboards by using Data connections for data source and designed KPIs, Filters, Reports, Indicators and Scorecards by using performance point,

Wrote store procedures to generate account statements for different types of accounts

Involved in migration of SSRS from SQL 2000 to SQL 2005

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Sybase, PDW

Educational details: Masters in Computers- NPU -2015

Contact this candidate