Rpa Developer Data Integration

Dilleswari Potnuru

RPA Developer ETL Specialist

[Dallas, TX] [*****************@*****.***] [210-***-****]

Professional Summary

Innovative and meticulous RPA Developer and ETL Specialist with more than 4 years of experience in designing, developing, and implementing automation solutions and ETL processes across diverse industries. Proficient in leading automation projects using RPA tools such as UiPath, Blue Prism, and Automation Anywhere, with expertise in building and optimizing ETL pipelines using SQL, Datastage, SSIS and Python. Known for improving operational efficiency and ensuring data integrity through effective automation and seamless data integration.

Technical Skills

RPA Tools: UiPath, Automation Anywhere

ETL Tools: DataStage (hands on), SSIS, Talend, Pentaho

Languages: Python, SQL, VBScript, C#

Databases: SQL Server, Oracle, MySQL, Snowflake

Cloud Platforms: AWS, Azure

Automation & Data Integration: API Integration, REST/SOAP APIs, Workflow Orchestration

Version Control: Git, Bitbucket

Process Design: BPMN, Agile Methodologies

Monitoring & Logging: Kibana, Splunk

Professional Experience

RPA Developer ETL Specialist Bank of America - Plano, TX (Jan - 2021 – Present)

Developed and deployed end-to-end RPA solutions using UiPath to automate repetitive manual tasks, resulting in a 30% reduction in processing time for key operations.

Collaborated with business units to design, map, and enhance workflows, leading to a streamlined order management process.

Created, scheduled, and monitored ETL pipelines using SSIS to extract, transform, and load data into SQL Server and Snowflake, ensuring 100% data accuracy across reporting systems.

Integrated RPA workflows with APIs and database systems to enable seamless data exchange between legacy applications and cloud-based services.

Automated monthly reporting by combining ETL workflows and RPA bots, reducing manual workload by 50 hours per month.

Conducted performance tuning and SQL query optimization for ETL pipelines, improving data load times by 40%.

Designed and implemented automation scripts using UI Path to manage routine processes in finance and HR, resulting in a 20% efficiency boost.

Led the automation of invoice processing using RPA bots integrated with OCR tools, reducing processing time by 70% and eliminating human error.

Participated in Agile sprints to deliver process automation solutions and ensure smooth handoffs to business teams.

Documented RPA workflows and provided end-user training, ensuring smooth transition and adoption of automation.

ETL Developer, USAA Plano, TX, Sep 2017 – Jun 2020

Designed and implemented ETL processes using Informatica and Talend to transform data from various sources into centralized data warehouses.

Improved data pipeline performance by 30% through query tuning and optimized ETL logic.

Collaborated with business analysts and stakeholders to identify data quality issues and implement automated data validation workflows using Python and SQL.

Ensured data integrity and consistency through error handling and rollback mechanisms during data loading.

Education

Bachelor of Science in Computer Science from [Aditya Institute of Technology and Management], [Andhra Pradesh, India] Year: [2017]

Certifications

Essentials Automation Certification (2023)

Advanced Automation Certification (2024)

Contact this candidate