Data Sales

Ron Keler

Newton, MA - 617-***-**** - ***.*****@***************.***

Blog: http://bihappyblog.com

SUMMARY

Over 20 years of experience delivering technology solutions that strengthen

core business competencies. Deep expertise and rich experience with data

integration and business intelligence implementations.

WORK EXPERIENCE

Cleartelligence, Inc 9/2011 - Current

Norton, MA: Business Intelligence and Data Integration consulting firm

PRINCIPAL ARCHITECT

Fortune 500 Technology firm:

. Install, configure and setup numerous SAP BusinessObjects 4.0 servers.

Setup clusters, federation, and high availability/high performance BI

systems, available on corporate intranet and world wide web for

commercial use

. Setup HANA databases, load data into HANA, design models and views,

expose HANA Data via BusinessObjects stack and HTML5 interfaces

. Design and implement traditional RDBMS data warehousing solutions,

including data modeling and architecture, data integration and quality

planning and implementation, ETL using PL/SQL and ETL tools

. Create SAP Business Objects universes, Xcelsius dashboards, web

intelligence reports and crystal reports to support commercial client

facing internet based reporting portal

. Integrate business objects content into external portal using business

objects java SDKs, leverage enterprise SDK for security integration,

crystal RAS sdk for crystal report integration

. Provide team and management with best practices and approach related

to the business objects implementation and product integration

Corporate Technologies 4/2006 - 8/2011

Burlington, MA: An IT Consulting firm, specializing in data integration and

business intelligence solutions

PRINCIPAL ARCHITECT - DATA INTEGRATION - BUSINESS INTELLIGENCE

. Lead enterprise data integration projects, envision business solution,

formulate and implement enterprise data architecture and strategy.

. Develop data warehouses, marts and solve highly complex data issues by

applying data warehousing best-practices as well as "out-of-the-box"

thinking. Use ETL tools, reporting tools, dashboarding and data

visualization tools, olap, modeling tools and uml designs to create BI

solutions.

. Create BI applications, information portals, executive dashboards and

reports, used for operational, analytical and management needs. Work

with executives, managers and business teams members to understand

needs and apply appropriate BI solutions.

. Architect and act as the key developer, delivering core project

components and mentoring clients and team members with all aspects of

the BI implementation. Including data modeling, ETL and data

architecture, meta data management, master data management, data

quality, BI applications development, dashboards and reports

development.

. Develop corporate policies and Business Intelligence governance

policies to address information ownership, enrichment, security,

quality and management across the enterprise. Champion and foster

solution adoption, provide training, technical documentation, manuals,

marketing materials, and more

Projects worked on:

Supply chain software company

Designed commercial BI application for company's clients. Product was

designed for hosted and on-site installations. Including reporting database

(data warehouse) solution, ETL, metadata layer, reports sophisticated, near

real-time BI dashboard application.

World largest clinical trials management company

Implemented and lead several BI applications projects. Projects included

data warehousing, ETL, meta data and BI application design. Applications

used by tens of thousands of employees across the world as well as external

clients.

Global Biopharmaceutical company

Implemented and lead several BI projects related to facility management,

commercial operations and financial operations. Projects included data

warehousing solutions, meta data solutions, dashboarding and reporting in a

complex, highly regulated environment.

Global marketing consortium: world's second largest media counsel and

buying group

Created a global financial dashboard, used to consolidate hundreds of

reporting entities across tens of companies around the globe. Dashboard

includes complex financial metrics, drill downs and forecasting

information, displayed in an intuitive and visually stunning fashion.

Global major consulting firm

Created an enterprise reporting solution for financial analysis and

planning. Enhance enterprise data warehousing architecture and create a new

reporting system to provide pipeline and forecasting, profit and loss and

utilization information.

Major online gaming company

Created an enterprise reporting solution for an online gaming company.

Solution included aggregate driven meta data layer to allow ad-hoc analysis

and reporting on a data warehouse with terabytes of data in transactional

factual data in near real time manner.

Medical records management company

Replaced existing Hyperion financials reporting system with business

objects based solution. Design and implement enterprise security model for

report consumers across the country. Gather requirements, understand data

model, enhance existing model and produce key financial reporting in less

than a month. Mentor and lead report developers.

Online secure transactions provider

Created reporting data warehouse for secure financial transactions software

provider. Solution integrated Salesforce.com CRM data with finance data.

Provided historical pipeline analysis, opportunities to sales analysis,

sales people performance measurement and commissions calculations based on

a complex splits schema.

World leader in information management services

Created complex sales commissions and sales performance evaluation tool.

Translated dynamic sales commissions calculation logic to a repeatable and

programmable algorithm. Enhanced enterprise data warehouse architecture to

accommodate new reporting needs. Created a visually stunning, personalized

and secure reporting application to navigate, measure and analyze sales

team performance.

Clinical trials management company

Created reporting system for medical trials administration company.

Solution addressed Finance and Trials tracking reporting. Designed the meta

data layer for MS Dynamics ERP system. Solution provided GL reporting, AP,

AP and Project Accounting as well as detailed trials metrics and trials

analysis. Designed and implemented complex security model including row

level security. Enhanced business objects reporting tool capabilities by

writing custom java utility for linking reports.

Major financial staffing company

Created an executive dashboard and data warehouse for the Boston based

Fidelity owned staffing company. Solution included designing and creating

corporate data warehouse and an Executive Dashboard. Dashboard included

some 20 KPIs represented in a custom dashboarding application with

navigation, drills and data visualization components.

CRM software company

Designed and built commercial reporting solution including reporting

database, meta-data and reports. Replaced legacy oracle forms based

reporting tool. Re-organized transactional data across dimensional lines in

data marts and created reporting and delivery architecture for maintaining

and distributing reporting product for external customers on a hosted and

"behind-the-firewall".

Investor's Business Daily 5/2005 - 4/2006

Los Angeles, CA: A daily investment and financial analysis newspaper owned

by William O'Neil.

IT PROJECT MANAGER

. Managed the development of a $5M custom built SOA enterprise software

system used for e-commerce, CRM, subscriptions management, product

management and more.

. Oversaw Marketing Automation and Campaign Management software

implementation.

. Managed internal staff of 20, including contractors and third party

vendors, responsible for all aspects of the development cycle. Use

iterative modern agile methods.

. Responsible for recruiting, hiring and retaining programmers, database

administrators and other IT staff members.

. Managed the IT budget and procurement of software, hardware, services

and all other project materials.

. Worked with executives and staff from all departments as the project

champion to assure communication and successful adoption of software

projects.

Emptoris Inc 2002 - 4/2005 (3 years)

Burlington, MA: Emptoris offers supply chain management, spend management

and e-procurement software and services.

TECHNICAL LEAD - DATA ANALSYS

. Lead the design and implementation of multi-million web-based spend

management BI applications and Data Warehouses for Fortune 500

companies. Projects include News Corporation, Vodafone, Unilever,

Owens Corning, Royal Bank of Canada, and Cigna Healthcare. Application

used to analyze multi billion in spending.

. Architect data marts to help clients identify over $100M in hard

dollar savings through various tactical and strategic sourcing

opportunities.

. Lead teams of up to 12 analysts, on site and off shore, during

multiple parallel projects. Mentor, review and provide direction to

team members.

. Manage application data model and deployment, from pre-sale through

all life cycle stages. Used Prototyping and RAD to improve projects'

quality and schedule.

. Spearhead the design and implementation of enterprise meta-data driven

ETL tools to improve data exploration, manipulation, transformation

and enrichment. Code and create Prototypes, Use Cases, Class Diagrams

and other UML, ERD and OO designs.

Riverdeep- The Learning Company 1993- 2002 (9 years)

Cambridge, MA: Riverdeep provides comprehensive K-12 classroom e-Learning

solutions over the Internet and CD-ROM. Riverdeep acquired Logal Software

in 2000.

ENTERPRISE REPORTING MANAGER (2000- 2002)

. Managed Business Intelligence tools and Enterprise Reporting Portal,

providing users access to Data Warehouse and e-Commerce systems.

. Coordinated teams of engineers, business analysts, and executives in

the implementation of a $1.5M Oracle Financials Applications ERP and

Data Warehouse.

. Built and oversaw web portals to provided management and staff access

to reports, lookups and analysis, including design, coding, testing,

maintenance and support.

. Provided e-Commerce and Web site analysis used for financial and

technical analysis. Website attracted over 1 Million users.

PRODUCT MANAGER (1998-2000)

Cambridge, MA

. Administered pilot program from beta stage to a flagship product

driving a $78M IPO. Product included 38 simulation based software

titles, delivered over the Internet.

. Coordinated teams of off shore developers in Israel and on site in the

US. Obtained, gathered and analyzed product feedback from clients'

sites.

. Headed customer support and services for Internet products and

provided implementation services for institutions. Built and lead a

successful sales support team of 6 members.

. Handled first, second and third level technical support to Internet

products suite.

SOFTWARE DEVELOPER (1996-1998)

Tel-Aviv, Israel

. Developed new Internet enabled technologies and products, the first in

the market to be fully Internet enabled. Used TCP/IP and HTTP to

deliver applications over the Internet. Created an Oracle Web server

and database driven application to manage users' portfolios.

. Developed three Educational Math software titles, using proprietary

scripting language. Contributed to the design, look and feel of entire

product suite.

OPERATIONS SPECIALIST, INTERNATIONAL LIAISON (1993-1996)

Cambridge, MA, Kiryat Shmona, Israel

. Streamlined communications between R&D teams in Israel and sales in

US. Established communications procedures, reports, and actively

encouraged information sharing between teams over seas.

. Strengthened and extended company investor and Board of Directors

relations, during an IPO.

. Administered company HR and daily operations issues, including

government regulatory reporting, manufacturing, and logistics.

EDUCATION

Bentley College, Waltham, MA.

. Masters of Science in Information Technology, May 2004. GPA: 3.7.

Graduated with Distinction.

University of Massachusetts, Lowell, MA.

. Bachelor of Liberal Arts, Psychology, August 2002. GPA: 3.7

COMPUTER PROFICIENCIES

Database: DBMS: Oracle/ MSSQL/ MySQL/kDB/Access, Toad

UML and CASE: Visio, Together Control Center

Scripting: JavaScript, ASP, VB Script, MS Visual Interdev

Reporting - Data Business Objects Enterprise XIR2/3.x, 4.0, Data

Mining: Integrator, Performance Management, Dashboard

Manager, Designer, Webi, LO, Xcelsius, Crystal

Reports, OBIEE, Oracle Discoverer, NetTracker

Programming: Java, J2EE, VB, Smart CSV, SQL

Web/App Servers: Jboss, Resin, Apache, ATG Dynamo, OWS, IIS

Project Management MS Project

LANGUAGES

Fluent in English & Hebrew.

INTERESTS

Cooking, Reading Fiction, American Films, Sci-Fi

Contact this candidate