Hardik Oza Email & Phone Number

New York, Ny, Us

Delivering advanced business intelligence solutions leveraging the Salesforce Einstein/Wave Data Analytics framework. Develop and communicate best practices to team and internal community. Create project plan and deliver of status updates. Have oversight of project deliverable, principal design and development of advanced solutions. Lead requirement and design sessions with clients, uncover data gaps and advise on business intelligence best practices. Facilitate client-facing iterative review sessions with a focus on agile development.Primary responsibilities include understanding Visualization / Dashboard business requirements, architecting and designing wireframe, data integration strategy, design data workflow and integrate data in single source in Tableau CRM Platform. Creating datasets using dataflow, using replication to replicate data from various sources to T CRM Platform. Scheduling and monitoring the dataflow regularly to make sure no data discrepancies in datasets.

New York, New York

Delivering advanced data analytics solutions leveraging the Salesforce Einstein/Wave Data Analytics framework. Develop and communicate best practices to team and internal community. Create project plan and deliver of status updates. Have oversight of project deliverable, principal design and development of advanced solutions. Lead requirement and design sessions with clients, uncover data gaps and advise on business intelligence best practices. Facilitate client-facing iterative review sessions with a focus on agile development.Salesforce Data Analytics Lead / Architect (Wave / Einstein)• Served as the Einstein (Wave) data analytics lead for multiple clients in past 4.5 years.• Primary responsibilities include understanding business requirements from customer, architect and designing data integration strategy, design data workflow and integrate data in single source.• Created various analytical dashboards to enable slicing and dicing of data, which provides in depth data visualization experience to client.• Additionally, created project plan, managed offshore team and executed the project in very agile method.Salesforce Integration Delivery Lead• Served as the Salesforce Integration Lead and responsible for Integrating Salesforce with multiple external systems with Comcast.• Architected and designed Data Integration patterns for Comcast to Integrate and migrate data from various external source systems to target Salesforce Platform using Various Design Patterns.• Designed Data Integration of Salesforce with external systems using SOAP Web services using heavy XML data exchange.• Did complete Application Performance Profiling of Salesforce using Nova suite profiler and pinpointed performance bottlenecks like Max Heap Size , Webservice call out failures , Concurrency Issues and suggested solution to resolve it with team to bring up the application performance to acceptable level.

The primary role is to architect and build data discovery, Data Quality and Master Data Management Solution to enable effective decision making for targeted business outcomes.Architect , Design and Implement Data Profiling and Data De-Duping , Data Cleansing and Data rationalization using Microsoft Data Quality Service ( DQS ) for Products and Customer ( Account ) Data. Architect , Design and Implement Master Data Management solution using MDS ( Master Data Service ) using Microsoft Platform for Product and Customer entities.Implement best practices for Business Intelligence and Data Warehousing.Work with the business users to define business requirements and develop and implement new BI solutions.Participate in projects: Business Intelligence and Data Warehousing, Technology Rationalization, Application Development and Integration, System Implementation and Migration.Enterprise Architecture and Data Engineering for all business systems including PLM, ERP, Sales, Finance and HR.

United States

Salesforce Data Integration / Migration Lead• Served as the Data Hub Lead responsible for Integration / Migration of Legacy systems data to Salesforce.• Architected and designed Salesforce Data Integration Platform (Data Hub) using ELT framework to Integrate and migrate data from various legacy source systems to target Salesforce Platform either real-time of in batch mode.• Understand source System and target (Salesforce) data models , map various data entities , attributes from source systems to target salesforce system to Integrate and migrate Data. • Creating design / framework for migration of the data and designing strategy to get real time updates from Legacy Systems to Target salesforce System.Salesforce Data Integration & DQ Lead• Served as the Data Hub Lead responsible for Data Quality and Data Integration of Legacy systems data to Salesforce.• Working with business representatives on requirements to identifying critical data elements for Data Quality, Business rules and Data workflows to creating Data Quality Framework for Salesforce Platform.• Creating framework for data discovery, data cleansing and data de-duping to integrate cleansed data from source system to Salesforce Platform.• Resolving the data ambiguity at the source level in order to provide cleansed data to the subscriber to avoid any future redundancy and de-duping Salesforce.

Upper Saddle River,Nj

Data Virtualization and Data Integration Architect ( Salesforce )• Served as a Data Lead responsible for data virtualization/federation of the multi geography data for china , Australia and federate/virtualize the data as per target systems need for salesforce and Oracle EBS. • Designed and implemented data virtualization solution by federating 5+ source systems and providing virtualized view to various Salesforce to consume / publish data using various data design patterns real-time.• Understand various source systems data entities and attributes, rationalize it and mapping it to the target Salesforce Platform Model salesforce system and Oracle EBS.• Consume data from source systems in various data formats and provide single view to target system and helping them to consume it using various data patterns like RPC , APIs ,XSLT transformations and csv consumption.Data Modelling and Master Data Management ( Salesforce )• Served as a Data Architect responsible for creating master data management platform for core reference data entities like Accounts, Products and Locations.• Analysis of various source systems entities and attributes rationalize it and create Enterprise Data Model for Accounts and Products which serve as EDW for Master Data Management Platform.• Brainstorming session with business and identifying and creating single source of systems for core reference data entities for accounts and Products.

Greater New York City Area

• Rationalization of around 350+ Data attributes from 3 Legacy Accounting Systems.• Creation of Universal Account Reference Data Model.• Creating Centralize Data Dictionary/Meta Data for 350+ Attributes.• Creation of Rationalize Canonical Data Model (XML) to distribute the data to various downstream systems using Message Bus via Publish & Subscribe Mechanism.• Creating Data Migration Design for migrating Legacy Data from 3 different systems to IM systems in Oracle.• Creating/Defining Business Terms and codes to centralize complete code values within all the publishing and subscribing systems.• Creation Conceptual and Logical Data Model for 150+ attributes.• Creating Physical Data Model for 150+ Attributes.

Pune Area, India

• Consolidation of Sybase databases in MAPS and XMAPS applications into a single Sybase database.• Migration of this consolidated database in Oracle.• Reviewing Stored Procedures, Functions & Database Triggers.• Performance tuning of the new Oracle Database Objects like Stored Procedures, Functions and Triggers. Reviewing / creating appropriate Indexes to make sure that the SQLs are performing at its best.• Design OTG Process to synchronize the migrated Reference Data between migrated Oracle Environment and non-migrated Sybase Environment.• Preparing Project Plan and Execution Strategy for Data Consolidation & Data Migration from two Sybase Source Systems to Target Oracle Database of around 100 GB of Data.• Resource allocation and Resource Utilization for the Project.• Budget Planning and Estimation for the JPMC ADR from Database Perspective.• Implementation of the best quality process for the Project and make sure that all the team members adheres to the same.• Onsite / offshore co-ordination for requirement and regularly updating the status report• Proper Work distribution and work allocation to the offshore team.• Sybase Code Consolidation Migration to Oracle around 1500 Stored Procedures.• Performance Tuning of PL/SQL Stored Procedures & Functions.• PL/SQL Coding & Code Review.• Technical Guidance to the Team.

Pune Area, India

• Creating Task order for the Project and Budget Planning for Market Data Console Project.• Estimation of the complete Project using Use Case Method.• Team creation and defining roles and responsibilities for each of the team member.• Onsite / offshore co-ordination on daily basis to understand the requirement & Issues.• Issues Resolution for the team and for the complete Project.• Helping team in Requirement Analysis & Design.• PL/SQL Coding & Tuning Activity.• Code Review & Unit Testing.• Technical Guidance to the Team• Preparing Project Implementation and Roll out Plan for multiple releases in the year for MDMU.

Pune Area, India

• Creating and Building complete Team at offshore for PNC HCA Project for Execution.• Creating Task Order and Creating Work Breakdown Structure for the Project.• Estimation of the project using Use Case method for PNC HCA.• Project Planning and creating WBS Structure for the Project at offshore.• Creating Traceability Matrix and tracking Functional and Non- Functional Requirement.• Regular Onsite & Offshore co-ordination for better execution of the Project.• Issue Resolution and Risk Tracking for the Project on regular Basis.• PL/SQL Coding & Tuning Activity.• Technical Guidance to the Team• Creating Project Implementation and Project Rollout Plan in multiple phases.

Duisburg Area, Germany

• Customer Interfacing and Customer Interactions at Onsite.• Resolutions of queries & questions posted by offshore team to Customer.• Discussion on engagement between iGate & Metro MGI for further prospects and for new business move.• Creating Complete Release Plan from Requirement Gathering till Production Move.• Creating Plan for Production Support.• Customizing/Creating Functional Specifications Template, Technical Specification Template, Test Scripts Review, Peer Review Template, and Test Plan & Test Cases Templates according to the project requirements.• Creation of Capacity Utilization Plan for each Release.• Requirement Analysis and Database Design • Onsite & Offshore co-ordination • Writing PL/SQL Stored Procedures & Functions• Unit Testing and Regression Testing of the System• Handling Customer issues & escalations for current Projects.• Technical Guidance to the Team.• Coding / Unit Testing / Code Review & Defect Fixing Activity.• PL/SQL Coding & Tuning Activity.• Technical Guidance to the Team.

Ahmedabad Area, India

• Design Oracle & Java Application• Performance Tuning of Oracle Database Objects• Construction activity for J2EE Projects.• Code Review , Code Tuning and Performance Tuning of J2EE Code.

Vadodara Area, India

• Involved in designing and coding. • Developed Forms and Reports using Developer 2000 and Designer 2000. • Writing Procedures that will calculate Payroll Calculation, Functions that will calculate dynamically all the heads applicable for employee. • Triggers Required in Database Design using Oracle PL/SQL. • Developed the Package for HRMS Module. • Generating the Scripts for Database Creation, which can be used at client side for database creation? Writing triggers required for automatic updates using Oracle PL/SQL. • Developed the Package for Purchase Module. Generating the Scripts for Database Creation, which can be used at client side for database creation.

Master Of Computer Applications, It, 85%

Bachelor Of Science, Statistics

High School, Science