SUMMARY:

• Over 19 years of experience in SAP R/3 implementation projects for Financial (FI), Business Planning and Consolidation (BPC), BW (Business Warehouse), Sales and Distribution (SD), Materials Management (MM), Production Planning (PP), Product Data Management(PDM).

TECHNICAL SKILLS:

SAP R/3: SAP NETWEAVER 7.31, SAP HANA STUDIO SP9, SAP BW 7.31, SAP BPC 10.0, AO Analysis office 2.5, SAP EPM Solution 2.5, ABAP/4, DIALOG Program, ALE, EDI, and IDOC interfaces, Data Archiving, BAPIs, BADIs, Data Conversions, LSMW, Reports, Enhancements/User - Exits, SAP Scripts, Smartforms, Data Dictionary, BDC, Table control, Job Scheduler & Customer Enhancements.

Other Programming Languages: ABAP, HANA Studio, MDX script, BADIs, Windows, MS Office, SQL SERVER SSIS/ SSAS, COBOL,REPORT WRITER, VSAM, DLI/I, CICS, BASIC, EASTRIEVE PLUS, QUERY DLI, JCL, VISUAL BASIC.

PROFESSIONAL EXPERIENCE:

Confidential

IT Analyst

Responsibilities:

• Experience in implementing BPC as technical analyst with EPM skills to develop templates, configuration of new environments/models, dimensions, script logics and computations using BPC skills
• Configure processes in SAP BPC BADI script logics and computations
• Support and advise on solution roadmap for BPC projects
• Troubleshoot production support issues and related to FMRS/BPC (Financial Management Reporting System)
• BADI implementation and enhancement
• ABAP knowledge
• Familiarity with SAP ERP for FICO, BW in a technical capacity
• Collaborate with peers in the technology team to apply best practices to integrate with SAP application (ERP, BW, and BPC)
• Review & participate in solution build and test activities on BPC implementations, rollouts, upgrade projects.
• SAP HANA development for PDM Visual Reporting
• Designed and developed data models using HANAviews and scripts
• Analyzed and debugged production issues with existing data models
• Performance tuning of different perspective in HANA Studio
• Developed and implemented analytics tools like SAP BI Suite (Webi, Design Studio, Lumira.
• Experience with reporting system and data warehouse requirements gathering, analysis and design of ETL processes
• Joined firm as IT Analyst and part of the Global FICO Application Development team.
• Programming experience in SAP NEWWEAVER
• Expert knowledge of RFC’s, BAPI’s, BADI’s, BDC’s, User Exits, Adobe Forms and enhancement points
• Strong hands-on experience writing outbound/inbound ABAP interfaces using IDOCs, BAPIs, RFCs to/from
• Object oriented development
• Experience in writing ABAP proxy code to accomplish interface requirements
• Experience in ALV reports

Confidential

System Analyst

Responsibilities:

• SAP Fiscal to Calendar year conversion. Oce financial reporting is based on the fiscal year. In order to comply with Canon calendar year for financial reporting. SAP objects have to be identified and be adjusted to reflect the new requirements.
• Automated the main Lockbox program and improved customer payments process. The new enhanced locbox processes are prepared, updated and posted into our SAP.
• Allowed SAP to process foreign currency in Mexican pesos.
• Team Lead coordinator for development, testing implementation and support with internal users, application team, external partners.
• Archived supporting documents with attachment metadata
• Secured business records from inappropriate access and misuse
• Complied with government regulations and corporate policies
• Configured functionality built into SAP
• Enhanced and automated reporting capabilities
• Enhanced functionality integrated directly into FI module
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
• Utilized ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers 2005

Confidential

Lead Programmer Analyst

Responsibilities:

• Developed customized SAP dialog programs to replace A/S400 system
• Designed new custom-built database structure using the Data Dictionary
• Report captured warranty data via FTP to Germany for financial reporting
• Developed materials and procedures
• Worked in various ALE interfaces involving enhancing IDOCS, enhancing user exits, configuration of Partner profiles, Configuration of Logical and Receiving systems.
• Initial data loads to clients for multiple plants using LSMW (i.e., customers, materials, bill of materials, customer open orders, and pricing).
• Developed Custom Bar Code SAP Script programs and forms.
• Product evaluation and recommendation methodologies
• Configured and customized of ADK, DART and archivelink to IXOS
• Heavy involvement in formulating data policies, legal and business concerns
• Responsible for data security,, and user’s manual.
• Developed complex fill rate reporting application to optimize the logistic supply chain. It supports many areas including procurement, Production, Distribution, Warehousing, Inventory, Transportation, and Customer Service. The measurement is based on line count fill rate. The amount of order lines shipped on the initial shipment versus the amount of lines ordered based on the requested delivery date. Also, based on sku fill rate.
• Cycle time measurement is based on customer order promised date. The anticipated or agreed upon cycle time of a purchase order. It is gap between the purchase orderc creation date and the requested delivery date. This tells the cycle time that is expected.
• Customer order actual cycle time. The average time it takes to actually fill a customer purchase order. This measure can be viewed on an order and order line level.
• Implemented FI ALE messages, eq. GLMAST, COSMAS, COELEM and ACC GL POSTING financial (master and transactional) messages.
• Developed custom reports to assist in reconciliation process.
• Configured error messaging using workflow.
• Involved in SAP R/3 upgrade from 3.0F to 4.6C system
• Worked on conflict identification and resolutions.
• Developed new reports and interfaces as some 3.0F functions and screens became obsolete in new 4.6C system.
• Worked on SAP Script modifications due to new and modified forms.
• Tested all the custom programs to check the validity of the reports and interfaces in new 4.6C system.
• Developed several interfaces and delta update programs to financial analysis system called Hyperion / Essbase. This interface involved extractions of Billings, Customers, Materials, Cost Component information, and G/L balances.
• Converted legacy data such as material master and customer open orders using direct input and batch input
• Developed new IDoc types, message types, extension IDoc types and segments wherever the standard basic Idocs did not support the required functionality.
• Worked on all the import techniques available in LSMW: standard batch input, batch input recording, business object method (BAPI), Idocs.
• Developed new reports such as Inventory Status reports, Bill of Material reports, Purchasing Information reports, and Quality Inspection reports.
• Developed a new system to print vendor evaluation reports by calculating the vendor score card based on the inspection results from Quality system.
• Developed new custom SAP Scripts for Vendor PO/SA delivery schedule notifications.
• Enhanced several EDI IDOC user-exits to customize the delivery and sales information before being transmitted to the customers.

Confidential, Northfield, Illinois

Programmer Analyst

Responsibilities:

• Participated in design and implementation of Distributed Control System (DCS).
• Developed and implemented programs in COBOL, CICS and VSAM for various business applications; Sales, Distribution and Financial.