Data Sql Server

Ira Lieman

E-mail: ira.wr (at) theliemans (dot) comResiding in Bergen County, New JerseyObjective

A key management role with responsibilities including business process redesign through information delivery.Skills

Database & Technical: Windows and Macintosh Operating Systems, Microstrategy DSS Suite,

Sagent Design Studio, Cognos Business Intelligence Suite, SQL/ODBC (against

multiple RDBMS including Teradata, Oracle 7-9i, Sybase 11, MS SQL Server 5-7, IBM AS/400

and DB2/6000), Crystal Reports, Microsoft Access, Microsoft FoxPro, Visio, Microsoft Office.

Web & Document Publishing: Microsoft FrontPage, Macromedia Dreamweaver, Allaire HomeSite, Quark Xpress,

Adobe PageMaker, Adobe Photoshop, Adobe Illustrator, Netscape Communicator, Internet Explorer.Microstrategy Gold Certified Decision Support ConsultantExperience

January 2005 - present

Company Confidential

Northern NJ

Manager, Web Development and Data WarehousingManaged two senior web application developers versed in Java, .NET, and scripting languages and one Oracle DBA with the goal of providing enterprise-wide information delivery for an audience of over 1,000 global associates. Identified opportunities for improvements in business processes by guiding associates in metric creation and further analysis of corporate data. Provided data warehouse reports on an ad-hoc and periodic basis to all levels of management.Served as subject matter expert on multiple executive committees, brought together to improve internal and external relationships.Initiated development of new corporate Intranet site that was to be the single worldwide source of internal information about the company. Maintained consumer web presence under the management of Marketing executives.

January 2004 - December 2004

Intrasphere Technologies,

New York, NY

Consulting Business Analyst

Pfizer Inc., New York, NY Managed the implementation of a web-based services catalog using ASP and proprietary technology against a SQL Server database. Managed the resources of a Senior-level developers and a Database Administrator for required upgrades to the existing system. Enhanced existing data model to respond to requirements set forth by the client. Utilized Crystal Reports to develop reporting against database for hard-copy' report functionality. Wrote detailed test scripts and managed the unit testing of the system, as well as regression testing in three environments.

MasterCard International, Purchase, NY Responsible for day-to-day VP-level client interaction on financial services data modeling project. Lead back-end ETL development and database management of large financial models for consumer finance organization. Utilized disparate internal systems to gather data. Data was accessed through Business Objects and Comshare front ends against vast corporate data warehouse. Managed internal standardization process through ETL. Consulted on gaps in reporting and model functionality based on business requirements. Documented enhancements and new application requirements for business unit population.

September 2001

December 2003

Independent Consultant for Data Warehousing Initiatives

Multiple client locations

Harte-Hanks Analytics, New York, NYReported on website activity for a national beverage

manufacturer, using NetGenesis and Microstrategy for reportingModeled data and developed reporting on Oracle and SQL Server

databasesCreated schema for analyzing customer sales and demographic

information for a national specialty retailer, regional family

restaurant chain, and pharmaceutical research and development

concern.

Dow Jones & Company, Princeton, NJIdentified enterprise-wide reporting requirements based on the

implementation of a new third-party data management system for

advertising sales. Directed development team for translating report requirements

into Cognos Impromptu web-based reporting solution and Cognos

PowerPlay cubes for ad hoc analysis against home-grown Oracle

RDBMSManaged contact with software vendor to communicate

requirements and for extracting data from their object-oriented

database into an Oracle Data Warehouse to facilitate reporting

needs. Instructed all levels of management in the benefits of Data

Warehousing and Business Intelligence, and what results could be

measured through a successful implementation.

Unisys Corp, Livingston, NJConceived enterprise-wide standards in reporting, and initiated high-level conversations

to refine these standards across multiple functional areas.Acted in an advisory capacity with technical database team on a Microstrategy implementation strategy.Instructed all levels of management in the benefits of Data Warehousing and Business

Intelligence, and what results could be measured through a successful implementation.

September 2000 - August 2001,

New York, NY

Project Leader/ManagerManaged support and enhancement of proprietary reporting suite at JPMorganChase, handling

market risk and derivatives collateral utilized by mid- and back-office staff.

Technology included: Sybase RDBMS data warehouse, ETL from various internal

systems through Sagent Design Studio, Internally developed Java applet for

graphing query results, Microstrategy web based front-end for complex ad hoc querying.Supervised daily data quality procedures, which required interaction between JPMorgan

offices in New York, London, and Tokyo.Developed SQL queries as needed against development and production databases for

quick-response ad hoc reporting.Managed personnel resources as needed for long-term enhancement projects.Created metrics measuring success against specified criteria for Client Services group.

Modeled data and created reports to show this information, using Microsoft

Access and Crystal Reports against Epicor Clientele tables.

August 1998 September 2000,

New York, NY

Lead Business AnalystInitial point of user contact within a women s apparel business unit for the

implementation of Teradata Data Warehouse and Microstrategy DSS Agent for

end-user ad hoc OLAP reporting, as part of our Y2K compliance initiative.Responsible for training and managing progress and assignments for two Analysts.Translated business requirements into further development of the OLAP system. Presented

must haves to central development teams and assisted with ETL methodologies

from the existing transaction logs.Created daily, weekly, and monthly query sets that performed regression tests for data

quality between Data Warehouse and other mission-critical systems.Started "Best Practices" sessions for users of multiple business systems to help them

better understand and analyze the data they required daily. Other business

units emulated these sessions as a monthly practice.Self-taught the operation and functionality of the Island Pacific retail management system,

an AS/400 application, and became de facto user support point for Island

Pacific issues.Developed cross-platform applications to meet business user needs, using Microsoft

Access, VBA, and ODBC SQL against production Teradata, SQL Server, and AS/400

databases.Developed multiple projects to port old reporting applications to the new data model,

many of which were adopted by other retail divisions of The Limited, Inc.

December 1995 August 1998

Ogilvy & Mather,

New York, NY

Business AnalystCreated and presented analyses of worldwide media spending reports for internal and

external clients using IBM DB2 SQL, Microsoft Access, Lotus Approach, Microsoft

FoxPro, Microsoft Excel and Crystal Reports.Managed offline information acquisition from international data providers, and assisted

with loading the records into our centralized relational database system.Documented database structural changes, and instructed data users on its new capabilities.Managed project requirements, departmental resources, and internal billing requirements

for ongoing media research projects.

June 1994 December 1995,

Westchester/Rockland, NY

Sr. Financial Services RepresentativeDesignated trainer for market area branches on improvements, changes, and new navigation

techniques in bank-wide computer system.At request of senior management, was sent to aid newly acquired branches with transition

to new banking system.Supervised personal goals and company policies for 2-4 Financial Services Representatives

in branch.Education

Binghamton University (SUNY)

Double BA: Psychology/Philosophy

Graduated: May 1994

Back to Ira's page

E-mail Ira

Contact this candidate