Bi Etl And Data Migration Developer
Liaise cross-functionally among executive-level decision makers, business process owners, subject-matter experts (SME), and stakeholders to define business objectives and elucidate requirements, informing strategic solution planning and development. Responsible for three applications: IBM Cognos TM1: Planning, budgeting, forecasting, analysis and analytical reporting Logility: Planning, forecasting Periscope McKinsey Solutions: Pricing tool, Metrics.Key Projects: ERP Migration/Integration to SAP: IDQ/ Power Center/ DW / BI / ETL Informatica Rel 9.6.1. Comprehensive data ETL solution providing end-to-end profiling, cleansing, enrichment, harmonization and transformation capabilities. Review of source systems and proposed data acquisition strategy Requirements and technical specification design Designed and developed ETL and Data Quality Mappings to load and transform data from source to ODS using Power center and IDQ Data-quality discovery and profiling for data stewards and analysts to identify data-quality errors Identity-matching-and-resolution engine to accurately identify unique customers, vendors, and materials. Provided knowledge transfer to the end users Created extensive documentation on the design Development implementation, daily loads and process Flow of the mappings Performance Metrics – Harmonization/Enrichment.