SUMMARY:

• 8 years of IT experience in Business Requirements Gathering, System Analysis & Design, Data Modeling, Development, Testing and Implementation of Business Analytic Data warehouses
• 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
• 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
• Management experience guiding onshore and offshore teams for teh 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 s
• 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)
• Profound knowledge in Transactional Systems and Enterprise Resource Planning systems
• Multi-platform experience on Unix/ Linux and Windows Server family

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10.1x,OBIEE 11.1x, Siebel Analytics 7.x, BI Publisher

ETL Tools/Schedulers: Informatica Power Center 9.x/8.x/7.x,Erwin, DAC, Tidal Scheduler

Databases: Oracle 9i/10g/11g,SQL Server, Teradata, Bigdata

Languages: SQL,PL/SQL,Core Java

Packages: OBIA 7.9.x, Oracle EBS R12, PeopleSoft

Environment: Windows, UNIX, SQL Developer, TOAD, Java Net Beans IDE

Application Servers: Weblogic 9/10/11.x

Technologies: JAVA Scripts, XML, PHP, HTML, CSS, AJAX,SOA,BPEL

Process: SDLC, Agile, ITIL, Project Management

PROFESSIONAL EXPERIENCE:

Confidential, Tustin CA

Senior OBIA Consultant

Responsibilities:

• Full life cycle (SDLC)implementation of Business Analytics Warehouse and Dashboards designed for teh 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 teh GAIA project
• Performed Extensive impact analysis of OBIEE and ETLS for teh GAIA project which is converted to 11 segments from previous 8 segments of TAMS systems and worked towards teh associated customizations
• End to End configuration and Implementation of Informatica and DAC applications.
• Involvement for evaluation, development, testing of teh end to end GAIA data warehouse
• Implementation of Data level security in teh 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 teh reports customizing teh oracle service analytics
• Developed various ETL design flow charts for end to end visualization for AP, AR subject areas of teh impacts caused by oracle EBS R12 segment changes from 8 segments to 11 segments
• Spearheaded teh impact analysis of reports caused by changes in descriptive flex fields of source OLTP systems like oracle EBSR12 by analyzing teh core warehouse tables eg: W GL ACCOUNT D, W SEGMENT D, W HIERARCHY D
• Constructed teh data lineage for enhancing impact analysis capabilities out of teh metadata of OBIEE repository
• Used Sparse and dense lookup function in OBIEE for teh install base report
• Enabled OBIEE usage tracking at teh enterprise level for HR Department
• Implemented OBIA ETL customizations on core fact tables AP, AR and related conformed dimensions both SDE and SILOS mappings
• Conducted extensive end to end testing to track teh consistencies between old legacy systems and new systems using various SQL test case scenarios
• Lead teh upgrade efforts for OBIEE from 11.1.1.5 to 11.1.1.7
• Performed teh Map integration in teh OBIEE 11.1.1.7 for State Level and Zip code level

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, Atlanta GA

Senior Developer

Responsibilities:

• Full life cycle (SDLC)implementation of Business Analytics Warehouse and Dashboards designed for teh subsidiaries customizing pre-built Oracle Business Intelligence Applications which Includes Informatica, DAC and OBIEE for ETL interfaces, Dashboards and reports
• Complete design of teh Dashboards, Reports, drilldowns, formatting for teh SPR subsidiary
• End to End RPD design of teh 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 teh 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 teh 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 teh application roles
• Creation of Application roles, application policies in enterprise manager to map to teh LDAP groups
• Created MUD (Multiple user Development) environment by utilizing projects in OBIEE.
• Gathered teh requirement, completed teh proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed teh setting up, Installation and configuration of teh complete Analytics platform environment and teh required connectivity for seamless integration with teh 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 teh security data like users and roles from People soft
• Built DAC execution plans, subject areas for teh 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 teh Performance of teh 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, St. Louis MO

Solution Development Senior Analyst (OBIA)

Responsibilities:

• Full life cycle (SDLC)implementation of Business Analytics Warehouse and Dashboards designed for teh 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 teh planned Business Analytics data warehouse for HR, SCM and Finance, Manufacturing Analytics using Pre-built OBIA
• Customization of teh Oracle Out of Teh 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 teh business functionality of teh OLTP incoming data
• Coordinated offshore and onshore teams and owned teh 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 teh audit columns for teh 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 teh 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 teh ETLS involved in HR,SCM subject areas using SQL query based Logics
• Complete configuration of DAC for all teh Subject areas to Orchestrate teh Full loads and incremental loads together with teh 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 teh mappings and fixed teh 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 teh BMM layer for Drill Down capabilities in teh front end reports
• Implemented Security Setup at both Object and Data levels and creation of users/groups, LDAP autantication 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 teh 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, Columbus OH

Senior OBIA consultant

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 teh 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 teh BI scheduler for me-bot alerts for end users to track teh key information on daily basis
• Cache implementation for Reports performance and execution of materialized views /table partitions
• Configuration of LDAP autantication and authorizing privileges for Multiuser Development Environment (MUDE).
• Development of Mappings/Mapplets using various Transformations, creating and monitoring Sessions/Workflows.
• Extensively used teh Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Coordinated with testing teams to resolve issues found during teh 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, Los Angeles CA

Sr. ETL/OBIEE Consultant

Responsibilities:

• Full life cycle implementation of teh Data warehouse for teh fashion company OLTP systems
• Sourced teh B2B transactional data to teh 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 teh business analytic warehouse
• Implementation of SCD (Type1/Type2/Type3) in teh 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 teh BI administration tool
• Administered Web Catalog Objects (pages/folders) for teh users
• Migrated existing legacy reports and edit into teh OBIEE dashboards
• Configured repository and session variables to produce dynamic reports and Dashboards
• Used HTTP transformation and web methods to import data from teh Fashion website data for records to improvise teh Pictures in website
• Used Source Analyzer and Warehouse designer to import teh source and target database schemas, and teh mapping Designer to map sources to teh 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, Kansas City

Siebel Analytics/ETL developer

Responsibilities:

• Shaped and administered teh 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 teh requirements
• Configured security through Siebel Intelligence Dashboards for users for subject areas
• Created groups in teh repository, added users to teh groups and granted privileges explicitly and through group Inheritance
• Worked on Siebel answers to create reports for teh 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 teh group in repository with inheritance features
• Implemented new star schemas and modified existing ones in related subject areas
• End user and Pilot user 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.