SUMMARY

• 8 years of experience in IT industry mainly in Design, development, implementation, testing and documentation of business applications using Oracle technologies.
• Experience in maintaining Oracle Forms and Reports application.
• Expert in Client - Server application development using Oracle 11g/10g/9i, PL/SQL.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Hands on experience on writing SQL queries, PL/SQL procedures, Functions, Cursors, Triggers in Oracle and SQL server, also involved in database testing.
• Oracle certified associate OCA (Developer).
• Informatica Power Center DI 9x Dev Specialist certified.
• Knowledge in Report writing using OBIEE.
• Expertise in Repository designing and Data modeling.
• Expertise in Dashboard Development in OBIEE Answers.
• Expertise in Managing Catalogs, Security, Repository Changes, Repository Users, iBots Configuration, Cache Management.
• Expert in data modeling, Normalization, database design, data loading, data retrieval, modification and archival techniques.
• Around 3+ years of strong Data Warehousing experience using Oracle 11g/10g/9i PL/SQL, Oracle, Informatica 8 ETL, OLTP,Dimensional Data Modelling using Star & Snow Flake schema.
• Have sound knowledge in ETL Process and Exposure to handling Data from various sources (Flat files, Excel, Access, Oracle) and have good understanding of ETL load processes as well to connect the implications of regular loads to data warehouse.
• Expert in Designing Dimensional Modeling (Star Schemas, Snowflake schema) and Operational Data store (ODS) Data Warehouse design and hands on Experience in Design Data models using Erwin 4.5/4.0/3.5.
• Experience in Performance tuning of SQL queries using Explain plan and SQL*Trace utilities and applying appropriate Hints, Indexes and Oracle Partitions.
• Migrated data from flat files to oracle database using SQL*Loader.
• Experienced in using SQL tools like TOAD, SQL Developer and SQL Navigator.
• Good Experience in Windows 95/98/2000/XP/NT, UNIX, Shell etc.
• Extensive experience in UNIX shell scripting, automating routine server using crontab.
• Have Business Intelligence experience in generating various reports using OBIEE.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica 9x/8x, OBIEE

Languages: SQL, PL/SQL

Database: Oracle 11g/10g/9i

Operating Systems: Windows 98/2000/XP/NT, MS DOS and Sun Solaris UNIX

Web Technologies: HTML

Tools: SQL*LOADER, SQL Navigator, SQL*Plus, TOAD, Oracle Forms 9i, Oracle Reports 9i

Scripting Language: Unix, PERL

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical and Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, De-normalization

PROFESSIONAL EXPERIENCE

Confidential - Green Bay

Data Archival Consultant (Solix EDMS)

Responsibilities:

• Requirement analysis on new purge and archive request.
• Identification of set of tables and it child tables involve in the archive and purge.
• Creation of functional and technical document.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements.
• Involved in setting up the Solix EDMS for new purge which involves getting the required tables, creating a joins and the building a config which internally creates the queries for data selection, archive and purge based on the earlier created join condition.
• Involved in Unit testing and UAT testing.
• Hands on Experience for UAT/production deployments using Anthill.
• Hands on Experience on Scheduling jobs using CA-WA.

Confidential - New York

PL/SQL Data Warehouse Consultant

Responsibilities:

• Involved in Design & Develop of Logical and Physical Model of Star Schema including Dimension and Fact tables.
• Generate the scripts for the updated data model using the script generator.
• Developed PL/SQL Programs to load data to DW from various sources.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, synonyms, procedures, functions and database triggers to meet the business requirements.
• Responsible for the development, implementation and support of the Production database of the server.
• Optimized and modified the triggers, complex store functions, procedures, user base data type etc.
• Used Oracle Analytical Functions to get tuned performance related issues.
• Involved in analysis and translation of business requirements into technical lineage documents.
• Using the explain plan for query tuning.
• Hands on Experience to write DDL scripts for UAT/production deployments.
• Developed Functional (Business terms) and Technical Design documents.
• Involved in data conversion from one database to Data Warehouse.
• Developed Staging jobs where in using data from different sources formatted, Cleaned, Summarized, aggregated and transform into data warehouse.
• Developed PL/SQL scripts for ETL (Extraction, Transformation & Loading).

Environment: Oracle11g, PL/SQL, Informatica, OBIEE 10.1.3, Answers and Dashboards, SQL Navigator

Confidential

Sr. Oracle and OBIEE Developer

Responsibilities:

• Closely worked with users to understand the business and to develop the Business Requirements into Product Requirement Document (PRD).
• Preparation of various 'Dashboards' to provide information about the data
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• 2+ years of experience in Dashboard, answers and repository building.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema, Modeling, fact and dimensions tables.
• Expertise in analyzing and designing customized analytical reports and creating Interactive dashboards with drill-down capabilities using OBIEE.
• Used union reports, drill down, presentation variables and prompts in the creation of answers and dashboard reports.
• Used different views in OBIEE like view selector, column selector, table, pivot, chart
• Prepared final design documents and general instruction to follow during development.
• Wrote and modified stored procedures, standalone functions and PL/SQL packages to comply with the requirements.
• Designed and developed master tables, indexes, views, sequences and synonyms.
• Used EXPLAIN PLAN and SQL Trace to tune queries for better performance and also extensively used Indexes and HINTS.
• Expertise in UNIX environment and shell scripting. Excellent knowledge in Batch Jobs using UNIX CRON, AWK UNIX Shell Script (csh, bash, ksh) and APIs Using PERL Scripts.
• Used different kinds of Oracle partitions like range partitioning, hash partitioning and list partitioning depending upon the requirement in order to achieve optimum performance.
• Effective co-ordination with the offshore team on timely resolution of help tickets.
• Detected and corrected bugs, managed open, closed and reopened defects using defect tracking system JIRA.

Environment: Oracle 11g, Pl/SQL, SQL*Loader, Linux 2.16, Explain Plan, PL/SQL Developer 9.0.6, SQL Navigator, OBIEE.

Confidential

Oracle Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions).
• Written many Stored Procedures, Functions and Packages.
• Written many database triggers for automatic updating the tables.
• Responsible for creating a report using Oracle 9i and testing/debugging the issue related with Forms and Reports application.
• Used TOAD developer tool for faster application design and developments.
• Data migration from Flat Files have been uploaded into Staging Tables using SQL* Loader.
• Identification of the database objects required for supporting the business requirements like tables, views, indexes, stored procedures, functions, database triggers, and synonyms.
• Utilized dynamic record groups to populate the LOVs and List item at runtime for data retrieval and data entry.
• Worked with performance and tuning issues. Creating tables and loaded the database on the views. Used index logic to obtain the good performance.
• Written Shell Scripts for automation of some daily tasks.
• Analyzing and resolving issues (ZRMS).

Environment: Oracle 10g, SQL*Loader, Toad, UNIX, Oracle forms 9i, Oracle Report 9i