SUMMARY:

• Hands - on experience in implementing large scale data warehouse using MPP system architecture.
• Strong industry experience in implementing Data warehouse solutions for Business needs.
• Strong Relational, Dimensional and Star schema logical and physical Data Modeling skills.
• Extensive experience using ETL tools; SSIS, Informatica, and WhereScape.
• Fifteen + years of Information Technology experience in System Analysis, Design, Development, Testing and Implementation of application software.
• Extensive experience in Operational and Data Warehousing activities of various business processes on the latest technology systems.
• Achieved significant cost savings to the company by developing processes and business aligned planning which allowed repeatable cost reduction methodologies for Data Warehouse applications.
• Extensive knowledge of Data and Information Life Cycle Management, Software Development Life Cycle (SDLC), Data Integration Development Cycle and Data Warehouse Life Cycle.
• Extensive experience in developing Business Intelligence Packages, cubes and reports.
• Proficiency in 3NF Relational database modeling, Data Warehouse/OLAP Dimensional Modeling, Star Schemas and Hybrid Models.
• Hands on experience in Data Profiling, Data Quality and Metadata Management.
• Thorough working knowledge of Teradata, Oracle and SQL Server databases.
• Collaborate with cross functional teams from gathering business requirements to transforming to high quality technical solutions.
• Teradata Certified Professional on Version 12 and Teradata-SQL certified. (ID # TDC00055127)

TECHNICAL SKILLS:

ETL Tools: SSIS, Informatica 9.0, Data Explorer, WhereScape Red

BI Tools: SSAS and SSRS and TBIO

Database: SQL Server 2005/2008/2012, Teradata 12/13.10/14.10/15, (Data warehouse and Data mart appliance), Oracle 9i/10g.

Modeling Tools: UML, WhereScape 3D, ER diagrams and Dimensional Modeling using Erwin 7.3

Operating Systems: Windows, UNIX, Linux

Software: SQL, T-SQL, PL/SQL, BTEQ, Teradata Parallel Transporter, UNIX Shell Script, Teradata BAR DSA

PM Tools: MS Project, MS Office, MS Visio

Job Schedulers: Control-M Desktop 7.0

PROFESSIONAL EXPERIENCE:

Confidential

DataWarehouse Architect

Responsibilities:

• Designed and Implemented Active Enterprise Data Warehouse Ecosystem for Platforming SODS (Sales Operational Data Source), which will enable high-performance analytics and provide real-time data services to support initiatives including customer personalization, experience, online growth and loyalty.
• Architected Teradata (MPP System Architecture)Eco System Solution for Nordstrom with 6690 ADW, 2690 Marts and Unity Data Mover, Viewpoint and TMSM
• Implemented Hadoop BigData NoSql platform to support Data Science projects.
• Implemented Teradata BAR DSA 15.10 backup solutions for Online and Offline backups
• Implemented Teradata Data labs for customer to quickly prototype their business models
• Supported projects solving data problems in retail domain using machine learning/statistical algorithms.
• Successfully upgraded Teradata Database 1 .10 and OS upgrades from SLES 10 to SLES 11.
• Teradata Performance Tuning go to expert for Active Data warehouse and Data Marts.
• Instrumented Teradata ECO System Unity Data Mover that runs around 100 daily incremental refreshes across Active Enterprise Data warehouse to Customer Data Mart, Merchandise Data Mart and other Departmental data marts.
• Implemented Self-service Business Intelligence using Teradata Data Labs.
• Acted as Subject Matter Expert (SME) for ETL/SSIS and Data Modeling issues within the team.
• Designed and Implemented Customer Analytics Datamart, a high-performance datamart appliance platform, which will give a real-time view of customer behavior, purchase history across all channels.
• Coordinating with Teradata Support in providing Business Critical Support for All Production systems. This involved reviewing tech alerts, implementing patches and DRs. Within the Nordstrom Enterprise Operations standards.
• Maintain and report PDCR/CPPT information to Project Managers and Leadership for the monthly Quality Of Service meetings to give insights in to Data warehouse incidents, performance issues, and Recommend and advice on disk space, sizing capacity and estimated annual growth.
• Effectively communicate with all levels of business from executives to business analysts to IT professionals in aligning the IT with business goals. Actively work with DBA’s, ETL developers, Modelers and BI reporting services teams to guide and advice on technical issues.
• Review data models and made necessary recommendations to development teams to comply with company’s PCI/PII standards and SOX audit requirements.
• Implemented data refresh strategies across Production to non-Production environments to support development, test, performance and user acceptance environments.
• Recommend and enforce policies for unit/integration/system performance/user acceptance testing in all phases of DW/ETL/BI design, development and deployment cycles.

DataWarehouse Lead for Platform Services

Responsibilities:

• Designed and Implemented Active Enterprise Data Warehouse Ecosystem for Replatforming SODS (Sales Operational Data Source), which will enable high-performance analytics and provide real-time data services to support initiatives including customer personalization, experience, online growth and loyalty.
• Architected Teradata (MPP System Architecture)Eco System Solution for Nordstrom with 6690 ADW, 2690 Marts and Unity Data Mover, Viewpoint and TMSM
• Implemented Hadoop BigData NoSql platform to support Data Science projects.
• Supported projects solving data problems in retail domain using machine learning/statistical algorithms.
• Successfully upgraded Teradata Database 1 .10 and OS upgrades from SLES 10 to SLES 11.
• Teradata Performance Tuning go to expert for Active Data warehouse and Data Marts.
• Instrumented Teradata ECO System Unity Data Mover that runs around 100 daily incremental refreshes across Active Enterprise Data warehouse to Customer Data Mart, Merchandise Data Mart and other Departmental data marts.
• Implemented Self-service Business Intelligence using Teradata Data Labs.

DATA WAREHOUSE ARCHITECT

Responsibilities:

• An active team member of BI Competency Center that helped marketing department save multi-million dollars by providing an agile CRM solution for distributing coupons to customer base to develop a loyalty segment.
• Led the DW team of 4 members to build the Data Warehouse from scratch adhering to the DW principles, i.e., by analyzing business user requirements, source system analysis to identify data points, mapping source data points to target data points, creating data dictionary to capture metadata, using Informatica Data Explorer for data profiling to understand the corporate data, using Erwin 7.3 tool to modeling dimensional star schema to provide logical framework for the DW, data quality management to cleanse and validate the data and, using Informatica ETL to transform and load before purging.
• A Go To expert for all Data Warehouse/ETL related query/reports tunings. Mentoring other team members in using Load strategies in to Star and Snow-Flake schemas.
• Expert in Retail LDM in customizing the Logical model to business user requirements. Using Erwin 7.3 Modeler tool to create the Logical Data Model for the Sales, HR, Finance and Inventory subject areas by a combination of reverse engineering the existing schema from source systems SQL Server 2005, Oracle 10g, and data points mapping, and created Star-schema dimensional model with confirmed dimension tables, confirmed fact tables, bridge tables and surrogate keys. Implemented the logical model to Physical model by creating DDL scripts for tables, merging minor entities, choosing the right candidate primary keys, partitioned tables with Multi-level partitioned primary indexes. Implemented Semantic layer on top of Physical model for easy user access by creating secured views with no locks for summary and reporting views.
• Perform tasks like table vertical/horizontal partitioning using Partitioned Primary indexes, creating aggregate join indexes, single table join indexes, hash indexes, creating unique/non-unique secondary indexes, single table join index, sparse join indexes, use compressions, collect statistics, system tuning, use semantic layers and views to secure the Data Warehouses, create slowly changing dimensions to track the history, create and maintain confirmed dimensions and confirmed fact tables, tune queries that involve joining fact tables by using stitch queries and, tune user queries to achieve the performance, etc.
• Led a team of 3 members in Design, develop, test and deploy SSIS packages to integrate data from multiple source systems into transactional and DW systems that are used by Sales, Marketing, HR and Finance departments to support day to day operations.
• Design, develop SQL Server Analysis Services (SSAS) and Reporting Services (SSRS) solutions for real-time key performance metrics like total guests, sales by menus, AM PM, hourly, daily, check level, discounts, marketing campaign coupons, daily inventories, district location hierarchy rollups, manager’s pars by week/period, customer promotions etc.
• Design, develop, deploy and support Cognos BI V10.1 framework manager DMR models, relational models, Cognos transformer power cubes and virtual cubes, periodical reports(for strategic and tactical), dashboards and score cards to help executives at regional levels to understand and track customer traffic, gross sales, inventories and staffing pars.
• Implement best practices in Dimensional Modeling using Erwin 7.3, Cognos BI Framework Manager DMR/Relational models, Cognos Transformer Power cubes, and multi-dimensional reports.

Database Administrator

Responsibilities:

• Implement, troubleshoot, maintain and administer SQL Server 2000/2005 database environments. Other responsibilities include tune and support the databases, recommend and help enforce policies and standards.
• Develop database backup and restore routines for test and production data.
• Implement and maintain physical database security.
• Work with system administrators and developers on configuration and performance issues.