We provide IT Staff Augmentation Services!

Sr Qa Analyst Resume

4.00/5 (Submit Your Rating)

MN

Summary

  • Over Seven years of IT experience in all phases of the development life cycle from requirement gathering and analysis to design, development, testing, implementation and support.
  • Certified Salesforce.com Developer and Administrator with 4 years’ experience in Requirements gathering and Creating Custom Objects, Tabs, Custom Apps, Territory Management, Workflows, Approval processes, Validation Rules, Page Layouts, Data Mapping, Cleansing, Data Export and Imports, Application Support, Performance Tuning, Security Administration, Maintenance, and User Security Management, Creating Reports, Dashboards, Apex Triggers, Apex classes, Visual Force Pages, Data migration, SOQL, SOSL Queries.
  • Experienced in building standard report templates, ad-hoc reports, data validation, and issue research/resolution. Strong analytical, reporting, Excel, and database skills, extensive knowledge of CRM software (experience administering and configuring Salesforce.com application).
  • Integration, Developing and deploying custom integration solutions using Force.com Eclipse IDE Plug-in, Force.com Explorer, Data Loader, Force.com Excel Connector, Migration Tool.
  • Conduct Release Management tasks required to promote tested functionality from different sandboxes into production environment.
  • Enthusiastic and adapt to new technologies with Strong technical, Analytical and problem solving skills. Excellent organizational, interpersonal and communication skill. Effortlessly establish and manage constructive and professional relationships with business partners, vendors, customers, and cross-functional teams.
  • Flexible to project demands and shifting priorities. Thrive in unfamiliar situations and enjoys opportunities to learn and gain exposure to new ideas and experiences. Open and willing to learn whatever is necessary to accomplish the goal.

Education / Certification

  • Bachelor of Science (Computer Science)

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: SFDC Core Legal is the Salesforce instance of Thomson Reuters Legal, the strategic business unit ofThe Thomson Corporation,that specializes in furnishing information and office solutions tolawyersand other legal professionals in theUnited StatesandCanada. This project involves migrating existing Siebel CRM Legal instance to SFDC. The new SFDC Core Legal integrates with various external systems like Siebel, Informatica 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 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: Optum Insight, 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, April 2011 – July 2011
Salesforce Consultant

Project description: Blackboard Inc. 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: Heald College, 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: PCCTG 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: Electronic medical records 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, Workflow & Approvals, Custom Reports, Dashboards, MS Access, Windows XP.

We'd love your feedback!