Data Architect

I have more than 18 Years (15+ IT & 3 Non IT) of experience. Extensively more than 10 Y in Data Management & Data ware house technologies in Architect role. Played different roles Technical& Management like Database Architect, ETL Architect, OLAP Architect, Information Architect, E2E Architect, Senior Solution Architect & Head DWH/BI Practice for Telecom BI. Researched and Developed Product for telecom BI for oracle database for their effective analysis on Enterprise level. The same was implemented & customized for major telecom operators. Extremely worked with Teradata iLDM models C-LDM, FS-LDM, R-LDM. Worked in large scale database size of 3.2 PITA Bytes for PAYPAL.  Good experience in Big data Implementation Framework for telecom domain.
 Highly Technically skilled in the following Data warehouse tools & Data Bases like architect, administrator, developer.
Big Data:                    Hadoop, Hive, Hbase, Spark, Sqoop, flume.
ETL tools:                  Data stage, Informatica, OWB, ODI, Talend, Teradata Utilities, SSIS.
BI tools:                      Cognos, Micro Strategy, Business Objects, OBIEEE, SSRS.
            Data Model:                ER-Win, ER-Studio, Power Designer and SQL Work Bench.
            Data bases:                Teradata, Oracle, SQL Server, My SQL, DB2.

• Developed large scale data bases from 100TB to 3.2 PITA Bytes. Worked & developed standard methodologies for continuity of DWH Systems.
• Developed third generation DWH system using Ralph Kimball, Inmon Approach.
• Expert in normalized & de normalized techniques and more in DWH with Star schema/snow flake schema and modelling in enterprise scenarios implementation of database architectures, ETL processes.
• Highly work experience in capacity planning, resource planning, cost estimation, time estimation, BAR Architecture.
• Worked more on change data capture, data archival process with different vendors.

Good experience on metadata management, master data management, data governance & analytical Models