Sql Developer

JORIS JOSE

Oracle PL/SQL Developer

Bentonville,AR

424-***-****, Email: *************@*****.***

https://www.linkedin.com/in/joris-jose-a5b27417/

SUMMARY:

** +years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Generated different reports through Forms and Reports in PL/SQL.

Performance tuning through queries involving Oracle SQL and PL/SQL queries.

2+ years of experience in working with Python, Machine Learning - Pandas, Numpy packages.

2 years of experience in web application development using JAVA/J2EE technologies.

Responsible for day-to-day systems maintenance such as installing patches and fixes, space monitoring, file system maintenance, performance monitoring and tuning in UNIX environment.

Worked on Logical /Physical Dimensional Data models and generated the DDL statements.

Gained good exposure to plan and execute the phases of Software Development Life Cycle (SDLC) including Requirement Analysis, Design, Development, Testing and Maintenance and implemented in Core Java and SQL and implemented various data structures and algorithms.

Develop, test and deployed stored procedures and packages to work in conjunction with UNIX scripts, Java and javascript applications.

Troubleshoot servers and client partition configurations.

Involved in the web application development using HTML,JavaScript,JSP,Servelet,Struts,Hibernate,JDBC and worked on the webservices using REST API

Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Configured user roles, privileges, and encryption in Oracle 12c to ensure compliance with data security standards.

Implemented partitioning and compression techniques in Oracle 12c to optimize storage and enhance query performance for large datasets.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.

Developed Materialized Views for data application in distributed environment.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Exposure in using CASE tools like TOAD, SQL Navigator for writing PL/SQL programs

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Strong experience in Data warehouse concepts, ETL.

Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Worked on JIRA for defect logging and tracking and documented all the works using Confluence

Excellent knowledge in cloud platform like AWS including S3 and EC2.

Strong knowledge in non RDBMS like BigData, Cassandra and Mongo DB

Expertise in writing Python scripts with Machine Learning Algorithms.

Good Knowledge on ETL and Data warehouse concepts

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

Technical Skills

Databases

Oracle 12C, Oracle 10G, Oracle 11G, ETL Concepts, Oracle Database - Administration, Mysql, DB2, SqlServer 2000

Programming Languages

PL/SQL, Java, Python, C, C++, Javascript, PL/pgSQL

J2EE Technologies

Servlets, JSP, Struts, XML, JDBC

Operating Systems

Windows vista/98/Xp/7, Unix

Development Approach

Waterfall, Agile

Design Patterns

MVC, DAO, Singleton

IDE

VSCode, Eclipse, NetBeans, Spring Tool Suite

Frameworks

Hibernate, struts

Build and Testing Tools

JUnit, Log4j, Maven

Web Servers

WebSphere, WebLogic, JBoss, Tomcat

Version Control

SVN, ClearCase, GIT, BitBucket

Tools

SQL* Loader, TOAD, Putty, WinSCP, SQL-Developer, FileZille, DataGrip, DBeaver

Scripting

Shell, python

Education

Masters in Computer Science

Texas A&M University, Commerce. 2019-2021 - 3.8 GPA

B Tech in Information Technology

Cochin University of Science & Technology

M S Course Project

Fraud News detection using Python and Machine learning libraries using KNN algorithms.

Career Profile

Canoo Inc, Torrance, LA July 2021 to Present

Designation: Software Engineer.

Title:

Software Engineer in various Technologies.

Technology

Oracle,PL/SQL,Python, PostgreSQL, Pandas, Numpy.

Database

PostgreSQL, PL/SQL

Description

The Parts managements system of Canoo done with Python, Postgresql.

The PLM Enrichment system build up on Python, pandas and numpy Libraries.

Roles & Responsibilities:

Programming, maintenance and support of the parts management system which has daily synchronization with PLM system involves daily parsing of xml files into the PostgreSQL based database system with Python scripts. Also, the SQL scripts developments for the maintenance of the database also needed.

Creation and Maintenance of Enrichment system before it submits to Oracle ERP from PLM system. Machine learning libraries – pandas and NumPy uses here for the data enrichment.

Deployment and testing of all codes through Jenkins after submitting it to the Bitbucket through git commands also required.

Execution and debugging of the scripts through entire pipeline in the AWS also need to take care of. Now everything taken care of in Agile and Sprint methodologies.

Texas A&M University, Commerce. July 2020 to April 30, 2021

Designation: Application Developer

Clients: Texas A&M University, Commerce.

Title:

Application Development for Banner Project

Technology

Oracle SQL, PL/SQL

Client

Texas A&M University, Commerce

Database

Oracle 12C/11g

Description

Various scripts writing using SQL, PL/SQL for the customized part of the Ellucian Banner system of Texas A&M Commerce. Various data uploading with and without scripts and also batch job changes using scripts included.

Roles & Responsibilities:

Worked extensively on PL/SQL stored procedures, packages, Functions and Triggers and optimized performance of the queries to retrieve, manipulate and migrate data sets in Oracle Databases.

Generated the DDL Statements with database design for the creation of tables, views and keys.

Involved in the meetings with the business users to gather functional and nonfunctional requirements to setup the time estimates for the project.

Manipulation of UTL_FILE using used regular expressions in procedures and functions have been done.

Involved in Performance Tuning, Monitoring and Optimization of PL/SQL blocks using tools such as Oracle Hints and Parallels in both Development and Production environment.

Utilized Java, Eclipse/J2EE, tested programing code & Applications, collaborated with team.

UST Global, Trivandrum. January 2014 to July 2017

Designation: Senior Software Developer

Clients: Allianz, General Electrics, MAERSK

Roles & Responsibilities:

Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java and Hierarchical databases like Oracle and Access.

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Written *.hbm.xml file for developed POJO to map the object to relational database.

Designed and implemented data model using Hibernate 3.0 as the persistence layer that uses Oracle as backend database.

Developed web services using Restful.

Implemented on Agile Process.

Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.

Developed code fixes and enhancements for inclusion in future code releases and patches.

Projects Undertaken:

Title

DnD Data Precision Project

Technology

Oracle SQL

Client

Maersk

Database

Oracle 11g

Description

DnD Data is missing on usual pattern. This has to be tuned to pick all the missing data through précising of missing chains, disordered event chains, error codes missing etc. This is implemented as a different project for the DB Team.

Title

Testing scripts on commercial upstream upgrades

Technology

Oracle SQL

Client

Maersk

Database

Oracle 11g

Description

Testing scripts on upgrades on all the tables based on different logics to ensure no data missed during the process

Title

Supplier Connect

Technology

Oracle PL/SQL

Client

General Electrics

Database

Oracle 11g

Description

Supplier Connect is the development of an interface which do the integration of third party supplier details into the Oracle ERP application with the Oracle PL/SQL APIs.

Title

Work For Hire Development

Technology

Oracle PL/SQL,Java.Rest API

Client

General Electrics

Database

Oracle 11g

Description

Various small development projects and works which comprises data loading, designing, development and testing.

Title

Oracle Punchout

Technology

Oracle PL/SQL, Oracle iProcurement

Client

General Electrics

Database

Oracle 11g

Description

Oracle Apps Punchout Automation helps most of the punchout requests to be automated.

Title

Address Point Rating

Technology

Oracle PL/SQL, Java,JDBC,Servlet

Client

Allianz

Database

Oracle 11g

Description

Making the addresses more accurate and so policy pricing.

Title

Precision Pricing

Technology

PL/SQL, Java,Hibernate,Struts,

Client

Allianz

Database

Oracle 11g

Description

Making the policy pricing more accurate.

Title

MTA Admin

Technology

PL/SQL,Java,JDBC,Servlet,JSP

Client

Allianz

Database

Oracle 11g

Description

Changing the current policy handling fee in various circumstances.

Title

Tia Upgrade

Technology

PL/SQL, Data Management, Java Connections.

Client

Allianz

Database

Oracle 11g

Description

Tia is an Insurance application, used globally. The project was for upgrading TIA version 5.4 to 6.2.

Company : Paladion Networks Private Limited.

Designation : Software Engineer

Clients : Central Government of India Agencies, Ministry of Telecom Algeria

Period : March 2010 to November 2013

Roles & Responsibilities:

Working Implement and maintain the database design.

Involved in the programming with core java.

Oracle Database Query creation, Management, Optimization.

Implemented Oracle Streams.

Performance Tuning and query optimization.

Oracle Lexer Indexing related research and works.

Use of partitioning in various databases and the optimization tuning.

Oracle PL/SQL Developments –Packages, Procedures, Functions, Triggers, Sequences etc.

Scripting and performance tuning of the Auto Correlation in 7 servers.

Many scripts have been made for Health Checkup Report generation of the servers etc.

Working experience in install, upgrade and patching of oracle software in linux environment.

Performed UNIX System Administrator duties: Software upgrades, Network troubleshooting and Monitoring, File System modifications, On-Call Support.

Working experience in oracle 10g / 11g, SQL, PL/SQL, MS SQL Server, mysql, db2, linux, unix.

Different binaries management in Linux servers during database operations.

Testing all kind of database developments.

Oracle RMAN backup management in production servers.

Worked in Oracle Forms and Reports

1 year in Algeria worked as Database Support Engineer.

Worked for the Radius server tuning for the implementation of the pl/sqlscrips in 7 of the collector servers.

Query Optimization tuning at production and sharing the results for the discussion with the development team.

Contributed to Database Link, AWR Report, Enterprise Manager.

Training & Certifications

Best Entrepreneurship award from UST Global.

Contact this candidate