SUMMARY

• 1.5 year experience in designing, developing and implementing Robotic process automation solutions.
• Expertise in Analyzing & Identifying use cases and documenting & submitting re - engineering proposals for Robotic automation of critical business processes.
• Hands on experience in development, implementation and integration of UiPath based RPA automations.
• Experience in Web based UiPath automations for Planisware based COTS web applications.
• Experience in developing and implementing RPA frameworks for Legacy Mainframe applications using TN3270 terminal application.
• Extensive knowledge and experience in UiPath Excel, E-mail (Outlook) and PDF activities and it’s integration with Web applications.
• In depth knowledge in UiPath Robotic Enterprise Framework implementation, Exception handling, Project organization and Invoking workflows.
• Understanding of UiPath orchestrator - Queues, Assets and Scheduling.
• Currently Undergoing training in Blue Prism RPA devolopemnt.
• 12+ years of total IT experience including more than 8+ years of Application development and 4+ years of application Maintenance.
• Experience in leading teams developing and implementing solutions according to business requirements and Stabilizing and upgrading applications in production environment.
• Excellent knowledge in development, Configuration, administration and integration of Planisware based Web applications .
• Expertise in Web application Architecture and Infrastructure - Linux IHS Web/App servers, WSL/ADFS, Windows SQL DB servers.
• Expertise in development and maintenance of Web applications - JavaScript, OPX2 scripting, HTML, CSS .
• Hand on experience in Webservices development using SOAP protocol with XML/JSON and Unix shell scripting.
• Knowledge in data transformation and analytics tools DataStage, QlikView and Alteryx .
• Hand on experience in developing POCs in Hadoop - HDFS, Sqoop, Hive and Pig
• Exposure to multiple Database management systems - MS SQL server, DB2, IMS DB
• Multiple certifications from IBM on DB2 database programming - “IBM DB2 UDB V8.1 Family Fundamentals” and “IBM DB2 UDB V8.1 Family Application Development”.
• Outstanding knowledge and development experience in IBM mainframe technology - COBOL, JCL, VSAM, IMS DB, Teradata and DB2.
• Deep knowledge ITSM process tolls Rally, HPQC, BMC and Request Centre .
• Exposure to both Agile and Waterfall project methodologies.
• Experience in multiple tools - Accurev, Autosys, SiteScope, SharePoint, Putty .
• Expertise in modern security authentication implementation using native ADFS as well ADFS with wsl5 agent integration.
• Exceptional knowledge in “Automobile” and "Health care insurance" domains.
• Excellent interpersonal and management skills.
• Work Experience Overview:

TECHNICAL SKILLS

RPA: UiPath, BluePrism (Training in progres)

Web architecture: HTML, CSS, JAVASCRIPT, OPX2 scripting, UNIX, MySQL, SQL DB administration

Data Analytics: DataStage, QlikView, Alteryx

HADOOP (Beginner): HDFS, SQOOP, HIVE, PIG

Tools: Rally, HP Quality center, Request center, BMC Remedy tool, PUTTY, SQL server Management studio, SiteScope, Accurev, Autosys

Security protocols: WSL, ADFS

Product: Planisware (Project and Portfolio management)

Servers: Linux server Administration, Windows SQL server, IHS

Legacy Mainframes: OS-390, Z/OS, COBOL, DYLAKOR, REXX, JCL, SAS and ISPF Panel, IMS DB, IMS DC, TERADATA, DB2, VSAM

PROFESSIONAL EXPERIENCE

Confidential

Planisware analyst & RPA developer

Responsibilities:

• Worked with business team to identify and document use cases for critical business processes suitable for RPA implementation to lower costs and increased efficiency.
• Designed and developed RPA POCs and Submitted automation proposals to upper management.
• Created and reviewed the PDD and SDD documents for the proposed automation.
• Architected the integration plan between multiple RPA modules and to the Planisware web application.
• Designed, developed and tested UiPath Objects, workflows and functions using UiPath studio, making sure they execute with optimum performance.
• Integrated multiple UiPath the functions to implement end to end automation of critical business processes.
• Deployed, managed and monitored BOTS using UiPath orchestrator
• Researched and defined RPA best practices and provided process improvement recommendations.
• Worked on Legacy mainframe (TN3270) and modern web applications (Planisware) automations using UiPath.
• Automated data movement (import and export) of data between Web application and Hyperion Financial applications using UiPath.
• Debugged and resolved UiPath workflow issues in SOX critical production environment.

Planisware Analyst

Confidential

Responsibilities:

• Designed, developed and configured Planisware Web applications using OPX2 script programming (JavaScript), HTML, CSS.
• Developed Hadoop (HDFS, SQOOP, PIG and HIVE) POC to resolve performance issues while processing huge volume of program data.
• Built the infrastructure for Planisware 3 tier architecture - Linux servers (with IHS) for Web layer, connect.exe for middleware and SQL server for Database.
• Developed SOAP webservices using XML/JSON to fetch data from Planisware web application to Datstage Linux servers.
• Designed and developed complex Unix shell scripts to establish parallel processing of webservice classes through multiple server ports.
• Implemented ADFS, wsl5 based modern authentication protocol.
• Involved in Data model development for MS SQL server staging layer database.
• Incident and defect management using HP Quality center, Request center, BMC Remedy tool
• Change control and version management using Accurev.
• Performed Job scheduling using Autosys.

Confidential

Business Intelligence developer

Responsibilities:

• Designed and developed 3 Tier architecture (Extract Layer, process Layer and Application Layer) for QlikView Dashboard applications.
• Developed, tested and deployed QlikView 12 dashboards as per business requirements.
• Implemented incremental QVD loads for QlikView applications to optimize the performance.
• Designed and developed Alteryx workflows to read/write business input data from SharePoint lists and load it in to SQL server DB which in turn served as input for the QlikView extract layer.
• Implemented EDX (Event driven execution) strategy to trigger QlikView jobs from Alteryx.
• Involved in Data model development for SQL server 2016 relational staging layer database.
• Performed end to end integration testing of the BI application which involved Planisware, Datstage, Webservices, QlikView and Alteryx modules.

Confidential

COBOL, Teradata and IMS/DB2 Database Developer

Responsibilities:

• Total responsibility in Estimation, Requirements gathering, Analysis, Design, Coding, Testing and Deployment.
• Designed and developed COBOL/DB2 programs as per the business requirement.
• Developed JCL jobs integrating to Teradata DB.
• Designed modules to pull, transform and load data from 3 source applications to a centralized Teradata database
• Co-ordinated with Teradata data architect and DBA to ensure that the new Data model design is optimum.
• Code review, Test Plan review, Test case review, Test results review.
• Implemented best practices from agile methodology.
• Co-ordinated Unit testing, system testing and UAT.
• Upon project completion, documented the learnings and best practices.
• Provide coaching/mentoring as and when needed.
• Utilized multiple tools - Change man, File Manager, IBM Debug Tool, SPUFI.
• Created a REXX tool which would utilize DFSORT functionalities and help the team to submit Sort jobs effectively.
• Automated the Work queue metrics creation process. This task was a manual task which took more than 2.5 hours every week. This was automated as part of six sigma programs which saved around 120 resource hours per year.

Confidential

COBOL and IMS/DB2 Database Developer

Responsibilities:

• Created technical requirements from each business requirements for a US based Health insurance client.
• Designed technical solutions for critical requirements.
• Coded and tested large COBOL programs using complex algorithms to develop the pharmacy claim processing engine.
• Developed the data model for an IMS database to efficiently store huge number of claims and benefits data.
• Designed and developed a complete balancing solution using Infogix ACR.
• Involved in System Integration testing and UAT.
• As a process improvement, designed report creation modules, which made the verification of business rules efficient.
• As the Quality Controller, created and maintained quality plan and goal trackers for the project.