OBJECTIVE:

Seeking a data architect C2C position where I can use my full lifecycle experience to improve the data and analytics capabilities of the organization. I have extensive experience in data architecture, data platforms, and business intelligence.

SUMMARY:

• Confidential Data Warehouse Certified Solutions Expert.
• Confidential Cognos Certified Solutions Expert.
• Netezza Silver Certified Engineer.
• Confidential Big Data Certified Big Data Foundations II, Hadoop Developer Level I, Spark Level I.
• Expert in business intelligence, big data, massively parallel processing, and cloud computing.
• Full lifecycle experience in the entire SDLC data warehouse stack including Cloudera (Hadoop). Confidential DB Dash, SQL Server, Oracle, Netezza, DB2, both RDMS and columnar database design, ETL, data modeling, and analytic semantic modeling.
• Project Management methodologies including Agile and Scrum.

TECHNICAL ACUMEN:

RDBMS Data Platforms: Oracle, MS SQL Server, DB2 Blue, DB Dash, Netezza, and MySQL.

Big Data Platforms and Tools: Apache Hadoop, Spark, Scala, MapReduce, YARN, Flume, Sqoop, Hive, and Cloudera Enterprise.

Data Modeling: MS Visio, Cognos Framework Manager, Database Workbench, MySQL Workbench, SQL Server Management Studio, Toad Data Modeler.

ETL: Confidential Cognos Data Manager, MS SQL Server Integration Services, and AB Initio.

Programming Languages: SQL, PL/SQL, T SQL, HIVE, HTML, CSS, XML, JavaScript, Java, C, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Warehouse Architect

Responsibilities:

• Develop logical data models, create physical database designs, assess implementation alternatives and formulate overall design approaches.
• Build and support ETL using Confidential Data Manager and 2005 SQL SERVER SSIS
• Design, develop, and deliver end - to-end business intelligence solutions
• Develop data models representing the business information requirements for functional areas. Utilize formal data modeling techniques and CASE tool technologies. Integrate the models and manage an overall enterprise data model.
• Utilizing data models, recommend appropriate database design (3NF, Star, Snowflake, Kimball dimensional modeling, and OLAP cube), explain merits of choice, create a physical database design, and implement it on RDBMS or MDDB technologies.
• Consult with end-user for their reporting & analysis needs and provide recommendations on potential solutions. Ensure solutions integrate with the data warehouse environment and appropriately leverage existing tools.
• Ensure data warehouse value proposition is sustained by developing and managing processes and procedures for communicating data warehouse content and value.
• Perform Data Architect role within Data Governance process.
• Provide on-going maintenance and operational support for the data warehousing environment.

Confidential

Senior Reporting Architect

Responsibilities:

• Conduct Current State Assessment ( Confidential ) of existing Data Warehouse and BI Technology
• Author North American Data Warehouse and BI Strategy including roadmaps and cost estimates
• Architect Logical Data Warehouse
• Deconstruct MS SQL Server 2012 DW for upgrade to 2016
• Technologies include Oracle 11 & 12, SQL Server 2205,2012,2016, SQL Server APS, CDC ETL

Confidential

Senior Data Architect

Responsibilities:

• Conduct Current State Assessment ( Confidential ) of existing Data Warehouse and BI Technology (Cognos, Oracle, and Netezza), Develop cloud based data strategy for Future State Architecture (FSA), Develop roadmap from Confidential to TSA.
• Lead Data Architect for Confidential - Star Hotel consolidation.
• Model & Design new data platform using Confidential Data Studio for DB2 Dash.
• Understand complex technical requirements for enterprise data management in a cloud big data platform including Confidential Big Insights, Impala, Spark, DB2 Dash, Cognos 10, and Netezza.
• The Data Warehouse Architect retains overall responsibility for the design, development, documentation and quality of the technical architecture that will support the functional design.
• Coordinate the design efforts of the various technical architects to ensure that the designs work together properly.
• Perform quality assurance on the designs created by each of the technical architects.
• Serve as the evangelist for the selected technical architecture.

Confidential

Enterprise Data Architect

Responsibilities:

• Design and Develop Compensation Application using MS SQL Server and Cognos 10.2 Dashboards.
• Developed ad hoc Tableau visualizations for executive team.
• Develop Cognos Framework Models.
• Work as an Enterprise Data and BI Architect.
• Responsible for delivering the logical and physical data models for AWS Data Lake for sales components.
• Document logical data integration into AWS Data Lake from data warehouses
• Working with both senior management and stakeholders to propose technology and architectural standards for the Enterprise Information Architecture and Data Warehouse / Business Intelligence platform.
• Provide clear direction and delegate responsibilities identifying the tasks, schedule, and resources with full ownership of quality of deliverables related to Data and BI Architecture.
• Build Oracle Data Marts and Cognos OLAP applications using Star and Snowflake schema design addressing Conformed Dimensions, Slowly Changing Dimensions, and Fixed and Variable Depth Hierarchies.
• Provided master data management and governance strategies to address data quality issues.

Confidential

Information Analytics Architect

Responsibilities:

• Design and Develop Data Warehouse for Tax Information Factory using Oracle PL/SQL.
• Design and implement data warehouse solutions using Confidential principles.
• Develop dimensional data model using Oracle SQL Developer.
• Design and code Tax to Warehouse ETL processes using JAVA Eclipse.
• Create Cognos Framework Models for Tax Data Warehouse.
• Proof Of Concept BI Application using the core technology stack of Oracle 11G and Cognos 10.X. POC Success Criteria is to reduce major report run times from 16+ hours to 5 minutes.
• Hands on expertise in Oracle SQL/PL SQL, JAVA, JAVASCRIPT, Cognos 10 including Report Studio and Dynamic Cubes.
• Develop ETL Jobs for Oracle using JAVA.

Confidential

Senior Enterprise Data Architect

Responsibilities:

• Develop and implement strategies, policies and standards for data architecture in the enterprise.
• Create data architecture to meet strategic business goals.
• This was an architecture and system evaluation of data warehousing, business intelligence, and planning technologies.

Confidential

Senior Data Warehouse Architect

Responsibilities:

• Lead Netezza implementation of Sales Data Warehouse including SalesForce.com components.
• Lead Oracle to Netezza data warehouse design conversion.
• Data Architect for Nielsen Sales data warehouse.
• Responsible for architecture, physical design, implementation of a data solution utilizing Cognos BI (empathizing dynamic cube architecture) and TM1 in-memory OLAP, Netezza, and Hadoop.
• A through understand of applied Confidential concepts including defined metrics, conformed dimensions, and dimensional hierarchies.
• Provided master data management and governance strategies to address data quality / integration issues.
• Hands on building of Cognos and Linux Cloudera HOA 24 x 7.
• Use database design and database modeling concepts to ensure data accessibility and security.
• Linux scripting, Cognos JAVA SDK, PL/SQL and Agginity Workbench.

Confidential

VP Data and BI Architecture

Responsibilities:

• Design, develop and implement complex data/information solutions across multiple projects requiring collaborate with database, data warehouse and business intelligence platforms teams to develop solutions that will support long term business needs. Managed a team of over 30 architects and developers on-shore, near-shore, and off-shore.
• Founder and leader of Chartis Finance Business Intelligence Center of Excellence (BICOE) responsible for architecture, standards, and governance.
• Lead and delivered BI Current State Assessment resulting in enterprise Cognos agreement with $7,000,000 in savings over 3 years.
• Lead architect to implement enterprise BI as a private cloud using C10 on System Z and Blue Insight program.
• Build ad hoc Cognos SPSS (based on R) statistical models for complex financial resolution.
• Team lead and senior architect to migrate 13,000 users from Impromptu 7.X, IWR, Power Play 7X, PPES, and Cognos 8.X to Cognos 10.1.
• Implemented SAP BW to HANA conversion with Business Objects reporting.

Confidential

Business Intelligence Consultant

Responsibilities:

• Develop both a current and future state architecture recommendation for the state executive committee for technology.
• Developed Cognos 8 Framework model to replace legacy SAS and Mark IV reporting.
• Install and configure Cognos 8.3 for development and test environments.
• SME for SAS to Cognos conversion.

Confidential

Data Warehouse Team Lead

Responsibilities:

• Lead Data Warehouse Architect and Cognos technical lead for Confidential 's DBG.
• Developed, tested and version controlled physical database changes ( Confidential ).
• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
• Enforced naming standards and data dictionary for data models.
• Developed data migration and data validation PL/SQL scripts.
• Performed SQL Query performance analysis using Toad Client software for Oracle / DB2 / SQL Server.
• Created and reviewed all Cognos Framework metadata models.
• Design and implement data warehouse solutions using Confidential principles.