PROFESSIONAL SUMMARY:

• Experienced Data Architect led multiple end to end implementation projects for customers in last 17 year time period. Implemented large scale IT projects based on Project specification & service level agreements.
• Competent in all stages of project lifecycle, from RFP to Business Analysis, Solution architecture, Data Architecture, Modelling, ETL architecture, performance tuning & BI Analytics. Comprehensive experience asData Architect, Solution Architect,BI Data Modeller, Data Migration Lead, Developer & BA
• Design and Implement Data Management Solution for large organization including UK Home Office, Federated Co - Op, Enbridge Gas, GE-Energy and HP
• Design & implement Enterprise Data Warehouse & Data Marts, Operational Data Store, Master Data Management, Supply Chain, Confidential & Siebel CRM implementation, Data Migration
• Specialized in analysing business requirements, identifying entities, Conceptual, Logical and Physical Database Design, Data Profiling, defining Data Lineage and validation rules etc.
• Recommend and implement new technologies, tools, procedures, provide Data Standards for MDM and Business Intelligence
• Delivered end to end five implementation projects, three Data Warehouse and Reporting projects, two MDM and three support projects

TECHNOLOGY:

Domain: Supply Chain, Retail, Public Sector, Energy & Utilities, Pharmacy, Sales & Marketing

Big Data: Python, Mongo DB, Kafka

Data Bases: Oracle11g, 10g, 9i, Microsoft SQL Server, DB2, Sybase, Access DB

Data Warehouse Appliances: Netezza 10.2

Data Virtualization Tool: Denodo

Data Replication Tool: Oracle Golden Gate, Attunity, tcVision, Informatica Power Exchange

Data Warehouse Model: IBM Retail Data Warehouse Design Model

Data Analysis Tool: IBM Infosphere Discovery, IBM Infosphere Information Analyzer, SQL

Data Modelling Tools: Erwin Data Model, IBM Infosphere Data Architect

Data Masking Tool: Data Masketer (TCS Propriety), IBM Infosphere Optim

Reporting Tool: Cognos 11, Cognos 10.2.2, Oracle OBIEE

ETL Tool: Informatica Power Centre, Oracle SQL Loader, Data Stage

MDM: IBM MDM Infosphere Standard Edition

MDM Data Domain: Customer, Product, Account

Project Management Tool: Microsoft Project Plan

CRM Technology: Siebel 8.2, Siebel 8.1, Siebel 7

Document Handling Tool: Oracle Web Centre Content

EMPLOYMENT HISTORY:

Confidential

Sr. Data Architect

Responsibilities:

• Delivered Enterprise BI roadmap and Cloud Strategy
• Recommend Enterprise Tools for Data Virtualization & Replication
• Successfully execute Projects require BI Development, Data Migration & MDM as Data Architect

Confidential

DW BI Architect

Responsibilities:

• Conduct Pre-workshop interviews, review Business Process & Technical Documents
• Delivered Decision Analysis Resolution Evaluation Report (DAR) to support the RFE process, delivered high level Architecture Definition Document
• Identify & Analyse the Source System Data Model, Key data elements using Data Profiling tools
• Create Reference Data Model, Logical & Physical data model to support master & Transactional data, Macro Design for ETL & Data Architecture & provide control framework for ETL Process
• Define & delivered Data Provenance Document for Business and Generate Data Lineage Document for technical team
• Evaluate & recommend Data Virtualization Software & Replication Software
• Define the Enterprise Application Landscape for Data Virtualization & Replication Software, delivered Architecture Design Document providing Application, Data & Technology Architecture
• Lead the POC for Sterling 9.5 Cognos 11 Application Integration, worked with Cognos Admin & support team for set up, integration & development of Operational & Analytical Reports
• Followed the ARTS Retail Operational Data Model, Logical and Physical Data Model
• Define Principles & Patterns for modelling integration patterns
• Update BI Standards & guidelines for developing reports using Cognos 11
• Worked with Cognos Team, define Data Model, Packages for Complex Reports
• Worked with Cognos Team to Identify & resolve Cognos Reports Performance issues
• Designed the real time analytics and ingestion platform using Python and Kafka. Hands on experience with Mongo Db.

Confidential

Solution Architect

Responsibilities:

• Lead multiple workshop with business to Identify Functional and Non Functional requirements
• Map the Legacy Mainframe Business Process with Data elements, generate the Data Flow Diagram & validate the same with Business & Technical Team (IT-Operations)
• Evaluate System that needs to be retired & recommend possible solution & services, delivered Decision Analysis Resolution Evaluation Report
• Delivered High Level Architecture Design Document covering Solution Building Blocks, Current & Target State Architecture, Application Architecture, Data Architecture, Network Architecture
• Provide Detailed Design Document covering data migration design, Data Lineage Document, Extraction Rules, Data Archival and Purging rules etc
• Review & Validate Functional & Technical Design Document, Worked with Business & JDE Vendor verifying Application Development, Data Migration & Business User Training document to ensure the solution implemented as expected to agreed timeframes

Confidential

Sr. Data Architect

Responsibilities:

• Worked with Business & Technical SMEs, understand the current Business Process, source systems, Master, Transactional data and business entities.
• Chair multiple session with Energy Business, Data SMEs, understand the Retail Business Process & generate the Data Flow Diagram
• Extract Adabas and VSM Data file from Mainframe System using Replication and ETL Tool, Interpret data, analyse results, complex relationships, design the Staging Database
• Perform Data profiling activity, did column analysis, key column analysis on Customer and Product using Information Analyser tool and share the results with Business
• Perform Metadata Management using Information analyser and Information Business Glossary
• Work with IBM Consultant in implementing MDM Solution using IBM MDM Infosphere, Define the business rules for Address Data standardisation & Implement using Canada Post Integration
• Provide the Architecture standard & guidelines for BI Projects
• Followed IBM Retail Industry Data Model, map FCL Energy Business Process and Data
• Generate Logical and Physical Data Model using IBM Infosphere Data Architect Tool
• Define Metadata using IBM Infosphere Business Glossary terms & assets
• Generate High Level Architecture Design Document, Detailed Architecture Design Document for Data Warehouse providing Application, Data and Technology Architecture
• Done the Data Analysis, check data for completeness & accuracy, Identify relationship, generate the Data Lineage Document
• Provide Technical Strategic advice and guidance to ETL, DBA and Data SMEs for a Project
• Design & develop the DataMart defining Dimensions, Fact by following the Kimball Approach
• Worked with Cognos Developer in defining the Data Model, Packages for Complex Reports using Framework Manager
• Review the Cognos Data Model, set up the guidelines on when & how to use Transformer & Cognos Cube modellers for the Reports
• Design & development of Self-Serve Analytics using IBM Cognos Report Studio & demonstrate the same to Energy Business Units
• Implement Enterprise Retail Data Warehouse using Bill Inmon’s top-down approach & DataMarts using Kimball bottom-up approach

Confidential

Associate Consultant

Responsibilities:

• Followed TOGAF Framework, open standards for Govt. Data and Technology, document and get agreed upon Architecture Principles
• Identified the legacy source systems & assess individually by series of questionnaires, meeting & sessions with existing Technical Team & Business SMEs
• Perform Data profiling activity, did column analysis, key column analysis and cross domain analysis using Information Analyzer Tool
• Perform Metadata Management using Information analyser and Information Business Glossary
• Generate the As Is Data Mapping Document, Define & produce Data Dictionary document
• Design & Delivered the Data Architecture Document, Data Migration Strategy, Data Masking Approach, Design & Mapping document, Archival & Retention Process Document
• Asses the business and technical requirement, evaluate & recommend Data Integration Software and Data Encryption software
• Establish Data Migration process & governance, define the data gathering, cleansing rules, Data Quality rules, data transformation rules, Process for upload, delta upload to staging database based on detailed data analysis, profiling of disclosure & barring databases
• Define the Master Data Management Strategy, Proposed and implement IBM Infosphere MDM Probabilistic Matching Algorithm
• Delivered High Level MDM Design covering Data Classification, Data Security, Data Governance Framework, Master Data Entities, Metadata, components, Data Sources etc.
• Lead the team of Java, Informatica ETL and MDM resource, Produce technical deliverables that include initial Configuration, Operational Server Processes, Data Standardization and validation rules, Data Comparison results, Bucketing, Data Model and attribute Weightage, Linkage etc.
• Worked with Data Stewards in determine matching accuracy, false Positive, False Negative and Golden Records and delivered Matching algorithm
• Documented Technical Specification document for design & development of Cognos Reports
• Create FM Model of Siebel Table/views & publish package for Report Development in Cognos
• Provide Technical direction to data analyst, data integration architects, developers & database administrators during design & development phase for Data Migration, MDM & Data Warehouse development
• Did comparison of Content and Structure of data over time using Information Analyzer
• Ensure solution designed to deliver business requirements & comply with organisation’s enterprise architecture
• Assist & verify design of ETL solution & production of all design phase deliverables.

Confidential

Data Architect

Responsibilities:

• Lead business requirement session, analyse the requirement, profile source data & create the High-level Reporting design doc
• Prepared logical & physical data model, Process model & detail design specification using Erwin Data Model
• Define the overall process design for the interfaces into & out of Siebel CRM to SAP & other downward systems
• Developed/Support Oracle Materialized views, prepared Unified Data Model for ETL Developers & assist them during the build & perform QA checks of the completed code
• Worked on integration of Siebel with SAP BO for Report Development
• Manage build phase & quality assure code to ensure fulfilling requirements & adhering to ETL architecture

Confidential

Data Architect

Responsibilities:

• Work upon RFP, did the initial project assessment & interview with business sponsors & users to understand the legacy application issues & constraints
• Participate in the functional assessment of the legacy application, requirement gathering sessions, break down of legacy application into number of modules & assess individually by series of questionnaires, meeting & sessions with existing Technical Team & Business SMEs
• Did the Initial assessment of Legacy Application, functional mapping of the legacy application & prepared High Level Design Documents for Data Migration & Integration
• Define the Conceptual, Logical & Physical Data Architecture, Design & Delivered the Data Dictionary, Data Migration Strategy, Design & Mapping document
• Produces Detailed Integration Architecture document providing integration design between Siebel system & various legacy systems
• Done the Qualitative & Quantitative Data Analysis, check data for completeness & accuracy, Identify relationship between the Tables, generate the As Is Data Mapping Document
• Prepared Unified Data Model for ETL Developers to do the Data migration from Legacy application to Siebel
• Preparing Data Transaction Rules, Prepared/Reviewed the detail level Technical Design Doc
• Lead and manage Datastage ETL resource, create ETL standards, generate detailed ETL Design Document
• Ensure the accuracy & accessibility of all important data, extensively worked with portioning for splitting multiple data streams into sub chunks to distribute the load evenly across all available processors to achieve maximum thru put in Datastage
• Ensure solution being managed meets business requirement by reviewing the Technical Design Document
• Cleansing & profiling of legacy data, prepared & finalized the template for Unit Test Plan & support testers in SIT & UAT
• Worked with Datastage Developer, did performance tuning of mappings, identify and resolving performance bottlenecks in source and target mappings in Pre Prod and Production environment
• Generate Shell Scripts to automate file manipulation and data loading procedures
• Create User manuals defining application process flow, Includes a description of the system functions & capabilities & step-by-step procedures for system access & use
• Work with Business Users and Technical Team during Warranty period on bug fixing & performance issues

Confidential

Sr. Technical BA /Data Migration Lead

Responsibilities:

• Work with Business and IT BA to get the high level requirement and business process document
• Combined disparate data sources and processes and provide unified view of the application
• Prepared/Reviewed the detail level Technical Design Document, Data Mapping Documents, EIM Data Flow Documents
• Prepared High Level and Detailed Design Documents for Data Migration
• Developed/Implement processes to migrate Pharmacy Sales data from different data sources (Third party data) to Siebel using Siebel EIM, Informatica and Unix
• Doing the Gap analysis on all the major entity for the releases and preparing Test Scripts
• Analysed and identified application performance issues and implemented code and configuration fixes to optimize the application
• Involved in the analysing, planning and execution of workflow process to enforce business rules

Confidential

Technical Business Analyst - Data

Responsibilities:

• Understand the legacy Application, provide Technical Design Specs for Data Migration
• Define, produce Data Dictionary document, Generate Data migration strategy design and development Document providing Physical Data Model, Data Dictionary, Data Mapping Templates, Data Archival Strategy
• Data migration / data cleansing process development and management
• Design and develop data mapping from legacy applications to Siebel
• Review data mapping, identify impacts and provide the feedback to development team
• Fixing of Bugs related to data loading reported in UAT and SIT
• Done successful migration in Production from Legacy Application to Siebel 7.5 Sales(Oracle 9i)