Senior Oracle Developer
Resume:
RENJI JOSEPH
*****.******@*****.***
SUMMARY OF QUALIFICATIONS
• 6.5 years of experience in Database Development using SQL and PL/SQL.
• 4 years of experience in Cognos 8 suite and Report Net with Report Studio, Query Studio, Cognos Connection and Framework Manager.
• Strong in Database Architecture, Database Development, and Data Modeling.
• Extensive work experience in Oracle 10g, Oracle 9i, Oracle 8i databases.
• Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers.
• Solid experience and knowledge in ETL and Data warehousing concepts.
• Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, PL/SQL)
• 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
• Created various multi-dimensional cubes using Cognos PowerPlay Transformer.
• Thorough knowledge and experience in using analytical functions, hierarchical queries.
• Experienced in Dos batch programming and UNIX 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)
• 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 in Dynamic SQL, PL/SQL Collections and Exception handling.
• Worked with version control tools like VSS, CVS.
• 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.
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 COGNOS 8.x & ReportNet1.1/1.0x( Report Studio, Query Studio, Framework Manager, Cognos Connection), Analysis Studio , 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.
LDAP ADAM, Sun One Directory Server
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.
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.
• 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.
• Designed the database split to split the reporting schema from the transaction schema
• Created Materialized views to store aggregate values.
• Monthly refresh of the development and test environment using the Data pump 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
• Developed PL/SQL procedures using dynamic SQL.
Report Development/Cognos
• Gathered requirements through detailed discussions.
• Worked extensively on report studio to create list reports, inline prompts, cascade prompts, Drill-Through Reports, Burst reports and cross tab reports based on the user specifications.
• Created folders, filters, prompts, and complex calculations in Framework Manager
• Enhanced reports by using a series of features like, highlighting report values using conditional style
• Thorough Data analysis to understand the behavior of data.
• Created Data source query subjects in Frame work Manager using SQL
• Involved in installing and configuring Cognos 8.2 and Cognos 8.4
• Report development using Cognos Report Studio and SQL.
• Built multidimensional cubes using Power Play Transformer by using multiple IQD files as a Data Source.
• Created VBScripts to add users to ADAM.
• Developed scripts to collect the CUBE build statistics of the Cognos CUBES.
• Analytical Functions, Cross tab queries and Hierarchical queries are used extensively in report development.
• Done a comparative study on Oracle Internet Directory and ADAM.
• Created reports in Microsoft Excel.
ENVIRONMENT: Oracle 10g, Cognos 8.2, 8.4, Frame Work Manager, Cognos Connection, Report Studio, Microsoft IIS, PowerPlay Transformer, 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.
• Involved in DATA MODELING using ERWIN.
• Made use 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.
• Maintained existing Cognos reports, and updating with new additions to the existing reports.
• Creation of various prompts including cascading effect using prompt pages.
• Created Simple List reports, Cross-tab reports, Conditional formatting, Drill-Through reports, reports with UNIONS and JOINS using Cognos Report Studio.
ENVIRONMENT: PL/SQL, Oracle 10g, , TOAD, SQL PLUS, SQL Developer, Cognos 8.2, Frame Work Manager, Cognos Connection, Report Studio, Windows 2000, Erwin, HP-UX 11.0
Binghamton University, Binghamton NY AUG 2005 – JUNE 2007
Research Assistant
BUSI SYSTEM
BUSI system is used to report about the classes taken by students in each semester. The system helps the students to know about their enrollments, details about the classes the grades they obtained in each class etc. The system is also used by the professors to monitor and manage the classes and the students.
• Created pl/sql packages and procedures to implement business requirements.
• Used Sql to create cross tab reports.
• Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.
• TOAD and SQL PLUS were used for PL/SQL Development.
• Analytical functions and hierarchical queries are used extensively.
• Ref cursors are used in pl/sql packages.
• Created data dictionary in html format using the UTL_FILE and data dictionary tables.
• Used sqlloader to load data from csv files into Oracle tables.
• Created database links to access data from remote databases.
• Maintained and created UNIX shell scripts.
ENVIRONMENT: PL/SQL, Oracle 10g, TOAD, SQL PLUS, HP-UX 11.0
CORDYS INDIA. Hyderabad, India NOV 2002 – JUL 2005
Software Engineer
Point of Sales Sept 2003 – 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. A reporting schema is used to for report development. Once the data is loaded into the reporting tables, query subjects are created in the Cognos Framework Manager using those table and Packages are created and published.
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.
• Created Namespaces, Query Subjects, Calculated Fields, Filters, Joins and Packages in Cognos Frame Work Manager.
• Created User Classes and Users in Access manager.
• Installed ReportNet in IIS, Windows and Oracle Environment,
• Created standard and Adhoc reports using Query Studio and Report Studio.
• Created User Groups, Roles to implement the security in ReportNet.
ENVIRONMENT: Oracle 10g, HP-UX 11.0, SQL DEVELOPER, TOAD, : Cognos Reportnet(Report Studio, Query Studio, Cognos Connection) Framework Manager, Cognos Series 7 (Impromptu Administrator, Power play Enterprise Server, Power play Transformer, Access Manager), Microsoft IIS
First Notice of Loss Nov 2002 – Aug 2003
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