PROFILE

• Over 10 years of experience in Information Technology with strong working knowledge in Business Intelligence and Data warehousing
• Over 8 years of design, development, administration and support experience in OBIEE 10g/OBIEE 11g / Siebel Analytics 7.x / OBIA 11g, 7.9.x and BI Publisher
• Over 6 years of experience in ETL development using Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformation Developer, Mapplet and Mapping Designer
• Expertise in end-end implementation of Business intelligence / data warehousing projects
• Well rounded and in-depth experience with OBIEE/Siebel Analytics Administration Tool, Dashboards, Answers, Web Administration, Catalog Manager, Delivers and DAC
• Extensive experience working with Answers Chart, Pivot, Radar, Pie, Scatter , Dashboards Prompts, Reports, Embedded Contents, Images, guided navigation links etc. , BI Publisher, Delivers and iBots
• Excellent working knowledge in Oracle BI Applications with sales analytics, service analytics, financial analytics, Supply chain and order management analytics marketing analytics and human resources analytics
• Excellent working knowledge in Business Intelligence infrastructure implementation using OBIEE server installation and configuration and good understanding of OBIEE server architecture
• Adhere to all OBIEE best practices and standards while performing development activities and maintain optimal application performance
• Excellent working knowledge in setting up procedures to extract, transform and load ETL data from operational and legacy systems to data warehouse using informatica
• Excellent knowledge in SQL and PL/SQL coding through various procedures , functions and packages to implement the business logic
• Involved in development of Test Plans, Test Cases and Executing Test Cases in quality center
• Excellent knowledge in through understanding of business requirements and translate them to technical design specifications
• Excellent working knowledge in working with waterfall and Agile methodology
• Excellent communication, self motivated, problem solving, positive attitude, ability to manage team and ability to work independently or co-operatively in a team
• Good experience in working with industries including Finance, Manufacturing, Telecommunication, Insurance, Healthcare and Media

TECHNICAL EXPERTISE

• Operating Systems : Windows NT/2000/XP, Sun Solaris8 and UNIX
• Languages : SQL, PL/SQL, TOAD, HTML, XML, Java script and Shell script
• Databases : Oracle 10g/11g, Ms-SQL Server 2005, Netazza and Teradata BTEQ, TPump, View Point
• Business Intelligence : OBIEE 10.1.3.4.2/OBIEE 11.1.1.7.0, OBIA 11.1.1.7.1/7.9.6.4, BI Publisher 11g
• , Business Objects BO , SSRS, Hyperion Interactive Reporting, MS Excel
• ETL Tools : Informatica 9.1/8.6.1 and Oracle Data Integrator ODI 11g
• CRM Tools : Siebel 7.x/8.x, Siebel Tools
• ERP Tools : Oracle EBS R12

RECENT PROJECTS

Client: Confidential

Role: OBIA Architect Design, Development and support

Confidential is a leading provider of medical devices, software and services for the Newborn Care, Neurology, Sleep, Hearing and Balance markets. Natus products are used in hospitals, clinics and laboratories worldwide. The project deliverables includes complete Oracle BI reporting solutions to the customer on Oracle Applications and Siebel CRM modules.

Responsibilities

• Worked with end users and IT manager for gathering Business requirements and getting the Sign-Off on the requirements by participating in the business discussions.
• Worked on Multi source environment with Oracle Applications and Siebel CRM Applications.
• Involved in OOTB Subject Areas validation for Financials, Order Management, Procurement, Seibel CRM Sales and Services Modules with Source systems and documented the validations for business training purpose.
• Worked on Custom Report development by doing the impact analysis on existing data model and customizing the OOTB data model.
• Leading and mentoring the offshore team to understand the data model and development and enhancement of OBIEE, ETL and DAC objects.
• Customized the Informatica mappings to make it fit for business requirements and custom reports development.
• Worked on RPD customizations and built custom star Schemas to accomplish the new reports development.
• Setup LDAP security for authentication and EBS and Sieble integration for Authorization and data level security.
• Provided the training on OBIEE to the end user.
• Installed configured and upgraded current environment to OBIEE 11.1.1.7.0 , OBIA 11.1.1.7.1, ODI 11.1.1.7.0 on Sandbox as per business requirement

Environment: OBIEE 11.1.1.7.0 , OBIA 7.9.6.4, OBIA 11.1.1.7.1, ODI 11.1.1.7.0, OBIEE Admin Tool, OBIEE Analytics Web Analysis, Dashboards, Agents and BI Publisher , Weblogic 10.1.3, Weblogic Admin Console, Weblogic Enterprise manager, Oracle EBS R12, Siebel 8.1.5, SQL, PL/SQL, Oracle 11g, Linux 5.6

Client: Confidential

Role: Lead OBIEE/ETL Developer Design, Development and support

Confidential is a leader in food services, facilities management, uniform/career apparel, health care institutions, universities/school districts, stadiums/arenas. ADS, KPM and MDM Projects are consolidated business-owned enterprise reporting environment to support Confidential Core Analytical reporting.

Responsibilities

• Worked on ADS, KPM and MDM projects for Report development using OBIEE and ETL development using Informmatica
• Converted about 25 business objects reports to OBIEE reports in ADS project and about 10 SSRS reports to OBIEE reports in MDM project
• Developed one new report and customized couple of existing OBIEE reports for KPM project
• Developed and customized Informatica mappings and workflows for KPM project
• Customized stored procedure, database views and informatica code to fix data issues in production for KPM project
• Customized instanceconfig.xml to fix report issues in OBIEE
• Migrated OBIEE RPD and reports, informatica code from dev to test and to production environment
• Customized/Developed OBIEE repository , reports and dashboards in 11g
• Applied performance tuning techniques to improve dashboard performance
• Developed informatica mappings, transformation logic, sessions and workflows in Informatica and load data from Oracle and SQL server databases
• Implemented different passive and active transformations like Source Qualifier, expression, Aggregate, Lookup, Filter, UNION transformation, Update Strategy and Router Transformations using transformation developer
• Point of contact for all production issues related to ADS, KPM and MDM projects.

Environment: OBIEE 11.1.1.6.2 , Informatica 9.1, Business Objects 6.0, Microsoft SSRS,OBIEE Admin Tool, OBIEE Analytics Web Analysis, Dashboards, Agents and BI Publisher , Weblogic 10.1.3, Weblogic Admin Console, Weblogic Enterprise manager, Oracle EBS R12, SQL, PL/SQL, Oracle 11g, SQL Server 2005,Windows Server 2008

Client: Confidential

Role: Senior OBIEE Administrator/Developer Install, Configure, Design, Development and support

Confidential is a diversified global insurer and the third largest property and casualty insurer in the Confidential. Confidential offers a wide range of insurance products and services, including personal automobile, homeowners, workers compensation, property, commercial automobile, general liability, global specialty, group disability, reinsurance and surety. Liberty Mutual's Human Resources department chosen to use OBIA HR Analytics as their new BI reporting tool.

Responsibilities

• Closely with business users and business analyst to understand business requirements
• Developed LM Talent Review subject area in OBIEE 10.1.3.4.2 and developed several reports and dashboards for Talent Management
• Customized workforce profile subject area and compensation, payroll dashboard/reports in OBIEE 10.1.3.4.2
• Involved in FIT GAP analysis between OBIEE 10.1.3.4.2 OBIA 7.9.6.2 and OBIEE 11.1.1.6.0 OBIA 7.9.6.3
• Installed and configured OBIEE 11.1.1.6.0 on new Linux servers
• Installed and configured OBIEE 11.1.1.6.0 and OBIA 7.9.6.3 HR Analytics on windows 7 and deployed OOTB RPD and web catalog to Linux server
• Installed and configured DAC 10.1.3.4.1 Data Warehouse Administration console on Linux server and applied new patch available on Oracle Support.
• Upgraded OBIEE 10g RPD and web catalog to OBIEE 11.1.1.6.0 RPD and web catalog
• Fixed all issues encountered during RPD upgrade and checked global consistency
• Merged upgraded RPD with OOTB 7.9.6.3 RPD and deployed to Linux server
• Merged upgraded web catalog with OOTB web catalog and deployed to Linux server
• Configured scheduler server, configured SMTP in enterprise manager and tested iBots
• Validated the OBIEE environment, Weblogic console, enterprise manager, presentation server, BI Server, scheduler server etc
• Applied patches to upgrade OBIEE 11.1.1.6.0 to OBIEE 11.1.1.6.2 and validated the environment
• Configured Usage tracking in OBIEE 11.1.1.6.2 and tested OOTB usage tracking reports
• Redeveloped all chart reports in OBIEE 11.1.1.6.2
• Converted pivot table to table view in some reports
• Modified formatting settings as per business requirements
• Fixed all reporting issues during testing phase and UAT
• Modified RPD to fix report related issues
• Validated application roles, application policies, row level security, dashboard level security, column level security
• Configured NQSConfig.INI, instanceconfig.xml in OBIEE 11.1.1.6.2 as per OBIEE 10g customizations
• Configured SSO OBIEE 11.1.1.6.2 and Oracle EBS R12 integration and logout, logoff URLs
• Validated talent management workforce profile dashboards and row level security from Oracle EBS R12
• Migrated OBIEE RPD and web catalog from performance environment to production environment
• Customized OBIEE repository , reports and dashboards in 11g
• Customized look and feel of reports and dashboards and also replaced Oracle banner with Liberty Mutual logo as per business requirements
• Applied performance tuning techniques to improve dashboard performance
• Customized and developed SDE and SIL mappings, transformation logic, sessions and workflows in Informatica and load data from Oracle EBS database to EDW
• Implemented different passive and active transformations like Source Qualifier, expression, Aggregate, Lookup, Filter, Update Strategy and Router Transformations using transformation developer
• Developed new aggregate fact tables to improve OBIEE dashboard performance
• Customized DAC tasks, subject area, indices, execution plan and schedule daily incremental load
• Supported and fixed issues raised in quality center during pre production and post production

Environment: OBIEE 11.1.1.6.2 , OBIEE 11.1.1.6.0, OBIA 7.9.6.3, OBIEE 10.1.3.4.2, Weblogic 10.1.3, Weblogic Admin Console, Weblogic Enterprise manager, Informatica 9.1, DAC 10.1.3.4.1 OBIEE Admin Tool, OBIEE Analytics Web Analysis, Dashboards, Agents and BI Publisher , Oracle EBS R12, Oracle 11.1.2, Windows 7 and Linux 5.5

Client: Confidential

Role: Senior OBIEE Developer Design, Development and support

Dish Network billing system got changed and is maintained by Confidential, a 3rd party company. All transactional systems got upgraded to new billing system called ACP hence all datawarehouuse projects and reporting projects also customized. Involved in development of multiple projects Programming payments, DNS and also upgraded OBIEE 10.1.3.4.1 to OBIEE 11.1.1.5 in Dish Network.

Responsibilities

• Closely work with business users and business analyst to understand business requirements
• Developed programming payments reports using Hyperion interactive reporting tool, later integrated all .bqy files to Hyperion workspace in production
• Developed OBIEE repository for DNS technician performance project and also involved in PI dashboard/reports development
• Developed OBIEE repository for DNS organization performance and also involved in business review dashboard/reports development
• Implemented Dashboard level and Data level security in OBIEE Dashboards
• Installed and configured OBIEE 11.1.1.5.0 on new Unix server
• Installed and configured OBIEE 11.1.1.5.0 and OBIA 7.9.6.3 HR Analytics on windows 7 and deployed OOTB RPD and web catalog to Unix server
• Upgraded OBIEE 10g RPD and web catalog to OBIEE 11.1.1.5.0 RPD and web catalog
• Fixed all issues encountered during RPD upgrade and checked global consistency
• Merged upgraded RPD with OOTB 7.9.6.3 RPD and deployed to Unix server
• Merged upgraded web catalog with OOTB web catalog and deployed to Unix server
• Configured NQSConfig.INI, instanceconfig.xml in OBIEE 11.1.1.5.0 as per OBIEE 10g customizations
• Fix all RPD, reports and dashboard related issues after upgrading to OBIEE 11.1.1.5.0
• Customized OBIEE repository , reports and dashboards with new features, look and feel
• Developed BTEQ scripts to load flat file data into EDW using import/export option
• Worked with DBA to collect statistics in Teradata that improves dashboard query performance
• Applied performance tuning techniques to improve dashboard performance
• Supported and fixed issues raised in quality center during pre production and post production

Environment: OBIEE 10.1.3.4.1, OBIEE 11.1.1.5.0, OBIEE Admin Tool, OBIEE Analytics Web Oracle Answers, Dashboards, Delivers and BI Publisher , Hyperion 9.0.1, Hyperion Interactive Reporting, Teradata SQL Assistance, BTEQ, View Point , Netazza, Windows XP and UNIX

Client: Confidential

Role: OBIA Architect/Developer ETL /OBIA/BI Publisher Design, Development and support

Confidential Project is a consolidated business-owned enterprise reporting environment to support Confidential Core Analytics reporting.

Responsibilities

• Work with business users and business analyst to understand business requirements
• Involved in GAP Analysis between Siebel source system, OOTB Sales Analytics application and business requirements to understand the level of effort in ETL and OBIA development
• Involved in design discussions with business users and business analyst and developed technical design documents based on functional requirements and GAP analysis document
• Involved in installation and configuration of Informatica power center 8.6.1, DAC 10.1.3.4.1, OBIEE 10.1.3.4.1, OBIA 7.9.6.2 and BI Publisher on development and QA Servers
• Customized and developed SDE and SIL mappings, transformation logic, sessions and workflows in Informatica and load data from Siebel and Sales data mart into Oracle data warehouse OBAW
• Implemented different passive and active transformations like Source Qualifier, expression, Aggregate, Lookup, Filter, Update Strategy and Router Transformations using transformation developer
• Developed data change capture for new mappings in Informatica and DAC
• Configured delete triggers for set of tables as per business requirements
• Customized DAC tables, tasks and created tasks, subject areas and execution plans for custom/new Informatica workflows and scheduled Executions plans for daily incremental load and weekly full load
• Developed Integration objects in Siebel and RTF templates for parameterized BI Publisher reporting Book store adoption report, EZ Print Report and New titles at glance in Siebel
• Implemented Dashboard level and Data level security in OBI Dashboards
• Troubleshoot the issues identified during and after the development of ETL, DAC and BI Publisher Reports
• Involved in data validation from Siebel to OBAW and fixed the defects during QA
• Involved in performance tuning to improve the data load performance by creating indexes, table partitions, created materialized views in under lying database as well as tuned mappings, sessions and workflows
• Implemented performance tunings techniques on OBIEE RPD, Reports, dashboards, Oracle database, ETL Informatica mappings, sessions etc
• Migrated Informatica repository, DAC repository, OBIEE RPD, web catalog from dev to test and to QA

Environment: OBIEE 10.1.3.4.1, OBIA Sales Analytics 7.9.6.2 , OBIEE Admin Tool, OBIEE Analytics Web Oracle Answers, Dashboards, Delivers and BI Publisher , DAC, Informatica8.6.1, Siebel 8.1.1, Oracle 11g, Windows XP and IBM AIX

Client: Confidential

Role: Senior BI Apps Consultant OBIA/ETL Design, Development and support

Confidential Project is a consolidated business-owned enterprise reporting environment to support Confidential Core Analytics reporting.

Responsibilities

• Closely work with business users and business analyst to understand business requirements and existing reports and dashboards available in Business Objects
• Involved in the implementation of Financial , Supply chain and Order management dashboards
• Integrated OBIEE with Oracle EBS R12 application as per business requirement
• Involved in GAP Analysis between existing source system, OOTB Analytics application and business requirement and identified the Gaps and documented
• Developed technical design documents based on functional requirements and GAP analysis document
• Customized/developed SDE and SIL mappings, transformation logic, sessions and workflows in Informatica and load data from Oracle EBS into data warehouse
• Implemented different passive and active transformations like Source Qualifier, expression, Aggregate, Lookup, Update Strategy and Router Transformations using transformation developer
• Customized DAC subject areas, tables, execution plans for custom ETL mappings /workflows
• Customized OOTB Analytics repository to create new measures, logical columns mappings, dimensional hierarchies, filters in logical table sources, variables, row level security and so on
• Implemented data level security, subject area level security and dashboard level security
• Optimized the performance by developing the aggregated fact tables and configured RPD with aggregated tables
• Created/Customized Financials dashboards General ledger, payables, receivables, profitability and Supply chain and Order management Inventory, Order management
• Involved in development of Map Viewer interface with OBIEE and provided ability to display maps in OBIEE based on data in reports and dashboards
• Developed map based reports and provided ability to drill into maps based on dashboard/ reports drilldown capability
• Created iBots for selected dashboard reports for performance improvement
• Migrated ETL mappings/Workflows, DAC repository, RPD, reports, dashboards from dev to test and to production
• Troubleshot ongoing Production issues by reviewing design changes made to production systems and made corresponding changes to informatica mappings/workflows and/or OBIEE RPD, reports and dashboards

Environment: OBIEE 10.1.3.4.1, Analytics Applications 7.9.6.1 applications, OBIEE Admin Tool, OBIEE Analytics Web Oracle Answers , Dashboards, Delivers and BI Publisher , DAC, informatica8.6.1,Oracle EBS R12, Mapviewer, APEX, Portal Integration Oracle 11g, Business Objects 7.0, Windows XP and Linux 6.0

Client: Confidential

Role: Lead developer Design, Development and support

Confidential Project is a consolidated business-owned enterprise reporting environment to support Confidential Core HR Analytics reporting.

Responsibilities

• Closely work with business users and business analyst to gather business requirements and documented technical design specifications
• Assist other developers in the implementation of repository, reports and dashboard development
• Customized OOTB Human Resources Analytics repository to create new measures, logical columns mappings, dimensional hierarchies, filters in logical table sources, variables, row level security and so on
• Optimized the performance by implementing group based security and customized stored procedure to load visible emp wids in security table based on security group
• Customized SDE and SIL mappings in Informatica designer to load data into new columns in dimension and fact tables
• Consolidated all subject areas in presentation layer into single subject area called EMC HR Data and modified all reports in answers
• Created new reports in answers for executive dashboard, Compensation HR, Headcount and workforce profile dashboards
• Created Payroll, Hires, Promotions and Report Links dashboards as per the Business requirements
• Customized OBIEE dashboard skin and styles for Nexus dashboards with corporate style using custom style sheet .css and XML coding
• Created iBots for selected dashboard reports for performance improvement
• Migrated reports, dashboards from dev to test, production using catalog manager
• Migrated repository from MUD to dev, test and production
• Troubleshoot critical technical issues opened by Nexus users in quality center
• Production maintenance and support

Environment: OBIEE 10.1.3.4.0,Human Resources Analytics 7.9.5 applications, OBIEE Admin Tool, OBIEE Analytics Web Oracle Answers , Dashboards, Delivers and BI Publisher , informatica8.6,Peoplesoft 8.9, Oracle 11g Windows XP and Linux

Client: Confidential

Role: Senior Architect Design, Development and Administration

SMF Sales, Marketing and Finance Project is to consolidate business-owned systems into enterprise reporting environment IDW , to support EMC revenue and operational reporting.

Responsibilities

• Closely work with business users and business analyst to gather business requirements and documented technical design specifications
• Work with OID team to install and configure OBIEE Dev, Test, Production environment on cluster environment
• Build multi user development MUD environment, created and maintained projects on master repository
• Created security groups in repository, web groups in presentation services and configured privileges for security groups in Administration
• Customized OOTB Financial Analytics business model with multi start schema, dimensional hierarchies, session variables, logical dimensions and logical fact tables with measures and time series calculations
• Developed FIN Consolidated Financial Rev, master data and inventory subject areas repository and created new measures, logical columns mappings, dimensional hierarchies, filters in logical table sources, variables, row level security and so on
• Optimized the performance with the help of aggregated table structure and cache management
• Created security groups in repository and implemented row level, table level and column level security
• Developed several reports in answers for Customer, Revenue and Marketing Dashboards
• Developed BI Publisher reports using OBIEE subject area and custom SQL as per business requirements and made BI publisher reports available on OBIEE Dashboards
• Customized look and feel of the dashboards as per the business requirements
• Developed iBots to pre-seed dashboards using server cache technique in Delivers
• Developed Dashboard level security and shared folder level security
• Migrated reports, dashboards from dev to test, production using catalog manager
• Migrated repository from MUD to dev, test and production
• Production maintenance and support

Environment: OBIEE 10.1.3.4.0, Financial Analytics 7.9.3, OBIEE Admin Tool, OBIEE Analytics Web Oracle Answers, Dashboards, Delivers and BI Publisher , informatica8.1.1, Oracle 10g, Oracle EBS, Windows XP and Linux

Client: Confidential

Role: Project Lead OBIEE/ETL Production Support Development

Cisco has large OBIEE analytical interface that optimizes current data in Siebel data store, allowing user to access a range of pre-built reports and to create bespoke reports.

Responsibilities

• Troubleshoot tickets opened by business users and customized repository to fix defect in the metadata repository in dev and migrate code to test and production
• Customized dashboard reports to fix defects in dashboards and migrate code to test and production
• Created new reports/dashboards as per the enhancement requirements provided by business users
• Manage team Provided application support and maintenance in onsite/offshore model, identified issues and implemented efficient solutions
• Created iBots to deliver analytics content dashboard/report based on schedule and automated iBots to deliver weekly or monthly
• Customized repository, dashboards and work with DBA to create indexes, table partitions and aggregate tables to improve dashboard performance
• Monitor OBIEE Server, Informatica server and trouble shoot server maintenance issues
• Customized informatica mappings and workflows as per the requirements provided by business users
• Monitor ETL jobs and troubleshoot defects for failed ETL jobs
• Documented technical designs for all enhancements requests provided by business users

Environment: J2EE, PLSQL, OBIEE 10.1.3.2.0, OBIEE Admin Tool, OBIEE Analytics Web Oracle Answers and Dashboards , informatica 7.1.2, Siebel 7.8, Windows XP, Oracle 10g and SQL Server 2005

Client: Confidential

Role: Siebel Analytics Support Analyst

Confidential is a Confidential services company with head offices in Confidential. Through its Confidential division it is a supplier of telecoms services to corporate and government customers worldwide. State Street has large Siebel analytics reporting environment to support users reporting requirements

Responsibilities

• Responsibilities include designing the documents which is based on the requirement specifications.
• Standard Dashboards requests data validation.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Perform unit testing at various levels of the ETL.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router and rank.
• Involved in the Development of Repository. Created Dimension Hierarchies.
• Created New OBIEE Requests with various templates like table, charts, pivot tables etc. Created Dashboards and placed the Requests on the Dashboard.
• Implemented the Data Level and Object Level Security.
• Worked on DAC and configured email notifications on DAC scheduled Loads
• Upgraded Siebel Analytics from 7.5 to 7.7.1 and then to 7.8.4 and OBIEE 10g
• Optimized the performance with the help of aggregated table structure and cache management
• Created security groups in repository and implemented row level, table level and column level security
• Developed several reports for risk, compliance, accounting and performance Dashboards
• Developed iBots to pre-seed dashboards in delivers
• 24x7 Production support for all Siebel analytics and Informatica issues

Environment: Siebel Analytics 7.5/7.7.1/7.8.4, OBIEE 10.1.3.2.0 platform, Siebel Analytics Admin Tool, Analytics Web Siebel Answers, Dashboards and Delivers , informatica 6.1, Windows XP and Oracle 8i/9.2.0.6