Sql Server Developer

Resume

Name: Peter Krolczyk

Email: *********@*****.***

Phone: 647-***-****

PERSONAL SUMMARY

Senior Data Warehousing Specialist and Systems Analyst with extensive

experience in data warehousing and database architecture. Logical and

physical data modelling, Kimball methodology skills include SSIS, SSRS,

SSAS, ETL, T-SQL, SAP, Informatica, Microsoft Dynamics and business

analysis with over 14 years of IT experience. Proficient in both

administration and development tasks with primary expertise in Microsoft

SQL Server design, development and administration. Experienced in Visual

Basic versions 4.0/5.0/6.0/.Net. Strong skills also include stored

procedures, views, triggers, DTS, OLAP, data migration, security,

backup/restore disaster recovery, VB script, and windows systems

administration.

PROFESSIONAL EXPERIENCE

June 2012 - Present

The Cosmopolitan of Las Vegas, Las Vegas, Nevada

ETL Developer, (Permanent Position)

Tasks:

. Works within applicable change management methodology.

. Creates conceptual and detailed design documents.

. Physical data modeling.

. Capture ETL Requirements.

. Design, develop, and test processes for extracting data from legacy

systems and production databases.

. Design, develop, and test processes for validating and conditioning

data prior to loading into a data warehouse.

. Design, develop, and test processes for loading initial and cyclical

data into a data warehouse sourcing from SQL Server, AS400 and

Teradata.

. Creates or modifies programs with or without written program

specifications, consistent with department procedures, philosophies,

and standards.

. Responsible for Business Intelligence solution design, integration,

data sourcing and transformation, database design and development

(logical / physical) and tool implementation related to data

warehousing

October 2011 - May 2012

Online Retail Startup, Berlin, Germany

Data Warehouse Architect (Contract Position)

Tasks:

. Worked with SQL Server 2008 R2, MySQL, developing data warehouse using

SSIS,SSRS, Star and Snowflake model using Kimball methodology

. Determined overall data warehousing standards, guidelines, best

practices and approved modelling techniques and approaches

. Collected requirements

. Reviewed and developed logical and physical data models, business flow

. Translated business requirements into technical architecture vision

and implementation plan

. Responsible for defining the complete data warehouse architecture.

. Defined requirements, data and technical architectures for the data

warehouse.

. Planned and designed the ETL processes involving data quality and

testing.

. Managed the process of discovery.

. Defined metadata standards for the data warehouse.

. Implemented Change Data Capture

. Directed and designed the information delivery and access for the data

warehouse.

. Developed Functional requirements and design documentation

February 2011 - September 2011

Irish Department of Justice, Dublin, Ireland

Database/SSIS Developer (Data Migration Project) (Contract Position)

Tasks:

. Business Analysis, collected requirements from end users

. Developed data migration from legacy systems

. SSIS and T-SQL development

. Developed ETL packages to transfer and clean data from DB2 to SQL

Server 2005, 2008 and DB2

. Developed migration scripts using SSIS and T-SQL

. Created audits and Monitor Data Extraction

Tasks:

November 2010 - February 2011

AIB Bank Center, Dublin, Ireland

SQL/Report Developer (Contract Position)

Tasks:

. Teradata scripts development

. Collecting user requirements and developed, update existing

procedures, reports

in Teradata environment

. Reports development using T-SQL in Teradata

. Designed and develop scripts, SSIS and SSRS to support financial

activities.

. Developed SQL scripts, SSIS packages to transfer large amounts of data

through the different systems.

. Designed and developed reports to retrieve data from various SQL

Servers using SSRS and MS Excel

September 2010 - November 2010

Union Bank, San Diego, California

Data Warehouse Consultant (Contract Position)

Tasks:

. Worked as part of the business intelligence group using SQL Server

2008, Visual Studio 2010.

. Developed and schedule SQL jobs to run every day to support banking

activities.

. Developed ETL packages and SQL jobs using SSIS packages to transfer

large amounts of data through different banking systems.

. Participated in daily scrum meetings and provide feedback on how to

improve processes.

. Developed SAP BW components

. Crystal Reports development

Tasks:

April 2010 - July 2010

Ezetop.com, Dublin, Ireland

Report and Data Warehousing Developer (Contract Position)

Tasks:

. Created Data Marts using Star and Snowflake Schema

. Database modeling and de-normalization

. Created scripts for Slow Changing Dimensions

. Created Reports in SQL 2008 (SSRS) in SharePoint

. ETL development, developed scripts and SSIS packages

. Database development included triggers, functions, stored procedures,

views

. T-SQL Development

. Analyzed existing architecture and suggest improvements

. SSIS Development and maintenance

. Collected user requirements, developed documentation

January 2010 - April 2010

Royal Bank of Scotland, Dublin, Ireland

SQL Database Analyst/Developer (Contract Position)

Tasks:

. DTS/SSIS Development, based on user requirements developed SSIS and

added functionality to existing DTS or SSIS

. TSQL Development, stored procedures development and troubleshooting

. Analyzing existing architecture and suggest improvements

. Administer various SQL server tasks: backup, performance tune up, jobs

. SSRS Development, based on user gathered requirements

December 2007 - November 2009

RBC Dexia, Dublin, Ireland

SQL Database Analyst/Report Developer (Contract Position)

Tasks:

. Database design and development.

. Upgrading existing SQL database to new functionality and better

performance by normalizing database and tuning SQL server.

. Upgrading from MS SQL server 2000 to 2005 version

. DTS Development for migrating data from different sources on timely

basis

. SQL scripting, adding new transact SQL procedures to a database,

improving existing ones by analyzing and tuning them, database tuning,

views, jobs and triggers development.

. XML development

. Writing documentation

. Gathered information from users and recommended improvements

October 2005 - March 2007

AIB Bank Center, Dublin, Ireland

T-SQL /VB Developer (Contract Position)

Tasks:

. Database modeling, analyzing and improving query performance, new

database development in SQL Server. DTS and application development

using Visual Basic 6. Creating Active X scripting and VB scripting.

. Meeting with users and business analysts to gather new requirements

. Analyzing old and new requirements and business logic flow to create

new specs

. DTS Development and migrating from previous database versions

. SQL scripting, adding new transact SQL procedures, improving existing

procedures by analyzing them, database tuning.

. Writing documentation

. Crystal Reports development

. Visual Basic 6 development

November 2001 - October 2005

Liberty American Insurance Group, Pinellas Park, FL

Database Developer /Visual Basic Developer (Permanent Position)

Tasks:

. General responsibilities include administering, maintaining all

existing SQL servers across enterprise. Developed and implemented

policies and procedures for ensuring the security and integrity of the

company databases.

. Implemented data models and database design, data access and table

maintenance, resolved database performance issues, database capacity

issues, replication, and other data issues.

. Designed physical data storage.

. Designed maintenance plans, backup strategy, disaster recovery plans,

evaluated and monitor databases to resolve performance issues.

. Configured database parameters and prototyped design against logical

data models.

. Responsible for defining data repository, data dictionaries and data

warehousing requirements.

. Build data warehouse, cubes, and stored procedures and DTS packages.

. Created reports using SSAS and Crystal Reports

. SSAS development using MDX for home insurance industry

. DTS development, data modeling

. Migrated data from Btrieve and M.S. Access to SQL 2000. Built

migration routines in Visual Basic and DTS.

. Created logins, groups, users, roles, databases, mirroring devices,

checking for database consistency, fixing DBCC errors, monitoring

error logs, database space allocations, transaction log space

allocations, fine tuning SQL performance.

. Cubes development

. Added and improved existing Active X objects

. Visual Basic 6 and .NET Development

November 2000 - May 2001

Chase Bank, Tampa, FL

DBA/Developer (Contract Position)

Tasks:

. Data modeling, SQL Server database and stored procedure design and

development DTS, OLAP and replication design and support.

. Created views, stored procedures, triggers and DTS.

. Developed utilities in Visual Basic 6.0.

May 2000 - November 2000

Pinnacle Towers, Sarasota, FL

DBA/Developer (Contract Position)

Tasks:

. Designed and created new databases and tables in SQL Server, optimized

databases and tables for storing large data types.

. Migrated M.S. Access to SQL server 7.0 and linked M.S. Access to

SQL server 7.0.

. Tuned SQL server logical and physical structures and T-SQL queries.

. Implemented, tested, backup and restore procedures.

. Maintained applications written in Visual Basic 6.0 with SQL server

7.0 back end.

. New software design and development which included rewriting

application into 3-tier architecture using COM and MTS.

. Active X development

. Power Builder development

. Training end-users

. Created documentation for developed solutions

April 1999 - May 2000

GTE Americast, Clearwater, FL

DBA/Developer (Contract Position)

Tasks:

. Administer SQL server 7.0 and M.S. Access databases.

. Migrated M.S. Access to SQL server 7.0.

. Designed and developed databases in SQL server 7.0, link databases

between M.S. Access and SQL server. Developed stored procedures and

triggers.

. Designed and developed applications using COM technology in Visual

Basic with back end SQL server and M.S. Access.

. Developed reports using Crystal Reports.

. Windows NT network administration.

December 1998 - April 1999

Edmonton Power, Edmonton, AB

DBA/Developer (Contract Position)

Tasks:

. Designed and developed relational database in SQL server, created

stored procedures, tables, user data types, indexes and views.

. Gathered information from end-users in order to determine application

and database scope.

. Designed and developed front-end multi user application written in

Visual Basic.

. Produced help files in HTML, created documentation and trained users.

December 1996 - December 1998

Baseline Technologies Inc, Edmonton, AB

Application/Database Developer (Permanent Position)

Tasks:

. Designed and developed new software and relational databases in M.S

Access and SQL server.

. Maintained existing programs using Visual Basic 4.0,Visual Basic 5.0,

Access 97, Visual C ++ on windows 95 and windows NT platform.

. Developed and update crystal reports based on user requirements and

maintained existing reports.

. Converted applications from 16-bit into 32-bit version to connect with

SQL 6.5 and MS-Access databases.

. Generated new stored procedures in SQL 6.5 server environment to

improve performance.

. Created exe and dll files.

. Developed applications in Power Builder.

August 1996 - December 1996

ISL, Edmonton, AB

Application Analyst (Permanent Position)

Tasks:

. Developed and maintained applications in Visual Basic, MS-Access, and

Power Builder

. Created and designed database in MS-Access to keep track of employee

performance.

. Developed and designed application to archive existing data from the

database.

. Maintained DB2 database and work on Visual Basic application to

retrieve data from the database.

. Generated documentation and help files for a new and existing

application.

. Provided technical support for users.

. Performed upgrade and hardware maintenance.

TECHNICAL Skills

SQL Server Data Modeling, Data Warehousing,

2000,2005,2008,2008R Database Architecture

Visual Basic M.S. Access

4.0/5.0/6.0/.NET Crystal Reports

Snowflake, Star Schema/Kimball

Methodology

Power Builder

Netezza SQL

Com, Com+

DTS/SSIS

Teradata, AS400, DB2

SAP

BTrieve/Pervasive

ETL Olap/SSAS SSRS

MS Dynamics

Transact SQL

Informatica

O.O.P. Methodology

EDUCATION & QUALIFICATIONS

Northern Alberta Institute of Technology (N.A.I.T)

Degree in Computer System Technology

Contact this candidate