We are currently seeking a SQL / Excel Report Programmer. This is a GREAT opportunity to work in the banking industry for one of the Top 20 largest Public Companies in the World. This is a 6 month contract. The team is responsible for reporting home loan modification workout data to Fannie Mae’s proprietary system, HSSN. Top 3-5 REQUIRED skills and years of experience: - 3 - 5 years required Microsoft SQL Management Studio 2005-2008. Strong working knowledge of stored procedures, query design, data mining. - 1-3 Microsoft Office 2007 proficiency, focus on Excel reporting, Pivot tables. - Ability to work independently, collaborate with team via conference calls and live meetings. - Experience building complex reporting from multiple systems of record, research and create qc test cases to prove accuracy. Top 3-5 PREFERRED skills and years of experience: - 1-3 years Project management experience, Visio flow charts, process design. - 3-5+ Microsoft Office 2007 proficiency, focus on Excel reporting, Pivot tables. - Working knowledge of Home Mortgage servicing terminology What are the daily duties/ responsibilities with this position? Take direction from management and work independent on assigned projects. Build reporting in Microsoft SQL 2008 through use of stored procedures, scripts and views to enhance operational productivity as well as creation of executive level KPI metrics. Create mapping documents and develop QC test plans to ensure report accuracy. Soft skills needed or preferred: - Problem solve - Critical thinker - Independent worker. - Comfortable tracking down and speaking with various SME’s throughout BAC in order to resolve outstanding issues. Perform a variety of programming assignments requiring knowledge of established programming procedures and data processing requirements. Maintain and modify programs. Code, test and troubleshoot programs utilizing the appropriate hardware, database, and programming technology. Refine data and format final product. Maintain and modify programs; make approved changes by amending flow charts, develop detailed programming logic, and coding changes. Test and develop programming modifications. Write new program code using prescribed specifications. Evaluate simple interrelationships between programs such as whether a contemplated change in one part of a program would cause unwanted results in a related part. Analyze performance of programs and take action to correct deficiencies based on consultation with users and approval of supervisor. Confer with users to gain understanding of needed changes or modifications of existing programs. Resolve questions of program intent, data input, output requirements, and inclusion of internal checks and controls. Write and maintain programming documentation. Maintain confidentiality with regard to the information being processed, stored or accessed. Document programming problems and resolutions for future reference. Assist personnel of other departments as a computer resource. At this time, we are unable to engage candidates that require sponsorship. C2C is not allowed by the terms of our contract with the client. W2 only. If interested, please send a Word copy of your resume with compensation requirements to be considered for this opportunity. Modis is a global provider of information technology staffing services and the second largest in North America. As the most dynamic IT recruitment specialists in the world, Modis connects leading companies in virtually every industry with top IT professionals for both temporary and permanent assignments. With keen industry insight, tenacity and unmatched depth of expertise, Modis understands the world of IT and the people who practice it. It is this understanding that empowers Modis to help both clients and candidates make exceptional connections in today's complex world of technology. As of January 2011, Modis has joined forces with Ajilon Consulting to create a true powerhouse in the field of IT staffing, offering the most expansive talent base, branch network and global reach available in today's workforce. For additional information, please visit www.modis.com. NO 3RD PARTY RESUMES WILL BE ACCEPTED Job Number 87599