IT Business Analyst (Information Technology Business Analyst)
Antaès
Total years of experience :24 years, 8 Months
For the leader of Swiss Luxury Watchmaking Industry (Rolex : 5 sites, and 4'000 users)
• Participated in the development of MES and QMS projects in the context of 4.0 Industry
• Wrote functional design documents to assist testing and development teams with implementation of client requirements
• Performed statistical and volumetric analyses
• Ran requirements workshops, client training sessions, UAT and final go-live assistance
• Collaborated in the implementation of SCRUM agile framework
• Participated in the evaluation and monitoring of risk management
• Wrote specs and managed tests on QC of ALM, and Jira / XRay / Confluence of Atlassian
• Wrote Automated tests (TXT / XML format) to support Continuous Integration process (Jenkis)
• Assured user's support on data process between PLM / SAP PP and BI / MES Apriso
• Solved issues' users in collaboration with development team
• Created training documentation for end users (Instant Producer - SAP)
• Developed and maintained Excel VBA tools multi-users
For the following customers: French Health National Agency, Chloé (Richemont), and many training companies (Orsys, Adiscos, Capital Formation, ICLG, Arkesys)
• Was support for a 2013 Office migration project (1000 users, over 150 VBA Excel and Access DB
• Was subcontractor of many training companies (Orsys, Adiscos, Capital Formation, ICLG, Arkesys)
• Organized and provided training sessions on PHP, Windows 7 and Office 2003 2013 (Outlook, Word, PowerPoint, Excel, Access, VBA, Power Pivot) in French and English
• Developed, created, and maintained training materials and exercises
• Managed customer relationship (prospect, billing, follow up)
For the following customers: Business Vision, French Institute of Madrid and Vatel School of Madrid
• Provided training sessions Word, Excel and Internet in Spanish for students
• Worked on the content and layout of e-learning platform to teach the French 5Tactics / Scorm)
• Designed and developed the scoriusgroup‘s website (PHP/MySQL) in English, French and Spanish
• Optimized traffics with Google Analytics SEO; Implemented FB, Amazon and LinkedIn API’s
• Participated in the definition and design of functionalities, and the version releases of the CRM software based on Java/Oracle web platform for banks
• Controlled the data integrity by making ad hoc queries (Oracle) to validate releases
• Did translation, editing and proofreading for the website, proposals and white paper : Spanish to French, and Spanish to English
• Participated in pre-sale presentations in Toronto and Paris
Managed the operational aspects of a factoring product : ensured file transmissions, accounting entries, and general ledger reconciliation, and primary contact for customers, the New York office, and vendors
Participated in the implementation of the project: UAT, RCSA, BCP, KYC, AML procedures
Drafted documentation (150 pages) in order to ensure backups and compliance with policies: procedures, system user guides, specifications, processes and controls
Was responsible for all aspects of the project life cycle of 3 complex Access multi-user applications and 3 sophisticated Excel/VBA-based tools :
to support front/back office coordination on treasury funding, credit risk exposure and interest rates; to streamline processes between Sales and Back Office teams; to reconciliate traders’ records with general ledger
MIS Report, to enhance the daily/weekly/monthly trade business reporting
Billing Reconciliation, to reconciliate the RBC’s invoices with Citi’s operating systems
• June 2003 - Sept. 2004: Effectuated a business roll up to liquidate a business of 3 million euros, and reinvested the amount in financial vehicles and real estate (Montreal)
• Jan. 2002 - May 2003: Co-managed a hotel in Paris, 42 rooms and 6 employees (Sud Hotel) Increased turnover by 15% in a year by using yield management methods
• Jan. 2002 - Dec 2002: (Remax agent, Flux Paris, Mediapolis, Altavia)
Designed 2 Access applications for booking, billing, reporting, printing and tracking functions Built databases, performed analysis and designed reporting and forecasting models
Participated in the development of 2 websites, design and content
• Supported the Sales Director by managing daily operations and IT project implementation:
15 employees and a catalog of 80 magazines and 70 journals generating 22 million euros
• Assisted the Controller with monthly financial reports, and budget forecast processes
• Designed the workflow of invoicing process; Coordinated the support and work of key users
• Developed multi-users Access applications to improve the claim treatment process (generating standard answer letter or e-mail automatically, facilitating the access to basic information through the Intranet in order to provide clients with accurate information in a short time-frame)
• Provided and improved business reporting, dashboard, and ad hoc analysis (SQL/VBA)
• Supervised the supplier billing validation process and followed up on litigious billing issues
• Managed the reduction of stock of 550, 000 issues by 50% by performing an ad hoc analysis
• Managed 4 Afghan employees on 4 bases, in charge of monthly accounting closings, financial follow-ups, and purchasing with a global budget of 1, 5 million euros
• Improved the financial reporting for Paris head office by designing an Access database
• Drafted financial reports for donors (US bank, and French and other European institutions)
• Monitored the implementation of humanitarian projects, and the delivery of 1, 500 tons of wheat
• Participated in the design and the implementation of a system capable of forecasting the customer’s purchasing and cancellation-related behaviour, and capable of modelling prices
• Designed decision-making tools and business cases (SAS/Access/Excel) to support business analysis related to yield management, costs, margins and profitability
• Created and implemented an opinion survey for employee feedback
• Designed, developed and implemented a balanced scorecard based on 25 indicators (GAN)
• Monitored the implementation of projects and their budgets by designing KPI
• Drafted technical and functional specifications (as is, and to be); Managed a PERT schedule and ensured that it was followed by the work teams:
o C.A.I. experienced document printing and IT systems duplication related to providing customer securities (shares, bonds, derivates) trading service; it was necessary to select one in order to centralize the flow of activity and to reduce costs
o B.N.P. wanted to identify the impact of Euro transition on bond front-office software
• Performed a statistical study on CIC’s securities stock and its global trading activity
• Build a VBA/Excel-based tool to automate the daily reporting on PnL and traders’ position
• Drafted the specifications of bond order processes (front, middle and back offices)