Banner Image

All Services

Programming & Development

Reporting with analytical SQL

$8/hr Starting at $50

The Federal Deposit Insurance Corporation (FDIC) preserves and promotes public confidence in the U.S. financial system. The projects involves development of tools to, retain all failed insured depository institution records for 6 years following the date of the initiation of the receivership. Retain records for 10 years for bank fraud prosecutions that are pursued by the Department of Justice (DOJ). Satisfy obligation to reply to discovery requests involving ongoing litigation and the need to protect personally identifiable information (PII). Responsibilities: ? Assess and understand how the current system works ? Explain the business users (FDIC) importance of Data Capture and nightly process to move data. ? Implement Data Design to capture data from failed banks to FDIC data center. ? Implement Informatica Mapping, Sessions and workflows to transfer data. ? Implement Data Mining Techniques (CART, Neural Analysis) to restive and predict critical signals for bankruptcy. ? Implement Pushdown Optimization to achieve maximum performance in Informatica. ? Work with development team to create project architecture. ? Work with development team (hands on) in solving technical issues and working on resolutions for the same. ? Work with development team in development of more reusable tools with good functionality. Environment : SQL Server 2008, Rational Robot, Informatica, Business Objects

About

$8/hr Ongoing

Download Resume

The Federal Deposit Insurance Corporation (FDIC) preserves and promotes public confidence in the U.S. financial system. The projects involves development of tools to, retain all failed insured depository institution records for 6 years following the date of the initiation of the receivership. Retain records for 10 years for bank fraud prosecutions that are pursued by the Department of Justice (DOJ). Satisfy obligation to reply to discovery requests involving ongoing litigation and the need to protect personally identifiable information (PII). Responsibilities: ? Assess and understand how the current system works ? Explain the business users (FDIC) importance of Data Capture and nightly process to move data. ? Implement Data Design to capture data from failed banks to FDIC data center. ? Implement Informatica Mapping, Sessions and workflows to transfer data. ? Implement Data Mining Techniques (CART, Neural Analysis) to restive and predict critical signals for bankruptcy. ? Implement Pushdown Optimization to achieve maximum performance in Informatica. ? Work with development team to create project architecture. ? Work with development team (hands on) in solving technical issues and working on resolutions for the same. ? Work with development team in development of more reusable tools with good functionality. Environment : SQL Server 2008, Rational Robot, Informatica, Business Objects

Skills & Expertise

AnalysisBankruptcyBusiness ObjectsData MiningDesignInformaticaLitigationMicrosoft SQL ServerSQL

0 Reviews

This Freelancer has not received any feedback.