Data Architect, Retail Analytics Resume

SUMMARY:

An award winning senior certified Enterprise Architect with 9.5 Years of design & implementation experience with MPP data systems (Teradata Certified DBA/Architect) H1B VISA Stamped - Eligible to work in USA
Solid mathematical background with strong production performance, application performance, data analysis & planning skills.
Excellent client interface and consulting skills. Experience in consulting with senior-level executives. Strong business and technical analysis background.
Strong experience with highly rich data sets ( Database as large as 2 Petabytes)
Expert level understanding of MPP databases, Data Warehouse design, BI reporting and Dashboard development. Strong knowledge and experience with benchmarking & implementation of distributed applications & system.

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect, Retail Analytics

As a Data Architect, I am responsible for building and improving the analytical data solutions that New York & Company executive & product team is depended on to make the decisions looking forward.
Drive roadmap planning and implementation of data architecture and data processes across the NYCO team, including driving the next generation decision support system using real time and predictive analytics (Elasticity of Demand/Promotion Affinity/Customer Life Time Value for a new customer / Ecommerce potential buyer prediction for targeted marketing/ Recommendation Engine using association rule / Chat Sentiment Analysis).
Architect & Implement scalable data pipelines (real time and batch) within lambda framework using retail structured (CRM, POS, MERCHANDISING SYSTEM, and STERLING) and unstructured data sources (Chat data, Clickstream data, Store Traffic Sensor Data, Social Media, Email, Website Traffic Data) Frame Work: Teradata/Hadoop / AWS / HIVE / Python / Spark /SQL
Establishing standards, guidelines and best practices for the design & development, tuning, deployment and maintenance of NYCO’s Big Data framework (Hadoop/Teradata).
Capacity Planning - Informatica/Teradata/Hadoop.
Responsible for oversight, business rule design and execution of NYCO’s CRM and marketing analytics solution.
Data Modelling to create logical model (Star/Snow Flake/ER) and physical relational model for micro strategy sematic layer.
Vendor Management & Negotiations.
Co-ordinate with NYCO Executive team for future reporting needs.

PS Consultant

Confidential

Ex-Senior member of Teradata COP Team (a specialized research group of 8-10 SME formed to tackle serious data-warehouse issues faced across the Teradata accounts) at Teradata Corp.
Maximum Team size lead - 12 Consultants.
Acting as a trusted advisor for Teradata Corp. clients and providing technical leadership to ensure they get maximum value from current Teradata (14/15.10/16.00 ) & Aster (6.2) architecture.
Closely working with the accounting team to create client interest in Teradata solutions.
Architecting & Setting up a Data Lake involving Teradata, Aster, and Hadoop. POCs on pattern matching using Teradata NPATH, Market Basket Analytics, Clickstream analytics using Sessionize. Query Grid Setup to connect Teradata, Hadoop and Aster.
Database designing (Physical/Logical data model) on relational database engines and Normalization/De normalization for ETL and DW operations.
Implemented Teradata on premise to AWS cloud migration.
Capacity planning of the MPP databases (Hadoop/Teradata/Aster).
Database query performance optimization across a distributed structure platforms. Managing Teradata Data warehouse performance. Creating visualizations using Tableau depicting critical KPIs and providing recommendations aimed at reducing the risk of a Teradata Data warehouse system failure.
Teradata Backup & DR design using Teradata DSA/NetBackup & EMC Deduplication. Data Migration using TPUMP, FASTLOAD, MLOAD, BTEQ, Shell Scripting, JAVA.
Design Priority Scheduler workloads (TASM) for Teradata.
Teradata Corp. Internal UI and Framework Tool developments using Java.
Conduct Teradata Performance Tuning sessions (USA/Australia/Manila/India).

TECHNICAL SKILLS

DATABASE: Teradata (14/14.10/15.00/16.00 ) Cassandra

PROGRAMMING: SQL PYTHON

ARCHITECTURE: STAR/Snowflake/Lambda

DATA MODEL: Physical / Logical

UTILITIES: Tpump,Fast Load,Fast Export, TPT,BTEQ

BIG DATA STACK: HIVE,Spark

ETL TOOL: Informatica

REPORTING TOOL: Microstrategy Tableau

PRIORITY SCHEDULER: TASM

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship