Skilled Enterprise Solutions Architect, Designed OLTP/OLAP entity/dimensional database relationship modeling and design, and System Development Life Cycles, Database Administrator and Proactive Tuning, excellent communication skills, project management, detail-oriented customer-focused service approach

Corey Kolodziejczak

Mid-Atlantic Region

Eastern United States

Mobile: 267-***-****

ady0wr@r.postjobfree.com

Data Modeling Tools: Erwin, Oracle (1x,2x,2xx), DB2/ SQL Server 20xx.

OLTP Tools: ODI, OBIEE, Hyperion/Brio, Cognos, Tableau.

Specialties: Exadata, PL/SQL, Golden Gate, Spark/Java/Python.

ETL Tools: ODI, OWB, Informatica, DataStage.

Operating Systems: UNIX (AIX, HP, Sun, Linux), Windows NT/20x.

Applications: SAP utilities, PeopleSoft (EPM), Oracle Applications.

International SOS Enterprise Systems Solutions Architect 8/21-Current

Horsham, PA

Managed deep analytics team and practicality of Big Data on Exadata also algorithms using Hadoop, MapReduce, and various distributed computing tools

Managed the design, development, promotion of web-based Intranet SOA utilizing BPEL, ESB, SOAP, WSDL, XML/XSLT, PL/SQL data retrieval (publisher/subscriber) synchronous and asynchronous systems for dashboard and OLAP reporting.

Exercise of Oracle Hyperion tools like FDMEE, Workspace, Financial Close Management, SmartView and DRM.

Modeled and architected multiple Data Lake OLAPs for reporting solutions as well as OLAP databases.

Experience leveraging ETL frameworks to develop scalable solutions using SSIS. Design and develop SSIS packages, configuration files, stored procedures, tables, views, and functions

A result-oriented professional with multiple years of software development in Unix, SQL and PL/SQL, CA- Un-Center middleware environment a managed designers of physical and logical data models utilizing techniques of Inman and Kimball

Plan and implement tuning strategy for all systems including the application, database, instance, and Operating system.

Environments: Hadoop/HDFS, Spark/Python/JAVA, OCI/OBIEE/OWB, OEM Grid Control, Sql Server 20xx(DTS, SSIS, SSRS), Enterprise Manager, RMAN, Golden Gate, Windows Servers, Informatica CA-PowerCenter.

Optum/UHG /AARP Solutions Architect 6/2015–9/2021

Horsham, PA

Produced multiple PL/SQL ETL packages for Data Warehouses on Solaris platforms.

Designed, developed, promoted web-based Intranet SOA, WSDL, XML, J2EE-PL/SQL data retrieval (publisher/subscriber) synchronous and asynchronous systems for Hyperion/Brio Dashboard reports.

Played major roles in Oracle ERP/CRM Production Conversion project translating multiple source databases utilizing XML, SOAP, Sql Plus, PL/SQL, shell scripts.

Environment: ODI/OWB/ OEM (Oracle Enterprise Manager), Sql Server 2xx(DTS,SSIS,SSRS), Oracle 9i, 9iAS, PL/SQL, UNIX Shell Scripting, Daemons and Cron Jobs,

Reed-Elsevier Enterprise solutions 9/2013–4/2015

Orlando/Philadelphia

Designed, developed, promoted web-based Intranet SOA, WSDL, XML, J2EE-PL/SQL data retrieval (publisher/subscriber) synchronous and asynchronous systems for Hyperion/Brio Dashboard reports.

Performance tuned Oracle 10g/Peoplesoft(EPM) databases as well as Linux platforms.

Mentored individuals in dimensional modeling of Data Marts/Warehouses and Database Administration.

Environment: Linux, Oracle 10g, Peoplesoft (EPM), PL/SQL, UNIX Shell Scripting, Daemons and CronJobs, OEM (Oracle Enterprise Manager), Sql Navigator.

Pfizer Inc. Senior Oracle DBA 5/2010–7/2013

New York City, NY

Provided physical and logical design of star-schemas and slowly changing dimensions, including demonstrative detail in the construction of table partitioning, materialized views, query rewrite, and star transformation.

Migrated and upgraded Oracle E-Business Financial Suite to 11.5.10.2 on AIX5L.

Debugged and tuned PL/SQL Packages, and stored procedures.

Rapid cloned multiple instances for test and development and monitored database performance.

Utilized Oracle Warehouse Builder in the creation and deployment of multiple materialized views.

Mentored individuals in dimensional modeling of Data Marts/Warehouses and Database Administration.

Environment: HP-UX, Oracle 10g, Oracle Warehouse Builder, PL/SQL, UNIX Shell Scripting, Daemons and Cronjobs’, OEM (Oracle Enterprise Manager), SQL Navigator.

Shire Pharmaceuticals Senior Data Base Administrator 4/2007–3/2010

Berwyn, PA

Developed and integrated customized PL/SQL and Unix shell scripting software in the implementation of wireless transactions.

Provided analysis, design and development efforts in the migration of 11.0.3 to 11.5.10 RAC.

Designed Parts and Tools Data Warehouse Dimensional Model utilizing OWB 10g.

Environment: Sun Solaris, Oracle 9i /10g RAC, Oracle Warehouse Builder 9/10g, 9iAS/10g, PL/SQL, UNIX Shell Scripting, Daemons and Cronjobs’, OEM (Oracle Enterprise Manager), Siebel 7, ErWin.

General Electric Aircraft Engines Data Architect/Developer/DBA 6/2003/-5/2007

Cincinnati, OH

Performed Logical modeling of star/ SCD historical schemas with OWB Managed RAC databases on Red hat Linux

Environment: Windows 20xx, Oracle Applications, Oracle RAC, 9iAS, PL/SQL, UNIX Shell Scripting, Daemons and cronjobs, OEM (Oracle Enterprise Manager).

Merck Research Laboratories SOA Data Architect 5/2004–4/2005

Blue Bell, PA.

Physical and Logical Modeling of Financial Data Warehouse utilizing ErWin and OWB/9iDS from DB2.

Debugged and tuned SQL Query/stored procedures, triggers.

Provided DBA services such as Backup/Recovery Rman scripts, index management, performance tuning, optimization, troubleshooting and database capacity management.

Analyzed business requirements creating, testing and documenting ETL database objects utilizing PVCS and executed with various Korn Shell scripts.

United Health Group Sr. Oracle Developer/DBA 4/2002–5/2004

Fort Washington, PA

Project manager for Oracle Database Security verifying the lockdown of databases per FDA/CFRGCC11 requirements utilizing complex password PL/SQL, Roles, and Profiles.

Installed and maintained Clinical/TMS 4/RDC with CRF/Batch loaders

Developed java batch applications, java beans, web application architectures and technologies, security protocols, network protocols, authentication, directory servers.

Installed, configured, monitored Oracle Applications E-Business including Financials and HRMS.

Upgraded several 8.0.4 database to 8.0.4.4. Installed and migrated several databases to 8.1.7 on NT platforms.

Provided proactive performance monitoring of databases ensuring service levels were met. Administered change control of physical data structure for all environments.

Johnson & Johnson/Centocor, Inc Sr. Oracle DBA 7/2001-4/2002

Malvern, PA

Monitored and tuned Oracle Database instances (all versions of Oracle 7) executing over layers of Oracle Applications and PeopleSoft on Sun Solaris 2.x.

Provided various UNIX scripts for the effective monitoring of index and table space usage. Assisted in the upgrade of Oracle (7.2 to 7.3 i.e.). Installed Oracle Web Application Server for Finance and Human Resource acting as internet/intranet technical lead.

The objective of this position was improving the DB2 application environment by way of relieving the database of data no longer required, thereby refining the selected DB2 access paths.

Assisted systems staff with the efficient utilization of DB2 architecture within the current application environment.

Decision One Oracle DBA 1/1997-7/2001

Malvern, PA

Complete installation of Oracle RDBMS, as well as the design, development of the USPS Marketing Database.

This involved the evolution of telemarketing, customer, and response profile databases. Installed and supported mainframe to PC server connections utilizing VTAM LU6.2/APPC DB2, MS SQL Server.

EDUCATION Including (20 years on the job experience)

9/1989 - 1/1991 Drexel University - Computer Science

7/1997 - 9/1997 Oracle (Berwyn, PA) - Performance Tuning,

- Basic Database Administration

- Backup & Recovery

9/1984 - 12/1984 Pierce Jr. College - Structured Cobol

- Business Systems Analysis

Contact this candidate