Pradip Joshi Email & Phone Number

Hong Kong

Los Angeles, Ca, Us

• Technical Lead for enterprise data warehousing initiatives by driving requirements gathering, analysis, design, functional/technical specification, development, deployment and testing.• Support, maintenance, enhancement, managing/tuning existing data warehouse using Amazon Redshift, Syncsort, Amazon S3 and Python/Shell scripts. • Design/build/maintain ETL data pipelines to/from Amazon Redshift including sources such as 3rd party API, Oracle, Sql Server, Postgress and Mysql. • Designed and implemented alert system for tracking data issue, data quality and consistency. • Partnered with analysts and stakeholders to gather, understand and develop technical requirements and plan projects from concept to completion.• Developed a new data mart for Inventory management system using Oracle, Amazon Redshift and bash scripts. • Developed a python script to load data in an automated way from Google sheets to Amazon Redshift. • Developed data model for landed cost for the retail items and integrated with existing finance data mart using Amazon Redshift• Developed a data mart for fraud orders and new dynamic reporting on existing current data to help fraud team to catch the fraudulent orders. • Performance improvement of tableau data extracts/Live queries

• Responsible for the overall BI & DW solution architecture, design, development and implementation leveraging Enterprise BI & DW platform and architecture.• Tuned existing Materialized Views queries to run in 30 minutes from 7 hours.

San Jose, Ca, Us

• Technical lead ,designer, developer for numerous data warehousing, financial processing, data visualization and reporting infrastructure back end applications. • Performance tuning of the ETL process to scale the increased Data capacity and meet the defined SLA for reporting • Collaborating with engineering teams , business teams , product managers, data scientists and BI analysts to understand data requirement and design end to end solution right from data acquisitions from multiple sources to data visualization using Oracle, Teradata , Hadoop Hive, Sqoop and Perl/shell scripts and Microstrategy.• Worked with data scientist team to develop data load processes to acquire data from multiple sources and transformation and push to Hadoop/Hive to meet their ongoing need for algorithm development. • Design and develop the process for the data integration with eBay using Oracle, Teradata, bash scripts and Hive.• Identified and addressed root cause for data quality/anomalies issues in data marts.• Identified and addressed performance/bottlenecks issues in data marts ETL process for Microstrategy based data marts. • Designed and developed and modified existing DWH ETL process to cater for a new attribute device type (Smart Phone/Tablet) in all data marts. • Develop a framework for financial process and dependent DWH processes to handle backlog gracefully in automated way using Oracle PL/SQL.• Design and develop 3 new DataMart for sku Analytics reporting using Microstarategy, Hadoop/Hive ,shell scripts and Oracle PL/SQL• Design and develop a process for uploading finance data to Oracle DB (input Excel sheet) using Oracle Express.• Tech lead for DWH Oracle 11g upgrade. Implemented successfully and addressed query performance issues.

San Jose, Ca, Us

• Architects and prototypes A Data Warehouse model for Cisco's devices to track hardware failures and overall performance of Cisco Supplied hardware using SQL-LOADER (DIRECT PATH), PL/SQL and Oracle processing upward of 10,000 transactions per second. Design of ETL architecture, Dimension and facts tables. • Install Hadoop/Hive on 5 node clusters for POC. Developed process for extracting data from Oracle to HDFS.

Provide the guidance to lead application teams in the proper leveraging of database technology and performance.Evangelize the technologies, solutions, and best practices developed within the organization.Daily responsibilities include Data Modeling , Design Large Scale systems, Performance Tuning , Capacity Planning , Replication , etc

• Shopping.com(SDC), an eBay company, pioneered online comparison shopping among the internet buyers. SDC's clickstream data is processed by homegrown ETL processes using PL/SQL , SQL-Loader and perl/Shell scripts which processes 100 mn rows per hour. Maintain/bug fixing/enhancement/performance tuning and production support for data warehouse ETL processes. • Database Tech lead/Developer for wallet project where SDC users are provided shopping cart functionality. Worked with Middle-Tier and front End team . Developed Functional and Detail Design Specifications and test plan. Added new objects and PL/SQL Code to support the wallet functionality. Tuned the code using sqltrace and tkprof. • Database Tech lead/Developer for Sunshine project where SDC deals are offered on ebay. Developed Functional and Detail Design Specifications and test plan. Modified existing etl process and added new PL/SQL packages to support functionality . Tuned the code using sqltrace and tkprof.

• Marketing Performance Dashboard (MPD) is a reporting and analysis tool for marketing data such as Sales Revenue, campaigns, leads, opportunities and activities. Marketing data is organized as multidimensional data source in Oracle analytical workspace, and each measure is dimensioned by its associated metadata.• Designed and developed MPD data warehouse using Oracle database 9.2.x.x , Oracle Warehouse Builder.• Implemented multi dimensional database using logical and physical data modeling techniques (Star schema) . ETL mapping to source system and data warehouse • Maintained repository for metadata using Oracle Warehouse Builder. Data Modeling with Oracle designer.

• Lead team of 8 through the development life cycle of above back-end data load processes using PL/SQL, Oracle 8i,Unix shell scripts, Perl and Java and TOAD from eQuest Software. • Required coordination with 12 different teams spread all over HP'S global territory.• Developed a data load using PL/SQL, SQL-Loader, and cron jobs calling Unix scripts to process catalog deal data in flat files received from Europe region.• Developed a data load using PL/SQL, SQL-Loader, Perl and cron jobs calling Unix scripts to process premerger Compaq products attributes data in flat file format.• Migrated a data load from Global Pricing Server from Perl and Oracle to PL/SQL, SQL Loader.• Developed PL/SQL procedures for migration/merging of Compaq catalog data with eComcat.• Developed data load processes using PL/SQL, SQL-Loader, Perl and cron jobs calling Unix scripts to process data received from HP'S legacy system such as WWTBL(worldwide Table systems), PATSY (Worldwide Purchase Agreement and Discount Systems).

Diploma, Database Management System

Ms, Statistics And Operation Research