Senior Systems Engineer Resume

PROFESSIONAL SUMMARY:

Over 5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
Expertise in Client - Server application development using Oracle 12c/11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Looking forward for an opportunity in a challenging environment, where I can utilize my experience and skills in contributing effectively to the success of the Organization and for the improvement of my personal skills.
Upgrade, maintain and troubleshoot Oracle forms and reports.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008 , DB2/UDB, Teradata, SAP Tables and MS Access.

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0 , PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

Reporting Tools: Business Objects Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Operating Systems: UNIX (Sun Solaris, LINUX), Windows.

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, MongoDB, Mulesoft.

PROFESSIONAL EXPERIENCE:

Confidential

Database/OS Oracle, Windows

Senior Systems Engineer

Role & Responsibilities:

Efficiently did the analysis and design of all the concerned objects in 11g and getting in touch with the respective owners.
Developed and modified the objects in 12c database according to the 12c oracle standards.
Created scripts to load data into tables.
Migrated around 100k data from 11g to 12c.
As an oracle developer was involved in the following
Involved in the whole life cycle of the project
Interacted with clients to understand their requirements.
Involved in Table design
Programmed Packages, stored procedures, queries, and triggers on Oracle 12c
Unit and System Testing
Plan and supervise the daily activities of the application support
Database Query tuning and Implementation
Involved in resolving production problems for the applications and Ensure all support service level agreements are met
Prepared root cause analysis for problems occurred
Worked with Confidential internal source code management system.

Environment: JAVA, Oracle 12c/11g, PL/SQL, SQL*LOADER, Oracle Streams(Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, Mulesoft.

Confidential

Database/OS Oracle, Windows

Senior Systems Engineer

Role & Responsibilities:

Efficiently handled time bound production issues and automated most of the manual activities.
Developed and modified existing codes to increase the efficiency of the process and meet SLA.
Documented tutorials for Oracle SQL, SQL and PL/SQL Tuning.
Engaged in Oracle PL/SQL development of stored procedures and packages in all phases of SDLC to optimize the existing system and enhance the code to comply with client’s dynamic requirements.
Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development
Developed ETL processes using PLSQL to transfer the data across various data source. Extracting the data from different sources to load into Oracle database stage tables to target.
Involved in developing packages for implementing business logic through procedures and functions.
Performed unit test on the developed code to ensure that its bug free.
Handled Production and UAT issues and manage the same in issue log.
The source code management system used was Git and Tortoise.

Environment: Oracle 10g/11g SQL, PL/SQL, Forms, Reports, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship