Etl Developer Customer Service

Rohitha Sai Alla

ETL Developer

**************@*****.***

Ph: 470-***-****

https://www.linkedin.com/in/rohitha-sai-alla-9b7214179 PROFESSIONAL SUMMARY

ETL developer with two years of experience in designing, implementing and optimizing extract, transform, load processes. Proficient in extracting data from various sources, transforming it to meet business requirements and loading it into target systems with a focus on accuracy and efficiency. Skilled in utilizing industry-standard ETL tools and technologies to streamline data workflows, improve data quality and enhance decision making capabilities. Passionate about leveraging data-driven insights to drive business growth and innovation. Leveraging LLMs to generate accurate and personalized responses, addressing customer inquiries based on specific needs using kore AI.

Designing and developing Extract, Transform, Load pipelines using Apache NiFi to automate the flow of data between systems efficiently in real time.

Developing PowerShell modules and functions to perform data transformation, validation and cleanup tasks in ETL processes.

Transforming data using PowerShell scripts to standardize formats, cleanse data, enrich information, and derive new insights for analysis.

Collaborating with business analysts, BIs and other stakeholders to gather requirements, define data processing workflows, and validate solutions.

Proven ability to work in both independent and team environments.

Utilized kore AI to automate and enhance customer service operations, improving customer satisfaction. Analyzing customer data to optimize chatbot conversations, ensuring contextually appropriate responses.

Worked on kore AI application to design and optimize appointment management flows, including cancel, reschedule and confirmation processes.

Skilled in designing and optimizing prompts for large language models, leveraging techniques like few-shot and zero-shot learning to enhance model performance and generate contextually accurate outputs across diverse applications. TECHNICAL SKILLS

Tools : Apache NiFi, SSRS, Kore AI, Apache Kafka, Docker Operating System : Windows, Linux

Languages : JavaScript, PowerShell

Database : Oracle SQL, SQL Server, MongoDB

Applications : Visual Studio Code, DBeaver, MS-Office, GitHub, JIRA PROFESSIONAL EXPERIENCE

Client: Charter Communications Jan 2023-Till date

ETL Developer

As an ETL engineer in the telecom industry, I played a pivotal role in bridging the gap between different applications to facilitate seamless flow. I design and implement robust data pipelines that harmonize data from diverse sources, including databases, APIs, and file systems. Enhance customer experience by streamlining appointment related interactions through kore AI. Key Responsibilities

Develop data pipelines to read data from/to various sources like Apache Kafka, Kibana, s3 bucket etc.

Build real time pipeline to read data from Kore AI platform through API and store in oracle DB this includes extracting useful information for further processes.

Generate reports for application performance, leveraging advanced SQL querying techniques to extract and analyze data. Utilize SQL to aggregate and transform raw data into meaningful insights, identifying trends and anomalies.

Worked on time tracking application crucial for accurate payroll processing. Engineered data pipelines to efficiently ingest, transform and store time punch data from various sources, ensuring data integrity and reliability.

Developed advanced SQL queries by considering shift schedule, overtime and breaks contributing to seamless payroll operations.

Designed AI-driven workflows to enhance customer experience by automating appointment management through voice interactions using kore AI.

Craft appropriate AI prompts to leverage large language models for extracting relevant keywords, ensuring appropriate routing of customer calls based on intent identification. Company: Capgemini Sep 2018-Dec 2021

Automation Engineer

As an SAP automation engineer worked with CBTA, UiPath to automate the redundant processes involved in invoicing, billing. Worked on SAP Hybris Billing BRIM methodology. Key Responsibilities

Good knowledge in ERP system mainly CRM. Good understanding on BRIM methodology.

Utilized SAP Convergent Mediation by DigitalRoute to collect, transform, and consolidate large volumes of data from SAP CRM to Convergent charging.

Collaborated with cross-functional teams to analyze business needs and translate them into technical specifications and mediation processes.

Managed end to end automation, data driven tests to perform regression and maintained CI/CD pipelines using Jenkins for automation.

Worked on UiPath to automate business process from SAP CRM to Convergent charging and then Convergent Invoicing.

Employment

ETL Developer at Acmesoft since January 2023. Client: Charter Communications

Associate consultant at Capgemini since May 2018 till December 2021. Client: SAP IT Education

Masters in Computer Science from University of Central Missouri, Kansas 2022.

Bachelor of Technology from Jawaharlal Nehru Technological University Hyderabad, India 2018.

Trainings

Trained in SAFe Agile practices by SAP Labs in June 2021.

Trained and certified in Agile software development in May 2021 authorized by University of Minnesota and offered through Coursera.

Trained on Relational Database Management Systems (RDBMS) offered by Capgemini as part of fresher training in December 2018.

Contact this candidate