Dara BAF

En résumé

Entreprises

• Sage Publication - Data Warehouse and BI Director

  2011 - maintenant

• Myspace, Inc. - Sr. Principal Data Warehouse Architect

  2010 - 2011 Responsible for improvement of technology, practices, processes and improvement of existing technical solutions with business sponsorship obtained. Lead several teams in meeting and exceeding the objectives. Orchestrated Vendor relations. Managed clients expectation while exceeding at times. Helped data platform VP and Executive Directors with budgeting and planning for FY11. Mentored other architects. Engaged with enterprise architects on meeting all areas of technical, process and legal obligations and best practices.
  
  Key Achievements
  • Approved comprehensive roadmap for immediate 6 months and the next 2 years.
  • Hardware and Software Acquisition & Deployment of 5 clusters from 18 to 120 nodes of databases
  • Establishment of best practices, charters and engagement rules for all teams including Enterprise Architects Team, DW, Unix Ops, System Engineers, Data management, Data Center and NOC.
  • Upgrade of all MPP clusters into a major version of Aster DBMS.
  • Re-architecture of all DBMS clusters on function and acquisition of an orchestration engine
  • Initiation of re-engineering of all offensive programs
  • Designed, Developed, Tested and Deployed a multiplatform Data Quality Monitoring Engine
  
  Responsibilities included:
  - Future State Architecture
  - Assessment of client demands on merits and cost and charting the appropriate course to meet them
  - Assessment of new code designs and management of development framework
  - Mentorship of other architects and technical staff
  - Managing internal and external relations
  - Driving and assistance with budgeting and planning on Infrastructure and related costs

• Microsoft Corp. - Sr. Data Management/BI Technical Architect

  Issy-les-Moulineaux. 2007 - 2009 Created and executed a three-year roadmap to enhance the DW/BI environment of the Entertainment and Devices division to eliminate redundancy and focus on transparency, agility and facilitating the transformation of data into insightful information. Modified data processes to leverage SET operations. Enhanced ETL infrastructure throughput and ETL Window by leveraging clustering and mirroring capabilities of SQL Server combined with DMX technologies.
  
  Key Achievements
  • Developed three (3) data marts (Manufacturing/Product Quality, Inventory Management and Interactive Entertainment Business) ranging in size from 900 GIG to 12TB, using SQL Server, Analysis and Reporting Services.
  Responsibilities included:
  - Logical and physical data modeling
  - Complex ETL design and development (worked more than 1 billion rows and 3 parallel types of ETL processes)
  - Addressing scalability issues (scaling out and scaling up)
  - Hardware infrastructure design to align with ETL and Query schedules
  - Technical assessment and approval of standards for ETL flow, engine and version. Also ensured TSQL and Visual Studio Database (VSDB) coding standards were met.
  - Conducting code reviews and logic validation
  - Technical architect addressing Query and ETL Windows using DMX technology.
  - Mentoring junior architects
  • Created consensus, momentum and socialized future state architecture
  • Designed data management/data quality platform comprised of data profiling, business rules engine and Master Data Management using off-the-shelf applications, Microsoft technology and home grown code as well as data and hardware infrastructure.
  • Addressed parallel processing and standardization collaborating with Product Team and Centers of Excellence.
  • Executed plans while coaching developers on application of best practices, creation of reusable components, emphasis on data modeling sessions and effective use of SQL
  • Collaborated on Data Governance Package, Knowledgebase Package, and Plug-n-Play reusable components.

• Amgen, Inc. - Enterprise Business Intelligence Architect

  PARIS 2002 - 2007 Developed end-to-end of data warehouse/business intelligence solutions for the Sales and Marketing business unit. Planned and developed strategic directions for a 10-year roadmap on a global and agile Business Intelligence system. Created RFPs and evaluated proposals collaborating with the procurement department. Developed business and system governance processes. Coached best practices and data modeling approaches and managed the technical architecture. Managed one to twenty-five (25) developers. Provided estimations and estimation methodologies. Recruited talented and highly effective staff.
  
  Key Achievements
  • Developed six (6) data marts comprised of conformed dimensions and SOA-flavored data management platforms ranging in size from 200 GIG to 5 TB. Technologies used were Oracle, Informatica , Cognos, and MicroStrategy suite of applications.
  Responsibilities included:
  - “Technical Lead of Program” for many projects
  - Logical and physical Data Modeling
  - Data Governance processes
  - ETL design – designed metadata driven ETL engine on top of SAS base.
  - Report and cube design
  - Code review and modifications
  - Managing technical staff and consultants
  • End-to-end automation of disparate systems
  • Introduced product and Customer Master Data Management (MDM)
  • Implemented Single, global reporting with conventions, templates, SOPs and supervision required
  • Automated some previous manual operations
  • Provided expertise in data modeling, data and front-end solutions

• Cognos (IBM) Corp. - Enterprise Account Manager

  1999 - 2002 Managed projects and consultants at client sites. Designed and developed data warehouse/business intelligence solutions for various clients. Responsibilities included requirements gathering, logical and physical data modeling, ETL design and development, conforming data marts, design/development of reports and analytics solutions. Assisted in the purchase, configuration and tuning of hardware assets and software applications. Provided Installation, administration and user guide documentations. Prepared and conducted numerous presentations to senior management and technical staff.
  Worked on many database platforms including Informix, Oracle, Teradata, SQL Server and Sybase.
  
  Key Projects
  • Biopharma DW/BI solutions (Amgen)
  • Healthcare DW/BI solutions (Wellpoint)
  • Manufacturing DW/BI solutions (Mattel, Honeywell, Western Digital, Kyocera, Pioneer, Channel)
  • Software DW/BI solutions (WRQ)
  • Services DW/BI solutions (Airport group)
  • Education DW/BI solutions (CSU-LA)
  • Construction DW/BI solutions (Kaufman & Broad)

• Informix Software Corp. - Data Warehouse Consultant

  1998 - 1999 Overall responsibilities included data modeling, both logical and physical design, and database engine tuning for online analytical processing. Performed ETL development and front-end design of ROLAP solutions using Informix’ Meta Cube. Provided ongoing support for ETL processes including the generation of SQL code, data definition language, partitioning of data, adjusting cache sizes and striping disks. Additionally, tested Meta Cube front-end product for performance, user friendliness and analytics capabilities. Provided Installation, supporting administration and user guide documentations.
  
  Key Projects
  • MCI data warehouse (over 6 TB)
  • KEY Data Modeler for Informix internal data warehouse with 12 data marts and ROLAP solution on top.

Formations

• University Of Houston (Houston)

  Houston 1995 - 1998 MS - Computer Science
  
  Thesis on On-Line Maintenance of Materialized Views (aka Data Warehouses)

• University Of Houston-Clear Lake (Houston)

  Houston 1992 - 1996 BA - Computer Information Systems
  
  Research Focus on Parallel and Distributed Processing

Réseau

Pas de contact professionnel