We provide IT Staff Augmentation Services!

Data Modeler / Data Architect Resume

SUMMARY:

  • 17 Years in IT industry, proven track record of successful, production implemented data project.
  • Strong Experience of Project Management, Program Management, Engagement Management, Stakeholder Management, RFE, RFI, Pre - Sales, Onsite-Offshore Model, Project Estimation and Budgeting, Capacity Planning, Product Management,
  • Business Consulting, Process Consulting, Data Management Consulting, Presentations, Define reference solutions, frameworks, Product Selection, Long/Short term technology roadmap
  • Exposure to IBM Reference Architecture, Insurance IDM, TOGAF, Za chman, Kimball, Inmon Architectural Framework
  • Good experience in Big Data Technologies,AI, Data Management, Machine data, sensor data, real time data streams
  • Extensive domain knowledge in Insurance Industry including P&C, Life, Specialty, Aerospace
  • Strong hands on experience in different data technologies
  • Strong experience as Data Architect, Big Data, Integration Architect, Real time Data Integration, Data Architecture, SOA Integration Architect
  • Active member of DAMA, Accord, Various Data warehousing and Analytics Architecture Groups
  • Multiple cycles of EDW, DM MDM, Metadata Management, and Reference Data Management Models
  • Experience in different data exchange standards including XML, XSD, Accord, ISO, Clinical Data
  • Specialized in Integrate analytics and business intelligence to provide solutions according to clients’ organizational policies and IT environment. Provide leadership to employees
  • Strong communicator, Requirement gathering, Business Presentations, Stakeholder Interactions, Managed Development Programs
  • Data Modeling: Over 10 years of Dimensional Data Modeling experience. Sound knowledge on Dimensional Modeling, OLTP Models, Canonical Integration Models, EAV, Associative Modelling, Ralph Kimball and Bill Inmon Methodologies, Star/Snowflake schemas, Data Marts, Facts & Dimensions, Logical & Physical data modeling, MDM Data Modeling, Unstructured Data Modeling, Metadata, Reference Data Process models. ETL and Reporting Framework Modeling, Database Management in SQL Server, Oracle,DB2
  • Data Management: Over 12 years of Data Warehousing experience using IBM InfoSphere Information server 11.5 ( DataStage, QualityStage, Multiple Connectors, CDC), Server and Parallel edition of DataStage 7.0 to 8.5, Informatica Power Center 6.0 till 9.5 (Designer, Workflow Manager, Workflow Monitor, Repository M anger), PowerConnect, Power Exchange. 10+ years of Microsoft BI Platform (SSIS, SSRS, SSAS). 7+ years of experience in AbInitio, Express IT, DM Express, Pentaho, Talend
  • Big Data: Tibco ActiveSpaces, Data Flux, HortonWorks, Hadoop, Hive, Spark, Scala, Cassandra, Sqoop, NoSQL, Kafka, Hive, Pig, Impala, Hbase, Nifi, Kibana, Apache Big Data frameworks and standards
  • Realtime Data: Tibco BE, CEP, BW,IBM MQ, IBM Infosphere ISD ( Infosphere Service director) for real time data integration
  • Architect: Over 12 years of Architectural experience as Data Integration Architect, ETL Architect, and Data Architect. Integration of complex Legacy systems in Warehouse, Data Migration Architectural design, Analytics over data. Defined various Data Integration patterns and Framework with innovative approach. Expert knowledge of Integration of New generation PAS systems with legacy systems. Expert in Accenture Duck Creek Integration, Shredding.

TECHNICAL SKILLS:

Business Intelligence: 8 years of Business Intelligence experience using SSRS, SSAS, Cognos, BO,Spotfire

Analytics: 5 years of Experience in Multidimensional Data Analytics including SSAS, TM1, R

Databases: 15+ years of experience using Oracle, DB2, MS SQL Server, Teradata V2R6/V2R5, Teradata

Hadoop: MongoDB, Hive, Hbase, Scoop, Ambari. Hortonworks Studio, Cloudera Studio.

Programming Languages: SQL, T-SQL, PL/SQL, Microsoft .Net, Java, VB, Perl, Python, R

Cloud Integration: SalesForce, Accord Integration, DuckCreek Integration, Informatica Cloud.

Data Tools: Trillium, Informatica IDQ, Informatica MDM

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler / Data Architect

Responsibilities:

  • Evaluate architecture patterns, Define best patterns for data usage, data security, data compliance
  • Define concept models, logical & physical data model
  • Define data integration needs, rules, data governance framework, data quality framework for MDM program
  • Define strategy for C Level Business users, Discussion with business, define short term and long term roadmap and blueprint
  • Architecture pattern management, core member of Architecture review board
  • Process management, Project management, Resource management

Technologies:

  • Enterprise Architect(EA), Tibco BE, BW, Spotfire, ActiveSpaces, IBM DB2, IBM Data Architect, Erwin
  • IBM InfoSphere 11.5 (Data Stage, Quality Stage, IGC, DataClick, Data Analyzer, ISD)
  • IBM Party Model
  • Cassandra, Spark, Scala, Data Flux(Big Data Platform),Python, Java, Hive, HDFS, Tibco AciveSpaces (IMDG)

Confidential

Data Modeler / Data Architect

Responsibilities:

  • Product Business Process Model Design
  • Extension of Accord and Define Enterprise Insurance Data View Model
  • Discussion with Various Project Partners, Stakeholders and build conceptual view of Product model
  • Manage Efficiency and Integrity while Integrating with Unstructured Model design.
  • Understand newer technologies like Big Data, Cassandra, MongoDB NoSQL, NewSQL

Technologies:

  • Erwin Enterprise
  • Microsoft SQL Server, SSAS, SSIS, Cassandra, Python, Java,
  • Hive, HDFS, HBase, Scoop, Data Flux, CDC (IBM CDC), IBM IFW/Reference Model

Confidential, Atlanta, GA

Data Modeler / Data Architect

Responsibilities:

  • Gathered Business Requirements, Consolidated and defined data Integration patterns for warehouse
  • Defined, Develop and Maintain data model for EDW, Multiple Data Marts, Compliance Data Management, Metadata Management, MDM
  • SQL Server Database Administration.
  • Defined Architectural Framework and Pattern for Successful Integration with Legacy Systems
  • Defined end to end data Integration strategy, methodology and Model driven ETL Framework
  • Defined Data Publishing strategy from data warehouse data
  • Issue resolution with Higher Management
  • Account and Project Management and Offshore Co-ordination.

Technologies:

  • Erwin Enterprise Data Model, Accord Insurance Data Model
  • Microsoft SSAS, SSIS, SSRS, Tableau, TeraData, R, DB2, SQL Server 2012, Power BI
  • Accenture Duck Creek, GuideWire
  • XML, Java, JavaScript, .Net C# Components, R Scripting

Confidential, Chicago, IL

Data Modeler / Data Architect

Responsibilities:

  • Interacted with End-users for gathering Business Requirements and Strategizing the Data Warehouse processes
  • Defined Data Model for data warehouse and Marts. Legacy Integrated Model
  • Compliance Data Model for ISO reporting extending Accord Insurance Data Model
  • Maintain and Mange OLTP Models for DuckCreek PAS Shredding environment
  • GuideWire Integration with Warehouse, Suggest source modifications.
  • Defined ETL strategies and Best Practices for E DW environment
  • Defined different data integration and validation frameworks including data validation, Error checking process, lineage, recovery and reconciliation.
  • Defined mechanism to extract and integrate data from COBOL data sets
  • Defined data usage using OLAP and Ad-hoc Data Analysis.
  • Defined SOA integration pattern with Warehouse.
  • Ensured Development as per Architecture defined

Technologies:

  • Erwin Enterprise Data Model, Accord Insurance Data Model
  • Microsoft SSIS, SSRS, Business Object, Cobol Copy Books, R, DB2, SQL Server 2012, TFS
  • Accenture Duck Creek, GuideWire
  • XML, .Net, Cobol, T-SQL, Stored Procedures, DB2

Confidential, Hoboken, NJ

Modeler/ETL Architect/Data Architect/Lead

Responsibilities:

  • Defined Data Models, Data Integration Meta model for Framework.
  • Designed TPA Data Integration methodology, TPA Data Integration Models
  • Defined SOA Integration methodologies and strategies through SOA Canonical Data Model
  • Defined OLTP and SOA Data Modeling for the SFDC applications
  • Interacted with business to check for data points and quality of data
  • Designed ETL specification and Development
  • Involved in Design and Development of ETL
  • Developed Integration with web services

Technologies:

  • Erwin Enterprise Data Model, EDW Standard Data Model
  • IBM Inforsphere DataStage, Informatica PowerCenter, PowerExchange, Web Service Hub, Oracle 9i, Teradata,SQL Server 2005
  • Business Object, Universe Designer, Cognos, Cognos TM1
  • XML, Java, Hybernet, Spring, Cobol, PL/SQL, Perl
  • SalesForce, Apex Script, Salesforce Informatica Integration

Confidential, Harleysville, PA

Architect/ Lead

Responsibilities:

  • Business Process Understanding and Requirement Gathering, Driving Business Meetings
  • Design and Develop End to End Data Model for EDW, Multiple Data Marts, Compliance Reporting Structure, Canonical Modeling, Integration and Process Models, Metadata Models,
  • Metadata and Master Data Management (MDM), MDM Modeling
  • Defined and Designed ETL architecture of the project
  • Defined Reverse engineering of Stat Application logic from Cobol programs
  • Defined ETL and Reporting Process Framework Model
  • Development of mapping Methodology, Data Lineage, Reference Data

Technologies:

  • Erwin Enterprise Data Model, EDW Standard Data Model
  • IBM DataStage Parallel Edition, Informatica PowerCenter, PowerExchange, Teradata,SQL Server 2005
  • Business Object, Universe Designer
  • XML, Java, Spring, Cobol, PL/SQL, Perl

Confidential

Developer/Lead/DBA

Responsibilities:

  • ETL Developer, DBA, Database Programmer
  • Java Developer
  • Business Analysis
  • Content Developer

Technologies:

  • Oracle Hyperion (BRIO Reporting)
  • XML, Java, J2EE, Hibernate, Spring, JSP, Cobol, PL/SQL, Perl, PHP, Perl
  • VB 6.0, .net, C#, IIS, ASP, SQL Server, COM, DCOM, DLL, C, C++
  • Informatica 6.0

Hire Now