PROFESSIONAL EXPERIENCE

1. North America Solution Hub

Company
Oracle India Private Limited
Tools
Oracle Database 12c, Oracle Golden gate 12c, ODI 12c
Team Size
25
Duration
Nov’17 till now
Role
Senior Solution Engineer

        Responsibilities:

    • Perform POC on latest oracle products
    • Providing demos and presenting the latest demo to the customer
    • Problem Solving
    • Consulting
    • Attending conferences with Product team for discussions on products

2. ER6/ER8/MR2 – Data Warehousing Retail project (Development & Designer):

Client
Morrisons
Company
Mastek India Private Limited
Tools
Oracle11g, Oracle Data Integrator(ODI) 11g/12c, Oracle Golden Gate 11g, OBIEE 11g, OLAP AWM 11g, Microsoft Visio 2010
Team Size
25
Duration
Aug’10 till Oct’17
Role
Technical Specialist, Development, Designing and Requirement Gathering

        Description: 
MORRISONS is Retail Supply chain having network of Stores, Warehouses, and Suppliers in UK. Evolve is an IT transformation program aimed at optimizing efficiency of operations across stores, warehouses, head offices. As part of evolve, a central retail data warehouse is being developed to provide analytical capability to the end users.
The objectives of the evolve program are – 
    • Single web based system to access information
    • Consistent information, governance and control
    • Improved decision making based on exception reporting
    • Self Service BI, pattern detection & predictive Analysis
Mastek is providing the Data Warehousing solution by bringing the data from Vertical Systems i.e. RMS (Retail management System), WMS (Warehouse management System) and WES (Voice). It is being done using Oracle Golden Gate, Oracle Data Integrator and OBIEE.
Responsibilities: 

    • Client interaction during requirement/design walkthroughs, User Acceptance Testing.
    • Managing Offshore Resources from Onsite.
    • Making understand of the requirements to Offshore.
    • Reviewing Business objectives, Understanding the Business processes and the feasibility study for implementation.
    • Creation of Interface programs i.e. PL/SQL packages as per the Technical Design Documents.
    • Creation of Interfaces, packages and procedures using ODI.
    • Internal Review of Technical Design Documents and codes.
    • Configuration Management of elements through check in – check out requests and ensuring the integrity of elements for given project functionality.
    • Supporting the UAT users.
    • Understanding the strategies to pull data from Vertical system to DWH via ETL and Golden Gate.
    • Attending Defect Prevention Meetings and discussion on trend charts.
    • Worked on creating procedures/Packages, complex logic SQL, materialized views, dimensions, query rewrite in Oracle database 11g.
    • Worked on performance tuning of ODI interfaces and packages.
    • Developed Design mappings and ETL mappings with process flows.
    • Designed Cubes in OLAP AWM 11g.
    • Developed RPD and dashboard in OBIEE 11g.
    • Was the Release lead at Onsite.
References: Available on request

SUMMARY:
    • About 9.5 years of work experience including 3 years Onsite (UK) on Oracle and ETL tools.
    • Excellent conceptual skills in writing SQL, PL/SQL, Stored Procedures using Oracle.
    • Excellent Skills on ODI (Oracle Data Integrator) and Oracle Golden Gate.
    • Excellent Skills on OLAP.
    • Knowledge of working with Shell scripts and workflows.
    • A highly motivated, energetic individual and a team player with excellent communication and interpersonal skills.

CORE COMPETENCIES:
    • Highly committed towards meeting project deadlines.
    • Possess strong problem analysis skills with ability to follow project standards.
    • A quick learner by traditional and conventional methods.
    • Working hard by holding responsibility and dedication.
    • Good oral/written skills and interpersonal skills.
    • An organized self-starter requiring minimal supervision.
    • Sound in basics of technology.
    • Ability to work in a group and adapt quickly to new environments.
    • Good team player with excellent interpersonal skills and positive attitude.

SOFTWARE PROFICIENCY:    
    • Databases                                 : Oracle 12C
    • ETL Tools                                : ODI(Oracle Data Integrator) 11g, 12C
    • Change Data Capture Tools     : Oracle Golden Gate 11g, 12C
    • OLAP Tools                             : Oracle AWM 11g
    • Design Tools                            : Microsoft Visio 2010
    • Source Code Control Tool       : Tortoise SVN, Atlassian Bit Bucket, GitHub
    • DevOps                                    : Jenkins
    • Others                                       : Ravello Cloud Systems, Google Cloud, Oracle Cloud
    • Big Data                                   : Hive, HDFS
    • Programming Language           : Core Python

ACADEMIC QUALIFICATION:
    • Bachelor of Engineering in Information Technology from Mumbai University, Mumbai

CURRENT EMPLOYMENT:
    • Organization               : Oracle
        ◦ Duration           : November 2017 to till date
        ◦ Onsite Duration        : 2 Weeks
        ◦ Total Experience      : 10 months
        ◦ Onsite Location        : United States(US)

PREVIOUS EMPLOYMENT:
    • Organization               : Mastek LTD
    • Duration               : March 2010 to October 2017
    • Onsite Duration              : April 2012 – March 2013
                                                           : October 2014 – September 2015
                                                           : June 2016 – September 2017
    • Total Experience            : 7.8 years
    • Onsite Location              : United Kingdom(UK)

ACHIEVEMENTS:
    • Got three times Mastek high recognition “Stellar Award” in span of 5 years.
    • Got multiple Spot Recognition Awards.
    • Got Delivery Excellence Award.
    • Appreciation from Morrisons (UK) for successfully delivering ER6.
    • Got Key player of the year FY19 award in Oracle 
    • Got multiple Customer appreciation in Oracle 
    • Got multiple appreciation in Oracle Newsletter

CERTIFICATIONS:
    • Oracle Cloud Infrastructure 
    • Oracle Autonomous Database