PROFESSIONAL SUMMARY:

• To be associated with a progressive Organization that gives scope to apply my knowledge, experience and team management skills for executing responsibilities given to the opportunity and to derive job satisfaction.
• Overall around 9 Years of IT Experience in IT industry on software development, design and implementation of various application systems using RPA (Robotic Automation Process) using Automation Anywhere, Blue Prism, Cloud and Analytics architecture.
• Strong Experience in Robotic Process Automation (RPA) Automation Anywhere.
• Developing rule based Robotic Process Automation (RPA) solutions using Automation Anywhere by following the industry standards and best practices.
• Automating user actions performed through interactions with clients - Browser, MS Excel, MS Word and other windows applications.
• Experienced in analysing & Robotics automation development and to be a part of requirement gathering team in facilitating improvement in applications, planning and building effective environments.
• Configuring new automated processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.
• Involved in end to end life cycle for Automation solution designing and development from Requirement gathering, executing development plans and Change Request Methodology.
• Extensive Knowledge in US Health Care Management.
• Problem solving issues that arise in day to day running of automated processes and providing timely responses and solutions as required.
• Experienced in automating desktop, Surface Automation, JDE, Web Applications.
• Expertise includes Decision Support Systems using Analytics Technologies, developed Multidimensional Power Cubes from different data sources.
• Automating user actions performed through interactions with client applications.
• Advanced automation techniques including image recognition, OCR.
• Having Flexibility and Adaptability regarding new technologies and environments.
• Experience in Report Development using Cognos Analytics 11.05, Cognos 10.2.2 and ETL using Informatica Power center 9.6.1.
• Developed Multidimensional Power Cubes from different data sources using Cognos Power Play Transformer, developed automation cube build scripts for cubes building and Deploying.
• Good understanding of various automation components and features available in Robotics Products. Understands development methodology and lifecycle.

TECHNICAL SKILLS:

Automation Tools: Automation Anywhere (10.3.1, 10.7.1,11.0.0 & 11.3.1), Blue Prism 6 and UiPath v2018.4.1.

Languages: VB, SQL, PHP, Python, HTML 5, HIVE, JQuery, JavaScript.

Databases: MS SQL Server 2014/2012/2008 R2, Oracle11g, SAP HANA.

Tools: MS Office 2007,2010,2013 and 2016, Eclipse, Toad

Other Technologies: Mongo DB, Cognos Analytics, Informatica, Tableau, R, Scala

PROFESSIONAL EXPERIENCE:

Confidential - San Antonio, TX

Robotics Process Automation

Responsibilities:

• Understanding the Business Process from the SMEs and Business Leads
• Requirement Gathering and Analyzing the existing Bank Back end process which involved multiple applications and multiple technologies. for one of the process called ALS, Portal, CLAS,NICE SCARF application in Deposits, CCM area.
• Analyzing the process and designed the improved processes for Framing of Proof of Concepts.
• Involved in Analysis, Design, Development, Testing and Implementation.
• Followed best practices recommend by Automation Anywhere.
• Responsible for designing the RPA solution Design.
• Developed Framework based various RPA Projects.
• The RPA project need to make sure is 100% compliance in the BANK standards.
• The RPA project production to pass BCP Team Test with 95%-100% level test.
• Project sub bots and main bots code review for the team.
• Developed various MetaBot and applications bots for team re-using purpose.
• Involved the Web, Windows based NICE application automation.
• Perform detailed analysis of functional, business requirements and prepared the POC for NICE SCRF (Cancel PTO) application for POC Assessment document.
• Designed the to be flow diagram for the for Confidential RPA NICE SCRF (Cancel PTO IN, shift slide, Shift adjustment in and Out) modules.
• Documentation of the entire NICE SCARF process for, which includes capturing all the functionalities through SOP review, discussions with SME, walkthrough and other mediums to gather all the requirements.

Confidential - Dublin, Ireland

Robotics Process Automation

Responsibilities:

• Involved in Development RPA solutions using Automation Anywhere for the Confidential Pick Face Allocation Module and another 2 Projects/Modules are developed using Ui Path.
• Process development, Exception handling design and correct use of stages and blocks correct use of data types, system and session variables.
• Involved in Development, UAT and robot deployment RPA solutions using Automation Anywhere by following the various methods for Confidential Pick Face Allocation.
• Preparation of process documents like UAT Result, Bot Exceptions Result Report and Technical Issue document (Occurred while bot execution).
• Worked on Change requests and production defects templates for RPA Support Model.
• Implementing the exception handling when needed within the process and Worked with BA to add the missing functionalities for future reference.
• Analyzing the environment requirement like JDE application access and Automation Anywhere license requirement and communicating the same to IT.
• Involved in bug fixing while project development, Automation Anywhere Environment setup installation, Configuration and Trouble shooting in the Window environment.
• Handle the UAT process.
• Defined the supporting the process and implementing change request as per client requirement
• Web, Windows and JDE based application automation.
• Followed best practices recommend by Automation Anywhere.
• Conducting Session to Clients about client Logs.
• Developing the Code and Uploading to Control Room.

Confidential

Senior BI & ETL Developer /Administrator

Responsibilities:

• Understanding the end-user requirements as per the Client specification. Analyzing the existing process and perform detailed analysis of functional and business requirements.
• Preparing Process Definition document by interacting directly with client’s/process owner and resolve all discrepancies identified during requirements gathering and planning.
• Analyzing the process and designed the improved processes for Framing of Proof of Concepts.
• Installed, Configured and Maintenance of Distributed Environment Administration.
• Developed automation cube build script for transformer cubes building and Deploying.
• Installing and configuring the Application, Database and Web Server (IIS 8.5), Creating Users and Permissions to the users.
• Involved in Unit testing, System testing to check whether the report data and meta data meets the target are accurate environment.
• Involved in client daily meetings and prepared the user manual for the end user to the new cloud environments for better understanding.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the process.
• Designing Parallel workflow using various stages which includes Join, Sort, Lookup, Expression, Aggregate, Stored Procedure, Normalizer Transformation using SQL Server, Oracle Enterprise, ODBC Enterprise, DB2 Enterprise and SAP HANA database.

Confidential

Senior BI & ETL Developer /Administrator

Responsibilities:

• Understanding the Business Process from the SMEs and Business Leads.
• Develop the List, Crosstab, and Chart Reports, calculations, conditions, filters and prompts to limit and target the report data output as per the user requirement.
• Performing grouping, sorting and filtering on the data and also Used Conditional Blocks, Conditional Formatting in a Report for better Identify Exceptional results and Rendering.
• Develop Drill up/Drill Down and Drill Through which includes Logical Condition based Parameter Passing and Master Detail reports.
• Created the reports using Dynamic column sorting and Mouse over tool tip using JavaScript in reports.
• Involved in unit and integration Testing of the reports manually by developing manual test cases in excel sheets.
• Worked with various prompts in reports for different aspects of client business.

Confidential

BI Developer

Responsibilities:

• Develop the List, Crosstab, and Chart Reports, calculations, conditions, filters and prompts to limit and target the report data output as per the user requirement.
• Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Active reports
• Performing grouping, sorting, filtering on the data and Used Conditional Blocks, Conditional Formatting in a Report for better Identify Exceptional results and Rendering.
• Develop Drill up/Drill Down and Drill Through which includes Logical Condition based Parameter Passing and Master Detail reports.
• Created the reports using Dynamic column sorting and Mouse over tool tip using JavaScript in reports.
• Worked with various prompts in reports for different aspects of client business.
• Create complex dashboard reports for eFR measurements, financial and performance using Report studio.
• Installing and Configuring Cognos 10.1.1 Server, Framework Manager.
• Migrating the existing Cognos 8.3 Reports to Cognos 10.1.1.
• Creating and publishing Packages using Framework Manager.

Confidential

BI Developer

Responsibilities:

• Creating list reports, Combinational Charts, Master Detail reports & Drill through reports by using Report studio
• Created project specific pages to view reports using Cognos connection.
• Creating value prompts, Date & time prompts, cascading prompts.
• Performing grouping, sorting and filtering on the data.
• Created the filters and prompts to limit data output as per the user requirement.
• Formatted the reports as per the user requirements and Perform unit testing.
• Created different variables for conditional formatting.
• Involved in deployment of the reports.
• Updating the reports according to the client requirements.
• Preparing the Gap analysis documents and rectifying remarks.
• Create complex dashboard reports for eFR measurements, financial and performance using Report studio.

Confidential

BI Developer

Roles & Responsibilities:

• Develop the List, Crosstab, and Chart Reports, calculations, conditions, filters and prompts to limit and target the report data output as per the user requirement.
• Worked on advanced features of Report Studio such as Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, Active reports
• Performing grouping, sorting, filtering on the data and Used Conditional Blocks, Conditional Formatting in a Report for better Identify Exceptional results and Rendering.
• Develop Drill up/Drill Down and Drill Through which includes Logical Condition based Parameter Passing and Master Detail reports.
• Created the reports using Dynamic column sorting and Mouse over tool tip using JavaScript in reports.
• Worked with various prompts in reports for different aspects of client business.
• Create complex dashboard reports for eFR measurements, financial and performance using Report studio.
• Installing and Configuring Cognos 10.1.1 Server, Framework Manager.
• Migrating the existing Cognos 8.3 Reports to Cognos 10.1.1.
• Creating and publishing Packages using Framework Manager.

Confidential

BI Developer

Roles & Responsibilities:

• Creating list reports, Combinational Charts, Master Detail reports & Drill through reports by using Report studio
• Created project specific pages to view reports using Cognos connection.
• Creating value prompts, Date & time prompts, cascading prompts.
• Performing grouping, sorting and filtering on the data.
• Created the filters and prompts to limit data output as per the user requirement.
• Formatted the reports as per the user requirements and Perform unit testing.
• Created different variables for conditional formatting.
• Involved in deployment of the reports.
• Updating the reports according to the client requirements.
• Preparing the Gap analysis documents and rectifying remarks.
• Create complex dashboard reports for eFR measurements, financial and performance using Report studio.