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