PROFESSIONAL SUMMARY

• Over 15 years of experience in software design and development in an Oracle database environment, hosted primarily on UNIX database servers AIX, Solaris with various clients.
• Participation in all phases of the software development and support life-cycle, utilizing both traditional waterfall and more iterative, object-oriented and rapid development methodologies RAD, Agile .
• Gathering and clarification of business requirements through interviews with the target user community to determine their needs and expectations and through iterative prototype demonstrations/discussions.
• Designing an extensible, viable schema and suite of customized applications focused on satisfying the functional requirements as well as the analytic and reporting requirements of the business enterprise.
• Use of Oracle development toolsets on various platforms UNIX, Windows PCs and Macs recently including extensive use of Oracle Data Integrator ODI 10g with Jython and PL/SQL procedures.
• Development and implementation of differencing queries to selectively update data elements, including the transformation and loading of image data with the creation and comparison of checksums..
• Development of reporting models and methods to intelligently analyze differences in raw data feeds.
• Creation and modification of extensive PL/SQL packages, procedures and triggers, including complex SQL statements required to implement and enforce business rules and methods, the creation of cursors for data retrieval, processing and reporting, leveraging Oracle's SQL engine and optimizer.
• Data extraction and cleansing in ETL modules maintaining database and data warehouse objects, data transformation and summarization for enterprise data warehouse reporting, migration of legacy data sources into newly designed schema objects, incremental updating of database objects.
• Design, creation and maintenance of metadata repository objects and conventions to enable automated detection, downloading and publishing of raw data feeds, including data domain characteristics, business rule definitions, error tracking, data receipt reporting, and storage parameter definitions.
• Experience with Developer 10g Forms/Reports in a 10g Application Services App/Report servers .
• Ongoing support of user community including the tracking of future enhancement requests, estimating level of effort and personnel required and scheduling/coordinating deployment of subsequent releases.
• Use of various tools/techniques for SQL query optimization and analysis Explain Plan, SQL Tuner .
• Use of various interactive tools for Oracle database and server support TOAD, SQL Developer, etc. .
• Performing basic Oracle DBA and application server administrator functions, creating/supporting multiple instances for production/standby, beta testing and development operational environments, as well as the creation of SQL scripts to perform and document schema object creation and maintenance.
• Establishment and advocacy of enterprise-wide guidelines and naming conventions promoting consistency and self-documentation in data domain names, types and corresponding precision/scale.
• In general, I have a passion for understanding the complex relationships between of all types of enterprise data, and for its management, quality, structure, integration and availability in order to provide timely, relevant information to decision-makers.

EXPERIENCE

Confidential

Confidential

SOFTWARE DEVELOPER III Toyota Cornerstone Publishing

• Performed data analysis of raw data files received from various Toyota divisions as part of the Toyota Cornerstone Publishing team, especially for Toyota Fast Moving Parts catalog data feeds, Toyota and Lexus Local Parts data feeds and Toyota Canada Accessory Parts data feeds.
• Designed and implemented database objects in the raw data schema for Toyota Cornerstone publishing based on the data analysis of raw data feeds and any existing data objects in the target baseline schema.
• Designed and developed data models, interfaces and packages using Oracle Data Integrator ODI 10g and stored PL/SQL packages/procedures in Oracle 10g and 11g database instances to automatically detect, download and process raw data feed files into newly created schema objects in the raw schema.
• Created models, interfaces, procedures and packages in ODI to migrate the raw data from the raw schema into the baseline schema by incremental updates of existing table data on a changes-only basis.
• Developed and integrated modules to transform and store both vector and raster format image data including creation of SHA-256 checksums for comparisons of incoming images.
• Created functional requirements documentation of the custom data receipt system components in ODI.
• Created and maintained standardized documentation for the data analysis of the raw feeds as well as the data mapping into the related database objects in both the raw and baseline schemas.
• Created ODI packages/procedures as well as documentation to capture and load distributed user content from remote clients into a centralized Oracle database for all OEM distributors/users.
• Performed on-going support of Operations personnel in the production tier related to Toyota data receipt systems, including publishing of bulletins and additional information.
• Supplied analysis of image data sizing differences at various scaling factors to enhance performance.

Confidential

SENIOR SOFTWARE ENGINEER

• Analyzed, investigated and resolved many problems reported by users of the Electronic Parts Catalog EPC products developed by Snap-On Business Solutions and utilized throughout the world by General Motors dealers/distributors.
• Mastered the complexities of VIN filtering , including the publishing and utilization of filter rules and queries designed to retrieve the appropriate parts information based on typical usage parameters specified by the OEM and similar attributes associated with a specific vehicle by VIN .
• Resolved over fifty VIN filtering issues concerning all GM EPC products, with special emphasis on GM North America, including extensive research and analysis of the scope and impact of solutions.
• Developed modifications to PL/SQL procedures responsible for the generation of filter rules.
• Developed and tested various data-related solutions, including adjustments to code family associations.
• Documented the initial cause, results of investigation and final disposition of each problem in the issue tracking system JIRA , often with before and after screen shots demonstrating the disposition as either resolved by code/data modifications or as requiring data adjustments/reconsideration from the OEM.
• Published and maintained the list of production option codes and associated attributes as received from the OEM, including manual updating of raw source tables based on OEM spreadsheets, the republication of code-related tables and the subsequent regeneration of part filter rules based on the revised codes and their associated family attributes.
• Created documentation detailing the code maintenance procedures and the distribution of revised production code data and filter rules across all Oracle instances in Snap-On's four-tiered environment.
• Created a document in Excel capturing all of the relevant production codes used in the GM Europe product database, including all of their descriptions in each of the 20 languages supported.
• Authored a guide for new employees introducing basic concepts and terminology used in GM publishing, including links to related and important information on Snap-On's SharePoint site, as well as introducing and mentoring new employees during their first days as GM Publishing team members.
• Performed extensive testing of pending new releases of PL/SQL publishing procedures and related database objects as well as the EPC application itself to identify and resolve problems pre-release.
• Performed data analysis of raw data files received from various Toyota divisions as part of the Toyota Cornerstone Publishing team, especially for Toyota Fast Moving Parts catalog data feeds, Toyota and Lexus Local Parts data feeds and Toyota Canada Accessory Parts data feeds.
• Designed and implemented database objects in the raw data schema for Toyota Cornerstone publishing based on the data analysis performed as well as any data objects already in use in the baseline schema.
• Created models, interfaces and packages using Oracle Data Integrator ODI 10g to successfully load the raw data feed files into the new schema objects in the raw schema.
• Created models, interfaces and packages in ODI to migrate the raw data from the raw schema into the baseline schema by incremental updates of existing table data on a changes-only basis.
• Created and maintained standardized documentation for the data analysis of the raw feeds as well as the data mapping into the related database objects in both Toyota Cornerstone schemas.

Confidential

WAREHOUSE SUPPORT/ORACLE PL/SQL DEVELOPER

• Created and modified PL/SQL procedures and packages in an Oracle 10g RAC environment on Sun database servers, including processes responsible for the transformation of data from various external sources, enforcement of business rules, and creation of characteristics and metrics aggregates stored in summary tables exported to the Pricing Information Center Data Warehouse, an Oracle 10g instance accessed and utilized by Nationwide's internal management via a MicroStrategy reporting environment.
• Created and maintained shell scripts bash under Linux on an auxiliary server used to launch specific streams of the packages/procedures on the database server that performed end-of-month data processing tasks, updating data warehouse objects with current data extracted from internal business unit sources.
• Downloaded data from IBM iSeries AS/400 sources via a locally installed AS/400 Client Access Tool.
• Developed and maintained parameter/control files used by SQL Loader to upload previously downloaded raw data source files into Oracle data structures required by data warehouse processing.
• Performed the entire end-of-month and end-of-quarter data processing procedures
• Pre-processing extracts from source data instances and the mapping of new data element values and relationships into the data warehouse by manual updates in advance of month-end,
• Launching of shell scripts on the Linux server for each phase of the month-end processing,
• Monitoring the performance of stored procedures on the database servers over the entire month-end processing event, often for 120 hours 5 days continuously , correcting any data anomalies that impacted the completion of the procedural stream, investigating/analyzing and reconciliation reporting of any aggregate totals that exceeded tolerance level standards
• Migration of data structures to the data warehouse instance at the completion of processing, creation of several reports based on updated data structures, often including the manual refresh of materialized views, often with extensive use of TOAD, and the delivery of the resultant dataset usually in Excel either by email or, for larger reports, by network distribution to other servers.
• Providing detailed documentation of the performance of each package and procedure including status and elapsed times, with comparative timings vs. previous month-end processing runs.
• Authored extensive documentation of the processes utilized by PIC Data Warehouse Support including the production of an End-of-Month /End-of-Quarter Processing Manual, and the End-of-Month Reports Manual, including detailed descriptions of each step in these processes, and was responsible for the ongoing maintenance of these documents to reflect the latest methodologies, alterations and additions.
• Created various complex reports, otherwise unavailable via the data warehouse reporting environment, by the creation of custom SQL queries and PL/SQL procedures, often storing interim result sets on which the final aggregates were based, exporting and delivering the requested report/data set in Excel.
• Created foundation of a metadata repository, encompassing all objects in the data warehouse, incorporating technical as well as business descriptions/rules and the originating data source of each.

Confidential

ORACLE DESIGNER/DEVELOPER/ORACLE DBA

• Oracle DBA functions included maintenance and backup/recovery procedures of production, standby, beta testing and development Oracle 8i 8.1.7 database instances on large SUN servers under Solaris 8.
• Installed Solaris 8 on smaller Sun X-1 servers for remote sites, then installed Oracle database software and instances as well as the MARS application schema and Developer software on each remote server.
• Created and maintained transfer of data from remote servers to central database for consolidated enterprise reporting via procedures launched overnight by DBMS JOB, with status logging/reporting.
• Performed SQL query optimization/analysis using Explain Plan queries and by utilizing SQLTuner.
• Created and administered Oracle 9iAS environment on Windows2000 servers, including Forms Server and Reports Server services, ensuring bi-coastal availability from 2:00 AM to 11:00 PM PT.
• Created and maintained custom Oracle Forms and Oracle Reports modules using Developer 6i, with an emphasis on reports, utilizing the user-defined parameter list-passing feature available in Reports 6i.
• Created ETL procedures for the migration of each club's legacy data, including membership, billing and jpeg images, to the central MARS production database, with FTP sessions for remote file transfers.
• Performed application user training and support, in person and by phone, including verification and resolution of software bugs and bottlenecks via TOAD, DBArtisan, and/or SQL scripts as required.

Confidential

ORACLE DATABASE DESIGNER/DATA MODELER/BUSINESS ANALYST

• l and defined system requirements for a custom application, Deal Development Tracking DDT , that tracked all contractual and other financial commitments by and across projects and divisions from the earliest phases of development through production. This application provided accurate tracking of over 250 million in annual commitments across all divisions of the company as well as the production of payment requisitions for over 225 million against those commitments annually.
• Developed extensive management reporting and expense reconciliation previously unavailable to Time Warner/ HBO management, creating project-specific aggregates by cost category rolled up for each division and across all divisions of HBO, using Oracle Reports modules incorporated into the DDT application.
• Designed and implemented interfaces to existing enterprise level accounting packages A/P, G/L .
• Supervised development team in an extensive redesign and reprogramming of DDT application interface from the original Mac client platform to one using Developer/2000 tools for PC clients.
• Proposed centralized Oracle database system to: Resolve intra-departmental discrepancies in contractual payment terms and current status, automate payment requisition production based on event-driven criteria, including fringe benefit payments to health/pension plans of Guilds associated with payee, track and report commitments by project and/or cost categories within/across divisions
• Performed support activities for user community in the LA and NYC offices, by phone and in person.
• Demonstrated in-house developed applications to IT and target user community, in both LA and NY.
• Supervised and performed application testing for Y2K compliance.
• Logged user enhancement requests, including priority, complexity, estimated effort to complete.
• Authored conventions/guidelines for the naming of database objects to promote self-documenting data structures enhancing the clarity of data elements available within and between application frameworks.
• Designed and implemented database schema in Oracle 8i 8.1.5 under UNIX AIX 4.3 to budget and track current and future cash flow requirements for HBO's Original Programming division.
• Designed and maintained dimensional models and created metadata universes for OLAP reporting using Business Objects 5.0 to satisfy decision support, analysis and reporting requirements, including distribution of report modules, and implementation of ad-hoc query capabilities via WebIntelligence.
• Toolset included: Rational Rose with UML and CRC cards for requirements definition and analysis BEA WebLogic EJB Server Visual Caf 3.0, JDK 1.1.7 and SourceSafe for custom EJB development and source code control SQL Navigator for schema documentation and maintenance Business Objects 5.0 for multidimensional OLAP reporting environment SQL Plus executing custom SQL scripts for 8i schema creation/maintenance and user privilege management.
• Designed data model and schema to implement application requirements for a Business-to-Business application enabling production personnel to register their expertise, experience, and availability.
• Implemented and migrated schema objects in Oracle moving from IBM AIX to Sun Solaris servers.
• Maintained a set of Perl 5.0 scripts hosted at HBO's extranet site, homeboxoffice.com.

Confidential

ORACLE DATABASE DESIGNER/NEXT DEVELOPER/BUSINESS ANALYST

• Produced formal project management plan for a custom application capturing detailed itinerary information, reservations entry, traveler preferences, and automating travel expense form generation.
• Defined purpose, scope, hardware platform, software environment, schedule of control gates and deliverables, module testing/acceptance, risk analysis and mitigation, final implementation/integration.
• Produced functional requirements definition based on discussions with users.
• Produced operational prototype demonstrating major functional requirements and look-and-feel.
• Designed and created relational database schema definition and implemented multiple instances in Oracle 6.0.33 running on several Pyramid misl2 servers under UNIX 4.3 BSD .
• Developed application using NeXTSTEP v. 2.1-3.1 /Objective-C and a new database application development tool for NeXT/Sun platforms 'Proponent' on NeXT color workstations under MACH 3.0.
• Wrote and reviewed technical documentation for accuracy, readability and adherence to standards.
• Designed and created relational database schema for a new version of their Personnel System in Oracle to capture, maintain and report data related to personnel in military and government agencies.
• Developed ETL procedures to migrate data from legacy personnel system to new Oracle schema.
• Developed, tested and implemented an English language query and reporting interface using Natural Language Inc.'s connections , relating specific words and syntax to corresponding database objects.
• Demonstrated and trained user community in new system features and reporting tools.
• Created Enterprise Data Model and other enterprise-wide entity relationship diagrams incorporating all existing database objects, facilitating the centralization of shared data objects used across the enterprise.
• Establishing standards and conventions for database object domains and names, software development procedures and style guidelines.
• Defining initial requirements and schema design for the Problem Logging and Tracking application.
• TS/SCI clearance, currently inactive, was granted after an EBI was conducted at the request of Trident Data Systems 1991 .

Confidential

ORACLE DESIGNER/DEVELOPER/CUSTOMER SUPPORT DIRECTOR

• for various business applications Accounts Receivable, General Ledger, etc. within an Oracle 6.0 environment on DEC platforms under VAX/VMS.
• Produced functional requirements definition and detailed user interface specifications, including complex database queries, reporting specifications and layouts for reporting sub-system.
• Authored design standards and conventions precisely describing interface style guidelines and reporting layout standards for product consistency and efficiency in application development.
• Coordinated support activities for all of MCBA's released products on all platforms, including the development, testing and distribution of software correction notices to the customer base.
• Developed a Bug Reporting and Tracking system by which all software bug reports could be logged, reviewed, routed to the appropriate personnel for the development of a patch or workaround.
• Worked directly with customers by phone in the analysis, reporting and resolution of their problems.