Summary:

• Over 8 Years of IT experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes Oracle Data Integrator 10g/11g/12c,OBIEE 10g/11g, SOA Suite 11g, and WebLogic server 10.3.
• Experience in leading small and medium teams and also extensive experience in onshore coordination.
• Experience in Analysis, Design, and Development including Implementation of Business Intelligence BI solutions using OBIEE/Siebel Analytics.
• Worked along with business analysts, developers, management professionals and with business users from various locations of customer to gather requirements.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Worked on ODI 11g and ODI 12c studios.
• Using Data Warehousing DWH tools like OBIEE, ODI and Jdeveloper.
• Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers , Answers, Dashboards, Catalog Manager.
• Configured the Oracle Data Integrator ODI software tool in a three-tier Environment and performed periodic upgrades, performed source-to-target mappings, storage capacity planning, developing ETL
• Developed and delivered ETL scenarios in the context of Services Oriented Architecture SOA
• Worked on Bulk data loading on Oracle EBS environments and involved to resolve the production issues.
• Extensive experience in developing the load plans, packages and job scheduling. Good knowledge in installing ODI11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.
• Gathering requirements from users to develop interfaces and packages.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.
• Sound knowledge on Standalone agent and Java-EE agent creation and configuration.
• Strong knowledge on ODI Administration tasks and experience in creating master and work repository in the initial set up of the environment.
• Knowledge on creating ODI procedures to create and populate in target systems. Having idea about KM customization. Knowledge on Deployment from DEV to SIT to UAT and PROD. Have good knowledge in building BPEL processes and SOA composites.
• Good experience on Deploying Scenarios from one environment to other environment.
• Having good experience on Upgrading from ODI 10g to ODI 11g environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Analyzed the Business requirement and developed physical and logical architectures based on source and targets Using Topology navigator in ODI.
• Having good experience on Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Worked on slowly changing dimensions SCD , Change data capture CDC as part of data warehousing concepts.
• Experience in OBIE Administration, configuring MUDE, OBIEE Schedule, usage tracking. Repository Sever and Presentation Server configuration changes, Cache management, space management.
• Strong SQL, PL/SQL ETL/ELT knowledge. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL to move the changed data across multiple environments using DB links.
• Having good experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using PL/SQL and Involved in performance tuning.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC Requirement Analysis, Design, Development, Testing and Documentation . Exposure to version tracking control systems.

Highlights:

• Extensive experience on Oracle Data Integrator ODI Development and Administration.
• Extensively worked on Bulk Data Integrations in different environments using ODI, Oracle EBS and SOA Suite.
• OBIEE Certified Implementation specialist and over 8 years of experience as an ODI/OBIEE Consultant.
• Developed the Oracle BIEE Metadata repository .rpd model
• Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers , Answers, Dashboards, Catalog Manager.
• Experience in various domains like Finance, Retails Insurance, Manufacturing and HealthCare.

Skills:

Professional Experience:

Confidential

Senior ODI/OBIEE Developer

• With the acquisition of Nortel by Ciena the Lead to quote team was formed to integrate the Ciena and Nortel IT infrastructure and tools to simplify and ease doing business with Ciena. This resulted in a number of L2Q work streams being created focusing on specific functions in the Business. The functionality of the overall L2Q project is Enable real-time self-service ordering of the entire Ciena portfolio for both Ciena red and Ciena blue channels using Order Centre OC .Enable real-time self-service order status checking for Ciena red channel orders product and service using the Order Status OS tool for all orders no matter how they were placed.
• End state goal is combined portfolio ordering enabled for all channels with 1 PO 1 invoice.
• Any gaps deemed by Ciena as a requirement defined in the contract would then be jointly assessed to determine the level of effort and timing of the implementation of the gap. If not defined within the scope of the contract, then the gap would be jointly assessed for level of effort and potential cost impact.

Responsibilities:

• Primary responsibility include installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL
• Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Extensively involved in production issues.
• Gathering requirements from users/business to develop interfaces, packages, Load plans.
• Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Extensively used ODI to load data from Oracle, XML files and flat files
• Worked closely with the end users/business and designing the documents to the track changes.
• Coordinated with the on-site and off-shore team and working on service requests as team.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables.
• Deployed rpd and catalogs using Enterprise manager.
• Created new reports and dashboards as per the business need.
• Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Caching options configured and defined overall cache strategy
• Worked on performance tuning of various OBIEE Reports / Dashboard.

Environment: Oracle Data Integrator ODI 11g/12c, OBIEE 11g/11.1.1.7, OBIA 11.1.1.7.1, Oracle 11g/10g, SQL Plus, TOAD, WinNT/7 and UNIX.

Confidential

Senior ODI/OBIEE Developer

Responsibilities:

• Responsible for Business meetings, conversion of business rules into technical design document.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Experience in ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Extensively used Synchronous and Asynchronous Change Data Capture CDC techniques.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle data warehouse
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used Oracle Data Integrator ODI to extract relevant data from Oracle EBS and map it to Siebel interface tables.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions SCD in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Configured ODI Agents on UNIX server and creating new agents and test them in ODI 11G.
• Worked on setting up crontabs on UNIX servers for scheduling the cron jobs.
• Worked closely with the end users and designing the documents to the track changes.
• Coordinated with the on-site and off-shore team and working on service requests as team.
• Upgraded catalog and rpd from existing 10g to 11g using upgrade agent ua .
• Creating and migrating iBots/Agents to 11g.
• Set up Act As /Impersonation in OBIEE 11g, which helps to debug end user's production issue.
• Deployed rpd and catalogs using Enterprise manager.
• Created new reports and dashboards as per the business need.
• Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Caching options configured and defined overall cache strategy
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Modified instance config file as per the need to accommodate data volume in pivot tables and charts.
• Used SQL tools like TOAD to run SQL and PL/SQL queries and validate the data loaded into the target tables.
• Used Oracle Stored Procedures, Functions and Packages.
• Developed and fine-tuned PL/SQL stored procedures to increase the performance.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data in OBIEE reports and dashboards.

Environment:, Oracle Data Integrator 11g, OBIEE 10g/11g, SOA 11g, Oracle EBS, Siebel CRM, WebLogic server 10.3 and Jdeveloper 11.1.1.6.0, Oracle 10g,UNIX, Windows 2003 Server.

Confidential

Senior ODI/OBIEE Developer

Responsibilities:

• Creating and submitting status reports to up line managements.
• Analysis, Design, Implementation, documentations and BI specifications that incorporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Caching options configured and defined overall cache strategy
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Extracted data from different sources like Oracle, flat files, XML, DB2 and SQL Server loaded into Data Ware House DWH .
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Oracle data warehouse.
• Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Created and Imported/Exported various Sources, Targets, and mappings in interfaces using ODI Designer and generated scenarios and scheduled as per client requirements.
• Loaded data from different source systems to target warehouse using interfaces with Knowledge modules like LKM, IKM and CKM for data quality check.
• Developed several Interfaces, Packages, Procedures and Scenarios in ODI
• Used most of the transformations such as the Source table joins, using Expression in mapping area, aggregations like SUM, MIN, MAX using in mappings, lookups, Filter, Datasets.
• Customized ODI KM like LKM and IKMs
• Created a Physical, logical schemas and Contexts for ELT process.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data.
• Performed scheduling with ELT jobs using Agents in ODI

Environment: OBIEE 10g/11g, Oracle Data Integrator 11g, Oracle 10g, Siebel 8.0, UNIX, Windows 2003 Server.

Confidential

OBIEE Developer

Responsibilities:

• Involved in requirement gatherings
• Organize presentation layer in a format that is easy for end user to use as basis for reporting.
• Developing custom Dashboards and Reports using Siebel Answers. Created Prompts, Filters, Charts, Pivot Tables and Views as per client requirement.
• Developed report with conditional filters, reports.
• Developed the different types of reports and few enhancements of existing reports.
• Monitoring the reports and fix the bugs using Different types of test data.
• Customization of Siebel Answers, Reports and Dashboards.
• Creating the Dashboard and Report level prompts.
• Creating Report level Navigation and Dashboard level Guided Navigation Link.
• Involved in unit testing preparing the test documents.
• Modified Metadata repository suiting to data requirements using Siebel Analytics Admin Tool.
• Developed Answers, Filters, Customized Reports and Dashboards using Siebel Analytics Web.
• Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
• Responsible for the definition, development and testing of the processes/programs necessary to extract data from the client's operational databases, Transform and cleanse the data, and Load it into the data marts.
• Responsible for the analyzing and comparing complex data from multiple sources Teradata, Oracle, flat files .
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
• Used TOAD to run SQL queries.
• Actively interacted with business analysts.
• Responsible for writing Unix Shell Scripts to schedule the jobs.
• ETL mapping Documents for every mapping and Data Migration document have been developed for smooth transfer of project from development to testing environment and then to production environment.

Environment: OBIEE 10g, Toad , Oracle 10g, SQL Server 2000, Teradata, Erwin, MS Visio, UNIX, Windows XP.

Confidential

BI Technical Consultant

Responsibilities:

• Organize presentation layer in a format that is easy for end user to use as basis for reporting.
• Developing custom Dashboards and Reports using Siebel Answers. Created Prompts, Filters, Charts, Pivot Tables and Views as per client requirement.
• Developed report with conditional filters, reports.
• Developed the different types of reports and few enhancements of existing reports.
• Monitoring the reports and fix the bugs using Different types of test data.
• Customization of Siebel Answers, Reports and Dashboards.
• Creating the Dashboard and Report level prompts.
• Creating Report level Navigation and Dashboard level Guided Navigation Link.
• Involved in unit testing preparing the test documents.
• Modified Metadata repository suiting to data requirements using Siebel Analytics Admin Tool.
• Developed Answers, Filters, Customized Reports and Dashboards using Siebel Analytics Web.
• Created users and groups and assigning permissions.

Environment: Siebel 7.8, Siebel Analytics 7.8, UNIX shell Scripting, Oracle 10g, UNIX, Windows NT/2000

Confidential

BI Implementation

OBIEE Developer

Responsibilities:

• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard end users.
• Created OLAP requests in OBIEE/Siebel Answers and multi-level requests drill-downs and guided navigation .
• Created multiple reports reflecting region hierarchy based on roles VP, Director and Account executive.
• Worked on cache purging strategy using Event-polling table. Worked on IBots using OBIEE/Siebel Delivers for caching and delivering the reports to subscribed users.
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Performance tuning in OBIEE for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle data warehouse
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied slowly changing dimensions SCD in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Used Oracle Data Integrator Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Used SQL tools like TOAD to run SQL and PL/SQL queries and validate the data loaded into the target tables.
• Used Oracle Stored Procedures, Functions and Packages.
• Developed and fine-tuned PL/SQL stored procedures to increase the performance.
• Understanding the customer Requirement and designing the solution documents.
• Reviewing the solution documents designed by other designers.
• Analyzing the requirements for the releases.
• Estimating the complexity, based on the requirement and volumes of data to be processed.
• Assisted development and testing teams during the SDLC cycle.
• Star Schema data modeling has been used.
• Developed and implemented various enhancements to the application in the form of production and new production rollouts.

Environment: Oracle Data Integrator 10g, OWB, Teradata, Oracle 9i, Siebel 7.8

Confidential

Role: Software Engineer

Responsibilities:

• Involved in preparation of Detail Design document with prototypes and screen shots based on the requirement documents
• Involved In creating User, Computer, Group and GPO and managing all objects
• Performed the unit testing for the application and resolving technical issues, writing and modifying code
• Responsible for administering and managing Development, Test and production environments using Windows and Exchange servers.

Environment: Windows 2003/2008 servers, Exchange server, Active Directory LDAP