We provide IT Staff Augmentation Services!

Im Architect/data Architect Resume

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.

Hire Now