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

LPS, Inc.

LPS, Inc. (Lender Processing Services) Oct 2007 to Feb 2009

• Designing and modifying reports for proprietary real estate tracking application utilizing Crystal Reports XiR2

• Assess needs, requirements and layout for Business Objects Xi R2 Universe

• Develop and maintain additional reports using MS-Access 2003 writing advanced queries and VBA code modules

• Backend databases consisted of MS-SQL Server 2005, MS-Access 2003

• Skills and Procedures used:

o Crystal Reports Xi R2

o MS-SQL-Server 2005 Management Studio

o MS-Access 2003

o Toad (Quest Software) to query SQL database to create queries, views, and procedures