PROFESSIONAL SUMMARY:

• Around 8 Years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Expertise in full life cycle Business Intelligence implementations and have an understand of all aspects of an implementation project using OBIEE 12.1.1.x
• Experience in Installation, Configuration, and Administration of Oracle BI Apps 7.9.6.3, OBIEE 11.1.1.7 / 10.1.3.4.1, Oracle Data Integrator, DAC 10.1.3.4.1 / 7.9
• Highly skilled with Caching & Mapping, data - level and object-level security, MUD, Integration Variables/Initialization Blocks configuration
• Experience in Installation and Configuration of OBIA (including ODI, DAC and OBIEE) Out of the Box Reports
• Extensive Experience in working with OBIEE 11g, Enterprise manager Fusion Middleware, .RPD (Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the Oracle BI Administration ) and Web catalog
• Created new models for the data sources - flat files, MS SQL server, Oracle
• Have good understanding of Tableau architecture, design, development, and end user experience
• Extensive knowledge in various reporting objects are Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB
• Have experience in data Extraction, Loading and Transformation in data warehouse environment (ODI)
• Worked on ODI designer, Topology, Operator and ODI Tools
• Worked on end to end implementation of BI APPS in various domains such as Marketing Analytics including (OBIEE, ODI and DAC) and OBIEE
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflakes modeling, Fact and Dimension tables modeling of data
• Expertise in design and development of three layers (Physical, Business model and Presentation) of an OBI Metadata Repository using Oracle BI Administration tool
• Hands on experience in gathering business requirements and creating functional and technical requirement specification documents
• ETL experience using Oracle Data Integrator (Source Analyzer, Data Warehousing Designer, Mapping Designer - data transformation and mapping issues, Mapplets, Transformations)
• Experience and strong Working knowledge with Oracle EBSr12 and People soft modules of Financial Analytics, Procurement and Spend Analytics, Sales Analytics, Project Analytics, Marketing Analytics, HR Analytics, HCM Analytics, and Supply Chain modules

TECHNICAL SKILLS:

Reporting Tools: OBIEE 12.2.2.0.0, 11.1.1.7 / 11.1.1. x, Oracle Apex, Tableau 9.X

ETL Tools: ODI v.11.1.2.4/v.10.1.3.4, DAC, Informatica

RDBMS: Oracle 12c/11g /10g/ 9i, SQL Server, Oracle EBS, MS Access, Teradata Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Bay Area, CA

OBI Cloud Developer/ Admin

Responsibilities:

• Work with business users to understand the needs and define the requirements, including report definition, conversion and data cleansing rules, design changes to screens and reports, develops user system documentation and provides appropriate user documentation
• Design and Develop Reports using OBI Cloud Services and OBIEE tool.
• Migrating the reports from OBI Discoverer tool and BI Publisher reports to OBI Cloud Service (BICS) and then taking care of the Production migration (Catalog and RPD migration)
• Create/modifying Metadata repository using the OBIEE Admin Tool 12's Physical, Business Model and Mapping and Presentation Layers.
• Deploying the MUDE rpd/replacing the data model in Console and migrating the reports, dashboards, prompts, filters from Dev to Test, Stage and Production instances.
• Managing the user roles and group responsibilities in BICS and Oracle Apex.
• Creating the technical design specifications, developing analytical reports, troubleshoot, and resolve technical issues, debug, tune and optimize report performance
• Re - modeling the existing Tables, Views structure in data mart to improve the performance of the BICS report by using PL/SQL. (PS Query, OBIEE, BI Publisher Discoverer Reports Remodeling and, Rebuilt in BICS to improve report performance)
• Migrating the OBI reports (Which the report has >65K rows) to Oracle Apex environment and Support
• Used the Oracle EBS tables (General Ledger, Account Payables, Account Receivables, Fixed Assets, Purchasing (PO), Inventory (INV) and Order Management (OM) modules etc.) in Target database and build the reports in OBI Cloud.
• Decoding the existing PL/SQL functions, procedures and packages and replacing the structure with Views to improve the performance of the query (Performance Tuning).
• Tuning the OBIEE Reports and designed Query Caching and Data Caching for Performance Gains
• Debugging the report issues or database issues creating interactive UI Design (Dashboard Indexes) including experience in User Interface Design using CSS, HTML, XML and Java Scripts.
• Proficient in PL/SQL programming -- Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects -- Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types
• Post implementation and, Production environment support
• Involved in customizing Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards.
• Identifying issues, action resolutions, and providing technical assistance for complex problems
• Effectively communicating with peers, developers, analysts, project managers, quality control, and across other technology team boundaries
• Evaluation and documentation of existing data. Gathering and documenting the technical and business meta data about the data as well as providing insight into the data itself
• Works in conjunction with System Administrators for migration, deployment and performance tuning of repositories

Environment: OBIEE 12.2.2.0.0, 11.1.1.7, Oracle Apex 5.1.0.00.45, OBI Discoverer 10.1.2.55.26, Oracle EBS, SQL Developer (Oracle IDE 4.1.5.21), PL/SQL, Windows 7.

Confidential, Atlanta, GA

Sr. OBIEE Architect/ Developer

Responsibilities:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Experience with Oracle Business Intelligence Enterprise Edition 11.1.1.7
• Worked closely with Business, Developers, and Administrator to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository
• Performed full repository and web catalog merge
• Worked towards the Performance Tuning of Dashboards including creating aggregate tables, caching and Reports with Business Analysts and DBAs
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts
• Coordinated the OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE)
• Expertise in creating various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes
• Extensively used repository and presentation variables
• Created Initialization blocks , Repository Variables and Session variables for Data level and User level security
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs
• Experienced in custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements
• Managed security privileges for each subject area and dashboards according to the user requirements
• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in different ways
• Built prototype reports from excel spreadsheets during the requirement - gathering phase to visualize the reports and clarify requirements

Environment: OBIEE 11.1.1.7, Oracle 11g, SQL Developer, Teradata developer, PL/SQL, Windows 7, HTML, CSS.

Confidential, Bridgewater, NJ

Sr. OBIEE Lead/ Tableau Developer

Responsibilities:

• Preparation of Functional Design documents
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool
• Architected and Implemented ETL routines using ODI
• Worked on migrating all the mappings from Hyperion to OBIEE
• Migrated the packages, scenarios from one repository to another repository
• Customized ODI inbuilt KM (Knowledge Modules) to build Interfaces for complex data requirements
• Created different visualizations by using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables using Tableau
• Involved in creating data blending in case of merging different sources
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI s) for the top management.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non - geographic data.
• Involved in Performance tuning of queries
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard
• Developed several mappings to load data from multiple sources to data warehouse
• Coordinated the Analytics RPD and Web Catalog objects migration from DEV environment to QA environment and to the Production environment
• Involved in designing the dimensional model and suggested as per the reporting requirements
• Unit testing the reports, debugging, and fixing the errors for right reports
• End to End testing of Reports for data and functional behavior
• Involved in customizing Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards. The tables like W AP BALANCE F, W AR BALANCE F, W GL ACCOUNT D were customized as per user requirements
• Managed Security in Admin Tool like Data level and Object level
• Providing support and fixing issues related to Data on Reports, Dashboards
• Proficient in PL/SQL programming -- Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects -- Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning
• Involved in preparing the TDD s, UDD s and Impact analysis document

Environment: OBIEE 11.1.1.7, OBIA Finance 7.9.6.4, Tableau Desktop 9.0, DAC 7.9.6, ODI 11.1.1.7, Oracle EBS, Windows Server, SQL Developer, Oracle 12c/11g.

Confidential, Atlanta

BI Developer

Responsibilities:

• Work with business users to understand the needs and define the requirements, including report definition, conversion and data cleansing rules, design changes to screens and reports, develops user system documentation and provides appropriate user documentation
• Perform business analyst functions to develop and maintain online reporting to support the data and information needs of internal customers
• Provide technical knowledge to the design and implementation of the enterprise wide business intelligence solutions
• Involved in creating KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each member, zone, region and nationally to gauge system performance using the Tableau
• Create technical design specifications, developing analytical reports, troubleshoot, and resolve technical issues, debug, tune and optimize report performance
• Responsible for setting up ODI in all the environments (DEV, UAT and PROD) which includes all the tasks from Installing and configuring ODI to releasing the environment to users (assigning security, client installations and other related tasks)
• Responsible for setting up/administering source and target connections in ODI
• Responsible for scheduling the Scenarios to execute in serial/parallel modes to meet the data load requirement
• Monitor the scheduled ODI jobs in PROD and apply fixes for failed ones
• Huge experience in fine-tuning complex ODI processes for better performance
• Migrate the ODI scenarios across different environments (from Dev to UAT and then to Prod) using PPM packages
• Experience in customizing ODI Knowledge Modules
• Develop reports, dashboards, and supporting our client's Intelligence platforms and applications
• Working Extensively with Physical Layer, Business Layer and Presentation Layer using OBI Administration Tool
• Developing Reports / Dashboards with different Analytic Views (Drill-Down / Dynamic, criteria filters, Prompts, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle BI Analytics Web / Oracle BI Presentation Services
• Created business reports using global and local filters with BI Analytic as per client requirement.
• Worked on designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences, and triggers using Oracle PL/SQL
• Developed data model, SQL Queries, SQL Query tuning process and Schemas
• Worked closely with the business users to identify various KPI's

Environment: OBIEE 11.1.1.5, OBIA Finance and HR 7.9.5, DAC 7.9.x, ODI, Tableau Desktop 8.X, Windows 2003 Server, SQL Developer, Toad, PL/SQL, Oracle 11g.

Confidential

Jr ETL Developer /SQL Developer

Responsibilities:

• Create the Source to Target Mapping Document, which also lists the transformation rules. Developed Informatica mappings and change detection procedures and also tuned mappings for improving performance
• Responsible for developing extraction /transformation /load (ETL) software, using INFORMATICA
• Mapping design
• Loading facts and dimensions from source to target data mart
• Creation, configuring, scheduling and running of Sessions and Batches
• Configuring Event Based scheduling using Indicator files
• Testing and maintaining of Informatica mappings
• Creating the tables, views and Synonyms in Data Mart
• Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures, functions
• Implemented Record Insert, Record update and also used Insert All to load the data into multiple tables
• Created the Shell scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders

Environment: Informatica Power Center 9.0, Windows, Oracle 10g, SQL Developer , PL/SQL.