SUMMARY

Mr. Lieberman possesses over 18 years experience in the Information Technology industry. His strengths include data base technologies, data warehousing, master data management, business intelligence solutions and Project Management. He excels in all phases of the systems development lifecycle from gathering requirements and solutions design through deployment and post-deployment operational support procedures. In complementing his architecture and industry knowledge, Mr. Lieberman’s strong business background enables him to understand, deliver, and deploy high-quality, optimized, and robust systems that allow businesses to store and retrieve information easily and effectively. Technical leadership and managerial experience have prepared Mr. Lieberman to lead others as well as participate as a team member with a keen appreciation for schedules, budgets, and deliverables.

Methodologies: Dimensional Database Modeling • Entity Relationship Modeling • Physical Database Design • Standard Lifecycle Methodologies • PMP Waterfall and Agile Methodologies • Client Server/N-Tier

Technologies: Databases: SQL Server 7/2000/2005/2008 • Oracle 7/8/10g • Teradata 7/12 • MySQL 5/6 • DB2

Design Tools: ERwin Data Modeler • Embarcadero ERStudio • TOAD • Visual Studio • Visio

Development Tools: Oracle Warehouse Builder • Teradata SQL Assist • Business Objects XR2 • Visual Studio 2005/2008/2010 • Toad • Talend Open Source • SQL Server DTS and SSIS

Reporting Tools: Business Objects • Crystal Reports • SQL Server Reporting Services • Knosys ProClarity Analytical platform • Active Reports Pro • Tableau

Languages: PLSQL • SQL • Visual Basic4/5/6 • Visual Basic.NET • C#.Net

Functional Areas: E-Commerce • Finance • Inventory Management Systems • Medical • Pharmaceutical • Mobile Communications • Sales • Marketing • Manufacturing

Education B.A. • Finance and Accounting

Certification: Project Management Professional (PMP) Certification

Confidential, 2010 to current

Position: Solution Architect/ Technical Project Manager (Sr. Consultant)

Mr. Lieberman performed a detailed analysis of the company’s enterprise architecture. The analysis encompassed the technical aspects of the architecture and the software development lifecycle.Numerous business units were also interviewed to determine how their business processes were shaped by the current architecture and how their needs could better be met.

The findings were presented to senior management along with recommendations for changes to the architecture. The recommendations included the establishment of a Master Data Management repository to consolidate disparate data stores and a Service Oriented Architecture to alleviate point-to-point interfaces.

Mr. Lieberman was responsible for the designed and implemented of the Master Data Management Architecture which used SQL Server 2008 R2, SSIS and the asynchronous nature of Service Broker for near real time processing. The MDM system integrates with disparate LifePRO Policy Management Systems as well as other information systems needed to satisfy the businesses processing needs. The MDM system consolidates Agent and Agent Policy information which eliminates the companies need for duplicate data entry and also provides a single source of information for reporting needs. Using Agile methodologies, Mr. Lieberman was also responsible for the coordination and management of the development team’s deliverables and the technical integration with the architect of the Biztalk ESB middleware layer. Mr. Lieberman was responsible for the coordination and creation of QA test methods and policies.

Mr. Lieberman was the joint Technical Lead teamed up with an internal GAFRI resource on the Secure Agent Web project. The Secure agent Web Project incorporated .Net 4 web services, SQL Server 2008 R2 and SharePoint 2007. Responsibilities include the integration of SQL Server 2008 Service Broker for near real time processing of disparate data sources which include the LifePRO Agency and Policy Management System, Not in Good Order database repository and the consolidated GAFRI SEEK ODS reporting system. Other duties included the mentoring of GAFRI internal resources and the coordination of ongoing projects such as Agent on boarding and Agent Training which integrates and leverages the previously architected Agent MDM foundation developed and Architected by Mr. Lieberman.

Confidential, 2008 - 2010

Position: Business Intelligence Architect/ Business Objects Team Lead (Sr. Consultant)

NetRX is an Integrated Pharmacy Benefits Management data mart consisting of both Anthem and WellPoint pharmacy benefit/claims data. The Enterprise NetRX Reporting System provides the delivery of internal and external reports, ad-hoc reporting, and dashboard functionality, to their Pharmaceuticals division customers. NetRX uses Business Object XI R2, Crystal Reports and Teradata. The charter was to supply 52 customer reports. The current architecture could not support the 20 largest reports.

Primary responsibilities included:

• Analyze the existing Business Objects XI reporting system from the Teradata data model through the Business Objects Universe and Crystal Reports. Find and recommend performance modifications to the existing architecture. The changes implemented based on our analysis enabled all 52 reports to run. The average increase in performance of the reports was above 40% and closer to 65% for the larger reports. Architectural changes included data modeling enhancements, proper indexing, creation of pre-aggregation tables and performance modification centered around the implementation of row level security.
• Maintain Business Objects delivery schedule within Microsoft Project.
• Coordinate deliverables and maintain project documentation through SharePoint Server 2007
• Responsible for unit testing and test case creation and coordination with QA.
• Responsible for the management and mentoring of the Business Objects development team. This team was responsible for the creation of all DDL scripts related to the Security/reporting performance enhancements as well as the creation and modification of the Business Objects Universe and associated Crystal Reports.
• Responsible for the communication and coordination of reporting deliverables with the dependant cross functional teams, which included the internal Business development group, DBA’s and QA teams.
• Other tasks included coordination with cross functional teams and the prioritization of reporting defects and enhancements.

Confidential, 2008 (4 MONTH ASSESSMENT)

Position: Technical Project Manager/Business Intelligence Analyst (Sr. Consultant)

Co-authored a BI capabilities assessment for a Web 2.0 startup company focused on facilitation content sharing across the internet. The assessment laid out the roadmap for establishing a robust and flexible enterprise business intelligence architecture to meet the changing needs of the business as they grow. This also included setting the project work plan, estimating resource needs, and maintaining the project schedule for the development of the “first phase” BI solution for the client to meet their current critical reporting and analysis needs.

Primary responsibilities included:

• Assess the current Sharethis architecture and business systems and lay out a roadmap for establishing a robust and flexible BI solution. This encompassed analysis of the current Sharethis OLTP database system, Web Log’s, Widget Click Stream data and base output reports.
• Create the project work plan and maintain the project schedule in Microsoft Project. This included keeping track of project milestones.
• Development of “first phase” BI solution for the client to meet their current critical reporting and analysis needs.
• Creation of Data Warehouse Dimensional models in Oracle 11g in support of the clients Customer and financial reporting needs. This included creation of Views, Stored Procedures, Triggers and Functions related to the Staging and Data Warehouse database systems.
• Creation of all (ETL) processes using Talend Open Studio to feed the newly created Data Warehouse with data from the 3 disparate Sharethis data sources. Data sources included Customer Web Site log information extracted from Google Analytics in XML format, Widget share and click through data logs extracted from Amazon’s Simple DB (1 Million records hour) and Customer/Publisher registration information from the Sharethis MySQL OLTP database.

Confidential, 2005 - 2008

Position: Database Manager/Architect

Led a team of engineers and business analysts to re-design the SQL Server 2005 transactional (OLTP) database and deliver a new Data Warehouse solution using SQL Server Analysis Services (SSAS) for a large lumber trading company. The Lowgrade Lumber (OLTP) database structure supports the internet based order and inventory trading platform. This included the separation and migration of all reporting functions from the Order Inventory transactional database over to the newly created Data Warehouse database. The separation of the databases relieved the transactional system from the Burdon of large running queries and help increase the applications scalability.

Primary responsibilities included:

• Architectural design and development of the OLTP and Data Warehouse Logical/Physical database Schema’s and data dictionary documentation.
• Responsible for database management functions such as database backup/restore procedures and database tuning/optimization processes.
• Responsible for efficiency and development of Database Schemas, Stored Procedures, Triggers and Functions.
• Responsible for database upgrades: Database upgrades from SQL Server 2000 to SQL Server 2005 and associated conversion of (ETL) DTS packages to SSIS.
• Architectural design and development of the Extraction, Transformation and Loading (ETL) system using SSIS 2005. This process feeds our Business Intelligence reporting database.
• Responsible for information gathering and (ETL) migration process of data from and to our corporate accounting system using SSIS 2005.
• Converted all financial and inventory reports from Active Report to SSRS. Also responsible for the design and development of additional reports using SQL Server Reporting Services.

Confidential, 2001 - 2005

Position: Project Manager (Strong Matrix Organization)

Q-Tel Rehabilitation Management System is a shrink rapped application. A-Tel RMS is a class 3 rehabilitation medical data entry and ECG monitoring system. Q-Tel RMS uses a SQL Server 2000 backend with a Visual Basic front end. All critical ECG and real-time Hart monitoring code is written in C and C++. The Q-Tel RMS server base system is built on a Windows XP computer platform and ECG Patient monitoring devices were vendor created firmware.

Primary responsibilities included:

• Personnel budgeting and costs responsibilities related to Q-Tel RMS. This included developer reviews and salary recommendation, and projecting project staffing requirements.
• Set Project work plan, estimates and milestones using Agile methodologies.
• Create and maintain Project schedules in Microsoft project.
• Staff Management of C++, VB, DBA and XML/ASP developers.
• Coordination of development enhancements and prioritization with Sales and Marketing Product Managers.
• Evaluation of external vendors as it related to the Q-Tel RMS application.
• Work with Customer Service Managers to provide routine procedures for product trouble shooting and enhanced development support when needed.
• Work with Quality Assurance Managers to coordinate development schedules, incorporate integrated QA, enhance procedures and set expectations.
• Visit client sites to ensure product satisfaction and obtain customer feedback for future product enhancements.
• Research new technologies for product improvements and lower cost of goods.

Position: Software Manager: Database and Business Objects

Primary responsibilities included:

• High level design overview and management of the database and middle tier Business Objects teams.
• Database design and architecture. This included the design, creation, coordination and optimization of:
• Database Schemas in Erwin.
• Stored Procedure, Trigger and Function creation and maintenance.
• Responsible for the accuracy of data being imported into and exported out of the database structures. This was accomplished through SQL Server SSIS and included data scrubbing, transformation and XML formatting. Import feeds were in XML and HL7 formats.

Confidential, 2000 - 2001

Position: Engineering Manager /Business Intelligence Analyst (Consultant)

The Wavelink.Net product incorporated customer and product account information as well as online internet software licensing and distribution. The Wavelink.Net project was designed to consolidate Wavelink’s disparate information systems into a centralized data repository for reporting and management purposes.

Primary responsibilities included:

• Management of Sr. Wavelink.Net development staff, which includes skills in C++, SQL Server technologies, ASP/HTML and Visual Basic web technologies.
• Architectural design and development of the OLTP Logical/Physical database Schema’s and data dictionary documentation. Design and documentation tool used is Embarcadero’s SQL Designer.
• Architectural design and development of the Extraction, Transformation and Loading (ETL) system using SQL Server DTS packages. This hourly update job transfers the Wavlink.Net transactional database data into the staging database for data scrubbing and then transferred into the Data Warehouse system.
• Architectural design and development of the Sales, Finance and Support/Knowledgebase OLAP Schema’s. This involved analyzing existing corporate information and reporting needs in order to assess the proper granularity levels of information. In addition it provided information necessary for the design and development of the dimension and fact table measures.
• Analysis, selection, and implementation of OLAP front end reporting tool (Knosys ProClarity Analytical Platform 4.0) and Sharepoint through SQL Server.
• Responsible for information gathering and (ETL) migration process of data from desperate legacy data systems into the new central corporate database structure of Wavelink.Net.

Confidential, 1998 - 2000

Position: Director Software Development

Web3000.com is an internet advertizing/Ad Networking product that attaches to an end users browser. The product serves up internet banner and popup advertisements. The Web3000 product also provides internet browser acceleration to the end users browser. The product manages customer account and Advertising campaign information. This information is stored in the customer management SQL Server 7 database system. Other transactional log information pertaining to number of Ad’s served and click through information is logged real-time and imported into the SQL Server 7 database through DTS packages. Nightly DTS packages aggregate and scrub the Ad and click through detail information into the Web3000 Data Warehouse reporting system.

Primary responsibilities included:

• Personnel budgeting and costs responsibilities related to Web3000 product development staff. This included developer reviews and salary recommendation, and projecting product development staffing requirements.
• Management of an 18 person development staff consisting of Project Management, C++, Database, ASP and Visual Basic development groups.
• Work with Quality Assurance Managers to coordinate development schedules, procedures and software quality expectations.
• Cross functional communication and coordination with the Sales, Marketing and QA departments.
• Setting the structure and vision for current and future architectural product designs.
• Create procedures in order to organized and manage the process to efficiently accept new product enhancement requests from the business units. This process then prioritized, scheduled and managed the workflow to complete these tasks via the various development units.

Position: Sr. Database Architect (DBA) /Internet Application Group Manager

Primary responsibilities included:

• Managed the database architecture/analyst team, ASP internet and Visual Basic developer teams.
• Creation of database schema’s, Stored Procedures, and Triggers.
• Creation and maintenance of the OLTP and OLAP SQL Server 7 database systems. This included the separation of the legacy database structure into distinct reporting and transactional databases. The OLTP database was designed and optimized for high transactional throughput and scalability. It currently handles 1.5 million transactions a day and 24 million advertising impression transactions daily.
• Design and development of all DTS packages for the purposes of importing and scrubbing advertizing and click through data into the OLTP system.
• Design and development of DTS packages for the purpose of aggregating transactional information through the staging database into the dimensional Data Warehouse reporting database.
• Creation and design of tabular Crystal Reports and Knosys Proclarity Dimensional reporting analysis system.
• Creation and maintenance of Backup, Restore and database tuning routines.

Confidential, 1997 - 1998

Position: BI System Architect (Principle Consultant)

Design and implementation of warehouse (Data Mart) project which entailed extracting data using Data Transformation Services (DTS) from two independent Oracle Manufacturing accounting databases. This included importing and massaging the data into a SQL Server 7 Dimensional Data Mart. Project also included the design and development of Intranet reporting and analysis program.

Primary responsibilities included:

• Design and creation of Staging and Dimensional database structures.
• Creation of scheduled extracts from the companies Oracle accounting databases into CSV format.
• Design and development of DTS routines to import CSV files into SQL Server Staging database. This included aggregation of data and DTS routines to load the Dimensional Data Mart database system.
• Design and development of ASP DHTML front end intranet GUI application using Visual Basic COM objects for the Business Rules and data access layer with Data Dynamics Dynacube as the front end report presentation tool.

Confidential, 1996 - 1997

Position: Lead Developer (Sr. Consultant)

Analysis and re-design the DCAC/MRM (Define and Control Aircraft Configuration/Manufacturing Resource Management) product. DCAC/MRM (Configurator) helps Boeing configuration engineers more accurately and efficiently configures the new airplanes operators purchase from Boeing. The Configurator reduces the complexity and length of defining the airplane configuration. The Configurator is designed to reduce the flow time to order an airplane including eliminating manual searches for information about airplane options. Configurator enables rapid analysis of all operator-ordered changes to ensure technical compatibility and completeness. The application allows the users to use Visio as the presentation layer to create workflow documents that contain many dependent workflow objects on them. This information is then dynamically stored in the SQL Server database. When a user calls up a Configurator document it then retrieves that information from SQL Server and re-populates the Visio diagram, subsequently all changes to the document are then saved and written back to the database.

Primary responsibilities included:

• Analyze and re-design a prototype Access 7.0 application to a production quality SQL Server 6.5, Visual Basic 5.0 and Visio application.
• Developed Stored Procedures, Views and Triggers in support of the Configurator Application.
• Design and development of middle tier data access layer through the use of Visual Basic 5.0 COM objects and ADO 2.0 as the Data Access layer.
• Development of routines to coordinate inflow and outflow of information from Visual Basic to Visio through OLE automation. These routines and Business Rules are the keys to the automation of document creation, maintenance and change management.
• Coordination of application enhancements and deliverables to the development team.

Confidential, 1995 - 1996

Position: Solution Architect/SQL Server DBA (Principle Consultant)

Quick View Reporting allows users to seamlessly retrieve up to date information on sales orders and order error’s broken out by Region, Sales Rep’s, Sales Groups, City, Part No and other user specified categories. The Quick View application allows users to pull up a list of possible reports and then fill in parameters that will be passed to SQL Server Stored Procedures for efficient data retrieval. The user also has the ability to further filter the report with additional report filter criteria. Reports can be displayed in both tabular and Graphical formats.

Primary responsibilities included:

• Gathered requirements and wrote functional specifications for the QuickView Application.
• Design and development of the supporting SQL Server 6.5 OLTP structure. This structure holds all the report and parameter information as well as user preferences.
• Creation of Batch import routines to load reporting information from Oracle source systems through BCP
• Creation of views and Stored Procedures in support of report information retrieval.
• Design and development of the QuickView reporting application using Visual Basic 5.0.
• Design and development of all reports using Crystal Report Pro 5.0.

Position: Lead 32 bit Visual Basic developer

Analyze and redesign the Air Touch Vissta Opec application. OPEC is a client/server application with an Oracle back end and a Visual Basic 5.0 front end running on Windows NT 4.0 workstations. Connectivity is done through Oracle Objects for OLE. The original application was written in Visual Basic 4.0 and the performance of the application made it unusable. I was chartered with analyzing and redesigning the application in order increase application performance and maintainability. In order to achieve the performance necessary to satisfy the business users: It required a redesign of the applications middle tier code base and up converting the Visual Basic 4.0 16 bit application to a Visual Basic 5.0 32 bit application. This included the keeping the same application functionality while swapping in new 32 bit OCX controls for the out dated 16 bit controls.

Primary responsibilities included:

• Analyze current application and recommend a migration path from 16 bit Visual Basic 4.0 to 32 bit Visual Basic 5.0. This was needed mainly to bring the performance of the application up to customer standards.
• Selection and implementation of 3rd party application user interface components.
• Code rewrite of the Vissta Opec middle tier layer in order to increase performance.
• Responsible for creating a stabilized application with effective error handling routines.
• Responsible for the coordination between DB2/Oracle DBA’s and application calls to Oracle Packages through the use of PL/SQL.

Confidential, 1994 - 1995

Position: Solution Architect/Sr. Lead Developer (Consultant)

Designed and developed a reporting application using Microsoft’s Access as the front end import and reporting tool. Key features included the dynamic graphical selection of financial information as generated from the host accounting system. The system allowed the user to select desired criteria (i.e., months, amount classes, line items, etc.), dynamically extract and populate columns and generate calculations on the fly with optimum response time. The system allowed the end user to combine values together to formulate accounts for financial reporting.

Primary responsibilities included:

• Creation of automated import processes to extract and import DB2 mainframe account information into end user reporting database system.
• Design, development of customer interface to allow users the ability to manipulate and combine imported values into custom chart of accounts for reporting purposes. This included all data input screens and error routines developed using VBA code.
• Development of all financial reports using the Access end user reporting tool.

Position: Sr. Lead Developer

Responsible for the redesign and enhancement of a Windows based Journal Voucher Entry (“JV Entry”) application. JV Entry is a user-friendly Visual Basic accounting application that facilitates the journal entry process using a PC workstation. It enables remote offices to enter journal vouchers and export them to the mainframe computer.

JV Entry allows you to enter, edit, approve, export and upload journals on your PC during normal business hours. These journals, once uploaded, are processed by the nightly batch posting job stream on the mainframe. For added convenience JV Entry allows users to copy data from Excel spreadsheets or import CSV data files directly into the application.

Primary responsibilities included:

• Redesign and enhancements to JV Entry Included:
• Re-development of data access routines enabling JV Entry to operate more efficiently in a multi-user environment.
• Enhanced end user edit and validation routines.
• Improving error handling.
• Redesign of the database structure to include referential integrity.
• Creation of new screens for maintenance and administration purposes.
• Development of cloning functions based off of existing entries/templates.
• Developed reports using Crystal Reports Pro.

Confidential, 1993 - 1994

Position: Systems Analyst/Sr. Lead Developer (Consultant)

TRACM’s objective is to expedite customer transactions and increase the efficiency of the banks personnel. It Provides bank personnel the ability to accomplish: Fund transfers between accounts, customer account balance inquiries, place stop payments on checks, issue new checking and savings accounts, research customer account history, verification of deposits, change customer address, end of year 1099 forms.

TRACM “Total Relationship Activity Communication Manager” is a Client/Server application with a UNIX (Oracle) and DB2 Back end and a Visual Basic Front End. It does extensive 3270 screen scraping, retrieving and sending data to the host with HLLPI and WCL. Connectivity to Oracle is accomplished through ODBC, and Oracle Triggers, constraints, and stored procedures are used whenever possible to insure speed, consistency and data integrity.

Primary responsibilities:

• Management of a 5 person development team responsible for the design and creation of the TRACM application.
• Design and development of TRACM application middle tier Business Rules in Visual Basic which support the transfer of funds.
• Developed screen scraping routines, for retrieving and sending data to the host with HLLPI and WCL.
• Responsible for communication with the business units for prioritization of defects and enhancements.
• Development of all database ODBC routines to extract data from Oracle and DB2 in support of the TRACM application.
• Design and development of stored procedures which interfaced with the TRACM Visual Basic routines.

Confidential, 1991 - 1993

Position: Systems Analyst/Lead Developer

Designed, developed, and implemented a Marketing/Cost Accounting Information System in Microsoft Access and Visual Basic for a $10.5 Million Dollar Manufacturing Company. This program supports 482 products, runs over a 65 user (client/server) Novel Network and consists of three integrated modules: History/Forecasting, Pricing/Competitor Gross Reference and Warranty Returns Analysis.

Following are the 3 modules (by department / functionality) and how they benefited the company:

• History / Forecasting Module:

Provided a more accurate and efficient system of forecasting customer demand. This decreased end-item inventory costs by 20% while sales increased by 33% for the 1994 fiscal year.

• Pricing/Competitor Cross Reference Module:

Provided a consistent pricing policy based on minimum set profit margins and competitive forces of the market place.

• Warranty Returns Analysis Module:
• Analyzed product return ratios and established costs associated with return goods per product.

Other responsibilities included: Management of the Sales and Marketing Administrative Department. The main focus was to insure proper communication, training, and accurate flow of information between departments.