Marek Majerczyk Email & Phone Number

Boulder, Colorado, United States

Designed, coded, tested, tuned, debugged and documented Oracle SQL, PL/SQL, Snowflake packages to support Yes Energy LLC data collections and power market applications.

Bellevue, Wa

Designed, coded, tested, tuned, and documented PL/SQL packages to support T-Mobile financial department batch processes.

Mansfield Massachusetts

Designed, coded, tested, tuned, and documented PL/SQL / SQL scripts to support Medtronic supply chain information loads for reporting purposes. Built Oracle Apex Applications for uploads into Oracle user-maintained table data.

Bellevue, Wa

Designed, coded, tested, tuned, and documented PL/SQL packages to support T-Mobile financial department batch processes.

Greater Chicago Area

Designed, coded, tested, tuned, and documented PL/SQL packages and Korn Shell wrappers to support JDA Supply Chain Planning and Optimization software.

Greater Denver Area

Worked on conversion/re-coding of PL/SQL fund reporting application to execute in the new database server architecture.

Hoffman Estates, Il

Designed, coded, tested, tuned, and documented PL/SQL packages and Korn Shell wrappers to support JDA Supply Chain Planning and Optimization software.

Lafayette, Colorado

Designed, coded, tested, tuned, and documented ETL processes supporting marketing technology applications utilizing IBM Netezza 7 and Oracle 11g databases as well as SQL, PL/SQL, and Korn Shell scripting.

Hoffman Estates, Illinois

Designed, coded, tested, tuned, and documented PL/SQL packages and Korn Shell wrappers to support JDA Supply Chain Planning and Optimization software.

Toronto, On, Canada

Designed, coded, tested, tuned, implemented and documented high-performance PL/SQL and KornShell interfaces for JDA Demand and Fulfillment modules with Oracle 10g and 11g as back-end databases.

Westminster, Co

Designed, coded, tested, PL/SQL extensions to the processes archiving/purging medical records for discharged patients; Performed code debugging/data mining for client-side issues with the archiving processes.

Design, coded, tested, tuned, implemented and documented high-performance PL/SQL procedures and triggers for:• History conversion between Legacy and Manugistics Demand Module• Automated and Manual DFU/ DFUMap Creation process in Manu Demand Module• Statistical Process Of Splitting the total history in to the base and lift portions

Senior Systems Analysts in the Logistics Department – Provided 3rd level support for production problems, root cause analysis, effective resolution and follow-up for the Manugistics Transportation Management System as well as integration Created on-demand reports for the TMS Business team.• Performed SQL/Database tuning for the TMS Application as well as integration processes reducing processing time several times.

Greater Philadelphia Area

Manugistics Project Process Support and Documentation - Documented existing interfaces for Manugistics DPEE/SCPO and Collaborate/OneView. Troubleshot, coded, tested, and implemented fixes for the existing processes as well as Worked as a lead for technical knowledge transition to the Indian support personnel. Performed SQL/PLSQL/Oracle Database tuning of the existing processes. • Developed new high-performance data integration layer between DPEE and Collaborate modules utilizing PL/SQL, SQL, Perl, Korn Shell, which replaced inefficient Java based import/export tools and reduced processing time several times.

Greater Chicago Area

Key accomplishments in projects below:Performed several successful implementations of Manugistics SCM software, involving full SDLC.Designed, coded, tested, implemented and efficient data integrations between various systems.Effectively analyzed and resolved problems occurring at various phases of SDLC.Consulting Projects:ABBOTT LABORATORIESManugistics Project Process Tuning and Documentation - Documented data interfaces for Manugistics DPEE module. Coded, tested, troubleshot, and implemented DFU synchronization process between SCPO and DPEE databases utilizing SQL, PL/SQL and DOS shell. KRAFTManugistics Project Lifecycle and Oracle DB Programming - Designed and documented interfaces for Manugistics Order Management product. Coded, tested, troubleshot, and implemented data interfaces. While unit testing, performed Oracle DBA tasks including database creation, management, dumping, restoring, and user management.PHILLIP MORRISData Mart and OLAP Implementation – Based on client software and hardware selection including Oracle, Manugistics (SCPO, OneView, Collaborate) and Cognos designed and implemented high performance architecture for data integrations, database, and data access. RADIO SHACKManugistics Project Lifecycle and Oracle DB Programming – Designed and documented interfaces for Manugistics SCPO module Coded, tested, troubleshot, and implemented designed data interfaces. While unit testing, performed Oracle DBA tasks including database creation, management, dumping, restoring, and user management on Oracle RDBMS.INTERNATIONAL PAPERManugistics Project Lifecycle and Oracle DB Programming - Established multiple environments installing and configuring various Manugistics products including SCPO, DP/EE, SCN, Collaborate. Performed Oracle DBA tasks including: database creation, management, dumping, restoring, and user management on Oracle RDBMS. Created data interfaces between installed Manugistics products. Troubleshot issues across all products.

Component Benchmarking - Performed benchmarking and technical analysis of motherboards, processors, hard drives, and graphics adapters utilizing DOS 6.22, Windows for Workgroups 3.11, Windows 95 and Windows NT 4.0 Workstation.

Ms, Technical Physics

Education record