SUMMARY

• Project platforms include Salesforce.com (SFDC), Cloud Computing/Software as a Service (SaaS), and Client - Server applications for companies in the healthcare, financial, insurance, manufacturing, education and information technology sectors
• Salesforce.com, Siebel, Oracle professional with 13+ 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 external system using Apex Data Loader, workbench in batch mode and shell scripts
• 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
• Committed to excellence, self-motivator, quick-learner, team-player, and a prudent developer with strong problem-solving, analytical skills and communication skills
• Experience in managing team members and inter-team co-ordination

TECHNICAL SKILLS

Tools: & Technologies: Salesforce.com, SFDC App Exchange Applications, Siebel (Sales, Public Sector, Service & Marketing, Finance) - Workflows, Siebel VB scripts and eScripts, EAI, EIM, Siebel Tools and configuration, Siebel Local database; Salesforce Standard /Custom Objects, Workflows & Approvals, Apex Classes/Controllers, Apex Triggers, Visualforce Pages, Data Loader, Reports, Workflow Rules, Validation, Record Type, Role Hierarchy, Page Layouts, Dashboards, Force.com IDE, and Eclipse, Sales cloud, Service Cloud, Customer Portal, Partner Portal, SQL, Mule ESB, API Integration (REST, SOAP) Apex Data Loader, SMS Magic, SSO, Lightning Components

Other Software Tools: MS Excel, MS Word, MS PowerPoint, MS Project, MS Outlook, MS SharePoint and MS Visio, Rational Clear Case, BMC Remedy, ALM, Informatica, Trello, Mulesoft, JIRA

Operating Systems: Windows 98/NT/XP/Vista/7/8, Windows CE, Linux, UNIX, IOS, Power Shell

Methodologies: SDLC, RUP, AGILE, UML, Waterfall, Iterative Agile

Databases: Oracle10G, Oracle 11i, Database.com, SQL server, DB2

PROFESSIONAL EXPERIENCE

Confidential

Salesforce Consultant, Data Architect

Responsibilities:

• System architecture, security, workflow, integration, user interface design, analytics, data integrity and customer & partner portals; Solicit business requirements after thorough analysis and change requests
• Translate business requirements into well-architected solutions that best leverage the Salesforce platform and products
• Create custom objects, fields, views, apex triggers, workflows, and complex code functions to support everyday Business processes and tasks
• Leading a data cleanup effort which includes data de-duplication, archiving, and introduction of data validation rules and page layout attribute modifications to protect data quality
• Expert in defining business solutions and the implementation of delivery methodologies
• Integration (interfacing) of enterprise software systems
• Configure process flows and business automation rules, email alerts
• Developing industry best practices governance procedures for security, sandbox management, system development, QA & testing, data integrity, and external partner integration
• Support Exact Target Communication Plans, Form Assembly data forms with Salesforce configuring connectors
• Creating a change management and release process for enhancements, UI modifications, and administration
• Skilled in understanding and implementing the new salesforce Lightning Experience.
• Analyzed the Scenarios for switching between salesforce classic and the Lightning Experience
• Used Lightning process builder for visualizing and creating automated business processes

Confidential

Salesforce Technical / Business Consultant

Responsibilities:

• Solicited business requirements and documented the Functional and Technical specification, created and maintained documentation on processes, policies, application configuration and help related materials throughout the project lifecycle
• Coordinated with clients by conducting project meetings and sessions for iterative agile business requirements analysis, conducted weekly demo session with the business to showcase the ongoing development and obtain valuable feedback
• Created custom objects, tabs - screens, fields, constraints, triggers, visual force pages, apex code, web services, workflow rules, approvals, assignment, validation rules and complex data objects; configured VFP, Page components, Apex controller and extensions
• Worked on integrating Salesforce and client external systems via Mule ESB; implemented two-way SSL authentication for SOAP based web services from Salesforce to Mule with Apex callouts
• Migrated data from legacy systems to Salesforce using Apex Data Loader
• Worked inSingle sign-on, SAML settings to enable the user to login to various applications simultaneously
• Involved in all stages from high level analysis to coding, final testing and deployment and user training
• Supported User Acceptance as well as Beta Testing for production releases and upgrades
• Conducted demo and end-user training sessions, compiled instruction and study guides emphasizing on the usage of the application, business process and everyday work items
• Configured several Business reports to help the top management understand the statistics better

Confidential, Reston - VA

Technical / Business and Data Consultant

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
• Experience in integration of Salesforce.com with external applications by usingWeb Services API,Metadata API,SOAP
• 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
• Supported User Acceptance as well as Beta Testing for production releases and upgrades

Confidential, McLean - VA

CRM Architect

Responsibilities:

• Created applications and integrated customized solutions to support business needs.
• 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 offshore technical 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.
• Prepared training 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).
• Experience working with Salesforce.com sandbox and production environments.

Confidential, Bethesda - MD

CRM Technical Architect

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, Washington DC

Sr. Developer

Responsibilities:

• Worked on configuration, security and security controls aspects, Created various custom Reports and Dashboards as per the customer requirements
• Developed Siebel IFB files for data migration and Siebel EIM
• 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 training plans, materials and documentation for CRM users, coordinate new user and ongoing training sessions.
• Involved in creating workflow rules, approvals
• Keep abreast of new application 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 Record Types, Validation Rules, Triggers and Page Layouts
• Involved in Siebel and Salesforce Application Setup activities and customized the apps to match the functional needs of the organization

Confidential

Siebel Technical Architect

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, Tempe - AZ

Team Lead/Siebel Analyst

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, Tempe - AZ

Sr. Software Engineer

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

Confidential, Tempe - AZ

Sr. Software Engineer

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.