Sql, UNIX, pl/sql, ETL

Location:

India

Salary:

8 to 9lpa

Posted:

June 02, 2018

Contact this candidate

Resume:

OBJECTIVE

By an enthusiastic approach and zealous spirit, I aspire to seek a challenging position as IT Analyst with a growth-oriented organization where my skills and experience will be utilized to their full potential and hereby affirm to enhance my capability for the benefit of the organization.

PROFESSIONAL SUMMARY

Young, energetic and result oriented professional with 4 years 9 months of experience in Analysis, Design, Development, Implementation and Support of Business Applications using Oracle Relational Database Management System (RDBMS) and UNIX Scripting. Expertise in Databases like Oracle 10g/11g and MSSQL with deep understanding of technology and focus on delivering business solutions.

Over 4.3 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).

Effective knowledge of Control M tool with respect to scheduling and monitoring.

Effective knowledge of Shell scripting and involved in the development of new code in shell scripting.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and support against aggressive deadlines.

Effectively made use of Functions, Indexes, Table Partitioning, Collections, Analytical Functions and Materialized Views.

Created Tables, Views, Materialized Views, Constraints, Indexes (B Tree, Bitmap and Function Based).

Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Expertise in Dynamic SQL, Collections and Exception Handling.

Knowledge of partitioning large tables using various partition techniques.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Proficient in using Tools like Toad, SQL Developer, SQL Server Management Studio – 2008/2012 and SQL Plus,Putty,essbase.

Ability to work in teams and independently with minimal supervision to meet deadlines.

Worked on Production Support, attending production calls, troubleshooting the application and identifying bugs.

Dedicated and highly ambitious to achieve personal goals as well as the organizational goals.

Superior communications and interpersonal skills, with an ability to interact with a wide range of people.

Proficient in translating business requirements into logical, physical data models and ER Diagrams

Experienced in Extraction Transformation and Loading (ETL) processes.

Enhanced UNIX Shell Scripts for OLAP modules i.e. validating the upstream feeds, parsing them, processing as per the business logic and loading them into the database.

CORE COMPETENCIES

Strong Technology Background

RDBMS Concepts

Oracle 10g/11g, MSSQL

Application Maintenance / Support/ Problem Solving

Mentoring / Training

Process Documentation

SDLC Implementation

Troubleshooting & Problem Solving

Technical Communication and Business Analysis

Strong Analytical abilities

Cohesive team worker

CAREER HIGHLIGHTS

Won several laurels(On the Spot Award) and appreciations from my superiors for my hard work and efforts shown in meeting the project deadlines.

Instrumental in each stage of SDLC during the projects.

Acting as a Point of Contact/Subject Matter Expert for client.

Acted as a Team Lead and managed the team for a certain duration.

Resolved and facilitated my team in number of technical issues.

Developed specific goals to plan, organize and prioritize the work.

Sound ability to develop strategies to achieve personal goals as well as organizational goals.

TECHNICAL SKILLS

Databases: Oracle 11i/10g

Languages: SQL, PL/SQL,Unix

Database Utilities: TOAD (9.6.1/9.1/8.5/7.4/7.1), SQL Developer, SQL*Plus, SQL Navigator (5.5/5.4), SQL*Loader

Operating Systems: Windows XP/2000/Vista, Sun Solaris

Applications: Putty, Microsoft Office,Essbase,Control M

RDBMS Tools: SQL*Plus, Toad 8.0, SQL*Loader

Web Related: HTML, Javascript

PROJECTS HANDLED

Project – 1#: PSRS(Privileged Access Review System)

Client : Deutsche Bank

Period : Dec 2017 – Present

Description : PSRS is the Review system used to review the logs generated when SA logged in in any of the brokering system.

Languages : SQL, PL/SQL, UNIX

Databases : Oracle 10g/11g, MSSQL

Tools : TOAD, SQL Developer, SQL* Plus, Putty,Control M

Roles and Responsibilities :

Gathering requirements from clients regarding required enhancements.

Worked on complex SQL queries for various bank applications.

Worked on PLSQL packages/procedures for implementing business logic as per the requirements.

Debugging various packages, functions, procedures and triggers for resolution of any particular issues.

Identifying risks proactively and proposing solutions to resolve them.

Coordinating with third party vendors to examine impacts and issues during change implementations.

Monitoring successful completion of jobs on a daily basis which were scheduled for accurate flow of data from one application to another.

Mentored junior resources in the project, creating awareness on project specific applications and company standards.

Identifying various tables which are required to be a part of Subsetting Framework and their classification at various levels.

Creation of new schema (with import of metadata) various tables and required synonyms for the framework to work properly.

Creation of various packages and procedures which involves setting up of framework, classifying high volume tables and creation of insert/merge scripts dynamically.

Project - 2# : HR Cube-Global

Client : Deutsche Bank

Period : Feb 2014 – Present

Description : HR Cube is a multidimensional Platform for reporting global employee Full Time Equivalent(FTE) and HeadCount(HC) data for Deytsche Group.

Languages : SQL, PL/SQL, UNIX

Databases : Oracle 10g/11g, MSSQL

Tools : TOAD, SQL Developer, SQL* Plus, Putty,Essbase