AddThis Social Bookmark Button
Ravi Ramaswamy ( Available )
635109 India
Expertise :SCALA 5.1 SR13 SP14, PROJECT MANAGEMENT, ORACLE APPS R12.0.5, CRYSTAL REPORT WRITER
Status :Citizen
Job Type :
All -
Position :

Resume
 
Summary


Seeking Managerial assignments in the Technical Consultancy or ERP Implementation or EDP Operations with a growth oriented organization.


A dynamic professional with over 13+ years of rich experience in ERP Implementation, EDP Management, Project Management and System Administration.
working with Tata Consultancy Services Ltd, Chennai as Asst Consultant Grade C3A.
A project planner with experience in spearheading the ERP SCALA system implementation initiatives, ensuring delivery of projects in the time and cost parameters.
Adept in IT Infrastructure Management with experience in configuring and troubleshooting Switches, Routers and networking equipments over WAN/LAN.
Proficient in managing the wide spectrum of tasks, procurement, vendor development, logistics, dispatch etc. across the supply chain.
Deft in mapping client s requirements, custom designing solutions for applications and troubleshooting for complex information systems management.
An effective communicator with excellent relationship building and interpersonal skills. Strong analytical, problem solving and organizational abilities. Possess a flexible and detail oriented attitude.
Acknowledged for integrity, high professional standards and customer-service orientation, with a sensitivity to the bottom-line.


Achievements

First Successful Implementation of Oracle e-Business Suite R12.0.4 in a Central Government Organization in India
Experienced in implementation and customization of Oracle Order Management and inventory module
Previous Assignment : Designated as Oracle Manager Client Engagement
Recognized with a Client Engagement Role which deals which Projects Audit
Working on certain ERP Projects and analysing the Health care of the projects
Reporting to the TCS Global Practice Head Oracle
Preparation of Project Case Studies
Generation of Audit Framework Documents A Checklist Template for Project Audits
Developed and refined ability of project members to estimate and maintain completion time for tasks .
Analyzed the existing backlog system manual tasks and procedures to develop a proposal for automating the manual procedures and improve tracking of system build backlogs .
Working closely with the client's representatives , developed a reputation for finding unique strategic solutions to problems and issues . Was able to build consensus on recommended upgrades and project parameters .
Preparations of Presentations based on the Project Audit
Conduct Review meetings
Recommending acceptable and Ethical Solutions to the client resolving critical issues


Employment

May, 2005 -  October, 2006
Mumbai as Consultant

with Sonata Information Technology Limited Grade JMA

Accountable for extending support for ERP systems along with client based SCALA Administration.
Rendering helpdesk support on SCALA.
Executed various projects and generating crystal reports for the same.
Functioned as an in-charge for Client Support Onsite and Offsite for ERP SCALA in coordination with the Head Office for any development requirement from clients.

Involved in the pre-sales activities and implementing SCALA at new client locations.

Conducted various training programs for educating the clients on the application.
Testing and Delivering Patches to Customer.
Handled Vat Migrations and Data Trimming Activity.
Fixed Asset Management and Depreciation Book and Income Tax methods.
Implemented TDS Accounting.
Automated SQL Server Database backup SCALA Database in a customer place, Mumbai.


January, 2001 -  May, 2005
Hosur Kanthal Division as Assistant Manager

with Sandvik Asia Limited EDP and Accounts Grade M1

Responsible for overall implementation and administration of ERP SCALA along with Database Administration, maintenance of Systems 75+ users and Network Administration.
Generating MIS reports through Crystal Report to facilitate management decision making process.
Played a key role in maintaining Zero downtime of the System.
Exposure in inventory valuation and reconciliation of Account heads viz. Automatic Accounting Schedule.
Vital contribution in Migration of existing crystal reports and migration of Scala 5.1 data in financial, manufacturing and logistics modules in SQL databases to Scala 5.1 SR13 with localization in MS-SQL database.

Validation of Accounting Information and balances through other applications like Access, Excel and Crystal Reports.
Verifying the Sub-Ledger transactions and General Ledger Transaction through third party tool.
Conceptualised and introduced new MIS Reports to determine the Obsolete Stock based on Purchase and Utilization of respective Raw Material for a Finished Product.
Comprehensive understanding and knowledge of monthly Charts on Stock, Delay in Production, Sales Order Acceptance, Process Order Acknowledgements.

Received various Awards and Laurels for exceptional performance, viz.:
Best Performer for recommending Innovative reports in MIS on Sales and Forecast during 2004 2005.
Small Memento for introducing the Visit Program Analysis for Sales Personnel Customer Visits.
Setup Continuous Consolidation process in SCALA


July, 1999 -  December, 
Hosur as System Administrator

with Netsoft Technologies

Involved in rendering System Integration support to end users along with installation of software and maintaining the Virus Free Systems.
established, maintained and troubles hooted various network printing issues.


December, 1996 -  May, 1999
Bangalore as Stores Assistant

with Buhler India Limited

Buhler had implemented Scala 5.1 for their internal operations.
As a user in Scala

Engaged in issuing materials to Sub-Contractor and In-house Assembly in coordination with the planning, purchase and other departments for clearing Purchase orders and shortages.
Monitoring stock maintenance operations for Sub-Contract, Indigenous and Imported items.
Maintaining records for inward and outward goods along with stock updation and validation.
Gained exposure in preparation of : Purchase Indent and Purchase Orders.

GRN and Delivery Challans and Job work Challans

Work Orders and follow ups
Stock reports through Access and Crystal Reports
Sales and Statistics Processes
Generating the GIT Statement and following up periodically to clear the Imported Goods from Customs House with the help of Customs House Agents.
Instrumental in maintaining Minimum Inventory Level for Semi-Finished and Finished Goods.
involved in analyzing Minimum Stock Level for Certain Products based on the ABC analysis and evaluating the lead time to deliver goods.
Comprehensive knowledge in revaluating the Machine Hours for Products where the productivity was low for working out the standard costing of a product at more profitable margin.
Functioned as a part of the Implementation or Migration team and representative of the stores or systems the functions undertaken
Data Migration
Stock Master Setup
Update of BOM regularly
Import of Purchase Orders into SCALA from external Source maintained the :
Trading Depot Activities Imported Finished Goods.

Goods Inventory and other all stores activities.
Preparing Dispatch related Documents viz. Invoice and Packing Slips.

Setup Work Centre Calendars and BOM Manufacturing and Engineering

Release and Reporting of Work Orders in Scala.
Setting up of Routings.

Work Order Issues and Receipts.
Posting of WIP and Stock Journals.


September, 1995 -  December, 1996
Hosur as System Assistant

with Hindustan Lever Limited




Education

Pursuing Master s Degree in Business Administration MBA HR from Annamalai University , Chidambaram .

1995 Bachelor s Degree in Science BSc Computer Science from M.G.R College , Hosur .



Training

Microsoft Certified Solutions Developer MCSD from Asset International , Bangalore .
Oracle Service Oriented Architecture Implementation Champion Certification
Oracle e-Business Suite R12 Financial Pre Sales Champion Certification
Oracle e-Business Suite R12 Supply Chain Management Pre Sales Champion Certification
Oracle e-Business Suite R12 Sales Champion Certification
Oracle Business Intelligence Data Warehousing Pre Sales Champion Certification


Skills


Operating Systems : MS DOS, Windows 95/ 98/ NT/ 2000 Languages : COBOL, Pascal, C, Visual Basic 6.0, Java 1.2, HTML RDBMS : Visual FoxPro, Oracle 8.0, Sql Server 2000 Developing Tools : Crystal Reports X1 Networking : LAN, WAN, TCP/IP, DNS, DHCP ERP : SCALA 5.1 SR13 SP14, Oracle e-Business Suite R12 Packages : Office 2003 Core Competencies Strategic Planning - ERP Implementation - EDP Management Finance and Budgeting - Project Management - Client Servicing System Administration - Vendor Development - Materials Management Logistics Management - MIS or Reporting - Team Management

ERP SCALA Implementation I am a competent Scala Techno functional Consultant with 11years experience in Scala 5.1 SR13 SP14. I have a total of 13+ years of experience out of which over 11 years in Scala, the recent 5 Years Understanding business process, study and analyse workflow to design solutions As-Is and To-Be Analysis and Freezing. Conducting Case or System or Process Study and Risk Analysis for project planning, scoping, estimation. Preparing Requirement Document for customer approval for various projects. Implementation of project plans in deadlines in the budgets. Field Level customization of Customer Master and Material Master. Handling configuration of various documents, BOM, G/L documents, split valuation, dynamic availability check for goods movements, configuration of different accounts and assigning users to the accounts. Evaluation of Free Goods, Material, Item Proposal, Condition Index and Listing. Integration with other modules, integration testing and extending Post Go-live support, training support to end-users. Experience in Automatic Accounting Schedules Process experience on Year End Routines and Migration activities Strong process knowledge in Supply Chain Management and Manufacturing experience on Reconciliations on General Ledger to Sub Ledgers Implemented Service Order Management. Developed various Crystal Reports for Customer and Supplier Ageing, Stock Reports, WIP Costing, PL and BS, GL Reports, Journal Coding Slips, Reconciliation Reports for General Ledger to Sales and Purchase and Stock, Sales Margin Reports with Charts, Purchase and Invoice Register, Pending Orders, Sales Statistics and more. Technical experience on SQL Server and Scala Migrations Administration Managing the overall administration of SQL Server and Scala System Configuration of SCALA Client Connectivity Regular monitoring of Business Data in the system through Audit Trial and System Trial. Creation of Users and Groups and setting up of Menu Access rights. Modifications of DDF as per Customer requirements for Order and Invoice printing Import of Data from External sources to SCALA Database Backup of Scala Database and Licensing Since November 06 with Tata Consultancy Services Limited, Chennai as Asst Consultant Grade C3A Key Responsibilities and Achievements Focussing on Key Objective of the projects Developing Project plans and Schedules and reporting project status Proposal review, compiling project master, time and cost estimation, statement of work, delivery Define project team organization, allocate and monitor tasks to team members Perform Team and Client reviews mid-term and end-of-term Recruit and train development team, shadows and develop a spirit of collaboration and teamwork Identifying, tracking managing and resolving project issues and achieve task milestones Identify Formal and Informal Team roles for each member of the team to contribute with their skill sets. Keeping the Team Motivated Current Assignment : Designated as Functional Consultant Oracle e-Business Suite R12 Project Characteristics : Oracle E-Business Suite R12 : Order Management/Entry OM/OE, Shipping Execution WSH, Inventory INV, Workflow, Concurrent Manager and Flexfields. Design, prepare and conduct workshops and training sessions for Order Management OM and Inventory INV module users to provide them with short cuts and point out lesser-known features so they can improve their day-to-day productivity. Analysis of system and process improvements allowing users to perform more transactions, in less time, with better quality. Stock Master re-engineered from Legacy to Oracle Applications R12 with de-duplication, Lot and Serial Controls verification and Organization assignment. Converted the following data from legacy systems into R12 : Pending Sales Orders Stock Master, Service Contracts or Sales Agreements and Stock Balances. Pricing occurs using Pricing Manager or Advanced Pricing QP. Worked on all phase of the project life-cycle : Gathered all business requirements in the service provider/service logistics area. Designed training materials to bring users up to speed with the standard system functionality. Performed an initial configuration of the system to support training and demonstration activities. Final design incorporated business processes throughout the Support organization. Completed configuration and setup to meet these needs. 3 cycles of testing performed : conference room pilots CRPs 1 and 2 and user acceptance testing UAT. Trained super-users. Supported all go-live activities and post-production troubleshooting. Contributions : Functional troubleshooting of the Shipping Execution WSH, Order Management OM/ONT and Inventory INV modules in Oracle Applications. Working on issues related to pick release, pick confirm, deliveries, reservations hard, soft, ATP, backorders B/O, interfacing to 3rd party warehouse and ship confirmations WSH, ONT, INV. Methodological identification of issues starting from order initiation to ship confirmation and closing of order line. Analysis of all scenarios/paths an order line can go through and issues that may occur during the full lifecycle of an order. Changes in configuration to Shipping, OM and INV setups as needed to address issues, improve performance and ensure proper flow of data to 3rd party systems Setting up Inventory Organization, Calendar, Subinventory, Item locators, Network Routing, Pick Rules, Sales Order Picking Release Rules, Accounting Rules Other activities include migration of on hand inventory quantity, coding of custom programs to load cost of items. Performed fundamental administrative tasks, registering applications and reports, defining user menus and setup value sets in the application



Miscellaneous

Key Responsibilities and Achievements
Responsible for handling Financial Accounting Package from Visesh technologies, Bangalore.
Coordinating with other department for computerizing the data flow.
Ensuring daily backup of Data and proper system maintenance.
Preparation of Reports in MSAccess and Excel
Pursuing Master s Degree in Business Administration MBA HR from Annamalai University, Chidambaram.
1995 Bachelor s Degree in Science BSc Computer Science from M.G.R College, Hosur.
Full Name : Ravi Ramaswamy
Date of Birth : 24th March 1974
Residential Address : Sri Mathru, Plot No 18/36, Jawahar Nagar, Near Ambal Nagar, Hosur 635109.