SUMMARY

• Over 7 years of experience in Complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, GAP Analysis, Data Analysis, Design / Modeling (Star and Snow flake), Development, Testing, Implementations and Documentation.
• Extensive Business Intelligence experience using OBIEE 11G, 10.1.3.x, Siebel Analytics 7.x.
• Very strong experience in working with Oracle BI (OBIEE) applications including meta data configuration, dashboard report development, configuring Physical Layer, Business Model, Logical Table, Dimension, Column, Logical Table Source, Logical Joins, Aggregation Rules, Dimension Hierarchies, Complex Case Expressions, Facts, Dimensions, Repository Static/Dynamic Variables, Session Variable, adding multiple sources, executing direct Database requests, Oracle BI Views (Compound Layout, Chart, Gauge, Title, Narrative, Table, Pivot Table, Funnel Chart, List, Crosstab).
• Excellent knowledge in configuring Interactive Dashboards with drill - down capabilities using global and local Filters, OBIEE Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in debugging, optimizing the Performance Tuning of Oracle BI / Siebel Analytics Repository & Dashboards / Reports.
• Strong understanding of data modeling and dimensional modeling, and designing Kimball’s Star and Snowflake schemas.
• Proficient in Extraction, Transformation and Loading (ETL) of data from various sources (such as OLTP Systems, Flat files)/data marts in to the target systems (such as OLAP Systems) using various tools and utilities which include Informatica 8.1.1, PowerCenter and DAC.
• Worked extensively in developing ETL Transformations, Informatica Designer (joiner, expressions, lookups, filters, routers, stored procedures etc.,), Informatica Workflow Manager (Sessions, sources, targets, transformations etc., & direct, indirect sources), Informatica Workflow Monitor, and Repository Manager.
• Knowledge on OBIEE Administration (Configuring MUDE OBIEE scheduler, Repository server and presentation server configuration changes etc).
• Extensively worked on the sales analytics module of OBI Applications.
• Worked on Oracle 10g/9i/8i, SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL.
• Well versed in creating database objects like Tables, Synonyms, Views and Materialized views.
• Good exposure in writing UNIX shell scripts, Scheduling Cron Jobs and Performance Tuning of SQL statements.
• Experience in working with different operating systems like UNIX, Linux (redhat) and Windows 7/Vista/XP.
• Interacted with Business Analysts to covert the business requirements into technical requirements.
• Highly motivated team player with good communication skills and excellent problem solving abilities.
• Bloomberg Essentials Certification in Fixed Income, FX, Equities and Derivatives.

TECHNICAL SKILLS

Business Intelligence/Tools: OBIEE 11G,10.1.3.x, Siebel Analytics 8.x, 7.x, Informatica Power center 8.1/7.1, OBI DAC 11G

Databases: ORACLE 10g/9i/8i, SQL Server 2005/2000, IBM DB2, MS Access, MYSQL

Languages: C, C++, SQL, Java, PL/SQL, XML, HTML, Perl Scripting and Shell Scripting

Financial Applications: MATLAB Toolboxes, EViews 7, X Trader, CQG, Patsystems

Operating Systems: Windows 95/98/2000/2003/ XP/Vista/7, Unix, Linux

PROFESSIONAL EXPERIENCE

Oracle Business Intelligence Lead Developer

Confidential, PA

Responsibilities:

• Involved in requirements gathering, designing functional and technical specifications to create reports.
• Interacted with Systems Engineering team to design - Facts & Dimensions for Repository.
• Developed physical and logical data models to support the functional reporting needs.
• Coordinated all the team meetings involving the analysis phase discussions with the business users and the development team.
• Extensively worked with OBIEE to build Physical Model, Business Model and presentation layer and established relationships.
• Created and administered the physical layer, Business Model and Mapping Layer and Presentation Layer in an OBIEE Repository using OBIEE Administration tool.
• Included Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges.
• Implemented Level based dimensional hierarchies and also handled ragged hierarchies.
• 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.
• Extensively used page prompts and dashboard prompts.
• Created Agents to generate alerts and delivered it to target users.
• Responsible for the design, set up and maintenance of both Production and Non-Production environments.
• Helped in developing the standards and best practices to ensure data standardization and consistency.
• Performed unit testing and supported end users during various test cycles.
• Worked on the detail documentation for the entire project.

Environment: OBIEE 11.1.X, UNIX, TOAD, Windows XP, Teradata SQL Assistant.

OBIEE Consultant

Confidential, CA

Responsibilities:

• Interacted closely with Business Analyst, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Used Oracle Business Intelligence Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository (.rpd).
• Worked on dimensional hierarchies to enable drill down capabilities.
• Developed trends dashboard to show booking trends like Current Quarter bookings Vs previous year Current Quarter bookings.
• Extensive implementation work on BI Answers to create the reports as per the client requirements. Used session and repository variables to control access and data, filters to restrict data.
• Created multiple aggregated tables and setup aggregate navigation to enhance performance.
• Defined additional views (narrative, pivot, chart views) of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Made use of BI Publisher to re-design report layouts in MS-Word. Created Data Model, Parameters and LOV in the templates. Uploaded and used templates on dashboard reports.
• Performed OBIEE performance tuning like use index hints to tune the SQL statements.
• Managed iBOTS and Delivers to issue Alerts on Dashboards and sent reports via emails based on a schedule, at designated intervals.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
• Worked on Informatica Source Analyzer, Warehouse Designer, Transformations Developer, Mapplet Designer and Mapping Designer.
• Worked on the existing repositories in sales analytics module to customize them according to the business requirements.
• Monitored over all OBIEE usage on server and resolved issues for better performance.
• Worked on presentation server and repository server configuration changes. Also, worked on server space management issues for cache files, back up files.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, PL/SQL, UNIX, ER-win 4, Informatica 8.1

Sr. OBIEE developer

Confidential, CT

Responsibilities:

• Involved in the full life cycle implementation of Invoices Tracking Analytics Application used by Accounting Team to monitor the invoices made to Point-of-Sale (POS) customers, Commercial / Business customers and third-parties.
• Interacted with Billing and Account Receivables Subject Matter Experts (SME), Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Participated in the installation and configuration of Oracle BI EE 10.x in the windows as well as the Linux environment.
• Attended meetings with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Created Dashboards / Reports using different Views (Pivot Table, Chart and Column Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Used Oracle Essbase to generate summary reports for faster analysis by the end users.
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes.
• Worked on Reconciliation Process Oracle BI Reports output with Excel Reports.

Environment: OBIEE 10.X, Siebel Analytics 7.x, Oracle 10g/9i,Toad,Putty,Linux.

DW/BI Consultant

Confidential

Responsibilities:

• Used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository (.rpd).
• Configured and customizing Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Worked Extensively on Siebel Answers to create the reports as per the client.
• Set up Filters and provided Prompts appropriately to avoid excessive data showing up Reports.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Extracted data from sources Like Flat Files, SQL Server and Oracle.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Modified mappings as per the changed business requirements.
• Worked on Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers

Environment: Informatica 7.1, Oracle, Microsoft Access, Siebel Analytics/Oracle Business Intelligence 7.8.4, Oracle 9i, PL/SQL, XML, UNIX, ER-win 4.0, Windows XP

Oracle Developer

Confidential

Responsibilities:

• Responsible for detailed technical design of multiple components for MSA environment.
• Participated in Requirement Traceability Matrix creation and discussions.
• Developed components using PL/SQL and UNIX shell scripts.
• Created multiple stored procedures and packages for the same.
• Understood the business requirements with extensive interaction with Business analysts and reporting teams, and assisted in developing the low level design documents.
• Designed multiple reports using SQL*PLUS and Pl/SQL. Also used Developer 2000 (Forms/Reports 6i) for creation of several reports and layouts.
• Extensive use of EXPLAIN plan and hints in queries to tune the application for running in MSA environment.
• Worked on deployment plans and release notes with details for each component designed.
• Attended RCA and status meetings.
• Performed status reporting and tracking of assigned components.
• Worked with Rational Clearquest and CVS for version control and tracking.

Environment: Oracle 9i, Perl, PL/SQL, UNIX, SQL Developer 2000

Oracle Developer /Trainee

Confidential

Responsibilities:

• Designed and developed database objects.
• Worked on overall application maintenance and database administration.
• Created stored procedures, functions, triggers for all the modules.
• Wrote documents for all the database modules.

Environment: Oracle 8i/9i, Visual Basic 6.0, Windows XP