Ravindra Mall

MIG-A/**, Ravishankar Shukla Nagar, Neha Apartments, Flat No.203, Indore (M.P.) – 452008, India

Mobile: +91-966*******; Phone: +91-731-******* ®; Email: lcz92y@r.postjobfree.com

Date of Birth: 5th Jul 1966

Technology Solutions ~ Projects Management ~ Resource Management

20+ Years of Accomplished Experience in Delivering Optimal Results and Business Value in High-growth Environments

Job Objective

Seek to contribute in a challenging work environment demanding organizational excellence and customer value. Provide thought leadership with macro level view and micro level precision to translate simple idea into great solutions.

Executive Summary

• Talented and profit driven professional backed by strong academic credentials – MCA, Microsoft Certified Professional – MSSQL and Oracle Certified Associate – 10g Database with continued career progression and documented history of bridging Technical and Managerial acumen in turning around of Information Technology coupled with insightful exposure to Systems Analysis & Design, Software Development, Projects Management, Information Security Management, Infrastructure Integration and Technology Operations.

• Comprehensive domain understanding of Finance, Production, MRP, BOM; displayed credentials in initiating, administering and executing across a portfolio of projects harmonizing technical needs with business realities including Conceptualization, Budgeting / Estimation, Planning / Monitoring, and final Commissioning across different geographical locations.

• An all rounder intellect with extensive experience in resource management, manpower management, process frameworks, process evaluation and its development, and software development methodologies & life cycles.

• Articulate communicator who can fluently speak the language of both people and business, blending technical expertise with interpersonal skills while interacting with the steering committees, customers, stakeholders and cross-functional team members.

• A keen strategist with expertise in providing effective business solution and technical architecture to leverage technology in creating revenue opportunities.

• Apt in managing different stages of Projects Execution, Information System Audits, and enhancing customer satisfaction through dedicated team work and operational excellence

• Proven Project and People management skills coupled with professional competencies in mobilizing and judiciously managing resources with structured inputs in the domains of project planning, scheduling and monitoring to ensure project accomplishment within defined time / cost parameters.

• Decisive leader capable of leading and managing multiple project teams while ensuring judicious resource allocation and utilization.

Technical Forte

• SAP

FI, CO, MM, PM, SD, QC, PP – Implementation from scratch (CSBP to FSBP) and after go-live training and development on the mention module. Training is the important area where users get more awareness and they know what they are doing and what they can do to achieve the business goal.

• Oracle Database Developer/Administrator

Oracle Database Installation, Configuration, Tuning, Backup & Recovery

Monitoring the locks, the processes running on to the server, Data transfer

Creation of users, Tablespaces, Additional data file creation and maintenance

Define the user roles & Snapshot creation and management according to security need

Designing schema, indexes and objects, tuning of database objects

Creation of procedure, triggers, functions and packages.

Physical Database Designing, creation of Database, creation of Redo Logs, creation of Procedure, creation of Cursors, creation of Schema and management.

Defining Constraints, Views, Stored Procedure Optimization, Analyzing Query Plans.

Migrating database from Sybase SQL Anywhere to Oracle.

Security and User Administration, Normalization, De-normalizing, Database Objects Placement.

• MS-SQL Server 2000

Installation of SQL Server, Creating & Implementation of Database, Files & File Group (Gathering Database Information, Creating Database, Setting Database Option, Resizing Database, Shrinking Databases, Working with File Group)

Using SQL -Server Logins and Security (SQL Server Security Access Model, Security Modes of SQL Server, Database Users and Roles). Business rules deployment in database via triggers and procedures.

Implementing Backup (Protecting Database with mirroring, Duplexing and Striping, Backup Terminology, Creating Backup Devices, Verifying Database Consistency)

Restoring Database (Auto Recovery, Manual Recovery). SQL Server Data Transformation Services (Backup & Restore, BCP, Package Security, Package component, DTS export import wizards)

Implementing Replication Methodologies

• Sybase SQL Anywhere Database

Sybase SQL Server Installation and Connectivity, Client Installation, Networking.

Managing Physical Resources, Database Creation, Defining Physical and Mirror Devices, Disk Initialization, Disk Mirroring, Defining Altering and Maintaining Database and Logs, Segments and Objects Placement.

Security and User Administration, Permissions, Roles, Adding remote Logins, Configuring Variables for Remote Logins.

Backing Up and Restoring Database and Transaction Logs, Database Logging and Recovery.

Configuring and Tuning the Server, Checking of Tables and Databases using Database Consistency Checker, Page Allocation. Designing Indexes for Performance, Query Optimization, and Index selection.

Data Migration Sybase tools for Migrating Data by Bulk Copy utility, Definition Copy Utility. (Hardware Selection and Tuning, Memory, Processor, Network, Windows NT configuration Parameter, NT Performance Monitor Counters)

• Windows NT Server 4.0/2000/2003/7 Administrator

Installation and Configuration Intel Based Server, NT Server Roles (PDC, BDC, and Member Services), Configuring Protocols and Protocols Bindings, Configuring Network Adapters, Configuring NT Server Core Services, Peripherals and Devices, Hard Disks, NT Server for various Clients.

Managing Resources, Users and Group Management, Administering Accounts Policies, Remote Administration, Disk Resource Management.

Troubleshooting, Resolving Disk Failure in a Fault Tolerant Environment, Disk Mirroring and Duplexing, Stripe Set with Parity.

Installation of IIS Server

• OPEN UNIX - Administration

Installation and Configuration of OPEN UNIX 8.0 with LKP Options. Configure LKP for Oracle 9i database, creating users, Group and Management, creation of Shell script for database inside process startup, database backup and others routine jobs.

Managerial Forte

• Strategic Management: Formulate and define cost effective short / long term budgets and corporate strategies for achieve pre-set profit targets while adhering to the quality of the products delivered and customer satisfaction level.

• Resource Utilization: Adroit in handling and managing a team with distributed resources thereby ensuring optimum resource utilization and subsequently timely delivery of the project.

• Project Management:

Adept at managing multiple projects and ensure successful completion of the projects within the approved Budget and smooth execution and implementation of the Project.

Actively involved initiating, planning, execution, tracking / monitoring, controlling and closing the project as scheduled and in implementing operational processes for increased efficiency and cost reduction.

• Relationship Management: Maintain highly cordial relations with various other departments within organization to ensure fulfillment of organizational goals.

• People Management: Collaborate with the team members as an effective leader to motivate them to realize their potential and deliver their best at all times; instrumental in transforming teams from lower to higher level of performance.

• Employee Retention: Deftly coordinate with the HR to plan and estimate resource requirements; acquire best talents and ascertain retention of productive employees.

Professional Experience and Accomplishments

ABG – Birla Lao Pulp and Plantation Co’s Ltd, Laos (South East Asia) Aug 2010 June-2012

Dy. Manager (IT-Section Head)

National Board of Trade Ltd. (NBOT), Indore Mar 2001 Aug-2010

Manager (IT & NW)

Sanghi Bros Ltd, Indore Oct 1999 – Mar 2001

Assistant Manager (Systems)

Hind Syntex Limited, Dewas Jun 1992 – Sep 1999

Database Admin/System Analyst

Project Executed

1. SAP – Full life cycle of SAP implementation: - Design the roadmap for SAP, Business benefits, Bid calling process, preparation of contract for selected SAP-Partner. Provide the input and lead the team of BPO’s and consultant for the CSBP, FSBP, BBP and Z development. Design the strategy to replace Oracle 10g based ERP legacy systems by SAP E6.0. Ensure the quality for master data template provided by the consultants and filled by the BPO’s team, Keep close eyes on UT/IT and final GO-live.

Land acquisition need strong documentation and Document Management system used to store all document received from approving authority (PAFO, FIPD, MAF, LMO, EIA/IEE Certification etc Plantation team using PM, MM. Number of function like land acquisition, labor management are mapped in SAP via Z development. QC module useful for R&D as well as for land department. System equips to finance department for real time basis activity going on field and they are able to generate payment for respective work in place of manual request.

Management has better control over the labor efficiency, weather status, quantification of work, planted land and land in hand for new planting, area reconciliation, Survival, schedule the activity as per standard plan, production efficiency for nursery, variance between budget v/s actual cost, equipment efficiency etc .

Duration: Jan’2011 to Oct-2011

Team Size: 29

Tools & Technologies: SAP

Role & Responsibilities: Dy. Project Manager SAP, IT Section Head - Project co-coordinator with 2 SAP implementation (1 Global Project and one domestic)

Designed the physical layout of the system, network and place appropriate infrastructure for SAP rollout.

Organize and lead the review meeting for SAP progress.

Verify AS-IS, BBP, FSBP and others document for SAP.

Create Roadmap to UT-1,IT-1,UT-2,IT-2 and final Go-live.

Place a strategy for smooth migration of legacy data to SAP ECC 6.0.

Update to Sr.Management for progress and further strategy to meet out the business need in SAP.

Place a help desk strategy for smooth operation after go live.

Design an alternate infrastructure, system to take care of any failure if happen.

2. Oracle ERP – Use for existing business process. SAP replaces it by oct’11.

Duration: Sep2010 to Dec-2010

3. Online Trading, Clearing & Settlement System: A real-time system wherein the clients complete their transaction soon without waiting for a fraction of second.

Duration: Jan 2004 Aug-2010

Team Size: 23

Tools & Technologies: PowerBuilder for MOPS and VC++ for TWS, Sybase Enterprise 12.5, HP UX Model rp 3410, HP UX – 11.00

Role & Responsibilities: Project Manager

Integration of CMC Made vector system with the online TWS.

Integration of CMC Made RMS with MOPS and surveillance.

4. Outcry Trading, Clearing & Settlement System:

Duration: July 2002 – Dec 2003

Team Size: 06

Tools & Technologies: IDS 6.0, Oracle 9i Rel.2.0 on SuSe Linux 9.0, IBM X Series Dual CPU Model 236(8841-17A), SuSe Linux 9.0

Role & Responsibilities: Project Leader

Designed the physical layout of the system and involved in module integration.

Created Logical Data Model of the system, packages and Triggers

5. Market Operation & Surveillance: The system controls all the operations of member as well as exchange. This is information base system to gather information from several system and process online for effective decision making

Duration: Apr 2001 to Jun 2002

Team Size: 04

Tools & Technologies: IDS 6.0, Oracle 9i Rel.2.0 on SuSe Linux 9.0, IBM X Series Dual CPU Model 236(8841-17A), SuSe Linux 9.0

Role & Responsibilities: Project Leader

Designed the physical layout of the system and accountable for module integration.

Created the Logical Data Model of the system, Dataflow Diagram, E-R Model, table definitions, constraints, and rules, Store Procedures and Triggers

Other Projects Executed

• Integration of General Operation – Modules (Purchase Order Processing, Sales Accounting, Financial Accounting, Inventory Management System)

• Integrated Solution- HSL – Modules (Payroll & HR Management, Sales Order Booking, Sales Accounting, Share Accounting System, Financial Accounting, Fixed Assets

• Integrated Solution – DSL – Modules (Raw Material (Soya Seed) Purchase Accounting, Sales Accounting, Gunny Bag Accounting, Inventory Management, Production & Planning, Machine Maintenance, Payroll and Financial Accounting.

Academic and Professional Credentials

MCA (Masters in Computer Applications), 2002

IGNOU

Master of Arts (Political Science), 1986

Gorakhpur University

Certifications

• Microsoft Certified Professional – MSSQL Server - 2000

• Oracle Certified Associate – 10g Database

Technical Skills-set

RDBMS : Oracle (10g, 9.i, 8.i / 8.0/ 7.x), Sybase, MSSQL Server 2000.

Languages : PL/SQL, SQL*Plus, iSQL*Plus, ’C’, Pro*C, PL/SQL, JServlet Cartridges (Mod_Pl/SQL, Mod_OSE, Jserv), Sybase ISQL, MSSQL SERVER 2000 Query analyzer and Unix Shell Scripts

RAD Tools : PowerBuilder 5/6.5/7/9, Oracle Form 6i, IDS and .NET

Miscellaneous : Oracle 9i Application Server (9iAS/OAS 4.0.8.1/WAS 3.0), Apache Web Server, SQL*Plus, SQL Navigator 3.2, Microsoft FrontPage, Access, PL/SQL Web Toolkit, CVS (Version Control), JDK, JDBC.

Operating Systems : Win-2003, Win-2000 Advanced Server, Caldera Open Unix 8.0, Red Hat Linux 9.0, NT 4.0/4.5 and LAN 3.12.

References: Available on request

Contact this candidate