TEKsystems

TEKsystems (Aurora Bank)

Nov 2009 to May 2010

• Converting SQL queries to reporting formats utilizing Crystal Reports 2008, Web Intelligence (WebI) 3.1, Desk Intelligence (DeskI) 3.1, Excel/Access 2007

• Scheduling converted reports in Business Objects Xi R3.1

• Rewriting/combining SQL queries for SQL Server 2005 in order to facilitate conversion process.

• Automating Excel 2008 with VBA for reports that could not be converted

• Skills and Procedures used:

o SQL Server 2005 Management Studio

o Business Objects Xi R3.1

o Business Objects Web Intelligence (WebI) 3.1, Desk Intelligence (DeskI) 3.1

o Microsoft Office 2007 (Excel, Word, Access), Excel VBA