EDW Architect Resume

SUMMARY:

Having more than 14 years of IT experience in complete Software Development Life Cycle.
Proficient in System Analysis, Large Database Design, Scalable & Efficient Data Management Strategy, Metadata Management, Structured Project Management and Strategic Planning.
Expertise in Business Intelligence and Analytics program design & implementation across various industries.
Expertise in ETL Tool Informatica & Databases Teradata, Oracle as well as experience of Reporting Tools as Cognos Reportnet 8, OBIEE, BO, MicroStrategy & Tableau 8.1
Experience in Big Data ecosystem: Hadoop, Hive, Hawq (Pivotal HD), Sqoop, Spark, Spark SQL, Spark Streaming, HBase, Kafka

TECHNICAL SKILLS:

RDBMS: Teradata 14/V2R12, Oracle Exadata/11g, MS Access

Big Data Ecosystem: Hadoop, Hive, Sqoop, Hawq, Spark, Spark SQL, Spark Streaming, HBase, Kafka

ETL Tool: Informatica 6.x, 7.x, 8.x, 9.x

Reporting Tool: Cognos Reportnet 8,BO XI, OBIEE, Tablaue 8.1

Design: Erwin 9.5

Languages: Java, Python

Operating System: Sun Solaris, Windows, Linux

Configuration Management: CVS

Functional Experience: Healthcare, Aviation, Banking, Media

PROFESSIONAL EXPERIENCE:

Confidential

EDW Architect

Responsibilities:

Integration of different systems to Oracle Data Warehouse environment for BI Reporting
EDW Architecture & Implementation
Big Data environment Setup for Data Lake & Analytics
Data Governance & IDQ implementation
Coordination with Business Users on different use cases and its implementation
Assessment of new tools for scheduling & Reporting
Weekly & Monthly Status Review & Reporting
Resource Management

Confidential

BI & Analytics Architect/Technical Program Manager

Responsibilities:

Integration of different systems to Big Data (Pivotal HD) environment & Sourcing Data from HDFS to Data Warehouse for BI Reporting
Big Data Architecture
Coordination with Business Users on different use cases and its implementation
Assessment of new tools for Analytics
Design & Development of different source systems to CDW for Sochi Olympics Reporting
Managing the Operations for Data warehouse which included daily reporting and coordination with different teams in case of any issue
Provide technical solution to team
Status Review & Reporting to NBCU Management
Effort Estimation & Resource Planning
Client Relationship
Program Management
Weekly & Monthly Status Review & Reporting
Resource Management
Preparing and submitting the business proposals
Project Budgeting & Billing

Confidential

ETL Architect/Technical Program Manager

Responsibilities:

Requirement Analysis
Impact analysis
Database & ETL design
Program Management
Project Status Reporting
Process document
Production Support

Confidential

EDW Architect

Responsibilities:

Business user interaction
Requirement Analysis
Impact analysis
Database & ETL design
Process document & Code Review

Confidential

Technical Project Manager/ Business Analyst

Responsibilities:

Business user interaction
Requirement gathering & Analysis
Design/development activities
Daily status/progress reporting to business
Weekly status/progress reporting to client
Project delivery and deployment in production environment
Post production support
Project estimation and Management from Offshore/Onsite

Confidential

Project Manager/ Business Analyst

Responsibilities:

Project estimation and Management
Business user interaction
Requirement gathering & Analysis
Leading the project for design/development activities
Weekly status/progress reporting to client
Project delivery and deployment in production environment
Post production support

Confidential

ETL Lead

Responsibilities:

Requirement gathering and analysis
Leading the project from onsite for design/development activities
Weekly status/progress reporting to client
Project delivery and deployment in production environment
Post production support

Confidential

ETL Lead

Responsibilities:

Low - level design.
ETL Design and development
Co ordination with offshore team
Unit & Integration Testing
Status review with client

Confidential

ETL Lead

Responsibilities:

Database design
ETL Design and development
Unit & Integration Testing
Production implementation
Post production support

Confidential

ETL Lead

Responsibilities:

Database design
ETL Design and development
Unit & Integration Testing
Production implementation
Post production support

Confidential

Senior Developer

Responsibilities:

ETL Design and development
Unit & Integration Testing
Production implementation
Post production support

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship