Sql Server Project Manager

Vito Addotta

Oak Ridge, NJ *****

973-***-****(H)

973-***-****(C)

********@*********.***

SUMMARY

Information Technology Professional with diversification in programming

languages for Business Applications and highly motivated Business

Intelligence Professional using SQL Server 2005 and Microsoft

Technologies. Extensive IT experience in developing, testing, deploying,

maintaining and debugging programs and installing vendor packaged systems.

Skilled in using databases on mainframes and servers. Strengths include

ability to educate and translate technical functionality to the non

technical end user, proven leadership ability, high collaboration within

teams and ability to work independently with all levels of management.

TECHNICAL SKILLS

Microsoft Technologies:

SQL Server 2005/2008 Integration Services (SSIS), SQL Server 2005/2008

Analysis Services (SSAS), SQL Server 2005/2008 Reporting Services (SSRS),

Microsoft Office SharePoint Server 2007, Microsoft Performance Point

Server, Microsoft Visio

Databases:

MS SQL Server 2005

Software:

SQL Server Business Intelligence Development Studio

Query Languages:

T-SQL, MDX

Application Software and Maintenance Utilities:

Oracle 11i ERP Application, Discoverer 4i,10g Desktop and PLUS, Oracle 9i

PL/SQL, Citrix, TOAD, SQL-PLUS, Harvest, Appsworx, Net Meeting, Windows XP,

HTML, Perl and DBI, Unix Scripts, SQL Programmer(Sybase), Windows 2000, MS

Word, MS Excel, MS Project, MS Outlook, MS Access, Lotus Notes, DB2/SQL,

QMF, Cobol 2, Cobol, CICS(Command), FileAid, Easytreive, BMS, Intertest,

Xpediter, TSO/ISPF, OS/JCL, Endevor, Panvelet

SetFocus, LLC. Parsippany, NJ 07/09 - 09/09

Business Intelligence Master's Program

. Implemented a Labor Analysis Business Intelligence solution for a

fictitious national construction company.

. Existing data from diverse data sources were consolidated into a

uniform SQL Server 2005 database. ETL capabilities of SQL Server

Integration Services were used to define imports of the data, build

scheduling packages, to define integration flow, log data error

exceptions and orphaned data and to define Database Maintenance Plans

and send emails.

. Created a number of cubes, dimensions and business critical KPIs using

SQL Server Analysis Services representing aggregations in several

different ways - hierarchically and using custom groupings that the

company will use to analyze performance. Created several MDX queries

according to business requirements.

. Developed several detail and summary reports including line and pie

charts, trend analysis reports and sub-reports according to business

requirements using SQL Server Reporting Services.

. Implemented business intelligence dashboards using MOSS 2007 Report

Center and Excel Services producing different summary results based on

user view and role membership.

. Created score cards with executive summary dashboards using MS Office

Performance Point Server 2007 Dashboard Designer that display

performance monitoring measures for sales, sales trends, and book

return rates for a fictitious book publisher deriving data from a SQL

Server 2005 OLAP data source and deployed them to SharePoint sites .

The dashboards also contain drill-down capabilities to view book sales

by book category and customer, through summary reports and sales trend

charts.

. Created score cards with advanced set of dashboards using MS Office

Performance Point Server 2007 Dashboard Designer that feature

executive summary measures for revenue, overhead costs, material

purchases, labor and profitability trends for a fictitious

construction company extracting data from a SQL Server 2005 OLAP data

source and deployed them to SharePoint sites. The dashboards also

contain pages to view performance by employee, by region, and by

quarter enabling end-users to make filter selections.

. Key product areas utilized also include data modeling, SSRS report

subscriptions and data driven subscriptions, SSAS analysis services

processing tasks, cube processing options and roles.

PROFESSIONAL EXPERIENCE

RICOH AMERICAS CORP. West Caldwell, NJ 1996 -

2009

Oracle Discoverer Administrator and Developer (2005-2009)

. Developed, tested, and deployed Discoverer 4i and 10g reports using

Discoverer Desktop. Responsible for fulfilling requests from users in

Order Management, Inventory Control and Finance.

. Created, modified, and enhanced numerous Discoverer reports within the

targeted timeframe.

. Developed, tested, and deployed Concurrent Program in PL/SQL package

to replace a Materialize View running for hours every morning.

. Accomplished during Discoverer development projects to run adhoc

reports upon request or respond to emails or calls periodically with

Discoverer Plus issues.

. Educated users to be 'Super Users' or developers via Webex followed by

procedural document from logging on to exporting reports.

Consultant Sr. Programmer/Analyst (1996-2005)

. Maintained Financial Management Interface (FMI) system designed for

IBM Mainframe, using DB2, QMF, COBOL and Cobol II. System interfaced

daily against an Inventory, Parts and Billing systems.

. Maintained numerous monthly Summary Reports used for balancing against

systems that fed FMI.

. Ensured monthly FMI fed into Client/Server G/L system called Computron

on a HP/Unix system. Utilized REXEC, Unix Scripts and SQL for SYBASE

to transfer FMI monthly detail Journal Entries to G/L Computron

system.

. Maintained Account Payable transactions (invoices) transmitted daily

via EDI (electronic data interface). Invoices were transmitted

directly or indirectly to either the IBM OS/390 and/or HP/Unix

systems.

. Maintained a CICS and batch Freight Rating system that processed all

freight invoices before passing to A/P Computron system and separate

batch process for Airborne Express invoices. Regarding Unix system:

company received daily invoices from in-house Purchase Order system

(CPS). Invoices were parsed by a Perl program, then loaded with Unix

scripts to Sybase database and fed into to A/P Computron system.

. Designed, developed, tested, and implemented an EDI transmission of

invoices daily from Federal Express. Process entailed receipt of EDI

transmission from Federal Express, editing and parsing by a Perl

program and loading into a Sybase database. User had ability to review

all open invoices on Intranet and update, display and/or approve for

payment via Intranet screens. User viewed invoices flagged for

approval, extracted from nightly batch process and fed into A/P

Computron system. System utilized Perl, Unix scripts, HTML and SQL for

Sybase.

PRUDENTIAL INSURANCE Roseland, NJ 1995 - 1996

Consultant Sr. Programmer/Analyst

. Converted VSAM files to DB2 tables for Agent Compensation System. Team

member responsible for Batch Design documentation process which

entailed gathering all Batch Program Specifications and organizing

information for formal presentation to, and education of, end users.

. Designed appropriate Audit System for batch process, which involved

three batch program specifications requiring SQL code. Responsible for

ongoing monitoring progress of project to ensure maximum efficiency.

PETRIE RETAIL STORES Secaucus, NJ 1994 - 1995

Consultant Sr. Programmer/Analyst

. Converted sales history by store to retrofit new Merchandising

Management System (MMS) package.

. Developed and implemented sales comparison program and maintained

programs for MMS package.

. Enhanced Distribution Planning System by implementing new category

called 'Inner City Stores'. Project required development of table then

loaded to identify all SKU's associated with stores. These

enhancements were written for batch and online programs. Project was

completed in MVS environment utilizing COBOL, Cobol 2, CICS, Xpediter,

CEDF, VSAM, TSO/ISPF, File_Aid and OS/JCL.

AMERICAN INTERNATIONAL GROUP (AIG) Livingston, NJ 1985 - 1994

Project Manager

. Manager responsible for full project life cycle from development

through implementation.

. Maintained, enhanced, and streamlined existing systems resulting in

improved overall business efficiency.

. Projects included: Improved efficiency of claim system, streamlined

loss reporting system, converted and compared data from VSAM files to

DB2 tables, transferred source code to new source facility system,

redesigned and consolidated foreign and domestic Risk Management

applications.

. Developed, tested and implemented new source facility called ENDEVOR.

Product controlled all application development, quality assurance and

production sources.

. Reduced processing time for claims system by 30% by revising daily

batch system to do concurrent processing.

. Assisted Business Analyst in design specifications for fraudulent

report system by eliminating two programs resulting in shorter

processing and development time.

Project Leader

. Directed team of five programmers to develop and implement Premium

Audit Tracking system within eight months. System was highly

innovative and involved cooperative processing on IBM 3090 and IBM

PS/2's using DB2, SQL, CICS, COBOL and MULTI-Soft's 4GL.

Sr. Programmer/Analyst

. Installed, tested and implemented Policy Management System (PMS)

package.

. Ensured stabilization and maintenance of system before turning over to

remote DP staff.

EDUCATION

Thomas Edison State College Trenton, NJ

B.S. Degree in Business Administration and Minor in Data Processing

Contact this candidate