Frank Ortega Email & Phone Number

Cherry Hill, Nj, Us

Mt. Laurel, Nj

Mt. Laurel, Nj

Mount Laurel, New Jersey

• Lead highly successful team of DB application development specialists, responsible for Financial and Risk and Regulatory Data Warehouses (Exadata) as well as Retail/Commercial/Corporate application databases for U.S banking, while remaining hands on with troubleshooting as needed.• Direct team and participating in providing application performance troubleshooting, development and enhancements to highly performing data load routines, automation of statistics gathering and Operations self-service routines, DB environment migrations/upgrades and regression testing, capacity management, space cleanups and reorgs, security and encryption, audit support, and Digital Crown Jewel initiatives.• Currently engaged in Oracle Cloud at Customer 19c DB Migration/Upgrade for DW development DBs.• Led cross-functional team initiatives to find and resolve root cause on reoccurring performance load and reporting issues.• Led successful initiative in migrating source repositories to Bitbucket, designing branching strategies and structure, and use of Nexus Repository for artifact repo and deployment.

Mount Laurel, Nj

• Implementation of Risk & Regulatory/Dodd Frank Data Warehouse environment from ground up on Oracle 12c Exadata X5.• Collaborated with Solutions Leads and Data Modelers to design and implement the RRDW platform.• Implemented encryption & security policies and administered database security.• Designed and coded background database utility packages to support efficient ETL data loads, partition management, and data retention policies.• Advocated for and implemented latest Oracle technologies available including automatic partition management via Interval Partitioning, Automatic Data Optimization (Information Lifecycle Management), Exadata Hybrid Columnar Compression and Advanced Index Compression.• Focused on cost effective solutions to avoid long term overhead of manual maintenance & administration seen in other Data Warehouses, resulting in significant recurring financial positive return.• Collaborated with Hadoop Solutions Lead to configure secured connectivity and integration with Hadoop Data Lake.• Led team members, trained and assigned activities.

Mount Laurel, Nj

Manage team of database and systems infrastructure engineers, responsible for Core Enterprise Services at Comcast, representing one third of all Top Tier One applications, focusing on architecting highly available highly performing systems, stability and capacity management. Focused on client relations, prioritizing projects and managing resource workloads, estimating, managing, escalating work with external vendors, focusing on delivery on time, on budget, on feature with high quality and high availability. Status reporting to clients and senior management.Incident and problem management, lead bridge calls, coordinate matrixed teams to resolve issues quickly and meet MTTR goals and perform root cause analysis.Leadership team member, setting strategy and overall direction of Application and Platform Services organization at Comcast.

Mount Laurel, Nj

Led a team of database engineers supporting BSS applications, including Enterprise Services Platform, Order Management, and Commercial Systems. Coordinated project initiatives, managed resources, managed client relationships and status reporting. Managed Oracle RAC database environments, including install, upgrades and patching.• Architected highly available database solutions implementing Oracle RAC and Active DataGuard across datacenters. • Consolidated databases and environments, increasing overall capacity and availability while reducing administrative costs.• Interacted and presented solutions to senior leadership including CIO.• Awarded 2009 Comcast Enterprise Technology Excellence Team Player award in support of Workforce Automation Systems.• Promoted to Principal Engineer as a result of excellence and leadership.

Mount Laurel, Nj

Led a team of database administrators, supporting Lawson ERP applications and a variety of banking systems including IVR, Leasing, Wires, FileNet Imaging, and Workflow applications. • Managed client relationships, project management, prioritization and status reporting. • Successfully installed and administered Oracle RAC environments on SUSE Linux. • Managed Lawson application database upgrade. • Installed Oracle Streams replication and created reporting environment for Human Resources. • Supported application projects and database upgrades, patching, capacity and performance management, troubleshooting. • Installed and supported Microsoft SQL Server databases. • Promoted to Bank Associate Vice President after successfully managing customer relationships and projects.

Wilmington, Delaware

Provided SAP and bolt-on DBA support on HP UNIX and Windows platforms. Installation and maintenance of DataGuard/Standby DR environment. Lead support for UNIX shell scripting development. Developed automation processes to streamline DBA functions. Developed secure interface function, utilizing PGP/FTP. Eliminated backlog of interface requests, simplifying process, significantly reducing overall costs. Provided HP Openview Operations administration support.

Wilmington, Delaware

Extracted data from PeopleSoft and performed conversions and loads to SAP R/3 for BetzDearborn division. Supported SAP R/3 HR/Payroll systems. Performed systems configuration and programming via ABAP. Configured and implemented Corporate HR Recruitment Module. Configuration and implementation of SAP R/3 HR/Payroll modules for Latin American region, including extract, conversion and loads of data from MS Access DB. Training of Brazilian headquarters staff on SAP HR/Payroll modules.