SUMMARY:

• 9 years of IT experience in Analyzing / Creating Complex Applications with emphasis on Design & Development of Data Warehousing, Oracle Business Analytics Warehouse (OBAW), Reporting, ETL, Development, Testing, Documentation. Perform variety of roles including BI Lead, Analyst, Administrator and Developer particularly excel at techno - functional roles that require liaison between user groups and IT.
• Experience implementing OBIEE11g, 10g and Applications (Financial Analytics, SCM, Manufacturing Analytics, HR Analytics, Procurement and Spend Analytics).
• Experience implementing OBIA 7.9.6.3, 7.9.6.4, 11.1.1.8 for EBS R12.1.x, EBS R11.5, Siebel, Teradata and PeopleSoft 9.x.
• Proficient in Installing, configuring, administering, Patching and Upgrading OBIEE 10.1.x, OBIEE 11g, Oracle BI Apps 7.9.6.4, 7.9.6.3, Informatica 9.1, 8.6 and DAC 10g, 11g.
• ETL Development / Architecture experience using Informatica Power Center/Power Mart (Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor).
• Worked extensively in developing Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.
• Expertise in providing end-to-end business intelligence solution by dimensional modelling design, developing and configuringOBIEERepository (RPD), Interactive Dashboards,OBIEEAnswers / Analysis, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots (Agents).
• Experience in extensive dimensional modelling in BMM layer (Creating business models, logical tables, Time series modelling, logical columns, level-based hierarchies, and level-based measures).
• Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmap indexes, partitions and aggregate tables.
• Expertise in fine tuning reports by using view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc., where ever necessary to increase performance.
• Experience in customizing OBIA Subject Areas like Finance (AP, AR, GL), Supply Chain-Sales Orders, Inventory and PO Dashboards, Reports, Fact Tables as per the client needs.
• Extensive experience in Oracle 9i/8i,10g/11g, SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL.
• Strong working experience in using OBIEE Delivers which includes configuring Delivery Devices, creating and configuring iBots (Agents), and building Alerts.
• Experience on assigning Data security & UI level security to the users using OBIEE repository objects & external data base.
• Experience in implementing comprehensive security functionality by defining the provider specific configuration for the Active Directory Authentication and by creating Application Roles in Oracle Web Logic Server 11g (OBIEE 11g).
• Excellent Self Driven project management skills, Team Player, Good communication and Presentation skills.

TECHNICAL SKILLS:

BI Tools/Analytics: OBIEE 11.1.1.x, 10.1.3.x, Siebel Analytics 7.x, Oracle BI Apps 7.9.x

Database: Oracle 11g /10g/9i/8i/7.x, SQL Server 2005/2000, SAP BW3.5/7,PeopleSoft 9.1

ETL Tools: Informatica 9.5.1/9.0.1/8.6, DAC 11.1.1.7/ 10.1.3.4.1

Methodologies: Data Modeling Logical/Physical, Star/Snowflake Schema, FACT Dimension Tables, ETL, OLAP, Software Development Life Cycle(SDLC)

Languages: SQL, PL/SQL, HTML, XML

Oracle Tools/Utilities: SQL*Loader, Oracle Designer, SQL Developer, TOAD, SQL

Navigator, JDeveloper, Oracle Developer 2000

Scripting Languages: JavaScript, VBScript and UNIX shell script

Operating System: Win 95/98/2000/XP, Win NT 4.0, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential -Boston, MA

Sr.BI Apps/ETL Developer

Responsibilities:

• Gathered and analyzed the Business Requirements along with SME’s to implement OBIA HR module for GHR Team.
• Actively interacted with Business Owners to translate business requirements into technical specifications.
• Customized existing OOTB Human Resources-Workforce Profile Subject Area to bring newly introduced allowances information for employees from PeopleSoft tables. Also built custom Human Resources-Compensation Analytics Subject Area and Recovery & Resolution Plan (RRP) Subject Area.
• Used Informatica Power Center 9.5.1 to develop Source Dependent Extract (SDE), Source Independent load (SILOS) mappings and load the data from PeopleSoft 9.1 into OBAW.
• Involved in developing Initial and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Designed and developed complex Aggregate, Join, Lookup transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL.
• Used DAC to schedule and run the full, incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.
• Created new DAC Tasks for Custom Informatica workflows and added them into existing Subject Area and Rebuilt the Execution Plan.
• Customized OOTB rpd for Workforce Profile Subject Area and built new rpd model for Compensation Analytics and RRP Subject Areas by adding new custom tables and creating logical columns in BMM layer.
• Created Dimensions, Aggregations and Levels using admin tool (RPD) in the Business Model and Mapping Layer.
• Developed new reports using OOTB & custom dimensions/facts in different views as per user requirement and placed them on custom dashboards.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-Across, Pivot Table, Gauge, Graph, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI Web.
• Developed some reports such as Employees list who is reporting to each other, Employees who do not have Supervisors info. etc. and built Agents to deliver those reports to People soft data management team for fixing the data issues.
• Involved in performance tuning of the Data Warehouse by implementing the materialized views, bitmap indexes, partitions and aggregate tables.
• Participated in Agile methodology provided by client ( Confidential ) for 3 weeks and implemented complete project using Agile/scrum process.

Environment: OBIEE 11.1.1.7, OBIA 7.9.6, Informatica Power Center 9.5.1, DAC 11.1.1.7, PeopleSoft 9.1, Toad 12.6.0

Confidential -Bloomington, MN

BI Apps Lead/Developer

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Business Analysts and SME’s to implement OBIA for Finance, LAM world area and Manufacturing Functional Teams.
• Interacted with Business Analysts to discuss timely deliverables & Documented Report Requirement Specifications (RRS), Technical requirement specifications (TRS) from functional requirement specifications (FRS) in reporting point of view.
• Heavily customized OBIA 11.1.1.8 Out of the Box Informatica, ODI mappings, Repository (RPD) and added additional data fields/tables into OBI Analytics (front-end) to create new dashboards as per the client requirements.
• Used Topology Manager Module to manage the data describing the information systems physical and logical architecture.
• Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Configured and setup ODI, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.
• Responsible for Metadata Administration and managed models and reverse engineering.
• Customized OOTB rpd for Finance module and Procurement and Spend Analytics by adding new custom tables and creating logical columns and hierarchies (World Area, HFM Org) in BMM layer.
• Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.

Environment: OBIEE 11.1.1.7, OBIA 11.1.1.8, ODI 11.1.1.7, Oracle 11g, Sql Developer

Confidential

BI Apps Lead/Analyst

Responsibilities:

• Gathered requirements from business users and translated them into technical specifications.
• Informatica was used to translate the business rules into mappings to include OLTP custom tables and columns from Oracle EBS and Unidata systems into OBA warehouse.
• Design the Informatica mappings, workflows. Writing Complex SQL and PL/SQL query for the Business Requirement.
• Customized OBIA 7.9.6.4 OOB Informatica ETL Mappings/ Workflows/ RPD as per the Client Requirement.
• Extensively used BI Administration Tool (.rpd) for customizing the physical, business and presentation layers of Finance and Sales repository.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-Across, Pivot Table, Gauge, Waterfall Graph, and Stacked Graph, View Selector, and Column Selector using Oracle BI Web.
• Used custom filters & dashboard prompts appropriately to avoid excessive data showing up in reports and maintained effectiveness in creating the dashboards by using guided navigational links &drilldowns.
• Designed and tested Reports on the Dashboards for Oracle Financial Analytics (GL, AP and AR), SCM, and Manufacturing Analytics and created the Adhoc report according to the client needs.
• Developed new BI discoverer reports for Finance and Sales teams and gave production support on discoverer reports.
• Based on user requirements, DAC tasks and Informatica mappings were debugged and DAC parameters were changed.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from Oracle EBS and Unidata systems, according to user requirements.

Environment: OBIEE 10.1.3.4.1, OBIA 7.9.6.2, Informatica PC 8.6.1, DAC 10.1.3.4.1, Oracle BI Discoverer 10.1.2.54.25, BI Publisher 10.1.3.4.1, Oracle 10g, SQL Developer, Toad 10.1,UNIX.

Confidential

BI Apps Developer

Responsibilities:

• Gathered requirements of the various work streams by meeting with the business users and base lining the details.
• Worked with data architects to translate business requirements into technical specifications and logical & physical data models.
• Imported Essbase Cubes from Hyperion Essbase multidimensional source and Dimensions & Facts from Oracle Warehouse into OBIEE Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Federated (Vertical & Horizontal) Essbase multidimensional sources with relational data sources in OBIEE Business model and Mapping layer.
• Used Fragmentation to pull the fact data distributed across different tables in a single data source.
• Created Parent-child hierarchies, Aggregations and Time Series functions using admin tool in the Business Model and Mapping Layer.
• Upgraded rpd and Web Catalogs (Answers, Dashboards), BI Publisher from OBIEE 11.1.1.5 to OBIEE 11.1.1.7.
• Developed new reports and customized existing reports using BI Publisher 11.1.1.7.
• Worked extensively on OBIEE answers to create reports containing charts, pivot tables, gauges.
• Informatica Power Center 9.0.1 is used to load the Oracle 11.5.10 data into OBAW using Source dependent adapters (SDE ORA) and Source Independent adapters (SILOS) and custom Folders.
• Used Oracle PL/SQL as ETL to pull the data from Oracle EBS stage tables and wrote complex logics (functions, cursors...etc.) before loading the data into OBIA warehouse.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Implemented object level security by creating Application Roles in Oracle Enterprise Manager 11g and by setting the permissions on dashboard pages using the application roles.
• Involved in users in developing, Customization and scheduling reports in BI Publisher 11.1.1.7.
• Provided end-user to power users to develop dashboards, reporting metrics and reports and provided documentation to BI Group.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5/11.1.1.7, BI Publisher 11.1.1.7, Informatica Power Center 9.0.1, Hyperion Essbase 11.1.2.2.310, Oracle 11g, Windows XP, Toad.

Confidential -Austin, TX

OBIEE Lead Developer

Responsibilities:

• Involved in Requirement gathering from business users and translated them into technical specifications.
• Worked as Subject Matter Expert and base lined the best practices that need to follow while creating Reports and Dashboards.
• Imported Dimensions and Facts into OBIEE Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Created Dimensions, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Created multiple data marts for the commercial BI project against Oracle EBS sources, Views, Flat files etc.
• Designed and developed Informatica mappings for Financial Analytics module, HR Analytics module and Procurement and Spend Analytics by using the WFS Source systems and created UNIX shell scripts to make the file transfers from the Windows directory to Informatica server directory.
• Scheduled and monitored the daily Informatica incremental loads through the Informatica Scheduler.
• Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
• Provided end-user and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5, OBI Apps 7.9.6.3, 7.9.6.2, Informatica 8.6.1, DAC 10.1.3.4.1, Oracle 11g, Windows XP, SQL Developer.

Confidential -Denver, CO

OBIEE Consultant

Responsibilities:

• Imported Dimensions and Facts into Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Worked with ETL team to push the calculations to database wherever possible and improved the query performance of reports in existing Dashboards.
• Created Logical Columns, Level Based Measures and Variables using admin tool in the Business Model and Mapping Layer as per reports requirement.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Developed many Reports/Dashboards with different Analytics Views (Pivot Table, Graph, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI Web.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Implemented comprehensive security functionality by defining the provider specific configuration for the Active Directory Authentication.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Development environment to QA environment and then to the Production environment.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5, Oracle 11g, Linux, SQL Developer.

Confidential -Oakland, CA

Sr. OBIEE Consultant

Responsibilities:

• Involved in designing the architecture of OBIEE integration with SAPBW3.5/7.
• Imported and worked on Cubes, Multi providers, Queries in BMM layer of OBIEE and resolved technical issues (Variables, hierarchies, time series functions, data types etc).
• Extensively worked with architect to baseline the best practices that need to follow for better performance while working on multidimensional objects (Cubes, Multi providers and Queries).
• Created Repository by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Created logical columns, Time series functions and Level based measures using admin tool in the Business Model and Mapping Layer.
• Modified presentation layer dimensions and attributes to match user requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Extensively worked on Various Dashboards and Scorecards in Order to Cash, Manufacturing Execution, Source to Pay and Forecast to Stock.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Performance Tuning of Repository and Reports by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
• Upgraded rpd, Web Catalogs (Answers, Dashboards) and BI Publisher from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.5 using upgrade assistant utility (Oracle Fusion Middleware Upgrade Wizard).
• Implemented Authentication of users during initial phase using Default Embedded Web Logic LDAP Server authentication. During second phase Security is implemented (Object Level and Data Level Security in OBIEE 11g Repository) using LDAP authentication in BI Repository.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Redevelopment environment to QA environment and then to the Production environment.
• Provided end-user and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.
• Utilized HP QC and JIRA for Requirement gathering and tracking issues.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5,11.1.1.3/ 10.1.3.4.1, SAPBW 3.5/7, Oracle 10g/11g, Windows XP.

Confidential -New York, NY

OBIEE Developer

Responsibilities:

• Gathered requirements from business users and translated them into technical specifications.
• Worked with data architects to translate business requirements into technical specifications and logical & physical data models.
• Evaluated and implemented data governance, data retention and data archiving strategies and business intelligence and reporting tools.
• Created Repositories by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Created Dimensions, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Developed Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Built custom analyze scripts for DAC to reduce the time for table analysis.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Informatica Power Center 8.1, Data Warehouse Administration Console (DAC), Oracle Delivers, BI Publisher, UNIX/LINUX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.