Summary

• Over 8 years of experience in Software Development and Expertise in OBIEE 11.x/10.x/OBIA 7.x, Siebel Analytics 7.x and Informatica 9.x/ 8.x/ 7.x.
• Over 3 years of experience Installing, upgrading, configuring OBIEE 11.5.x, 11.6.x, 11.7.x on UNIX, Linux, Windows Server .
• Worked Extensively on Oracle BI Siebel Analytics Administration Tool, Oracle BI Web / Presentation Services, Answers, BI Publisher, scheduling iBots using BI delivers.
• Extensive experience in designing Star Snowflake Schema, Slowly Changing Dimensions, Facts, Dimensions tables.
• Implemented Security by creating roles web groups, checks with External tables LDAP
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Expertise in Business Model development with various functionalities like Hierarchies, Measures, Aggregation Rules and Time Series.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Siebel Analytical Dashboards / Reports to improve performance at Database.
• Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes, partitions and aggregate tables.
• Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters using Presentation services.
• Experience in extracting data from Siebel, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Proficient in developing OBIEE/Siebel Analytics Repository at the Physical, Business and Presentation Layers Data Modeling , Time Series Objects, Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE/Siebel Security setup users/group, access/ query privileges , configuring OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog objects Dashboards, Pages, Folders, Reports, Alerts, Briefing Books , Scheduling iBots or Schedulers and OBI Cluster Controller.
• Very good experience in developing Informatica Mappings / Mapplets and Workflows with Worklets Tasks for ETL data from Multiple Sources to Data Warehouse.
• Vast experience in designing, developing and tuning complex mappings from varied transformation logic like lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Rank etc.
• Experience in Extraction, Transformation Loading of data from multiple sources to Data Warehouse using Informatica OTB mappings and DAC.
• Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
• Extensive experience with various databases Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

• Reporting Tools: OBIEE 11.x, 10.x , Siebel Analytics 7.x,Oracle BI apps 7.9.6.3
• ETL Tools: Informatica Power Center 9.x, 8.x, 7.x , Power Mart , DAC 10.x, 7.x
• Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C
• Operating Systems: Windows 2000/NT/XP/7, Windows Server 2008, UNIX, Linux
• Web technologies: HTML, JavaScript, XML.
• Tools: Toad, SQL plus,SQL Developer
• RDBMS: Oracle 11g/10g/9i/8i,EXADATA MS Access
• Hilton Worldwide Mclean, VA Nov 2012 - Till Date
• Project: SST Single Source Truth

Role OBIEE Sr Developer

Hilton Single Source Truth SST project involves migrating PSFT from version 8.9 to 9.1. OBIEE reporting Application is used to reconcile validate data from different sources such as PSFT8.9, PSFT 9.1, Hyperion Essbase R1 R2, OBI Applications OOTB Finance Ledgers Journals. Also HR BI Application is implemented to generate Payroll and Workforce profile reports.

Responsibilities:

• Installed, Configured and Upgraded OBIEE, .RPD, Webcatalog and Config Files from 11.1.1.5.0 to 11.1.1.6.0 and then from 11.1.1.6.0 to 11.1.1.7.1 on Windows and UNIX box.
• Worked Closely with Business users for writing/converting FRD, BRD to Technical Specs in order to create BI business data model using Admin Tool and design Intelligence Dashboard Reporting.
• Designed and developed the OBIEE/ Metadata Repository .rpd using OBIEE Admin tool by importing the required objects Dimensions and Facts from Multiple data sources with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Customized W GL BALANCE A, W GL BALANCE F, W ACCT BUDGET F PSFTSTDACTUAL tables to support GL Detail, GL Summary and Tax BI reports
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measure in OBIEE business model mapping layer.
• Created T, T-7, T-15, T-30 Time Series measures in OBIEE Repository in order to retrieve data faster than Time Series AGO TODATE functions.
• Developed various Analytical and Operational complex Dashboards and reports to support Finance GL, Journals, TAX, Hilton Operations, EBITDA, HR using BI best practices with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Presentation Services.
• Designed Logical Table Source sourcing to multiple physical databases in the Business Model Layer to support the structure of the RPD for generating the desired reports.
• Created custom Data Model using BI Publisher to generate an XML template based on OBIEE answers and also created custom RTF Template to show data for Hilton HR FTE Dashboard.
• Extensively used Repository, Session and Presentation Variables to obtain the user requirements and generate dynamic reports.
• Migrating 11x RPD, Web catalog, Config Files for weekly releases from Development to Quality Testing, Staging and Production.
• Extensive use of the MUD Environment for making online changes in the RPD in parallel with the Development team using the Check in Checkout and Merge functions.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Implemented row and data level security on subject areas, dashboards and reports to filter data based on user profile
• Used best Caching techniques by scheduling the reports containing large volume of data.
• Enhanced performance of Reports / Dashboards by implementing Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Involved in developing complex ETL process i.e., Mappings Mapplets using various Transformations Source Qualifier, Aggregator, Rank, Router, Update Strategy, and Look-Up and Workflows with Sessions / Tasks

Environment: PeopleSoft 8.9/9.1 General Ledger, OBIEE 11.1.1.7.x/11.1.1.6.x/11.1.1.5.x Oracle BI Apps 7.9.6.3 Finance.HR , Informatica Power Center 9.1HF4, Oracle 11g, PL/SQL ,DAC 10.1.3.4.1, Toad , Linux RED HAT 5.0, Putty, WinSCP.

Confidential

Role: OBIEE Sr Developer

US Foods is an food service company for that we developed BI reports for the internal users like VP, RSM, DSM and TM and Top Management and also for US Food customers to track down and analyze the Sales for US Foods

Responsibilities:

• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Performed the setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the DataWarehouse.
• Installed and configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Customized W AR BALANCE F,W AR XACT FW ASSET F,W GL BALANCE F,W GL COGS F schemas to meet business requirements reporting.
• Customized W AR BALANCE F,W AR XACT FW ASSET F,W GL BALANCE F,W GL COGS F ETL mappings to load from flat files , oracle databases to OLAP databases.
• Designed and developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power Center.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding extra columns to the Existing Facts and Dimensions.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Implemented row and data level security on subject areas, dashboards and reports.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Migrated Analytics RPD and Webcat from one environment to another.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Column Selector, View Selector and Combined with Similar Requests.
• Configured IBOT's for delivering alerts and for Cache Seeding.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances. Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache etc.

Environment: PeopleSoft 9.1 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 11.1.1.5/10.1.3.4.1, Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 11g, PL/SQL ,DAC 10.1.3.4.1, Toad , Linux, File-Zilla.

Confidential

Role: OBIEE Developer

Keeping track of the instances assumptions occurred across the United States to monitor the history and compare with the future transactions. Creating Reports for comparing previous fiscal years with current fiscal year to monitor the business based on the profitability and accountability. Keeping Track Financial Risk Management Statistics

Responsibilities:

• Worked as Sr Developer to successfully deliver a multiphase OBIEE deployment by coordinating between offshore and onsite team and also involved in various status and activity meet up with client's IT and Business team.
• Created 4 Primary CEO Level Dashboards with more than 20 Reports
• Involved in installation and configuration of OBIEE platform.
• Provided Line 3 build support, resolving incidents and supporting the RUN team on OBIEE issues, handling RFC and Problem tickets.
• Dealt with the performance issues such as tuning the queries using Views , Materialized Views and Indexes for the reports which are running at significantly higher time periods.
• Performed Dimensional modeling, Identify Fact tables Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables their definitions.
• Used OBIEE environmental and Multi-User development MUD migration process to check out projects, merge changes, publish changes to network, and create migration plan to move repository .rpd respective environments.
• Responsible for migrating the web catalog and RPD from DEV, UAT and PROD environments..
• Configured External Database Authentication Security and created OBI USER, OBI GROUP, OBI PRIVILAGE OBI PASS ENCRYT to store OBIEE Users Credentials which was used to setup Data Level Object Level Security.
• Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards.
• Presented to the end users the functionalities of OBIEE reports which have different look and feel using Skin Variable when compared to existing dashboards in Java platform.
• Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Maintained the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Executed the workflows through shell scripts using pmcmd.
• Performed the Server Administration tasks of migrating the BI Repository, Webcat between the Development, Testing, UAT and PROD environments.
• Have extensively used presentation variables and Guided Navigation for reports like Market share reports and Overview Reports.
• Created Go URL to navigate and pass the parameters from narrative views.
• Configured and Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents iBots to intelligence dashboards for subscribed users.

Environment: OBIEE 10.1.3.4.1, Informatica Power Center 8.x, Oracle 11g , Toad , Windows XP, UNIX, FileZilla,DAC.

Confidential

Role: ETL/Oracle Developer

The CITI Group offers the industry's most comprehensive suite of integrated corporate trust, depositary receipt and shareowner services. Shareowner Services helps clients address and manage their Stakes, equity compensation plan and direct investment administration needs.

Responsibilities:

• Developed Syndicated oracle packages to include the rolling 24-month syndicated third party data that was mainly in flat files.
• Provided support activities to their existing warehouse by developing new pl/sql programs to support their existing structure and also data validation.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Performed mapping gap analysis between existing OTB mappings and already existing tables to support the new requirements.
• Developed complex new Informatica ETL process and Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator and Workflows with Sessions / Tasks.
• Designed and documented multiple interfaces using the Informatica Power Center.
• Developed many complex Informatica mappings and mapplets to build key interfaces using transformations reusable transformations Source Qualifier, Update Strategy, Lookup, Expressions and Aggregator for loading the data into DW.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable / parameters for simplifying complex mappings.
• Performed Database and Informatica performance tuning and implemented the session partitions, changes to database by re-building the indexes, analyzing the objects etc.
• Developed many Shell Scripts for pulling data from remote machines, Backup / Migration of metadata from version, development and production, FTP, untar sending files to source directory, managing sessions files in the server.
• Extensively developed complex PL/SQL packages for ETL.

Environment: Oracle 10g R2, TOAD, Informatica 6.x/7.x, Windows XP, Sun Solaris.

Confidential

Role: ETL /Oracle Developer

Confidential offers the industry's most comprehensive suite of integrated corporate trust, depositary receipt and shareowner services. Shareowner Services helps clients address and manage their shareholder, equity compensation plan and direct investment administration needs.

Responsibilities:

• Creation of database objects and storage structures tables, views, indexes .
• Involved in the design of the detailed functional and design specifications of the Table layouts and data entry screens
• Migration of legacy data into Oracle via SQL Loader.
• Coding of PL/SQL procedures and Triggers for efficient and modular data retrieval.
• Extensively used Informatica to load data from different data sources into the oracle data warehouse.
• Involved in data cleansing and extraction.
• Imported Sources and Targets created Mappings and developed Transformations using Power Mart designer.
• Created complex mappings and transformations using expressions, aggregators, filters, sorter, sequence generator, connected and remote lookups' to develop and populate Data Marts.
• Created reusable transformations, Mapplets and used them in the mappings.
• Fine tuned Transformations and Mappings for better performance.
• Used Informatica Power Mart Server manager to create sessions, Sessions to run with the logic embedded in the mappings.
• Mappings are tuned to optimize the load performance.
• Used Forms to provide the interface for the application and Reports to take periodical

Environment: Oracle 10g, TOAD, Informatica 6.x, Windows XP, Sun Solaris.