SUMMARY

• Have 6+ years of extensive experience in the IT industry with 5 years of experience in Siebel Analytics/OBIEE
• Experience working with Different Domains like Insurance, Pharma, Telecom, Media.
• Have 1+ years of experience inBI Publisher.
• Expert in developing and analyzing of data warehouse applications using Siebel Analytics 7.7/7.8.2/OBIEE 10.1.3.x with windows/ Unix Environment.
• Proficient in creating, configuring and managing Dashboards, Reports.
• Expertise in gathering Business Requirements, GAP Analysis, Documentation.
• Well versed with Dimensional Modeling (Star and Snow flake) to build the Data warehouse developing and integrating data sources, Client/Server applications using Informatica and Oracle 10g.
• Managed to seed and purge the cache using iBots.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Experience in development and designing of ETL process for supporting data transformations and processing in a corporate wide environment using InformaticaPower Center 6.x/7.x/8.1
• Experience in writing, testing and implementing SQL/T-SQL, Stored Procedures, Triggers and Functions.
• Good experience in providing tier 3 support in resolving production issues.
• Optimized the Solution using various performance tuning methods (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 in prioritizing and resolving the Production issues.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using different Methodology.
• Strong experience in Extraction, Transformation, Loading (ETL) of data from various sources into target Data Warehouse and Data Marts using Informatica Power Center 8.1.
• Experienced in configuring, administering and managing the repository, creating complex reports and role based Analytics Intelligence Dashboards using OBIEE (Seibel Analytics).
• Developed iBots in OBIEE to automate report delivery, seed cache and provide alerts on Interactive Dashboards.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL's and reports that are generated from Informatica and OBI/Siebel Analytics.
• Worked on OBIEE features (i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Single Sign-on, Variables/Initialization Blocks configuration etc.).
• Has been involved in business-related project milestones such as in Requirements Gathering, Data modeling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

EDUCATION

• Bachelor of Technology

TECHNICAL SKILLS

Reporting/Data warehouse Tools : OBIEE 10.1.x.x/ Siebel Analytics 7.5/7.7 Informatica Power Center/Power Mart 7.x SQL*Loader Business Intelligence : OBIEE, Siebel Analytics, Oracle BI Publisher 10.1.3.4.0 Development Tools : Siebel Tools 7.7, 7.8, OBIEE 10.1.x.x Relational Databases : Oracle 9i/10g, SQL Server 2000/2005/2008, MS Access Database Languages : SQL, SQL*Plus, PL/SQL, UNIX shell scripts Web Technologies : JDBC, Java Script Programming Languages : C, C++, PL/SQL Operating Systems : Windows XP/2000/NT, UNIX Data Modeling : Power Designer, Erwin Case Tools : MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, GA Nov 09 - Till Date OBIEE Lead Developer

Project Description: OBIEE Global Human Resource Implementation ATT has implemented Oracle Business Intelligence Enterprise Edition (OBIEE) reporting environment and phase out reporting from Business Objects (BO) environment. During the implementation customizations has been minimized by reviewing existing practices and business processes and standardized them wherever possible. Responsibilities:

• Participating in requirements gathering of the various work streams by meeting with the business user and by analyzing the existing Business Objects Reports and base lining the details.
• Analyzing Functional documents, identifying the GAP's, designed Reporting Technical Specification documents.
• Analyzing and mapping Source System to target (table relationships) so that it meets the incremental requirements.
• Designing and developing the Informatica Mapping Documents.
• Developing and Implementing completely mappings, sessions and workflows for some of the Subject Areas, using the Informatica Power Center Designer, Power Center Workflow Manager.
• Configuring the DB connectivity to the Database (Informix) and also designed the Mapping Documents, Developing the mappings from the HiPath Procenter DB to the Target Tables Using the Informatica.
• Identifying key dimensions and measures for business performance, Developing Metadata Repository (.rpd) using Oracle BI Admin Tool.
• Building the new hierarchies, Logical Tables, Physical and Complex Joins according to the Client's Business without losing existing Functionality.
• Developing Reports / Interactive Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle Business Intelligence (OBI) Presentation Services, Oracle BI Publisher for the various work streams.
• Developing some of the reports using the BI Publisher, using the sql's OBIEE Answer queries. And also creating and uploading many layouts for the reports based on the requirement using the Microsoft Plug-Ins.
• Working with different data sources, like Informix, Oracle, Flat files, xml files, and handling huge data.
• Developing some flow charts using Microsoft Visio in connecting Informix to Oracle, and for better understanding of Informix tables and relationships.
• Enhancing performance of Reports /Interactive Dashboards by implementing the Aggregate tables, Materialized Views, Table execution path by making use of hints, Creation / Re-building of Indexes and managing Cache etc.,.
• Created Cache Purge and Cache Seed scripts and running them using Autosys. Creating/modifying jobs jobs in Autosys.
• Migrating reports/dashboards from development to QA environment using Catalog Manager.
• Implementing different levels of security by creating Users, groups using the OBIEE Admin Tool.
• Configuring iBots to deliver Analytics content based on schedule, automated iBots queries to obtain daily and weekly reports.
• Performing data validation between Oracle BI reports with Business Objects reports.
• Implementing query optimization techniques to improve performance of existing reports.
• Supporting UAT testing team for testing of enhance functionality/Bug Fixes.
• Supporting and coordinating onsite/offshore teams.
• Fixing some of the issues related to performance, data quality during production support.
• Conducting user training to familiarize them to the new reporting environment and to use the reporting infrastructure for effective decision-making.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.4, BI Publisher 10.1.3.4, Informatica 8.6.1, Oracle 10g, OBIA- Supply Chain Analytics, UNIX.

Confidential, New York, NY Feb 09 - Sep 09 OBIEE Developer

CRM Mobile Pharma Project Description: Forest Labs is one of the major Pharmaceutical companies. The project was on the extraction of Data from Siebeland other Systems and building the common operational data store for Forest Labs. By using this application end users have the capability to do Adhoc reporting. Responsibilities:

• Involved in the full life cycle implementation of Invoices Tracking Analytics Application used by Accounting Team to monitor the invoices made to Point-of-Sale (POS) customers, Commercial / Business customers and third-parties.
• Worked with Hyperion Dataware house as a datasource for generating reports.
• Involved in gathering requirements and translating business requirements into a business dimensional model preparation.
• Worked with different data sources like oracle, Teradata V2R5.1 imported them into the repository.
• Interacted with Billing and Account Receivables Subject Matter Experts (SME), Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Experience in configuring the metadata in all the three layers physical, semanticand presentation layers.
• Developed the repository model for the different work streams with the necessary logic (physical Joins and Logical Joins) that involved creating the Physical, BMM and the Presentation layer.
• Created session variables for users to provide data level security and used the session variable in OBIEE answers to build the query.
• Created dimension hierarchies, aggregates, level based measures, logical measures and logical table sources in the BMM layer.
• Worked on Windows platform (pre development environment) and UNIX platform (development/ test environment) to do the administrator tasks.
• Set up BI publisher Security to control access given to business users.
• Worked in ETL process using Informatica for various transactions and loading data from Relational Database and Flat Files.
• Developed Dashboards / Reports using different Views (Pivot Table, Chart and Column Selector, view Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Implemented Oracle's best practices in designing Dashboards/Reports.
• Created BI Publisher reports using OBIEE answer queries and published different templates, rendered into different output formats.
• Configured the security settings in OBIEE Admin tool/Presentation Services to setup users, Groups and grant/deny Access.
• Successfully implemented custom java scripts in reports/dashboards.
• Used customized prompts to avoid excessive data showing up in the reports
• Involved in Merging Repositories using administration tool and Web Catalogs using Catalog Manager (migration).
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes.
• Involved in Reconciliation Process Oracle BI Reports output with Excel Reports.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Used Toad for connecting to different databases and for data validation.
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Actively participated in meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: Oracle Business Intelligence (OBI) EE 10.x, Hyperion, Oracle BI Publisher 10.x, Oracle 10g, Informatica8.x, Toad9.1, TeradataV2R5.1, Linux.

Confidential, Hartland, WI Mar 08 - Jan 09 OBIEE Consultant Next Generation

Project Description: AQS Systems INCis one of the major insurance client which provides various plans across subsidiaries and the management of the company will be able to analyze which plans generates more revenue and who are all the competitors for that and how the service requests are handled. The agents will be able to receive the reports on a weekly basis by using delivers. Responsibilities:

• Involved in gathering the business requirement and completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Creating Interactive Dashboards, Answersusing OBIEE.
• Worked with Oracle BI Server, Presentation Server, Repository development and Oracle BI Administration.
• Involved in developing the Initial and Incremental ETL process i.e., Mappings using various Transformations in Informatica.
• Involved in set up of MUD Environment.
• Conducted meetings and Design sessions with Business Analysts from OLTP and OLAP to customization of Oracle Business Analytics warehouse (OBAW).
• Defined and documented the technical architecture of the data warehouse, including the physical components and their functionality.
• Involved in Installing and configuring 2-node Clustering Configuration (Active/Passive) in Windows Environment.
• Developednew Dashboards prompts, Filters, Customized Reports and Dashboardsusing OBIEE for Finance and Order management modules.
• Scheduled iBots and seeded BI server cache using Ibots to improve system performance. Also used iBots to clear server cache using NQCmd utility.
• Worked with SQL Performance Tuning for backend in order to resolve issue with Presentation services.
• Responsible for administration and migration of repositories between Development, Test (QA) and Production environments
• Extensively used SQL Tuning to improve performance.
• Adding users to the new group and applied the data level and object level security at the repository and Web cat.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Worked with all three layers in the metadata repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on LDAP, External table authentication and Database authentication types.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added data level security at the repository level. The data was restricted with respect to the group user belongs to.
• Created reports according to user requirements and also created corresponding dashboards for the reports.
• Scheduled reports and delivered the same to the end-users through Delivers.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.

Environment: Oracle BI Application 7.9.5, OBIEE 10.1.3.2, Informatica 8.x, DAC, Oracle10g, BI Publisher, SQL Developer, Windows, UNIX.

Confidential, New York, NYJan 07 - Feb 08 Magazine OBIEE Developer Project Description: Condenastis the world's leading document management technology and services enterprise. The zest of the project was Tracking Analytics Applications. With this project, Condenast advanced from Excel based reporting to OBIEE Reporting, achieving better performance and successfully reconciling collections to billing data. Responsibilities:

• Developed Ad-hoc and standard Reports / Dashboards with different AnalyticsViews (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Imported physical tables and creating the required aliases, views and creating the joins in the physical layer of the Metadata Repository(rpd)
• Developed the Facts, Dimensions, necessary hierarchies and the joins between the logical tables, adding aggregates in the BMM layer of the Metadata Repository(rpd)
• Analyzed and validated the business model in Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Implemented Security/Access privileges by creating roles & web groups, checks with External tables.
• Performance Tuning of Dashboards/Reports and made changes to database by overwriting the SQL execution path by making use of hints, aggregate navigation, etc.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations
• Creation of repository using Repository Manager.
• Used most of the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Router, Update strategy etc.
• Used Informatica Workflow Manager to create Sessions, Workflows to run with the logic embedded in the mappings.
• Created and Customized DAC Tables, Tasks, Subject areas, Execution plans.
• Unit Testingthe RPD and Presentation Reports

Environment: Oracle Business Intelligence suite 10.1.X (OBIEE), HR Module, Oracle 10g, Toad 8.0, Windows Adv Server 2003, PL/SQL, Informatica Power Center 7.x, MS Visio, Oracle BI Publisher 10.1.X

Confidential, CA Jan 06 - Dec 06 Siebel Analytics Responsibilities:

• Worked closely with Business Analyst, Discussed and Gathered the Analytics requirements from different user groups and created the Business Model using Star and Snowflake schemas.
• Installation, Configuration and Administration of Siebel Analytics.
• Creating Metadata Repository on Physical Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool.
• Creating dimensions, aggregations and levels using admin tool in the Business Model and Mapping Layer On Metadata Repository.
• With the Security settings in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges.
• Configuring repository & session variables to get dynamic reports and dashboard.
• Implementing Cache management to handle performance issue in report generation.
• Developed Dashboard prompts, Filters, Customized Reports and Dashboards using Siebel Analytics Web for Finance and Order management.
• Creating Users and Groups and assigning permissions depending on the user using Siebel Analytics Administration Tool.
• Configuring Siebel scheduler and generating iBots alerts for different threshold values in multi-task environment.
• Taking backups of Informatica Repository, Siebel Analytics Repository and Webcat files.
• Installed and configured Informatica repository server.
• Involved in Performance Tuning which included Fragmentation of data sources, cache management, creating Aggregate tables from multiple sources.
• Design, Development and Testing of Mappings, Mapplets, Workflows, and Worklets using INFORMATICA POWER CENTER 7.1 which involved data migration.
• Created Mappings with error handling logic in Mapping Designer using heterogeneous Sources Oracle database, Flat files.
• Configured and developed different Transformations like Source Qualifier, Filter, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected Lookups, Sequence Generator, Router, Update Strategy and Unconnected Stored Procedure.
• Developed Transformations by using complex transformation expressions Mapping Parameters and Variables and involved in ETL data loads.

Environment: Informatica Power Center 7.x, Siebel Analytics7.x, Oracle 8i (SQL, PL/SQL), SQL Server 2000, TOAD, XML, Windows NT.

Confidential, India May 04 - Nov 05 SQL Server Developer Project Description: ICICI is a leading General Insurance Company. It has more than three decades of experience and is headquartered in Chennai, India. We managed around 45 MS SQL Servers as a team. Responsibilities:

• Maintaining Databases and Tables
• Installation and configuration of SQL Server 2000 components
• Created logins, groups, users, roles, databases checking for database consistency.
• Involved in Creating tables with different types on constraints like Primary, Foreign, Unique etc
• Involved in reviewing and designing table additions, changes, deletes according to the Database Change Request form.
• Familiar and experience with Database concepts with all data objects and referential Integrity concepts.
• Specific hands on experience on larger Databases, Database Design and Normalization.
• Involved in writing T-SQL queries to do the operations on the database objects
• Involved in writing the SQL queries, Stored Procedures, Indexesusing T-SQL to optimize the performance of the database.
• Managing the security using different server roles and database roles.

Environment: MS SQL 2000, Windows 2000/XP, SQL Query Analyzer and Enterprise Manager, MS Access 2000 & Windows NT platform