Management Sales

PROFESSIONAL SUMMARY

A SR. SIEBEL BUSINESS ANALYST WITH 20+ YEARS OF IT EXPERIENCE AND 15+

YEARS OF SIEBEL EXPERIENCE IN IMPLEMENTING SIEBEL'S VARIOUS VERSIONS,

INCLUDING ANALYSIS, DESIGN, CONFIGURATION, DEVELOPMENT, SUPPORT, AND

TESTING. PARTICIPATED IN 9 FULL SIEBEL LIFE CYCLE IMPLEMENTATIONS.

Strengths:

. Business Requirements gathering, Requirements analysis, Business

Process documentation, Gap Analysis, Business Process

reengineering, business process models, use case diagrams, Data

flows and mapping, Test Cases/Requirements traceability matrix, User

training, user administration.

. Siebel Sales, Siebel Call Center, Siebel Marketing, Siebel

Analytics, Siebel Data Quality.

. Products, Contacts, Opportunities, Quotes, Contracts, OBIEE, and

Siebel Open UI.

. Designing, Documenting, conducting Jar/JAd Session.

. SystemTest Functional Testing, UAT testing, and Performance testing.

. Programming in C, C++, VC++, C#, PL/SQL, Visual Basic, Java Script,

VB Script, HTML, DHTML, XML

siebel technical employment summary

Versions: Siebel 5, 6.3, 7.5, 7.7, 7.8, 8.0, 8.1.1

Verticals: ePharma, eCommunications and eFinance

Horizontals: Siebel Marketing, Sales, Service, PRM, Call Center,

eSales, eService

Industries: Finance, Pharma, and Communication.

Roles: Sr. Business Analyst, Application Quality Test Lead

Business Modules: Marketing Management, Account Management, Contact

Management, Prospect Management, Opportunity management,

Partner Relationship Management "PRM", Event Management,

Order Management, Activity Management, Service Request

Management, etc

Other Experience: Project Planning, JAR/JAD sessions, Process Design,

Process Reengineering, Requirements gathering, Gap

analysis, Impact and Risk analysis, system analysis, User

Training, documentation etc.

. Siebel 6.3

. Siebel 7.5 & 7.7

. Siebel 7.8, 8.0, 8.1.1

. Siebel Call Center

. Siebel Sales

. Siebel Service

. Siebel PRM

. Siebel Field Service

. Siebel eFinance

. Siebel ePharma

. Siebel eCommunications

. Siebel Campaigns

. Siebel List Management

. Siebel Workflow

. Siebel Assignment Manager

technical summary

. OPERATING SYSTEMS: MS WINDOWS 2000, 2003, XP, VISTA, WINDOWS 7, UNIX,

LINUX

Databases: SQL Server, Oracle, DB2, MS Access

Programming & Scripting Languages: C, C++, VC++, PL/SQL, Visual Basic,

Java Script, VB Script

Methodologies: Water Fall, Agile

Software Packages: Microsoft Office, Visio, Project, Excel, Word,

PowerPoint, Crystal Reports,

Actuate, WinRunner, LoadRunner, Test

Director, HP Quality Center, QTP,

Toad, Oracle SQL Developer, HP

LoadRunner.

education

ITT TECHNICAL INSTITUTE, NASHVILLE, TN 2004

Bachelor of Applied Science in Project Management (Class Valedictorian)

University of Alexandria, Alexandria, Egypt 1999

Bachelor of Applied Science in Computer Engineering (Class Valedictorian)

ITIL Foundation studies

Professional history

EMPLOYER: FANNIE MAE JAN 2008 TO JUNE 2013

Sr. Siebel Business Analyst (Subject Matter Expert)

.

. Acted as the liaison between business users and technology teams.

. Conducted joint application development (JAD) sessions with

developing team stakeholders throughout software development life

cycle (SDLC) to resolve issues and support decision-making.

. Performed GAP analysis of business rules, business and system

process flows, as-is and to-be business processes.

. Documented and Developed use cases and business process models.

. Participated in and contributed to business process reengineering.

. Created documents for data mapping functional points discovered

during design stage.

. Created documents for data consumption and data flows between

Siebel and upstream and downstream systems.

. Developed traceability matrix for Business Requirements, Test

cases, and functional specifications through each design stage and

discussed gaps with teams participated in the release.

. Analyzed business requirements for testability and discussed test

coverage with business stakeholders and technical teams; developing

and support SMEs.

. Analyzed test coverage and communicated LOE "Level of Effort" and

SOW "Statement of work", and secured sign offs from Stakeholders,

project Management office and technical teams.

. Verified and validated solution designs for solution coverage and

testability.

. Provided leadership in the area of Siebel CRM testing and directed,

managed, and coached less experienced Siebel testers.

. Created System Test test strategy and test plan documents,

communicated with and secured sign offs from business stakeholders

and project management office.

. Wrote detailed test cases and test scripts for the Functional and

data driven testing.

. Created test scenarios and test cases and ensured that all test

cases are properly mapped to Siebel requirements and providing

complete coverage for testing and validation.

. Developed various test artifacts, including test results and

reports and ensured they meet client expectations.

. Supported business team efforts in user acceptance testing (UAT)

and provided guidance on developing the various test artifacts.

. Fostered and maintained good relationships with all project teams,

both internal and external.

. Applied latest SDLC guidance for testing.

. Created and administered SharePoint sites serving as centralized

repository for all program documents.

. Developed and Led the efforts to develop detailed Siebel test

scenarios and test cases, automation test scripts, and test data

"including data in upstream and downstream systems" preparation

for execution.

. Executed test cases and led test efforts to meet required execution

targets to keep the project on schedule.

. Assisted business users with managing and tasking Siebel shakeout

testing.

. Created test status and execution progress reports and communicated

with project teams and management.

. Leveraged HP Quality Center to manage requirements, Test Plan, Test

Scenarios, Test Cases, Defects life cycle, and dashboard and

reporting.

. Initiated the Test Kick off meetings and conducted Defect Scrub

Meetings while testing.

. Performed and led regression testing for the required coverage.

. Generated Scripts for the automation team for Performance testing

using HP Load Runner

. Conducted Load Tests with Matrix defined scenarios.

. Created and communicated Test Summary Reports.

. Involved in regular interactions with development team and

presentations to the Client

. Managed defects lifecycle and reports through HP Quality Center

reports and Dashboard.

. Maintained and cleaned up Regression test suite; identified

redundant and outdated test cases to enhance testing efficiency and

expedite the software certification process.

. Wrote and executed various SQL queries to check that data is

appropriately consumed /populated/ updated on upstream and

downstream systems.

. Administered testing team Siebel access to ensure that testers

having the responsibilities and positions needed for testing.

. Administered Testing team HP QC access to ensure testers efficiency

and test data security.

. Supported UAT team with creating UAT test plan, creating test

scripts and executing the UAT testing.

. Supported UAT team with identifying valid defects and with

retesting after solution implementation.

. Led Functional, Regression, and Performance testing efforts for

various enhancement, upgrade, and fixes releases.

. Led Functional testing efforts for multiple projects in various

stages at the same time.

. Effectively followed Modified Water Fall and Agile methodologies

based on the stakeholders and PMO office requirements.

. Discussed, gathered, analyzed and documented business users' post-

deployment challenges and successfully identified Siebel critical

design enhancements to meet business requirements.

Environment: Siebel 7.7 /7.8 Siebel Sales, Siebel Call Center, Siebel

Marketing, Actuate Reports, Siebel Analytics, Oracle OBIEE,

Siebel Open UI, Business Objects, HP Quality Center, Toad,

Oracle SQL Developer, HP LoadRunner

Employer: AETEA Information Technology Inc.

Client: Fannie Mae March 2007 to Dec 2007

Sr. Siebel Business Analyst

. Led and managed business efforts of business requirements gathering

and analysis,

. Interviewed senior business stakeholders and SMEs and successfully

developed business use cases.

. Managed and executed Siebel application support and operations

including: Tier 1 support, business license administration, e-mail

campaigns, and data quality activities.

. Created end to end process mappings using key Siebel entities such

as Accounts, Opportunities, Campaigns and voice of the customer

requests.

. Led business efforts of "Contacts" data cleanup; Deduplication &

Identifying Relationships "Match, link and merge data to create

optimized records"

. Created iHelp scripts to guide users through standardized processes

and in Siebel.

. Used Rational Requisite Pro for requirements gathering, Rational

ClearQuest for Logging bugs, defects & Change Requests & Rational

ClearCase for software configuration management & Version Control,

on this project.

. Created and managed Siebel Analytics (Siebel Answers) reports.

. Created User Training documents and provided training for business

users.

. Created UAT test strategies, test Plans, Test scripts, and Test

Cases.

. Managed and executed UAT testing.

. Facilitated UAT test status/progress reports and obtained necessary

signoffs.

. Created UAT test results reports and secured stakeholders signoffs.

Environment: Siebel 7.7 /7.8 Siebel Sales, Siebel Call Center, Siebel

Marketing, Actuate Reports, Siebel Analytics, Business

Objects.

Client: Prudential, January 2006 to February 2007

Sr. Siebel Business Analyst

. Responsible for the preparation of the design document that listed

the Screens, Applets, Views, BO, BC, Field Mappings, MVG's, Joins,

Links, LOV's, PickLists, PDQ's, Responsibilities, positions, View

Visibility settings to control data access, Business Requirements

and their corresponding proposed development method to be used to

develop the process

. Prepared the Data Flow diagrams, ERD, Screen Mockups

. Involved in Gap analysis and preparation of workflow diagrams

. Worked on creating a solution for telesales professionals for

forecast management, account management, contact management,

campaign management, activity tracking, and quota and incentive

management

. Heavily worked on Contract Management and Assets management Modules

of Siebel

. Heavily worked on automating the Outbound call centers and involved

in all the aspects including gathering requirements, analyzing

data, making design documents for integration and functionality and

then finally testing and delivering the system.

. Worked with telesales users to gather the requirements regarding

their processes, documented the processes and performed gap

analysis.

. Involved in the design and deployment of Accounts, Contacts,

Opportunities, Orders, and Service Requests. Involved in the

configuration of Applets, Views, Business Components and underlying

business and data layer objects.

. Involved in the configuration of Applets, Views, Business

Components and underlying business and data layer objects.

. Involved in gathering requirements for Adding controls, creating

and configuring pick applets and multi value applets, joins and

links.

. Interacting with the Business Users and Prototyping the modules

Service requests, Accounts, and contacts.

. Worked on implementing a solution for telesales people to

seamlessly share information on customers, services, competitors,

and partners across field sales, telesales (contact center), and

supporting organizations

. Worked on a solution using Siebel PRM to plan and execute

collaborative sales, marketing, and service programs.

. Involved in understanding the customer requirements and mapping the

business.

. Deep understanding of various Project Phases and Siebel

Implementation.

. Working knowledge of all the issues that crop up while gathering

Sales, Service requirements from corresponding teams.

. Involved in training and coming out with a strategy to use training

for User awareness of features during UAT.

. Involved with the Testing team to resolve, fixing and testing

problems found during the Systems integration test, SIT Regression,

UAT Phases.

. Involved in the overall application testing.

. Created parameterized test script.

Environment: Siebel 7.7 eFinance, Siebel 7.7 Tools, PRM, Siebel Call

Center, CTI, IVR, VRU, Siebel Telesales, Siebel Marketing,

Siebel Sales, Siebel Telesales, Actuate Reports, UNIX,

Oracle, Windows NT, Informatica, PL/SQL, Toad, QTP

Client: Avaya, October 2004 to December 2005

Sr. Siebel Business Analyst

. Assisted in identifying solutions that met client's objectives and

satisfied the business metrics.

. Made a preliminary estimate of the feasibility of solutions within

cost and profit metrics of the client.

. Lead a multi-functional team (Corporate, Divisional and External

Vendors) to ensure that alignment between the claims application

modules and infrastructure architecture met the functional business

objectives.

. Collecting, understanding, and transmitting the business

requirements for the project, and translating these into functional

specifications and detailed test plans.

. Talk to business side and relate/translate their requirements

technical teams.

. Asset Initialization, Asset Serialization, Asset pricing, and Asset

Currency changing as Asset Currency changes, Asset Configuration,

Asset Modification, Asset Update, Asset Deactivation, Asset

Renewal, Asset Tracking

. Heavily worked on Contracts/Agreements and Entitlements and SR to

Contract Management integration (business process wise).

. Worked with user group including Telesales users and Implementation

users to gather requirements, document outbound calling process

flows, to prioritize requirements and change requests, document the

designs and prototypes and conducting UAT.

. Prepare and analyze reports and document specifications based on

the requirements.

. Worked on various modules (screens) viz. Account Management,

Contact Management, Opportunity Management, Order Management,

Service Request Management, and Activity Management.

. Worked on various aspects of Siebel Application like visibility

rules based on positions and responsibilities, Workflows, various

Siebel constructs like MVG applets, pick lists, Applets, Views,

various Navigation methods.

. Involved in designing the browser-side validations, formats, FF

fields, constrained fields, LOV's, MVG Applet, Pick Applets to

streamline the data entry.

. Involved in designing the toggle buttons for various applets to

enhance data visibility and easy data entry for more productivity.

. Conducted JAR/JAD sessions between developers and End users.

. Moderated meetings and facilitated interaction between developers

and end users.

. Provided training to end users

. Involved with the Testing team to resolve, fixing and testing

problems found during the Systems integration test, SIT Regression,

UAT Phases.

Environment: Siebel eCommunications 7.5, Siebel Marketing 7.5, List

Management, Campaign Management, Siebel Smart Scripts,

Opportunity Management, Order Management, Service Request

Management, UAN, Oracle, CTI, IVR, VRU.

Client: Amgen Pharma, May 2003 to September 2004

Siebel Business Analyst/ QA Analyst

. Involved in understanding the customer requirements and mapping the

business.

. Prepared process documents, business requirements documents and

plans and conducted meetings with users to gather requirements.

. Prepared templates, project plan, release plans and production

support plans and developed standards for documentation and created

processes for maintaining documents.

. Actively participated in the requirements and process mapping

workshops for the project.

. Participated in the design of various development templates and

methodology documents.

. Was part of the Samples Management Analysis team and extensively

developed various GUI elements including web templates, applets,

views and screens

. Planned, Gathered requirements, mapped requirements to Siebel,

prepared design documents, training documents, prepares test plan

and test scripts for Med Ed functionality of Siebel Med Ed module.

. Gathered requirements for Workflow Process, Workflow Groups,

Workflow Policies, Workflow Actions and Workflow conditions.

. Involved in gathering requirements for reports and various options.

. Wrote User Acceptance Test Plan and oversaw the creation of 25+

Test Scripts

. Provide support in testing, preparing test cases and resolve issues

on an ongoing basis.

Environment: Siebel ePharma 7.5, eScript, Smart Script, Actuate Reports

6.0, Oracle, EAI, Assignment/Workflow Manager, Windows NT,

UNIX, Siebel Sample Management, Siebel MedEd, Siebel

professional Calls, Siebel Pharma Account Management.

Client: Invitrogen, January 2002 to April 2003

Siebel Business Analyst/ QA Analyst

. Involved in defining the product structure and user sessions and

configuring the screens as per the client's requirements.

. Developed high level Design documents for data mapping of various

function points discovered during Discovery and Design stage.

. Worked with other Siebel Groups in requirements gathering sessions

and preparing the use case scenarios.

. Worked closely with cross-functional team members (development,

testing, and end-users) to understand business and technical

requirements to derive the data requirements.

. Executed SQL queries in the preparation of data requirements

documents.

. Worked closely with Technical writers and Training Instructors in

developing the training material for the Siebel Enhancements. Also

involved in coaching and mentoring existing resources.

. Involved in testing of visibility rules ( position based and

responsibility based)

. Involved in system testing.

. Participated and developed test strategies and test plans.

. Developed and executed test scenarios, conditions, and scripts.

. Perform analysis and documented test results and understand the

deliverables within SDLC.

. Responsible for System Test, Regression Test and coordinated UAT

execution.

Environment: Siebel 7.5, Siebel eClinical, Siebel Call Center, Siebel

Sales, Tibco, UAN, Windows 2000 Professional, Mercury tools

(WinRunner, LoadRunner, QTP, Test Director), Siebel VB, Siebel

Analytics, Informatica, MS Word, MS Excel, XML, MS Access,

SQL, Sales Force Automation (SFA)

Client: PDL, Nov 2000 - Dec 2001

Siebel Business Analyst/ QA Analyst

. Participated in Meetings with Business to finalize the scope of the

project.

. Assisted the functional team in FDD preparation

. Prepared the data mapping documents and design documents.

. Involved in the creation of new List and Form applets, and modified

existing ones in order to incorporate new fields defined in the

business requirements documentation

. Worked on various modules (screens) viz. Account Management,

Contact Management, Opportunity Management, Order Management,

Service Request Management, and Activity Management.

. Worked on various aspects of Siebel Application like visibility

rules based on positions and responsibilities, Workflows, various

Siebel constructs like MVG applets, pick lists, Applets, Views,

various Navigation methods.

. Involved in designing the toggle buttons for various applets to

enhance data visibility and easy data entry for more productivity.

. Involved in designing the required fields, calculated fields, pre-

defaults

. Developed user acceptance test scenarios and lead user acceptance

testing. Responded to complex end user questions and production

problems.

. Provide support in testing, preparing test cases and resolve issues

on an ongoing basis.

. Analyzed specifications and test plan for the testing process of

Applications

. Developed test cases after analyzing the specifications Document

. Analyzing system requirements and developing test plan for end-to-

end testing.

. Investigating software bugs and reporting to the developers.

. Involved in white box testing.

. Performed Functional, GUI, Regression testing of the application

Environment: Siebel Call Center 6.x, Siebel eService, Agreements,

Entitlements, Workflow, Accounts, Contacts, Cases ( Service

Requests), Assets, Forecast, Server Admin, Oracle, Actuate,

Windows 2000 pro, WinRunner, LoadRunner, MQ Series, CTI, IVR,

VRU.

Client: ADP, May 1999 to October 2000

Siebel Business Analyst/ QA Analyst

. Worked on Siebel Quotes, Siebel Sales.

. Involved in defining the product structure and user sessions and

configuring the screens as per the client's requirements.

. Developed high level Design documents for data mapping of various

function points discovered during Discovery and Design stage.

. Worked with other Siebel Groups in requirements gathering sessions

and preparing the use case scenarios.

. Worked closely with cross-functional team members (development,

testing, end-users) to understand business and technical

requirements to derive the data requirements.

. Executed SQL queries in the preparation of data requirements

documents.

. Involved as a data analyst in the team participating in JAD

sessions with the Business Users and the end users (CSR'S).

. Involved in analyzing the requirements and understanding the

business process to make proper decisions.

. Responsible for System Test, Regression Test and coordinated UAT

execution.

. Responsible for Writing and execution of test plans, test cases

based on the business requirement of the application.

. Worked extensively in configuring Bus Comps, Business Objects,

Joins, Links, Applets, Views, and Screens involving customizations.

. Designed and Customized Several Object Definitions, Creating Pick

Lists, Pick Applets, MVG's, Joins, and Links etc.

. Involved in designing business processes, process mapping, process

improvement initiatives and business system design.

Environment: Siebel Sales, Call Center 6.x, Siebel eScript, EAI,EIM,

Oracle, windows NT, Windows 2000, Unix, MQ Series, WinRunner,

LoadRunner, Actuate, Siebel VB

Client: EBay, May 1992 to March 1999

Developer

. Designing, Coding and testing for all Data Entry screens.

. Used SQL server stored procedures for the crystal report data population.

. Developed Screens for the User Interface for the posting Process.

. Used NT Challenge/Response to restrict different user authentication.

. Used crystal Report Engine and Crystal Report Viewer to display crystal

reports in the Browser.

. Creation of Tables and Database using Normalization Methods. And writing

Stored Procedures and Triggers in ORACLE.

. Generated Reports using Seagate Crystal Reports

Environment: VB, HTML, VB Script, JavaScript, ORACLE, Crystal Reports

and Windows NT, Forms 3.0, PL/SQL, SQL* PLUS

Contact this candidate