Business Intelligence Architect Resume
SUMMARY:
- More than 19 years of experience into analysis, programming, application development, technical leads and team leads, coaching and managing and most notably into BI (business intelligence), enterprise data warehousing architecture, enterprise data modeling and ETL development (Data Integration).
- Over 19 years strong experience in designing, building and managing enterprise data warehouse on Oracle, Teradata and SQL Server including BI report design, data warehouse modeling, ETL development and, quality assurance and technical supporting.
- I have worked in different industries like retail (General Motors Canada, Confidential, Loblaws, Confidential, La Senza), pharmaceutical & health care (IMS Health Canada, Confidential ), telecommunications (Cogeco, Confidential Mobility), financial ( Confidential, Bank of Confidential, Confidential, Genworth Financial), media (Code Rouge Media), loyalty (Air Miles) and transportation (Air Canada).
- Over 17 years' BI reporting design and development experience on Microstrategy 6, 7i, 8.1.1 & v9
- Over 17 years of on Microstrategy software to end - users and new development teams in various locations
- Over 17 years of ETL development manually scripting SQL code and calling it through automated processes or with the use of software like Oracle Warehouse Builder, SSIS and Informatica.
- Over 10 years of Kornshell and Batch scripting for custom projects automated with Autosys and Cybermation on UNIX and Windows platforms.
- Over 3 years of custom solutions development using VBA & VB.Net.
- Over 2 years of development of query tools in C and C#.
- 1 year BI reporting design and development experience on Cognos, Business Objects and BI/Query including architecture design, report development, deployment, administration and performance tuning.
- Proficient in Entity-Relationship and multi-dimensional modeling and SQL programming including SQL Server procedures and Oracle PL/SQL procedures.
- Strong industry related experience such as retail, pharmaceutical, insurance, telecommunication, finance and media.
TECHNICAL SKILLS:
BI: Microstrategy 6,7, 8 & 9 suite, Cognos, Business Objects, BI/Query, JasperSoft iReports, WebFocus, Microsoft Power BI
OS: Unix (Sun, HP and IBM), Windows, Linux
DBMS: Oracle, NCR Teradata, MySQL, MS SQL Server, Netezza, DB2, Access
ETL Tools: Informatica, OWB (Oracle Warehouse Builder v9 & 10.2), SSIS, DataStage, Bteq, Mload, Tpt
Programming: MS C#/VB.net, VBA, Unix Shell, Batch Scripts, ErWin, Visio
WORK EXPERIENCE:
Business Intelligence Architect
Confidential
Responsibilities:
- Provide leadership and define the corporate strategy for all data modeling/warehousing projectsfor Air Canada
- Supervise the integration of new data sources that will retire legacy systems/applications and contribute to the competitive success of Air Canada.
- Oversee cross functional data integration with multiple Business Units (Commercial,
- Finance, HR, eCommerce, Maintenance, Corp Safety, Revenue Accounting, etc…)
- Guide enterprise clients to make better business decisions via timely, accurate and scalable data access.
- Air Canada onsite data integration team (DataStage Administrator/ETL Developer, Teradata DBA/ETL Developer)
- Teradata onsite senior DBA/ETL Developer
- Teradata offshore ETL Developers
- Teradata offshore DBA's
- RMODC, revenue management origin destination calculations
- Upgrade of the Teradata database server to a 6700 Active Data Warehouse
- Installation & Configuration of IBM Infosphere Information Server
- Altitude Qualifying DollarsHere are some of the different tasks I have to execute:
- Data Architecture, Data Dictionary, Entity Relationship Diagrams, Data Modelling, Data
- Consolidation, Data Integration, ETL, BI, Database Administration, Project Management, Optimizations & Support
- Commercial
- Revenue Management
- Sales
- Marketing
- Revenue Accounting
- Finance
- Rouge
- Production & Performance Teradata DBA
- ETL Developer (DataStage, Mload, Bteq, Tpt)
- Support on ETL jobs
- Project Manager
Teradata 14.10
- IBM Infosphere Information Server Datastage 11.3
- Information Builders WebFocus 8
- CA Erwin Data Modeler 9.5
- IBM Infosphere Information Server Data Architect 9.1.2
- Attended Teradata Partners in Anaheim
Enterprise Data Architect
Confidential
Environment: Teradata, DataStage, Informatica, Control-M, MS Power BI & IB WebFocus.
Responsibilities:
- I managed 4 different teams, onsite & offshore, for a total of 25 resources.
- Data Architecture: Logical modeling, physical modeling and data dictionary done with Erwin. Database design is denormalized, data marts, 3nf normalized, multidimensional star / snowflake oriented.
- Data Analyst: Data mapping, data profiling, value mapping and data transformation rules.
- ETL: Development done with Teradata Tools & Utilities, DataStage & Informatica. Scheduling through Cron, Daemon and Control-M.
- BI: Development done with Information Builders WebFocus and Microsoft Power BI.
- Develop the vision around design and management of data as it pertains to the business strategy.
- Build a 3 to 5 years data roadmap plan highlighting future requirements, projects and budgets.
- Establish processes for governing the identification, collection and use of corporate metadata; take steps to assure metadata accuracy and validity.
- Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, business cases for expansions.
- Develop data security policies in conjunction with other security focused IT resources based on regulatory guidelines and ensure guidelines are followed as we are audited on a yearly basis.
- Enterprise-wide data modeling and database design - design data models and architectural plans based on business and strategic requirements.
- Analyze and establish governance, stewardship, and frameworks for managing data across the organization. Ensures existing data/information assets are identified, stewarded and leveraged across the enterprise.
- Oversee the design, evaluation, selection, implementation and support of major databases and metadata structures.
- Work with third parties and external service providers to develop reporting solutions and approaches.
- Ownership and maintenance of data-related artifacts (e.g. Data Governance Framework).
Data Architect
Confidential
Environment: SQL Server databases, SSIS & Microstrategy.
Responsibilities:
- Project management: Agile
- Data Architecture: Logical modeling, physical modeling and data dictionary done with Erwin. Database design is multidimensional star / snowflake oriented.
- Data Analyst: Data mapping, data profiling, value mapping and data transformation rules.
- ETL: Development done with SSIS from automatic scheduling of daily extractions across different databases. Multiple packages, slowly changing dimensions, SFTP, exception handling, automation of email notifications.
- BI: Development done with Microstrategy Enterprise Analytics. Dashboards, Data Visualization, Scheduled reports and automatic distribution through emails. Development of the mobile content for tablets and smartphones.
- Develop the vision around design and management of data as it pertains to the business strategy for a shared services organization.
- Establish processes for governing the identification, collection and use of corporate metadata; take steps to assure metadata accuracy and validity.
- Conduct data capacity planning, life cycle, duration, usage requirements, and feasibility studies.
- Develop data security policies in conjunction with other security focused IT resources based on regulatory guidelines and ensure guidelines are followed.
- Design and lead implementation of a self-service data access solution for non-technical users.
- Enterprise-wide data modeling and database design - design data models and architectural plans based on business and strategic requirements.
- Maintain and adhere to enterprise modeling standards. Establish, maintain, and enforce data model design principles, techniques, standards, and best practices.
- Analyze and establish governance, stewardship, and frameworks for managing data across the organization. Ensures existing data/information assets are identified, stewarded and leveraged across the enterprise.
- Oversee the design, evaluation, selection, implementation and support of major databases and metadata structures.
- Work with third parties and external service providers to develop reporting solutions and approaches.
- Ownership and maintenance of data-related artifacts (e.g. Data Governance Framework).
Senior Onsite BI Technical Architect
Confidential
Environment: SQL Server databases, Informatica & Microstrategy.
Responsibilities:
- Active involvement with the Data Architect to provide helpful tips as to best practices and requirements of the BI tool.
- Assisted with Informatica development.
- Built a demo with Microstrategy new features in 9.4
- Dashboard and data visualization development.
Senior Data Integration Architect
Confidential
Environment: SQL Server databases, Informatica & Microstrategy.
Responsibilities:
- Ensure the overall development of tools for data warehouse.
- Perform design and architecture of the MicroStrategy platform.
- Ensure the quality and consistency of projects related to the MicroStrategy platform.
- Estimate the effort required to make changes to MicroStrategy objects.
- Ensure that the design and modeling of the database interacts properly with the MicroStrategy SQL engine.
- Approve deliverables on the MicroStrategy platform.
- Review data models and support product development team.
- Ensure that BI products produce optimal times for data retrieval queries.
- Develop and implement effective procedures for extraction and data access.
- Perform quality control on the various developments, ETL with Informatica and BI with MicroStrategy.
- Coordinate the production of solutions and provide support as needed.
Senior Data Integration Architect & BI Lead
Confidential
Environment: Oracle databases, JasperSoft iReports & Microstrategy, ErWin.
Responsibilities:
- Functional analysis using waterfall model on.
- Identifying gaps and mapping data from source to data warehouse.
- Report development using JasperSoft iReports.
- Support assistance and development of a forecast metric.
Senior Business Intelligence Consultant
Confidential
Environment: Informatica, Oracle databases on Exadata & Business Objects.
Responsibilities:
- Data Integration using Informatica on an Oracle database sitting on Exadata servers from Oracle.
- Creation of DDL’s for DBA’s for the creation or modification of tables, creation or modification of procedures.
- Team working with the data architects, with the business analysts, with the business objects teams.
- 18 projects divided under 4 tracks to be delivered within a 3 months period.
- ETL development with Informatica involves creation of mappings, workflows, sessions and many other Informatica objects as well as monitoring and debugging of queries. Modifications to existing data marts. Inserts/Updates/Deletes of tables and SCD tables.
BI / Oracle Warehouse Builder / Microstrategy Technical Lead
Confidential
Environment: Oracle Warehouse Builder, Oracle databases & Microstrategy v9.0.2, ErWin.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, ETL process, Data Warehouse & Schema objects).
- Creation of schema objects like facts, attributes, hierarchies, parent/child relationships and also database objects like views.
- Modifications include: tables and views in database schema, metadata objects, advanced filter qualifications, complex compounded metrics and customized documents (report services).
- ETL development with OWB Designer. Creation of mappings and workflows. Modifications to existing data marts. Insert/Updates of tables and SCD tables.
Business Intelligence Technical Lead
Confidential
Environment: Informatica, Teradata database & Microstrategy v9.0.2, ErWin.
Responsibilities:
- On this short contract, I had to focus on one huge dynamic dashboard that made use of intelligent cubes to improve performance at run-time.
Lead BI Consultant
Confidential
Environment: Tibco/Ab Initio, Oracle/DB2 databases & Microstrategy v9.0.2.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, ETL process, Data Warehouse & Schema objects).
- Creation of schema objects like facts, attributes, hierarchies, parent/child relationships and also database objects like views.
- Modifications include: tables and views in database schema, metadata objects, advanced filter qualifications, complex compounded metrics and customized documents (report services).
- Development of dynamic dashboards scheduled and distributed.
Business Intelligence Technical Lead
Confidential
Environment: Informatica, Teradata database & Microstrategy v9.0.2, ErWin.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, ETL process, Data Warehouse & Schema objects).
- Creation of schema objects like facts, attributes, hierarchies and also database objects like views.
- Modifications include: tables and views in database schema, metadata objects, advanced filter qualifications, complex compounded metrics and customized documents (report services).
- Development of dynamic dashboards.
Senior Business Intelligence Consultant
Confidential
Environment: Informatica, Oracle 10g database & Microstrategy v9.0.1, ErWin.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, ETL process, Data Warehouse & Schema objects).
- Creation of schema objects like facts, attributes and hierarchies.
- Modifications include: ETL process, tables in database schema, metadata objects, advanced filter qualifications, complex compounded metrics and customized documents (report services).
- Development of dynamic dashboards and custom widgets.
Senior Business Intelligence Consultant
Confidential
Environment: Netezza database, Oracle 10g database & Microstrategy v8.1.2 et v9.0.1, ErWin.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, Data Warehouse & Schema objects).
- User/License management, technical support, enhancements.
- Enhancements include: Custom SQL procedures, tables in database schema, metadata objects, advanced filter qualifications and complex compounded metrics.
- Microstrategy upgrade to version 9.x
- Architecture and modeling for a new project, ad-hoc reports, custom dashboards using v9.x functionalities.
Senior Business Intelligence Consultant
Confidential
Environment: Informatica, Oracle 10g database & Microstrategy v8.1.2, ErWin.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, ETL process, Data Warehouse & Schema objects).
- Creation of schema objects like facts, attributes and hierarchies.
- Modifications include: ETL process, tables in database schema, metadata objects, advanced filter qualifications, complex compounded metrics and customized documents (report services).
- Development of dynamic dashboards and custom widgets.
Senior Business Intelligence Consultant
Confidential
Environment: Informatica, Oracle 10g database & Microstrategy v8.1.1, ErWin.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, ETL process, Data Warehouse & Schema objects).
- Modifications include: ETL process, tables in database schema, metadata objects, advanced filter qualifications, complex compounded metrics, customized documents (report services).
- Development of dynamic dashboards and custom widgets.
Senior Business Intelligence Team Lead
Confidential
Environment: SQL Server 2005 database & Microstrategy v8.1.1, ErWin, SSIS.
Responsibilities:
- Analysis at the functional & back end level (Business perspective, ETL process, Data Warehouse & Schema objects).
- Modifications include: ETL process, tables in database schema, metadata objects, advanced filter qualifications, complex compounded metrics, customized documents (report services).
- Automated report executions with custom scheduling criteria’s.
- Microstrategy Mobile for Blackberry’s & report delivery methods through Narrowcaster.
ETL - Oracle Warehouse Builder Developer
Confidential
Environment: Oracle 10gR2 Database & Oracle Warehouse Builder 10gR2, ErWin.
Responsibilities:
- Documented best practice, focused on environments for multi-department developers. f new developers with no previous warehouse builder experience.
- Conversion of existing ETL PL/SQL scripts into Oracle Warehouse Builder.
Senior Business Intelligence Consultant
Confidential
Environment: Teradata Database & Microstrategy v8.0.1, ErWin.
Responsibilities:
- Gathered client needs in regards to the apparel department, performed conceptual analysis of new model for this department, conception of the Microstrategy model, schema & reports.
- Worked in parallel with 3 other teams from different firms competing one against each other.
- All database scripts (ddl’s) were created and tested before submitted to dba’s for execution.
- Creation of Microstrategy Dashboards with flash technology for the web.
Senior Business Intelligence Team Lead
Confidential
Environment: Oracle Database 9i & Microstrategy v8.0.1, ErWin.
Responsibilities:
- Gathered internal client needs, performed conceptual analysis, conception of the Microstrategy model, schema & reports. to end users on Microstrategy features.
- Analysis documents created for business functional needs, Oracle schema conception & ETL, Microstrategy schema solution, report development and end user guides.
Senior Analyst
Confidential
Environment: SQL Server, IBM AS/400, VBA development, Batch Scripting on Windows platform.
Responsibilities:
- Gathered internal clients needs, performed conceptual analysis and programmed an automated solution.
- Developed and tested new financial reporting systems using VBA and SQL Server (Papyrus).
- Documented existing procedures, improved already existing systems.
- Converted all databases & programs to new versions of financial tools (Max 3, Integra).
Business System Analyst, Microstrategy specialist
Confidential
Environment: SQL Server, IBM AS/400, Oracle Database, Microstrategy v6 and v7i, VBA development, Batch Scripting on Windows platform & UNIX, ErWin, SSIS.
Responsibilities:
- Conducted technical and feasibility analysis on external client needs gathered by our representatives, most of theses were based on our Xplorer solution (Microstrategy 6).
- Developed and tested Microstrategy report solutions offered to our clients as Xplorer.
- Assisted schema designers in Plymouth (USA) with the conceptual model for Xplorer based on our current model (Microstrategy 7).
- Kornshell and batch scripting for custom projects automated with Autosys and Cybermation.
- Documented all new development in all new projects for future, both technical and business oriented.
- Custom solutions built using VBA & VB.Net.
Programmer / Analyst, Microstrategy Developer
Confidential
Environment: Teradata, IBM AS/400, Microstrategy v7i, Batch Scripting on Windows platform & UNIX, ErWin.
Responsibilities:
- Our small team of Microstrategy 7 specialists built the whole schema, reports, portal and security. I have been involved in all steps of the conception providing analysis on business needs.
- Assisted in the analysis of the star database model which was later exploded in each dimension in order to build aggregates tables to improve data mining capabilities.
- Monitored the system regularly to optimize and do some performance tuning.
- Produced analysis on internal clients needs before the report development started.
- Provided on Microstrategy software to end-users and new development team in Toronto.
- Used different business intelligence software such as: Eureka: Reporter and Strategy, Hummingbird: BI/Query and Cognos.
- Development of query tools in C.
- Procedure documentation from a technical point of view and from a business perspective.
Programmer Analyst
Confidential
Responsibilities:
- Development of interfaces and management of MRO: MAXIMO.
- Asset, Work, Procurement, Service, Materials and Contract management through MAXIMO.
- Oracle based reporting using SQR & SQL.
- Reporting analysis and interface analysis provided with every solution built.