We provide IT Staff Augmentation Services!

Obiee / Bi Apps Developer Resume

Sunnyvale, CA

SUMMARY:

  • Around 8 years of total IT experience and 7 years of experience in Business Intelligence Applications using 10.1.3.4, 11g, 12c / Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps).
  • Expertise in Dimensional Data Modeling experience using Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling, and Data Modeling Tools Visio.
  • Experience in creating OBIEE Metadata, OBI Answers, OBI Dashboards, and BI Publisher.
  • Expertise in support forms generated using legal pre - printed forms through Oracle BI Publisher
  • Expertise in the configuration, and documentation of all OBIEE, OBIA components.
  • Expertise in Building Executive Dashboards using Dashboard Manager for BI Analytics Web / Oracle Presentation Services for BI Analytics Web / OBIEE.
  • Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
  • Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
  • Expertise in Business Intelligence Applications using BI Analytics, Oracle Business Intelligence (OBIEE/OBIA) in Marketing, Sales, Procurement modules.
  • Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
  • Expertise in Setup Multi User Development Environment (MUDE) in OBIEE.
  • Expertise in Business Intelligence Applications using BI Analytics, Oracle Business Intelligence (OBIEE/OBIA) in Marketing, Sales, Procurement, Supply Chain, Order Management, Financial, Retail, Health, modules.
  • Responsible for BICS Data and monitor workload by company code, due date, degree of difficulty, and all analytics as needed.
  • Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load).
  • Expertise in Topology, Designer, Operator in (ODI) Oracle Data Integrator.
  • Experience in creating entity relational & dimensional relational data models with i.e., Star schema and Snowflake schema.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
  • Package Software: Expertise in Informatica ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
  • Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions) I have been key in delivering innovative database /data warehousing solutions to the Retail Industries.
  • Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Strong aptitude for learning and understanding business process and needs.

TECHNICAL SKILLS:

BI: OBIEE 10.1.3.4, /11g, 12c BI Publisher, DAC

ETL: Informatica Power Mart, Informatica Power Center 9.1x/8.6

Languages: SQL, PL/SQL, HTML, XML

Databases: Oracle 11g, Microsoft SQL SERVER, 2005, 2008

Tools: Visual Source Safe

OS: Windows 7/ 8/, UNIX, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

OBIEE / BI Apps Developer

Responsibilities:

  • Worked closely with the business community to assess business needs, define requirements and Implement solutions.
  • Interacted with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
  • Design OBIEE Answers and Intelligence Dashboards. Documented all the configurations and new reports creation and published it to the end users.
  • Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
  • Created proper documentation to describe program development, logic, coding, testing, changes and corrections.
  • Developing Business Objects reports using Universe and BICS.
  • Implement Marketing Analytics module from Oracle BI Apps.
  • Implement new data modeling and new hierarchies on the existing marketing module as per client requirements.
  • Redefine hierarchies in Marketing Accounts and contacts as per client requirement.
  • Map the tasks to execute mappings in Informatics.
  • Modified mappings as per the changed business requirements.
  • Implemented security based on LAP Authentication.
  • Worked during the whole life cycle of the project from requirements gathering to deployment.

Environment: OBIEE 11g, 12c BI Apps, Informatica 9.1, Oracle 10g, Oracle SQL, PL/SQL, DAC, TOAD, SQL, Unix, Windows XP.\

Confidential, Edison, NJ

OBIEE 11g Developer/ BI Apps Developer

Responsibilities:

  • Involved in business requirements gathering and translated the requirements into technical requirements.
  • Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
  • Developed mappings in Informatica to load the data from various sources into the Data warehouse different transformations like Source Qualifier Expression, Lookup, Aggregate, Update Strategy and Joiner.
  • Kimball dimensional modeling, OLTP and OLAP database designs and implementation strategies.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
  • Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
  • Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
  • Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
  • Setup Multi User Development Environment (MUDE) in OBIEE.
  • Created new requests and opened Answers for adhoc reporting to the End users
  • Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
  • Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
  • Created workflows for full load and incremental loads to be used by DAC.
  • Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
  • Documented all the configurations and new reports creation and published it to the end users.
  • Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
  • Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: 10.1.3.4,11g, BI Apps, Informatica 9.1, Oracle 10g, Oracle SQL, PL/SQL, DAC, TOAD, SQL, Unix, Windows XP.

Confidential, New haven, CT

OBIEE/BI Apps Developer

Responsibilities:

  • Full project life cycle implementation for Oracle Business Analytics Warehouse (OBAW)
  • Performed Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities, Project Execution Plan and Resource Plan.
  • Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area.
  • Expertise with Siebel Base tables and EIM workflows.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
  • Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
  • Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model.
  • Developed and tuned all the Affiliations received from data sources using Oracle and Informatica and tested with high volume of data.
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and Informatica Power Center.
  • Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
  • Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables
  • Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
  • Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data.
  • Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
  • Developed BI Consumer reports using OBIEE 11g.
  • Expertise in segmentations and scheduled programs on daily basis.
  • Expertise in SQL check and List pulls.
  • Proficient in using Xcelsius tools.
  • Developed new Informatica mappings for enhancement and bug fixes for various brands as per various requirements.
  • Worked on Informatica Performance tuning methods like various ways of using lookup caches depending on the size of source and lookup tables.
  • Added new facts and Dimensions to the OBAW and created new execution plan in DAC for dial load into these table.
  • Proficient in working with HP Service center and Quality center.
  • Worked in production support and seen through the phase of the developments in the production and done various bug fixes.

Environment: OBIEE 10.1.3.4./11 g, BI Apps, Xcelsius, Informatica 8.6, Oracle 10g, Oracle SQL, PL/SQL, DAC, TOAD, SQL, Windows 8.

Confidential, Washington DC

OBIEE Developer

Responsibilities:

  • Work with end users to understand business process of Credit Union and gather requirements for the necessary reports.
  • Analysis of business requirement to define KPIs (Key Performance Indicator).
  • Designed the RPD and defined the Subject Areas.
  • Customized Oracle BI Repository defining Physical Data Layer and developed Business Model and Presentation Layer using Administration Tool.
  • Prepare technical design documentation of all the necessary aggregates, KPIs which needs to be configured in fact dimension.
  • Implemented data level and object level securities.
  • Designed the implementation of ETL and OBIEE for various Modules like incentives, loans and cross sales.
  • Worked with different groups in organization to understand their business requirement and give valuable suggestions for reports and dashboards.
  • Create groups for different users to provide suitable securities for different dashboards and reports.
  • Designed the layout for different dashboards and reports.
  • Managed day-to-day .rpd, Scheduler & iBots.
  • Implemented BI Publisher and created business reports using BI Publisher.
  • Configured Database to authenticate users against Microsoft Active Directory.
  • Work closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.
  • Extensively used Informatica to load data from wide range of sources such as flat files (CSV, fixed length), Oracle to Oracle.
  • Extensively worked with performance tuning of the mappings, sessions and Stored Procedures.
  • Developed re-usable transformations, mappings and Mapplets conforming to the business rules.
  • Involved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes.

Environment: OBIEE 10.1.3.4, Informatica Power Center 8.6, Oracle 10g, TOAD, SQL, PL/SQL, Unix Shell scripts.

Confidential, Corona, CA

OBIEE: 10.1.3.4, 11g Developer

Responsibilities:

  • Worked closely with the business community to assess business needs, define requirements and Implement solutions.
  • Interacted with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
  • Design OBIEE Answers and Intelligence Dashboards.
  • Implement Marketing Analytics module from Oracle BI Apps.
  • Implement new data modeling and new hierarchies on the existing marketing module as per client requirements.
  • Customized BI Repository defined Physical Data Layer and developed Business Model and Presentation Layer using BI Analytics Administration Tool and using OBIEE.
  • Configure DAC and create containers, subject areas and tasks.
  • Customized the repository and created new requests using Answers.
  • Managed day-to-day .rpd, Scheduler & iBots
  • Worked on creation and configuration of BI dashboards, customized reports and charts (like Sales, Service and marketing), in BI Answers.
  • Redefine hierarchies in Marketing Accounts and contacts as per client requirement.
  • Map the tasks to execute mappings in Informatica.
  • Extensively used Transformations like Lookup, Router, Aggregator, Source Qualifier, Joiner, Expression, and Update Strategy.
  • Modified mappings as per the changed business requirements.
  • Developed UNIX and PL/SQL scripts to automate chronological loads.
  • Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.

Environment: OBIEE, DAC, Oracle 11g, Oracle SQL, PL/SQL, UNIX, Windows 8.

Confidential, Bethesda, MD

BI Analytics Developer

Responsibilities:

  • Responsible for delivery of quick fixes and enhancements to BI customers in the form of Fix packs.
  • Developed End-to-End Reporting Solutions.
  • Installation and Configuration of DAC (Data warehouse Application Console) for multi OLTP regional instance environment.
  • Used DAC client to load the custom mapping to the warehouse.
  • Direct Interact with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
  • Created/Modified Workflow Process.
  • Developed mappings by extensively using Informatica Transformations like Lookup, Filter, Expression, Aggregator, Joiner etc.
  • Extensively involved in designing the workflows, worklets and also involved in designing sequential and concurrent sessions using workflow manager.
  • Created Reusable Transformations and Mapplets in the Designer using Transformation Developer and Mapplet Designer Tools. Created and Monitored Workflows and Sessions using Informatica Workflow Manager.
  • Customized the application using BI Tools configuration in Data, Business and User interface layers.
  • Involved in unit testing and integration testing of all the mappings, workflows, schedules.
  • Configured BI Web Components including BI Answers and Intelligence Dashboards.
  • Created Logical Columns based on other Logical and Physical columns in the BMM layer.
  • Customized users, groups and assign privileges for the users to access the data from the warehouse.
  • Customized the repository and created new requests using Answers.
  • Created and configured the BI dashboards, customized reports and charts (like Sales, Service and marketing), in BI Answers.
  • Created Workflow Process, Workflow group and policy conditions to handle bounce backs.
  • Developed UNIX shell and PL/SQL scripts for pre & post session processes to automate daily loads.
  • Provided production support for applications.

Environment: 10.1.3.4, Informatica Power Center 8.6, DAC, Oracle 10g, PL/SQL, Oracle SQL, Toad, UNIX.

Confidential

Oracle Developer

Responsibilities:

  • Involved in user requirement and requirement specification from users.
  • Documenting business requirements, functional specifications and test requirements.
  • Identified the key facts and dimensions necessary to support the business requirements.
  • Prepared prototype models to support the development efforts.
  • Developed various complex SQL queries, stored procedures, functions, packages and Database triggers.
  • Involved in the design, development and testing of the PL/SQL stored procedures, packages
  • Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
  • Provided input into updates and modifications of the product documentation and support the testing team to deliver the highest product quality to the customers.
  • Involved in analysis, estimating, design, development, testing, and 24 x 7 production support.

Environment: Oracle 1Og, Oracle SQL, PL/SQL, Windows 8, UNIX, SQL

Hire Now