Sql Server Data Warehouse

KEITH M. HAROUTUNIAN

** ********* ****, *** #* ( Boston, MA 02118 ( ******@*****.*** ( (617)

***-****

OBJECTIVE

Seeking a business intelligence management position where I can leverage my

extensive technical and business experience to help drive financial performance.

TECHNICAL SKILLS

Languages: Proficient in VB.NET, T-SQL, VBA. Experience with C#, ASP.NET,

HTML, JavaScript

Databases: Proficient in SQL Server 2000/2005/2008, Access.

Operating Systems: Windows (Server 2003/2000/XP/Vista/7)

Tools: Proficient in Visual Studio.NET, SSRS, SSIS, SSAS, ERwin. Experience

with Dreamweaver, Flash

PROFESSIONAL EXPERIENCE

Caturano and Company - Charlestown, MA June 2006 to Present

Senior Application Developer October 2007 to Present

Accomplished developer and team leader responsible for the delivery of high

quality financial reporting systems and custom applications for a leading

regional accounting, CPA and consulting firm.

Key Achievements:

Project lead on a $350,000 SQL 2005/2008 Data Warehouse implementation

integrating the firm's major systems: CRM, practice management, budgeting and

ADP. Played a pivotal role in system design, gathering business requirements and

developing SSIS integrations

Architect of a common business logic tier ensuring data consistency and accuracy

between all reports, cubes and applications that utilize the Data Warehouse

Designed and built a suite of SSRS reports and SSAS cubes providing analysts near

limitless ad-hoc reporting capability. Created KPIs in SSAS mirroring the firm's

key metrics making firm-wide dashboard reporting a simple task

Developed an extensive ASP.NET architecture to centralize data administration and

automate key processes such as budgeting, payroll integration and system

synchronization

Automated AR collection administration by creating an email reminder and tracking

system, reducing outstanding AR by $3MM

Managed project to migrate the Data Warehouse to PolyServe, HP's clustered

virtual SQL Server platform

Deployed a series of SSRS data-driven subscriptions to automate firm-wide AR,

profitability and expense report distribution, reducing annual administration

costs by nearly $50,000

Senior Consultant - Application Development June 2006 to October

2007

Successful consultant with a unique blend of client relationship and technical

skills. Managed development teams on multi-million dollar engagements while

maintaining critical client communications and relationships. Lead architect

and developer on several data warehouse and reporting engagements with the

proven ability to translate business requirements into robust, scalable

business intelligence platforms.

Key Achievements:

Lead developer and business analyst on $75,000 SQL 2005 Data Warehouse

implementation complete with several custom SSRS sales commission and financial

reports. Developed a secure ASP.NET web-based front end to allow Finance and

Sales employees to access the SSRS reports worldwide

Managed all development and administration on a clients' existing $2MM mixed

Business Objects 6.5/XI environment. Lead 6.5 to XI migration project while

simultaneously reducing the number of reports from 1,100 to 300. Implemented

Infosol Business Objects source control system and implemented a software

development process with appropriate controls on the system

Developed an automated email application to replace a clients' cumbersome manual

process, resulting in an annual cost savings of $25,000

Sterling Autobody Centers - Natick, MA August 2000 to June 2006

Programmer October 2005 to June

2006

Skilled programmer with the ability to write effective and efficient

applications by adhering to programming standards and best practices. Worked

directly with the CIO rewriting Sterling's core business application for SQL

Server 2005. Managed key reporting automation projects to streamline processes

and reduce costs. Teamed with first and second level technicians to provide

exceptional field support for legacy applications. Worked on early stages of

migration to ASP.NET / JavaScript architecture.

Key Achievements:

Consolidated fragmented corporate reporting structure into a web based Reporting

Services portal, effectively reducing company-wide report administration by

nearly 75%. Managed key project initiatives including report authoring,

deployment and SQL Server administration

Designed, developed and implemented an automated national accounting system that

generated $125,000 in labor cost savings annually

Migrated several VB core business modules from Access to SQL Server 2005.

Transferred embedded VB logic to SQL stored procedures, significantly increasing

application speed. Worked closely with the QA team to ensure deployment of high

quality, stable applications

National Financial Analyst April 2004 to October

2005

Proficient analyst with the proven ability to manage key projects and

significantly reduce operating costs. Advanced financial and operational

analysis supporting the CEO, CFO, COO and Sterling's national operations team.

Exceptional ability to communicate effectively with top-level executives to

accomplish team goals.

Key Achievements:

Automated key finance and operations reports using Excel VBA generating

approximately $55,000 in cost savings annually

Worked with software development team to analyze, diagnose and remedy data

integrity issues. Managed projects that significantly improved the accuracy and

quality of the information in the data warehouse

Lead in-depth statistical analyses to identify key business drivers and outline

the resulting impact on operations. Presented recommendations to senior

management for review regularly

Conducted complex demographic and sales analyses pivotal in the new site

selection process. Engaged in strategic planning and site selection process for

over 40 locations nationwide

Marketing Analyst August 2000 to April

2004

Accomplished professional with a diversity of technical and analytical skills.

Webmaster for two company websites providing continuous HTML updates and site

support. Design and distribution of marketing materials, posters and printed

materials for over 60 locations nationwide.

Key Achievements:

Executed joint venture between Sterling and Allstate, Sterling's parent company,

to create, design and build Sterling's website. Project involved copy writing,

designing page layouts and templates, functionality testing and ensuring both

company's goals and objectives were met

Negotiated deal to produce the company website $20,000 under budget

Coordinated yellow pages advertising in over 20 different markets and achieved

$50,000 in cost savings annually by eliminating advertising redundancies

Developed and implemented national e-commerce program to handle over $125,000 in

employee apparel orders annually

AWARDS

Relentless Award - Caturano and Company

Annual award given to employees who relentlessly pursue client service (2007)

TECHNICAL TRAINING

Ralph Kimball - Data Warehouse Design

Microsoft - SharePoint Boot Camp

EDUCATION

University of Massachusetts - Amherst, MA

Bachelor of Business Administration, Marketing (1999)

Contact this candidate