Summary:

• 8 years of experience in Business Intelligence using Oracle Business Intelligence OBIEE 10g and 11g. Strong experience in OBIEE 11.1.1.X/10.1.3.x,Informatica and BI Applications,Siebel Analytics 7.x modeling and developing Metadata, Repositories, Dashboards and Reports. Scheduling and Monitoring ETL routines through DAC on different environments like Development and Test environment.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Snowflake Schema, Fact Dimensions tables, Physical Logical Data Modeling.
• Experience in OLTP / OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact, dimensional tables, slowly changing dimensions, Physical and Logical Data Modeling.
• Implemented Oracle BI Apps in all phases like implementing Out of order Box Vanilla mappings prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW , OBIEE RPD development, reports and dashboards
• Configured Answers ad-hoc querying, reports , Interactive Dashboards with drill-down capabilities charts/tables/graphs , Delivers/iBots alerts , administered Web Catalog Objects pages, folders , configured OBI Publisher and integrated Publisher reports into dashboards by creating a customized layout.
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment MUDE .
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented BI solutions for Pharmaceutical, Retail, Financial and other sectors for their various business processes i.e. Marketing, Sales, Services and Customer Care, Energy etc.
• Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets , data modeling, data cleansing, data loading.
• OBIEE- SECURITY- SSO- LDAP-- OID, External Table, OBJECT level Security, ROW level Security using INIT Blocks. Experience with Federated Query tuning strategies.
• Detail understanding of OLTP and OLAP Data models to create and manage the repository with the available metadata using OBIEE.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 8.x/ 7.x.
• Proficient in coding in SQL, PL/SQL, procedures/functions, packages, Explain Plan, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views using SQL Plus, TOAD.
• Expertise in all phases of the Software Development Life Cycle SDLC including Analysis, Physical and Logical design, Resource Planning, Code development, Testing, Implementation and Maintenance.
• Expertise in Debugging, Optimizing and Performance tuning of OBIEE reports.
• Outstanding communication, analytical and presentation skills.
• Ability to provide timely solutions and work within specified time frames.

Technical Skills:

• Reporting Tools OBIEE 11.1.1.7/10.1.3.x, ODI, OBI Publisher 11.1.1.7/10.1.3.4, Siebel Analytics 7.8x/7.7x/7.5x, OBIA BI Applications 7.9.X
• ETL Tools Informatica Power Center 8.x/7.x/6.x, DAC 7.8.5
• Operating Systems UNIX, MVS, Windows95/98/NT/XP/7/8, MS DOS
• Languages SQL, PL/SQL, COBOL, JCL, Easytrieve
• OLTP / Middleware CICS, MQ Series
• Tools Utilities SQL Developer, SQL Plus, PL/SQL Developer, TOAD, SPUFI, QMF, File Aid, ChangeMan, MS Office, IBM Utilities, SDF II
• Databases Oracle 11g/10g/9i/8i, SQL Server 2000, DB2 UDB, VSAM, MS- Access
• Web Technologies HTML, CSS/JavaScript, AJAX, XML
• Data Modelling Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling Star Schema, Snow-Flake, FACT, Dimensions , Entities, Attributes, Cardinality, ER Diagrams, Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer, OLAP.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. OBIEE Developer

Responsibilities:

• Involved in every OBIEE project from initial design phase through production implementation release. Duties include requirement gathering, design, development, testing and release.
• Developed all layers Physical, Business and Presentation of the OBIEE repository from the startup as per business requirements.
• Created customized dashboard layout in order to neatly fit and present OBI Publisher reports to the customers.
• Worked with OBIEE Answers, Intelligence Dashboards and OBI Publisher reports. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager.
• Involved in customizing Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards.
• Identified Data warehouse and staging tables, workflows/mappings and DAC tasks related to Finance data and customized mappings to load historical data
• Created numerous reports and dashboards with drill down and navigation capabilities.
• Administered the entire OBIEE application. Implemented LDAP security, managed access to the reports through roles and permissions.
• Developed tuning process for the longest running mappings by turning them to SQL procedures for quicker run times.
• Worked with data warehouse architect in designing and tuning the data as per reporting needs.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Worked in Catalog Manager to migrate Answers objects and Dashboards between the tiers.
• Created several BI Publisher reports and developed standard RTF templates.
• Wrote stored procedures and functions for user authorization and report filtering purposes.
• Trained all the team members on creating OBIEE Answers reports, Dashboards and OBI publisher reports.
• Involved in end user training of OBIEE Dashboards.
• Proficient in coding in SQL, PL/SQL, procedures/functions, packages, Explain Plan, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views using SQL Plus.

Environment:OBIEE 11.1.1.7/10.1.3.4.1, Teradata, Oracle 11g/10g, BI Publisher, ERWIN PL/SQL Developer, SQL Developer, UNIX Shell Script, Microsoft Visio, Windows XP/7/8.

Confidential

Sr. OBIEE Lead Developer / Admin /ETL Developer

Responsibilities:

• Requirement analysis gathering, analyzing the functional and technical specifications.
• Gathered requirement and analysis for contact center telephony customized analytics.
• Work closely with business users to ensure completeness of requirements.
• worked mainly on HR Analytics and worked with ETL team to develop tables and generated reports, as per requirements
• Worked with detailed reports on various aspects of financial transactions and marketing data to brokers, historical sales, customers and financial centres on daily basis.
• Extracted the pre-built BI solutions of tables using Oracle BI Apps 7.9.6. Marketing Analytics
• Preparing MD50 and MD70 documents for the new functional requirements.
• Working on the BI publisher reports, dashboards, adhoc reports.
• Implemented Security by creating roles web groups using LDAP Authentication.

• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.

• Extensively worked on admin tool, Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports, and cutomized widgets.
• Designed, developed and modified OOTB reports and dashboards.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Configured users, roles and privileges in administration console.
• Worked on security for users based on LDAP Authentication and SSO in Production and also other Authentication types External table authentication and Database in other environments.
• Worked extensively on Custom Build Real-time OLTP source and Non Real-Time Reports to enable Market/Corporate Users to Order Management, Installation Management and Cash Management.

• Created Test Cases based off of the design specifications.
• Created mock reports as per the user requirements.
• Developed liaison with the Business to translate Business issues into IT solutions.
• Created adhoc reports and dashboard mock up as per the requirement.
• Wrote SQL Queries to test the transformations.
• Aggregate Navigation-Creating aggregate tables using materialized views.
• Executed Test cases in all phases of testing Regression testing, Integration Testing, System testing, end-to-end testing and UAT.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Involved in adding all the newly developed Dimension, General, Aggregate and Fact tables in to DAC and creation of new Subject Areas.
• Observed configuring DAC environment created and scheduled execution plans.
• Develop Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.
• Performed Report Validation and Integration Testing and manipulations using SQL.
• Exposure and knowledge of ETL transformation using ODI.

Environment: Oracle BI Apps 7.9.6, OBIEE 10.1.3.4, Oracle10g, ODI, DAC 10.1.3.4.1, Oracle 10g R2, ERwinr7.3, SQL, SQL Developer 1.5, HTML, Solaris 5.1, Windows Server 2003.

Confidential

OBIEE Developer

Responsibilities:

• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository .rpd .
• Worked with business analyst and users Financial Advisors or FAs to gather analytics requirements and created the business model using star schemas.
• Worked with System Engineering team to design Facts, Dimensions and Hierarchies of the business model.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Creating global filters, complex queries, prompts, reports charts, tables, graphs in Answers.
• Setup and administered Usage Tracking using the direct insert process.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Configured repository and session variables to get dynamic reports and dashboards.
• Good working knowledge of Trader, Broker, and Mutual fund tables.
• Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Developed Informatica mappings and mapplets to build key interfaces using transformations Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator for loading the data into data warehouse.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment: OBIEE 10.1.3.4, Informatica 8.1, OBI Publisher 10.1.3.4, SySQL Server 2005, Oracle 10GR2, TOAD, Windows XP.

Confidential

Siebel Analytics/ETL Developer

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Configure Interactive Dashboards with delivers/iBotsto alert the marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler andiBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Designed and developed new Aggregates using Informatica ETL processes.
• Created mappings for initial load and daily updates using Informatica.

Environment: Siebel Analytics 7.5.2, Informatica 6.1, Oracle 8i, UNIX, SQL server, Windows NT 2000

Confidential

ETL Developer

Responsibilities:

• Created and customized database with appropriate table spaces to increase the performance.
• Created stored procedures and triggers to view, update and enter the check-in and checkout procedures.
• SQL Loader was used to convert the data from the Excel to oracle tables.
• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Sub-queries and joins were extensively used in stored procedures.
• Created database triggers to automate the transactions that take place online.
• Used dynamic SQL to find out the availability of tickets.
• Optimize the SQL statements using hints and created SQL scripts to tune performances and makebackups.

Environment: Oracle 8i/7i, PL/SQL, Visual Basic, ASP, HTML, JavaScript, VB Script