SUMMARY

• A dynamic professional with around 9 years of rich experience in Business Analysis, adept at managing the complete SDLC with skills in analyzing requirements and translating ideas into solutions.
• Highly experienced consultant in implementations of OBIEE/Oracle BI Apps (OOB - Prebuilt) Analytics/Siebel Analytics in all phases like implementing Out of the Box (Vanilla mappings) prebuilt mappings, Designing ETL/Informatica, metadata management using DAC (Data warehouse Administration Console), Creating Oracle provided Business Analytics Warehouse (OBAW), OBIEE RPD development, reports and dashboards and Oracle EBS.
• Involved in end to end implementations of BI solutions for implementing Oracle Financial Analytics, U.S Federal Financial Analytics, Procurement and Spend Analytics, Human Resources, Supply Chain and Order Management Analytics, Oracle Project Analytics.
• Involved in implementing prebuilt solutions in converting data from ERP systems like Oracle EBS, Siebel CRM, PeopleSoft into Oracle provided data warehouse (OLAP-BAW).
• Experience serving industrial segments like Finance, Insurance, HR, Sales and Marketing, Manufacturing and Service in business related to implementation of EBS and BI Solutions
• Extensive experience working with Oracle Business Analytics Warehouse and creating Star Schema, Snowflake data structure, slowly changing dimensions and dimensions and fact tables in the BI Apps and experience with understanding universal adaptors in order to load into BI
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Mapping and Presentation Layer), RPD Development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management, Delivers, security using LDAP.
• Extensive experience in configuring Interactive Dashboards, Answers with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Having good experience with configuring Data Warehouse Administration Console (DAC) for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• Involved in performance tuning at the DB level, ETL - Informatica level, OBIEE-RPD, Dashboard Server Level
• Experience with Hyperion Essbase, and Integrated Essbase with OBIEE
• Having extensive working experience with Oracle10g/9i/8i/7, Essbase, SQL Server 2003/2000, DB2, MS Access, TOAD and SQL Developer, Putty, SQL, PL/SQL and Shell scripting.
• Experience in development, customization and migration of BI Publisher (XML Publisher) and Oracle Business Intelligence Discoverer Metadata to OBIEE.
• Having good Exposure in Oracle Data Integrator (ODI)
• Experienced in Oracle AIM Methodology (Functional Design, Technical Design and Installation Documents) and experience in writing unit test scripts, Visio for documentations and diagrams, and Excel spread sheets and Oracle Utilities like Toad,

TECHNICAL SKILLS

Business Intelligence: BI Apps 7.9.6.1 / 7.9.5 , OBIEE 10.1.3.4/3/2 , Siebel Analytics 7.8/7.7.

ETL: Informatica 8.6/8.1.1/ 7.1.4/6.1.1 , Oracle Data Integrator (ODI)

Applications/Analytics: Oracle BI Applications- Oracle Financial Analytics, U.S Federal Financial Analytics, Procurement and Spend Analytics, Human Resources, Supply Chain and Order Management Analytics, Oracle Project Analytics.

RDBMS: Oracle 11g/9i/8i/7, Essbase, Teradata, Netezza, SQL-Server 2003/2000, DB2 UDB 8.1/7.0, TOAD and MS Access.

Data Modeling: Erwin, Dimensional modeling, Star, Snowflake

Methodologies: Star Schema, Snowflake Schema.

Languages: services SQL, PL/SQL, C, C++, Java, HTML, XML, SQL Scripts, Web

Tools: Mercury Quality center, Microsoft Visio, Quest Central for DB2, SQL*Loader, TOAD, SQL Developer, J-Developer

Operating System: AIX, Linux, SUN Solaris, Windows

ERP: Oracle e-Business Suite R12/11i, PeopleSoft, Siebel CRM (related to analytics)- Administration Console DAC 10.1.3.4/1 (Data Warehouse Administration Console)

Reports: BI (XML) Publisher, BI Discoverer 4i/10g

PROFESSIONAL EXPERIENCE

Confidential, Texas

Sr.Oracle BIApps7.9.63/OBIEE 11g /Informatica9.0/ETL/DAC Architect/Developer

Responsibilities:

• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept and conducted Joint Application Design sessions with Business Analysts from OLTP and OLAP to configure and customization of Oracle BI Analytics in all phases of implementing Out of the Box (Vanilla mappings) prebuilt mappings and Oracle Business Analytics warehouse (OBAW).
• Installed the Oracle BI Applications(Informatica, DAC, OBIEE) on distributed environment and configured the OOB Oracle Financial Analytics, U.S Federal Financial Analytics
• Responsible for all the domain values configuration and lookup files which are necessary for configuring the OOB Analytics solutions on Oracle EBS as Source System
• Responsible for administration and migration of repositories between various environments and responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Validation of all the OOB Dashboards: U.S Federal Financial, General Ledger, Payables, Receivables and Procurement and Spend dashboards against Oracle EBS Source System
• Customization of OOB dashboards: U.S Federal Financial, General Ledger, Payables, Receivables
• Configured Delivers and iBots.
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.

Environment: Oracle BI Apps 7.9.6/1, OBIEE 11g, Informatica 9.0 DAC 10.1.3.4.1 , OBAW, Oracle10g, SQL Developer, Oracle E-Business Suite R12\11i, PeopleSoft, BI Discoverer 10g, PL/SQL

Confidential, Sunnyvale, CA

BI Apps/OBIEE Sr Developer

Responsibilities:

• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Conducted Joint Application Design sessions with Business Analysts from OLTP and OLAP to customization of Oracle Business Analytics warehouse (OBAW).
• Defined and documented the technical architecture of the data warehouse, including the physical components and their functionality
• Gathered requirements from the users and generated prototype reports to help the business to visualize the design.
• Leading the offshore team to Co-ordinate the requirements and delivery of the components.
• Installed the Oracle BI Applications(Informatica, DAC, OBIEE) on distributed environment and configured the OOB Oracle Financial Analytics and responsible for administration and migration of repositories between various environments
• Integrated the Companies Custom Budget system from Hyperion Essbase cubes into OBIEE by designing and developing the ETL and reporting approach by using the existing Oracle BI Apps components.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Customized and developed approach to load data into GL Star, AP Star, AR Star, Budget star Data Models using ETL tool Informatica
• Customization of pages and reports into new dashboards: GL, AP, AR and Procurement and Spend
• Configured Implicit fact columns, Delivers- iBots enabled and administered Usage Tracking, NQSCONFIG.INI and Instanceconfig.xml configuration files
• Created various Static and Dynamic variables for Security requirement.
• Configured DAC - Data warehouse Access control for running of ETL jobs
• Worked on OOB and customized Informatica SDE, SIL,PLP adaptors, DAC,OBIEE
• Creating DAC tables, Subject areas, task definitions and indexes and worked on change capture.
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Created reports according to user requirements and also created corresponding dashboards for the reports.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.
• Created and converted BI Publisher reports into OBIEE as interactive dashboards.
• Having good experience with writing Views and materialized views.
• Migrated Oracle BI Discoverer EUL Metadata in to OBIEE using Oracle Discoverer Metadata Conversion Assistant.

Environment: Oracle BI Apps 7.9.5/7.9.6 , OBIEE 10.1.3.4, Informatica 8.6/8.1.1, DAC 10.1.3.4, OBAW, Oracle10g, EPM 11, SQL Developer, Oracle E-Business Suite R12\11i, PeopleSoft, XML (BI) Publisher, BI Discoverer 10g, PL/SQL.

Confidential, California

Sr OBIEE developer

Responsibilities:

• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept and conducted Joint Application Design sessions with Business Analysts from OLTP and OLAP to configure and customization of Oracle BI Analytics in all phases of implementing Out of the Box (Vanilla mappings) prebuilt mappings and Oracle Business Analytics warehouse (OBAW).
• Installed the Oracle BI Applications(Informatica, DAC, OBIEE) on distributed environment and configured the OOB Oracle Financial Analytics, U.S Federal Financial Analytics
• Responsible for all the domain values configuration and lookup files which are necessary for configuring the OOB Analytics solutions on Oracle EBS as Source System
• Responsible for administration and migration of repositories between various environments and responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Validation of all the OOB Dashboards: U.S Federal Financial, General Ledger, Payables, Receivables and Procurement and Spend dashboards against Oracle EBS Source System
• Customization of OOB dashboards: U.S Federal Financial, General Ledger, Payables, Receivables

Environment: Oracle BI Apps 7.9.6/1, OBIEE 11g, Informatica 9.0, DAC 10.1.3.4.1 , OBAW, Oracle10g, SQL Developer, Oracle E-Business Suite R12\11i, PeopleSoft, BI Discoverer 10g, PL/SQL

Confidential, Greenville, SC

BI Apps/OBIEE Developer

Responsibilities:

• Involved gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Installed the Oracle BI Applications(Informatica, DAC, OBIEE) on distributed environment and configured the OOB Oracle Financial, Sales Prebuilt Analytics
• Creating Interactive Dashboards, Answers and Administering Oracle BI Apps Applications.
• Worked with Oracle BI Server, Presentation Server, Repository development and Oracle BI Administration.
• Analysis, Design, development and customization of Reports and Dashboards in OBIEE and daily client interaction. Preparation and execution of the test plans.
• Involved in developing the Incremental ETL process i.e., Mappings using various Transformations and Workflows.
• Conducted meetings and Design sessions with Business Analysts from OLTP and OLAP to customization of Oracle Business Analytics warehouse (OBAW).
• Defined and documented the technical architecture of the data warehouse, including the physical components and their functionality
• Responsible for administration and migration of repositories between Development, Test (QA) and Production environments
• Integrated the Companies Custom Budget system from Hyperion into OBIEE and Order Billing, Manufacturing System by designing and developing the ETL and reporting approach by using the existing Oracle BI Apps components
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Customized and developed approach to load data into GL Star, AP Star, AR Star, Budget star Data Models using ETL tool Informatica
• Configured DAC - Data warehouse Access control for running of ETL jobs
• Worked on OOB and customized Informatica SDE, SIL,PLP adaptors, DAC,OBIEE
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on LDAP, External table authentication and Database authentication types.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Created reports according to user requirements and also created corresponding dashboards for the reports.
• Actively involved in deployment and post release support.
• Having good experience with writing Views and understanding of the materialized views and Discoverer EUL Metadata.
• Created the new reports and converted the existing Oracle BI Discoverer Business Area’s, workbooks and EUL Metadata in to OBIEE
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.

Environment: Oracle BI Apps 7.9.5, OBIEE 10.1.3.2, Informatica 7.9.1, Oracle E-Business Suite 9i, DAC, OBAW, Oracle10g, XML (BI) Publisher, SQL Developer, PL/SQL.

Confidential, Vienna, VA

Siebel Analytics / Informatica and Data warehouse developer

Responsibilities:

• Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of Siebel Analytics
• Develop Logical and Physical data models that capture current state/future state data elements
• Designed, Developed and Implemented an Enterprise Wide Reporting system and created, tested Report in the Dashboard.
• Designed, Developed and Tested Data security and Dashboard security in Analytics
• Migrated the Tested Code from Dev to QA and QA to Production of Repository, Dashboard Reports and Informatica mappings and workflow and DAC Entities.
• Designed the logical and physical data model for Siebel data warehouse to store OLAP data.
• Used Informatica Mappings and Transformations to load data into the data mart.
• Created & Called Stored Procedures and functions using Informatica.
• Created Worklets & Workflows to Schedule and Trigger Mappings.
• Used Update Strategy to update tables.
• Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
• Designed, Created and used Mapplets for Repeated functionalities.
• Sourced Data from multiple databases & files.
• Installed and configured Informatica Power Center and Informatica Client tools.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like XML Files, Flat files, COBOL Files, SQL Server, DB2 and loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update strategy, Lookup (Connected and Unconnected) to load the data
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Devised extensive PL/SQL Stored Procedures & Triggers to populate the base tables on daily basis and implementing business rules and transformations
• Performed Mapping Optimizations to ensure maximum Efficiency
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session
• Implemented complex mapping such as Slowly Changing Dimensions (Type 2) using Flag.
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for Bulk Loading.
• Performed extensive tuning of database and SQL queries, thereby enhancing efficiency using Execution Plan/TKPROF and Trace File
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
• Defined Upgrade steps and created Design Document for upgrade from version 7.5.x to 7.8.x
• Repository Upgrade, Database upgrade, Informatica Repository Upgrade.

Environment: Siebel Analytics 7.8/7.7, Informatica Power Center 7.1.4/6.1.1 , Siebel CRM, Oracle 7i,6i, SQL Server 2003/2000, DB2, PL/SQL, Flat files, SQL*Loader, SRMW, TOAD, UNIX, Windows 2000

Confidential, Texas

Siebel Analytics Developer

Responsibilities:

• Used the Siebel Analytics Administration tool to develop and enhance meta-data
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. ‘Dashboards’ were generated to provide insight into the financial reporting for insurance industry.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Build geographical report drill down from state maps to county maps to zip code maps.
• Involved with requirement gathering and interacting with Business Analyst and Business users
• Used Answers to create queries, format views, charts, and added user interactivity and dynamic content to enhance the user experience.
• Extensive experience working with views including charts, pivot tables, and narratives. And also, created selectors to drive interactivity in Business Intelligence requests.
• Worked extensively with dashboard prompts to filter dashboards and populate variables.
• Implicated in the specification and design documentation
• Design the Data Mart model using Dimensional Modeling methodology in conjunction with data architects and ETL team.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins
• Configured and enhanced Repository using Siebel Analytics Administration Tool
• Organized dimension attributes into hierarchical levels that represent the organizational rules and reporting needs required by the business.
• Created dimensional hierarchies, assigned levels and custom aggregation rules for each level, and configured cross-dimensional drill downs to get more detailed views of the data.
• Used Security setting in Siebel Administration tool to set up external database authentication for users.
• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement
• Implemented cache purging and seeding script and corresponding ibots.
• Upgraded from Siebel Analytics 7.8.4 to OBIEE 10.1.3.3

Environment: Siebel Analytics 7.5, Informatica 4.7, SQL Server 2003,SQL, SQL*Plus, TOAD, Windows X

Confidential

Responsibilities:

• Assembled system and software application documentation, informing users of training opportunities in the corporate learning center.
• Built, maintained, and repaired computer systems to improve speed, reliability, and efficiency of operation.
• Followed departmental procedures to purchase, configure, and install new and recycled hardware systems, maintaining corporate standards for system compatibility.
• Conducted security analysis to identify and address weaknesses. Office Manager/Remote Technical Support
• Built workstations, networks and Point Of Sale software for multiple small retail chains. Assessed and custom built computers to suit clients' needs provided telephone-based technical support for clients, going on-site if necessary. Assisted in development and implementation of network infrastructure. Assembled and soldered circuit boards, CPU, cooling system, power supply and wiring.
• Configured and installed desktop PC'S, resolved hardware/software issues, troubleshoot connectivity issues, and ensure user satisfaction.
• Experience with remote access software. Password recovery and maintenance.
• Improved stability and performance of system and network by upgrading Windows 98 to Windows XP Professional; saved all customer data on existing PCs, built new computers, migrating existing applications, and customizing configuration settings.
• Reversed prior history of single-drive data protection by implementing use of Ghost software to replicate image from primary to secondary hard drive.
• Implemented disaster recovery procedures using Veritas, Retrospect Pro, and Ghost managing repair and warranty program