PROFESSIONAL SUMMARY:

• 7+ years of Business Intelligence and reporting experience in working with OBIEE 11g/10g/10.1.3.x / Oracle Business Intelligence Apps (BI Apps)
• Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using ETL and Reporting tools like Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), Informatica and OBIEE 11g/10g/10.1.3.x.
• Expertise in Business Intelligence Applications using Oracle Business Intelligence (OBIEE/OBIA) in Marketing, Sales, Procurement modules.
• Extensive experience in Design, Development, Implementation and Support using Oracle SOA/OSB/BPEL/B2B/AIA
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
• Expert in domain services like Oracle Service Bus (OSB), Service Oriented Architecture (SOA), Business Process Execution Language (BPEL) and with message oriented middleware 
• Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience
• Strong experience in BI Admin tool, OBIEE Web Catalog and application/object security, working knowledge of Web - Logic Server and Architecture.
• Experience in deploying BPEL, OSB services on WEB Logic Server and maintenance. 
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security
• Have good knowledge in Oracle Business Intelligence Applications (OBIA), WebLogic server architecture (WLS), administration activities using administration console and enterprise manager (EM). 
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Experience in creating entity relational & dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema.
• Experience in creating and understanding Use Case Specifications and UML diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams, Data Flow Diagrams, and Flow Chart Diagram using Rational Rose and MS Visio.
• Configured OBIEE presentation layer with reporting capabilities like Visual Analysis, Drill-Down, Ad-hoc, Multi- Dimensional, Slice/Dice, Alerts, Graphs and Guided Analytics. 
• Experienced in Installation, Configuration, Upgradation, Migration and Administration of Informatica Power Center/Power Mart and ODI.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load).
• Conversant in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
• Expertise in ETL methodology in Data Extraction, Transformation and Loading using ODI and Tableau.
• Independently managed, organized and prioritized multiple tasks and responsibilities.
• Experienced in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Responsible for production and non-production BI support services and processes.
• Defined and managed the work plan, schedule, budget, and required managed service personnel for continued support of applications and systems
• Strong aptitude for learning and understanding business process and needs.
• Exceptional leadership, written and oral communication, and meeting facilitation skills
• Excellent Team Management Skills with good business acumen, effective communicator, experience in working with Business Users and Senior Managers and Executives.

TECHNICAL EXPERTISE:

ETL tools: ODI, Informatica Power Mart, Informatica Power Center 9.x/8.x/7.x/6.x, Tableau

Business modeling Tools:  IBM-Rational Requisite Pro, IBM-Rational Rose, MS Visio, SmartDraw, Unified Modeling Language (UML)

Methodologies:  Software Development Life Cycle (SDLC), Agile methodologies including Extreme Programming (XP), Rational Unified Process (RUP)

Languages: SQL, PL/SQL, HTML, C, C++

Web Servers: Apache, IBM Web Sphere, Web Logic, and IIS.

RDBMS: Oracle11g/10G/9i/8i/8.0/7.x, MS SQL SERVER 2008/2005,TOAD, PLSQL.

OS: Windows 95/98/2000/XP, UNIX, Linux

Confidential, New Jersey

Sr. OBIEE Developer/ ODI Developer

Key Responsibilities:

• Project data deliverables include gathering of data requirements, data flow diagrams, data sourcing plans, data privacy/security architecture, data integration specifications, design, development, testing, status updates and implementation.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Involved in transformation project of reports from OBIEE to Tableau, performed full repository and web catalog merge.
• Imported Supply chain data (Consumer products; Health care systems - Pharma Data) into Tableau to perform data manipulations, data analytics by creating calculated fields, parameters and generated reports.
• Generated Tableau dashboards, writing complex SQL queries on Hive/Impala and worked on transforming project reports from other tools to Tableau.
• Built, published customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Involved in business requirement gatherings to design and develop enterprise integration solution for trucking application and back end systems, using OSB and complex business orchestration flows using BPEL. 
• Created Repositories, Physical Layer, Business Model and Mapping Layer and Presentation Layer using ODI Administration Tool.
• Ensured all services related processes are followed and provide improvement suggestions for streamlining and/or new process for improving service delivery
• Created ODI (Data Integration) design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages 
• Designed, developed ODI (Oracle Data Integrator) (Data Integration) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources. 
• Designed a data integration workflow design that provides for the extracting, loading and transforming of data, primarily for compliance reporting and analytics using Oracle ODI
• Installed and configured ODI for full loads and Incremental loads daily.
• Customized ODI mappings in OBIAPS according to the client requirement.
• Migrating Repository and Web Catalog files from Development to Test and Production environment.
• Participated in the walkthroughs of the data models, ETL specifications, identification of dimensional attributes Facts and Star Schema to fulfill requirements.
• Involved in merging changes of OBIEE Repository and Web Cat from Development to Test and Production.
• Involved in Unit Testing of Reports and performance tuning of queries.
• Migrating Repository and WebCat files from Development to Test and Production environment.
• Co-ordinated Steering Committee Meetings and Project Governance Meetings
• Worked in a collaborative environment to support rapid development and delivery of highly demanding projects

Environment: ODI (Oracle Data Integrator) 11g/10g (11.1.1.6/10.1.3.5)Tableau Desktop 10.1/9.2/9.3, Tableau server / Administrator, Hyperion IR, OBIEE, Oracle SQL developer, Oracle SOA Suite 12g, Oracle EBS, OSB, Hive/Impala, SAP and Databases: Hive/Impala, Oracle.

Confidential, Massachusetts

OBIEE/ODI Developer

Key Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document
• Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Created business reports using BI Answers as per requirements.
• Generated various Analytics Reports using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.
• Hands on experience on working with ODI Knowledge Modules like, Golden gate knowledge module LKM, IKM and JKM, CKM
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Relational Database Management servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security) 
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Monitoring Incremental & Full load through DAC.
• Trained End Users and Pilot Users about OBIEE Tools.
• Managed and reported managed services team allocations and status
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS.

Environment: OBIEE 11g, BI Apps 7.9.6.3, Web Logic Server, ODI 12C Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.

Confidential, California

OBIEE/ODI /ETL Developer

Key Responsibilities: 

• Used Oracle Data Integrator(ODI) for Extraction, Loading and Transformation. 
• Created data servers related to specific technologies and mapped with and physical and logical architectures.
• Created various mappings from source to target using Topology and Designer Navigator. 
• Extensively used various knowledge modules such as Loading Knowledge Module, Integration Knowledge Module and Journalizing Knowledge Module for loading data into staging and target areas as well as to main data consistency. 
• Created ODI Packages to improve inter-application dialog by having interfaces executed asynchronously. 
• Designed logical Data model based on source system tables. 
• Involved in migration from development phase to system integration testing. 
• Experience in Failure analysis for ODI loads using Operator logs. 
• Defined and implemented processes for supporting and managing BI technologies and applications
• Involved in full life cycle implementation of Financial and Supply Chain Analytics including installation, configuration, extension and customization. 
• Developed Different Reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services. 
• Configured Scheduler by creating Scheduler tables in database. 
• Perform daily Production Support recurring tasks and monitoring of the tickets queue, assign tickets, resolve tickets and update root cause and remediation. 
• Developed Logical Columns in Business Model Layer based on Business Requirements by using Time Series Objects and business logic's, and creating the Presentation Catalogs in Presentation Layer. 
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys. 
• Designed and executed unit test cases and debugged mappings successfully.
•  Ensured the readiness and effectiveness of the managed services support team.

Environment: ODI 12c, OBIEE 11g, Oracle11g, WebLogic 10.3.6., Linux, Oracle SOA Suite 11g

Confidential, New Jersey

OBIEE/OSB Developer

Key Responsibilities:

• Full project life cycle implementation for Business Analytics Warehouse.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Implemented REST Web Services in OSB to Interact with Third Party API's to Insert/Delete/Update/Get Data from Those Systems. 
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services
• Implemented schema validation at OSB proxy level using Validate action and reported back error to client.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Worked on Jenkins, Config plans and Customization files in SOA and OSB to Deploy Projects from Dev Environment to higher Environments like UAT and PROD.
• Created new requests and opened Answers for adhoc reporting to the End users
• 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.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Documented all the configurations and new reports creation and published it to the end users.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.
• Ensured adherence to Quality assurance processes.

Environment: Oracle SOA Suite11g(BPEL)/12C, Siebel Analytics 7.8.4, BI Apps 7.8.4, Informatica 7.1, Oracle 10g/9i, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP. 

Confidential

ETL Developer

Key Responsibilities:

• Installed and configured Informatica Server and Power Mart.
• Created Repository, Folders, and User accounts using Power Mart Repository Manager.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Designed and developed mappings using Power Mart Designer.
• Used all Transformations such as Expression, Filter, Joiner, aggregator, Lookup and Router, to load consistent data into Warehouse Database.
• Used Server Manager to create database connections, sessions to run the mappings.
• Wrapped the sessions with pre-session and post-session UNIX shell scripts. Created and scheduled batches for the daily load of the data.
• Used various performance tuning methods to make the loads more efficient.
• Tested the Informatica mappings and creating QA Test Plans.
• Developed the documentation on the complete data mart ETL process.
• Supported the data mart in Production.

Environment: Informatica 7.1, Oracle 9i, SQL, PL/SQL, Windows 2003, UNIX.