Post Job Free
Sign in

Management Sql Server

Location:
United States
Posted:
August 30, 2011

Contact this candidate

Resume:

Syed

Chennai, India

: 91-984*******

**********@*****.***

PROFESSIONAL SUMMARY

• 11 Years of Extensive experience in ERP product development, Maintenance & implementation.

• In-depth knowledge and experience in PS - General Ledger, Accounts Payables, e-Procurement, Purchase Order.

• Strong technical background – Certified PS Developer.

• Proven ability to deliver high quality IT solutions on schedule and under budget.

• Excellent interpersonal skills in communications & client relations.

• Hold Valid H1-B/B1 Visa.

PROFESSIONAL EXPERIENCE

Hexaware Technologies Chennai, India Aug 2010 – Till Date

Oracle Bangalore, India Nov 2004 – Aug 2010

Bluestar Infotech Banglore, India Nov 2003 – Nov 2004

Ramco Systems Chennai, India Aug 2000 – Mar 2003

EDUCATIONAL QUALIFICATIONS

Course Institution

MCA Bharathidasan University, Trichy

MBA Pursuing from Madras University

B.Sc., Computer Science The New College, Chennai

GNIIT NIIT, Chennai

SOFTWARE SKILL SETS

Operating Systems DOS, Windows NT, MPE

Peoplesoft Technologies PeopleTools 8.4x, 8.50. Application Designer, PeopleCode, Application Engine, Data Mover and Query Manager, SQR, Component Interface, Integration Broker, Process Scheduler, Data Mover, XML Publisher, Performance tuning, Workflow.

RDBMS Oracle, MS-SQL Server

ERP Peoplesoft (8.4, 8.8, 8.9, 9.0, 9.1) – Purchasing, Inventory, Order Management, e-Procurement, sPro (services procurement), AP (Accounts Payable), GL (General Ledger)

Ramco e.Applications – Sales, Shipping and Inventory

MAJOR ASSIGNMENTS

Aug 2010 – Till Date

Role : Technical Architect

Responsibilities

Part of GL Implementation team in the capacity of a technical architect

Handle Customizations & enhancements

Handle PeopleSoft Security

Handle Production Support Issues

Achievements

Designed inbound/outbound interfaces

Design Web Service

Workflow setup

Environment People Tools 8.50, Application Designer, PeopleCode, Application Engine, Data Mover, ORACLE, SQR, Integration Broker - Web Services, Workflow, Security.

Description

Client is a global leader in delivering innovative investment management, asset and fund administration, fiduciary and banking solutions to corporations, institutions and affluent individuals. While on their growth trajectory they acquired many large and small organizations. I was part of the Global GL implementation team as a Technical Architect. Currently i am supporting the GL system.

Nov 2004 – Aug 2010

Role : Technical Project Leader

Responsibilities

Analyze customer issue and define the scope

Provide solution to the customer reported issues on terms of SLA

Unit testing and integration testing

Achievements

Handled high priority issues efficiently providing solutions to customers within the stipulated time

Mastered specific functional areas such as Requisitions, Receipts Accruals

Gained knowledge in PeopleSoft Accounts payables pay cycle

Environment PeopleTools 8.4X, 8.50, Peoplesoft 8.4, 8.8, 8.9, 9.0 and Application Designer, PeopleCode, Application Engine, Data Mover, Change Assistance, MS-SQL Server 8.0, DB2, ORACLE, SQR.

Description

Oracle's PeopleSoft Enterprise Supplier Relationship Management (SRM) is an integrated family of applications that dramatically cuts all supply management costs. It enables organizations to reduce spend on all categories of goods and services, streamline procurement processes and enforce policy compliance. PeopleSoft Enterprise Purchasing is the application for professional buyers that streamlines purchase order processing while strengthening policy compliance. PeopleSoft Purchasing enables customers to automate core transaction processing and electronically transact with suppliers. PeopleSoft Enterprise Order Management offers visibility into system wide product availability - from current inventory levels to order status information. Synchronize your orders with product availability in real time, no matter where the orders are coming from - field sales, the web, email, call centers, electronic data interchange (EDI), or fax. I am part of the global team which provides support for PeopleSoft customers across the globe. The modules I am currently working on are Purchasing, eProcurement, sPro (Services Procurement) and Order Management. I have just started with Inventory module too.

Nov 2003 – Nov 2004

Role : MAINTENANCE ENGINEER

Responsibilities

Interaction with customers for requirement finalization.

HLD, LLD & Estimation Sheets preparation,

Test strategy preparation

Unit testing and integration testing

Install on live server

Achievements

Major role in implementing the new functionality of Consolidated Billing

Actively involved in developing of the Virtual Order Processing concept

Prepared Integration Test Case for the components designed

Actively involved in First level Integration Testing

Major Role in Configuration Management process

Environment MPE & IMAGE

Description

This project is for a $3 billion U.K headquartered MicrowareHouse, which is a leading IT Retailing company with offices in USA, Europe and Canada. It is rated as one of the best technology enabled company in retail business. MACS is a maintenance project, involving the current product engineering (CPE) activities. The scope of the project is to provide

• Day to day management support services

• Bug fixing and enhancement services

MACS is Mail Order Cataloging System for processing the orders. This is a packaged application running on a HP Server. The features of this application are core to the functioning of the business. This application covers the entire gamut of functionality ranging from Order Capture through Fulfillment, Invoicing and Receipts. I am involved in the maintenance and enhancement of the Product Management module which is a superset of Order Processing, Open Account Management, Return Management and Order Control.

MARCH 2002 – MARCH 2003

Role : PROGRAMMER

Responsibilities

Provide a design that will satisfy the software requirements and also enable Implementation, construction and delivery

Implementation of the design including BE coding and user object implementation.

Generate Unit Test plan and test case

Unit testing and integration testing

Achievements

Major role in Definition and Design of services and Methods

Prepared Integration Test Case for the components designed

Actively involved in First level Integration Testing

Environment Ramco Virtual Works (RVW) & SQL 2K

Description

Developed major finance components like Currency Revaluation, Supplier Receipts, Sundry Payments, Sundry Receipts. Played an active role in the development of VAT Declaration and VAT Setup components. These components capture the activity of recording certain Cash outflows and Cash inflows of the organization by generation of receipts and vouchers. The VAT rules differ from country to country, this component was developed for the Swiss customers.

SEP 2000 – FEB 2002

Role : ERP PRODUCT MAINTENANCE ENGINEER

Work Site : Ramco Systems Ltd., Chennai, India.

Responsibilities

Simulation Of Cases reported by the Euro customers

Defect Fixing, Verification and Internal Testing

Customizations & Enhancements and Performance Optimization

Utilities/Tools Development

Merge and Service Pack Release and Porting

Customer Support

Handled Configuration Management activities

Achievements

Fixed a large number of defects in Ramco Marshal – AP & GL on time and hence provided satisfaction to the European customers.

Improved execution time by Performance Optimization.

Ensured delivery with near zero defects.

Provided off line technical and functional support to customers.

Developed custom tools and utilities as per project needs

Highly interactive with a large team

Ported the Financial modules from SQL Server 6.5 to SQL Server 2000 and ensured no performance degradations.

Projects handled

1. Management Accounting (Additional Work Order Cost)

2. SQL 2K Porting



Contact this candidate