SUMMARY

• 8 years of significant experience in various phases of software development life cycle SDLC in finance, insurance, retail, pharmaceutical, and telecommunication domains.
• 8 years of experience in the IT industry with 7 years of experience as a Business Analyst in Salesforce.com Customer Relationship Management CRM process.
• Experience in Oracle E-Business Suite Oracle 11i Financials Module .
• Deep knowledge of Oracle E-Business Suite EBS and Oracle Supply Chain Applications, including GL, AP, AR, Cash, Order, Fixed Assets, CRM, Cost Management, Human Resources Management, Projects, Project Manufacturing and Manufacturing Applications.
• Extensive knowledge of Salesforce.com implementation cycle in Sales, Marketing, Service and support modules.
• Subject matter expert in SFDC Administrative tasks like creating Profiles, defining Roles, assigning Users, setting permissions, constructing Page Layouts, enabling Email Services, Approval processes, Workflow alerts and actions, generating Reports and Dashboards, Lead and Case assignment rules.
• Experience in Salesforce.com CRM integration, developing and deploying custom integration solutions. Excellent skills in creating/troubleshooting/modifying APEX code, S-Controls and Visualforce pages.
• Have vast experience in onsite/offshore working model with various clients across US and India.
• Expert in gathering business and technical requirements from both formal and informal sessions utilizing a variety of software tools like Use Cases and Rational Suite like Rational Clear Quest, Requisite Pro and Clear Case.
• Domain expertise coupled with technical expertise to perform requirements gathering, requirement analysis, project planning, use case designing and impact analysis of architectural change in as-is vs to-be product.
• Experienced in agile methodologies scrum, extreme programming as well as typical waterfall model
• Highly proficient in preparing Business Requirement documents BRD , Functional Requirement Documents FRD , User Requirement Document URD , essential in bridging the gap between Business Management and the Development Teams.
• Expert in identifying business and functional requirements creating global metrics, trend charts and other decision-making tools, leading data-modeling and process-mapping initiatives and designing/re-engineering processes, workflows and technology solutions.
• Expertise in preparing workflows, business process models and mock-up screens which can be transposed to technical requirements.
• Extensive experience in data analysis, writing data mapping documents, data transformation rules and maintaining data dictionary for business intelligence and data warehouse applications.
• Extensive Salesforce knowledge and hands on experience with solution design, workflow implementation, complex customizations, data loading, configuring and administering features available on Marketing Cloud, Sales Cloud and Service Cloud.
• Wrote complex SOQL, SOSL queries across multiple objects within the SFDC database.
• Knowledge in data migration from Traditional applications to Salesforce, data warehousing concepts and ETL processes using Data loader, ETL tools such as Informatica and reporting tools like Business Objects.
• Worked with Eclipse IDE with Force.com Plug-in environment for writing Business logic in Apex Programming Language, Target App Exchange Product and Salesforce Mobile Experience.
• Installed Salesforce Apps, configured and maintained user security permissions in compliance with organizational needs.
• Expert in migrating data from various systems into Salesforce CRM using ETL tools Informatica on Demand, Cast Iron CI experience, to synchronize data between Sales.com and web service endpoints. Data Junction Pervasive , Excel connector and DQC.
• Hands on experience in using Data loader for data management in force.com platform and good knowledge in cast Iron and Informatica.
• Worked with Salesforce.com sandbox and production environments. Expertise in developing web based GUIs using Applets, Servlets, JSP, HTML, JavaScript, CSS, and Java Swing.
• Working experience on Web Services XML, WSDL, SOAP,REST, SSI web integration with SDFC.
• Experienced in working on Oracle 9i/10g, SQL Server 2000, and SQL databases. Hands on working experience with Stored procedures, Triggers and Functions using PL/SQL and AJAX.
• Expertise in Requirements Engineering techniques like use case diagrams, activity diagrams, process flow diagrams and sequence diagrams.
• Proficient in Unified Modeling Language UML , VISIO, Object Oriented Analysis and Design techniques OOAD and version controls to include the addendums.
• Comprehensive Knowledge in reviewing Test Procedures, extensively worked with the QA Team in executing the Test Plans for UAT, providing Test Data, creating Test Cases, analyzing bugs, interacting with team members in fixing errors and also assisted in Post Production support. Worked on Black box, White box Testing and also worked with stakeholders to obtain deliverable sign-offs.
• Experience in integration testing, system testing, and GUI testing.
• Proficient in SQLs to analyze the data pattern to accommodate the various business scenarios.
• Proficient in reporting the status, metrics, risks, issues and mitigation plan to various stake holders of the project
• Single point of contact between business users, development teams and QA teams for sign-offs and finalization of requirements.

SKILLS

• CRM: Salesforce
• Salesforce: APEX, Webservices, Visual force, Triggers, Work flow rules, Webservices API, Reporing, Inbound Outbound job, Reporing, AJAX, Javascript, Dashboards, SOQL, SOSL, APP EXCHANGE
• Languages: C, C , C , CSS, MySQL, SQL, VBA, Java, VB Script, ESQL and HTML, XML
• Technologies: Snapshots, Case Management Automation, Custom Objects
• Tools: SQL Server management Studio, SQL Profiler, Performance monitor, Microsoft visual studio2005/2008, Microsoft Office Suite
• Database: Oracle 10g, SQL Server 2000/2005/2008, MS Access
• Data Modeling: UML, MS Visio
• Load Testing: LoadRunner, Test Director
• Operating Systems: Windows 95/98/2000/XP/NT/Vista, MAC OSX, UNIX/Linux
• Domain Knowledge: Life Insurance, Group Insurance Dental, Vision, EAP , E-commerce, Finance, Pharmaceuticals.

EXPERIENCE

Shelterpoint has entered into a claim servicing agreement for Group Dental with Revolv, a third party administrator. The Revolv financial feeds and reporting project involves financial transactions and reconciliation between Revolve, Shelterpoint and Chase Bank. The internal financial and performance measure reporting and end client reporting has to be supported .This project is being executed in agile methodology- scrum with shorter sprints, as the financial feeds and reporting needs keeps changing based on the type of services being sold. The TPA source data has to be mapped to Shelterpoint target data, based on the business needs.

Responsibilities

• Assuming a leadership role in the area of requirements definition and application best practices and assisting with determining project scope with project managers and sponsors.
• Gathered and documented use cases, detailed business requirements and developed process flow. Also prepared Business Requirement documents BRD , Functional Requirement Documents FRD , User Requirement Document URD , essential in bridging the gap between Business Management and the Development Teams. Conducted walkthroughs and delivered the signed - off business requirements document BRD and system specification document SSD for the financial transactions and reporting needs.
• Conducted Joint Application Development JAD sessions with stakeholders throughout SDLC.
• Moved data from SAP to SFDC using Informatica On-Demand Tool and completed data migration.
• Involved in integrating Salesforce CRM with its ERP Oracle EBS system.
• Experience with Sales cloud and service cloud.
• Customized the dashboards to monitor lead activities based on sales geography.
• Generated different reports like standard, summary and matrix for quarterly and half yearly sales.
• Worked with Apex Data loader for loading the Leads, Opportunities and their related activities into salesforce.com.
• Developed various Visualforce Pages, Apex Triggers to include extra functionality and wrote Apex Classes and Controller to provide functionality to the visual pages.
• Wrote Apex Trigger, Visualforce pages, JavaScript, Web services design development and donor databases integration for websites.
• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Worked on various AppExchange products according to the needs of the organization.
• Worked on various Salesforce.com standard objects like Case Management, Accounts, Contacts, Content, Reports and Workspaces.
• Developed and supported Extraction, Transformation and Load process ETL using Informatica.
• Communicated regularly with the SFDC designated super users to support them in their role and provide information and training on new features and functionality.
• Performed analysis on inbound/outbound file layouts and analyze sample data to identify the transformation rules with respect to the business logic.
• Analyzed the existing reports and backtracked the reports to the feeds - to identify the gaps in the data elements needed to produce customized reports for the new venture.
• Worked with QA team to design test plan and test cases for System testing and User Acceptance Testing UAT .
• Performed GAP analysis between the source and target system and proposed changes to the feed layouts to accommodate prudential data elements and the processing rules.
• Liaised with business SMEs, development team and QA teams.
• Updated System Change Request SCR forms for enhancements or change requests and implemented version controls across all impacted documents.
• Traced test cases and functional specifications to System Specification Requirements.
• Reported the status, metrics, risks, issues and mitigation plan to various stake holders of the project.

Environment:

Saleforce.com platform, Apttus, Apex Language, Visualforce Pages, Component Controllers , Salesforce.com Data Loader, Workflow Approvals, Reports, Service Cloud , Oracle 10g ,Custom Objects, Custom Tabs, Email Services, HTML, Java Script, Java, Web Services, WSDL, Sandbox, Eclipse IDE Plug-in, Oracle, Windows.

CAPS Claim Application Process System

• CAPS Claim Application Process System is VB based Client-server application that facilitates management of short term and long term disability claims and adjudicates disability claims. The application is primarily used to manage Disability and FMLA claims throughout their life cycle starting from claim intake, evaluation, management, processing disability payments and eventual claim termination. The system also supports Web based claim submission and client reporting.
• The system aims to improve and maintain uniform DB platform across multiple applications which will in turn leverage the business team to operate more efficiently with the use of single platform across applications.

Responsibilities

• Worked with multiple departments to understand complex business processes, and configure applications and systems into efficient technical solutions.
• Captured input, business rules from business users through JAD/Requirement gathering sessions and defined scope of the project.
• Created Functional Requirement Document and Software Requirement Specifications for the design solutions based on the requirement.
• Created Test case documents based on use cases for Integration testing and UAT.
• Actively involved in business process analysis for Case management, Opportunity Management, Product Management, Quote Management, and Ordering Process.
• Perform due diligence to understand the existing framework of the various applications.
• Perform analysis on the coverage of existing regression test suite to minimize the knowledge transition effort during the startup phase.
• Gathered the functional requirements and created the vision, scope, and other artifacts during the inception phase of the project.
• Designed, developed and deployed the Custom objects, Page layouts, Custom tabs, Components.
• Coordinated with vendors and legacy application team for integrating data flow with Salesforce as centralized system.
• Created Formula Fields, Validation Rules, Workflow and approvals for the flexibility and functionality of force platform application.
• Customize dashboard for various managerial view.
• Created multiple record types based on the category of clients.
• Based on the business requirements created multiple custom objects and fields created lookup fields to maintain relationship between objects .
• Worked on maintaining the functional areas of accounts, contacts, leads, campaigns, opportunities, quotes, activities, dashboards.
• Participated in business requirement definition workshops along with client SMEs and analyzed the GAP in the new product.
• Defined the business process models and milestone deliverables for the various phases of the project.
• Created workflows, screen mock-ups, use case diagrams, activity diagrams, and sequence diagrams.
• Assisted in architecture analysis and design using UML and Rational tools.
• Documented and delivered the signed - off business requirements document BRD for the commencement of coding.
• Conducted Joint Application Development JAD sessions with stakeholders throughout SDLC to resolve open issues.
• Worked with QA team to design test plan and test cases for System testing and User Acceptance Testing UAT .
• Interfaced with business users to prepare and update Business Process Requirements BPR and Software System Requirements SSR .
• Performed GAP analysis of business rules, business and system process flows and requirements.
• Documented and maintained the business rules catalogue.
• Created SQLs to analyze the data pattern to accommodate the various business scenarios.
• Liaised with business SMEs, development team and QA teams.
• Created induction manuals for training new joinees.
• Traced test cases and functional specifications to System Specification Requirements.
• Reported the status, metrics, risks, issues and mitigation plan to various stake holders of the project.

Environment:

VB, VBscript, SQL, HP Quality Center, Quicktest Pro,VBScripts, Saleforce.com platform, Apex, Visualforce, Data Loader, HTML, Java Script, Workflow Approvals, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandboxes Developer sandbox, Configuration only, Full sandbox Eclipse IDE Plug-inAdobe Acrobat 9,Crystal Reports, Windows XP, VISIO.

• Problem: The Business Management/Sales department needed a sophisticated CRM application to handle sales tasks and keep track of business development/progress.
• Solution: Developed several Visualforce pages which have the layout of user applications. Developed test classes for test coverage.

Responsibilities

• Lead design discussions with users, technical and functional stakeholders to analyze Salesforce.com functional, technical, integration and data needs and clarify, refine and document requirements.
• Primarily involved in developing prototype of the application as proof of concept POC for business team and as a guideline for development team.
• Critically evaluated information and data from multiple sources. Reconciled differences and troubleshoot issues.
• Decomposed high-level business needs into Salesforce.com requirements and explained detailed technical concepts at a high level.
• Collaborated with developers, product managers, subject matter experts and users to communicate the proposed solution vision and analyzed tradeoffs between usability and performance needs.
• Translated requirements into application and operational deliverables.
• Researched business requirements, documented user stories, test cases and collaborated with SFDC developers to estimate level of effort
• Created various Custom objects, Tabs, Workflows, Reports, Apex triggers and validation rules for the application.
• Created Email templates in Text, HTML and VisualForce necessary for the application.
• Analyzed and Created Custom Profiles as required for the business needs and implemented Object level, Field level and Record level security.
• Devised Salesforce.com solutions based on business problems. The designs included requirements documentation, graphical representations, and presentations that described the desired solution and product features. Documentation included business process flows, security access matrix, data mapping tables, integration diagrams, RACIs, application prototypes, user stories and specific, testable functional requirements.
• Used Data loader for all data adding, updating, and deleting, exporting data.
• Used Eclipse IDE for building scripts and deployment.
• Documented Sales force fundamentals and reporting for easy understanding and navigation for business users.
• Acted as a liaison between the application development team, technology teams and product managers.
• Exhibited solid understanding of project management practices, SDLC and Agile deliverables.
• Managed requirements delivery to: create and review backlog, plan sprint releases, manage releases builds and deployments, manage release expectation and communication with product management and users.
• Manage change control process to help prioritize and estimate enhancements requests. Lead user advisory board and review sprints
• Assist business Super Users with creating Salesforce reports, dashboards, email templates.
• Proven ability to lead teams, create action plans resolve obstacles to achieve deadlines.

Environment:

MS Access, UML, MS Visio 2008, Microsoft Office 2008, MS Project, Visual Studio 2008 professional, MS Expression 2008, Visual Source Safe, Salesforce.com, Apex Classes, VisualForce Pages, Data Loader, Workflow Alerts, Approvals, Validation Rules, Sharing rules, Reports, Standard Custom Objects, Tabs, Email Templates, Roles, Profiles, HTML, Force.com IDE.

Implementation of Oracle E-Business suite modules: Oracle Inventory, Order Management, Install Base, Inventory, Advanced Pricing, BOM, Service Contracts, Shipping Execution, Service Fulfillment Manager, System Administration, and integration of Oracle E-Business Suite and Salesforce CRM.

Responsibilities

• Implemented and identified improvements to the existing interfaces and processes.
• Reworked Inventory and BOM to ensure they are effectively tracked in Oracle Install Base.
• Efficiently organized test plan and scenarios for functionality testing and conducted business end-to-end manual testing.
• Granted exceptional assistance to the OM Team in conducting daily activities utilizing Service Contracts.
• Proactively facilitated the IT team in renewal and consolidation of Service Contracts data on a monthly basis to generate renewal letters.
• Functioned effectively in improving the client's order processing ability by 70 through implementing database tools, which successfully led to a Q4 revenue realization of over 22 million in Service Contracts.
• Accurately documented defects and communicated issues during daily Scrum meetings.
• Effectively resolved end-user issues and questions for Service Contracts, OM, and IB.
• Professionally conducted end-user training for Service Contracts, Order Management, and Install Base.
• Expertly granted production support across Sales Online, Oracle Order Management, Oracle Install Base, Oracle Discoverer and Custom Billing application.
• Conducted root cause analysis of issues and worked with track lead and development to provide fixes.
• Accurately created test cases and conduct unit, integration and user acceptance testing.
• Efficiently used Quality Center for bug reporting and defect tracking.
• Effectively designed and deployed business reports using Oracle Discoverer.
• Actively participated in requirement gathering from business users to integrate Salesforce and Oracle EBS.
• Effectively conducted user acceptance, unit, integration, usability, and regression testing between the Oracle application and Salesforce as well generate and grant support to SRs all the way through issue resolution.
• Ensured identification of software problems, accurately wrote easy-to-follow bug reports and log them into bug tracking database monitored the development and verified fixes.

Environment:

Oracle E-Business Suite R12, Oracle Install Base, Order Management, Shipping, Inventory, Oracle Sales Online, Oracle Discoverer, Sales Store, Oracle Incentive Compensation, Salesforce

• Project: Worked on e-commerce projects involving new content packages, site updates and enhancements for sites serving Disney's flagship family destinations, including DisneyParks.com, Disneyland.com and Aulani.com.
• Problem: Business needed to develop an M2M app to provide order-to-cash billing services, hosted in the cloud. The business also needs monitoring the data flow from SalesForce to Kenan via Workpoint. Current code had CSS/Java/iframes which were causing defects.
• Solution: Developed several VisualForce pages which have the layout of user applications. Developed test classes for test coverage. Prepared an LOE for refactoring JavaScript, CSS, and iframes.

Responsibilities

• Gathered requirements from the business and technical end to develop the mainframe and the web portal backend.
• Php pages were developed using dreamweaver and CSS for actual web development.
• Designing team was involved to develop product catalog.
• SSL certification for electronic funds transactions.
• Actively participated during the Production releases of the products and provided go-live support during Production deployments.
• Worked on script to read accounts CSV and create accounts on Force.
• Worked on integrating the ExtJS Grid for Account search results
• Developed several Triggers Before events on various Standard/Custom SalesForce objects for validating the user applications.
• Separated CSS/JS/iframes from the code and uploaded them into static resources.
• Manually tested iframe changes.
• Worked on Defect resolution.
• Implemented formulas and Validation rules.
• Implemented complex Business rules using APEX, handling triggers.
• Participate in users UI requirements meetings to edit page layouts as per business needs.
• Developed Test classes to cover and test Apex class functionality.
• Implementation of SalesForce SFDC CRM with end to end experience.
• Used Apex Data Loader 23 for inserting test data from comma separated values CSV files.
• Developed Visualforce pages to include features like Dynamic list populations and AJAX.
• Involved in deploying code to different environments.
• Conducted JAD sessions with management, SME, vendors and other stakeholders for open, pending and critical issues. Sessions focusing on IT strategies.
• Gap analysis and structured walk through of work flow with Actuaries and Underwriters to identify and fill the gap after the merger.
• Problem solving skills and building a liaison between business and technical ends of the project.
• Resolved system issues as they relate to production processing, report applications and system output.
• Researched in determining the reporting tool, and the allocation of direct access to backend tables for real-time Ad hoc Reporting and analysis.
• Played a major role in documenting functional and technical specifications.
• Assigned problems to appropriate software development team for fixes.
• Performed meetings and discussions to implement technology concepts.
• Created and managed project templates, use case project templates, requirement types and traceability relationships.
• Performed document management using Microsoft Sharepoint.
• Developing Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Designed SQL queries for Backend Testing and Report Generation accordingly based on the specifications.
• Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules Requirements, Test Plan, Test lab and Defects .
• Liaised between client and Salesforce teams to ensure work met client requirements. Communicated to Salesforce team when business requirements changed.
• Assisted project leader for project management and delivering projects.
• As a member of production support team, I have provided on-call support to all enhancements done on production servers.
• Performed Functionality, Integration, GUI, Regression, Usability and System testing.
• Performed script import and synchronized JAVA based applications with client website.
• Used Quality Center to log all the test cases/scripts and generate a daily status report.
• Performed testing and developed usage manual for Quick Test Professional QTP .
• Performed automated testing using Quality Center, Business Process Testing BPT , Quick Test Professional QTP or Winrunner.
• Tested the Applications compatibility on different browser versions of IE, Firefox and Safari.
• Used BPT in Quality Center for the login in Access Manager and Single Sign in Opal Applications.
• Involved in creating a detailed System Test Plans, Test Cases and Test Scripts for different modules in the Application according to the Business Requirement Documentation.
• Conducted meetings with the Business representatives to review products.

Environment:

PHP, ASP,.Net, WAS, SQL Server, QTP, QC, VBA, Office, Eclipse, MS Access, MS Visio, MS Office, Lotus Notes, PL/SQL,Gap Analysis, SalesForce, APEX, Visual force, Webservices, Force.com IDE, Apex Data Loader 23, JavaScript, Triggers, XML, WSDL, Webservices API, Test classes, Deployments, Agile/Scrum development, Oracle BI Discoverer.

Responsibilities

• Created Workflow Rules, Page Layouts, Approval Process, Tasks, Email Alerts, Field Updates and Outbound Messages to manage the Workflow Approvals.
• Created Profiles, Roles based on Organization role hierarchy and implemented Record-Level and Field-Level security and configured their sharing settings.
• Responsible for enabling network-based security and organization-wide list of trusted IP address.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports.
• Created the workflows for automated lead routing, lead escalation and email alerts.
• Work closely with prospects/clients to identify technical requirements and technical infrastructure for CRM based enterprise solutions.
• Worked as enhancement team member and performed the roles of Salesforce.com Administrator in the organization.
• Worked closely with sales team and business analysts and performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SalesForce.com SFDC .
• Involved in the maintenance of the previous versions of the product by addressing bugs and client issues.
• Responsibilities include defining integration architecture, documenting technical requirements, and identifying success criteria.
• Customized page layouts for Opportunity, Contacts, and Accounts depending upon user roles, and groups.
• Involved in integrating web service with SalesForce.com to load Leads back and forth from Salesforce.com to Legacy and vice versa.
• Developed and configured various Reports and Report Folders for different user profiles based on the need in the organization.
• Responsible for creating Sharing rules among all the users in Different Roles and Subordinates.
• Responsible for creating Queues, Workflows rules and tasks to share and automate work to the users in the Queue.
• Created unit test cases and coordinated change requests to drive the business requirements during Integration and Testing stages.
• Working with Operations Manager and users to determine business requirements, provide administrative support and design/implement solutions in Salesforce.com CRM.

Environment:

Saleforce.com platform, Visual Force Pages, Data Loader, Workflow Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox data loading, Windows XP.