Experience Summary:

Eightplus years of experience in various roles as Developer,Administrator, Architect, Analyst, Module Lead in Business intelligence suites like Siebel Analytics/OBIEE, Siebel CRM Oracle EBS. Proficient with Development Methodologies, Technical Writing/Design Documentation, Quality Processes and AIM Methodologies with Strong Communication skills, Correspondence Excellent Email Etiquettes. Willing to work under challenging environments and ready to add value to the external and internal customers.

Technical Skills:

Tools:Siebel Analytics 7.7.1 /7.8.2 OBIEE 10g/11g Oracle Business Intelligence Enterprise Edition /OBIA Oracle Business Intelligence Applications ,Informatica 8,DAC,SSRS SQL Server Reporting Services ,,C and .net frame work.5,HTML, XML.

Databases: SQL Server 2000/2005,Oracle 9i/10g, SQL Developer/TOAD

Oracle EBS:OrderManagement/Inventory/Purchasing /Procurement/BOM/Oracle Financials-AP/AR/GL/ASCP/Demantra/Fixed Assets.

Non Technical/Soft skill Trainings: Body Language, Managing Virtual Teams, Power of Assertiveness, Impact-Campus To Corporate, Corporate Values, Professional Assertiveness, Working Effectively with Customers, Writing to reach the Audience, Email Organization Communication, Everyday Business Etiquette, Sustaining Excellent Customer Service, Major Time Management Challenges.

Professional Experience

Confidential

Developer/Analyst/Admin/Architect

Confidential is implementing a Federal project called Confidential Data Engine which essentially deals with Confidential and many OBIEE reports have been developed out of Claims/Providers/Patients/Diagnosis/Services data which are used by the users across different states in Confidential.

Responsibilities:

• Working with Business Analysts to understand/analyze the requirements.
• Worked on Technical Design Documentation Unit testing documentation.
• Vital Role in weekly conference calls with Business Analysts and the Users.
• Worked extensively on Oracle views to have a dimensionalized data model as the source for the OBIEE reports
• Worked on majority of Admin Tool objects like Physical Layer, Business Model Mapping Layer and Presentation Layer in Repository .rpd , different Admin Tool managers,Time Dimensions, Security etc.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Worked on scheduling the BI reports as per the user requirements.
• Worked on Catalog Manager to migrate the code from Dev, Test environments to Production Environment.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Used the 11g Web console Enterprise Manager to manage the users/security and server management.
• Worked on Unit Testing/ System Testing
• Code Migration

Environment:Oracle Business Intelligence 11g, Oracle R12 Toad/SQL Developer.

Confidential

Developer/Analyst/Admin/Architect

Confidential is the second largest canned seafood manufacturer in Confidential implemented Oracle E-Business Suite to track their business metrics/performance using OBIEE 11g for reporting purposes and the target users were from OM/Inventory/Sales/Purchasing/AR/Demantra.

Responsibilities:

• Direct User Interaction in gathering requirements and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Worked extensively on Oracle views to have a dimensionalized data model as the source for the OBIEE reports
• Worked on majority of Admin Tool objects like Physical Layer, Business Model Mapping Layer and Presentation Layer in Repository .rpd , different Admin Tool managers,Time Dimensions, Security etc.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards, scheduled reports for the users as per the requirements
• Worked on a Major Executive Dashboard for the regional managers which included the major Inventory Sales reports using Bar Charts, Pie Charts, and Line Graphs etc.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Used the 11g Console Enterprise Manager to manage the users/security and server management.
• Handled Support Issues by directly interacting with users/trained them on the application.
• Handled Admin activities like solving environment issues, code move from Dev environment to Prod. Also managed Access Privileges/Security using webconsole
• Handled User Training individually on OBIEE to Regional Managers at the Client Location.

Environment:Oracle Business Intelligence 11g, Oracle R12 Toad/SQL Developer, E-Business Suite Financials/OM/Sales/Inventory/AR/Purchasing/Demantra.

Confidential

Developer/OBIEE Architect

Technology score card is an application used by PNC directors and Managerial persons to report on different Category and accounting levels.CIO can report on the Directors strategic objectives and performance and the users couldmake an analysis on the KPI scores and accountability for period ranges at different levels.

Responsibilities:

• Requirements Gathering.
• Worked on Adhoc Prebuilt reports/dashboards. Also worked extensively on rpd as part of the reports development
• Used MUD environment during development of the project.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Month Ago, Year Ago based on the Requirements.
• Created Logical Tables, Logical Columns with Measures/Metricsas per the business needs..
• Implemented OBIEE Security Object Level and Data Level Security in the OBIEE Repository and Answers using Repository Variables, Session Variables and Initialization Blocks.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the reports/dashboards.
• Created Business Model to support Adhocreporting based on Requirements.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Responsible for documenting the OBIEE framework and track the progress.

Environment:Oracle Business Intelligence 10.1.3.4, Informatica Power center 7.1.2/8.1,Oracle 10g, Microsoft Windows Server 2003, Erwin.

Confidential

Module Lead/Developer/OBIEE Architect

The Oracle Financial Implementation OFI program is a multi-year initiative to deploy a proven, technologically modern, global financial solution that supports the external / management reporting needs of all American Express business units. Consolidations utilized Oracle's Corporate Performance Management application to improve the American Express Legal and Management reporting processes.

Roles Responsibilities:

• Requirement Gathering for high level low-level design for the reports dashboards
• Worked using AIM Methodology , documented Technical Design documents
• Worked on MSVisio and designedbusiness process flow diagrams
• Involved in Technical Writing , documented MD70s MD140s.
• Worked on Financial Analytics Schema developed new reports enhanced existing reports
• InstalledOBIEE 10.1.3.4 in development and test servers
• Designing/ConfiguringOBIEE Repository/Data modeling
• Reviewed Logical and Physical Data Model changes to ensure appropriate granularity and replacement of Facts/Dimensions, and the data architecture standards and guidelines being complied: data element definition and name consistency across the enterprise, data field naming convention and data type consistencies
• Customizing requests by using different views Chart, Pivot table, Narrative views, Title etc,
• Leading few Modules with onsite/offshore coordination.
• Designing Development of dashboards/reports
• Writing Test scripts/Test cases using Mercury Quality Center testing tool

Environment: Oracle BIEE10g Business Intelligence tool, the enhanced version of Siebel Analytics ,Oracle 9i, Oracle Financials,Windows XP, Sun Solaris

Confidential

Customer Excellence ReportingOBIEE Architect/Lead/Developer

Juniper Networks headquartered in Confidential having high-performance network infrastructure helps businesses create a responsive and trusted environment for accelerating the deployment of services and applications over a single network.The client wanted Sierra Atlantic to configure adhoc prebuilt reports/dashboards to analyze their Customer, Sales Shipment data using Siebel Analytics BI Tool.

Roles Responsibilities:

• Responsible for Gathering Business Requirements, Database ETL Design
• Worked using AIM Methodology, documented Technical Design docs was involved in Business Requirements Gathering.
• Created Logical Designs, Physical Designs , and Star Schemas for Analytics Reporting.
• Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica, Oracle SQL.
• Requirement Gathering for high level low-level design for the reports dashboards
• Designing Development of dashboards/reports, Design Development of Analytics repository.
• Design, develop and test dashboards and reports in Siebel Answers,created Delivers Ibots and scheduled for caching reports
• Modified various CSS and XML files to customize GUI look and feel and form messages.
• Analytics Cache Management User Management
• Implement Analytics web security and responsible for web catalog management.
• Object level Data level Security Implementation.

Environment:Siebel Analytics 7.8/OBIEE Business Intelligence tool, the enhanced version of Siebel Analytics , Oracle 10g, InformaticaPowercentre8.6.1, Customer Relationship Management, Document Management, OLAP, Linux

Confidential is one of the leading banks in the world and a major investor in Saudi Arabia's business world. The bank uses various legacy systems in their day to day operations viz. Cards Management System for cash Cards, Retail banking System for retail banking etc.Sierra Atlantic proposed a business intelligence solution to give the client a 360 degree view about the Bank's customers and Operational efficiency involving data conversion from OLTP to OLAP start schema using SQL loader, creation of role based dashboards and ad-hoc reports using Oracle BI EE.

Roles Responsibilities:

• Coordinated Data Architecture while acting as the central point of contact for data modelers, DBAs and business users. Identified gaps while ensuring compliance to established procedures, legal regulations and methodologies.
• Worked on Banking/Finance data, developed Balance sheet, debit cards/credit cards reports
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• Analyzed the Out Of Box Mappings and Created Gap Document detailing the Gaps.
• Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.
• Created Aggregate Tables to improve the Performance of the Reports.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards. .
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Data modeling Analytics Repository Configuration
• Designing Development of dashboards/reports

Environment: Oracle BIEE Business Intelligence tool, the enhanced version of Siebel Analytics , SQL Server 2005, Siebel CRM Customer Relationship Management , Informatica, Document Management, OLAP, Linux

Confidential

Platform ConsolidationDeveloper Tester

Confidential is to provide users with the necessary information to make strategic business decisions regarding sales, partners, accounts, teams and the like. To achieve this, the platform backend database will pull data from various sources, such as MS Sales, Siebel and HeadTrax and from there, the data will be placed into reports in a web browser to make the data easier to understand and more digestible.

Roles Responsibilities:

• UI Development using SSRS SQL Server Reporting Services Siebel Analytics
• Authored Technical Design documents Unit Test documents.
• Prepared the ETL Mapping Spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
• Development of Adhoc Reports Dashboards,rpd using Siebel Analytics
• Work with the Siebel Analytics Administration Tool
• Designed ,develop and test Analytics repository
• Created various calculated and level based measures involving various levels of aggregations
• Configured External authorization authentication
• Analytics Cache Management using caching parameters and event polling tables
• Designing and conducting training programs
• Planning and conducting training programs
• System Testing Unit Testing

Environment: Siebel Analytics 7.8, SQL Server Reporting Services SSRS,SQLServer 2005, Siebel CRM Customer Relationship Management , Document Management, OLAP

Integrated Reporting Platform IRP project replaces existing Enterprise Reporting System application to provide rich functionality Business Intelligence BI to the users.IRP integrates all the existing sources and provides a single data store to meet the reporting needs of the users.IRP replaces existing data warehouse tool Informatica with SQL Server Integration Services catering to the global business needs of Enterprise Sales and Call Center users of Microsoft.

Roles Responsibilities:

• UI Development Adhoc Reports Dashboards
• Involved in Technical Writing, designed documented TDs
• Used Visio designed Business process flow diagrams
• Siebel Analytics Configuration rpd and web-catalog
• Stored Procedures to extract Data from OLTP to OLAP
• Function Spec/ Technical Spec analysis reviews
• Technical Design Documentation
• Code reviews DBA Activities like replication, Backup Restores
• Designing and conducting training programs
• Creating and executing unit test cases .
• Troubleshooting ETL and data loading processes. Provide high quality suggestions to customers to design, customize and improve the Siebel OLAP data model.
• Planning and conducting training programs
• Implemented Usage Tracking
• Involved in writing test scripts for IRPS System Testing

Environment: Siebel Analytics, SQL Server 2000, SQL Server 2005, Siebel Sales Data, Informatica,Customer Relationship Management, Document Management, OLAP

Confidential

Enterprise Reporting SolutionsDeveloper Tester for ERS

Confidential Reporting Solutions is a data warehousing project used for ad-hoc reporting of Microsoft sales data. Enterprise Sales and Call Center personnel used ERS to generate the required reports to meet the global business needs.This reporting system also helped the higher level management to analyze and forecast the data and come up with marketing and sales strategies.

Roles Responsibilities:

• UI Development Adhoc Reports Dashboards
• Designed Documented TDs MD70s
• Siebel Analytics Configuration rpd and web-catalog
• Function Spec Technical Spec analysis reviews
• Technical Design Documentation Code reviews
• Implement the ETL mapping using the Informatica tool. Working on effectively tuning and addressing the performance of the data warehouse
• Troubleshooting ETL and data loading processes. Provide high quality suggestions to customers to design, customize and improve the Siebel OLAP datamodel.
• DBA Activities like replication, Backup Restores
• Designing and conducting training programs
• Creating and executing unit test cases,Bug triages System Testing

Environment: Siebel Analytics 7.7.1, 7.8.2, SQL Server 2000 and 2005, Informatica 6.1, Siebel Sales Data Windows XP, Customer Relationship Management, Document Management, OLAP.

Confidential

Employee Portal Developer

Employee portal is the central place for the employees which will act as a information central. This will contain the dashboard for a quick review of the happenings, inbox for the internal mails, forums for knowledge sharing, shift planners, cab bookings, timesheet, hardship allowance details etc...

Roles Responsibilities:

• Development of UI forms, WebPages using C , HTML XML.
• Creating and executing unit test cases,Technical Design Documentation
• Function Spec Technical Spec analysis reviews.
• Creation of Stored Procedures in SQL Server 2000.
• Code reviews/BugTraiges/Planning Team Meetings/Unit Testing/System Testing Integration Testing.

Environment: Net using C ASP.Net, SQL Server 2000.

Confidential

MSW ResourceDeveloper

Confidential facilitates Tracking the Resources and Project Details of MSBUIT. As these tasks being done manually using excel sheets by TMs Wipro implemented this project to simplify the process of allocation and de-allocation of resources and to keep track of projects in MSBUIT business unit of Wipro.

Roles Responsibilities

• UI Development
• Creating and executing unit test cases
• Technical Design Documentation
• Function Spec Technical Spec analysis reviews
• Bug triages
• Creation of Stored Procedures
• Code reviews
• Planning and conducting training programs

Environment:

.Net using C ASP.Net, SQL Server 2000.