Please submit resumes to gopal@metasenseusa.com REQUIREMENT# 1
SAS 9.2 Data Integration, Data Modeling and SAS Reporting Health Care Insurer Claims Consultant, with excellent communication skills.
Duration: 3 months Plus (Extendable)
Location: Portland, OR
Rate: your best
Primary Skill Set and Job Description:
A consultant, with strong communication skills—ideally with experience working with Health Care Insurer "Claims" data (not required, though)—with exceptional Base SAS / Macro / DATA step skills,
coupled with knowledge of data modeling, and experience working with EG and various ACCESS engines (and ideally some experience with DI Studio).
The consultant must be an expert SAS programmer with extensive experience using DATA step, PROC and MACRO Language.
The consultant must know the most efficient way of analyzing tremendous volumes of data originating from any number of RDBMS systems.
Additionally, the consultant should be able to use combinations of SAS functions and Procedures in novel ways for increased performance.
The following are a list of requirements broken out by topic.
• The consultant should be able to generate RDBMS specific SQL for explicit pass-through purposes when accessing source databases.
• The consultant should have experience with householding methodology, however since this is medical claims data the householding would be to the subscriber level that is submitting the multiple claims resulting from multiple doctor/hospital visits.
• The consultant should have extensive experience with SAS MACRO for efficiency, automation, code generation and conditional processing.
• The consultant should also have experience with SAS DI Studio and EG, being able to work within both environments. (Code nodes can be used within DI Studio in situations in which that would make things more efficient.)
The consultant will need to extract data from multiple large claims data sources, pulling them together to create four (4) State Mandated extract files / reports.
The consultant will need to create initial report extractions and then put a process in place for repeatable, scheduled jobs for future reporting needs.
The consultant must have experience working with large volumes of data. (18 months of data is required for each reporting period.)
The consultant should also have experience:
1. Leveraging and utilizing SAS/ACCESS Interface to Oracle and/or other RDBMSs on UNIX.
2. Leading or assisting with activities related to project definition, requirements, design and then development / implementation. (Requirements clarification and Design and approach, led by the consultant, will take place at the beginning of the project.)
The SAS consultant will also:
A. Possess the ability to perform Services with little direct supervision as a self-starter; have a self-motivating personality and a strong work ethic; be able to document work performed; and have a customer focused demeanor
B. Have good oral and written communication skills
C. Lead and/or actively participate in limited SAS knowledge-sharing activities with customer.
*****************************************************************************************************************************
REQUIREMENT# 2
SAS DI STUDIO CONSULTANTS
Client: CASINO in LAS VEGAS
Location: 70% Work from home - 30% Onsite
Duration: 3 Months
Rate: your best
Experience / Skills Required:
* Need a "doer." Someone who takes direction well. Can take a spec and implement. "Not" looking for architect / designer.
* Needs to understand that design is complete, now we are just about knocking out the implementation tasks. Therefore, looking for someone very hand's on.
* Teradata experience (needs to understand Teradata SQL )
* Experience with the following transforms: SQL join, extract, user written node, Teradata table loader, loops
* SAS programming experience
* Previous EDW / ETL experience – including loading type 1 and type 2 tables.
* Needs to understand surrogate keys, SCD's, general ETL steps and processes.
* Experience with DI Studio v4.21.
Thanks & Regards,
Gopal
MetaSense, Inc.
NJ Minority Certified Company
100 Technology Way, Suite 320
Mt. Laurel, NJ 08054
Fax: (856) 475-0555
gopal@metasenseusa.com
www.metasenseusa.com
MetaSense Inc. is a Professional Services, Staff Augmentation, Web Design, Call Center, BPO Company with offices located in Mt. Laurel, NJ. MetaSense specializes in the delivery of cost effective, high-value Information Technology and Business Solutions since its inception in 1999.
--
Introduce business in 3800 cities. How?
=====================================================
Thanks for using group.
Moderator
1) This group is managed by www.BRCIndex.blogspot.com
2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business.
3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club)
4) Reply to two message before posting new one.
5) Donot post same message in all 3800 business Referral Club.
You received this message because you are subscribed to the Google Groups "Outsource" group.
To post to this group, send email to Outsource@googlegroups.com
To unsubscribe from this group, send email to Outsource-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Outsource