Data Manager

MONISH

SR. (Hyperion/ODI) Consultant

571-***-**** ******.***********@*****.***

PROFESSIONAL SUMMARY

* ***** ** ********* ********** as a dedicated Business Oriented Professional, worked as Oracle PL/SQL Developer using the Oracle Relational Database Management System (RDBMS), I Oracle Data Integrator (ODI), ETL Developer, Oracle Business Intelligence (OBIEE), FDMEE, Hyperion Essbase, Hyperion Planning, Hyperion Reports, Hyperion Financial Management (HFM), Oracle EPM, Data Warehouse Analyst.

Experience in OLAP design, Analysis, Architecture, Development, Implementation, Reporting, Administration, and Migration of various applications in client/server environment using Oracle Hyperion financial management, Oracle FDMEE, Oracle Hyperion Essbase, Hyperion Planning, Essbase Integration Services, Hyperion Reports, Essbase Spread Sheet Add-in, and Essbase Query Designer under Windows and UNIX environments.

Hands on experience on Essbase 9.x and Hyperion Financial Management 11.1.2.3/11.1.2.4.

Having strong knowledge of implementation of Hyperion Financial Management, Hyperion FDM, Workforce and Capital Expense Planning applications, ODI, Implemented Oracle Exadata, Exalogic, Exalytics

Extensive experience in the Implementation, development, design, analysis and of various applications using Hyperion Financial Management 11.x/9.x, FDM 11.x/9.x, Essbase […] planning 11.x/9.x/4.x, Hyperion interactive reporting 11.x/9.x/8.x, OBIEE 11.x/10.x, Hyperion Data integration management (DIM), Hyperion Workforce Planning, Hyperion Capital Expense Planning, Essbase Integration Services, HAL, Hyperion financial Reports, Essbase Studio and Essbase Spreadsheet Add-In, Hyperion Visual Explorer.

Worked on installation and configuration of Hyperion EPM 11.x version on windows/Unix environments.

Successfully implemented Single sign, URL redirection and SSL configuration for Hyperion products.

Designed Classic/EPMA HFM applications for consolidation purposes and used FDM for ETL activities.

Developed EPMA as well as Classic planning applications with Workforce and Capital expenses modules included.

Extensive knowledge of building dimension building as well as data loading using EPMA products for EPMA apps and outline load utility, HAL for classic planning apps

Experience in creation of FDMEE data load process for loading data into Planning and Essbase applications from various data sources. Creation of load rules and MaxL scripts for rest of the data loads.

Set up locations, control tables and import formats for FDMEE configured users and access rights in FDMEE.

Experience in Integrated Oracle EBS to the HFM/Planning/Essbase applications using FDMEE as the ETL tool.

Experience in Creating, Maintaining, and supporting all application objects including Outlines, calculation scripts, Rules files for dimension builds and data loads, Transparent partitions, and Security objects through both Essbase Administration Services (EAS) and Maxl scripts; also involved in automation of these procedures using Batch scripts.

Experience in a range of Hyperion products including Hyperion Essbase, Hyperion Planning,

Created and maintained Finance, Headcount, Planning, and Reporting cubes across BSO and ASO.

Extensive experience in writing Procedural Calculations for Essbase ASO technology.

Vastly experienced in Hyperion planning and budgeting.

Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata

Processing, upgrading, testing and migration of cubes.

Implemented Hyperion Planning and developed web-based forms for budgeting and forecasting purposes.

Hyperion Reports, Hyperion Financial Management (HFM),

Implemented the extraction, loading, and transformation (EL-T) of data using Oracle Data Integrator.

Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator and

Configuring the ODI master and work repositories, ODI models defining and organizing the ODI project

Including interfaces, packages, procedures, variables and user defined-functions.

Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM, SKM and CKM.

Customized versions for the existing ODI Knowledge modules which can be re-used in data Integration projects.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using PL/SQL.

Utilized ODI in-built Journalizing (J$ tables) methodology to manage and maintain Change Data Capture (CDC) from source data.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Development experience with multiple applications in Oracle EBS versions 11i and/or 12x.

Hands on experience working with Oracle Enterprise Data Quality (EDQ).77

Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers.

Experienced in setting up ODI standalone Agents and J2EE Agents on WebLogic server based on requirements.

Expert knowledge of report development execution in a complex environment.

Experience in configuring Standalone agent & Java EE agent in ODI.3

Experience in setting up all three types of Slowly changing dimensions and customization of knowledge modules.

Administration of OBIEE and the OBIEE Web Catalog.

Experience in incorporating BI Publisher with OBIEE. Installation, configuration of ODI in Unix / Linux environments.

Excellent relational abilities, administration aptitudes, group abilities with result arranged mentality.

Excellent communication skills, strong architectural skills, hardworking and a good team player.

Experienced in gathering reporting and analysis requirements, documenting the report specifications, Implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.

Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in

OBIEE using drill down, guided navigation, prompts, filters, and variables.

Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.

Expertise in installing, configuring, and administering WebLogic Server 9.x/10.x/11.x in various environments.

Expert ability to trouble shoots and prioritizes issues.

Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SUMMARY

BI/Reporting Tools

OBIEE 11.1.1.7/10.1.3.x, Discoverer 4i/9i/10g, BI Publisher, Oracle Business Intelligence

Applications 11.1.1.X/ 7.9.x, Siebel Analytics 7.8/7.7. Hyperion Reporting tools.

DWH/ETL Tools

Oracle Data Integrator 11.1.1.7,12.1.2.0, Informatica Power center 9x/8x/7x, DAC10G/11G.

Database.

Oracle RDBMS, Oracle 11g/10g/9i/8i, Sybase 15/12.x, UDB 8.1, SQL Server 2005/2000, Hyperion Essabse

Languages

SQL, PL/SQL, HTML5, CSS3, JAVASCRIPT, ANGULARJS, ASP.NET.

Operating Systems

Windows NT/2008/XP/2000/2003, RHEL 4.x/5.x, UNIX (Solaris, Linux).

Database Tools

SQL*Loader, SQL*Plus, TOAD 9.x, 8. x.

Data Modeling

Dimensional Data, Erwin, ER/Studio, Visio, Star Schema, Snowflake, Tables, Physical

Logical.

PROFESSIONAL EXPERIENCE

Sherwin-Williams, Cleveland, OH

SR. (Hyperion/ODI) Consultant

Feb 2015 - Till date

Role and Responsibilities:

Created master and work repositories in ODI.

Implemented Hyperion Financial Management/Hyperion planning/Essbase classic and EPMA applications from the scratch to the Go Live.

As a technical/functional consultant worked on complete life cycle of the EPM Suite applications which includes from requirement gathering to production deployment

Worked on detail level of server requirements based on number of users accessing the system.

Designed system architecture according to client requirements and provided list of tools to be used to fulfill client requirements.

Installed and configured EPM Suite 11.1.2.3 on multi server environment to serve 1000 plus concurrent users.

Worked on multi cluster environment hosting Essbase, Foundation, Planning, RMI services on the Linux servers and the other Hyperion Financial Management related services on the windows.

Worked with issues related to version 11.1.2.3 installation and configuration and product deployment.

Worked with Subject matter experts (SME) and business analysts to gather the business requirements during development stages and prepared BRD and FDD.

As per the requirements developed Essbase/Planning/HFM/FDM applications in classic and EPMA mode applicable for Planning and HFM.

Extensively used Calc Manager for designing the rules related to Essbase/Planning/HFM.

Experience in writing formulas, Calc Scripts, Business rules according to business requirements for Essbase and planning (Classic Applications)

Creating data serves for database connections, context, physical and logical schemas using the Topology Manager. Implemented Oracle best practices for the naming conventions.

Created NEW USERS IN ODI and configuring profiles.

Used Expressions, filter, joins, Split, Variables, user functions in ODI.

Integrated source PeopleSoft with Hyperion for using FDMEE.

Worked on Setup and Workflow in FDMEE.

Designed the data flow from ERP applications to the Hyperion application using FDMEE as the ETL Tool.

Strong knowledge of working on FDMEE components like ODI, ERP Integrator, FDM.

Translated end user requirements into application design specifications.

Designed logic groups, locations, import format, validations, data load rules and mappings in FDMEE

Integrated ERP Systems (People Soft, Oracle EBS, SAP) in order to extract and load the data in to the target HFM applications using FDMEE.

Set up locations, category mapping, periodic mapping and import formats for FDMEE.

Configured users and access rights in FDMEE.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Exported and imported budget/P&L and headcount actual data from HFM into

Essbase/workforce planning for forecasting, budgeting purpose using ODI.

Supported existing HFM and Planning applications. Maintaining dimensions, data management,

Created new data forms and data grids, consolidations, calculations, rules.

Documented all the detail of the ODI objects that are implemented such as mapping, procedures, variables, packages, user functions, scenarios and Load plans. Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and bridge tables.

Worked in performance tuning of various integrations and database by creating indexes on the tables for faster retrieval of the data, used hints in select statement for improving the performance

Installed, Maintained and Documented the ODI setup on multiple environments.

Created, executed and managed ETL processes using ODI.

Created numerous ODI Interfaces (Mappings in ODI 12c).

Worked with ODI Graphical (Designer, Topology Manager, Operator and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration, Service)

Performed reverse engineering of databases using ODI Designer tool.

Implemented Type-II Slowly Changing Dimension (SCD) logic in ODI environment. And Incremental Load mappings for Fact mapping.

Implemented Type-I, Type- III Slowly Changing Dimension (SCD) logic in ODI environment.

Implemented CDC through ODI Normalization of Knowledge Modules (KMs).

Used JKM Oracle to Oracle Consistent (OGG Online) for golden gate replication.

Applied Multi-threading concept in tasks for serial and parallel executions.

Performed Query optimization, debugging, and performance tuning for improving performance.

Export/Import scenarios & Loads plans across different environments (Dev/SIT/PROD)

Worked closely with OBIEE team to provide support to implement complex logics.

Worked extensively on Physical Layer, Business Layer and Presentation Layer of the RPD.

Conducted various workshop sessions with super users to bring them up to speed on subject areas, reports, dashboards and also helped them to understand the limitations of the System.

Environment: ODI 12c, Hyperion Financial Management 11.1.2.4, Hyperion FDM 11.1.2.x, Hyperion planning 11.1.2.3/11.1.2.4, Essbase11.1.2.3/11.1.2.4, Essbase Studio 11.1.2.3, Hyperion smart view, PL/SQL, SQL, SQL Loader, Toad, Oracle 11g/10g, MS SQL Server 2008/2005, Shell Programming, SQL Developer, Toad, Unix scripting, Windows, OBIA/BI APPS 11.1.1.7.1/7.9.6.

L.S. Starrett Company, Athol, MA

SR. (Hyperion/ODI) DEVELOPER

Jan 2014 – Feb 2015

Role and Responsibilities:

To understand organizations business requirements and functionality, interacting with client for appropriate requirement specifications.

Optimization of data storage which increased the performance of existing cubes.

Designed load rules for Dimension build and data loads.

Designed new CALC scripts and Report Scripts.

Created and made changes to the existing MaxL scripts and scheduled the batch script.

Automated running new Calc Scripts.

Developed and modified Report Scripts and Rules files.

Involved in Performance Tuning to minimize data load time.

Maintain outline, metadata and member formulas as business requirements change.

Created custom reports using Hyperion Reports.

Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense variances over prior periods using Hyperion Reports/Analyzer.

Involved in automation of all operations using MaxL scripts.

Created Security access to different users in both Essbase and Hyperion Planning.

Designed Filters using Essbase Administrative Services (EAS) and assigned them for different users

Created hierarchies, complex and foreign joins initialization block, presentation or repository or session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.

Designed and developed RPD models to support defined reporting requirements.

Design various import scripts for FDMEE data files.

Schedule data load process in FDMEE for monthly and yearly close process.

Implemented Hyperion Planning and developed web-based forms for budgeting and forecasting purposes. Hyperion Reports, Hyperion Financial Management (HFM),

Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.

Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC

Used suitable ODI Knowledge modules to achieve requirements. Extracted data from specific technology, transforming the data, checking it, integrating it, etc. Created Custom Knowledge Modules.

Experience in performance tuning complex ODI interfaces by breaking them into small ODI processes and finally integrating them into one job to meet the data requirement.

Used ODI commands like ODI File Move, ODI File Append, ODI File copy etc.,

Created and maintained Finance, Headcount, Planning, and Reporting cubes across BSO and ASO.

Responsible in Automation, Optimization and Performance Tuning of Essbase application data/metadata

Processing, upgrading, testing and migration of cubes.

Using ODI, Developed, maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets.

Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order etc.,

Configured OBIEE Security and Performed OBIEE Admin Activities

Developed customized dashboards and created custom reports

Extensively experienced gathering requirements from Business Users and translating them into FRD/Design documents

Created many Templates (Excel, Word) using BI Publisher to meet the requirements of the users.

Created much analysis, dashboards and scheduled many Agents to make sure that the users receive the reports as per their demand.

Trouble shooting the data against the core database and delivering the good results to the users.

Created new subject areas in RPD and also involved in Full merge, patch merge and deployments in the server.

Experienced in agents failing issue and in migrating the reports from one environment too other.

Created repository variables and Initialization blocks.

Created level based measures.

Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to buy Worked with multiple sources such as Relational database, Flat files for Extraction,

Created Narrative reports to understand the Business.

Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.

Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.

Created Aggregated Tables and configured the content in Business Model Layer to use the Aggregate tables for better performance.

Implemented Time Comparison and Calculation measures in the business model using Time series Functions.

Environment: OBIEE 11.1.1.3/6, ODI 10g/11g: Oracle Hyperion Essbase 11.1.2.x, Hyperion Planning 11.1.2.x, Hyperion Financial Management 11.1.2.x, Hyperion Smart View 11.1.2.x, FDM 11.2.2.x with ERP, Hyperion Calc Manager, EPMA v11.1.2, Oracle Reports Builder, BI Publisher 11G, Oracle 10/11g, PL/SQL, TOAD, SQL Developer, Windows XP, Windows 2003 Server.

Selective Insurance Group, NJ Jun 2013– Jan 2014

Sr. (Hyperion/ODI) Consultant

Role and Responsibilities:

Developed Block Storage Cubes (BSO) cubes using ESSBASE

Extensively involved in designing and modifying the outlines for ESSBASE Cubes

Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds

Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to ESSBASE cube

Developed OLAP Models and Meta outlines using ESSBASE Integration Services from star schema in relational databases

Created business rules as per the business logic at workflow level and restricted user to input any wrong data, which minimized use of validation at DRM end and hence improving the tool performance

Involved in installation of Hyperion Planning on Windows environment

Designed and developed several ad-hoc and financial reports using Hyperion Analyzer and Hyperion Interactive Reports

Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning

Developed Calc scripts to calculate values like Hourly Wages, Depreciation, Benefits and Revenue

Involved in Migration of Hyperion Reports and Analyzer Report groups

Used ESSBASE Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers

Installed ODI studio on Citrix windows 2003 server and created privileges to DW team

Customized Emails to send out all the details about every ODI object like interfaces, variables and packages with No of inserts, updates, errors and which object has error out for what reason.

Migrated and converted CSV and flat files from multiple sources to ORACLE 11g.

Involved in design, development of ODI (formerly known as Synopsis) for ELT Project, gathering requirement specification documents and presenting and identifying data sources.

Using ODI, Developed, maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets.

Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements.

Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectations.

Designed, developed ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources.

Environment: ODI 11g, Oracle Hyperion Essbase 11.1.2.x, Hyperion Planning 11.1.2.x, Hyperion Financial Management 11.1.2.x, Hyperion Smart View 11.1.2.x, FDM 11.2.2.x with ERP, Hyperion Calc Manager, EPMA v11.1.2. x.

WellPoint Inc., CA Jun2012 – Jun 2013

(Hyperion/ODI) Technical Consultant

Role and Responsibilities:

Involved in developing design specifications of Essbase cube with Customers.

Extensively involved in designing and modifying the outlines for Essbase Cubes.

Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.

Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.

Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.

Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.

Assisted with the integration of financial reporting along with streamlining of process/method improvement for data collection.

Presented detailed analytical reports to higher administrative people using Hyperion Planning induced collaborative decision making.

Developed Block Storage Cubes (B.S.O) cubes using Essbase 10.

Optimized the applications to bring down the runtime and database size considerably.

Involved in production support and maintenance of existing cubes. • Worked as a team member in Hyperion Essbase & Planning Implementation

Created maps for Extraction, Loading, and Transforming process in Oracle Data Integrator - ODI.

Developed interfaces for loading the lookup and Transactional Data.

Created ODI packages, scenarios using interfaces, variables, procedure.

Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.

Transforming and Loading data into target tables.

Installing and Configuring ODI on all the environments with standalone agents for custom Data Warehouse project.

Integrated SQL Developer unit testing framework with ODI scenarios and load plans.

Installed and configured ODI Master and Work Repositories, ODI agents (standalone agents).

Experience in Customizing ODI inbuilt Knowledge Modules to build Interfaces with complex data requirements.

Troubleshooting the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.

Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.

Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.

HSBC, Bangalore, India Sep2010 – Mar 2012

OBIEE/OBIA Developer

Role and Responsibilities:

Participated in discover/design phase of business requirements by meeting various business users.

Prepared Fit/Gap Analysis documents between requirements in necessary customizations and out-of-the-box Oracle BIA functionality.

Analyzed the business requirement gatherings and translated the functional specifications into technical specifications.

Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP systems.

Extracted the pre-built BI solutions of tables by using Oracle BI Apps, OBI Admin tool to configure and create repository (. rpd) and prepared a detail design document.

Developed the repository model based on different requirements, with the necessary logic that involved customizing the OOTB Physical, Business Model Mapping and the Presentation layer.

Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.

Created hierarchies, variables, time series measures and event poll strategies in the repository.

Developed and customized HR Analytics OOTB reports and new Reports, performed look-good changes to OTB Dashboards with different subject matter Views (Drill-Down/Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBI Presentation Services for the various work streams.

Developed calculated measures and assigned Aggregation levels based on dimension hierarchies.

Worked Extensively on OBIEE Answers to create the reports as per the client requirements.

Designed and implemented the Bulletproof Single Sign on (SSO) process so that users can navigate from the portal to the OBIEE dashboard.

Implemented guided navigation within reports.3

Worked with ETL Team on Informatica Power Center tools - Source Analyzer, Data warehousing designer, Mapping Designer and Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets and Work Flow Designer) and Work Flow Monitor.

Involved in creating custom Mappings, Mapplets to load the new tables and the new information into the warehouse.

Used DAC Client to customize and execute out-of-the box DAC execution plans to run all ETL mappings at specified interval.

Customized DAC tasks, tables, table groups and indexes as per requirements.

Performed nightly incremental loads using DAC.

Customized the change capture process of DAC to load data incrementally.

Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.

Environment: Oracle Applications 11g (AR, AP, GL, FA, OM, INV, SCM), Oracle 10g, OBIEE 10.1.3.2.1, Oracle BI Apps 7+, SQL*Loader, Oracle BI Publisher, Informatica 8.1, 8.5, Discoverer 10g, Reports 6i, PL/SQL, TOAD, UNIX Shell Scripting, Shell Scripting, Windows NT, Solaris.

Hindustan Lever Ltd, India Aug 2008– Aug 2010

OBIEE/Siebel Developer

Role and Responsibilities:

Understanding the Business Design Documents and creating an overall design based on requirements and Business reviews.

Built the Physical layer/Business Model and Mapping Layer/Presentation Layer of a Repository by using Star Schemas.

Customized Mappings and used Aliases in Physical Layer.

Participated in Adding Calculations to a Fact Table for various reporting requirements.

Created Dimension Hierarchies and Level-Based Measures for Business requirements.

Used Aggregate Tables and specified Aggregate Levels for each source.

Mapped Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model.

Designed and customized Siebel Answers Views and Charts, Create and save filters, Create Charts and Tables in Siebel Answers, Intelligence Dashboards and created Global Filters.

Used Session Variables in report calculations and Security implementation.

Used Preferred Drilldown to provide seamless navigation capability to business users.

Involved in Performance Tuning of reports, created bitmap Indexes, Materialized Views and Table Partitions.

Used Metadata Design Principles to Design Repository based on business requirements and followed best practices.

Set up Analytics Server Security to control access given to business users.

Created and granted privileges for the users using Analytics Catalog Manager.

Set up LDAP authentication, used Row-Wise Initialization Blocks and set web groups.

Administrated Scheduler Server and Tables to set up Delivers to configure iBots based on the threshold value of the user.

Enabled Usage Tracking Table and Dashboards.

Managed Deployment of Web Catalog and Repository of Siebel Analytics in dev to stage, stage to prod environments. Promoted changes in Repository and Web Catalog onto the production servers.

Involved in creating Complex mappings using lookup, filter, joiner, aggregate, sequence generator and expression transformations using Informatica Power center.

Created Test plans and executed the Unit and Integration Testing Scripts.

Environment: OBIEE 10.1.3.1, Siebel Analytics 7.8.2, Oracle 10g, DB2, PL/SQL, Informatica Power Center 7.1.3, UNIX, XML, SQL Navigator 4.5.

EDUCATION

Bachelor of Technology in Information Technology JNTU, India.

Contact this candidate