Profileimage by Pietro Dallabetta ERP - sql developer - ETL - BI - CRM - BA - Visual studio from Trento

Pietro Dallabetta

available

Last update: 06.04.2016

ERP - sql developer - ETL - BI - CRM - BA - Visual studio

Company: DBMS
Graduation: BA Economics degree
Hourly-/Daily rates: show
Languages: English (Full Professional) | French (Elementary) | Italian (Native or Bilingual) | Spanish (Elementary)

Skills

ERP, Software Project Management, Visual Basic, Microsoft SQL Server, Software Development, SQL Server, Management Consulting, Business Intelligence, PowerBuilder, ASP, Software Design, Accounting, HTML, Project Management, Software Procurement, Office Automation, EAM, Management, Budgets, Financial Software Development, Budgeting, Business Analysis, Requirements Analysis, Change Management, Business Requirements, ETL, Business Intelligence Projects, CRM, Microsoft CRM, CRM Integration, Vtiger CRM

Project history

EXPERIENCE

Dynamic Business Management System Inc
Owner & Founder : IT freelances service company
03.1999 - today
Manage ICT company Business strategy activity – Partners & Contractors Agreement Management – Director of Business Analysis Department – Customers Change Management activity – Billing supervisor,

Innovative and result-driven leader focused on achieving exceptional result in highly competitive environments that demand continuous improvement. Experienced in driving product, process, and customer service improvements while building partnership with key business decision-makers. Known for building and motivating cross-functional team that exceed corporate expectations.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Contractor agreement @ Infor.com
BA/ERP/BI/ETL Project Manager & Developer
01.1999 - today
Collect requirements, analyze businesses and execute process workshops - Consult client to collect all relevant data for implementation - Implement and configure ERP application consulting customers - Provide post-sales support - Interact with AGILE teams of developers, offshore teams then monitor and tune performances - Prepare necessary project documentations associated with implementation like manuals, customer query data, issue logs and their resolution – Customize INFOR FM ERP application object oriented languages - ETL & BI projects MSSQL/ORACLE/SYBASE databases.

Technical and cultural skills in managing international projects . Best practice in Software Development Life Cycle. Self-Confident attitude in Change Management Advisor activities.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

CSC Consulting
Etl Developer
01.1998 - 12.1998
ETL & BI Developer in Finance applications in complex organisations.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Deloitte & Touche
Consultant
10.1993 - 01.1998
Help clients with human resources transformation and organizational change, including talent management, leadership development, learning and development - knowledge management - Advise companies on best human capital management practices – Manage & Teaching ICT courses funded by Social European Fund.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MAIN PROJECTS

Project @ Gruppo Demont
Project: Change Management Advisor & Business Analyst & ETL Architect
01.2010 - 2014
Change Management Advisor and Business Analyst in IT / HR / Finance / Procurement departments - Migration of 12 Group company. Project Manager & Scrum Master in ERP implementation Agile & Scrum oriented - building Enterprise Data warehouse, manage business intelligence application (BI).

Developer: managing ETL MSSQL activity connecting Financials & Procurement applications; creating T-SQL stored procedures & full finance and accounts web & client-server interface into ERP environment.

-----------------------------------------------------------------------------------------

Project @ Eurointerim S.p.A.
Project: Change Management Advisor & Business Analyst & ETL Architect
02.2006 - today
Change Management Advisor and business analyst in IT / HR / Finance / Procurement departments. Application - Migration of 12 Group company. Project Manager & Scrum Master in ERP implementation Agile & Scrum oriented - building Enterprise Data warehouse, manage business intelligence application (BI).
Developer: managing ETL MSSQL/ORACLE activity connecting HR and GL applications; creating T-SQL stored procedures & full finance and accounts web & client-server interface into ERP environment

-----------------------------------------------------------------------------------------

Trento RISE
Project: Business Analyst & Product owner
08.2012 - 09.2013
Business Analyst focused on building Management information system (MIS) and realize central purchasing department system in order to simplify a procurement budget and keep the organization\'s spending in a centralized location.
Product Owner in implementing in house ERP procurement application. Tester: prototype and start-up pilot activity with the Stakeholders.

-----------------------------------------------------------------------------------------

Project @ Eni - Trans Tunisian Pipeline Company S.p.A.
Project: Business Analyst and ETL Architect
04.2011 - 08.2011
Business Architect. Experience using model-based representations that can be adjusted as required to collect, aggregate or disaggregate complex and conflicting information about the business.
ETL Architect delivering SQL based component to monitoring ETL process and measure system performance. Assists in troubleshooting system problems.

-----------------------------------------------------------------------------------------

Project @ Infor
Country Manager
01.2006 - 07.2011
Customer Portfolio Management and ERP projects manager of Morocco area.

-----------------------------------------------------------------------------------------

Project @ Ermenegildo Zegna Group
Project: ERP Systems Specialist & ETL senior developer
07.2010 - 02.2011
ERP Systems Specialist. Start up of EAM & Purchasing ERP application in 5 company: Turkey, Spain, Mexico, Italy and Switzerland. Mange Federal, State, and local laws and regulations related to confidentiality. Assists in the creation and updating of ERP system policies and procedures, business rules, end user desk aids, and training materials. Provides instruction, assistance, and support services to ERP System end-users.
ETL senior developer: syncro EAM and Financial Application into MSSQL; developing full finance and accounts T-SQL stored procedures into ERP application.

-----------------------------------------------------------------------------------------

Project @ Credit Suisse
Project: ERP Systems Specialist & Product Owner & ETL architect
06.2009 - 12.2010
Start up 5 legal entity fund control, purchasing, budget using Financial INFOR FM. Ensure that the client\'s requirements are met, the project is completed on time and within budget and that everyone else is doing their job properly and manage accounting, costing and billing.
ETL architect: synchronizing Budget-Procurement-Financial application in MSSQL environment; developing T-SQL stored procedures integrating ERP Modules.

-----------------------------------------------------------------------------------------

Project @ Rai - Pubblicità (Gruppo Rai)
Project: Business Analyst & Product Owner & PM & ERP Systems Specialist & ETL Architect
07.2004 - 11.2009
Business Analyst & Product Owner & PM & ERP Systems Specialist.
Helping businesses implement technology solutions in a cost-effective way by determining the projects requirements, communicating them clearly to all stakeholders, facilitators and partners. Interfacing with several scrum teams in developing ERP customization; Maintained project document and validate sprints delivery with keys users; Managed Budget SAL and Billing activities.
ETL Architect: synchronizing HR/Procurement/Financial applications in SYBASE/ORACLE Databases; developing SQL stored procedures for customizing ERP Modules; managing full finance and accounts web & client-server interface. BI senior developer: Provided technical and functional development of reporting solutions and data analysis on Procurement and Accounting applications on Cognos 7.x.

-----------------------------------------------------------------------------------------

Project @ Gruppo Falck S.p.A - Sadelmi
ERP Specialist
02.2008 - 05.2009
Redesigned processes for the acquisition and payment of goods and services in 5 legal entity.
Implemented Commitment and project management system.
Implementing and rolling out of SmartStream Financials (Ledger, Funds Control, Asset Management, Account Receivable and Project Modules).
Implementing and rolling out of SmartStream Procurement (Payables, Purchasing Modules, Requisition e HR Expenses Reimbursement).

-----------------------------------------------------------------------------------------

Project @ AttijariWafaBank
Project: Product Owner & PM & ERP Systems Specialis & BI senior developer
03.2006 - 06.2008
Product Owner & ERP Systems Specialist. Managed a scrum team of 5 developers in implementing SmartStream Payable / Purchases / Fund control modules and developing several software integration on the bank business applications. Provided Agile Business Analysis after every sprint activity; Project Manager: Accomplishes project objectives by planning and evaluating project activities; managed training activity and created key users documentation; Provided SLA, SAL and Billing of the projects.
BI Senior Developer: Provided technical and functional development of reporting solutions and data analysis on Budget-Procurement-Accounting application. Provided ETL activities.

-----------------------------------------------------------------------------------------

Project @ La Banque Postale
Project: ERP Specialist & ETL Developer
01.2004 - 05.2006
Implementing and rolling out of SmartStream account reconciliation, purchases , payables and assets modules. Created users and managers documents; managed training and user validation activities.

ETL Developer: synchronizing Accounting and Reconciliation applications in SYBASE/MMSQL Databases; developing SQL stored procedures for customizing ERP Modules in order to manage ‘Letterage’ process and Enterprise Workflow.

-----------------------------------------------------------------------------------------

Project @ MAAF
Project: ERP Specialist & ETL senior developer
06.2005 - 12.2005
Implemented and rolling out of payables, assets and purchase SmartStream module - created users and managers documents; managed training and user validation activities.

ETL Senior Developer: synchronizing Asset INFOR Application with Hyperion application in MSSQL Database; developing T-SQL stored procedures for integrating ERP Modules.

-----------------------------------------------------------------------------------------

Project @ Consorzio RFX Padova
Project: ERP Consultant
09.2003 - 08.2004
Design and implement ERP system.

-----------------------------------------------------------------------------------------

Project @ UniCredit
Project: ERP & ETL Developer
07.2003 - 01.2004
ETL developer: Created software interfaces between Billing & Receivables accounting records and assets into the ERP INFOR FM environment; created technical and end users documents - driven meeting with INFOR top manager at the end of every sprint.

-----------------------------------------------------------------------------------------

Project @ Carraro SpA
Project: Business Analyst & ERP Systems Specialist & ETL developer
0.1999 - 0.2003
Followed Start-up of 9 Italian company and 6 foreign group company (India, Argentina, Germany, Poland, United Sates, China). Defined Enterprise and business requirement of foreign companies; Managed Federal, State and local laws and regulations related to confidentiality; managed international fiscal rules IAS based; Implemented ERP system policies, procedures, business rules, end user desk aids, and training materials. Provides instruction, assistance, and support services to ERP System end-users.

ETL developer: synchronizing Legacy and INFOR FM in MSSQL/SYBASE/DB2 Database; created T-SQL stored procedures for customizing ERP Modules; managing full finance and accounts web & client-server interface.

-----------------------------------------------------------------------------------------

Project @ Trieste Trasporti
ERP Consultant
01.2001 - 08.2002
Implementing and rolling out of SmartStream (Ledger, Billing, Account Receivable, Asset Management, Payables )

-----------------------------------------------------------------------------------------

Project @ Gruppo Coin Spa
ERP Consultant & ETL Developer
01.1998 - 05.1999
Outsourcing Geac SCM and Management audit module. ETL & BI project between Finance application and GEAC Analysis Reporter using MSSQL stored procedures.

-----------------------------------------------------------------------------------------

 

Local Availability

Only available in these countries: Italy
All Europe countries starting for next month
Profileimage by Pietro Dallabetta ERP - sql developer - ETL - BI - CRM - BA - Visual studio from Trento ERP - sql developer - ETL - BI - CRM - BA - Visual studio
Register