Rss

Allen R

Datawarehouse Designer

Occupation:

Datawarehouse Designer

Education Level:

Master

Will Relocate:

YES

CollapseDescription

ACCOMPLISHMENTS Senior Manager or Solution Architect * Managed a Corporative initiative to Re-Engineer the existing Data Warehouse to align with its 5-year growth strategy. I was responsible for resource planning, implementation plans, roadmap, project plans, current state assessment and future state architecture. Developed Logical Data model of core subject areas. * Led JAD sessions with Senior Management and SME's of functional areas and assisted the development of initial business requirements. Developed a Data Management Process with work products and templates, which was a repeatable process that reduce the time and cost to delivery. This allowed the Data Management team to meet their SLA obligations to the Business Users. * Responsible for developing information strategies and roadmaps, as well as, delivering analytical solutions to support the business. I was also responsible for promoting ways to use data and analytics to best meet enterprise business needs, and facilitating a consistent approach to developing, accessing, and applying data across the enterprise. * Led the development and execution of the Business Intelligence Data Roadmap. This roadmap is a multi-year strategy focusing on data integration and process improvement, analytic capabilities, and user data access tools, as well as data governance and data quality to support the enterprise's 5-year strategy. * Managed the implementation of Master Data Management approach that generated 23% process improvement while taking advantage of shared Customer and Product Data information. Produce Data Governance guidelines to manage a MDM environment. * Implemented Data Management Process and RACI to ensure quality measures with a repeatable process. This process was aligned with day to day activities and Governance council activities. * Provided direction on the development of the Data Mart and Dashboards to support the reporting and analytical needs of the multiple functional business areas. * Collaborated with business stakeholders, other shared services organizations, development teams, corporate groups, and vendors to implementation of Enterprise Data Warehouse solution using Business Objects XI and Oracle. * Managed in the implementation of Teradata's Telecommunication Logical Data Model and IBM's Retail data model. * Develop Enterprise Data Warehouse architecture which included SOA interfaces and a Federated Data Warehouse. * Managed the implementation of Business Intelligence application using Netezza and Business Objects. * Implemented SAP NetWeaver BW and Retail Link data marts in Teradata. * Developed POC Dashboards using Business Objects Xcelsius * Managed the integration of Financial General Ledger and Billing applications into the Enterprise Data Warehouse. * Developed Solution Architecture to support Data and User Migration process to convert from DB2 to Teradata * Designed a Solution Architecture to build a Hub and Spoke EIM architecture using Netezza and Cloudera (Hadoop), which centered around three major components (Operational Data Hub, Enterprise Data Hub, Analytical Data Hub and MarkLogic (NoSQL). * Developed an Architecture Blueprint and strategy for data retirement and archive using AWS Redshift and Hadoop. * Architected a MS Azure data lake solution using JSON file, Hive DB, and Tableau reporting tool. SKILLS SUMMARY Tools: Business Intelligence - Cognos, Hyperion, Business Objects XI, Siebel Analytics, Oracle OBIEE DB2 OLAP, SAP NetWeaver BW, Tableau ETL: Prism, Informatica Suite (MDM, Metadata Mgr, etc), DataStage, PLSQL, BO Data Integrator Data Modeling: Erwin, Data Architect, System Architect, Rational Rose, Visio, ER Studio Embarcadero Master Data Management (MDM): Siperian, Trillium, BO Data Quality Manager (DQM), Informatica Suite MDM, Metadata Mgr, etc) Modeling: Business Model, Logical Data, Physical Data, Dimensional, Conceptual, Component and UML

Right_template4_bottom

CollapseWork Experience

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom