SUMMARY

• 6 + years of experience in Software Development and Expertise in OBIEE (Siebel Analytics)
• Experience in developing Metadata Repository at three layers using Oracle BI/Siebel Analytics Administration Tool.
• Experienced in Data Warehousing concepts and Data modeling using Star schema and Snowflake schema.
• Extensive knowledge in Customizing repository(rpd), configuring Metadata objects (Subject Area, Logical tables, Logical columns) and Web Catalog (Dashboards, Pages, Folders, Reports).
• Experience in configuring Interactive Dashboards wif drill - down capabilities using Filters and Dashboards Prompts, OBIEE Security Setup (groups, access privileges), Metadata Objects and Web Catalog (Dashboards, Pages, Folders and Reports).
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in relational and dimensional modeling.
• Strong knowledge in OLAP system, source and target table mapping to OLTP system
• Experienced in Oracle PL/SQL backend programming like Stored Procedures, Functions, Cursors and Triggers.
• Working knowledge on different data sources as Siebel, Oracle, SQL Server, DB2, XML and Excel files
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment
• Excellent problem solving skills wif strong technical background and good inter-personal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.

PROFESSIONAL EXPERIENCE

Confidential, Seattle WA

Senior Oracle Business Intelligence Developer

Responsibilities:

• Used the OBIEE 10.1.3.3.x, OBIEE 11g Administration tool to develop and enhance meta-data.
• Configured Oracle Business Intelligence Application (BIAPPS) prebuilt repositories for Marketing Department, including setting up Oracle Business Analytics Warehouse (OBAW) formerly and using Database Administration Console (DAC).
• Customized the OBAW to meet the business requirements for Holland America reporting purposes using Oracle application Express and stored procedures in ORACLE 10g.
• Strong understanding of Transactional and Dimensional Data Modeling, Data Warehousing Concepts, and Designing Star & Snowflake Schemas for OLAP Systems
• Expertise in developing OBIEE repository wif Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE (Siebel) Answers and troubleshoot various technical issues and bugs.
• Successfully establishes the connectivity from Sieble to OBIEE10.1.Xand OBIEE 11.1.X and designed customized reports using OBIEE metadata.
• Working knowledge in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows wif Worklets & Tasks and Scheduling using Workflow Manager.
• Experienced in Performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User acceptance.
• Experience in interacting wif Business users to analyze the business process and requirements and writing technical documentation and rolling out the deliverable
• Configured Job manager and BI scheduler to Deliver reports and per cache huge marketing report.
• Created, Scheduled & monitored the reports in Oracle BI Publisher Enterprise.
• Performance Enhancement of the data ware house using indexing, partitions and running statistics.

Environment: OBIEE 11g, OBIEE 10.1.3.3.3 , OBI-APPS 9.3.5, Siebel Analytics 7.8, DAC 7.95, ORACLE 10g/ 11g, SQL, TOAD, Informatica 8/7.1, ORACLE Application Express, Oracle Job Manager Scheduler 10.1.3.3, Web Analysis studio.

Confidential, Seattle WA

Siebel Analytics Consultant

Responsibilities:

• Coordinated and presented deliverables to marketing team and Development teams.
• Sourced requirement documents and produced functional specifications.
• Presented functional and technical requirements information in-group settings.
• Created high-level and detailed design documentation.
• Work closely wif the marketing team to understand and build segments trees for the campaigns.
• Launch campaigns, supervise, analyze and build reports for the campaigns wif direct mailing and electronic mailing.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet marketing requirements.
• Implemented the best practices, which reduced the cycle time and improved profitability for the organization.
• Worked closely wif the DBA and ETL Leads for gathering necessary data.
• Configured Repository on the Physical, Business and Presentation levels.
• Optimize query cost and improve the performance of Marketing and campaign reports.
• Configure caching in order to improve the performance of reports.
• Migration of reports from Cognos version to OBIEE wif out changing the functionality of the Report.
• Migration of reports from existing Cognos version to OBIEE nvolves entire process of analytics Data sets again and building repository and developing reports from scratch.
• Create internal reports to track query performance and also monitor report /dashboard usage through Usage Tracking.
• Performed Pre and post implementation testing of dashboard, answers and validating repository.

Environment: OBIEE 10.1.3.3.3 , Siebel Analytics 7.8, DAC 7.95, ORACLE10gSQL, TOAD, Informatica 8/7.1, Oracle Job Manager Scheduler 10.1.3.3

Confidential, New Jersey

Analytics Consultant

Responsibilities:

• Gatheird, defined and documented business requirements, including review, approval and analysis of business problem/needs related to the complex business processes.
• Supported the SDLC/RUP to bridge the gap between business requirements and technical solutions and ensure dat technical designs/solutions meet functional specs and requirements.
• Partnered wif business stakeholders to define user acceptance criteria and conducted/coordinated UAT.
• Coordinated activities between business unit and technical staff to develop new methods, policies, and procedures to meet the business needs.
• Work wif the analytics development team to gather requirements for generating reports and track changes wif each migration and RPD development.
• Conducted postproduction release evaluation.
• Prepared and presented project deliverables to the appropriate management for project review throughout the development life cycle.
• Involved in collecting, analyzing and documenting the business requirements for the project, and translated these into functional specifications and detailed test plans;
• Updating the requirements documents as per business user feedback and change in functionality of the application; creating the personalization for the complete portal.
• Clarifying QA teams issues and guided in performing unit testing and integration testing.

Environment: Windows XP/2000/NT, SQL 2005 Test Director, Win Runner, HTML, MS Word, MS Power Point, MS Excel, MS Access, MS Visio, MS Project, Analytics Reports, TOAD, Windows 2000 Server.

Confidential, New Burgh NY

Business System Analyst

Responsibilities:

• Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
• Conducted User Requirements Meeting.
• Involved in analysis and documentation of client requirements using UML and RUP.
• Assisted in creating ERD for system design.
• Translated the business needs into system requirements, communicating wif the business on a non-technical level, and wif the System Analyst on a more technical level.
• Assisted in developing Test Scenarios and Test Plan.
• Assisted in developing User Training Plan and conducted UAT.
• Conducted project related Presentations.
• Project management for respective projects. Liaison between Software team, Management team to build software for the IP surveillance camera followed by testing and reconciliation.
• Document deliverables and ownership of the whole project plan and SRS.
• Extensive collaboration between teams based out of India.

Environment: Windows XP/2000/NT, SQL 2005 Test Director, Win Runner, HTML, MS Word, MS Power Point, MS Excel, MS Access, MS Visio, MS Project.

Confidential, Hopewell NY

Business System Analyst

Responsibilities:

• Involved in facilitating Joint Application Development (JAD) sessions to gather requirements from employers of different groups.
• Performing Gap analysis and Data analysis for the impact areas; documenting system/user requirements including process flow mapping, definitions and translations; preparing and managed project plan using MS Project; analyzing and developing requirement documents functional specifications, test-case scenarios .
• Developing the prototype for the application and assisted in developing reports tracing requirements to High Level Design, Test Cases and Product Requirements.
• Assisting in development of training material for new technology and process improvements.
• Preparing and managing project plan and Weekly project status reports using MS-Project and MS-Word and reporting the same to the Project Sponsor

Environment: Windows XP/2000/NT, SQL 2005 Test Director, Win Runner, HTML, MS Word, MS Power Point, MS Excel, MS Access, MS Visio, MS Project.

Confidential

Business Analyst

Responsibilities:

• Involved in facilitating Joint Application development (JAD) sessions to gather requirements from SME s of different groups;
• Performing Gap analysis and Data analysis for the impact areas; documenting system/user requirements including process flow mapping, definitions and translations; preparing and managed project plan using MS Project; Analyzing and developing requirement documents (functional specifications, test - case scenarios) using Catalyze Enterprise wif supporting business process flows;
• Developing the prototype for the application and assisted in developing reports using Siebel Analytics tracing requirements to High Level Design, Test Cases and Product Requirements.
• Working closely wif and supporting the Project Manager and associates.
• Assisting in development of training material for new technology and process improvements.

Environment: Siebel Analytics 7.0, Oracle 8i, SQL Server 2000 and Windows 2000.