PROFESSONAL SUMMARY

• Dedicated IT professionalwith7years ofprogressive expertiseindesign, development, testingandimplementationofData warehousing and Business Intelligence Applications.
• Well versed with Dimensional Modeling (star and snow flake schema) to build data warehouse.
• Experience inOracle BI Appsthat includeOBIEE/Siebel Analytics,ETL Tools and DACinBanking, Financial,Pharmaceutical,andSales&Marketing domains.
• Worked extensively in the analysis and development of Data warehousing applications usingSiebel Analytics /OBIEE.
• Good understanding of OBIEE Architecture.
• Strong experience in developingOBIEE/Siebel Analytics Repository - three layers (Physical Layer, Business Model and Mapping Layer& Presentation Layer).
• Hands on experience in customizingreports, filtersandchartsin OracleAnswers.
• Experienced in usage ofSiebel/Oracle Deliversfor sending alerts via intelligence agents (iBots) to thedashboardsfor the end users.
• Comprehensive knowledge inPerformance Tuningof Oracle BI/Siebel Analytics Dashboards/Reportsby implementingAggregate navigation,cache managementand materialized views.
• Workedon various OBIEE features like Cache, Variables, Usage tracking, Dimensional hierarchy, Level Based Measures, Aggregate tables, and Fragmentation.
• Experienced in security setup at bothObject level and Data level.
• Hands on experience in configuration of Multi User Development Environment (MUDE).
• Knowledge in extracting data fromSiebel CRM, Oracle EBS, PeopleSoft,OLTP, flat files and loading data toOLAPsystems.
• Proficient in using ETL Tool Informatica PowerCenter to develop Mappings, Workflows Using different transformations.
• Knowledge of Data warehouse Application Console (DAC) Architecture.
• Excellent problem solving skills with strong technical background having the ability to meet deadlines and quickly master new technologies and skills.
• Good communication and presentation skills.

QUALIFICATION

• Bachelors of Technology in Electronics & Communication Engineeringfrom Confidential University

TRAINING

• Undergone training for OBIEE 11g:Building Repositories from Confidential University.
• Undergone training for OBIEE 11g:Creating analyses and Dashboards from Confidential University.

TECHNICAL SKILLS

Reporting Tools: OBIEE11.1.1.6/10.1.3.4.1,OBIA 7.9.6.3, Siebel Analytics 7.5/7.7/7.8.
ETL Tools: Informatica Power Center, DAC.
Databases: Oracle, DB2, MS-SQL Server & MS Access.
DB Tools: TOAD, SQL Developer, Advanced Query Tool (AQT).
CRM Tools: Siebel 7.0/8.0
Languages: C, C++, Java,SQL & PL/SQL, HTML.
Operating Systems: Windows 2007/XP/NT/Vista/2003 server, UNIX, Redhat Linux.

PROJECT HISTORY

Confidential, Atlanta, GA Jul 2010 – Nov2012Role:Sr.OBIEE Developer

Confidential was founded in 2006 as a private company with the mission to bring the next generation of connected solutions to the automotive industry. CONFIDENTIAL’s patented systems allow complete connectivity to any vehicle with safety and security as the beginning. What differentiates them from others is their broad portfolio and implementation of services. Each designed to significantly improve vehicle and customer relationship management potential while greatly reducing costs.

Responsibilities:

• Effectively interacted with the end users and involved in meetings with team members for requirement gathering and defined requirement specifications document.
• Develop mappings in Informatica Power Center to extract data from OLTP applications such as Oracle EBS, Oracle BRM, Siebel CRM and other legacy systems such as MSA and load data in to Oracle Datawarehouse for reporting in OBIEE.
• Worked extensively with Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Created and Managed Object Level, data level security, Hierarchies and tuned running queries to optimize performance.
• Created business reports using filters with BI Answers as per client requirement.
• Setup Users and granted privileges to access OBIEE Dashboards and Reports for users in the organization.
• Was responsible in migrating Informatica workflows and OBIEE RPD/ Webcatalog migrations.
• Monitored Incremental & Full loads in DAC.
• Configured Usage Tracking in OBIEE.
• Configured Multi User Development Environment (MUDE).
• Customizing the out of box ETL, Reports and Dashboards in OBI Apps for Siebel, Oracle EBS applications to fulfill company’s reporting needs.
• Worked on Sales and service modules.

Environment: OBIEE 11.1.1.6, BI Apps 7.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle 11.2.0.2, DAC, Oracle SQL developer, SQL* Plus, Unix, Windows XP.

Confidential, Easton, PA Mar 2009 – Jun 2010
Role:Sr. OBIEE / ETL Developer

Confidential, the world leader in grooved and plain-end mechanical pipe joining systems, was founded in New York City in 1925 to market a radical new concept in the piping industry — a mechanical bolted coupling that would engage into grooves and feature a gasket seal. For CRM needs Confidential uses Siebel CRM sales and Services along with OBIEE for reporting purposes.

Responsibilities:

• Gathered requirements by involving in meetings with the managers and business analysts.
• Was solely responsible in upgrading Siebel Analytics 7.8 to OBIEE 10.13.4 and all other related components.
• Worked on AP, AR, GL and procurements modules and PeopleSoft financials budget and expenses.
• Configured and developed different Transformations like Source Qualifier, Filter, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected Lookups, Sequence Generator, Router, Update Strategy and Union Transformation for custom Informatica mappings and workflows.
• Defined Organization structure for the client to be used as prompts in OBIEE.
• Modified DAC repository to integrate custom Informatica workflows, tables and indexes.
• Modified Repository and configured Physical Layer, Business Model and Mapping Layer and Presentation Layer using Administration Tool.
• Configured Hierarchies, Aggregate columns, Time series wizard in the Admin Tool.
• Created Repository and Session variables in the Admin Tool.
• Implemented Object level and Data level security and LDAP authentication for the Business Users.
• Created Dashboards using Answers, Dashboard prompts, guided navigation.
• Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors.
• Created Indexes, Aggregate tables and implemented Cache to tackle performance issues.
• Configured ibots, writeback functionality, action links and usage tracking, Microsoft Office Plugin as per the requirements.
• Configured and developed BI Publisher reports.

Environment: Siebel Analytics 7.8.4 / OBIEE 10.1.3.4, OBA 7.9.4, Informatica Power Center 7.1.2/8.1 (Designer/ Repository Manager/ Workflow Manager) / Informatica Power Center 8.1.1, BI Publisher ,Oracle (OLTP), Oracle (OLAP), Toad.

Confidential, St. Louis, MO Aug 2007 – Feb 2009
Role:OBIEE Report Developer

Confidential, with headquarters in St. Louis, Missouri, is a leading specialty pharmaceutical company that develops, manufactures and markets innovative branded, quality generic/non-branded and unique specialty ingredient products, utilizing proprietary drug delivery technologies. 
In addition to its comprehensive research & development and manufacturing processes, KV has broad marketing and sales capabilities through its three wholly owned subsidiaries, There-Rx Corporation, marketing branded products, ETHEX Corporation, marketing generic/non-branded products, and Particle Dynamics, Inc., participating in the value-added specialty ingredient marketplace.

Responsibilities:

• Installation of Siebel Analytics Standalone 7.8.4 and Siebel Analytics Application 7.8.4 on the designated server.
• Configured and scheduled the DAC to load Siebel eBusiness Application data to Oracle Warehouse for Pharma and Pharma syndicate data Execution Plans.
• Created custom INFORMATICAmappings to load the IMS data (external syndicate data) into flat files for direct sales and Prescribed Rx data.
• Created custom INFORMATICA mappings with the Transformations like Source Qualifier, Filter, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected Lookups, Sequence Generator and Router.
• Implemented Data level and Object level security for the users.
• Merged repository and webcat file.
• Creating dimensions, aggregations and levels using admin tool in the Business Model and Mapping Layer.
• Configuring repository & session variables to get dynamic reports and dashboard.
• Taking backups of Informatica Repository, Analytics Repository and Webcat files.
• Created objects in Physical, BMM and Presentation layer to be used in Siebel Answers.
• Created high level and detail level dashboards for different users in the organization.
• Implementation of different views of report i.e. View selector, Pivot table, Column selector, charts, Narrative etc.
• Configured and Scheduled iBots in Siebel Delivers to show alerts on Dashboard.

Confidential Jul 2006 - Jun 2007
Role: Informatica Developer

Project Description:

CONFIDENTIAL is a diversified financial service company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The data warehouse was primarily designed to provide Marketing Managers with the complete understanding of customer pattern (market based analysis) and their preference (Trend Analysis). This data warehouse was later extended to cater the needs of Sales, Marketing and Human Resources.

• Installed and Configured Informatica 5.1.
• Created necessary Repositories to handle the metadata in the ETL process.
• Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
• Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema.
• Created the Source and Target Definitions in Informatica PowerCenter Designer.
• Created mappings in mapping designer by using various transformations like Expression, Router, Filter, Lookup, Update strategy, Sequence Generator.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings.
• Created sessions and workflows in Workflow manager.
• Created reusable sessions to use in multiple workflows.
• Examined session log carefully to identify bugs and resolved successfully.
• Performed bulk and normal loads.

Environment: Informatica 5.1, SQL Server 2000, Flat Files, SQL, PL/SQL, MS Visio, Windows 2000.

Confidential May 2005 – Apr 2006 
Role: PL/SQL Developer 

Project Description: 

The project called SMS (Staff Maintenance System). The project contains that accepts the employees details and maintain the staff information in one database as well as we have maintained personal record of the employees and generating the employees\' reports monthly, quarterly, half year and yearly. The process of accepting the details about employees forms and gives the employees reports.

Responsibilities:

• Involved in user requirement and requirement specification from users.
• Documenting business requirements, functional specifications and test requirements.
• Identified the key facts and dimensions necessary to support the business requirements.
• Prepared prototype models to support the development efforts.
• Developed various complex SQL queries using stored procedures, functions, and Database triggers.
• Involved in the design, development and testing of the PL/SQL stored procedures.
• Provided input into updates and modifications of the product documentation and support the testing team to deliver the highest product quality to the customers.
• Involved in analysis, estimating, design, development, testing, and 24 x 7 production support.

Environment: Oracle 9i, SQL, PL/SQL, Windows XP, UNIX, SQL*Plus.