Mark Shillinger

Gladstone, MO ***** 360-***-**** ad2b5c@r.postjobfree.com

Highly skilled Technical Lead Oracle production support with a proven track record of managing and optimizing complex IT infrastructures. Now seeking a new challenge as a Technical Lead for a team of Oracle PL/SQL Developers. Expertise in Oracle tools, server management, network administration, and IT security, combined with a strong understanding of Oracle technologies, makes me an ideal candidate to lead and mentor a team of developers in delivering exceptional solutions and driving success in Oracle-based projects. Extensive experience in writing SQL queries, PL/SQL procedures, functions, packages, triggers, exception handlers, cursors, collections, PL/SQL tables in 19c,12c,11g,10g, 9i and 8i. Extensive experience in Oracle/Exadata SQL, PL/SQL and performance application tuning using various tools like Explain Plan, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports.

Professional Experience

Kaiser Permanente National IT

Technical Lead Oracle PL/SQL/ System Administrator February 2015 – August 2023

●Lead Disaster Recovery testing for MBE, developing a comprehensive test plan and executing a successful Desktop exercise

●Worked in PL-SQL code tuning System Analysis, Design, Coding, Testing, Development and Documentation.

●Worked on both proactive and reactive SQL Tuning and Query Optimization Techniques for complex SQL Statements.

●Collaborate with UAT and WIT testing teams to refine testing plans and ensure expected results are achieved. Develop efficient PL/SQL solutions for MBE production, optimizing system performance

●Implement a robust Cyber resiliency plan for MBE, utilizing Fusion technology to enhance data security and protection

●Fixing performance problems with PL/SQL programs.

●Review trip wire and DML activity reports to ensure compliance with SOX regulations and maintain data integrity

●Migration of Oracle DW data to the Click house DB using Apache Kafka, Stream sets Data Collector.

●Successfully submit Monthly SOX attestation for production servers containing PHI data, demonstrating adherence to regulatory requirements

●Train team members on Medicare CMS Files and Financial Reconciliation processes, enhancing their skills and knowledge

●Successful completion of the Oracle Database migration from CTL (CenturyLink) Cloud to Oracle Cloud OCI (Oracle Cloud Infrastructure).

●Transfer expertise and knowledge to 4 TCS contract employees, fostering a collaborative and skilled team environment

Computer Science Corporation CSC Lake Oswego, OR Consultant for Kaiser Permanente September 2013 - January 2015

●Spearheaded the Medicare Business Engine for Market Prominence Application as the Technical Lead,

ensuring seamless operations and successful project delivery

●Executed the technical financial reconciliation of Medicare CMS processing with precision, maintaining accurate financial records and compliance

●Conducted comprehensive training sessions for team members on Medicare CMS Files and Financial Reconciliation, enhancing their skills and knowledge in the domain

●Revamped and optimized complex PL/SQL Packages to meet stringent HIPAA compliance standards, ensuring the security and privacy of medical claim data

●Took the lead in developing and implementing Data Clean-up PL/SQL solutions, improved data quality

Mastech Corporation Lake Oswego, OR

Consultant for Kaiser Permanente July 2012 - August 2013

●Assessed and analyzed healthcare processes and systems to identify areas for improvement and efficiency enhancement at Kaiser Permanente

●Conducted in-depth data analysis and market research to provide valuable insights and recommendations to leadership, enabling informed decision-making

●Facilitated workshops and training sessions to educate staff on best practices and new methodologies, improving their skills and knowledge

●Created detailed project reports and presentations to communicate findings, progress, and outcomes to stakeholders, fostering transparency and alignment

Arizona Department of Revenue Phoenix, AZ IT Director October 2007 - March 2010

●Directed a team of 18 skilled software engineers and provided leadership to 2 supervisors

●Implemented and executed IT strategies to align with the organization's goals, resulting in increased efficiency and productivity across all departments

●Managed and led a team of IT professionals, fostering a collaborative and innovative work environment that resulted in improved employee satisfaction and retention rates

●Successfully upgraded the company's IT infrastructure, resulting in enhanced system performance, security, and scalability

●Spearheaded the adoption of new technologies and software solutions, optimizing business processes and driving digital transformation initiatives

Additional Experience

Database Developer, Acxiom Corporation

Consultant, CCITriad / Continuum Consulting, Inc. / NDC Health Information Services

Senior Oracle Developer, Dial Corporation

Developer/DBA, Boeing Corporation

Technical Skills

Oracle 8i, 9i, 10g, 11g, 12c, 19c Exadata, Oracle Reports 6, 6i, 10g, Oracle Forms 5, 6i, 6,10g, PL/SQL, Oracle BI, UNIX, SQL Server 2005, 2008, Oracle DBA, Oracle Data warehousing, ETL Tool Informatica 1.6, 6.0, Netezza Server, NZSQL

Core Competencies

System Administration, Server Management, Network Administration, Virtualization Technologies, Cloud Computing, IT Security and Cybersecurity, Backup and Disaster Recovery, Configuration Management, Monitoring and Performance Optimization, Troubleshooting and Issue Resolution.

Education

BS in Business – Computer Science (Magna Cum Laude), Western International University

Western International University Phoenix, AZ

Student of Computer Science, Full time April 2010 - May 2011

●Graduated Magna Cum Laude, and recognized as a member of prestigious honor societies including Golden Key, Delta Mu Delta, and Upsilon Pi Epsilon

●Gained in-depth knowledge of computer programming languages, data structures, algorithms, and software development methodologies

●Increased proficiency in various programming languages, including Java, Python, C++, and JavaScript, with hands-on experience in developing and implementing software applications

Contact this candidate