Data Architect Contract Resume Profile

SUMMARY

Extensive professional experience in business and data analysis, data modeling, metadata management, reverse engineering and various distributed relational databases provide a unique opportunity to bring in with technical expertise and the business knowledge that is needed by today's Information Technology professional.

COMPUTING SKILLS

Requirement Analysis Translate business requirement into functional design documents and into detailed technical specifications that include technical flow, ER and RDF diagrams, detailed report logic, measurements and layouts. Document database objects, and error handling while ensuring these technical designs meet the business/functional requirements specified in the Functional Design. Database performance and map and gap analysis using Excel, Power Point presentation and MS Word documentation.
Architecture Data Quality, Data Integration, Master Data Management CDH,CDI, PMI , Business Data Quality BDQ and Business Data Object BDO , Business Intelligence BI , Reference Description Framework RDF
Modeling -- Forward and reverse engineering ERD for traditional databases, data marts and data warehouses Stars Schema with data dictionary using CA ERWIN, IBM System Architecture and MS Visio tools.
Implementation OLTP and OLAP for traditional and analytical databases, data marts and data warehouses.
Design Development Database driven applications, specifically for Internet and custom client/server RDBMS solutions using C , C, visual C , J script, VB script, JAVA, Shell script, SAS and REXX programming languages. Used WEB / JSP/ ASP / PHP / IIS / Apache / HTML / .NET for front-end application development.
Integration Data Integration using PL/SQL, DTS, SSIS, SSRS, BODI, BODQ ETL and cleansing tools for SQL/DS and DB/2 mainframe, Sybase, Oracle, MS SQL Server and MYSQL databases.
Conversion / Porting Moving data from one database vendor platform to another such as from Oracle to MS SQL Server vise versa with applications using vendor / platform specific tools.
Servicing Writing and maintaining stored procedures PL/SQL on SQL/DS and DB/2 mainframe, Sybase, Oracle, MS SQL Server databases.
Connectivity Internet connectivity consulting for databases including minor web administration and resolving performance issues using ODBC, JDBC and ADO database connectivity.
Reporting BI metrics, ad hoc and analytical reporting and dashboard using Brio, Business Object and Tableau reporting tools.

AREAS OF EXPERTISE SELECTED RELEVANT EXPERIENCE

Architectural Framework

As-is Business Processes
As-is Data Architect
To-be Data Architect
As-is Application Flow
As-is Data Flow
Systems Usage
Technology usage
End-State Architecture
Data Dictionaries

Documented, Mentored Developed conceptual and logical data models, BPMN and application models for Quote to Cash, Customer Advocacy and Enterprise Architecture team at CISCO using IBM System Architect Telelogic modeling tool.

Developed BOM model at HP, COSTS QSAR Model at IBM and Reverse Engineered Mac Indigo Data Warehouses at Apple using ERWIN modeling tool.

Documented and developed as-is QTC and CA applications and data flow diagrams at CISCO using System Architecture tool for Order and Customer subject area.

Developed and standardized data flow schema using Gene Sarson data flow methodology and implemented at Delta Dental using MS Visio for Member, Provider and Claim subject areas.

Created Data Dictionary for Order, Customer and Shipment subject area for Cisco Claim, Member and Provider subject area for Delta Dental Automobile Repair Order and Appointment subject area for Xtime Contract Manufacture and Supply Chain subject area for HP and Apple.

Strategy and Tactical Data Process design
Strategic data analysis
Tactical ETL processes

Designed strategic address standardization and enrichment processes to enable all dental insurance related subject areas for deliverable addresses which enable Delta Dental to contact all their customers via mail as a part of MDM project.

Designed a tactical ETL processes to port data from main frame to 3rd party dental application databases for Member and Provider subject area for Delta Dental.

Designed analytical BI metrics measurement processes to improve performance for Xtime service marketing and management reporting.

Data Mining Data Quality
Data Pattern
Map Gap Analysis
Data Anomalies

Design the Searching data pattern graphical representation tool to detect live IBM DB2 mainframe databases performance and presenting to IBM researchers.

Conduct RAMBO Universe As-is performance analysis and EDW data mapping for QTC at CISCO.

Analyze Bill of Material BOM structure and identified gap for HP and Apple.

Establish automated process to find anomalies of Claim, Member and Provider subject area for Delta Dental which helps to take data cleansing decision on data conversion processes.

Analyze Contract Manufacture supply chain data process gap for Apple Mac and Indigo products data anomalies.

Meta Data Architecture
Metadata Concept

Design customer services metadata and presented to CISCO Enterprise Architecture Group.

Design Skill RDF metadata for CISCO services Group.

Modeled metadata and built user friendly interface for ROCHADE metadata repository tool for Delta Dental.

EXPERIENCE

Confidential

Data Architect Contract

Define BOST Architecture frame work specifically on Systems and Technology subject area.
End-to-End BI Services Architecture using IBM System Architecture tool.
Designing and Integrating Resource Description Framework RDF Data model using Oracle Spatial RDF database technology.
Drawing RDF data model, Data Transformation / Data Flow diagrams using Visio tool.
Creating and Maintaining RDF data models into Oracle Spatial RDF database.
Converting various sources of Relational data into RDF format
Map Gap Analysis of Skills subject area for RDF
Created Data Dictionary for Skills RDF metadata.
Responsible for writing Functional specs, Detail design and Support documents for SDCA Resource Profile project.

Confidential

Data Warehouse Architect Contract

Database Conversion from MS SQL Server 2005 to Oracle 11g.
Map Gap Analysis of MS SQL database Schemas and PL/SQL.
Designing and Integrating Rovi's to-be BI architecture using Oracle PL/SQL.
Documenting use cases to test conversion processes.

Confidential

Data Architect Contract

Reverse Engineered Regional Strategy Model RSM extracts business rules from SAS Datasets.
Mentored Offshore / Onshore team Recommended RSM Extracts to-be architecture for EDW.
Map Gap Analysis of RSM Extracts processes ETL for provider, member and claim subject area.
Coordinated business approval process for RSM transformation rules.

Confidential

Data Quality Architect Contract

Data mining and as-is analysis of Apple Contract manufacturing Mac and Indigo subject area.
Reverse Engineered Mac and Indigo data warehouse schemas and build inferred relationships for as-is architecture using CA Erwin tool.
Map Gap Analysis of Business Processes and Data for MAC and Indigo Bill of Materials BOM subject area.
Responsible for standardization of data quality processes, data profiling and data governance strategies for systems and applications.
Created Data Dictionary for Mac and Indigo subject area.

Confidential

Data Integration Architect Contract

Data mining and as-is analysis of Xtime Automobile Dealership Management, Repair Order, Appointment and Customer subject areas.
Responsible for documenting as-Is ETL processes of Xtime BI Metrics and recommending to-be ETL processes.
Designing, Packaging and Integrating Xtime to-be BI architecture using Oracle PL/SQL.
Responsible for demonstrating BI metrics performance improvement using Tableau BI reporting tool.
Created Data Dictionary for Repair Order RO , appointment taker and agent subject area.

Confidential

Enterprise Data Quality Architect / Data Modeler Contract

Data mining and as-is analysis of Delta Dental member, provider and claim subject area.
Reverse Engineering third party Oracle database schema and building inferred relationships for to-be architecture.
Responsible for drawing as-is and to-be Data Flow diagrams by applying Gene Sarson methodology and using MS Visio tool.
Responsible for assessing mainframe data quality and reporting.
Map Gap Analysis of Business Processes and Data for provider and claim subject area using SAP Business Object tool.
Responsible for standardization of data quality processes, data profiling and data governance strategies for MDM program.
Developing data cleansing and ETL via SAP Business Objects Data Quality BO/DQ Software.
Responsible for Modeling, developing and administering Delta metadata repository using ASG ROCHADE.
End-to-End data cleansing Architecture for Language Assistance Program LAP member survey data.
Created Data Dictionary for Claim, Member and Provider subject area.
Responsible for writing Business Requirement, Functional specs and Detail design documents for Address standardization and conversion projects as a part of MDM program.

Confidential

Enterprise Data Architect / Data Modeler Contract

Data mining and as-is analysis of Oracle 11i ERP Modules in CISCO environment.
Reverse Engineered Order Entity, OE/OMT and IB ERP Modules for to-be architecture as a Single Source of Truth SSOT .
Responsible for drawing Data Transformation / Data Flow diagrams using Visio as well as IBM System Architecture Tele logic tools.
Responsible for Business Intelligence, End State as-is and to-be architecture.
Managed and published as-is and to-be Business Processes, Logical Physical data models, System Architecture, Interface and Infrastructure Architecture for Oracle Customer Data Management and Oracle Trading Community Architecture TCA .
Map Gap Analysis of Business Processes and Data using SAP Business Object tools for Order and Customer subject area.
Generating Reporting and Metrics in SAP Business Objects RAMBO .
Created Data Dictionary for Order, Customer, Shipment and Service Contract Subject Areas.
Responsible for writing Business Requirement, Functional specs and Detail design documents for QTC and CA BI Metrics projects.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship