Post Job Free

Resume

Sign in

Developer Oracle

Location:
United, PA
Salary:
$75
Posted:
April 03, 2020

Contact this candidate

Resume:

Karthikeyan Shanmugam

Unix, Sr. Oracle Developer, Oracle Forms/Reports

adcly0@r.postjobfree.com

Ph: +1-732-***-****

Result driven technology professional with 14+ years of experience in design, development using Object Oriented Technology, testing, deployment, maintenance and production support. Development experience spreads over Parts Distribution, Inventory Control Management, Insurance, Human Resource Management and Fixed Asset Management sectors using UNIX, Oracle PL SQL, Pro*C, Oracle Forms and Oracle Reports. Familiarity with complete SDLC project life cycle from feasibility of projects.

Technical Skills:

•RDBMS: Oracle 9i, 10g, 11g and 12c, MS Access

•Languages: SQL and PL/SQL, Proc*C

•GUIs: Form6i/9i/10g/11g/12c, Report6i/9i/10g/11g/12c

•Utilities/Tools: SQL* Plus, SQL*Loader, Visio, SQL Developer, Putty and WinSCP

•OS: Windows 10/7/XP/NT/98/2000 and Unix/Linux

Education:

B.Sc., Computer Science from Tagore Arts and Science College affiliated by Pondicherry University (1998 – 2001)

M.C.A from Rajiv Gandhi College of Engineering and Technology affiliated by Pondicherry University (2001 - 2004)

PROFESSIONAL EXPERIENCE

Ford Motor Company, NJ Nov 2018 – Till date

Sr. UNIX scripting and Oracle PL/SQL Developer

Performed requirement collection, analysis and design documentation for the trading utilities supporting manufacturing functionalities. Designed and developed PL/SQL packages/stored procedures/functions/triggers to enhance the system User Entitlements, Trading Workflows as per business requirements.

Designed and developed SQL*Loader scripts to load data-files of various formats. Created SQL and PL/SQL scripts to clean and process data for various compliance rules, UBS utilities, user reports and interfaces with other applications such as Accounting, Corporate Actions, Risk Monitoring.

Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.

Involved in the migration and resolution of issues of the following Oracle 11g Forms and Reports applications to 12c.

Experience using configuration in 11g/12c Web Logic E-business suite such as environment file readiness, index page changes in https server.

Wrote Oracle PL/SQL procedures for data migration and validation.

Created database objects like tables, views, materialized views, indexes, procedures and packages using Toad and SQL* plus.

Developed, tested and optimized SQL queries and PL/SQL code for migration of large database files to target Data Warehouse database.

Created records, tables, collections (nested tables and arrays) for improving BULK Query performance by reducing context switching.

Analyzed Oracle PL/SQL code for optimization. Performed SQL and PL/SQL tuning using EXPLAIN PLAN and using hints to direct the optimizer to choose an optimum query execution plan.

Clear understanding of Agile Scrum development methodologies.

Performed data analysis and modeling for client-server RDBMS.

Extensively worked on storing and managing JSON data.

Designed and developed Unix shell script to perform data loading, BOD setting of systems, intra-day processing and reporting. Designed and developed PL/SQL packages/triggers to handle database tasks. Developed Autosys JIL scripts for scheduling. Created Unix shell scripts for Interface tool to run sessions.

Performed day-to-day ETL progress monitoring and maintenance, for trade data loading and processing in data warehouse schemas.

Performed initial implementation and production support for Order Management System and subsequent upgrades.

Used UNIX Shell scripts for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.

Environment – Unix/Linux, Oracle Forms, Oracle Reports, Oracle 11G / 12C databases, PL/SQL and Shell scripting, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader, TOAD, and Windows 2010

Nike, US Nov 2013 – Oct 2018

Sr. Oracle Developer

Performed back end Oracle PL SQL development for NCAT System. This content management system has replaced existing Bloomberg system of gathering, processing and storing/retrieval of financial data in the form of News, Company related information as well as company’s financial and other documents.

Performed database modeling, design and development of Profiles, Fundamentals sub-systems. Developed PL SQL stored procedures/ packages/ triggers to support business logic and front-end processes.

Involved Upgrading Oracle Forms and Reports

Developed a Custom Package which parses and compares fields from a XML using DBMS_XML.

Responsible to define the concurrent programs and their executables.

Carried out registration of concurrent programs and request sets.

Developed custom D2K forms using form builder.

Developed reports using report builder.

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

Designed and developed SQL*Loader scripts to load data-files of various formats. Created SQL and PL/SQL scripts to clean and process data.

Created of database objects like tables, views, procedures and packages using Toad and SQL* plus.

Developed, tested and optimized Oracle queries and PL/SQL code.

Created records, tables, collections (nested tables and arrays) for improving BULK Query performance by reducing context switching.

Analyzed Oracle PL/SQL code for optimization. Performed SQL and PL/SQL tuning using EXPLAIN PLAN and hints.

Environment - Oracle 11g/12c database, Unix, Oracle Forms, Oracle Reports, PL/SQL scripting, Oracle PL/SQL stored packages/procedures/triggers, SQL Developer.

Sony DADC, Austria Aug 2010 – Sep 2013

Sr. Oracle Consultant

Involved in Analysis, Design, and Coding phases.

Preparation of Technical specification based on Functional specification.

Defect fixing / Test case Preparation.

Development or enhancement in backend Procedures / Functions / Packages / Triggers.

Involved in designing Flow charts, Data flow Diagrams etc. for the business documents and categories using Microsoft VISIO.

Designed and developed Oracle Forms Reports using Forms11g/10g/6i and Reports11g/10g/ 6i Including Forms based on stored procedures.

Development or enhancement in Oracle Forms, Reports and SAP BO report.

Implementing the customized ERP application developed in ORACLE/PLSQL and D2K.

Interaction with onsite coordinator on weekly basis. Allocation of work to team members and interaction with onsite coordinator.

Environment – Unix/Linux, Oracle 11G databases, Unix, PL/SQL and Shell scripting, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader, TOAD.

Omnitech Systems, Bahrain June 2009 – Feb 2010

Sr. Oracle Consultant

As an Application developer, my key role is to understand the requirements and to develop the business cycle depends on the requirements.

Analysis of existing application.

Based on the requirement, modification as to be created, modified in Packages, Procedure, Functions, views and Triggers.

Customization in Forms and Reports and Unit level testing.

Review the Client specification.

Environment – Oracle 11G databases, Unix, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader, TOAD.

3i Infotech, India May 2007 – Apr 2009

Software Engineer

Developed hourly reports for price and quantity variations between the order placed by the customer and the order filled by the inventory system.

Developed various EDI interfaces using Pro*C and embedded PL/SQL stored packages and procedures. Also developed Unix and AutoSys job-scheduling scripts for the same.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL* plus.

Re-engineering the application.

Delivery the scheduled date.

Co-coordinate with team members and achieved the targeted goals.

Environment – Oracle 11G databases, Unix, PL/SQL and Shell scripting, Oracle PL/SQL stored packages / procedures / triggers, SQL Loader.

Roadmap IT Solutions, Pondicherry Oct 2004 – May 2007

Sr. Software Engineer

Instrumental in backend UNIX, Oracle PL/SQL, Pro*c development for the business cycle of Assets sharing by departments.

Performed requirement collection, analysis, Design, development of database interfaces for this System, Designed and developed PL/SQL packages/ stored procedures to capture and process incoming data for validation and retrievals.

Developed hourly reports for price and quantity variations between the order placed by the customer and the order filled by the inventory system.

Developed various EDI interfaces using Pro*C and embedded PL/SQL stored packages and procedures.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL* plus.

Used DML and DDL (Data Definition Language) used for creating and modifying tables and other database structures.

Developed, tested and optimized Oracle queries and PL/SQL code.

Created records, tables, collections (nested tables and arrays) for improving BULK Query performance by reducing context switching.

Analyzed Oracle PL/SQL code for optimization. Performed SQL and PL/SQL tuning using EXPLAIN PLAN and hints.

Environment - Oracle 11G database, Unix, PL/SQL scripting, Oracle PL/SQL stored packages / procedures / triggers, TOAD.



Contact this candidate