Venkata Chaitanya Marre

Customer profile Master(CPM) is an application that brings together disparate sources of customer data and provides a 360-degree view of the customer.

Responsibilities:

• Leading a team of 8 as a PL/SQL Developer for the development of the Customer Profile Master (CPM) application.
• Responsible for designing and developing database components, such as tables, procedures, functions, views, advanced concepts, indexes, and partitions.
• Managed data transfer between various source systems through the CPM database, implementing necessary business logic.
• Performed database performance tuning, including query optimization, indexing, and partitioning to enhance efficiency.
• Developed and optimized complex SQL queries, stored procedures, and functions to improve system performance.
• Collaborated with cross-functional teams to gather and analyze requirements, ensuring effective database design and implementation.
• Documented high-level design (HLD), low-level design (LLD), database schema, and technical specifications for future reference and knowledge sharing.
• Engaged with business stakeholders, Product Owners, and Scrum Masters to gather requirements and ensure successful project delivery.
• Actively involved in creating user stories, tasks, and project planning.
• Implemented and followed Agile methodology, using Jira for project tracking and management.

NMBS is a National Railway company of Belgium. It provides various types of railway services across the country.

XRAY: It is an application that stores the scanning details of people and baggage of machines located at multiple NMBS railway stations. This scanned data is being used by businesses for reporting purposes.

Cassandra: Case and Safety Analysis for Detecting Risks and Defining Actions. It is centralized IT application for managing governance, risk, compliance, safety & Well-being, Enterprise Risk Management (ERM) data.

Responsibilities:

• Worked as a PL/SQL Developer for the XRAY application, built using PL/SQL and Java Spring Boot.
• Demonstrated expertise in designing data flow and creating tables, views, and applying appropriate constraints.
• Hands-on experience in implementing packages, procedures, functions, triggers, exceptions, cursors, Oracle built-in functions, Bulk Collect, Ref Cursor, and collections for the XRAY project.
• Successfully enhanced performance using indexing, partitioning, and hints.
• Proficient in analyzing EXPLAIN PLAN, AWR, and ASH reports.
• Actively participated in the development lifecycle, including planning, analysis, design, testing, and implementation.
• Interacted with business users and clients to gather new requirements, creating user stories, tasks, and plans using the Master Craft DevPlus tool to follow Agile and Scrum methodologies.
• Worked as an ETL Developer for the Cassandra Application, responsible for data transfer from various systems in CSV, XML, and table formats to a centralized IT application using the Pentaho ETL tool.
• Created transformations, mappings, and jobs to ensure successful data transfer between source and destination systems.
• Worked with data warehouses and databases for data retrieval and loading.
• Implemented complex transformations such as Execute SQL Script, Table Input/Output, Group By, SFTP File, Mail, Update Strategy, Lookup, Row Filter, Join Rows, and REST Client Transformations.

The ING Group is a Dutch multinational banking and financial services corporation headquartered in Amsterdam. Its primary businesses are retail, direct, commercial,investment, wholesale, private banking and insurance services.

Responsibilities :

• Worked as a PL/SQL Developer at ING, Netherlands, responsible for migrating payment-related package functionalities from Oracle Database 11g to Database as a Service (DBAAS).
• Created and maintained database elements, including tables, views, constraints, indexes, packages, procedures, functions, triggers, exceptions, and collections.
• Designed, developed, and tested custom packages and procedures to support business requirements.
• Implemented advanced database features such as DBMS_PIPE, UTL_HTTP, and Advanced Queuing.
• Enhanced packages and procedures to streamline the payment portal's process flow.
• Collaborated with end-users and functional analysts to conduct system and regression testing.
• Followed Agile and Scrum methodologies for efficient project delivery.
• Interacted with client and Business on new requirements.

ASML Holding N.V. ASML is a Dutch multinational corporation founded in 1984 and specializes in the development and manufacturing of photolithography systems, used to produce computer chips.

Responsibilities:

• Served as the Technical Lead at an onsite client location in the Netherlands, leading a team of 8 members in the development and support of Oracle database technology applications (PL/SQL, Oracle Forms & Reports, Oracle APEX, Oracle Warehouse Builder, Informatica, and Unix Shell & Perl scripting).
• Worked extensively with PL/SQL concepts, including the creation of tables, views, constraints, indexes, packages, procedures, functions, triggers, exceptions, and collections.
• Managed and stored machine performance data.
• Developed, maintained, and supported mission-critical, and business-critical applications.
• Handled incident resolution, prioritized issues, and prepared Root Cause Analysis (RCA) and Problem Management reports.
• Utilized ServiceNow for application support in line with client processes.
• Optimized SQL queries using EXPLAIN PLAN, DBMS_PROFILER, and AWR reports.
• Gained extensive experience in project implementation, maintenance, and upgrade activities.
• Engaged with clients for gathering new business requirements, participating in key user meetings, and conducting service level review meetings.
• Coordinated and interacted with stakeholders for seamless project execution.

Cisco Systems is an American multinational technology conglomerate corporation headquartered in San Jose, California. Cisco develops, manufactures, and sells networking hardware, software, telecommunications equipment, and other high-technology services and products. Worked on Service commerce tool, which is mainly used for quoting and ordering of Products.

Responsibilities:

• Developed and enhanced applications using Java and PL/SQL technologies.
• Created and maintained database components, including tables, views, constraints, indexes, packages, procedures, functions, triggers, exceptions, and collections.
• Developed monitoring tools using PL/SQL scripts to track system performance.
• Acted as the point of contact for handling P1 and P2 issues, collaborating with upstream and downstream system teams.
• Created automation scripts using Oracle PL/SQL to reduce manual intervention.
• Investigated and resolved incidents within SLA, working in agile and Kanban methodologies.
• Engaged with clients to gather new requirements and provided comprehensive, end-to-end documentation of those requirements and solutions.

The Christian mutuality is a Belgian mutuality (social insurance) founded in 1886 which provides insurance service for people in Belgium.

Responsibilities:

• Designed and developed reports functionality using PL/SQL and Java technologies.
• Contributed to team meetings, providing insights on project timelines, design improvements, and feature enhancements.
• Created and maintained database elements such as tables, views, constraints, indexes, packages, procedures, functions, triggers, exceptions, and collections.
• Participated in client calls to gather and understand new requirements.
• Collaborated with upstream and downstream system teams for requirement gathering.
• Documented new requirements and system changes in accordance with project guidelines.