Abhinav Onkar

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