SUMMARY:

• A professional with over 14 years of experience in the technology industry.
• Strengths include sharp attention to detail, good written and verbal communication skills, as well as the ability to produce high quality products - all of which are necessary for customer satisfaction.
• Able to work as a team member and on own initiative.

TECHNICAL SKILLS:

Skill Set: SQL/TSQL, XML, XSL, HTML, VBA, JScript, ColdFusion, Visual Studio/SSRS, SSIS, SharePoint Designer, c360 Import Manager, c360 Console, MS Dynamics CRM, Access, Excel, MS Dynamics Great Plains, MS Exchange, Active Directory, SQL Server Management Studio

Platforms: Citrix Terminal Server, SQL Server 2008 R2, Windows 7, SharePoint Server 2010

PROFESSIONAL EXPERIENCE:

Confidential

Database Manager

• Management of the Dynamics CRM 4.0 AMS, including form customization, maintenance, troubleshooting, user security and creation of entities, attributes and database relationships.
• Create Dynamics CRM 4.0 field logic using JScript for auto-completion, field visibility, and data validation.
• Extensive experience with coding in SQL and VB for a variety of purposes and processes, such as SSRS and ad-hoc report design, membership and subscription dues billing, data mining and mailing list maintenance.
• Collaborate with the web manager to maintain integration between CRM and AHLA’s website, including configuring web parts and modifying .ascx files.
• Excellent documentation skills, for example, in authoring procedural documentation and in composing training material for staff.
• Provide support to staff and membership by troubleshooting technical issues, by functioning as the primary liaison to the AMS/website vendors and by serving as a member of the helpdesk team.
• Meet with stakeholders to gather requirements for projects such as the implementation of automated processes, complex report design and the streamlining of the dues billing process.
• Design or modified SSRS reports for analysis and performance indicators over time. Examples include reports that query enterprise data for membership demographics (i.e. race and gender), meeting registration types in conjunction with profits per event sessions selected, event session speakers with speaker demographics, membership enrollment and termination rates within a time range, member retention rates per member type, and education credit types earned by event registrants per selected event.
• Include features such as sub-reports, charts, single or multiple parameters, hyperlinks, and drill-down capability to provide users with robust reports.
• Maintained current Dynamics CRM street address records by utilizing SSIS monthly to import Melissa Data files and update the Address entity. Also created tables for various projects and populated those tables by running SSIS processes.
• Created c360 Import Manager templates to append or update professional development records and contact demographic records multiple times each month.
• Modified ColdFusion (CFML) code to customize professional development and membership directory web pages.

Confidential

Database Analyst

• Member of the QA team which conducts weekly meetings with the client to discuss data trends (for example, complaints, driver on-time performance and out-of-service events).
• Utilize SQL queries of transportation data & Trapeze (transportation reporting application) reports to create analytical Excel reports, charts & graphs.
• Conduct on-site auditing, for compliance reporting, at provider paratransit facility locations.
• Design quality assurance checklists for use by street & provider location inspectors to record compliance (or non-compliance) regarding provider paratransit customer service and facility safety.

Confidential

SSRS Reports & SQL Server Database Developer

• Gather reports requirements, then design and deploy reports to the MS Dynamics CRM 2011 application (Protech’s CRM4M/UX Online).
• Collaborate with, and assist web development staff by creating and modifying database objects (i.e. views, tables, functions and stored procedures).
• Provide descriptions of iMIS and CRM4M fields/attributes to illustrate mappings between the two databases.
• Assist staff with training and Author procedural documentation.

Confidential

Database Manager

• Ensure data integrity by use of SQL queries, CRM advanced finds and reports. Use these integrity-check methods to merge contact records, correct data format inconsistencies (i.e. phone number format), and remove duplicate membership renewal records.
• Collaborate with AAFCS’ member relations staff, communications staff and technical vendors to set up the aafcs.org member and non-member landing pages.
• Set up and test CRM back-office and webportal annual conference registration processes. Setup includes pricing structures, registration types, special discount packages, sessions, and online pop-ups regarding additional product details. Modify registrant reports using SSRS. Generate reports, badges, invoices and labels for registration packets.
• Modified or designed at least 30 CRM reports using Visual Studio/SSRS & SQL. Two of the reports, which list current and past member statistics, are available to state affiliate officers on the AAFCS’ webportal.
• Set up c360 import rules for mass creation of CRM contact records, import of contact demographical data, and import of education test results history.
• Provided in-house technical database support. As a result, AAFCS saved approximately $10,000 in the past year in vendor costs.
• Configured network, email, and CRM accounts.
• Assisted technical (network consulting) vendor to troubleshoot issues such as remote login problems and server unscheduled shutdowns.
• Created custom attributes and added the corresponding fields to CRM’s forms, views and the web portal (where necessary). One example is the data-gathering of contact demographics, where individuals would log in to the portal and enter biographical and career information.
• Authored CRM technical documents for staff. Some examples include certification setup, meeting registration process, product and price setup, GL account setup, roster setup and maintenance, advertising and membership invoice processes, and descriptions/purposes of various CRM reports.
• Modified CRM forms as needed. For example, added JScript logic behind selected fields to enable auto completion during data entry.
• Ran SSIS process to export event participant and professional development records to Excel. Records were provided to vendor to integrate with their event registration application.

Confidential

Data Entry Specialist

• Set up and updated patient records in the Oracle CRM database application
• Processed incoming FaxPress (virtual fax application) patient requests in preparation of data entry

Confidential

Database Manager

• Manager of the CRM (Protech Associates’ CRM for Members) legacy database. Maintained data integrity by using merge and query functions.
• Modified CRM views and forms for user-friendliness.
• Modified entities by adding and editing attributes to modify the member demographical portion of the web portal.
• Used CRM, Excel and Access functions to consolidate legacy database records for mailing lists.
• Provided technical assistance to users regarding convention (meeting) setup.
• Ran SSIS process to export event participant and professional development records to Excel. Records were provided to vendor to integrate with their event registration application.

Confidential

Database Administrator

• Experienced with the full life-cycle database implementation process. Was responsible for the migration of approximately 100,000 central database records to the CRM4M product; additional converted legacy data included financial history, meeting/exhibitions and demographical records. Sales client communication history from Goldmine was also included in the data conversion.
• Business intelligence experience included the use of SSRS/SQL queries to design and deploy reports to CRM4M menus and Excel data exports.
• Analyzed facility statistics in Excel and Access to develop standard member demographical and graphical trend reports. The primary target audience for these reports was AHCA’s CEO and management team.
• Designed and generated record-checking reports and merged duplicated records on a daily basis.
• Worked with the Director of Internet Communications with web portal development by setting up backend database structures and assisted with troubleshooting web processes.
• Authored and edited standard operating procedures for staff and executives of AHCA’s member state affiliates.
• Set up network/Exchange accounts (by use of Active Directory), distribution lists as well as CRM4M user account and security groups.
• Served as a technical support team member; AHCA’s staff consists of approximately 95 individuals. Also assisted state affiliate executives with training and finding resolutions to problems encountered with web portal processes.
• Liaison to AMS vendors.