Oracle Data
Resume:
Contact Information:
Ron E Berger
Bedford Heights Ohio 44146
E-mail abnhas@r.postjobfree.com
RONALD E. BERGER
PROFESSIONAL SUMMARY
Ronald Berger is a Software/Analyst/ETL/DBA/Lead Developer with extensive experience,
utilizing Oracle /9i/10g/11g & PL/SQL, Form & Reports, Net Frameworks, SSIS, SSAS, SSRS.
His background includes SOA & WOA System design, DB2, CICS, IDMS, Disaster Recovery.
Oracle Database Administration, SQL 2005 Database Administration., Data Architecture,
Data Warehouse development .and design. Enterprise-wide Decision Support Systems
(DSS) analsis and design. Within lagacy and multiple DBMS environments.
Erwin Entity Relationship Diagram (ERD), multidimensional databases, Relational Modeling,
Data/system architect. System enhancements. And Project Lead (Management).
CERTIFICATIONS:
Oracle SQL and PL/SQL
Oracle Database Administration
Oracle Backup & Recovery
Oracle Performance & Tuning
Oracle Data Modeling & Relational Database Design
Oracle Developer Forms & Reports
Oracle Network Administration
TECHNOLOGY SUMMARY
Software
COBOL, COBOL II, .NET FRAMWORKS, HTML, XML, JAVA, J2EE ORACLE,
ASP (Web Pages), Visual Studio, VB.Net, C#, QMF. PLATINUM. UNIX SHELL SCRIPTING,
OLAP,ORACLE FORMS & REPORTS DATA WAREHOUSING & DESIGN, MS VISIO.
DB2, CICS, Oracle 9i/10g/11g Oracle 11i FINANCIAL & MANUFACTURING APPLICATIONS,
IDMS, ADS/O, ADS/A, OLM, IDD, IMS, DL/1, ACCESS, EDI PROCESSING, VISIO.
MICROSOFT SQL SERVER.2005/2008, RAC, RMAN LOAD BALANING. BI SOLUTION TOOLS
TSO, ISPF, TELON, VSAM, LIBRARIAN, VOLLIE, ICCF, OS/JCL, FILEAID, IBM UTILITIES,
ABEND AID, SAS, CRYSTAL REPORTING, MICROSOFT OFFICE 2000, FRONTPAGE, IMAGE,
TERADATA DB, QUERY, INFORMATICA. ENDEVOR, DYL280, T/SQL, & PL/SQL.
Hardware
IBM mainframes, IBM390, RS/6000, HP 3000, AS/400, Server’s, and PC's
Operating Systems
MVS/OS, UNIX, AIX, VISTA, MICROSOFT WINDOWS and SERVER.
EXPERIENCE
Integration/ETL/BI:
• Have Created Interface/integration Tables between Legacy system and Oracle Applications,
while applying Business rules, OBIEE (Oracle's BI strategy).data transformation, and data
Disaster Recovery for these systems.
• Defined additional/new reporting requirements and provided the programming necessary to
ensure Integration implementation. Within a RAC, Data Warehousing environment.
• Created BI strategy, SSIS & SSAS packages and SSRS Reports for ETL, data validation,
editing and auditing within Informatica extract data.
• Experience in data validation, XML-based data exchanges, setting up Business rules, data
transformation, and data mapping.
RONALD E. BERGER PAGE TWO
January 2007 CYNERGIES SOLUTIONS
to Present CONSULTANT / DBA / SSIS & SSAS Designer/Developer:
Insurance
• Provided direct Oracle DBA Administration support for all staging and ETL data bases.
Perform inter facing, maintenance and analysis of vendors software for Staging. and conversion.
Working with Oracle, SSRS, SSIS, (Oracle's BI strategy), within an Oracle 11g, SQL and DB2
Data Warehouse and Data Marts. On an Client/Server platform.
• Responsible for Converting SQL 2000 DTS packages and Data Cubes. Over to 2005 SQL SSIS
Data packages, and SSAS Data Cubes. This task Included. Net programming, ETL, Systems
Staging, SQL 2005 Database Administration, Data Warehouse, SOA System and Design,
System Data Architecture, SSRS Reporting and application Clustering.
And major analysis. Alone with C#, Data Warehousing programming, integration and design.
Banking
• Current responsibility Data Manager/Integration Lead. Performed Client/Server data loading.
from Oracle 10g/11g, SQL 2005, DB2 and Vsam. Within Warehousing & mainframe platforms.
• Verification of Oracle DB2 and SQL scripts for performing system integration. Within SSIS,
ETL Staging tables compliance. Perform control requirements testing, & SSRS reporting
for SQL, DB2 & Oracle Databases And perform BI strategy, and Disaster Recovery
for these systems.
• Data planning, and data verification for implementation into Test and Production,
Data Warehouse. Also worked with multidimensional analytical databases
This included SQL & Oracle DBA system support, development of BI solutions and analysis.
August 2006 VITAL Resources
To December 2006 CONSULTANT / DB2 / Developer:
Banking
• Provided direct application support within The Product Initiatives Team. Perform System analysis,
CICS and DB2 application programming. & .Net Frameworks programming, C#, VB.net
• Performed major System and Application tasks, for program implementation into production.
• Responsibilities include BI solutions, Informatica extracts, system support. Analysis and
design.
September 2003 COMSYS
To July 2006 CONSULTANT/DBA/Developer:
DFAS
• Current responsibility Oracle DBA/ & IDMS, Systems Developer, maintenance and Application
Programming, Performed store procedures, and application triggers. Along with shell scripting.
• Performed PL/SQL and Oracle Database Administration functions, on a HP Unix server within a
Client/Server Platform. Also work with .NET, Visual Studio, FTP, Access and SQL 2000 Server.
• Responsibilities include system support, analysis and design within the DFAS support area.
Work within the IDMS APS group, perform (ADSO) dialogue screens programming, together
with (ADSA) procedures. Cobol and CICS.
August 2002 SOGETI
To June 2003 SYSTEMS CONSULTANT /Oracle/DBA/Developer:
• Oracle DBA/Developer working with user and staff on user interactive forms and tables. utilizing.
PL/SQL and Oracle 9i database, and Form & Reports, JAVA, SQL Plus, & file transfer protocol.
• Performance Systems & data clustering. Utilizing shell scripting, RAC, System Clustering.
Oracle’s Recovery Manager, for System Backup & Recovery, failover.
Performed all major PL/SQL and Oracle Database Administration functions, on a Windows
2000
server within an Oracle Client/Server Platform. Working with Java, J2EE & Jdeveloper.
RONALD E. BERGER PAGE THREE
• Responsible for SOA System and Design application support,analysis and design within the
customer support area.
• Created new user interactive Oracle Forms & Reports and PL\SQL procedures
Utilized all current application store procedures program units, and triggers.
July 1999 University Hospitals of Cleveland
to April 2002 ANALYST INTERFACE DEVELOPMENT & INTEGRATION ENGINE
• Provided direct application support within the interface integration application area.
• Responsibilities included analysis, design, programming, testing, and interfacing with IMS, DB2,
Oracle 8i, SQL Server, Data Warehouses and Data Mart, multidimensional database
applications. Along with Systems & data clustering.
• Utilized Unix OS FTP, with support for Oracle OLAP I-Expense, & Purchasing applications.
Oracle Forms, and implementation of small, medium, and large development.
• Responsible for providing new and current support for all Oracle Forms & Reports, Oracle
applications, PL\SQL procedures, and new interface functions within UHHS Unix network.
• Created new Shell scripting, user interactive forms, and tables utilizing DB2, Oracle Forms
and Reports within Oracle Application 11i, Financials.
• Performed all major SQL and Oracle database administration functions,
Including Backup & Recovery utilizing, Oracle’s Recovery Manager.
September 1994 Computer Task Group, Inc.
to July 1999 SR. SYSTEMS SOFTWARE ENGINEER / DBA
Utility Corporation
• Responsible for maintaining total functionality and operations of three major Materials
Management Systems, along with all system interfaces, download, and 24/7 support.
• Correlated all interaction with support staff, operation, tech support, end users,
and Corporate managers.
• Assisted in database design, database analysis, and creation of all of open interfaces
Within all Oracle application, using ETL & PL\SQL procedures/programming,.
• Performed major updates to Oracle GL, AP, FA, CE, and AR modules.
Management Oracle OLAP and Transaction SQL database systems.
While working with SQL Loader.
• Assisted in SOA System analysis to an Oracle Client/Server platform, utilizes
• Data Modeling, Oracle forms, and Oracle reports. Created Interface Tables between
the Legacy system and Oracle 11i Financials Applications for interface/Conversion.
Banking
• Responsible for the analysis, design, programming, testing and implementation of a LeMans
System utilizing ENDEVOR that provided leasing information to the user via CICS, batch, DB2,
and VRU (voice response systems).
• Responsible for incorporating modifications to this LEASING system that allowed inquiry access
to the leasing system via CICS and VRU 24 x 7. The system also interfaced with Oracle online
AP system utilizing Oracle Forms & Reports.
• Created a stand alone IDMS fee billing system, implementing modifications to this system, which
permits interfacing with Amtrust, a technological high level architecture banking database
system.
Converted IDMS database to DB2.
Manufacturing
• Assisted in database design, database analysis, and converting of an Oracle7 database over to an
Oracle8 Client/Server RDB with multiple database views, and stored procedures utilizing PL/SQL
programming and UNIX Shell scripting. Created Oracle Forms and Reports for editing and
auditing. Performed all major database administration functions.
RONALD E. BERGER PAGE FOUR
September 1989 Keane, Inc.
to May 1994 SR. PROGRAMMER / ANALYST
Major Securities Investment Company
• Performed analysis and design for networking to the National Securities Clearance Corporation
(NSCC) utilizing Network Data Mover (NDM) within a Data warehousing network,
alone with EDI processing.
• The system enabled the network user five separate processing functions for financial transactions
including year-end tax reporting. Responsibilities included data mapping to new NSCC formats
and converting NSCC CICS screens to interface the client's existing systems.
• JCL streams were created for NDM communication links that executed UCC7 scripts. Technical
skills used were DB2, CICS, IDCAMS, COBOL, OS/JCL, SYSTEM ARCHITECT and
ENDEVOR.
• The system enabled the network user five separate processing functions for financial transactions
including year-end tax reporting. Responsibilities included data mapping to new NSCC formats
and converting NSCC CICS screens to interface the client's existing systems.
• JCL streams were created for NDM communication links that executed UCC7 scripts. Technical
skills used were DB2, CICS, IDCAMS, COBOL, OS/JCL, SYSTEM ARCHITECT and
ENDEVOR.
Retail
• Provided analysis, programming and customer support of multiple critical business systems.
Responsible for tying together high level dialogue screens together (ADAS) to complete the
integration of complimentary applications.
• Aided in the conversion of these applications from VSAM and IDMS to DB2. Participated
in system testing.
EDUCATION
Oracle Institute Oracle Database Administration (certified).
Cleveland State University Visual Basic.
DBMS ADS/O, ADS/A.
Cullinet IDMS.
IBM CICS, BMS.
Keane DB2.
Control Data Institute Computer Science (Data Processing.)
Contact this candidate