Jairo Leon
**** ******* ****, ********, **, L*H *C8
Phone: 905-***-**** Cell 416-***-****
Email: ******@*****.***
OBJECTIVE
Consolidate an opportunity as a SAP Lead Consultant FI/CO Enterprise Solutions to analyze, plan, lead and implement critical business initiatives, methodologies and a sound understanding of supply & demand chain processes in the high-tech and manufacturing industries by my experience in IT and continuity practices to improve business operations
QUALIFICATIONS
Over sixteen years of progressive experience with SAP R/3 clients and a total of 25 years of IT experience working in team and international environments
Senior SAP R/3 FI/CO with AP, AR, New GL, COPC, COPA, Closing Cockpit, OIM-Clearing process Specialist with significant exposure to MM and SD in Global implementation and support including America, APMEA, India, Grant China & SEANAP
Clear understanding of the integration between SD and MM to FI/CO modules
Provided functional support to SAP users on FI/CO, CO-PC, AP, AR, GL, CO-PA issues including problem resolution, corrective action, testing and documentation that arise in the course of supporting users
Responsible for the appropriate testing in FI/CO, PS, CO-PA and CO-PC, during implementation, and ensured the across functional integration in SAP, documented, communicated and trained
Proficiency in SAP ABAP 6.0, LSMW, report writer, reports painter and provided technical expertise, supervision and coaching to other analyst
Good understanding of IFRS principle-based
Bilingual: English/Spanish, and learning French
COMPUTER SKILL
Microsoft Windows, Excel, PowerPoint, Word, SAP, Email, Internet, Visual Visio, Clarify, CDMS, ATMS, Payformance
TECHNICAL SKILL SUMMARY
Operating Systems: Windows NT 4.0/95/98/2000/XP, AIX / IBM, Unix (Sun), HP
RDBMS: Oracle 7.2
Languages: ABAP/4, Query, Report Writer, Sap script, LSMW, RPG, Visual FoxPro 5.0, Visual Basic 4.0, 5.0, Clipper 5.2, Java, C++
GUI’s: Visual FoxPro 5.0, SQL, Visual Basic 4.0, 5.0, SAP R/3
Hardware: IBM S/36, AS/400, RISC/6000, desktops and laptops
Networks: LAN, TCP/IP, Routers, Switches, FTP
Remote Access: PC Anywhere, Net meeting, join.me
Tools Lotus Notes, Remedy, Clarify, CDMS, ATMS, Payformance, USD 6.0
WEB Internet Explorer, Mozilla
SAP R/3 3.1h, 4.6c and 4.7; ECC5.0 (with new G/L active) and ECC6.0
PROFESSIONAL EXPERIENCE
SAP Lead FI-CO Consultant-Architect ECC6.0 (EHP6) Nielsen, Ontario 2012/04 Present
Responsible for managing SAP FICO project across regional boundaries within Nielsen. This involves architecting SAP solution on new business requirements, business functionality expansion, new countries/companies onboarding and working on continuance improvement projects using a Global Template
Project scope
SAP Lead FI/CO to full roll out in Bulgaria & Germany for FI-CO, T&E including AA, GL, AR, AP, CCA, PCA, CO-PA, Internal Orders, T&E, Banks, Taxes WHT since project preparation and hands on configuration
Closing Cockpit Project for month-end close activities
SAP Lead FI/CO to full roll out in 13 countries with 27 company codes in Europe region for FI-CO, T&E including AA, GL, AR, AP, CO, T&E, Banks, Taxes WHT since project preparation and hands on configuration
SAP Lead FI/CO to full roll out in 12 countries with 13 company codes in LATAM region for FI-CO, T&E including AA, GL, AR, AP, CO, T&E, Banks, Taxes WHT since project preparation until go-live supporting and hands on configuration
Acquisition company code for Nielsen Audio (Arbitron) and migrated to SAP
SAP Lead FI/CO to full roll out in 22 countries in APAC, India, MENAP & Sub Sahara Regions, for FI-CO & SD modules, including: AA, GL, AP, AR, CO, Bank since project preparation until go-live and supporting
Defined, prepared, moderated, documented, requirements in the Business Blueprint, Business Process Procedures
Financial Integration with O2C-Order to Cash and P2P-Procurement to Pay
Performed Unit Testing & assists in Integration/Regression Testing/Unit Testing for FI, CO & CO-PA
Defined Profitability Segments Characteristics in CO-PA
Define Characteristics values fields and Derivation in CO-PA
Define Flexible Upload Budget in CO-PA via KEPM
Execute and created custom programs to maintain FI & CO-PA balanced
Define PA Transfer Structure for Settlements, and assigned PA Transfer structure to settlement profile
Data transfer between CO-PA and BW
Define Flows of Actual Values for FI, Billing, Projects and Sales Order
Defined and solved issues with RAR-Revenue Accounting and Reporting for Revenue Recognition Process. Standard Revenue Recognition at time of billing including Account Determination and Reporting control with unbilled & deferred G/L’s Account
Implemented a Global Report for Unbilled & Deferred Revenues
Helped and Resolved issues between CO-PA and FI
Supported issues related with WBS Elements, Settlements, Master data
Helped to implemented IFRS for Colombia company code
Helped and resolved Revenue Recognition issues for Brazil
Helped and resolved Treasury & Banking issues
Helped and resolved issues with HFM consolidation
Helped to activate pending G/L’s as Open Item Management Globally with Clearing
Helped for LATAM countries the– Business Process Optimization, including Hyperinflation in Venezuela, Fixed Assets & ARBA/ARCIBA in Argentina & Peru, Tax reporting for Mexico with (Retefuente, IVA, IETU), AR
Identified gathering requirements for European Countries for VAT issues amount others
Solution Delivery Lead B2R (FI-CO) ECC6.0 Holcim (Canada) Inc., Ontario 2008/11 2012/04
As a FI-CO Lead, the core responsibilities include support and lead the Project Implementation Team. Involved with all levels of the organization with the ability to prioritize multiple projects and change request
Delivery Planning
Was responsible to define the 5 years plan Road Map for all B2R projects
Defined an estimated resources for all Approved projects
Leadership
Managed and participated in all system development phases
Was a Technical Leader for B2R Holcim projects
Ensured compliance with PMO standards and processes for all development activities
Gathered high-level of business requirements
Performed configuration of SAP FI-CO using HARP/IFRS standards
Financial Integration with SD & MM Modules (O2C & P2P)
Performed configured of RAR-Revenue Accounting and Reporting
Performed Unit, system and Integration testing.
Supervised of assigned staff and offshore in India
Provided leadership and guidance to other systems analysts and personnel assigned to the projects
Lead and manage small teams implementing business process improvements
High performance within the team focused on continuous improvement
Prioritized and assigned incidents with the corresponding resource
Supported IT Service Management and IT Quality processes
Routinely quantified and qualified project team’s work
Implemented projects on time with standards and quality
SAP Release:
SAP Release coordinator to implement HRSP & Changes request into SAP for FICO and cutover activities
Coordinate effort to archiving FICO data into PBS system
Month-End Coordinator to ensure the business process for the company during closing
Confirm the ME official Basis, Security, Operations and Network ME
Projects Scope
Implemented multiple projects as: Closing Cockpit, Merging and New acquisitions Companies, Inter Unit Freight, ECC60 Upgrade, Trade & Non Trade Settlement, Support Packs, and Month End Optimization
As a Technical Lead implemented new plants across stream
Leverage business and technical expertise to implement projects in all phases: blueprinting, analysis, business modeling, technical design, application development, integration, and post go live production
Assisted with scoping prospective engagements and developing proposals
Created detailed systems documentation, test scripts, and presentations
Conducted solution architecting workshops with business managers
Implemented current settings for EC-CS transactions and month end process with profit centers
Application Management Support
As Month End coordinator, assisted in the monthly quarterly and the year-end close audit process and financial statements
Worked closely with the business users to understand their business processes, gather and document project requirements and translate them into functional specifications for Financial & Controlling.
Assisted and resolved on day to day support incidents and project related to workflow, substitution rules, Intercompany transactions, GL, Internal Orders, Product Costing, Cost center Accounting, Profit center Accounting, EC-CS-Consolidations, Profatability Analysis, BW reporting
Modified EC-CS and EC-CS FS versions and hierarchy structures
Configured the SAP FI/CO system to meet the business requirements.
Provided support in the area settlement profile, setlement rules, costing sheets and asset Accounting
Coordinated and troubleshooted the implementation of changes request as a monthly release
SAP Consultant FI/CO ECC5.0 Atos Origen Inc., Ontario 2007/04 2008/11
Provided hands on implementation and configuration in the module FI/CO
Supported New G/L:
oDefined Ledgers for General Ledger Accounting
oDefined Currency of Leading Ledger
oDefined and Activated Non-Leading Ledgers
oDefined Ledger Group
oDefined documents in Entry view / General Ledger View
oDefined document splitting
Improved customer’s existing business processes configuring new functionality in FI/CO as FICO consultant
Defined functional and technical specifications for development of ABAP enhancements, coordinating near-shore and off-shore ABAP developers.
Build positive client relationship an understanding of customer business and project scope
Developed analytical and recommendations to meet deliverable targets and complete project tasks within budget and customer satisfaction
Created detailed systems documentation, test scripts, and presentations
Worked with client staff and end-users to determine the functional requirements for the system within the SAP FI/CO module
Assisted, designed and developed interfaces and conversion programs to/from existing legacy systems of client proposals
Provided technical support in FI/CO for our clients and conduct SAP training as required for client personnel
SAP BSA Senior ECC4.7 Alcatel Canada Inc., Ontario 2005/04 2007/04
Implemented BW-BPS (Business Planning and Simulation) for replacement OFA of North America since Business Blue Print until implementation and post go-live support:
-Leaded Blueprint Workshops and documents results
-Provided SAP solution and documents them
-Performed Unit Testing & assists in Integration/Regression Testing
-Prepared Functional Specifications for technical solutions
-Participated in Cutover activities
Defined and designed recommendations in the Controlling & Product Costing modules SAP
Analysis of Business Blue Print and Business Process:
Defined, prepared, moderated, documented, requirements in the Business Blueprint
Analyzed the requirements for the user To-Be business process model during Analysis phase
Defined in Product Cost Planning Cost estimate with quantity structure, Overhead cost controlling
Worked with Product Cost by Order, BOM, Routing and Work Center:
Worked SD variant configuration, defined and assigned Valuation Strategies in CO-PA
Development, Loading, Reporting and Integration
Developed and modified procedures to solve complex problems
Guided and advised other IT staff in the development and configuration of business systems solutions
Analyzed business and user needs, documented requirements and translated into systems specifications
Participated in help desk support and I’ve acted as Finance IT Lead on projects
Managed, executed Designed & Build sessions: CO & CO-PC Modules
Support Post-Production
Helped to defined integration “Payformance Aplications” with Payment program and the corresponding configuration (Paying, Payment methods, bank selection).
Was involved in the payment run (Parameters, proposal, program, print)
Supported end-user in the tickets resolution with AP, AP & GL. T
Defined sustitutions and validation for FI and CO
Was involved into open items clearing and posting payment differences controlled by tolerances groups
Mainteined and configured automatic account determination
SAP Systems Analyst ECC4.7 Sony Canada Ltd., Ontario 2004/10 2005/04
Helped to implement of TM Par project (Transport Management), the functionality to automatically calculate and allocate Logistics Revenue Elements in SAP
Supported requirements, applicable interfaces and enhancement to SAP to support logistics requirements
Provided detailed requirements, account allocations, method of calculating revenue amounts and triggers
Determined the cost of shipments based on carrier rates and will calculated the amount payable to carrier for posting in Accounts Payable (FI-AP)
Consultant for R/3 Optimization ECC4.7 CIE, Mexico D.F 2004/07 2004/10
Participated in the BI project (Business Intelligence) for the whole group CIE-Mexico; Optimized SAP R/3, implemented cross functional module SD and EC-CS
Configured changes to accommodate changing business needs and to provided additional functionality inline
Tested, documented, communicated and trained the changes made
Understood and complied with the client’s Information Systems and regulatory standards
Provided technical expertise, supervision and coaching to other analyst
Ensured alignment with changes to the client’s policies, procedures and practices, and to legislation and regulations
Analysis & Identification
Detailed analysis of existing R3 environment and followed system lifecycle methodology
Identified new opportunity areas, modified, changed / enhancements & fine tuning
Classified and identified areas - immediate, year end, future and documented of detailed analysis
Executed project plan with schedule of activities, timeline and resource plan
Logical Design (Mapping)
Mapped SAP R3 functionality to CIE requirements, configured requirements within FICO module
Mapped of integration related configuration requirements within SAP R3
Realization (Configuration of R3 Modules)
Organized Structure, Master Data, Transaction processing, Analysis and Reporting
Defined User Roles and Profiles
Integrated, configured, implemented FICO modules
Technical Environment
Windows XP, Unix (Sun), FTP, Microsoft XP (Excel, Word, Project), Internet Explorer, SAP R/3 V.4.6C
SAP Systems Analyst ECC4.7 Sony Canada Ltd., Ontario 2002/11 2004/07
I worked and improved functionality within the 4.7 version of SAP. Continued SAP support after migration to newer version. Upgraded entire SAP R/3 system as a result created programs, interfaces, modifications and reports to ensure that they functioned in the new system. This applied to ALL areas of the SAP system (APO, CRM, BW, Service and Core modules)
Analysis, support and interpersonal
Provided and designed technical solutions to the functional team members
Assisted the functional and Basis teams on issues relating to environment, version, hot packs and transports, reported monthly on progress, supported end-users and implemented solutions to meet users requirements
Maintained and record time spent on projects and tasks including administrative tasks
Development, Loading, Reporting and Integration
Maintained and developed reports in SD, MM, PS and FI/CO
Defined and created different reports for assist users in managing EDI inbound sales orders, logistic costs, download into UNIX. Used BAPIS for integration with others environments
Developed programs with Upload/Download from Unix or into PC, to maintain information between Tokyo and Canada with confirmations by e-mail to end-users
Created reports to Management Information Systems (MIS)
Searched OSS notes for solutions to problems, defined jobs in SAP that also include FTP and RFC
Developed for data transfer include EDI, generated ALE interfaces, managed data replication through filtering BAPI parameters and enhanced receiver determination for BAPIs
SAP Analyst CO-PC ECC4.7 GlaxoSmithKline Inc., Ontario 2002/06 2002/07
Reviewed, verified, tested and ensured customization of PS and CO-PC modules
Responsible for review of the documentation for CO-PC/PP and PS
Tested all exercises of CO-PC/PP and PS and reviewed all relevant documentation
Verified the customization of: cost elements, cost center, order types, activity types, overhead surcharges, cost estimate, standard price, resources, activity type prices
SAP Business Analyst ECC3.1H to ECC4.6b Siemens S.A, Colombia 1997/09 2002/04
Implemented Project SAP in the Andean Countries:
Analysis of Business Blue Print and Business Process:
Analyzed, defined, prepared, moderated, documented, optimized and customized business blueprint and the To-Be business process model during the full life-time cycle implementation
Identified user functional requirements, user impact as well as systems impact over entire business process, and provided better services to end-users
Defined future business process, analyzed and documented business process in detail
Interpersonal
Facilitated the whole change management process, trained and assisted end-users in the full acceptance testing and commissioning process
Ensured alignment with changes to the client’s policies, procedures, practices, legislation and regulations
Expressed excellent communication, presentation and moderation skills and ability to learn and understand in-house, developed transactions
Gained strong interpersonal relations skills, industry knowledge as well as an extensive expertise in the SAP covering full life-cycle implementation with 2 SAP full implementation, FI/CO, PS and CO-PC/PP
Support Post-Production
Supported post go-live production, solved applications problems, trained end-users and provided second or third level hotline to support in the Andean Countries
Troubleshoots production issues in a timely manner, including responding to heat tickets
Provided SAP functional support to functional, technical team members and SAP users
Developed, implemented and improved news and existing business processes
Ensured highest possible efficiency over business processes model
Development, Testing, Interfaces, and Integration
Tested all transactions and test scenarios in FI/CO, PS and CO-PC/PP, during implementation, and ensured the functional integration with the modules MM, SD, PS, CO, PP, SM, HR, WF and FI
Realized interfaces, data conversion and integration with BPCS (AS/400) and SAP, during implementation CO-PC, PS and PP; and others applications with SAP
Designed, documented programs, tested solutions which require customized changes in ABAP, customized forms, reports by means of ABAP programs, SAP Script, SAP Forms, Report Writer, Report Painter
Maintained of information between FI/CO and PS correct, investigated data inconsistencies, transactional malfunctions and provided technical and procedural solutions
Customizing
Configured SAP FICO/PS modules and was done to meet user requirements as defined in the agreed “To-Be” process model
Executed Period-End Closing, periodic processing in FI, Distribution & Assessment and on a weekly basis executed results analysis and settlement
Executed Year-End Closing for Cost Object Controlling, CO-PA, CCA, PCA, PS
Defined and maintained Master Data for CCA, PCA, CO-PA and CO-PC, including groups, standard hierarchy and Revenue/Costs Elements
System Analyst Legis S.A, Colombia 1986/09 1997/09
Analyzed, designed and developed system of Costs in Developer 2000 of ORACLE
Migrated Data Base from S/36 computer to IBM RISC/6000 computer
Developed and implemented Information Technology Projects: HR, Payroll Systems, Accounts Receivable, Production, Logistic, Sales Departments, Finance and Operations
Systems Programmer E.D.P LTD, Colombia 1986/06 1986/09
Developed and implemented Human Resources System with IBM S/36, RPG
Consultant 1990/11 2002/04
Provided, developed, and customized hardware/software, implemented information technology projects, configured nets, maintained software and PC’s, and administered systems at client
EDUCATION
2011 SMI210-Solution Manager SAP
2010 ECCS Training Holcim
2010 BIT600-Workflow SAP Canada
2009 HARP / IFRS Training Holcim
2009 BW305 BI – Enterprice Reporting SAP Canada
1999 Software Engineering University Distrital, Colombia
1998 Information Systems Administrator University Jorge Tadeo Lozano, Colombia
1986 Computer Science University Jorge Tadeo Lozano, Colombia
1985 Technology Systematization of Data University Jorge Tadeo Lozano, Colombia
PROFESSIONAL DEVELOPMENT
1998-2000 SAP R/3 V4.0 CO/PS, QUERY ABAP/4, SAPSCRIPT, ABAP/4 Development Workbench, Java, Language C SIEMENS S.A, Colombia
1992-1996 Development of applications with procedural options, Forms 4.5I, ORACLE7, SQL *Report Writer, SQL *Forms, PL/SQL, SQL *Plus, CASE, SQL * PLUS ORACLE, Colombia
1988-1992 AS/400 DB Design & Coding, Systems Analysis and Design, Shell Programming, AIX IBM, Colombia
References: Available Upon Request