Objective:

Seeking a challenging opportunity where I can make optimum use of my knowledge and experience in a competitive environment which would enable me to improve my skills and strengths and also contribute to the growth and success of an organization.

Overview:

• 8 years of IT experience involving Analysis, Design, Development and Implementation using standard SDLC methodologies.
• Over 6 years of experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence OBIEE / Siebel Analytics, including 3 full life cycle implementations.
• Expertise in data modelling, design and development of ETL Data mart, Development/Administration of DAC, Informatica and OBIEE repositories, building OBIEE Dashboards/Reports and OBI Publisher reports in Banking, Financial, Pharmaceutical, and Sales Marketing domains.
• Extensive hands-on expertise using Informatica 8.x/7.x/6.x/5.x and Erwin Data Modelerwithstrong business understanding of Banking, Insurance, Finance and Pharmaceuticals-Healthcare and Telecom sectors.
• Expertise in design and development of the three layers Physical/Business Model and Mapping/Presentation of an OBI Metadata Repository using Oracle BI Administration Tool.
• Extensive experience in OBIEE 11.1.1.5/10.1.3.3/10.1.3.4.x, Oracle BI applications 7.9.5/7.9.6 and Siebel Analytics 7.7.1/7.8.5 which includes creating, configuring, customizing and managing repository and Presentation services Answers, Dashboards Delivers , OBI/Siebel iBots BI Scheduler , BI publisher, BI RPD and Web-catalog administration.
• Experience installing and configuring OBIEE Platform, DAC and out of box BI applications 7.9.5/7.9.6
• Experience in Installing, configuring and customizing DAC execution plans, subject areas, tables, task and monitoring ETL process using DAC 7.9.5, 10.1.3.4.1 Informatica workflow manager
• Strong experience in Customizing the OOTB RPD file for Oracle/ Oracle Financials for GL, AP and AR Subject Areas.
• Configured Answers ad-hoc querying, reports , Interactive Dashboards with drill-down capabilities charts/tables/graphs , Delivers 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.
• Proficient in ETL processes of creating Source/Target definitions, building Mappings/Mapplets using various Transformations, creating and monitoring Sessions/Workflows.
• Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets , data modeling, data cleansing, data loading.
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• Used DAC Data Warehouse Administration Console to configure, administer, load and monitor modular data warehouse applications.
• Experience in writing shell scripting for various ETL needs and worked on integrating data from flat files mainframe .
• Extensive experience in Unit, Regression, Performance, Integration and User Acceptance testing methodologies.
• Expertise in Debugging, Optimizing and Performance tuning of OBIEE reports.
• Expertise in Transportation,Financial, Sales/Marketing, Telecom, Retail and Pharmaceutical domains.
• Strong conceptual background of RDBMS and access methods SQL, PL/SQL.
• 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.6/10.1.3.x, ODI, OBI Publisher 11.1.1.6/10.1.3.4, Siebel Analytics 7.8x/7.7x/7.5x, 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/Administrator

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.
• Implemented key projects like SFS, ARRA which involved a variety of Answers and OBI Publisher reports integrated into OBIEE dashboards.
• 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.
• Customized OBIEE repository by adding custom columns and tables using BI administration tool for Service Analytics tables like W ACTIVITY F, W AGREE F, W AGREEITEM F, W QUOTE D, W OPTY D tables in Service Analytics Oracle CRM .
• Involved in customizing Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards. The tables like W AP BALANCE F, W AR BALACE F, and W GL ACCOUNT D were customized as per user requirements.
• Based on user requirements, DAC tasks and mappings were debugged and DAC parameters were changed to load multiple Subject Areas into OBA Warehouse.
• Identified Data warehouse and staging tables, workflows/mappings and DAC tasks related to Finance data and customized mappings to load historical data
• Took back-up of DAC, BI repositories and BI Web catalogs
• 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.
• Optimized performance by tuning the Informatica ETL.
• Worked on various issues on existing Informatica Mappings to produce correct output.
• Developed Informatica SCD type-I, Type-II and Type III mappings and tuned them for better performance. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• 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
• 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
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Worked in Catalog Manager tomigrate 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.
• Worked on Primavera BI publisher and developed, tuned many reports for P6.
• Trained all the team members on creating OBIEE Answers reports, Dashboards and OBI publisher reports.
• Involved in end user training of OBIEE Dashboards.

Environment:OBIEE 11.1.1.5/10.1.3.4.1, BI Apps 7.9.6, DAC 10.1.3.4.1,, Oracle 11g/10g, BI Publisher, Informatica 7.x, ERWIN PL/SQL Developer, SQL Developer,UNIX Shell Script, Microsoft Visio, Windows XP/7/8.

Confidential

OBIEE/Siebel Analytics

Responsibilities:

• Involved in all the OBIEE projects from initial phase to the production release like requirement gathering, design, development, testing and release.
• Customized OOTB Out of the box Sales Analytics and Oracle Incentive Compensation repository as per the business requirements.
• Personally implemented most key projects of Empire like Empower rollout which involved building dashboards for Order Management, Order Fulfillment, Customer Service, Installation Management, Cash Management and Incentive Compensation.
• Worked with OBIEE Answers, Intelligence Dashboards. 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.
• Worked with onshore and offshore team of 5 developers and led the team in the direction of development.
• Deployed the workflows to the Siebel DAC and created dependency and dependent hierarchical tasks and monitored all the tasks in the execution plans that were running, scheduled, completed and failed with DAC feature called run history and resolved the failed ones. Streamlined the Execution plans with their respective tasks in Siebel DAC.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analysing the database systems currently in use.
• Complete understanding of the proposed Architecture/Design for Business Model and the Metadata Modeling for proposed architecture. Recommended design alternatives to confirm to the business requirements, Worked on reporting in data modeling to satisfy the end user requirements. Maintained Referential integrity, Dimensional hierarchy and Aggregations at the Metadata level. Configured OOB/Custom Siebel Repository using Siebel Analytics Administration Tool, Created Repositories using Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Involved to translate the business rules into mappings to include OLTP custom columns tables from Siebel Billings application system into OBA warehouse
• Worked on tuning the longest running mappings by turning them to SQL procedures for quicker run times.
• Performed Data Migration using EIM tables to load data from Non-Siebel systems like POS, EIMS, and Epicor to Siebel EIM tables. Worked on creating .ifb files to load the data from the EIM tables to main Siebel tables.
• Experience in Oracle EBS R12.
• Involved in Production support for DAC and Analytics and helping users with any questions regarding the reports or the data.
• Developed and support the extraction, transformation and load process ETL for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment :OBIEE 10.1.3.4, BI Apps 7.9.6, Oracle EBS R12, Oracle Incentive Compensation, Data warehouse application console DAC 7.8.5,Informatica 7.x, Oracle 8.0.x/8.1.5, ERWIN Sybase, SQL Server 2000, TOAD, UNIX Shell Script, and Microsoft Visio.

Confidential

Siebel Analytics/OBIEE Developer

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in installation, configuration and administration of Siebel Analytics server/repository, DAC client/server.
• Configured out-of-the box and custom Analytics/Dashboard reports using Siebel Answers.
• Involved in designing and development of building Physical Layer, Business model and presentation layer.
• Designed and built Siebel Analytics data model, designed and customized Star and Snowflake schemas by extending Fact and Dimension tables.
• Installed and configured Oracle Business Intelligence Suite OBIEE 10.1.3.2 in development environment to explore the new features like enhanced Data Mart automation, Microsoft Office integration, BI Publisher, Improved Data Visualization and End User Personalization.
• Developed strategy for migration from Siebel Analytics 7.7.2 toOBIEE 10.1.3.2.
• Developed data maintenance strategy which included proven data standard rules.
• Implemented Security by creating roles, web groups, external tables and LDAP.
• Developed delta/incremental complex Informatics ETL process and Oracle Packages i.e., Mappings and Mapplets using various transformations.
• Implemented the session partitions, for Performance Tuningof sessions by running parallel sessions and re-arranging the session's dependencies.

Environment:OBIEE 10.1.3.2, Siebel Analytics 7.7.1/7.8, Oracle 9i/10G, TOAD, PL/SQL, Windows 2000

Confidential

Siebel Analytics 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/iBots to alert the marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.
• 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 ETL processes.
• Created mappings for initial load and daily updates

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

Confidential

Oracle 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 make backups.

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