Pl Sql Oracle Financials
Resume:
GENE KAZAKISH
********@*******.***
Northbrook IL 60062
SUMMARY
Information System Developer with a proven background in Oracle Applications - Financials/Manufacturing modules and custom development. A self-starter with excellent troubleshooting and problem solving skills experienced in all phases of system development, from analysis and design through construction and implementation under multiple platforms. Areas of expertise include Oracle Financials, Oracle Databases, Oracle Forms and Reports, Oracle Discoverer R10 and 11.
Operating Systems: UNIX, Linux, WINDOWS
Applications: Oracle Financials/Manufacturing r.10.7/11/11i, EMPAC
Languages: SQL, PL/SQL, C/C++, JAVA 2, PowerBuilder 4, SQA Basic
Design Tools: Forms 4.5/6i/9i/10g/11/12, Reports 2.5/6i/9i/10g/11/12, Designer 2000, TOAD, PL\SQL Developer, BI Publisher, Discoverer version 10, 11, Developer 2000 (Forms 4.5, Reports 2.5), SQL Loader, QR Repots
Databases: Oracle 7.x, 8i, 9i, 10g, 11g, 12, 19c, MS SQL Server 2005
PROFESSIONAL EXPERIENCE
M&R Printing, Chicago, IL 6/2013 – present
Oracle PL/SQL & EBS and Forms, reports Developer
●Lead Developer for data maintenance and Oracle Forms packages and procedures.
●Primarily develop and maintain a library of Oracle Forms using Forms
●Migrated Oracle Forms to Oracle 11g.
●Work onOracle (INV, BOM, PO, OE, GL, AP, AR modules)
●Create and maintain PL/SQL procedures, packages, functions and procedures.
●Creating and modifying various reports and forms for customers using Oracle 6i and 11g Developer tools
●Converting the business requirements into Technical requirements for Oracle Applications ERP and get them reviewed by architect.
●Supporting applications and upgrade and testing of Forms and Reports and various PL/SQL packages, procedures and functions while various utilizing Windows Servers and Oracle 19c databases.
●Developed DDL Scripts for Database Objects like Tables, Views, synonyms, sequences, Indexes etc.
●Created complex packages, procedures, functions, views, materialized views using Oracle SQL and PL/SQL.
●Responsible for coding and unit testing
●Troubleshooting and resolving issues that occur in Oracle Forms and PL/SQL components of the ERP system
●Maintain interfaces between Oracle EBS Applications and custom applications.
●Work closely with end users, leadership, and stakeholders to get requirements and translate them into functional database operations
Rogers & Hollands, IL 4/2009 – 6/2013
Oracle EBS Developer
R12 and R 11i Oracle (INV, BOM, PO, AP, AR modules)
•Developed and maintained custom and standard reports utilizing PL/SQL, TOAD, Oracle Forms 10g / Reports 10g and BI Publisher. Linux and Windows environments. Worked on R12 upgrade process.
•Migrated ORACLE Forms, Reports, PL/SQL.
•Maintained stored procedures, functions and packages (to transfer and process data, build reports etc.).
•Customized Forms and Reports for Oracle EBS Applications.
•Maintained/worked on issue resolution for INV, BOM, PO, AP, AR modules in EBS
•Created personalizations in Oracle Apps.
•Customized BI Publisher reports.
•Created BI Publisher reports rendering HTML formatted data
•Created reports using Oracle Discoverer.
Mesirow Financial, Oracle PL/SQL – Chicago, IL 2/2008 – 3/2009
Oracle Report/Forms Developer
Environment: ORACLE 10G, UNIX HP, Forms 9i, Reports 9i, BI Publisher reports
•Maintained existing application.
•Developed custom forms and reports using Oracle, BI Publisher report.
•Responsible for writing UNIX shell scripting using redactor VI.
•Worked with user to take requirements and create technical documentation.
•Created PL/SQL procedures and packages to transfer and process data.
Allstate Financial - Northbrook IL 4/2006 – 1/2008
Oracle PL/SQL- Oracle Report/Forms Developer
Environment: ORACLE 10G, UNIX HP, Forms 10G, Reports 10G, SQL Server 2005
•Created and maintained application to validate errors on reimbursements.
•Developed and maintain custom forms and reports using Oracle Forms/Report 9i.
•Responsible for writing shell scripting to automating processes.
•Worked with user to take requirements
•Created PL/SQL procedures and packages.
Chicago Stock Exchange, Chicago, IL 11/2004 – 3/2006
Oracle PL/SQL- Oracle Report/Forms Developer
Environment: PL/SQL 9I, UNIX, Forms/Report 9i
•Enhanced and maintained the in-house Integrated control validation system using PL/SQL and Unix Shell scripts.
•Created PL/SQL packages for validation of transactions in CSE
•Created PL/SQL procedures and packages.
•Tuned applications for better performance
•Manually tested application.
•Creating custom forms and reports using Oracle Forms/Report 9i.
AMG, Arlington Heights, IL 6/2003 – 11/2004
Oracle PL/SQL- Oracle Report/Forms Developer
Environment: PL/SQL Oracle Report/Forms 6I, UNIX,Oracle Applications 11i Oracle (PA,GL modules)
•Responsible for data and application conversations.
•Created PL/SQL procedures and packages.
•Developed custom forms and reports using Oracle Forms/Report 6i.
•Responsible for writing shell scripting.
•Used SQL Loader for data migration.
IMC GLOBAL, Lake Forest, IL 10/2000 – 05/2003
Oracle Application Developer
Environment: Oracle Applications 10.7/11i, PL/SQL, Oracle Forms 6i/9i, Oracle Reports 6i/9i, SQL*Plus, SQL Loader, UNIX.
The largest global producer and supplier of concentrated phosphates and potash for the Agriculture, Feed, and Pharmaceutical industries. Company has a high variety of integrated applications and currently in a process of conversion to Oracle Applications R.11i.
•Participated in the creation and implementation of interfaces between Oracle Application PO and EMPAC application; custom Forms and Reports for Oracle Application 10.7; customized standard applications reports and development of new reports using Reports 6i/9i.
•Created PL/SQL procedures and functions to be included into custom pll.
•Developed custom forms to achieve user personalization.
•Developed and customize SQR Reports for EMPAC application.
•Designed and coded interfaces for data integration using Pl/SQL and SQL Loader
•Analyzed and troubleshot application problems.
•Designed data conversion programs
•Prepared unit level test plans and performed the tests.
•Tuned applications for better performance.
SBC AMERITECH, Arlington Heights, IL 01/1999 – 10/2000
Oracle Application Developer
Environment: Oracle Applications 11, PL/SQL, Oracle Forms, Oracle Reports, SQL*Plus, UNIX
A global leader in communications with strong, fast-developing growth platforms in the industry's most promising segments - data, long-distance and wireless.
•Personally responsible for resolving problems in Contract Ledger (developed for the Company), Purchasing, Order Entry, and Inventory - rel.11.0.
•Customized standard reports for various Oracle Financials and Manufacturing modules.
•Created and maintained custom reports for different modules, including GL, AP, AR, PO, OE and Inventory.
•Created and maintained triggers, procedures and functions.
•Maintained EDI processing.
•Moved data from legacy system to Oracle using SQL*Loader.
•Created reports using Oracle Discoverer.
EDUCATION/PROFESSIONAL TRAINING
B.S. in Computer Science, National Technical University of Ukraine, Kiev, 1993
Training in Oracle Classes in Reports 9i, 2003
Training in Oracle Classes in Designer 2000 v2.1, 1998
Contact this candidate