Francisco A.

Francisco A.

Sr Database Architect development dba

Tallahassee , United States

Experience: 20 Years

Francisco

Tallahassee , United States

Sr Database Architect development dba

108000 USD / Year

  • Immediate: Available

20 Years

Now you can Instantly Chat with Francisco!

About Me

Sr technical professional with 20 yrs experience which includes the following: Team Leader (12+ technical, 33+ non-technical); data architecture; data modeling; database design and programming,; database performance tuning; data migration; ETL proces...

Show More

Portfolio Projects

Contribute

Lead data architect, data migration specialist responsible for design, analysis and data cleansing processes in a major data migration project to new vendor environment.

Description

Generate, update and maintain data models representing the structures for databases. Design and code procedures for new data repository, table design. Develop and code prcedures to find, identify, catalog and isolate duplicate data across the division's databases. Implement data cleansing processes,generate gaps analysis and data mappings plans.

Show More Show Less

Contribute

Review and maintain data models and data warehouse structures in accordance with the data architecture standards of the enterprise.

Description

Support & maintain data models,data structures,data integrity and interdepartmental Service Level Agreements (SLA's) supporting the multiple data warehouses and reporting systems within enterprise.I maintained a 98%+ SLA completion performance in all my taskings.

Participate in project meetings and JAD sessions with management, technical staff and business users

Generate, update and maintain data models representing the structures for databases. Design and code procedures for new data repository, table design. Develop and code prcedures to find, identify, catalog and isolate duplicate data across the division's databases. Implement data cleansing processes,generate gaps analysis anddata mappings plans.

Review, approve and promote data definition language (DDL) changes to the structures for databases, data warehouses and multiple reporting systems within the organization.

Show More Show Less

Contribute

Research and document the capabilities and limitations of Business Intelligence tools currently available in the market place.

Description

Research and document the capabilities and limitations of Business Intelligence tools currently available in the market place.

Develop functional and non-functional requirements for several Business Intelligence tools, including Extract, Transform and Load (ETL), Master Data Management (MDM), Metadata, and Reporting.

Develop functional and technical requirements to meet the overall objective of procuring the Business Intelligence tools to support FDOT in the futur

Participate in project meetings, research sessions and planning using a variety of processes, which include SDLC, AGILE and SCRUM methodologiese.

Lead training sessions for FDOT personnel across all districts on the overall capabilities of Business Intelligence tools and the benefits they can provide across the enterprise.

Show More Show Less

Contribute

Recommend data integration, data models, data structures and methods to collect, process and maintain OLAP data within models responsible for insurance information in the personal and commercial lines

Description

Participate in project meetings and JAD sessions with management, technical staff and business users to track milestones within multiple projects and the data usage and long-term data reporting needs

Recommend data integration, data models, data structures and methods to collect, process and maintain OLAP data within models responsible for insurance information in both the personal and commercial lines

Data Analyst/ Database Modeler directly involved in supporting new development efforts as well as on-going maintenance and support of Core efforts in Billing, Policy and Claim systems and data reporting warehouse (following Inmon’s data warehouse / data marts approach).

Big Data analysis and mining: Data Analyst supporting the ClaimCenter, PolicyCenter and BillingCenter development effort of Guidewire system implementation.

Design and create PowerDesigner physical data models, data structures and ERD diagrams reflecting current information systems, databases and new subsystems for a major insurance company within the state of Florida.

Support the Claims and Policy areas of the current systems and new development efforts using a variety of development processes, which include SDLC, RAD, AGILE, SCRUM and Sprint methodologies

Show More Show Less

Contribute

Design and create Oracle data structures, spatial (geo-location) data structures, stored procedures and packages for online transaction processing (OLTP) data scrub and reconciliation processes

Description

Research, outline, and diagram logical and physical data models for TMDL Data Warehouse using Oracle iDS and Visio - describing the business and data processes used within the Water Resource Management Division of DEP. The business and data processes pertain to water body health, status, properties and sampling reporting to support information sharing within the organization.

Design Oracle enterprise wide OLAP database structures and ETL processes to capture, synchronize and merge water body quality and assessment data from various data sources supporting the master data design.

Design and create Oracle data structures, spatial (geo-location) data structures, stored procedures and packages for online transaction processing (OLTP) data scrub and reconciliation processes for water body, facilities and monitoring stations sampling

Interface, analyze, download and process geographical attribute data from ARCGis layers into new Oracle spatial-enabled structures to bring new information dimension (layers) into the new enterprise-wide architecture I have designed.

Recommend metadata and repositories to maintain data definitions and cross references for data used throughout various levels in the organization.

Show More Show Less