SUMMARY

• Salesforce.com, Siebel, Oracle professional with 11 years' experiencein Analysis, Design, Development, Implementation, Upgrading, Deployment and Testing of Applications
• Experience in System Architecture, Technical Design, Implementation, Data Architecture Migration Set up data transfers between Salesforce.com and the mainframe based ERP system using Apex Data Loader, workbench in batch mode and shell scripts
• Requirement gathering and analysis, configuration, customization, implementation and data migration of Salesforce.com modules,Worked on Data Modelling and accordingly configured various Custom Objects, Tabs, Components, Workflows, Profiles and Security Settings required for the application
• User management, setting up analytics and dashboards, customizing of profiles and roles. Maintained application components such as templates, field rules, assignment rules, workflows, custom objects and reports, Developed Visual force pages, Apex codes and Triggers for requirements like Calendars, Gantt charts and other reports not normally provided by Salesforce
• Knowledge in web technologies like HTML, XML, CSS, JSP, JavaScript, WSDL, and SOAP
• Good knowledge in querying databases such as MySQL, SOQL SOSL queries using Force.com Explorer
• Strong experience and knowledge in Siebel Data Model and Architecture, Siebel Tools and Client in configuration and customization of Siebel Objects at multiple levels Significant experience in Siebel EIM developing Configuration ifb files and EIM jobs with SQL, PL/SQL and Unix
• Experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence OBIEE / Oracle Business Intelligence Apps BI Apps
• Experience with Data Flow Diagrams, data dictionary, normalization theory techniques, ER modelling, Data Warehouse concepts, RDBMS concepts and ETL
• Proficient at software quality stages such as code review, defect prevention, change management etc. at CMM Level 5
• Experience in managing team members and inter-team co-ordination, Excellent verbal and written communication skills and the ability to interact professionally with a diverse group team In-depth understanding of the software development life cycle, Excellent written and verbal communication skills

Technical Skills:

PROFESSIONAL EXPERIENCE:

Confidential -

Role: Technical / Business and Data Consultant

Fannie Mae uses the Siebel 8.x application as Registration and Account Management System for Broker-Lender registration. It contains broker, lender, account and user information and acts as an SOR for other applications.

RESPONSIBILITIES:

• Solicited business requirements after thorough analysis and managed change requests
• Created and maintained documentation on processes, policies, application configuration and help related materials throughout the project lifecycle
• Created tables, views, constraints, triggers and complex data objects like Stored Procedures, Functions, Packages Developed Materialized views, refresh groups for data replication in distributed environments, created procedures, triggers, functions and packages
• Designed and developed reports and statistical information sheets using OBIEE tool Experience in creating entity relational dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema
• Involved in all stages from high level analysis to coding, final testing and deployment
• Coordinated with clients by conducting project meetings and sessions for business requirements analysis
• Configured and customized the Applets, Views,Screens,Business Components, Business Objects though Joins, MVLs, Links and MVGs
• Extended the Siebel tables through Custom tables - columns and created User keys and Indexes
• Coordinated and implemented various Change/Work requests and enhancements
• Supported User Acceptance as well as Beta Testing for production releases and upgrades

Confidential

Role: CRM Architect Salesforce, Siebel

Develop the Confidential that provides a single platform for management of group sales and booking. This system is in design development stage that will help small to medium scale hotel chains manage end-to-end customer relationship right from the initial sales call, to booking and subsequent invoicing.

RESPONSIBILITIES:

• Created applications and integrated customized solutions to support business needs
• Experience working with customers in a collaborative development environment
• Provided testing functions of unit and systems for product release and development.
• Developed customized and business solutions by usage of Visual force and Java applications
• Assisted internal and offshoretechnical team staff with designing and testing practices.
• Prepared reports and expense records and updated time tracking systems on timely basis.
• Evaluated technical decisions and deliverables for compliance and quality analysis.
• Designed, developed and deployed the Custom objects, Page layouts, Custom tabs, Components, Visual Force Pages, Apex classes Triggers to suit to the needs of the application.
• Preparedtraining material for marketing on Sales Cloud, Service Cloud, Custom Cloud and Apex Programming on Force.com Platform
• Extensive experience in lead case management Web-to-Lead, Email-to-Case .
• Worked with Visual force Pages, Custom Controllers, Extension Controllers, Apex Coding, Apex Batches, Apex Web Services, App Exchange deployment, Apex Classes and Apex Triggers

Confidential

Role: CRM Technical Architect

Confidential is a worldwide operator and franchisor of a broad portfolio of hotels and related lodging facilities. It uses Owner Account Strategic Information System OASIS to give business owner account information on the hotel properties. Ritz-Carlton is a subsidiary of Marriott. Its Mystique application helps in capturing and report generation of Guest Profile, Stay Information for better customer service.

RESPONSIBILITIES:

• Developed sales and marketing apps on Salesforce.com platform using CRM Process.
• Involved in Application Setup activities and customized the apps to match the functional needs of the organization.
• Interacted with various business team members to gather the requirements and documented the requirements
• Designed and developed SFA based Application on Force.com Platform in Salesforce.com environment with Apex programming language at backend and Visual-Force pages as user interface.
• Used Sales Force Automation SFA for Sales Lead Management, Account and Contact Management and Approvals and Workflow.
• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Worked with various salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports and Dashboards.
• Developed various Custom Objects, Tabs, Entity-Relationship data model, validation rules on the objects and tabs, Components and Visual Force Pages.
• Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Created workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.
• Developed Custom Objects, Custom Reports and configured the Analytic Snapshots to dump the data on regular basis for the sales performance and lead generation statistics.
• Used the sandbox for testing and migrated the code to the deployment instance after testing.

Confidential

Confidential uses the Siebel-Salesforce application as an enterprise system NxGen that contains case information, events and related documents. Comprehensive and customized, NxGen improves collaboration on cases by various branches of the Agency, in particular Regional and Headquarter Offices.

RESPONSIBILITIES:

• Worked on configuration, security and security controls aspects of Salesforce
• Created various custom Reports and Dashboards as per the customer requirements.
• Daily administration and support, including, but not limited to, user setup, profiles and roles, custom object and field creation, page layouts, record types, workflows and validations
• Working with management, strategic planning analysis staff and end-users to create and manage complex workflow rules, data validation, and triggers.
• Develop reports, dashboards, and processes to continuously monitor data quality and integrity.
• Develop training plans, materials and documentation for CRM users, coordinate new user and ongoing training sessions.
• Involved in creating a workflow rules to monitor user adoption rates and respond as needed.
• Keep abreast of new Salesforce features and functionality and provide recommendations for process improvements.
• Create and maintain documentation on processes, policies, application configuration and help related materials for users as database applications are developed.
• Provided support for ongoing Salesforce maintenance by reviewing trace logs, developing action plans and other administration services including periodic data cleansing, workflows and approvals.

Role: Siebel Technical Architect

and related lodging facilities. Marriott implemented Siebel in order to handle web based application enables small business to manage customer: tracking sales, collaborate instantly company wide, increase efficiency. The siebel solution provides ease of use, convenience and simplicity.

RESPONSIBILITIES:

• Solicited the business requirements and implemented Opportunity, Account, Contact and Activity management modules in SFA.
• Involved in all stages from high level analysis to coding, final testing and deployment
• Implemented best EIM practices in mapping Siebel data with external data worked with data import/export/delete along with integration of legacy systems, wrote complex SQL queries, configured and optimized config IFB files to run EIM jobs.
• Built custom Business services,Siebel EAI, integration objects, Data Mapper,XML converter, external COM and DCOM for Opportunity and Billing credit reservation system in SFA.
• Integrated Siebel through IBM MQ series middleware using integration objects and XML
• Configured and customized the Applets, Views,Screens,Business Components, Business Objects though Joins, MVLs, Links and MVGs
• Configured Picklists Static and Dynamic , LOVs,Toggles and Drilldowns
• Extended the Siebel tables through Custom tables - columns and created User keys and Indexes.
• Implemented the Declarative Config Alternatives using Data Validations, User Properties, Workflows and Run-Time events, customized the application using Siebel VBScript and eScript for functionality extension.
• Designed and built Actuate and Access Reports.
• Built various UNIX shell scripts for implementing reports to send out SFA data to business users.
• Co-ordinated and implemented various Change/Work requests and enhancements

Role: Team Lead/Siebel Analyst

• design, manufacturing and sales operations in more than 25 countries. It used the Product and Sales - Marketing Model in its CRM implementation. The entire Business Opportunity Life cycle with various stages was controlled through Workflow based architecture. The Miller Hieman TAS Target Account Selling model was integrated with Siebel using EAI for better sales control and visibility for future decision making.
• Campaigns and responses to the Campaigns were managed Service Requests and Activities for Service Requests were handled and closed to completion in Siebel. It employed workflowbased automated data cleansing and flow of shipment of semiconductor Products for the entire process. It also interacted with various interfaces in different areas for transferring the data.

RESPONSIBILITIES:

• Managed and lead a development team that handled day to day change requests / business needs involved in direct interaction with customers/end users for requirements
• Provided assistance to the project management and QA teams on effort estimation, schedule planning, creating project plans, high-end analysis, milestone reports, test cases performed interfacing role with various client-site groups, other development groups, Business groups and end-users
• Followed CMM Level 5 activities during the project execution
• Practiced SLA rules with end-users and client to ensure minimal turnaround time
• Co-ordinated efficient Onsite-Offshore tech development teams, its interaction and communication
• Managed Code Review and Code Optimization processes for various developmental units
• Participated as a key member in designing, developing and integrating Third Party Model Miller Hieman TAS using Siebel EAI with workflow adapters, transport scripts, integration objects and XML
• Involved in Admin activities of successfully migrating the repository from development to testing and then to Production environment
• Built scalable solutions for many interfaces exchanging data with SAP, Mainframes and other legacy systems using Siebel EIM and EAI practices.

Role: Sr. Software Engineer

architecture Siebel 7.7 was the main highlight of the year. Transformation of heavy customization of the current Siebel 6 Business process logic was framed to the Siebel 7 Data Model. Interface modifications using Siebel EIM was executed to map to the new Siebel 7x Party Model. New workflow concepts with demanding requirements were incorporated.After the successful Upgrade to Siebel 7.7 the Global Interactive Blue Chip GIBC project based on Opportunity and Lead Management where customized logic for handling margin and bonus, maintaining Competitor data and several other enhancements was implemented.

RESPONSIBILITIES:

• Implemented the Siebel 6 to Siebel 7 Upgrade project and the GIBC project performed high-level analysis effective design solutions, methods and gathered detailed business requirements
• Designed and executed the integration of legacy applications so as to decommission certain legacy functionality
• Redesigned entities like Opportunity, Service Requests, Activity, Product and Campaigns
• Involved in writing complex SQL queries, stored procedures and Shell scripts for Data Extraction and Migration and wrote Siebel EIM files and batch jobs
• Built various interface implementations developed externally managed VBCOM Interfaces out of box functionality actively involved in inter-team co-ordination and technical discussions
• Successfully executed various pre and post Upgrade tasks involving Siebel concepts like EAI, Workflows, Workflow policies/triggers
• Prepared excellent technical specifications and test case documents / results
• Provided post production support for the application and addressed the issues/defects
• Utilized VSS and CVS for managing software configuration and tracking of documents

Role: Sr. Software Engineer

Confidential has long been recognized as a leader in the auto and home radio, television, commercial communication equipment, and military electronics industries. The Siebel 6.0 Sales and Marketing app of the Motorola Products had the Siebel Opportunity, Product, and Activity entity. Later, a scratch development and prototyping in Siebel 7.5 was successfully implemented for an initial step towards the upgrade of Siebel 6 to Siebel 7.7.

RESPONSIBILITIES:

• Developed and designed several PL/SQL Stored procedures to integrate outside systems within Siebel Data Framework Optimized complex queries and stored procedures so as to reduce the network traffic between database server and the Application server
• Prototyped modules in Siebel 7.5 on Oracle 8i, like Product management, Opportunity, Activity, CTI, Campaigns, Responses
• Designed the UML diagrams for the system requirements
• Participated in software processes like Code Review and Defect Prevention
• Prepared detailed design and technical documents for various components of the Siebel 7.5 application
• Configured and customized the Applets, Views,Screens,Business Components, Business Objects though Joins, MVLs, Links and MVGs and custom configuration through Siebel VBScripts
• Worked with the project manager/lead in tandem with other team-members.

Role: Intern

RESPONSIBILITIES:

• Researched and designed the entire architecture combining the features of Gnutella and Napster to develop a new file sharing protocol Directly responsible for code generation, review and testing
• Programmed various modules/entities for the project Participated in the demo at the end of the assignment
• Documented the project specification and code, pseudo-code