We provide IT Staff Augmentation Services!

Data Architect/etl Architect Resume

Washington, DC

SUMMARY:

  • Accomplished and high performing Data Warehouse, Data Integration, Data Quality, Data profiling, Master data management and BI Solutions architect with 16+ years of experience in implementation of Analytics, Advanced Analytics, Big data, Business Intelligence, Data warehousing and Data Mart projects across all industry verticals.
  • Experienced in implementing and executing data profiling and data quality projects.
  • Experienced in providing data governance, data vision and strategy pertaining to Data Profiling, and Data Quality Testing and Measurement capabilities.
  • Experience in Monitoring, identifying and analyzing data quality and data integrity issues.
  • Established best practices, standards, policies and procedures to utilize data profiling and data quality tools to proactively identify data quality issues.
  • Performed data profiling to identify quality gaps in applicable dimensions based on intended use Cleanse and transform data to publish data to dashboards.
  • Experience in leading huge data warehouse, data integration, ETL, ELT and BI resource teams as a delivery Manager and Data warehouse/BI lead.
  • Skilled in developing and managing Data warehouse, ETL, BI and associated cross - departmental teams resulting in efficient design, development and implementation of analytical and operational reporting projects.
  • Experienced in performing iterative reviews with customers Lead complex projects to integrate new data sources in collaboration with data owner, data analysis and business owners
  • Provided guidance and assistance to technologists to help develop requirements, Data Quality rules and scorecards.
  • Provide guidance to Data Stewards and Data Analysts to utilize Data Quality tools in in the adoption of data quality standards, policies and procedures
  • Work with DQ Issues groups and LOB stakeholders to define best practices for DQ Profiling and Measurement.
  • High quality focus on ensuring Data Profiling, Testing and Measurement standards are coherent, accurate and timely at all times
  • Strong partnership with CDO, LOB and Technology support groups to ensure a high quality product and operating environment.
  • Strong in Confidential Database administration, performance tuning & sizing of Confidential Databases.
  • Experience in building Data Integration and BI practice with consistent utilization & financial goals.
  • Managed & delivered multiple Data Integration, Data Quality, Master Data Management and BI projects globally with onsite/offshore blended model in leading global companies like Confidential & Confidential .
  • True leader and mentor who inspires confidence in employees.

EXPERTISE COVERS:

Database Design: Star/Snow Flake Schema Big Data/IOT Strategy & Roadmap Master Data Management Requirements Gathering /Gap Analysis, Delivery of DW & MDM / IDQ Projects ETL Design/Development

Database Design: Star/Snow Flake Schema Global Delivery-Onshore/Offsite model, Informatica Power center, MDM, IDQ Confidential Database Administration

Cost & Resource: Estimates OBIEE/OBIA implementations

BI: Pre-sales & Solution Roadmap Datawarehousing & Datamart

Erwin: 9.7 / Visio Confidential, Sql server, Teradata, Confidential, Sql server, Teradata

PROFESSIONAL EXPERIENCE:

Data Architect/ETL Architect

Confidential, Washington, DC

Responsibilities:

  • Conducted workshops/interviews with Confidential subject matter experts and created a conceptual, logical and physical model for IPAR application & IPAR reporting.
  • Analyzed client's applications, operations and programs. Reviewed the objectives of the new application and reporting data model.
  • Designed proposed system, defined database physical structure and functional capabilities of different subject areas i.e Core Application, Security Data Model, Communications data model & Outbound system data model.
  • Implemented database systems by developing flowcharts, applying optimum access techniques and developed scripts meeting WB naming standards and data governance standards.
  • Designed & implemented IPAR Data mart for Loan Loss Reserve module reporting.
  • Designed & implemented ETL data migration strategy for IPAR reporting and application.
  • Build High level and low level design documents for Confidential Enterprise Architecture Board review and approval.

Technologies: Erwin 9.x/10.x, Confidential Exadata, Visio, Data Flow Diagrams,Conceptual,Logical & Physical Models, Data Governance processes, Data Standards

Data Architect/ETL Architect

Confidential

Responsibilities:

  • Designed and customized HR Analytics data model to integrate Taleo metrics into existing OBIA out-of-the-box delivered data model.
  • Designed and customized HR Data model to integrate the Careerlink metrics into existing OBIA out-of-the-box data model.
  • Managed and delivered OBIA/TA Analytics by leading a team of onsite/offshore functional and technical consultants.
  • Designed Custom subject areas for Taleo and Careerlink Star schemas for custom reporting.
  • Authored design documents, Business process models, Data models and documented details of process flows and narratives as per the SOW.
  • Held JAD sessions & prepared functional/nonfunctional specifications as required.
  • Designed Use Cases, Activity Diagrams, Sequence Diagrams in MS Visio and Pencil free ware.
  • Delivered Talent Acquisition Dashboards - Open Requisitions, Closed Requisitions, Hired Pool and Veteran Demographics.

Confidential

BI & DW Delivery Lead/ Data Architect 

Responsibilities:

  • Managed Saks account by leading a team of BI functional & technical developers/analysts to develop a vision, strategy and roadmap for SAKS BI Retail Analytical System.
  • Conducted workshops/interviews with Saks subject matter experts for analytical and operational reporting requirements. Created a gap document by analyzing the Out of the box retail analytical system and Saks reporting requirements.
  • Delivered a strategy and road map to take SAKS BI from current state to future state architecture.
  • Conducted feasibility of Reports and Dashboards and provided technical and functional guidance to the SAKS technical team by developing mockups on the key reports.
  • Developed custom OBIEE reports for MFP module.
  • Created technical ETL mapping document for custom reporting requirements.
  • Developed custom subject areas and custom star schemas for custom reports by utilizing the conformed dimensions.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Managed Confidential project with team of onsite and offshore resources to implement HR analytics and Supply Chain & Order Management modules.
  • Successfully implemented OBIEE 11g BI Apps 7.9.6.3 - Supply Chain and Order Management & HR Analytics.
  • Configured Complex Security - SSO implementation between EBS and OBIA
  • Designed and developed multiple custom Reports in HR Analytics.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Installation and configuration of OBIEE11g on Linux/Windows 2008 environments.
  • Infrastructure and Strategy design for OBIEE11g for custom financial and payroll data mart.
  • Implemented single sign on(SSO) and SSL with Iplanet LDAP Server with Verisign SSL Certificates.
  • Designed storage and partitioning strategy for various Data warehouses and Data marts.
  • Designed and implemented OBIEE Caching Strategy for better performance.
  • Designed and created aggregate tables/materialized views and configured OBIEE repository to use the aggregate Tables for better performance.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Lead a team of Confidential DBA’s, ETL developers,OBIEE developers for implementing OBIEE with JD Edwards as source.
  • Installed Informatica 9.0.1, OBIEE 11g, DAC and BI Apps on Linux.
  • Configured JD Edwards Financials for Out of the Box Data Load.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Managed BI group and associated cross-departmental team of onsite and offshore and delivered a custom reporting modules for Confidential Aviation.
  • Provided vision and design of a robuts advance supply chain management business intelligence warehouse/system unique to Confidential Aviation requirements.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Provided the vision and design for a robust, flexible, scalable financial business intelligence warehouse/system unique to the banking industry.
  • Developed strategies to access, integrate and analyze data from ten different Peoplesoft Financial systems across the world.
  • Designed a ETL execution to execute the data loads based on the time zones on daily basis.
  • The goal is to provide a one-view of their financial reports globally with an option to select the country specific reports with local currencies to the C-level executives.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Implemented HR Analytics with custom extensions.
  • Involved in optimizing the datamart and created index organized tables for efficient query and application performance.
  • Responsible for guiding, creating and maintaining custom pl/sql packages, functions, procedures and cursors.
  • Involved in extraction, cleansing and integration of data from different data sources.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Implemented Financial Analytics with custom extensions at Patterson’s UTI.
  • Designed and configured security with SSO with EBS financials and Microsoft ADI.
  • Managed BI team in the design, development and implementation of Operational financial reports.
  • Converted key discoverer reports into OBIEE.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Designed and configured SSO between Hyperion Shared services and OBIEE.
  • Created OBIEE groups in Hyperion Shared services and configured the security files for users to single sign on from Hyperion Shared services.
  • Implemented Financial Analytics with custom extensions

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Analyzed performance issues of Confidential ’s LCMS systems and created a document with required actions to be taken.
  • Based on the review of the key reports having performance issues major action items has been recommended to improve the performance i.e Partition the Fact tables, Create aggregate tables, Create bit map indexes.
  • Increase the memory as server paging is noticed when users are executing the reports concurrently.

Confidential

Sr.Pricipal Consultant/Solution Architect

Responsibilities:

  • Defined the Confidential Analytics Extraction, Transformation, and Load (ETL) Strategy and Architecture.
  • Developed custom star schema extensions to support the management of protocol information.
  • Created subject areas for management of Site and Investigator contact information.

Confidential

Sr. DBA

Responsibilities:

  • Responsible for leading a Team of Confidential DBA's/Developers for supporting various Datamarts of 3TB in size.
  • Responsible in providing Daily Status and Schedules to Senior Management and Business Analysts & Technical Analysts.
  • Involved in creating a Process in Clear Case and Clear Quest for Database Code Maintenance and Migrating the Baselines in coordination with Release Management Team.
  • Designed, Developed and Deployed Star Schema for Securities Datamart.
  • Designed and Implemented the Capacity Planning and Storage Requirements of Securities Datamart in Confidential .
  • Designed Partitioning Strategy and Indexing Strategy of Securities Datamart.
  • Involved in Performance Tuning of Securities Datamart and day to day Trouble Shooting on Performance Related issues.

Hire Now