Data Integration Architect Consultant Resume
Houston, TX
SUMMARY:
- Result - oriented and skilled professional with more than 12 years of experience as a stakeholder with data warehouse infrastructures, performing disparate system integration using OLTP and OLAP tools, product integration with GIS components, and advance skills with O& Confidential technical data management, with excellent knowledge of software development and data architecture assurance, 8 years of expertise with O& Confidential proprietary Business Intelligence Solutions built in Business Objects and integrated with a Location-aware component, excellent written and oral communication skills and other
- Project management experience includes scheduling expenditures in MS Project; analyzing variances; initiating corrective actions.
- Technical DW experience includes has a strong understanding of Data Warehousing concepts (Migration, Cleansing, Mining & Auditing).
- Proficient at using OLTP/OLAP tools for ETL and ELT transactions in data warehouse infrastructures.
- Works with code repositories and deployment management systems to synchronize builds (i.e., Team Foundation Server, SourceSafe and Eclipse, Team System Server for collaboration.
- Proficient in using data analytics tools to perform queries and analyses, to define and correlate data, works with business units to design KPIs and metrics.
- Skilled at utilizing data visualization (BI tools) platforms to organize and present summarizations, predictive analysis, comparative analysis, dashboards and reporting.
- Works with large and complex enterprise data models and large volumes of data, and assess data quality issues for local and familiarity with Cloud data storage.
- Provides assistance or guidance on domain business/functional strategies and plans for project cleanup and data migration, performs product evaluations and strategic assessments.
- Knowledgeable about big data platform and processing in distributed architectures such as Hadoop, Cassandra, MongoDB and NoSQL tools and Informatics PowerCenter, and Data Stage from product evaluation usage performing data plumbing (optimization of data flows and in-memory analytics).
- Big Data language familiarity (only) with R, Map-Reduce, HBASE, HDFS, Pig, and Hive.
- Performs data quality, risk assessments and data governance roles in support the development and implementation of APDM, PPDM and PODs data models and governance principles, procedures, and standards.
- Excellent technical knowledge in support of requirements gathering and documenting workflows.
- Able to deploy and enable spatial components and visualization APIs, and enable Metadata in Data Quality tools, Dashboards & Reporting of evaluated products (i.e., familiarity with ESRI Business Analyst Online, Spotfire, IBM Cognos, MicroStrategy, Penthao, Jasper Soft, Birst, TOGAFs, Tableau and Informatics PowerCenter, MongoDB and Data Stage). Leverages available analytical tools to provide insight into general industry trends as well as specific operational results.
- Run, analyze, develop and develop queries and reports using SSRS and OEM, using Oracle Developer, Toad and ER Studio to conduct comprehensive testing to ensure compliance with user requirements.
- Experience with using Enable integration of applications with metadata solution via XML and XSL transaction protocol languages and perform reference data modeling and data architecture assurance.
- Deploy, configure, and perform patch updates on ArcIMS servers, ArcSDE server, and ArcGIS map server on Windows, Linux, and ArcGIS Desktop for SharePoint 2.1.1 environments.
- Deploy and integrates server applications with ESRI’s ArcGIS Server using WMS, WFS and REST/SOAP services on LINUX and Windows platforms.
- Deploy and integrates server applications with Google Earth enterprise on Windows platform.
- Managed SOM/ SOC client connections to ArcSDE to include system monitoring, installing, upgrading, and managing users, and tracing errors.
- Deploy and integrates server applications with ESRI ArcIMS servers by creating and managing WMS and WFS, defining AXL, monitoring user activities, and performance tuning, and tracing errors.
- Knowledge of spatial, analytical and statistical tools for modeling geospatial data to simulate natural processes, for estimation, interpolation, and prediction.
- Knowledge and skill in applying analytical and evaluative methods and techniques and evaluation criteria to issues concerning the efficiency and effectiveness of geospatial and information program effectiveness and operations.
TECHNICIAL SKILLS
OS & Databases: UNIX, Linux and HP-UX Platforms, Microsoft Novell, Windows Server 2003 /XP; Access, SQL Server and Oracle 10g Web Services, AS Server and GIS Technology Oracle Web Logic, IBM WebSphere; GRASSE, Quantum GIS (QGIS), Google Earth Enterprise, ArcGIS Desktop, ArcIMS and ArcGIS Server and ArcSDE Server in windows and Linux environments, and Oracle Spatial SDE configuration and ESRI Business Analyst Online; TFS/ TSS and SourceSafe deployment environment and Eclipse IDE
BI and ETL and ELT tools: TGS EnerConnect (for ETL from EPOS4, Petra, OW and GeoInfo) KINGDOM Global Service (formerly OpenKingdom Domain), Confidential Enterprise Analytics, familiar with DecisionSpace, PowerExplorer/PowerHub Confidential ; and Microsoft BI (SSIS/SSRS/SSAS), training in SAP BO and Web Intelligence Advanced, and familiar with Spotfire, MicroStrategy, Birst, Data Stage, PowerCenter, Tableau, Jasper Soft and Penthao; Confidential Tool, a reference data modeling tool for OpenWorks and The Kingdom Software.
Data Management, Server Apps: ER Mapper, Zycor ZMap, Landmark OpenWorks R5000, Landmark WOW, Geoframe4.4/4.5, Geoframe IESX 4.4, ProSource Front Office for Petrel and Techlog platforms, Seisworks, Geographix, DSS, Petra, Techlog, Petrel, Paradigm Geolog and EPOS 4 application suite (including 3D Canvas, Section, BaseMap, StratEarth); and BMC PATROL, and SMT Kingdom Software
EXPERIENCE:
Confidential, Houston, TX
DATA INTEGRATION ARCHITECT CONSULTANT
Responsibilities:
- Schedules task and expenditures in MS Project; analyzes variances; initiates corrective actions.
- Data Integrity and Governance Analyst in support of the development and implementation of SOX controls, ADPM, PPDM and PODs data principles, procedures, and standards.
- Analyzing issues in the integrity and governance of enterprise data, including problem definition, root cause analysis, and solution recommendations.
- Utilizes off-the-shelf commercial BI tools and various OLAP/OLTP tools for data migration in a data governance capacity (i.e., using business rules in reference data modeling, ETL and data visualization integrations projects).
- Provides onsite support in the role of GIS System Integrator and Server Administrator, Confidential & Confidential Application Support .
- Routinely works with business units to gather requirements for designing KPIs and metrics, and skilled at utilizing data visualization platforms.
Confidential, Houston , TX
GIS DATA ARCHITECT CONSULTANT
Responsibilities:
- Provides onsite support, GIS Administrator, application support for many Confidential & Confidential applications.
- Utilize Confidential Tools (Business Object solution) for reference data modeling and versioning standardization in Openworks projects.
- Schedule testing and support activities in MS Project, analyze variances and initiates, corrective actions for support tasks.
- Perform large volumes of data QC for data governess project, merge data sets in consolidation efforts and data type clean -up efforts in the corporate data standardization process .
- Perform data quality and data governance analyst roles in support the development and implementation of ADPM, PPDM and PODs data models and governance principles, procedures, and standards.
- Analyze issues in the integrity and governance of enterprise data, including problem definition, root cause analysis, and solution recommendations.
- Integrate Google Earth and SAS statistical model with Confidential Tools suite to perform logistical analysis in the map viewer.
Confidential, Houston, TX
LANDMARK SR. CONSULTANT
Responsibilities:
- Perform Well Data Management data architect and QC for project consolidation data clean-up in Landmark R5000 and client’s Corporate Data Storage ( Confidential /PowerHub).
- Direct support for DM for Landmark PowerExplorer (a Business Intelligence OLAP Solution) using SAS Statistical Model for integrating with Corporate Data Storage (MDM) repository for data migration from OpenWorks R5000 to Confidential via ADT (advance data transfer) protocol products.
Confidential, Houston, TX
CONTRACT GIS SUPPOR
Responsibilities:
- Maintain and support an enterprise-wide Oracle ArcSDE Geodatabase.
- Responsible for spatial database maintenance and configuring TIBCO OpenSpirit® Extension for ArcGIS.
- Provide ongoing support for a corporate-wide enterprise Geodatabase model utilizing ESRI’s SDE methodology.
- Collect/reformat/load data from 3rd party entities such as IHS, Intellex, OWL into the enterprise Geodatabase.
- Backup Confidential & Confidential application support for Petrel, Petra and Openworks R5000.
Confidential, Houston, TX
TECHNICAL DATA MANAGEMENT/QA
Responsibilities:
- Implementation specialist performing support functions and integration troubleshooting of data transfers from EnerConnect a SAS Statistical Model integrated with GeoInfo web ((a Business Intelligence Solution) MDM for OLAP ETL data mining with Petrel, Petra and Paradigm EPOS 4 data sources; applications hosted on SQL and Oracle database servers, using TomCAT AS and ArcGIS Server distributed web services.
Confidential, Houston, Texas
SR. TEST DEVELOPER CONSULTANT
Responsibilities:
- Uses this OLAP tool to perform ETLs (import and exporting) of wells, culture, local and shared T-D charts, seismic horizons, faults and fault polygons and zone data from ProSource Log server archives.
- Performs data analysis and data quality checks in an effort to run comparisons datasets for data archives with source data in PSFO via Techlog and Petrel 2d/3d viewers in order verify accuracy of well logarithm data and core interval displays of imported data.
Confidential, Houston, Texas
SR. CERTIFICATION ANALYST & ARCGIS SERVER ADMINISTRATOR
Responsibilities:
- Performed integration troubleshooting of Confidential adapters with Confidential Enterprise (a Business Intelligence Solution) hosted on Oracle Web Logic AS and ArcGIS Server distributed web services performing data migration via PWE (OLAP/ OLTP tool).
- Work closely with the Geoscientists to design KPIs and metrics for dashboard analytic feature in PWE. Performs data quality checks, perform data modeling prior to running ETLs, and maintain data in the MDM database environment.
- Utilize code repositories and deployment management systems to synchronize builds (i.e., Team Foundation Server and Eclipse, and Team System Server) and for collaboration.
- Contribute to strategy & technical decisions for PWE product training and Confidential / MDM database deployment, and writing workflow use cases for best practices documentation.
Confidential, Houston, Texas
SR. SOFTWARE DEVELOPMENT ANALYST
Responsibilities:
- Maintain project schedule for testing and support activities in MS Project.
- Conducts project status reviews in support of product commercialization.
- Utilize a code repository and deployment management system to synchronize builds (i.e., Team Foundation Server and Team System Server) and for collaboration.
- Performed integration troubleshooting of I.H.S. KINGDOM Global Service (formerly OpenKINGDOM Domain) (a Business Intelligence Solution) use to integrator OpenWorks and Finder project via OLAP/ OLTP ETLs with SMT Kingdom projects and TIBCO OpenSpirit® Extension for ArcGIS.
- Work closely with the Geoscientists to data quality checks and design KPIs and metrics for dashboard analytic feature in Kingdom Global Services product.
- Perform business workflows that include ETLs and archiving data in the MDM database server environments.
- Contribute to strategy & technical decisions for deployment, user training, workflows and best practices.