OBIEE/Siebel Consultant Resume

Title
OBIEE/Siebel Consultant

Primary Skills
Siebel Analytics, OBIEE, Siebel CRM

Location
Canada-ON-Toronto

Posted
Apr-23-09


PROFESSIONAL HIGHLIGHTS

• Over Nine years of comprehensive exposure in Information Technology.
• Over nine years of development, administration, support, and maintenance on CRM/BI applications.
• Seven years analyzing business requirements, designing, and implementing Customer relationship Management and Business Intelligence systems.
• Project management experience from conceptual phase to successful implementation. Possess strong
understanding of Business Processes and IT integration.
• Gather and document User requirements using UML, process flows, and use cases. Possess strong interview and workshop facilitation skills.
• Perform Gap Analysis and make recommendations
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies. Familiar with Global Business Model
• Execute QA testing and validation using Test plans and scripts
• Great communicator and diligent team member


PROFESSIONAL EXPERIENCE

iGATE Global Solutions,
Client: General Electric, Shelton, CT February 2007 ? December 2008
OBIEE Consultant- ver 10.1.3.2.1
A role of a Business/Technical consultant with Project coordination/management working on a HRMS system
Responsibilities:
• Involvement in application performance improvement efforts
• Conducted workshops to gather Business requirements, Performed Gap Analysis and translated them to technical design requirements
• Involvement in application maintenance activities and implementation
• Involvement with creation of test scripts and validate Integration/Regression test results
• Offered recommendations on business process improvement
• Created new dashboards/reports and made recommendations to report layout with reference to table, narrative, pivot, chart views in Siebel Answers and embedded them into new/existing dashboards pages as required by the project.
• Assisted with application production support
• Offered OBIEE architecture recommendations by setting up an efficient development environment (MUD) taking into consideration Oracle/Siebel's best practices
• Coordinated activities onsite & offshore towards meeting project timelines

Client: Cummins, Columbus, IN
OBIEE Consultant- ver 10.1.3.3.1
A role of a Business/Technical consultant with Project coordination/management working on an ERP implementation
Responsibilities:
• Offered assistance with infrastructure recommendations and put together sizing questionnaire for capacity planning
• Offered data architecture recommendations with Master Data Management (MDM)
• Modified prebuilt dashboards/reports comprising of table, pivot table, chart views and created a Proof of Concept to demonstrated the ability of OBIEE
• Conducted workshops to gather user requirements and performed Gap Analysis, document and translate them to technical requirements
• Coordinated activities onsite & offshore towards meeting project timelines



Client: Royal Bank of Canada, Toronto, ON
Siebel Analytics Analyst- ver 7.8.2
A role of a Business/Technical consultant with Project coordination/management working on a Change Management system
Responsibilities:
• Apply analytical skills to high-level Business requests to determine the needs of the business and transform the requirements to technical specs.
• Facilitate requirement gathering sessions and offer recommendations when required.
• Provide Scope validation and recommend enhancements in functionality
• On-site Single Point of Contact to issues regarding the application
• Communicate the requirements and technical specs over to off-shore development team and involved in Design documentation
• Created new Dashboards/reports as required by the project. Worked on reports delivery using Delivers
• Estimate and provide project time line on the deliverables and co-ordinate the project
• Create test plans and scripts and execute Unit testing of code as required by test plan


SI Systems,
Client: Procter & Gamble, Toronto, ON April 2006 ? February 2007
Siebel Analytics Analyst- ver 7.8.4
• Apply analytical skills to high-level Business requests to determine the needs of the business
• Liaise with various internal business units & external vendors to gather requirements and resolve issues
• Provided data architecture recommendations by Analyzing and mapping processes current state/future state
• Provided Scope validation and recommend enhancements in functionality
• Provided Application support and maintenance by identifying inconsistencies and implementing alternative and efficient solutions
• Configured Analytics repository metadata by Configuring drilldowns, develop narrative, pivot, chart views and reports in Siebel Answers and embedded them into new/existing dashboards pages. Created Filters for user based control on requests embedded in dashboards
• Reviewed ETL designs for conformance to infrastructure standards and good practice
• Create test plans and scripts and execute Unit testing of code as required by test plan

Ness Canada, Inc.,
Client: Royal Bank of Canada, Toronto, ON February 2006 ? March 2006
Siebel Analytics Analyst- ver 7.8.2
• Managed analysis process including: defining the project scope, and deliver requirements specifications
• Translated user requirements to technical specifications and configured application
• Configured Analytics repository metadata
• Configured drilldowns, developed narrative, pivot, chart views and dashboards/reports in Siebel Answers. Created Filters for user based control on requests
• Performed Unit testing of code as required by test plan by developing use cases and documented functional specifications

Capital Technology Partners
Client: Yellow Pages Group, Montreal, QC October 2005 ? December 2005
Siebel Actuate Report Analyst- ver 7.7
• Developed Siebel Actuate Reports -- List and Master detail reports with composite datastreams and datafilters
• Configured Siebel tools to add/change Business Components, add/change physical joins/keys
• Worked with the team and a DBA to communicate and negotiate data needs.
• Developed Multilingual reports in French
• Managed and troubleshoot the Reports server environment and Actuate Management Console
• Performed Unit testing of code as required by test plan , executed system testing of reports with other teams as required

Irevolution Consulting
Client: Ministry of Environment, Toronto, ON January 2005 ? May 2005
Siebel Actuate Report Analyst- ver 7.5.4
• Worked as a team member with other members to coordinate and communicate modifications to insure previous and future changes to system are incorporated
• Developed Siebel Actuate Reports -- List and Master detail reports with composite datastreams and datafilters
• Configured Siebel tools to add/change Business Components, add/change physical joins/keys
• Worked with the team and a DBA to communicate and negotiate data needs.
• Enhanced existing reports (post production) based on Business requirements
• Analyzed, troubleshoot and apply fixes to post production reports
• Performed Unit testing of code as required by test plan , executed system testing of reports with other teams as required

Client: CGI/Bell Canada, Toronto, ON
Siebel Analytics Analyst - ver 7.7
• Configured Siebel Analytics package as required by the project
• Understand the requirements from the business perspective and translated them into technical specifications, smaller sub-requirements, functions, and tasks.
• Configured Analytics repository metadata
• Configured drilldowns, developed narrative, pivot, chart views and reports in Siebel Answers and embedded them into dashboards pages. Created Filters for user based control on requests embedded in dashboards
• Reviewed ETL designs for conformance to infrastructure standards and good practice
• Performed Unit testing of code as required by test plan and Produce high quality documentation
• Executed system testing of reports with other teams as required


Roots Consulting
Client: Technion Communication, Tamarac, FL November 2003 ? Jan 2005
Siebel Analyst ver 7.5.3
Configured and Supported Siebel- Call center Application and administered Oracle database
Responsibilities:
• Met with end-user groups and minimized system detailed business requirements
• Lead requirements gathering sessions (JAD) with Business Unit representatives
• Translated business requirements into functional requirements for logical and detailed design documents, Siebel configuration changes and UI enhancements.
• Involved in configuring Siebel call center Application. Used various business objects such as Opportunity, Quote, Account, Contact, Internal Product, and Action.
• Provided Application support and maintenance by identifying inconsistencies and implementing alternative and efficient solutions
• Configured Siebel Remote (Siebel Anywhere) on Siebel servers and clients.
• Involved in designing Siebel EIM (Enterprise Integration Manager) process to incorporate legacy data into Siebel system tables via interface tables provided by Siebel. Oracle 7.5 was is the back end database.
• Test Scripts validation and developed a prototype to train Siebel end users.

MSX International
Client: Ford Motor Company, Allen Park, MI April 1998 ? October 2003
Database Analyst
Supported Siebel- Call center Application and administered Oracle database in the Marketing and Sales Department at Ford Motor Company.
Responsibilities:
• Provided support to multiple Business projects
• Lead requirements gathering sessions (JAD), with Process Consultants and Business Unit representatives
• Created Technical Design documents, determined resources requirements, and assigned tasks accordingly
• Worked with customers to help them identify the best ways to improve departmental as well as cross-departmental processes.
• Provided recommendations for improving the processes and procedures of various systems and defined detailed business requirements
• Facilitated meetings to gather user requirements for screen functionality and layouts
• Configured and supported Siebel application by Creating use cases, Data Dictionary, Work load & Functional diagrams for Entry screen, Calculations and Display Screen
• Developed Actuate Reports, and configured Siebel Workflow, and Siebel EIM
• Performed application level database administration
• Performed software upgrades on clients and Server
• Provided user training and acted as bug Analyst (train the end users in the new process and application, analyze the bugs generated for nonconformance)
• Supported and troubleshoot mobile environment issues - Interface with Level one support and Siebel Systems as needed
• Executed QA processes using test plans and scripts

Client: General Motors, Pontiac, MI
Database Analyst
Developed, Supported and Administered Engineering design applications and Oracle databases in the Engineering department of the truck Product Center at General Motors.

Responsibilities:
• Administered Oracle 8i databases.
• Developed System Development Plan & System Architecture.
• Derived Client-side & Server-side Functionality & Designed Database Structure.
• Assigned tasks to Development Team. Developed standards and supervised deliverables against strict time constraints.
• Developed User Interface Screens and created Requirement and Analysis models.
• Facilitated Data modeling sessions.
• Created Data Flow Diagrams (DFD) and Entity Relationship Diagram (ERD).
• Participated in the technical review of the data model, entities, keys, relationships and the business process where the data and process requirements are matched together. Generated Data Definition Language (DDL).
• Data loads using SQL* Loader. Export and import utilities. Participated in establishing Database Management standards and formulating Knowledge Management strategies.
• Created and administered Oracle 8i databases. Tuned and enhanced current Database designs. Facilitated in the creation of logical and physical data model.
• Managed Database, Storage, Rollback Segments, Table/Index segments, Database Access, Roles, Profiles, and Users.


Harvard Pilgrim Health Care, Dedham, MA May 1995 ? August 1995
Summer Marketing Intern
• Assisted in the development of regional marketing communication opportunities for fall 1997.
• Worked on an integrating marketing communication plan for minority communities in the New England area.
• Offered assistance in Marketing & Advertising campaigns to increase awareness
• Worked towards getting leads to target prospective audience in the emerging markets. Analysis of leads generated by corporate advertising and trying to improvise on it.







(Attachment I)
CAPABILITIES
Methods & Techniques


• Process Reengineering
• Database Administration (OEM)
• Software Development Lifecycle
• Applications Development

• Project Management
• Microsoft Project
• FAST (Approach) JAD/RAD sessions
• Oracle Data Warehouse Methodology

Technology Software, Tools & Languages:
MS Word, MS Project, MS Excel, MS PowerPoint & Visio
Siebel 2000 (6.2.1, 7.5.3, 7.5.4) Siebel Analytics (7.8.4), OBIEE (10.1.3), Erwin, Designer 2000, Developer 2000, Oracle Discoverer, Toad
Oracle Warehouse Builder, Oracle Darwin, Oracle Portal, Oracle Application Server, SQL*Plus, HTML, PL/SQL, SQL, MS Visual Basic, Oracle Enterprise Manager (OEM) Multimedia (Macromedia Director, Adobe

Database:
Oracle 7.X, 8i, 9i, Oracle DBA, MS Access

Statistical Package:
Familiar with SPSS

Other
Disaster Recovery, Data Mining, Performance Tuning, Benchmarking, Backup and Recovery

Hardware & Operating Systems
HP-UNIX, NT Server, MS Windows, MS Windows 2000/NT, UNIX

Industry Experience
• Automotive
• Marketing & Sales
• Financial Services
• Engineering
• Services
• Human Resources

EDUCATION, TRAINING & RECOGNITION
Education: (Master of Arts in Global Marketing)
Emerson College, Boston, MA
Master of Science in Engineering
University of Arkansas, Fayetteville, AR
Bachelor's in Engineering
Bharathiar University, Coimbatore, India

Training
• Oracle Enterprise DBA - Architecture & Administration
• Siebel ebusiness essentials
• Oracle - Client Server Development
• OBIEE plus

Recognitions:
• Extra Effort (MSX International, Client: Ford Motor Company)
• Graduate Assistantship - Emerson College, Boston, MA
• Graduate Assistantship -- University of Arkansas, Fayetteville, AR

Certifications: (PMP/ITIL)

Certifications
Working on PMP/ITIL certifications


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Toronto, ON | Resumes in Ontario

View other OBIEE/Siebel Consultant resumes, System / Network Administrator resumes