Sql Data
Resume:
RENJI JOSEPH
*****.******@*****.***
SUMMARY OF QUALIFICATIONS
• 5 years of experience in Database Development using SQL and PL/SQL.
• Extensive work experience in Oracle 10g, Oracle 9i, Oracle 8i databases.
• Solid management skills, demonstrated proficiency in leading and mentoring individuals to maximize levels of
productivity, while forming cohesive team environments.
• Participate as a significant individual contributor including specification, design, and implementation of different
database oriented applications using Oracle and other similar databases.
• Strong in Database Architecture, Database Development, and Data Modeling.
• Knowledge about best practices in human factors and end-user needs.
• Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers.
• Solid experience and knowledge in ETL Framework and Data warehousing concepts.
• Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, PL/SQL)
• Proficient in designing, developing, and implementing ETL solutions and providing quality data services.
• Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, Index Organized Tables,
external tables etc.
• Good knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables
• Very good knowledge and experience in using analytical functions.
• Proficient in analyzing business/data requirements, writing metadata definitions, and writing data mapping
specifications.
• Experienced in O/S scripting (Windows/Unix) and good knowledge of UNIX commands and shell programming
• Experienced in Database Optimization by making use of various Performance Tuning techniques.
• Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN and TKPROF.
• Experienced in Partitioning Administration. Creating and Managing Partitioned Tables and Indexes.
• Experienced in Normalized Database Design and Modeling.(Logical and Physical design of database)
• Detailed working knowledge in designing and developing data architectures using common and standard data
modeling techniques.
• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques,
database normalization theory.
• Experience in physical and logical data modeling.
• Very good knowledge and experience in using Oracle in-built packages like UTL_FILE, DBMS_SQL etc.
• Extensively worked in Oracle Forms, Reports.
• Very good working knowledge in ERWIN, TOAD.
• Experienced to translate reporting and analytical needs into technical solutions
• Experienced in writing SQL queries, understanding requirements, writing functional specs, writing test specs and
plans.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Worked with version control tools like VSS, CVS.
EDUCATION
• M.S Computer Science State University of New York Binghamton. GPA(4.0/4.0)
• Bachelors Degree in Computer Science, India. (B.Tech).
Oracle Certified Professional. (10g DBA)
•
• Oracle Certified Associate. (10g DBA)
• Oracle Certified Associate. (PL/SQL Developer)
• Red Hat Certified Engineer.
TECHNICAL EXPERTISE
Languages SQL, PL/SQL, C, JAVA
Databases Oracle 10g, Oracle 9i, Oracle 8i.
Tools ORACLE, COGNOS, ADAM, TOAD, SQL*PLUS, ERWIN
PL/SQL DEVELOPER, DATAPUMP, TOAD Data Modeler. Oracle Designer.
Web Technologies XML, HTML, JavaScript.
Operating Systems Windows 2003/XP/2000/NT/9x, Red Hat Linux AS3, Sun Solaris, HPUX 11.0
Versioning Tools Microsoft Visual Source Safe (VSS), CVS.
PROFESSIONAL EXPERIENCES
Dept of Education, Massachusetts. NOV 2007 –
CURRENT
SENIOR ORACLE DEVELOPER
The project deals with building a software system for managing accountability and results through technology. This
system is used by Massachusetts Department of Education to manage and to monitor the Adult Basic Education programs
funded through DOE. The system helps the program directors to design curriculum, allocated the funds appropriately,
conduct staff evaluation, and monitor the progress of the student.
Database Administration.
• Designed the database split to split the reporting schema from the transaction schema.
• Monthly refresh of the development and test environment using the Datapump Import/Export.
• Configured Logminer in development and test environment.
• Involved in creating and maintaining Partitioned Tables and Indexes
• Used public synonyms, read only user accounts and database links for remote database access.
ETL Development
• Involved in DESIGNING & CREATING an ETL Framework that works based on a table driven approach.
• Involved in the LOGICAL & PHYSICAL MODELING of the Zip Code schema.
• Developed the entire ETL process using PL/SQL.
• Dos batch scripts are developed and are used in the windows scheduler to initiate the batch process.
• AUTONOMOUS_TRANSACTION PRAGMA is used in the framework procedures to log the status when error
occurs.
• External tables are used to convert the incoming tab separated files to staging tables.
Data Dictionary Development
• Developed ER diagram and data dictionary of existing tables in the production environment.
• UTL_FILE is extensively used to create data dictionary in a html format..
• ER diagrams are developed using TOAD Data Modeler.
Report Development/Cognos
• Gathered requirements through detailed discussions.
• Thorough Data analysis to understand the behavior of data.
• Report development using Cognos Report Studio and SQL.
• Created VBScripts to add users to ADAM.
• Developed scripts to collect the CUBE build statistics of the Cognos CUBES.
• Analytical Functions and Cross tab queries are used extensively in report development.
ENVIRONMENT: PL/SQL, Oracle 10g, TOAD, SQL PLUS, Oracle Designer, Toad Data Modeler, Windows 2000,
Erwin, HP-UX 11.0
TD-BANKNORTH Portland, MAINE. JUL 2007 – OCT 2007
SENIOR ETL DEVELOPER
This project deals with building an ETL platform that supports data integration service for loading data. This platform is
used to load data from the ENCORE source tables for the Platform and Teller reports. Development of platform includes
building procedures to map and load the data from the source OLTP table to target table columns for reporting.
• Involved in creating a separate reporting environment for TELLER and PLATFORM using ETL Development from
bank’s OLTP database, which is a replica of the bank’s SYSTEM OF RECORDS.
• Involved in DESIGNING & CREATING an ETL Framework that works based on a table driven approach.
• Created PL/SQL Stored procedures and Functions and embedded them in packages.
• Involved in the LOGICAL & PHYSICAL MODELING of the Encore Reporting Data Mart.
• Mainly involved in creating procedures for TELLER Events such as Daily Cashbox Summary, Teller Cash-
Over/Short, Canadian Cash Exchange History etc. and PLATFORM Events such as EBU-Electronic Banking Unit,
Profiler, Deposit Operations, Branch Operations and Work Queue Operations etc.
• Involved in creating and maintaining Partitioned Tables and Indexes
• Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.
• Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, ER Diagrams, Dependency
documents.
• Implemented pivot queries using MODEL CLAUSE.
• Involved in creating Schema comparison reports between Development, QA and Production databases.
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Made of used of DML triggers for updating sequences.
• Worked with very large tables and databases which are sized in Terabytes.
• AUTONOMOUS_TRANSACTION PRAGMA is used in the framework procedures to log the status when error occurs.
Wrote triggers for auditing purposes.
•
ENVIRONMENT: PL/SQL, Oracle 10g, Oracle Discoverer, TOAD, SQL PLUS, SQL Developer, Windows 2000, Erwin,
HP-UX 11.0
Binghamton University, Binghamton NY MAR 2006 – DEC 2006
Teaching Assistant, Research Assistant
Worked as a Teaching Assistant for the System Programming course during fall 2006 semester. This course is a
programming course in C to help the students in getting better understanding of the UNIX operating system and C
language. Also worked as a Research Assistant with BAE Systems.
• Helped the students with the course content.
• Grade the exams and assignments of the students.
• Involved in the research work with the Professor.
• Involved in the design of the real time file system for an existing real time file system.
• Involved in Testing and support of the software.
CORDYS INDIA. Hyderabad, India NOV 2002 – JUL
2005
Software Engineer
Point of Sales Apr 2004 – July
2005
The point of sales project is done for the Binghamton Giants Company headquartered in vestal. It has a chain of
supermarkets located throughout southern NY. In this project, played the role of a senior PL/SQL developer where my job
includes enhancements and bug fixing in the backend PL/SQL stored procedures for the Point of Sales system. Wrote
programs to get data from Customer Database systems and load it into the different tables in the core application. This job
also involved customer interaction and production warranty support.
Roles and Responsibilities
• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Extensive Performance Tuning(SQL Tuning, PL/SQL Tuning)
• Involved in ETL Development using native Oracle tools(SQL*LOADER, Oracle PL/SQL)
• Involved in the creation of Partitioned Tables and Indexes
• Involved in the creation and modification of Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL Queries to implement the business requirements.
• Involved in loading data into Database using SQL*Loader.
• Data Migration using PL/SQL stored Procedures.
• Involved in DATA MODELING using ERWIN.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Involved in cleaning and maintaining migrated data.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Involved in Index Monitoring for identifying the Unused Indexes.
• Involved in analyzing Schema’s, Tables and Indexes as part of OPTIMIZATION.
• Used data pump to refresh the development and test database environment.
• Worked with AUTONOMOUS TRANSACTIONS in Triggers and Functions in order to include logging.
• Involved in creating UNIX shell Scripts for automating various routine database tasks.
• Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.
• TOAD and SQL PLUS were used for PL/SQL Development.
ENVIRONMENT: Oracle 10g, HP-UX 11.0, SQL DEVELOPER, TOAD, ORACLE DISCOVERER
First Notice of Loss Nov 2002 – Mar
2004
Involved in the backend development of the (First Notice of Loss) FNOL, which is a web based insurance system. This
system allows clients with internet access to complete their own claim form in a timely manner and transmit it
immediately to the appropriate claim service center. It processes auto claims for glass and other auto related claims.
Roles and Responsibilities
• Wrote PL/SQL stored procedures and triggers to implement business requirements.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK
INSERT features.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Used sqlloader and external tables to load data from text files into the database.
• Involved in creating and maintaining Partitioned Tables and Indexes
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Extensively worked with DML Triggers.
• Involved in writing complex SQL statements.
• Created UNIX shell scripts to invoke the SQL scripts which are run daily.
• Involved in creating stored procedures and packages with DYNAMIC SQL.
• Involved in analyzing the schema, so that the cost’s can be efficiently utilized by the optimizer.
• Involved in creating user roles.
• Involved in comparing Production data with Test data for identifying and cleaning corrupted data.
ENVIRONMENT: PL/SQL, Oracle 10g, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 11.0
Contact this candidate