Summary

Self-motivated, results-driven developer highly experienced in: Oracle PL/SQL in UNIX environment, as well as MS environment. SQL database code optimization, problem solving, systems analysis and development throughout systems development life cycles, business requirements analysis, data migration and project/team leadership. Guided the successful and timely implementation of many mission-critical projects and tasks of varying sizes and sophistication.

Key Areas of Experience:

• Oracle v7.3 through Oracle 10g
• Stored Procedures, Functions, Packages
• Packages and Triggers
• Analytical SQL functions
• UNIX Korn Shell scripting
• TOAD v9.0
• SQL-Loader
• MS Powershell
• SVN Code Management
• Business Requirements Development
• Systems Analysis and Design
• Software migration and deployment
• Global team coordination
• Systems Development Life Cycle

Professional Experience

Confidential

Software Developer

• Enhanced the mission critical Daily Sales processing system. Upgraded table's structures, views, procedures and functions to support dozens of additional metrics.
• Improved the Manpower Hours Tracking System to better record technician jobs, tasks and hours. Improved performance of this system by reducing the job run time of the process from 50 minutes to 12 minutes.
• Created enhancements for the Data Warehouse Management system. This system helps manage, organize and categorize data base objects used within the data warehouse system.
• Produced multiple extract files or 3rd party vendors using FTP, SFTP and GPG to securely transfer encrypted/decrypted files.
• Developed advanced Oracle objects such as Materialized Views, Views, Type, and Collections.
• Developed and enhanced objects using analytical SQL functions such as Rank, Dense Rank, Sum and Row Number.
• Constructed Sales Activity data loads and corresponding views, joined with dimension tables to be used by the business users.
• Assisted in real-time error handling and resolution to support Data Warehouse and Finance systems.

Confidential

Software Developer

• Assembled a process to integrate PKMS PIX perpetual inventory transactions into the RMS Retail Management System for the DC Transition Project. This process validates incoming transactions and handles the creation/update of ASN's, creation/update of Appointments, Receipts, Receipt Adjustments and Inventory Adjustments.
• Created custom database triggers on several RMS base tables to support newly instituted Dressbarn EDI functionality. This will allow new and updated orders to be transmitted to the EDI clearing house via the EDI-850 extract file.
• Constructed a store distribution extract file to interface Allocation data to the warehouse management system. This interface will allow the warehouse to allocate product to the Dressbarn stores.
• Developed Warehouse Transfer, RTV and Store Packaway extracts to interface to the PKMS warehouse management system.
• Enhanced, maintained and supported project code during the critical project deployment period and continue to maintain ongoing support of project applications via real-time fixes and reprocessing of PIX inventory transactions.
• Guided the Business Analysts on an ongoing basis with reconciling inventory positions between RMS and PKMS.
• Developed full ETL as well as monthly delta ETL for Size Scaling application accessing the data warehouse as the data source.
• Produced daily ETL using data warehouse for all allocated items to be used for reporting tools.

Confidential

Programmer/Analyst

• Developed proficiency in ORACLE 10g, SQL, PL/SQL and SQL Loader, SQL Plus, TOAD, awk and grep in a Linux/Unix environment creating Korn Shell and PL/SQL scripts.
• Coordinated a team of associates to support and maintain an Oracle Data Base containing over 100 high-visibility, mission critical decision support tables and systems.
• Enhanced more than 300 existing Korn shell and PL/SQL scripts for performance tuning, additional job logging, thorough error handling and adding job restart logic where required.
• Piloted teams of off-shore and on-site consultants through project life cycle processes: business requirements, spec reviews, unit test plans, development, and implementation.
• Coordinated activities of several associate teams across many different IT and business groups for several major Store/DC Realignments projects, in order to complete all tasks on time and within budget.

Confidential

Consultant FYI Solutions Software Developer

• Generated PL/SQL packages to migrate data from existing mainframe based Customer Service system to a new client-server system built on ORACLE v7.3.
• Responsible for creating and maintaining PL/SQL packages serving to keep third party companies data systems synchronized with enterprise systems for support and help desk systems.

Confidential

Software Developer

• Worked on several development projects using Oracle 7.1, SQL, SQL Plus, PL/SQL ,Oracle Forms, and Oracle Reports.
• Project Leader for the development, implementation and subsequent support of various DLB Clinical trials Application systems.

Confidential

Programmer

• Assembled and managed a team to enhance and stabilize existing Sales and Inventory systems which includes many large critical applications as well as dozens of sub-systems.
• Designed, developed, implemented, and maintained enhancements of many Sales and Inventory system programs using Korn Shell scripts, Oracle 7.3 SQL, PL/SQL scripts and SQL Loader in a UNIX environment.
• Developed, supported and maintained online and batch systems using the Unisys A-Series Mainframe via DMSII Database, Unisys Cobol and Xgen Batch programs and Screen Designer.