IT Systems Analyst Lead - Expert SQL Stored Procedure developer with moderate experience in development of .Net web applications
*Technical developer with excellent skills and experience developing
SQL SP*s against SQLServer 2005 database
*Re-engineer all Management Accounting SP*s and MS Access processes from an Oracle to SQLServer 2005 environment
*Primary developer for development & maintenance oflimited .Net web front end UI to allow Financial MA analysis to select or input parameters as required for calculations and processing related to Funds Transfer Pricing, Capital/Expected Loss, Cost allocations and Data attribution to determine account level profitability based on market indicators and portfolio risk factors, etc.
*ETL from flat files created from mainframe applications to SQLServer
*ETL historical information from Oracle to SQLServer( 1 time effort)
*Participate in data analysis for data integrity of data loaded to our EBDW
to facilitate the eventual development of LOB DataMarts to satisfy the long term Financial MA reporting needs.
*Eventually ETL procedures will be converted to extract and transform data from our Enterprise Bank Data Warehouse using Informatica tools.
*Longer term opportunity to develop BI Microstrategy skills for LOB reporting and elaborate dashboards from LOB DataMarts created from our EBDW. Anticipate training for these skills in the 2010 and beyond timeframe.
*Interaction with other IT Services technical resources responsible for Database Services and support for core applications on the mainframe
*Collaborate with business and technical SME's to understand Market Risk Exposures, Credit and Operational Risk, and Economic Capital Models used to simulate and measure portfolio risk and allocation of capital as appropriate to mitigate risk |