Veteran consultant in data warehousing and analytics with broad business and IT experience spanning analysis, design, development, and implementation with emphasis on: • Tableau Visualization, Data integration, ETL and business intelligence • Data architecture, conceptual/logical/physical data modeling and complex terabyte sized integration applications • Broad experience in project recovery and re-engineering efforts from legacy implementations to scalable enterprise solutions • Business analysis, data analysis and profiling experience including dimensional modeling and functional analysis in various business domains • Ability to differentiate business from technical requirements and priorities as well as communicate effectively with both business and technical teams • Broad experience working on a variety of database and BI environments including Oracle, SQL Server, Sybase, DB2, UDB, MySQL, Netezza, Hadoop Hive, Tableau, Microstrategy, Business Objects, OBIEE, Hyperion and Cognos

Tableau / Visualization Analyst @ • Report directly to the marketing department to develop advanced dashboards and visualizations for operational and analytic requirements around sales, web traffic, conversion funnels, and user segmentations • Collaborate with internal Salesforce and Hive resources to develop the required data pipelines for Tableau data sources • Create Tableau server based data sources and extracts with business oriented metadata layers connected to various data repositories such as Cloudera Hive, SFDC, Sql Server and Excel. • Develop operational, strategic and analytical dashboards, utilizing advance features such as table calcs, blending, parameters, actions, etc. • Perform light administrative functions such as creating users, user groups and projects with the appropriate permissions • Create starter and template workbooks for new Tableau business users • Technology Stack: Tableau desktop and server 8.3, Cloudera Hive, Salesforce From January 2015 to Present (10 months) San Francisco Bay AreaTableau / BI Analyst @ • Interact directly with marketing and finance business users to understand their dashboard and analytics requirements • Create business and functional requirement documents containing presentation and data requirements • Perform source data and gap analysis and coordinate with IT data services teams to meet data requirements • Create Tableau server based live and extract (full and incremental) enterprise data sources with business oriented metadata layers connected to various data repositories such as Oracle, Excel, Hadoop Hive and complex custom sql. • Develop and prototype Tableau interactive dashboards and workbooks with appropriate and effective visualizations, utilizing advance features such as table calcs, blending, parameters, actions, custom geocoding and mappings, etc. • Perform light administrative functions such as creating users, user groups and projects with the appropriate permissions • Create starter and template workbooks for new Tableau business users • Technology Stack: Tableau desktop and server 8.2, Pentaho Enterprise BI 5.x, Oracle, Postgres, and Hadoop Hive From December 2013 to December 2014 (1 year 1 month) San Francisco Bay AreaETL Architect @ • Informatica SME resource for OWB to Informatica conversion project • Provide reference/template Informatica mappings for different use cases • Analyze business rules and production OWB mappings to create current source to target specifications • Develop pilot project workflows to serve as a reference framework and benchmark comparisons against legacy OWB processes • Provide technical leadership and assist internal OWB resources with their transition to Informatica. • Gather business requirements and create functional and technical specifications for onsite and offshore ETL teams • Technology Stack: Oracle 11g, OWB, Informatica 9.5 and Business Objects From July 2013 to December 2013 (6 months) San Francisco Bay AreaData Architect / Modeler @ • Asses the current state of AAA’s property and casualty insurance enterprise data warehouse structures in meeting the business’ analytic and reporting requirements for premium/loss stat, loss ratio and executive score card related data. • Recommend data warehouse project recovery strategies • Develop conceptual, logical and physical data models. • Develop data models for OLTP, dimensional and anchor model (IBM IIW) technical environments • Support the model from inception, physical instantiation, optimization and maintenance. • Gather business requirements and create functional and technical specifications for onsite and offshore ETL teams • Provide business and technical leadership for both on-site and offshore leads and develop the complex and mission critical mappings. • Work with business stakeholders and ETL teams during requirements, development and user acceptance testing to ensure data elements affecting key performance indicators are captured and populated accurately. • Technology Stack: IBM IIW, Erwin 7/8 Modelmart, Oracle, Informatica 8.6 and Cognos From November 2011 to July 2013 (1 year 9 months) Walnut Creek, CABusiness & Functional Analyst @ • Gather business requirements for global sales, order management, supply chain & Finance domains and create functional specifications for data warehouse, cube and presentation layers • Review reporting designs/mock-ups to ensure the capabilities address the functional needs of the business including KPI’s and usability • Identify technical areas and estimate the work effort and resources affected by business requirements • Manage IT architects and developers in delivering project driven business and functional requirements • Manage systems integration testing, facilitates creation of QA environments, and coordinate user acceptance tests • Work with business program, IT managers and business stakeholders in prioritizing BI requirements and IT dependencies • Function as the main IT project point of contact and business liaison in a global environment • Technology Stack: Oracle, EBS, OBIEE, Hyperion Essbase, and Informatica From March 2011 to November 2011 (9 months) Fremont, CAETL Architect @ • Analyze business and technical requirements and collaborate with Subject Matter Experts, Technical Consultants, Solution Architects and Developers to drive the design and development process • Evaluate the current data warehouse implementation, recommend and implement architecture based on the company’s BI sophistication while leveraging in-house technology and existing code base • Stabilize and optimize highly unstable and inefficient ETL processes for the company’s mission critical Financial Data Warehouse • Re-engineer ETL processes from store procedures, SSIS and Pentaho (Kettle) into Informatica • Re-configure and upgrade Informatica PowerCenter from 8.1 to 8.6, 8.6 to 9.x • Mentor and train employees in Informatica to attain consultant level skills • Provide 24/7 production level-2 support retained services • Technology Stack: Informatica PowerCenter 8.6 on Windows, Microstrategy, SQL Server 2005 and MySql From August 2010 to February 2011 (7 months) San Mateo, CAInformatica Consultant @ • Assist in designing the MDM hub for shrink-wrap and b2b customer mastering and develop Informatica and ABAP ETL processes for Adobe’s first Customer MDM initiative. • Cleanse and load the MDM hub customer data from SAP: ECC, CRM, SFA (Sales Force Automation), and legacy systems using PowerExchange SAP Netweaver. • Source licensing and billing transactional data from BW with Informatica PowerExchange for licensing reconciliation and optimization, EDW, BI and operational reports • Physicalize and optimize logical data models into Oracle objects; partitions, materialized views, indexes, etc. tuned for ETL and reporting functions • Technology Stack: Informatica PowerCenter / SAP PowerExchange 8.6 on UNIX, Business Objects, Oracle 10g, Initiate, SAP, and BW From November 2009 to August 2010 (10 months) San Jose, CAInformatica Consulant @ • Re-engineer existing SSIS / SQL loads with Informatica • Train and mentor client employees in Informatica • Formulate a group development, support and change control process for a shared Informatica environment • Assist client employees in the physical modeling of ODS and data mart structures • Document departmental wide ETL standards and Architecture • Design a source adapter architecture to integrate data from multiple and heterogeneous source systems • Evaluate, benchmark and deliver POC for Talend • Technology Stack: Informatica PowerCenter 7.1.x on Linux, Talend Enterprise, Microstrategy, Netezza, Oracle 10g From February 2009 to November 2009 (10 months) San Francisco Bay AreaETL Architect @ • Upgrade from PowerCenter 7.x to 8.1.1 and installing metadata manager component • Install additional nodes and implementing a high-availability server grid environment • Determine the best implementation of recently purchased PowerConnect component for Netezza • Evaluate existing Informatica licenses/options and recommend what’s optimal for classmates’ environment • Develop POC for the Pushdown and 64-bit options for Netezza • Develop, maintain and re-engineer the most complex and mission critical ETL processes • Technology Stack: Informatica PowerCenter 8.1.x on Linux, Microstrategy, Netezza, Oracle 10g From July 2008 to February 2009 (8 months) Greater Seattle AreaData Integration Architect @ • Create a comprehensive Process/Data Flow/Database EDW blue print architecture from back to front room areas of implementation • Set up and recommend Informatica infrastructure, standards, and best practices for EDW version 1.0 • Design High-Availability and server grid architecture with Informatica 8 • Lead ETL developers and build the most complex Informatica mappings • Design/model logical and physical dimensional schemas • Support the legacy data warehouse on Sql Server 2000 • Technology Stack: Informatica PowerCenter 64-bit 8.1/8.5 on Linux, Oracle 10g, Sql Server 2000, DTS, Microstrategy From August 2007 to July 2008 (1 year) Pasadena, CAData Architect / Data Modeler @ • Gather business requirements and translate them to technical business rules and prototypes for requirements validation • Create data models and transformation rules for traffic categorization and member segmentation • Lead development of ETL processes to populate and process transformation rules • Technology Stack: Informatica PowerCenter 7.4 on Linux, Microstrategy, and Netezza, Oracle 10g From January 2007 to August 2007 (8 months) Greater Seattle AreaSenior ETL Developer @ • Redesign existing ETL processes from SQL Server DTS packages and transact SQL procedures to Informatica mappings and workflows • Develop and maintain Informatica mappings and complex workflows to load corporate housing tenancy, inventory management, Siebel opportunity and gross profit data marts • Redesign existing Business Objects universes to connect from an OLTP to star schema database structure • Responsible for overall application QA • Technology Stack: Informatica PowerCenter 7.1, Business Objects XI, SQL Server 2000/2005 From February 2006 to January 2007 (1 year) Greater Los Angeles AreaInformatica SME @ Informatica SME • Stabilized and optimized existing ETL processes for the Royalty/Licensing Data Warehouse. • Recommend Informatica infrastructure, standards, and best practices • Reverse engineered Sybase stored procedures into Informatica mappings • Provide informal Informatica “Boot Camp” training for in-house staff • Provide 24/7-production support. • Technology Stack: Informatica PowerCenter 6.2 / 7.1, Sybase ASE, UDB DB2, UNIX Sun Solaris From April 2005 to February 2006 (11 months) Burbank, CAData Architect / Modeler @ From July 2004 to April 2005 (10 months) Bakersfield, California AreaData Acquisition Specialist @ Data Acquisition Specialist • Informatica Subject Matter Expert • Developed and deployed Informatica ver 5.x and 6.2 mappings and batches/workflows to load Genentech’s pharmaceutical enterprise data warehouse concentrating on sales and reimbursement subject areas. • Installed and supported upgrade to PowerCenter Version 6.2. • Created and maintained logical and physical data models. • Defined Oracle objects in development and QA environments • Developed PL/SQL stored procedures • Technology Stack: Informatica PowerCenter 5.1 – 6.2 on Unix, Crystal Reports, Oracle 8i, HP-UX From July 2003 to July 2004 (1 year 1 month) San Francisco Bay AreaSenior ETL Developer @ • Developed and deployed Informatica ver 6.x mappings and workflows to load Nissan’s Global Financial and Accounting Data Warehouse • Sources were pushed from various accounting systems including SAP and Nissan subsidiaries, which were validated, re-allocated and loaded to a UDB DB2 data warehouse which in turn were extracted for loading to Essbase and Hyperion reporting. • Extensively utilized the new features of Informatica ver 6.x whenever feasible and advantageous. • Technology Stack: Informatica PowerCenter 6.1 on Unix, UDB DB2 EEE, Essbase / Hyperion, Unix AIX (RS/6000) From October 2002 to June 2003 (9 months) Greater Los Angeles AreaData Architect @ • Gathered business and reporting requirements to determine project scope and identify data architecture and ETL requirements. • Architected, modeled, and integrated additional data mart subject areas including modeling for ODS and data mart schemas. • Architected and designed new financial data warehouse sourcing from Oracle Financials. • Enhanced and optimized Siebel’s pre-packaged CRM data mart application specifically affecting the bundled Informatica Maps. Functionality added included incremental loading and implementation of type-2 slowly changing dimensions. Source and target RDMS was Oracle. • Assumed role as Informatica Subject Matter Expert with deliverables including “best practices”, administration and change control procedures and optimization techniques. • Technology Stack: Informatica 5.x on Windows, Business Objects, Oracle 8i, Siebel, Unix Sun Solaris From September 2001 to September 2002 (1 year 1 month) San Francisco Bay AreaInformatica SME @ • Architected, designed, and developed Informatica/ETL architecture and maps including oracle schema objects for 1:1 and CRM Business Intelligence data warehouse/stores and ODS/HDS. • Gathered and documented end-user requirements. • Designed Business Objects Universes and Business Intelligence reports • Assisted Informatica Corp in developing and enhancing their e-commerce data warehouse application to source from BroadVision. • Trained and mentored employees on Data Warehouse and Informatica “best practices”. • Performed data sourcing and transformation across various sales, support and customer profile systems mostly from Broad Vision while loading a customer and web click stream data mart on Oracle 8, NT, and Sun Solaris platforms using Informatica PowerMart 4.5 • Stabilized the Informatica development and production environments by formulating standards and procedures as well as optimizing existing Maps • Recommended and implement repository and folder architecture to implement a secured change control and migration procedure for development, implementation and maintenance • Installed and configured PowerMart NT and Unix servers • Technology Stack: Informatica 4.x on Windows, Oracle 7/8, SQL Server 7, 2000, Unix Sun Solaris From May 2000 to September 2001 (1 year 5 months) San Francisco Bay Area (Macromedia)Business Intelligence Consultant @ BI Architect • Delivered Proof of Concept and pilot for a Dimensional Clinical Trial Data Mart Environment sourcing from Informix and Oracle Clinical while targeting Oracle schemas • Implemented the use of ROLAP technology for real-time test result analysis and mining (Business Objects) • Architected and modeled data mart star schema models and ETL specifications after a thorough analysis of the users’ scientific, statistical and business requirements • Developed Informatica ETL and stored procedure processes for the Clinical Trial Data mart • Technology Stack: Informatica 4.x on Unix, Business Objects, Erwin, Oracle 7/8, Unix AIX – RS/6000 From June 1999 to May 2000 (1 year) Greater Los Angeles Area

Anthony Calayag is skilled in: Data Warehousing, Informatica, Data Modeling, ETL, Data Integration, Business Intelligence, Business Objects, Oracle, Data Quality, Data Warehouse..., Dashboard, Cloud Computing, Microstrategy, OLAP, Teradata, Databases, Dimensional Modeling, Erwin, Subversion, .NET, Windows, Sybase, SQL, BI Publisher, Data Marts, Database Design, PL/SQL, Business Intelligence..., Unix Shell Scripting, Netezza, Tableau, Master Data Management, Hadoop, SSIS, OBIEE, DB2, Data Architecture, Performance Tuning, Data Governance, Data Mining, QlikView, Pentaho, MicroStrategy, Shell Scripting