SUMMARY

• Over seven years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Business Intelligence tools/applications.
• Expert in using OBIEE and BI Publisher 11g/10g, OBIA 7.9.x, Siebel Analytics 7.x, Extraction, Load and Transformation (ELT) using Oracle Data Integrator (ODI) 11g, Informatica 9.x/8.x/7.x and SQL, PL/SQL.
• Expert in developing dynamic interactive dashboards with guided navigations, action links, drill - down, master-detail reports and dashboard prompts.
• Configured and customized OBIA out of Box Reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Experience in designing and testing mappings, mapplets and workflows using Informatica Power Center.
• Familiar with Oracle EBS concepts of Financial Analytics, Spend Analytics and Supply Chain modules.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements.
• Expert in creating and deploying Metadata Repository Layers: Physical layer, Business Model and Mapping (FACT and Dimensional Tables) layer and Presentation Layer.
• Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables as per business requirements.
• Experience in setting up Session Variables, Repository Variables and Server Variables using Initialization Blocks.
• Expert in tuning performance by utilizing aggregate tables, caching, and setting query limits etc.
• Worked on various complicated scenarios of Simple and Complex joins.
• Strong Knowledge of Data warehouse Application Console (DAC) Architecture and created Execution Plans, Subject Areas, Tasks and Repository Management.
• Experience in migration techniques forOBIEEcomponents into various test and production environments.
• Experience in Security Setup at both Object levels and Data levels which includes creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUDE) also Experience in applying Out of box type Object Level and Data Level security (Decentralized Security Model) for Dynamic Groups in LDAP using DBMS LDAP Package.
• Implemented the extraction, loading, and transformation (EL-T) of data using Oracle Data Integrator.
• Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator and configuring the ODI master and work repositories, ODI models defining and organizing the ODI project including interfaces, packages, procedures, variables and user defined-functions.
• Involved in various Admin tasks such as setting up security, new users and configuring ODI on new machines.
• Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM and CKM. Customized versions for the existing ODI Knowledge modules which can be re-used in data integration projects.
• Expertise in developing ODI objects - Project, Model, interfaces, Yellow interfaces, Procedures, Filters, Models, Load plans and generating / regenerating ODI scenarios.
• Experience in implementing Change Data Capture (CDC), Slowly Changing Dimension (SCD) type 1, type 2, type 3 using ODI.
• Strong Knowledge and understanding of Relational Databases (Oracle and SQL Server), data warehousing concepts and querying tools.
• Experience and Strong understanding as Oracle BIEE Developer to design and Implementation of Data Warehouse/Data Mart, transactional data modeling and dimensional modeling, experience in gathering Business Requirements, performing Analysis, Design / Data Modeling, Development, Testing using agile development techniques.
• Used both the BI Publisher Standalone and integrated with OBIEE 11g to meet business requirements
• Very strong in Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects.
• Optimized the Solution using various performance tuning methods like SQL tuning, ETL tuning (i.e. optimal configuration of transformations and memory parameters), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions etc.
• Experience with working on OracleDirectoryServiceManager (ODSM), OracleInternetDirectory (OID) andOracleVirtualDirectory (OVD) for authentication of users.
• Experienced in applying Software development life cycle like Agile software development for proper planning, development and delivery of project in time.
• Excellent Written and Verbal Skills; Ease to learn and apply new technologies and improve processes.

TECHNICAL SKILLS

BI Tools: OBIEE 11g/10g, OBIA 7.9.6, BI Administration Tool, BI Publisher.

ETL Tools: ODI 11g (v.11.1.1.7/v.11.1.1.3), Informatica 9.x, 8.x, 7.x.

Databases: Oracle 10g/11g/12c, MS SQL Server 2005/2008, DB2.

SQL Tools: SQL plus, SQL Developer, TOAD

Oracle Directory Tools: ODSM 11g, OVD 11g, OID 11g.

Reports: BI/XML Publisher

PROFESSIONAL EXPERIENCE

Confidential

Sr. OBIEE Developer

Responsibilities:

• Gathered and analyzed the business requirements and defined their relationships with existing Business entities.
• Stakeholder matrix mapping to understand needs and project influence for increased technology adoption.
• Led the team in business intelligence solutions development.
• Worked closely with the ETL and Database Team to coordinate the Necessary Data movement
• Worked with multiple sources such as Relational database, Flat files for Extraction, Transforming and Loading data into target tables.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and Filters.
• Worked on Oracle Answers/Analytics to build Interactive Dashboards with drill-down capabilities.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Worked on Security Functionality and Identity Management by creating users & web groups in the LDAP using OID and ODSM directory tools.
• Worked with team to implement a Decentralized Federation Model of Security, allowing each of the Local Educational Agencies to maintain their own user credential stores, and validating user identities locally.
• Implemented Single Sign-On (SSO) between MSDE and Local Educational Agencies thus removing the need for manually copying user credentials and information between Local Educational Agencies and MSDE.
• Used DBMS LDAP package to get the User and Group Attributes from the LDAP.
• Created table views out of User and Group Attributes for Data Level Security using DBMS LDAP package.
• Created session variables using the table views in the data base and used session variables for Data Level Security.
• Integrated Dynamic Groups and Users in the LDAP using OVD Authenticator into the Web logic Console.
• Created the Roles in the Enterprise Manager (EM) for the Dynamic Groups.
• Created Catalog Groups out of the Roles in EM and used them to apply Object Level Security on the Dashboards.

Environment: OBIEE 11.1.1.7.1 , SQL*Plus, PL/SQL, SQL Developer, TOAD, DBMS LDAP Package, ODSM 11g, OID 11g, OVD 11g

Confidential, Kansas City, MO

Sr. OBIEE/ODI Developer

Responsibilities:

• Worked closely with executives, senior leadership teams, management and business analysts in business process modeling and mapping, and the understanding of business requirements.
• Created the business models from business cases and enterprise architecture requirements for process monitoring, improvement and reporting and led the team in business intelligence solutions development.
• Worked on the ETL processes, generating load plans and running them.
• Installed and configured ODI for Multi-User Development Environment.
• Created ODI design documents from the existing mappings and used these design documents in development of interfaces/packages.
• Configured and setup ODI, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition.
• Created the users, profiles using the ODI security manager and also Performance tuned the ODI interfaces.
• Worked closely with the ETL and Database Team to coordinate the Necessary Data movement to make data available for reporting.
• As per requirements, developed metadata repository, configured metadata for the business model and mapping layer from physical data models.
• Importing table metadata for creating the physical joins/keys required.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer.
• Established the logical joins/keys required to support drill-down aggregation.
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, testing and validating the models using OBI Administration tool.
• Created dimension hierarchies and assigned levels for each level.
• Designed and configured dashboards in Analytics for different groups of users to view figures across regions, products with the facility to drill down to individual customer relationship manager.
• Configured iBots/Agents to deliver Analytics content based on a schedule, automated iBot queries to obtain weekly reports and updates.
• Implemented the delivery of iBots/Agents using OBI Delivers to alert the associated teams, security groups and individuals.
• Performed diagnostic test to optimize performance through caching, setting logging levels and enabling and monitoring usage tracking.
• Worked on Oracle Answers/Analytics to build Interactive Dashboards with drill-down capabilities.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and Filters.
• Responsible for Unit and System Testing and Performed Data Validation for all the reports that are generated from OBIEE.
• Assisted in creation of reporting views, allowing management to analyze the business from different perspectives, and also provided optimized analytics requests using column selector.
• Environment management and monitoring using Enterprise Manager and Web logic Console.
• Testing and recommendation of BI tools and solutions.

Environment: OBIEE 11.1.1.7.1 , ODI 11.1.1.7, Oracle 11gR2, SQL*Plus, PL/SQL, SQL Developer, TOAD.

Confidential, Albany NY

OBIEE/ODI Developer

Responsibilities:

• Performed Project Scoping, Organization and Management including Business and IT Requirements.
• Installation and setup of Oracle BI Applications in Development, Test and Production environments.
• Designed, developed and tested reports for Oracle Financial Analytics modules (GL, AR, AP and Employee Expenses) as per the requirements.
• Designed and modified ETL Mappings using Informatica to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse.
• Installed and configured DAC client and server.
• Created custom mappings for the data sources - flat files, and Oracle.
• Worked closely with the Project Manager and Data Architect and assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Analysis, Design, Implementation and documentation for various projects for reporting aspect i.e. OBIEE metadata/logical/physical data models.
• Design, develop and implementation of complex OBIEE user interface objects (e.g. reports, analytics, adhoc queries, dashboards, etc.)
• Did configurations for OBIEE (Multi User Development Environment MUDE, Usage tracking, iBot(scheduling), Security Model using LDAP authentication) and BIApps ( Roles, responsibilities, security model)
• Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE.
• Configured caching options and defined overall cache strategy.
• Worked on Initialization Blocks and Variables development to achieve security and personalization.
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Contrived different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Formulated custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards and dashboard prompts.

Environment: OBIEE 11.1.1.7.1 , Informatica, OBIA 7.9.6.4, Oracle 11g, SQL*Plus, PL/SQL, SQL Developer, TOAD.

Confidential, Webster, MA

OBIA/OBIEE Developer

Responsibilities:

• Installation and setup of Oracle BI Applications in Development, Test and Production environments.
• Designed, developed and tested reports for Oracle Financial Analytics modules of AP, AR and GL as per the requirements.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse.
• Installed and configured DAC client and server to work with Oracle BI Applications and Informatica.
• Defined Repository objects in DAC (tasks, task groups, subject areas etc.)
• Customized, ran and monitored ETL execution plans.
• Customized out of the Box OBIA reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Converted Discoverer EEX files into OBIEE RPD files, configured the metadata and recreated the required reports using Discoverer Metadata Conversion Assistant.
• Setup of Multi User Development Environment (MUDE) in OBIEE.
• Created OBIEE Repositories 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 and cache management.
• Responsible for implementing and managing security at both Repository Level and Presentation Catalog Levels.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors and warnings.
• Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports. Managed dashboard and request security/privileges in the analytics catalog manager.
• Successfully implemented OBIEE delivers/Created Proactive agents (iBots) and configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Configured, Designed and developed BI Publisher reports according to client’s requirement.
• Involved in merging changes of Repository and Web catalog from development to test and production environments.
• Migrated Repository and Web Catalog files between development, test and production environments.
• Trained and assisted Business users to generate their own reports.

Environment: OBIEE 11.1.1.6.x, OBIA 7.9.6.3 (AP, AR, GL), Informatica Power Center 8.6, DAC 10.1.3.4, Oracle 11g, Oracle EBS R12, Oracle BI Publisher, SQL*Plus, SQL Developer, TOAD

Confidential

OBIEE Developer

Responsibilities:

• Worked closely with business users and BI team which built reporting solution for the Sales BI Project and gathered business requirements.
• Designed the required reports for the FC Supply Agreement module to meet the business requirements.
• Worked closely with the Data Modeling team in understanding the business requirements and generated DDL scripts for the target tables as per the FC naming standards - column, table, index, etc.
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management and Variables.
• Responsible for implementing and managing security at both Repository Level and Presentation Catalog Levels.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Developed dimensional hierarchies based on the business requirements of an attribute.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Built test cases and tested the Repository/Reports by comparing the SQL Output on the Data warehouse to the values in the Reports and documented the test results.
• Worked with OBIEE Answers and created required reports. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, guided navigation, customization, conditional formatting of reports.
• Responsible for maintaining and troubleshooting issues on the servers. Migrating RPD and Web catalog between different environments.
• Designed the Business Requirements document and Technical Design document as per the company format.

Environment: OBIEE 10.1.3.4.1 , Oracle 11g, SQL Developer, Oracle EBS R12, Data modeler.

Confidential

Siebel Analytics Report Developer

Responsibilities:

• Develop new Data models and customize existing Data Models and Reports as per business requirements.
• Designed and Developed RPD (Physical Layer, Business Model / data mapping and Presentation Layer).
• 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).
• Provide technical and functional support to users and help them in understanding reports and ad-hoc analysis.
• Scheduled and configured the BI Scheduler for iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Develop reports as per user requirements and migrate all data from legacy application to Siebel Analytics.
• Implemented report level security in Siebel Analytics.
• Perform testing, resolving defects and coordinate with Oracle support.
• Work on complex problems where analysis of situations or data requires an in-depth evaluation of various factors and Worked on developing complex reports for end users.
• Responsible for Application performance and bug fixes.

Environment: Siebel Analytics 7.x, Oracle 9i, SQL Developer, Toad, UNIX/Linux, Windows 2003 & 2008 server.

Confidential

Oracle Developer/Report Developer

Responsibilities:

• Reverse Engineered database design and interfaces.
• Wrote complex Views, Materialized views for application interface needs.
• Involved in writing PL/SQL Stored Procedures.
• Involved in developing reports using Oracle forms.
• Tuned and enhanced existing SQL Queries for improving Performance.
• Involved in writing Shell Scripts using Korn shell and AWK.
• Data was inserted and updated into back end using SQL.
• Conducted unit testing of other modules and reported bugs.

Environment: Oracle, Toad, SQL, PL/SQL Stored procedures, UNIX, Siebel Analytics 7.x, sun Solaris.