SUMMARY

• 8 years of IT experience in Analysis, Design, Development, Implementation and Testing of various CRM, Client/Server Technologies and Web Technologies.
• Involved in every SDLC phase of the project with thorough understanding of the delivery process and expectation
• Excellent Knowledge of Siebel business Platform and underlying architecture
• Expertise includes industry knowledge for implementing Siebel Sales, Siebel Call Center, and Siebel Marketing, Siebel Lead Management, Siebel Order Management and integration of Siebel with other enterprise applications.
• Strong knowledge of Software Development Life Cycle (SDLC - Requirements Analysis, Design, Construction, Testing, Implementation, Support), Project Life Cycle and SDLC Models - Waterfall, Prototyping, and Methodologies - Agile (SCRUM), Rational Unified Process (RUP)
• Extensive experience in application development using Siebel including Siebel Sales, Siebel Marketing, Siebel Order Management, Call Center, Siebel Support, Siebel eScript, EIM, EAI, Workflow, Assignment manager and Smart Scripts.
• Extensive Siebel background including performing Technical Architecture, Design/Process mapping, Tools configuration, Workflow, eScript, EIM, Siebel Actuate, Siebel Data Model and Server Administration.
• Worked on design and implementation of Oracle’s MDM suite and Oracle Enterprise Data Quality (EDQ) application.
• Extensive experience in HealthCare industry - Membership, Eligibility, Claims and Billing.
• Working experience in EDI HIPAA 4010, 5010; 837, 835, 270/271, 276/277 Transactions.
• Very good working experience in Medicare and Medicaid plans, Medicare Parts A, B, C & D, and Insurance Claims.
• Excellent knowledge in Healthcare domain like Claims system, Medicare, Medicaid, Managed care, Health Plan, provider, membership and HMO/PPO.
• Hands on experience in Business Intelligence tools and data analytics background and an in depth understanding of how to design and createOBIEEapplications, and reporting solutions.
• Trained and educated other team member around core Siebel TPM functionalities and help them deliver high quality and deliverables.
• Strong technical skills include development and customization of applications to suit specific requirements for various clients utilizing Siebel Tools, Oracle, SQL.
• Expertise in Siebel Configuration, Siebel Data model, Siebel Architecture, EIM Interfacing with Legacy/Proprietary DB, Integrating Siebel Applications with third party.
• Experience indocumenting Functional specifications, Data Mapping Documents, Testing requirement documents, Use Cases & Process flow Diagrams.
• Experience in all aspects of the Software Development Life Cycle (SDLC) from inception to Implementation.
• Hands on experience in creating Use Cases, User Stories, Activity Diagram, and Sequence Diagrams
• Comprehensive knowledge of RUP, Waterfall and Agile (Scrum & XP) methodology
• Expertise in writing, Maintaining and Executing Test plans, Test procedures, Test Cases and generating software defect reports for the developers and stakeholders.
• Strong working experience on database tool like Oracle 8i/9i/10g, Microsoft SQL and Microsoft Access.
• Expertise in Problem solving and Bug Reporting using Bug Tracking Tools.
• A high tendency and capability to suit to the high paced and largely pressurizing work environment at a software development organization.

TECHNICAL SKILLS

Programming Languages: C, C++, VC++, C#, JAVA

Siebel Modules: Siebel Sales, Marketing, Siebel TPM, Order management, Call Center, CRM, Leads, ePricerProduct Configurator,EIM, EAI, CTIDatabases Oracle 8i/9i/10g, Microsoft SQL Server 2000/2005/2008 R2, MS Access

Web Development: VB.Net, ASP.Net 2.0/3.0/3.5/4.0 , HTML, DHTML, XML, CSS

Siebel Skills: Siebel Sales, Siebel Call Center, Siebel Marketing, Siebel CRM

Siebel Packages: Siebel 6.x/7.x/8.x

Microsoft Tools: Microsoft (Word, Excel, Power point, Visio, Project)

Operating systems: MS DOS, Linux, UNIX, Windows 98/2000/2003/ NT/XP/Vista/7

Testing Tools: Mercury Quality Center, Test Director, Win Runner 7.0, QTP 8.0.

PROFESSIONAL EXPERIENCE

Confidential - Reston, VA

Siebel Systems Analyst

Responsibilities:

• Involved as a business analyst in the team participating in JAD sessions with the Business Users and the end users (CSR’S)
• Developed high level Design documents for data mapping of various function points discovered during Discovery and Design stage
• Involved in developing training documents for heavily customized applications such as VBC applet, EBC which invokes a Business Service to retrieve the data from external system and also to write the selected records on VBC applet into Siebel (Vanilla) database.
• Created Outgoing and incoming workflows for EAI data synchronization
• Worked closely with cross-functional team members (development, testing, end-users) to understand business and technical requirements to derive the data requirements.
• Worked closely with Siebel TPM analytics reporting and the ETL team to performance
• Extensive experience in designing and or managing major Siebel projects.
• Executed SQL queries in the preparation of data requirements documents.
• ValidatedSiebel workflow rules, validation rules and functionality of different fields for Opportunity, Account, and Contacts in the Siebel CRM.
• Provide solution to call center reps to view account information and manage & track customer orders in Siebel.
• Designed processes to integrate Oracle's Enterprise Data Quality (EDQ) for data cleansing and standardization.
• Configuration and integration of Siebel reports with OBIEE and other applications.
• Managed product Master Data Management (MDM) changes to support the standardization of downstream processes and the migration of multiple enterprise resource planning (ERP) instances to a single global instance.
• Involved in E2E testing to make sure that all integration is working fine specially Opportunity to Cash cycle (Oracle EBS, SFDC, Siebel CRM)
• Created manualTest CasesinHP QC/HP ALMfor variousUser Storiesbased onReleaseandSprintPlan.
• Having knowledge of Enterprise Application Integration (EAI), Web services.
• Developed training scripts at Business Service level which updates the parent Activity record with the correct Account Id in case if wrong Account is popped by CTI
• Developed and configured Pick lists, MVG’s, Screens, Views, Links, Joins, Business Objects to meet the user interface layer requirements.
• Developed a complete solution and detailed requirements for the replacement of Business Objects with Siebel Analytics/OBIEE.
• Used a Meta Data repository to capture and present mapping, standards and application within the Oracle's Enterprise Data Quality (EDQ).
• Worked on Siebel TPM related functional and technical tools.
• Support for the Siebel Sales application. Debugging of production issues and root cause analysis.
• Configured various applets and developed scripts at applet level to invoke buttons and to meet various customized activities as per user requirements
• Done data mapping for the Bus Comps configured and extended number of columns at table level based on the requirements
• Worked on detailing, sampling and syndicated data.
• Anaylzed data requirements and developed and tested workflows, Assignment Manager tasks, EAI, EIM, Smartscript, Siebel Upgrades to do specific activities background based on the requirements

Environment: Siebel Product Catalog, Siebel Sales Force Automation, Siebel TPM, HP ALM, Siebel Marketing, Siebel ePricer, MS Office, Mercury Quality Center, OBIEE, MS Project, Visio, Quality Center, EIM, QTP, Access

Confidential - Stamford, CT

Sr. Siebel Business Analyst

Responsibilities:

• Design Business Process Flow as per the Business Requirementsand created functional specification.
• Create Cross functional process flow diagrams in Visio.
• Involve in JAD sessions with Developers for analysis or requirement and for Technical Solution.
• Work on defining interfaces and data mapping between Siebel and various applications accessing Siebel downstream Schema to access data.
• Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
• Created Testing Requirements Document (TRDs) and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
• Involved in Writing and executing SQL scripts to test various reporting logic and data accuracy.
• Involved in writing Test plans, Creating Test scripts, Team Co-ordination, Training and Technical Writing.
• Worked with the Testing team to resolve, fixing and testing problems found during the Systems integration test, Functional testing & UAT Phases.
• Complete approved business requirements for Siebel TPM technology.
• Writing, unit testing and integration testing data quality software using Oracle's Enterprise Data Quality (EDQ).
• Organized the test cases in Mercury Quality Center fortraceability and monitored test results, tracked defects and communicated them using Mercury Quality Center.
• Integrating Siebel with external Systems and other enterprise applications.
• Configured Siebel applications and environments to support business requirements, performance and technical design specifications.
• Developed a complete solution and detailed requirements for the replacement of Business Objects with Siebel Analytics/OBIEE.
• Experience in administering and configuring Siebel CRM application to includeworkflows, page layouts, user profiles, roles, security access, data validation, data utilities, reports and dashboards.
• Design, develop and performance tune Web Services and Business Services; Siebel Adapters, EAI Transport Adapters, HTTP, XML, XSD, SOAP, WSDL.
• Used Siebel Assignment Manager to automate the routing of sales accounts and sales opportunities to the appropriate users
• Supportapplicationimplementation through design reviews, development, code reviews, unit testing, deployment and support.
• Analyzing and profiling sources of data used in Oracle's Enterprise Data Quality (EDQ) Solutions
• Involved in creating Unit Test case, preparation of Test Logs and performing self and peer review based on predefined set of coding standards.
• Fine-tuned various long running queries for improving System performances.
• Work on various aspects of Siebel Application like visibility rules based on positions and responsibilities, various Siebel constructs like MVG applets, Pick lists, Applets, Views, various Navigation methods.

Environment: Siebel Sales, Siebel Leads, Siebel Marketing, Contract Management, Siebel ePricer, Siebel PRM, Siebel Marketing, Siebel TPM, Mercury Quality Center, Siebel Campaign Management, Siebel Loyalty, Business Objects, MS Office, MS Project, Visio.

Confidential, Mississippi

Business Analyst

Responsibilities:

• Actively worked on Business requirement gathering, analysis and Data analysis.
• Created Business Rule Comparison (BRC) documents and Side-By-Side (SBS) comparison documents using 10 implementation guides for X12 transactions(i.e. 837 (I, P, D), 834, 835).
• Created BRCs of EDI inbound and outbound transactions and mapped the provided data.
• Identified risks, problems, requirements and concerns of the Hospital in order to comply with ICD-10 changes by conducting interviews.
• Collected the information related to ongoing application upgrade. Studied their impact on ICD-10 implementation and created awareness within departments.
• Involved in providing education/training about the ICD-10 codes and 5010 standards, its requirements, complexity, and accuracy to Physicians and Nurses.
• Extensively involved in HIPAA 5010 User Acceptance Testing (UAT). Defined and maintained Test Cases for EDI transactions.
• Worked with business users to assess the impact of implementation of HIPAA 5010 on claims processing and EDI Transactions.
• Worked with multiple clearing houses to ensure smooth transition to 5010 standard for their day-to-day EDI X12 transactions.
• Manually read through the loops, segments and elements of individual test files from clearing houses using Notepad++ and compared them to Implementation Guide/ Companion Guide to ensure that they met 5010 standards. If errors were found on these, the same were communicated back to the clearing house and asked them to resubmit the file after making necessary changes.
• Used HP Quality Center for error reporting and communicating between developers, product support and test team members.
• Worked on various subsystems within the MMIS including but not limited to Recipient Payer, EDI etc.
• Used MS Share point for sharing documents, calendars and other data between users in different locations.
• Checked the functionality at implementation level using SQL and PL/SQL.

Environment: Microsoft Office suites (Word, PowerPoint, Access, Excel, Outlook, Project, Visio), Quality Center.

Confidential - Bellevue, WA

Siebel Business Analyst

Responsibilities:

• Extensive experience in effectively interacting with clients.
• Coordinated project from onsite with respect to documentation, deliverables and updates.
• Responsible for the solution design of requirements on the end to end BSS (Business Support Operational) systems architecture which includes components ranging from Siebel, AIA (Application Integration Architecture), BRM (Billing and Revenue Management), OSS (Operational Support Systems) and ASAP (Automated Service Activation Platform).
• Involved in successful implementation of major TERs and CRs including Circle of Friends, Family Plan Implementation and Intra-Company PortIn within COX.
• Performed Technical Assessment of Siebel Upgrade for COX from 8.1.1 to 8.1.1.3 and successfully implemented the same.
• Effectively handled Siebel change requests/defects by proposing and supporting the design, development and testing of solutions documented in CR Notes.
• In-depth knowledge of the Oracle BI Publisher technology and an extensive experience in delivering Oracle BI Publisher based reporting solutions in Siebel.
• Prepared training documents for Call Center agents on system usage determining opportunities for improvements.
• Specialize in working with technical staff to create, interpret, and implement business requirements into technical specifications.
• Experience in Siebel Administration & Management and Production Support including deployment and migration activities from Development through Testing in Production environment.
• Resolved operational and production issues through in-depth coordination with cross functional/ cross divisional teams

Environment: Siebel Contract Management, Siebel ePricer, Siebel PRM, Siebel Marketing, Siebel Campaign Management, Siebel Loyalty, Business Objects, MS Office, MS Project, Visio.

Confidential - Bothell, WA

Siebel Business Analyst

Responsibilities:

• Used Siebel Assignment Manager to automate the routing of sales accounts and sales opportunities to the appropriate users.
• Implemented Siebel Order Management for corporate clients
• Used Siebel EIM to export the Service Agreement billing data into SAP R/3 system for Invoicing.
• Created personalized home page for each service providers (Channel Partners.
• Integrate with SAP R/3 via Siebel Enterprise Connector to implement the quote and order generation process.
• Configured Siebel Service Remote that enables the field service agents to automatically log time and expenses and to log activity related to the Service Requests
• Implemented various business processes using Siebel Workflow Manager.
• Worked on Workflow Groups, Work Policies, Workflow Process and Business Services.
• Implemented various business processes using Siebel Workflow Manager

Environment: Siebel Real Time Decision Engine (RTD), Siebel Marketing 7.8, Siebel Call Center 7.7, Siebel Product Catalog, Oracle, MS Office, MS Project, Visio.