Ramon H. Venegas
Over 10 years of experience in Data Warehousing and Business Intelligence. Hands on responsibility for full SDLC using Oracle, MicroStrategy, Informatica, SAP BW.
Ø 2 years of SAP BW development including extractors, DSOs, Cubes and multiprovider developement.
Ø 3 years designing and coding ETL processes using Perl.
Ø 3 years of PeopleSoft HCM, EPM, and Student Administration development.
Ø 7 years of MicroStrategy installation, administration, project design, creating reports, documents and dashboards, distribution services, migrations, upgrades, security, user training, and design of star and snow flake schema, URL API, Command Manager, Object Manager, and Enterprise Manager.
Ø Fluent in Spanish and English.
BOSTON UNIVERSITY, Boston, MA - 2008 to
Senior Business Intelligence Developer.
Responsible for installation, administration, migration, object and project design, development, upgrades, and production support of several MicroStrategy 9.x applications for Student Life Cycle Analysis, including the design of Star/Snow-flake Schemas, data loading (ETL) using Perl, PL/SQL and Informatica. Performed user training and developed end user reports, documents and dashboards. Responsible for development and support of SAP BW 7.x data models for HCM and Grants Management, and for optimizing them for reporting using MicroStrategy and via SAP's BW BEx and SAP's portal.
· Extended and enhanced the Development and Alumni Relations MicroStrategy BI application.
· Designed and developed the Information Technology Services Project Portfolio Management MicroStrategy BI application.
· Designed and developed the Academic DW MicroStrategy BI application, currently with the Admissions and Registration modules.
· Implemented the BU MicroStrategy Self Service system to serve the Medical Campus and the Parking Office self-service BI needs.
· Designed and developed Grants Management MicroStrategy dashboards for BU Investigators using SAP BW data and authorizations.
Designed and developed the Student
Payroll financial data integration and reporting in SAP BW by creating an
automated process to import data from the external system to be blended with SAP
ERP payroll data.
BRANDEIS UNIVERSITY, Boston, MA - 2002-2008
Senior Data Warehouse Developer 2007-2008
Responsibilities included all those listed below under Technical Project Leader, in addition to analytical dashboards for HCM and enterprise data standardization.
· Designed and developed the Recruitment & Admissions MicroStrategy BI application.
· Designed and developed the International Student Office MicroStrategy BI application.
· Designed and developed the ETL for Graduate Admissions.
· Designed and developed a Workforce Performance MicroStrategy dashboard.
· Wrote or re-wrote numerous SQR programs for PeopleSoft HCM and Financials with many performance optimizations.
Technical Project Leader - 2002-2007
Single technical resource responsible for
project and object design, development, training, administration, migrations,
upgrades and production support of all MicroStrategy Business Intelligence
solutions and integration with PeopleSoft's EPM, SA, HR, FIN, including ETL
work using Perl, PL/SQL, Informatica and DataStage. Responsible for MicroStrategy installation, customization, upgrades and report development.
NORTHEASTERN UNIVERSITY Boston, MA - 1996-2002
Director of Enterprise Application Development Services (2001-2002)
Management of project and application development and production support with a staff of 13. Applications included PeopleSoft HR and Advancement, Student Web Self-Service using WebSphere, DB2 and Versata - Java J2EE, and Workgroup/Email/Scheduling applications using IBM Domino.
Director of Enterprise Application Services - 2000-2001
Led project teams to create and administer PeopleSoft enterprise applications. Provided technical leadership from design to production support, with a staff of 23 in addition to project personnel. Applications included PeopleSoft HR and PeopleSoft Advancement.
Associate Director for Business Applications - 1999-2000
Responsible for PeopleSoft development and production support (with a staff of 8), including People Soft HR and PeopleSoft Advancement.
Client/Server Applications Architect -1996-1999
Technical evaluation and implementation of PeopleSoft Public Sector products for Student Information and Human Resources. Reponsible for the design and development of a PeopleSoft SDLC application using PeopleTools and HCCC/Harvest version control system.
M.S., Information Systems/Operations Research, NORTHEASTERN UNIVERSITY, Boston, MA
Thesis: Estimating the Pure Premium Distribution of an Electric
Power Plant Using Simulation on a Microcomputer.
B.S., Nuclear Engineering, UNIVERSITY OF FLORIDA, Gainesville, FL
Double major in Nuclear and Mechanical Engineering.
SAP BW: BW310 - Enterprise Data Warehousing, SAP Education.
ITIL v3. Foundation: certification by Loyalist Certification Services.
MicroStrategy: Engine Tuning Track, Report Developer Track, Architect: Project Design, and Administration, Engine Essentials, Engine Tuning & VLDB Properties, Enterprise Manager, Report Services, MicroStrategy Corp.
Application Developer Certificate - Introduction to Oracle SQL, SQL*Plus, and
PL/SQL; Administer Database I; Develop Complex Queries; Develop Applications
Using Database procedures; Developing Complex Data Models and Design Databases;
Tune ORACLE Applications. ORACLE Corporation Education.
IBM Ascential: Data Stage, and DataStage Server essentials, IBM Education.
PeopleSoft: PeopleTools I
and II, PeopleCode, Process Scheduler, Business Process Design, Web Client,
Configuration and Administration, and Application Engine/Mass Change/Import
Manager, Advanced Query, SQA for PeopleTools, Data Management Tools,
Fundamentals. IBM Global Services.
Sybase 11: Fast track to System 11; Advanced Stored Procedures; Advanced Transact-SQL. SYBASE Corporation Education.
Samples of my work are available at http://rvenegas.com/work.html