SUMMARY
Over 12 years of experience in Analysis, Designing, Coding, Testing, Support, Trouble Shooting, Performance Tuning & Implementation of Database Applications utilizing POWERBUILDER, SYBASE, ADAPTIVE SERVER, INFOBUILDER, Visual Basic 6, Visual Basic.NET, XML, SQL Server 2005 & 2008, SSIS, SSAS, SSRS & Crystal Reports under Windows environment.

• Over 12+ years of Information Technology experience in Analysis, design, development, testing & implementation of various projects in software application.
• Good exposure in interacting with clients.
• Good exposure in Finance & Retail.
• Good analytical, communication & interpersonal skills.
• Strong team management experience along with task planning & monitoring.
• Perform problem research & analysis.

GUI : Power Builder version 4 to 11, Visual Basic 6.0, VB.NET 2005 & 2008
RDBMS : Sybase SQL Any Where 5.5, Sybase Adaptive Server, MS SQL Server 2005 & 2008
Reporting Tools : Info maker 5 & 7, Crystal Reports 9, 10 & 11, SQL Reporting Service
Operating System : Windows 2003/NT, Novell NetWare 4.0, Windows XP/98/95, MS-DOS
Languages : T-SQL, XML
Tools : Interactive SQL, Sybase SQL Central, SSMS, SSAS, SSIS
Others : MS Office, Clipper 5.x, Dbase, FoxPro 2.6, Visual Fox Pro

Project Name : Confidential,
Organization : Confidential,India
Duration : Dec 2008 – Oct 2009
Role : Programmer
Environment : Visual Basic.Net 2005, MS SQL Server 2005, MS Windows 2003/9x

Confidential,is a record keeping application for Purchase Department. It’s come with several separate forms & reports. The module covers Indent, Inquiry, Quotations, Quotation Analysis, Purchase Order with Delivery Schedule, Goods Receipt, Q.A/Q.C, Rejection, Purchase, Purchase Return, Branch Transfer & multiple statutory reports & analysis summary reports.

As a Programmer:

• Responsible for screen design & coding
• Responsible for developing repots in SSRS & Crystal Reports
• Responsible for writing procedures, triggers & functions

Project Name : Confidential,
Organization : Confidential,India
Duration : April 2008 – Nov 2008
Role : Programmer
Environment : Visual Basic.Net 2005, MS SQL Server 2005, MS Windows 2003/9x

Confidential,is a record keeping application for debt collection agency. User can enter or import the pending invoice. Each collection clerks have multiple clients as per allocated area. The system gives the pending invoice list to collection clerk as per allocated area. Collection clerk follow up the customer to get payment & he gives customer to extra due period to pay the payment & he record all the discussion with client on system. If the customer didn’t pay the invoice in certain follows up then the invoice goes to the manager & the same process do by the manager & if the manager didn’t get the payment from client then the invoice goes to the legal department. The system generates clerk wise follow up register, collection register, disputed invoice register & many more.

As a Programmer:

• Responsible for screen design & coding
• Responsible for developing repots in SSRS & Crystal Reports
• Responsible for writing procedures, triggers & functions

Project Name : Confidential,
Client : Confidential,India
Organization : Productive Systems
Duration : April 2006 – March 2008
Role : Programmer/Analyst
Environment : Power Builder 7, Sybase Adaptive Server, MS Windows 2003/9x

Confidential, is a full featured, real-time Enterprise Resource Planning System for mid size & small companies. ERP is a client-server architecture offering flexibility & scalability. ERP comes with several separate modules. All modules are included as part of the base package. They are utilized as follows.

Access : Create the user & give him privileges to forms, reports & their control options.
Purchase : Purchase module comes with several separate forms & reports. The module covers Inquiry, Rate confirmation, Purchase Order with schedule; Goods receipt Note, Material QA/QC, Material Rejection, Purchase & Goods Return forms & multiple registers, statutory reports & analysis summary reports.
Sales : The module covers Inquiry from customers, Quotation, Sales Order, Delivery Note, Sales Bill, Goods Return Note forms & multiple registers, statutory reports & analysis summary reports.
Accounts : The module covers Bank, Cash, Journals, Expenditure, Debit Note, Credit Note, General Purchase, Reconciliation & Budgeting forms & multiple registers, statutory reports & analysis summary reports.
Production : The module covers Bill of Material, Batch Planning, Material Issue, Inspection/QA/QC, Finish Material Received, Packing forms & multiple registers, statutory reports & analysis summary reports.
Payroll : The module covers Employee Detail forms, Addition & Deduction, Daily Attendance, Monthly Payroll & multiple registers, statutory reports & analysis summary reports.

As a Programmer/Analyst:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for screen design & coding
• Responsible for writing procedures, triggers & functions
• Responsible for developing reports
• Responsible for testing & implementation

Project Name : Confidential,
Client : Confidential,India
Organization : Productive Systems
Duration : Jan 2006 – March 2006
Role : Programmer/Analyst
Environment : Power Builder 10, Sybase Adaptive Server, MS Windows 2003/9x

Confidential,is a full featured, real-time record keeping application. It’s a client-server architecture offering flexibility & scalability & comes with several separate Forms & Reports like Business Segment, Members Information with multiple business segments, Query module to help customer executive to find the member information, store callers information & auto generate weekly caller register.

As a Programmer/Analyst:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for screen design & coding
• Responsible for writing procedures, triggers & functions
• Responsible for developing reports
• Responsible for testing & implementation

Project Name : Cost Center Report Generation & Changes in Accounting Software
Client : Confidential,NJ, USA
Organization : Productive Systems
Duration : July 2004 – Dec 2005
Role : Programmer/Analyst
Environment : Power Builder 8.0, Sybase Adaptive Server

As per customer’s requirement we developed a cost center reporting, budgeting & actual expenditure analysis, compare profitability with selected period & calculate production cost per kg.

As a Programmer/Analyst:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for screen design & coding
• Responsible for writing procedures, triggers & functions
• Responsible for developing reports
• Responsible for testing & implementation

Project Name : Confidential,
Client : Confidential,India
Organization : Ideal Systems Pvt. Ltd
Duration : Feb 2004 – Jun 2004
Role : Consultant
Environment : PowerBuilder 7, Sybase Adaptive Server, MS Windows 2003/9x

As per clients requirement we developed a Dealer Accounting Software with Order Management, Inventory Monitoring & Daily business analysis for their entire agency network. It has Receipt, Payment, Purchase, Goods Return, Debit/Credit Note, Journal Vouchers & Accounting Reports.

As a Consultant:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for design screens

Project Name : Well logging System
Client : Confidential,
Organization : Ideal Systems Pvt. Ltd.
Duration : Aug 2003 – Jan 2004
Role : Consultant
Environment : Power Builder 7, Adaptive Server, MS Windows 2003/9x

Confidential,is record keeping application for the logging department. In the System they enter some data regarding the well measurement, location, working date, start time, end time, team, extra manpower they used, drilling machine they have to used, dynamites they have to blast, tools they have to use, how much expense they had done & tools or drills breakdown for this well. The system generate many reports regarding inventory of tools & dynamites, inspection of tools & drilling machine, team performance, analysis of wells, logging file information & many more.

As a Consultant:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for design screens
• Responsible for monitoring & implementation

Project Name : Asset Management System
Client : Confidential,
Organization : Ideal Systems Pvt. Ltd.
Duration : Feb 2003 – Jul 2003
Role : Consultant
Environment : Power Builder 7, Adaptive Server, MS Windows 2003/9x

Calculate depreciation on straight-line method & declining-balance method, add audit module to recalculate the asset value from 1952 as per different methods for different period as per defined in master. Assets revaluation, Scrap, Scrap sale, Depreciation calculation & generate accounting effects every month & so on.

As a Consultant:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for design screens
• Responsible for monitoring & implementation

Project Name : Confidential,
Client : Confidential,India
Organization : Productive Systems
Duration : Sep 2002 – Jan 2003
Role : Tech Lead
Environment : Power Builder 7, Sybase Adaptive Server, MS Windows 2003/9x

Multilevel Marketing software is develop for the record keeping & calculates the commission to the members. The Software arrange company’s genealogy, member’s genealogy & generate monthly commission register with detail overview about the members earnings & Print the Payment note of each members who is eligible to get commission.

As a Tech Lead:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for screen design & coding
• Responsible for writing procedures, triggers & functions
• Responsible for developing reports
• Responsible for testing & implementation

Project Name : Library Management Software
Client : Confidential,India
Organization : Productive Systems
Duration : Mar 2002 – Aug 2002
Role : Tech Lead
Environment : Power Builder 7, Sybase Adaptive Server, MS Windows 2003/9x

Confidential,is record keeping application having member information, renewal period, inventory, booking information, query module for search album/movie information on multiple column like language, movie category, movie name, actor, actress, release year, director wise, renewal income, store expenses, wages expenses, bank records, inventory audit, inventory scrap & many more report related the accounting & management.

As a Tech Lead:

• Responsible for system study & database design.
• Responsible for Creating technical documents
• Responsible for screen design & coding
• Responsible for writing procedures, triggers & functions
• Responsible for testing & implementation

Bachelor in Commerce