Developer Data
Resume:
Sabarinath Logantha Mobile: 813-***-****
Professional Summary:
15+ years of programming experience as an Oracle PL/SQL, PRO*C Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
2+ Years of Experience as a Python Developer in design, development, testing, maintenance and documentation of Enterprise applications using various technologies, analyzing complex business requirements & mapping them to system specifications
Developed Restful API’s using Python FLASK and FASTAPI for ISafety Application.
Create Insomnia JSON to test the API.
Expertise in working with Python and Shell scripting for designing automation framework.
Developed python script to load the data from CSV file to Oracle Tables.
Developed python script to generate JSON object from CSV file.
Extensively used CX_Oracle, Pandas, JSON, CSV modules in Python.
Expertise in application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER, PRO*C, UNIX SHELL scripting.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Index, Synonyms and Views.
Done logical and physical Data Modeling using normalizing Techniques.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Developed materialized views for data replication in distributed environments.
Worked extensively on Ref Cursor, External Tables and Collections.
Expertise in Dynamic SQL, Collections and Exception handling.
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.
Good knowledge in Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Technical Skills:
Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers)
Tools: SQL Developer 4.0, PL/SQL Developer 7.1.5, TOAD 8.5, SQL Data Modeler
Management Tools: Visual studio TFS, Tortoise SVN, Jenkins, Git
Operating System: Unix, Windows 95/98/XP/7
Languages/Utilities: Python, SQL, PL/SQL, Basic Unix shell scripts, SQL LOADER, PRO*C, UNIX shell scripting
Education Qualifications:
Bachelor’s in Information Technology.
Professional Experience:
Project Name: Intelex Data Load and Isafety/ misafety
Client: EOG Resources Inc, Houston, Texas
Role: Application Developer
Duration: Mar 2020 - Till Date
Description:
Intelex is a Third-party system to capture the safety / Injury data for the EOG Resources field workers. EOG is developing the in-house desktop application and mobile application to capture the safety data. Intelex data load process is developed using python scripting to read the CSV file and load in the oracle system. This process will also convert the CSV file into JSON form for the mobile and desktop applications.
RESPONSIBILITIES:
Developed and designed python script to load the Intelex Data into oracle database.
Created python script to generate JSON object for the UI to render the data.
Developed and designed an API for the Isafety / misafety apps.
Co-ordinating with UI team to provide the required API for the UI.
Worked with team to test the application.
Created Insomnia JSON to test the API.
Worked on GIT repository for the code base.
Project Name: ODM (Operational DataMart)
Client: EOG Resources Inc, Houston, Texas
Role: Application Developer
Duration: Oct 18 - Till Date
Description:
The client, EOG Resources Inc. is one of the leading oil and gas exploration company which has oil wells across USA, Trinidad and China. Across Eog there are many applications captures data from leasing the land till oil production process. ODM team will consolidate the data from all application platforms and will maintain the data in one platform. Daily production volumes will be generated from ODM platform.
RESPONSIBILITIES:
Involved in the continuous enhancements and fixing of production problems.
Involved in design and coding phase.
Created applications using Python scripting.
Extensively used the python modules cx_Oracle, Pymssql, data dictionaries, smtp in the application development process.
Creation of database objects like tables, views, procedures, packages, Materialized Views using oracle tools like Toad, SQL Developer and SQL* plus.
Created required windows batch file for batch processing.
Used AdTempus scheduling tool to schedule the jobs.
Project Name: IMS (Investment Management System)
Client: State Stree Bank & Trust, Quincy, Massachusetts
Role: Oracle PL/SQL Developer
Duration: Jan 18 - Oct 2018
Description:
The client, State Street Bank & Trust provides investment management, servicing and administration, research and trading, and financial data analytics for institutional investors. State Street Enterprise Servicing Platform provides a complete middle and back office solutions to the state street clients. It gives asset owners and managers a dynamic, customizable, and scalable self-service platform for all their data needs. ESP provides end to end solution.
RESPONSIBILITIES:
Involved in the continuous enhancements and fixing of production problems.
Involved in design and coding phase.
Created Data Marts, Extracts using ESP (Enterprise Servicing Platform) Tool.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Created required Unix shell scripts for the batch processing.
Created events and autosys jobs for feed load automation process.
Environment: Oracle 11g, SQL Developer
Project Name: Global Prepaid Platform – Navy Cash
Client: JP Morgan Chase, Tampa, Florida
Role: Oracle PL/SQL Developer
Duration: Sep 14 - Dev 17
Description:
The client, JP Morgan Chase (JPMC) has an existing Global Prepaid Platform developed/managed over the past 10+ years which has been supporting their Health Savings Account, Corporate Prepaid, Navy cash and other prepaid business. NavyCash program offers a solution to Navy for their fleet of 120+ ship and shore needs, this program card has been enabled to get their payroll to be used on the ship for all purpose, maintain an account for other needs on shore. NavyCash portal supports for both end users and support team with various functionalities like transaction history, balance adjustment and transfers etc. This program also integrates with various other teams for card, transfers and regulatory requirements.
RESPONSIBILITIES:
Involved in the continuous enhancements and fixing of production problems.
Involved in design and coding phase.
Created PL/SQL stored procedures, functions and packages.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Created required Unix shell scripts for the batch processing.
Designed the data migration framework for Global prepaid platform.
Involved in navycash data migration design and implementation end to end activities.
Environment: Oracle 11g, SQL Developer
Project Name: WGPR (Wholesale Global Profile Repository)
Client: Wells Fargo, San Fransisco, CA
Role: Oracle PL/SQL Developer
Duration: Feb 14 - Aug 14
Description:
WGPR is an authorization profile repository, using Oracle 10g database, containing data related to CEO customers (companies) and users along with the information about their products, accounts and account authorizations. CEO Middleware provides its client applications access to WGPR via the Envoy2 application which acts as a logical interface for applications to carry out their business-related functions.
RESPONSIBILITIES:
Coordinated with the business team to get necessary requirement for housekeeping stored procedures and packages.
Involved in the continuous enhancements and fixing of production problems and used the SQL Data Modeler tool to change the existing data model.
Created PL/SQL stored procedures, functions and packages.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Environment: Oracle 11g, SQL Developer, Windows 7
Project Name: CADIS Data Load
Client: Indexium, Zurich, Switzerland
Role: Oracle PL/SQL Developer
Duration: Aug’ 12 – Jan 14
Description:
This project is to load the CADIS(external system) securities data in to IPS system. System will generate the IPS Security ID (internal for IPS system) for all the securities from the CADIS based on the source provider ID. If the Source provider is already exist in the system then it will not generate new IPS security ID, system will check for any update in the existing data, if any changes found in the data then it will update the existing IPS security ID Valid till data as current date and it will insert a new record for the same IPS security ID with valid from data as next date and valid till as null.
Responsibilities:
Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Involved in the continuous enhancements and fixing of production problems and used the SQL Data Modeler tool to change the existing data model.
Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Created PL/SQL stored procedures, functions and packages to load the data from Stage tables to Target tables.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Creation of database objects like tables, views, procedures and packages using oracle tools like PL/SQL Developer and SQL* plus.
Extensively used bulk collection in PL/SQL objects for improving the performing.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Environment: Oracle 11g, SQL Developer, Windows 7
Project Name: RDL (Regional Data Load)
Client: A.C.Nielsen, Tampa, FL
Role: Oracle PL/SQL Developer
Duration: Nov’ 11 – Aug’ 12
Description:
A.C Nielsen is the world leading company which is taking survey for retail products across the world and gives the best rated products by the customers. In RDL system all the data about the products will come as input flat file, the RDL system will load the data into the regional database in the two modes. One is initial load and the other is the incremental load. During the incremental load system will capture the changed data (CDC Changed Data Capture) and it will upload only the changed data in the regional database. If any error occurred during the RDL process all the information will get stored in the respective log tables. If all the data uploaded successfully, System will extract the file in the same format which is initially received for the RDL process and will place in the outgoing area from where the MDL (Massive Data Load) process will get initiated.
Responsibilities:
Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
Wrote Unix Shell Scripts to process the incoming files on daily basis in loading them into the base tables.
Involved in the continuous enhancements and fixing of production problems.
Created PL/SQL stored procedures, functions and packages in oracle APEX for moving the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Extensively used the Table Partition, sub partition, and exchange partitions concepts to move the data from stage table to target tables.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Environment: Oracle 11g, SQL Developer, Windows XP, Unix
Project Name: Employee Personal Details Update Workflow
Client: Technip, TX
Role: Oracle PL/SQL Developer
Duration: Jul’ 10 – Oct’ 11
Description:
This project is used to send an email to the employee of Technip whoever does any changes in their personal details in IFS ERP. An Oracle job has been written to check any employee updated his/her personal details for every one hour. System will check if any data available in the appropriate table then the system will send an email to the employee with the old values and new values of the employee personal details.
Responsibilities:
Coordinating with onsite manager and functional people to get the requirements for the report and workflow module.
Reviewing the Technical Specification prepared by the developer based on the Functional specification.
Developing the jobs to Load the data from CSV file.
Developing code for the reports and workflow using Oracle PL/SQL and designing the report layout using Crystal Report XI tool.
Reviewing the code developed by the developer and releasing the reports for functional testing.
Coordinating with team members while fixing the issues.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Involved in data loading using PL/SQL and SQL*Loader.
Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Windows XP.
Project Name: SMS Enhancement – Product Transaction Limit (FLEXCUBE)
Client: OFSS, INDIA
Role: Oracle PL/SQL Developer
Duration: Aug’ 08 – Jun’ 10
Description:
Flex cube is one of the leading banking products. Security is the major part of the banking product system. This project is used to set a limit for various product transactions. If the transaction limit exceeds the maintained limit then the system requires multiple levels of authorization for that transaction. The level of transaction will get vary depending up on the limit and the level of authorization maintained for the product.
Responsibilities:
Preparing DS (Design Specification), UTP (Unit Test Plans) as per the RS (Requirement Specification), FS (Functional Specification) provided by the Business Analysts.
Responsible for assuring the Software Development by developing modules assigned in Flexcube using RAD TOOL, PL/SQL
Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Involved in the continuous enhancements and fixing of production problems.
Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Environment: Oracle 10g, SQL * Plus, TOAD, RAD, SQL Developer, Windows XP.
Project Name: WITH HOLD TAX FOR US CUSTOMER
Client: Citibank, INDIA
Role: Oracle PL/SQL Developer
Duration: Jun’ 06 – Jun’ 08
Description:
Citibank is one of the leading banks worldwide, have developed many enhancement in the existing retail bank system, this project is to deduct tax amount from the interest applied for the deposit of all the USA customers.
Responsibilities:
Preparing DS (Design Specification), UTP (Unit Test Plans) as per the RS (Requirement Specification), FS (Functional Specification) provided by the Business Analysts.
Developed the code using Pro*c, unix (vi editor) and PL/SQL.
Involved in the continuous enhancements and fixing of production problems.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Environment: Oracle 9i, SQL * Plus, JSP, Java,TOAD, NAPT, PL/SQL Developer, PRO*C. Unix (Vi editor).
Contact this candidate