SUMMARY:

• Oracle professional with 15 years' experience as a developer, systems analyst, data analyst, data modeler and DBA. He has experience with HR, accounting
• ERP, MRP, call center, communications, (medical) insurance, government and sales applications, which could range from handling nearly static data to fully OLTP enterprise systems. To compliment his technical expertise, he has excellent oral and written communication skills.
• Experienced with data modeling and process modeling methodologies (and tools).
• Comfortable setting up and directing meetings, and keeping teams cohesive and productive.
• Perfectly at ease creating documentation - -including diagrams and graphs (even cartoons).
• Participated in every step of development from requirements gathering to implementation.
• Familiar with current business intelligence and data mining schemes.
• All-around creative, original and organized thinker.
• Experienced with sourcing and auditing data, including effective-dated data.
• Comfortable with version control, problem tracking systems and SDLC.
• Familiar with project management protocols.
• Able to produce almost any kind of report exploiting all tools available.
• Naturally, able to write software for analytical tasks impossible for humans, when necessary.

TECHNICAL SKILLS:

Hardware: HP9000, PCs, Sun, Mac

OS Literacy: Windows, NT, SCO, AIX, SunOS, System V, MacOS, Linux, HPUX.

Languages: PL/SQL, SQL, SQL*Plus, C, C++, PRO*C, LISP, UNIX Shell, Spanish.

Software / Tools: Oracle Forms and Reports (v2.5/4.5-6.0) development. Oracle Developer 2000, Erwin, PVCS, Visio, DBArtisian, PeopleSoft, Visual Studio.

DBA: Oracle 6, 7.x, 8.x, 9.x (i), 10g and related tools such as SQL*Loader, SQL*DBA, DBArtisian, TKProf and networking utilities.

Sys. Admin: SCO, NT, SunOS, System V.

Analysis: Human Resources, Accounting, Customer Service, Marketing, Telecommunications, ERP and Insurance businesses.

Methodologies: Reverse engineering, OOP, Data Warehousing, OLTP, modeling, tuning and configuration management.

PROFESSIONAL EXPERIENCE:

Confidential

DBA, Analyst

Environment: Oracle, Windows NT, C#, Visual Studio

Responsibilities:

• Participated in the design of an (ultimately) snowflake mart/OLTP database whose function was to collect information via data entry forms and back-end loads as well provide business intelligence.
• Implemented referential integrity, indexes, security and triggers where necessary, taking full advantage of all Oracle capabilities.
• Required to learn C#, design and write supporting programs to validate incoming data.

Wisconsin Physicians Service

Oracle Programmer/Analyst

Software Environment: Oracle, UNIX

Developed programs to implement a new alternate ID system for the company. These automatic nightly feeds to document tracking and claim processing systems would provide changes in customer social security numbers to a new internal scheme.

• As this was back-end processing on a UNIX system, all capabilities of the OS and Oracle were utilized to develop a robot user for said batch processing.
• Implementing projects hinged on capabilities only offered with later versions of Oracle supporting functional indexes, file I/O, auto extending tablespaces and dynamic SQL.
• Gained valuable analytical experience dealing with a large-scale expert system, itself a robot user.
• Required to provide assessments for potential future projects involving Oracle systems.

Confidential

IT Support

Environment: Windows, related networking hardware

Responsibilities:

• Custom products developed were Oracle packages, procedures and custom views utilizing PL/SQL and SQL.
• Required a very rapid assessment of customer’s snowflake data mart scheme and related BI procedures and products.
• All custom software and related objects were fully documented.
• Platform: Oracle/UNIX

Confidential

Programmer/Analyst

Environment: Windows NT, Oracle, Linux

Responsibilities:

• Developed and tuned loads to customer's datawarehouse exploiting custom programs and SQL*Loader on a rather massive scale.
• Created Oracle 7 (for AIX on Linux) database and tables as personal project to hold linguistic data.
• Completed several short, but demanding, contracts involving large datasets, hardware and network support.

Confidential

Developer/DBA

Environment: Oracle, UNIX

Responsibilities:

• All coding in PL/SQL and SQL, primarily for reporting but also for ETL purposes.
• DBA responsibilites included all account management for users, monitoring system for error logs, performance and space issues and maintaining security.
• Platform: Administration and maintenance of Oracle 8 Database on UNIX with application running under Citrix/Metaframe.

Confidential

Developer/Analyst

Environment: Oracle, Windows NT (Reports, Forms, Cognos, Crystal Reports)

Responsibilities:

• PL/SQL batch programming, Oracle Reports and Forms development through versions 6.0
• Responsibilities include pay-affecting data.
• Implemented the use of real-time ETL between HR and accounting OLTP products using custom triggers and modeling intermediate database for data transforms.
• Implemented version control for the most business critical applications in the company (EZAccess, Humanic, SQL*Time) using PVCS.
• Responsible for design and implementation of proprietary database models, utilizing Erwin and other tools.
• Developed numerous PL/SQL stored procedures, packages and triggers.
• Consolidation and warehousing of EZAccess databases.
• Platform: Oracle/NT

Confidential

Developer/Analyst/DBA

Environment: Oracle, Windows, UNIX, Access, SQL Server, Excel, Tabula

Responsibilities:

• Responsible for designing the tables and programs for sales forecasting and creating a data warehouse for reporting.
• Performed analysis, design and development for numerous OLTP solutions in various manufacturing environments.
• Platform: Oracle, Tabula DB on UNIX or NT. User interfaces naturally on Windows.

Confidential

Developer/Analyst

Environment: Oracle, UNIX

Responsibilities:

• Developer and analyst for a number of HR applications such as the payroll system and feeds to and from benefits providers.
• Participated in the modeling and implementation of data mart and related database objects and programs.
• Authored and performed troubleshooting and maintenance on numerous programs which interacted with an Oracle (PeopleSoft) database in any combination of Pro*C, C++ and PL/SQL and UNIX shell script. Programs ranged from simple ETL applications to enterprise-level data interfaces to other companies.
• Responsible for the resulting documentation of analysis, database structure changes and impact evaluations for constantly changing business requirements.
• Platform: Oracle/UNIX

Confidential

DBA/Developer

Environment: Oracle, Windows NT, UNIX Emulation

Responsibilities:

• Maintained and implemented Developer 2000 as well as CM application.
• Windows NT/Network Administrator and database administrator.
• Software developer on Oracle as well as on UNIX shell.
• Responsible for documentation and management of software release schedules.

Confidential

DBA/Developer

Environment: Oracle, UNIX, Windows (Forms, Reports, PowerBuilder)

Responsibilities:

• Developed procedures and programs using PL/SQL for reverse engineering.
• Performed ETL analysis for data feeds from legacy systems.
• Acquired valuable experience maintaining multiple large instances, modeling, tuning, security, backup and implementing the Oracle Transparent Gateway.
• Extensive coding in PL/SQL and Designer/Developer 2000
• Platform: Oracle/UNIX

Confidential

DBA/Developer

Environment: Oracle, UNIX, Windows (Forms, Reports)

Responsibilities:

• Responsibilities included installing, configuring, upgrading and maintaining a number of lead tracking Oracle databases on a Sparc 10 and an Intel System V machine.
• Purchasing, installation, training and maintenance of all network hardware and software and development of numerous data processing applications for reporting, data entry, and interfacing with the company’s web site.
• Developed many C/Pro*C and PL/SQL applications.
• Managed all aspects of security, backup and restoration.
• Platform: Oracle/UNIX
• Installed and serviced users on Business Works Accounting and Job Costing package and developed general accounting procedures.
• Provided hardware and software support for upgrade of business computers.