Scribd
Upload
34 views5 pages

Developing Date & Time Apps in Oracle Cloud

its sample cv for 7+ year oracle job

Uploaded by

sirish.raksha25
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
34 views5 pages

Developing Date & Time Apps in Oracle Cloud

its sample cv for 7+ year oracle job

Uploaded by

sirish.raksha25
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

(ORACLE PLSQL DEVELOPER)

Professional Summary:
• 7.9 years of experience in the development of client/server and multi-tiered applications using
Oracle SQL and PLSQL on different platforms like Windows and UNIX.
• Involved in the Design, development, implementation, testing, release, support, and
documentation of business applications using Oracle technologies.
• Strong knowledge of Oracle architecture and database design concepts like Normalization and ER
Diagrams.
• Extensively used PL/SQL to build various database objects like Packages, stored procedures,
functions, triggers, cursors, ref cursors, collections, views, materialized views etc for processing
data, enforcing referential integrity and needed business rules in 19c/12/c/11g/10g.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transactions,
Compound triggers, Materialized Views, LOB data types, etc.
• Knowledgeable in client-server technology, GUI design, and Relational Database Management.
• Experience in Tuning SQL and PL/SQL code for better performance with a large volume of data.
• Strong knowledge with work experience in Unix Shell programming.
• Strong knowledge of loading the data processes using Oracle SQL Loader and UTL_FILES.
• Strong knowledge of GIT commands for version controlling with work experience.
• Worked in Telecommunications and Retailer domains on various applications.
• Knowledge in Snowflake.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design,
Development, Testing, Release, and Support with extensive exposure to databases.
• Tested deliverables for conformance with requirements and specifications, including Unit, Module,
Integration, and System testing.
• Known for managing groups of teams and achieving on-time deliveries by working with cross-
functional teams and various stakeholders such as QA, Release Management, Change Control
teams, etc.
• Quick learner with an ability to master new concepts and applications.
• Excellent analytical, problem-solving, communication and interpersonal skills to manage and
interact with individuals at all levels. Able to interact effectively with other members of the
Business, Engineering, Quality Assurance and other teams involved with the System Development
Life cycle.
• Experience in working with both on-premise and cloud database applications.
• Active participation in all the Sprint meetings.
• Assist in the implementation of QA standards and continual improvement activities.
• Assess testing quality by monitoring defect trends while moving applications between various
environments.
• Generate various metrics to measure the cause of disproportionate defect density.

Technical Skills:
Databases Oracle 19C/12C/11g/10g/9i, MYSQL, Oracle Apps R12, Snowflake
Languages SQL, PL/SQL
Tools SQL Developer, PL/SQL Developer, Oracle Enterprise Manager, SQL*Plus,
SQL*Loader, PostMan
Internet XML, JSON, Oracle Application Server
Technologies
Scripting Unix shell scripting
Ticketing Tool Jira
Operating Systems UNIX, LINUX, Windows

Work Experience:
• Working for Sutherland Global Services Pvt Ltd, Hyderabad from June, 2023 to till date.
• Working for Sunera Technologies, Hyderabad from April, 2022 to May, 2023.
• Worked for Accenture Solutions Pvt Ltd, Hyderabad from December, 2016 to April,2022.

Education:
• [Link] in VLSI & EMBEDDED Systems Design from Jawaharlal Technological University,
Anantapur.
• [Link] in Electronics and Communication Engineering from Jawaharlal Technological University,
Anantapur.

Project summary:

Project #1:
Project Name : Tracfone
Client : Verizon
Role : Senior Software Developer
Duration : April,2022 to till date
Database : Oracle
Environment : SQL* PLUS, SQL Developer
Description:
Tracfone is an American prepaid, no-contract mobile phone provider. TF offers wireless products
and services under various brand names. It operates as a mobile virtual network operator, holding
agreements with the US largest wireless network operators to provide service including AT&T Mobility, T-
Mobile US and Verizon.
Responsibilities:
• Responsible for developing database objects - Functions, Procedures, Packages, Collections,
Cursors, Triggers, etc.
• Used high-level backend PL/SQL programming involving different databases.
• Created various reports by using SQL correlated subqueries, regular expressions, PIVOT, UNPIVOT,
aggregate and analytical functions.
• Extensively used various Oracle’s Regular expression functions like REGEXP_COUNT,
REGEXP_REPLACE, REGEXP_SUBSTR, and REGEXP_INSTR.
• Created various types of triggers like Instead of triggers and Compound Triggers.
• Extensively used PL/SQL BULK COLLECT and FORALL to process the bulk data.
• Extensively used Oracle’s JSON_VALUE, JSON_QUERY, JSON_TABLE, and JSON Dot Notation
functions to extract the data in the JSON format into the RDBMS format.
• Extensively used JSON_VALUE, JSON_MODIFY and JSON_QUERY functions in Microsoft SQL
Server.
• Created dynamic SQL procedures in PL/SQL.
• Used various SQL hints to improve the performance of the code.
• Added new objects to the existing data model (logical/physical) as per the business requirements.
• Created SQLLDR scripts (Parameter files, Control files, Log files, Bad files and Discard files) to load
the data from the text files into the Oracle tables.
• Worked on Hierarchical SQL queries in Oracle.
• Created shell and awk scripts in the Unix environment.
• Created batch jobs by using Oracle’s DBMS_SCHEDULER package to run the stored procedures on
daily basis.
• Working in a multi-task environment by resolving service requests.
• Interact with other teams like SOA (JAVA), OFS, IVR, and DataPower during the CR development.
• Optimized the performance of SQL queries, established joins, and created clustered/non-clustered
indexes wherever necessary
• Involved in code review, writing a Unit test case, and creating a platform to run and validate these
Test cases.

Project #2:
Project Name : SCM-OALC
Client : AT&T
Role : Senior Software Developer
Duration : Jan,2020 to till date
Database : Oracle
Environment : Toad, Oracle Apps EBS R12, Unix, Postman
Description:
OALC is a model built on the Oracle ERP system. It is integrated with DC center and other front-
end applications like OMNI, ORACLE, DTV and CFAS system. OALC majorly deals with business activities
includes wireless and wireline.
Responsibilities:
• Coding and Handling the Change Requirements.
• Created Value sets and Concurrent programs, scheduling the programs.
• Created and modified Oracle stored packages, procedures and functions using PL/SQL, SQL.
• Involved in Code review and design review to ensure the delivery of quality solutions.
• Developed Unix shell scripts part of Data Load Process (SQL Loader).
• Coordinate with the QA team to ensure the quality of the product before release it to Production
Environment.
• Understanding the requirements, analyzing the impact.
• Active participation in Scrum calls and client interactions part of requirements gathering.
• Delivered quality code on time by meeting coding standards and business requirements without
any slippages.
• Performing Unit & Integration Testing and Writing and Executing Test Cases.
• Involved in release process, Preparing RN, BR100s and SIS pan.
Project #3:
Project Name : CDM2.0
Client : ECOLAB
Role : Senior Software Developer
Duration : Mar 2019 – Jan 2020
Database : Oracle
Environment : SQL Developer, UNIX, Azure
Description:
Ecolab provides water, hygiene and energy technologies and services to the food, energy,
healthcare, industrial and hospitality markets. The company's food safety services provide consulting to
restaurants, hospitals, food retailers and food & beverage manufacturing facilities. Every day, help make
the world cleaner, safer and healthier protecting people and vital resources.
Responsibilities:
• Coding and Handling the Change Requirements.
• Written complex SQL queries using Inline views, correlated sub-queries, joins etc.
• Created the database tables, data objects, setting privileges for various business requirements.
• Created and modified Oracle stored packages, procedures, functions, tables, indexes, synonyms,
sequences, database links, views and materialized views etc., using PL/SQL, SQL.
• Developing Applications based on Concepts like Cursors, Ref Cursors, Collections (Nested Table,
PL/SQL Table) and Bulk Collect.
• Developed the Business constraints by implementing the Triggers
• Involved in Performance Tuning the queries using AWR Report Analysis & Optimizer Hints.
• Coordinate with the QA team to ensure the quality of the product before release it to Production
Environment.
• Understanding the requirements, analyzing the impact.
• Performing Unit & Integration Testing and Writing and Executing Test Cases.
• Played a key role in enabling the client application development team on CDM process.

Project #4:
Project Name : ETR
Client : ENGIE
Role : Software Developer
Duration : Dec 2016 – Feb 2019
Database : Oracle
Environment : SQL* PLUS, SQL Developer, Oracle Lodestar
Description:
“GRTgaz” is a public limited company, a subsidiary of the industrial group ENGIE (formerly Gaz de
France. GRTgaz operates in the regulated energy sector (the rates it charges for its services are public
and set by the Government).
GRTgaz has a dual role:
• To transport natural gas to industrial customers and public distribution networks, at optimum cost and
in maximum safety.
• To support the opening up of the energy market in France by providing equal access to the
transmission system to all licensed natural gas shippers.
GRTgaz has a public service role as well, it guarantees a continuous supply of natural gas, even in times of
extreme cold.
Responsibilities:
• Created and/or modified Oracle stored packages, procedures, functions, tables, indexes and
sequences etc., using PL/SQL, SQL.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from
the database.
• Coordinate with the QA team to ensure the quality of the product before release it to production
environment.
• Developing Applications based on Concepts like Cursors, Ref Cursors.
• To fix the staging & Production issues.
• Development of Code for various modules.
• Used Explain Plan for query optimization.
• Performing Unit & Integration Testing and Writing and Executing Test Cases.

Common questions

Powered by AI

PL/SQL object types and triggers are utilized to encapsulate complex business logic into reusable components. Triggers ensure that business rules and data integrity constraints are automatically enforced whenever a table’s data is modified. This enhances the application by making sure business processes are consistently applied at the database level, thereby increasing reliability and reducing the need for additional checks in application code .

JSON functions in Oracle provide significant advantages for data interchange by enabling seamless conversion between JSON and relational data formats. Functions like JSON_VALUE, JSON_QUERY, and JSON_TABLE allow developers to easily extract, query, and manipulate JSON data, facilitating interoperability and integration with modern web technologies and APIs that commonly use JSON for data interchange .

Experience with tools like SQL*Loader and DBMS_SCHEDULER is important because these tools facilitate crucial database operations. SQL*Loader is essential for high-performance data loading, while DBMS_SCHEDULER automates routine tasks by scheduling and running PL/SQL procedures. Using these tools optimizes operations, improves efficiency, reduces manual interventions, and ensures tasks are completed reliably and on schedule .

Database performance tuning is crucial for managing large volumes of data as it helps in optimizing SQL and PL/SQL code. This involves using techniques and tools to ensure queries run efficiently, reducing execution time and improving the overall system performance, which is particularly important in environments with significant data volumes .

Involvement in Scrum meetings and client interactions can significantly enhance the requirements gathering process by providing continuous feedback loops and fostering clear communication. This involvement helps ensure that developers understand client needs accurately, align development efforts with business priorities, and adapt quickly to any changes, thus increasing the project's chance of success .

Tools like Toad and Oracle Apps EBS R12 are significant in Oracle database projects, especially in complex enterprise environments, because they offer comprehensive functionalities for database administration, development, and optimization. These tools simplify complex tasks, provide intuitive interfaces for managing multiple databases, and help maintain the high standards needed for enterprise-grade applications, thereby increasing efficiency and reliability .

The expertise in Oracle PLSQL allows developers to efficiently design, develop, and implement database objects like packages, stored procedures, functions, triggers, and cursors which are critical in processing data, enforcing business rules, and ensuring referential integrity in applications. This expertise supports robust client/server and multi-tiered application development by providing a reliable back-end structure and optimized performance .

Hierarchical SQL queries enhance data retrieval by allowing the representation and manipulation of hierarchical data structures, such as organizational charts or family trees, directly within an Oracle database. This capability simplifies complex data relationships and facilitates efficient queries that mirror the natural hierarchies in data sets, enhancing both performance and comprehensibility .

The understanding of Unix shell scripting contributes significantly to automating the data loading process by creating scripts that handle data extraction and management tasks efficiently. Shell scripts are used in conjunction with tools like SQL Loader to streamline the process of loading large datasets into Oracle databases, improving both productivity and accuracy .

Performing unit and integration testing is essential in database development to ensure that each component functions correctly in isolation (unit testing) and works together as expected within the larger system (integration testing). These testing phases identify defects early in the development cycle, reduce bugs in production, and guarantee that the application meets the specified requirements and quality standards .

You might also like