Professional Synopsis
- More than 4.5 years of IT Experience in Oracle Database Development.
- Responsible and dedicated with ability to meet deadlines while handling multiple projects.
- Effectively made use of Table Functions, Indexes, Table Partitioning, Collections,
Analytical functions, Materialized Views, Query Re-Write and Transportable table
Spaces.
- Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
- Developed Complex database objects like Stored Procedures, Functions, Packages
And Triggers using SQL and PL/SQL.
- Loaded Data into Oracle Tables using SQL Loader and External Tables.
- Developed materialized views for data replication in distributed environments.
- Exposure on Data warehouse concepts.
- Partitioned large Tables using range, list & hash partition technique.
- Experience with Oracle Supplied Packages such as DBMS_SCHEDULER and UTL_FILE.
- Experience working in Oracle performance tuning.
- Experience working on preparing technical High (HLD), Low (LLD) level design documents and case studies
- Worked extensively on Ref Cursor, External Tables and Collections.
- Expertise in Dynamic SQL, Collections and Exception handling.
- Excellent experience of working on MS Excel, MS Word, PowerPoint.
- Sound understanding of business rules and ability to work as a part of a project team
Professional Experience
Working as Software Engineer from 26th Feb 2019 to till the date.
Education
- Bachelor of Engineering Completed in Veltech Engineering College at 2015 with 71%.
Skill Set
Skills
Oracle SQL & PLSQL, MS SQL & POWER BI
Tools
PL/SQL Developer, SQL*Plus, SQL Developer, Toad.
Operating Systems
Linux, Windows
File Transfer Tools
WinSCP, SFTP
Microsoft Office Tools
MS Excel, MS Word, MS PowerPoint.
Version Control/CI Tools
GIT, SVN, Jenkins, TFS & PVCS.
Ticketing Tools
Jira, ServiceNow
Project Profile
Client: FedEx <From: Mar21> - <To: till the date>
Project Name
TNT
Client Name
FedEx
Technology
Oracle DATABASE, Oracle PLSQL/SQL
Duration
2 Year
Team Size
8
Role : Developer
Responsibilities:
- Designed and developed OLTP and OLAP databases in support of Service Oriented Architecture solutions.
- Developed procedures to migrate legacy systems into the next generation sy