SUMMARY

• IT professional with over 7 years of progressive expertise in gathering and analysing the requirements, building an application design, development and testing with a comprehensive background in Database and Data Warehouse developments and providing business intelligence solutions using OBIEE reporting tools.
• Perform variety of roles including Designer, Analyst, System Integration Specialist. Particularly excel at techno - functional roles that require liaison between user groups and IT.
• Experience with Data Integration and Analysis for Decision Support Systems in Banking, Pharmaceutical, Healthcare, Insurance, Sales and Telecommunication industry domains
• OverFive years of professional experience as a technicalERP Developer/ConsultantinOracle E-Business Suite Applicationswith expertise involved in end to end implementations of BI solutions for implementing Oracle Financial Analytics, Procurement and Spend Analytics, Human Resources, Supply Chain and Order Management Analytics.
• Over Seven years of strong experience in Extraction/Transformation/Loading of the data to Data Warehouse using Informatica Power Center 9.0.1, 8.6.1, 8.1,7.1.3,7.1/6.2,6.1/5.1.2 (Designer, Workflow Manager, Workflow Monitor).
• Involved in implementing prebuilt solutions in converting data from ERP systems like Oracle EBS into Enterprise Business Analytics Warehouse (BAW) with excellent knowledge of Business Intelligence concepts and involved in different phases of Software Development Life Cycle in Data Warehousing.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Centre and Data Warehouse Administration Console (DAC).
• Strong understanding of OBIEE 10g and 11g concepts, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges), its architecture and components (OBI Server, Oracle BI Presentation Services, Web cat file, config files and other tools and utilities).
• Extensive experience in building OBIEE Repository (.rpd) file, configuring OBIEE Analysis (Answers), Interactive Dashboards with drill-down & drill-across capabilities, Guided Navigation, Alerts (iBots), Security Setup (access privileges), Filters, setting up Roles - Profiles - Personalization.
• Configured and customized xls and rtf templates in BI Publisher for creating various pixel-perfect BI reports by connecting to the database and BI Server.
• Hands-on experience in developing Dimensional Hierarchies/New logical columns/Filters/Variables as per business requirements.
• Ability to enhance performance by understanding when & how to leverage aggregate tables, materialized views, table partitions, indexes, and managing cache etc.
• Expertise in Dimensional data modeling, Star schema modeling, ETL, OLAP, Data Normalization, and Physical & Logical Data Modeling.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, and transformations.
• Extensive experience with prebuiltOracle BI Appsfor HR and Financial modules.
• Extensive experience in writing SQL queries/reports, PL/SQL Stored Procedures, Functions, Packages, triggers for Oracle 11g/10g/9i/8i and tuning of SQL queries/scripts.
• Excellent working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Very good on working with Multiple Databases, in writing complex procedures and tuning performance.
• Expertise in Supply chain, Order Management and Financials (Account Receivable, Accounts Payable, General Ledger)
• Solid analytical & functional skills, ability to effectively communicate with technical & business audiences and expert negotiating skills while working with complex delivery variables and defining client requirements and ability to provide client executives with a comprehensive solution and coherent high level technical analysis.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

Business Intelligence: Oracle Business Intelligence Enterprise Edition(OBIEE) 11.x/10.xSibel Analytics 7.x, BI Publisher, OBIA 7.x.

ETL Tools: Informatica Power Center 9.x/8.x/7.x, DAC 10.x

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , MS Access

Operating Systems: Windows 2000/XP/vista/7, LINUX, UNIX (Solaris)

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, HTML, ASP.Net, C#

Web Based: HTML, XML, Dreamweaver

Tools: SQL*Plus, SQL*Loader, Oracle SQL Developer 2.1.x, TOAD

Data Modeling Tools: Microsoft Visio

Others: MS office, Adobe Acrobat

PROFESSIONAL EXPERIENCE

Confidential, MD

Sr. OBIEE developer

Responsibilities:

• Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.
• Played major role in upgrading OBIEE 10.1.3.4 to 11.1.1.5 and BI Apps 7.9.6 to 7.9.6.3
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation and Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, cache management and implemented business logic for facts and dimensions.
• Imported new tables and columns from the Data warehouse, created Physical and Logical Joins, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement, wrote Case SQL Statements to manipulate the data as per the needs in the rpd.
• Created connection pools, imported physical tables and defined joins in the physical layer of the Rpd.
• Customized out of boxDashboard pageslike General Ledger, Accounts Payable, Accounts Receivable, Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Financials,Supply Chain Analytics and Procurement.
• Created reports and schedule reports as per the requirement using BI Publisher and represented them in Web Application (dynamic/static scheduling)
• Worked on the security previliges of the repository by creating users, groups and setting up the data and object level security as well. On the web catalog, worked on creating dashboard users and groups and setting up section level permissions.
• Working on new security model introduced in OBIEE 11g. Implemented security using Weblogic server Administration console by creating and setting up users and groups. Used Enterprise Manager Middleware control to create and setup Application Roles and Application Policies. Setup the external table authentication and data visibility implementation.
• Developed/tested/migrated the RPD and web catalog in/from different Environments (Dev, QA, Production).
• Used BI answers to develop ad-hoc reports.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigation links, drilldowns, roll downs and slice & dice features.
• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships & Foreign Keys (Physical & Logical) between tables.

Environment: OBIEE 11.1.1.5/ 10.1.3.4.1 , Oracle Bi Apps 7.9.6.3/ 7.9.6 , Informatica 8.6.1, DAC, Oracle 11g/10g, Oracle EBS R12, Oracle SQL Developer 2.1.1, Windows 2003 Server/XP, RHEL 5.x.

Confidential, NY

Sr. OBIEE developer

Responsibilities:

• Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Interacted with end users and developers to validate the data model, requirement validation of the reports and drilldowns with business users
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Architecture design of business model. Identified Facts, Dimensions, and Hierarchies of the business model. Created complex calculated measures based on time dimension to calculate Quarter Ago and Year Ago metrics
• Effectively managed ODBC connections and imported the Physical tables, keys and physical joins from the databases.
• Responsible for BI/ETL architecture, installation, administration and implementation.
• Developed the OBIEE Metadata Repository using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Involved in completeProcure-to-pay(P2P) andOrder-to-Cash(O2C) life cycle.
• Customized out of boxDashboard pageslike General Ledger, Accounts Payable, Accounts Receivable, in Financials,Supply Chain Analytics.
• Used Informatica Mapping Designer to customize pre-built mappings using different transformations required to move data into data warehouse.
• Develop Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Created new requests and opened Answers for ad-hoc reporting to the End users
• Managed security privileges for users & groups using LDAP & SSO authentication, OS external database authentication/login as well as Dashboard/Report-level security.
• Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Utilized Oracle BI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to interactive dashboards for subscribed users.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables.

Environment: OBIEE 10.1.3.4.1 , Oracle 11g, Oracle Bi Apps 7.9.6.1, EBS HR, Informatica Power Center 8.6.1, Microsoft SQL Server Management Studio Express 9.0, SQL*Plus, SQL*Loader, Windows NT Server/XP, UNIX.

Confidential, Newark, NJ

Sr. OBIEE developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Involved in Installation, configuration and administration of OBIEE server and repository.
• Customize Out of the Box ETL Mappings/ Workflows/ RPD as per the Client Requirement.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Worked extensively on OBIEE and Siebel Analytics Metadata(RPD) Development, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation and Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, cache management and implemented business logic for facts and dimensions.
• Customized Star and Snowflake schemas by linking Fact and Dimension tables in the BMM layer.
• Worked on the security previliges of the repository by creating users, groups and setting up the data and object level security as well. On the web catalog, worked on creating dashboard users and groups and setting up section level permissions.
• Configured Analytics Metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Worked on building the Dynamic/Drill-Down Cascading Style sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters.
• Utilized Siebel Delivers/iBots for delivering reports, personalized alerts and schedule iBot for subscribed users.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity.
• Worked on Informatica Power Center for ETL purpose, for Data Extraction from ERP, Data Mapping and Data Conversion (Transformation) and Data loading into the BAW warehouse.
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters, Router, Source Qualifier, Sorter, Update Strategy, Normalizer, Rank, Expression, Sequence Generator Transformations) in Informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center.
• Used Informatica Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Responsible for customization of Prebuilt (OOB) Applications.
• Prepare “Performance Recommendation” Document to improve the performance of long running ETL Sessions.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.

Environment: OBIEE 10.1.3.3, Oracle BI Apps 7.9.5, Informatica 8.1.1, DAC, Oracle 11g, 10g, Oracle EBS, Oracle SQL Developer 1.5.5, SQL*Plus, Windows 2003 Server, UNIX.

Confidential, VA

OBIEE developer

Responsibilities:

• Gathered & reviewed customer Information Requirements for OLAP and building the data mart.
• Responsible for developing OBIEE repository (RPD) from the scratch. Worked closely with ETL team to understand and implement primary key, foreign key and composition key relationship among physical facts and dimension tables.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• Customized Oracle BI Repository defining Physical Data Layer and developed Business Model and Presentation Layer using Administration Tool.
• Created connection pools, imported new tables and columns from the Data warehouse and defined Physical joins in Physical layer and in Business Model Layer created Logical Joins, created Dimensional Hierarchies and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement, wrote Case SQL Statements to manipulate the data as per the needs.
• Worked on Security settings in Administration Tool to set up users, groups, access privileges and query privileges and also managed security for groups in Answers.
• Implement both object level and row level security based on roles and responsibilities of end user.
• Experienced in Data Warehouse and performed ETL procedure to load data from different sources into data- warehouse using Informatica Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Post Production support of the application.
• Extensively worked with performance tuning of the mappings, sessions and Stored Procedures.

Environment: OBIEE 10.1.3.2, Oracle BI Apps 7.9.5, Informatica Power Center 8.1.1, DAC, Oracle 10g, Oracle EBS, Oracle SQL Developer 1.5.5, SQL*Plus, Windows 2003 Server, UNIX.

Confidential, VA

ETL Developer

Responsibilities:

• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created Informatica mappings using Transformations like Sequence generator, Lookup, joiner and Source qualifier transformations in Informatica Designer.
• Created Complex mappings using Unconnected Lookup, Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Developed Informatica mappings and also tuned them for better performance.
• Created mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Created events and tasks in the work flows using workflow manager
• Created Schema objects like Indexes, Views.
• Designed and developed Oracle PL/SQL Procedures.
• Performance tuning of Oracle PL/SQL Scripts
• Designed and developed UNIX shell scripts.
• Developed views necessary for structured and ad-hoc reporting.

Environment: Informatica Power Center 6.2, Oracle 9i, UNIX Shell Scripting, SQL, PL/SQL, Toad, SQL * Loader, MS SQL Server 2000, Sun Solaris 2.6 UNIX, Windows XP.