SUMMARY

• Qualified MS in Software Engineering, BITS Pilani, RajasTEMPthan and 8+ years experience in handling several types of CRM projects. Proficient in SalesLogix, Siebel 6, 7.8, 8.0 and 8.1.1.11.Expertise in Siebel Configuration, eScripting, Business Service, Work Flows, Assignment Manager, BIP and Siebel EIM.
• Keen understanding of Siebel architecture. Proficient in Siebel Administration, EAI, Workflow & problem solving skills. Involved in Project Management, implementing BR. An TEMPeffective communicator wif strong relationship management skills. Adept at maintaining cordial business relations wif Clients.
• Extensive experience in CRM implementations of Siebel Financial Services, eFinance and eCommunications. Key areas of skill consist of Requirements gathering, functional and technical analysis and documentation, GAP analysis, configuration and software development.
• Good hands on in List Import and BI Publisher report development (Integration Objects & SQL Reports).
• Proficient in facilitating scope definition including functionality, technology and project plan development to set expectations for deliverables and schedule.
• Expertise in data analysis and validation by using complex SQL.
• Knowledge of Tableau reporting tool.
• Expert in Validating the application requirements to meet overall business process needs wifin the project scope working wif the Business, their staff and the SME’s.
• Experience in analysing volumes of data using MS excel(Pivot tables, formulas, V - lookup), VBA and macros.
• Developed complex Database objects like stored procedures, functions and triggers for performance enhancement and automation.
• Reviewed project deliverables for completeness, quality and compliance wif established project standards.
• Involved in PLSQL and VB automations related to applications.
• Proficient in Subrogation process and has coordinated wif vendor and business team for the technical issues.
• Proficient in writing complex SQL queries and extracting data to generate customised reports based on the requirements from client\business.
• Functional Knowledge across different domains:- Security Products and Services, Banking, Insurance and Retail
• Experience in various SDLC methodologies:-Agile and waterfall.
• Handled onsite resourcing needs, performance management and people management for multiple teams.
• Certified in CRM Siebel on Demand and proficient in PLSQL, Toad and SQL Developer skills.

PROFESSIONAL EXPERIENCE

Associate Consultant

Confidential

Environment: Siebel eCommunications 8.1.1.11, VB Script, SQL, Oracle 11g

Responsibilities:

• Working as Siebel Techno-Functional Lead to support Siebel application.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Responsible for Incident Management and providing assistance to application users for smooth functioning of Compass(Siebel) application.
• Coordination wif Business team & end users for requirement elicitation, analysis & preparation of business requirement documents.
• Debug Siebel technical issues, perform root-cause analysis & provide resolution for production issue
• Work on effort estimations & preparation of functional design documents.Automated excel reports
• Arrange conference room pilot wif business users to brain storm on the proposed solutions & identify gaps.
• Responsible for technical design document review.
• Coordinating and Leading the team in putting the strategy to integrate a new solution
• Development of requirements & code review for the team members
• Working wif the client to understand business needs and objectives and assist in the design and implementation of new solutions.Significant highlights:
• Automation of the Business Processes and other manual processes wifin the application
• Involved in client discussion during production deployment and in migrating the changes across business on time.
• Proposed solution to integrate Oracle TCA to Siebel
• Analysed all the BIP reports and provided suggestions for the new design
• Provided analysis and recommendations to the Business on any process decisions, gaps, or unmet requirements.
• Played major role in Establishing and Stabilizing the Project.

Confidential

Lead Engineer (12 Months) -Onsite

Environment: Siebel Financial Services 8.1.1.11,VB Script, SQL, Oracle 11g

Responsibilities:

• Provided Level 3 support to the SRM\WCIS Applications.
• Interaction and coordination wif users and business for production support issues.
• Delivery of the requirements/stories using the Agile Framework
• Root cause analysis and preparation of understanding document for the enhancements.
• Created custom reports using Tableau reporting tool as part of POC.
• Provided technical guidance and application noledge to the offshore team.
• Performed data analysis and validation by using complex SQL.
• Coordination wif QA Team & Business in QA & UAT testing cycles.
• Support admin team in deployment activities.
• Provided post Deployment Support.
• Involved in handling incident and problem management from onshore efficiently.
• Implemented Marketing Import and Applet Import based on customer needs
• Involved in client discussion during production deployment and in migrating the changes across business on time.
• Automated several marketing import templates using macro.
• Automated data loads and reports mailing.
• Developed Client side Business services for fixing production issues.
• Configured Runtime event in production environments for non srf fixes.

Confidential

Production Support Module Lead

Environment: Siebel eFinance 6, 8.1

Responsibilities:

• Provided production support to the CRN\Heart Applications.
• Interaction and coordination wif users and business for production support issues.
• Provided resolutions for tickets and defects.
• Wrote complex SQL queries for extracting data to generate customised reports based on the requirements from client\ business.
• Root cause analysis and preparation of understanding document for the enhancements.
• Interfacing wif business analysts to resolve clarifications from offshore.
• Provided technical guidance and application noledge to the offshore team.
• PLSQL & VB automations Analyzing Anomalies.
• Coordination wif testing teams to fix defects raised.
• Providing post Deployment Support.
• Worked as Module Lead for CRN\Heart Production Support leading a team of 10 members
• Involved in handling incident and problem management from onshore efficiently.
• Involved in client discussion during production deployment and in migrating the changes across business on time.
• Ensured cross-team communication and collaboration.
• Identified cross-team issues and coordinated issue resolution.
• Provided analysis and recommendations to the Business on any process decisions, gaps, or unmet requirements.
• Involved in preparing monthly reports related to production efforts.
• Automated data loads and reports mailing.
• Lead offshore team efficiently and always maintained zero backlogs throughout my tenure.
• Involved in outage calls related to Siebel production environments and lead in front in resolving issues ASAP.
• Coordinated wif farmers business team and vendors for Subrogation related issues

Confidential

Siebel Financial Release Coordinator (8 Months) -Onsite

Environment: Siebel eFinance 6, 8.1

Responsibilities:

• Independently handled Business Requirements and Responsible to drive the product development, marketing and functional strategy for key technology solutions.
• Lead the 5 member CRN team comprising developers at both onsite and offshore.
• Represented the team in release scope management, requirement review, release status, architecture review and defect review meetings.
• Handled onsite resourcing needs, performance management and people management for multiple teams.
• Interfaced wif vendor partners on behalf of customer in designing integration applications.
• Active support during release deployment.
• Supervising resolution of critical production issues.
• Guided the team in resolving technical challenges.
• Worked as Onsite Coordinator for CRN release project leading a team of 8 members
• Played major role in Establishing and Stabilizing the Project.
• Engaged project manager, team members, and SME’s in conversations about the system functionality, business process changes, and gap recommendations.
• Reviewed and signed off on requirements, process flows, gaps, and design documents.
• Ensured dat the organization and distributed user community are prepared to use the product and the necessary support is in place.
• Seek, accept, and respond to feedback from the users during and after the system is installed.
• Designed Complex Assignment Manager Configurations.
• Involved in showcasing and configuring Siebel electronic signature capture capability.
• Rewarded as outstanding performer.

Confidential

Development\Support Engineer

Environment: Siebel eFinance 6, 8.1

Responsibilities:

• Participated and assisted in the requirements capturing of the Insurance functionalities.
• Involved in application production support and maintenance (configuration, data migration, and Interface and server administration).
• Supported Siebel eFinance Application in different languages like English and Spanish
• Created Functional, Technical and design documents for enhancement requests.
• Responsibilities included configuring and optimizing the Routes module which TEMPhas been the critical part of the Application involving complex custom Business Services and Work Flow Processes.
• Worked on Peregrine Incident management and Problem Ticket Management so as to track production issues.
• Created UTC documents and review documents for testing environment.
• Configured Object definitions in the UI layer and Business object layer.
• Used eScripting on a large scale so as to meet the business logic
• Configured User Properties at Business Component level for reducing scripting.
• Configured Integration Objects for Application integration.
• Designed and configured different types of objects like Business components, Applets, Pick Applets, Links and Joins.
• Added Screen and Views.
• Developed Client side Business services for fixing production issues.
• Configured Runtime event in production environments for non srf fixes.Server Administration Lead Role
• Involved in Server Admin Related activities such as Repository Migration, SRF Replacement, Restarting components, SRF Stamping.
• Involved in Siebel remote components issues and worked on performance tuning.
• Created database indexes, triggers for performance tuning issues.

Confidential

Software Engineer

Environment: Saleslogix 6.2.6, SQL server 2000,VB Scripts, Crystal Report

Responsibilities:

• Involved in gathering business requirements and developing Business Requirement Document.
• Customized the Sales Module as per the requirements given by ConAgra.
• Heavy Customization of Account, Contact, Opportunity, Literature Fulfillment modules
• Created and modified custom Tables, Fields, Records, Navigation Bars, Tool Bars, and Menus as per the requirements.
• Developed complex Database objects like stored procedures, functions and triggers for performance enhancement and automation.
• Created custom reports for the client using Crystal Reports
• Created custom tools

TECHNICAL SKILLS

SalesLogix: 6.2.6

Siebel CRM: 6, 7.8, 8.1,8.1.1.6 and 8.1.1.11

Languages: C, C++, VB, C#, VBScript

Software Tools: Websphere MQ 4.3, CCC-Harvest, Lotus Notes, Crystal Report, BIP, Tableau, Macro

RDBMS: Oracle Database 10g and 11g, SQL Server 2000, Sybase, ODBC, PL/SQL, SQL

LOADER, SQL*Plus, TOAD, Turbo C++.:

Web Technologies: HTML, DHTML

PM/Architect Tools: MS Project, Quality Center (Defect Tracking), MS Visio, MS Office