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.

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.
• 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.

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 (.

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.
• 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.

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.
• Served as a Data Architect responsible for creating master data management platform for core reference data entities like Accounts, Products and Locations.

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.

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.

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.

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.

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.

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.

Master Of Computer Applications, It, 85%

Bachelor Of Science, Statistics

High School, Science