Jerome P.

Led the design and development of Power BI dashboards tailored to commercial, operational, and R&D performance within the pharmaceutical industry.

Engineered optimized data models using PostgreSQL and Power BI, applying star schema design, DAX performance tuning, and query folding techniques to ensure speed and scalability. Automating tasks and workflows using Power Automate and Power Apps.

Applied data engineering best practices to build reliable, auditable data pipelines that unified siloed clinical, sales, and supply chain data.

Ensured alignment with BI best practices, emphasizing data integrity, user-centric design, and governance standards to deliver actionable insights to stakeholders.

Collaborated closely with data scientists, analysts, and pharma domain experts to translate complex requirements into measurable analytics outcomes.

Developed and maintained advanced data analytics dashboards using Qlik Sense and Power BI, enabling real-time insights and strategic decision-making across financial product lines.

Designed and implemented intelligent deep-dive analytics solutions to uncover customer behavior patterns, transaction anomalies, and revenue growth opportunities.

Leveraged Python for data transformation, automation, and custom analytics modeling, integrating with internal APIs and external financial data sources.

Built scalable data pipelines using Azure Data Factory (ADF) to ingest, clean, and orchestrate large datasets across cloud and on-prem environments.

Collaborated with cross-functional teams including product, engineering, and compliance to translate business needs into data-driven solutions.

Implemented role-based access and security governance through Azure Active Directory, ensuring secure and compliant data access across platforms.

• Organisaation tiedonhallinnan ja data-analytiikan valvonta.
• Tieto- ja informaatiostrategian johtaminen yhdessä toimitusjohtajan, teknologiajohtajan ja operatiivisen johtajan kanssa.
• Palkittu organisaation parhaiten johdettuna tiiminä ja menestyneimpänä osastona – saavutti ja ylitti tavoitteet kahden vuoden ajan.

Cipla is a leading global pharmaceutical company.

• Oversaw the organization’s maturity for data analytics and digital transformation.

• Implemented SSRS/SSIS solutions for data migration from tools like SAP, and reporting.

• Introduced intelligent reporting to establish mobile reporting, ease of use analytics, self-service BI, risk analytics, executive reporting, budgeting and forecasting.

• Introduced the following: data governance, risk mitigation factors, industry standards and practices such as code reviews, scrums, agile framework, business gathering processes, cloud-based solutions, machine learning solutions.

• Undertook ownership of the BI landscape from SQL Server VMs, instances, reporting servers, applications, reloads and maintenance, BI roadmap, etc.

• Managed several projects (ML, AI, Robotics, BI, DW) comprising of R30m over my tenure and successfully delivered all projects timeously during the pandemic.

• Konsultoinut muun muassa seuraavia yrityksiä: Morgan Stanley (UK), IUA (SA), SPAR Group Ltd. (SA), TECOM Dubai (UAE), Adapt IT (SA), etc.
• Toteuttanut Power BI -palveluja Azuressa, paikallisissa palveluissa ja muissa ratkaisuissa kuten SSRS, ETL-migraatiot ja OLAP-ratkaisut, kuten MDX ja taulukkomuotoiset ratkaisut.
• Luonut räätälöityjä ratkaisuja ja tekniikoita tietojen analysointiratkaisujen rakentamiseksi Exco- ja Manco-tiimeille.
• Luonut MS Azure -ohjelmassa koneoppimismalleja, joilla analysoidaan asiakkaiden ja tietojen osajoukkojen trendejä ja epälineaarisia malleja.

Provided enterprise analytics and reporting for a leading credit services provider.

• Introduced cost-saving BI solutions, replacing expensive licensed tools with custom-built dashboards.

• Led the implementation of self-service analytics, enabling departments to create their own insights and reducing BI bottlenecks.

• Delivered KPIs and in-depth analytics to executive and operational teams.

Keyrus delivers advanced BI solutions to Fortune 500 and global clients.

• Developed QlikView dashboards for Morgan Stanley using the DAR (Dashboard-Analytics-Reporting) framework.

• Automated reporting workflows using NPrinting and CIA Enterprise tools.

• Optimized backend processing with SQL Server and QlikView scripting to enhance report generation performance.

• Modeled data warehouses using Kimball methodology and tools such as Alteryx and Lavastorm.

• Kehittänyt SSRS-verkkoraportteja.
• SSRS:ää ja SQL Server 2008 R2:ta käyttävien sisäisten raporttien ja tietoon perustuvien tilausten johtaminen.
• Kehittänyt DTS- ja SSIS-paketteja ETL-tehtäviä varten.
• Kehittänyt ja ylläpitänyt intranetin SharePoint-portaalisivustoa.
• Luonut jäsenneltyjä ja hyvin porrastettuja SQL-tietovarastoja käyttämällä integroituja tietomallinnustekniikoita.
• Suorittanut päivittäisiä DW-poimintoja ja -latauksia OLAP-malleihin ja SQL Serverin OLTP-taulukoihin.