SUMMARY

• Overall 9 years of experience as BI Analyst in IT field
• Experience in full life cycle implementation (SDLC) of Oracle Business Intelligence/Siebel Analytics in UNIX/Solaris and Windows environments
• Extensive Business Intelligence experience using Oracle Business Intelligence EE 11.x/10.x(OBIEE), Siebel Analytics 7.x
• Experience in Banking, Manufacturing, Telecom, Medicare and Retail domains
• Strong Knowledge of Data Warehousing concepts and Dimensional modeling using Star schema and Snowflake schema.
• Expertise in Siebel Analytics Web in designing Dashboards and Answers.
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router and rank in Informatica.
• Involved in upgrade from OBIEE 10.1.3.4.1 to 11.1.16.2 BP1
• Performed Informatica code migrations, test, debug, document and maintain programs and monitor according to Best practice standards
• Expertise in developing Oracle BI / Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer),Interactive Dashboards / Reports with drill-down & drill-across capabilities using global & local Filters, Security Setup, External Tables, Cache Management, configuration of Analytics Metadata objects, Web Catalog Objects and scheduling iBot.
• Worked on repository variables and initialization blocks to initialize the system session variables for defining security, creating filters and build the business logic.
• Had strong experience in connecting the physical connection pool to different data sources
• Worked with Metadata in the Business model & mapping layer
• Proficient in working with OLTP and OLAP database system.
• Trained and mentored new hires in OBIEE with documentation support
• Applied graphical settings in the Dashboards & Reports using Java Scripts
• Expertise in debugging, optimizing the performance tuning of Oracle BI / Siebel Analytics Repository & Dashboards / Reports
• Worked on both standard alone and out of box model for OBIEE
• Multi-platform experience on UNIX / Solaris and Windows Server family of products.
• Experience in BI Publisher as per providing the reports as per the user requirements
• Created iBOTS using BI Delivers and send reports as per scheduled slots to business users
• Having good experience in handling Development & Production Supports issues as per Service Level Agreements (SLA's). Reviewer for the deliverables for around 66 OBIEE applications and ensured that the deliverables meet OBIEE standard guidelines
• Responsible for preparing checklists about the procedures carried out through development, Testing & deployment phases
• Played a key role as Technical point of contact for queries raised by OBIEE developers.
• Responsible for overall deployments of analytics development for many modules in the project.
• Implemented Data/Object level security in OBIEE
• Excellent Team Management Skills with good business acumen, effective communicator, experience in working with Business Users, Directors, Senior Managers and Executives and Department Heads
• Highly Committed, Enthusiastic, Creative team player possess good interpersonal, written and verbal communication skills

EDUCATION:

TRAININGS/CERTIFICATIONS:

• Completed the Oracle 10g: Analytics Overview & Oracle BI Applications 7.9: Develop a Data Warehouse course from Oracle
• Certified onInformatica 9.X trainingfrom Informatica
• Trained on ER/Studio Data Modeling Tool.
• Conducted HIPPA training across Health Care systems.
• Possessed certifications on 1Z0-007 and on OBI applications from Oracle

TECHNICAL SKILLS:

BI/ETL

OBIEE 11g,OBIEE 10.1.3.4,OBIEE 10.1.3.3, SiebelAnalytics7.8.5/7.7, OBIEE Administration Tool, BI Answers, Interactive Dashboards,
Delivers, BI Publisher, Noetix, OWB,SQL Server Management Studio
Release 2,ODS,Informatica

Database

Teradata 12.0.0.10,Oracle 11i, Oracle 11g/10g/9i/8i,SQL Server

Operating Systems

UNIX, Ms-DOS, Windows 2000/NT/XP/Vista,Solaris

Oracle Tools

Teradata SQL Assistant, TOAD, SQL*Plus, SQL Developer

Languages

C, SQL, PL/SQL, Core Java, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, New Orleans, US
Apr 2011 - Till Date
Role: OBIEE Admin/Lead Developer

Description:

Confidential, is a global medical and academic leader which is playing an important role in the health of community. The only Louisiana\'s area hospital honored as one of "America\'s Best Hospitals" by U.S. News and World Report, singled out from more than 5,000 U.S. hospitals for our exceptional medical care. As an OBIEE Admin, I am responsible to maintain OBIEE analytics application developed for the top executives to view, analyze the visibility of health care system are carried out smoothly.

Responsibilities:

• Gather the requirements and kick off the new OBIEE Projects with Project plan. Assisted business users on OBIEE adhoc report queries.
• Technical Point of contact for the OBIEE developers across the team.
• Involve and approve the project plan decisions. Act as a scrum master for the Business Intelligence and daily OBIEE developers meetings. Worked with Oracle Support on product bugs.
• Responsible for Reviewing RPD and Web Catalog and make performance recommendations
• Make configuration changes in the server to improve OBIEE performance.
• Carry out OBIEE migrations for all the environments across the Organization.
• Responsible for successfully carrying out Change Management Process (CMP) approval process during migrations.
• Worked with Upgradation process of OBIEE 11g environment.
• Worked with weblogic administration, Active Directory setup and SSO using OIM
• Conducted OBIEE trainings for new hires in the organization.
• Environment: OBIEE 11g, OBIEE 10.1.3.4.1, Weblogic, Oracle 11g, Toad Data Modeler, Informatica 9.x

Confidential, Irving, US
Nov 2010 - Apr 2011
Role: OBIEE Consultant

Description:

Confidential, Services Operation Enterprise Reporting and Architecture group supports overall transformation to a common platform for reporting/analysis environments and a common interface infrastructure for complex business processes. Digital Distribution Clearinghouse project is handled by Verizon which deals with different content providers like Sony, Paramount, Disney pictures and many other groups with OBIEE as the front end reporting tool. As an OBIEE consultant I gather the requirements from the clients and understand them and create the dashboards which need to be user friendly even for first time Non OBIEE users.

Responsibilities:

• Need to analyze the business requirements and portrait the requirement specification according to flexibility of the BI tool.
• Created of high-level and detailed design documentation, accurately mapping requirements into OBIEE functionality.
• Worked with BI Plug in for providing dynamic report data to OBIEE users.
• Responsible for working on POC, to confirm whether requirements are feasible with tool features.
• To provide customization for tool as per the customer requirements trained in other BI tools.
• Developed the project from the scratch by building the E-R diagrams, creating RPD/Dashboards.
• Pulled data from ODS and built the OBIEE reports on top of it.
• Involved in transforming mappings which are built in OWB to informatica.
• Tried the feasibility of requirements in latest versions of OBIEE.
• Worked with IQY's for report download feasibility.
• To train the users to meet their objectives by showing the reports and type of information that can be extracted.
• Environment: OBIEE 11g, OBIEE 10.1.3.4.1, Oracle 10g,SQL Developer, SQL Server Management Studio Release 2, Informatica 7.1.1,OWB

Confidential, Richardson, US
Dec 2009 - Nov 2010
Role: OBIEE Designer/Sr.Developer

Description:

Confidential, planned to integrate AT & T mobility and Wireline sales force across several organizations, so it can address customers with a single AT & T voice while delivering the full value of AT & T assets, expertise, and solutions. As an OBIEE designer, I am designing the customization of OBIEE Inventory by re-plat forming of current OLAP database which is in Oracle to Teradata platform and even build the infrastructure to enable the business to operate in an integrated environment.

Responsibilities:

• Playing a key role in analyzing the system requirements gathering the requirements and meeting the specifications of the client.
• Creation of high-level and detailed design documentation, accurately mapping requirements into OBIEE functionality.
• Responsible for working on POC, to confirm whether requirements are feasible with business requirements.
• Involved in Data Model Design and used best approaches to configure Physical, Logical and Presentation Layer
• To Analyze the pros and cons of impact of the existing environment with the new design implementation
• Created MUD (Multiple user Development) environment by utilizing projects.
• Performed ETL procedure to load data from different sources into data marts and data warehouse using Informatica Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor
• Debugging the Mappings, which were raised by QA at Testing Environment
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router and rank.
• To be technical point of contact for the issues faced by team in SDLC phases.
• Provide approvals for code deployment in the environments after code review.
• Responsible for helping team to setup the OBIEE in solaris environment.
• Making environment compatible with teradata which was previously feasible to oracle.
• Environment: Teradata SQL Assistant, Oracle 10g, SQL Developer, TOAD,Solaris12, OBIEE 10.1.3.3, Visual source safe,Informatica 6.2

Confidential, Cleveland, US
Mar 2008 - Dec 2009
Role: Analyst/ Senior Developer

Description:

Confidential, is a highly diversified and growing financial services organization spanning the retail, business and corporate markets. As per the banking requirements it will generate OBI reports based on the daily ETL processing at the backend which will enable client to automate Queue Monitoring process. As an OBIEE Analyst I had gathered the requirements from the business/management and designed the dashboards/RPD which will be delivered based on the day to day requirements discussed with the clients.

Responsibilities:

• Played an active role in gathering the requirements and meeting the specifications of the client.
• Gathering, Analyzing and identifying the Gap in Business Reports Requirements
• Involved in the development of the RPD and Dashboard.
• Understood the Business point of view to implement coding using Informatica power center designer
• Review the code developed by the team and provide approval for UAT/production environments
• Customized and developed the OBIEE Business Model and Mapping layer.
• Implemented logical column measures and calculations with well expertise in the Business Model and Mapping layer.
• Implemented caching and aggregate table techniques to improve the performance.
• Capturing and documentation of Management Information/Business Intelligence requirements from clients, via interviews or workshops, ensuring suitable balance of business needs and delivery feasibility.
• Environment: Oracle 10g, SQL Developer,TOAD, OBIEE 10.1.4,Visual source safe,Informatica 7.1.3

Confidential, Huddersfield, UK
Oct 2006 - Feb 2008
Role: Analyst/OBIEE Administrator

Description:

Confidential, previously known as the Holset Engineering Co Ltd, is the world\'s leading manufacturer of turbochargers for diesel engines. It was a challenge to have the unified face to customers on behalf of the manufacturing units situated across the globe and an interface to co-ordinate with all these manufacturing units. As an OBIEE Analyst understood the business requirements and took part in proposing the details required to achieve coordination of metrics in manufacturing units and worked to setup the environment in the unix box as per the requirement.

Responsibilities:

• Working on Request for proposals for OBIEE
• Analyzing the requirements and developing data warehousing solution for the requirements.
• Interacting with clients to conduct requirement analysis and develop the technical specifications based on their projected business needs.
• Working with high level design documents.
• Working with the setup for the project environment.
• Developing the OWB mappings
• Creating the reports based on the requirements in OBIEE.
• Creating iBots in Delivers to send alerts to the recipients on occurrence of a business event or at the time specified
• Training new hires on OBIEE.
• In addition carried out the administrator role for OBIEE in Unix environment
• Environment: Noetix, Oracle10g, SQL Developer,TOAD, OBIEE 10.1.4,Visual
• source Safe

Confidential, Cardiff/London,UK
Jul 2003 - Sep 2006
Role: Senior Developer/Administrator/Project Lead

Description:

Confidential, is a UK based Telecom company which provides Broadband Connections to Retail customers and wholesale connections to Communication Providers.
Enterprise Data Warehouse (EDW) is the integral part of BT StepChange Programme.It is a large application with a complex architecture and uses a set of relatively new technologies.The Enterprise Data Warehouse (EDW) initiative intents to support the CRM (Customer Relationship Management) stream of the Step Change programme within the Retail Consumer business. EDW has a large number of processes and entities, and operates with a data model and domain, encompassing PSTN, Broadband, Narrowband and Mobility data.The EDW implementation is required to be "generic" solution and scalable enough to accommodate future products and services with minimum effort.The EDW will provide a single end-to-end view of customer, service, network and infrastructure element inventories for the broadband technologies. As a Siebel Project lead guided the team and defined Siebel Analytics metadata repository and created subject areas and reports and supported Siebel Analytics for their Retail department. Later played an OBIEE administrator to review & be responsible for deliverables of OBIEE code across 7 servers and 66 live applications.

Responsibilities:

• Handling the lead role for 6 Projects including playing a key developer role for one OBIEE module.
• Involved in the development of the RPD and Dashboard.
• Aid in design and development of reporting metadata & Dashboards/Reports.
• Experience in configuring OBIEE repository by working on Physical, Business Model and Mapping layers of repository by creating aliases, logical tables , joins, Dimensional hierarchies and calculated measures to build the business logic as per the reporting needs.
• Implemented Security mechanism using external database table.
• Implemented automatic scripts for Cache management
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts. Analyzed and validated the business model in Siebel Analytics Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Responsible for maintenance of OBI environment in Windows for overall Retail EDW for 66 OBIEE live applications.
• Responsible for overall deployments/migrations of analytics development for many MNC companies in the project which are working with BT.
• Reviewed the deliverables and ensured that the deliverables meet OBI Standard Guidelines.
• Responsible for maintaining 7 OBIEE Servers.
• Point of contact for any queries raised by the developers.
• Implemented caching to increase OBI performance.
• Also worked with Security of the Oracle BI Administration Tool to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
• Environment: Oracle 10g, SQL Developer,TOAD,Siebel Analytics 7.8.5,Visual source safe, Discoverer, Business Objects,OWB

Confidential, Kolkata,India
May 2002 - Jul 2003
Role: Developer/Tester

Description:

The Performance Improvement Tool (PIT) is a first and second line management coaching dashboard for all customer service contact centre managers. It will provide a 360 degree picture of the customer's experience via a series of customer centric measures that will capture the voice of customer and business. This area PIT provides intelligence repository (RPD) using OBI reporting tool and I took part in developing RPD's are configured enough to be able to access data for producing adhoc or regular reports.
Responsibilities:

• Involved in the development of the RPD and Dashboard.
• Worked on Siebel Answers and Dashboards to create Requests, designed various report views like Table, Chart Created Column Filters and Prompts to filter the request and worked with column formatting functions.
• Implemented the Hints at the OBIEE end.
• Performed tuning in the reports by implementing the indexes wherever required.
• Performed extensive testing in RPD and Answers
• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Defined Hierarchies, Aggregate Navigations in the RPD.
• Created User Groups in RPD.
• Environment: Oracle 10g, SQL Developer,TOAD, Siebel Analytics 7.7,Visual source safe, OWB