SPECIFIC EXPERTISE
. Strong knowledge of the Systems Development Life Cycle (SDLC) models
such as Agile, Water Fall and Rational Unified Process methodology
(RUP)
. Experienced in Siebel applications: Siebel Financial, SiebelCall Centre
& Siebel eCustomer
. Strong knowledge in Siebel CRM Architecture and Data Model.
. Proficient with Siebel Tools and Client in configuration and
customization of Siebel Objects at multiple levels.
. Excellent Siebel development skills in implementing Siebel Scripting
(Server & Browser), Workflow Processes, Workflow Policies and Business
Services
. Excellent understanding of the Call Centre, Sales, E-costumer,
Financial modules.
. Have fair knowledge of Enterprise Application Integration - EAI
. Proficient in creating and deploying BI Reports
. Have experience in using JAWS and WAVE tool for accessibility.
. Highly analytical in developing the methods and measures to meet
requirements and solve any issues that arise during the project.
. Optimum use of documentation to avoid any form of miscommunication or
misinterpretation during the entire software development process.
. Skills in developing Use Case diagrams, Sequence diagrams, State Chart
diagrams, and Class diagrams
. Exposure in creating and analyzing Data flow diagrams, and Entity
Relationship diagrams.
. Strong knowledge of Project management skills such as time estimation,
task identification, and scope management.
. Experience in customer / client interaction, deep understanding of
business systems functionality and technicality.
. Conducted requirement analysis techniques such as Business Process
Automation, Business Process Improvement, and Business Process Re-
engineering.
. Proficient to productively work remotely, even on an onsite-off-shore
model
. Proficient in making the system ready for 508 compliance.
. Experienced in using the Quality center tool and QuickBase application
for defect management
. Good knowledge of SQL queries and PL/SQL procedures.
. Experience in writing test plans, defining test cases, developing and
maintaining test scripts.
. Expertise with QA Methodology to ensure robust functionality.
. Also involved in presales activities, providing end to end IT Solutions
to clients.
. Co-ordination with the Core Team Members / Network Team for day to day
support activities
. Ability to rapidly learn & apply new technologies to make an impact as
a productive individual contributor as well as team player
EDUCATION:
Bachelor of Engineering (Computer Engineering), India
Trainings:
Business Analyst - Siebel 8.1.X
. Siebel 7.7 CCC
. Oracle (SQL)
. WAVE Tool
. 508 compliance
Technical Skills
Siebel Version : Siebel 8.1, Siebel 7.8, Siebel
7.7, Siebel 6.0
Languages : C++, SQL, eScript
Databases : Oracle 9i/10g
Operating Systems : 2003 Standard/Enterprise, Red Hat, Ubuntu,
XP/Vista
Tools & Utilities : Siebel Tools, WAVE, JAWS, TOAD, SQL Dev,
MS
Visio, PowerPoint, Microsoft Word, Excel.
Defect Tracking Tool : HP Quality Center, Mercury
Quality Center
Centers for Medicare & Medicaid Services (CMS), MD Nov
2010 - Present
Sr. Siebel Business Data Analyst
Project Description:
The project is for creating and tracking appeals for US Department of
Health & Human Services known as MAS. This project is basically involving
Production support & Enhancing the application. It also has Siebel Standard
Interactivity application to provide accessibility support. It is spanned
across multiple releases & has many different groups of users for which
different customizations are implemented
Responsibilities:
. Assured that all Artifacts are in compliance with corporate SDLC
Policies and guidelines.
. Conducted JAD sessions with the stakeholder on 508 compliance.
. Created UAT/QA test plans, strong manual, functional, system and
regression testing in an agile development environment
. Involved in updating the System Requirements & Technical Design
documents
. Participated in the business process and workflow, interacting with
technical and non-technical staff to articulate technical concepts
. Monitored and assisted in designing and development of Use Cases,
Activity Diagrams, Sequence Diagrams, OOD using UML
. Translating requirements and process flows into Siebel-specific
functional design which are in liaison with Siebel best practices
. Ability to convince and obtain consensus across stakeholder groups.
. Worked on making the system 508 compliant, it involved changing the
HTML Attribute property, modifying the controls & layout.
. Created & deployed BI Publisher Reports
. Used BI Publisher Desktop Tool to customize existing BI Templates.
. Integrated BI Reports with Siebel & generated the same in PDF & WORD
. Used WAVE Tool to find & track the page accessibility & fix the same.
. Compared and verified the functionality/layout changes in High
Interactivity Vs. Standard Interactivity for both applications.
. Documented the discrepancies between the standard and high interactive
application version.
. Gap Analysis between Siebel 8.1.1.3 SIA vs. 8.1.1.4 SIA.
. Configured Static & Dynamic Toggle Applets
. Customized Pick Applets, Associate and Shuttle applets and configured
MVGs using MVLs.
. Prepared the EIM jobs integrating with the external system for bulk
import of data.
. Use SQL to query for data across the databases.
. Coordinated with testers to effectively track/fix/close the defects
encountered.
. Single POC for raising/ maintaining/ documenting/ updating ORACLE
support SR & 508 Issues.
. Sanity Testing the system at the end of each migration.
. Involved in Regression testing as the new enhancement has been
developed.
. Successfully migrated the sif, images and other deliverables across
multiple environments using VSS.
. Maintained versions for deliverables for each phase/release.
. Single POC for check-in check out request in VSS.
. Actively migrated the user (LOV), admin data (View-Responsibility) &
srf across the environment and worked closely with CM team.
. Analyzed requests and provided appropriate feedback to insure that the
information being requested and provided make sense in the context of
what is being asked.
. Developed SQLs for Extracting data from database and built data
structures, reports.
Farmers Insurance, CA
Nov 2009- Oct 2010
Sr. Siebel Business Systems Analyst
Project Description:
The project is for one of the largest Insurance Company of North America.
This project involves implementing a CRM solution for different lines of
business and moving the client away from its current mainframe-based
system. It involves use of many technologies including Siebel, IBM MQ, BEA
Aqua logic etc. This project is basically divided into 2 areas: Upgrade
from existing Siebel 6.0 to Siebel 8.0 application and Enhancing the
application by use of Siebel Out of the Box features plus incorporating new
requirements
Responsibilities:
. Identified processes for developing and documenting detailed business
requirements. Data was collected from end-users, and analysts.
. Participated in Joint Application Design/Development (JAD) sessions and
involved in discussions with clients/users/SME to determine the
dimensions, hierarchies and levels, basic measures, derived measures and
key metrics for multidimensional data model for the system, understanding
reporting requirements, designing star schema data model. The business
users from Finance, Risk, and Compliance participated in the JAD sessions
to gather and interpret the business requirements.
. As part of SWAT team member, worked closely with business, testing team &
developers in resolving the defects. .
. Involved in weekly walkthroughs and assessment meetings, to verify the
status of the testing effort and the project as a whole.
. Followed a structured approach to organize requirements into logical
groupings of essential business processes, business rules, and
information needs, and ensure that critical requirements are not missed
. Followed the UML based methods using MS Visio to create: use case
diagrams
. Implemented and managed migration process and tracked progress for team
members of project through completion
. Determined and documented the discrepancies between Siebel 6.0 & 8.1
. Performed Sanity Test for the upgraded application
. Prioritized enhancements for a specific release as per the project plan
. Determined and assigned View-Responsibility to various users.
. Tested Fields for data Validation
. Worked on the development and changes to the look and feel of the
application and performed user acceptance testing for errors
. Was responsible for creating the test plan, high level test case
documentation & complete End to End testing. Was involved in the creation
of both the Shell test cases and the Site specific test cases
. Was responsible for tracking issues that are detected and updating the
status of existing issues based on the daily meetings with the off-shore
team
. Troubleshot issues related to Select Refresh and data loading process
. Analyzed the tables that were being loaded to as to exclude tables that
were not needed and tables that were too big, so as to minimize the time
taken to refresh the test environment
. Prepared a list of the critical customers and materials that were
necessary to load to the testing environment to execute all the scenarios
during testing
. Identified and analyzed the data requirements for the various site teams
and made sure that the required data is available in the testing
environment.
. Prepared Test Data Matrix which had the data requirements for each of the
site teams and was used to load data to the test system
. Analyzed and maintained the status of all the jobs in the WBS as per the
project plan and updated the project plan for QA team on a regular basis
for the weekly status report meeting
. Conducted result analysis and interacted with developers to resolve bugs
IEEE, NJ
Apr. 2007- Oct 2009
Business System Analyst
Project Description:
This project is for a non-profit organization known as IEEE, which is
primarily involved in setting the industry standards for diverse areas.
Basically the company's business is involved in generating members who rely
heavily on it as a source for technical and professional information. They
used eCustomer for member registration and Call Center for administration.
Responsibilities:
. Actively involved in requirements definition meetings with design team
. Participated in design walkthroughs and prototyping and implemented
the suggested changes
. Tested the functionality for entire online product shopping (Checkout)
process.
. Associate View to Responsibilities and LOVs creation/maintenance.
. Project initiation documents preparations related to infrastructure
management
. Worked on many SQL queries used to verify the data uploaded in the
database
. Worked on creating traceability matrix to trace Business Requirements,
Functional Requirements and Use Cases
. Worked on performing Gap analysis between businesses requirements of
proposed system and existing system
. Worked on creating UML Diagrams
. Worked as a team member to design the models for the database, and Ad
hock reporting
. Worked on manual testing of the data base, and on various reports in
MS Excel.
. Worked on Project documentation preparation with MS Visual Studio, MS
Power Point and MS Word Document.
. Played a major role in developing the product user manual
ADA, IL
Apr. 2005 - Mar
2007
Business Systems Analyst
The project was for one of the world's largest dental association. ADA
Upgraded Siebel 7.5 to Siebel 7.8 Call Center and Financial eCustomer and
also added enhancements the functionalities of existing applications for
managing their employees, customers and clients.
Responsibilities:
. Actively involved in requirements definition meetings with design team.
. Participated in design walkthroughs and prototyping and implemented the
suggested changes.
. Configured and customized the Applets, Views, Screens, Business
Components and Business Objects through Joins, Links, MVGs and MVLs.
. Involved in configuring State Model and worked in configuring List of
Values, Pick Lists (Static &Dynamic), Toggles and Drilldowns.
. Extended the Siebel tables through Custom tables and columns.
. Associate View to Responsibilities and LOVs creation/maintenance.
. Project initiation documents related to infrastructure management.
. Created new extension Table as per the requirement.
. Created new fields in BC and user properties to achieve desired
customization.
. Involved in participating and organizing JAD sessions with the business
users to fix the anomalies in the mapping process and participated in Gap
Analysis to identify data anomalies to determine the cause and identify
options for the removal of the data anomalies.
. Created, Verified and managed the First Responders list, and IT call
list.
. Discussed with client groups to determine User Requirements and Goals,
thus converting User Requirements into Business Requirements and User and
Functional Requirement Specification.
. Analyzed the system and suggested enhancements for the system so as to
streamline the business process and to make sure the accounting process
was correct, efficient and effective.
. Documented the enhancements and converted them into business rules so
that they can be used by the development and the testing teams
. Developed ER diagrams and Physical Data-model along with the testing team
so as to provide a clear understanding of the system under development
and for reference of the testing tem
. Developed the Business Requirements Document for the reports that was to
be used by the development team and later by the testing team
. Worked closely with the project Manager in planning, coordination and
implementing methodology.
. Responsible for Documenting in each phase of RUP Methodology, in Risk
Assessment, and in validation & verification of the Testing process
. Linked the requirements to the appropriate test cases and maintained RTM
in Quality Center.