We provide IT Staff Augmentation Services!

Senior Data Architect Resume

SUMMARY

  • I have been a Data Warehouse Practice Lead and Manager, Governance Practice Lead at Enterprise Level for more than a decade with a special emphasis on EDM, Stewardship, Data Warehouse Practice, Data Archiving, Data Architecture, Data Modeling and Data Governance serving Health Care, Insurance, Finance, Banks,
  • I have extensive experience using Erwin, Power Designer, ER Studio for Data Architecture and Data Modeling (Logical, Physical and Conceptual), Data integration with COTS products, Collibra for Data Governance, COGNOS, BOXI, Micro Strategy, Tableau for BI Reporting and Presentation Layer connecting Oracle, DB2, SQL Server and TERADATA databases.
  • I have many years of experience using Hadoop ecosystem components like Hadoop Map Reduce, Cloudera, Hortonworks, HBase, Oozie, Hive, Sqoop, Pig, Flume, and Cassandra.
  • I have many years of experience working with business SMEs, Stake holders, techno - functional management team for gathering requirements, articulating facts, developing used cases and facilitating JAD sessions .
  • I am expert in implementing projects in agile work environment
  • I have many years of experience preaching methodologies such as Zachman, TOGAF, Ralph and Bill Inmon.
  • I have managed projects over 100M$ and managed large number of direct reports.
  • I have been responsible for developing road-maps, managing projects and budget, for implementing projects that require data and information architecture, data warehouse governance practice, modeling and metadata management

TECHNICAL SKILLS

  • ERWIN 9, Power Designer, ER Studio, TOAD, SQL, COGNOS, Micro Strategy, WebI, SAS, Collibra 5.7, Cassandra, Impala, Hbase, Kafka, Spark, Python, Map Reduce, O racle 11g, Sybase, SQL Server 2012 and DB2, MS Office, MS Project and Visio
  • Ralph Kimball, Bill Inmon, Zachman Framework, Agile, Waterfall, DAMA, ITIL and TOGAF

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Architect

Responsibilities:

  • Responsible for working with business users to gather requirements, articulate facts and provide a conceptual view, data and process flow diagrams
  • Responsible for data warehouse design, develop and manage data models enterprise wide
  • Responsible for evaluating, documenting and enforcing best practices
  • Responsible for addressing and resolving issues with stake holders
  • Responsible for project delivery, resource and project management, status update to stake holders, forecasting and developing roadmaps.
  • Responsible for working with business users to gather requirements, articulate facts and provide a conceptual view, data and process flow diagrams
  • Responsible for conducting brain storming sessions with business users for data mining, data profiling and data catalogs
  • Responsible for data warehouse design, develop and manage data models for data marts
  • Responsible for evaluating, documenting and enforcing best practices supporting Data governance practice
  • Responsible for developing user guide, training and educating business users
  • Responsible to lead design and development of data warehouse to support the reporting needs for the proposed integration of SESIS product
  • Responsible for Infrastructure assessment and addressing the performance issues
  • Responsible for Collibra set-up using Collibra Connect for Data Governance
  • Responsible for configuring Manta to analyze transformation logic one by one and store the metadata in Manta’s repository
  • Responsible for reviewing data mappings and physical data lineage
  • Responsible for managing releases, production support issues and SLAs

Technology: Oracle, SQL Server Data Warehouse, SQL, ERWin, JIRA, Visio

Confidential

Senior Data Architect

Responsibilities:

  • Responsible for working with business users to gather requirements, articulate facts and provide a conceptual view, data and process flow diagrams
  • Responsible for evaluating current architecture and proposing a better approach and product suite
  • Responsible for conducting brain storming sessions with business users for data mining, data profiling and data catalogs
  • Responsible for data warehouse design, develop and manage data models enterprise wide
  • Responsible for evaluating, documenting and enforcing best practices supporting MDM and Data governance practice
  • Responsible for addressing and resolving issues with stake holders
  • Responsible for data mapping, generating DDL scripts and performance improvement
  • Responsible for Collibra set-up using Collibra Connect for Data Governance
  • Responsible for configuring Manta to analyze transformation logic one by one and store the metadata in Manta’s repository
  • Responsible for translating the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
  • Responsible for creation and maintenance of Conceptual, Logical and Physical Data Model’s to include documentation of all entities, attributes, data relationships, referential integrity, domains, codes, business rules and glossary terms
  • Responsible for Data Stewardship, Data Governance, Data Architecture and Data Modeling
  • Responsible for creation and enforcing the execution of SLAs
  • Responsible for extensive research on clinical collection of data and validation
  • Responsible for evaluation of best practices such as HIPAA compliance and Clinical safety

Technology: Oracle, SQL Server, Cassandra, Impala, Informatica, ERWin, Collibra, Azure, AWS, Snowflake, PHR, PMR & Tableau

Confidential

Project Lead

Responsibilities:

  • Responsible for project delivery, resource and project management, status update to stake holders, forecasting and developing roadmaps.
  • Responsible for working with business users to gather requirements, articulate facts and provide a conceptual view, data and process flow diagrams
  • Responsible for evaluating current architecture and proposing a better approach and product suite
  • Responsible for conducting brain storming sessions with business users for data mining, data profiling and data catalogs
  • Responsible for data warehouse design, develop and manage data models enterprise wide
  • Responsible for evaluating, documenting and enforcing best practices supporting Data governance practice
  • Responsible for developing user guide, training and educating business users

Technology: Oracle, Zachman Framework, Golden Gate, ER-Studio and MS project

Hire Now