Ramon H. Venegas

2313 Stearns Hill Rd, Waltham, MA 02451 (617) 590-7588 dw.bi.devl@gmail.com http://www.rvenegas.com/resume.html


SUMMARY

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.

 

PROFESSIONAL EXPERIENCE

BOSTON UNIVERSITY, Boston, MA - 2008 to present.
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.

Projects:

         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.

Projects:

         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.

 

EDUCATION

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.

 

PROFESSIONAL TRAINING

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.

ORACLE: Master 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, SQL/SQR. PeopleSoft Education Services.

DB2/UDB: Family 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