Larry Francisco

• Lead end-to-end BI implementations across retail, pharma, insurance, banking, and telecom (e.g., Farmatodo, Novartis, Sanofi Aventis, Mapfre, Sudeban, CANTV) from requirements through rollout and enablement. • Architect and administer IBM Cognos BI/Analytics (v8.4–11), including installation, configuration, security, and governance across multi-environment deployments. • Developed and delivered reports and dashboards utilizing legacy IBM Cognos suite (Report Studio and Analysis Studio) across relational and OLAP data sources. Built data models in Framework Manager and created Transformer cubes, strictly adhering to the Ralph Kimball dimensional modeling methodology (star schemas, conformed dimensions, Slowly Changing Dimensions, and integrated data marts). • Implement enterprise planning solutions: install/support Cognos Planning (v8.4, 10.1) and IBM TM1/Planning Analytics (v10.2, v11); develop TM1 models for sales, HR, and expense budgeting/forecasting (Novartis, Metropolitan Distributors, Masisa). • Develop SQL Server data warehouses and ETL pipelines to integrate sources and optimize analytic performance (Materiales Los Andes, Metropolitan Distributors, Farmatodo). • Deliver instructor-led training on Report Studio, Framework Manager, Transformer, Analysis Studio, Metrics Studio, and Cognos Administration (v8, v10) to build client self‑service capability. • Manage the Sudeban currency redenomination initiative, updating ETL, models/cubes, and reports/dashboards to ensure regulatory compliance and uninterrupted reporting.

• Designed and developed applications for 3G handsets, ensuring performance and compatibility. • Collaborated with product and carrier teams to align on project goals and deliverables. • Refactored legacy modules to enhance application stability and implemented automated builds. • Established basic unit tests to streamline release processes and improve quality assurance.

• Developed engaging educational software and games tailored for students at CBIT learning centers. • Designed a comprehensive database model to efficiently register and analyze survey data from public schools. • Collaborated with educators to ensure software met learning objectives and enhanced student engagement.

• Planned and delivered the PostgreSQL data model and deployment for the Renadit platform. • Owned the development and maintenance of an employee access-control solution, enhancing reliability and security. • Collaborated with cross-functional teams to ensure project alignment and successful implementation.

• Developed BREW-based applications for third-generation mobile devices, overseeing requirements, implementation, and testing. • Optimized code to enhance performance and user experience on constrained device resources. • Collaborated with cross-functional teams to deliver high-quality mobile applications at 3G Data Soluciones in Caracas.

Built a Visual Basic tool to query the Telcel Traffic department’s Oracle database and generate reports.