sr data architect / dba

Russell B. Mazelsky

San Diego, CA *****

Voice: 858-***-****

Skype: data.architect1

Email: *******.********@******.**

Education Ph.D. in Applied Mechanics (ABD)

University of California, Los Angeles – Los Angeles, CA

Master of Science, Bio Engineering

University of California, San Diego – San Diego, CA

Bachelor of Science, Pre-Medical Bio Engineering

University of California, San Diego – San Diego, CA

Skills Hardware & OS: Windows servers and PCs, Sun Solaris 8/9/10, UNIX, Red Hat Linux, AIX, HP-UX, IBM 360/370/390

Operating Tools: Tivoli, CA Unicenter, Legato, Veritas

Networking: UNIX TCP/IP, NFS, SQL*Net

Reporting Tools: Crystal Reports, JReports, Business Objects, Cognos, Excel

RDBMS: Oracle 6/7/8i/9i/10g/11g, Oracle Apps 10/11i, SQL Server T-SQL 7, 2000, 2005, 2008, SAP, DB2, Informix Enterprise/Server/Repository Manager, Oracle iCRM, SQL Plus, Forms, Menu, Oracle GLUE, Crystal Reports, Designer/Developer 2000, Erwin/ERX, Pro*C, Data Junction, Business Objects, MicroStrategy

Configuration Management: Visual Source Safe, CCC/Harvest, ClearCase, RCS, SCCS

Applications: JDA, Retek, Oracle Apps11i, Siebel, Remedy, Similarity/Axio Data Profiling Toolset, IBI DataMigrator, IBI Adapters to AS400, IBM390, Adabas, Windows

Languages: DHTML, XML, HTML, Java, LISP, Basic, C/C++, FrontPage 2000, COBOL, Visual Basic 1.0-6.0

ETL Tools: IBI Data Migrator, Oracle Warehouse Builder, Oracle Data Integrator, Informatica.

Data Profiling Tools: DataCleaner, Talend Data Profiler, Axio (Similarity Systems), Datiris Profiler

Data Modeling Tools: CA ERWin Data Modeler, Oracle SQL Developer, ER/Studio, PowerDesigner, Silverrun, Toad Data Modeler, Visio Professional

Certifications: Oracle and SQL Server DBA Instructor, Data Warehouse / Architect

Professional

Summary Senior Database Architect with 15+ years of experience in the full software development life cycle (SDLC) including database design, development, administration, tuning, implementation, troubleshooting and quality management of large scaled distributed systems.

Performed automated and manual BI and ETL processes, data feeds, database design and development using Oracle, MSSQL, and internet technologies.

Was responsible for creating, testing/validating complex SQL queries across multiple environments including PL/SQL and t-SQL.

Developed an ETL architectural solution using MSSQL Server which involved the integration of multiple large data sources into a single isolated staging environment.

Developed the architectural solution using metadata models and resolved any bottlenecks in the ETL loading process while assuring compliance in all phases of the SDLC process by providing documentation, reviews, and data analysis summaries.

Worked with large data sets (millions of rows), utilizing patient/hospital/physician data all throughout San Diego, CA.

Professional

Experience

01/13-Present ESRHealthcare – San Diego, CA

DATABASE ARCHITECT / DEVELOPER / ADMINISTRATOR / SENIOR RECRUITER

Acted as the Lead Data Architect/DBA/Developer in a team of 15 (5 Developers / 10 business users).

Performed automated and manual BI and ETL processes, data feeds, database design and development using Oracle, MSSQL, and internet technologies.

Was responsible for creating, testing/validating complex SQL queries across multiple environments including PL/SQL, t-SQL, and PRO*C / C programs.

Developed back end stored procedures, functions, and programs using PRO*C and C language including:

OLTP transaction processing for database updates, inserts, deletes, and

ETL batch feed processing

Data Ware reporting and data quality reporting

Extensive financial and customer batch

DBA functions including backup and recovery, data quality, and database tuning

Utilized MSSQL Server and Oracle as the databases, working with thousands of rows of data.

50-100 sites (database backend) with web based front end displaying approx 10 GB of data primarily for query and reporting purposes

Worked with hundreds to thousands of business users per day.

Data was used for making marketing and sales decisions about vendor products and services available including recruiting.

09/12-01/13 Sempra Energy – San Diego, CA

DATABASE ARCHITECT (CONSULTANT)

Developed an ETL architectural solution using MSSQL Server which involved the integration of multiple large data sources into a single isolated staging environment. The staging environment was used for loading, filtering, profiling, and eventual loading into the Archer schema target environment for asset security compliance with company and SOX requirements.

Worked with large amounts (millions of rows) of asset, HR, and security related data which included flat files and database tables from multiple sources. Sempra Energy worked with utility data for residents and businesses all throughout San Diego County.

Profiled, cleansed, validated, and integrated all data loaded into staging schemas using T-SQL scripts and 3rd party data profiling tools.

Validated all data with security business analysts to make sure that the data was correctly mapped, loaded, and compliant with corporate security / SOX standards.

Translated all business security reporting and analysis requirements and models into working ETL process. Used PRO*C for Oracle stored procedures and functions.

Developed the architectural solution using metadata models and resolved any bottlenecks in the ETL loading process while assuring compliance in all phases of the SDLC process by providing documentation, reviews, and data analysis summaries. Bad data was filtered out early in the loading stages thereby reducing future costly efforts of data clean-up in production targets.

Established data standards and policies, data modeling, systems architecture design, and migration system architectures to ensure access to and integrity of data assets for security and confidentiality compliance.

Analyzed changes in online transactional processing, business processes, and external information sources and recommends modifications, to improve quality of applications and meet additional requirements.

09/10-03/11 Anvita Health – San Diego, CA

DATABASE ARCHITECT

Designed, tested, and deployed an enterprise database reporting system for medical information using MySQL, Oracle, Windows, and UNIX environments.

Worked with large data sets (millions of rows), utilizing patient/hospital/physician data all throughout San Diego, CA.

Reports consisted of analysis of medical drug and patient information for several major medical insurance providers including return on investment, drug safety, and gaps in care.

Performed detailed analysis of database architecture and newly designed processes supporting medical prescription and drug interaction with diseases as they were related to medical insurance claims. In particular performed database and data model analyses and process migration between several Oracle and MySQL customer database architectures.

Analyzed data quality and evaluated/proposed new reporting architecture for end-to-end on-demand reporting requirements for multiple clients/environments.

Utilized Oracle, MySQL, custom interfaces/rules, and proposed J-Reports reporting architecture.

Developed and tested PL/SQL and T-SQL scripts and documented the new processes in the architecture. Developed PRO*C programs for custom reporting and complex algorithms.

08/08-09/10 Akimeka, LLC. – Kihei, Maui

DATABASE ADMINISTRATOR

Data Warehouse Architect responsible for the design, building, testing, and documentation of an Enterprise Data Warehouse integrating several source system schemas using Oracle Warehouse Builder (OWB 11gR1) and Oracle 11g.

Designed and implemented the ETL process using several staging schemas and an Operational Data Store for reporting using Business Objects. Dashboards were implemented for monitoring the job feeds as well as monitoring data quality. The stage and target star / snowflake schemas were designed and modeled using ERWin.

Developed a new architecture and implemented an enterprise strategy for loading data for the Theater Medical Data Store (TMDS) application for the Defense Health Information Management System (DHIMS).

Responsible for data modeling of several new and modified systems including OLTP, data feeder systems, and data warehouses. Used ERWin and Quest data modeling tools.

Designed and implemented stage, vault, and data mart schemas using Oracle 10g database, Oracle Warehouse Builder11gR1, and Business Objects XI Rel.1

Received training and certification on the Data Vault data modeling methodology – see http://www.GeneseeAcademy.com/certification/ which means that I have a foundational base for creating, designing, and building scalable, flexible, and accountable enterprise data integration stores.

Received training on Oracle Warehouse builder from Oracle Corporation.

Received training on Business Objects XI Rel.1 in support of report creation for the Theater Medical Data Store application. Designed and implemented several XML feeder system interfaces to Oracle back-end databases.

Designed Blood schema model using ERWin and deployed into an Oracle development environment. Developed PL/SQL stored procedures and functions to support access to the Oracle database from the web application.

Implemented Oracle Spatial (and the entire MSAT schema) by loading and transporting spatial data, and allowing for SDO_GEOMETRY to be used in a web application performing spatial queries (MSAT). Performance improvements of from 2-7 times were achieved using an Oracle database - version 10.2.0.3.0.

Maintained and maintained using SDLC best practices - entire dev, qa, test, demo, and production instances for MSAT.

Developed several Oracle database standards documents including schema design, installation+patch, feed system designs, database configurations, as well as installation documents and security.

Performed Oracle database tuning for the Blood Inventory Management (BIM) project as well as the for the Medical Situational Awareness Theater (MSAT). Wrote many stored procedures and functions using PRO*C and the Oracle database.

Converted FEEDBACK web application back-end database originally in MySQL to Oracle 10g.

Received training on HIPAA Privacy and Security in order to comply with HIPAA privacy regulations.

03/08-06/08 Sempra Subsidiary – San Diego, CA

DATABASE ADMINISTRATOR

ETL administrator ensuring that existing jobs complete on time and checking for errors.

Organized a conversion effort of Oracle PL/SQL reporting queries to be used in the MSSQL Server T-SQL 2005 environment. Total of over 300 PL/SQL routines converted to T-SQL routines.

Designed and coding ETL routines for loading data from Excelergy Oracle to LoadStar MSSQL Server databases.

Responsible for creating, testing/validating complex SQL queries across multiple environments including PL/SQL and t-SQL and PRO*C for stored procedures and functions and C for reporting.

06/07-01/08 Linsco Private Ledger – San Diego, CA

TECHNICAL PROJECT LEAD

Led the development team for the BranchNet Pershing Integration project which

provided data to an integrated trading system enabling advisors of a brokerdealer system to view data from multiple disparate sources.

Managed the development of Informatica PowerCenter v8.x workflows, as well as database schemas, ETL processes utilizing an in-house proprietary job scheduling system.

SQL Server 2000 and 2005 were utilized on Windows platforms using T-SQL.

Managed technical developers, prepared system specification documentation, built and deployed servers, and prepared release documentation to support the SDLC release process.

Developed stored procedures, functions, and reports using C and PRO*C.

09/06-05/07 SDDPC – San Diego, CA

DATABASE ARCHITECT / ADMINISTRATOR

Installed, configured, tuned, and re-architected production criminal and mapping databases using MSSQL Server 2000 and 2005 using T-SQL. These databases supported a variety of law enforcement web sites.

Performed production DBA monitoring of all database servers. These included crime search, mapping, and SDPD data as well as various flavors of 3rd party databases.

Created and maintained job schedules for ETL processing.

Performed security audits, enforced best practice database design methodologies.

Re-designed the SAN partition layouts for disk I/O database performance and future growth.

Developed, tested, and documented Disaster Recovery (DR) practices for Oracle as well as MSSQL Server databases.

Upgraded databases from MSSQL Server 2000 to MSSQL Server 2005.

Upgraded and supported blade servers as well as preparing SAN for VM-ware applications.

Prepared project plan, analyzed, designed and began porting the CALPHOTO database running on Oracle 9i to SQL Server 2000 and 2005 using T-SQL. This involved the re-design of the schema using ERWin as well as reverse engineering, documenting, and analyzing all of the PL/SQL code including triggers, functions, stored procedures, etc.

Patched and performed maintenance and upgrades of production SQL Server databases systems.

Migrated databases from the different states: DEV to QA to PROD states.

Developed project plan, migration plan, and target schema for CalPhoto image database ported from Oracle to SQL Server.

Developed enterprise OLTP schema for the ATD crime database using ERWin. The Global Justice XML format was used in the model in order to ensure proper mapping of data feeds coming in and going out of the database.

Performed schema comparisons and maintained production and QA/test databases.

Designed target schema for SDPD database using MSSQL Server and T-SQL. DTS jobs and job scheduler tasks were used to refresh the data on a daily basis.

Responsible for creating, testing/validating complex SQL queries across multiple environments including PL/SQL and t-SQL.

Utilized a variety of DBA tools including Spotlight on MSSQL Server, Spotlight on Oracle, DBArtisan, Quest Toad with DBA option, ERWin, and T-SQL. Posted server and database architecture information on the Intranet Wiki.

7/06 – 9/06 Time Warner Cable, San Diego, CA

DATABASE ARCHITECT

Re-architected the back-end ETL process supporting the Call Center reporting data warehouse using Microsoft SQL-Server.

Designed new data warehouse reporting system that provided statistics which improved the Quality of calls and workorders, and also improved Call Responses thru providing information on attendance, availability, schedule compliance, and other business statistics.

Source systems included Sybase, Oracle, SQL Server databases.

4/06 – 6/06 eSignal Corporation, Hayward, CA

DATABASE CONSULTANT

Provided production and application DBA support for Microsoft SQL-Server and Oracle9i database systems for various on-going projects.

Managed the configuration, testing, and release of new production SQL Servers.

Wrote and tested SQL Server stored procedures and Oracle PL/SQL to implement business logic.

Developed SQL coding (SQL Server and Oracle) including PL/SQL and Unix Shell Scripting.

Migrated databases to/from SQL Server to Oracle.

Performed database performance tuning, monitoring, and troubleshooting.

Managed Oracle9i on Linux operation system.

Performed Oracle Partitioning, RMAN, Statspack, SQL*Loader tasks.

Implemented RAID on SQL Server machines.

Experience and knowledge of HTML, ASP, Visual Basic 6.0, VB.Net and other web development languages and tools was required.

7/05 – 4/06 San Diego County, San Diego CA

DATA WAREHOUSE ARCHITECT

Lead the Datawarehouse team in the methodologies and tools utilized in the deployment of the San Diego county IPTS datawarehouse.

Architected the design of the Datawarehouse including dimensions, cubes, ETL process, job scheduling, and reporting queries.

Performed basic project management tasks including planning, estimating, status reporting and scope management.

Met with vendors and aided the negations as well as 3rd party tool selections as well as licenses for databases and hardware configurations.

Mentored and trained project team members in the implementation and use of latest datawarehouse tools and methodologies including Oracle10g, Oracle Warehouse Builder, and various reporting tools.

Worked with business users to define user requirements and business rules.

Developed standards and prescribed a defined software development life cycle methodology

Ensured the integrity, reliability, efficiency, and data quality of the BI design and resulting infrastructure.

Developed the detailed data architectures that support the enterprise and defined the data standards for enterprise systems.

Reviewed and assessed all major database designs for implementation feasibility, ensuring that data structure aligned with business goals, intended use, and flexibility of design.

Translated business requirements into implementation process by considering all alternatives and implementing the best strategy to ensure design meets performance, usability, reliability and scalability requirements.

Participated in the definition of both functional and non-functional requirements of a system and defines the development strategy, standards and support tools.

Performed analysis and conceptual design to ensure high-level designs are accurately documented and receive the appropriate stakeholder approval.

Tracked all tasks and deliverables throughout the phases of the project.

DATA MIGRATION SPECIALIST

Designed and implemented the data migration and profiling methodology of up to 40 source legacy systems using Similarity Systems Axio 4.x and IBI Data Migrator 5.3 and 7.1.

Lead the efforts to design and develop both the OLTP database target and OLAP datawarehouse for the San Diego County IPTS property tax system. Included a reporting datamart and delivered daily canned reports as well as ad hoc reports using JReports server.

Managed consultants working on Enterprise data modeling, 3rd party vendor consultants providing business and data knowledge, as well as the data migration strategy.

Systems included: Oracle 10G, Solaris 10, Windows 2003 Enterprise Server, SQL Server 2000 and 2005, Similarity Systems Axio data profiling toolset, IBI Data Migrator and IBI commercial adapters to mainframe legacy systems.

4/04 – 2/05 Intuit, La Jolla CA

SYSTEM CONFIGURATION MANAGER CONSULTANT

Technical project manager responsible for creation, maintenance, and enforcement of System Configuration Management best practices for Legacy Datawarehouse systems including both Oracle and SQL Server Data Repositories.

Managed team of resources responsible for the development and QA testing of the company’s core datawarehouse systems.

Managed build processes and directed resources who prepared architectural documentation in support of the entire build procedures.

Software Tools include: Oracle 9i, Informatica PowerCenter Designer/Repository Manager/Repository Server Admin Console/Workflow Manager/Workflow Monitor 6.2.1, Business Objects, Siebel 7.5.26, Tidal (job scheduler), and Hyperion. PRO*C and C programs used to support batch and online processing.

Provided technical project management direction of a team of datawarehouse developers, testers, and business members during the migration of four large Enterprise Intelligence projects.

9/01 – 3/04 Classified Ventures, Chicago IL

DATABASE ARCHITECT AND DATAWAREHOUSE TEAM LEAD

Lead the team in the use of appropriate methodologies and strategies for both data warehouse and OLTP system.

Lead the re-architecture and re-configuration of both OLTP and Data Warehouse applications.

Developed project plans to re-architect and migrated SQL Server 7.5 to SQL Server 2000 for Customer Center application a multi-TB Hybrid (OLTP+OLAP) application ported to Hitachi SAN.

Lead the effort to ensure that proper data modeling was performed company-wide using ERWin 3.5.1 and 4.0.

Supported the entire project lifecycle from detailed functional specification through design, coding, QA/test, and production release. Approximately 50% technical management and 50% technical consultant.

Established business requirements and documentation standards for new and modified business processes using Visio Professional.

Responsible for the enforcement of change control policies throughout the business vertical.

DBA Backup/Recovery and Disaster Recovery

Implemented redundant backup and recovery strategies including hot and cold backups, scheduled nightly exports, and archivelogmode. Used RMAN and operating system utilities to perform backups.

Developed thorough DR plans for several production systems. Extensive use of PRO*C and C for stored procedures and reporting.

Environment: SUN Enterprise running Solaris, Netscape, Dynamo, Erwin, Oracle 8i/9iAS/10G, SQL Server 7/2000, Visual Source Safe, Business Objects.

Past 2 Years DePaul University Chicago, IL

DATABASE TUNING INSTRUCTOR

Oracle database instructor teaching database administration courses during fall, winter, and spring sessions.

11/00 –8/01 Global Training & Consulting Inc., Emeryville CA

TECHNICAL MANAGER/CONSULTANT

Managed teams developing multimedia on-line Internet training courses deployed on NT server and IIS 4.0 for Oracle certification. The training courses were prepared using Trainersoft Professional are preparatory for Oracle8i and 9i Database Administrator and Oracle Applications 11i certification.

Managed system administration functions on SUN E450 (Solaris 8) and numerous NT 4.0 Servers running Oracle8i/9i databases, Apache web servers, and Oracle Apps11i applications. Utilized Oracle/UNIX compliant scheduling tools for Enterprise backup and recovery. Developed UNIX toolset for integrated tuning and operations of distributed clustered file systems.

Managed migrations from Apps 10.x to 11i and performed gap analysis of new features. Trained in Oracle Apps 11i functional and technical implementations.

Responsible for the installation, configuration, and gap analysis of Oracle 11i on NT and Solaris 8. Managed project timelines and also provided hands-on technical expertise on Apps 11i rollouts.

Managed the installation, configuration, and administration of Siebel 2000 CRM product suite.

Developed commercially available Oracle database reporting toolkit using Visual Basic and Crystal Reports. Reporting capabilities included sending daily reports to DBAs and managers, and alerts.

Environment: Oracle 8i, 9i, PL/SQL, UNIX, Solaris 8, SUN E450, Visual Basic 6 Pro, Crystal Reports, Siebel 2000, Oracle CRM, Oracle Apps 11i.

6/00 –11/00 Yipes Communications Inc., San Francisco CA

PROJECT MANAGER

Lead the interface project team in the design, development, testing, and deployment of interfaces between the Siebel and Remedy applications.

Responsible for installation, configuration, and administration of Siebel on NT and Solaris platforms.

Prepared functional and design specification documents for the interfaces including flow-through mapping, collaborative design, cross referencing (static and dynamic), and canonical mappings between application specific and generic business objects.

Acted as test manager, gathered and documented required test data requirements for unit testing and system testing Siebel applications.

Managed the testing efforts across application environments for Siebel to 3rd party applications.

Performed Enterprise data mapping using DataJunction, ERWin, and ActiveWorks tools of Siebel back end with other 3rd party products.

Developed Siebel message queueing system prototype using IBM MQ Series using Java and XML. This home grown system was compared to the Active Works product.

Configured and installed DEV, QA, and PROD instances of Oracle and Siebel.

Developed batch jobs for data synchronization using Siebel’s EIM toolset.

Managed enterprise sales and marketing reporting system using Actuate and Siebel based upon Oracle database repository.

Environment: Sun Solaris 8 and NT, Java, ActiveWorks, Oracle8i, PL/SQL, IBM middleware, Siebel, Remedy.

2/00 – 5/00 Nortel Networks, Santa Clara CA

PROJECT MANAGEMENT AND SENIOR TECHNICAL CONSULTANT

Managed a team developing the Special Business Approval Manager application, a web-based approval system using an Oracle back-end database, gathered and documented functional and design requirements for the system. Acting as test manager and configuration control manager, developed all support systems including document control and source code control systems.

Designed and implemented the schema and business rules for the SBA application.

Maintained project repository using Visual Source Safe and acted as version release manager.

Acted as Quality Assurance manager during the testing phase of this project which was completed on time and on budget.

Environment: Oracle 8.x, Visual Source Safe, PL/SQL, NetDynamics, Visual Basic.

4/98 – 12/99 JUSCO Co., Ltd., Chiba Japan

SENIOR TECHNICAL CONSULTANT

Lead technical manager and architect providing guidelines and analyses of future IT systems. Performed business process and data modeling at the Enterprise level and provided guidance in the development of migration and integration strategies within a datawarehousing environment .

Responsible for leading the technical evaluation of three major software systems including the new Merchandise Management System, Store System, and Logistics Warehouse Management System.

Efforts included team coordination, strategy, preparation, analysis, and presentation of technical sections of the three Request for Proposals (RFP’s) related to the three new sub-systems.

Prepared and coordinated scoring of the technical results, leading the on-site vendor visits and technical demonstrations, and prepared summaries of the technical findings.

Datawarehousing activities involved some HR and finance related areas.

Managed and lead 3 groups with 250 technical and non-technical people (issue management) over multiple locations.

Configured and sized future hardware configurations for future sub-systems including Conference Room Simulation (CRS), Pilot, and Production environments. Systems conformed to the JUSCO’s future architecture and operational standards (e.g. Oracle, SUN, Solaris, Win NT, CORBA) that were proposed.

Performed system operational tools assessment and eventual integration into the legacy-client/server environments. System operational tools utilized included Hitachi JP1 / JP Walker. Other tools that were fully integrable were also considered (CA Unicenter, Tivoli, and others.) These tools were used to monitor the enterprise and perform daily scheduled tasks such as: automated backups, automated PC updates, and batch scheduling.

Prepared and tracked technical schedules and participated in Program Management Office (PMO) activities providing roles, deliverables, standards, and training plans for the modified organization.

Recommended, prepared, and performed training on relevant technical software tools including data and business modeling, data mapping tools from legacy to client-server systems, database/network/server performance analyses, and software configuration management.

Performed Oracle and client-server training sessions to teach the technical project team members the essence of relational database technology and in particular the Oracle RDBMS.

Developed and enforce source code control systems, business process modeling, and weekly reporting of issues for the entire enterprise.

Environment: Oracle 8.x, PL/SQL, Sun Solaris, NT, CORBA, E10000.

2/97 –12/97 Genentech Inc., San Francisco CA

CONSULTANT TO THE ASSOCIATE DIRECTOR OF MEDICAL AFFAIRS IT

Tasks included the selection and implementation of various software tools in support of the Software Development Life Cycle (SDLC), Configuration Management, Oracle*Clinical enhancements (batch scheduling), and Data Warehouse efforts using Oracle 7 and SAS.

Implemented several systems in support of the pharmaceutical approval cycle of new drug testing including Labs File Transfer across a firewall, generic pre-processing and filtering of data eventually loaded into the Oracle*Clinical application, and selection and implementation of Software Configuration Management tools including: PVCS, ClearCase, ClearGuide, and DTTS (bug tracking). Also involved in Informatica architecture, SAS/DW, and exposure to COGNOS within the environment.

Hardware consisted of Digital Alpha UNIX, Hewlett-Packard HP/UX, Sun Solaris, Win'95, and NT4.0 running Oracle Version 7. Wrote UNIX shell scripts to perform daily processing of file transfer and other scheduling tasks which integrated AutoSys with Oracle*Clinical, and other UNIX database and web systems.

9/87 – 9/96 Other Employment History

ORACLE DEVELOPER, DBA AND DESIGNER ON SUN UNIX SYSTEM

Vest Technologies

Designed and implemented an Oracle 7 database solution to support the Style On-Line web-based application that selects clothing from the database suitable to user-selected characteristics defined on the Web application.

Charles Schwab

Designed and implemented the Oracle 7 database for the Mutual Funds Performance Guide that supports an on-line Internet web page application. The work was performed on a number of Oracle database servers using Sun equipment and the AIX operating system. Wrote stored procedures and triggers using PL/SQL.

Pacific Bell

Prepared PL/SQL packages and alerts procedures for daily monitoring and tuning of Oracle Version 7 production database instances on SUN/OS. Wrote UNIX shell scripts that automated the UNIX and Oracle administration functions that guaranteed the successful running of the production server.

First National Bank of Chicago

Responsible for performance tuning of production quality ORACLE Reports 2.5 and FORMS 4.5 marketing application in a client-server environment including OS/2

Contact this candidate