Data Modeler and Data Integration Architect/Solution Architect Resume

SUMMARY

Data Modeling specialist with more than 10 years of experience in Data Integration and conversions of large applications. Creative problem solver with a successful track record in building complex data integration solutions.

TECHNICAL SKILLS

CORE COMPETENCIES: Business Requirement analysis, Technical Architecture, Data Modeling, Data Interface Design and Data Conversion rule determination, Integration, Technical Documentation, Full Project Lifecycle Management. Auto finance domain expert

TECHNICAL COMPETENCIES: Informatica7.X,Informatica8.X, Informatica9.X, HyperionIR9.0, Oracle10g, Netezza, Autosys, Reflection, Aginity, Erwin Data Modeler, OBIEE 10G/11G, Siebel Analytics, Teradata, PL/SQL,SQL, NZSQL,Unix Shell Scripts, ColdFusion, UNIX (SUN - SOLARIS 10) Windows 9x/2000/NT, Linux.

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler and Data Integration Architect/Solution Architect

Responsibility:

Understanding the Business Processes
Analyzing the Source Systems
Profiling the source data
Identifying the Master Data and Analyze its change
Requirement Gathering and Understanding the need of the business
Logical, Physical, Conceptual Data Model creation
Creating of Business Requirement Document
Data Dictionary creation

Technology: Erwin Data modeler, Informatica 9.X, Unix, Netezza, Visio

Data Quality Repository

Confidential

Responsibility:

Understanding the Business Processes
Requirement Gathering and Understanding the need of the business
Identifying the Master Data and Analyze its change
Logical, Physical Data Model creation
Architecting the end to end solution
Data Flow determination
Data and Reporting framework creation
Creating frame work for Identification and Presentation of Critical Data Element
Business and Technical Metadata Capture

Technology: Erwin Data modeler, Informatica 9.X,Unix, Netezza, OBIEE 11G,Informatica Metadata Manager

Confidential

Solution Architect /Data Modeler/Project manager

Responsibility:

Understanding the Business Processes
Requirement Gathering and Understanding the need of the business
Identifying the Master Data and Analyze its change
Logical, Physical Data Model creation
Architecting the end to end solution
Determination of Migration Path and ETL roadmap creation
End to End Design including ETL process flow
Reporting framework creation and report migration from Hyperion to OBIEE
Project Management

Technology: Erwin Data modeler, Informatica 9.X, Unix, Netezza, Visio, OBIEE 11G, Hyperion

Confidential

Technical Architect /Technical Lead

Responsibility:

Analyzing the Reporting Systems
Oracle Control tables and VPD Design
Participated in Hyperion Access control design Development
Construction of Oracle VPD scripts Testing Identifying the Master Data and Analyze its change

Technology: Oracle 10G,Unix, Hyperion IR

Confidential

Technical Architect /Technical Lead

Responsibility:

Re - Architecting of existing ETL’s
Re - Architecting of Database objects
Performance tuning of existing ETL’s.
Testing of ETL and database objects

Technology: Informatica 8.x,Oracle 10G,Unix,Autosys

Confidential

Technical Lead

Responsibility:

Informatica Service monitoring in all the ETL environments
Informatica installation in the new environment
Maintaining the user access and rights.
New patch installation on all of the servers.
Performance tuning of Informatica servers
Coordination with Vendors to resolve critical issues

Confidential

Developer

Responsibility:

High Level and Low Level Design Document creation
ETL Code creation
END to END testing
Data Model analysis
Implementation Coordination
Informatica Metadata Customized Query preparation

Technology: Informatica 8.X,Unix, Oracle 10G,Autosys

Confidential

Technical Lead

Responsibility:

ETL and Report Maintenance
Release Management
ETL Performance Tuning
Feasibility Study of the requirements

Technology: Informatica 8.X, Oracle 10G, OBIEE 10, Siebel Analytics, Unix

Confidential

Production Support Analyst and Application Developer

Responsibility:

Job Monitoring and Ticket Maintenance
Impact analysis and ETL Code Fix
END to END testing
Data Model analysis
ColdFusion Code development and Maintenance

Technology: Informatica 7.X, Unix, Oracle 9i, SQL Server 2000, Coldfusion

Confidential

Production Support Analyst and Application Developer

Responsibility:

Job Monitoring and Ticket Maintenance
Impact analysis and ETL Code Fix
END to END testing
Data Model analysis
ColdFusion Code development and Maintenance

Technology: Informatica 7.X, Unix, Teradata, Coldfusion

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship