SUMMARY:

• Over Ten (11) years of experience in requirement analysis, system analysis, design, development, Implementation, Optimization, validation testing, program testing and debugging.
• Over Seven plus years of experience in implementing OBIEE(7 Years), Siebel Analytics Administration & Answers, Delivers, ibots (4 years) with Data Warehousing(Informatica).
• Hands on experience in Oracle OBIEE, Siebel Analytics in designing Dashboards, Answers, Delivers and Analytics Administration Tool.
• Participated with Business system analysts and DW/BI architecture teams to gather requirements like Key Performance Metrics for Dashboards and Answers
• Having Very Good knowledge in Data modelling (OLTP,OLAP) and ERWIN Data Model.
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.

  Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using OBIEE Admin Tool and Siebel Analytics Web.

• Expertise in configuring Data Models for Analytical platforms using OBIEE Presentation, Business Logical and Physical modeling layers
• Configured OBIEE presentation layer with reporting capabilities like Visual Analysis, Drill-Down, Ad-hoc, Multi- Dimensional, Slice/Dice, Alerts, Graphs and Guided Analytics
• Worked in Agile methodology.
• Strong experience in building Analytics dimensions and Level based hierarchies and custom aggregation rules for each Performance Metric
• Very strong in developing Informatica Mappings using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows, Tasks and scheduling using both Workflow Manager and Unix Shell scripts (using pmcmd)
• Good experience in developing ETL processes, loading and validating data from source systems into the data warehouse using Informatica and Oracle Data integrator (ODI)
• Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL tools and DAC in Financial, Banking, Health Care, Insurance and Sales/Marketing domains
• Good experience in developing ETL processes, loading and validating data from source systems into the data warehouse using Informatica and Oracle Data integrator (ODI)
• Knowledge of Data warehouse Application Console (DAC) Architecture.
• Established data & user level security in OBIEE platform
• Excellent skills in assessing the business requirements and handling of multiple tasks.
• Worked extensively in design and implementing solutions with Informatica, That includes working on PowerMart and Informatica Power Center 8.1.1/6.1/6.0/5.0,
• Skilled in performance tuning of mappings and sessions
• Experience in Data Conversion from legacy system to Oracle Database.
• Experience in developing and supporting both production and development system.
• Ability to successfully communicate at all business levels
• Team player with Excellent communication skills

TECHNICAL SKILLS:

CRM: Siebel 7,8,7.7,Siebel 99, 5.5 6.0, 7.0,7.7,7.8

Verticals: e-Comm, e-finance, e-sales

BI Tools: Oracle Business Intelligence(OBIEE)11g, 10.1.3.3, 10.1.3.2Siebel Analytics, 7.8/7.7 / 7.5.3

Data Warehouse Tools: Informatica 8.1/7.1

RDBMS: Oracle 11g/10g,9i, 8.0 8i 7x SQL Server, MS Access,Terradata,DB2

Operating Systems: Windows NT/95/2000/XP,UNIX

ERP: Oracle Financials 10.7 / 11.03( AP,AR,GL,FA,OM)

SQA Tools: Silk 6.0, Win Runner 5.0/6.0, Test Director

Other Tools: TOAD, BRRT, Doors, Putty, Secure CRTTest Director, Quality Center.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta GA

Sr Obiee Developer

Responsibilities:

• Extensively worked with Data Models, Data Architectures, Data Analyst and Business Analyst understanding the business model for designing the Meta data Repository
• Designed and Developed RPD with multiple hierarchies with complex scenarios.
• Modified existing reports and created new reports from various sources as per the business requirements.
• Performing Data Analysis and creating Data Models as per the requirements.
• Created session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Extensive experience in Deployment of RPD Catalog to various environment.(Dev, SIT, Prod)
• Creating the packages for Code Migrations of Rpd and catalog.
• Good experience in Created DDD Design document
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Developed Subject Area with Physical Layer Objects(Database, Connection Pool, Catalog, Schema, Table), Business Layer Objects (Logical Table, Dimensions, Joins, Aggregation Rules, Case Expressions for Unmapped Columns, Facts, Initialization Blocks, Repository Dynamic Variables), Presentation Layer Objects (Table, Columns)
• Extensively Created adhoc reports
• Involved in Dimension modeling, Identified business attributes and measures, defined dimensional model (STAR Schema) to store the business attributes and measures
• Designed various reports in OBIEE Answers and configured Intelligent Dashboards for different user groups to view data across regions and Customer Demographics with the facility of drill downs and Effectively communicated and co-ordinated with Business Requirements, Testing, Data team and BI teams.
• Analysing, development of OBIEE Environment RPD, Reports and Dashboards.
• Creating Adhoc Reports, Static and Dynamic Reports, Dashboards, charts, and graphs. as per customer requirements
• Creating and updating the Reports based on Manual Reports as per users requirements
• Working with ETL team, and Data modelers for creating mapping document
• Working with Business Users for any new features and mentoring them
• Working with Testing team in debugging the defects and solving the issues in Jira
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Environment: Oracle Business Intelligence (OBIEE 11g), OBIEE Answers 11g, Oracle BI Presentation Server, Oracle BI Java Host,Oracle11g, TOAD, SQL Tools, Ms Visio, MS Office Plug-Ins, ERwin, JIRA Version Contro, Quality Center, Windows XP Professional.

Confidential

Sr OBIEE Developer

Responsibilities:

• Worked closely with Business user in Understanding the OBIEE reporting needs from target user groups.
• Extensively worked with Data Models, Data Architectures, Data Analyst and Business Analyst understanding the business model for designing the Meta data Repository
• Configured and set up the MUDE environment
• Extensive experience in working with Multi User Development Environments
• Deployed the RPD from MUDE to DEV, QA and production environments
• Expertise in Developing the Subject Area with Physical Layer Objects(Database, Connection Pool, Catalog, Schema, Table), Business Layer Objects (Logical Table, Dimensions, Joins, Facts, Initialization Blocks, Repository Dynamic Variables), Presentation Layer Objects (Table, Columns)
• Created various logical columns based on existing logical/physical tables as sources
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
• Extensively worked on Data analysis of various data marts and source systems
• Designed and Developed RPD with multiple hierarchies with complex scenarios.
• Modified existing reports and created new reports from various sources as per the business requirements.
• Created session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector
• Created user level security for intelligence dashboards based on Business Requirement.
• Created users, groups, access privileges and query privileges using Security settings in OBIEE AdminTool
• Worked with ESS Base connecting with OBIEE and importing tables and designing the cubes
• Defined users, groups, access privileges and query privileges
• Extensively worked on Converting the SAS reports to BI Publisher.
• Developed Data Model with Dimensions and hierarchies
• Created various templates, reports, and prompts in BI Publisher.
• Integrated multiple schemas into single schema as Integrated Data Model with multiple data sources
• Worked in Agile methodologies with daily scrums
• Experience working with ETL Informatica for updating the mapping
• Worked with ETL team in Creating the source to target mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter
• Attended regular daily scrums, project meetings and weekly team meeting
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Environment: Oracle Business Intelligence (OBIEE 11g), OBIEE Answers 11g, Oracle BI Presentation Server, BI Publisher 11g, OBIEE Administration Console, OBIEE Enterprise Manager, Oracle BI Java Host, Informatica Power Center 9.0, Oracle 11g, TOAD, SQL Tools, Ms Visio, MS Office Plug-Ins, AQT, Version one, ERwin, SAS, Toad, Quality Center, Windows XP Professional.

Confidential, Atlanta GA

Sr OBIEE consultant

Responsibilities:

• Worked with Business user in Understanding the OBIEE reporting needs from target user groups.
• Involved in the design of Analytics repository from the Physical layer to the Presentation layer and defining the responsibilities for various users and groups based on position.
• Configured Dimension tables in Business layer for Drill down functionality.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created dimension hierarchies, levels, level based measures and defined logical levels and keys.
• Implemented the security in OBIEE Admin tool to set up users, groups and access privileges.
• Used the expression builder utility for the new logical columns in the BMM layer and created various calculation measures.
• Created Sales Dashboards for different positions & Hierarchy in different Business Units.
• Extensively worked on Data analysis of various data marts and source systems like Oracle ERP Application.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector
• Implemented the Customer & Product Dimensions and their hierarchies.
• Created user level security for intelligence dashboards based on Business Requirement.
• Implemented security by creating roles & web groups, checks with External tables and Object Level Security.
• Created mock reports and dashboards for review by the business users
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Modified existing reports and created new reports from Siebel Data as source and Siebel DW tables as per the business requirements.
• Extensive Performance tuning in OBIEE by implementing aggregate navigation and cache management techniques
• Involved in Creating the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter
• Developed standard mapping using various transformations like expression, aggregator, joiner, source qualifier and route.
• Hands on experience in Data Warehouse Administration Console for scheduling and executing Incremental ETL loads.
• Validated Source data with Target Data in Teradata.
• Extensively usedCASE & CAST functionsforData Cleansing.
• Worked with Session Logs, and Workflow Logs for Error handling and troubleshooting in DEV environment
• Trouble shooting reports For Oracle BRM, bill revenue reports, purchase orders and Invoices through SQL Statements
• Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
• Used Debugger to troubleshoot the mappings.
• Good experience in communicating with offshore team
• Extensively performed data validations and created mapping document from source to target
• Involved in testing/validating and debugging the applications using SQL scripts and appropriate log files.
• Co-ordinated with QA team and created Unit Test Cases to test and validate the reporting system and its data

Environment: Oracle Business Intelligence (OBIEE 11g), OBIEE Answers 11g, Oracle BI Presentation Server, General ledger, Accounts Receivables, Accounts Payables, Oracle BI Java Host, Informatica Power Center 8.6.1, Oracle 10g, ODI, TOAD, Data Warehouse Administration Console (DAC 10.1.3.4), SQL Tools, Ms Visio, MS Office Plug-Ins, TeraData, Toad, BRRT tool, Quality Center, Windows XP Professional.

Confidential

Sr OBIEE consultant

Responsibilities:

• Working closely with Business user in Understanding the Analytics reporting needs from target user groups.
• Actively involved in gathering requirements from Business user for creatingData Warehouse.( Centralized Repository)
• Created Mapping the elements from Legacy system to New System.
• Performed GAP Analysis .
• Developed Subject Area with Physical Layer Objects(Database, Connection Pool, Catalog, Schema, Table), Business Layer Objects (Logical Table, Dimensions, Joins, Aggregation Rules, Case Expressions for Unmapped Columns, Facts, Initialization Blocks, Repository Dynamic Variables), Presentation Layer Objects (Table, Columns)
• Extensively Created adhoc reports
• Involved in Dimension modeling, Identified business attributes and measures, defined dimensional model (STAR Schema) to store the business attributes and measures
• Designed various reports in OBIEE Answers and configured Intelligent Dashboards for different user groups to view data across regions and Customer Demographics with the facility of drill downs and Effectively communicated and co-ordinated with Business Requirements, Testing, Data team and BI teams.
• Analysing, development of OBIEE Environment RPD, Reports and Dashboards.
• Interacted with a wide variety of vendors to understand and address problem and developed long range technical solutions that combine information and ideas in new, unprecedented ways
• Created reports using BI Publisher on MS Word
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Responsible for developing ETL processes, loading and validating data from source systems into the data warehouse using Informatica.
• Validated Source data with Target Data in Teradata.
• Collected Statistics for Tables and Columns.
• Co-ordinated with QA team and created Unit Test Cases to test and validate the reporting system and its data
• Attended bug review and client meetings
• Attended regular project meetings and weekly team meeting

Environment: Oracle Business Intelligence (OBIEE 10.1.3.4), OBIEE Answers 10.1.3.4, Oracle BI Presentation Server, Oracle BI Java Host, Informatica Power Center 8.1.1, Oracle 10g, TOAD, SQL Tools, Ms Visio, MS Office Plug-Ins, TeraData, Toad, BRRT tool, Quality Center, Windows XP Professional.

Confidential, Atlanta GA

Sr OBIEE Consultant

Responsibilities:

• Worked closely with Business user in Understanding the OBIEE reporting needs from target user groups.
• Expertise in Developing the Subject Area with Physical Layer Objects(Database, Connection Pool, Catalog, Schema, Table), Business Layer Objects (Logical Table, Dimensions, Joins, Facts, Initialization Blocks, Repository Dynamic Variables), Presentation Layer Objects (Table, Columns)
• Created various logical columns based on existing logical/physical tables as sources
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
• Extensively worked on Data analysis of various data marts and source systems like Oracle ERP, Siebel CRM
• Created mapping documents from source to target for Siebel CRM system.
• Strong experience in building Analytics dimensions and Level based hierarchies
• Developed many Reports / Dashboards with different Analytics (Pivot Table, Chart, Column Selector, and Tabular with Filters), Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities with Dimensional Hierarchies.
• Developed BI dashboards for Billing and Revenue Subscriber daily activates, Subscriber daily deactivates, Monthly Revenue Report, Total usage reports, including Products, Customers, Territory Report and Sales Performance reports for summary level and detail level as per the user requirements etc.,
• Worked on various Subject Areas to create new reports Marketing, campaigns, Order Management and Product Defects.
• Modified existing reports and created new reports from Siebel Data as source and Siebel DW tables as per the business requirements.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges
• Created SQL scripts for Data Validation in order to verify the mapping from source (Legacy) to target Tables.
• Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
• Collected Statistics for Tables and Columns.
• Granted Permission to different Users to Table which I was created.
• Experience in using Teradata Utilities like Fast load and MOLOAD for data loads.
• Experienced in Performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User Acceptance
• Worked with Business Users and created Adhoc Reports
• Working on data validations and pulling the data from Siebel CRM tables
• Extensively worked with Siebel CRM tables
• Created KPI for Product/Service Defects and Customers.
• Effectively communicated and co-ordinated with Business Requirements, Testing, Data team and Siebel teams.
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Environment: Oracle Business Intelligence (OBIEE 10.1.3.4), OBIEE Answers 10.1.3.4, Oracle BI Presentation Server, Siebel Call Center, Siebel Sales, Oracle BI Java Host, Informatica Power Center 8.1.1, Oracle 10g, TOAD, SQL Tools, Ms Visio, MS Office Plug-Ins, TeraData, Unix, Toad, Oracle10.g, Quality Center, Windows XP Professional.

Confidential

Sr OBIEE Consultant/ETL Developer

Responsibilities:

• Worked extensively with users in gathering information, analyzing the data and creating adhoc reports
• Worked extensively on Customizing OBIEE Administration tool for Repository that includes Physical Data Layer, Business model and mapping layer and Presentation Layer.
• Involved in creating Star schema as per the business requirements to store the business attributes and measures and configured the Logical Layer, Logical tables, dimensions and columns and created the logical joins required to support drill-down aggregation
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Configured the Dashboard and Saved requests in Answers for drill down features
• Worked with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
• Configured Analytics Reports, dash boards, web catalog and the RPD using OBIEE Administration tool.
• Developed many Reports / Dashboards andScorecardDashboards, with different Analytics Views (Drill-Down / Dynamic, Narrative View, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters)
• Interacted with Business Analyst and data Modelers to understand the required functionality for OBIEE reports.
• Worked extensively on Customizing OBIEE Administration tool for Repository that includes Physical Data Layer, Business model and mapping layer and Presentation Layer.
• Involved in creating Star schema as per the business requirements to store the business attributes and measures and configured the Logical Layer, Logical tables, dimensions and columns and created the logical joins required to support drill-down aggregation
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Having Very good Understanding of the business requirements and Transforming the requirements into subject areas
• Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts
• Configured the Dashboard and Saved requests in Answers for drill down features
• Created Tasks and Task group and Subject Matter in DAC.
• • Developed the Incremental ETL Processes like Mappings using various Transformations and workflows with Sessions/Tasks.
• Worked with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
• Configured Analytics Reports, dash boards, web catalog and the RPD using OBIEE Administration tool.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Involved in creating High level Design documents(HLD) for data flow process in MS Visio.
• Configured the scheduler which runs the Ibots and delivers the content
• Developed BI dashboards for territory report, Sales Performance etc.
• Extensively used OBIEE Answers and Dashboard, Pages, Sections, Add Column, Dashboard Prompts including View Selector, Column Selector, Pivot Tables, Charts, Presentation Variables, Permissions on Shared Folders via Catalog Manager etc.,
• Worked in Multi User Development(MUD) Environment.
• Good experience in understanding & creating source and target definitions, mappings, and working with sessions
• Involved in Creating the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter
• Extensively performed data validations and created mapping document from source to target.
• Created the required mappings using Informatica Power Center Designer and created the tasks for the mappings developed through Informatica Power Center Workflow Manager
• Participated in weekly team meetings and reviews meetings.
• Co-ordinated with QA team and created Test Plans and Test Cases to test and validate the reporting system and its data

Environment: Oracle Business Intelligence(OBIEE)10.1.3.3,OBIEE Answers, Dashboards, Oracle BI Applications 7.9.4(Sales Analytics), Informatica 8.1/7.1.3, DAC, Siebel Call Center, Siebel Sales, Oracle BI Server, MS Office Plug-Ins, BI Components,, TeraData, Unix, Secure CRT, Toad, Oracle10.g, Quality Center.

Confidential

OBIEE Developer

Responsibilities:

• Worked closely with Business user in Understanding the OBIEE reporting needs From target user groups.
• Developed Subject Area with Physical Layer Objects(Database, Connection Pool, Catalog, Schema, Table), Business Layer Objects (Logical Table, Dimensions, Joins, Aggregation Rules, Case Expressions for Unmapped Columns, Facts, Initialization Blocks, Repository Dynamic Variables), Presentation Layer Objects (Table, Columns)
• Designed various reports in OBIEE Answers and configured Intelligent Dashboards for different user groups to view data across regions and Customer Demographics with the facility of drill downs and Charts
• Involved in Dimension modeling, Identified business attributes and measures, defined dimensional model (STAR Schema) to store the business attributes and measures.
• Developed Dashboards, Reports with Analytics Views like Pivot Table, Chart, Tabular and View Selector, Alerts, Guided Navigation with drill-down capabilities
• Actively involved in gathering user requirements and GAP Analysis
• Participated in creating mapping document for legacy systems.
• Designed & Developed a star schema for Fact, Dimension, Aggregates and Configured Physical/Business Modeling/Presentation Layers demonstrate the exiting Subject Areas and provided Functionality to OBIEE Users
• Developed Dashboards, Reports with Analytics Views like Pivot Table, Chart, Tabular and View Selector, Alerts, Guided Navigation with drill-down capabilities
• Implemented Data Level security into Business Model that has both Position Based Security and Geo based security for different user groups.
• Created and tasks and tasks groups and subject matters in DAC. for informatica servers.
• Customized the out of the box DAC containers to configure the ETL to run in both full and incremental loads as per the staging and target requirements.
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Tested various reports, graphs and updated in Test Director
• Developed ScorecardDashboards, with Analytics Views Dynamic View, Narrative View, Pivot Table, Chart, Column Selector, with global and local Filters
• Configured the scheduler which runs the Ibots and delivers the content & also seed the cache
• Created the required mappings using Informatica Power Center Designer and created the tasks for the mappings developed through Informatica Power Center Workflow Manager
• Responsible for developing ETL processes, loading and validating data from source systems into the data warehouse using Informatica.
• Co-ordinated with QA team and created Test Cases to test and validate the reporting system and its data

Environment: Oracle BI Platform 10.1.3.3.1, Oracle BI Applications, Oracle BI Server, Sales Analytics, Oracle BI Presentation Server, Answers, Dashboards, Oracle BI Scheduler Oracle BI Java Host, iBots, MS Office Plug-Ins, Disconnected analytics, UINIX,Informatica 7.1, Oracle 9i, Toad, Quality center.

Confidential

Siebel Analytics developer/Functional Analyst

Responsibilities:

• Worked closely with Business user in Understanding the Analytics reporting needs From target user groups.
• Actively involved in gathering user requirements and GAP Analysis
• Involved & Developed Full cycle implementation of Siebel Analytics in all phases.
• Imported Physical Tables and Defined Relations in Physical Layer in Siebel Analytics
• Worked extensively on Customizing Siebel Vanilla Analytics Repository, that includes Physical Data Layer, Business Model and Presentation Layer in Siebel Analytics Administration Tool.
• With the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges.
• Involved in Dimension modeling, Identified business attributes and measures, defined dimensional model (STAR Schema) to store the business attributes and measures.
• Created Reports in Siebel Answers/Dashboards in Analytics Answers
• Created Reports for the opportunity forecasts to measure the potential business, as well as the business to measure lost business opportunity and the factors associated with it to aid the management.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies.
• Hands on experience in creating ETL Mapping document.
• Designed various reports like Drill Down, Pivot Reports in Answers and configured Intelligent Dashboards for different user groups to view data across regions and Customer Demographics with the facility of drill downs and Charts.
• Trained the end users in accessing reports in pre-built dashboards, configuring their personal “My Dashboard”, creating sharing reports with shared folders etc.
• Implemented Data Level security into Business Model that has both Position Based Security and Geo based security for different user groups.
• Designed, developed and implemented a replacement budgeting system for the IT department. This replaced an Excel-based budgeting system with a Hyperion Planning application. The project resulted in IT's management and financial planners being able to see consolidated budgets in real-time, versus having to wait for an overnight batch process.
• Simplified the process of comparing Hyperion Essbase metadata (dimensions) against source trees in PeopleSoft. Created a Visual Basic .NET application that connects to Essbase databases and produces simple text files containing dimension information. These files can be loaded in Excel or Access and quickly compared against PeopleSoft reports..
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Designed the Star Schema after identifying the Facts and Dimensions
• Created the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter Workflow Manager

Environment: Siebel Analytics 7.7,Siebel Answers, Siebel Dashboards, Siebel Sales, UNIX, Oracle Essbase Hyperion 9, Informatica 6.1, Db2, Oracle 9i, Windows XP, IE 6.

Confidential, Atlanta Ga

Functional Analyst/Siebel Analytics Developer

Responsibilities:

• Documented and designed requirements and transformed the Business Requirements to System Requirements with technical specifications leading to design of reports and charts
• Involved in writing Use Cases for the Offer/Order and HelpDesk functional areas - submitted & approved by CIT Architecture
• Good experience in understanding & creating source and target definitions and Source Data Mapping - Offer/Order, HelpDesk
• Involved in Target (cLDM ) Mapping - Offer order/RTM,IOM, Billing
• Documented and designed requirements for Logical Data Models (cLDM) Entity/Attribute level - Offer/Order, RTM, IOM, Billing
• Involved & Developed Full cycle implementation of Siebel Analytics in Development life cycle.
• Actively involved in gathering user requirements and GAP Analysis
• Actively involved in writing System Requirements for Domains - documented and loaded into DOORS
• SR’s - OFFER/ORDER
• SR’s - RTM
• SR’s - Integrated Order management
• SR’s - Billing
• SR’s Customer
• Worked with various Tools BRRT and Doors and developed various reports in Access and Excel as per the client requirement
• Created Customization Packet - Summary of Customizations to Siebel, Siebel Analytics and Legacy systems by Domains
• Involved in Customization Reviews with Business - in addition to customization deck, additional documents were created to facilitate the reviews
• Created ‘1+1’ Reporting Tool and analyzed ‘1+1’ reporting impacts on metrics
• Good experience in understanding & creating source and target definitions, mappings, and working with sessions
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Designed the Star Schema after identifying the Facts and Dimensions
• Designed and customized Siebel Answer Views and charts, Create and save Filters and Prompts, Create Charts and Tables in Siebel Answers Created Star schema in the BMM layer.
• Created Dimensional Hierarchies and Modeled Slowly Changing Dimensions
• Created the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter Workflow Manager
• Actively involved in creating DATA MAPPING GAP SUMMARY (by Domains)
• Created Reports in Siebel Answers/Dashboards in Analytics Answers
• Managed Analytics Responsibilities to the user group for visibility of screens, views, reports, and dashboards
• Co-ordinated with QA team to test and validate the reporting system and its data.
• Trained the end users in accessing reports in pre-built dashboards, configuring their personal “My Dashboard”, creating sharing reports with shared folders etc.

Environment: Siebel Analytics 7.5.3, Siebel Answers, Dashboards, Siebel Call Center, Siebel Sales, Sales Analytics, Informatica 6.1, Oracle 9i, Windows XP, IE 6.

Confidential, MN

Siebel Analytics Reporting/Functional Analyst

Responsibilities:

• Worked closely with Business user in Understanding the Analytics reporting needs From target user groups.
• Actively involved in gathering user requirements and GAP Analysis
• Worked extensively on Customizing Siebel Vanilla Analytics Repository, that includes Physical Data Layer, Business Model and Presentation Layer in Siebel Analytics Administration Tool.
• With the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges.
• Involved in Dimension modeling, Identified business attributes and measures, defined dimensional model (STAR Schema) to store the business attributes and measures.
• Created Reports in Siebel Answers/Dashboards in Analytics Answers
• Created Reports for the opportunity forecasts to measure the potential business, as well as the business to measure lost business opportunity and the factors associated with it to aid the management.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies.
• Designed various reports like Drill Down, Pivot, Break down Reports and Nested reports in Answers and configured Intelligent Dashboards for different user groups to view data across regions and Customer Demographics with the facility of drill downs and Charts.
• Trained the end users in accessing reports in pre-built dashboards, configuring their personal “My Dashboard”, creating sharing reports with shared folders etc.
• Implemented Data Level security into Business Model that has both Position Based Security and Geo based security for different user groups.
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• Designed the Star Schema after identifying the Facts and Dimensions
• Created the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter Workflow Manager
• Having Good knowledge of DAC

Environment: Siebel Analytics7.5, Informatica 6.1, Oracle 9i, SQL Sever 7, Windows 2000, IE 6.

Confidential, Chicago,IL

Siebel Reports Developer

Responsibilities:

• Worked with Business People for gathering requirements, Identified Analytics Report requirements and defined ETL Process Flow to aggregate the data.
• Performed Gap Analysis on Siebel Vanilla Data Warehouse STAR Schema and created new STAR Schemas and extensions to Existing Fact - Dimension tables.
• Used Informatica ETL to extract data from different Sources and loaded into Siebel CRM system.
• Created Repositories, Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool.
• Designed and customized Siebel Answer Views and charts, Create and save Filters and Prompts, Create Charts and Tables in Siebel Answers Created Star schema in the BMM layer.
• Created Dimensional Hierarchies and Modeled Slowly Changing Dimensions
• Customized Siebel Data warehouse mappings and sessions for the extensions tables and columns in the Siebel OLTP database also tuned out of box, Sessions and mappings for better performance
• Good experience in understanding & creating source and target definitions, mappings, and working with sessions
• Worked extensively developing the ETL mapping. Worked with various transformation such as Source Qualifier, Joiner transformation, Lookup transformation, Expressions, Aggregator and Sequence Generator.

Environment: Siebel Analytics 7.5.2, eclinical, Oracle 9i, Toad, Sql, pl/sql, Informatica Power Center 6.1.

Confidential

Siebel Analytics Developer

Responsibilities:

• Installing Siebel Analytics Server, Configuring and Administration of Siebel Analytics.
• Developed the Analytics reporting prototype and Demonstrated some of the Siebel Analytics advanced features such as end user ad-hoc querying, drill downs, Navigational links and generating reports out of versatile data sources such as excel spreadsheets, Flat files and relational data base.
• Involved in creating Data Sources for connecting to the back end database.
• Created Repositories using Siebel Analytics.
• Created the Physical Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool.
• Involved in creating Dimensions in the Business Model and Mapping Layer.
• Developed Customized Reports and Filters in Answers, Dashboards.
• Administered the user / responsibilities on the production environment.
• Managed Analytics responsibilities to the user group for visibility of screens, views, reports, and dashboards
• Trained the end users in accessing reports in pre-built dashboards, configuring their personal “My Dashboard”, creating sharing reports with shared folders etc.
• Co-ordinated with QA team to test and validate the reporting system and its data.

Environment: Siebel Analytics 7.5, IIS, SQL Server7, IE5, Windows 2000.

Confidential, Houston,TX

Siebel Configurator / Developer

Responsibilities:

• Used Siebel Tools to configure objects such as Screens, Views, Applets and Pick Lists as per customer requirements.
• Involved in creation of List and Form Applets and also modified existing ones in order to in corporate new fields defined in the business requirements documentation.
• Configured Business Components and Visibility as per requirements.
• Created a Pick List to map to the status field of contact’s account business component. (The values were New, Active, Inactive, and Pending Care).
• Involved in the implementation of Siebel Finance
• Working on Siebel Tools general configuration to add new functionality or modify the existing functionality to meet the client’s requirement.
• Configured eBusiness Applications using Siebel Tools 2000 and customized as per the Client’s requirements.
• Initializing the local database for Mobile clients and administrating them using Remote Administration.
• Configuration of Applets, Views, Business components and objects using Siebel Tools.
• Involved in finalizing and setting up of the Organizations, Divisions, Positions and Responsibilities the business requires.
• Administered Enterprise Integration Manager and carried out data migration. Configured EIM configuration file, prepared interface table for migration, executed various EIM processes.
• Documented and designed process requirements and transformed the requirements to technical specifications leading to design of reports and charts.

Environment: Siebel 2000, Siebel finance/eFinance, Siebel PRM, Siebel Tools, eScript, EIM, Workflow Manager, Oracle 8, Java, WIN NT.

Confidential, Houston, TX

Siebel Configurator

Responsibilities:

• Involved in Extending the Database-Added Custom Extension Columns to existing tables, Added new Fields to the Business Components & reference the custom Extension Columns & display them on Applets.
• Developed eScripts to Invoke Workflows.
• Created and maintained custom siebel eScript routines to add or enhance the functionality of the application.
• Configured the fields & Business Component Properties.
• Created a Picklists to a field, made it available to the user through an applet and modified the Picklists to add new choices.
• Performed data migration into Siebel database.
• Configured and optimized the configuration (.ifb) file to run EIM server tasks
• Populated EIM tables, performed processing and follow-up activities for importing corporate data into Siebel database using Oracle and PL/SQL
• Created/modified tables, business components and objects, applets, views related to Accounts, Activities and Service Request modules for the purpose of streamlining the process of improving productivity and providing access to legacy data using Siebel Tools.
• Created Siebel Workflow Policy to invoke Workflow process when the required conditions are met.
• Populated EIM tables, performed processing and follow-up activities for importing corporate data into Siebel database using Oracle and PL/SQL
• Integrated Siebel application with other third party Applications
• Used Assignment Manager to assign the Opportunities and Service requests to the right candidates. Created Assignment Attributes, Criteria and Rules to do the same. Used Batch Assignment as well as Dynamic Assignment as per the requirement. In Siebel Sales.
• Cleansing the existing data in the system like merging of records etc.
• Responsible for designing and maintaining the workflow processes. PVR Approval process was completely automated using the Workflow processes.
• Implementation of static and dynamic Pick-Lists, Pick Applets, Joins, Links, Hyper-Linked Drilldowns.

Environment: Siebel 7, Tools Configuration, EIM, Workflow, Assignment Manager, Call Centre, Script.