SUMMARY:

• Dedicated IT professional with a wide range of experience including 15+ years in Oracle PL/SQL Development; 8+ years in Systems Analysis, Data Analysis, Data Modeling, Oracle Data Base Design and Confidential Transportation Management application; 4+ years in Business Intelligence, Oracle Data Warehousing, MS Access, MS Excel, Supply Chain Planning, Chain Management and Demand Forecasting applications.
• 3+ years in Teradata development; 2+ years in Oracle Database Administration.
• Provided services in all areas of Software Development Life Cycle (SDLC) with consideration of Sarbanes - Oxley Guidelines. Have remained current with developments in new technologies and have high proficiency in research, analysis and troubleshooting.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i/8i/8/7.3/, Teradata, Acumate DB (Retek), Gentia DB, MS Access, MS Excel

Programming languages and shell scripts: Oracle PL/SQL, Retek MSPL, Gentia GDL, Java 2, Power Builder, AWK, UNIX shell script, Windows batch programs.

Data modeling tools: Case*, Erwin, MS Visio.

Software development applications, frameworks and reporting tools: Oracle PL/SQL packages, Oracle SQL*Loader and other utilizes, Oracle SQL, SQL* Plus, Oracle Forms and Reports, BTEQ, Teradata Load Utilities, Teradata SQL Assistant, EDI, HTML, XML IBM Web Sphere, Visual studio, Eclipse, MS Server Reporting Services, Crystal Reports, MS Visio, PowerPoint, Share Point.

Third-party software applications: Confidential TMS ( Confidential Transportation Management System), Gentia BI/OLAP; Retek Demand Forecasting and Retek Supply Chain Planning; Oracle Applications -- 11i/e-Business Suite, ERP Oracle Financials AP, AR, GL, PO, Projects, Oracle HRMS; Oracle CRM, TOAD, SQL Navigator, WebLogic, Apache, Microsoft Office; MS Visio; Version Control with Subversion, GIT, Confluence

Operating systems: UNIX HP, Unix AIX, Sun Solaris, Windows.

PROFESSIONAL EXPERIENCE:

SR. PL/SQL Developer

Confidential, Peapack, NJ

Responsibilities:

• Provided administration and support of the Confidential Transportation Management 7.5 application.
• Developed, tested and implemented additional functionality to the Confidential home grown automated system that correlates data exchange between SAP TMS and Confidential TMS applications. Utilized Oracle DB 11.2, Oracle PL/SQL, Oracle SQL queries, SQL*Loader, MS Access, MS Excel, UNIX shell scripts.
• Added backend automation to the TMS carrier rates load processes for TL, LTL, parcel and air transportation carriers.

Data Analyst

Confidential, Roseland, NJ

Responsibilities:

• Data analysis and big data integration of the Confidential BI applications: Confidential Analytics, Vantage, WFN and EV5.
• Utilized Oracle DB 12c, PL/SQL programs, Oracle SQL queries, Informatica ETLs, GIT, Confluence.
• Provided demonstrational data sets to illustrate future planed features of the Confidential Analytics application.
• Work on Oracle DW data model changes, database objects maintenance and data migrations.
• Supported QA team by providing troubleshooting and tuning of the SQL queries for the Oracle DW.

Sr. PL/SQL Developer

Confidential, Branchburg, NJ

Responsibilities:

• Provide Oracle database design, development, data analysis, PL/SQL programs development, maintenance and production operations support for Confidential Reporting applications utilized by Network Performance and Real Estate Management.
• Gathering business requirements to reflect the changes in metrics data and KPIs and transforming them into technical specifications and programming solutions.
• Work with QA team on developing test scenarios correspondent to technical specification and code modifications.
• Uploading data into Real Estate Management database from a variety of data sources utilizing database links, Oracle utilities, stored procedures, database triggers, views, DBMS SCHEDULER package and MS Excel.
• Maintain Oracle partitioned tables. Rearranging database tables utilizing DBMS REDEFINITION package.
• Migrated UNIX, Linux shell scripts and Oracle databases from stand-alone servers to VM servers.

TMS Analyst

Confidential, Peapack, NJ

Responsibilities:

• Provided Confidential Transportation Management 7.5 application upgrades, administration and support.
• Worked with Confidential USA transportation management team and Confidential support to gather and upload into Oracle database the nationwide collected carrier rates for TL, LTL, Intermodal and Rail transportation.
• Designed, developed and implemented the automated correlation system to support the data exchange between RCS, SAP Transportation Management systems and Confidential TMS application. Utilized Oracle DB, PL/SQL stored procedures, packages, functions, triggers, DBMS SQL, MS Excel, MS Visio.
• Developed, tested and implemented interfaces between SAP applications and Confidential TMS 7.5 application.
• Implemented the Confidential TMS 7.5 LDAP and SSO utilities in the Confidential US Active Directory and SSO applications.

Confidential, Bedminster, NJ

Oracle Database Developer

Responsibilities:

• Administration, enhancements, tuning, troubleshooting and support of the Universal Medical Prescribers Validation system (UMP) to provide verification of prescriptive rights and medical licenses of Medical Prescribers for pharmaceutical industry needs. Utilized Oracle 10g DB, UTL FILE, DBMS ROWID, DBMS REFRESH SQL*Loaded, MS Excel, MS Access, developed Oracle PL/SQL packages, stored procedures, functions, triggers, collections and SQL queries, UNIX shell, AWK scripts, Apache server.
• Provided data analysis and data cleansing on the UMP Validation system.
• Designed, developed, implemented the UMP data consensus processes for the OneKey database.
• Provided the data modeling and the database design for the UMP Reporting needs. Developed ETLs and reports to view and verify the data in the UMP database writing complex SQL and utilizing MS Server Reporting Services.

Confidential, Mahwah, NJ

PL/SQL Programmer Analyst

Responsibilities:

• PL/SQL programs development, enhancements and troubleshooting of the Decoupling system to recombine and exchange data between Liberty Travel Vacation Planning Application and Oracle 11i e Business Suite (EBS) Oracle ERP applications, including GL, AP, AR Projects, Oracle HRMS and Oracle CRM.
• Utilized PL/SQL, Oracle APIs and custom developed packages.
• Designed, developed, tested and implemented the Decoupling database changes.
• Provided Oracle Database model modifications on the Supplier Contracting Pricing Promotions and Marketing applications utilizing Erwin.

Confidential, Wayne, NJ

Systems Analyst

Responsibilities:

• Project lead of the ‘ Confidential R Us -Transportation Carriers on EDI. system. Managed the system and database design, development, testing and implementation. System was rolled out to over 40 transportation carriers realizing a $90,000 yearly savings for the company.
• Systems design, development, testing, implementation, troubleshooting and support of the Merchandise Distribution Centers, the Transportation Logistics, the Sales Analysis, the Demand Forecast and the Supply Chain Planning systems.
• Designed, developed, tested and implemented more than 100 programming interfaces.
• Provided Oracle database design, data modeling, development of the backend code, OS processes and Web Pages for the Apparel Cartons Tracking System (ACTS). Utilized Oracle DB 8i, PL/SQL, SQL*Loader, SQL, SQL*Plus, HTML, XML, JAVA, J2EE, Web Sphere framework, Visual Studio, Unix shell scripting.
• Provided TERADATA data base design and backend development for Demand Chain Management (DCM) system. Developed more than 70 ETLs utilizing BTEQ, Teradata Load Utilities, Teradata SQL Assistant,
• Provided administration, technical support, maintenance and troubleshooting for the following third-party applications: Confidential Transportation Management, Retek Demand Forecasting and Retek Supply Chain Planning

Confidential, Wayne, NJ

Oracle Data Warehouse Engineer

Responsibilities:

• Oracle DBA on Oracle 7.3 database and UNIX operating system.
• Participated in database modeling of the global Sales Analysis system built on Oracle 7.3.
• Designed, development, tested and implemented the automated system of Oracle database objects maintenance and data uploads into the Oracle Data Warehouse by using Oracle DMBS SQL and other standard packages, SQL*Loader, Unix shell scripting.
• Design developed and implemented ad hoc Query Builder for the OLAP Sales Analysis Application utilizing BI Gentia 4.0 software and GDL programing language.
• Programmed, tested, and implemented customized interfaces to populate BI Gentia database from Oracle Data Warehouse using Windows batch programs, Oracle PL/SQL, SQL, SQL*Plus and Gentia 4.0 programming interface, GDL language, Unix shell scripting and AWK.
• Administration of the Crystal Info 6 and development of the Sales Performance reports utilizing Crystal Reports and Queries, MS Excel and Windows batch programs.