Ken Lawrence Email & Phone Number

Greater Seattle Area

* Develop Crystal Reports* Develop ETL packages for data integration and data warehousing using T-SQL, Informatica and SSIS* Develop SSRS reports* Develop Cognos BI reports

Working on customer site doing Crystal Reports XI modifications and troubleshooting as well as T-SQL development of stored procedures.

Working on a project to convert Oracle-based Crystal Reports to SQL source. Also did some SSIS work for a data migration and created data validation scripts.

Working on site creating a series of Crystal Reports (XI) using an Oracle 10g database for the client's customers.

Develop new reports and enhanced existing reports using Crystal Reports XI.Made repairs/edits to existing reports when problems were identified in production.Deployed reports using Business Objects XI Enterprise.Used SQL to enhance report performance for reports that take a long time to run.Developed stored procedures, views and DTS packages for reporting using SQL 2000 & 2005.Work on location at customer site, City of Seattle (DoIT), doing various Crystal Reports XI… Show more Develop new reports and enhanced existing reports using Crystal Reports XI.Made repairs/edits to existing reports when problems were identified in production.Deployed reports using Business Objects XI Enterprise.Used SQL to enhance report performance for reports that take a long time to run.Developed stored procedures, views and DTS packages for reporting using SQL 2000 & 2005.Work on location at customer site, City of Seattle (DoIT), doing various Crystal Reports XI projects, based on ACD call center data for city entities and various other reports on city IT-related data.Work with end users and/or business analysts to determine and refine their reporting needs.Work independently on projects with little guidance from the technical team.Also did some reporting work for client Snohomish Fire District #1 and documentation for SanMar Corp. Show less

Developed new reports using Crystal Reports XI.Worked on location at customer site, Puget Sound Energy, on a project for automation of field technician forms, I produced the printed reports using Crystal Reports XI off of an Oracle database.Work with end users and/or business analysts to determine and refine their reporting needs.Many of these reports were reproductions of company forms, with no variations allowed.Work independently on projects with little guidance from the… Show more Developed new reports using Crystal Reports XI.Worked on location at customer site, Puget Sound Energy, on a project for automation of field technician forms, I produced the printed reports using Crystal Reports XI off of an Oracle database.Work with end users and/or business analysts to determine and refine their reporting needs.Many of these reports were reproductions of company forms, with no variations allowed.Work independently on projects with little guidance from the technical team.Worked remotely for Serena Software producing management level reports regarding service level agreements for their technical support.Supported front-end developers calling Crystal Reports from within their code. Show less

Helped support a production APPRO database (SQL) and any issues that came up. (issues with stored procedures, DTS packages, jobs and data storage)Used SQL to enhance report performance for reports that take a long time to run.Developed stored procedures, views and DTS packages for reporting using SQL 2000.Converted Access database in Everett location to use SQL 2000 and a newer version of Access.Documented some of the nightly job processes and how they generally worked, to help… Show more Helped support a production APPRO database (SQL) and any issues that came up. (issues with stored procedures, DTS packages, jobs and data storage)Used SQL to enhance report performance for reports that take a long time to run.Developed stored procedures, views and DTS packages for reporting using SQL 2000.Converted Access database in Everett location to use SQL 2000 and a newer version of Access.Documented some of the nightly job processes and how they generally worked, to help support in the future.Work with end users and/or business analysts to determine and refine their reporting needs.Supported any Crystal Reports issues that came up. Show less

Gathered reporting requirements from business users and/or analysts and supported end users thru helpdesk ticketing system.Used SQL to enhance report performance for reports that take a long time to run.Developed stored procedures, views and DTS packages for reporting using SQL 2000.Wrote SQL stored procedures and user defined functions based on reporting requirements and performed code reviews on other developer's code (including SQL written for nightly jobs and… Show more Gathered reporting requirements from business users and/or analysts and supported end users thru helpdesk ticketing system.Used SQL to enhance report performance for reports that take a long time to run.Developed stored procedures, views and DTS packages for reporting using SQL 2000.Wrote SQL stored procedures and user defined functions based on reporting requirements and performed code reviews on other developer's code (including SQL written for nightly jobs and applications).Work with end users and/or business analysts to determine and refine their reporting needs.Code reviews done to ensure best practices in use in SQL and Crystal Reports code.Generated Crystal Reports for the enterprise using Crystal Reports 8.5, 9.0 & XI. Report types included financial analysis, client statements, client financial statements of net worth, labels, form letters, print screens of applications and management level reports. Implemented, enhanced and repaired well over 300 reports during my time there.Created templates for new report development, to ensure a uniform look across reports within the company.Financial reports involved calculating various complex analyses on fund performance numbers (Sharpe ratios, Kurtosis, Cumulative Returns, Annualized Returns, Sortino Ratio, IRR etc.)Several reports involved adhering to strict formatting guidelines for external presentations set by the company's Client Communications department.Created and implemented several universes in Business Objects XI Enterprise along with a set of web intelligence reports for these universes. (started this around 6/05) Also installed the server and set up users for initial implementation. The universes were used for risk analysis, development project tracking and proximity searching on clients. I was responsible for the company's first implementation of Business Objects XI Enterprise, from installation to universes, to the web intelligence reports. Show less

Gathered reporting requirements from users within the organization.Installed and administered Crystal Enterprise 8.0 Web Server for distribution of reports enterprise-wide.Designed and enhanced reports using Crystal Reports 8.5Wrote SQL Queries for reporting needs. (SQL 7)Work with end users and/or business analysts to determine and refine their reporting needs.Wrote Visual Basic application for Sales organization to run complex query reports.Created reports on an ad-hoc… Show more Gathered reporting requirements from users within the organization.Installed and administered Crystal Enterprise 8.0 Web Server for distribution of reports enterprise-wide.Designed and enhanced reports using Crystal Reports 8.5Wrote SQL Queries for reporting needs. (SQL 7)Work with end users and/or business analysts to determine and refine their reporting needs.Wrote Visual Basic application for Sales organization to run complex query reports.Created reports on an ad-hoc basis as needs came up.Wrote reports against in-house custom CRM product, running on a SQL 7 database. Show less

Installed/Implemented Crystal Reports Web ServerCreated a reports package for a client in the legal industry per specificationsWork with end users and/or business analysts to determine and refine their reporting needs.Worked with HTML/ASP linking web users to reports via the Crystal ISAPI Web ServerImplemented web server and initial 15 report package within 1 ½ weeks

and created reports for Project Office software suite using Crystal Reports 8.0.Created and designed custom reports for customers.Used SQL Enterprise Manager to manipulate database information as needed.Used Microsoft Framework for development cycles.Traveled to customer sites (US Dept of HUD, Enterprise Rent-A-Car) for custom reporting needs.Used OLEDB connection to SQL 7.0 database.Designed many different categories of reports for project management usage.

Creation of medical reports and forms per specifications of corporate users.Modification of report to meet changing demands of users.Work on location at customer site. (NextRx)Connectivity to SQL 7 database, and use of SQL Enterprise Manager to modify database.Design of reports using Seagate Crystal Reports 7.0.Integrated reports into a Cold Fusion application for the customer.Implementation of Seagate Crystal Reports Web Server.

Designed and enhanced reports using Crystal Reports 8.Modification of reports to meet changing demands of users.Moved reports into production environment using Crystal Info Server.Worked on location at customer’s sites. (Associated Grocers & Catapult Software Training)Connectivity to Oracle using ODBC.

in Crystal Report Creation and Design as well as Crystal Reports Visual Basic/OCX certification.Expert knowledge in creation of reports using Crystal Reports versions 3-7.Excellent knowledge in troubleshooting design issues with Crystal Reports.Worked on other contracts for AIL, designing reports for other city entities, in other states, making forms to their specifications (law enforcement, etc.)Created and maintained reports for upper management, per their guidelines.Team… Show more in Crystal Report Creation and Design as well as Crystal Reports Visual Basic/OCX certification.Expert knowledge in creation of reports using Crystal Reports versions 3-7.Excellent knowledge in troubleshooting design issues with Crystal Reports.Worked on other contracts for AIL, designing reports for other city entities, in other states, making forms to their specifications (law enforcement, etc.)Created and maintained reports for upper management, per their guidelines.Team Leader of technical support operations team.Used MS Word and MS Outlook (Office Suite) for day-to-day operations.Trained in the support of Seagate Crystal Reports, connecting to data sources such as Access, SQL, Oracle, FoxPro and many other databases, as well as ODBC compliant sources and the support of applications made in C++, Visual Basic, Visual FoxPro, and Visual Interdev.Support customers with installation issues and runtime file issues for applications.Supervision and training of a team of about 10 technicians.Log daily calls into call tracking software (Pivotal Relationship 99) Show less