Ira Lieman
E-mail: ira.wr (at) theliemans (dot) com

Residing in Bergen County, New Jersey

Objective

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 Consultant

Experience

• Managed 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.

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.

Harte-Hanks Analytics, New York, NY

• Reported on website activity for a national beverage manufacturer, using NetGenesis and Microstrategy for reporting
• Modeled data and developed reporting on Oracle and SQL Server databases
• Created 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, NJ

• Identified 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 RDBMS
• Managed 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, NJ

• Conceived 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.

• Managed 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.

• Initial 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.

• Created 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.

• Designated 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