133 viewsjobseeker
Francis M. — Senior Business Intelligence Developer from Philippines

Francis M.

Senior Business Intelligence Developer

Philippines 6+ years
Open to offersNew to Platform
Video Introduction
No video introduction yet
The candidate has not added a video.
Contact information and social networks are private. Connect to unlock.
Hidden

About

Francis M. is a seasoned BI Developer with extensive expertise in mortgage insurance, manufacturing, pharmaceuticals, and information technology industries. At Arch Global Services Inc, Francis supports both onshore and offshore teams, handling Cognos Analytics development, Power BI dashboards, and SSIS (ETL) tasks while maintaining and upgrading systems for Mortgage Risk Transfer, Underwriting Operations, Claims, Sales, and more. His tenure in Singapore with Shell Infotech and Optimum Solutions involved advanced Cognos report and cube development for clients like Panasonic and Boehringer-Ingelheim, emphasizing data mart design and server administration. Earlier roles included business intelligence consulting, software development with Deltek, and technical associate responsibilities involving payroll system customization. Francis holds a Bachelor’s in Computer Engineering from the University of San Carlos.

Experience

  • BI Developer

    Arch Global Services Inc · 2018 — Present
    Handled development, installation, configuration, and upgrade of Cognos Analytics (v11). Created and maintained Cognos 10.2 reports utilizing SQL datasource for Mortgage Risk Transfer (MRT), Underwriting Operations, Claims and Delinquencies, and Sales systems. Provided consultation and support on Cognos for both onshore and offshore teams. Managed installation and configuration of Cognos v11 development servers with LDAP and Single Sign On. Enhanced Power BI dashboards and developed SSIS ETL tasks.
  • Senior Cognos Developer

    Shell Infotech · 2013 — 2016
    Performed production environment administration for Cognos server and related reports for Panasonic Singapore. Developed Cognos 10.2 reports, managed Framework Manager Modeling, designed Transformer Cubes, and acted as Cognos administrator for PISCAP. Reorganized server security, conducted server maintenance on Linux, addressed user bug fixes, and performed SQL performance tuning and data analysis with Oracle database.
  • Cognos Consultant

    Optimum Solutions · 2012 — 2013
    Delivered Cognos 10.2 report development, Framework Manager model design, and datamart architecture for Boehringer-Ingelheim in Vietnam, Philippines, and Middle East. Executed data warehouse analysis, supported ETL, and produced reports compatible with Cognos Mobile/iPad. Handled data analysis and verification using Oracle.
  • Cognos Consultant

    Hypercube Consulting · 2011 — 2012
    Worked on Cognos 10 report development for projects in China and Korea. Analyzed Cognos Transformer Cubes, created Framework Manager models, and generated reports in Report Studio, Query Studio, and Analysis Studio. Conducted data analysis and verification with Oracle 10g.
  • Freelance Developer

    null · 2009 — 2011
    Completed website development using HTML and CSS. Accepted computer encoding assignments while attending graduate studies.
  • Business Intelligence Consultant

    Ventus Global Pte Ltd · 2008 — 2009
    Provided Cognos development and support services to Ventus-Global clients. Upgraded Cognos 8.2 to 8.4, resolved issues in reports post-upgrade, and developed new Cognos 8.4 sales reports and dashboards. Delivered report development for Merial Korea package using Cognos 8.2.
  • Senior Systems Analyst

    Satyam Computer Services Ltd · 2007 — 2008
    Supported, developed, and consulted on projects using PL/SQL and Cognos ReportNet. Led project teams, executed SQL scripting, and handled Cognos Framework Manager and report upgrades. Conducted analysis and report implementation for clients in finance and banking sectors, and verified data integrity.
  • Software Developer II

    Deltek Systems Philippines Ltd. · 2003 — 2007
    Performed data analysis, report writing, and catalog design using Cognos Impromptu and Cognos ReportNet for Costpoint, Time Collection, and GCS Premiere software. Upgraded reports to newer Cognos versions, developed automated report deployment scripts in Java, and managed catalog repairs and data verification using PL/SQL.
  • Technical Associate (Programmer)

    Corporate Information Solutions · 2000 — 2002
    Maintained and customized Peoplelinks Payroll Management System through Powerbuilder and PL/SQL. Supported payroll system implementation, resolved database issues, and stabilized system functionality for client users.

Skills & Expertise

Education

  • Bachelor of Science in Computer Engineering
    University of San Carlos · 1991 — 1996