Sr. Bi Apps Developer Resume
Springfield, MA
SUMMARY
- Eight plus years of total IT experience across Data warehouse development providing business intelligence solutions using OBIEE (Siebel Analytics) reporting tools.
- Excellent noledge of Data Warehousing and Business Intelligence concepts and involved in different phases of Software Development Life Cycle in Data Warehousing.
- Hands - on experience in installation and configuration of OBIEE.
- Solid understanding of Oracle Business Intelligence Enterprise Edition (OBIEE 11.1.1.x), its architecture, components (OBI Server, Oracle BI Presentation Services, Web cat file, config files and other tools and utilities), and Informatica 9.x/8.x/7.x/6.x.
- Hands-on experience in building teh OBIEE Repository (.rpd) file, Interactive Dashboards/Answers, Security Setup and scheduling iBots using Oracle BI delivers.
- Excellent experience in creating pixel-perfect BI reports using Oracle BI Publisher.
- Ability to enhance performance by understanding when & how to leverage aggregate tables, materialized views, table partitions, indexes, and managing cache etc.
- Designed and developed Oracle Stored Procedures and Packages to meet data integration and processing requirements.
- Strong understanding of ETL, OLAP, Star Schema, Business Process Analysis, Dimensional Data Modeling, Physical & Logical Data Modeling.
- Hands-on experience wif prebuiltOracle BI Appsfor HR and Financial modules.
- Highly proficient in Design, Development, Implementation, Administration and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica Power Center 8.x, 7.x, 6.x1, Power mart and Metadata Reporter.
- Experience in extracting data from Oracle EBS, PeopleSoft, Siebel CRM, SAP HR, OLTP, and integration and loading data to OLAP systems.
- Practical, hands-on experience working wif Informatica Data Integration Tools - Repository Manager, Designer, Workflow/Server Manager, and Workflow Monitor.
- Subject Matter Expert in Financials (Account Receivable, Accounts Payable, General Ledger).
- Expertise in writing, testing and implementation of Stored Procedures, Triggers, Functions, Packages and design of star schema at database level using SQL, PL/SQL.
- Experience in using Data Warehouse Administration Console (DAC) to schedule teh Informatica jobs and metadata management.
- Excellent balance between technical and business skills. Able to interact wif users and business owners, while still maintaining a deep technical competency to interact wif technical teams.
- Quick learner and excellent team player, ability to meet deadlines and work under pressure.
- Strong Experience in Data Warehouse Administration Console (DAC).
- Detailed noledge in Data warehouse Application Console (DAC) and Informatica Servers.
- Extensive experience in installation and configuration of BEA WebLogic Server. Experience in troubleshooting teh deployment and other application problems.
- Subject matter expert for OBIEE expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
- Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and demo configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
- Excellent noledge of AOL (Application Object Library) and System Administration Modules.
- Good technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE) components in teh domain of Oracle Applications E-Business Suite.
- Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL*Loader scripts.
TECHNICAL SKILLS
Reporting Tools: OBIEE 11g/10.1.3.x, Siebel Analytics 7.x, BI publisher, Oracle BI Apps 7.9.x
DWH/ETL Tools: Informatica Power Center 9.x/8.x/7.x
RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2003
Languages: SQL, PL/SQL, UNIX Shell Scripting, C, HTML, ASP.Net, C#
Operating Systems: Windows NT Server/2000/2003/XP, RHEL 4.x/5.x
Database Tools: SQL*Loader, SQL*Plus, TOAD 9.x, 8.x
PROFESSIONAL EXPERIENCE
Confidential, Springfield, MA
Sr. BI Apps developer
Responsibilities:
- Working wif teh business teams to implement teh OBIEE and BI publisher reporting.
- Upgraded teh older version of OBIEE(10g) to teh latest(11g).
- Customized Standard 6i reports to XML/BI publisher reports.
- Worked on integrating and configuringBI PublisherwifOBIEE.
- Creating teh Dashboards using guided navigation links, drilldowns and slice & dice features.
- Created MUD (Multiple user Development) environment by utilizing projects in OBIEE.
- Customized OBIEE Styles, Skins and Messages according to teh client requirements
- Designed and developed Oracle Stored Procedures and Packages to meet data integration and processing requirements.
- ETL Design and Development, Data Integration, Data Migration, Data Quality, Data Profiling.
- Designed teh star schema and defined teh subject areas accordingly to teh reporting requirements.
- ManagedSecurity privilegesfor each Subject area and Dashboards according to user requirements.
- Used OBIEE Administration Tool for customizing and modifying teh Physical, Business Model/Mapping and Presentation layers of metadata repository (rpd).
- Designing and developing physical and logical star schema using OBIEE admin tool. Import/create tables and add/change physical joins/keys.
- Gathering requirements from business users and converting them into technical design documents.
- Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns and used DAC TEMPhas deployment tool for ETL.
- Creating global filters, complex queries, prompts reports (charts, tables, graphs) in Answers and also created rpd/report development and worked on OOTB.
- Worked on integrating and configuringBI PublisherwifOBIEE.
- Worked on teh complex BIP reports and Scheduling of BIP reports.
- Worked on Informatica - Source Analyzer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Informatica server to load data from flat files, SQL.
- Customized OOTB Informatica mappings.
- Created new Mappings, Sessions, Workflows in Informatica.
- Created Full and Incremental sessions in Informatica and used Workflow monitor teh workflows.
- Exported and Imported Informatica workflows by using Repository Manager.
- Knowledge on database design -Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of teh DB.
- DevelopedBack Order Detail ReportandSales Tracking Reportin Order Management.
- ConfiguringOBIEE Agentsto deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
- Involved inMigration, UAT, Go-Live, andProduction Support.
- Configured teh NQSCONFIG.INI file for usage tracking wif direct insertion.
- Performed gap analysis and feasibility study for teh given requirement.
- Good noledge working on Linux for maintain and configuring teh OBIEE services.
- Created Execution plans, Subjects Ares in DAC.
- Registered teh Informatica workflows, tables, Indices in DAC.
- Created new task groups in groups to change teh depth of tasks to run.
Environment: Oracle Bi Apps 7.9.6.2, OBIEE 11.1.1.6.4 (Financial Analytics, Supply Chain Analytics, Procurement and Spend Analytics), Informatica 9.0.1, DAC 10.1.3.4.1, Oracle 10g/11g.
Confidential, Chicago, IL
Sr. OBIEE developer
Responsibilities:
- Worked wif functional and technical project leads, finance, and other business groups to identify, analyze, and document Business requirements.
- Configured Metadata and Web Catalog Objects and also created drill-down hierarchies and implemented business logic for facts and dimensions.
- Managed security privileges for users & groups using LDAP & SSO autantication, EBS and Excel-based authorization as well as Dashboard/Report-level security.
- Involved in cache management, performance tuning, data and object security.
- Involved in teh cut-over activities for Rpd and Web-catalog migration.
- Configured OBIEE iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
- Performed end-user training to develop ad-hoc reports using BI Answers.
- Designed and developed a standalone OBIEE solution for Process Manufacturing Inventory Period Balances, Work Order, Cost Analysis and Sub Ledger Accounting modules.
- Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships & Foreign Keys (Physical & Logical) between tables.
- Created groups in teh repository and added users to teh groups and granted security privileges explicitly and through group inheritance.
- Used Calculation Wizard, Time series wizard and Expression Builder to perform logical operations in teh BMM layer.
- Maintained effectiveness in creating teh Dashboards by appropriately including guided navigation links, drilldowns, roll downs and slice & dice features.
- Used teh expression builder utility to create new logical columns in teh BMM layer and created various calculation measures.
- Worked on Informatica - Source Analyzer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Informatica server to load data from flat files, SQL.
- Customized OOTB Informatica mappings.
- Created new Mappings, Sessions, Workflows in Informatica.
- Created Full and Incremental sessions in Informatica and used Workflow monitor teh workflows.
- Exported and Imported Informatica workflows by using Repository Manager.
- Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all teh reports and dashboard prompts, to minimize teh delay in Physical Query Execution.
- Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
- Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
- Developed Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Expressions and Aggregator) for loading teh data into data warehouse.
- Participated in teh entire SDLC starting from Analysis including design, development, testing, implementation and maintenance of teh Gilead reporting application.
- Registered new tasks in DAC and run them through DAC Execution plan.
- Created task actions in DAC for PL/Sql procedures.
- Created new subject Areas, Execution Plans in DAC.
- Registered teh new tables, Indices in DAC.
Environment: OBIEE 10.1.3.4.1 (Financial Analytics, Supply Chain Analytics, Procurement and Spend Analytics, HR Analytics), Oracle Bi Apps 7.9.6, Informatica 8.6.1, DAC 10.1.3.4.1, Oracle 10g/11g, Oracle EBS R12, Oracle SQL Developer 2.1.1.
Confidential, CA
Sr. BIApps developer
Responsibilities:
- Interacted wif end users and developers to validate teh data model, requirement validation of teh reports and drilldowns wif business users
- Developed proof of concept to check teh functional feasibility of teh OBIEE implementation.
- Involved in Installation, configuration and administration of OBIEE server and repository.
- Effectively managed ODBC connections and imported teh Physical tables, keys and physical joins from teh databases.
- Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer, Created session & repository variables using OBI Administration Tool.
- Managed security privileges for users & groups using LDAP & SSO autantication, OS external database autantication/login as well as Dashboard/Report-level security.
- Configured Analytics Metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
- Created new mappings in Informatica and also customized teh existing OOTB mappings and registered them in DAC.
- Utilized Oracle BI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to interactive dashboards for subscribed users.
- Optimized performance using Indexes, Aggregate tables and materialized views.
- Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters and custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards as per requirements.
- Performed end-user training to develop ad-hoc reports using BI Answers.
- Used Data Stage for ETL purpose, for Data Extraction from source tables, Data Mapping and Data Conversion (Transformation) and Data loading into teh HR Data Mart.
- Integrated OBIEE wif EBS for Single Sign On (SSO).
- Worked on integrating and configuring BI Publisher wif OBIEE.
- Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
- Documented teh Requirements and implemented a Design Solution for teh BI Architecture.
- Worked extensively on teh Oracle BI Admin Tool to create teh Physical, Business and Presentation Layers.
- Created hierarchies, complex and foreign joins initialization block, presentation or repository or session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
- Setup Multi User Development Environment (MUDE) in OBIEE.
- Granting access to users and maintain security by using database autantication and authorization.
- Defined teh Dimensional Hierarchy and created teh Dimensional Levels for each of teh dimensions in teh BMM layer for Drilldowns.
- Implemented Type-II Slowly Changing Dimension (SCD) logic in OBIEE environment.
- Implemented Incremental Load mappings for Fact mapping.
- Performed OBIEE Admin works likenew ID creation, Account modification of existing users, Password reset and Deletion of accounts.
Environment: OBIEE 10.1.3.4.1, Oracle 10g, SAP HR, Informatica Power Center 8.1.1, Microsoft SQL Server Management Studio Express 9.0, SQL*Plus, SQL*Loader, Windows NT Server/XP, UNIX.
Confidential, GA
Sr. OBIEE developer
Responsibilities:
- Worked wif Business users to gather Business requirements.
- Developed proof of concept to check teh functional feasibility of teh OBIEE implementation.
- Involved in Installation, configuration and administration of OBIEE server and repository.
- Created multiple connection pools, deployed opaque views and called stored procedures using SQL View, Select and Where statements in teh physical layer.
- Created Dimensional Hierarchy wif drill-down capabilities using global and local filters, Logical tables & columns, Aggregate columns, Time-Series Objects, Level based Measures & Aggregate navigation and customized Star and Snowflake schemas by linking Fact and Dimension tables in teh BMM layer.
- Managed security privileges for users & groups using LDAP & SSO autantication, OS external database autantication/login as well as Dashboard/Report-level security.
- Configured Analytics Metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
- Developed and debugged many Dashboards / Reports wif different Analytics Views (Pivot Table, Chart, Tabular and View Selector).
- Created report templates using BI Publisher.
- Designed and Developed Custom Mappings in Informatica to bring teh data from Legacy system.
- Created Custom Mappings in Informatica to Load teh Receivables Data from Legacy system.
- Performance Tuning of Dashboards/Reports and made changes to database by implementing teh materialized views, partitions, re-building of indexes, partitions, fragmentations, aggregate tables, managing cache and overwriting teh SQL execution path by making use of hints.
- Designed and Developed Dashboard Pages Like Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance in Supplier Performance Dashboard.
- Used advanced SQL techniques like Indexing and hints for performance tuning.
- Worked extensively on teh Oracle BI Admin Tool to create teh Physical, Business and Presentation Layers.
- Utilized session variables, repository variables and initialization blocks in teh repository building and modification procedures in OBIEE.
- Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
- Worked on teh testing and validating teh Repository in OBIEE.
- Created and customized Oracle BI metadata in teh analytics repository wif Oracle BI Administration Tool.
- Customized teh login page and dashboards in OBIEE using style sheets and XML files.
- Implemented Security by creating roles & web groups, which included Autantication to LDAP, which was SSO for Oracle BI environment, and Authorization to external table where roles and responsibilities were stored.
- Setup teh visibility of Dashboard Pages to employees wif respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
- Utilized Oracle BI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to interactive dashboards for subscribed users.
- Optimized performance using Materialized views wif query rewriting. Varied Updates refresh interval from instantaneous rebuilding to a hot refresh that occurs weekly.
- Used Informatica Power Center for ETL purpose, for Data Extraction from ERP, Data Mapping and Data Conversion (Transformation) and Data loading into teh BAW warehouse.
- Developed many complex Mappings and Mapplets using various transformations (Source Qualifier, Sorter, Joiner, Router, Filter, Update Strategy, Normalizer, Lookup, Rank, Expression, Sequence Generator and Aggregator) for loading teh data into Data Warehouse.
- Worked wif Designer, Repository manager, Workflow Manager and Workflow Monitor.
- Participated in teh complete SDLC of teh application starting from Analysis including design, development, testing, implementation and maintenance of teh BI Apps application.
- Setup dashboards for Oracle BI Apps Financial modules like GL, AP, AR, FA, PO etc.
- Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.
Environment: OBIEE 10.1.3.3, Oracle BI Apps 7.9.5 (Financial Analytics), Informatica 8.1.1, DAC, Oracle 10g, Oracle EBS, Oracle SQL Developer 1.5.5, SQL*Plus, Windows 2003 Server, UNIX.
Confidential
Siebel Analytics developer
Responsibilities:
- Designed, developed and documented multiple interfaces using teh Informatica Power Center.
- Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
- Developed many complex Informatica mappings and mapplets to build key interfaces using transformations & reusable transformations (Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator) for loading teh data into Data Warehouse.
- Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control)
- Optimal utilization of object-reusability features like reusable transformations, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
- Performance Tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.
- Designed and Developed many Shell Scripts for pulling data from remote machines, Backup/Migration of metadata from version, development and production, FTP, untar & sending files to source directory, managing sessions files in teh server directory.
- Involved in Unit testing, System testing to check whether teh data loads into target are accurate.
Environment: Oracle 10g/9i, Oracle SQL Developer 1.5.5, UNIX, Windows 2000.