Developer Data

SURESH PARVATHINI

PROFESSIONAL SUMMARY:

Around 12 years of Experience in IT as BI Developer, Oracle BI/OBIA Developer. Involved in gathering Business Requirements, performing GAP Analysis, Design / Data Modeling, Development, Testing, Implementation and Documentation of multiple functionalities in area of Data Warehousing and Business Intelligence Applications.

Over 10years of experience in designing, development and implementation of OBIEE 11g / 12c/BICS, OBIA (7.9.6.3, 7.9.6.4) with 2 Full Life Cycle Implementations and OBIEE Development.

Experienced in new technologies Attunity, WhereScape Red.

Good exposure in SnowFlake

Excellent Exposure in Informatica Repository manager and code migrations using deployment groups and XML export and import methods..

Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE 11g,and OBIEE 12c.

Expertise in design and RPD development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool

Detailed knowledge, understanding and experience of OBIEE 11g and OBIApps with ability of develop, customize OBIEE solutions and extend BI Application solutions.

Expertise in handling all phases of Quality Assurance Life Cycle and Software Development Life Cycle(SDLC) of the BI Projects.

Experienced in Design, Development and Implementation of Business Intelligence solutions using Oracle Business Intelligence, Oracle Warehouse Builder, Noetix and Discoverer.

Designed Presentation, Logical, Alias Tables Designed and developed BICS repository(RPD) using Oracle BI admin tool by importing the required objects (Dimensions, Facts & Aggregates) with constraints into physical layer by employing connection pool, developing multiple dimensions & Logical & Facts measures objects in BMM Layer, and developing web catalog in presentation layer,

Expertise with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series & Caching.

Extensively worked on Informatica Designer components including Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer and workflow manager.

Expertise in OBIA,BICS, BI Publisher, Tableau and MicroStrategy reporting tool with extensive experience in Oracle PL/SQL programming.

Experience in different source systems like EBASE, PEOPLE SOFT and SFDC

Experience in Oracle HRMS reports development.

Expertise in debugging, optimizing the performance tuning of OBIEE repository & dashboards/reports. Administration and Configuration OBIEE and BICS.

Good experience in Informatica, worked on OBIA 7.9.6.4 and 7.9.6.3.

Expertise in developing end-to-end integration solutions using Informatica and multiple databases like ORACLE, DB2, Teradata, MySQL, PostGreSQL and SQL Server

Strong experience with Informatica tools using real-time Change Data Capture and MD5

Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookups, joiner, sequence generator, sorter, SQLT, stored procedure, Update strategy, Source Qualifier, Transaction Control, JAVA, Union, CDC etc

Designing and developing Informatica mappings including Type-I and Type-II slowly changing dimensions (SCD).

Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping

Experienced in BI Publisher, MS Office Plug in for rich reporting and Oracle BI Scheduler Configuration for Alerts /Agents.

Good Experience in Informatica,DAC and ODI

Having good Experience in OBIA, (7.9.6.4) BI Publisher Reports.

Strong Analytical, Interpersonal, Problem Solving, written and communication skills

Experienced in using advanced concepts of Informatica like push down optimization (PDO)

Experienced in writing SQL, PL/SQL programming, Stored Procedures, Package, Functions, Triggers, Views, Materialized Views.

Implemented Data Level, Object level Security and Active Directory Integration with OBIEE

Expertise in Performance tuning at Database level and RPD side in OBIEE and BICS.

Experience in requirement analysis, gathering, preparing project plan, high-level and low-level design documents and test cases

Experience in Deployment, Migration and upgrades of RPD and Web Catalog across instances and environment.

Installation and single sign on configuration

Have hands on experience on creating dashboards and reports using Hyperion SQR Production reporting, Financial Reporting, Interactive reporting (Brio) and Web Analysis.

Capable Team player, Technical and Maintenance leader who works well with people at all levels. Capable to cope up with pressure, short deadlines, compressed schedules and long hours.

CERTIFICATIONS:

Certified Oracle Business Intelligence Enterprise Edition (OBIEE 11G)

TECHNICAL SKILLS:

BI Tools:

OBIEE 11G,BICS,Oracle Analytics Cloud Services Hyperion ESSBASE 9.3.1, OBIA 7.9.6.3, OBIA 7.9.6.4,APEX, Tableau. Oracle EBS 12.2.6, Looker,Power BI

ERP Packages:

Work Day HCM, Oracle Applications / Oracle E-Business Suite: R12, R11i, R11, (AP, AR, GL, OM, Install Base Service contracts) Revenue systems (Revpro)

ETL Tools:

Informatica Power Center 9.0, ODI. WhereScape Red

Databases:

Snowflake, Oracle 12c/11g MS SQL Server 2005/2000, Teradata, DB2, MS Access

Languages:

C, C++, VB, SQL, PL/SQL

Operating Systems:

Windows XP / 00 / NT, Linux Red Hat, UNIX AIX, Solaris

Packages:

SQL *PLUS, Query Analyzer, PeopleSoft, ERWIN, SAS, Oracle EBS, CRM

Web Technologies:

HTML, DHTML, CSS, XML, Oracle SOA

Applications:

MS Word, MS Excel, Outlook, FrontPage, Data Modeling, PowerPoint

Utilities:

Toad 9.0/8.5.1, SQL *Loader, Putty, APEX, SQL Navigator 4.4, BI Publisher.

Replication Tool

Attunity

PROFESSIONAL EXPERIENCE:

National Marrow Donor Program – Minneapolis, MN July, 2018 - Till Date

Sr. OBIEE Lead

Project Description:

NMDP is the world's largest hematopoietic cell registry, listing nearly 16 million individuals and nearly 238,000 cord blood units. Hematopoietic cells from NMDP donors or cord blood units are used to transplant patients with a variety of blood, bone marrow or immune system disorders. Financial, Operational and all other more sensitive information reporting done through by OBIEE with ETL (BODS) Worked on implementing new visualization tool Looker and migrating all OBIEE reports in to Looker.

Responsibilities:

Provided full-lifecycle support for migration efforts from development to QA to production analytics

Involve in all the requirement gathering meetings to understand the business requirement.

Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

Helped refine and determine feasibility, correctness, and completeness of end-user's requirements.

Effectively interacted with the end users for requirement gathering and defined requirement specifications document.

Analyzed and resolve data discrepancies, performance issues, defects and bugs.

Performed production support activities/trouble shooting the issues

Good experience in Attunity, WhereScape and Snowflake.

Worked on Identifying key reports in OBIEE and convert them in to Looker.

Worked different sources ORACLE,SQL SERVER,HAPLOGIC and SALESFORCE and replicated in Snowflake through attunity.

Worked on whereScape procedures and created required data model in wherescape.

Environment: OBIEE 11.1.1.7, Oracle EBS 12.2.5,12.2.6.BODS 14.2.4,WhereScape 8.1,Snowflake,Attunity 6.4

Riverbed Technology – Bay Area, CA June, 2017 – July 2018

Sr. OBIEE Tech Lead

Project Description:

Riverbed Technology will adopt ASC 606 based on the new revenue guideline. Rev Pro has been initiated to automate the revenue recognition processes globally across Riverbed using RevPro Release 3.1 and this causes issues in reporting.

Riverbed Technology’s Finance Team had decided to adopt the Full Retrospective transition approach as part of the Revenue Recognition ASC 606 Implementation Project.BI perspective retrofitting changes to integrate the new revenue standards ASC 606 as secondary ledger with recasting data.

Responsibilities:

Responsible for New BICS reports development and existing report Change based on the new 3.0 Revpro.

BICS finance reports enhancements.

Security Implementation

Reports migration from Discoverer to BICS.

Involve in all the requirement gathering meetings to understand the business requirement.

Worked with both functional and technical teams of RevPro - the one implementing revenue upgrade from RevPro 2.4 to RevPro 3.1 Performed Unit, Integration and Regression testing to validate reports

Build few reports on apex which is having performance issues in OBIEE and BICS.

Worked on Financial reports by using oracle EBS as a source system.

Done customization on oracle financials and added segmentation data into existing subject areas.

Expert Technical knowledge of Oracle Business Intelligence Cloud Service (BICS)

Done Impact analysis on already existing reports present in all dashboards and gave a detailed level document.

Done enhancements on already existing reports, retiring unused reports as suggested by user.

Built some new dashboards and reports, prompts, filters as per the user requirements

Performed RPD level change, DAC and Informatica level changes.

Worked extensively on EBS finance module and Revpro.

Created prompts, Drill down and navigation for the Business to view data at different level of granularity

Worked on Oracle Application Express and developed few reports having bulk data.

Performed Data Validation of data in the reports and dashboards.

Performed production support activities/trouble shooting the issues.

worked on general ledger subject and built financial value creation reports to analyze company performance as per client request.

Prepared and maintained documentation for all new or modified RPD objects and ETL mappings.

Provide support to Super Users and business users on reports/dashboards.

Involved in creating Informatica mappings, mapplets, worklets and workflows to populate the data from different sources to warehouse.

Generated reports using the BICS features like pivot tables, charts and view selector.

Development of RPD in MUD environment.

Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer

Configured facts, dimensions and Hierarchies.

Done vigorous Unit testing and coordinated with users throughout the UAT phase.

Responsible for taking the user sign off for all our BICS reports before going live into production.

Lead the offshore team from beginning, responsible for work break down structure and tasks / open issues tracking and status update to the project sponsors

Configured facts, dimensions and Hierarchies.

Defined permission and the privileges to the users as per their role.

Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.

Environment: OBIEE 11.1.1.7,BICS 12.2.2.0.0, Tableau, Revenue systems (Revpro), SQL Developer. Oracle EBS 12.2.5,12.2.6. Informatica Powercenter 10.1, MS SQL, Control M, SQL, PL/SQL

CBRE, Dallas TX October, 2014 – May 2017

Sr. OBIE Lead/ Business Systems Analyst

Implementation Partner: Mphasis (Bangalore)

Project Description:

CBRE Group, Inc. is an American company with headquarters in Los Angeles, California.

CBRE was ranked at 387 in the Fortune 500 in 2013 and was the highest ranked company in the Real Estate sector.

The goal of the Project is to provide appropriate information regarding financial reports for their Management

Responsibilities:

Responsible for Overall Implementation of the Project starting from Requirement gathering to final deployment of the OBIEE Application in Production and giving OBIEE Demo to the end users.

Responsible for Functional and Technical design documents for all the requirements gathered for the BICS Rpd Development

Designed few specific subject areas for financial reporting.

Gathering business requirements from the users and creating functional documentation for the Inbound and Outbound AP Interfaces from Oracle EBS

Worked with support its production, test and development environment by solving issues which arises in the loading of data in the data warehouse by the use of tool ODI.

Designed and developed Metadata Repository (.rpd) that consist of physical layer, business model / layer with aggregates, dimensions and Dimension hierarchies, presentation layer with catalogs & folders using OBIEE Administration tool.

Knowledge in dealing with various BICS functionalities like Dashboard prompts, views, aggregates, global filters, scheduling, contextual/guided navigation, conditional formatting of reports to satisfy the end users. Developed business models conforming to functional mapping, defined logical and complex joins for the dimension tables.

Implemented Hierarchies, Aggregates, Level based measures and Partitions to meet the business requirements.

Worked on Change Data Capture (CDC) requirement using ODI.

Worked extensively on finance module by using R12 as a source.

Involved in setting up Session and Repository (Static and Dynamic) variables using various Initialization blocks.

Providing technical support in various Oracle EBS modules like Inventory, Fixed Assets, Accounts Receivables, Accounts Payables, General Ledger.

Integrated Windows Active Directory authentication LDAP with OBIEE including the security levels at group level. Defined security matrix for BICS data and object level security.

Involved in testing the reports, dashboards for data integrity and using the query log and Micro strategy queries.

Creation of customized Knowledge modules like LKM in order to use Excel (XLSX) file as a source as per the project requirement

Implemented cache management and enhancing query performance, As a part of performance tuning

Used ETL processes to accommodate changes in source systems and new business user requirements.

Creating reports using Hyperion Smart view.

Testing and validation of various ODI Mappings and associated Workflows

Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.

Worked on resolving production issues and BI tickets within strict timeline.

Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data. 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 Single Sign on for Users in Development environment leveraging Analytics Repository.

Developed Hyperion Financial Reports

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.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL

Trained End Users and Pilot Users about OBIEE Tools and BICS.

Tuning Informatica Mappings and Sessions for optimum performance.

Environment: OBIEE 11.1.1.7, OBIA 7.9.6.4, ODI, Informatica, Oracle 11g, ODI, Oracle EBS 12.2.3, SQLDeveloper, Hyperion Financial Management 11.1.2.3 Windows and UNIX,RDBMS,DAC,OBIEE 12C,BICS,Oracle 12c,HTML,BI Sechedular.Weblogic. People Soft. Oracle EBS 12.2.5 (Oracle Financials (AR, AP, GL)

Verizon VDSI Chennai. January, 2012 – September, 2014

Sr. BI Apps Developer (OBIA Developer)

Project Description:

Verizon one of the largest telecom operator in USA.CPM is a single source of reliable data for executive reporting. Bringing together Financial, Operational. Sales and Service metrics.

Responsibilities:

Worked closely with the ETL team to determine the granularity and figure out the facts and dimensions.

Migrated Oracle Hyperion Interactive Reports (Brio) to OBIEE

Migrated Hyperion SQR reports to OBIEE BQY DM dimensions (Stars/Snowflakes) and extended OBIEE physical layer.

Developed, implemented and deployed data warehousing and business analytical solutions

Identified production faults and critical issues followed and troubleshoot them

Worked with administrators, users and analysts to maintain exchange of reporting requirements

Understanding in project requirements and work towards design and development of the plan layout

Developed and deployed dashboards, analytics and reports properly

Developed and designed dashboards, reports, ad hoc queries and analysis

Installing, upgrading and configuring business intelligence and OBIEE tools

Data modeling, meta data and user interface

Use the best practices of business intelligence to meet project and company objectives

Trained the administration team on new OBIEE, BI and ETL tools

Managed security privileges for each subject area and dashboards according to the requirements.

Configured Agents to deliver BI content to subscribers based on schedule and events

Created Security settings in OBIEE Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Answers

Used the Catalog manager and maintained the Oracle BI web catalog to manage Dashboards, Answers.

Involved in unit testing, integration testing of the reports generated by OBIEE.

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

Worked with DBA and SME towards performance tuning.

Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE.

Environment: OBIEE 11g, Informatica 8.x, Oracle 10g, Informatica Power Center, OBIA 7.9.6.3, Oracle 11g,SQL Plus,SQL Loader,Discoverer, SVN, Toad, SQL Developer, Windows and UNIX. Oracle E-Business Suite: R11i, R11.

Daimler India Commercial Vehicles, Chennai. January, 2011 – December, 2011

OBIEE Consultant

Project Description:

Client is one of the German’s largest Automobile Industries. Dealer Management System gives them the ability to find out the market trends and dynamics and ability to get more customers through their automotive experience

Responsibilities:

Developed and test OBIEE dashboards and reports to high standards of quality and performance.

Perform design/code/test reviews for OBIEE components.

Assist with planning and execute the release of OBIEE components into production.

Research, identify and recommend technical and operational improvements resulting in improved reliability and/or efficiencies in maintaining and/or developing OBIEE components.

Environment: OBIEE 11g, Oracle 11g, Unix, DAC, Informatica, OBIA 7.9.6.3.

Bank Of Mellat, Iranian Bank, Hyderabad January, 2009 – February, 2010

OBIEE Developer

Implementation Partner: Cinar Software Technologies

Project Description:

Bank Mellat is a state-owned commercial Iranian bank having fully implemented core banking master plan for the domestic currency in all its line and staff units.The whole process has been automated and entire extraction, transformation and loading process has been done with the help of Informatica and reporting done using OBIEE

Responsibilities:

Worked closely with Business Analysts to gather the Analytics requirements and translated business requirements to technical considerations for Data Warehouse and Reporting.

Created connection pools, physical tables and defined joins in the physical layer of the repository.

Created dimension hierarchies and assigned levels and custom aggregation rules for each level.

Involved in creating Users, Groups and managing the object level and data level security

Integrated BI Publisher with OBIEE answers and performed configurations.

Environment: OBIEE 10.1.3.4, PL/SQL, SQL Developer, TOAD, SQL*Plus, SQL*Loader, JAVA, Windows and UNIX.

Pharmax Pharma - Canada August, 2007 – December, 2008

OBIEE Developer

Responsibilities:

Created different types of reports using Answers, Dashboards and Delivers to meet the Business requirements.

Created mockup reports and dashboards for review by the business users.

Using Answers design different kinds of reports like filters, prompts, table & title view, column selector and view selector as per Business requirements.

Designed charts view, narrative view, pivot table, legend, funnel chart, ticker, static text, no result and other views as per Business requirements.

Designed Dashboards prompts, pages, links, images, embedded content, text, folders and guided navigation links as per Business requirements.

Implemented Prompts to provide dynamic filter condition to end users.

Environment: OBIEE 10G, Siebel Analytics, Oracle 9i

Great West Life Insurance - Canada September, 2006 – July, 2007

Siebel Developer

Responsibilities:

Extensively worked on Siebel Answers create reports as per client requirements.

Created iBots and Delivers to send Alert messages to subscribed users.

Developed custom reports/Ad-hoc queries using Siebel and assigned them to application specific dashboards.

Design and present the various scenarios for implementing organization and position based data security in Siebel.

Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

Implemented Prompts to provide dynamic filter condition to end users.

Environment: Siebel Analytics, Oracle 9i

Contact this candidate