Data Warehouse Architect / Director

Nicholas Galemmo

Stevenson Ranch, CA ***** 661-***-**** ********@*****.***

Director – Data Warehousing/BI

Big Data Architect Enterprise Data Architect

Dedicated, knowledgeable Thought Leader in Big Data, Data Warehousing, and Business Intelligence. Proven track record creating and implementing powerful enterprise solutions for Fortune 500 companies. Excels at devising comprehensive strategic plans to support long-term business goals as well as immediate objectives. Fully understands how technology impacts the bottom line, and how effective data integration can improve business success.

Technologies

Database Systems: Oracle, SQL/Server, Netezza, Sybase, Gemstone, DB2, Teradata, Hive

Programming Languages: Java, Smalltalk, C, C++, COBOL, Visual Basic, Scala, Python

Programming Tools: DataStage, Informatica, DTS, SSIS

Query Tools: Cognos, Business Objects, Microstrategy, SAS, Tableau

Modeling Tools: ERWin, ER Studio, Rational Rose, UML

Operating Systems: Spark, Hadoop, Windows, HP/UX, Solaris, AIX, Unix, MVS, VMS, RSTS, MCP

Middleware: Content Integrator, CICS, MQ Series, CORBA, EDA/SQL

Applications: Oracle ERP, SAP BW, SAP (SD, FA, APO, MD), Siebel, Manugistics, Ross Systems, Command Data, MSA

Other: TCP/IP, HTML, XML

Professional Experience

AGINITY LLC, Evanston, IL (10/2010-8/2017)

Big Data Architect

Created Aginity AMP metadata repository, the core component of Aginity’s Data Warehousing/Analytics product, which transitioned the company from services to software, leading to a successful VC funding round. Directed enterprise-level Data Warehousing projects for major Fortune 100/500 clients.

Developed solution at one of the largest commercial Netezza installations containing worldwide retail sales data with a load volume of approximately 500,000,000 transaction lines per day.

oReduced load times by 80% or more by constructing warehouse model, advising on load processes, and researching and specifying AMP product improvements.

oBrainstormed strategy to support localized data sets and analytic environments against the global data set.

Recommended and implemented improved customer identification strategy for an international big-box retailer that eliminated information loss.

oImproved customer service by providing the ability to adjust marketing messages based on the level of certainty of customer identification.

oCompany stock price has increased 85% in the years following implementation, in part due to increased customer satisfaction.

Led integration of 8 third-party systems for a global beverage company’s on-line loyalty program, including mobile phone activity, geo-location, points redemption, and omni-channel marketing.

Devised analytic solution to evaluate member engagement and campaign effectiveness for Fortune 100 website.

Provided architectural guidance for a major data warehouse platform conversion from Sybase to Netezza at a major financial institution to better handle portfolio risk management.

Conducted data warehouse assessments and strategized roadmaps for multiple Fortune 500 clients.

Developed multi-system integration architecture to manage analytics for international warehouse retailer.

KAISER PERMANENTE, Pasadena, CA (2/2010-10/2010)

Consultant

Architected and designed comprehensive data warehouse solution for the facilities division.

SOUTHERN CALIFORNIA EDISON, Rosemead, CA (2/2009-2/2010)

IT Specialist – DW & BI

Recommended best practices and standards as internal consultant to various departments. As Technical Lead over project teams, implemented data warehouse and business intelligence solutions using Teradata and Oracle.

Delivered Business Objects solution to analyze and monitor work orders and projects.

Implemented data mart and Business Objects solution for Corporate HR to conduct workforce planning.

HEADSTRONG, Fairfax, VA (11/2005-11/2008)

Managing Consultant/Practice Lead

Oversaw Data Warehouse and Business Intelligence implementation projects. Built and maintained strong relationships with clients to effectively manage project scope and client expectations. Produced and presented business proposals, estimates, and contract proposals to assist in achieving sales targets for DW/BI practice. Managed offshore resources.

Designed and led development of a divisional data warehouse in Sybase and Informatica for a global financial services firm’s derivatives business.

Executed re-platform of OBIEE data warehouse from Oracle to Netezza for global materials company using OBIEE, Oracle, Netezza, and Informatica.

Developed enterprise data warehouse utilizing SQL Server and SSIS for a global fruit company.

Crafted reference data architecture and strategy for a major financial services firm.

Coached and mentored technical staff.

Previous Experience

Director, Technology, Architecture and Standards, EDMUNDS.COM, Santa Monica, CA

Director, Data Warehousing and Data Architecture, EDMUNDS.COM, Santa Monica, CA

Consultant, KAISER PERMANENTE, Pasadena, CA

Information Architect – Enterprise Data Warehouse, NESTLÉ USA, Glendale, CA

Senior Data Warehouse Consultant, ENTERWORKS, Pasadena, CA

Senior Systems Analyst – Decision Support Systems, HEALTH NET, Los Angeles, CA

IS Manager – Asphalt Division, CALMAT, Los Angeles, CA

Consultant, THE OHIO MATTRESS COMPANY, Cleveland, OH

Manager COMMAND Applications Support, PIONEER SOFTWARE PTY., Escondido, CA

Project Leader, Business Systems, BURROUGHS CORPORATION, San Diego, CA

Team Leader, Cable TV System Conversions, FIRST DATA RESOURCES, Omaha, NE

Manager of Systems & Programming, STATE UNIVERSITY OF NEW YORK, New Paltz, NY

Programmer/Analyst, STATE UNIVERSITY OF NEW YORK, New Paltz, NY

Professional Recognition

Co-Author of “Mastering Data Warehouse Design: Relational and Dimensional Techniques”

with Dr. Claudia Imhoff and Jonathan J. Geiger, published by John Wiley & Sons

IBM Redbooks Thought Leader – Big Data Analytics (2014)

Co-Inventor in Patent by Aegis Analytical Inc.

“System, method and computer program product for mapping data of multi-database origins” (US Patent 6,725,230)

Education

B.S. Computer Science – STATE UNIVERSITY OF NEW YORK AT PLATTSBURGH

M.S. Computer Science Candidate – UNION COLLEGE, Schenectady NY

Contact this candidate