We provide IT Staff Augmentation Services!

Senior Data Architect Resume

4.00/5 (Submit Your Rating)

Nashville, TN

SUMMARY:

  • More than 15 years Information/Data Architecture, Data Modeling (Conceptual, Logical, Dimensional (Star/Snowflake), Physical) using Industry’s leading data modeling software - ERWIN, Power Designer & IBM Infosphere Data Architect (IDA), Data Analysis, Source to Target Data Mapping, ETL Design, Enterprise Data Management (DQ & Data Governance), Data Architecture Development/Design (ODS, EDW, DM, OLAP), SOA, Master Data Management (MDM), Big Data Strategy, Implementation and Maintenance of Complex Software Systems to improve Enterprise Operational Efficiency. Over 14 years experience with both Data Warehousing and high availability business Systems in major multinational corporations, out of which 7 years in leadership and technical project management role.
  • Expert Enterprise Data Modeler with a deep understanding of developing transactional (OLTP) enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using both Kimball and Inmon data warehouse methodologies
  • Expert knowledge & Architecture CoE experience with Industry best practice data models such as ADRM (Healthcare Insurance, P&C Insurance, Healthcare Provider, Government, Financial Services, Communications, Manufacturing, Utilities, Retail), IBM Banking Data Warehouse (BDW), IBM HPDM (Healthcare), for Enterprise Data Warehouse, Master Data Management, Information Architecture, Operational Data Store, Data Marts, SOA, Metadata & Mapping, Data Governance, ETL, & Corporate Glossary
  • Expertize in designing the conceptual big picture of all business entities for the Enterprise Data Warehouse, and designing the detailed data architecture for each business requirements within each Business Focus area(subject area) such as Profitability, Risk Management, Customer Relation Management, Asset & Liability, Regulatory Compliance for various Industry (primarily Healthcare, Financial Services, Banking, Communications), both as a Lead Data Architect and as a Data Architect team member
  • Expertize in Enterprise Canonical Modeling (ECM) Framework of messaging for ISO 20022 / SWIFT MX compliance
  • Expertize in designing various data models - normalized, denormalized, star schema, snow-flake schema, dimensions/facts
  • Expertize in architecting and guiding IT and business organization for the Enterprise Data Warehouse, Master Data Management (MDM Golden Records/Keys Delivery), Data Mart & BI systems, and implementing the Enterprise Data Governance
  • Expertize in designing and implementing Big Data Strategy using Technologies such as Hadoop (HDFC, Map Reduce) and NoSQL ( tools - Cassandra, Riak, Redis, HBase, Oracle, membase, mongoDB, SOLR, IBM BigInsights, Big Data Analytics with IBM Daeja (now IBM Watson Foundation)) for 5 years
  • Experience designing ETL(Informatica & IBM Infosphere Information Server DataStage) and system integration architectures combining data from disparate source systems, packaged applications and disparate data formats
  • Expertize in designing Enterprise Data Standards & Standard Words/Business Term Abbreviations for the Enterprise Data Governance
  • Experience in designing Data Lineage & Mapping using IBM Infosphere Metadata Workbench, IBM Business Glossary, Infosphere FastTrack, Information Analyzer & Asset Manager
  • Expertize in designing/managing the Staging, ODS, DW, DM, BI for various industry segment’s data, primarily - Healthcare, Financial Services, Banking, Retail, Telecommunications,
  • Expert SQL skills and Physical Data Modeling techniques with multiple databases/network appliances - Teradata, Oracle, Netezza, DB2, UDB & SQL Server, various structured/unstructerd data - VSAM, etc
  • Experience of designing VLDB (very large DW), integrating large number of tables & databases and flat files, in several subject areas, merging several major line of businesses for various industry clients.
  • Expertize in use of naming standards, domain, and managing the data model for the enterprise using Industry’s leading tools like Erwin, IBM Infosphere Data Architect (IDA) & SAP Power Designer
  • Experience with both SDLC methodologies and Agile methodologies
  • Pioneered Enterprise Master Data Management(MDM) implementation for IBM - Customer Data Integration (CI Golden Keys) of the 300 plus systems, in multiple line of businesses, spanned across 3 geographies of IBM Corporation.
  • Expertize in designing Data Quality (DQ) Framework using tools like IBM Infosphere Information Server QualityStage, monitoring DQ, implementing automated DQ Score cards for each business rule, designing implementing data health checks, designing and development of web based DQ dashboard, and coordinating DQ efforts & resolution for the Enterprise Data Governance
  • Expertize in aligning people, process, technology tools for Enterprise wide Data Quality & Governance
  • Expertize in designing the metadata strategy for the enterprise, ensuring the compliance to the established IT standards and developing metadata database of all data assets for the Enterprise
  • Expert liason between the business stake holders and technical team.
  • Recognized project management expertise including leading JAD sessions, facilitation, problem resolution, planning, scheduling, and of end-item objectives.
  • Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions.
  • Excellent written & oral communication, coordination, organizational, follow-through and Problem Solving skills
  • Broad understanding of Data Administration concepts, principles and industry “Best Practices”
  • Healthcare (HealthSpring, Confidential, Covidien), Telecom (AT&T), Financial (TD Ameritrade), Banking(Fifth Third, Credit Suisse), Manufacturing (IBM/Sony), Insurance (AIG), & Retail (Qualex/Target) Industry experience

TECHNICAL SKILLS:

  • MDM(Master Data Management) (8 years) - IBM MDM Server (6 years), Informatica MDM (5 years )
  • Big Data (5 years)- Cassandra, Riak, Redis, HBase, Oracle, membase, mongoDB, Big Data Analytics with IBM Daeja
  • Data Modeling/ERD (14 years) - ERWin 8 (8 years), Power Designer (8 years), IBM Infosphere Data Architect 8.x (8 years), Embarcadero ER/Studio (4 years)
  • Enyterprise Canonical Modeling (ECM) - 4 years
  • Data Warehousing/ETL/CDC/Realtime: IBM Infosphere Information Server DataStage (10 years), Informatica 9.0.1 (8 years),Oracle Golden Gate (3 years), MSBI/SSIS (6 years), ETI*Extract (3 years), Genio (3 years)
  • DB - Teradata (10 years), Oracle 11g (10 years) with RAC Architecture, Netezza (5 years), DB2/UDB 9.5 (8 years), SQL Server (8 years), IMS (6 years), Sybase, FoxPro, SAS (4 years)
  • Data Analysis/Data Profiling/Data Mapping (14 years) - Infosphere FastTrack (5 years), IBM Infosphere Info Analyzer, Informatica Data Analyzer/Explorer (8 years)
  • SQL (18 years - various DBs), Stored Procedures (10 years - PL/SQL, TSQL)
  • NO SQL - MongoDB (2 years)
  • Essbase (6 years), Cognos & SPSS ( 6 years), SSRS (4 yrs)
  • SOA ( 8 years) - Web services, SOAP, WSDL, XML
  • Cloud Computing, SaaS (4 years)
  • IBM Business Glossary (3 years)
  • Java/JSP (3 years), Visual Basic .Net (6 years),J2EE(3 years)
  • Techincal leadership(10 years), Project Management (MS Project (7 years)),
  • Architecture - Visio (10 years)
  • Industry Models - ADRM(7 years), IBM Banking DW (7 years), IBM Health Plan Data Model (HPDM) (6 years),IIA (4 years)
  • IBM p Series, IBM z Series, PC, IBM/Lenevo ThinkPad, HP
  • MS WINDOWS, Linux, AIX, zOS, OS/2, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Senior Data Architect

Responsibilities:

  • Architected the data for the purpose of the transactional, MDM and BI Systems that support the Enterprise Data Warehouse, and all related work associated with that Enterprise Data Warehouse structure.
  • Reviewed and participated in discussion on Business Data Requirements. Translated Business Data Requirements to Business Focus Area (Subject Area) & main Business Entities
  • Presented the conceptual big picture of Business Entities, Subject Areas to business and IT Executives, Managers & Project Management
  • Researched & Incorporated Industry best practice by adopting ADRM Health Insurance Industry model
  • Lead Data Architecture brainstorming sessions, based on the ADRM model, adopted Industry best practice entities into the Conceptual Big Picture
  • Designed the Conceptual Data Model by customizing the ADRM model, and including the Conceptual Big picture elements
  • Reviewed and Presented the Conceptual Data Model to business and IT Executives, Managers & Project Management for the final approval, obtained approval for next steps.
  • Conducted discussion within Data Architecture team to identify the grouping of Conceptual Data Model entities to each Subject Area - Risk Management, Member Management, Provider/Vendor Management, Claims, Revenue, Profitability, etc.
  • Assigned each Subject Area to Data Architecture team members and to self, and reviewed/mentored progress of each Subject Area on a regular basis, updated the Data Architecture status to Project Management
  • Ensured the Data Architecture work done by team members, follow existing Data Model Practice Standards & guidelines and DW Model Architectural Principles
  • Designed development of Logical Data Model for each subject area working with Data Architecture team members and for the self assigned subject area
  • Maintained the integrated the normalized Enterprise Logical Data Model
  • Ensured Enterprise Logical Data Model Attribute/Entity definitions accurately represents business, and validated the documentation with business users by generating various model reports for the same, supported end users and IT with Data Dictionary
  • Identified Master Data Management domains for generating golden keys in support of Enterprise Data Model
  • Analyzed CMS Medicare & Medicaid Source data for determining the Member domain matching patterns, worked with Data Stewards for approving the match rules for generation of Member Golden Keys
  • Designed the denormalized schema with Fact/Dimensions (Snowflake Schema) for the Data Mart
  • Identified the sources (CMS, MHC, QNXT, BEQR), and managed/created the staging data model to bring the source data for ETL
  • Took responsibility and accountability for Data Architecture deliverables to ensure project goals are met.
  • Collaborated with Lead Enterprise Architect in developing the overall Data Warehouse Architecture
  • Designed the normalized Operational Data Store for fixing/analyzing the operational data
  • Designed the Physical Data Model for Staging, Enterprise Data Warehouse, ODS, DM, and lead the design of Source to Target mapping to load data from various Sources to the Data Warehouse.
  • Worked with business Executives, business analysts, Application Architects, Enterprise Architect, DBAs,and project team members to plan, design, and to help develop, implement, and enhance applications, DDL scripts and metadata for databases
  • Provided full-life cycle architectural guidance and ensured quality technical deliverables
  • Served as a data technical strategy subject matter expert and lead the creation of technical requirements and design deliverables
  • Designed Data Naming Standards for the enterprise, and implemented Class words, Prime Words and Business Terms in an Enterprise Glossary (Naming) Model, which enforced the Enterprise Data Standards
  • Established Data Lineage by implementing IBM Asset Manager which captured metadata from all metadata sources including ETL
  • Structured Query Language support to end user presentation layer needs
  • Communicated with business managers to confirm logical model based on data requirements
  • Provided timely Data Architecture estimates, Lead timely resolution of data architectural issues
  • Acted as point of contact for tools and standards, mentored junior Data Architects to ensure common understanding of architectural policies, procedures and standards.

Confidential, Hartford, CT

Senior Data Architect/Modeler

Responsibilities:

  • Reviewed current enterprise operational data structures and recommend optimizations and reconfigurations, documented gaps/changes
  • Reviewed and participated in discussion on High Level Business Needs (HLBN) & Analytics raw requirements
  • Translated Expanded Business Needs (EBN) to logical data requirements
  • Designed and maintained Enterprise Data Standards - Enterprise Business Words & Class Words Dictionary pursuant to data structures and enterprise models
  • Worked with business clients, business analysts, Application Architects, Enterprise Architect, DBAs,and project team members to plan, design, and to help develop, implement, and enhance applications, DDL scripts and metadata for DB2, Oracle relational databases and Teradata databases
  • Worked with DBAs to migrate complex large scale databases into development, system Integrated Test and production environments
  • Recommended and evaluated Master Data Management tools and methodologies
  • Designed the Enterprise MDM Strategy and matching rules for integrating various data domains
  • Provided full-life cycle architectural guidance and ensured quality technical deliverables
  • Served as a data technical strategy subject matter expert and lead the creation of technical requirements and design deliverables
  • Lead team on Enterprise Canonical Modeling (ECM) Framework and development of messaging, and industry compliance
  • Designed schemas for all business applications
  • Followed Confidential Project Life Cycle (APLC) - Confidential ‘s own SDLC process
  • Communicated with mid-level business managers to confirm logical model based on data requirements
  • Developed conceptual, logical (ERD), dimensional and initial physical models using Infosphere Data Architect
  • Worked with DBAs to complete a fully attributed physical model and to create the physical database in DB2, Oracle 10g & Teradata
  • Reverse Engineered Source data schemas into model
  • Generated LDM and Model reports - Entity definition, Attribute definition and Model Listing
  • Documented Primary Keys, Foreign Keys, Indexes and constraints
  • Acted as an Subject Matter expert of Data Management and rationalization of data
  • Designed the metadata including standards, naming convention aligining with IT Standards and Data Quality (DQ) strategy for the enterprise
  • Developed ERD of enterprise Metadata consolidating all enterprise data assets to implement the metadata repository database ( MRD)
  • Responsible person for metadata management and support
  • Developed Scorecards for tracking, monitoring Data Quality (DQ)
  • As a Metadata Architect in developed the overall data management/metadata/repository strategy for Enterprise
  • Participated in project specific architectural working groups
  • Mentored Business Analysts for designing the mapping specifications, Developers and QA Analysts in understanding data models and worked closely to understand the data needs of development team
  • Facilitated model review sessions
  • Provided input to existing Data Integration Modeling standards and guidelines
  • Reviewed standards with Enterprise Architects and Solutions Architects
  • Updated the logical Enterprise Information Model with entity and attribute definitions
  • Provided knowledge transfer to other data integration modelers and architects (internal or external)
  • Lead the timely resolution of data architectural issues and problems
  • Acted as SME of data integration modeling technical framework
  • Conducted WPI and WPR of the model deliverables
  • Signed-off on Data Integration Model peer reviewed documents after WPI
  • Provided Data Integration Modeling estimates and refined as necessary throughout the system development life cycle (APLC), Attended project meetings
  • Provided project architectural status and project plan to stake holders and management, and responsible for project management of DQ
  • Delevered Information Architecture Document (IAD) for various projects
  • Provided on-call support as needed for model related questions and issues
  • Participated in project risk assessments and issue management meetings
  • Handled escalated data team issues, Mentoring and developing of junior staff

Confidential

Senior Data Architect

Responsibilities:

  • Reviewed the architecture, and presented the current state of Architecture, and assessment to top business Executives
  • Participated in discussion on Business Data Requirements
  • Lead team in translated Business Data Requirements to Business Focus Area (Subject Area) & main Business Entities
  • Lead team in architecting the data for the purpose of the transactional, MDM and BI Systems that support the Enterprise Data Governance, and all related work associated with that Enterprise Data Warehouse structure.
  • Influenced the top Business and IT Executives, and formed Enterprise Data Governance Steering Committee
  • Lead Enterprise Canonical Modeling (ECM) Framework of messaging for ISO 20022 / SWIFT MX compliance
  • Chaired the regular Enterprise Data Governance Steering Committee meetings, lead of discussion the business unit high level data requirements, Issues, IT problem tickets, helped business units to come to agreement/consensus on data issues, helped IT to resolve issues surrounding the data
  • Presented the conceptual big picture of Business Entities, Subject Areas to business and IT Executives, Managers & Project Management
  • Researched & Incorporated Industry best practice by adopting IBM Banking Data Warehouse (BDW) Industry model
  • Responsible for designing MongoDB implementation
  • Lead Data Architecture brainstorming sessions, based on the BDW model, adopted Industry best practice entities into the Conceptual Big Picture
  • Lead design of the Conceptual Data Model by customizing the BDW model, and including the Conceptual Big picture elements
  • Reviewed and Presented the Conceptual Data Model to business and IT Executives, Senior Business Managers & Project Management for the final approval, obtained approval for next steps.
  • Conducted discussion within Data Architecture team to identify the grouping of Conceptual Data Model entities to each Subject Area – Risk Management, Revenue, Profitability, etc.
  • Assigned each Subject Area to Data Architecture team members and to self, and reviewed/mentored progress of each Subject Area on a regular basis, updated the Data Architecture status to Project Management
  • Architected Data Model Practice Standards & guidelines and DW Model Architectural Principles
  • Ensured the Data Architecture work done by team members, follow existing Data Model Practice Standards & guidelines and DW Model Architectural Principles
  • Designed development of Logical Data Model for each subject area working with Data Architecture team members and for the self assigned subject area
  • Maintained the integrated the normalized Enterprise Logical Data Model
  • Ensured Enterprise Logical Data Model Attribute/Entity definitions accurately represents business, and validated the documentation with business users by generating various model reports for the same, supported end users and IT with Data Dictionary
  • Identified Master Data Management domains for generating golden keys in support of Enterprise Data Model
  • Lead Analysis of various Commercial Credit Source data and Probability Default Rating Models for determining the Legal Entity, Collateral & PD Model domain matching patterns, worked with Data Stewards for approving the match rules for generation of MDM Golden Keys
  • Provided full-life cycle architectural guidance and ensured quality technical deliverables
  • Served as a data strategy subject matter expert and lead the creation of technical requirements and design deliverables
  • Enforced the Enterprise Data Standards
  • Provided timely Data Architecture estimates, Lead timely resolution of data architectural issues
  • Acted as point of contact for tools and standards, mentored junior Data Architects to ensure common understanding of architectural policies, procedures and standards.

Confidential

Senior Data Architect/Modeler

Responsibilities:

  • Reviewed current enterprise operational data structures and recommend optimizations and reconfigurations, documented gaps/changes, Reviewed Business & Analytics raw requirements
  • Translated Business requirements to logical data requirements
  • Designed and maintained Enterprise Data Standards pursuant to data structures and enterprise models
  • Worked with business clients, business analysts, technical staff, Enterprise Architect, and project team members to plan, design, develop, implement, and enhance applications, DDL scripts and metadata for Oracle relational databases and Teradata databases
  • Worked with DBAs to migrate complex large scale applications into system Integrated Test and production environments
  • Worked closely with 3rd party vendors such as Sales Force.com (SFDC), Peoplesoft, Wall Street on Demand (WSOD) to integrate the respective data structures into EDW Datawarehouse
  • Recommended and evaluated Master Data Management tools and methodologies – Siperian, Informatica 9.1
  • Designed the Enterprise MDM Strategy and matching rules for integrating TOS Accounts
  • Provided full-life cycle architectural guidance and ensured quality technical deliverables
  • Served as a data technical strategy subject matter expert and lead the creation of technical requirements and design deliverables
  • Communicated with the business regarding data issues, data relationships, and data sources
  • Communicated with mid-level business managers to confirm logical model based on data requirements
  • Developed conceptual, logical (ERD), dimensional and initial physical models using Power Designer & ERWIN
  • Worked with DBAs to complete a fully attributed physical model and Created the physical database in Oracle 10g & Teradata
  • Analyzed source Data from Oracle databases and flatfiles, Reverse Engineered schemas into model
  • Researched various databases and Conducted Source Data Analysis And Profiling using Informatica Data Explorer
  • Implemented Teradata specific performance parameters in Physical Data Model, Generated source, physical and presentation layer DDLs
  • Designed 64 TB Teradata DW, integrating 800 plus tables in 60 plus disparate databases and flat files, in 16 subject areas, merging 6 major line of businesses for TD Ameritrade CDW.
  • Identified business transformation rules and data demographics by working with source system SMEs
  • Performed mapping between source and third normal form layer (physical data integration layer)
  • Performed 3NF to dimensional mapping
  • Acted as an Subject Matter expert of Data Management and rationalization of data
  • Designed the metadata including standards, naming convention aligining with TD IT Standards and Data Quality (DQ) strategy for the enterprise
  • For TD Bank – imported Banking Data Warehouse (BDW 8.2) Industry Model into IDA Modeling tool, defined scope, designed Conceptual Model based on 9 BDW areas, developed Logical Data Model based on BDW Analytical Requirement Model, transformed into Physical Data Model, generated Teradata DDLs for implementation
  • Responsible person for metadata management and support, Scorecards for tracking, monitoring Data Quality
  • As a Metadata Architect in developed the overall data management/metadata/repository strategy for Enterprise
  • Coordinated the activities of resolving DQ issues, Created SQL for views
  • Participated in project specific architectural working groups
  • Mentored Data Analysts, Developers and QA Analysts in understanding data models and worked closely to understand the data needs of development team, Facilitated model review sessions
  • Reviewed standards with Enterprise Architects and Solutions Architects
  • Updated the logical Enterprise Information Model with entity and attribute definitions
  • Provided knowledge transfer to other data integration modelers and architects (internal or external)
  • Lead the timely resolution of data architectural issues and problems
  • Acted as SME of data integration modeling technical framework
  • Signed-off on Data Integration Model peer reviewed documents
  • Designed ETL using DataStage, Oracle Golden Gate, Oracle TOAD, WinSQL & Teradata
  • Provided project status and project plan to stake holders and management, and responsible for project management of DQ
  • Provided on-call support as needed for model related questions and issues
  • Participated in project risk assessments and issue management meetings
  • Handled escalated data team issues, Mentoring and developing of junior staff

Confidential, Plano, TX

Senior Data Architect

Responsibilities:

  • Reviewed Business & Analytics raw requirements
  • Reviewed existing Enterprise model and documented gaps/changes
  • Translated Business requirements to logical data requirements
  • Communicated with the business regarding data issues, data relationships, and data sources
  • Communicated with mid-level business managers to confirm logical model based on data requirements
  • Analyzed source Data from Teradata, SQL Server, IMS, VSAM, FoxPro, & Oracle databases and flatfiles
  • Designed 200 plus TB Teradata DW, integrating 2500 plus tables in 100 plus disparate databases and flat files, in 13 subject areas, merging 5 major line of businesses for AT&T eCDW
  • Reverse Engineered Source data schemas into model
  • Researched various databases and Conducted Source Data Analysis And Profiling using Informatica Data Explorer
  • Developed conceptual, logical (ERD), dimensional and initial physical models using ERWIN
  • Worked with DBAs to complete a fully attributed physical model and Created the physical database in Oracle 10g
  • Analyzed data through screens, report mockups, and source extracts
  • Generated source, physical and presentation layer DDLs
  • Identified business transformation rules by working with source system SMEs
  • Performed mapping between source and third normal form layer (physical data integration layer)
  • Performed logical to physical mapping
  • Documented Primary Keys, Foreign Keys, Indexes and constraints
  • Acted as an Subject Matter expert of Data Management and rationalization of data
  • Designed the metadata including standards, naming convention aligining with AT&T IT Standards and Data Quality (DQ) strategy for the enterprise
  • Developed ERD of enterprise Metadata consolidating all enterprise data assets to implement the metadata repository database ( MRD)
  • Responsible person for metadata management and support
  • Developed Scorecards for tracking, monitoring Data Quality (DQ)
  • As a Metadata Architect in developed the overall data management/metadata/repository strategy for Enterprise
  • Designed Web based Enterprise DQ Dashboard Portal delivering all aspects of data – Metadata, problem tickets tracking, Audit metrics & scorecards, tower owner to data relationships, all data documents, Load metrics, automation of notification of exception and health checks, Other audit information, etc to stakeholders
  • Coordinated the activities of resolving DQ issues
  • Captured business rules for logical to physical mapping in metadata
  • Performed mapping from third normal form to dimensional (presentation layer)
  • Documented specifications for views
  • Created SQL for views
  • Reviewed standards with Enterprise Architects and Solutions Architects
  • Updated the logical Enterprise Information Model with entity and attribute definitions
  • Provided knowledge transfer to other data integration modelers and architects (internal or external)
  • Lead the timely resolution of data architectural issues and problems
  • Acted as SME of data integration technical framework
  • Signed-off on Data Integration reviewed documents
  • Provided Data Integration estimates and refined as necessary throughout the system development life cycle
  • Attended project meetings
  • Designed ETL using DataStage, Informatica, Oracle Golden Gate, Oracle TOAD & Teradata
  • Provided project status and project plan to stake holders and management, and responsible for project management of DQ
  • Provided on-call support as needed for model related questions and issues
  • Participated in project risk assessments and issue management meetings
  • Mentoring and developing of junior staff

Confidential

Senior Data Architect

Responsibilities:

  • Requirement analysis and prepared detailed functional specification as PRD (Product Requirement Document) which consists of Report Mockups, Business Hierarchies, Business facts & Dimensions
  • Designed Logical Data Model, Dimensional Model and Physical Data Model and generated DDL
  • Implemented Teradata (UPI, NUPI, USI, NUSI, Partitition by RANGE N, CASE N, Join Index, etc) & Netezza (Distribution Key) in physical models
  • Pioneered/Implemented Industry Enterprise Data Models like BDW for banking sector, FSDM for Financial Services sector, ADRM for various Industry sectors (Healthcare, Telecom, Retail, etc)
  • Interviewed business and understood/documented data demography of access, use, cardinality, criteria, range, etc.
  • Created source to target mapping document mapping the source data elements to target tables fields based on business transformation rules designed earlier.
  • Designed Enterprise Data Standards and Data Model Design guidelines, and enforced the same
  • Designed Data Model Development strategy – from abstract data analysis, identifying entities, attributes & data types, identifying subject areas, identifying keys, analyzing cardinality, identifying data hierarchies to logical data model & dimenisional data model, transformation into physical data model. Brainstormed on various design issues and educated team
  • Conducted Source Data Analysis using Informatica Data Explorer
  • Worked with DBAs and Created the physical database in ORACLE 11g, Netezza, UDB, SQL Server & Teradata
  • Architected & Lead/Implemented Master Data Management Golden Keys for identified domains
  • Developed business transformation rules by working with source system SMEs
  • Documented the data cleansing rules, Developed and maintained traceability matrix
  • Designed the feed from various Source Systems to ODS
  • Documented and maintained the metadata
  • Well versed with Teradata technology (PE, AMP, ByNet) and utilities (FastLoad, MultiLoad, FasExport, BTEQ)
  • Explained the Source to Target Mapping to Informatica development team
  • Explained the data model to Report attributes mapping to the BO Reporting team
  • Designed and Implemented Realtime Change Data Capture using DataMirror Transformation Server & Oracle Streams.
  • Experience with Oracle RAC architecture, PL/SQL, Sun Solaris, analyzing existing ETL and Shell Scripting.
  • Informatica ETL Experience
  • Experience in Oracle Designer, Oracle Developer, Oracle Enterprise Management Tools
  • Facilitated enterprise-wide understanding of heterogeneous data assets
  • Designed the conceptual, logical, physical data model of Enterprise Data Warehouse/Datamart environments
  • Data sizing, and volumetrics
  • Teradata Experience
  • Analyzed existing database schema DDL/instance layout and determine impacts migrating to new target schema/instance environment.
  • Interacted with external DBAs and helped develop approach
  • Collaborated the data model, data architecture & analysis activities, lead team to create an integrated business model spanning multiple lines of businesses and subject areas within the operational data store and datawarehouse
  • Conducted checkpoint review meetings with client leadership team, and all resources in development and data architecture.
  • Expertize in relational database design, data warehousing and database administration
  • Provided guidance to offshore developers and lead design activities.
  • Experience in C, C++, VB, Unix Shell Scripts
  • Experience in configuration management and version control
  • Experience in database performance tuning
  • Managed the data team project plan by working with Senior Project Manager
  • Design, build, and maintain the logical & physical data models for the enterprise
  • Leveraged IBM Banking Data Warehouse (IBM BDW) model to understand the financial client requirements and to create initial Architecture Framework needed to re-engineer and update outmoded Financial Information systems, with Service Oriented Architecture (SOA)
  • Leveraged IBM Health Plan Data Model (IBM HPDM) model to understand the health care client requirements and to create initial Architecture Framework needed to re-engineer and update outmoded Healthcare Information systems, with Service Oriented Architecture (SOA)
  • Demonstrated data modeling expertise using ERWIN & Infosphere Data Architect (IDA) tool
  • Mantained Enterprise blueprint of complex data model
  • Participated & lead team in proposal development and client presentations
  • Lead the team in creating new data model with over hundreds of tables in multiple subject areas & process interaction diagrams and maintained the existing models/diagrams for the enterprise organization, using ERWIN & Infosphere Data Architect (IDA) tool.
  • Implemented Data Standards considering Data Quality, Data Redundancy, Data Privacy, & Data Management
  • Lead Development of Enterprise Master Data Management, Data Integration & Metadata strategies.
  • Lead junior staff in Data Cleansing, Data Transformation, Data Archiving processes, and Enterprise Data Integration, Data Stewardship stategies
  • Provided timely feedback to proposed solution based on the established data standards
  • Conducted Design of Analytical reports
  • Analysis & Design of Datawarehouse from OLTP systems to accommodate the Business Requirement
  • Knowledge of Oracle database server, SQL, PL/SQL, XML, SQL Server, UNIX, shell scripting
  • Lead team in DW Best Practices and Data Governance discipline
  • Evaluated, procured, installed, and optimized the DW tools
  • Mentoring and developing of junior staff

We'd love your feedback!