Summary:

• Profound knowledge in Transactional Systems and Enterprise Resource Planning systems
• Hands on Implementation Experience of 3 years in Oracle Business Intelligence Applications OBIA customizing pre-packaged OBIEE, Informatica, DAC metadata solutions in HR, SCM, Manufacturing, Financial Analytics
• Experience of more than 6 years Incorporating SDLC and standard OLAP methodologies for Designing and Developing end-to-end BI solutions using Oracle Business Intelligence OBIEE ,Informatica power center
• 8 years of IT experience in Business Requirements Gathering, System Analysis Design, Data Modeling, Development, Testing and Implementation of Business Analytic Data warehouses
• Management experience guiding onshore and offshore teams for the client deliverables
• Expertise in developing Business Analytics Warehouses for various business verticals like Health Care, Telecom, Manufacturing ,Banking with source ERP Systems Oracle EBS,SAP, PeopleSoft and Siebel CRM
• Oracle Certified Associate with SQL and PL/SQL certifications
• Proficiency in design and development of Physical/Business Model and Mapping/Presentation layers in OBI Metadata Repository using Oracle BI Administration Tool
• Expert in Building and configuring Presentation Services like Answers ad-hoc querying, reports , Web Catalog and Interactive Dashboards
• Comprehensive Data Integration experience in ETL using Informatica Power Center - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica/ Repository Server manager
• Expert skills in customizing Pre-built BI apps Informatica workflows Source dependent extract SDE and Source Independent Loads SILOS in accordance with business requirements
• Expert Orchestration skills in Data Warehouse Administration Console DAC to Configure, Monitor ,Schedule ETL
• In-Depth performance analysis skills using Metadata tables of DAC and Informatica repositories
• Experienced in OLAP Data Modeling using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling using Data Modeler Erwin
• Multi-platform experience on Unix/ Linux and Windows Server family

Technical Skills:

Professional Experience:

Confidential

Role: Senior OBIA Consultant

Confidential an independent group company of Confidential, is a global leading provider of diagnostic medical imaging systems and comprehensive medical solutions, such as CT, EP Labs, X-ray, Ultrasound, MRI and information systems

Responsibilities:

• Full life cycle SDLC implementation of Business Analytics Warehouse and Dashboards designed for the subsidiaries customizing pre-built Oracle Business Intelligence Applications which Includes Informatica ,DAC and OBIEE for ETL interfaces, Dashboards and reports mainly focusing on Financial Analytics
• Provided technical support on Oracle Business Intelligence projects and ETL using informatica for data integration purposes of the GAIA project
• Performed Extensive impact analysis of OBIEE and ETLS for the GAIA project which is converted to 11 segments from previous 8 segments of TAMS systems and worked towards the associated customizations
• End to End configuration and Implementation of Informatica and DAC applications.
• Involvement for evaluation, development, testing of the end to end GAIA data warehouse
• Implementation of Data level security in the RPD for supporting end user needs
• Worked on OBIEE administrative tasks like creating MUD environment
• Used Advanced OBIEE techniques like lookups , circular joins for complex requirements building the reports customizing the oracle service analytics
• Developed various ETL design flow charts for end to end visualization for AP , AR subject areas of the impacts caused by oracle EBS R12 segment changes from 8 segments to 11 segments
• Spearheaded the impact analysis of reports caused by changes in descriptive flex fields of source OLTP systems like oracle EBSR12 by analyzing the core warehouse tables eg: W GL ACCOUNT D , W SEGMENT D, W HIERARCHY D
• Constructed the data lineage for enhancing impact analysis capabilities out of the metadata of OBIEE repository
• Used Sparse and dense lookup function in OBIEE for the install base report
• Enabled OBIEE usage tracking at the enterprise level for HR Department
• Implemented OBIA ETL customizations on core fact tables AP , AR and related conformed dimensions both SDE and SILOS mappings

Environment: Oracle BI Applications 7.9.6.3, Informatica 9.1 Power Center , OBIEE 11g, UNIX Shell scripting, Oracle 10g/11g SQL, PL/SQL , DAC scheduler

Confidential

Role: Senior Developer

Confidential auto parts is a service organization engaged in the distribution of automotive replacement parts, industrial replacement parts, office products and electrical/electronic materials. We are geographically located across the Confidential with over 2000 operations in network

Responsibilities:

• Full life cycle SDLC implementation of Business Analytics Warehouse and Dashboards designed for the subsidiaries customizing pre-built Oracle Business Intelligence Applications which Includes Informatica ,DAC and OBIEE for ETL interfaces, Dashboards and reports
• Complete design of the Dashboards , Reports , drilldowns , formatting for the SPR subsidiary
• End to End RPD design of the Business Model Layer , Presentation and Physical layers for user needs
• Enhanced RPD with various complex calculations , Dimensional Hierarchies and new Facts
• Implemented Income statement report for comparing actuals , budgets for EIS subsidiary
• Worked on OBIEE administrative tasks like creating MUD environment , upgrading the OBIEE 11.1.1.5 to 11.1.1.7 in LINUX, Applying Patches for fixing bugs , Deployment of RPD s
• Implemented user impersonation for testing the user security issues
• Performed migration/merging of RPD's and catalog objects in sync with their security within Environments
• Implemented usage tracking and impact tools for data lineage
• Implemented data-level , object level , user level security for SPR users
• LDAP server host configuration in weblogic administration console for syncing LDAP groups to the application roles
• Creation of Application roles , application policies in enterprise manager to map to the LDAP groups
• Created MUD Multiple user Development environment by utilizing projects in OBIEE.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Designed Schema/Diagrams using Fact, Dimensions, and Physical, Alias and Logical tables.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Created Custom Mappings in Informatica to Load the security data like users and roles from People soft
• Built DAC execution plans , subject areas for the loading custom security tables
• Worked using Catalog manager to migrate web catalog between different instances.
• Created Pivot Tables and manipulated Initialization Blocks for report analysis.
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables. Profitability
• Created AD hoc reports in AP, AR , GL , Profitability Dashboards
• Tuned the Performance of the OBIEE reports by methods like aggregate tables , materialized views, indexes
• Break fixing of various adhoc user requests in live production reports

Environment: Oracle BI Applications 7.9.6.3, Informatica 9.1 Power Center , OBIEE 11g, UNIX Shell scripting, Oracle 10g/11g SQL, PL/SQL , DAC scheduler

Confidential

Role: Solution Development Senior Analyst OBIA

Confidential is a non-profit company that operates a network of hospitals and related health facilities in the Confidential. It is the nation's largest Catholic and largest non-profit health system.

Responsibilities:

• Full life cycle SDLC implementation of Business Analytics Warehouse and Dashboards designed for the Systems Across health Ministries and MIC applications customizing pre-built Oracle Business Intelligence Applications which includes Informatica ,DAC and OBIEE for ETL interfaces, Dashboards and reports
• Worked on MIC application architecture for requirements gathering, GAP analysis, TDD s towards the planned Business Analytics data warehouse for HR , SCM and Finance, Manufacturing Analytics using Pre-built OBIA
• Customization of the Oracle Out of The Box ETL interfaces using Informatica for Extracting various data from OLTP systems like People Soft ,Siebel, Oracle EBS
• Customized various Source Qualifier Queries to meet the business functionality of the OLTP incoming data
• Coordinated offshore and onshore teams and owned the ETL interfaces related to Supply chain and Human Resources
• Involved in Design and build for ETL deliverables for customizing SDE and SILOS mappings
• ETL enhancements for analytics like supply chain, HR from OBIEE report perspective
• Implemented Change data capture and incremental logics in inventory ETL Interfaces by identifying the audit columns for the data coming From People soft Purchasing and Supply chain modules
• Implementation of SCD type1/type2/type3 in existing ETL interfaces for capturing slowly changing dimensions
• Configured the Domain Value Lookup files for ETL interfaces related to HR analytics
• Production Support Service requests , Bug fixes like duplicate data issues and data mismatches and Enhancements related to the ETLS involved in HR,SCM subject areas using SQL query based Logics
• Complete configuration of DAC for all the Subject areas to Orchestrate the Full loads and incremental loads together with the DAC parameters and variables at runtime
• ETL Interface development for masking incoming files to Enterprise Data Warehouse and various other Interfaces like HYPERION , CROWE
• Handled repository level migrations for UAT and Train environments and administrating ETL migrations from Development to QA
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, and lookup, Sequence Generator, Router, Sorter and Stored Procedures, SQL transformation Java Transformations. And used debugger to test the mappings and fixed the bugs
• Extensive analysis using Queries on OPB Metadata tables and REP views from metadata repository in Informatica to improve performance
• Customization of Oracle pre-built Metadata .rpd to built Dashboards/Reports in HR and SCM subject areas
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed Dashboards / Reports using views like Pivot Table, Chart, Gauge, Tabular and View Selector, Alerts, Guided Navigation and Interactive Dashboards with drill-down capabilities
• Created Dimensional Hierarchies in the BMM layer for Drill Down capabilities in the front end reports
• Implemented Security Setup at both Object and Data levels and creation of users/groups, LDAP authentication Setup and configuration of Multiuser Development Environment MUDE
• Configured users and security in web logic console of OBIEE 11g
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Worked on materialized views and aggregates for performance of the reports
• Created Dashboard global Prompts and integrated with existing reports and key performance indicators
• Supervised Oracle Business Intelligence Server Application Server , Oracle BI Presentation Server Web Server, BI Access, Web Services
• Proof of concept work on OBIEE 11g Scorecards and Key Performance Indicators

Environment: Oracle BI Applications 7.9.6.2, Informatica 9.1 Power Center , OBIEE 11g/10g, UNIX Shell scripting ,Oracle 10g/11g SQL, PL/SQL , TIDAL Scheduler, DAC scheduler, Erwin data modeler, APEAR tool

Confidential

Role: Senior OBIA consultant

Confidential: Confidential is a global company that processes steel for use in the automotive, construction, hardware, aerospace and many other industries.

Responsibilities:

• Performed GAP analysis on existing systems and gathered requirements from business users
• Customized prebuilt Business Intelligence BI Applications using OBIEE ,Informatica and DAC for the subject areas like Supply Chain Analytics ,Sales Analytics
• Complete configuration of OC4J/web logic servers to accommodate service oriented architecture and OBIEE
• worked with Data models to identify key joins between tables to built complex joins in BI repository
• Report calculations in OBIEE admin tool by modifying repository objects .rpd in physical/BMM/presentation layers
• Created Dimensional Hierarchy, logical columns, aggregate columns, level based measures in BMM layer
• Built various views in front end OBIEE answers like charts, gauge views, Pivot tables
• Configured Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, Charts, tabular using global and local Filters, and Page/Dashboard Prompts.
• Configured repository and session variables to get dynamic reports and dashboards.
• Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers.
• Worked on Security settings in Oracle BI Admin Tool to set up users, groups, access privileges and query privileges.
• Enabled the BI scheduler for i-bot alerts for end users to track the key information on daily basis
• Cache implementation for Reports performance and execution of materialized views /table partitions
• Configuration of LDAP authentication and authorizing privileges for Multiuser Development Environment MUDE .
• Development of Mappings/Mapplets using various Transformations, creating and monitoring Sessions/Workflows.
• Extensively used the Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Coordinated with testing teams to resolve issues found during the DEV,QA, UAT phases.
• Peer evaluation of code, testing, monitoring NQSQuery and tuning reports.

Environment: OBIEE 10.1.3.4.1, Oracle 10GR2, Informatica 8.1, DAC 7.8.5, OBI Apps 7.9.4, UNIX, Linux, Oracle 10g/11g SQL, PL/SQL

Confidential

Role: Sr. ETL/OBIEE Consultant

Confidential caters to hundreds of members in the Confidential District, and tens of thousands of buyers worldwide, providing them with a centralized place to conduct business to business transactions.

Responsibilities:

• Full life cycle implementation of the Data warehouse for the fashion company OLTP systems
• Sourced the B2B transactional data to the warehouse for analytical purposes
• Preparation of Technical design documents and data analysis documents for source OLTP
• Collaboration of complete ETL end to end design , build and deliverables for the business analytic warehouse
• Implementation of SCD Type1/Type2/Type3 in the ETL build for Business analytics warehouse
• Extensively worked on OBIEE administration tool for customizing physical /BMM/presentation layers
• Customized security settings for privileged users, groups and classify based on roles in the BI administration tool
• Administered Web Catalog Objects pages/folders for the users
• Migrated existing legacy reports and edit into the OBIEE dashboards
• Configured repository and session variables to produce dynamic reports and Dashboards
• Used HTTP transformation and web methods to import data from the Fashion website data for records to improvise the Pictures in website
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the mapping Designer to map sources to the target
• Used Informatica Designer to create complex mappings using different transformations like filter, Router, Aggregator, Lookup, Sorter, Update strategy, Expression to pipeline data to Data Warehouse
• Debugging code, testing and validated data after processes are run in development/testing according to business rules
• Prepared unit test plans and maintained defect logs to resolve issues

Environment: Informatica 8.1.1, DAC 7.9.5, Linux, OBIEE 10.1.3.4.1, Oracle 10g/11g SQL, PL/SQL

Confidential

Role: Siebel Analytics/ETL developer

Responsibilities:

• Shaped and administered the Physical Layer, BMM layer, Presentation Layer in a Siebel Analytics repository
• Developed physical layer connection pools with authorizations and imported necessary tables with joins
• Developed Reports with pivot, charts, gauge views applying local and global filters
• Implementation of Interactive delivers/ibots to alert business end users about changes
• Rpd Development using Siebel Analytics Server Administration Tool in accordance with the requirements
• Configured security through Siebel Intelligence Dashboards for users for subject areas
• Created groups in the repository , added users to the groups and granted privileges explicitly and through group Inheritance
• Worked on Siebel answers to create reports for the Business users
• Created Dashboards for OLTP systems using Siebel Intelligence Dashboards
• Worked on Subscribed user groups privileges for ibot alerts
• Creation of groups and adding users to the group in repository with inheritance features
• Implemented new star schemas and modified existing ones in related subject areas
• End user and Pilot user training for customizing ad-hoc reports using Siebel answers
• Upgrade work related to Existing Legacy system in Siebel analytics to OBIEE 10g
• ETL interface builds in Informatica power center custom source qualifiers SQL to load data into data warehouse
• Worked comprehensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizer transformations.
• PLP ETL development using PL/SQL stored procedures ,packages and functions

Environment: Informatica Power Center 8.1.1, Oracle 9i, Siebel Analytics 7.8.4, XML, Flat Files, SQL, PL/SQL, Windows NT.