Experience Summary:

• Around 7 plus years of solid experience in Information Technology with strong working knowledge in in Business Requirements Gathering, GAP Analysis, Data Modeling Testing, Implementations and Documentations of Data Warehouse / Data Marts deployments and Business Intelligence solutions
• Knowledge and experience in handling every phase of Software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Extensive experience in using Oracle Business IntelligenceEnterprise Edition 10.1.3.3.3/10.1.3.2 and SiebelAnalytics 7.7.1/7.8.5
• Expertise in developing OBIEE repository development, configuring metadata objects(Subject Area, Table, and Column) and webcatalog objects (Dashboards, Pages, Folders, Reports).
• Expertise in configuring Siebel Analytics Admin Tool, Analytic Web and Scheduler.
• Expertise in developing Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Strong in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series etc.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in publishing using BI publisher to publish the reports in different formats based on the request.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytics/ Dashboards / Reports.
• Expertise in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 8.x/7.x/ 6.x.
• Strong understanding of data warehousing concepts, dimensional modeling, designing Star and Snowflake schemas.
• Extensive experience with developing Logical and Physical Data models using Erwin.
• Expertise in writing stored procedures, Functions, Views, Packages, Database triggersand extensively worked on Backend Programming using PL/SQL.
• Excellent interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools and business environment with excellent communication and analytical skills.

Education:
B.Tech in Electronics and Communication Engineering

Technical Skills:

RDBMS: Oracle 10g/9/8.0/7.x, MS SQL Server 2005/2000/7.0,
Data Warehousing tools: Informatica (Power center 8.6, 8.1/7.1/ 6.2)
BI: Oracle Business Intelligence Enterprise Edition, (OBIEE)10.1.3.3/10.1.3.4,
Siebel Business Analytics 7.8.2/7.7.1
Operating Systems: Windows XP/2003/2000,AIX 5.3, MS DOS
Languages: SQL*Plus, PL/SQL,T-SQL, .NET
MS Suite: Word, Excel, PowerPoint, Access, Visio.
Tools: Erwin 7.2/4.1/3.5, TOAD 6.5, SQL Developer 1.5, Test Director 8.0,
Quality Center 9.0
Web Based Technologies: HTML, XHTML, JavaScript, Flash, Actionscript, XML, CSS

Confidential, NY Aug'10- Till Date
BI Consultant

Confidential, is a world-leading financial services company, advising clients in all aspects of finance, around the world, around the clock.The project is to create a monthly management dashboard, internally referred to as the "Executive Summary", spotlights data as it corresponds to risk and control. The objective is to integrate relevant data into a dashboard structure from mentioned systems and bring in as much automation as possible for efficiency in management reporting for the control group.

Responsibilities:

• Interacted with Business Users and conducted many brain storming sessions,Gathered the requirements and responsible for preparing the HLD documents and FDD documents for deliverables.
• Analysed all their source systems data which was in excel sheets in process to create the Data Store.
• Responsible for creating data model (Conceptual,Logical and Physical data model) using Visio.
• Performed the Gap analysis and done a mapping exercise on process for creating the Data Store.
• Identified the Data Sources (Relational, Excel etc), Facts, and Dimension tables in designing the Star Schema for the Datastore.
• Finalized all the reporting views and Dashbord views Business was looking for during the functional requirement and design phase and given them best solutions.

Environment: Oracle Business Intelligence EE 10.1.3.3.4, Oracle 10g, Informatica PowerCenter 8.6, Visio Embercadero, PL/SQL,Windows XP/2003 Server

Confidential, MN Jan'09 - June' 10
BI Consultant

Confidential, is one of the leading provider of products, programs and services that help people celebrate important moments, recognize achievements and build affiliations.The company\'s products include yearbooks, class rings, graduation products and products for athletic champions and their fans.. This project involves organization and tracking of the data from multiple channels for analysis of Order entry system, Sales and Marketing.

Responsibilities:

• Interacted with Business Users ,Gathered the requirement and responsible for preparing the HLD documents and FDD documents for deliverables.
• Analyzed the requirements, functional specifications and identified the source data to be moved to the repository from datawarehouse.
• Performed Gap Analysis and translated them to technical design requirements.
• Actively resolved some of the ongoing production issues.
• Designed and Development of Oracle BI Metadata Repository(.rpd) with multiple business layers using joins, presentation catalogs with access validations and externaltable security repository.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic /Interactive Dashboards with drill-down capabilities using global and local Filters.
• Involved in integrating OBIEE user interface with EBS
• Designed and developed the many Performance Measurement Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & different charts (bar-charts, pie-charts, radars, and bubble-charts), reports for summary & details information, and local & global filters andcache monitor using Oracle BI Presentation Services.
• Filters (Prompts) and Filter Criteria were created and configured as per the business requirements.
• Integrated MS Word BI Publisher and OBIEEto publish the reports in different formats.
• Configured Security levels for users, groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security).
• Configured BI Publisher Settings in the Configuration File for Presentation Services
• Renamed the components as per business terminology and Configured Dimensional Hierarchies as required.
• Implemented Basic Security and LDAP server Authentication
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.

Environment: Oracle Business Intelligence EE 10.1.3.3.1, Oracle 10g, Informatica PowerCenter 8.1,Toad, PL/SQL,Windows XP/2003 Server

Confidential, PA Nov'07-Dec'08 OBIEE Developer
Metadata & ReportsDeveloper

for the Confidential,Analytics implementation.The implementation was on Siebel Analytics which is used to replace their current system [Excel Based reporting]. This has provided a single point repository which contains a complete portfolio of the company's clinical trials and provided a clean interface for exporting the reports.

Responsibilities:

• Attended meeting along with the Project manager and involved in Datamodeling and Dataanalysis.
• Extracting business logic, Identifying Entities and identifying measures/dimension out from the existing data.
• Created and modified mappings according to the client\'s requirement.
• Created Repository and designed physical and logical star schema.
• Configured different subject areas according to the business requirement.
• Created dimension hierarchies to achieve the drill down functionality.
• Implemented Security management for users, groups and web-groups using the various authentication systems.
• Created reports and prompts in answers and creating dashboards and links for the reports.
• Customized all the dashboards, reports to look and feel as per the business requirements using different analytical views.
• Developed many Reports using different Analytics Views (Pivot Table Chart and Column Selector) Dynamic / Interactive Dashboards with drill-down capabilities charts tabular using global and local Filters. Extensively used Siebel Delivers and iBots
• Create BI Publisher report based on answers request and view its data in BI publisher.
• Created materialized views and aggregates to improve performance of the queries generated by BI server.
• Created XML/BI reports using XML/BI Publisher

Environment: Oracle BI EE (10.1.3.3.1), Sibel CTMS, Windows 2000/2003, Informatica PowerCenter/Power Mart 7.1.3 ,TOAD 6.5,Oracle 10g.

Confidential, MN Sep'06 - Oct '07
BI Consultant

The project was developed to enhance the Management Information Group to effectively monitor, track and utilize their existing Call Center Agents. It helps to develop a management strategy inorder to increase the productivity, effectiveness and thereby enhancing their client satisfaction index which in turn improves the overall ROI of Target Corporation.

Responsibilities:

• Involved in Understanding the Requirements and Preparing Design Documents.
• Extensively involved in creating logical and physical joins using RPD.
• Work extensively with Physical Layer, Business Model & Mapping Layer and Presentation Layer.
• Design Schema/Diagrams using Fact, Dimensions, Physical, Logical and Alias tables.
• Responsible for configuring and monitoring different siebel architechture components.
• Created logical tables and assigned levels and custom aggregation rules.
• Developed Calculated measures, level based measures and dimension hierarchies in the Business Model and Mapping Layer .
• Developed Subject areas and organized the presentation layer in a format that is easy for the end users to use for reporting.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Created presentation catalog which allows exposing the business model to users in Siebel Analytics Answers so that users can build requests to analyze the data.
• Create groups in the repository and add users to the groups and grant privileges.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities based on period and class hierarchies
• Involved in implementing different views of report such as Pivot table, Titles, Graph, Filters etc.
• Implemented Dashboard prompts and Filters for limiting the number of records.
• Managed day-to-day repository, Scheduler & IBots.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.

Environment: Siebel Analytics 7.8,SQL Server 2000/2005, SQL Query Analyzer, Oracle 9i,Erwin 4.1, Informatica7.1.2, Windows 2000.

Confidential, Jan'06 - Aug' 06
Siebel Analytics Developer

This is a datawarehouse project for Daimler Chrysler Truck Finance Division. A web based single source integrated reporting application was implemented, resulting in improved business performance.

Responsibilities:

• To gather all the information relevant to the task and use the OBIEE administration tool to develop and enhance meta-data.
• Created a repository using Siebel Analytics Administration tool by importing tables into the physical layer and created the business and mapping model to incorporate the business logic.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Create/Manage Web Users and Groups and assigning permissions using Siebel Analytics Administration Tool.
• Created presentation catalog which allows exposing the business model to users in Siebel Analytics Answers so that users can build requests to analyze the data.
• Administered security privileges and permissions for each subject area and dashboards according to customer requirements.
• Created Pivot tables, views, charts for different requests.
• Developed Answers, Filters, Customized Reports and Dashboards using Siebel Analytics Web.
• Designed Integrative dashboards/Reports to help support Multi Org data and Multi Org Users.
• Configure Siebel Delivers/iBots to support critical business needs

Environment: Siebel Analytics 7.8.5, 2Informatica power center 6.1, ,Oracle 9.2.0.6., Toad, Erwin 3.5.1 ,PL/SQL, Windows 2000

Confidential, India Jan'04 - Sep'05
Oracle Developer

The project is all about automating the Medsite activities. The primary clients for the Medsite are doctors, pharmaceutical and biotech companies. Medsite acts as a mediatory between the two. When a company reaches Medsite to organize an event, it collects all the related information and generates invitation and sends it to the doctors who are registered in the Medsite Database. Event creation, invitation generation and sending these to the doctors are vital activities of the project.

Responsibilities:

• Extensively used SQL statements for adding, updating and fetching the required data from the database.
• Created dimensional data model for different modules using Erwin3.5.
• Developed complex SQL queries and PL/SQL packages, including stored procedures & functions, to fetch data for reporting and to accomplish several computations.
• Created Database Objects (indexes) to boost the performance of the Application.
• Extensively involved in coding of Triggers, Packages in the Application Level at each and every Transaction.
• Developed several forms and reports in the process. Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
• Responsible for creation of logical data models based on entity-relationship diagrams. The models were developed in accordance with the rules of referential integrity and normalization.
• Involved in interacting with the business community to understand their requirements.
• Created tables, table spaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD tool.

Environment: Oracle 7.3/8i, SQL*Loader, Erwin 3.5, PL/SQL, TOAD 6.5, Windows NT

Confidential, Aug'02 - Nov'03
Database Developer

Performed requirement analysis, designed and implemented a comprehensive Financial Accounting System. The application keeps track of all Cash, Receipts, Payments and Journal Vouchers.

Responsibilities:

• Performed Database design and development.
• Involved in designing the target Data Warehouse using Star Schema.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL / SQL for Incremental updates.
• Created necessary Repositories to handle the metadata in the ETL process.
• Created the Source and Target Definitions in Informatica PowerCenter Designer.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings.
• Perform Database Backup/Restore & Recovery operations.
• Create & maintain relationship constraints in order to ensure data integrity

Environment: Oracle 8i,PL/SQL, Windows 2000, TOAD.