Abhinav Onkar

Abhinav Onkar

Trainee/Software Developer

Followers of Abhinav Onkar204 followers
location of Abhinav OnkarPune, Maharashtra, India

Connect with Abhinav Onkar to Send Message

Connect

Connect with Abhinav Onkar to Send Message

Connect
  • Timeline

  • About me

    Snowflake | Data Engineering | Oracle SQL-PL/SQL | Database Designer-Developer | Unix/Python Scripting | Oracle Cloud Infrastructure Certified

  • Education

    • G.H. Raisoni College of Engineering(GHRCE), Nagpur

      2006 - 2010
      Bachelor's degree ENGINEERING
  • Experience

    • CMC LTD

      Jun 2010 - Nov 2011
      Trainee/Software Developer

      • Have worked as version manager and creating VSS scripts to automate the deployment process for testing environment.• Worked as deployment manager and handled production deployment of code and fixing the issues in deployment.

    • CBT

      Nov 2011 - Aug 2012
      PL/SQL Developer

      • Providing MIS requests solution through Oracle Sql/Plsql queries as per business requirement for Telecom domain. • Writing SQL/PL SQL queries, creation and modification in database objects such as procedures and cursors, functions, exceptions used in Reports.

    • Rajdeep Info Techno Pvt. Ltd.

      Aug 2012 - Jun 2013
      Software Developer

      • Writing PL/SQL Blocks like Procedure, Functions, Cursors, Triggers as per requirement.• Creating Views for the Reports.• Analyzing & modifying data in database if any mismatch.• Have worked on automating the creation of schema replica using DBMS_SQL package

    • Experis

      Jun 2013 - Jul 2014
      Software Developer

      • Creating & modifying PL/SQL blocks like Packages, Procedure, Functions, Cursors, Triggers for the new requirement.• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.• Providing support by Remedy application with analyzing Unix Shell Scripting & PL/SQL blocks and updating the data in database.• Performed SQL and PL/SQL tuning by using EXPLAIN_PLAN.• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger. Show less

    • Cognizant Technology Solutions

      Jul 2014 - Sept 2015
      Project Associate

      - Creating & modifying PL/SQL blocks like Packages Procedure, Functions, Cursors, Triggers for the new requirement.- Performed SQL and PL/SQL tuning by using EXPLAIN_PLAN.- Providing support by Remedy application with analyzing Unix Shell Scripting & PL/SQL blocks and updating the data in database.- Analyzing & modifying data in database if any mismatch.

    • SphereGen

      Dec 2015 - Mar 2022
      Senior Software Engineer

      • Worked on migrating to Snowflake with COPY command using internal and external stage• Worked on creating clone objects from production in Snowflake to maintain zero copy cloning for code modifications and testing.• Creating complex Snow SQL queries for business analysis and reporting.• Designing data ingestion framework in Snowflake for both batch and real time data from different file formats (CSV, XML, JSON) using Snowflake Stage and Data Pipe.• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like SQL Navigator.• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.• Involved in the continuous enhancements and fixing of production problems.• Requirement gathering & understanding the visibility of requirement, designing Database accordingly.• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.• Partitioned the fact tables and materialized views to enhance the performance.• Extensively used bulk collection in PL/SQL objects for improving the performing.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.• Develop new SSRS report and modify existing SSRS report as per the business requirement, identifies critical integration issues with Oracle database and develop corrective solutions.• Worked on Oracle forms and Oracle reports in project to convert in SSRS.• Worked on Oracle Cloud to migrate on premises infrastructure on oracle cloud.• Worked on Python scripting for data processing in database. Also have exposure to python libraries like Pandas, Numpy. Show less

    • Atyeti Inc

      Mar 2022 - Jan 2023
      Senior Database Developer
    • LTIMindtree

      Jan 2023 - now
      Senior Specialist - Data Engineering
  • Licenses & Certifications

    • SnowPro Core Certification

      Snowflake
      Aug 2022
      View certificate certificate
    • Oracle Cloud Infrastructure Foundations 2020 Certified Associate

      Oracle
      Apr 2020
      View certificate certificate
    • Oracle Autonomous Database Cloud 2019 Certified Specialist

      Oracle
    • Oracle Cloud Infrastructure 2019 Architect Associate

      Oracle
      May 2020
      View certificate certificate