Ron Patel
SAP Business One Functional- Techno Consultant
Certified Microsoft SQL 2005 (MCIP)
Cell: - 732-***-****
Email:- ***.*****@*****.***
Professional Summary:-
• Over 6 years of extensive SAP Business One experience in Implementation, Development and Production with Compassionate Care Hospice, Tampico beverages, DotCAD, INFINIUM Technology Ltd, Intelicon & Lee-Pharma Ltd.
• Did the whole 5 life cycle of SAP Business One such as setting up a new company, version upgrade, and user technical training and post implementation support.
• Certified Microsoft SQL 2005 (MCIP) in PRO: Design & Optimize Data Access by Using MS SQL 2005.
• Certified Microsoft SQL 2005 (MCIP) PRO: Designing Database Solutions by Using MS SQL 2005.
• MICROSOFT CERTIFICATION ID IS: 6693333.
• Facilitated client requirement communication, gathered business needs, developed business model, defined process models, identified gaps in existing business processes and defined new processes as required.
• Adapted, composed, and executed business process in real-time to address changing business requirements.
• End to End SAP Business One project implementation as Project Manager.
• Set up, Configuration & Integration of G/L accounts, Finance, Banking, Purchasing, Sales Inventory, Production, MRP, Service, and Reports designer.
• Exposed to various modules: GL/AP/AR/Sales Order/Inventory/Production/PO/Fixed Assets/HRMS/Return Management etc.
• Add on configuration (XL Reporter, Outlook Integration, Copy Express, BC Set-up etc) & add on developments as per requirements of the end users using VB.Net and SAP Business One SDK.
• Handled post go-live support to the users right from uploading of business data in to SAP B1.
• Resolved day to day queries of the users.
• Used Crystal Reports to design a complex, on the fly, report that displayed a potential field layout of offensive and defensive players based on the data entered by the scouts.
• Used Crystal Reports to design a complex, on the fly, report that displayed complete charts of players categorized by playing style, team defense, and other parameters.
• Analyzed and customized (in XAL language) as per the organizational requirements in the modules i.e. Ledger, Sales, Purchase, Stock & MRP.
• Strong knowledge in data modeling, process chain, high level architecture design and business processes.
• Strong work ethics, very hard working.
• Excellent inter-personal skills.
• Good team player.
Core Technical skills:
SAP Business One : SAP Business One 2007 A, 2005 A, 2005 B, 2004 B, SDK , Crystal Reports
Add-on : Primavera, XL Reporter, Outlook Integration, Copy Express, BC Set-up
Environment : Windows XP/2000/NT/98, UNIX
Data Warehousing : SAP BW Release 2.1C/3.OB SAP R/3 4.6c, 4.6B, 4.0B
OLAP Tool : BEx Analyzer, BEx Browser.
Languages : C, C++, VC++, COBOL, ORACLE
Middleware : COM
Front End/GUI : Visual Basic, VB.Net, Visual C++, D2K, SAP, ASP /C, HTML, JavaScript
Databases : SQL Server 2005, Oracle, DB2
Other/Misc : MS Project, Adobe PhotoShop, Macromedia Fireworks2.0, Great Plains
Professional SAP Experience:
Compassionate Care Hospice
Location: Westampton, NJ, USA
Duration: December 2009– Present
Role: SAP Business One Support Consultant
Compassionate Care Hospice is a community based organization committed to providing the highest quality hospice care to patients, their families and close friends throughout Pennsylvania, New Jersey, and New York.
Responsibilities:
• Analyzing modules (Finance, Sales, Purchase, Inventory, Production & MRP and Human resources) for the formation and finalization of scope of Work.
• Develop a relationship as a business advisor and partner with the client at the executive levels, serving as the main point of contact for ongoing communications through the implementation process.
• Support client on their ongoing queries and resolve their business process issues.
• Performed business analyses, develop project plans and schedules; on-site training, make recommendations and respond to questions and issues on the implementation of the software both from a functionality and a planning perspective.
• Up-gradation of SAP B1 2005 A to SAP B1 2007 A with latest patches directly on Client’s Server.
• Responsible for improvement of system by doing regular monitoring of system.
• Having expertise in understanding the SAP Business One System and considerable experience in Application programming techniques, using quality driven methodologies.
• Knowledge on SAP Business One Integration technology.
• Expertise in developing Implementation Wizards for SAP Business One.
• Create User Defined Field & User Defined Table in SAP B1 as per Client requirement.
• Responsible for regular monitoring of the system to improve the quality of the system.
• Good understanding of the ERP software to incorporate into client’s business flow thereby improving their productivity.
• Importing of data from Legacy systems into SAP B1 via DTW (Data Transfer Workbench).
• Trained users on SAP’s functionality and helped with development of screens and menus to stream line their process flow.
• Created report’s using Queries, Formatted searches, User Defined fields, User Defined tables
• Post Implementation Support.
• Daily maintenance of SQL server, MS SQL backups.
Environment: SAP Business One 2007 A, SDK, Add-On : XL Reporter, Outlook Integration, PLD (Print Layout Design).
Tampico Beverages
Location: Chicago, IL, USA
Duration: Feb 2009 – November 2009
Role: Consultant SAP Business One
This multinational company with headquarters in Chicago, IL sells Tampico beverages in USA, Latin America and Worldwide. Tampico purchased production facility in Manaus, Brazil.
Responsibilities:
• End to End SAP Business One project implementation as techno-functional Consultant.
• Analyzing modules (Finance, Sales, Purchase, Inventory, Production & MRP and Human resources) for the formation and finalization of scope of Work.
• Wrote an interface to allow scouts to perform complex searches on players and generate reports.
• Designed an interface in ASP for the Cold Fusion application to generate reports over the web using Crystal Reports ASP Server. The interface allowed scouts (by using the Cold Fusion application) to specify desired information and build the report on the fly.
• System integration & configuration, initialization and setup.
• Project review meetings with end users.
• Reports generation through PLD (Print Layout Design) reporting tool.
• Conducted final testing before moving to go-live.
• Handling post go-live support to the users’ right from uploading of business data into SAP B1 to resolving day to day queries of the users.
• Add on configuration (XL Reporter, Outlook Integration, etc) & add on developments as per requirements of the end users using VB.Net and SAP Business One SDK.
• Implementation and support for ERP (Concord XAL) as Super User/Administrator.
• Analyzing and Customizing (in XAL language) as per the Organizational requirements in the modules i.e. Ledger, Sales, Purchase, Stock & MRP.
• As a member of core group, extended functional and technical support to all the client Tool rooms on Concord XAL.
Environment: SAP Business One 2007 A, Crystal Reports, SDK, Add-On Copy Express, Concord XAL, VB.Net, XL Reporter, Outlook Integration, PLD (Print Layout Design) & BC setup.
DotCAD Pvt. Ltd
Locations: - Ahmadabad, India
Duration: Jan’ 2008 to Nov’ 2008
Role: SAP Business One Support Consultant
DotCAD is a service provider and business partner of HP for all hardware support of HP. Being a Business partner of SAP, DotCAD implement SAP B1 to stream line its service and CRM process. All business process are re-engineered and best practices are followed as a result of that, company improve its CRM services and focus more on targeted sales and service.
Responsibilities:
• Involved in technical pre-sales by working together with sales executives to identify the client's needs and present solutions and demos.
• Specialized in ERP implementation and support of SAP Business One system.
• Worked on various versions of SAP Business One (2004B release) (2005 B release) (2005A release with COA with Segment) and SDK development tool.
• Worked as a functional / technical consultant preparing gap analysis, gathering requirements, performing customizations, and configuration to suite to the organization.
• Exposed to various modules: such as GL/AP/AR/Sales Order/ Inventory/ Production/ PO/ Fixed Assets/ HRMS/ Return Management etc.
• Extensively used the Data Work Bench (SAP), Data Migration Tools like Integration Manager of Great Plains and DTS of SQL Server to prepare the company database.
• Customization and development of Input screens using the following customizations tools:
o SDK (UI/DI API) for SAP Business One
o Dynamics Modifier and VBA for Great Plains
• Installed and implemented additional products and Service Packs.
• Tested connectivity to the server / ODBC.
• Used Crystal Reports to design a complex, on the fly, report that displayed a potential field layout of offensive and defensive players based on the data entered by the scouts,
• Used Crystal Reports to design a complex, on the fly, report that displayed complete charts of players categorized by playing style, team defense, and other parameters.
• Developed external packages using Visual Basic 6.0 and integrate with SAP Business One / Great Plains.
• Expertise in designing Chart of Accounts with segmentations.
• Trouble shooting and conducting training sessions for the users.
• Expertise in installation, development and customization of XLReport & XLR Designer
• Worked to migrate accounts from 1994 to 1996.
• Conference Room Pilot Run.
Environment: SAP Business One 2005 B,SDK,Copy Express , Great Plains, Visual Basic, Outlook Integration, BC Set-up, XLReport & XLR Designer
Sable Farming Company Pvt. Ltd
Location: Malawi, Africa
Duration: Jan’2007 to Dec’2007
Role: SAP Business One Consultant
Global Tea & Commodities Ltd is one of the fastest growing, fully integrated tea, coffee and macadamia nut companies offering a range of services at all stages of the supply chain. Their plantations in Tanzania and Malawi produce the finest range of tea and coffee. They are the largest producers of macadamia nuts in Central Africa.
Responsibilities:
• Developed a relationship as a business advisor and partner with the client at the executive levels, serving as the main point of contact for ongoing communications through the implementation process.
• Set up, Configuration & Integration of G/L accounts, Finance, Banking, Purchasing (A/P), Sales (A/R) Inventory, Production, MRP, Service, and Reports designer.
• Importing of data from Legacy MS Access database systems into SAP Business One via DTW (Data Transfer Workbench).
• Design and develop process to integrate Business One with 3-party application’s B1dev for real time processing of credit card transactions.
• Performed business analyses, developed project plans and schedules.
• Worked on Trimergo B2 PM and SAP Business One include Project planning, Capacity planning, Bill of Material, Job costing, Accounting and Invoicing, Sales management, Workflow, Procurement and Inventory, Time registration.
• Made recommendations and responded to questions and issues on the implementation of the software both from functionality and planning perspective.
• Trained 15 users on SAP’s functionality and helped with development of screens and menus to stream line their process flow.
• Created report’s using Queries, Formatted searches, User Defined fields, User Defined tables.
• Worked together with sales executives to identify the client's needs and presented solutions and demos.
• Post Implementation Support including telecommuting.
• Daily maintenance of SQL server, MS SQL backups & 3-party solutions backups.
• Ability to effectively work autonomously, take initiative and manage time effectively.
• Worked as functional / technical consultant preparing gap analysis, gathering requirements, performing customizations, and configuration to suite to the organization.
• Exposed to various modules: GL/AP/AR/Sales Order/Inventory/Production/PO/Fixed Assets/HRMS/Return Management etc.
• Extensively used the Data Work Bench (SAP), Data Migration Tools like Integration Manager of Great Plains and DTS of SQL Server to prepare the company database.
• Customization and development of Input screens using the following customizations tools: SDK (UI/DI API) for SAP Business One, Dynamics Modifier and VBA for Great Plains
• Installed and implemented additional products and Service Packs on the Clients Terminals.
• Tested connectivity to the server / ODBC.
• Developed external packages using Visual Basic and integrate with SAP Business One / Great Plains
• Expertise in designing Chart of Accounts with segmentations.
• Trouble shooting and conducting training sessions for the users.
• Expertise in installation, development and customization of XL Report & XLR Designer.
Environment: SAP Business One 2005 B, SDK, Copy Express, Outlook Integration, Visual Basic, BC Set-up, XL Report & XLR Designer, Trimergo B2 PM.
Intelicon Pvt, Ltd
Locations: - Gandhinagar, India
Duration: Jun ’2006 to Dec’2006
Role: Consultant SAP Business One
Intelicon wanted to give a new identity to the flagship company Essen Telecommunications. The scope of operations was to redefine and free the company to advance into new technology products. It joined hands with World's leading Visual Communications Giant to promote Video Conferencing solutions to cater to every application required in the field.
Responsibilities:
• Handling all modules in SAP B1 such as Administration, Sales, Finance, Business Partner, Purchase, and Inventory management, Production, MRP, Banking, Human Resource, CRM/Service and Reports.
• Understanding & analyzing customer’s ‘As Is’ Business Processes and mapping ‘TO-BE’ processes.
• Finalizing the Business Drivers and project scope for the client by mutually agreeing and signoff on deliverables for the project.
• Preparing Business Blue Print.
• Identification of the GAPS and providing the solutions for the gaps.
• Help technical team for configuration and testing of all modules.
• Systematic transfer of data into the system.
• Making User Manuals and conducting user training.
• Expertise in Installation, development and customization of XL Report & XLR Designer.
Environment: SAP Business One 2005 B, SDK, Copy Express, Outlook Integration, BC Set-up, XL Report & XLR Designer
Lee Pharmacy (P) Ltd
November ’2005 to May’2006
Role: Consultant SAP BW
Lee Parma is an ISO 9001: 2000 certified companies engaged in the manufacture of Active Pharmaceutical Ingredients (API), Intermediate Chemicals & Bulk Pellets Operating with two production units in Hyderabad. The implementation of this project includes BIW, ABAP, FICO, HR, MM, PP and SD modules.
Responsibilities:
• Installed relevant Business Content Objects as per client requirements.
• Worked with Info Cubes like Customer, Deliveries, Sales Overview and Info Sources like Customer, Sales Order, and Delivery.
• Maintained Data Sources, transferred structures, communication structures, transfer rules and updated rules, Info Packages for Data Targets.
• Extensively involved in extraction of data by customizing predefined extract structures, generating data sources and setting up of V3 Update.
• In Sales, the Sales item level and schedule line level data is extracted from BW standard Data Sources and data is loaded initially into ODS and then subsequently loaded into the respective Cubes.
• Scheduled jobs using Info Package groups.
• Involved in creation of reports with Info Cubes and ODS Objects related to SD.
• Worked on conditions, exceptions, filters, structures, free characteristics, restricted key figures and variables using BEx. Analyzer.
• Modified existing queries on various Info Cubes related to SD and MM and also developed specific Queries based on user requirements.
Environment: SAP BW 3.0A, ABAP/4, BEx. Analyser, BEx. Browser, Web application designer.
EDUCATIONAL QUALIFICATIONS
• Bachelor of Computer Applications
• Certified Microsoft SQL 2005 (MCIP)
• MCP Certified
PROFESSIONAL TRAINING:-
• SAP Business One 2005 B Training in IBM
• Microsoft SQL 2005