Gian Puma Email & Phone Number

Northgate, Sa, Au

Adelaide

Develop integrations between business systems such as D365FO, D365CRM/CE and SAP Success Factors using Azure Integration Services. Integrations are built using the publisher/subscriber model. In addition, development of data pipelines for ETL processing of data into data lakes. This involved the following technologies:Source and Target Systems:- D365 Finance and Operations, D365 CRM, SAP Success Factors, SAP Litmos, and a series of on-premises systems.Integration Tools:- Standard Logic Apps to orchestrate workflows.- Function Apps to perform complex transformations.- Azure Service Bus and Event Grids to publish messages into topics/subscriptions.- Other Azure services such as: Azure Key Vault, Azure Storage Accounts (containers and table storage), Azure Application Insights.Data Engendering Tools:- MS Synapse, pipelines, spark notebooks, python and spark data frames.APIs:- MS Graph APIs for retrieval of MS EntraID users, groups and memberships.- D365 Dataverse APIs for integration of D365 CRM/CE with other business systems.- D365 FO oData APIs for integration of employees, positions, roles and position hierarchies into the ERP system.- D365 FO Data Management Module asynchronous APIs for accounts receivables, accounts payables, general ledger journal and purchase orders file-based integrations.- SAP Success Factors oData APIs. SAP Litmos APIs.Other- Azure Entra ID and D365FO app registry to authorize integrations solutions to access APIs.- Document integrations in Azure Devops Wiki.- MS Dataverse: creation and configuration of tables, columns, relationships, business rules, views and forms.- MS Power Apps / MS Power Automate: development of model driven apps and canvas app with associated workflows for custom MS Dataverse entities

Adelaide, South Australia, Australia

Adelaide, South Australia, Australia

Adelaide, Australia

Adelaide

Responsibilities- Ensuring integrity of financial systems- Designing and managing quality/integrity checking systems and processes to ensure all financial information is accurate between systems- Systems automation- Identifying and streamlining processes- Provide oversight of the chart of accounts- ERP implementation and system administration- Reporting duties- Provide leadership from a systems accounting perspective- Provide advice and input to systems changes, implementations and enhancenments

Design and develop the financial data migration for the implementation of the RAMCO ERP system. Responsibilities included:- Analyse the financial information (accounts payables, accounts receivables and general ledger) in the legacy system- Develop SSIS packages to extract the data, apply the corresponding business rules and load the data into the new ERP system (RAMCO

Adelaide, Australia

o Responsibilities Design, maintain and improve the organizations Business Intelligence Platform: develop the BI road map to be implemented including: new features, implementation of new tools, infrastructure enhancements, hardware migrations, etc. Gain understanding of transactional systems and business processes: Acquiring an understanding of all transactional systems that feed the data warehouse such as ERP systems, CRM systems and payroll systems and the business processes that define the use of these systems Design and maintain the data warehouse database (MS SQL Server 2014): define schemas, views, store procedures, query performance tuning, metadata, etc. Design and maintain ETL procedures: Write ETL procedures using SSIS, defining package configuration, defining security, uploading ETL procedures to SQL Server. Design and maintain DataMart’s and cubes: Defining reporting multidimensional cubes across main subject areas. Defining measure groups, perspectives, upload cube to servers and set security.  Develop reports (SSRS): meet with stakeholders, elicit business requirements, develop reports and dashboards using multidimensional cubes and relational DW sources. Offer ideas on how best display information for user consumption. Define report security Data Governance: Scheduling data governance team meetings, setting meetings’ agenda, documenting reporting business rules defined, communicate decisions. Documentation: Document BI infrastructure at different levels: high level: for a bird view of the entire system; medium level: for a greater understanding of all the individual parts and detailed level: for a very technical explanation of the system.o Projects Design and develop a new BI infrastructure system Migrate BI infrastructure from 2005/2008 to 2012 and then to 2014 Promoted the creation of data governance team Develop set of Dashboard for KPI analysis

Adelaide, Australia

- Business Intelligence Duties: develop a reporting platform and a datawarehosue using a MS BI Stack (SQl Server 2008 R2, SSRS, SSIS, SSAS) and Cognos 10. Write sales reports, expense reports, financial reports and dashboards.- Systems Administrator Duties: for Active Directory and Exchange 2010. Duties include: Creating windows users, joining computers to the company domain, creating/sharing mailboxes, distribution list, redirecting emails and others.- Process Improvement Duties: Implementing an ERP system (Pronto ERP). Duties consisted in perform data conversion from legacy system to the new one, develop flowcharts for the company processes and general duties regarding the implementation of the system

Adelaide, Australia

- Business Intelligence Duties: Plan, design and develop the reporting infrastructure and the data warehouse. Analyze data sources, define business rules, write Extract, Transform and Load (ETL) procedures and write reports using Crystal Reports and Qlikview- Develop IT projects: Plan, design and develop in-house business solutions across the entire SDLC down to the coding of these solutions.Process Improvements: analyze current work processes and design solutions to stream line them.- Excel macro generation: Automation of excel spread sheets using VBA.Website Maintanance: Day to day general maintance of the company website. Apply Search Engine Optimization (SEO) techniques.- Write technical documents: such as project frameworks, business and solution requirement documents, user manuals and others

Acarigua, Venezuela

- Responsible for the entire accounting systems- Preparation of quaterly reports which included vertical and horizontal analysis of financial statements and the calculation of KPIs.- Streamline business processes

Bachelor'S Degree, Accounting

Bachelor'S Degree, Systems Analyst