www.sqlpass.org    Professional Association for SQL Server
 Welcome

We have meetings on the second Friday of every month starting at 11:30 MST.  Our location varies from month to month so please double check our Next Meeting notice often.

 


 

 

 

 What's Happening?

Next Meeting: Fri, Jul 12 2013

ABQSQL July Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

July meeting of ABQ SQL

When

iCal
UTC : Fri, Jul 12 2013 17:30 - 19:00
Event Time : Fri, Jul 12 2013 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Jul 12 2013 17:30 - 19:00

Where

6700 Jefferson Street
Albuquerque , New Mexico

Direction: None

Featured Presentation

Getting Solid Results Using The Fuzzy Data Controls in SSIS

Speaker: Gene Hill, DBA

Summary: You'll feel warm and fuzzy after learning how controls in SQL Server Integration Services (SSIS) can play a major role in improving the quality of your data. Using a list of medical providers as our example, we will walk through the full cycle of a process that performs historical list cleanup and detects new list members via fuzzy matching. This entails identifying string patterns in data fields, parsing them accordingly, then feeding the results through an SSIS process that employs the Fuzzy Lookup and Fuzzy Grouping controls. Subject to additional user-designed filters, a resulting similarity score is then compared to a threshold to either match new members to an existing member or create a new list entry. We will conclude the session touching on the new Data Cleansing Services (DQS) transformation bundled in SQL Server 2012.

About Gene: Gene Hill serves as data manager at LCF Research, an Albuquerque-based health services research organization whose activities include management of the New Mexico Health Information Exchange. Prior to LCF, Gene worked as a systems analyst and database consultant in financial services, merchandising and municipal government in New York City, New Mexico and Madrid. Gene holds an MA in Economics and a BBA in General Management from University of New Mexico

Attachments

Supplementary Materials

The following event attachments are available to you:

Analyst Programmer 2

UNM Medical Group, Inc. (UNMMG) is the practice plan organization for providers associated with the UNM Health Sciences Center. UNMMG is a New Mexico non-profit corporation and is an equal opportunity employer. UNMMG offers a competitive salary and an attractive benefit package which includes medical, dental, vision, and life insurance as well as tuition assistance, paid leave and 403(b) retirement match.

We are seeking dedicated and talented individuals who will work as part of the IT team responsible for the development and maintenance of revenue cycle application software at UNMMG.  Specifically involves developing and supporting professional billing applications, medical claim editing applications, and other vendor software and in-house developed applications and processes.  The successful recruits will provide primary and backup support to designated modules and processes involved in the billing, collecting, and reporting of professional medical services.

Desired skills: analytical or programming experience with business accounting or medical billing software; SQL experience; experience with QA testing; excellent attention to detail.  The successful candidate will have a strong focus on creating and maintaining superb customer relationships.  
 
BEST CONSIDERATION DATE:  JULY 24, 2014

https://ch.tbe.taleo.net/CH07/ats/careers/requisition.jsp?org=UNMMEDICALGROUP&cws=1&rid=597
This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer. 

 

From our friends at Robert Half:

 

Well respected professional services organization is seeking a SQL Database consultant to provide development support on a couple of key applications. The SQL Database consultant will assist with an upgrade to an existing billing application as well as developing a new web based application for an existing client. Day to day duties include developing database objects and structures for data storage, retrieval and reporting according to project specifications; implement and test database design and functionality, and tuning for performance; Design and develop back-end database interfaces to web and e-commerce applications.

 

The successful SQL Database consultant will have experience with MS SQL Server development. Experience with MS SQL Server, writing stored procedures and queries, ETL . Business intelligence is a plus. Must have excellent communication skills and customer service. 

Contact Willis Johnson:   

Willis.johnson@rht.com (505)888-6225

 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif