SUMMARY

• Siebel Oracle professional with 11 years experience in 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
• Experience 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 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

Technical Skills

PROFESSIONAL EXPERIENCE

Confidential

Role CRM / 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

• 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
• 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
• 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 Hotel CRM Module HCM 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.
• Provided testing functions of unit and systems for product release and development.
• Suggested steps and measures for improvements in software solutions and systems.
• Developed customized and business solutions by usage of Visual force and Java applications.
• Assisted internal and offshore technical team staff with designing and testing practices.
• Coordinated with clients by conducting project meetings and sessions for business requirements analysis.
• 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.
• Working Knowledge 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 .
• Experience working with Salesforce.com sandbox and production environments.
• 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

Marriott International Inc. NYSE MAR 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 Salesforce.com 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.
• Designed developed and deployed Apex Classes Controller Classes and Apex Triggers for various functional needs in the application.
• Developed and configured various Reports and Report Folders for different user profiles based on the need in the organization.
• 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

Role Sr. Developer Salesforce Siebel

NLRB uses the 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.
• Find opportunities to leverage and evangelize Salesforce by working with other teams throughout the organization.
• 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.
• Worked on configuration security and security controls aspects of Salesforce
• Created various custom Reports and Dashboards as per the customer requirements.
• Worked on Record Types Validation Rules Triggers and Page Layouts.
• Involved in Salesforce Application Setup activities and customized the apps to match the functional needs of the organization.
• Integrated the SOAP and Rest based Web Services for extracting the data from external systems to display in the pages of salesforce.com.
• Provided support for ongoing Salesforce maintenance by reviewing trace logs developing action plans and other administration services including periodic data cleansing workflows and approvals.

Confidential

Role Siebel Technical Architect

FedEx provides customers and business worldwide with a brand portfolio of transportation e-commerce and business services. FedEx integrated business application through operating companies competing collectivity and managed collaboratively under the respected FedEx brand. FedEx implemented Salesforce 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

Confidential

Role Team Lead/Siebel Analyst

Freescale Semiconductor Inc. a subsidiary of Motorola Inc. has a 50-year history in microelectronics. It has 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 workflow based 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.

Confidential

Role Sr. Software Engineer

The Siebel version used by Freescale was Siebel 6.0 a client server architecture. The upgrade to the Web 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