We provide IT Staff Augmentation Services!

Information Architect Resume

PROFESSIONAL SUMMARY:

  • Having 14 years of Technical experience in Information Architecture, Data Architecture, Data Modeling, Data Governance, ETL Design, Data Quality and BI - Analytics. worked with OLTP/ Data Warehouse Modeling and Played key role in multiple projects and act as knowledge expert (Technical, Functional).
  • Expertise on NoSQL data modeling using Hackolade tool for databases like MongoDB, HBASE, Hive and JSON Schema.
  • Having very good knowledge and PoC experience in Snowflake Data Wareshusing and AWS components.
  • Expertise on Relational Data Modeling using Erwin 9.x/7.x/4.x and Sybase Power Designer and MS Visio for both Normalized and Denormalized (Star Schema and Snowflake Schema) Data Models.
  • Expertise in analyzing source systems data, profiling data using SQL, Hive QL and NoSql.
  • Knowledge in hadoop technologies( HDFS, MapReduce, Hive, HBase etc...).
  • Experience in data model review, data governance and data rationalization.
  • Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution.
  • Experience with Data lake and loading the data to Data lake and data repository.
  • Expertise in Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, DataMart Design, Metadata, Data Quality, Master Data Management and Master Data/Data Governance.
  • Architected data warehouse from requirements gathering to conceptualization to creation of data marts using Inmon and Kimball methodologies. Build model for ODS.
  • Created Low level (LLD), High Level (HLD) design documents. Prepared Detail Design, Architecture, Use-Case documents. Having excellent project management and client interaction skills
  • Knowledge of Unified Modeling Language (UML). Work with Offshore/Onsite People.
  • Excellent documentation skills for Database Design Document, Technical design document.
  • Handled all oracle database development, PL/SQL, SQL programming, ETL, job automation, query tuning. And also Having Very good expose on Informatica 9.1 Client tools.
  • Has full project life cycle, SDLC and Agile experience and has Thorough knowledge of Ralph Kimball's Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Slowly Changing Dimensions (Type1, Type2, and Type3) and Surrogate keys.
  • Experience in working various domains like Banking, Insurance, TPA, Healthcare Retail and successfully completed the tasks from project deliverables perspective and given a key contribution in this related domain and related projects. I am well versed with industry standard quality procedures along with testing life cycle process that is part of any project.
  • Dealt with complex Data models. Done Reverse engineer/Forward engineering.
  • Collaborate with Solution & Enterprise Architects, Business analysts, and others to understand business or industry requirements
  • Engaged by several clients to understand and reengineer their business processes
  • Co-ordinate with business owners, DBAs, reporting team to address system improvements.

TECHNICAL SKILLS:

Technical Modelling Tools: ERWIN , ER Studio , Power Designer , Microsoft Visio and Hackolade ( NoSql).

Languages: SQL, PL/SQL, Hive QL and NoSql

Hadoop/Cloud: NoSQL, Map reduce, HBASE, HIVE, HDFS, Snowfkake DW, AWS

Database: Oracle 10g/11g/12c, SQL Server 2008/2012/2016 , Teradata 12.0/15.1, DB2

Other Tools: EA Sparx, Rally Project Management Tool, AQT, Studio 3T, Putty, Win SCP

Domain Areas: Insurance, Banking, Health Care and Retail

Operating System: Windows and Unix

PROFESSIONAL EXPERIENCE:

Confidential

Information Architect

Responsibilities:

  • As an Information Architect, assist with architectural strategic thinking, Information solutions and roadmaps to derive architectural recommendations.
  • Support maintenance of plans to address significant architecture gaps between current and target state.
  • Provide Information Architecture services to the Confidential project teams and participate in reuse, buy and build decisions. Participating in defining and driving architecture competencies, processes and best practices across Business Insurance. Analyzing and profiling existing legacy system data and sourcing data from legacy systems.
  • Developing Proof Of Concept (PoC) for the proposed solution.
  • Requirements gathering from business users for upcoming project requirements, analyzing the existing systems, preparing functional and technical specification documents and make offshore team to understand AS-IS Systems and TO-BE System during the requirement gathering phase of the project.
  • Work with LDM- Logical Data Modeling, PDM- Physical Data Modeling and Master Data/Data Governance.
  • Creation and maintenance of Data Dictionary for Data models (Conceptual, Logical Data Model -LDM, Physical Data Model-PDM), experience with Data Vault Modeling.
  • Work with HBASE and MongoDB. Design NOSQL Data Models for MongoDB using Hackolade modeling tool.
  • Designing the data Architecture, designing Conceptual, logical and Physical data models and maintaining the data Dictionary as for the Standards.
  • Responsible for identify metrics and develop high level Data Model and Document Attribute list.
  • Involved Creating Source to Target mapping and supporting development team to clarify all transformation logics
  • Involved in Data validation and Integration testing.
  • Responsible for maintaining and timely refresh(Update) for existing Confidential operational data models like TrvPass CDM, ODS and SCI models.
  • Provided architectural guidens to load transactional unstructured data into the data lake.

Environment: Snowflake Data Warehouse, SQL Server, Oracle 12c, Hadoop- NOSQL, Map Reduce, HBase, HIVE, UNIX, Putty, Rally, ERWIN 9.6, Hackolade, EA Sparx, AQT, Studio 3T and Ambari.

Confidential, illnois

Data Architecture, Data Modeling

Responsibilities:

  • Requirements gathering from business users, analyzing the existing systems, preparing functional and technical specification documents and make offshore team to understand AS-IS Systems and TO-BE System during the requirement gathering phase of the project.
  • Responsible for Review business requirements, identify Dimensions and Fact and Their granularity
  • Designing the data Architecture, designing Conceptual, logical and Physical data models and maintaining the data Dictionary as for the Standards.
  • Responsible for identify metrics and develop high level Data Model and Document Attribute list.
  • Responsible to identify the GAPs between Customer EDW components and iDecisions Components.
  • Responsible for Customize the iDecisions Data Model as per Customer Requirement
  • Involved Creating Source to Target mapping and supporting development team to clarify all transformation logics
  • Direct interactions with the IT and Business team for Requirement Gathering and providing the solutions to the given requirements.
  • Involved in Data validation and Integration testing

Environment: Sybase Power Designer, SQL server PDW, SSIS, iDecisions

Confidential

Data Architecture, Data Modeling

Responsibilities:

  • Responsible for Review business requirements, identify Dimensions and Fact and Their granularity
  • Responsible for identify metrics and develop high level Data Model and Document Attribute list.
  • Responsible to identify the GAPs between Customer EDW components and iDecisions Components.
  • Responsible for Customize the iDecisions Data Model as per Customer Requirement
  • Responsible for Designing Logical and Physical Data Models using SAP Sybase Power Designer.
  • Direct interactions with the IT and Business team for Requirement Gathering and providing the solutions to the given requirements.
  • Involved requirement Gathering, Analysis and preparing Functional Specification Document and System specification Document.
  • Involved in Data validation and Integration testing

Environment: SAP Sybase Power Designer, iDecisions

Confidential

Data Architecture, ETL Developer

Responsibilities:

  • Responsible for understanding the requirements and preparing the Understanding document and providing the BI solution to the Customer for the given requirements.
  • Responsible for Designing Logical and Physical Data Models using ERStudio Data Architect.
  • Direct interactions with the IT and Business team for Requirement Gathering and providing the solutions to the given requirements. requirement Gathering, Analysis and preparing Functional Specification Document and System specification Document.
  • Responsible for Designing ETL Architectures where contains different layers Like Source, Staging, Data warehouse and integration layer.
  • Responsible to Design ETL and guiding the development team to develop the ETL Mappings, Sessions and workflows.
  • Involved Code Review Activities and Leading the Team.

Environment: ER Studio, Oracle, Spotfire and Informatica.

Confidential

Data Architecture, ETL Developer

Responsibilities:

  • Direct interactions with the IT and Business team for Requirement Gathering and providing the solutions to the given requirements.
  • Involved requirement Gathering, Analysis and preparing Functional Specification Document and System Specification Document.
  • Implemented the Informatica MDM(Siperian) Data Model
  • Creating Base Objects, Staging and Landing tables
  • MDM Landing to Stage Mappings creation
  • Developed Cleanse Functions to cleanse the data between Landing and Stage
  • Configured the Match Rule Set
  • Involved in validation rules creation
  • Worked on the Trust Settings, User/Roles
  • Developed PUT packages for IDD and Web Services
  • Configured Batch Groups to run the stage and load jobs
  • Possess good knowledge on Match and Merge in MDM
  • Involved Code Review Activities and Leading the Team.

Environment: Erwin 7.1, Oracle 11g,Informatica MDM (Siperian)

Confidential

Data Architect

Responsibilities:

  • Responsible for understanding the requirements and preparing the Understanding document and providing the BI solution to the Customer for the given requirements.
  • Involved in proposing project proposals, plans, pricing, effort estimation & cost estimation. Drafted & pitched process flow and solution model to the client.
  • Direct interactions with the IT and Business team for Requirement Gathering and providing the solutions to the given requirements.
  • Involved requirement Gathering, Analysis and preparing Functional Specification Document and System Specification Document.
  • Responsible for Designing BI Architectures where contains different layers Like Source, Staging and Data warehouse, Responsible for Designing Logical and Physical Data Models using Erwin Data Modeler and 8. Development of PL/SQL procedures/ Packages to load the Data through complex ETL process.

Environment: Erwin 7.1, Oracle 10g, and PLSQL

Confidential

Data Modeler, ETL Developer

Responsibilities:

  • Direct interactions with the IT and Business team of every country is required for developing the Data warehouse with multiple customizations pertaining to each country.
  • Involved in Database Model Enhancements using Erwin Data Modeler.
  • Preparation and ownership of design documentation for the new implementations and of any major enhancements.
  • Development of PL/SQL procedures/ Packages to load the Data through complex ETL process
  • Performance of Unit and Integration Testing on the source code.
  • Involvement in the data quality tests and code reviews
  • Automation of the process using Autosys scheduler.
  • Handle Production issues and manage the same in issue log.

Environment: Erwin data modeler, Oracle PLSQL, Oracle 10g and TOAD

Confidential

Data Modeler, ETL Developer

Responsibilities:

  • Requirement gathering and Business Analysis.
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
  • Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
  • Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible. Data Quality Analysis to determine cleansing requirements.

Environment: Erwin 4.1, Oracle 10g and TOAD

Hire Now