PROFESSIONAL SUMMARY:

• More than ten years of Experience in Information Technology (IT) industry working on various reporting tools and integration technologies.
• Experienced in all stages of System Development Life Cycle (SDLC) efforts including requirements definition, design, architecture, development, testing, maintenance and support (SDLC)
• Expertise in industry standard methodologies for Requirements Gathering and Estimation including conducting workshops to Business Users
• Worked on projects Integrating Oracle BI system with Siebel, Oracle EBS, PeopleSoft, and Documentum Systems.
• Rich experience in conducting requirement gathering sessions with business and IT stake holders.
• OBIEE implementation experience including five end - to-end green field OBIEE project implementations having global deployment, rollout and leveraged systematic methodologies and processes during all phases of the software development life-cycle
• Experienced with design and development of large scale OBIA/OBIEE solutions integrating internal and external sources.
• Developed a full spectrum of reports and metrics including OBIA Financial Analytics(GL, AR, AP), providing key information required to determine the financial state of the company and what actions/decisions may be required.
• Experience doing fit-gap analysis of transitioning many of the user reports for HR and Financials in legacy reporting systems to OBIEE
• Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
• Extensive experience Implementing BI solutions for Pharmaceutical, Retail, Financial,Telecom, Manufacturing and other sectors for their various business processes i.e., Sales Analytics, Service analytics, and Marketing Analytics
• Experience working on OBIEE/Siebel Analytics features (i.e. Clustering, Security,cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Disconnected, Integration Variables/Initialization Blocks configuration etc.)
• Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with worklets& tasks and scheduling using workflow manager.
• Experienced in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
• Optimized the Solution using various performance tuning methods (SQL tuning, ETL tuning (i.e. optimal configuration of transformations and memory parameters), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Tables, Procedures, functions etc.
• Proficient building reports in BI Publisher and using various templates to publish the reports as per user and business requirements.
• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

TECHNICAL SKILLS:

Business Intelligence: OBIEE\OBIA11.x/10.x, Siebel Analytics 7.x, RPD, Dashboards, Delivers, BI PublisherOracle BI Apps(OBIA) 7.9.5/7.9.6 , ODI.

ERP/CRM(Source Systems): Siebel, PeopleSoft, Oracle EBS

Horizontals: Contact Center, Service Analytics, Sales Analytics, Supply Chain & Order Management Analytics

ETL: Informatica Power Center 7.0, 8.0,9.1,Data stage

Languages: PL/SQL, SQL*PLUS 8.x/9.x,Java

Web: JSP, HTML, XML

Scripts: Shell Scripting

Data Modeling: SQL Developer, TOAD 11.5

Databases: Oracle 9i/10g,11g

OperatingSystem: Windows, UNIX, Linux, Solaris.

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Sr. OBIEE\OBIA Developer

Responsibilities:

• Worked closely with business users in the client side and designed the system accordingly.
• Functional knowledge of D2 Documentum system.
• Involved in gathering and analyzing requirements and documenting them for further implementation.
• Identified issues, performance bottlenecks, and optimized the logical queries generated by Analytics engine.
• Used job manager to manage and monitor iBots.
• Extensively worked in designing the BI Publisher templates for pixel perfect reports.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Used several OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, and Security….etc.).
• Involved in OBIEE upgrade from 11g to 12c.

Environment: OBIEE 11.1.1.7, OBIEE 12c, Oracle 11g, Oracle Answers 11.1.1.7, SQL Developer

Confidential, Charlotte, NC

OBIEE\OBIA Architect

Responsibilities:

• Worked Extensively on Financial Analytics data.
• Worked on the different layers in the data model (Physical, Business and Presentation).
• Customized Repository (RPD) to work with other systems. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Implemented new functionality in OBIEE for a report to pop-up in a new window.

Environment: OBIEE 11.1.1.7,Oracle 11g, Oracle Answers 11.1.1.7, SQL Developer

Confidential, Newark, NJ

OBIEE\OBIA Architect

Responsibilities:

• Worked closely with business users in the client side and designed the system accordingly.
• Worked Extensively on KPIs, in Call Center Analysis and Service Analysis.
• Created Authentication Blocks to capture the User login and displaying the data for the user alone.
• Customized Repository (RPD) to work with other EBI systems. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Worked Extensively with Time Series Calculations.
• Involved in developing complex logic, to capture the prompt values and displaying the results accordingly.
• Implemented security to display data depending on the login.

Environment: OBIEE 10.x/11.x (Contact Center Analytics), Oracle BI Apps (OBIA) 7.9.5/7.9.6 , DAC 11g, Siebel CRM 8.X, Oracle Answers 10.1.3.4, SQL Server 2008 , TOAD, Informatica 9.1,SQL Navigator

Confidential, Alpharetta, GA

Sr. Oracle BI Developer

Responsibilities:

• Installed and configured complete suite of OBIEE 10.1.3.4 in test and development environment on windows platform.
• Working on a fit-gap analysis of transitioning many of the user reports for HR and Financials in legacy reporting systems to OBIEE
• Implementing Financial Analytics (AP, GL,AR)
• Customized the configuration files of OBIA based on the client’s implementation of Oracle EBS
• Customized the OBIA out of the box mappings to build extensions to bring in additional data from Oracle EBS (Descriptive Flexfields, Oracle Shipping data, and FND lookups transformations)
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.

Environment: OBIEE 10.x/11.x (Contact Center Analytics),Oracle BI Apps(OBIA) Financial Analytics 7.9.5/7.9.6 , DAC 11g, BI Publisher,Siebel CRM, Oracle Answers 10.1.3.4, Informatica Power Center 8.1.1, Oracle 10g/11g,SQL Server 2008, TOAD, SQL Navigator,Informatica 8.0 ETL

Confidential, Peapack, NJ

OBIEE Consultant

Responsibilities:

• Developed dashboards in Supply chain including Order Management dashboard,Order Fulfillment dashboard,Inventory Dashboard
• Order Management dashboard provides order statistics, insights and trends for:
• Revenue comparisons
• High Value orders
• Discount trends
• Cancellation and Return Statistics
• The Order Fulfillment dashboard provides reports that highlight:
• Order Fulfillment performance
• Shipping and Backlog Trends
• The Inventory Dashboard provides insights into:
• Fast moving items of various category
• Transaction by plants and warehouses
• Component Utilization
• Implemented OBIEE security at the data and object levels
• Implemented user level security for intelligence dashboards based on Business Requirement.

Environment: OBIEE10.1.3.2(Clinical Analytics), OBIA 7.9.5 Supply Chain, Order Management Analytics, and ProcurementAnalytics, Oracle 10g, DAC 11g, Windows 2003 server,Informatica 8.0,Red Hat Linux.

Confidential, Houston, TX

Oracle BI Developer

Responsibilities:

• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Involved in Configuration of Web Catalog Security and Cache Management
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Involved in implementation of Pre built OBI analytics (Financial Management and Procurement Analytics)
• Trained and worked with the end-users in developing their own ad-hoc reports using OBIEE Answers

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4(Sales Analytics), Oracle BI Apps Financial Analytics(OBIA) 7.9.5/7.9.6 , DAC 10g,Oracle BI Server, BI Answers, BI Administration, BI Dashboards, BI Scheduler, BI Publisher, Oracle BI apps 7.9.5, Oracle 10g, Oracle e-Business Suite (EBS), Siebel CRM 8, PL/SQL Windows XP Prof.

Confidential, Cherry Hill, NJ

Oracle BI Consultant

Responsibilities:

• Identified the Data Sources (Relational, Excel etc), Facts, and Dimension tables in designing the Star Schema.
• Designed and Built OBIEE/Siebel Analytics RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.).Supported the testing of Siebel 7.5 to Oracle Order Management interface.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Developed test plans for quarterly CRP of every new quarterly release
• Created reports with different views (Compound, Chart, Table, Pivot, Ticker and Narrative)
• Secured Dashboards and Reportsby defining user roles.

Environment: OBIEE 10.1.3.4.0 , Oracle 10g, TOAD, Windows XP Prof

Confidential, New Brunswick, NJ

Siebel Analytics\Oracle BI Developer

Responsibilities:

• Involved in gathering new and existing report Business Requirements, performed GAP Analysis, and Data Analysis
• Identified the Data Sources (Relational, Excel etc), Facts, and Dimension tables in designing the Star Schema.
• Created logical tables and assigned levels and custom aggregation rules.
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

Environment: Siebel Analytics\OBIEE 10.1.3.4.0 , DAC, Oracle 10g, TOAD, Informatica 8.1.1, Sun Solaris 64