SUMMARY

• Over 10 years of comprehensive and in - depth experience in Information Technology (IT) industry with specialization and expertise in Data Warehousing and Business Intelligence.
• Accomplished Data warehouse Architect, Data Modeler and ETL Designer.
• Well acquainted with latest trends in data warehousing like Big Data, Hadoop, MDM.
• Performed overall project management, analysis, architecture, design, development and implementation of data warehousing / business intelligence initiatives for last 10 years
• Worked on data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner, meeting and exceeding the business requirements.
• Responsible for defining the information architecture and technology infrastructure solutions which includes design of multi-dimensional data models, ETL Architecture and Business Intelligence (BI) delivery solutions
• Expertise in Conceptual Data Modelling, Enterprise Data Modelling, Logical/Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design, Metadata, Data Quality, Master Data Management and Data Governance
• Responsible for defining ETL architecture for batch and real-time load, backup, reconciliation process, alerts and notification, real-time, archival and purging, etc
• Responsible for defining and designing end-to-end data warehouse security solution from source system to application layer
• Expertise in Ralph Kimball and Bill Inmon’s Data Warehouse methodology and implemented in various projects
• Provided architectural solutions for various database platforms, ETL tools and OLAP tools

TECHNICAL SKILLS

Data Warehousing: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g/10gInformatica 9.1, Ab-initio 2.13/2.14, Informatica Data ExplorerMicrosoft SSIS/SSRS, Pentaho Open Source.

Data Modelling: Teradata FSLDM Modeling, Dimensional and Relational Data ModellingConceptual, Logical and Physical Data Modelling, Erwin r7.1/7.2

Database Tools: Teradata v12, v13, Microsoft SQL Server 2000/2005/2008 Oracle 11g/10g/9i, Sybase.

Job Scheduler: Autosys, Control-M, Maestro, CA Unicenter

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, Shell Scripting

Packages: Microsoft Office Suite, Microsoft Visio 2010, Rapid SQL, TOAD, Embarcadero

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Architect

Responsibilities:

• Playing role of architect in project with team size of over 25 member (including onsite and offshore)
• Analyzed existing system and business user requirement and designed strategic solutions for different phases of the project which includes data modeling, ETL and BI
• Performed Infra-structure analysis to set-up new Teradata warehouse for client’s data warehouse and did the sizing estimate for Teradata Development and Production box
• Defined the architecture and various phases to create the data warehouse
• Defined logical and physical data modeling principles and guidelines for Teradata FSLDM modeling
• Reviewed logical and physical models and provided inputs
• Created ETL architecture and provided strategy for data cleansing, data quality and data consolidation. Designed various Informatica ETL load patterns which include SCD Type I, Type II, full load, etc.
• Created end-to-end security architecture solution from sources system, warehouse till consumer layers like web portals, BI reports.
• Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results
• Defined architecture for BI along with providing the guidelines and principles for OBIEE RPD model which includes defining facts and dimensions, star model, rules for snow-flaking the dimensions, etc.
• Reviewed RPD model and provided the inputs

Environment: Teradata v13, Erwin, Informatica 9.1, OBIEE 11g, Maestro Scheduler

Confidential

Data Warehouse Architect

Responsibilities:

• Responsible for design of logical and physical Data model for client’s investment management ODS using dimensional modeling
• Defined data consolidation and data cleaning strategy for data coming from 8 different business units (8 different countries of ASIA) of ING to load it into ODS
• Defined data profiling strategy using Microsoft SSIS data profiling
• Defined ETL architecture which includes load pattern for staging and ODS layer using Microsoft SSIS ETL tool, file archival process, data purging process, batch execution process
• Defined the architecture for reporting using SSRS which includes the design of report models in Report Model Designer to use in Report builder
• Designed security solution to authenticate and authorize users to access reports

Environment: Erwin, MS SQL Server, Microsoft SSIS, Microsoft SSRS

Confidential

Lead Designer - Data Modeling & ETL

Responsibilities:

• Managed and lead the project with team of 10 members as data modeling and ETL lead
• Responsible for design of Data model and ETL architecture of client’s retail data warehouse and marketing warehouse
• Created the dimension and fact model using CA Erwin tool as per the requirements given by client
• Implemented Slowly Changing Dimensions - Type I & II in Teradata database using Ab-initio ETL tool for loading
• Worked closely with client to understand the business requirements and provide the strategic solution
• Followed SDLC process, created detailed design and ETL design specification documents for each subject area of the project.
• Designed complex ETL mappings as per the requirements.

Environment: Ab-initio 2.14, Teradata 12, UNIX Shell scripting, Control-M

Confidential

ETL Lead

Responsibilities:

• Lead the ETL development of client’s Revenue and Asset data mart to facilitate their financial reporting
• Worked closely with client to understand the business requirements and convert them into technical artifacts
• Followed SDLC process, created detailed design and ETL design specification documents for each subject area of the project.
• Designed complex ETL mappings and directed the team for converting them into Informatica ETL code.
• Imparted Design presentations and Code walkthrough sessions to client SMEs/Designers/Developers.

Environment: Informatica 7, 8.5, Sybase, UNIX Shell Scripting, CA Unicenter

Confidential

ETL Developer

Responsibilities:

• Performed analysis of existing code written in SAS, UNIX and Perl scripts and converted it into Ab-initio graphs
• Used all complex Ab-initio components like Multi-file systems, XML, Cobol source, Normalizer, Partitioning components
• ETL performance enhancement using Ab-initio parallelism techniques (Data/Component/Pipeline)
• Created Ab-initio schedules using Autosys job scheduler.
• Written complex UNIX scripts for File transfer, Mail Notification, File Archival.
• Prepared the documents for each SDLC phase which includes, Detailed Design, ETL design, Test plan and Production Implementation documents

Environment: Ab-initio 2.13, Oracle 9i/10g, UNIX Shell scripting, SAS, Perl, Autosys