KAREM AGUILAR MARCANO **** EMERALD WINDS CIR
FL *3473
**********@*******.***
SUMMARY
I am a 16 years experience Information Technology professional graduated as System Engineer from Metropolitana University, one of the most prestigious engineering universities in my origin country. During my career I have been involved in over 30 software/technology projects working with several technologies, however I have specialized myself in Business Intelligence, counting with 10 years of experience in this field and with solid understanding of decision support systems.
I have mastered the processes related to data warehousing and business Intelligence, like data and multidimensional modeling, ETL, report design, dashboard creation and performance management. All the projects I have been involved in areas such like Financial Planning, Inventory and Financial KPI’s have made me be passionate about technologies that add great strategic, tactical and operational value to the organizations I work for.
My main strength is the way I engage with final users of the systems who work in the business. This allows me to fully understand their needs and to translate them into deliverable features. This strong engagement has driven great success in the majority of the projects I have been part of. I am able to manage technology projects from start to end, and I can adapt to any work environment and team.
I look forward to keep providing value to any organization thru my knowledge and expertise on Business Intelligence, reducing costs and maximizing accuracy of data.
EDUCATION
Systems Engineer May 1988 – May 1993
Universidad Metropolitana, Caracas, Venezuela
Studies focused in software engineering, optimization and information technology applied to business. Internship held in Venezuelan official oil company – a Fortune 500 organization. Graduation thesis was on project management.
EXPERIENCE
Project Leader August 2008 – Present
Cipher Business Solutions, Miami, Florida
Business Intelligence Consulting Firm
Acted as consultant and leader on several BI projects. Created demo Financial Consolidations, Sales and Budgeting BI demos to drive international sales in Latin America. Helped international customers to support their actual infrastructure.
Relevant Projects • Sales Affiliate Plan System for HBO LAG – HBO Latin America
• Budgeting System, Bear Mountain – Canadian Hotel
• Personnel Cost Budgeting, JVS – Jewish NGO
Consulting Services Manager September 2004 – June 2007
Cipher Corporation, Caracas, Venezuela
Business Intelligence Consulting Firm
I was the leader of the service organization with 10 consultants reporting to me. Responsible for defining and implementing the consulting services strategy. Managed several BI projects from beginning to end. Drive further sales due to successful projects. Sustained great relationships with customers as evidenced 80%+ satisfaction rate in all projects. Defined for the first time in the organization clear productivity metrics to measure success of the business and consultants. Drove development of consultants, certifying 5 consultants in Microsoft Technologies. Achieved 75% usability of the practice, 5 points above target.
Relevant Projects • Financial Consolidation Vengas and Promigas – Prisma Energy subsidiaries
• Financial Consolidation Transbanca -
• BI platform improvement Biggot - BAT subsidiary
• BI platform improvement INLACA -
• BI platform improvement PAVECA -
.
Business Specialist November 2003 – August 2004
DB Access, Caracas, Venezuela
Information Technology Services Firm
Quality assurance of sale proposals achieving 25% attach rate. Involved in several BI projects, since analysis to deployment. Thru great engagement with customers, I achieved 85% satisfaction rates in the projects I participated on. Responsible for developer training toward CMM Level 2 certification, becoming the driver person of this achievement.
Relevant Projects • ETL model for SIGBANCA Business for Banesco, 2nd largest bank in Venezuela
Senior Consultant October 2001 – October 2003
Cipher Corporation, Caracas, Venezuela
Business Intelligence Consulting Firm
Started as consultant and promoted to Senior Consultant. Involved in every stage of BI several projects, from analysis, design and implementation of multidimensional model, ETL process, front end delivery and reporting generation. Designed KPI’s and dashboards required by customers to implement business performance management processes in several areas of the organization. Established great connection with customers, having 90%+ satisfaction rate. Projects objectives were achieved eliminating human error by 99% and reducing manual labor 95%. All projects I was involved were delivered on time.
Relevant Projects • WRAPPING MATERIAL , SUPLLY PLANNING multidimensional models for cost projection on cigarette packing - BAT
• KPI Management System CANTV, Venezuelan phone company
Project Leader October 1994– March 2001
KE Consultores, C.A., Caracas, Venezuela
Information Technology Services Firm
Started as software developer and I was promoted to Project Leader. Involved in over 10 software projects executing analysis, design, development and deployment phases. Implemented for the first time in the organization the process to measure customer satisfaction. Thru strong engagement with customers, projects met user’s needs and achieved over 90% of satisfaction rate. Led the most important projects as they represented over 50% of the revenue stream for the organization.
Relevant Projects • SEIF, Financial Consolidation for SIVENSA, top 20 company in Venezuela
• TRESYS, Packaged Treasury System deployed in DIRECT TV and INLACA
Technical Skills
ETL
Data Stage
SQL Server
Pentaho
OLAP Engine
Infor OLAP PM
Pilot
Analysis Services
BPC
Front End
Excel
Pilot
Infor Office Plus
Reporting
Reporting Services
Crystal Reports
Pentaho
Infor Application Studio
Performance Management
SAP Strategy Management
Applications
Consolidation
Modeling
Visio
Soft Skills
Management
Project Management
Requirement Analysis
Team Work
User Engagement