M.S RAGHAVAN
Mumbai
Cell No: 989797979
Email-id: msragav@rediffmailer.com
Job Objectives:
To work as Oracle SQL Developer in a multinational IT firm that believes in providing high standard solutions to their clients.
Work Experience:
Oracle SQL Developer, August, 2010 to present
Softronics India Ltd,Mumbai
Over 6 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 11g/10g/9i/8i, PL/SQL, 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.
Good knowledge on logical and physical Data Modeling using normalizing Techniques.
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.
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,DBMS_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.
Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Oracle SQL Developer, July, 2007 to May, 2010
Computech India Pvt Ltd,Bangalore.,
Formulated SQL and PL/SQL scripts and modified codes to enhance performance and to resolve issues if any.
Developed oracle modules, Stored Procedures, and indexes.
Created reusable items such as packages, triggers, processes and PLSQL validations.
Prepared software packages and managed particular functions of business requirements.
Evaluated and updated programs with interpretation of workflow illustrations and graphs.
Programmed applications and computer system software.
Developed and assimilated SQL server and database designs and systems.
Evaluated root cause and provided support to SDLC models like Agile.
Built Oracle SQL database objects, SSIS and ETL scripts.
Optimized modules using XML, HL7 and answered to user queries.
Drafted procedures to resolve intricate issues in systems.
Analyzed and approved technical specifications of database.
Technical Qualification
Databases: Oracle 7.x/8i/9i/10g/11g (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, HP UNIX, AIX), Windows NT/98/95/2000 & Windows XP.
Data Modeling: Erwin 3.5.2,4.0
Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, XML, C and Cobol.
Other Tools: AutoSys, Control-M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange Informatica 9.1.0 Developer/Analyst, TPump, Fast Load, BTEQ
Education:
MCA From Mumbai University
Certifications:
Database Administration Certification
PL/SQL Certification
Oracle Certified Master (OCM DBA)
Personal Details:
Father’s Name
Date of Birth
Permanent Address
Passport Details
Languages Known
SOFTWARE DEVELOPER SAMPLE RESUME
To work as a stock clerk in a leading company where my skills in organizing merchandise can help in tracking inventory accurately.
LINUX NETWORK ADMINISTRATOR SAMPLE RESUME
To obtain the position of a Linux Network Administrator in an organization where I can utilize my professional skills and experience towards the growth of the organization.
DB2 SQL DEVELOPER SAMPLE RESUME
To develop a long-term career by seeking a position which is full of challenging avenues and where the through knowledge and experience acquired to utilized the maximum, giving me satisfaction on one hand and fulfilling the organizations objective on the other hand.
ORACLE PL/SQL DEVELOPER SAMPLE RESUME
To obtain a position where I can utilize my technical skills for the enhancement of Oracle database systems.
RSS Feed for Sample Resume Blog