Harish Panchal

Provide Snowflake based solutions to client

Helped client with building an Enterprise DW.

Helping the client with their 2nd phase requirements and enhancements of Snowflake cloud DW.

Helped client with Snowflake instance security setup. POC of migrating specific subject area objects from on premise SQL server to Snowflake, loading of source flat files and crude oil prices API data to Snowflake

Helped the client with integration of products and orders data between Hybris, JDE and SAP for their EU and UK online parts stores.

Helping the client with POC of migration from Teradata to cloud based Snowflake DW

Helped the client with conversion of Functions/Queries to Snowflake based javascript stored procedures

Helped client to integrate rental data between Hybris and JDE using Informatica Cloud technologies

Helped the client with migration of their DW from Teradata to Snowflake Cloud DW

Helped the client with design/building and loading of constituents and donation data from SalesForce CRM, Blackbaud and Unica into cloud DW on Snowflake using Informatica Cloud.

Helped the client with building and loading subscription, orders and products data from Magento into Snowflake, a cloud based DW environment.

Helped the client with architecture and build data integration framework within Informatica Cloud to sync product and orders data between SAP, JDE ERP and their ecommerce Hybris application.

Learnt ETL development within SnapLogic, Snowflake Cloud Data warehouse. Informatica Cloud – Online training from Informatica. Learnt Data Synchronization, replication and mapping configuration. Real time guides and process with Salesforce data. Hadoop – install and configure apache and Cloudera Hadoop ecosystems. installed Hadoop HDFS, Yarn, Hive, Oozie, Spark, Zookeper, sqoop and Hue. POC of extracting data from LinkedIn profiles and groups and load data to Hadoop HDFS with Informatica ETL

Helped the client with setup of Informatica 10.0 DIH, PowerCenter and B2B servers. Deigned and developed ETL process flows and code to load Patient and Clinics survey data from files uploaded via B2B portal. Also designed and created ETL code to automate maintenance of B2B Partner, Account and profiles using WEB API and Sales Force data.

Helped the client with design, development and implementation of new dimensions and fact tables in DW to capture Purchase and Customer data from their order management source system using Agile methodology. Also helped the client with design of ETL logic for customer address cleansing and de-duplication. Mentoring and doing code review of team members. Technologies: Oracle, Informatica Power Center and Power Exchange Express for Oracle, PL/SQL, Unix, Windows, Toad, Jira.

Worked on a project to consolidate all Enterprise Asset Management solution applications of its subsidiary company into a single application - Ventyx Asset Suite 8 (EAM). This was done by converting existing applications’ data to fit new target application table structures. Designed and build appropriate ETL to load historical data from all other source applications. Designed JSS schedule flow and wrote Unix scripts to automate data conversion and data loads.

Helped the client with design and development of near real time DW. Data was sourced from their JDE, Lease Administration, Work Order, Client Property, Financial Management and Project systems using relational databases, Web services, CDC, Flat and XML files methods. Did source data analysis, source to target field mappings and documented the designs. Wrote Power Center ETL code to load data warehouse from various data sources. Used agile methodology for the development of DW.

Did feasibility study and impact analysis of enabling month end processes, for DW positional fact tables, during non month ends and archiving of old history from some of DW tables. Provided multiple strategies/solutions and documented the analysis results.

Represented implementation partner company to do knowledge acquisition to capture and document information on various source systems and logical/physical models for Enterprise DW. Completed a full life cycle project to source GEOGRAPHY master data and load into enterprise data warehouse. Assisted project manager with identification and time estimation of each task on the project

Data Modeling and designing of DW fact and dimension tables. Worked on multiple projects to add new business functionality to the data warehouse.