We provide IT Staff Augmentation Services!

Data Warehouse And Business Intelligence Architect Resume

SUMMARY:

As a Senior Data Warehouse\Business Intelligence Architect, Mr. Aurelio has successfully implemented numerous business intelligence solutions ranging from global enterprise data warehouses and data marts to custom OLAP reporting systems since 1994. He has architected, designed, developed, and implemented a number of data warehouse, business intelligence, web, and client - server solutions for numerous clients in various industries. With over fifteen years of solid experience in architecting, designing, building, implementing, and optimizing the underlying physical data warehouses with business intelligence on top, Mr. Aurelio’s solutions consistently exceed customer expectations.

TECHNICAL SKILLS:

  • MicroStrategy Business Intelligence Suite v8 and v9
  • Informatica 8.1.1
  • Oracle Warehouse Builder (OWB), OBIEE
  • ERWin
  • Enterprise Architect
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft Data Transformation Services (DTS)
  • DB2 Warehouse Manager
  • Confidential DataStage
  • Brio, Cognos, Business Objects, Siebel Analytics
  • Oracle 11g
  • Netezza
  • Microsoft SQL Server
  • DB2
  • Teradata
  • MicroStrategy SDK
  • Java/J2EE/ JavaScript
  • SQL/ PL/SQL / Transact-SQL
  • Packages, Stored Procedures, and Triggers
  • Active Server Pages (ASP)/Visual Basic (VB)/C
  • HTML/DHTML/CSS/XML
  • MS Windows
  • UNIX (AIX, Solaris)

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse and Business Intelligence Architect

Responsibilities:

  • Assess current data warehouse and business intelligence life cycle processes which includes but not limited to requirements gathering, logical design, dimensional design, normalized schema implentation, physical schema implementation, ETL design and implementation, BI design and implementation, performance tuning strategy, data quality, release / change management, and defect resolution, .
  • Formulate and document best practices and standards (includes logical and physical naming convention) to improve or fix flaws in current processes and design and make design and implementation success repeatable.
  • Analyze and review business and/or IT information reporting, analytical, and operational requirements
  • Familiarize, explore, and profile source system data models, data, and data quality.
  • Design and document using Oracle Data Modeler the logical entity model, dimensional model, staging schema, CIF/normalized schema, and physical star-schema data model.
  • Develop scripts to create needed tables - master, reference, transaction, staging, facts, dimensions, lookups, aggregate with the necessary PK, unique, and foreign key constraints.
  • Design, document, and implement indexing and aggregate strategy.
  • Formulate and document ETL source to target transformation mapping
  • Design, document, and implement reporting view layer.
  • Design, document, and implement BI tool schema and reporting layer.
  • Lead, mentor, train, and review work deliverables of data modelers, ETL developers, and BI developers.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects such as attributes (and their parent-child relationships), facts, transformation, hierarchies, aliases, and logical table using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, filters, prompts, consolidations, custom groups, advanced reports, datamarts, and documents using MicroStrategy Desktop
  • Design and develop custom look and feel and add-on functionality using MicroStrategy SDK

Confidential, Denovo

Data Warehouse/Business Intelligence Architect/Offshore Team Lead

Responsibilities:

  • Analyze and review functional and reporting requirements, existing reports, and source data.
  • Design logical dimensional model and physical star-schema data model.
  • Develop scripts to create fact and lookup tables.
  • Design inventory strategy.
  • Develop scripts to create sparse inventory tables.
  • Design aggregate strategy.
  • Develop scripts to create aggregate tables.
  • Develop ETL scripts to incrementally load fact, lookup, inventory, and aggregate tables.
  • Develop database scripts to create necessary views.
  • Design, develop, and test ETL mappings and packages with Oracle PL\SQL, Netezza scripts, Informatica, and SSIS.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects such as attributes (and their parent-child relationships), facts, transformation, hierarchies, aliases, and logical table using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, filters, prompts, consolidations, custom groups, advanced reports, datamarts, and documents using MicroStrategy Desktop

Confidential

Data Warehouse/Business Intelligence Architect

Responsibilities:

  • Analyze and review functional and reporting requirements, existing reports, and source data.
  • Design logical dimensional model and physical star-schema data model.
  • Develop scripts to create fact and lookup tables.
  • Design inventory strategy.
  • Develop scripts to create sparse inventory tables.
  • Design aggregate strategy.
  • Develop scripts to create aggregate tables.
  • Develop ETL scripts to incrementally load fact, lookup, inventory, and aggregate tables.
  • Develop database scripts to create necessary views.
  • Design, develop, and test ETL mappings and packages with Oracle PL\SQL, Netezza scripts, Informatica, and SSIS.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects such as attributes (and their parent-child relationships), facts, transformation, hierarchies, aliases, and logical table using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, filters, prompts, consolidations, custom groups, advanced reports, datamarts, and documents using MicroStrategy Desktop

Confidential

Data Warehouse/Business Intelligence Architect

Responsibilities:

  • Analyze and review functional and reporting requirements, existing reports, and source data.
  • Design logical dimensional model and physical star-schema data model.
  • Develop scripts to create fact and lookup tables.
  • Design inventory strategy.
  • Develop scripts to create sparse inventory tables.
  • Design aggregate strategy.
  • Develop scripts to create aggregate tables.
  • Develop ETL scripts to incrementally load fact, lookup, inventory, and aggregate tables.
  • Develop database scripts to create necessary views.
  • Design, develop, and test ETL mappings and packages with Oracle PL\SQL, Netezza scripts, Informatica, and SSIS.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects such as attributes (and their parent-child relationships), facts, transformation, hierarchies, aliases, and logical table using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, filters, prompts, consolidations, custom groups, advanced reports, datamarts, and documents using MicroStrategy Desktop

Confidential

Data Warehouse/Business Intelligence Architect/Developer

Responsibilities:

  • Analyze and review functional and reporting requirements.
  • Review and validate physical data model against the requirements.
  • Design and document the necessary attributes, facts, metrics, filters, prompts, report data sets, and dashboards for delivering the requirements,
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, filters, prompts, advanced reports, and interactive dashboards using MicroStrategy Desktop
  • Design row-level security architecture and develop proof-of concept.

Confidential

Data Warehouse/Business Intelligence Architect

Responsibilities:

  • Develop and design conceptual, logical and physical data models for MDM (Master Data Management) and BI architectures.
  • Develop and document data model metadata.
  • Interact with customers to gather requirements and provide solutions in support of business requirements.
  • Reverse engineer existing database schemas into 3rd normal form logical data models.
  • Work closely with Client to develop overall BI and reporting solution architecture and design guidelines
  • Provide vision and technical direction for advanced data visualization and analytics
  • Oversee technical deliverables of MicroStrategy Environment
  • Complete development of MicroStrategy Prototypes
  • Supervise BI developers and performs code reviews
  • Develop proofs-of-concept on an as-needed basis
  • Perform best in class technology knowledge transfer
  • Interact with customers to gather requirements and provide solutions in support of business requirements
  • Suggest and implements methods to improve process efficiencies
  • Work closely with system and database administrators
  • Adhere to standards and Agile methodology
  • Maintain customer confidence and protects operations by keeping information confidential

Confidential

Data Warehouse/Business Intelligence Architect

Responsibilities:

  • Gather reporting requirements and work with end users to ensure environment can reach its full potential
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Design, develop, and test ETL mappings with Informatica.
  • Ensure data is integrated for timely reporting and analysis
  • Design and implement reporting solutions to help customers gain insight into their data to maximize performance and profitability using OBIEE and MicroStrategy.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 and v9 Desktop.
  • Create custom web interfaces and enhance functionality using MicroStrategy SDK v8 and v9.
  • Gather reporting requirements and work with end users to ensure environment can reach its full potential
  • Work with clinical research data, protocol or study data, and patient’s adverse event data.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Design, develop, and test ETL mappings with Informatica.
  • Develop, optimize, and maintain Oracle and Sybase DDL/DML scripts which are used to create tables, indexes and views and populate tables.
  • Design and document source to target data mapping and transformation documents
  • Review and test data loads and provide feedback and suggestions to ETL team
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 and v9 Desktop.

Confidential

Data Warehouse/Business Intelligence Architect

Responsibilities:

  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Design, develop, and test ETL mappings and packages with Microsoft SSIS.
  • Gather reporting requirements and work with end users to ensure environment can reach its full potential
  • Ensure data is integrated for timely reporting and analysis
  • Design and implement reporting solutions to help customers gain insight into their data to maximize performance and profitability
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 and v9 Desktop.
  • Create custom web interfaces and enhance functionality using MicroStrategy SDK v8 and v9.
  • Work with member, subscriptions, medical claim, and pharmacy claim data which includes procedure, diagnosis, drug, lab, and clinical research information.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Develop, optimize, and maintain Oracle and Sybase DDL/DML scripts which are used to create tables, indexes and views and populate tables.
  • Design and document source to target data mapping and transformation documents
  • Review and test data loads and provide feedback and suggestions to ETL team
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 and v9 Desktop.
  • Create custom web interfaces and enhance functionality using MicroStrategy SDK v8 and v9.
  • Create dynamic subscriptions using MicroStrategy Narrowcaster
  • Design, develop, and implement conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Design and document source to target data mapping and transformation documents
  • Design, develop, and test ETL mappings with Informatica.
  • Review and test data loads and provide feedback and suggestions to Informatica ETL team
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 and v9.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Design, develop, and test ETL mappings and packages with Microsoft SSIS.
  • Review and analyze existing environment, metadata architecture, reports, and dashboards
  • Optimize and tune existing metadata architecture, reports, and dashboards
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect
  • Design, develop, and implement additional complex metrics, advanced reports, and interactive dashboards using MicroStrategy Desktop.
  • Develop, optimize, and maintain Oracle DDL/DML scripts which are used to create tables, indexes and views and populate tables.

Confidential

Business Intelligence / Data Warehouse Architect

Responsibilities:

  • Work with member, subscriptions, medical claim, and pharmacy claim data which includes procedure, diagnosis, drug, and lab information.
  • Involved in reviewing user reporting and analysis requirements and specifications.
  • Involved in project planning and design.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Created and maintained data model using ERWin.
  • Created and maintained ETL design.
  • Created and maintained data dictionary, data mapping, and transformation specifications.
  • Design, develop, and test ETL mappings and packages with Microsoft SSIS.
  • Developed Oracle PL/SQL scripts to create tables, indexes, triggers, and stored procedures.
  • Developed ETL mappings using Informatica 8 and Oracle Warehouse Builder (OWB).
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 Desktop.
  • Create custom web interfaces and enhance functionality using MicroStrategy SDK v8.

Confidential

Business Intelligence / Data Warehouse Architect

Responsibilities:

  • Involved in reviewing user reporting and analysis requirements and specifications.
  • Involved in project planning and design.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Created and maintained data model using ERWin.
  • Created and maintained ETL design.
  • Created and maintained data dictionary, data mapping, and transformation specifications.
  • Developed Oracle PL/SQL scripts to create tables, indexes, triggers, and stored procedures.
  • Developed ETL mappings using Informatica 8 and Oracle Warehouse Builder (OWB)
  • Developed complex SQL queries to validate quality of data and for exception reporting.
  • Assisted in the design, development, test, and deployment of Cognos reports ranging from simple to complex.
  • Performed database tuning and optimization for standard and ad hoc reports.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 Desktop.

Confidential

Business Intelligence / Data Warehouse Architect

Responsibilities:

  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8.
  • Involved in reviewing user reporting and analysis requirements and specifications.
  • Involved in project planning and design.
  • Performed data model analysis and data exploration on JDE and PeopleSoft source systems.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Developed SQL SERVER and Oracle scripts to create tables, indexes, triggers, and stored procedures.
  • Developed ETL mappings using Informatica, SSIS, and Confidential Ascential DataStage
  • Developed OLAP cubes using SSAS and BI reports using SSRS
  • Developed complex SQL queries to validate quality of data and for exception reporting.
  • Designed, developed, tested, and deployed Microsoft Report Services projects ranging from simple to complex.
  • Performed database tuning and optimization for standard and ad hoc reports.

Confidential

Data Warehouse Architect

Responsibilities:

  • Involved in reviewing user reporting and analysis requirements and specifications.
  • Provided input for in project planning and design.
  • Performed data model analysis and data exploration on finance, sales, and operations source systems.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Developed, modified, and maintained SQL SERVER, Oracle, and Teradata SQL scripts to create tables, indexes, triggers, and stored procedures.
  • Developed ETL mappings using Informatica 7 and SSIS
  • Developed OLAP cubes using SSAS and BI reports using SSRS
  • Assisted report developers using Business Objects and Siebel Analytics.
  • Developed complex SQL queries to validate quality of data and for exception reporting.
  • Performed database tuning and optimization for standard and ad hoc reports.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 Desktop.

Confidential

Business Intelligence / Data Warehouse Architect

Responsibilities:

  • Designed, developed, tested, and deployed MicroStrategy and Brio reports ranging from simple to complex.
  • Involved in reviewing user reporting and analysis requirements and specifications.
  • Involved in project planning and design.
  • Involved in the evaluation of various reporting/analytical tools like MicroStrategy, Brio, Business Objects, and Crystal Reports and ETL/EAI technologies like DB2 Warehouse Manager, Ascential DataStage, Informatica, and Confidential MQSeries.
  • Architect, design, develop, implement, and maintain conceptual, logical, and physical data models specifically for the BI/DW environment while adhering to enterprise standards and best practices.
  • Develop and maintain the data dictionary and ETL high level design and source-to-target mapping specifications.
  • Developed SQL SERVER, DB2 SQL, ORACLE SQL, and UNIX scripts to create tables, indexes, triggers, and stored procedures. This also includes PLSQL, TransactSQL, DTS packages, Informatica mappings, Teradata SQL and BTEQ, and Oracle Warehouse Builder (OWB) mappings.
  • Developed complex SQL queries to validate quality of data and for exception reporting.
  • Performed database tuning and optimization for standard and ad hoc reports.
  • Add warehouse tables to the metadata repository catalog, create and configure schema objects (attributes and facts) and their relationships with each other using MicroStrategy Architect.
  • Design, develop, and implement complex metrics, advanced reports, and interactive dashboards using MicroStrategy v8 Desktop.

Confidential

Application Architect

Responsibilities:

  • Responsible for developing OLAP cubes, web interfaces and components, data modeling, and database development for a financial budgeting and forecasting system to be used by a major oil and gas exploration and drilling company.
  • Technologies, languages, and tools utilized included SQL Analysis Server (OLAP Server), SQL, T-SQL, SQL Server 2000, DTS, Stored Procedures and Triggers, JavaScript, ASP, Visual Interdev, VB, COM, XML, SOAP, HTML/DHTML, and JSP.

Hire Now