Sr. Qa Analyst - Salesforce Resume
Experience Summary
- Over Seven years of IT experience in various stages of Software Development Life Cycle (SDLC) including analysis, requirement engineering, development, enhancements, testing, and maintenance of Multi-tier, web-based, and portal based object oriented enterprise applications.
- Certified Salesforce.com Developer and Administrator with 4 years’ experience in Administration, Configuration and Customization, Requirements/Business Analysis, Implementation, Data Migration and Support of Salesforce CRM.
- Experience in developing Validation Rules, Work Flows and Approval Processes for new Tasks, field updates, and Email generation according to application requirements.
- Implemented security and sharing rules for different users at different levels of organization.
- Experienced in Data Migration using Apex Data Loader, and Third Party ETL tools like MS-SSIS, Informatica.
- Created page layouts, search layouts to organize fields, custom links, related lists and VF Pages on a record detail and edit page.
- Experienced in training and mentoring team members with product knowledge and business processes.
- Strong work ethic, taking ownership of all duties and responsibilities and meeting management objectives.
- Conduct Release Management tasks required to promote tested functionality from sandbox into a production environment
- Creativity and flexibility to face and resolve challenges, Good presentation skills and effective team player with excellent communication skills.
Education / Certification
- Bachelor of Science (Computer Science)
- Master of Foreign Trade
- Salesforce.com Certified
Technical Skills
SalesForce.com:
Triggers, Custom Objects, Data migration, Record Types, Workflows, Email Templates, Visualforce, Apex, Data loader, SOQL, SOSL, Force.com Excel connector, Desktop Integration, Chatter
Operating Systems:
Windows 9x/2000, Win-XP, Windows Vista, Windows 7
Languages and Scripts:
JAVA , JavaScript, VBScript, HTML, XML, CSS
Tools and Utilities:
- SSIS, Bugzilla 3.2.3, Tortoise SVN, MS Excel, HP-Quality Center
Database:
SQL Server 2005, Oracle, MS Access, Peoplesoft
Professional Experience
Confidential,MN January 2012 – Present
Sr. QA Analyst - Salesforce
Project description: Confidential,is the Salesforce instance of Thomson Reuters Legal, the strategic business unit . This project involves migrating existing Siebel CRM Legal instance to SFDC. The new SFDC Core Legal integrates with various external systems like Siebel and SAP.
Responsibilities:
- Creating Requirements document, Test plan and Test strategies.
- Creating Test Scripts based on the Business Requirements Specification documents in HP Quality Center.
- Interact with various Business Analysts and Developers to design better test plan and strategies based on the requirements of the business.
- Executing Test Cases in QC and logging defects.
- Prepare documentations like Testing Progress, Test coverage and providing status to Project Manager.
- Recommend some enhancement features to the system.
- Helping the Business team in carrying out the User Acceptance Testing.
Environment: Force.com, Apex Data Loader, HP – Quality Center 11.0, SAP, Siebel, SQL Server 2005, SOQL, SOSL, MS Office 2007, Windows XP.
Confidential,Optum Insight, MN August 2011 – December 2011
SalesForce - Data Analytics Consultant
Project description: Confidential,part of United Health Group, provides various technology services, analytics, business services and consulting for the health industry. One of the acquisitions of Optum Insight is CareMedic, an Industry leader in Revenue Cycle Management. This project involved moving all service cloud customizations and data of CareMedic into Optum Insight Salesforce instance.
Responsibilities:
- Migration of Service Cloud data into Optum Insight SalesForce using Data Loader.
- Created data migration check list and field mapping document.
- Daily extract of Optum Insight data into SQL Server database.
- Create new SSIS packages to ETL data from Salesforce to SQL Server and vice versa.
- Migrate monthly contract renewal and related objects from legacy Onyx system to Optum Insight SF, using SSIS.
- Eliminate and merge duplicate Accounts and Contacts in legacy Onyx and SalesForce.
- Involved in various user stories and worked with QA team to test in various sandbox environments and update fields in Production.
- Periodic data load into various Configuration only and Developer Sandboxes after refreshes, using SSIS.
Environment: Force.com, Apex Data Loader, Eclipse IDE, SQL Server 2005, MS-SSIS, SOQL, SOSL, MS Office 2003 & 2010, Windows XP.
Confidential,DC (Wipro Technologies) April 2011 – July 2011
Salesforce Consultant
Project description: Confidential,develops software applications and related services that are used by over 2000 education institutions in more than 60 countries. One of the major acquisitions of Blackboard was Wimba Elluminate, another market leader in software services for Education institutions and renamed Blackboard Collaborate. This migration project involves moving all the Salesforce customizations and data of Blackboard Collaborate into the main Salesforce instance of Blackboard.
Responsibilities:
- Gathered business process requirements and utilize Salesforce functionality to automate and achieve those objectives.
- Created Field mapping document for various objects like Accounts, Contacts, Tasks, Opportunity, and Lead.
- Worked on objects like Territory management, Forecasting, Multi currency, Assets and Opportunities.
- Eliminate duplicate Accounts after merging parent and child organization data, using fuzzy match.
- Create Profiles and Role hierarchy of Child org in Parent org.
- Used Dreamfactory SnapShot and Monarch for Metadata and Data migration.
- Migrate Child org customizations like Custom objects, Custom Tabs, Record Types and Page Layouts to Parent org using Eclipse IDE.
- Migrated Custom fields, Public Groups, Custom Settings using Packages.
- Migrate Child org Reports, Report types, Dashboards, Email templates to Parent org using Eclipse IDE.
- Migrated Child org data like Accounts, Contacts, Activities to Parent org using Apex Data loader.
- Customized user Roles, Role hierarchies, Profiles and Sharing settings to ensure that the protected data is available only to the authorized users of the respective organization.
- Used Chatter, Chatter desktop, and Chatter Mobile extensively for file sharing and Ideas sharing.
- Migrated Custom Links and Buttons that were used for various business needs.
- Deployed Components and Data from one environment to another using change sets.
- Used third party Apps like Eloqua, Dreamfactory SnapShot , Search first before create, Country complete, Riptide Pop-Up alert, Xactium ERD Tool, Field trip, Hoopla Countdown etc.
Environment: Force.com, Apex Data Loader, Eclipse IDE, Dreamfactory SnapShot and Monarch, SOQL, SOSL, PeopleSoft 8.21, Chatter, Eloqua, MS Office 2007, Windows 7.
Confidential,CA February 2011 – January 2012
Salesforce Consultant (Telecommute)
Project description: Confidential,the private career college has 11 campuses in the western United States. With Salesforce Enterprise Edition and applications from salesforce.com’s AppExchange marketplace, Heald College automated admissions report generation from initial inquiry to enrollment, resulting in significant time savings and higher enrollments.
Responsibilities:
- Gathered business process requirements and utilize Salesforce functionality to automate and achieve those objectives
- Provided support as a Salesforce.com administrator to 200+ users.
- Designed, and deployed the Custom objects, Custom tabs, validation rules, Workflow Rules, Auto-Response Rules, Page layouts, to suit to the needs of the application.
- Customized user Roles, Role hierarchies, Profiles and Sharing settings to ensure that the protected data is available only to the authorized users.
- Maintained data cleanliness and accuracy by adding custom validation rules, custom formulas
- Implemented Chatter, Chatter desktop, created public and private groups.
- Created and deployed several Custom Reports using salesforce.com platform.
- Created VisualForce email templates (HTML and custom), New Templates, Mail Merges and also automated Email Process to send installation instructions to new and existing customers.
- Created Custom Links and Buttons for various business needs.
- Created VisualForce page for entering the HS Lead Upload in Salesforce, gathered from High school presentation and Event leads.
- Provide Salesforce best practices and customizations with regard to SDLC
- Configured workflows and approval processes to enhance business logic.
- Created new sandboxes and deployed Components and Data from one environment to another and Managed sandbox refreshes and release testing.
- Analyze Salesforce system usage and data storage patterns to improve efficiency
Environment: Saleforce.com platform, Visual Force (Pages, Component & Controllers), Data Loader, HTML, Java Script, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox, Oracle BPEL Process, PeopleSoft 8.21, Windows 7.
Confidential,CT July 2009 – Feb 2011
Salesforce Administrator
Project description: Confidential, is a leading software solutions provider marketing various software products for industries like Healthcare, Transportation and Finance. Salesforce application was implemented to keep track of all the clients and day to day business transactions which helped in improving productivity, maintaining valid data and helped sales team to achieve their goals in a timely manner.
- Responsibilities:
- Gathered business process requirements and utilize Salesforce functionality to automate and achieve those objectives
- Provided support as a Salesforce.com administrator to 150+ users.
- Customized user Roles, Role hierarchies, Profiles and Sharing settings to ensure that the protected data is available only to the authorized users.
- Designed, and deployed the Custom objects, Custom tabs, validation rules, Workflow Rules, Auto-Response Rules, Page layouts, to suit to the needs of the application.
- Involved in migrating data from Oracle to Salesforce.com using Data loader.
- Created Visualforce email templates (HTML and custom), New Templates, Mail Merges and also automated Email Process to send installation instructions to new and existing customers.
- Created/Modified Visualforce pages and Apex Custom Controllers on Force.com IDE to customize the view and functionality of the page according to organizational needs.
- Configured workflows and approval processes to enhance business logic.
- Created new sandboxes and deployed Components and Data from one environment to another and Managed sandbox refreshes and release testing.
- Analyze Salesforce system usage and data storage patterns to improve efficiency
Environment: Saleforce.com platform, Apex Language, Data Loader, HTML, Java Script, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox, Data Loader, Oracle, Windows XP.
Confidential,TX Oct 2008 – June 2009
Salesforce Consultant
Project description: Confidential,An Electronic Medical Record (EMR) system manages data about the patient, their visit, and treatments performed. It is typically used as a replacement for a paper patient chart, but often provides much more functionality such as eprescribing and clinical decision support.
- Responsibilities:
- Set up and integrate Salesforce.com for company with divisions in 3 Locations and provide routine maintenance
- Research, integrate, test and train on AppExchange modules to meet the needs of management
- Gather detailed requirements by performing document analysis, conference calls, business process descriptions, and use cases to customize Salesforce.com and integrate new applications to meet the needs of end users
- Build custom reports and apply to custom manager dashboards based on specific needs to continuously monitor data quality and integrity.
- Efficiently and effectively work on projects for Salesforce.com, providing timely, detailed solutions, helping to streamline business processes
- Support end-users to encourage effective use of all CRM systems
Environment: Salesforce.com platform, Data Loader, Workflow & Approvals, Custom Reports, Dashboards, MS Access, Windows XP.
Confidential,Austin, TX Aug 2007 – Sep 2008
Salesforce Consultant
Project description: Confidential,is an intelligent transaction processing engine that manages and protects payment card transactions across a variety of enterprise applications such as SAP, legacy CRM systems, call centers and web stores. XiPay, Paymetric\'s sell-side solution, seamlessly integrates payment card transactions across the supplier\'s enterprise and optimizes transaction processing with financial institutions.
- Responsibilities:
- Implementation and system administration of Salesforce.com and provide routine maintenance
- Analyze clients’ current software to determine appropriate strategy and timeline for transfer to Salesforce.com platform
- Design, customization and implementation of Salesforce.com solutions
- Setup and installation of compliance and client service tools (internal database and Salesforce.com)
- Manage data migrations/conversions from other data sources into Salesforce
- Create usage tutorials and end user training materials for all internal users
Environment: Salesforce.com platform, Data Loader, Workflow & Approvals, Custom Reports, Dashboards, Windows XP.
- Confidential,Austin, Texas April 2006 – June 2007
Team Lead - Quality Assurance
- Project description: Confidential,is a desktop visual modeling environment used by business analysts and architects across the enterprise to create models and analytic tools that promote the communication and analysis of the most complex aspects of the enterprise. Troux Architect represent organizations, processes, information, technologies and their interrelationships as they exist today, as well as communicate how they will be transformed in the future.
Troux Metaverse manages information through object-based architecture that file-based storage systems were not designed to handle and it includes the Troux repository and more-sophisticated capabilities for managing and communicating information.
Responsibilities:
- Create, review and execute Smoke, Integration and Regression test cases using QTP.
- Involved in the system integration and validation portions of the system/product development life cycle.
- Involved in Retest and Regression Testing, Performing UI Testing and Functionality Testing.
- Attend daily Scrum meetings and staff meeting, discussing with QA Manager about bugs, which are promoted in the release. Finding bugs, and reporting bugs through Bugzilla.
- Leading a team of 5 members and assigning tasks under Agile Scrum methodology.
- Environment: QTP, J2SDK 5.0, HTML, C++, JavaScript, JSP, EJB2.0, Oracle 10, SQL Server, XML
Confidential, Feb 2005 – March 2006
Test Engineer
- Project description: This product developed for Confidential,, maintains the complete accounting and billing transactions of a business. It involves the Masters, Transactions and Report Modules. This product helps the concern to manage the purchase, sales and stock of goods. It also has other features like Inventory alerts, pending bills alert, and stock transfer etc. This system has been designed to be stable and upgradeable for any retail business. Also this product can be linked with other existing accounting software.
- Responsibilities:
- Developing test plans, distinct test cases and execution of Test cases.
- Performing UI Testing and Functionality Testing.
- Documented test cases, test results, test procedure and reported to client.
- Coordinated with development team for Bug fixing.
- Actively involved in review meetings.
- Comprehensive application testing for various sales order entry modules.
- Environment: Visual Basic 6.0, Sql Server.
- Confidential,India April 2004 – Dec 2004
- Test Engineer
- Project description: Confidential,is a website developed for M/s Suncabs, Coimbatore. Suncabs is a well-established travel agent in Coimbatore, India. This site provides various services like online tour booking, Buying and Selling Vehicles.
- Responsibilities:
- Developed and executed Test cases and logging defects.
- Created Test Scripts analyzed the user/business requirements. Functional specs, Use Case documents and created the Test cases for System testing.
- Involved in system integration & validation portions of the system/product development life cycle.
- Attend weekly status meetings and staff meeting discussing with developers and business analysts about bugs, finding the bugs, filing the bugs, coordinating with developers in fixing the bugs.
- Environment: Java 2, JSP, HTML, MS-SQL Server
Confidential,California Aug 2003 – Feb 2004
- Test Engineer
- Project description: Confidential,is a B2C portal developed for M/s. DeTour Consultancy Inc., California. Various products and services that can be bought and sold through this portal are Automobiles, Computers/Peripherals, Real Estates, Apartments, Business opportunities, Jobs/Services, Garages, Pets/animal, Friends/Dating and announcements. Anyone who wants to sell his product/service can place the product features on this Portal and whoever need that product may purchase that by contacting the advertiser.
- Responsibilities:
- Detailed study of the Software Requirement Specification Study.
- Understanding the functionality and preparing the test cases based on it. Developed and executed Test cases and logging defects.
- Created Test cases for System testing and analyzed the user/business requirements. Involved in the system integration and validation portions of the system/product development life cycle.
- Conducting the regression testing and database testing.
- Responsible for Bug tracking and reporting.
- Attend weekly status meetings and staff meeting discussing with developers and business analysts about bugsfinding the bugs, filing the bugs, coordinating with developers in fixing the bugs.
Environment: JDK 1.3, HTML, JavaScript, JSP, Oracle