SUMMARY:

• 11+ years of experience in Complete Software Development Life Cycle (gathering Business Requirements, System Analysis, Design & Data Modeling Star and Snow Flake, Development, and Testing) implementation experience of Data Warehouse, Datamart and Business Intelligence using Oracle Business Intelligence (OBI), Siebel Analytics and Informatica.
• Expertise in Oracle BI 11/10.x EE / Siebel Analytics (Admin Tool / Administration, Analytic Web / Presentation Services, Answers, Dashboards, Alerts, Delivers, iBots, Scheduler and Informatica (PowerCenter / PowerMart) .
• Experience in identifying & analyzing the source/feeder systems, identifying GAPS and providing appropriate solutions.
• Expertise in providing End - to-End Business Intelligence solution by configuring metadata, building Oracle BI / Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) and developing the Analytical Dashboards / Reports.
• Extensive experience in configuring Interactive Dashboards with drill-down & drill-across capabilities, Guided Navigation, Alerts, Security Setup (groups, access privileges), Filters & Rules with User Identity & Roles, Profiles & Personalization, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in debugging and optimizing the Oracle BI/Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• Experience in installation and configuration of Oracle BI EE 10/11g.
• Performance tuning of Oracle BI/Siebel Analytics Repository & Dashboards / Reports, by implementing Aggregate tables, Indexes and Cache management.
• Experience in implementation of Usage Tracking to analyze and tune the query performance.
• Worked in (MUD) Multi-User Development environment.
• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations (Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator) for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks.
• Experience in Oracle PL/SQL backend programming like Stored Procedures, Functions, Cursors, Triggers, Packages and other objects.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements. Expertise in working with business user’s community.
• Ability to work in a team environment, and desire to learn new tools and technologies. Always willing to work in a challenging and cross platform environments.

TECHNICAL SKILLS:

Oracle Business Intelligence EE 10/11.x: (Admin, Presentation Services, Publisher), BI Apps 7.9.x, Business Objects XI R2, Tableau, SSRS, SSAS, APEX, Exalytics Times Ten, Amazon RedShift, Tableau, Talend, Xplenty, MySQL, MS SQL Server

Siebel Analytics 7.x: (Admin, Web, Answers, Dashboards), Scheduler (iBots)

Informatica 7.x/9.x: (PowerCenter / PowerMart), Datawarehouse Administration Console (DAC)

Oracle: 8i/9i/10g, SQL*PLUS, PL/SQL, TOAD, SQL Developer, Data warehousing

Unix, Linux, Windows: XP/2003/NT

PROFESSIONAL EXPERIENCE:

Confidential, Walnut Creek, CA

Sr Business Intelligence Analyst/Solution Architect

BI/DW Implementation for Sales Analytics

• Founded in 2001, YLighting is the leading retailer dedicated to the best in modern and contemporary lighting. We offer design driven consumers and trade professionals a premier selection of more than 15,000 products from top international brands, such as Artemide, FLOS, Nelson Bubble Lamps, and Louis Poulsen. Our curated collection ranges from iconic mid-century modern works to today’s most innovative, contemporary lighting. Our difference is our commitment to an incomparable customer experience including an extensive assortment of the best in modern and contemporary lighting, expert advice and service, inspiration and support throughout our customers’ projects.

Confidential, Sunnyvale, CA

Sr Business Intelligence Analyst/Solution Architect

• Global Support contributes a significant percentage of the Riverbed Revenue, however we are always focused on improving. This project has targeted First Year Renewals and Run Rate Renewals as two areas of lower than average performance which need attention and improvement. The business is making process changes to address these areas, but in order to measure our progress we need metrics which will chart the progress.

Environment: OBIEE 11.1.1.7, Informatica PowerCenter 9.x, DAC 11g, BI Apps 7.9.x, Oracle 12c, APEX 4.x, BI Publisher 11.x, Exalytics, TimesTen, JIRA

Confidential, San Diego, CA

OBIEE Solutions Architect/BI Technical Lead

• The AT&T National Compliance Center (NCC) needs appropriate reporting access to the data in EDW. The required manual interface must support 2 queries for Subscriber Accounts and Subscriber Payments. The interface must allow entry of the required and optional input fields and provide a report of the required output.
• This solution will leverage business rules designed into existing Stored Procedures for Subpoena Compliance (GetEDWSubInfo and GetEDWPaymentInfo) where possible but due to different technologies, modifications will be needed.

Environment: OBIEE 10.1.3.4.1/11.1.1.7 , Informatica PowerCenter 8.6.1, DAC 10g, BI Apps 7.9.6, Oracle 10/11g, Tableau 8.x

Confidential, San Jose, CA

IT Analyst

Responsibilities:

• Gathered Business Requirements & Prepared Business Requirements Document (BRD) and based upon BRD prepared Functional Specification Document (FSD).
• Determined Facts & Dimensions, Date & Time relationships, Granularity, Data Consistency across Dimensions, Identified Business Users & Group Security and Data Source systems.
• Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Names for Source Columns, Reports and Dashboard Layouts).
• Developed RPD and Webcat based on the BRD and FSD.
• Implemented Data level and Object level security for (CBR).
• Created ad-hoc reports as per the user requirement.
• Involved in loading the data through flat files every month.
• Executed and Monitored daily ETL during source upgrades.
• Secondary support for the Sales Dashboard project.
• Analyzed the impact of BI reports during source upgrades and prepared the detail document with respect to Sales BI.
• Did Regression Testing and Data Validation during source upgrades.
• Documented RPD and Webcat.
• Updated Sales Usage data per quarter for Sales Dashboard Confluence every month.

Environment: Oracle Business Intelligence (OBI) EE 10.x, Oracle8i, PL/SQL, TOAD, HCMC Tool, Dollar Universe, Windows XP

Confidential

IT Student Assistant

• Trouble shooting Computers
• Setting up Projectors
• Installing Software’s/Operating Systems

Confidential, Mountain View, CA

QA Engineering Intern

• Performed Client side testing by installing IEIM and Server side testing using SyncML Server on Nokia N-series, Blackberry, and Palm devices.

Confidential

IT Student Assistant

• Data Entry
• Organizing files