Sql Server Crystal Reports

Krzysztof (Kris) Sobkowski

**** *** ***, *** ***, Seattle, WA 98121

e-mail: abmy1h@r.postjobfree.com

mobile: 617-***-**** / home: 206-***-****

PROFESSIONAL PROFILE

Business Intelligence professional with experience in Business Objects

reporting, universe design and data analysis in Oracle, SQL and Crystal

Reports. Proven ability of managing transition of reporting systems

between large financial institutions. Executed financial critical

processes which included debugging applications and resolving data issues

on very tight schedule. Recognized for quality work and fast,

professional response to customer needs.

EXPERIENCE:

JP Morgan Chase/Washington Mutual, Seattle, WA 2003 to 2009

Software Developer Senior (2006 - 2009)

. Led transitioning efforts of Business Intelligence for Corporate

Property Services of JP Morgan Chase.

. Led reporting migration for Corporate Property Services FAMIS

program to new web based environment. Modifying mappings and

workflows using Informatica 8.1.

Software Developer (2004 - 2006)

. Developed and maintained reports and Universes using Business

Objects 5.1, 6.5 and XI and Crystal Reports 10.0 and XI for various

clients within the organization.

. Provided ongoing production support, including the creation of ad

hoc reporting and resolution of complex reporting issues; developed

and analyzed queries to verify data accuracy displayed in reports

using SQL 2005 and Oracle 9i.

. Continuously participated in Washington Mutual Business Objects

Users Community of Practice, delivered presentations on best

practices for general BO user audiences.

. Executed internal monthly processes for Corporate Services Finance

group using MS Access applications, Oracle 9.i and Informatica 8.x.

. Provided supportive training on Business Objects & Crystal Reports

to peers as well as the end user base of internal customers.

Consultant (2003 - 2004)

. Developed reports using Crystal Reports 9.0 and integrated them

with internal program Building Central; wrote views and stored

procedures using SQL Server 7.0 and Oracle 9i; run queries to

verify data accuracy displayed in reports for Corporate Property

Services (CPS).

. Developed universe with Oracle 9.2 as data source and created

reports in BusinessObjects 5.1 for CPS

KForce, Burlington, MA 2002 to 2002

Consultant for CSI, Hudson, NH and JP Morgan Chase, Lowell, MA

. Upgraded Crystal Reports from versions 4.0 & 6.0 to 8.5, which

involved changing functions and their parameters in report

formulas; changing reports' data source from SQLBase to SQL Server

to improve performance

Page 2 Resume of Krzysztof Sobkowski

. Analyzed internally developed software in C++ 6.0 to configure

reports compatibility; preparing documentation on steps to be taken

for reports conversion and specification for reports with missing

guidelines.

Maxim Group, Burlington, MA 2000 to 2001

Consultant for Thinq, Billerica, MA

. Built enterprise-wide reporting utilizing Crystal Reports 8.0 and

ASP, including advice regarding troubleshooting Windows 2000, ODBC,

and Crystal Reports issues

. Managed weekly and monthly reports run and published them to

intranet site

. Wrote program in Visual Basic 6.0 to automate scheduling.

Renaissance Worldwide, Inc., Newton, MA 1997 to 2000

Consultant for Philip Morris International Richmond, VA, Cable & Wireless -

Tysons Corner, VA and Niagara Mohawk Power - Syracuse, NY

. Designed reports in Crystal Reports 7.0 to display enrollment

statistics necessary for medical services purposes.

. Wrote SQL code to extract data from Oracle 8i; analyzing and

redesigning existing reports to significantly cut expense in

production and distribution of the reports.

. Wrote code in Visual Basic 6.0 to pass parameters and display

appropriate data in Crystal Reports.

. Converted Access 8.0 database to SQL Server; customizing Access

interface to work with newly redesigned database.

. Analyzed existing rules and business requirements to meet customer

satisfaction.

. Provided consulting services to client regarding queries in SQL

Server and Oracle 8i and implementation in Visual C++ 6.0;

developing reports using Crystal Reports 6.0.

. Designed WinBatch modules for network software operation

installation.

. Prepared specification and documentation for clients on how to use

developed programs.

Previous Experience, Toronto, ON 1995 to 1997

. Developed software to prepare employee and customer satisfaction

surveys using Visual Basic 4.0; analyzed tables and created queries

in SQL Server to support Visual Basic application

. Designed reports for analysis of surveys using Crystal Reports 4.5;

installed hardware and software in Windows NT and Windows 95

environments.

. Upgraded and added new functions for Human Resources program using

Visual Basic 3.0; redesigned database using Access 2.0; modified

and created reports using Crystal Reports 4.0.

EDUCATION:

The Institute for Computer Studies (Honeywell Institute), Toronto, Ontario,

Canada: Diploma in

Computer Programming & System Analysis, 1995

University of Agriculture, Warszawa, Poland: MS - Horticulture, 1986

Contact this candidate