Abhijeet Raut
Mobile:+91 9699849569
Email: rautabhijeet129@[Link]
PROFESSIONAL SUMMARY:
Working experience of 3+years on Oracle SQL, PL/SQL database applications which
involve Development Life Cycle (SDLC) like Analysis, support, Development and Testing
of applications in PLSQL, SQL
Experience in software development and maintenance of Oracle 10g/11g applications
Experience in Creation of Tables, Indexes Constraints using SQL and PL/SQL.
Extensively worked on Backend Programming using PL/SQL stored Procedures,
Functions, Packages, Database triggers, Exception Handling.
Expertise in creating Schema Objects like Table, Views, Joins, Sequences, and DML
statements.
Good in WITH Clause, analytical and aggregate function, hierarchical, SET operators
Extensive experience in using Cursors and Ref-cursors for processing of data.
Ability and willingness to learn new technology and acclimatize to any work culture.
Excellent skills in communication, problem solving and logical methodology work well in the
team environment or leading a team. .
Experience in Bulk Collection & Bulk Binding, PL/SQL Tables.
Writing queries based on schema knowledge for various reporting requirements.
Due to the dynamic nature of the business, Self-motivation & the ability to learn quickly.
Effective planner and works under tight schedules.
Good exposure with Oracle utilities like SQL*Loader and Oracle Developer Suites
10g/11g.
Good analytical and team playing skills
Tuning SQL queries to improve response time using Explain Plan and TKPROF.
Good knowledge about UTL_FILE package and DBMS_SCHEDULER,DBMS_PROFILER
package.
With the help of SSIS I have worked on control flow and data flow.
Developed visual reports, dashboards using Power BI desktop.
Good experience in Basic UNIX Commands.
EDUCATIONAL QUALIFICATION:
BE from Sant Gadge Baba Amaravti University
TECHNICAL SKILLS:
Databases : Oracle 10g,11g.
Languages : SQL, PL/SQL .
Oracle IDE Tools : Oracle SQL/PLSQL developer & Oracle developer suites10g/11g.
Operating System : Windows 7/10/UNIX
Ticketing Tool: EPMO
WORK EXPERIENCE:
June 2018 –Till Date : - Atos Syntel, Mumbai as a Software Engineer.
PROJECTS ENTILTED:
PROJECT #1:
Project Name : Marathon
Client : Marathon
Role : PL/SQL Developer.
Database : Oracle 11g.
Operating Systems : Windows XP.
Practice : SQL, PL\SQL.
Scope & Description:
Marathon is a crude oil refining company. Serving customers across the U.S., the company
refines, supplies, transports, and sells petroleum products. Marathon is leaseholder or owner of
thousands of miles of petroleum pipelines and has been the owner of the Speedway gas station
chain
Responsibilities:
Involved in writing complex SQL Queries,PLSQL code to implement the business requirements.
Involved in Creating the Procedures, Functions, Triggers, Views, and Collections.
Involved in analyzing Schema’s, Tables and Indexes as part of Query optimization.
Involved in creating the Nested Tables, Pl/Sql Tables in Different areas.
Resolving the Exceptions in the Sub Programs at run time.
Provides updates and status to the Managers and others, on customer issues.
Extensively Used Joins writing Views in the Database.
Worked with Sub-Queries/Co-related Sub-queries in different areas of the Database.
Scheduled jobs using DBMS_SCHEDULER package.
Involved in importing data from client files to Oracle.
Involved in creating charts for data analysis using power bi.
Project #2:
Project Name : Northern Oil and Gas
Client : Northern Oil and Gas
Role : Developer.
Database : Oracle.
Operating Systems : Windows XP.
Practice : SQL, PL\SQL
RESPONSIBILITIES
Involved in Analysing, designing and implementation of the project.
Involved in Development of Database using Oracle 10g/11g.
Created database objects like Procedures, Functions, Packages, Cursor, and Triggers.
Solving CRs (Change Request) raised by the clients.
Preparing Technical Design Documentand Low Level Design (LLD).
Modifying the code to accommodate Client’s requirements.
Data fixing involves writing PL/SQL Scripts and SQL, which would cater the needs of
the businesses requirement.
Wrote complex SQL Queries using Joins, sub query and inline views to retrieve data
from the database.
Strong Knowledge on working with Collections to fulfill the user requirement.