Lead Data Architect Resume CA - Hire IT People

SUMMARY

Functional & Technical expertise in Business Analytics, High Volume Enterprise Data Warehouse, MDM, OLTP, NoSQL and Big Data environments.
Excellent experience in working in wide variety of industries from Ecommerce, Financial, Insurance, Telecommunication, Energy, Product Development and Technology start - up companies.
Lead and worked with global, cross-functional matrix teams.
Lead and implemented projects in an Agile and Lean environments.
Work with Business Customers to help them define their requirements, understand their needs and translate them into technical design.
Successfully implemented Business and Technical Metadata systems and linking them and setting up process for Agile Metadata driven processes from Agile Data Modeling to ETL/ELT.

TECHNICAL SKILLS

Databases: Teradata, Oracle, SQL Server, MySQL

Database Appliances: Greenplum, Exadata

Metadata Tools: Alation, Rochade, MetaGlossary

ETL Tools: Informatica Power Mart, Power Center, Oracle Express

OLAP Tools: Business Objects, Microstrategy, Crystal Info, Oracle Reports, Oracle Discoverer

Data Modeling: Power Designer, ERWin, Oracle Designer

Application Servers: Apache, Tomcat, BEA Web Logic, Oracle Application Server

Tools: MS Office, Visio, MS Project

Scripting: JSP, PL/SQL

Operating Systems: Linux, Windows, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, CA

Lead Data Architect

Responsibilities:

Successfully implemented Business Health Analytics which is used by C-Level executives on daily basis. The financial numbers to be reported to SEC, Wall Street and other third parties is generated from this system on daily, monthly and quarterly basis.
Customer MDM between Confidential and Paypal to get a 360 view - Relational, Transactional and Behavior, of the customer which is being used by all the subsidiaries.
Seller Dashboard and Analytics for Confidential sellers to get insights into the market items being sold, the pricing, location, etc.
Defined the process to achieve Single Source of Truth for all the data coming from site and other sources and having a single process for achieving the metrics in Warehouse. Setup a scrum process to achieve this.
Implemented a unified view of all the business and technical metadata repository and setup process to have them in sync with physical systems as part of Data Governance. For this we used Alation, Power Designer and in-house developed tool.
Involved in defining Real-Time Analytics using NoSQL, Hadoop and Teradata in the EDW.

Confidential, CA

Data Architect / Data Modeler

Responsibilities:

Implemented Fixed Income Analytics for business users to make informed decisions.
Designed the MDM and EDW architecture for all domains of the business and successfully implemented the Customer Domain.
Successfully migrated EDW from Oracle to Greenplum.
Successfully migrated ODS from Oracle to Exadata.
Architected, Designed and implemented Metadata Repository for Business and Technical Metadata using Rochade.
Defined Data Architecture and Modeling standards.

Confidential, CA

Lead Data Modeler / Team Lead / Business Analyst

Responsibilities: