PROFESSIONAL SUMMARY:

• Over 9 years of expertise in all phases of Software Development Life Cycle (SDLC) and having comprehensive background in End - to-End implementation of Business Intelligence using Oracle Business Intelligence (OBIEE)/BI Publisher/OBIA.
• Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star schema, Snowflake schema and Dimensional modeling.
• Installed and configured different versions of OBIEE & Informatica.
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies), Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog/Subject Areas in Presentation Layer.
• Hands on experience in customizing analysis, filters and charts in OBIEE Analytics.
• Understand the standard of best practices in BI architectural design.
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Compound Layout, Narrative, Column Selector, View Selector, Ticker, Segment, Section, Tabular with local and global filters) using OBIEE Analytics.
• Experience in Configuring Interactive Dashboards with Security Setup (groups, data access/query privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).
• Created, modified, and Administered Analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.
• Implemented Dynamic Dashboard Prompts using Presentation variables to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports.
• Install, Configure and integrate BI Publisher with OBIEE RPD/Presentation layer.
• Proficient with BI Publisher reports using various templates to publish the reports as per user requirements and in bursting and scheduling BI Publisher Reports.
• Experienced in usage of Disconnected Analytics and Strong working experience in using OBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.
• Strong expertise in Implementing MUD (Multi User Development) Environment.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by designing Query Caching and Data Caching for Performance Gains.
• Involved in the Upgradation of OBIEE 10g to 11g across all business verticals.
• Expertize in data modeling skills ( conceptual, logical and physical model design)
• Experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts .
• Strong experience in using different Informatica Designer Components.
• Expertise in developing Informatica Mappings/Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookups, Update Strategy) and also in creating Workflows.
• Experience in using Data warehouse Administration Console (DAC) to schedule, run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Experienced in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers , and Indexes.
• Experience in customizing out-of-box reports(Financial, Procurement and Spend, Supply chain, Sales and Marketing Modules)
• Good understanding of Software Development Life Cycle (SDLC).
• Expertise in interacting with Business users, Architecting requirements and design documents.
• Team player and self-starter with good communication skills and ability to work independently.

TECHNICAL SKILLS:

OBIEE: 11.x/10.x, BI Publisher11.x/10.x, Discoverer, Oracle BI Apps, Tableau, Noetix

ERP/CRM(Source Systems): Siebel CRM 8.1.1,PeopleSoft 9.0,Oracle EBS R12/11i,Oracle Fusion HCM 11.1.9.2

ETL Tools: Teradata Studio Express 15.10, Teradata SQL Assistant 14.10,Informatica Power Center 9.0.1/8.x/7.x, Data stage 8.0.1, DAC, OBIA 7.9.6.x, ODI

Languages: C,C++, PL/SQL, SQL*PLUS 8.x/9.x, Java, Java script, Shell Scripting, Unix scripting

Web Technologies: JSP, HTML, XML,VB Script, ASP

Data Modeling: Erwin 4.1,SQL Developer,, SQL Explorer, TOAD 11.5, SQL Server Management studio

Databases: Oracle 9i/10g,11g, MS SQL Server 2000, SQL Server 2005, SQL Server 2008

Operating System: Windows NT/2000/95/98/XP, Windows 2003 server, UNIX, Linux, Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Iowa City, IA

OBIEE Developer

Responsibilities:

• Worked closely with corresponding service analysts in gathering user stories/reports Requirements.
• Involved in Agile Scrum methodology (sprints) in delivering OBIEE and BI Publisher reports to business users.
• Designed mockups and demos to the business users to give them a high level picture on code changes for the reports.
• Involved in RPD and OBIEE Reports Design and Development.
• Developed different kinds of Reports and Interactive Dashboards with various logical calculations using Pivots, View Selectors, Column Selectors, and with drill-down/Navigation capabilities-Summary and detail, charts, tabular using global and local Filters, and Page/Dashboard /Hierarchical Prompts.
• Worked on designing data models and Confidential Workkeys Assessment summary score reports/certificates for examinees.
• Worked on Oracle BI publisher RTF templates to make the required business changes like new columns, banner page and Confidential logo changes and provided the capability to download the reports in the user defined formats in the Confidential WorkKeys Validus Report Portal.
• Involved in Migrating Oracle discoverer 10g reports to OBIEE 11g.
• Involved in gap analysis of the reports using SQL from Oracle discoverer reports and mapped different data sources to the Physical Layer and designed Star schema for fact & dimensional tables, created aliases for the dimensional tables and opaque views, created outer joins between dimension and fact tables in the business model layer and built subject areas in the presentation layer when necessary in the RPD.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Used SQL developer to debug the SQL query to identify data in the oracle discoverer e-business tables and Workkeys warehouse tables, and to debug and tune the SQL queries issued during report execution.
• Unit, Integration, System testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Involved in Sprint Daily Stand ups meetings, Sprint Backlog Stories Refinement, Iteration review, demo and planning migration, UAT, Go-Live, and Production Support for incidents requests by customers.

Environment: OBIEE 11.1.1.9, BI Publisher 11.1.1.9, Oracle EBS R12/11i, Oracle 11g, JIRA 7.4.3(Agile software),Oracle SQL Developer 17.3.1, Oracle Discoverer Plus 10g, Windows 8.

Confidential, Columbus, IN

Senior OBIEE Developer

Responsibilities:

• Worked closely with corresponding area's Subject Matter Experts (SME), Stake Holders and Key Business Users in gathering the Analytics / Reports Requirements.
• Designed prototypes and performed GAP Analysis for the business requirements and made sure that business requirements are correctly translated into Teradata database schemas and ultimately into the OBIEE application.
• Involved in RPD Development and Oracle BI Answers.
• Mapped different data sources to the Physical Layer and designed Star schema for fact & dimensional tables, created alias for the dimensional tables when necessary.
• Designed Degenerate, Conforming and Non-Conforming dimensions in the BMM layer.
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Developed different kinds of Reports and Interactive Dashboards with various logical calculations using Pivots, View Selectors, Column Selectors, and with drill-down/Navigation capabilities-Summary and detail, charts, tabular using global and local Filters, and Page/Dashboard /Hierarchical Prompts.
• Used Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Preparing physical mapping for the reporting attributes and finding a Noetix match.
• Monitored database performance tuning and implemented the session partitions and made changes to database by re-building the Indexes.
• Used Teradata SQL Assistant to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.
• Unit, Integration, System testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Coordinating with on-shore and off-shore clients and ensure project delivery on time.
• Involved in Migration, UAT, Go-Live, and Production Support.

Environment: OBIEE 11.1.1.9, Finance Module(General Ledger),Oracle EBS R12/11i, Noetix, Teradata Studio Express 15.10, Teradata SQL Assistant 14.10, Clear Case Explorer, Blade logic, Windows 8.

Confidential, Charlotte, NC

Senior OBIEE Developer

Responsibilities:

• Worked closely with the business users to make sure that business requirements are correctly translated into Oracle fusion HCM schemas from People soft HCM source system and ultimately into the application.
• Created pixel perfect reports using BI Publisher in interactive mode by creating data models and data sets using the Oracle fusion HCM pre-built database schemas, tables and OTBI subject areas and used MS office plug-in for analyzing data.
• Created parameters and List of Values in the Data model to save the prompt values and use them in reports based on user’s requirements.
• Implemented data level security for Employee PTO Summary Reports and Manager Reports using global session variables and Oracle fusion HCM secured views in the data models.
• Worked extensively on Oracle BI Publisher RTF templates and provided the capability to download the reports in the user defined formats in the Oracle Fusion HCM interface.
• Proficient in bursting and scheduling of BI Publisher Reports.
• Passed parameters from OBIEE Dashboards to BI Publisher Reports by creating dashboard prompts and assigned BI Publisher parameter values to the presentation variables.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Chart, Union reports, and Narrative and Nested reports in OTBI Analytics.
• Created Manager Dashboards with local/global Dashboard prompts using BI Publisher Reports and OTBI Analysis and Master-Detail linking.
• Implemented security for OTBI analytics and BI Publisher data models and reports by creating application roles and catalog groups and assigned them to the employees and managers with respect to their roles and responsibilities.
• Setting up LDAP authentication to enable Single Sign on for Users in Production environment using Oracle fusion Web logic Console.
• Created Adhoc reports and Audit reports for the business users.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
• Involved in performance tuning of BI Publisher report by debugging the XPATH in a single for each loop and sorting the data at the data model.
• Unit, Integration, Regression and User Acceptance testing (UAT) testing for all components in OTBI and BIP. Test cases have been prepared and documented the results.
• Involved in Migration, UAT, Go-Live, Upgrade and Production Support.

Environment: OTBI 11.1.1.7.29 , BI Publisher 11.1.1.7.29 , Oracle Fusion HCM 11.1.9.2/11.1.10.0 , People Soft HCM, Oracle 11g, SQL Developer 11g, Windows 7.

Confidential, Waltham, MA

Senior OBIEE Developer

Responsibilities:

• Worked with corresponding area's Subject Matter Experts (SME), Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Worked on Oracle BI Applications pre-built DAC and ETL repositories and execution plans.
• Worked on ETL Enhancements by creating custom SQL scripts to make changes to the existing tables in the OLAP database as per the business requirements.
• Involved in designing Mappings, Mapplets and Transformations using the tables from Siebel CRM (OLTP) System and Unit testing and Integration testing of all the mappings, workflows, schedules.
• Responsible in designing and introducing new FACT or Dimension Tables to the out of box RPD and decide the granularity of fact tables.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Created Session variables, Repository variables in RPD and used the same for role based security, object level and dynamic calculations in OBIEE answers.
• Added users and configured security in web logic console of OBIEE 11g.
• Designed and implemented Oracle OLAP (cubes) for use with OBIEE dashboards.
• Created Union Reports to get World Wide results as per the Business requirement.
• Customized existing OBIA / out of box reports in Finance and Marketing modules.
• Created Monthly, Quarterly and Yearly reports which gives detailed information on Budget, Actuals and Forecast Revenue and published them on Dashboard.
• Customized Reports look and Feel using Column Formatting, Cross Conditional formatting.
• Implemented Multi User Development (MUDE) for concurrent rpd development.
• Involved in upgrading RPD and web catalog from OBIEE10g to OBIEE11g.
• Unit, Integration, Regression and User Acceptance testing (UAT) to validate report and mapping functionality.
• Prepare and maintain technical documentation for all new or modified objects.
• Coordinated the OBIEE .rpd and Web Catalog objects deployment from Development environment to QA environment and then to the Production environment.

Environment: OBIEE 11.1.1.6, Oracle BI Apps 7.9.6.4, Siebel CRM 8.1.1, MS SQL Server 2014, Informatica 9.1.1, DAC, SQL Server Management studio , Windows 2003, UNIX.

Confidential, Grand Rapids, MI

Senior Oracle BI Developer

Responsibilities:

• Worked closely with Business Analyst, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled slowly changing dimension data.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Designed and Integrated Oracle Essbase (cubes) for use with OBIEE dashboards.
• Configured Repository Initialization Blocks and session variables to get dynamic reports and dashboards.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and associated catalog objects and Web modules with the created groups.
• Customized OBIA reports in Sales and Marketing modules.
• Developed PL/SQL stored procedures and triggers to facilitate consistent data entry into the database.
• Monitored database performance tuning and implemented the session partitions and made changes to database by re-building the Indexes.
• Created pixel perfect reports using BI Publisher in Interactive mode by creating data models and data sets and used MS office plug-in for analyzing data.
• 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 and Created workflows for full load and incremental loads to be used by DAC.
• Merge Repositories two way and three way into master repository from each developer.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Coordinating with on-shore and off-shore clients and ensure project delivery on time and Involved in Migration, UAT, Go-Live, and Production Support.

Environment: OBIEE 11.1.1.3, Oracle 11g, OBIA 7.9.6.3, Informatica 9.1.1, DAC, TOAD, PL/SQL, Oracle e-Business Suite (EBS), BI Publisher, Erwin, Windows XP.

Confidential, Bentonville, AR

OBIEE Developer

Responsibilities:

• Analyze the specifications provided by the client, understanding the business.
• Worked extensively on Supply Chain and Demand Data warehouse Schemas/Reports.
• Involved in RPD Development, Oracle BI Server, And Oracle BI Answers.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Extracted data from Various ERP Systems like Siebel OLTP database, Oracle E business Suite (EBS).
• And worked on data models, data stage and data mining tools.
• Designed Star schema for fact & dimensional tables, created alias for the dimensional tables when necessary.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions and Created Opaque views as per the user Requirements.
• Implemented Multi User Development (MUDE).
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle BI Presentation Services.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.
• Implemented Security by creating roles & web groups, checks with External tables and LDAP.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Involved in implementation of Pre built OBI Analytics.
• Used PL/SQL to validate data and to populate billing tables.
• Involved in migrating Discoverer reports to OBIEE.
• Good hands on experience in using BI Publisher to create reports from BI answers, BI server.
• Merged and compared two different Repositories using administration tool.
• Trained and worked with the end-users in developing their own ad-hoc reports using OBIEE Answers.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.0 , BI Publisher, Oracle 10g/11g, Informatica, DAC, OBIA, Discoverer, SQL Developer, PL/SQL, People Soft, Windows NT, UNIX.

Confidential

Jr. INFORMATICA Developer

Responsibilities:

• Developed ETL to load data from Microsoft SQL server into the target Oracle database.
• Data warehouse Architecture and Dimensional Modeling (Star Schema- Facts and Dimensions,Type 1 &2 SCD, Snowflake)
• Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, and Update Strategy.
• Developed simple & complex mappings using Informatica to load dimension & fact tables as per STAR Schema techniques.
• Drilldown reports with SQL queries and SQL, PL/SQL, scripts for data validation and reconciliation and used Procedure Transformations to invoke Oracle PL/SQL Procedures
• Worked extensively with Oracle Stored Procedures, triggers, View and DDL commands.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level and Performed error handing using session logs..
• Developed stored procedures using PL/SQL to implement the business logic as well as changing the existing logic.
• Moved the mappings from development environment to test environment.

Environment: Informatica 6.x, 7.x, SQL*PLUS, Erwin 4.0, PL/SQL, Windows 2000, UNIX, IBM DB2, MS SQL Server 2000.