TECHNICAL SKILLS:

Application programmer, System Engineer with over 16 years of experience in: Oracle 9i, 10g, 11g, PL SQL, SQL,TOAD, Sql Loader, Oracle Data Warehousing Unix utilities, Korn Shell Scripting, Linux, vi editor, SVN Data Warehousing, Cognos, Report Studio, Query Studio, OLTP SQL, Cobol/Microfocus Cobol

HARDWARE: Oracle Solaris, Red Hat Linux, IBM PC’s, AIX, HP9000

PROFESSIONAL EXPERIENCE:

Oracle, Linux, Excel Developer, Consultant

Confidential, Houston, TX

• Designed and developed database packages, procedures, functions and triggers in Oracle 11g databases.
• Made enhancements and applied defect fixes in the test shipping system. RDM functionalities: Distribution, Picking, Inventory Control and Invoice. These changes were developed using Oracle sql, Linux shell scripting, PL/SQL, Excel 2010 and TOAD.
• Created Technical Design documents for major enhancements and attended Technical Design Reviews with the owner of the company, gained comprehensive experience in SDLC (Software Development Life Cycle)
• Improved performance of the Oracle programs by retrieving the Execution plans, creating new indexes, rebuilding indexes, introducing hints LEADING(tablename), SORT MERGE JOIN, HASH JOIN, INDEXED,etc. Partitioned tables by Range and by List, used analytical functions RANK, DENSE RANKRATIO TO REPORT, OVER PARTITION BY.
• Heavy use of Linux utilities including but not limited to awk, sed, grep, sort, mailx, mutt and vi editor.

Oracle developer

Confidential, New York, NY

• Participated in enhancement of Customer Acquisition Tool (CAT) application, using Oracle 11g, sql Navigator, Unix Oracle Solaris.
• Created dozens of new and modified existing Oracle stored procedures, Functions and Packages. Created new tables, indexes, sequences, performance tuning, used analytical functions. Introduced new Medicare option for customers, who shop for Family coverage, introduced options to buy Medicare coverage online, by using VISA, MASTERCARD, without mailing the checks
• Programs adjusted to include affordable care act requirements.
• Performed system and unit tests, using sql navigator Run PL SQL Menu, which allows to enter Input parameters in Text boxes and to check the output parameters from the PL SQL stored procedures after execution.

Oracle /Unix AIX developer

Confidential, Dallas, TX

• Work as an Oracle 11g/ Unix AIX developer for major insurance company, supporting Drugs Utilization Review system.
• Developed new and maintained existed Oracle Packages, Procedures, Functions, Using PL SQL Developer tool and sqlplus.
• Deleted data from children tables, to enable foreign keys, that were disabled previously.
• Applications are running on Unix IBM 6000 computer, using the cron file.
• Oracle Procedures and packages are called from Unix Korn Shell scripts, that pass parameters to them.
• Support of Acute frequency, Retail To Mail, Brands To Generic, Length of Therapy and other applications.
• Use of Unix utilities awk, grep, sort, mailx and vi editor.

Oracle /Linux RedHat developer

Confidential, Pittsburgh, PA

• Worked as a Programmer Analyst to support Medicare Part A System that includes creation of new Linux scripts, Oracle 11g sql and pl sql.
• This new system includes claims processing for providers that are located in CO, NM, OK, TX, AR, LA and DE.
• The programs are to be transferred from Confidential to Confidential .
• Designed, documented, wrote and debugged 100’s of Oracle scripts, stored procedures and functions required to complete my various assignments for Confidential .
• Documented, recommended, and implemented effective steps to improve database performance and partitioning of the tables.
• Wrote Linux scripts that insert mainframe files into Oracle tables using sqlldr,conventional and direct
• Paths. Direct path: disabled integrity constraints, prior to loading of data (Not Null, Unique, Primary
• Key). Differed Index Maintenance, using SKIP INDEX MAINTANANCE=TRUE on the sqlldr command line.
• Checked Statuses of the Constraints by querying view USER CONSTRAINTS
• Checked log file after loading of data
• Re - enabled all constraints, by using ALTER TABLE … ENABLE CONSTRAINT …
• EXCEPTIONS INTO ...
• Loaded data, using SQL MERGE, by using “when matched” and “when not matched” options
• Executed Oracle sql, pl sql, Linux utilities.
• Worked on improvements and new requirements for various functions of the following applications: Benefit Integrity System, Appeals Application, Return to Provider, Medical Review Part A, Inspection Assessment.

Oracle Developer, Tester

Confidential

• Wrote and Tested Oracle sql for Citywide Payments and Receivables Repository Project (CPRR ), STARS ( Summons Tracking Accounts Receivable System ).
• These systems were an integral part of the Department of Finance and tracked Red Light Violations, Parking and Bus Lane Violations, Summonses.
• There were about 14 millions active summonses in Stars.
• Performed comprehensive system test, including the validation of the input data that was loaded by Informatica program into the Oracle database.
• Heavy use of Oracle 11g sql, Sql Loader utility and TOAD.
• Performed validation of the data that was inserted into the CPRR database according to the ETL spec. Created and executed test cases, uploaded the results into Share Point and Rally.

Linux Developer

Confidential, Pittsburgh, PA

• Modified existing Linux scripts due to Lotus Notes replacement with Outlook.
• Assignment included processing files that were previously sent as attachments that were gziped and moved to a shared drive.
• Hardcoded e-mail addresses were replaced with the e-mail addresses found on the test servers Oracle database.
• Heavy use of Linux utilities including but not limited to awk, sed, grep, sort, mailx, mutt and vi editor.

Oracle developer / Consultant

Confidential, Charlotte, NC

• Oracle developer in Merchandising group for Confidential, a major Supermarket Chain.
• Wrote Oracle sql and PL SQL to process vendor products, their description, vendor and store locations, wrote new and updated existing Oracle stored procedures, Functions and Packages.
• Created jobs in Control M that submit scripts for execution on Unix. Tuned applications by retrieving their execution plans.
• Created new and changed existing Korn Shell scripts. These scripts contained Oracle sqlplus commands to retrieve the data, produced and ftp’d the reports to other unix or windows servers.

Consultant

Confidential, Lexington, MA

• Wrote Oracle SQL, PL SQL stored procedures, functions and packages for the Retail Automation System of the Collective Brands Sales Company, OLTP.
• These programs created output files that were transmitted from OMNIA to the JDA system to compare the sales data in both systems (order numbers, billing dates, sales prices, shipment dates, shipping addresses, returns, etc).
• Created Unix Scripts on AIX which archived and deleted files, based on the retention periods.
• Used awk, grep, find, cat utilities and the vi editor.

Oracle, Sybase/PL SQL/ UNIX developer

Confidential

• Created Oracle 10g sql, stored procedures, triggers, packages and functions. Application calculated Universal Connectivity Charges for Confidential &T customers. These charges have been inserted into Oracle tables and written into files for transfer to a mainframe for further processing.
• The batch part of the project was developed using PL SQL and Datastage, an ETL tool. Supported batch applications running on unix Sun Solaris servers using, Oracle, Sybase databases.
• Tuned up Oracle 10g database, partitioned tables, created indexes, materialized views to pre-store results and refresh them Confidential set intervals, used different optimizer modes: FIRST ROWS n, ALL ROWS, hints for optimizer: FIRST ROWS(n), ALL ROWS, ORDERED, LEADING(tablename), SORT MERGE JOIN, HASH JOIN, INDEXED,etc, retrieved execution plan and runtime statistics by executing DISPLAY procedure from DBMS XPLAN package.
• Provided production support, used Remedy tool, traced and solved production problems through log files using different unix utilities (awk, grep, sed, sort), vi editor.
• Users opened tickets in Remedy system, assigned the severity ( from 1 to 4 ), provided the error logs.
• I solved the tickets by investigated the problems, changing sql or Unix scripts, closed tickets with the user permission, documented the resolution, worked as a Tier 3 support person for GCP systemwhich was running on Sun Solaris servers and used Oracle and Sybase databases, using cron-tab utility. Performed production support by solving tickets from Remedy system.Attented Datastage Training classes.
• Problem troubleshooting, root cause analysis and facilitation of both short and long-term solutions.

Confidential, New York, NY

Programmer/Analyst

• Participated in the development of moderate to complex applications that process automated bill payments and claims. Wrote new and maintained existing programs using Microfocus Cobol/AcuCobol, SQL.
• Converted programs from UNIX and DOS operating systems to Windows NT. Development has been performed on Windows NT and UNIX operating systems.

Confidential, Queens, NY

Consultant

• Maintained and supported Warehouse Management System, designed and provided easy to use Purchase Order entry screen that will enable users to create purchase orders and effectively communicate with LIRR suppliers.
• WMS's purchase orders supported both one-time deliveries as well as scheduled or blanket deliveries.
• Allowed to coordinate drop shipments to other service providers/suppliers.
• Created Customer Service Reports, Inventory Reports, Planning Reports, Production Reports, and Financial Reports.
• Improved customer service levels. Data accuracy and inventory accuracy both improved. Mistakes are pushed to an absolute minimum.
• Deliveries are timely, shipments are accurate and customers stay satisfied. This results in avoided the very costly problem of having limited supply of the parts in the warehouse.
• Microfocus Cobol/CICS is implemented as a front end, Oracle 8 as a back end, UNIX (AIX version 4.3.2.0) as an operating system.

Confidential, Monvale, NJ

Consultant

• Maintained and supported Time Detail System, for major accounting Company (KPMG LLP), this system was written in MicroFocus Cobol 2.
• Heavy user support based on the implementation of the Remedy system. Used Microfocus workbench to write the source code, Animator to debug programs, Workbench File Loader (WFL) to recover corrupted indexed files and to convert data files from EBCDIC to ASCII format.
• Provided QA for Y2K compliance of Time Detail System programs.

Confidential, Mahwah, NJ

Programmer

• Wrote programs in MicroFocus COBOL II, Cobol 2, APS, C with SQL to process data from various tables using Watch, Step, setting conditional Breakpoints and Zoom. Both character based and GUI based versions are implemented.
• Maintained DB2 data using SQL Insert, Update and Delete statements for embedded and interactive formats.
• Created and maintained hundreds of programs for Automotive and MaxiShip applications.
• These programs were written using the Client/Server Architecture; tested and ran with the workbench animator.