SHIVARANJANI RAMACHANDRAN

Oracle certified PL/SQL Developer with 3+ years of experience in Analysis, Design and Implementation of business applications using the Oracle 10g database for a global financial firm. Proficient in custom application development following waterfall and agile methodologies. Competent and skilled in various phases of SDLC such as Requirements Analysis, Design, Development and Testing. Experience in creating automation macros, generating reports by connecting SQL server database and excel.

PROFSESIONAL EXPERIENCE

Mar. ‘15 – present Career Gap New Jersey, United States

Gained in-depth training in basic concepts of data visualization tools like Tableau through web based training

Experience in customizing interactive reports and dashboards using Tableau

Ability to create action filters, highlighters, calculated fields and hierarchies for Tableau dashboards and worksheets.

Created Tableau workbooks from multiple data sources using Data Blending

Good understanding of core technologies like HTML5 and CSS3 for building webpages through online training

Ability to create responsive personal blogs using HTML5 and CSS3.

Nov. ‘11 – Feb. ’15 TATA Consultancy Services PL/SQL Developer Chennai, India

Involved in all phases of software life cycle like Requirement gathering and Analysis, Application development, Test, Implementation and Support

Ability to explain technical concepts and communicate with users and system administrators at all levels.

Expertise in creating user interfaces that utilized Project Portfolio Management applications

Proficient in creating automation macros to generate a report connecting SQL server database and excel

Played a vital role in resolving the errors in the test environment helped in the successful migration to production

Programming experience in Analysis, Design and Implementation of Business Applications using PL/SQL in Oracle 10g database

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus

Experience in advanced PL/SQL concepts like Multi Table insert, PL/SQL tables, Cursors, Records and Dynamic SQL for DML operations for better performance

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files

Expertise in creating Packages and Procedures to automatically drop and create indexes for the tables

Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts

Played a vital role in resolving the errors in the test environment helped in the successful migration to production

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD

ADDITIONAL SKILLS

Language/Utilities

SQL, PL/SQL, HTML5 & CSS3 and Basics of Unix shell scripts

Tools

SQL *plus, Toad, HP PPM & Basic Concepts of Tableau

Database

Oracle 10g, MS SQL Server

Operating System

Linux & Windows

PROFESSIONAL MEMBERSHIPS/ CERTIFICATIONS

ALMI Certified from Life Office Management Association (LOMA)

Introduction to Oracle 9i SQL (1Z0-007)

Program with PL/SQL (1Z0-147)

EDUCATION

Jul. ‘07 – May. ‘11 Bachelor of Technology in Information Technology

SASTRA UNIVERSITY, TAMILNADU, INDIA

New Jersey 201-***-**** add5al@r.postjobfree.com

Contact this candidate