We provide IT Staff Augmentation Services!

Enterprise Data Catalog Sme Resume

Durham, NC

SUMMARY:

  • Over 11 years of work experience in design, development, implementation, and maintenance of Oracle Business Intelligence, Oracle Data Integrator, Oracle Warehouse Builder, Hyperion Financial Reporting, Informatica MDM, Informatica Product 360 (PIM), Informatica AXON, Secure@Source, Informatica Enterprise Data Catalog (EDC)
  • Experience in Installation, Configuration and managing of OBIEE (10g/11g/12c), BI Publisher (10g/11g), OWB (10g), ODI (10g), Informatica Product (PIM) 360, Informatica MDM, Informatica AXON, Secure@Source, and deploying Informatica EDC in on - premise and on the cloud (AWS and Microsoft Azure)
  • Experience in implementing Data Governance projects using Informatica technologies
  • Experienced in resource creation and extraction of a source and profiling metadata, managing global level and resource level security, scheduling and monitoring a resource, attribute management, data domains, rules, profiling information and troubleshooting, and performance tuning in EDC.
  • Understanding knowledge on Big Data Hadoop concepts, Hadoop components (HDFS, YARN, Hive, HBase), Hadoop architecture, Service Oriented Architecture (SOA), Networking basics including TCP Ports
  • Experienced in creating user profiles in Product Information Management tool and user access groups
  • Have good experience in analyzing process overview logs (Merge, Import, Export), Data transfer perspectives (Import, Export, Merge) and Data maintenance Perspectives such as Structure group assignments, Multimedia attachments, Prices, Attribute assignments in PIM
  • Performed end to end configuration in Informatica MDM (Tables Creation, Mappings, Hierarchies, Match and Merge Rules, Trust Scores, IDD Application)
  • Fined tuned Match and Merge rules
  • Performed bulk merge and un-merge activities
  • Worked extensively on OBIEE Analytics Administration Tool involving all the three layers namely Physical Layer, BMM Layer, and Presentation Layer
  • Worked extensively on OBIEE Analytics Administration Tool to develop a business model with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions
  • Expertise in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization
  • Experienced in setting up security in OBIEE, Weblogic Server, Enterprise Manager, OWB (10g), ODI (10g), Informatica Product (PIM) 360, Informatica MDM, Informatica AXON and deploying Informatica EDC,
  • Debugging, Optimizing and Performance Tuning of OBIEE Dashboards / Reports to improve performance at Database
  • Skilled expertise in creating reports using BI Publisher from OLTP and OLAP
  • Significant experience with ETL/Data Integration tools such as OWB and ODI
  • Experience in creating ETL processes using complex and reusable Mappings, Transformations, and multiple file handling sessions in Oracle Data Integrator
  • Extensive experience working with financial modules AP, AR, GL, Payroll, and Score4
  • Experience in implementing Oracle BI EE repository design best practices
  • Practical understanding of Ralph Kimball approach and experience in Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
  • Expertise in providing End User and Support

TECHNICAL SKILLS:

Data Integration: Informatica PowerCenter, Oracle Warehouse Builder (OWB), Oracle Data Integrator (ODI)

Data Quality: Informatica Data Quality (IDQ)

Data Governance: Informatica AXON

Data Security: Secure@Source

Master Data Management: Informatica Enterprise Data Catalog (EDC), Informatica Product 360 (PIM), Informatica MDM

Big Data: Enterprise Data Preparation (EDP/EDL), Hadoop 2.x (Platform), Zookeeper, Solr, Spark, HBase, HIVE, YARN

Business Intelligence and Analytics: Tableau, Microsoft Power BI, Insight Reporting, Hyperion, Oracle Business Intelligence Enterprise Edition (OBIEE)

Application Server: Weblogic Server 11g, JBoss

ERP: JD Edwards

Languages: SQL/PL SQL, XML, CSS, HTML

Data Model: Erwin 4.0

Databases: Oracle DB, Microsoft SQL Server, Teradata, DB2

Operating Systems: Solaris (Unix), Linux (Red Hat Enterprise 7.4), Microsoft Windows

WORK EXPERIENCE DETAILED:

Confidential, Durham, NC

Enterprise Data Catalog SME

Responsibilities:

  • Deployed EDC 10.2.2 on a new VPC using the AWS CloudFormation template
  • Worked with network team to configure VPC, subnets, NAT gateways, and Security Groups
  • Scanned and Profiled MDM Oracle Database to identify the PII data elements for Customer and to identify the critical data elements for Product Domain
  • Scanned and Profiled Oracle ERP system to identify the PII data elements for Employee and Customer Domain
  • Scanned and Profiled MySQL Database to identify the critical data elements for product, Customer and pricing information
  • Scanned and Profiled Salesforce CRM system to identify the PII data elements for Customer Domain
  • Created a file system resource to scan HCM Fusion extracts stored in SFTP to identify the critical data elements for Employee Domain
  • Created a file system resource to scan SAP Hybris extracts stored in SFTP to identify the critical data elements for Customer and Product Domains
  • Scanned and Profiled PowerCenter to enable the data lineage between Salesforce CRM and MySQL database
  • Created custom lineages between resources to identify the origin of the data
  • Created custom data domains by defining the column name rules and metadata rules using Developer Tool
  • Integrated EDC with AXON to capture the key business terms under each application in AXON and to capture the impact analysis on the applications on any data change and to understand the data quality across systems
  • Populated Metadata content and associated business terms to the Business Glossary using Informatica Enterprise Data Catalog and AXON
  • Created and Enforced Policies and Regulations in AXON
  • Integrated AXON with IDQ to identify the critical data elements and evaluate the data quality health of each system
  • Created Workflows for Approval Process, and Change Requests in AXON
  • Created users in AXON and mapped them to the roles defined
  • Documented proper test cases for testing the functionality of the tool
  • Applied recommended and emergency bug fixes
  • Trained and documented Informatica EDC capabilities and AXON Data Governance processes

Environment: EDC 10.2.2 HF1SP2, Axon 6.2, Apache Ambari 2.6.1.3, HDFS, YARN, MapReduce2, ZooKeeper, Ambari Metrics, Red Hat Linux Enterprise, IDQ 10.2.0 HF1, DBeaver, Oracle Database, SQL Server 2016

Confidential, Fort Mill, SC

Sr. Metadata Engineer

Responsibilities:

  • Performed data analysis and profiling using Informatica Enterprise Data Catalog (EDC) to interpret patterns, identify relationships, understand anomalies, assess data quality, and provide mitigation strategies and cleansing solutions
  • Resized the EDC architecture to handle large volumes of data sources
  • Upgraded EDC from 10.2.1 to 10.2.2 to 10.4 and applied recommended and emergency bug fixes
  • Created and managed data definitions and taxonomies, metadata curation for critical data assets, datastore structural information, business data flows, technical data lineage, and sensitive data discovery using Informatica EDC
  • Developed standard operating procedures and process enhancements to adapt to the needs of varied data sources
  • Evaluated metadata cataloging methodology and documented appropriate process improvements
  • Performed data mapping and gap analysis
  • Created and maintained Data Feed Specifications to capture the layout and metadata of all incoming and outgoing data feeds
  • Upgraded AXON from 5.4 to 6.0 to 6.1 to 6.2 to 6.3
  • Integrated AXON with EDC to discover and retrieve enterprise metadata from the catalog
  • Created connections between the EDC resources and AXON systems
  • Created links between EDC Columns/Fields and the AXON attributes
  • Populated Metadata content and associated business terms to the Business Glossary using Informatica Enterprise Data Catalog and AXON
  • Created relevant AXON attributes utilizing the recommendation from EDC
  • Mapped AXON Glossaries to EDC data domains
  • Created reusable schedules and custom schedules to extract the metadata from multiple resources
  • Enabled transformation logic for data structures such as tables and columns and identified the frequency of values in data sources
  • Created regulatory guidelines regarding data privacy, usage, and data retention
  • Upgraded IDQ from 10.2 to 10.4
  • Developed mapplets/rules for custom data domains
  • Integrated AXON with IDQ to retrieve data quality scores and measures
  • Performed data quality analysis on large and complex dataset flows.
  • Defined data quality rules to address data quality issues, code fixes, source system changes
  • Installed and Configured Secure@Source 5.1
  • Defined data security standards
  • Integrated AXON with Secure@Source to identify the sensitive data
  • Mapped AXON Systems to Secure@Source Data Sources and configured a privacy dashboard to show a consolidated Privacy/Security view of the system and the data that it contains
  • Mapped AXON Policies to Secure@Source Classification Policies and configured a privacy dashboard to show the Privacy/Security view of the policy and monitored risks associated with a policy
  • Automated solutions to enable data protection for inter-related systems data
  • Documented proper test cases for testing the functionality of the tool
  • Applied recommended and emergency bug fixes
  • Trained and documented Informatica EDC capabilities, AXON Data Governance processes, and Data Security

Environment: EDC 10.2.1, Axon 5.4, Secure@Source 5.1, Apache Ambari 2.6.1.3, HDFS, YARN, MapReduce2, ZooKeeper, Ambari Metrics, Red Hat Linux Enterprise 7.5, IDQ 10.2.0 HF1, Azure Data Studio, DBeaver, Oracle Database, SQL Server 2016

Confidential, Atlanta, GA

Informatica Enterprise Data Catalog (EDC) Consultant

Responsibilities:

  • Installation and configuration of Informatica EDC 10.2.1 on external and internal Hadoop Cluster deployment
  • Created users, groups and assigned appropriate roles, privileges and permissions in Informatica Administrator tool
  • Configured Amazon S3, Redshift, Athena, SQL Server data sources in EDC Administration Tool and extracted source metadata using native scanners
  • Created reusable schedules and custom schedules to extract the metadata from multiple resources
  • Created custom domains in IDQ and imported them into Analytics Tool
  • Performed Data Profiling and Data Domain Discovery on various data resources to check the quality of data for the assets
  • Created custom attributes and annotated data assets using the custom attributes in Catalog Administrator
  • Associated business context with data assets
  • Created rule-based data domains, smart domains, composite data domains, and data domain groups to search for entities across schemas in a data source
  • Created and uploaded the Synonyms definition file in the Catalog Administration Tool
  • Defined data rules, columns name rules, conformance criteria, and proximity rules to create custom Data Domains in Informatica Developer and Informatica Analyst Tool
  • Performed a detailed impact analysis using a lineage diagram to view the upstream and downstream assets in the data flow
  • Enabled transformation logic for data structures such as tables and columns and identified the frequency of values in data sources
  • Deployed Informatica EDC on AWS and Microsoft Azure cloud

Environment: EDC 10.2.1, Axon 5.1, Cloudera 5.15.x9, HortonWorks 2.5.0, Red Hat Linux Enterprise 7.4, IDQ, Hadoop, AWS S3, AWS Redshift, AWS Athena, S3 Browser, Azure Data Studio, DBeaver, SQL Server 2016

Confidential, Atlanta, GA

Informatica Product 360 (PIM) Analyst

Responsibilities:

  • Installed and configured Informatica Product 360 (PIM 8.1.0), Supplier Portal Database, Audit Trail Database, Application Server, GraphicsMagick, Message Queue 5.14.1, Media Manager and Web Client
  • Configured the Informatica MDM Hub to support loading, merging, and publication of MDM data
  • Configured structural hierarchies to manage Product Data
  • Created mappings for Import using data sheets to Informatica PIM
  • Scheduled import of product data from multiple systems and exported the product data in different Channel specific Output formats to downstream systems
  • Enriched product data with consistency and accuracy by linking
  • Information and media assets to the core product Information
  • Configured users, groups and security privileges
  • Performed unit testing on the parts implemented by Confidential
  • Coordinated with Confidential Subject Matter Experts (SME) and testing teams and documented the solution design
  • Provided implementation specific on PIM
  • Provided post-Go-Live support to Confidential

Environment: PIM 8.1.0, Active Message Queue 5.14.1, GraphicsMagick-1., ImageMagick-6.8.9-Q16, ExifTool-10.78, SQL Server 2017, Windows Server 2012

Confidential, Atlanta, GA

Informatica MDM Consultant

Responsibilities:

  • Installed and configured MDM Hub Store, Hub Server, Cleanse Server and JBoss
  • Created Landing, Staging and Base Tables and defined relationships in the base object tables and lookups to retrieve data from parent tables during the load process using the Hub Console
  • Configured exact and fuzzy matching rules to match identical records and to perform a probabilistic match in base objects using the Schema tool
  • Configured the merge process by setting rules to consolidate data from matched records into a single, master record
  • Created queries and packages to provide data views for Data Manager to view records in the base object, Merge Manager to review records queued for consolidation, Informatica Data Director, and Security Integration Framework in MDM Hub Queries tool
  • Configured batch Jobs to execute the stage, load, match and merge processes from within stored procedures
  • Utilized data management tools in the Informatica Hub to manually search, edit, flag, and merge records queued for merging and additionally unmerge records in the base object
  • Utilized Enterprise Manager to view properties, version history, and environment reports for MDM Hub components and to configure database logs for ORS databases
  • Worked with Informatica GCS team to resolve the product bugs and apply necessary hotfixes

Environment: Informatica MDM 9.7.1, Informatica Data Quality 9.6,9.5, JBoss 6.4 EAP, Oracle 11g, SQL Server 2012, Windows Server 2008

Confidential, Atlanta, GA

ODI Production Support, OBIEE Developer/Admin

Responsibilities:

  • Installed and configured a new OBIEE 12c environment and migrated the metadata from the OBIEE 11g environment.
  • Provided appropriate permissions on root file systems
  • Configured Weblogic authentication to enable 11g users to sign into the 12c environment
  • Created an export bundle from a read-only OBIEE 11g using the BI Migration Tool and imported the exported bundle into the 12c system using the BI Migration Script.
  • Validated the data in OBIEE 12c environment
  • Migrated Catalogs Groups from 11g to 12c
  • Configured the Database to use DataDirect Drivers
  • Configured Usage Tracking
  • Configured Compatibility Framework for Oracle BI Server
  • Migrated the Fusion Middleware MapViewer configuration
  • Integrated BI Publisher with Oracle BI Presentation Services
  • Created Data Models based on BI Server SQL Query, Oracle BI Analysis and OBIEE Subject Areas
  • Defined Parameters and LOV’s for the data model
  • Implemented features like Global level functions, bursting, sub templates, excel templates in BI Publisher reports
  • Created BI Publisher reports by using the Template Builder in Online Mode
  • Designed RTF Templates for BI Publisher reports
  • Configured Delivery Options including Print, Fax, Email, WebDAV, HTTP Server, FTP and CUPS
  • Configured BI Scheduler
  • Configured Usage Tracking in BI Publisher
  • Integrated Essbase with OBIEE 11g by importing Essbase data source into the BI Repository
  • Converted the measured dimension into flat measures
  • Created a subject area for Essbase data source
  • Created Analysis and Dashboards with Essbase as the data source
  • Configured Data-level security using Essbase filters
  • Created Essbase filters and defined filter definitions in Essbase Administration Services (EAS) Console
  • Fixed issues that arise during the integration process
  • Documented the integration process for future s
  • Installed and Configured OBI EE 11g on DEV, QA and Prod servers
  • Set up LDAP Security system and remodeled the Security system based on Application Roles and Groups in OBIEE 11g
  • Set up a one domain authentication in OBI EE 11g
  • Set up clustering and load balancing
  • Created Application Roles using Oracle Enterprise Manager and assigned different permissions on dashboards and reports
  • Configured Repository, Session variables to generate dynamic reports
  • Prepared Custom Dashboards, Reports and Filters
  • Created Agents /iBots using Delivers & delivered using Scheduler services
  • Configured Usage Tracking and Act as Proxy User functionality in OBIEE 11g
  • Migrated the Repository and Web Catalog from QA and Production server using Oracle Enterprise Manager
  • Resolved issues that occurred during the OBIEE upgrade process
  • Used Customized JavaScript’s to disable certain standard OBIEE features at the dashboard page level and also at the report level
  • Implemented Caching to improve the performance of BI Server
  • Integrated OBIEE 11g with SSIS to check the consistency of the data and proper functioning of reports
  • Documented issues that occurred during the upgrade process and integration process
  • Provided end user about new tools and concepts in OBIEE 11g
  • Assisted users in designing Report Layouts and Report Structure for better utilization and understanding of data
  • Interacted with end users and gave access to BI tool
  • Weblogic Server administration and maintenance
  • Upgraded OBIEE from 11.1.1.7.1 to 11.1.1.9.0 and applied the new customizations
  • Integrated Essbase with OBIEE 11g and developed user-defined reports
  • Managed Help Desk cases and provided resolutions
  • Extracted JDE reports using Insight Reporting
  • Developed complete ad-hoc inquiries and build reports including totals and headers, calculations, hierarchies and user-defined formatting using Insight
  • Created inquiries and reports in real time using Insight
  • Provided access to the Insight tool to the end users
  • Created dimension hierarchies, aggregates, and logical sources in the BMM layer
  • Configured Repository, Session variables to generate dynamic reports
  • Created users and groups using Administration Tool
  • Created views and aggregate tables to improve performance in Repository
  • Created reports with appropriate views such as charts, pivot, scatter, legend, narrative, and ticker
  • Configured Interactive Dashboards with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects
  • Created dynamic Dashboards with Dashboard prompts, Charts, Pivot Tables, Guided Navigation Links and Sections
  • Applied Cascading Prompts and Multi-Level Prompts on Dashboards
  • Configured Catalog Groups and set permissions for items in the presentation catalog, set privileges and rights to users and groups, and manage users, permissions, jobs, files, and folders
  • Migrated reports, dashboards, filter, prompts, custom views from QA to Production using Catalog Manager
  • Created Alerts /iBots using Delivers & delivered using Scheduler services
  • Managed user sessions and iBots sessions using Job Manager
  • Setup Usage tracking option to monitor frequently run reports to provide caching for the reports and perform database optimization by analyzing query performance
  • Modified the InstanceConfig.xml to configure the maximum number of rows, columns, sections, records required on the reports
  • Wrote Custom SQL Codes and XML Codes for the reports
  • Used SQL Tuning and Indexes to improve performance
  • Applied several Optimization Techniques to increase the performance of the reports
  • Set up clustering and load balancing
  • Upgraded OBIEE from 10.1.3.3 to 10.1.3.4.2
  • Provided end user about new concepts in 10.1.3.4.2
  • Applied patches to fix bugs after upgrading
  • Developed jobs using ODI that migrates data from INFORMIX to AS400
  • Extracted and migrated data from INFORMIX to AS400 as and when requested
  • Tested and validated migrated data for consistency
  • Created definitions for tables, views, materialized views, sequences, and external tables in Oracle Data Integrator
  • Created appropriate dimensions and fact tables and created indexes and partitions for design objects
  • Wrote SQL Queries in retrieving the data, validated from the business model and built the Data model
  • Scheduled and monitored nightly ODI ETL and Mid-day ETL processes and troubleshoot data load failure issues
  • Run daily data audit scripts and troubleshoot the problems and route integrity issues to an applicable person
  • Performed several payroll conversions and migrations
  • Developed the Time Dimension based on the date for supporting the Operational Reporting
  • Imported and executed several ODI extracts for Payroll 8.12 parallel testing and go-lives and migrated ODI objects to the production environment
  • ICL creation and maintenance required for promotions and production issues

Environment: ODI 10.1.3, OBIEE 10.1.3.3/ 10.1.3.4.2 /11.1.1.7.1/11.1.1.9.0/12c, Hyperion 11.1.2.1, SQL Server 2005/2008/2012, JD Edwards Enterprise One, INFORMIX, Windows 2003/2008 R2 Server

Confidential, Hanover, NH

OBIEE/OWB Developer

Responsibilities:

  • Constructed Segment Value Detail, Work Order Detail and OGA Repositories (RPD)
  • Developed financial reports such as GL Budget vs. Actuals, GL Funding Balances, GL YTD Transactions, and OGA Actuals by Month, OGA Commitments, Internal Revenue, and Expense Reconciliation, Segment Value Detail, Transfers Reconciliation, Work Order Details as per the client requirements
  • Configured Interactive Dashboards with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects
  • Created and applied Cascading Prompts and Multi-Level Prompts Pivot, Table and Narrative views on Dashboards
  • Developed BI Publisher reports and published them as Dashboards
  • Used Siebel Delivers and iBots
  • Identified issues, performance bottlenecks, and optimized Dashboards and Reports
  • Configured Catalog Groups and set permissions for items in the presentation catalog, set privileges and rights to users and groups, and Manage BI Publisher users, permissions, jobs, files, and folders
  • Validated reports by cross-checking with values with the Hyperion Reports
  • Used Custom SQL Codes and XML Codes for the reports
  • Applied several Optimization Techniques to increase the performance of the reports
  • Installed and configured the OWB 10gR2 and designed mappings and process flows.
  • Used mapping operators like Key lookup, joiner, splitter, sorter, filter, aggregator, expression, mapping sequence, mapping input parameter, pre-mapping process, and post-mapping process
  • Monitored and Scheduled different process flows using Oracle Work Flow Manager
  • Transformed and Loaded data from Flat files into target tables from external tables
  • Resolved the load failure issues, including database problems

Environment: OBIEE 10.1.3.3.3, OWB 10g, Hyperion, Oracle Database 10g and Windows

Hire Now