We provide IT Staff Augmentation Services!

Bi/ Location Analytics - Data Integration Architect Consultant Resume

0/5 (Submit Your Rating)

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 Confidential components, and advance skills with Confidential & Confidential technical data management, with excellent knowledge of software development and data architecture assurance, 8 years of expertise with Confidential & Confidential proprietary Business Intelligence Solutions built in Business Objects and integrated with a Location-aware component, excellent written and oral communication skills and other Core Competencies are.
  • 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
  • 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.

TECHNICAL 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 Confidential Technology: Oracle Web Logic, IBM WebSphere; GRASSE, Quantum Confidential (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, OWand Confidential ) KINGDOM Global Service (formerly OpenKingdom Domain), PetrisWinds Enterprise Analytics, familiar with DecisionSpace, PowerExplorer/PowerHub CDS; 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; RoQC 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 Confidential PATROL, and SMT Kingdom Software

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

BI/ LOCATION ANALYTICS - DATA INTEGRATION ARCHITECT CONSULTANT

Responsibilities:

  • Client: San Jose Systems: provide Business development services, and completed (90 days project at Texas ERS) as ETL
  • ELT Developer using SSIS to perform data integration services, works with business units to design KPIs
  • Metrics; and skilled at utilizing data visualization platforms to organize and perform business assessment and design requirements for the integration of Confidential technology with Tableau verse ArcGIS Online dashboard implementation.
  • 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 Confidential 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

DATA ARCHITECT CONSULTANT

Responsibilities:

  • Provides onsite support, Confidential Administrator, application support for many Confidential & Confidential applications.
  • Utilize RoQC 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 RoQC Tools suite to perform logistical analysis in the map viewer.

Confidential, Houston, TX

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 (CDS/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 CDS via ADT (advance data transfer) protocol products.

Confidential, Houston, TX

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 Confidential 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 Confidential, 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 Confidential via Techlog
  • Petrel 2d/3d viewers in order verify accuracy of well logarithm data and core interval displays of imported data.

Confidential, Houston, Texas

ANALYST & ARCGIS SERVER ADMINISTRATOR

Responsibilities:

  • Work closely with the Confidential to design KPIs and metrics for dashboard analytic feature in Confidential .
  • 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 Confidential product training and CDS/ 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 Confidential 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.

Confidential, Houston, Texas

DATABASE ANALYST/ IT SUPPORT

Responsibilities:

  • Performed database integration of Geographix Discovery project shape files data with ArcIMS distributed web services for department intranet.
  • Install ArcGIS Desktop and ArcIMS software on Windows Operation system and provide support to staff geologist and geotechnicians.

Confidential, Houston, Texas

DATABASE ANALYST

Responsibilities:

  • Responsibilities include development of ESRI product-based Confidential UI integrated with SAS - Statistical Models as component in the Pavement Maintenance Management Program, (a Business Intelligence Solution) an engineer street rating and survey data management application, for various types of clients, including desktop applications, hand-held applications and web-based applications.

Confidential, Houston, Texas

GIS ANALYST

Responsibilities:

  • Conducted data gathering, (wells, fields and seismic), conversion and analysis of Confidential data.
  • Prepare maps and exhibits with Confidential datasets.
  • Prepare data documentation or metadata for Confidential projects and digital map data file production and map printing, data population
  • Perform data migration with functional understanding of relational databases at both personal and enterprise levels.
  • Participate in client need analysis for marine and aerial seismic data review.

Confidential, Stafford, Texas

CONSULTANT

Responsibilities:

  • Duties included data management and analysts of North West Africa project files stored in shapefile and geodatabase format in ArcView 8 solution.
  • Performed data validation testing and conversion of shape files to metadata layer for migrations to ArcGIS 8.2.3; and updating Arc Catalog metadata information on these source layer files.

Confidential, The Woodlands, Texas

CONSULTANT

Responsibilities:

  • Duties included data manager of Gulf of Mexico project data and performed data validation and updates of company’s Spatial Data Environment project metadata.
  • Performed imports of asset/ production excel format data from Lexicon OWL web server to Access RDBM files then converting them
  • Geodatabases and/or storing as shape files or metadata layers in ArcGIS in support of future ArcIMS web server.
  • Responsible for Geoframe and Finder files data conversions and migrations to ArcGIS 8x on Windows platform, and re-projecting raster metadata.

Confidential, Houston, Texas

TECHNICIAN

Responsibilities:

  • Performed massive digitizing of Pittsburgh region Confidential lease holdings utilizing digitize tablet and Arc Plot feature of ArcGIS 8/Arc Map for reproducing map coverage's

Confidential, Houston, Texas

GEOLOGICAL TECHNICAL ANALYST

Responsibilities:

  • Assigned to provide innovative data management support for 12 Geologist and as local geotechnical support to 12 geologists in the Shell SIEP Deepwater
  • Regional Studies Group for new builds of Arc Tool export and import Arc Plus component, which was a proprietary component, designed and developed in the Netherlands.
  • Responsible for creating these global project datasets by importing or exporting files from Zycor ZMap (mapping software) to ArcGIS
  • Responsible for Z-Map data conversions and migrations from Arc View 3x on UNIX to ArcGIS 8x on Windows platform, and re-projecting raster metadata.

Confidential, Houston, Texas

MAP RESEARCHER

Responsibilities:

  • Responsible for verification of existing utility service via SAP Easy Access database and then performs research utilizing the Arc Catalog Geo-reference feature referencing attribute data in the database of geocode addresses.
  • Used ArcGIS Desktop, Arc Map feature to generate plot files to allow serviceman to validate geocode addresses and to indicate positions of reverse geocode addresses on subdivision lot plans that reflect excavation with pipe mainlines.
Confidential, Houston, Texas

GEOTECHNICAL/ ANALYST

Responsibilities:

  • Performed specialize data integration while utilizing ArcView features and AML scripts to create shape files in UNIX environment and/or convert to Arc Info master cartographic coverage.

Confidential, Houston, Texas

STAFF TECHNICAL ANALYST AND TEMPORARY TECHNICAL EDITOR

Responsibilities:

  • Maintain project schedule for testing and support activities in MS Project.
  • Conducts project status reviews in support of product commercialization.
  • Utilize code repositories and deployment management systems to synchronize builds (i.e., Team Foundation Server and Eclipse, and Team System Server) and for collaboration.
  • Responsible for writing the release notes and user documentation specific for the Patrol for IBM Web Sphere Application Server, Knowledge Module (a Business Objects Solution).
  • Utilized extensive workflow scenarios to troubleshoot this technology and its interoperability with IBM Web Sphere product.

Confidential, Houston, Texas

SOFTWARE TESTING ENGINEER

Responsibilities:

  • Assign to Data Management Product Group QA Testing / OpenWorks and OpenExplorer Certification Team.
  • Utilize code repositories and deployment management systems to synchronize builds (i.e., Team Foundation Server, SourceSafe, and Team System Server) and for collaboration.
  • Wrote Test Plan and Test Cases for regression and black box testing, and assisted in problems with unit testing and code reviews involving future integration and security issues with this product.
  • As the Lead Forms and Reports Tester on Open Explorer product team: Components developed in C/C++, Oracle Developer 2000 and Avenue;
  • Maintain project schedule for testing and support activities in MS Project.
  • Conduct project status reviews in support of product commercialization.
  • Analyzed test failures on multiple platforms and debugging problems; reported bugs identified in Scopus tracking system.
  • Install, built and restored data shell scripts to return the seismic and Oracle RDBMS to original and new projects.

Confidential, Bryan, Texas

TECHNICAL ENGINEERING SPECIALIST

Responsibilities:

  • Performed drafting and design utilizing AutoCAD LT, cartography and topography data research as Global Positioning Technician for assigned unit.
  • Utilized GRASSE and MCS Phoenix GPS systems. Performed cartographic and terrain analysis duties.
  • Collected and processed military geographic information from remote sensed imagery, digital data, intelligence data, existing topographic products and other collateral data sources; edits cartographic and terrain analysis products.
  • Advised command and staff officers on topographic operations and special map product planning.

Confidential, Houston, Texas

DATA ANALYST

Responsibilities:

  • Use technical experience with pipe drafting to perform pipeline historical data analysis which includes reviewing and updating pipeline alignment sheets, stationing, pipe/ fitting specifications, and historical pipeline construction information.

We'd love your feedback!