Alexandre Frament
Business Analyst FI CO on SAP ECC 6 - BI Developer at Horiba Medical- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
HORIBA Scientific
-
Research Services
-
700 & Above Employee
-
Business Analyst FI CO on SAP ECC 6 - BI Developer
-
Jan 2014 - Present
SAP ECC 6- Master Data. Setting. Mass Data extraction, preparation and load. Interfaces Bapi.- Import Master Data with Yoursoft & LSMW.SAP FICO- Expert SAP CO certified.- User Exits. SPRO parameters. ABAP programming. Deep Debug Mode. - Transport Orders for Programs and Data.DWH - Datawarehouse- Creation of Datawarehouse on SQL Server 2012 : Tables, Views, Stored Procedures, Indexes- Batch Jobs on the SAP ETL called BODS and ODI (Oracle Data Integrator)- Creation of complex universes UNV and UNX- Creation of complex WEBI reports- Schedule and publication of mass WEBI reports.- Dynamic push of complex reports with dynamic Prompts and Parameters. Show less
-
-
Business Analyst on ERP MOVEX V10A - BI Developer - DWH Manager
-
Oct 2008 - Dec 2013
Expert in Finance, Accounting, Costing and Budgeting.- Implementation of new Movex V10A Modules : Budgets, Financial Consolidation. Internal Accounting, Reportings- Internal consultant / Instructor for modules AR, AP, GL, CA, RG, - Find, analyse and implement improvement in Data Management and business flows. Wide functional experience. I worked with all the Departments heads.BI Developer and DWH Manager :Creation of user-friendly Crystal Reports. Complex SQL queries and procedures. Complex Scheduled emails. Show less
-
-
-
HORIBA
-
Japan
-
Measuring and Control Instrument Manufacturing
-
400 - 500 Employee
-
BI Developer - DWH Manager - SQL Server IBM DB2, AS400 - RPG QUERY - ETL ODI Lotus Notes - LEI
-
Oct 2002 - Sep 2008
IBM AS400 platform / iSeries - Programming of Queries (WRKQRY, RUNQRY) and Scheduled Jobs (WRKJOBSCDE) - Programming of AS400 languages : SQL, RPG, Batch, JCL, Shell - Programming of Screens and new specific modules with GUI. - Automatic Mailling, Dataload Expert in 2 ETL : ODI (Oracle Data integrator) and LEI (Lotus Enterprise Integrator) - creation of jobs, scenarios, connectors, architecture. - import / export from / to DB2, SQL, Lotus Notes Domino, Txt, Csv files Reporting Tools : Crystal Report 10 and XI and Cognos BI - creation of complex reports - scheduling and mass mailing with dynamic recipients Lotus databases, applications, workflows : NSF, NTF, Agents. - development / maintenance. Show less
-
-
-
AtemisCloud
-
United States
-
Software Development
-
1 - 100 Employee
-
Co-founder of Web agency. Business Development. Team Management
-
Nov 1999 - Sep 2002
Co-founder of ATEMIS SA in Luxembourg and Manager of Warsaw Office. Web agency , VAR software reseller. Development of Workflow on Lotus Notes. Web agency : - creation of dynamic web sites (ASP pages, Java Script, SQL Server). Extranet and Intranet. - recruitment and management : 2 salespeople, 1 commercial assistant, 2 graphists, 2 developers Reseller / integrator - BO Business Objects. Lotus Notes, MediaApps Portal. EDI solutions. Various Web sites, for ROCHE. SG. CARREFOUR. CREDIT LYONNAIS. BOSCH Show less
-
-
-
Bosch Braking Systems Europe
-
Paris, France & Wroclaw, Poland
-
Plant and Country Controller
-
Oct 1995 - Oct 1999
Controller of the plant : 600 Workers. 20 Millions brakes / year. - Creation of the position. Full integration. I learned to speak Polish fluently. - Procedures. Tools. Implementation of SAP R3 for FI, CO, SD - Budget, Forecasts, Costs, Opex & Capex monitoring. - Adhoc analysis (cost reduction, production investments). - Monthly Legal and HQ Financial statements : P&L, Balance Sheet, Cash Flow. Accruals. Management Fees. - I developed complex simulations on SQL and Excel tools. I modelized all the Financial and Physical Flows from high target budgets thru BOM and routings to Analytical costs) - I worked with all the Departments heads and projects managers. Show less
-
-
Education
-
Ecole supérieure de Commerce de Toulouse / ESC Toulouse
Gestion Finance Systèmes d'information -
University of Central Lancashire
BSc in Computer Science, Algorithmique, Programmation C, Pascal, Shell, Unix, SGBDR Oracle