Ramon Venegas
781-***-**** **.**.****@*****.***
Work Samples - https://www.rvenegas.com/work.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 development, MicroStrategy dashboards using BW MDX data sources.
3 years designing and coding ETL processes using Perl.
3 years of PeopleSoft HCM, EPM, and Student Administration development.
12 years of MicroStrategy installation, administration, project design, creating reports, documents and dashboards, distribution services, migrations, upgrades, security, user training, and design of star and snowflake schema, URL API, Command Manager, Object Manager, Usher, and Enterprise Manager, Windows, Unix, Linux, AWS.
Prepared and delivered end user MicroStrategy training for the past 10yrs and 4 yrs experience teaching undergraduate and graduate level courses at Northeastern University, Boston.
Fluent in Spanish and English.
EXPERIENCE
IntelliCog Inc., Culpeper, VA – 2014 - Present
Senior Business Intelligence Developer/Administrator.
• Expert in the MSTR BI Stack – Projects (logical models/schema objects), Intelligent Cubes, Reports, Documents, Visual Insight, Dossiers, Security Filters, Security Groups, Mobile and 3rd party integration.
• Responsible for BI development efforts (coding/configuration/ maintenance/installation, testing, debugging) and technical documentation. Perform code reviews and follows development best practices.
• Responsible for administration of the BI application including user management & MSTR services/engine maintenance, and 2-factor authentication setup and configuration using Usher.
• Perform proof-of-concepts and demonstrate new capabilities benefiting our clients and advancing our product strategy.
• Provide dashboard visualization expertise, create visualization library and visualization best practices.
• Proactively communicate development status, issues and concerns to management with risk mitigation recommendations.
• Troubleshoot MSTR application issues internally and with vendor.
• Perform user & account administration; demonstrate deep knowledge of license types and privileges to support end user needs.
• Design and develop semantic layer deliveries for end user effectiveness, specifically performance and use case compatibility.
• Partner with internal and external customers & Power Users to resolve issues or problems quickly; drive design and implementation of self-service support system.
• Provide direction and support and assists in the training of less experienced staff to orient them and increase their understanding of more complex MSTR development.
• Responsible for assessing, planning and installing upgrades, both software, and hardware-based, including impact analysis and/or building prototype(s).
• Monitor platform performance and identify obstacles to scalability; communicate requirements and partner with the Infrastructure team, ensure requirements are met by hardware and OS configuration provided. TrialCard Inc, Cary, NC – 2014.
Senior Business Intelligence Developer/Administrator.
• Expert in the MSTR BI Stack – Projects (logical models/schema objects), Intelligent Cubes, Reports, Documents, Visual Insight, Mobile and 3rd party integration.
• Responsible for BI development efforts (coding/configuration/ maintenance/installation, testing, debugging) and RAMON H. VENEGAS
2
technical documentation. Perform code reviews and follow development best practices.
• Responsible for administration of the BI application including user management & MSTR services/engine maintenance.
• Perform proof-of-concepts and demonstrate new capabilities benefiting our clients and advancing our product strategy.
• Provide dashboard visualization expertise; create visualization library and visualization best practices.
• Proactively communicate development status, issues and concerns to management with risk mitigation recommendations.
• Troubleshoot MSTR application issues internally and with vendor.
• Perform user & account administration; demonstrate deep knowledge of license types and privileges to support end user needs.
• Design and develop semantic layer deliveries for end user effectiveness; specifically performance and use case compatibility.
• Partner with internal and external customers & Power Users to resolve issues or problems quickly; drive design and implementation of self-service support system.
• Provide direction and support and assist in the training of less experienced staff to orient them and increase their understanding of more complex MSTR development.
• Responsible for assessing and planning for upgrades, both software, and hardware-based, including impact analysis and/or building prototype(s).
• Monitor platform performance and identify obstacles to scalability; communicate requirements and partner with the Infrastructure team, ensure requirements are met by hardware and OS configuration provided. BOSTON UNIVERSITY, Boston, MA - 2008 - 2014.
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/Snowflake 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. RAMON H. VENEGAS
3
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. Responsible 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.
RAMON H. VENEGAS
4