Siebel Crm And Analytics Resume
SUMMARY
Experienced in analysis, design, development, testing, implementation, production support and maintenance of various Business Applications. 10+ years of experience in Siebel CRM and Analytics environment. Worked on CRM, Marketing Campaign Management and Analytics. Extensive knowledge in entire Siebel Project Delivery life cycle including requirements gathering, customization, development, prototyping and testing including functional testing. Experienced with RDBMS and SQLs development. Worked on various databases like Oracle, Sybase, SQL Server, UDB DB2, MS Access and SQLBase. Worked on stored procedures, views, triggers and SQL queries. Detail focused, aggressive problem solver able to multi-task and to meet a deadline. Committed to superior customer service.TECHNICAL SKILLS
Siebel CRM 8.0 / 7.5 / 6.0
Quick Test Professional 11
Oracle 7
Siebel Analytics 7.7
Win Runner
Oracle Forms 4.5
JavaScript/ VBScript
Load Runner
SQLBase 7.5
UDB DB2
HP Quality Center 9.2
Centura Builder 1.2/ SQL Windows 5.0
Sybase 12
Informatica 8.6+/7/1
MS Access 2002/98/97
SQL Server 2000/7.0
Crystal Reports 10/8/7.5
Micro Focus COBOL / Vax COBOL
Web Methods
FoxPro / Clipper 88 / Paradox
EDUCATION
- M.S. in Technology Management
- Post-graduate Diploma in Systems Management
- Bachelor of Commerce in Financial Accounting
PROFESSIONAL DEVELOPMENT / TRAINING
- Siebel Analytics Server Architect 7.7
- Siebel eBusiness Essentials
- SQL Windows
- Oracle database
PROFESSIONAL AND BUSINESS EXPERIENCE
Confidential,
March 2002 to August 2010
Environment: Siebel 8.0 / 7.5, Siebel Analytics 7.7, JavaScript, UDB DB2, QTP, HP Quality Center
Confidential,is a global; diversified financial services organization. I worked at MassMutual supporting the Retirement Services systems for Siebel CRM and Analytics projects. I was actively involved with CRM development team, business users, business analyst and testing team. I was also assisting Production support team, Analytics development team and Integration teams. This was a very challenging environment with lot of integrations with Legacy systems for the nightly batch involving webMthods and ETL. This also involved Siebel ASL calls to get real-time financial data from the Legacy system.
- Worked on various modules and enhancements and support our Sales team, PIC (Call center), Roll-in Roll-over team and Account Managers / Relationship Managers
- Worked on Blackberry Pyxis mobile solution integrating with Siebel for our Sales team
- Worked closely with the marketing team to help/support them with Siebel Campaign Management
- Involved in the design, development and testing of first Siebel Campaign Management release which includes Segmentation Bridge. It connects Siebel 7.5 to Analytics 7.7 and also customization and development of various Analytics segments, list formats and Siebel campaign templates
- Interact with business partners, understand their requirements and provide solutions, work with contractors and train new team members
- Liaise with developers, business analysts, and user representatives in application design and document reviews
- Review test plans and defined cases for functional, integration system, and user acceptance testing
- Performed extensive integration testing of the application, tested source and target databases using SQL queries
- Work closely with team members and business users in development of various Answers requests in Analytics for testing and data analysis purpose for business users
- Train and helping business users in creating new Answers requests and maintain existing Answers requests
Synergy America, Inc.
Client: Confidential,
June 2000 to December 2001
Environment: Siebel 2000 - 6.0.2, JavaScript, DB2, Centura Builder 1.2 (SQL Windows), Sybase 12
I worked on Siebel CRM system, which provides Sales, PIC & Ontrack users with the Sponsor, Plan, Subscription, Participant and their activities information. This was the first implementation of Siebel at MassMutual and I worked very closely with Accenture team and MassMutual team to implement end-to-end solution.
- Interact with Business Analysts to gather requirements
- Involved in the design and development of various Sybase database views for the daily night batch process to extract data from Reflex system for Siebel
- Involved in the design and development of Siebel EIM jobs
- Design and develop various Siebel Application applets, views, screens, business components, etc.
- Performed extensive integration testing of the application, tested source and target databases using SQL queries
Synergy America, Inc.
Client: Confidential,
June 1996 to May 2000
Environment: Centura Builder 1.2 (SQL Windows), SQLBase 7.5
Confidential, provides a multi-service billing and support system for the total telecommunications provider. I developed a feature-rich billing and support system “WinCommand”, which provides a Windows based Customer management system and a multi-service statement format. The system facilitates the complicated rating, taxing and processing associated with billing wireless and other telecom services. The system comprises of various modules such as Basecmd, Service order, Cash management, Inquiry, Extract/Update, etc.- Involved in the design and development of the forms using Centura Builder 1.2 as the Front-end with SQLBase 7.5 as the backend
- Involved in the conversion of applications from SQL Windows 5.0 to Centura Builder 1.2
- Involved in design and development of utilities for import/export data to VAX-VMS system Involved in design and development of various other internal projects using Centura Builder 1.2 as the front-end with SQLBase 7.5 as the backend
- Involved in the implementation and user support for the system
- Provide training to the users and business clients
Blue Chip Computer Consultants
Client: Confidential,
November 1994 to May 1996
Environment: HP-9000, Oracle 7 / Forms 4.5, 80486, SQL Windows (5.0.1), SQLBase Engine (5.2.0-A)
The Company is a pioneer manufacturer of Plastic processing machinery viz., Injection Molding machines, Blow Molding machines and Extrusion lines.
- I was a key member of a consulting team from Blue Chip
- Involved in design, development, implementation and user support of all the modules
- Worked on Integrated Enterprise Wide System covering modules like Sales, Purchase, Stores, Materials Planning, Production Planning, Accounts Payable and Accounts Receivable
- The entire factory related modules were developed in ORACLE Forms 4.5 - ORACLE 7 database
- Other modules like Sales, Marketing were developed in SQL Windows 5.0
- Training new programmers in SQL Windows, Forms 4.5 and Oracle stored procedures
Blue Chip Computer Consultants
Client: Confidential,
April 1994 to October 1994
Environment: 80486, SQL Windows 4.1 & 5.0 with SQL Base & SQL Server Engine
I worked in SQL Windows version 4.1, on a Health screening system for their client Beng & Ooi Screening Centre. SQL View Pte. Ltd., is a distributor for Gupta products in Singapore. They also develop applications and provide training for their clients in Gupta and other products.
- Involved in development of the various modules of the application comprising of Patient Registration, Doctors Scheduling, Patient Folder, Cash Register and Invoicing Modules
- Involved in assisting the Project Leader in design, programming, implementation and user support
- Worked in SQL Windows 5.0, for development of a Helpdesk system for their internal requirement.
Blue Chip Computer Consultants
Client: Confidential,
November 1993 to March 1994
Environment: 80486, SQL Windows 4.1 with SQL Base
I worked on Sales Analysis System. The system was meant for providing various types of MIS reports based on Oracle database. Data is down loaded from HP-9000 (running under UNIX) into an ASCII format using FTP and then uploaded into SQLBase Engine.
- I was a key member of a consulting team from Blue Chip
- Lead a team of 2 programmers
- Develop various MIS reports using SQLBase Engine data
- Provide implementation support and training to clients
Blue Chip Computer Consultants
Client: Confidential,
October 1992 to October 1993
Environment: VAX-3400, SYBASE
I worked on Materials Management System. This is a comprehensive materials system covering quotations, indenting, ordering, inventory, planning, Valuation and passing of supplier bills.
I was a key member of a consulting team from Blue Chip Lead a team of 3 programmers Involved in the design and development of new stored procedures and modified various stored procedures in Sybase database Assisted in design, programming, implementation and user support for some modules.Blue Chip Computer Consultants
Client: Confidential,
June 1992 to September 1992
Environment: 80386, PARADOX 3.5
I worked on Performance Monitoring & Evaluation System for maintaining economy performance data for Ministry of Finance, Government of Trinidad & Tobago.
- I was a key member of a consulting team from Blue Chip
- Responsible for leading a team of 2 programmers to develop this application within a tight dead line, as per design specifications developed by Price Waterhouse, Jamaica
- Responsible for Testing and certifying
- Responsible for implementation and training of user for this system at Trinidad & Tobago
Blue Chip Computer Consultants
Client: Confidential,
December 1991 to May 1992
Environment: 80386, FoxPro 2.0
I worked on Financial Accounting System. This system was designed for a specialized Financial Accounting System for RCSB, a non-profit organization sponsoring Eye camps and other Health and Rural Education Service projects in India under the parent UK organization. This system is an accounting and MIS application for monitoring project wise budget and actual expenses accounting. The system tracks the complete finances, from the time of donor receipts to disbursements and performance monitoring.
- I was a key member of a consulting team from Blue Chip
- Lead a team of 3 programmers in this project
- Involved in the design, development, implementation and user support
Blue Chip Computer Consultants
Client: Confidential,
October 1990 to November 1991
Environment: VAX-3400, VMS-COBOL
I worked on Shares and Debentures Accounting System for covering 500000 investors of the company. The application tracks investor’s holdings in the form of Shares or Debentures of the company and processes Share / Debenture Transfers and other investor data. It processes dividend and interest warrants and reconciliation of these. The system meets all statutory record keeping and returns to the government of India.
- I was a key member of a consulting team from Blue Chip
- Lead a team of 3 programmers in this project
- Involved in the design, development, implementation and user support
Blue Chip Computer Consultants
Client: Confidential,
April 1990 to September 1990
Environment: 80286, MF-COBOL
I worked on Shares Accounting System for covering 150000 investors of the company. The application tracks investor’s holdings in the form of Shares of the company and processes Share Transfers and other investor data. It processes dividend warrants and reconciliation of these. The system meets all statutory record keeping and returns to the government of India.
- I was a key member of a consulting team from Blue Chip
- Lead a team of 3 programmers in this project
- Involved in the design, development, implementation and user support
Blue Chip Computer Consultants
Client: Confidential,
January 1989 to March 1990
Environment: 80286, CLIPPER-88
I worked on Profit-Centre Performance Monitoring System. This system was developed for operations of the Wheel detergent. This is essentially on MIS system monitoring sales, production, distribution, stocks, collections of the newly introduced product-line Wheel and providing MIS reports to the profit-centre management.
- I was a key member of a consulting team from Blue Chip
- Lead a team of 2 programmers in this project
- Involved in the design, development, implementation and user support