We provide IT Staff Augmentation Services!

Data Architect,resume Profile

EXECUTIVE SUMMARY

  • Around 9 years of IT experience
  • Around 7 years of experience in Data Modeling Data Analysis and Data Architecture
  • Conceptual Data Modeling Logical Data Modeling Physical Data Modeling
  • Entity Relational Model 3 NF Dimensional Model Star Schema Reference Model Hub Spoke Model
  • OLTP OLAP EDW DW MDM ODS
  • Reference Data Architecture Kimball s approach and Bill Inmon s approach
  • Application and Enterprise business glossary data dictionaries data mapping Metadata management
  • Data Integration Data Migration Data Profiling Data Analysis Data Governance Data Lineage Data Quality
  • Oracle SQL Server Sybase DB2 Teradata MySQL
  • Requirement analysis High Level and Detail Level Design Data Flow Diagram Sequence Diagram
  • ERwin Power Designer TOAD Teradata SQL assistant SQL TSQL Data Profiler SSIS Crystal Report

Confidential

Technologies CA Erwin Oracle SQL Server Teradata SSRS SQL. TSQL TOAD PL/SQL Sybase Power Designer

Role Data Architect / Data Modeler

Responsibilities

  • Requirement / Business analysis On Shore and Off Shore Development Coordinator
  • Conceptual Logical and Physical Data Model
  • Perform the detailed data analysis. Verify natural keys through SQL queries against the source databases.
  • Develop data modeling standards
  • Master Data Management working with third party solution
  • SQL with emphasis on the SELECT statement to query against violation of RI
  • Perform source data quality assessments.
  • Identify the appropriate data sources with the assistance of the business analyst.
  • Assist the Business Data Analyst in mapping the data from source to target.
  • Assist the Business Data Analyst and Data Integration team with data related issues such as assessing data quality data consolidation evaluating existing data sources.
  • Perform re-engineering of source models when necessary.

Confidential

Technologies CA ERWIN SQL SERVER SSRS Hyperion

Role Sr. Data Modeler

Responsibilities

  • Database design and modeling for transactional and analytical databases EDW
  • Data architecture solution for applications
  • Business analysis requirement analysis and data analysis
  • Data governance data quality data migration ETL
  • Evaluating data modeling tools
  • Meta data management and publishing data
  • Data naming convention and data modeling standards for enterprise
  • Development DBA for SQL Server
  • Assisting production DBA for physical database

Confidential

Technologies MS SQL Server2008 Oracle SYBASE TSQL PL/SQL

Role Data Modeler/Data analyst

Responsibilities

  • Conceptual data model and logical data model creation for business requirements
  • Requirement analysis Client interaction and model demonstration
  • Data modeling conceptual logical and physical model for DBA
  • Metadata Management
  • Use Case modeling Class Diagrams Sequence Diagrams and Object Relational Model
  • Oracle 10G installation and hand on experience as development DBA
  • Data Migration from Sybase to Oracle and SQL server
  • ETL Development in SQL Server DTS
  • SQL Coding Stored Procedure Query optimization
  • Explain data relationships to development team

Confidential

Technology ERWIN MS SQL Server2008 TSQL Oracle PL/SQL SYBASE

Role Data Modeler/Data analyst

Responsibilities

  • Interact with users/access to the requirement documents in the respective financial domains to understand the requirement.
  • Conceptual data model CDM Logical Data Model LDM Physical Data Model PDM
  • ETL mapping Data migration Gap analysis Data analysis
  • Review and walkthrough with Clients Manager and Technical Lead
  • Demonstrate knowledge transfer and handover the assignment

Confidential

Technologies MS SQL Server2005 TSQL

Role Senior Software Engineer / Data Analyst

Responsibilities

  • Involved In Coding for customized Control Web Service and business logic
  • Designing Web Forms for the Applications of B2B module.
  • Designing Tables Wrote stored procedures created views
  • Involved in documentation of the application
  • Provided production support documentation of production support process

Data Analysis

Confidential

Technologies C .NET 2.0 MS SQL Serve 2000 Crystal reports

Role Software Engineer

Responsibilities

  • Involved in Coding Designing tools to support production support processes
  • Involved In production support for Hp s register site for EMEA regions
  • Involved in Automating process Developed Windows services for batch processing and log backup
  • Involved in Maintaining system health
  • Involved in documentation of production support process and tools developed for the same.

Confidential

Team Size 8

Role Software Engineer

RESPONISIBILITES

  • Involved In Coding for customized Control Web Service and business logic
  • Specifically Worked for the Auditors module
  • Designing Windows Forms For The Applications
  • Designing Tables Writing stored procedures created views
  • Unit testing done for the coding of the application
  • Created reports using crystal reports.

Confidential

Technologies C .Net 1.1 SQL Server 2000

Role Software Engineer

RESPONISIBILITES

  • Coding Of Inventory Management Part designed windows forms
  • Designing Forms using visual studio 2003
  • Unit testing done for the coding of the application

Hire Now