Oracle Developer

Sukhwinder Singh

** ********** **. *******, *** *W8, ON

Contact #: 647-***-**** E-mail : acrm73@r.postjobfree.com

PROFESSIONAL SUMMARY

6+ years of Expertise in Oracle ERP Development using Oracle 6i/ 11g Forms & Reports, PL/SQL and Database Development, OBIEE, Data Warehouse and 8+ years of Strong SQL, PL/SQL Experience using TOAD for Schema Comparison, SQL *PLUS, SQL*LOADER and functions of OOPS methodology.

Strong Experience to upgrade an existing application [Oracle 6i Forms] to the Web [Oracle 11g Forms], and enhances the capabilities of Web based Oracle Forms applications using Webutil and PJC/Beans.

Bachelor’s degree in Computer Science and Engineering and Postgrad in Database Development (Oracle 11g & SQL Server 2012) from Humber College and attained Honours Degree.

Good Functional and technical experience of Oracle 11i and EBS R12.1.1 ERP (P2P & O2C Cycles) i.e. PO, INV., OM, Quality, WIP, Projects, Service, AP, AR, GL, FA, Cash management & Core HR Module in Manufacturing Organizations.

Extensive experience in requirements gathering, Gap Analysis and documentation during all phases of software development cycle/ SDLC as an Agile Practitioner.

Strong interpersonal and communication skills, Excellent Problem Solving, Time and Team Management Skills, Strong leadership qualities and ability to Work on Multiple Tasks and fast paced Environment.

Seeking a role of a Business Analyst / Oracle Forms and Database Developer.

TECHNICAL SKILLS

Databases

& Database Tools

ORACLE 12c, 11g/10g/9i, SQL,PL/SQL (Stored Procedures, Functions, Views, Cursors, Triggers), Oracle Forms, Reports, Fusion Middleware / Weblogic10.3.3, OBIEE, TOAD 8.6 / 9.5, Oracle Discoverer, RMAN, ASM, OEM, Data Guard, SQL *Plus

SQL Server 2012(T-SQL), MySQL, MS Access

Data Warehousing OWB, AWM (ETL, STAR/SNOWFLAKE SCHEMA, Dimensions, partitioning, SQL Loader/ SQL*LDR, Materialized Views.), Informatica Power Centre 9.1, 9.5

Operating System

Oracle Linux, Red Hat Linux RHEL 5.4, UNIX, Windows 98/ XP/ Vista/7.

VMWare Workstation 9.0.2, Oracle VM Virtual Box.

ERP Solutions

Oracle 6i / 11g Customer ERP Application, Oracle EBS R12 (ver. R12.1.1) & Oracle Apps 11i (ver. 11.5.10.2).

Report Tools

Oracle AWR, Oracle Business Intelligence(OBIEE), Oracle Discoverer 11.1.1

Cognos BI 10.1.1, Oracle Reports Builder (10g); Seagate Crystal Reports 6.0

Scripting & Programming Languages

Shell Scripting (LINUX/ UNIX), JavaScript

PHP, DOM Parsing, Excellent Knowledge of Algorithms & Data Structure

HTML, CSS, CSS3, HTML5, XML, DHTML, XHTML, XSLT, XSD, Apache Server

C/C++, Java, VB.NET, ASP.NET, ADO.NET

Data Processing Tools

MS Office Tools (Word, Excel, Outlook, PowerPoint)

Project Management Tools

Microsoft Project 2010, 2007, MS Visio 2010

EMPLOYMENT EXPERIENCE

Oracle Forms and Database Developer/ Software Developer [June 02, 2014 – Till Date]

Plexxis Software Inc., Toronto Full Time – Regular

An international leader in the ERP Software, Mobile Apps, and Windev Applications Development for Drywall and Wine Manufacturing Companies.

Project: Oracle Forms 6i/11g Development and Conversion from 6i to 11g and Database from 11g to 12c and new enhancements.

Description: Worked in a Team of 8-10 persons to upgrade an existing application to the web, and enhances the capabilities of Web based Oracle Forms applications and Bug fixing & Troubleshooting for 6i and 11g forms.

Role: Oracle Forms and Database Developer.

Job Description:

Extensive experience of up gradation of Oracle 6i Forms application to Fusion Middleware 11g Web Application using Webutil and PJC/Beans and modernization of Oracle Forms.

Strong experience of Reading, parsing, manipulation and writing text, csv, excel pdf, xml formatted files on the client /Application Server.

Experience of using D2k[6i] and WebUtil[11g] to achieve client side integration while running Oracle Forms on the Web and Integration of oracle forms with Microsoft Word, Excel, and Outlook.

Created a Centralized Dynamic Source Code Management Application using Oracle 11g Forms [User and Directory Specific] similar to GIT to control and track the changes, history and versions of Projects under development.

Created and Implemented Dynamic PDF Parser Database Package to fetch data from multi-page invoices from a single or multiple pdf files into the database / Client / Application Server and splitting then into single invoice [Single/Multiple Pages].

Created Unix script for Oracle 11g Forms to run whenever file stamp of any file [*.fmb,*.pll,*.mmb files] in Windows Directory [Forms Source Files Path] changes to compile those files to generate executable file for Linux OS.

Implemented Drag and Drop, File Upload Functions, and Integrated forms with Browser Functions to Store /Move Multiple Files from between the client, application server and database.

Strong Hands on Experience with Oracle Supplied Packages such as UTL_FILE, DMBS_SQL, DBMS_JOB, and PL/SQL Collections and used BULK binding involved in writing database procedures, functions and packages for Front End Module.

Experience in Database Application Development, Query Optimization, Performance Tuning and implementation experience in complete System Development Life Cycle.

Created PL/SQL scripts to extract the data from the database into simple flat text files using UTL_FILE packages.

Changed the look and Feel / modernization of all Oracle 11g forms.

Good experience of Manipulation of Client Side Files and interface with client side C and reading Windows registry information and running Host commands in silent mode on Client machine from oracle Forms.

Excellent experience of implementing ActiveX Controls and PJC / Java Bean Libraries for modernization of forms.

Involved in the continuous modifications, Enhancements, New development, Troubleshooting assistance and fixing of production problems on existing form and code reviews to understand the testing as per change request and maintained it using Agile Software Development.

Dynamic Package Body created to View, Copy, and save files in a directory / Folder using Virtual directory tree in Oracle Fusion Middleware 11g Forms.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error and warning messages in the application.

Configured formsweb.cfg, default.env and Registry.dat Files.

Extensively Used Bulk Collections in Database Cursors for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Modified Packages, Procedures, Functions and Triggers for designing user interface and Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Oracle Database Developer/ Systems Engineer (IT) [April 05, 2010 - June 30, 2012]

Enexco Teknologies, Beumer Group Full Time – Regular

An international leader in the manufacture of cement plants and intra logistics for conveying, loading, palletizing, packaging, sortation and distribution technology.

Project: Oracle EBS R12 (R 12.1.1) Implementation & Support

Description: Worked in a Team of 15-18 persons for the implementation of Oracle Order Management, Bills of Material, Engineering Change, Financials, Projects, Costing, Work in Progress, Planning, Inventory, Purchase, Field Service, Quality, and Core HR Modules on Red Hat Linux RHEL 5.4 OS and IBM System x3650 M2 Server.

Role: Oracle EBS R12 Technical Consultant

Job Description:

Excellent Hands on experience and knowledge of SQL, PL/SQL, ETL, SQL*Loader, Oracle Discoverer, Oracle Forms Oracle Reports /BI Publisher and large volume data processing in a time critical window.

Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters, and Program units by using PL/SQL procedures and functions of OOPS/ Object Oriented Development methodology

Created menu, responsibility & Implementation of custom forms to CRM system

Created job using DBMS Scheduler to Schedule database procedure every night to generate Auto Purchase Order for Items whose In-Stock Quantity is less than Minimum level. Separate POs generated for each Supplier. After PO Generation Mail scheduled to Purchaser for Final Approval.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Strong Functional and technical experience of P2P & O2C Cycles i.e. PO, INV., OM, Quality, WIP, Projects, Service, AP, AR, GL, FA, Cash management & Core HR Module.

Analysed data, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.

Good Knowledge of Oracle Database utilities like Imp/Exp, Data Pump, RMAN and TKPROF.

Configured Web Logic Server – Admin Server, Managed Servers, Node Managers and Domains.

Programed in UNIX shell scripts to provide a user interface to Oracle forms and reports.

Extensive experience of scheduling Oracle Database / OS jobs [Procedures to purge temp tables data] using Oracle Scheduler.

Used MS Project to Track Project status and Visio for UML and Class diagrams for document Business Requirements.

Created Cron jobs in UNIX for scheduling file pre-processing.

Pre & Post Production troubleshooting exercises, bug fixes, raising TAR's/ Service Requests on Oracle Meta-link and working with oracle support for escalating issues and finding resolutions.

Debugging / Troubleshooting (Identification & Solution for critical technical application problems including those relating to performance, Web-Server (Apache), Concurrent Manager, concurrent processes, Forms, Report, Start-up-Shutdown, Login Issues, Work Flow, and all other Related issues.)

Vast Experience of Oracle EBS R12 Application and Database Cloning using RMAN and manual using tar utility.

Developed Analytical Workspace, Oracle OLAP, Building Analytical Reports, Dimensional design, Business Intelligence presentation Services

Experience of installation, configuration and Implementation of Oracle Business Intelligence Suite (OBIEE).

Developed Oracle database platforms and Data warehouse design

Strong Experience of OLAP Designing, Dimensional Model creation, Partitioning, Tuning, ETL tasks, creating Materialized view, Cubes

DW, ETL, OLAP, Presentation Layer Design and Implementation.

Implemented Oracle Discoverer 11.1.1 with Oracle EBS R12.

Oracle BI dashboards and reports for various functional groups within the organization.

Worked on Business Intelligence platforms for transition back and forth from E/R modelling to a fact-dimension model with ease.

Business Intelligence: Building Analytical Workspace, Oracle OLAP, Building Analytical Reports, Dimensional design, Business Intelligence presentation Services

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Performance Tuning for Oracle RDBMS using explain Plan and HINTS.

Oracle Forms and Database Developer/ Systems Engineer (IT) [August 18, 2009 - March 31, 2010]

Indian Sucrose Ltd, Yadu Group Full Time – Regular

One of the world’s Top Sugar renowned exporter, manufacturer and supplier of premium quality Sugar.

Project: Oracle Apps 11i (11.5.10.2) Implementation and Support

Description: Worked in a Team of 5-7 persons for the implementation of Oracle Financials, Cash management, Inventory & Purchase Modules on Red Hat Linux RHEL 5.4 OS and IBM System Xeon server 346 & 366Server.

Role: Oracle Apps 11i Technical Consultant

Job Description:

Created Stored Procedures, Cursors, Functions, Packages, Triggers, Sequences and Dynamic SQL

Worked on PL/SQL cartridge for an application logic stored in databases as stored procedures.

Wrote Oracle Technical Documentation and Drafts for user assistance.

Troubleshooting and Bug-fixing of Oracle ERP Forms by raising SR on Oracle Support.

Conducted CRP and UAT on the development and enhancements using multiple testing scenarios/ parameters on wide variety of platforms to ensure that all business requirements are met.

Technical Support for Order-to-cash / Procure-to-Pay / Supply Chain Management / Inventory business processes.

Implemented LINUX/ UNIX operating systems, middleware and other technologies for building and maintaining multi-tiered enterprise business solutions.

Proactive performance monitoring measures (using ADDM, AWR) to ensure SLA performance goals.

Applied RDBMS patches, one-off patches, mini pack patches and family pack patches.

Oracle BI dashboards and reports for various functional groups within the organization.

Worked on Oracle cache package contains functions and procedures to improve the performance of PL/SQL web applications.

Created Shell Scripts and Unix Cron jobs as per requirement, maintained the existing scripts and administrated the Cron entries

Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.

Oracle Forms and Database Developer / Associate Engineer [June 02, 2008 - August 14, 2009]

Apple Computer Education Centre Full Time – Regular

Project: Office Automation Implementation & Support [Oracle Forms 6i and Oracle Database 9i]

Description: Worked in a Team of 3-5 persons for the implementation of on Windows Server 2003 OS.

Role: Oracle Database Developer

Job Description:

Designed & Developed application using Oracle 6i Forms and Report Builder.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Deployed reports on Reports Server and troubleshooting Reports Server

Conducted unit testing and helped resolve issues and enabled bug fixes by development team.

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

Test case/data preparation, execution and verification of the test results.

RMAN Backup & Recovery, Performance Tuning and Maintenance of Database Instance.

Designed Company website used ASP.Net, Php and HTML.

Maintained other software coded using VB.Net, C#.Net/C-sharpe.Net and Java.

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

Monitored and Tuned database performance, Concurrent Manager, SQL Statement Performance, Network Performance, snapshots.

EDUCATION

Post-Graduation in IT Solutions – Database Development [September 2012 – May 2014]

Humber Institute of Technology and Advanced Learning, Canada Full Time – Regular

Appreciation Letters from Honourable Dean of Humber College, Toronto Canada for achieving good Academic Record in Information Technology Solutions – Database Development (Oracle).

Successfully completed Capstone Project on ERP system using Oracle 10g forms, Oracle 10g Reports, Oracle 11g database and PL/SQL for Merry Tunes Inc.

Successfully completed Health and Safety Workshop help for Student Workers of Humber College on February 14, 2014.

Bachelors of Technology - Computer Science & Engineering [August 2004 – June 2008]

Guru Nanak Dev University, India Full Time – Regular

Runners up in technical event (Programming using C++ language) of Tech hunt 2005 organized at Guru Nanak Dev University, Regional Campus, Jalandhar.

Won Academic Scholarship Twice during Engineering from Guru Nanak Dev University, Amritsar.

Senior Secondary School (10+2) [April 2003 – May 2004]

Army School Unchi Bassi, India Full Time - Regular

Won Inter Army School Basketball Zonal Tournament (North India) in 2003-2004.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate