SUMMARY:

• Data Warehouse / Big Data Lead & Architect with demonstrated expertise in Leading Projects, Data Warehouse Architecture & Design and People Management.
• Proficient in leading delivery teams, design, reviews, implementation and Performance tuning
• Extensive noledge of all components of Big Data & Data Warehousing (Data Modeling, ETL, BI, Data Lake, AWS Technologies)
• Skilled at utilizing Agile methodologies for development / creating storylines / leading scrum etc.
• Deploy near real - time DW on AWS using Kinesis, Lambda, Data Pipeline, Redshift, and Elasticache for big Telco firm.
• Lead Design / Perf Optimization team at Astra Zeneca for AWS Redshift / Data Warehouse enhancements
• Lead migration of on premise datamart to snowflake. Migrate data structures / Data Integration artifacts.
• Lead Micro cluster Migration project at Amazon (Migrate multiple Data Warehouses into a 10 Rack cluster having 400 TB space.
• Lead Oracle BI Financials team at Amazon

PROFESSIONAL EXPERIENCE:

AWS Solutions Architect

Confidential

Responsibilities:

• Solutions Architect for enhancing / deploying new data warehouse / data lake solutions
• Reengineer existing Jobs Infrastructure to reduce operational costs in AWS by 80%
• Build DataLake in S3
• POC Snowflake as an alternative to Redshift / sql server data warehouse environment
• Migrate Sales Data Mart from Redshift to Snowflake (data Structures, Data Intregration artefacts).
• Achieve 65 % cost reduction by using Snowflake Instead of RedShift (On Demand) for high concurrency (500 queries) Sales Commission Data Mart using Auto Scaling.
• Migrate on premise sql server data warehouse to Redshift on AWS.

AWS Solutions Architect (Big Data)

Confidential

Responsibilities:

• Serve as SME for AWS technologies (Redshift, Data Pipeline, EC2 )
• Guide team members reg AWS best practices
• Design & Build Data pipelines to load ecoupon / Redemption data from Flat files / Redshift into Oracle / RDS Databases.
• Optimize Redshift table design (Compression, sort keys, dist keys, join columns, query plan etc)

AWS Big Data Architect

Confidential

Responsibilities:

• Project scope was to build replace in house cloud based platform for Customer Timeline with AWS technologies so dat it can become a separate product
• Serve as SME for AWS Big Data technologies.
• Build Lambda Architecture (Batch & Real time reporting) using Kinesis, Kinesis Firehose, S3, Redshift, Elasticache, AWS Data Pipeline, EMR
• Guide Comcast team members reg AWS best practices
• Build POC for migrating existing memsql based Data Warehouse to Redshift

AWS Big Data Lead

Confidential

Responsibilities:

• Lead 4 member team to design, build & deploy optimized data structures in AWS Redshift for Sales Data Warehouse.
• Serve as SME for AWS Redshift
• Deploy WLM & User Groups / Query Groups in Redshift
• Optimize usage between Dense Storage and Dense Compute Clusters. Migrated 15 TB of data from Dense Compute to Dense Storage Clusters (with 80 % performance) at one third teh cost.
• Design Redshift Spectrum for large infrequent workloads

Sr. Data Warehouse Architect / Lead

Confidential - Seattle WA

Responsibilities:

• Created project plan, analyzed effort estimate and lead 6-member team to successfully complete teh project.
• Reengineered ETL, OBIEE components, which were written for Exadata to run on regular Cluster setup.
• Project completed on time and on budget
• Manage QA, prod implementation and post production support for all data warehouses migrated to cluster.
• Manage all Customer communications and trouble tickets for teh project.
• Lead 2 member team to design, pilot and implement encryption processes for storing /retrieving critical /highly classified data related to Amazon customers / suppliers as well as internal unpublished financial info.
• Create data lake in EMR (AWS private cloud) for handling Unstructured / ION / JSON files from Amazon Tax source systems
• Design / Deploy data warehouse in HIVE for Audit Reporting
• Design / Deploy process to archive data in Amazon RedShift.

Data Warehouse Lead

Confidential

Responsibilities:

• Created Data Integration architecture and overall Data Integration design of Telco prepaid components
• Collect Requirements, Design and Lead team to build Prepaid Revenue Module for NII.
• Reviews Data Integration project deliverables in order to ensure compliance with Architectural Standards and meeting SOW deliverables list
• Lead 10 member team (Onsite / Offshore) in creating Physical Data Integration models, ETL components, Unit Testing and Documentation for prepaid components
• Capabilities of teh NII BI Data Warehouse Solution include
• A Single source of truth for data across all Latin American Markets in which NII operates
• Retire various Metric definitions used for teh same metric (ex Revenue). Standardize metric definitions within and across markets
• Serve as Data Repository for all Usage, Revenue Information
• Homogenize data across various systems (Billing, Networks, Rating, Recharging, prepaid systems)

Data Warehouse Lead

Responsibilities:

• Understand Cognos Planning Publishes and support Data Architect in creating Schemas to support reporting
• Serve as teh SME for Cognos Planning Publishes and communicate requirements between Reporting, ETL and planning team.
• Design overall ETL Architecture, ETL Components and led 6 team members in Implementing Informatica based ETL Solution.
• Capabilities of new Cognos Planning / Reporting suite for Disney Studios include
• Retire existing SAP BPS (SAP Planning tool) and Implement Cognos Planning / reporting suite
• Create plan for various sites with multiple versions. Publish multiple versions separately andCapable of fine tuning teh publish tables to suit ETL needs
• Ability to perform Ad-Hoc reports, compare plan / actuals data between various sites.

ETL Lead / Data Architect

Confidential, Mountain view, CA

Responsibilities:

• Analyze teh existing complex views to understand teh business rules and requirements.
• Create Star Schemas to support teh reporting requirements
• Led 3 member ETL Team to come up with ETL Design Documents, ETL Architecture and Tech Design document for 9 Star Schemas
• Review teh design documents prepared by team, provide feedback, share with Clients and get necesssary approval for Development work.
• Led teh ETL Team in Development of ETL components for teh 9 star schemas which load data from GHR source systems into HR Data warehouse. Provide Effort, Schedule estimates with development using KETL.

DW ARCHITECT/ ETL TEAM LEAD

Confidential, Dallas, TX

Responsibilities:

• Performed Requirements Analysis to add new Star Schemas to Siebel Analytics.
• Designed Logical and Physical Data model for teh new Star Schemas.
• Designed and Implemented Overall ETL Architecture except for Siebel Analytics.
• Provide high level ETL Design to team members, perform code reviews, aid in system test plan development and system testing.
• Capabilities of Customer Value Management project include
• Consolidate customer data from Subscription, Advertisement, Preprint data, and Belo customer interactive websites to identify potential customers. USPS address data (CDS) for Dallas region was used to identify list of potential addresses dat can be targeted.
• Customers with no solicit constraints like Do not Call, Do not Mail, Do not Email can be identified and excluded from campaigns.
• Led 4 member ETL Team in Development of Staging, EIM and DW loads to Siebel Analytics. Provide Integration plan for all ETL components, Implement ETL components & workflows, and review for functionality, performance and interoperability with Siebel components
• Performance tuning of Data Warehouse components (Oracle & Informatica) during UAT /Production Deployment

ETL ARCHITECT/TEAM LEAD

Confidential, Irving, TX

Responsibilities:

• Managed a 12 person ETL Team in development, maintenance and implementation of Workflow, PL/SQL & Korn scripts for real-time ODS & DW loads.
• TEMPEffectively performed as team lead.
• Successfully managed and executed integration and transition of MDR ETL Phase me, II to UAT, and subsequently to production.
• Led ETL performance tuning team (DB & Informatica) in achieving terms of service level agreements. Accomplished significant reductions in ETA’s for both real time ODS loads and DW.