Sql Server Project Manager

Resume of PETER DOLINA

SUMMARY:

I am recently working for Sur La Table which is a chain of high-end kitchen-ware stores. My role

was to set up an efficient database environment to collect data from several independent systems:

POS, HR, Marketing. The challenge has been timely data transfer, data cleansing and data

quality evaluation. Using SSIS and SSRS, SSAS with some dashboard software additions we

were able to create a “cap” covering important data distributed into both OLTP and OLAP

formats. I am leading a team of 4 developers, I have already groomed my successor and I would

like to start in a new place to help them build their data functions as I have done here: I need new

challenge.

I worked as Senior Data Architect with Limelight Development in Seattle. In that position I was

responsible for translating business requirements into functional data related specifications, for

creating architectural design supporting both OLAP and OLTP processes, for defining and setting

up taxonomy rules to drive text analysis and to ensure compatibility of structured and un-

structured data in different data marts.

As a Senior Database Architect at Microsoft I spent time in architectural design and technical

implementation including ETL design and implementation of OLTP and OLAP solutions

supporting NAP (Network Area Protection) and MSN Sales. I was responsible for data

management, data quality evaluation and data cleansing using MS IS as well as information

presentation using MS RS. In my previous assignments at Microsoft and elsewhere I also acted

as team lead almost exclusively in the areas utilizing SQL Server (various versions) with RS, IS,

and AS. I tutored team members on MDX and delivered several complete data warehouse design

proposals both static (DW design) and dynamic (ETL, data quality control). I have also worked

as a Senior Development Manager for Russell Investments where I led the effort to improve the

overall compliance process and reduce cost of it by measuring and improving processes and

implementing a new IT solution using Six Sigma methodology. I have a doctorate in computer

science from the second oldest university in Europe: Charles University in Prague.

EXPERIENCE:

Sur La Table, Seattle, WA March 2009 – Current

Senior Data Architect

• Design and build OLTP databases from scratch by business requirements.

• Design and build Integration Services packages for ETL from POS and other systems.

• Design and develop complex queries for transactional and reporting purposes.

• Participate in strategic management decision process involving the usage of IT.

• Design and build data marts for OLAP analysis.

• Design and develop SSRS reports and dashboards.

• Mentor team members in efficient usage of SQL Server (T-SQL optimization, index

usage, partitioning…)

Limelight Development, Seattle, WA March 2006 – March 2009

Senior Data Architect

• Evaluate business requirement and functional specification for database implementation.

• Define and design data marts in the SQL Server 2008 environment.

• Suggest full-time index usage to cater to different taxonomies.

• Design and implement OLTP database functions to support data collection.

• Manage and coordinate data centric team effort set standards to avoid deadlocks and

improve performance.

500 Wall Street, Seattle, WA 98121-1510

Phone:509-***-**** • email: ********@*******.***

Microsoft, Inc. Redmond, WA. (TEKsystems) June 2004 – March

2006

Senior Database Architect

• Sent to a 4 month assignment to help the team in North Carolina with meteorological data

mart design and implementation utilizing SQL Server 2008 spatial data types and

methods.

• Design IT solutions supporting business and technical goals based on SQL 2005

database: T-SQL, IS, AS (MDX), RS

• Perform dimensional modeling to facilitate understanding and development of data marts.

• Design and implement ETL for both OLAP and OLTP data marts.

• Analyze, design, implement tools to monitor and improve data quality in different CRM

systems (Siebel, msorg) using SQL Server 2005.

• Coordinate efforts to establish common practices for inter-departmental cooperation.

• Design and implement practices for improved performance and resource usage.

• Design, construct and implement data exchange between various systems to support

analysis of overall system performance and data quality.

Russell Investment, Tacoma, WA. March 2003- June 2004

Senior Development Manager

• Led the effort to improve the overall compliance process and reduce cost of it by

measuring and improving processes and implementing a new software solution using Six

Sigma methodology.

• Coordinated the transition from the existing software system to the new system in all

SDLC phases.

Microsoft, Inc. Redmond, WA July 2002 – March 2003

Senior Database Analyst/Architect

• Responsible for performance improvement of a part of Sales and Marketing system.

• Assessed performance impact of new business rules, helping developers with physical

and logical database design both normalized and dimensional.

Delloitte Consulting, Harrisburg, PA January 2000 - July 2002

Team Lead

• Lead and coordinated team of 5 developers and 76 users in data extraction, migration,

and cleansing.

• Developed best options based on business and hardware requirement for inform data

migration and formatting.

• Designed and constructed stored procedures in DTS packages and SQL Server jobs to

facilitate data extraction, cleansing and loading process.

• Developed interface to DB2 using CICS as transaction manager.

• Set up reports and charts to support user’s business decision making.

CVS.COM, Seattle, WA April 1998 - January 2000

Team Lead

• Lead team responsible for design and construction of the RX (prescription drugs)

functionality.

• The team used: SQL Server, Oracle, IIS, VB6, COM objects written in house as well as

third party COM objects.

• Responsible for data extraction and migration into the RX system.

Kaiser Aluminum, Spokane, WA May 1997 - April 1998

Senior Developer

• Oversaw transition from Mainframe Inside Sales System to Client Server Inside Sales

System.

• Lead the data extraction and migration process from DB2 along with data cleansing

following the full set of business rules.

Pacific Gas and Electric, San Francisco, CA November 1987 - May 1997

Senior Analyst/Project Manager

• Acted as Project Manger for selected initiatives including an SAP R3 integration project.

• Analyzed, designed and coded C/S (Visual Basic, SQL Server 6.5 SQL Server 7, Access)

systems.

• Worked with mainframe systems (Cobol II, CICS, DB2).

• Served as database administrator for SQL Server 6.5.

EDUCATION

2006-Villanova University, Villanova, PA

Six Sigma Green Belt Certificate

1998-Microsoft Corporation, Redmond, WA

Microsoft Certified Professional

1985-Charles University, Prague, Czech Republic

Doctorate in Computer Science

1983-University of P.J. Safarik, Kosice, Slovak Republic

Master’s Degree in Mathematics

500 Wall Street, Seattle, WA 98121-1510

Phone:509-***-**** • email: ********@*******.***

Contact this candidate