SUMMARY:

• Around 8 years of Experience in IT as BI Developer, Tableau developer, Oracle BIEE/Siebel Analytics 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.
• Experience on OBIEE Applications include:
• Experienced in all phases of project from gathering business requirements to production support.
• RPD Development (physical, Business, presentation Layers)
• Dashboard development, building reports & enhancing existing reports
• Creating initialization blocks, repository and session variables
• Aggregate Navigation - Creating aggregate tables using materialized views
• Multiuser development, Merging and Importing Objects from different repositories
• Experience in migrating metadata and web catalogue between different environments
• Clustering, Load Balancing, Configuring delivers, ibots
• Cache management, performance tuning at report level, database level
• Setup, Installed and configured OBIEE 11g/OBI Apps 7.9.6 cluster supporting the EBS 11.x and 12.x Financial, Supply Chain Management and Order Management Modules including Procurement and Spending Modules
• Used Informatica Power Center v9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Had good knowledge on functional & technical aspects related to EBS domain.
• Productively used Informatica tools - Informatica Repository Manager, Informatica Power Center Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Expertized in using Data Warehouse Administration Console (DAC) for scheduling and executing Incremental ETL loads.
• Customized OBIA modules - Financials, Projects, Account Payables, Procurement and Spend Analytics, Order Management, Inventory, Purchase Orders, GL, Account Receivables, reports and subject areas in the RPD and developed new analytics using these OOTB objects.
• Hands on data warehousing experience using Informatica powermart, Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer - data transformation and mapping issues, Mapplets Transformations).
• Extended skills in using Informatica Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Expertise in configuration of Oracle BI Analytics Repository, DAC (Execution Plans, Subject Areas, Design, Setup, execute etc.,)
• Expertise in BI Apps (OBIA) for Sales, Service, Financials, EAM, HR Analytics, Procurements, Order Management, Supply Chain Management, Manufacturing and Project analytics.
• Experience including Technical support, troubleshooting, report design and monitoring of system usage.
• Possessed core skill on Tableau Desktop and Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Expertise in working with Financial, Sales, Marketing, HR, and Order Management Analytics.
• Mastered in communication, team building, presentation, facilitation techniques, motivation & leadership skills. Ability to learn and adapt to new technologies.

TECHNICAL SKILLS:

BI/Reporting Tools: OBIEE 11g/10g, Exalytics, BI Publisher, OBIA, DAC, Crystal reports Essbase, OAC, BICS, Tableau

ETL tools: Informatica 9.5, ODIEE and Data stage, Oracle EBS R12

Databases: Oracle 11g, MS-SQL Server, Golden Gate, Sybase

Operating Systems: LINUX, UNIX and Windows

ERP: Oracle EBS, SAP

Data Modeling Tools: Erwin, MS Visio

CRM: SFDC, Siebel and SAP

Other Tools: Clear Case, HPQC, TOAD, SQL Plus, OFFICE, IBM Rational, etc.

WORK EXPERIENCE:

Confidential, CA

OBIEE Developer

Responsibilities:

• Responsible for gathering business requirements from users in all phases of the project
• Worked with both functional and technical teams of RevPro - the one implementing revenue upgrade from RevPro 2.4 to RevPro 3.1
• 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.
• Responsible for triggering, auto - scheduling the loads, monitoring loads and initiating the execution plans.
• Done end to end analysis on population of records from Oracle source into warehouse level and to OBI reports.
• Coordinated with the EBS team, gathered inputs from EBS to implement the corresponding changes required in BI.
• Back tracked target tables to source and responsible for updating the strategies and revenue codes.
• Customized OOTB OBIA packages for ETL using ODI studio based on the business requirements.
• Majorly implemented the changes in the source qualifier query at ETL level so that our OBI environment can adapt to new revenue standard (RevPro 3.x)
• Done vigorous Unit testing and coordinated with users throughout the UAT phase.
• Responsible for taking the user sign off for all our OBI 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.

Environment: OBI 11g / 12c, Informatica v 9.0 /10, DAC 11g, SQL, PL/SQL, BICS, OAC, TOAD, Office, UNIX, WINDOWS, JIRA, Oracle EBS R12

Confidential, FL

OBIEE Developer

Responsibilities:

• Worked on all phases of data warehouse development lifecycle, ETL design and implementation, and support of new and existing applications.
• Experienced in analyzing business requirements and translating requirements into functional and technical design specifications.
• Involved in creating mappings, mapplets, active transformations and reusable transformations.
• Experience in working with different data sources like Flat files, XML files and Databases.
• Loaded the dataset into Oracle for ETL (Extract, Transfer and Load) operation.
• Created Complex OBIEE Dashboards for different hospitals, physicians and executives.
• Responsible for migration activities which includes DDL changes, DAC & Informatica repositories
• Provided estimates to build reports for EBS Modules such as Order Management, Inventory Management & Delivery Management (Supply Chain Management)
• Worked together with EBS team to meet the business requirements.
• Lead and Coordinated with the offshore team from onsite for project execution
• Responsible for catalog migration activities which includes DDL changes, DAC & Informatica repositories.
• Customized OBIA Out of the Box Reports to meet the requirements by doing Business Analysis, Technical Analysis to design and create reportsand RPD Modifications.

Environment: Informatica 8.6 /9x, Oracle 11g, Oracle 12c, SQL Server, UNIX, OBIEE 11.1.17x. Oracle EBS R12

Confidential

OBIEE Developer

Responsibilities:

• Analyzed, designed, created and manipulated Oracle tables.
• Understood the business needs and designs programs and systems that match the complex business requirements and records all the specifications that are involved in the development and coding process
• Resolved moderate problems associated with the designed programs and provided technical guidance on complex programming.
• Developing mappings to load data from multiple data sources to target.
• Researched manual and automated systems, developed recommendations and prepared documentation.
• Worked with data warehouse staff to in corporate best practices from Informatica.
• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Prepared unit test plans and functional validation.
• Have defined production release requirements and sustainment architecture
• Developed OBIEE/OBIA reports for all departments across all modules - AP/AR/GL/Award/Grand/PA/iSupply/HR Payroll/OAB

Environment: Informatica 8.x, Oracle 10g, UNIX, SVN, Windows XP, VISIO, JIRA

Confidential

OBIEE Developer

Responsibilities:

• Source data was extracted from Oracle, SQL Server, flat files, COBOL sources and XML sources.
• Involved in Analysis, Requirements Gathering and documentation of Functional & Technical specifications.
• Prepared the impact analysis document and high-level design for the requirements.
• Worked on preparing unit test plans and functional validation.
• Worked closely with ETL Analysts and project subject matter experts to create technical designs, developed ETL modules using ETL software (Informatica) and stored procedures, thoroughly test the software, integrated the code in to workflows or scheduling solutions, and execute the code modules as necessary for final conversion
• Performed Requirements gathering, development estimation for each phase of the OBIEE reports and setting up the environment for OBIEE Server & OBI Applications
• Designed Data model for custom Repository development, Business model mapping and OBIEE prompts and Dashboards.
• Designed and developed ad-hoc reports on Customer service activities and Sales target
• Responsible for setting up DAC execution plans and Administration of Oracle BI Publisher
• Worked in OBIA Modules - Financials, Procurements and Spend, Projects and HR Analytics
• Modifying and managing the Informatica workflows relating to OBIA OOTB objects.

Environment: Oracle 11g, Informatica Power Center 9.1, OBIEE 10.1.3.4, OBIA 7.9.5 and Windows 2003, UNIX, Oracle EBS R12

Confidential

OBIEE Developer

Responsibilities:

• Lead the team in developing Data Warehouse roadmap, strategy and architecture for enterprise data warehouse.
• Preparation of Business Requirements Document (BRD)
• Prepare Data Flow diagrams, identify major streams like Data Conversion, Historical, Data Retention Archival, Data Quality, Reconciliation
• Identified facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created the dimensional logical model using with help of Data Governance team for better performance of data.
• Reviewed the logical model with Business users, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Worked with DBA to create the physical model and tables.
• Participated in UAT sessions to educate the business users about the new BI System.
• Installed and configured OBIA with the existing OBIEE setup by merging the RPD and importing all the OOTB OBIA objects and custom columns from Siebel source.
• Provided interactive reports on OBIA Modules over Sales, Financial and EAM analytics

Environment: Informatica 9.1, Oracle 10g, UNIX, Oracle EBS R12, PVCS, UC4, Oracle APPS.

Confidential

ETL Developer

Responsibilities:

• Worked with ETL team on Informatica Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them.
• Coordinated with business and Functional Team in releasing requirements.
• Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center and extracted source data from flat files, Oracle and loaded to an Oracle.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Involved in Creating Sessions, Workflows Using Workflow Manager and monitoring sessions using Workflow monitor and testing mappings.
• Worked closely with the Managed Services team to provide high level design document, monitor progress, provide guidance, review and sign off on all documentation and testing.

Environment: Informatica 8.1, Oracle10g, Ware house builder, VISIO, UNIX, WINDOWS

Confidential

Data Warehouse developer

Responsibilities:

• Responsible for establishing dimensional data modeling standard and guideline.
• Analysis of business requirement to define KPIs (Key Performance Indicator).
• Extensively used DAC 10/11, to build the subject areas, execution plans /routines and schedule for the jobs.
• Worked in roles that combined Business Analyst, Data Modeler, BI Developer and source system expertise and developed reports and layouts using BI publisher
• Installed and configured Pentaho (5.3) EE and Community editions of BI and DI applications on Linux machine.
• Worked on large volume of online data with performance tuning techniques. Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Environment: OBIEE 11g/10g, Siebel CRM, BIP, Pentaho 6.1, Informatica, ERWIN, Solaris