Sql Server Data

RIMVYDAS BUCINSKAS

***** ******* ** • LAKEWOOD RANCH • FL • 34202 • USA

312-***-**** • *****@*******.***

OBJECTIVE: Data Architecture Data Warehousing Business Intelligence

20+ years of professional application design and development experience. Last 10 years expertise building Business Intelligence, Data

Warehouse, Master Data Management, Data Integrity and Quality solutions. Practicing in data modeling, database design, data mining,

data integrity and quality assessments, measurements and statistics capturing, analysis, reporting, full cycle application development,

user interface design and media content management. Experience in Financial Services, Health Care, Insurance, Transportation, Customer

Relationship Management (CRM), Enterprise Resource Planning (ERP), Electronic Data Interchange (EDI), Media Production and

Entertainment industries.

EXPERIENCE:

July, 2009 – Present RB Technology Consulting Inc. Naperville, Illinois, US

Managing Principal Consultant

Specializing in Data Architecture (DA), Data Warehousing (DW), Business Intelligence (BI), Master Data Management (MDM), Data Integrity

and Quality (DIQ).

Present and past clients:

October, 2013 – March, 2014 USG Corporation usg.com

•

In a role as ETL Architect/Developer produced MDM solution for organization master data management using

!

SQL Server 2012 Master Data Services (MDS).

Integrated newly created MDM repository with legacy data warehouse on SQL Server 2005.

!

Developed interface to ETL HR data from Oracle E-Business Suite to MDS.

!

September, 2011 – October, 2013 Florida Family Insurance flfamily.com

•

! Developed MDM solution to inventory and track disk and database space utilization across enterprise of all hosting servers

and SQL Server instances.

! Architected and created Report Catalog repository/database to capture report metadata and report specific information.

! Converted 50+ DTS packages to SSIS of SQL Server 2008 R2.

! Upgraded 270+ SSRS reports to SQL Server 2008 R2.

! Software/tools utilized: SQL Server 2005/2008 R2, SSIS, SSRS, PowerShell, Visual Studio 2005/2008, Visio, TFS.

September, 2012 – April, 2013 Hallmark Services Corporation hscil.com

•

! Information Architect for Business Intelligence solutions.

! Involved in a number of projects for healthcare membership management systems to comply with Affordable Care Act 2013.

! Rewriting, enhancing, adopting current EDW/ODS and designing future state of DW/BI solution.

May, 2012 – August, 2012 RiverPoint Solutions riverpoint.com

•

! Developed data warehouse solutions on SQL Server platform.

November, 2009 – December, 2011 Cancer Treatment Center of America cancercenter.com

•

! Architected, data modeled, created ETL data flows and procedures for Enterprise Data Warehouse – build Marketing, Clinical,

Pharmacy, and Patient Financial Management data marts and repositories; General Ledger Account Hierarchies for aggregate

budget and actuals fact tables.

! Created pilots, proof of concept of business intelligence reports.

! Developed table structures and ETL modules for marketing campaigns to interface with Neolane marketing partner via SFTP.

! Software/tools utilized: ERwin, SQL Server 2005/2008 R2, SSIS, SSRS, Visual Studio 2005/2008, Visual SourceSafe 2005,

Oracle, InterSystems Caché, BusinessObjects, Lawson, Sunrise Clinical Manager (SCM), Eclipsys AMPFM System, Microsoft

Dynamics CRM.

June, 2011 – August, 2011 OpenTrader opentrader.com

•

! Developed backend data processing and business intelligence 1st release solution for open source professional grade

trading suite, targeted at high-frequency algorithmic trading and statistical arbitrage. OpenTrader is a social network for

traders and investors built on the innovative foundations of real Profit & Loss transparency.

! Software/tools utilized: SQL Server 2008 R2, Visual SourceSafe 2005.

February, 2011 – October, 2011 Newell Rubbermaid newellrubbermaid.com

•

! Continue seasonal consulting services as independent contractor at Office Product Group.

! Developed Profitability Analysis System (PAS) for finance and marketing departments to perform analytics on budget, actual

and forecast data.

! Developed Office Product Catalog (real time pricing report) based on actual data from SAP.

! Software/tools utilized: SQL Server 2005, SSIS, SSRS, Visual Studio 2005, Visual SourceSafe 2005, IBM InfoSphere DataStage.

Resume of Rimvydas Bucinskas 1 of 3 8/4/2014

RIMVYDAS BUCINSKAS

14407 SUNDIAL PL • LAKEWOOD RANCH • FL • 34202 • USA

312-***-**** • *****@*******.***

October, 2007 – October, 2010 Sanford Brands – Office Products Group at Newell Rubbermaid Chicago, Illinois, US

SQL Developer – Consultant sanford.com

Consulting, architecting, coding and delivering data warehouse (DW), business intelligence (BI), data integrity and quality (DIQ) solutions;

profitability analysis, budget and forecast financial systems. Majority of custom solutions, applications, interfaces and modules were

developed to supplement SAP ERP system functionality.

Primary responsibilities and contractual obligations:

Establish and provision coding standards, design patterns and versioning control;

•

Data architecture and modeling;

•

Develop SSIS, ETL modules and reusable objects; collect and report statistics of running processes;

•

Design prototypes and reporting templates, develop SSRS reports and fulfill BA role as needed;

•

Perform SQL ad-hoc requests, performance tunings, benchmarks, audits, data quality and integrity checks;

•

Administer SSIS and SSRS;

•

Administer SQL Servers when specific expertise is required;

•

Assist DBA with change control and deployment tasks.

•

June, 2007 – September, 2007 Chicago Public Schools Chicago, Illinois, US

Report Analyst – Consultant cps.edu

Consulted in business intelligence on Direct Dashboard project initiatives. Utilized Crystal Reports XI R2, SQL Server 2000/2005 and .NET

(Visual Basic) technologies to deliver custom solutions. Designed prototypes, database structures and reporting templates. Created

number of Direct Dashboard reports to supplement ISAT statistics. Developed report publishing application/service to automate report’s

generation, distribution and delivery processes. Created table structures to manage variety of reports form different sources and

organized into a single repository for availability via custom web application.

December, 1997 – June, 2007 YRC Worldwide Inc. Chicago, Illinois, US

Sr. Programmer/Analyst yrcw.com

Within years of obtained business knowledge and technical experience in a large scale of various IT systems and applications acted as

advising architect for DW/BI solutions, participated as a primary intellectual contributor, business analyst, hands-on designer, developer,

programmer, mentor and trainer. Leaded development of reporting objects within Data Warehouse and Business Intelligence Solutions,

Data Integration and Quality, Reporting and Analysis, Planning and Performance Management. Provided business case studies, proof of

concepts and technical expertise. Consulted on data modeling, EDW, ODS, OLAP, OLTP database designs and MDM concepts. Reviewed

high-level proposals and recommended specific applicable solutions. Communicated methodologies, design principles and best practices

to development teams. Mentored and educated team members and peers about data assets and necessities of transportation business. As

a programmer built full cycle applications and services with tools such as Visual Basic, SQL Server, Crystal Reports, RightFax, Imaging

Professional. Designed, developed and deployed various internal freight management applications, modules and interfaces. Gained solid

technical knowledge and experience with third party transportation software packages such as i2 TMS and TMW Systems.

Some of selected DW/BI contributions:

Established and set standards, design patterns and versioning control within Visual SourceSafe;

•

Developed objects in Oracle, SQL Server and Teradata databases for use within BusinessObjects and other applications;

•

Designed prototypes and reporting templates, crafted most challenging reports, automated distribution processes;

•

Developed and deployed numerous Crystal Reports for all level executives, finance, marketing, sales and daily operations;

•

Produced countless ad-hoc requests, SQL queries, performance tunings, audits and data quality checks;

•

Established, configured and administered Business Objects Enterprise;

•

Developed USF CPC (Custom Processing Center) imaging application suite for US/Canada freight cross-border operations which

•

still successfully running since 1999.

1996 – 1997 Diners Club International Chicago, Illinois, US

Programmer/Analyst dinersclub.com

Client/Server application maintenance and development for international finance administration and management, including accounting

and financial applications using Visual Basic, Microsoft Access, Excel, Borland Paradox, Oracle and Crystal Reports. Some of my

responsibilities included auditing and maintenance of relational data, improvements in design, database management, and creation of

financial reports using currency conversion, pricing and fraud management strategies.

1995 – 1996 Methode Electronics Inc. Chicago, Illinois, US

Programmer/Production Line Supervisor methode.com

Managed experimental fiber optics components assembly line for design and engineering department. Maintained product tracking

manufacturing system. Designed and developed Inventory Control application to consolidate related data and programs to support

assembly line and ordering inquiries. Deepened skills in Visual Basic, Microsoft Access and SQL Server.

1994 – 1995 Aras International Ltd. Manchester, United Kingdom

Programmer/Marketing and Commercial Manager

Resume of Rimvydas Bucinskas 2 of 3 8/4/2014

RIMVYDAS BUCINSKAS

14407 SUNDIAL PL • LAKEWOOD RANCH • FL • 34202 • USA

312-***-**** • *****@*******.***

Lithuanian business affairs coordination and administration. Designed and developed accounting applications such us Account Payable,

Account Receivable, Purchase and Sales Orders, Inventory Control using Microsoft Access, Excel and Visual Basic. Responsible for new

projects full cycle design, development, coding, testing and deployment.

1993 – 1994 Style TV Ltd. Lithuania

Creative Director, Advertising and Multimedia

Responsible for working closely with clients to turn their business objectives into consumer-focused broadcast advertising campaigns and

then uphold and hone that vision through to the end of the inventive production process.

1989 – 1994 Media Design Studio “Tomana Video” Lithuania

Producer/Executive Creative Director

Planed, designed, scripted and produced music and video advertising and publishing materials. Implemented new digital technology

solutions for our customers. Created public image and portfolio for clients. Talent discovery, project management and promotion.

1985 – 1994 Performing and producing with various orchestras and music bands. Lithuania

EDUCATION:

1988 - 1992 University of Technology Bachelor of Computer Science Vilnius, Lithuania

1982 - 1986 S. Simkus Conservatory Emphasis in Clarinet Performance Klaipeda, Lithuania

PROFESSIONAL DEVELOPMENT:

June, 2005 Certificates of BusinessObjects (Full Client) 6.5 Core, Intermediate and Advanced Reporting Rosemont, IL, US

March, 2005 Certificate of BusinessObjects XI Universe Design Rosemont, IL, US

February, 2004 Certificate of BEA WebLogic Portal 8.1: Developing Enterprise Portals Chicago, IL, US

June, 2000 Certificate of Guerrilla VB, COM+ (DevelopMentor course) Torrance, CA, US

August, 1998 Certificate of Achievement in Microsoft Visual Basic 5.0 Chicago, IL, US

December, 1997 Certificate of Excellence in Microsoft Visual Basic 5.0 Chicago, IL, US

SKILLS:

SQL Server, SSIS, SSRS, PowerShell, Oracle, Teradata, IBM DB2, AS/400, Microsoft Access, MySQL, SQL, TOAD, BusinessObjects (Enterprise

Server, Universe Designer, Web Intelligence, Crystal Reports), IBM InfoSphere DataStage, Informatica, ODAC, MDAC, ADO, OLEDB, ODBC,

Microsoft Visual Studio - Visual Basic, Visual SourceSafe, TFS, Microsoft Office, Visio, Adobe Dreamweaver, PHP, ASP, VBScript, JavaScript,

CSS, HTML, XML, VisionShape, Eastman/Kodak Imaging Professional for Windows, RightFax, IIS, Apache, Windows, MS-DOS.

LANGUAGES: Fluent in English, Lithuanian and Russian.

Resume of Rimvydas Bucinskas 3 of 3 8/4/2014

Contact this candidate