Deepa Chandramohan

San Diego, California

Email: ac7v3u@r.postjobfree.com

Cell: 858-***-****

Summary of Qualifications

Dynamic and eager Oracle / SQL Server Developer / Admin with 2+ years of experience.

Principal strengths include

Over 2+ years of programming experience as an Oracle PL/SQL Developer.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely deliver 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 11g/12g, SQL *PLUS, TOAD and SQL *LOADER.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Strong experience in Data Warehouse Concepts, ETL.

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

Developed materialized views for data replication in distributed environments.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL, DBMA_JOB and UTL_FILE.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

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

Business Analysis and Strategy Planning

Excellent communication skills with all levels of business users

In-depth experience with requirements gathering and managing deadlines

Exceptional analytical problem solving skills.

Hands on, energetic motivated self-starter with a positive attitude

Ability to interact effectively at all levels Enterprise organizations

Strong customer, quality and with a focus on real results

Strong technical analysis and engineering skills

Effective team leader that provides leadership across complex teams

Ability to analyze complex business/technical data and develop innovative solutions

Ability to focus align teams around critical initiatives

Career Highlights and Experience

2 years of Oracle 11g / 12g

2 years of SQL Server

3 months of Android development

Professional Experience

Database Developer / Analyst @ Ripper Code – Chennai, India (2012 – 2014)

Junior developer / admin role to support in-house database systems including Oracle and SQL Server to support existing system maintenance and development. As part of the team, I was mentored and ramped up on various aspects of the database development / administration.

Responsible for Development of Forms and Reports

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Installed and Implemented 11g.

Worked in Production Support Environment as well as QA/TEST/STAGE environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes to patching and installations.

Wrote database triggers, procedures and packages

Backend operations including adding data files, roll back segments, creating indexes

Table structure designing

Performed changes and enhancement in design of application

Involved in testing of applications along with users.

Software Skill Set

Main Technologies

Oracle 11g/ 12g, SQL Server 2013.

Extended Technologies

Microsoft Office, Windows Server 2008, 2012.

Language / Utilities

SQL, PL/SQL, SQL Developer

Project Management Approaches

Agile, Scrum, SDLC.

Other Technologies / Tools:

Android Development (with Java & SQL)

Education

Master of Business Administration (MBA) – Human Resources (2010 – 2012) GPA 3.2

Madras University – Chennai, India

Bachelor of Science – Computer Science (2007 – 2010) GPA 3.3

Ethiraj College for Women – Chennai, India

Contact this candidate