Ramya Y

Results-driven professional with over 11 years of experience in Ab Initio, Metadata Management, Oracle, GCP BigQuery, SQL, and Informatica. Expertise in Graphical Development Environment, EME, and Metadata Hub components, along with hands-on skills in SQL, relational database management systems, and performance tuning.

Assistant Consultant - TCS

(2022-05)

Client: British Telecom

• Collaborated with stake holders to collect and document business requirements.
• Developing ETL pipeline and applying the business rules during the processing. Implement the Batch and continuous flow.
• Involved in end-to-end project lifecycle (EMP & User Stories) including requirement analysis, development, testing, and deployment.
• Design and develop ETL workflows using Ab Initio (GDE – Graphical Development Environment). Build and maintain data pipelines for large-scale data processing. Work with components like: Rollup, Scan, Join, Partition, Reformat, Sort, etc.
• Develop and optimize Ab Initio graphs for performance and scalability Use Co-Operating System (Co-Op) for parallel processing
• Handle data ingestion from various sources (files, databases, APIs, cloud).
• Perform data transformation, cleansing, and validation.
• Worked with the Data Governance team to support metadata management, ensuring data lineage, consistency, and compliance across systems.
• Create workflow, imports, Data product in metadata portal.
• Experience in metadata management - Business Glossary, Lineage, data dictionaries, ETL is essential.
• SQL, Linux and PLSQL knowledge and analytical skills Attributes and write SQL queries to validate test results in DW database.
• Collaborated with cross-functional teams to implement IVVT (Integration, Verification, Validation, and Testing) processes for robust data integration solutions.

IT Analyst - TCS

(2020-01 - 2022-04)

Client: Western Digital

• SQL, Linux and PLSQL knowledge and analytical skills Attributes and write SQL queries to validate test results in DW database.
• Writing efficient and optimized PL/SQL code. Use of cursors (explicit/implicit).
• VMI and JIT Models: Worked on Vendor Managed Inventory (VMI) and Just-In-Time (JIT) models. Currently, materials are pulled from vendors to the warehouse based on work order (WO) quantity and 48 hours ahead of pack-out. However, Work In Progress (WIP) does not move by WO, leading to excess inventory at the warehouse. Implemented JIT material triggering based on WIP position rather than WO.

Teamlease Digital Pvt Limited

(2018-10 - 2019-12)

• SQL, Linux and PLSQL knowledge and analytical skills Attributes and write SQL queries to validate test results in DW database.
• Writing efficient and optimized PL/SQL code. Use of cursors (explicit/implicit).
• Part Number Harmonization (OPN/BPN) Project: Contributed to the part number harmonization project. The existing logic had hardcoded part numbers. Introduced a new logic using card type instead of hardcoded part numbers, facilitating the addition of new part numbers.
• Strong understanding of SQL (SELECT, INSERT, UPDATE, DELETE, MERGE). Views, synonyms, sequences. Materialized views

Software Engineer - Eteam Infoservices Pvt Limited - Bangalore

(2018-10 - 2019-12)

• This project involves migrating HP's systems from a Unix environment to a Linux AWS cloud environment. The primary objective is to ensure a seamless transition to the cloud, leveraging AWS's robust infrastructure for enhanced performance and scalability.
• SQL, Linux and PLSQL knowledge and analytical skills Attributes and write SQL queries to validate test results in DW database.
• Collaborated with cross-functional teams to implement IVVT (Integration, Verification, Validation, and Testing) processes for robust data integration solutions.

Agile Consultant - Tquanta Technologies pvt limited - Chennai

(2016-08 - 2017-05)

• This airline project is designed and developed for creating a mobile application. The purpose of this mobile application is to calculate their customer credit allowance, baggage redemption calculations, flight cancellation, flight rebooking, credits expiry, and seat upgrade. Cancel and rebooking service successfully delivered.

Fault Engineer - Nokia - Chennai

(2014-10 - 2016-05)

As Contract Payroll

• This is supporting project for Telecom Company called Vodafone Telecom, Australia which is a telephony service provider. The purpose of this application is to support their employee's flexi allowance and their Day to day Release, Delivery Order processing requirements.

Data Entry - MEENAKSHI UDYOG (INDIA) Pvt Ltd - Hosur

(2013-08 - 2014-10)

• Provided non-technical support to team members.
• Enhanced financial reporting accuracy by streamlining and automating data entry processes.
• Reduced manual data entry errors, implementing automated data capture and reconciliation tools.

B.E - Electronics and Communication - Excel Engineering College (2013)

+2 - Sri Vijay Vidyalaya Mr. Higher Secondary School (2009)

10th - Our Lady's High School (2007)