SATYA

-------------------------------------------------------------------------------------------------------------------------

SUMMARY

• Around 8 years of experience in IT industry involving requirement analysis, design, development and implementation, reporting tools, RDBMS and Client Server applications under different environments
• In which seven years of experience in OBIEE 11.1.1.7/11.1.1.6/10.1.3.4, Oracle BI Analytics 11g, Oracle BI Applications 7.9.4, Siebel Analytics 7.7,7.8.5 which include building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots ETL-Informatica and OWB, Reporting-Siebel Analytics, Scheduling- DAC
• Experience in Oracle Business Intelligence e-business suite with Siebel as source system
• 4 years of Data warehouse and ETL design, build, and test experience
• Implemented BI solutions for Elsevier, Citco Fund services, CSC, US Foods, New Breed Logistics, Public Service of New Mexico, QUALCOMM, State farm and other sectors for their various business processes i.e. Financial, Medicare, Marketing, Sales, Services and Customer Care, Energy etc
• Responsibility includes gathering business requirements, analysis, design, data modeling, development, Client Interaction, and Compiling Specifications from client, Modification and Testing along with Agile Methodologies
• Experience with repository development, configured metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports, Alerts, Briefing Books . Added Metadata changes to the OBI/Siebel Analytics .rpd
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL's and reports that are generated from Informatica and OBI/Siebel Analytics
• Hands on experience in ETL process using Oracle Warehouse Builder and Informatica Power Center for various transactions and loading data from disparate data sources
• Expertise in data warehouse concepts and data models included physical, logical and conceptual to implement data marts and ODS
• Extracted data from various source systems like SIEBEL CRM, Oracle EBS ,PeopleSoft, Global, Seed and Aexeo Client Databases
• Worked on Siebel Analytics features i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUDE, Variables/Initialization Blocks configuration etc.
• Extensive experience in Oracle 8i/9i/10g SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL
• Experience in writing UNIX shell scripts, SQL Loader, Performance Tuning of Database
• Excellent problem solving skills with strong technical background and good inter-personal skills.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure

TECHNICAL SKILLS:

• Reporting/Data warehouse Tools Oracle's Siebel Analytics 11g, 10.1.3.2/7.7.1/7.5,OWB10gR1 2
• Informatica Power Center/Power Mart 9.0.1, 6.2/7.x, 8.1, SQL Loader
• Business Intelligence OBIEE 11.1.1.5, OBIEE 10.1.3.4, Siebel Analytics 7.5, 7.8
• Oracle Applications Oracle Financials E-Business suite R12/11i
• Relational Databases Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS Access
• Database Languages SQL, SQL Plus, PL/SQL, UNIX shell scripts
• Web Technologies JSP, JDBC, Java Script.
• Programming Languages C, C , Java, VB 6.0, PL/SQL
• Operating Systems Windows XP/2000/NT, UNIX, Linux
• Scheduling Tools DAC Data warehouse Access Control
• Data Modeling Tools Erwin, Power Designer, ODI

PROFESSIONAL EXPERIENCE

Confidential

Senior OBIEE CONSULTANT

• Worked on OBIEE 10/11g version upgrades and modifying the reports for different teams: Clinical Key Reporting, Info button and CK Analytics, Audit Reporting
• Upgrades to OBIEE 11.1.1.6.12 to 11.1.1.7.14 in all Environments.
• Updated Logo/ Styles as per the new Clinical Services Business Intelligence name change from Shared Services Business Intelligence in the all the Environments.
• Also developed OBIEE metadata repository using Admin Tool from physical layer to presentation along with setting up the security for the specific users of this Project.
• Worked on OBIEE 11g for creating the repository and generating reports for entire Retired Expert Consult Team, which supports Inkling Vendor.
• Worked on Loading REX Source files into Amazon Web Services using Public/Private Key Authentication.
• Migration of RPD, Web catalog from different environments using Clear Case.
• Supported their Security Implementation based on External Table Authentication for their Account based Users.
• Created, customized the mappings using different transformations in Informatica Power Center and ran Sessions Workflows using Informatica Workflow manager to load the data into the Data warehouse.
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Worked with business users to gather business requirements and provided reports in Financial, Supply Chain modules.
• Configuration of Financial Analytics in OBIEE 11.1.1.5.0, DAC, BI Apps 7.9.6.3 and Informatica 9.0.1
• Coordinated all along the Project Working with DBA's, Java Developers, QA and the entire team throughout the project's JAD Sessions and sort out some developmental and administrative tasks.
• Created Time Period based Reports like Chapter, Ancillary, Bundle History, along with the new functionalities of OBIEE 11g by mockups using MS Visio, as well as features of MS Office.
• Monitored both Incremental and Full load of DAC and Informatica Workflow Monitor.
• Created AD hoc reports in Account Payables, GL and receivables and developed Dashboard pages like Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard, Trail balance, Monthly and Quarterly Balance Sheet
• Worked on Dashboard pages like Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard along with Dashboard pages like Overview, Payments Due, Effectiveness and All AP Transactions in Payables Dashboard.
• Designed and developed custom Dashboards and also designed and developed Customer Interface, Auto Lockbox Interface.
• Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG's.

Environment: OBIEE11.1.1.5/10g, Linux, PL/SQL Developer, Windows Vista, Informatica, HPQC, Putty, AWS, clear case, FileZilla, Oracle Applications R12- General Ledger, Account Payables, Accounts Receivable, Inventory, OBIEE 11.1.1.3.0/11.1.1.5.0, OBIA/BI APPS 7.9.6.3, DAC 10.1.3.4.1, Informatica Power center 9.0.1,WebLogic 10.3.5.0, HPQC.

Confidential

Senior OBIEE CONSULTANT

• Worked on OBIEE 10.1.3.4.1 version for creating the repository and generating reports for different Aexeo Development Warehouse and Risk Development Warehouse.
• Also developed and fine tuned OBIEE metadata repository using Admin Tool.
• Worked on the Baskets Functionality for Equities, options related Instruments at Client Vendor Broker and Fund Levels as per time series related report dates.
• Installations included Oracle Client, Oracle BI Enterprise Suite 10.3.4.1 on Windows Vista.
• Worked on Limits Functionality which would help users to see the trends for different Entities and their Gross Exposures, Soft Limit Values and Hard Limit Values along with references amounts and Result sets.
• Worked on end to end Developemnt in RPD with Dimensional Hierarchies for Publishers, Instruments and other attributes, Variables both session and repository and also Logical Table Sources from different facts.
• Worked on Portfolio and Accounting Subject Area, Created users and Groups Risk and managed security at both RPD and Presentation Server Level.
• Used Partitioning and Fragmentation to model Fact based Partition and also used Expression Builder and Calculation Wizard to create calculation Measures like Positions related, Trading Related and Fund level Measures.
• Renamed and remapped tables/Views depending on the user for better performances in RPD.
• Designed and developed single Prompt set dashboard Pages including all the formatting and report changes as per the standards.
• Debugged issues for different business users from front to back end to identify both data and design related.
• Created Metadata dictionaries to support Users for Business needs related to Front, Middle Back Offices.
• Performed Design feasibilities to use variables and Oracle Functions in Write back Functionality to enable users to populate filter criteria by insert, update and delete Global Temp tables.
• Worked on session variables to populate the connections scripts to execute the queries depending on changes
• Participated in all Business User Meetings to discuss the requirements and design the data warehouse objects to further accomplish BI Solutions focused on Oracle BI Suite.
• Assisted in Migrating Reports and RPD From Local to Development Box and then to QA.

Environment: OBIEE10g, Oracle11g with RAC, Linux, PL/SQL Developer, Windows Vista, ODI11g, Aexeo Client Db, Jira

Confidential

Senior OBIEE CONSULTANT w/ BI Publisher

• Worked on OBIEE 11.1.1.5 version for creating BI Publisher Reports for Fiscal Year 2014 under the Program End-Stage Renal Disease ESRD .
• Worked on the Performance Score Summary and Performance Score Certification Reports for CMS in English and Spanish Languages.
• Installing Oracle BI Publisher Template Builder for Word and configuring the data model with multiple data sets along with the parameters settings for each report.
• Created Data models for the reports including the RTF Templates, defining table styles, Paragraph styles and defining Header and Footers.
• Also Adding Translations to the style templates to support Spanish translated RTF, which involved XLIFF .xlf files for Style Templates.
• Worked with Inserting Data fields, charts and performed calculations on fields within the template along with conditional formatting.
• Worked in both connected and disconnected modes.
• Loading Data from the sample XML files and also uploading the Layout template file to the BI Publisher Catalog.
• Used Field Browser to edit, review and update to refresh the form fields added or modified.
• Configured Report General Properties including Caching, formatting, Font mapping and Currency Formats.

Environment: OBIEE 11g., Oracle 10g, PL/SQL Developer, Windows Vista, MS Word 2007, JDK 1.5,Oracle Application Server 10.1.3.1, Explorer 7.0

Confidential

Senior OBIEE CONSULTANT

• Worked on OBIEE 10.1.3.4.1 version for Merlin Reporting to Executives, Regional and Divisional Presidents for the Company and BI Analytics 11g for Cash GP
• Worked on three different projects involving different teams and different areas of company's rebranding and data from different sources
• Created Dashboards, reports, offline Briefing Books and Scheduled ibots in Delivers for Executive Summary Reporting
• Worked with the feasibilities and different approaches related to GO URL's, Guided Navigations, Aggregate Tables, Bins and Evaluate Functions based on different Time Frames
• Involved in Repository Configuration, Troubleshooting and Migrations to from all the environments LOCAL to DEV to QA to PROD and all three layers of RPD.
• Have done Business requirement gathering, understanding business objectives and analysis between Functionalities and feasibilities with the tool
• Involved in One on One meeting with SME to understand the business scenario and process flow.
• Used Filters Global and provided customized prompts to avoid excessive data showing up in the reports
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE answers to build the query
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Server Administration Tool by considering the Standards of the company
• Designed the Star Schema for all the different subject areas and build hierarchies, level-based measures, Aggregate level, Alias tables, Implicit Facts
• Used constrained filters, column filter prompts and various views such as Table View, Pivot tables, View Selector, Column selector, Chart, Narrative view
• Worked on Aggregate Tables created for different subject Areas of Pyramid Segmentation and Corp Regional Reporting Executive Summary
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository and TIMESTAMP Functions in the Answers
• Created Report Mockups to better demonstrate the features of reporting using MS Visio and MS Office to the business users.
• Worked on data from different sources and data at different levels of granularity to build the required functionality
• Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
• Shared Knowledge in ETL processes using Informatica Power Center, PL/SQL for various transactions and loading data from various legacy data sources
• Configuring the Informatica Mappings and DAC accordingly for controlling the data set for the out-of -the box reports
• Worked with Other Teams of Reporting, Data warehouse Developers and DBA's along with the Business Analysts and BRM's for requirement Gatherings, JAD Sessions and Feasibilities, Standards and Troubleshooting with the Issues along with QA Teams in Agile Methodology using HP Quality Center.

Environment: OBIEE 10.1.3.4., Oracle BI Analytics 11g,Oracle 10g/11g, TOAD,HPQC SQL Developer, Windows XP, Linux.

Confidential

Senior OBIEE CONSULTANT

Responsibilities

• Installed and configured complete suite of OBIEE 10.1.3.4 on both Windows DEV and Linux QA and PROD environments.
• Designed the star schema in the data model Physical, Business and Presentation in the repository for Lost and Stolen Project in OLTP System by setting the Staging Tables for Reporting.
• Worked on RPD for the VZW as per the requirement changes and also with BI Answers for Reporting and Dashboards.
• Created, Copied and Moved Dashboards along with the Pages, Reports, Filters, Prompts using Catalog Manager.
• Created reports using the Pivot Tables, View Selectors, Column selectors, Guided Navigations, In-place drills in the reports, Embedding HTML links in the report columns for Dashboards.
• Worked in Creating Variables, global filters, charts, tables, global prompts. Created glossaries as a book-mark link in the reports along with combined similar requests.
• Also worked on color gauge reports on a different dashboard that helped the users to easily analyze the reports.
• Created, Edited and Scheduled BI Publisher reports as required for the Lost/Stolen Project as well as for VZW.
• Created the hierarchies, drills and level-based measures on different dimensions in the repository.
• Worked efficiently in creating the session variables and also the assigning the security groups and users. Also, worked on the data-level security to restrict the data to certain groups of users.
• Worked closely in migrating the Security Groups, Id's, Users at the time of migration along with catalog.
• Also applied the different OBI Patches both on the Windows and Linux boxes.
• Involved in migrations of the development from DEV to QA and finally to PROD environments on both Windows and Linux boxes using the version control tool called SVN.
• Worked on performance tuning on dashboard and BI Publisher reports working closely with the database developers on indexes and tuning the data in the tables with the appropriate facts and dimension measure in the tables along with the Java Bean Based Data Extraction and validations.
• Performed Unit and Regression testing on all the reports developed to maintain consistency and efficiency to meet the user's requirement.
• Involved in all the meetings and worked closely with the business analysts from both the client and end client Verizon .
• Documented all the Technical Specification Documents for VZW and Lost /Stolen Projects as well as worked with analysts for the Functional Design Documentations as well.
• Used TOAD and SQL Navigator for the database queries to resolve any data issues along with the data model changes.
• Efficiently co-ordinate with the offshore team in taking the requirements between the client and team efficiently and meeting the deadlines and the deliverables on time.

Environment: OBIEE 10.1.3.4. Oracle BI Publisher, Oracle 10g, TOAD, HPQC, SQL Navigator, Windows XP, Linux.

Confidential

OBIEE Developer

Responsibilities

• Installed and configured OBIEE on Linux and Windows
• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Added Aggregate measures using Aggregate Persistence Wizard
• Enabled Usage Tracking Table and Dashboards
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and ToDate functions
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Siebel Application level
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
• Creating new measures as well as modifying the existing measures at RPD levels
• Involved in creating dimensional hierarchies to support drill downs
• Designed and Implemented the Pre Staging and Staging approach, for cleansing using Informatica ETL and Oracle Warehouse Builder 11g
• Design and developed process for Initial loads and Ongoing loads Incremental Aggregation with Extract Date concept
• Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Oracle warehouse Builder

Environment: Oracle Business Intelligence 10.1.3.4, Oracle 10g, Oracle Warehouse Builder 10g R2, Informatica Power center 8.1, Microsoft Windows Server 2003, SQL, PL/SQL, Linux, UNIX

Confidential

OBIEE Developer

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
• Involved in preparation of technical documents and end user training
• Interacted with Billing and Account Receivables Subject Matter Experts SME , Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements
• Experience in configuring the metadata in all the three layers physical, semantic and presentation layers
• Participated in the installation and configuration of Oracle BI EE 10.x in the windows as well as the Linux environment
• 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 in the repository
• Developed 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
• Created dimension hierarchies aggregates and logical sources in the BMM layer
• Configured the security settings in Siebel Analytics Admin tool to setup users Groups and Access privileges
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Involved in Reconciliation Process Oracle BI Reports output with Excel Reports
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters for performing the customer insights / trends using Siebel Analytics Web
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process using Informatica and integrate to Oracle Warehouse Builder 10g R2 for reporting

Environment: Oracle Business Intelligence OBI EE 10.2, Oracle 9i, Oracle Warehouse Builder 10g R2, Toad, Teradata, Putty, Linux.

Confidential

OBIEE Developer

Responsibilities

• Coordinated in the client installations of Oracle BI
• Install, configure, and administer the OBIEE platform
• Upgraded the existing Siebel Analytics Application on 7.8.4 to Oracle Business Intelligence 10.1.3.2.1
• Added Aggregate measures using Aggregate Persistence Wizard
• Designed Intelligence Dashboards and created Global Filters
• Used Preferred Drilldown to provide seamless navigation capability to business users
• Customized the logical tables and columns, defined the Analytics dimensions, aggregations and levels
• Worked closely with Business Analyst, discussed and gathered the Analytics requirements and created the Business Model using Star schemas
• Expertise in RPD Development, Oracle Answers, Oracle Delivers, ETL Configuration, and BI Publisher
• Used Oracle Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository .rpd
• Managed security privileges for each subject area and dashboards according to user requirements and also LDAP Security
• Worked Extensively on Oracle Answers, Dashboards, to create the reports as per the client requirements
• Built and Deployed Oracle Portal. Managed it through Role based Interface
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers
• Involved in unit, integration testing and User Training of the generated reports using Siebel Analytics
• Worked in ETL process using Informatica for various transactions and loading data from Flat Files and Relational Database
• Assisted in creating, Reusable and Non-Reusable Mappings and Mapplets using Filters, Aggregator, Lookups, Expression Aggregator, Sequence generator, sorter, Joiner and Update Strategy Transformation

Environment: Oracle Business Intelligence suite 10.1.3.2.1,Oracle 9i/10g, Toad, Windows Adv Server 2003, SQL, PL/SQL, Oracle Warehouse Builder 10g R1, Informatica Power Center 8.1.1/ 7.1.4, MS Visio 2007 professional