PROFILE SUMMARY:

• Confidential is a Data Modeller/Data Architect/DBA, System Analyst, Application Developer and Teacher with over 20 years professional experience in the Information Technology and Education fields.
• In the past few years, Confidential has gained extensive experience on many projects utilizing Data Modelingtools(ERWin, Enterprise Architect, Oracle Designer, ER Studio), Data Architecture and PL/SQL on various platforms such as UNIX and Windows.
• Confidential has demonstrated flexibility and initiative by adapting very quickly to all work environments and is respected by his peers and subordinates.
• He has shown the ability to work on many consecutive projects, handle pressure, and still maintain the same quality service level to his clients.
• Confidential has shown on his previous projects his dedication and desire to give more than what is required by the client.
• Confidential has proven himself to be an invaluable technical resource, who is capable of understanding challenging projects and delivering within tight time frames.
• He is a confident and capable resource with good interpersonal skills and would be a welcome addition to any client site as either a sole resource or as a member of a project team.

PROFESSIONAL EXPERIENCE:

Confidential

IM Architect/Data Architect

Responsibilities:

• Responsible for the design of the Enterprise logical and physical ESDP data model.
• Met with various business groups to gather and confirm business requirements
• From paper and electronic based documentation designed the ESDP data model.
• Took a data and application driven approach to define Data Architecture going forward.
• Created a Master Data structure which will be used across the Enterprise
• Led the horizontal working group to identify and define business terms across the Enterprise.
• Met with Senior Management to present the new data governance roadmap moving forward.
• Analyzed the impact of Data Architecture changes to current and future systems.
• Developed new data architecture documents to be followed for any new future systems.
• Analyzed the quality of the existing data to be migrated and integrated from old to new database.
• Reviewed the quality of the existing data to be migrated to future systems.
• Defined documentation on how the data will be governed going forward.
• Created a strategy to ensure security and access of departmental data.
• Developed database procedures and packages.
• Conducted walkthroughs with Confidential staff and senior management.

Environment: Oracle 11g, Oracle SQL developer data modeller, Erwin, windows 7, Oracle Apex

Confidential

DBA/Database Developer

Responsibilities:

• Responsible for the support and development of all Enterprise Applications.
• Created Ad Hoc reports for Management using SSRS
• Supported application developers database change requests
• Met with clients to discuss and define new business requirements

Environment: Oracle 11g, SQL Server 2012, SSRS, PL/SQL developer, Windows 7

Confidential

Database Architect/Database Modeller/DBA

Responsibilities:

• Responsible for the design and implementation of the Enterprise Data Model for SBMS.
• Used ER/Studio for the Enterprise Data Management design and implementation as well as the metadata repository
• Designed and developed the logical data model for the OLTP application.
• Designed and developed the physical model for the OLTP application.
• Mapped data from external systems to SBMS
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Performed database related promotions to UAT and Production
• Created databases for development and quality assurance
• Created conversion scripts to transfer data from one database to another.
• Participated in Enterprise Data Architecture meetings and decisions.
• Created a corporate standardization process by which all elements in a business data set are driven to conform to a common understanding of the terms, definitions and values.
• Created data standards and naming conventions document for SBMS
• Monitored database performance and tuned accordingly within a Multiple Virtual Storage environment
• Created and generated all oracle data structures and DDL to the database using ER/Studio
• Designed relational database to third normal form.
• Provided input and advice into the Master Data Management model for MDM.
• Provided technical advice to client
• Used Use Cases to lead conceptual, logical and physical documentation and design on future system.
• Attended and led weekly JAD sessions
• Assisted client in definition of data requirements

Environment: ER/Studio, Microsoft Visio, Windows XP, Oracle, SQL/Developer.SQL Server 20085,SQL Server 2008 R2

Confidential

Senior web developer/DBA

Responsibilities:

• Responsible for the development and implementation of the Amateur Boxing Database.
• Used Oracle Apex for the Enterprise Data Management design and implementation as well as the metadata repository
• Managed the metadata of the data model including the logical and physical models as well as descriptions of schemas, fields and columns and data integrity rules
• Developed Apex reports and forms for data entry.
• Provided technical advice to client
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible.
• Installed configured and implemented the application and database for client
• Used the Agile approach for best practices for application development
• Documented the development, design and installation procedures.
• Assisted client in definition of data requirements.

Environment: Oracle Apex, Microsoft Office, Windows XP, PL/SQL developer, Oracle 10G.

Confidential

Database Modeller/Data Architect

Responsibilities:

• Responsible for the design and implementation of the Enterprise Data Model for LFP.
• Used Erwin for the Enterprise Data Management design and implementation as well as the metadata repository
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Created data standards and naming conventions document for LFP
• Designed and developed the logical data model for the OLTP application.
• Designed and developed the physical model for the OLTP application.
• Provided technical advice to client
• Peer reviewed dimensional data models.
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible.
• Used Use Cases to lead conceptual, logical and physical documentation and design on future system.
• Attended and led weekly JAD sessions.
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Created a corporate standardization process by which all elements in a business data set are driven toconform to a common understanding of the terms, definitions and values.
• Created functional design definitions for SVR using Microsoft Office Suite
• Assisted client in definition of data requirements.

Environment: Erwin, Microsoft Visio, Windows XP.

Confidential

Database Developer

Responsibilities:

• Responsible for the migration of databases from a non unicode to Unicode database
• Created scripts to modify existing database structures to conform to a Unicode database
• Modified PL/SQL packages to conform to new database standard
• Modified application code to conform to new application standard
• Created data manipulation scripts to conform data to new standard
• Attended weekly JAD sessions

Environment: Erwin, Oracle 10g, Toad

Confidential

Database Modeller / Data Architect

Responsibilities:

• Responsible for the redesign and implementation of the Enterprise Data Model for MDR
• Analyzed and modified physical data model for SWI to enhance performance and scalability.
• Used Erwin for the Enterprise Data Management design and implementation as well as the metadata repository
• Facilitated and chaired a working group for Master Data Management(MDM) and CRM(Customer relationship management)
• Designed and developed the logical data model for the data warehouse.
• Designed and developed the physical model for the data warehouse.
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible.
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Created virtual unified views to view all information from multiple silos.
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Used Team Foundation Server for database script source control.
• Reviewed the .net architecture for the Single Window application
• Shared project documentation using Team Foundation Server
• Used Team Foundation Server to track service and change requests.
• Created a corporate standardization process by which all elements in a business data set are driven toconform to a common understanding of the terms, definitions and values.
• Used Erwin tool to model database
• Developed the Data Modelling standards for the Enterprise
• Analysed exiting architecture/engineering design
• Created data standards and naming conventions document for MDR
• Created Point In Time(PIT) and auditing for the Enterprise Data Model
• Created and lead conceptual, logical and physical documentation and design on future system.
• Created document of findings to senior management
• Performed database refreshes from Production to non - production environments
• Performed database related promotions to UAT and Production
• Designed backup and recovery strategies
• Created databases for development and quality assurance
• Managed Database security, roles and user role assignment
• Attended weekly jad sessions to review project progression
• Created data definition structure from data requirements.
• Created required documentation of system development using Microsoft Office Suite
• Assisted client in definition of data requirements.
• Modified physical database model according to business rule changes and user requirements

Environment: Erwin, SQL Server Windows XP, Sharepoint, SQL Server 2005, Team Foundation Server 2010, Oracle 10G database.

Confidential

DBA/Oracle Architect/Data Modeller/Developer

Responsibilities:

• Re develop and migrate EAUTS visual basic application to Oracle Forms 10G.
• Lead the implementation of project design, standards and processes.
• Designed and developed the logical data model for the OLTP application.
• Designed and developed the physical model for the OLTP application.
• Debug and unit test modules before deployment to QA.
• Trouble shot technical data issues and code
• Responsible for the design and implementation of the Enterprise Data Model for Confidential .
• Created the conceptual, logical and physical data model for Confidential .
• Used Enterprise Architect for the Enterprise Data Management design and implementation as well as the metadata repository
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Created a virtual schema combining multiple data sources together
• Monitored database performance and tuned accordingly within a Multiple Virtual Storage environment
• Gathered business requirements from existing application teams and business owners
• Used Visio to produce the Model diagram for the Subject Area to support functional area integration .
• Used the Agile methodology to accelerate delivery
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Created data standards and naming conventions document for Confidential
• Created PL/SQL packages and
• Performed database refreshes from Production to non-production environments
• Performed database related promotions to UAT and Production
• Designed backup and recovery strategies
• Created databases for development and quality assurance
• Managed Database security, roles and user role assignment
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible.
• Created a corporate standardization process by which all elements in a business data set are driven to conform to a common understanding of the terms, definitions and values.
• Indexed columns and keys for increased performance
• Created complex material views for reporting purposes
• Mentored junior developers
• Used Oracle Reports for BI reporting
• Attended and led weekly JAD sessions.
• Created strategy to archive data.
• Created ETL procedures for the conversion/migration of multiple legacy systems data from source and to target database
• Created data definition structure from data requirements.
• Created required documentation of system development using Microsoft Office Suite
• Modified physical database model according to business rule changes and user requirements.
• Implemented user level security and account management at database and client level.
• Analyzed exiting data architecture and design to improve on efficiency.

Environment: Erwin, Designer 10g, Reports 10g, Oracle 10g, Forms 10g, Oracle BI Reports 10g, J2EE, C, Enterprise Architect, Oracle IDS, Oracle 11g CASE,SQL Server 2005, Java, Oracle Configuration Management, PL/SQL, UNIX, Oracle Portal, Java Script, PeopleSoft, Enterprise Architect, Windows NT, Toad database administration tool.

Confidential

DBA/Data Architect

Responsibilities:

• Analyzed current data architecture, design and sizing
• Created document of findings to senior management
• Created data mappings for each database
• Analyzed the departments four main databases for data consolidation

Confidential, Housten, Texas

Oracle Web Developer

Responsibilities:

• Met with client to review required application changes
• Conducted impact analysis of requested changes on Imaging system
• Modified the application code to implement business requirements
• Modified the database to conform to application changes
• Conducted testing with the testing team to confirm changes were correctly implemented

Environment: Designer 10g, Reports 10g,SQL Server 2005, Oracle 10g, Forms 10g, Oracle BI Reports 10g, J2EE, Windows XP, Toad database administration tool.

Confidential

DBA/Database Modeller / Data Architect

Responsibilities:

• Responsible for the design and implementation of the Enterprise Data Model for OMSR.
• Analyzed and modified physical data model for OMSR to enhance performance and scalability.
• Used Oracle Designer for the Enterprise Data Management design and implementation as well as the metadata repository
• Used Visio to produce the Model diagram for the Subject Area to support functional area integration .
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Mapped data from the Data Warehouse model to the OLTP model.
• Gathered business requirements from existing application teams and business owners
• Provided technical advice to client
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible
• Monitored database performance and tuned accordingly within a Multiple Virtual Storage environment
• Performed database refreshes from Production to non-production environments
• Performed database related promotions to UAT and Production
• Designed backup and recovery strategies
• Created databases for development and quality assurance
• Managed Database security, roles and user role assignment
• Created a corporate standardization process by which all elements in a business data set are driven to conform to a common understanding of the terms, definitions and values.
• Used the Agile methodology to accelerate delivery
• Used Use Cases to lead conceptual, logical and physical documentation and design on future system.
• Attended and led weekly JAD sessions.
• Analyzed, defined and documented business and system data requirements
• Used Oracle Reports for BI reporting
• Created logical and physical OLTP application for system renewal.
• Created and documented conversion strategy from source system target database.
• Created functional design definitions for OMSR using Microsoft Office Suite
• Assisted client in definition of data requirements.
• Modified physical model to enhance performance and scalability.
• Modified physical database model according to business rule changes and user requirements

Environment: Designer 10g, Oracle 10g, SQL Server 2005, Oracle BI Reports,Windows XP, PL/SQL Developer.

Confidential

Data Modeller/Data Architect

Responsibilities:

• Responsible for the design and implementation of the Enterprise Data Model for RDHI.
• Analyzed and modified physical data model for RDHI to enhance performance and scalability.
• Used Erwin for the Enterprise Data Management design and implementation as well as the metadata repository
• Managed the metadata of the data model including the logical and physical OLTP data model as well as descriptions of schemas, fields and columns and data integrity rules
• Analysed exiting architecture/engineering design and system size.
• Provided technical advise to client
• Used Use Cases from BRD to lead conceptual, logical and physical documentation and design on future system.
• Created data standards and naming conventions document for RDHI
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible.
• Created a corporate standardization process by which all elements in a business data set are driven to conform to a common understanding of the terms, definitions and values.
• Attended and led weekly JAD sessions.
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Created data definition and data mart structure from data requirements.
• Designer Oracle Forms 10g web prototype.
• Created functional design definitions for RDHI using Microsoft Office Suite
• Assisted client in definition of data requirements.
• Modified physical database model according to business rule changes and user requirements

Environment: Designer 10g, Erwin, Oracle Forms 10g, Oracle BI Reports, Microsoft Visio, Windows XP, PL/SQL Developer.

Confidential

DBA/Database Modeller / Data Architect

Responsibilities:

• Responsible for the design and implementation of the Enterprise Data Model for SVR.
• Analyzed and modified physical data model for SVR to enhance performance and scalability.
• Used Erwin for the Enterprise Data Management design and implementation as well as the metadata repository
• Managed the metadata of the data model including the logical and physical OLTP data models as well as descriptions of schemas, fields and columns and data integrity rules
• Database Developer for medium scale multi tiered (3 tier) applications
• Provided technical advise to client
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Monitored database performance and tuned accordingly within a Multiple Virtual Storage environment
• Created data standards and naming conventions document for SVR
• Used Use Cases to lead conceptual, logical and physical documentation and design on future system.
• Attended and led weekly JAD sessions.
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible.
• Created a corporate standardization process by which all elements in a business data set are driven to conform to a common understanding of the terms, definitions and values.
• Created PL/SQL packages and procedures
• Created complex material views for reporting purposes
• Analysed exiting architecture/engineering design and system size.
• Created functional design definitions for SVR using Microsoft Office Suite
• Assisted client in definition of data requirements.
• Modified physical model to enhance performance and scalability.
• Modified physical database model according to business rule changes and user requirements

Environment: Designer 10g, Oracle 10g, Oracle BI Reports,Erwin, Microsoft Visio, Windows XP, PL/SQL Developer, Toad.

Confidential

Database Modeller / Data Architect

Responsibilities:

• Responsible for the design and implementation of the Enterprise Data Model for GLMS.
• Analyzed and modified physical data model for GLMS to enhance performance and scalability.
• Used Oracle Designer for the Enterprise Data Management design and implementation as well to design and develop the logical and physical data model
• Used Visio to produce the Model diagram for the Subject Area to support functional area integration .
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Database Developer for medium scale multi tiered (3 tier) applications
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Used pl/sql to write conversion scripts from source system to target
• Used Oracle Designer CASE tool to model database
• Provided technical advise to client
• Created and lead conceptual, logical and physical documentation and design on future system.
• Created data standards and naming conventions document for GLMS
• Analyzed current data architecture, design and sizing
• Created document of findings to senior management
• Attended weekly jad sessions to review project progression
• Created data definition structure from data requirements.
• Created required documentation of system development using Microsoft Office Suite
• Assisted client in definition of data requirements.
• Modified physical model to enhance performance and scalability.
• Modified physical database model according to business rule changes and user requirements

Environment: Designer 10g, ASP.Net, Microsoft Visio, VB.Net, Oracle 10g,Oracle BI Reports, Windows XP, PL/SQL Developer, Toad.

Confidential

Oracle Developer / Data Modeller

Responsibilities:

• Responsible for the redesign and implementation of the Enterprise Data Model for Confidential .
• Analyzed and modified physical data model for Confidential to enhance performance and scalability.
• Used Oracle Designer for the Enterprise Data Management design and implementation as well as the metadata repository
• Database Developer for medium scale multi tiered (3 tier) applications
• Used pl/sql to write conversion scripts
• Developed and executed procedures for granting, maintaining and terminating access to the Data for which the client is responsible.
• Used the Agile methodology to accelerate development
• Implementation of project design, standards and processes.
• Used designer 10g to apply system development life cycle
• Indexed columns and keys for increased performance
• Created web application using Oracle Forms 10g.
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements
• Performed database refreshes from Production to non-production environments
• Performed database related promotions to UAT and Production
• Designed backup and recovery strategies
• Created databases for development and quality assurance
• Managed Database security, roles and user role assignment
• Created a corporate standardization process by which all elements in a business data set are driven to conform to a common understanding of the terms, definitions and values.
• Created complex material views for reporting purposes
• Provided technical advise to client
• Used Oracle Reports for BI reporting
• Created and lead conceptual, logical and physical documentation and design on future system.
• Monitored database performance and tuned accordingly within a Multiple Virtual Storage environment
• Analysed exiting architecture/engineering design and system size.
• Attended weekly jad sessions to review project progression
• Created data conversion strategy from source to target database.
• Created document of findings to senior management
• Created data standards and naming conventions document for Confidential
• Created required documentation of system development using Microsoft Office Suite
• Assisted client in definition of data requirements.
• Used Designer10g to maintain all database structures as well as logical and physical data model.
• Modified physical database model according to business rule changes and user requirements.
• Used PL/SQL to created packages and procedures
• Modified physical model to enhance performance and scalability.
• Performance tuned PL/SQL code and database structures

Environment: Designer 10g, Reports 10g,SQL Server 2005, Oracle 10g, Forms 10g, Oracle BI Reports 10g, J2EE, Windows XP, Toad database administration tool.

Confidential

DBA/Oracle Developer/Data Modeller

Responsibilities:

• Responsible for the design and implementation of the Enterprise Data Model for USCord.
• Analyzed and modified physical data model for USCord to enhance performance and scalability.
• Used Oracle Designer for the Enterprise Data Management design and implementation as well as the metadata repository
• Senior Systems Analyst/Developer for medium scale multi tiered (3 tier) applications
• Created indexes on columns and keys to increase performance
• Migrated C programs to oracle PL/SQL.
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Used Oracle Designer to develop logical and physical data models for the Confidential OLTP application.
• Implemented range partitioning to speed up performance
• Performed database refreshes from Production to non-production environments
• Performed database related promotions to UAT and Production
• Designed backup and recovery strategies
• Monitored database performance and tuned accordingly within a Multiple Virtual Storage environment
• Created databases for development and quality assurance
• Managed Database security, roles and user role assignment
• Lead the implementation of project design, standards and processes.
• Used the Agile methodology to accelerate development
• Gathered information from software vendor Oracle for application version integration
• Created data standards and naming conventions document for Confidential
• Troubleshooted technical data issues and code
• Created complex materialized views for reporting
• Migrated Confidential application from Forms4.5 to Oracle 10g for the web.
• Created required documentation of system development using Microsoft Office Suite
• Created documentation and scripts for conversion strategy for moving data from source to target database for multiple legacy systems
• Created strategy to archive data.
• Attended and led weekly JAD sessions.
• Configure and deployed WEBUTIL to use with Confidential
• Created packages and procedures with PL/SQL
• Assisted client in definition of data requirements.
• Used Oracles Metadata API to retrieve database object definitions
• Help define data requirements to implement migration from Forms4.5 to 10g.
• Used Designer10g to maintain all database structures, allow access to users, and enforce integrity.
• Modified physical database model according to business rule changes and user requirements.
• Implemented user level security and account management at database and client level.
• Performance tuned PL/SQL code and database structures using 10g

Environment: Designer 10g, SQL Server 2005,Oracle BI Reports 10g, Oracle 10g, Forms 10g, Reports 10g, J2EE, C, Oracle IDS, Oracle 10g CASE, Java, Oracle Configuration Management, PL/SQL, Erwin, UNIX, Oracle Portal, Java Script, Windows NT, Toad database administration tool.

Confidential

Senior Oracle Developer/DBA

Responsibilities:

• Technical Architect for a medium scale multi tiered (3 tier) applications
• Designed work flow management system for OC Transpo
• Lead the development and creation of application using oracle forms 6i and reports for the web.
• Analyzed, defined and documented business and system data requirements
• Created object library to standardize application.
• Used Oracle Reports for BI reporting
• Maintained documentation on system using Microsoft Office Suite
• Created pl/sql procedures and packages.
• Created data standards and naming conventions document for WMS
• Attended and led weekly JAD sessions.
• Used the Agile methodology to accelerate development
• Created data definition structure from data requirements
• Created indexes on columns and keys for increased performance
• Created complex materialized views to develop query forms
• Maintained changes to data model.
• Assisted client in data conversion strategy for ETL for multiple legacy systems.
• Performance tuned PL/SQL code and database structures
• Troubleshot technical data issues and code

Environment: Oracle BI Reports 6i, Oracle 6i, Forms, J2EE, Oracle IDS, Oracle 9i IAS, PL/SQL, Windows NT, Toad database administration tool

Confidential

Senior Oracle Developer / Senior Data Modeller/DBA

Responsibilities:

• Technical Architect for a large scale multi tiered (3 tier) applications
• Analyzed existing architecture and system sizing to create a report to management
• Responsible for the conceptual, logical, and physical design and implementation of the Enterprise Data Model for ALS(Financial Center Application) and GDOC.
• Created indexes on columns and keys for better performance
• Created complex materialized views for forms and reports
• Used the Agile approach for best practices for data warehousing/BI projects. For example prioritize requirements.
• Used Oracle Designer to develop logical and physical data models for the GDOC data warehouse.
• Analyzed and modified physical data model for ALS and GDOC to enhance performance and scalability.
• Prepared technical architecture of functional requirements
• Gathered information from software vendor Oracle for application version integration
• Used designer 10g to apply system development life cycle
• Prepared high level design
• Managed the metadata of the data model including descriptions of schemas, fields and columns and data integrity rules
• Created data standards and naming conventions document for GDOC
• Used the Agile methodology to accelerate development
• Analyzed, defined and documented business and system data requirements
• Responsible for modifying and making changes to data model
• Created the warehouse data model and data marts used for end user reporting
• Used SQL to transfer data to data warehouse
• Created scripts to populate data marts from data warehouse
• Set up and configured Designer 10g for the re-engineering of the Global Documentation Management System (GDOC).
• Implemented configuration management for applications using Designer 10g.
• Deployed GDOC to the web using Oracle 10g IAS.
• Created template and object library for 100% code generation and common look and feel in Designer.
• Set up and configured the Application Preferences in Designer.
• Attended and led weekly JAD sessions.
• Documented conversion strategy for moving data from source to target databases for multiple legacy systems.
• Created data definition structure from data requirements.
• Created strategy to archive data.
• Responsible for maintaining and making required changes to data model.
• Used Oracles Metadata API to retrieve database object definitions.
• Implementation of project design, standards and processes.
• Assisted client with definition of data requirements on three different applications.
• Used Designer 10g advanced features to design complex forms: 100% code generation, absolute tab stops, overwriting designer triggers, tab pages, multiregion blocks, module subcomponents.
• Created Oracle Forms modules and pl/sql procedures and packages.
• Helped create server model (database tables/schema/constraints).
• Migrated GFORM application from Forms4.5 to Oracle 10g for the web.
• Used Designer10g to maintain all database structures, allow access to users, and enforce integrity.
• Modified physical database model according to business rule changes and user requirements.
• Implemented user level security and account management at database and client level.
• Setup Configuration Management for Oracle Designer.
• Created required documentation of system development using Microsoft Office Suite
• Created presentations and presented to management team on the methodology used to design the system.
• Lead/mentored Confidential employees.
• Migrated C code to PL/SQL
• Performance tuned PL/SQL code and database structures using 10g

Environment: Designer 10g, Reports 10g, Oracle 10g, Forms 10g, Erwin, J2EE, Oracle BI Reports 10g, C, Oracle IDS, Oracle 10g CASE, Java, Oracle Configuration Management, PL/SQL, Java Script, UNIX, Windows NT, Toad database administration tool.