OnBenchMark Logo

Gaurav (RID : qzyclisnqywh)

designation   Java Lead

location   Location : Noida, India

experience   Experience : 15 Year

rate   Rate: $14 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Shortlisted : 21
Total Views : 85
Key Skills
Java NoSQL ETL JSON PL-SQL Oracle DB APEX Mongo DB
Discription

GAURAV SHARMA

Technical Synopsis

Experienced in web application development, Data Modelling, DWH, Data Analysis and handling, DB development and Performance Tuning using Oracle, ETL technologies (informatica PC), NoSQL DB (Mongo DB), Shell Scripting, handling Big Data files using Hadoop technologies, python, jQuery, AJAX, Java Script, JSON, REST API with enriched technical and team management skills and experience with the exposure in a wide array of domains and international clients.

Currently working as Principal Consultant involved in technical, project and team management activities.

  • Long term onsite working experience in the UK and Norway.
  • B1 visa holder valid till 2026.
  • Working on various oracle web applications in three tier architectures.
  • Working on unstructured data storage and development using Mongo DB and JSON.
  • Working experience in End-to-End DB implementation using Data Modelling techniques.
  • Working on Data mining, migration and loading from the heterogeneous sources to the Oracle DB using ETL tool.
  • Working experience of migration of DBs from in premise to Cloud environment.
  • Working experience in handling DWH environments.
  • Working Experience on the storage and processing of various big data file format using Hadoop, Hive, PostgreSQL.
  • Have worked on Oracle Portal, APEX tools for rapid development of oracle web applications.
  • Constantly involved in conceptual, logical and physical data modelling.
  • Working with MOD-PL/SQL and OWA (Oracle Web Agent) packages.
  • To develop oracle scripts, PL/SQL packages, procedures and functions, views, triggers etc. for various business applications.
  • Develop WEB/REST APIs for accessing information of our DB from other applications.
  • Execution of different jobs to perform daily activities like DB upload using shell scripting.
  • Performance tuning of SQL queries and PL/SQL packages, routines.
  • Technical design documentation for existing applications based on reverse engineering.
  • Planning of team resources, work allocation and managing project work release.

IT Skills

Technical

  • Database : Oracle 11g, 12c, MySQL, PostgreSQL,
  • Methodology : Data Modelling, DWH, BI, Analysis, OORDB, RDBMS, DBMS, ETL, Agile.
  • Scripting Languages : Python, Linux Shell Scripting, PL-SQL, JSON, Java-script
  • API’s Used : J-Query, REST
  • Tools Used : PLSQL Dev, SQL Dev, PySpark, Atlas, Altova, Visual Studio, TFS, AUTOSYS
  • ETL : Informatica Power Centre
  • Data Modelling Tool : Oracle Data Modeler, Erwin
  • NoSQL DB. : Mongo DB
  • Big Data/Cloud tech : Hadoop, HBase, Sqoop, AWS
  • BI Tool : Tableau
  • Agile : Jira

Functional Activities

  • Co-ordination and interaction with business and functional owners of applications throughout the project lifecycle. Support ad-hoc requests.
  • Requirement analysis and come up with proposed technical solutions docs.
  • To create and manage conceptual, logical and physical data models.
  • Managing DWH data flow and managing future DB needs, memory management.
  • Peer review of software deliverables and other project related documents.
  • Co-ordination/calls with onsite manager for ongoing application releases/activities on daily basis.
  • Preparation of daily, weekly and monthly reports for project management matrix.

Technical Activities

  • Processing of Data files in various formats into the respective sources.
  • Uploading of Business Data files to the different applications using their native techniques.
  • Generate Summarized table for BI Reports.
  • Develop the application logic at DB side to enhance existing and add new functionality.
  • Version control of the application code across the different environments.
  • Handling Oracle database administration function involving:
    • Creation of database objects, including tables, indexes, views, materialized views, sequences, synonyms etc.
    • Generation of physical data models, tables, sequences, triggers.

Professional Experience

  • Duration
  • Oct’21- Sep’22
  • Oct’10 to Till Date

Company Name

Wipro Technologies (Wipro LTD.)

Designation

Principal Consultant Lead Consultant

  • Aug’08 – Sep’10

HCL InfoSystems Ltd.

Sr. Tech. Trainer

  • July’06 – Aug’08

NIIT LTD.

Tech. Trainer

Academic Qualifications<

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!