Oracle PL/SQL, Development DBA
Resume:
M. DANIEL SIELICKI
IL *****
**.********@**********.***
ORACLE PL/SQL, DEVELOPMENT DBA
Michael Daniel Sielicki, OCP, MCP, CBIP, CDMP, ISMP, OCE-SOA, OCUP, HITCP, has years as senior technical contributor fostering creative solutions for various types of database-focused production-ready scalable deliverables. Skills
Database, Data Profiling, Data Modeling, Vector Semantic Search, Structured Unstructured Agreed Data Sources Multi-Level Process Integration, Self Service Report Framework, Facilitate RPA Objective, Refactor Generated SQL Solid PL/SQL Programming and SQL for High Performance, Security-Privacy, Test Automation, ETL Processes Oracle, Microsoft, SOA, ITIL, Kimball, MSF-MOF, VBCS, UiPath, TOGAF, BIAN Experience
Charter Communications, MO, Data / Design Integration Lead / Sr Manager, Nov2019-Jun2024
·Migrate rebuild legacy Revenue Share platform, Crafting data process streams for Tax, Labor, Utility reporting
·Capture and address current and emerging requirements, Document best practice design patterns, Data Models
·Define standardized change control for Business Stakeholder Data Strategy, ERP Finance Data Concerns
·Create, refactor, optimize highly complex interdependent PL/SQL SP for regulatory environmental impact reporting Oracle PL/SQL, SQL Server, SAP, DB2, SQL Developer, SSMS, Visual Studio SSIS, Visio, MDM Profiling IRI Information Resources, IL, Lead Developer, PIM, Retail Data Consolidation, Jun2017-May2019
·Collaborate and partner with key business and technical stakeholders over syndicated supply chain data
·Rebuild document multi data source acquisition and reporting application for beverage product sales
·Develop PL/SQL daily import process to pipe mainframe POS data files into Oracle DBMS report tables Oracle, SQL Server, Postgre, MonetDB, PL/SQL, SQL Loader, External Tables/Folders/Directories Crawford Risk Sciences, IL, Data Integration Developer, Apr2014-Sept2015
·Convert-Migrate SQL ETL process for insurance claim-exposure, loss-trend benchmarks, and subrogation recovery Oracle, IBM Cognos Netezza, PL/SQL
FTD Group, IL, Amada Group, Oracle DW Developer, Product Information ETL Process, 2013-2014
·Refactor, Repurposed, document source-target, fact-dimension dependencies, OWB, PL/SQL, EM Cap Gemini-Sogeti, IL, IT Consultant, Integration-Developer, 2011-2012
·Astellas Pharmaceuticals, IL, Prepare and diagram certain PL/SQL to Xcode cross development documentation
·Mercer Marsh & McLennan, IL, Refactor PL/SQL currency conversion service API and dimensional hierarchy
·Follett Education Group, IL, Refactor ETL load process, PL/SQL records and data-sets First Union Rail – Wells Fargo, IL, TekSystems, BI DW Architect DBA, 2007-2008
·Developed Rail-Car Leasing Maintenance DW, Oracle Applications EBS integration, ODI, PL/SQL Oracle Corp, IL, Sr Principal Consultant, 2004-2007, Various Client Assignments, OAF, EBS, PL/SQL, APEX
·Louisiana Ins Grp, Developed claim deception predictive BI AI models (SAM Suspicious Activity WLS Watch List)
·IRS Internal Revenue Service, Prepared Oracle EDW load time estimates, process performance analysis
·Chicago Police Department, Defined metadata for response performance criteria, Oracle APEX, SQL, PL/SQL
·Sprint-Nextel, Provided detailed guidance for People Soft SOA migration and upgrade from DB2 to Oracle IT Solution Design Developer, USA, 1982-2004
·AON Corporation, IL TekSystems, Refactor currency conversion API using dimensional matrix
·University Chicago, Opinion Research, Developed K-12 DW design and ETL using OWB with SQLServer
·ACS, NM, Developed Oracle Message Queues for medical claim process workflow
·USANA Health Sciences, UT, Designed dynamic data exchange method for Oracle PIM supply-chain status views
·US DoE, National Nuclear Security Admin, NV, Prepared OWB ETL infrastructure for loading inventory DW
·Primedia Group "Modern Bride Magazine", CO, Migrated SQLServer CRM data into Oracle EBS tables
·ATT-TCI Broadband, CO, Designed Geo-Spatial process for perimeter blackout of live-event broadcast
·US West Comm, CO, Designed capture-merge process for remote engineered blueprint change
·US DoE, National Renewable Energy Laboratory (NREL), CO, Prepared DW readiness assessment
·Oracle Corp – Energy, USAFA, CO, Principal Consultant, Developed PL/SQL packages APIs
·Coors Brewing Company, CO, Merged supply-chain product information management Universe to Oracle EDW
·MCI, CO, Defined and promoted SOA enterprise standard TCP/IP API strategic usage
·Colorado Dept of Trans, Developed process for data acquisition from remote construction locations
·US West Comm – Research & Analysis, CO, Developed dynamic rule generator for survey statistics
·Marriott Hotels Corp, CO, Developed resort-conference event-booking commission calculation process
·General Mills – Market Research & Analysis, CO, Developed retail competitor product information analytics Education
Some College, Colorado, Software Engineering, Technical Management, Attended 1981-1982 Relevant Certifications
HITCP Healthcare IT Certified Professional HIPAA HITECH PHI CRM Risk Management Principles and Practices ARM-1 Institutes ISFS Information Security Foundation based on ISO/IEC 27002 CISCS Cloud Integrator Secure Cloud Services
CLOUDF Cloud Computing Foundation
MCPD Azure Windows Design Developing Applications
MOFF Microsoft Operations Framework
OCUP Certified UML (Modeling) Professional Fundamental OMG OCE Oracle SOA Architect Certified Expert
ISMP ITIL Service Management Professional
CDMP Certified Data Management Professional, Data Management CBIP Certified BI Professional, Data Analysis Design TDWI MCP Microsoft Solutions Framework MSF
OCP Oracle Advanced PL SQL Developer Certified Professional OCP DBA Developer Oracle Certified Professional (8i)(9i)(10g) Relevant Coursework Certificates
Oracle Unified Method 5 (OUM) Implementation Specialist Oracle Exadata 11g Extreme Performance Technical Workshop Oracle OBIEE 10g Business Intelligence Administration, Configuration Oracle OBIEE 10g Business Intelligence Repositories, Presentation Service Kimball Data Warehouse ETL Patterns in Depth
Kimball Data Warehouse Life Cycle in Depth
Contact this candidate