SKILLS:

• Able to design, test, and implement workflows on Salesforce.com’s Service Cloud, and import and export data using Apex Data Loader and Informatica Cloud
• Experience in SQL (including DDL and DML), C++, VBA 6.0, SQL Server 2000, SQL Server 2005, Oracle 10g, Oracle 11g, and SQL Loader
• Highly experienced in Microsoft Word, Excel, and Access
• Analytical problem solver
• Detail - oriented with consistent follow-through
• Great communication
• Great organization
• Excellent time and task management
• Strong customer service

EXPERIENCE:

Salesforce Administrator, Gaithersburg, MD

Confidential

Responsibilities:

• Translate business requirements into configuration in Salesforce.
• Develop, research, and test Salesforce change requests. This includes creating and maintaining workflows, approval processes, validation rules, and email alerts, and working with the implementation vendors as necessary.
• Troubleshoot Salesforce questions and issues, leveraging the Salesforce Success Community and Premier + Support as necessary.
• Manage the Change Control process for all Salesforce changes with Confidential & Confidential, including scheduling changes, testing and validation with the business, and preparing Change Control documentation. Created the Change Control process in partnership with Confidential & Confidential .
• Manage Salesforce sandboxes by performing refreshes, managing users, using change sets to move configuration, and creating and deleting sandboxes as needed.
• Create and maintain user security (roles, profiles, and permission sets).
• Create and maintain custom objects and fields, handle bulk data migration using Data Loader and/or Informatica Cloud, and maintain page layouts.
• Determine the impact to Confidential for each Salesforce upgrade from release notes and preliminary testing, and sharing the changes with the business reps; test and validate changes and perform regression testing to determine the impact to the system; coordinate with business reps as needed; create release notes for the end users; and create Change Control documentation.
• Successfully implemented a new team onto the Service Cloud in January, 2017. This required utilizing workflows, case assignment rules, process builder, creating a new case action, creating new list views, creating new custom fields, and updating page layouts after working with the business to determine requirements.
• Worked with the appropriate business areas and implementation vendor in order to successfully launch an HR employee portal and HR knowledge base using Salesforce Knowledge, Service Cloud and Communities in February and March, 2016. This required working with the business areas to validate requirements and successfully test the product after each agile sprint.
• Designed the requirements, worked with IT to develop, and tested the automated process for automated user provisioning for Confidential 's entire US population (125,000+ employees).
• Worked on creating the user activation, deactivation, and update process with Audit and Compliance, HRMS Information Security, and multiple business areas for users requiring access to the Service Console.
• Worked with the appropriate business areas and implementation vendor in order to successfully launch the Service Cloud with 169 agents in September and October of 2014.

Confidential, Gaithersburg, MD

Responsibilities:

• Assisted in decisions around portal groups and portal security for the new HR portal which leveraged Salesforce Communities.
• Worked with the business to define and recommend requirements to populate the account and contact objects within Salesforce for the launch of the Service Cloud.
• Conducted system integration testing into the account and contact objects within Salesforce using Data Loader and Informatica Cloud.
• Generated reports for Confidential in order to assist with reorganization, portal requirements, and portal groups. This required prioritizing as many as eight report requests at one time from individuals within the Confidential team.

Sr. HRIS Analyst, Gaithersburg, MD

Confidential

Responsibilities:

• Managed 58 interfaces between Confidential ’s Enterprise Data Warehouse (EDW) and external and internal vendors. Gather requirements, create logic, test new interfaces, and test changes to interfaces after development and troubleshoot issues as they arise. Manage the process by working with the business and developer so that the interface moves to production on time. Prioritize the development as necessary. 9 of these interfaces were for highly visible international projects that were completed successfully on time.
• Worked with business owners, data architects and ETL team to develop new star schemas and modify existing data models. Test new development and changes.
• Gathered requirements and created three reports using SQL Server 2005 to process 60 million rows of data. These reports were used by a third party to analyze possible reductions in worker’s compensation claims. The resulting analysis led to a possible savings of $17 million for Confidential .

HRIS/Benefits Analyst, Fairfax, VA

Confidential

Responsibilities:

• Rewrote the electronic file in SQL for all enrollees in the Tricare supplement, a medical benefit for the members of the US military.
• Resolved issues with Time & Expense & Employee Self Service ( Confidential ) and Costpoint including thorough and systematic validation of solutions in a test instance before they were applied to the production instance.