Dynamic data professional specializing in Google Cloud and BigQuery, refined at Cognizant. Demonstrated success in data migration and ETL processes, enhancing performance while overseeing CI/CD pipelines. Robust analytical capabilities paired with exceptional communication skills, fostering successful project outcomes and improving operational efficiency.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Associate - Projects
Cognizant |Client - VERIZON
Hyderabad
07.2022 - Current
Company Overview: Verizon is an American wireless network operator that previously operated as a separate division of Verizon Communications under the name of Verizon Wireless. In a 2019 reorganization, Verizon moved the wireless products and services into the divisions Verizon Consumer and Verizon Business and stopped using the Verizon Wireless name.
Designed Metadata for metrics for different business.
Calculate the metric using Metrics and store the result in GCP Bigquery target table.
Prepared automation script where Postgres to BQ and Different source for BQ using Python.
Studying the source of the data to identify the methods of data extractions.
Prepare Metadata in Postgres repository.
Working experience in Data ingestion.
Prepared table and views in Teradata.
Having experience in CICD pipeline.
Working experience with files.xlsx, .CSV, and XML in Talend.
Prepared the test cases and test criteria for the developed jobs.
Worked with Error handling mechanisms and mailing components to send mails, to report the status of the job.
In Teradata worked on ingestion and curation part.
Worked Experience in data migration from Teradata to Bigquery.
Worked on BQ optimization.
Implementation checklists while promoting testing and production.
Involved in Unit Testing and documentation.
Verizon is an American wireless network operator that previously operated as a separate division of Verizon Communications under the name of Verizon Wireless. In a 2019 reorganization, Verizon moved the wireless products and services into the divisions Verizon Consumer and Verizon Business and stopped using the Verizon Wireless name.
Senior Process Executive
Infosys | Client - TOMTOM
Hyderabad
04.2021 - 03.2022
Company Overview: TOMTOM company is majorly works on navigation related product where client provides some shape files from which data can be extracted in .csv or.txt files. Then using Talend components and job designs, need to create projects in desired format which will be uploaded to FTP servers as inputs to production team. Client will upload those projects in IRIS workflow tool where production team will work on database using inputs and it is a continuous process.
Gathering Requirements and implementing them into Source to Target mappings in loading and staging.
Interacting with client in understanding the requirements whenever process change occurs before changing the job designs.
Created metadata for oracle, MSSQL for implementing ETL jobs in Talend.
Extensively used for joining different sources using tmap components.
Processing the Data files in Talend Open Studio using different components like tFilelist,tMap, tFilterRow, tUniqueRow, tAggregate, tReplicate, tUnite and tSendmail etc.
Created context variable to store metadata information of all the sources and targets.
Used FTP components for copying data from server to local and local to server.
Monitoring data from Tableau on daily basis and scheduling jobs based on inputs from Tableau.
Used best practices Performance tunings methods to handle the nulls, minimize the warnings, error handling and involved in load scheduling and performance optimization.
Effectively played a multi dynamic role facing all challenges and managed working on similar projects as well.
TOMTOM company is majorly works on navigation related product where client provides some shape files from which data can be extracted in .csv or.txt files. Then using Talend components and job designs, need to create projects in desired format which will be uploaded to FTP servers as inputs to production team. Client will upload those projects in IRIS workflow tool where production team will work on database using inputs and it is a continuous process.
Process Analyst
Teleperformance | Client - AMERICAN CAB LIMO-US
Hyderabad
11.2019 - 04.2021
Company Overview: The claim management system (CMS) deals with all types of claims (bills, payments...etc) in the organization. It automates the Manual claim processing system. The CMS receives all the claim related mails and check whether the claims are valid or not by scanning the inner details of the mail and also check by naming conventions, date and time validations and finally identify correct claims and send them to the concern person for process and rejected claims are sent to recipients with the reason why it is rejected.
Designed jobs to create all the tables required in the project.
Created different context variables in Job level and Project level, worked with the context groups.
Created Data migration job designs for various item structures in Talend as per client requirement.
Studying the source of the data to identify the methods of data extractions.
Prepare Metadata in Talend Open Studio repository.
Processing the Data files in Talend Open Studio using different components like tMap, tReplicate, tFilterRow and tLogRow etc.
Working experience with files xlsx, CSV, and XML in Talend.
Prepared the test cases and test criteria for the developed jobs.
Worked with Error handling mechanisms and mailing components to send mails, to report the status of the job.
Involved in different types of the Validations in development process by using the tMap component.
Implementation checklists while promoting testing and production.
Involved in Unit Testing and documentation.
The claim management system (CMS) deals with all types of claims (bills, payments...etc) in the organization. It automates the Manual claim processing system. The CMS receives all the claim related mails and check whether the claims are valid or not by scanning the inner details of the mail and also check by naming conventions, date and time validations and finally identify correct claims and send them to the concern person for process and rejected claims are sent to recipients with the reason why it is rejected.
Business Analyst
Futurz Consultancy |Client - TCS
Hyderabad
07.2018 - 06.2019
Company Overview :Tata Consultancy Services is an Indian multinational technology company specializing in information technology services and consulting.
Designed jobs to create all the tables required in the project.
Created different context variables in Job level and Project level, worked with the context groups.
Studying the source of the data to identify the methods of data extractions.
Prepare Metadata in Talend Open Studio repository.
Processing the Data files in Talend Open Studio using different components like tMap, tReplicate, tFilterRow and tLogRow etc.
Working experience with files .xlsx, .CSV, and .XML in Talend.
Prepared the test cases and test criteria for the developed jobs.
Worked with Error handling mechanisms and mailing components to send mails, to report the status of the job.
Involved in different types of validations in the development process by using the tMap component.
Implementation checklists, while promoting testing and production. Involved in unit testing and documentation.
Involved in unit testing and documentation.
Education
Bachelor of Technology -
Dr BR Ambedkar Institute Of Technical Education
Port Blair Andaman & Nicobar Islands
06.2018
Diploma -
Dr BR Ambedkar Institute Of Technical Education
Port Blair Andaman
06.2015
High School Diploma -
Govt Girls Senior Secondary School
Port Blair Andaman & Nicobar Islands
05-2010
Skills
Google Cloud and BigQuery
CI/CD pipeline management
Data migration and ETL
Performance optimization
Metadata management
Google Cloud Storage
Workflow orchestration with Airflow
Cloud orchestration with Google Cloud Composer
SQL proficiency
PostgreSQL expertise
Teradata knowledge
Python programming
Version control with GitHub
Continuous integration with Jenkins
Appreciations
Teleperformance, best performer of the year
Infosys, certification of appreciation
Training
Technosiam, BCA students, JNRM, 2015
Internet of Things, computer students, DBRAIT, 2014
Android, computer students, DBRAIT, 2014
Networking, Network Bulls, DBRAIT, 2015
Ethical hacking and cyber security, AKR Educations, DBRAIT, 2018
Languages
English
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Tamil
Proficient (C2)
C2
Certification
An associate cloud engineer deploys and secures applications, services, and infrastructure, monitors operations of multiple projects, and maintains enterprise solutions to ensure that they meet target performance metrics. This individual has experience working with public clouds or on-premises solutions They are able to perform common platform-based tasks to maintain and scale one or more deployed solutions that leverage Google-managed or self-managed services on Google Cloud.
Internships
Information Security, Indian Institute of Technology Madras (IIT), Chennai, 2017
Mean Stack Web Development, Engineering Staff College of India, Hyderabad 2018
Senior Front End Developer at Cognizant Technology Solutions - Client: VerizonSenior Front End Developer at Cognizant Technology Solutions - Client: Verizon