Vikrant Pathode Email & Phone Number

Expertise in handling errors using Google Cloud Platform (GCP)  in Analysing and implementation of the project.Worked on google cloud platform (GCP) services like compute engine, cloud storage and cloud SQL also involved in Development of BigQueries.Knowledge on GCP other services like Data Fusion,Dataflow,Data Functions,DataProc,Composer.Wrote complex GBQ Queries using Joins, sub query and inline views to retrieve data from the database.Experience in writing complex GCP Queries, GBQ Code(Group by functions, Analytical (functions, Co-Related Sub Queries and Inline views).Expert in creating SQL Queries, IICS Mapping, CA Jobs, stored procedure, Informatica Workflow, Netezza Query and Unix.Experience also in Dynamic SQL, Materialized view, ref cursor of SQL/PLSQL.Good working knowledge on Tables, Data warehouse , Oracle Database, Informatica .Knowledge on Performance tuning like INDEX, BULK COLLECT, BULK BINDING, EXPLAIN PLAN, TKPROF And DBMS_PROFILER in SQL/PLSQL.Devised experience on writing SQL, PLSQL code using Aggregations, CTE, Joins, Views, Analytical functions, Materialized Views, Regular Expressions to perform ETL Processes. Developed the scripts to load data into the staging tables from the flat files.Knowledge in Data Loading through Unix for History Load.Created scripts for Data Migration from one table to another.Good Hands-on experience in PL/SQL and GCP tool.Good experience in Informatica. With the help of Informatica I have worked on control flow and data flow.Maintained metadata models and complex ETL packages and OLAP cubes using Informatica.Experience in Power BI development.Developed visual reports, dashboards and KPI scorecards using Power BI desktop.Basic Knowledge in UNIX.

• 

  Shri Sant Gajanan Maharaj College Of Engineering, Shegaon

  Electrical, Electronics And Communications Engineering