SUMMARY:

• Over 7+years of IT experience in the analysis, design, development of database, data warehousing and BI applications with good understanding of requirements and business data flow. Expert knowledge in working with SQL Server and Oracle databases.
• Ability to analyze source systems and business requirements, identify and document business rules, design data architecture.
• Strong experience as BI Developer in developing/modifying repositories and reports using OBIEE/Siebel Analytics.
• Good understanding of functional specs and converting them into technical specs in accordance with SDLC guidelines.
• Experience in designing Star/Snowflake Schema using OBIEE Analytics Administration tool.
• Experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the OBI Administration Tool.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series.
• Experience in building, configuring and managing repository, creating and managing OBI Dashboards, OBI Answers, Delivers and iBots.
• Experienced in configuring OBIEE Reports & Dashboards, OBIEE Delivers, Narrativeviews, advance Reports.
• Experience in setting up Object level and data level security. Configured OBIEE Variables and security Users and Groups.
• Experience in building Reports, Prompts and Dashboards using Answers.
• Experience in building the reports using BI Publisher.
• Created Reports including Charts, Pivot tables and Compound layouts using OBI Answers.
• Troubleshooting performance related issues with reports and data.
• Experience in Migration of RPD and Web Catalogue across Instances (Dev to QA and QA to Prod).
• Experience on working with Oracle EBS modules like Account Payables, iProcurement, General Ledger etc.
• Experiencein ETL concepts/methodology for supporting data extraction, transformation and loading using Informatica PowerCenter.
• Areas of expertise in extraction, transformation, and load (ETL) of data directly from different heterogeneous source systems like flat files, Excel, Oracle, and SQL Server. Implemented ETL process to load data into target tables.
• Developed Informatica mappings using various transformations. Involved in performance tuning of Informatica mappings, sources, targets, transformations, sessions and SQL Queries.
• Proficient skills in using SQL/PL-SQL Queries, Stored Procedures, Triggers and Functions and UNIX shell scripting.
• Excellent communication, interpersonal, analytical skills and strong ability to perform in a team

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6/8.1.1/7.1.4, SSIS
OLAP Tools: OBIEE 10.1.3.3, Siebel Analytics 7.8.2/7.7.1/7.5.2, SSRS
RDBMS: Oracle10g/9i, SQL Server 20008/2005/2000, MS Access
Languages: SQL, PL/SQL, Shell Scripts
Testing Tools: IBM Rational Clear Quest, Clear Case
Operating Systems: Windows NT/ 2000/ XP, UNIX
Data Modeling Tools: Erwin 4.1/4.0
GIS Tools: Arc GIS 9.0, Arc View, MapInfo

EDUCATION:

Bachelor of Technology in Computer Science

PROFESSIONAL EXPERIENCE:

Confidential, VA Apr\'11\' - Oct\'12\' - Present
Role: OBIEE Consultant

Responsibilities:

• Involved in Upgrading OBIEE from 10g to 11g.
• Worked with End users and oracle support in resolving many product issues.
• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Analyzed the specifications provided by the client, understanding the business.
• Install, configure, and administer the OBIEE platform
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• 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
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle BI Presentation Services.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Involved in upgrading the database form 10g to 11g.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Involved in setting up methods of Usage Tracking using Direct Insertion and setting up Log File. Merged the Usage Tracking Repository with the main repository to have dashboard based usage tracking.
• Implemented Multi User Development Environment(MUDE) forconcurrent rpd development
• Involved in System Integration Testing (SIT), User Acceptance testing (UAT) and Production support.
• Involved in leading the training sessions for the end user.

Environment: OBIEE 11.1.1.5, OBIEE 10.1.3.3/10.1.3.4, BI Publisher 10.1.3.4, Oracle 10g/11g, SQL, SQL Server 2005, SQL Developer, Windows XP, UNIX

Confidential, MD Feb \'10\' - Mar\'11\'
Role:OBIEE Developer

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Analyzing and understanding different sources and target.
• Involved in daily, weekly loading of data from Flat files and other sources into the EDW by applying business logic on transformation mapping.
• Developing Mappings as per the design document with proper naming conventions for transformations and Mapping.
• Extensively worked on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Joiner Transformations and SQL Override.
• Created Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Extensively worked on Administration tool to build Physical Model, Business Model and presentation layer and established relationships.
• Created dimension hierarchies to achieve the drill down functionality.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled Slowly Changing dimension data.
• extensively worked with BI Answers to create various reports such as Drill down, Chart, Pivot, Narrative Reports etc as per the client requirements.
• Created, modified, and administered BI Dashboards with links to web sites, HTML text, links to documents and embedded content such as images, text, charts, and tables.
• Implemented Prompts to provide dynamic filter condition to End users.
• Used BI Publisher to create checks, sales and marketing letters, Financial Statements etc.,
• Created proactive agents (iBots) using BI Delivers and interactive dashboards to alert the agents.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: OBIEE 10.1.3.3, Informatica PowerCenter 8.6/8.1.1,Informix, Oracle 10g, SQL, PL/SQL, TOAD, UNIX Shell Script, UNIX, Windows XP.

Confidential, FL Aug\'08\' - Jan\'10\'
Role:OBIEE/ETL Consultant

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Analyzing and understanding sources of SQL Server and target with Oracle.
• Created several new mappings based on the user requirement.
• Involved in ETL processes to load the data from SQL Server and Flat files into the target (warehouse) Oracle tables by applying business logic on transformation mapping and maintaining referential integrity.
• Developing Mappings as per the design document with proper naming conventions for transformations and Mapping.
• Extensively worked on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Joiner Transformations and SQL Override.
• Extensively used mapping parameters, mapping variables and parameter files.
• Performed Unit and Integration testing.
• Involved in migration of folders from development to Integration and then to QA.
• Configured analytics repository with logical dimensional modeling using star schema.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents (iBots) and interactive dashboards to alert the agents.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Design various reports, i.e. Drill down, Pivot, Narrative Reports in Siebel Answers.
• Implemented Prompts to provide dynamic filter condition to End users.
• Providing object level security for different web groups based on responsibilities.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: OBIEE 10.1.3.1, Informatica Power Center 8.1.1/7.1.4,Oracle 10g, SQL Server 2000, SQL, PL/SQL, TOAD, Shell Script, UNIX, Windows XP.

Confidential, India May\'06\' - Jul\'08\'
Role: Siebel Infrastructure and upgrade consultant

Responsibilities:

• Built reports using Answers including drilldown objects, union based reports,
• formatting and functions within the reports, dashboards, filters, and prompts.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Implemented Time Comparison and calculation measures in the business model Using Time series wizard and modeled Slowly Changing dimension data.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Maintained effectiveness in creating the dashboards by appropriately including drilldowns. Setup the visibility of dashboards to employees with respect to their
  Responsibilities.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed Role-Based Dashboards for Managers and Business Heads to review the reports according to the role.
• Developed process and business rules around setting up new users (Logins, Responsibilities, Positions, etc)
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.

Environment: Siebel CRM 7.5, Siebel Analytics 7.5, Oracle 9 and Windows 2000.

Confidential, India Jun\'05\' - Apr\'06\'
Role: Informatica/ Siebel Analytics Developer

Responsibilities:

• Used Informatica Designer for developing mappings, using transformations, which includes aggregation, Updating, lookup, and summation. Developed sessions using Server Manager and improved the performance details.
• Maintain Development, Test and Production mapping migration using Repository.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Used Informatica Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Worked with Informatica Designer tool in developing mappings and mapplets to extract and loading the data from flat files, oracle to Oracle.
• Extensively used Informatica for loading the historical data from various tables for different departments.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Setting up Delivers to configure iBots based on the threshold value to the users.
• Worked with Siebel Analytics Developer to create Repository with Siebel Analytics Admin tool.
• Worked extensively in Siebel Answers and Dashboards.
• Created and granted privileges for the users using Analytics Catalog Manager.

Environment: Informatica 7.1/8.1, Siebel Analytics 7.8.2, PL/SQL, Oracle 9i, Windows 2003.