We provide IT Staff Augmentation Services!

Sr. Oracle Bi Consultant Resume

Houston, TX

Professional Summary

  • Result Oriented IT professional with over 8+ years of experience in analyzing the Business Users Requirements, Application Design & Modeling, Development, Testing, Implementation, Documentation and Support of Business Intelligence using Oracle Business Intelligence (OBIEE/BI Publisher), Database Development using Oracle, ETL methodology for supporting data transformations & processing using Informatica PowerCenter.
  • 7+ years of extensive experience in providing end-to-end business intelligence solutions using OLAP/DSS tools like OBIEE 11.1.1.7.0/ 11.1.1.6.2 /10.1.3. 2/3.3/3.4 and Oracle BI Publisher 11.1.1.7.0/11.1.1.6.0 /10.1.3. 4.
  • Expertise in User Requirement Gathering and converting the same into Technical Specifications.
  • Worked extensively on OBIEE Administration Tool, Presentation Services/Answers/Analytics, OBIEE Interactive Dashboards, OBIEE Delivers/IBOTS, Cache Management, OBIEE Scheduler Configuration and BI Publisher.
  • Proficient in building three layers (Physical Layer, Business Model & Mapping Layer and Presentation Layer) of OBIEE Repository using OBIEE Administration tool.
  • Expertise in translating high-level business requirements into logical business dimensional model.
  • Extensive experience, Defining various logical subject areas and organization of Presentation Layer metadata; Understanding and defining key metrics, dimensions, hierarchies and attributes.
  • Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Experience in upgrading OBIEE Repository, Presentation Catalog, BI Publisher, BI Security from OBIEE 10g to OBIEE 11g using Upgrade Assistant wizard.
  • Proficient working on various RDBMS (Oracle 8i/9i/10g, SQL Server 2005/2008, Teradata v2r5).
  • Extensive experience in Oracle 10g/9i/8i Database Development and hands on experience in writing Oracle SQL queries and creating, testing and implementation of Oracle Database Objects like Tables, Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, Views.
  • Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses.
  • Experience in integration of various data sources like Oracle 9i, SQL server 7.0, Teradata v2r5, Flat files and Excel files into staging area.
  • Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes and partitions.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
  • Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and production support.
  • Strong understanding of Systems Development Life Cycle (SDLC).
  • Highly motivated, enthusiastic professional with a high degree of commitment to succeed.
  • Excellent writing, analytical, communication and interpersonal skills.

Technical skills

  • OLAP/DSS Reporting Tools: OBIEE 11.1.1.7.0/ 11.1.1.6.2 /10.1.3. x. and Oracle BI Publisher 11.1.1.7.0/11.1.1.6.0 /10.1.3. x
  • Database Tools : TOAD 10.6/7.4/7.2 , SQL*Plus, SQL Developer, SQL Loader, Forms 6i/6.0/10g, Reports 6i/6.0/10g, SQL Server Management Studio 2008.
  • OLAP/DSS ETL Tools:Informatica Power Center 7.1
  • Databases:Oracle 8i/ 9i/10g, SQL Server 2005/2008, Teradata v2r5
  • Programming Languages:SQL, PL-SQL, and C.
  • Scripting Languages:Perl and Shell Scripting.
  • Operating Systems :Windows XP/2003/2008/7, Sun Solaris, Redhat Linux 6.0 and MS-DOS
  • Markup Language:HTML, CSS, XML
  • Tracking Tools : Mercury Quality Center 9.0/HP ALM 11 , JIRA and Bugzilla 3.2.10

Professional Experience

Confidential , Houston TX

Sr. Oracle BI Consultant

Confidential is a leading provider of real estate services, including global residential and commercial title insurance, escrow and settlement services, lender services, underwriting, specialty insurance and other solutions that facilitate successful real estate transactions. Stewart offers personalized service, industry expertise and customized solutions for virtually any type of real estate transaction, through our direct operations, network of approved agencies and other companies within the Stewart family.

Responsibilities

  • Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
  • Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Views and defined Fact & Dimensions using the foreign key joins in the physical layer of the repository.
  • Created dimensions, dimensional hierarchies, levels, level based measures and defined level, attributes level keys.
  • Used expression builder utility to create new logical columns/measures in the BMM layer.
  • Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters) as per the client requirements.
  • Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports via email using BI Delivers.
  • Implemented OBIEE security using embedded LDAP and Microsoft active directory.
  • Created new Users and assigned the users to the BI Administrators group in OBIEE 11g Administration Console.
  • Created custom Application Roles and mapped them to the User Group in OBIEE 11g Enterprise Manager.
  • Implemented and Managed object level and data level security using custom User groups/Application roles.
  • Ran the utilities nqudmlgen.exe and nqudmlexec.exe to downgrade the server repository version from 326 to 325.
  • Merged on the repositories from Dev and Pre-QA environments using 3-way merging feature and deployed the new repository obtained from the result set in Pre-QA.
  • Migrated OBIEE web-catalog objects from Dev to Pre-QA by archiving and unarchiving features of OBIEE catalog manager.
  • Drafted OBIEE deployment document and prepared Rpd & webcatalog objects for migration from Pre-QA to QA.
  • Coordinated with the administration team on deployments and validated the migrated code.
  • Used SQL Server Management Studio to debug the SQL query issued during report execution.
  • Coordinated with the QA team on defect fixes and on deployments for retesting the dashboards.
  • Involved in the implementation of Usage Tracking reporting to monitor the user activity.
  • Deployed Sample Application V309 on a physical server and recorded the implementation steps.
  • Involved in setting up Multiuser Development Environment, documented the steps and trained other Developers on check-out and check-in process of a OBIEE project.
  • Ran RCU (repository creation utility) 11.1.1.6.0 to drop and recreate BIPLATFORM and MDS schema’s on Production Server.
  • Involved in the Installation of OBIEE 11.1.1.7.0 on new Production server and applied the patches to upgrade OBIEE to 11.1.1.7.131 that includes Mobile Application designer feature.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.7.0/11.1.1.7.13/11.1.1.7.14 , Windows 7 / Windows Server 2008, SQL Server 2008, SQL Server Management Studio 2008, Microsoft Visual Studio Team Foundation Server 12.0

Confidential, Columbia MD

Sr. Oracle BI Consultant

Confidential is an established consulting organization with a proven track record delivering a broad range of solutions with particular expertise in Software and Cloud Application Engineering, Data Management, Software Quality Assurance, Security and Privacy, and Managed Business Services innovations. In the Health IT landscape, Confidential acts as an implementing partner for the Centers for Medicare & Medicaid Services (CMS), a federal agency within the United States Department of Health and Human Services (DHHS) that administers the Medicare program and works in partnership with state governments to administer Medicaid, the State Children's Health Insurance Program (SCHIP), and health insurance portability standards.

Responsibilities

  • Worked extensively on Oracle BI Publisher Audit (OOTB) and Operational reports (Custom).
  • Analyzed business requirements documents.
  • Created high-level and detailed design documentation.
  • Installed jrockit (jdk1.6) and weblogic 10.3.6 in Dev and Test environments.
  • Ran RCU (repository creation utility) 11.1.1.6.0 and created BIPLATFORM and MDS schema’s in Dev and Test environments.
  • Installed Oracle BI Publisher 11.1.1.6.0 in Dev & Test environments.
  • Configured the weblogic domain for BI Publisher for both the environments.
  • Involved in the up-gradation of out of the box Oracle Fusion Middleware Audit (Access Manager, Identity Manager, Virtual Directory, Internet Directory etc.) Reports from BI Publisher 10g to 11.1.1.6.0. using upgrade assistant wizard.
  • Created the JDBC’s and configured the reports pointing to this JDBC’s.
  • Used Oracle SQL Developer to debug the SQL query issued during report execution and also to identify the data discrepancies.
  • Optimized the SQL Query to improve the performance.
  • Customized the SQL queries as per the data attributes available within the database.
  • Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Worked extensively on customization of audit Report layouts (Tabular, Pivot Table and Chart View) using RTF template as per the client requirements.
  • Created and configured datasets using query builder, LOVs (list of values) and parameters for building the data-model component of Operational reports.
  • Worked on layout editor feature for defining the templates/layouts of operational reports.
  • Implemented and managed BI security using Oracle Virtual Directory as an LDAP.
  • Created new Users & custom user Groups and associated the users to the groups in Oracle Identity Manager.
  • Created custom Application Roles and mapped them to the User Groups in Fusion Middleware Control / BI Enterprise Manager.
  • Implemented and Managed object level security using custom User groups/Application roles in Dev environment.
  • Worked closely and supported testing team in preparing test scripts, establishing test data, executing test scripts, recording and fixing defects in Bugzilla 3.2.10.
  • Migrated Reports from Dev to Desktop environment and Desktop to Test environment using winscp.
  • Migrated security.xml file from Dev to Test environment to replicate object level security.
  • Prepared Oracle BI Publisher Installation and configuration reference document to support the Infrastructure team for further installations in Implementation and Production environments.
  • Prepared deployment documents for migrations from Test to Implementation and Implementation to Production environments.
  • Worked closely with DBA’s for all the Database related issues.
  • Took the ownership of managing the admin and managed servers in Dev and Test environments.
  • Coordinated with development team and updated the project status to the development manager.

Environment: Oracle Business Intelligence Publisher 11.1.1.7.0/11.1.1.6.0 , Windows 7, Oracle 11g, Oracle SQL Developer 11g, Bugzilla 3.2.10, Redhat Linux 6.0, MobaXterm 6.5,winscp 5.1.4 .

Confidential, San Francisco, CA

Sr. OBIEE Consultant/Offshore Co-Ordinator

Confidential is a technology company that specializes in improving the performance of networks and networked applications. Riverbed's main product is the Steelhead Appliance, a networking appliance that combines several techniques to optimize data traffic and bandwidth utilization across a wide area network.

Responsibilities

  • Analyzed business requirements documents.
  • Created high-level and detailed design documentation.
  • Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
  • Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Views and defined Fact & Dimensions using the foreign key joins in the physical layer of the repository.
  • Created and modified logical tables, logical columns and defined complex joins.
  • Created dimensions, dimensional hierarchies, levels, level based measures and defined level, attributes level keys.
  • Used expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
  • Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters) as per the client requirements.
  • Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports via email using BI Delivers.
  • Involved in the up-gradation of OBIEE repository and web catalog from OBIEE 10.1.3.4.2 to 11.1.1.6.9. using upgrade assistant wizard.
  • Implemented and managed OBIEE security using LDAP and External Authentication.
  • Created new Users & user Groups and assigned the users to the groups in OBIEE 11g Administration Console.
  • Created Application Roles and mapped them to the User Group in OBIEE 11g Enterprise Manager.
  • Implemented and Managed object level and data level security using custom User groups/Application roles.
  • Worked closely and supported with the business users in preparing test scripts, establishing test data, executing test scripts, and recording defects in JIRA.
  • Migrated OBIEE Repository from Dev to Test and Test to Support environments using UDML.
  • Migrated OBIEE web-catalog from Dev to Test and Test to Support using catalog manager.
  • Prepared OBIEE code migration documents and submitted requests for migrations from Support to Prod.
  • Coordinated with offshore development team and helped them with the roadblocks/concerns on the project.
  • Used Oracle SQL Developer to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.7.0/ 10.1.3.4.2 , Windows 7, Oracle 11g, Oracle SQL Developer, JIRA.

Confidential, Pittsburgh, PA

Sr.OBIEE Consultant/Offshore Co-ordinator

Confidential is one of the U.S based largest financial services corporation. It is a diversified financial institution, which includes a regional banking franchise operating primarily in 15 states and the District of Columbia. It offers a wide range of services for all customers, from individuals and small businesses, to corporations and government entities. It stands sixth largest bank by deposits and is the third largest bank off-premise ATM provider in USA.

Responsibilities

  • Analysis, functional/technical Requirements Gathering, Design, Development, Testing, Deployment, Maintenance, Documentation and Support.
  • Interacted regularly with Business Users and gathered Report Specifications.
  • Created high-level and detailed design documentation.
  • Analyzed the logical Data model of the target systems and implemented it on local machine with sample MS Access data source to build mock up reports using Oracle SQL Developer tool.
  • Created mock-up reports and dashboards for review by the business users.
  • Worked extensively on Physical Layer, Business Modeling & Mapping Layer and Presentation Layer for Configuring, Creating and developing meta-data using OBIEE Administration tool.
  • Created Database objects, Connection Pools, Schemas, Physical tables, Alias tables, Views and defined Fact & Dimensions using the foreign key joins in the physical layer of the repository.
  • Created and modified logical tables, logical columns and defined complex joins.
  • Created dimensions, dimensional hierarchies, levels, level based measures and defined level, attributes level keys.
  • Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
  • Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Worked extensively on OBIEE web services to create Reports / Dashboards from a variety of data sources with different Analytics Views (Tabular, Pivot Table, Chart, Static Text, Column Selector and View selector with global and local Filters) as per the client requirements.
  • Configured Intelligence dashboards by adding included and embedded content such as sections, Folders, Text, Links/Images, Guided navigation links, HTML objects for navigation.
  • Created multiple OBI variables like Repository Variables, Session variables, and Presentation variables for the implementation.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports via email using BI Delivers.
  • Involved in up-gradation of OBIEE rpd and web catalog from OBIEE 10.1.3.4 to 11.1.1.6.2
  • Prepared OBIEE code migration documents and submitted requests for migrations from Dev to QA and QA to Prod.
  • Worked closely with the BI Admin team for all code migrations, code validations, creation & granting required permissions for all users and security groups.
  • Worked on Oracle BI Publisher for Pixel perfect reports and integrating them with Dashboards.
  • Customized BI Publisher reports to meet the requirement by creating RTF (Rich Text Format) Templates using BIP Template Builder for Word.
  • Worked closely and supported testing team in preparing test scripts, establishing test data, executing test scripts, and recording defects in Mercury Quality center/HP ALM.
  • Worked closely with DBA and Data Modelers for all the Database related issues.
  • Coordinated with offshore development team for couple of the projects and helped them with the roadblocks/concerns on the project.
  • Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.
  • Prepared functional & non-functional, Requirement Report Matrix and RPD documents by reverse engineering as a part of Production support documentation.
  • Trained Users on the generated reports for the projects.
  • Also worked as a Production Support Developer and resolved real time issues.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.6.2 /10.1.3.4, Windows XP, Toad 10.6, Oracle 10g Enterprise Edition, SQL*Plus, Oracle 11g, SQL Server 2005, Oracle Essbase 11g, Oracle SQL Developer, Oracle BI Publisher 10.1.3.4, Mercury Quality Center 9.0/HP ALM 11.

Confidential, Atlanta, GA Sr.OBIEE Developer

Responsibilities

  • Involved in gathering the requirements, performing scope analysis and identifying gaps.
  • Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
  • Created mock-up reports and dashboards for review by the business users.
  • Involved in the development of Metadata repository (.rpd) as per user requirements and available information in Data Warehouse.
  • Created connection pools, defined joins and implemented authorizations in the Physical Layer of the repository.
  • Imported required physical tables (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool and defined Physical Joins using new foreign key join.
  • Worked extensively on BMM (Business Model and Mapping) layer using Star Schema.
  • Created Logical Tables, Logical Facts, Complex joins between various Dimension and Fact Tables, additional Metadata in the Business Model & Mapping Layer Created Drill-Down Hierarchies and set the estimated levels in Hierarchies, Logical columns.
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Worked on the Time Series function and implemented time comparison sales.
  • Created materialized views and aggregates to improve performance.
  • Customized the Presentation layer model objects and Re-named the data as necessary for the set of users.
  • Analyzed and validated the repository file by performing check global consistency.
  • Developed many Reports with different Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Web Answers and assigned them to application specific dashboards.
  • Debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment.
  • Worked on Oracle BI Publisher for Pixel perfect reports and integrating them with Dashboards.
  • Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.
  • Configured iBots to deliver Analytics content based on schedule.
  • Created proactive agents iBots (BI Scheduler) and interactive Dashboards and sent Alerts to High Level Client Users.
  • Implemented security by creating roles & web groups, checks with External tables and LDAP.
  • Involved in migration of Analytics .rpd and Web Catalog objects from developing environment to QA environment and to the Production environment.
  • Trained Users on the generated reports for this project and documented the work.
  • Participated in Post implementation reviews with the Project teams.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.4, Oracle BI Publisher 10.1.3.4, Oracle 10g, SQL*Plus, Sun-Solaris.

Confidential, Memphis, TN

OBIEE Developer

Confidential is a global network of companies that provides integrated business applications through operating companies competing collectively and managed collaboratively, under the respected Confidential brand. Confidential has grown to become the world's largest express transportation company, providing fast and reliable delivery to nearly every address by air, surface and ocean solutions to meet your unique needs. It provides direct-distribution services that make it easy to move your goods across borders to customers and retail stores, bypassing distribution centers and cutting fees and time to market

Responsibilities

  • Extensively worked on Answers, Dashboards and Security for users.
  • Worked on creating complex reports.
  • Modeled the Logical Layer based on the Business requirements in the Business Model and Mapping Layer and Developed the necessary Star Schemas.
  • Created Users, Groups by establishing a Connection to the existing LDAP Server.
  • Worked on security for user based on external table authentication.
  • Created Initialization Blocks and variables to call VPD Functions for establishing Client Level Data Security.
  • Created various Static and Dynamic variables for different report and Security requirements.
  • Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
  • Managed security privileges for each subject area according to user requirements.
  • Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
  • Generated custom reports by using OBIEE report features like Pivot tables, Charts, Ticker, Narrative and View selector.
  • Assigned the customized reports to application specific dashboards.
  • Maintained effectiveness in creating the Dashboards by appropriately including global prompts, column selectors, guided navigational links, and automatic drill-down.
  • Created user level security for intelligence dashboards based on Business Requirement.
  • Used Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
  • Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
  • Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
  • Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.
  • Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
  • Modeled time series and slowly changing dimension (SCD) data in OBIEE Analytics.
  • Trouble shooted errors in the BI Server and made backups for RPD’s.
  • Interacted regularly with Business Users and gathered Report Specifications.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.3, Oracle 10g, Windows XP, Oracle SQL Developer.

Confidential, SFO, CA

OBIEE Developer

Confidential is a diversified financial services company providing banking, insurance, investments, mortgage and consumer finance through Confidential and Wachovia stores, Confidential and Wachovia ATMs, the internet and other distribution channels across North America and internationally.

Responsibilities

  • Worked closely with Business Analyst in understanding the requirements and created the business model for generating reports as per the requirements.
  • Extensively worked on OLAP and OLTP systems existing in different DB systems like Teradata v2r5, Oracle DW, and XML files.
  • Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager. The objective is to extract data stored in different databases such as Oracle, SQL Server, Flat Files and Excel Files and to load finally into a single Data Warehouse i.e. Oracle.
  • Developed many complex Informatica ETL process and Oracle Packages i.e., Mappings & Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) and Workflows with Sessions / Tasks.
  • Extensively used Informatica (PowerCenter Designer, PowerCenter Workflow manager) to load data from Flat Files to Oracle 10g.
  • Generated Complex queries, Stored Procedures, Functions using SQL, PL-SQL.
  • Created the High Level Design Document (HLD) and Technical detailed design document (TDD) of Repository.
  • Developed the Metadata Repository (.rpd) using BI Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer using connection Pool.
  • Created multiple Dimensions (Drill-Down Hierarchies) & Fact objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
  • Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
  • Created materialized views and aggregates to improve performance.
  • Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
  • Customized reporting with OBIEE Answers and integrated them into the Dashboards.
  • Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector. Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
  • Created user level security for intelligence dashboards based on Business Requirement.
  • Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
  • Created Dashboards with Dashboard prompts, Charts, Pivot tables.
  • Involved In Analyzing the ER-Diagrams.
  • Optimized/Tuned the database design.
  • Performed Data Validation of data in the reports and dashboards.
  • Involved in Data migration and Data distribution testing.
  • Extensively used SQL Tuning to improve performance.
  • Created iBots to send pre-processed reports using OBIEE Delivers.
  • Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
  • Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
  • Documented the design for intuitive understanding and future reference .

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.2, Oracle 10g, Toad, SQL* Plus, Informatica 7.1, Oracle 9i,Teradata v2r5, Windows Server 2003 R2.

Confidential, INDIA

Oracle Database Developer

Confidential is the largest engineering and manufacturing enterprise in India in the energy-related/infrastructure sector. It manufactures products under major product groups and caters to core sectors of the Indian Economy viz., Power Generation & Transmission, Industry, Transportation, Telecommunication, Renewable Energy, etc. It promptly serves customers and provides them with suitable products, systems and services -- efficiently and at competitive prices.

Responsibilities

  • Involved in gathering business requirements, and designed the process flow.
  • Involved in design and re-structuring of the Database.
  • Imported data from various file formats into staging tables using SQL*Loader, perform validations prior to transferring data into Oracle Interface tables.
  • Created Database objects like Tables, Views, Primary Keys, Indexes, Constraints, Grants, Synonyms and Sequences.
  • Designed and developed Stored Procedures, Functions, Cursors, Packages and Triggers using PL-SQL as per the business process.
  • Developed complex procedures to handle errors and exceptions at database level using PL-SQL.
  • Developed Data entry screens, Master screens and transaction screens with Triggers, Alerts, and Multiple Windows using Forms 6i.
  • Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
  • Generated complex financial Reports, Purchase Order Reports using Reports 6i.
  • Generated PDF files for documentation purpose and future references .
  • Monitored software functionality.
  • Trained end users for effective usage of the software package.

Environment: Oracle 9i, SQL, PL-SQL, SQL*PLUS, SQL*Loader, Forms 8i, Reports 8i, TOAD, UNIX, Windows Server 2003.

Hire Now