SUMMARY:

• Having 9+ years of IT experience with 3+ years experience in Robotic Process Automation (RPA) using UiPath.
• Strong Experience with Uipath Components like UiPath studio UiPath robot and UiPath orchestrator
• Experience in automating Windows, Web, PDF, Excel and Citrix virtual machines.
• Experience in Banking, insurance, Healthcare, Automobile, Retail l domains. worked on the Database Activities like Connect, Disconnect, execute query, Execute Non - query, Insert in the Ui Path installed DB Packages for Database Activities in the Ui Path used Debugging for troubleshot the issue in the UI Path
• Experience in configured the Outlook mail activities in the UiPath. used Recording for automating business processes in the UiPath
• Experience in estimation, planning, forecasting and tracking for projects
• Strong software troubleshooting skills, and an understanding of programming construct
• Co-ordinate with multiple development teams to track the progress of the project experience in supporting UiPath BOTS and the RPA Platform
• Experience in all Phases of System/Software Development Life Cycle (Process Consulting, Architecture, Design, Development, Testing, Deployment and Support).
• Familiar with aspects of technology projects like Business Requirements, Technical Architecture, Design Specification, Development and Deployment.
• Experience in Agile Methodology
• Worked on the Excel package Activities like Excel application scope, read cell, Read Range and Append range installed various package like excel packages and pdf packages
• Experience in pdf activities like Read pdf text and Read pdf with OCR in the UiPath
• Experience in data scrapping, selector in the UiPath. worked the various activities like set text, Get text, Select item, Type into, send hotkey, click Activities in the UiPath
• Experience in MS Visio for Process modeling pened specified url in IE/Firefox/Chrome Browser by using Open Browser Activities worked on the Sequence and Flow Chart workflows in the Uipath Studio.
• Good Exposure to complete RPA Life Cycle Discovery, Solution Design, Build and Test, UAT, Go-Live, Run support in multiple projects.
• Experience with using version control tools like PVCS and Accurev
• Worked on the Estimation, Planning, the Managing team for the complete project Execute in the UI path
• Worked on UI path studio concepts like debugging a work flow, creating variables, arguments, control flows.

TECHNICAL SKILLS:

RPA Tolls: UI Path, Automation Anywhere, UiPath studio,UiPath robot and UiPath orchestrator

Programing Skills: .Net, C#, Java, J2EE, C, C++

ETL Tools: IBM Infosphere DataStage11.x/9.x/8.x/7.5x2

RDBMS: SQL Server,Teradata V13, V14, Oracle 12g/11g/10g/9i, DB2, MySQL

Scheduling Tools: Autosys, Crontab

Version control Tolls: PVCS, Accurev

Tracking tool: JIRA,Bugzero

Change Management Tolls: HP Service Manager, Remedy, Cherwell

Other Technologies: Citrix, Putty, Humming Bird,Winscp

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

RPA Developer

Responsibilities: .

• Interacted with business owners for Requirement gathering
• Implemented End to End Robotic Process Automation (RPA) using UiPath.
• Used Data Scraping method for extracting structured data from browser applications or documents into a CSV file or Excel Spread sheet Used SQL to extract data from Oracle database by creating user defined SQL statements.
• Extensively worked on screen scraping and Data scraping, Full text, Native text and OCR using UiPath.
• Experience in supporting UiPath BOTS and the RPA Platform.
• Experience in pdf activities like Read pdf text and Read pdf with OCR in the UiPath installed various package like excel packages and pdf packages
• Experience in pdf activities like Read pdf text and Read pdf with OCR in the UiPath
• Experience in data scrapping, selector in the UiPath. worked the various activities like set text, Get text, Select item, Type into, send hotkey, click Activities in the UiPath.
• Meeting SLA’s and providing accurate results to the client management.
• Performed Unit Testing, Integration Testing and User Acceptance testing for code change and enhancement.
• Involve in the build and testing of small to medium-scale projects.
• Knowledge of ITIL concepts
• Utilize business knowledge to collaborate and offer technical solutions.
• Design and track the changes of Components and check for Error free code build across various instances throughout the project.
• Defect tracking and Resolutions
• Co-ordinate with business and testing teams as applicable.

Environment: UiPath, PDF Reader,.net,C#, OCR,Web services,SOAP,Rest, JIRA,Bug Zero, HP Service Manager, SQL Server

Confidential, Detroit,MI

ETL Developer

Responsibilities:

• Worked on full software development cycle activities including analysis, design, development, testing, deployment to production and support.
• Developed detailed ETL design documents, ETL specifications and data mappings based on requirements
• Written UNIX shell script to handle automation of daily batch runs to handle catch up runs by passing last run date, last pull date and use of infrastructure ETL run tables to accomplish daily batch runs catch-up
• Schedule the jobs through Autosys JIL.
• Involved in documentation for Design Review, Code Review and Production Implementation.
• Experience in writing rule sets using Quality Stage.
• Experience in writing Survivorship rules using Quality Stage.
• Experience in Investigate stage, Standardize stage, Match stage
• Experience in writing rule sets using Quality Stage.
• Experience in writing Survivorship rules using Quality Stage.
• Perform column analysis, rule analysis, primary key analysis, natural key analysis, foreign-key analysis, and cross-domain analysis using IBM Info Analyzer
• Configure and code data quality validation rules within IBM Info Analyzer
• Information Analyzer administrative tasks such as managing logs, schedules, active sessions and security roles etc
• Import/export projects along with rules and bindings successfully from one environment to another using Information Analyzer
• Involved in Low Level design document for mapping the files from source to target and implementing business logic.
• Conduct all review meetings and explain the process of new implementations.
• Coordinate with team members and administer all onsite and offshore work packages.
• Prepared documentation including requirement specification
• Worked with Developers to troubleshoot and resolve issues in job logic as well as performance.
• Conducted weekly status meetings.
• Maintained Data Warehouse by loading dimensions and facts as part of project.
• Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Head & Tail Stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
• Debug, test and fix the transformation logic applied in the parallel jobs
• Successfully implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.
• Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for bulk data loading and for performance boost.
• Developed UNIX shell scripts to automate file manipulation and data loading procedures.
• Tuned transformations and jobs for Performance Enhancement.
• Scheduled the jobs using AutoSys
• Involved in Reading and writing to the XML

Environment: IBM Info Sphere Data stage 11.X, Quality stage & Information Analyzer 11.X,SQL, Business Objects XIR2,DB2,Teradata, Netezza, SQL Server, Oracle, Autosys, PVCS, SAP, PLSQL,TOAD, UNIX- AIX, MS Word, Excel, DB2,IBM Info Sphere Master Data Management Enterprise Edition, XML, TOAD, SAP

Confidential, Detroit, MI

ETL Developer

Responsibilities:

• Used the Autosys job Scheduler to schedule the Datastage jobs to run the daily jobs and weekly jobs.
• Production Support - Identify issues, review errors, approve resolution, and advise of potential downstream impacts
• Experience in debugging ETL jobs to check in for the errors and warnings associated with each Job run
• Worked on data analysis and data correction and cleanup for warehouse tables
• Responsible in debugging Ticketing issues in the production phase
• Password maintain in Production environment
• Code migration in Production environment
• Worked on new generic UNIX scripts and existing scripts to automate some of the warehouse functionality.
• Monitor Automobile Environments and run defined Data Quality Checks
• Maintain relationships with IT and Business.
• First line support for Business Users and Analysts including mailbox support, researching questions and maintaining web-based knowledge base.
• Created jobs in Datastage to import data from heterogeneous data sources like Oracle 9i, Text files and SQL Server
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually
• Worked on Fast load, Multi load for loading the data into the Teradata database
• Provided production support and performed enhancement on existing multiple projects.
• Automate the process of data stage jobs to handle multiple day runs to catch up for any missed day runs
• Written UNIX shell script to handle automation of daily batch runs to handle catch up runs by passing last run date, last pull date and use of infrastructure ETL run tables to accomplish daily batch runs catch-up
• Validated the current production data, existing data and the programming logic involved
• Responsible in debugging Ticketing issues in the production phase

Environment: IBM Info Sphere Data stage 8.X, Information Analyzer, Quality stage & Information Analyzer 8.X, Autosys, Teradata, Oracle, Netezza, SQL Server, Oracle, Teradata, UNIX,SQL Server,DB2,PVCS,Autosys