We provide IT Staff Augmentation Services!

Reports Developer Resume

Sacramento, CA

PROFESSIONAL SUMMARY:

  • Over 6 years of experience in designing, developing and implementation of OBIEE 10g & 11g , 3+ years’ experience in 11g .
  • Experienced in OBIEE 11.1.1.7, Oracle BI Applications 7.9.6.x, Siebel Analytics 7.x 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, Reporting - Siebel Analytics, Scheduling-DAC). Experienced in Data Warehousing Methodologies.
  • Experienced in OBIEE solution architecting ( OBIEE 11g & OBIEE10g) and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server. Knowledge on Tableau 8.1
  • Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer. Experienced in working with Oracle Fusion & Web Logic.
  • Experienced in designing and developing Data Modeling and Analysis using Dimensional DataModeling,StarSchemamodeling, Fact andDimensions tablesand Physical and Logical data modeling in the OBI Administration tool.
  • Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.
  • Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.
  • Experienced in IntegratingOBIEE withHyperion Essbase 9.x and in developing RPD and reports against multidimensional databases.
  • Expert in configuring, designing, development, implementation and using Oracle pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
  • Expert in building repositories using star schema , developing Subject Areas , and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers. Expert knowledge of report development execution in a complex environment.
  • Comprehensive knowledge in general accounting principles , business functions of general ledger , treasury accounting , accounts payable , asset management , billing , cash flow statements and receivables .
  • Experienced in Simplifying Migration Process - Changing environment specific variables in RPD development, administration, analysis report.
  • Created and scheduled iBotsusing delivers to send alerts, run reports, and deliver reports to the users. Experienced in supporting performance tuning and process tuning at all levels.
  • Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables.
  • Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
  • Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
  • Experienced in translating business requirements into a business dimensional model , key subject areas , dimensions , hierarchies , attributes and measures .
  • Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

OBIEE: 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g

OBIA: 7.9.6.3, 7.9.6.1(Financialanalytics, HR Analytics, Sales, Service, Marketing)

Knowledge in Informatica Power Center: 9.0, InformaticaPower center8.6.1, DAC 10.1.3.4.1 , ODI 11g

Languages and Web Technologies: SQL, PL/SQL, C, C++

Oracle Applications: 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.5

RDBMS: DB2 UDB (8.x and 7.x), Oracle11g /10g, MS-Access, SQL-Server 2008, Hyperion System 9 Essbase

Operating Systems: Microsoft Windows 8.x, Windows 7

Methodologies: Software Development Life Cycle (SDLC) -Waterfall ModelAgile Methodology, Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Reports Developer

Responsibilities:

  • Worked as Business analyst to understand the requirements.
  • Prepared technical documents to automate the Financial Validations in Excel to OBIEE.
  • Created different Reports in OBIEE which replicates reports in Excel, further created master-detail reports, actions links to present the best visualization in terms of OBIEE.
  • Created Table level security to certain group where data which was to be secure.

Confidential, Sunnyvale, CA

Sr OBIEE Consultant/OBIA Support

Responsibilities:

  • Created prompts, Drill down and navigation for the Business to view data at different level of granularity.
  • Generated reports using the OBIEE features like pivot tables, charts and view selector.
  • Performed Data Validation of data in the reports and dashboards.
  • Performed production support activities/trouble shooting the issues.
  • Prepared and maintained documentation for all new or modified RPD objects and ETL mappings.
  • Provide support to Super Users and business users on reports/dashboards.
  • DAC Load Monitoring and Performance Tuning.
  • Giving access to business users to OBI using Apex.
  • Development of RPD in MUD environment.
  • Creating reports for quarter end analysis and performance.

Confidential, Dallas, TX

Sr.OBIEE Consultant /OBIEE Developer

Responsibilities:

  • Played an active OBIEE/Informatica developer role - Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst.
  • Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.
  • Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
  • Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
  • Track project timelines, provide regular project written communications and conduct regular status meetings.
  • Be a self-starter and anticipate needs of the business team. Communicate status to all impacted departments.
  • Developed OBIEE reports for the end users and also trained the users on the reports usage.
  • Resolved the issues in the integration of BI and ODI (Oracle Data Integrator) with the help of the ODI and infrastructure team.
  • Done Analysis and Debugging (Resolution) of issues raised by users for issues related to data quality of the records associated with specific Period, Warehouse and Route.
  • Used mapping variables, parameters, workflow variables & parameter files to support change data capture and automate workflow execution process to provide 24x7 available data processing unit via Informatica PC tool.
  • Involved in writing UNIX shell scripts (Pre/Post Session commands) for the Sessions & wrote shell scripts to kickoff workflows, unscheduled workflows, get status of workflows.
  • Performed Informatica administration like user, privileges, migrations, starting, stopping pmrep /pmserver. Backup and restore repository service.
  • Performed unit testing, system integration testing, and supported user acceptance testing.
  • Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA.
  • Built metadata in the analytics repository within physical, business and presentation layers.
  • Imported tables and created Aliases, views. Implemented the star and the snowflake schemas.
  • Created union queries to satisfy complex presentation requirement. Used different views (Pivot, Narrative etc.) for various presentation purposes.
  • Implemented new and modified existing Dimensional Hierarchies to provide drilldown capability.
  • Installation of OBIEE 10g/11g on windows and Linux system.
  • Upgraded environment from 11.1.1.6.2 to 11.1.1.7.1 by applying required patches.
  • Implemented External Table and BI SQL group provider security
  • Setting/Migration of users/groups and security to new environment.
  • Implemented Usage tracking to know the usage of the reports & dashboards.
  • Involved in the security part of the project like adding users & providing the necessary Access Rights.
  • Implemented Object and Data level security.
  • Developed interactive dashboard using various objects such as embedded content, images, text, charts etc.
  • Compared actual results to expected results and suggested changes to mappings owned by others.
  • Supported Informatica, non-informatica code migration between environments (DEV/QA/PRD).
  • Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: OBIEE - Oracle Business Intelligence 11.1.1.7, 10.1.3.4, ODI 11g, Oracle Database 11g, Oracle Business Intelligence Data Warehouse Administration Console v 10.1.3.4.1 , Informatica Power Center 9.6, PL/SQL, Oracle11g, Teradata, Erwin, Control-M.

Confidential, Texas

OBIEE/ETL Developer

Responsibilities:

  • Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
  • Performed gap analysis and provided a timeline for the requirements.
  • Configured the Data warehouse Administration Console (DAC) according to the OBIA 7.9.6.3financial analytics.
  • Modified the Source system parameters in the DAC according to the Business requirements with their respective currencies and exchange rates.
  • Built custom execution plans as to pull data from two different People soft sources simultaneously in a single run.
  • Scheduled the Custom Execution plan for a weekly run in the DAC scheduler.
  • Built custom mappings in InformaticaSDE, PLP and SIL folders according to the Business Tree structures.
  • Included the custom mappings in DAC Execution plan.
  • Custom data mart is built with dimensions and facts in order to retrieve the necessary measures and attributes.
  • Provide ad hoc ability in the OBIEE system for query and build reports.
  • Automated ETL process is set up using Informatica and DAC scheduling tool to gather all the required data.
  • Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
  • Configured the OBIEE repository (Physical, BMM and Presentation layer)
  • Created dimension hierarchies and aggregates in the BMM layer.
  • Worked with the repository (PRD) and session variables. Created Initialization blocks to provide Object level security for the users.
  • Designed developed new subject areas and modified according to the requirements. Created answers page/dashboards/prompts/Analysis on requirement.
  • Used the security settings to setup users, Groupsin Web logic Consoleand Access privileges.
  • Built materialized views to solve complicated joins and improve performance.
  • Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
  • Created prompts, Drill down and navigation for the Business to view data at different level of granularity.
  • Generated reports using the OBIEE features like pivot tables, charts and view selector.
  • Performed Data Validation of data in the reports and dashboards.
  • Performed production support activities/trouble shooting the issues.
  • Prepared and maintained documentation for all new or modified RPD objects and ETL mappings.
  • Unit, integration and system testing for all components in OBIEE. Prepared test cases and documented the results.

Environment: OBIEE 11.1.1.6, OBIEE Financial Analytics 7.9.6.3, Oracle EBS R12.1.1, Informatica 8.9, Oracle 11g, Oracle Enterprise Linux 5.7, Windows Server 2008 R2, Windows XP.

Confidential, Gaithersburg, MD

OBIEE Developer

Responsibilities:

  • Gathered information by interacting with clients and end users.
  • Involved in full Life Cycle Implementation of OBIEE.
  • Involved in requirement analysis, designing of Data Warehouse, populating Warehouse using Informatica ETL, Design and implementation of custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
  • Performed the detailed design implementation and testing of Reports/Dashboards and Analytical Data Model (Metadata/rpd).
  • Designed and built Starschemas/snowflake schemas upon requirements.
  • Configured repository (RPD) to use the LDAP authentication.
  • Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
  • Defined dimensions and facts in the subject areas.
  • Implemented OBIEE security for users and groups in administrator tool.
  • Created reports by applying views, filters, calculations and conditional formatting in answers.
  • Designed Intelligent Dashboards for different user groups to view updated KPIs.
  • Created and scheduled iBots as per the business requirements.
  • Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement.
  • Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in Informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center.
  • Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.
  • Applied Optimization techniques and tuned performance of the reports.
  • Provided technical and user documentation and training. Created Dashboards on Pharma Sales Analytics.
  • Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
  • Worked in the development of OLAP Databases and Structures used in the Health Care sector.
  • 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.
  • Migrated the tested code of Repository, Dashboard reports, and OW Mappings and Workflows from Development to QA and from QA to Production Environments.

Environment: OBIEE 10.x, Informatica Power Center 7.1.3, Oracle 10g, TOAD, Teradata and Windows 7.

Confidential

OBIEE Developer

Responsibilities:

  • Involved in Customization and Development of the OBIEE Metadata Repository (.rpd) using OBIEE Admin Tool in Multi User Development (MUD) Environment.
  • Developed managerial hierarchy in the RPD with vertical table structure to identify the direct report employees of a particular manager at certain level. Implemented conditional formatting to identify the employee level of reporting.
  • Developed the reports based on Dimension hierarchies and presentation columns to provide the filter at any level of column detail.
  • Implemented security on fact table to restrict the organization data limited to their own hierarchy.
  • Restricted confidential data to certain groups including top talent associates profile information access to higher level management only.
  • Created set of dashboards/reports for talent planning, performance management, competencies, and Executive profiles using OBIEE.
  • Developed report with conditional filters, Prompts, Drill Down reports, Drill Reports, different Analytics Views (Pivot Table, Charts).
  • Created user level security for intelligence dashboards based on Business Requirement and utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
  • Security has been considered primarily for the confidential columns data by generating the SQL and gathering the group’s information to restrict the data to certain groups only.
  • Implemented Workforce planning project to allow users to forecast the Organization metrics data, and displaying the current and forecasted data in a single dashboard by having run time calculations to display forecasted data.
  • Provided new design for Associate movement summary as Daily data or monthly data changes. Configured the RPD to switch the sources to provide the flexibility of choosing daily or monthly snap shot data
  • Limited the row level data to the certain groups based on inclusive or exclusive access to the organization, Location, Manager and Confidential information. Limited the intersection of row and column by categorizing the confidential columns based on row level data and exclusive or inclusive access to it.
  • Provided additional layer of security on physical data base objects to the particular promo group to perform the data base authentication.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.4.2 , Informatica 8.1.x, Oracle 10g

Hire Now