| PROFESSIONAL EXPERIENCE Sr.OBIEE/BI Reporting Consultant Confidential Responsibility: Design, developed and translated business requirements to technical design for the BI reporting generation. Worked on customization of pre-built STAR dimensional MODELING, design and developed repository ETL/workflow processes, Operated and maintained all ETL schedules through DAC. Administered BI Server, RPD according to reports requirement. Implemented SSO LDAP , Secruity, Custom dashboards, ad-hoc reports, Bi Publisher report by using answers and O M support. Tools Databases: Oracle Apps Rel12, OBIEE Oracle 10g, Bi Publisher 10g, Siebel, Oracle 11g database , Weblogic Admin, Case management analytics 7.9.6.1, Informatica 8.6.1.0 9.0.1,Weblogic 10g, obiee 10G TO 11G UPGRADE Sr.BI Reporting Consultant Confidential - Design and developed BI answers, KPI and Scorecards for ad-hoc/stand alone reports and integrated with BI Dashboards from SEAM Enterprise Asset Management Projects and PA , GL AR Warehouse system by using Oracle's Business Intelligence OBIEE /BI Publisher 11g reporting tools .
- Modules involved in Supply chain Analytics INV, OM, Asset management , GL, Procurement AR in Oracle Apps Rel12 EBS environment.
Responsibility: Design, developed and translated business requirements to technical design for the BI reporting Bi Publisher generation. Design and created repository ETL mappings, customized OBIEE pre-built TART DIMENSIONALdata models according to the client requirements. Scheduled ETL Informatica workflows through DAC, administered BI Server, RPD according to reports requirement. Implemented security structure SEAM system. Tools Databases: Oracle Apps Rel12, OBIEE BI Publisher 11g. , Oracle 11g , OBIA 7.9.6.X Financial analytics, 11g database, web Services, Informatica 8.6.1.0, Win2008 and Linux redhot. Sr.BI Reporting Consultant Lead - Confidential - Design and develop ad-hoc/stand alone reports from Connectrix Warehouse system by using Oracle's Business Intelligence OBIEE /BI Publisher 11g reporting tools.
- Worked on HR Analytics OBIA 7.9.6.2 System designed and implemented dashboards analytics related to Absence , Compensation, Human Resource Performance, Recruitment, Workforce Development and workforce Profile for HR department.
Responsibility: - Design, developed and translated business requirements to technical design for the BI reporting and scorecard generation. Design and created repository RPD according to reports requirement. Implemented security structure for HR system.
- Designed and Developed BI Publisher reports with data template design and calling procedure/functions from template OBIEE Answers, KPI for ad-hoc reports.
Created OBIEE dashboard and integrated with BI Publisher reports for business users. Tools Databases: Oracle 11g Release1, OBIEE BI Publisher 11g. , Oracle 11g Rel1datase, financial Procurement spend analytics 7.9.6.x, webServices,Win2008 and Linux redhot. Sr. Oracle BI Reporting Consultant Confidential - Designed and Developed BI Publisher reports with data template design and calling PL/SQL package from template OBIEE Answers for ad-hoc reports from custom data warehouse, STAR/dimensional schema data mapping , Bi delivery, Security, BI server administration implementation. Leading assisting staff in the development of reporting capabilities using BI Publisher. Design and modify repository according to reports requirement.
- Established and setup Multi User Development MUD environment for other OBIEE developers to work on same application.
- Setup and documented of the OBIEE configuration file.
Tools Databases: Oracle 11g , OBIEE 10.1.3.4.1 BI Publisher 10g, OBIA apps 7.9.6.x Financial, P S Analytics. Sr. Oracle BI Reporting Consultant Confidential - Philosophy is consumer retail and online cosmetic cutting-edge internal research and development, manufacturing and distribution company and having products like results-driven skin care, clean fragrances, joyous bath body line and skin-loving makeup.
- Philosophy decided to implement Oracle BI Applications Analytics Financial, OM, HR, Supply chain modules to optimize corporate profits and performance.
- The most valuable BI systems pull data from across the enterprise and present information to users in a meaningful way to improve decision-making.
Project : Oracle OBAW BI Applications version 7.9.6.1 Ver. , Financial Analytics GL,AP,PA,FA , Created designed FSG reports, SCM Order Management , customized OBIEE pre-built STAR Dimensional data model. dashboard ad-hoc reporting implementation. And customized Presentation Layer according to the clients requirements and scope. Responsibility: - Meeting with the business Users/Managers Finance IT to determine reporting score cards and dashboard needs and implement a solution to meet those needs on weekly basis.
- Design, developed and translated business requirements to technical design for the Analytics report generation.
- Developed, documented and operated the OBIEE security strategy. Conducting OBIEE performance tuning and management.
- Modify the Business mapping layer through OBIEE Admin. tool to create aggregates and impose some business rule on FACT AND DIMENSION tables.
- Direct and design the information delivery and access for the OAW warehouse.
- Choose or suggest data warehouse technologies such as Data Quality, ETL, BI and FACTS, Summary tables.
Tools Databases: Oracle 10g Release2 , Oracle Apps 11i,OBIEE 10.1.3.4.1 BI Publisher 10g , Discoverer 10g, InformaticaPowercenter ETL and DAC. . Sr. Oracle BI Reporting Consultant Confidential Design, developed BI Publisher multi-lingual Spanish reports with data template design, Data Mapping, Bi delivery, BI server administration, Labels , BARCODE, SSO/LDAP implementation. Responsibility: - Gather and document reporting/process requirements for the business
- Users. Performed and submitted Gap Analysis to the project manager, document and translate them to technical requirements. .
- Also involved in UAT user acceptance testing and production support for BI answers, Dashboard and Publisher reports.
- Developed and implemented processes and procedures for the migration of OBIEE RPDs, web catalogs, and individual web catalog objects through the development, test and production environments.
- Tools Databases: Oracle 10g Release2 , OBIEE 10.1.3.4 BI Publisher 10g Web Services BIP API's
- Oracle Warehouse Builder 10g Rel2.
- Confidential
Project: Oracle Fixed Assets, Items and Customer Conversions from 11.5.6 to 11.5.10. and Reports. Tools Databases: Oracle 10g, PL/SQL, Reports 10g. Oracle Independent Consultant Confidential Tasks Performed: Provided technical design/architecture for BI reporting solution for corporate data. Created , designed , implemented, administered End User Layer/ Meta-Layer Business Area's, Complex Folders, complex workbooks , security for Oracle EBS 11i Inventory and GL which is used to created Ad-hoc reports by business users. Tools Databases: Oracle 10g, Oracle BI Discoverer 10g Release2 , Discoverer 10g PLUS VIEWER. Confidential Oracle Lead Consultant - Project: Implement Product Partners BI Reports by using OBIEE Siebel Analytics tools.
- Tasks Performed:
- Responsible for defining the complete data warehouse architecture e.g. OLAP, ETL process, SATR , DIMENTIONAL, EDW .
- Classify the key business drivers for the data warehouse initiative
- Establishing a multi-user OBIEE development environment.
- Define data and technical architectures and technical requirements for the data warehouse.
- Planning and creating Oracle BI Repository, Creating and Administering Physical, Business model Data mapping, and Presentation layer, Creating dimensions hierarchies in BI repository, design build Interactive Dashboard, Create and Publish Data ob Dashboard for higher management, Created near 30 various Order Fulfillment, Service Track, Inventory reports for business users, Scheduling the reports by Oracle BI Delivers called iBot, End user training.
Define meta data standards for the data warehouse. Tools Databases: Oracle 10g, Oracle OBIEE Release 10g Ver 10.1.3.2.1 , Oracle OWB 10g Confidential : Created , designed , implemented, administered End User Layer/ Meta-Layer Business Area's, Complex Folders, complex workbooks , security for Oracle EBS 11i AR OM module which is used to created Ad-hoc reports by Thompson Enterprise business users. Also designed and developed Purchase Order and Payable Invoice and register XML reports integrated with Oracle 11i through concurrent manager. Tools Databases: Oracle 10g, Oracle BI Discoverer 10g Release2 , Discoverer 10g PLUS VIEWER. Sr. Oracle Applications Developer/Analyst Confidential - Working on creating/implementing End User Layer Business Area's, Folders, Complex Workbooks for Order Management, Supply Chain Management SCM Account Receivable AR 11i modules for Business user's community. Also performed Discoverer administration responsibility for OMAR IT group.
- Designed and developed custom oracle reports/forms OM,AR,SCM,QP SHIPPING modules , conversions from 10.7,11.5.7 to 11.5.10. forms/reports/API .Worked on warehouse builder to create Star Schema and designed cubes for BI reports.
Environment: Oracle apps 11.5.10 ,forms report 6i , Discoverer 10g Administration, PLUS,VIEWER ,interfaces PL/SQL Confidential Crystal Enterprise and Siebel Analytics 7.5 Reports Developer Confidential Designed, Developed Deployed Crystal and Siebel Analytic ad-hoc Reports for Enterprise Data Warehouse for Corporate Apollo Group. Designed and developed BI repository ROLAP model for Students Financial Management System. Designed and created Students financial performance status ad-hoc web based reports for finance department . Designed, developed and automated , Business Development Specialists BDS Enrollment Counselor reports by extracting the data from Galaxy ODS Osiris systems SQL SERVIER ORACLE according to the rankings established in the business rules for TSR project. Crystal Enterprise 10 BOXI Administration Performed ETL jobs from source to warehouse. Design developed BO universes and reports. Environment: Oracle 9i database, SQL SERVER2000,PL/SQL developer, Crystal Report 10,11 , Siebel Analytics 7.5 ,ETL Datastage, Crystal Enterprise 10, BOXI . Confidential Oracle Consultant - Working currently on customized AP/GL load PL/SQL package.
- Upgrading oracle reports 2.5 and forms 4.5 to web reports to 6i for AP, PO, GL, PA AR modules.
- Worked on custom forms and API's.
- Designed and developed EUL, BA's , Folders workbooks for Business Users.
Environment: Oracle 9i database, Developer 6i Forms Reports , Discoverer 9i and Admin tool, Oracle Applications 11i 11.5. 8 , Unix, TOAD. Confidential Oracle Consultant - Designed automated WIS/EDM data conversion/migration pl/sql procedures, triggers packages from AS400 Sybase to Oracle tables.
- Designed ,automated developed inspection reports in crystal 9.0 and BO 5.1 reports for inspectors.
Environment: Oracle 8i database, PL/SQL TOAD,BO Reports, Universes, Crystal Report 9.0,Crystal Enterprise 9. Confidential Oracle Consultant - Designed developed EUL, business areas, workbooks, manage user access control, implemented ad-hoc reports for data mart using discoverer 4i.
- Designed and developed pre-defined reports 6I for data mart General Ledger History for different countries.
Environment: Oracle 8i database, Oracle Applications 11.5.8, Oracle 9IAS discoverer release1, Developer 6i Forms Reports , PL/SQL and SQL Navigator. Confidential Oracle Consultant - Developed business areas, work books, implemented ad-hoc reports oracle discoverer 9iAs Rel2 and uploaded to Microsoft xl spread required by concerned business users.
- Integrated oracle reports 9iDS to oracle portal 9iAs Rel2 .
- Designed and coded general database provider portlets, which are used for portal integration.
Environment: Oracle 9i database, Oracle Applications 11.5.8, Oracle 9I discoverer release2, Developer 6i Forms Reports , Discoverer 9i , PL/SQL Web tool kit, Unix, Windows XP and SQL Navigator. Confidential Oracle Consultant - Worked on data conversion implemented interfaces by using third party tool TAVIZ PL/SQL for AP, GL and Order Management, Inventory modules.
- Worked with business and accounting users to formulate business requirements with frequent interactions.
- Converted custom forms 4.5 to 6i and integrated with sub ledger.
- Involved in user meetings for Gap Analysis and legacy field mapping.
- Prepared technical specificationsb and build custom forms report 6i for different modules like AP, AR, FA and order management modules.
- Also designed , developed and administered EUL, users security , ad-hoc reports for invoice sales order details Discoverer9i to analyze support decision making for higher management.
- Able to manage sys admin responsibilities like control the concurrent manager, Register Printers, manage responsibilities, users and deploying forms, reports programs into different environments.
- Able to manage concurrent requests.
Environment: Oracle 8i database, Oracle Applications 11.5.8, Discoverer 9i, Oracle 9IAS release2, Developer 6i Forms Reports , PL/SQL, Unix, Windows XP and SQL Navigator and PVCS version control. ACS, Phoenix, AZ Confidential - Designed and implemented security application at various levels like form, menu and items based on user roles.
- Developed and deployed online fuel tax return web forms and reports in Oracle 9iAS environment for Arkansas and Michigan.
- Involved in data conversion from Access database to Oracle 8i.
Environment: Oracle 9iAS, Oracle8i, Developer 6i Forms , Crystal Reports 8.0 PL/SQL, Windows2000, HP Unix. Confidential - Customized, designed and registered in Application Object Library AOL for Account Receivable, Order Management /Inventory modules for web based Oracle 11i implementation.
- Implemented custom Vendor Interface API to load Vendor information into Oracle tables.
- Prepared technical specifications and build customized forms report 6i for different modules like AP, AR, FA and Order Management modules.
- Customized Oracle Workflow for credit card status checks.
- Developed ad-hoc reports, which are very much required by higher management for business analysis.
- Upgraded forms reports 4.5,2.5 to 6i.
- Able to manage sys admin responsibilities like control the concurrent manager, Register Printers, manage responsibilities, users and deploying forms, reports programs into different environments.
Environment: Oracle Applications 11.5, Oracle 8i, Discoverer 9iAS, Oracle 9iAS, Developer 6i Forms and Reports , PL/SQL, Unix and PVCS version control. Sr. Consultant - Confidential Confidential Program Management Portal - Designed and developed Bug and Tar batch reports for daily, weekly and monthly for higher management and integrated with Oracle Program Management Portal by using PDK.
- Involved in development of online web forms, which are required for METALINK web publishing.
- Involved in installations, upgrades, patching for Oracle 11i CRM and ERP applications modules.
Environment: Oracle 9i, Oracle 9iAS Portal, Forms9i, Report9i and Graphics, Unix Shell Scripts, Portal Development Kit PDK , WEB PL/SQL web tool kit , Java, Unix Confidential - Worked on Open Requisition Interface API to load requisition information into Oracle tables from Legacy system.
- Prepared conversion scope, objectives and approach, conversion strategy, conversion data mapping, design.
- Created SQL Loader scripts to validate and load legacy data using standard APIs, Extract and clean legacy data.
- Customized standard P.O. report by using developer 6i.
Environment: Oracle Apps 11i, Forms 6i, PL/SQL, Oracle 8i, Unix, Windows NT Confidential Student Financial Assistance SFA - Involved in technical implementation for projects Voluntary Flexible Agreement VFA for Guaranty Agencies and integrated with main module Student Financial Assistance SFA Financial Management System FMS .
- Involved in user meetings for Gap Analysis and legacy field mapping.
- Involved in migration/conversion from Developer 2000 Forms, Reports to Developer 6i. Customized Forms 6i and Reports 6i, Oracle 8i with three-tier architecture.
- Responsible for Oracle Workflow approval business process, developed ad hoc reports by Discoverer 3i, AP-GL interface API , custom forms integrating/register with Apps, creating VFA schema, custom library, AOL and interface tables with AP and GL tables.
- Coordinated with Oracle support and development to resolve application issues.
- Involved in conversions and upgrades.
Environment: Oracle Apps 11i, Forms6i, Reports 6i, Discoverer 4i, PL/SQL, HP Unix, Windows2000 Order Management System OMS - Designed and developed End of Order Edits EOE and Admin web forms, reports, menus and templates, integrated with UUNET portal.
- Provided production support.
Environment: Oracle 8i, OAS, Web PL/SQL Web tool kit , Portal-to-go 3.0, Sun Unix, Windows NT ADSL 11i Project Implementation Confidential - Involved in Call Center Applications 11i Advanced Inbound, Outbound implementation, sales service modules, Oracle Scripting 11i for order capture, Oracle 11i iStore for shopping cart, system and integration testing and production support.
Environment: CRM 11i Apps, Scripting, Java, JDeveloper 3.x, JSP, Servlets, PL/SQL, Oracle 8i, FORMS REPORTS 6i, Windows2000, HP Unix Confidential - Involved in automatic, managed and approved Purchase Order business process reviewed and evaluated Purchase Order information.
- Worked on custom Forms and Reports, register/integrate with Oracle Apps 11i custom library, AOL.
- Prepared conversion scope, conversion strategy, conversion data mapping. Designed and create SQL Loader Scripts to load data from legacy system to Oracle Apps 11i database.
Environment: Oracle Apps 11i, Forms 6i, Reports 6i, PL/SQL, SQL Loader, Oracle 8i, Windows NT, Unix Confidential Order Management Systems - Involved in implementation of web based Order Management System OMS in Oracle Apps 11i for order entry, shipping execution, pricing.
- Customized front end order entry web forms, developed and integrated with custom library.
- Prepared development strategy and customized scope and strategy.
- Worked on backend customized workflow business processes like order tracking status, sending notifications, purging workflow status information, order management order process API, interfaces.
- Prepared technical specifications and build customized forms report for order entry, pricing screens according to customer requirements.
Environment: Oracle Apps 11i, OAS, Web PL/SQL Web tool kit , Oracle Workflow, WebDb, Oracle 8i, Windows NT, HP Unix Undersea Network Administration Database Confidential - Worked on requirement analysis and documented database info with Designer 2000.
- Developed web reports, designed and developed API's to communicate with external systems and performed end-to-end system integration testing.
- Designed and developer customer forms and report by using Developer/2000.
Environment: Designer 2000 2.1, HTML, JavaScript, PL/SQL, Reports3.0, Oracle 7.3, WindowsNT4.0 Confidential - Worked on designing and generating web forms and customized forms according to company requirements using Designer 2000 option with forms generation.
Environment: Designer 2000 Web Server generation 4.0/3.0, PL/SQL, Oracle, WindowsNT DOD Project Confidential - Worked on reports that are useful for tracking availability of conference rooms by dates and video equipment details at different locations around country.
- Involved in development of report and SQL optimization.
Environment: Developer 2000 Reports2.5 , PL/SQL, Oracle 7.3.2, Windows NT, Unix Confidential Visa Fleet Card System - Involved for database tuning for stored procedure, Pro C programs and Shell Scripts.
Environment: Proc C, shell script, Oracle, WindowsNT, Unix Confidential Payroll System - Designed and developed various ER diagrams, function-hierarchy diagrams data flow diagrams.
- Performed coding that involved PL/SQL programming i.e. stored procedures, Pro C, functions, packages, cursors and triggers with PL/SQL.
Environment: PL/SQL, Pro C, Oracle, Windows NT, Unix Confidential Financial Control System - Designed and developed various ER diagrams, function-hierarchy diagrams data flow diagrams.
- Designed and developed front-end screens using Developer 2000.
Environment: Developer 2000, Oracle, Windows NT4.0 |
Privacy Policy
