SUMMARY

IT professional with more than 8 years of diversified experience inOBIEE & Siebel CRM Implementation, production support, Training and Project Management. Advance level expert in the domain of Siebel CRM and Oracle Business Intelligence spanning across different industry segments and business areas. Extensive experience working very closely with business & IT teams for various global customers located in USA, Canada and India. Successful in driving and delivering small to large scale projects by applying a balance of project management skills, business understanding and technology skills.

Personal attributes include excellent organizational skills, high self-motivation for quality results and excellent multi-tasking capabilities. Excellent inter-personal skills enhance communication at all levels of the organization. Exceptionally able to influence and manage large and diversified project resources.

HIGHLIGHTS

• Excellent work experience as Architect, Project coordinator, Project Lead, Team lead, and consultant. Extensively involved in interacting with business/Stakeholders and IT teams for implementation and maintenance of Siebel CRM & OBIEE systems.
• Adept at communicating and operating in fast paced environment.
• Accustomed to work within tight deadlines aided by good organizational skills.
• Experienced as an independent task owner as well as team lead for coordinated efforts.
• Extensive experience working in an onsite/offshore model for deriving value and cost effectiveness.
• Siebel CRM & OBIEESME and consultant.
• Experienced solution architect of designing and developing OBIEE reporting solutions for global customers.
• Experience across SIEBEL CRM versions 7.7, 7.8, and 8.0.
• Familiarity with the Hyperion financial applications.
• Exceptional project management capabilities via status tracking and proper communication channel.
• Excellent stakeholder relationship skills.
• Ability to prioritize tasks and manage deliverables in a constrained environment without compromising on Quality.
• Effective team mentoring skills.
• Trained 50+ entry level trainees spread in various batches for Siebel CRM & OBIEE, architecture concepts and practical implementation.

Siebel CRM experience summary

• Siebel Development -Design &Customize Business Objects, Business Components, Applets, Views and Screens. Siebel Application Administration. Written Business Services.
• Workflow -Workflows for automating Business Processes. Rule Sets, Validation Messages for approval process.
• EIM -EIM mapping to Party & Non Party tables on Siebel from external sources.
• Scripting -Written Scripts on Applets, BC’s & Business Services
• Integration -Worked on Thin BC’s & Integration Objects.

OBIEE experience summary

• OBIEE Data modeling – Designed& Build DW tables based on Star & snowflake schemas.
• OBIEE Data Extraction/Transformation/Load-Designed ETL(Informatica) process & SQL’s to populate data from different source to data warehouse.
• OBIEE Reporting – Designed & developed reports in OBIEE, Developed joins on RPD to facilitate star schema functionality.
• OBIEE Security – Designed & developed Active Directory for OBIEE11g

PROFESSIONAL EXPERIENCE

Client: Confidential,NC Mar 10 - Present
Role: OBIEE Architect
Environment: OBIEE 10g & 11g, Oracle 11g

Client is world\'s leading and most diversified specialty metals producers. This project aims to customize OBIEE seeded analytics (financials, supply chain, procurement, and inventory), design and develop BI reporting solutions for Manufacturing, Planning (ASCP), & Quality functional areas. Data flows from multiple source systems for these areas.

As a BI Architect my responsibilities include:

• Design OBI for ATi Allvac Manufacturing, Planning (ASCP), Quality areas in addition to seeded analytics (Financials/Procurement/Supply chain/Inventory).
• Responsible for OBIEE administration through Weblogic & Enterprise Manager.
• Designed & developed star & snowflake schema to facilitate the functionality.
• Created multiple reports which includes Drill down, Go-Url, Union of Subject areas, etc in Table, Pivot & charts views.
• Created logical dimension level based hierarchies & repository and session variable to achieve the functionalities.
• Administration of OBIEE, DAC & Informatica.
• DAC Configuration, Monitoring & Execution.
• Troubleshoot/Design Informatica Mapping/Workflow for ETL execution.
• Manages project scope, WBS & timelines
• Created procedures/methods for Dev to PROD migration of all 5 components of OBIEE in-line with client Audit process.
• Manages an Offshore team of 13 people.
• Identify areas for performance improvements and suggest solutions.
• Work closely with client IT team to ensure timely delivery, testing and adherence to Quality processes.
• Interface between the technical team and the client business team for requirement clarifications; discuss business scenarios, design and delivery.
• Collect performance report, project status and report from stakeholders using pre-defined templates.
• Suggest and implement Quality improvement processes.
• Participate in weekly team meetings with client.
• OBIEE training to Client IT team as well as developed training materials for business team& end users.
• Work with various business groups and functional leads to gather requirements.
• Identify and pursue potential opportunities within the engagement there by helping to grow the account.

Client: Confidential,NC Aug 11 – Feb 12 Role: OBIEE Upgrade Architect
Environment: OBIEE 10.1.3.4 to OBIEE 11.1.1.5,Oracle 11g

The key objective was to upgrade ATi Allvac OBIEE environment from 10.1.3.4.1 platform to 11.1.1.5.0. In addition to seeded analytics Allvac BI contains Manufacturing, Planning (ASCP), Quality areas. This includes upgrade of existing customization on seeded & custom DW, Informatica, DAC, RPD & web catalog changes.
As an onshore coordinator my responsibilities included:

• Prepare GAP Analysis, upgrade Approach& project blue print.
• OBIEE 11g security implementation with Active directory
• Work in close co-ordination with the upgrade team to identify pre and post upgrade activities, issues, maintain a risk management plan , creation of test scripts and report validation
• Monitoring data loads and apply fixes to failures thereby ensuring business continuity.
• Provide technical insights to improve processes and performance of the overall BI landscape.
• Maintain issue logs and user query log to help identify risk patterns and suggest solutions.
• Project execution, delivery& documentation

Client: Confidential,ON Mar09 – Feb 10
Role: Sr. OBIEE Consultant
Environment: OBIEE 10g/Hyperion, Oracle 10g

The project was to implement financial management reporting solution for Lafarge North America region. Users were manually sent the consolidated reports to head office (Paris).The challenge was to identify the reporting tool & to convert excel sheet & manual calculation to online reports.
My responsibilities as a Project Lead:-

• Identify the tool & Design system to meet requirements.
• Layout the road map for project execution by creating the project plan.
• Lead a team of 3 OBI and 4 Hyperion consultants
• Successful in building a dedicated offshore team of 2 OBI and 2 Hyperion resources for production support
• Analyze the data flow from the basic system to OBI DW in order to address key user queries relating to report functionality, usage and handling.
• Participate in dry runs and integration testing of OBIEE 10g & Hyperion applications prior to system roll out.
• Provide technical support related to OBI enhancements & Hyperion development and reports.
• Perform team appraisals.
• Actively involved in post go-live production support activities

Client: Confidential,USA (Worked from Offshore) May 08 – Feb 09
Role: Sr.Siebel Developer
Environment: Siebel 7.7,Oracle 9i

The client is a global leader in design and manufacture of embedded semiconductors for the automotive, consumer, industrial, networking and wireless market. Support team consists of First Line & Second Line Support. First Line support interact with users and resolve issues if they are simple otherwise it will forward to second line support which consist of technical team.

My responsibilities here were

• Lead a team of 3 at offshore

Handled Enhancement Requests (ER’s). Designing and customizing Workflow objects, Policies and Run time Events.

• Requirement specifications for different screens, views and applets according to particular ER’s.
• Configured Static and Dynamic Pick lists, and specialty objects such as Drilldown and Toggles for Applets.
• Break down user requirements further to create work packages.
• Compilation of Development & Test Servers.
• Report to the Project Manager
• Application Administration: Proper implementation of the Responsibilities and Views Matrix which included
• Creating new Views
• Creating new Responsibilities
• Assigning Views to Responsibilities
• Assigning Users to Responsibilities

Client: Confidential,CA (Worked from Offshore) Oct 06 – Apr 08
Role: Siebel Support Engineer
Environment: Siebel 7.8, Oracle 9i

The client was the global leader in Business Performance Management software. This Project aims the entire automation of the quote life cycle, beginning with the generation of a Quote by the sales rep, getting approvals for the terms of a quote, generation of a quote output for customer, entering the accepted quote into the order management system, and finally the conversion of an order into an asset..As a Consultant Siebel my responsibilities were:

Customized object definitions in the business object layer, as per customer requirements.

• Coordinated with BA to obtain Functional Requirement document.

Helped Technical teams to convert the Functional specs to Technical specification documents. Used Siebel Tools for modification, enhancement and customization of Siebel Business Components, user interfaces (Screens, Applets, and Views) and Calculated Fields according to the client requirement. Written Business Services to achieve business requirement. Designed and developed new pick list components, MVG lists, links, joins and defining several other object definitions and linking to each of the objects defined in user interface layer in the Call Center Application. Configured specialty objects such as Drilldown and Toggles for Applets. Created Thread bars for easier navigation within Siebel.

• Configured hierarchical Pick Lists.

Client: Confidential,UK (Worked from Offshore) Jan 05 – Oct 06
Role: Siebel System Analyst
Environment: Siebel 7.5, SQL Server

Project involved customizing Siebel Call Center application for Tektronix, implementing to provide customer support for their product related problems and particularly designed for increasing the sales in the largest and most rapidly developing international market.As a Siebel Configurator my responsibilities were:

Customized object definitions in the business object layer, as per customer requirements. Used Siebel Tools for modification, enhancement and customization of Siebel Business Components, user interfaces (Screens, Applets, and Views) and Calculated Fields according to the client business process. Designed and developed new pick list components, MVG lists, links, joins and defining several other object definitions and linking to each of the objects defined in user interface layer in the Call Center Application. Involved in EIM process. Configured hierarchical Pick Lists.

Client: Confidential, UK (Worked from Offshore) Jun 04 – Dec 05
Role: Siebel Developer
Environment: Siebel 7.0, SQL Server

Client is a pharmaceutical company. Siebel Sales Application is implemented to automate the sales process. Customization of Siebel applicationto provide enterprise level data sharing among sales teams and to support sales team to increase the sales. An order is delivered by the order processing team. As a Siebel Configurator my responsibilities were:

Configured Business objects as per customer requirement. Configured specialty objects such as Drilldown and Toggles for Applets. Tested and debugged various customized Siebel interface applications Created Thread bars for easier navigation within Siebel Designed and configured various applets, views and screens. Modified Style sheets included in Web templates, configured banner frame and startup texts

EDUCATION
Master of Computer Application
Bachelors of Science (Computer Science)