PROFESSIONAL SUMMARY:

• 16+ years extensive experience in IT field
• 14+ year experience with Oracle technologies including OBIEE, Hyperion Interactive reporting and eBusiness Suite
• 8+ year experience in OBIEE development and administration
• 10+ year experience with Oracle Applications / E - Business Suite - performing functional and technical work with Financials (General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Cash Management), Supply Chain (Purchasing, Inventory, Order Management) and Oracle Process Manufacturing for ERP (Enterprise Resource Planning)
• Certified OBIEE Consultant
• Received OBIEE RPD 12c development training by Oracle Corporation
• Certified Oracle eBusiness Suite consultant (General Ledger, Purchasing)
• Expertise in defining OBIEE repository, creating Physical through Business Model and Presentation Layers, creating hierarchies, implementing data security
• Development and configuration of OBIEE components, including Dashboards, Analysis, Prompts, BI Publisher reports, Agents (iBots), Guided Analytics, Contextual Navigation
• Administrating OBIEE environment by setting up security (groups and privileges), setting up object level user security, Active Directory authentication
• Experience working in different set of clients including FMCG, Law enforcing institutes, Education sector, Public service organizations
• Administrating day-to-day OBIEE tasks, keeping system healthy and up to mark, performing upgrades and patching
• Experience in creating BI Data Lineage reporting, developed utility to extract catalog and repository metadata and transform to BI dashboards
• Experience in developing BI Publisher reports, creating dynamic data models, templates and sub-templates, adding bursting
• Experience in developing and administration of Mobile interfaces (MAD)
• Integrating OBIEE 11.1.1.9 with Teradata V.15 and transforming repository/catalog objects to work with the robust database
• Query optimization in Teradata using explain plan, identifying the problem areas including long running AMP operations, queries with No or low Confidence, missing data Stats and spooling operations
• EBS Functional Responsibilities: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users and post implementation production support
• EBS Technical Responsibilities (technical lead, developer etc.): interfacing with users, identifying technical and functional gap, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling and producing documentation. Worked on Bill of Materials (BOM), Work in Process (WIP), Financial Statement Generator (FSG), Procure to Pay (P2P), and Order to Cash (O2C) cycles/processes.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 11g/12c, Oracle Data IntegratorDatabase: Teradata V.15, Oracle8i/9i/10g/11g, SQL Server 2000/2005

Database Tools: TOAD, SQL Developer, MySQL, Teradata SQL Assistant

ERP Packages: Oracle eBusiness Suite (certified consultant)

Operating Systems: UNIX, LINUX, Windows 95/NT/XP/2007/2010

Programming Languages: C, C++, SQL, PL/SQL, Shell scripts, PHP, HTML, XML, Visual Basic

Reporting tools: OBIEE, Hyperion Interactive Reporting, Crystal Reports, Oracle Report Builder

Data Modeling Tools:: ERWIN, Microsoft Visio

EXPERIENCE:

Confidential

OBIEE/Hyperion IR Consultant

Responsibilities:

• Involved in OBIEE11g upgrade to version 11.1.1.9 and then to 12c (12.2.1)
• Integrated OBIEE with Teradata V.15 and transformed repository (RPD) and catalog objects by replacing oracle native functions with Teradata specific changes
• Setting up OBIEE environment to use Teradata capabilities in more efficient way by setting RPD database parameters
• Involved in Multiuser development set up by creating different projects
• Created data lineage utility to extract metadata for repository, catalog objects (dashboards, analysis, agents etc.), catalog ACL (system-jazn-data.xml) and developed management dashboards
• Designed migration utility to automate catalog and repository migration between environments as part of production releases which reads different set of input files, keeps backup of existing components, creates log files, setup catalog object security
• Defined best practice report/dashboard development approach
• Managed OBIEE WebLogic and Enterprise Manager
• Developed robust BI Publisher reporting process where one data model and template transforms into different reports, along with WriteBack functionality to users, where user can switch between subTemplates, define titles for data elements (columns, rows) and set custom properties (header and footers)
• Created complex repository using more than one databases including Oracle 11g and Teradata V15
• Defined hierarchies both level based and parent-child for data element
• Created presentation variables, repository variables, session variables and initialization blocks to get dynamic content in reports and dashboards
• Created OBIEE dashboards in different business areas including Sales, Finance, Manufacturing, Supply and Planning
• Setup Mobile Application Development (MAD) environment and Created various dashboards
• Administration of Hyperion IR servers, setting up securities, creating jobs
• Developed Hyperion Reports in Sales and Manufacturing business area
• Transformed Hyperion IR reports to OBIEE dashboards before retiring the product at client

Environment: BIEE 11g/12c, Hyperion Interactive Reporting 11, Hyperion Planning, Oracle11g, Oracle BI Administration tool, Teradata V.15

Confidential

OBIEE Consultant

Responsibilities:

• Involved in every OBIEE project from initial design phase through production implementation release. Duties include requirement gathering, design, development, testing and release
• Developed all layers (Physical, Business and Presentation) of the OBIEE repository from the startup as per business requirements
• Worked with OBIEE Answers, Intelligence Dashboards and OBI Publisher reports. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager
• Created numerous reports and dashboards with drill down and navigation capabilities.
• Administered the entire OBIEE application. Implemented LDAP security, managed access to the reports through roles and permissions.
• Developed tuning process for the longest running mappings by turning them to SQL procedures for quicker run times.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Expertise in performing code migrations between the environments, document issues and fixes.
• Worked in Catalog Manager to migrate Answers objects and Dashboards between the tiers.
• Created several BI Publisher reports and developed standard RTF templates.
• Wrote stored procedures and functions for user authorization and report filtering purposes.
• Trained all the team members on creating OBIEE Answers reports, Dashboards and OBI publisher reports.
• Involved in end user training of OBIEE Dashboards

Environment: OBIEE 11.1.7/9, Oracle 11g, Oracle SQL developer, Toad, Windows 7

Confidential

OBIEE Consultant

Responsibilities:

• Designing and developing physical and logical star schema using OBIEE admin tool.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Creating global filters, complex queries, prompts, reports (charts, tables, graphs) in Answers.
• Setup and administered Usage Tracking using the direct insert process.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Configured repository and session variables to get dynamic reports and dashboards.
• Good working knowledge of Trader, Broker, and Mutual fund tables.
• Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• 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.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures

Environment: OBIEE 10g/11g, Oracle 10g/11g, SQL Server 2005

Confidential

Oracle EBS/OBIEE Team Lead

Responsibilities:

• Performed gap analysis and feasibility study for the given requirement.
• Created mockup reports and dashboards for review by the business users.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Created materialized views and aggregates to improve performance.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down
• Created user level security for intelligence dashboards based on Business Requirement.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.

Environment: OBIEE 11g, SQL Server 2005, Linux, Windows XP

Confidential

Senior BI Developer

Responsibilities:

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Analyze, Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer
• Worked on oracle 11g database, used 11g's usage tracking to keep updated of all the ongoing processes.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Trouble shooting the issues related to repository models and report development.
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Administered the Cache parameters and implementing the cache feature for improving the BI Server performance
• Create users and groups and assigning the security privileges.

Environment: OBIEE 10.1.3.4, Oracle 10g, SQL, Informatica

Confidential

OBIEE Developer

Responsibilities:

• Gathered requirements, documented and delivered functional specification documents and configured CRM to meet requirement.
• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Design and implement ODI Extract, Load and Transform (ELT) processes, programs and scripts.
• Design of data warehouse tables, including source to target mappings, configuration of ODI knowledge modules etc.
• Develop and document the ODI ELT process. Help in Creation and maintenance of the source to Client data mappings.
• Extracted data from different sources like Oracle Tables, views and flat files, Hyperion implemented Business logic and loaded into target warehouse (Oracle).
• Experience in ODI designer, Topology, Operator, Master repository and work repository creation.
• Prepared detailed design for the ELT & PLSQL part of the system
• Worked in Interface creation, Packages, Scenarios, Variables, Sequences, Procedures and User Functions in ODI.
• Worked for different concepts like pivoting and parallel job execution in ODI.
• Involved in Performance tuning for the jobs in ODI.
• Scheduling jobs and load balancing in ODI.
• Created different schemas in database using oracle 11g to configure the different objects implementation.
• Worked in SCD TYPE1, TYPE 2 and Confidential implementation.
• Performed OBIEE System Administration Tasks like Configuration of system for deployment, Security privileges like Object level & Data level, Starting and Stopping services, managing and resolving services, migration of rpd and web catalog from test to production, backing up metadata.
• Worked on OBIEE Object Level Security by creating users, Groups & Roles

Environment: OBIEE 10g, Oracle Database 10 G, Windows XP

Confidential

Oracle EBS Consultant

Responsibilities:

• Techno-functional consultancy and user trainings
• Oracle ERP system administration, responsibilities assignment and controlling access
• Monitoring and modification of oracle workflow
• Customization of OAF pages and extension
• Developed customized application as a replacement of Financial Statement Generator (oracle standard functionality), to meet day to day changing in business requirements
• Designing, development and embedding Gate Control system with Oracle EBS
• Integration of Gate Control System with oracle Inventory using Oracle API
• Use of APIs to create new inventory items from within customized Gate Control System
• Controlling purchase orders on basis of quantity received through customized solution
• Workflow customizations in Purchasing for auto approval of purchase orders with specific conditions
• Customization of Accounts Payables, restricting payments against invoices on user defined criteria and adding exceptions whenever required
• Creation and implementation of flexfields for Payables, General Ledger, Receivables and Purchasing
• Customized reports development in Financials

Environment: Oracle EBS R11, Oracle Developers 6i/10g, Oracle PL/SQL, TOAD for Oracle

­­

Confidential

System Analyst/Programmer

Responsibilities:

• Developed Point of Sale system in visual basic providing with facility of capturing barcode data
• Analyze and designed Inventory module
• Analyze, design and developed Purchasing application with multilevel approvals for documents on required scenarios
• User training at client environment

Environment: Visual Basic 6, MS. SQL Server, Crystal Reports