Summary

• 8 years of experience in IT industry mainly in Design, development, implementation, testing and documentation of business applications using Oracle technologies.
• 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 .
• Expert in data modeling, Normalization, database design, data loading, data retrieval and modification.
• Extensive 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.
• Experience in Logical Physical design modeling using Erwin.
• Extensively worked on data modeling Star schema .
• 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.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.

Technical Skills

.

Professional Experience

Confidential

Role : Sr. OBIEE Developer

Environment: OBIEE 11G/10.1.3.3, Oracle Delivers, Informatica Power Center 8.1/8.6, Data Warehouse Administration Console DAC , Windows XP, UNIX, Shell Scripting, Oracle 11g/10g, MS Access 97/2000, PL/SQL, and TOAD 6.3/7.0,SQL

Responsibilities:

• Upgraded data warehouse from OBIA 795 to 7962. This involved Financial, Sales and Procurement module with pre built and customizations.
• Upgraded OBIEE 10.1.3.4 to 10.1.3.4.1 and to OBIEE 11G.
• Upgraded Informatica from 811 to 861
• Upgraded DAC from 795 to 10.1.3.4
• Guide offshore BI team members in Oracle OBIEE applications and standards for interfaces.
• Worked on Access database to design input forms for plan and forecast data.
• Analyzed the business requirements by partnering with business and application developers to create conceptual data models and identify the facts, dimensions, business logics needed to build the reports.
• Participated in various interactive meetings with different users and business analysts for a clear understanding of the Business requirements and to bridge the gap between user needs and tool functionalities.
• Developed interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters using OBIEE Answers.
• Created Filters and provided customized prompts appropriately to avoid excessive data showing up on reports.
• Generated Reports and Dashboards by using Report features like pivot tables, charts and view selector.
• Created many pivot table requests allowing manager's to analyze the business from different perspectives.
• Created new ETL routines for modeling and extracting Sales data from Oracle and POS data from 3rd party vendor.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges.
• Created dimension hierarchies, aggregates and keys in the BMM layer.
• 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.
• Configured iBots and Delivers to send alerts to subscribed users.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Implemented and worked in MUD Multi User Development Environment.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Created Initialization blocks and worked on repository and session variables.
• Worked on integration Essbase cubes with OBIEE to build reports across Relational and Multi-dimensional database.
• Performed Data Validation of data in the reports and dashboards.
• Extensively used SQL Tuning to improve performance.

Confidential

Role : Lead OBIEE Developer

Environment: OBIEE 11.1.1.6, Informatica 9.1, OBIA 7.9.6.3, Windows XP, UNIX, Shell Scripting, Oracle 11g, PL/SQL, and TOAD 10.1,SQL

Responsibilities:

• Gap analysis between OBIA and existing legacy BI system and close the gaps.
• Interprets requirements data, maps current and future state business processes to the packaged application.
• Develops plans to address functional gaps between the packaged application and the redesigned processes by building custom schema, ETL mappings, answer reports and dash boards in OBIEE 11G.
• Customize out of box dashboards per user requirement and specifications.
• Build around 30 new star schemas from different legacy and Oracle sources to support around 300 legacy reports in OBIEE.
• Guide other BI team members in Oracle OBIEE applications and standards for interfaces.
• Manages internal client expectations and balances the needs of the company and the client to ensure satisfaction
• Performance Tuning of Dashboards/Reports.
• Held interactive meetings with business users for a clear understanding of the Business requirements and to bridge the gap between user needs and tool functionalities.

Confidential

Role : OBIEE Developer

Environment: Siebel Analytics, OBIEE 10.1.3.3, Oracle Delivers, Oracle BI Publisher, Informatica Power Center 8.1, Data Warehouse Administration Console DAC , Windows XP, Oracle 10g, PL/SQL, and TOAD 6.3/7.0,SQL

Responsibilities

• Customized and developed RPD Physical, BMM and Presentation Layer , configured metadata objects and Web Catalog Objects
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Siebel Analytics Web.
• Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• Developed many PL/SQL procedure functions and used the same in mappings, pre and post sessions.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Upgraded Siebel analytics, Informatica and DAC to latest versions.

Confidential

Role: PL/SQL Developer

Responsibilities:

• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.
• Used Microsoft Visio to design the workflow diagrams necessary for the application.
• Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Interfaced Perl with Oracle database for the data feeds generation.
• Written Shell Scripts, control files to load data into staging tables.
• Optimization of SQL queries using EXPLAIN PLAN.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Migration of data from flat files into database tables using SQL Loader.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Fine tuned the SQL queries using Explain Plan and applying appropriate hints and indexes.
• Effective Interaction with Support and other Application groups for high priority issues
• Detected and corrected bugs, managed open, closed and reopened defects using defect tracking system JIRA.

Environment: Oracle 11g, Pl/SQL, SQL Loader, PERL, SQL Navigator.