Sql Server System
Resume:
HIREN KHATRI
Mobile: 339-***-****
***********@*******.***
Over 12 years of experience in Analysis, Designing, Coding, Testing,
Support, Trouble Shooting, Performance Tuning & Implementation, Application
Support of Database Applications utilizing PowerBuilder 4/10, Sybase
Adaptive Server, Visual Basic 6, Visual Basic.NET, XML, MS 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 and application support
of various projects in software applications.
. Over 7 years PowerBuilder. Successfully completed Four Full Life cycle
implementations using PowerBuilder versions 9.0/8.0.
. Over 3 years of experience in Installing, Configuring, Administering,
Designing, Implementing and Supporting Databases with MS SQL Server
2005 & 2008 & Sybase Adaptive Server.
. Over 3 years of experience in Developing Reports using SQL Reporting
Service & Deploy it on Production Server, ETL using SQL Integration
Service & Develop a Cube using SQL Analysis Service & Deploy to
Analysis Server. Crystal Reports 9, 10 & 11.
. 2.5 years on Development & Application Support on commercial software
product ProSys Accounting System with Inventory Control. It has more
than 1000 Customer Installations and over 3000 users. Initially
developed the application in Clipper 5x/Foxbase and later migrated to
PowerBuilder 7/Sybase Adaptive Server.
. Over 10 years in application support of various applications including
commercial software product ProSys and other customized applications.
This includes coordination with customers using phone support,
PCAnywhere, VPN, Remote Desktop, and site visits as needed.
. Experienced using PowerBuilder features such as PFC, Dynamic data
windows, MDI, User Objects.
. Expertise in writing complex T-SQL Stored procedures, Functions,
Triggers, Query optimization and Performance Tuning.
. Experienced in using OOPS (Inheritance, Encapsulation, and
Polymorphism) with PowerBuilder
. Good exposure in interacting with clients.
. Good exposure in Finance, Retail & Manufacturing.
. Good analytical, communication & interpersonal skills.
. Strong team management experience along with task planning &
monitoring.
. Perform problem research & analysis.
TECHNICAL SKILLS
RDBMS : MS SQL Server 2005 & 2008, Sybase Adaptive Server,
Sybase SQL Any Where
GUI : Power Builder version 4 to 11, Visual Basic 6.0, VB.NET
2005 & 2008, ASP.NET
Reporting Tools : SQL Reporting Service, Info maker 5 & 7, Crystal
Reports 9, 10 & 11
Operating System : Windows 2000/2003/NT, Windows XP/98/95, MS-DOS, Novell
NetWare 4.0
Languages : T-SQL, XML, HTML
Tools : Interactive SQL, Sybase SQL Central, SSMS, SSAS, SSIS
Others : MS Office, VPN, PC Anywhere, Remote Desktop,
Clipper 5.x, Dbase, FoxPro 2.6,
Visual Fox Pro
WORK EXPERIENCE
Productive Systems, Ahmedabad, India, Jan 1993 - Oct 2009
Client: Katlax Enterprise Pvt. Ltd., Ahmedabad, India (http://katlax.com)
Jan 2006 - Oct 2009
DBA/Developer/Application Support
RDBMS: MS SQL Server 2005
Frontend: PowerBuilder 9.0, VB.Net 2005
OS: Windows 2003 Server
. DBA for Enterprise Resource Planning System (ERP).
. Installed & Configure SQL server 2005 at production environment.
. Creating and maintaining various databases on production/development
servers and provide support.
. Involved with performance tuning.
. Developed Various Reports Using SSRS (Inventory Analysis/Customer
Analysis and Other Reports).
. Configured Log shipping from Production to Disaster Recovery server
for Production Extensive Performance tuning of Queries and System
Hardware configuration For Better system Performance.
. Development of automated daily, weekly and monthly system maintenance
tasks such as database backup, replication verification, database
integrity verification and indexing updates.
. Creating and managing schema objects such as Tables, Views, Indexes
and referential integrity depending on user requirements and
converting them into technical specifications.
. Creating stored procedures, scripts, cursors for the Bulk insert
application, testing on the test servers and moving them to
production.
. Extensive performance tuning, and optimization of procedures and
queries designed for inventory and shipment reports.
. Tested DTS packages to SQL Server 2005 Integration Services.
. Developed extensively the front end screens, report forms & non visual
object inherited from the standard framework.
. Testing, Implementation & Training
. Install Application on different operating system
. Provide Application operational support onsite & offsite (using
PCAnywhere), phone support, even personal customer visits if required.
. Updating application on newer version & Fix the bugs
. Debug & modify the application entry forms & reports as required.
. Developed Web forms; product catalog in ASP.Net, publish on Website.
Client: Deepkiran Foods Pvt. Ltd, India
Aug 2004 - Dec 2005
Developer
RDBMS: Sybase Adaptive Server
Frontend: PowerBuilder 7.0
Tools: Crystal Report 9
OS: Windows 2003 Server, XP
. Create schemas, tables, primary key, foreign key, views & users.
. Create stored procedures, user functions, triggers & cursors.
. Create and maintaining databases on production/development servers and
provide support.
. Create extensively the front end screens inherited from the standard
framework.
. Create Reports in Crystal Reports 9.
. Development of automated daily, weekly and monthly system maintenance
tasks such as database backup, replication verification, database
integrity verification and indexing updates.
. Involved with performance tuning
Develop and support Accounting System (customized version of ProSys) with
Inventory Management. The application maintain inventory, general ledgers,
suppliers, customers, assets, employees, statutory books, summary reports.
Client: Productive Systems, Ahmedabad, India
May 2003 - Jul 2004
Developer/Application Support
RDBMS: Sybase Adaptive Server
Frontend: PowerBuilder 7.0
OS: Windows 2000 Server, 2003 Server, XP
Product: Commercial Software ProSys Accounting System with Inventory
Control
. Create and maintaining databases on production/development servers and
provide support.
. Create schemas, tables, primary key, foreign key, views & users.
. Create stored procedures, user functions, triggers & cursors.
. Create extensively the front end screens inherited from the standard
framework.
. Create Reports in PowerBuilder 7
. Develop distribution set
. Install Application on different operating system
. Provide Application operational support onsite & offsite (using
PCAnywhere) phone support, even personal customer visits if required.
. Updating application on newer version & Fix the bugs
. Debug & modify the application entry forms & reports as required.
Development & Application Support for Commercial Software ProSys Accounting
System with Inventory Control for Manufacturer & Traders. The system
generates statutory reports, analysis summary, collection reports, ledgers,
balance sheet & many more. Many reports & invoice print format was user
generated. The ProSys Accounting System has more than 1000 Customer
Installations with over 3000 users.
Client: Ideal Systems Pvt. Ltd, Ahmedabad, India (www.isplindia.com)
Dec 2000 - Jul 2004
Developer
RDBMS: Sybase Adaptive Server
Frontend: PowerBuilder 7.0, VB.NET 2003
OS: Windows 2000 Server, 2003 Server, XP
. Create and maintaining databases on production/development servers and
provide support.
. Create schemas, tables, primary key, foreign key, views & users.
. Create stored procedures, user functions, triggers & cursors.
. Create extensively the front end screens inherited from the standard
framework.
. Create Reports in PowerBuilder 7.
. Development of automated daily, weekly and monthly system maintenance
tasks such as database backup, replication verification, database
integrity verification and indexing updates.
. Involved with performance tuning
. Oil & Natural Gas Corporation Ltd, (ONGC) Mehasana, India
(www.ongc.gov)
Develop well logging system. It is record keeping application for
the logging department of Mehasana Branch. The application
maintains Inventory, Tools, Manpower, and contractual Manpower,
earnings per project, team performance, location, and breakdown
time; analyze skills, store logging data records (on tape) & many
more.
. Gujarat State Fertilizers & Chemicals Ltd, Baroda, India
(www.gsfclimited.com)
Develop Asset management system. It's record keeping application.
The application maintains Assets valuation on straight-line and
declining-balance method, revaluation of the assets based on
international currency, repairing cost add to asset, depreciation
calculation, scrap the asset, sale the asset & many more.
. Mehasana Nagarpalika, Mehsana, India
(www.mahesananagarpalika.org)
Develop Accounting with Town tax billing system. It's client-server
architecture. The application maintains Tax billing records,
Collections, Budgeting and Expenditure, Birth and Death records,
Employee Payroll and many more.
Client: Scanpoint Graphics Ltd, Ahmedabad, India (www.scanpointindia.com)
Oct 1996 - Nov 2000
DBA/Developer
RDBMS: Sybase SQL Anywhere.
Frontend: PowerBuilder 6
OS: Windows NT 4.0, Windows XP
. Create and maintaining databases on production/development servers and
provide support.
. Create schemas, tables, primary key, foreign key, views & users.
. Create stored procedures, user functions, triggers & cursors.
. Create extensively the front end screens inherited from the standard
framework.
. Create Reports in PowerBuilder 7.
. Development of automated daily, weekly and monthly system maintenance
tasks such as database backup, replication verification, database
integrity verification and indexing updates.
. Involved with performance tuning
Develop and support Accounting Software with Sales monitoring system for
service industry. The software is a full featured real-time record
keeping application. It's a client-server architecture offering
flexibility & scalability. Develop DTS package for integrate data from
branch. Develop branch profitability, budgeting & inventory consumption.
Mar 1993 to Sep 1996 worked as a Programmer at Productive Systems on
various projects for various clients.
. Responsible for coding, testing & implementation.
. Configure invoice printing, tax reports & tax summary.
. Develop standard procedure & function in clipper 5.x
Develop and support a commercial Standard Accounting System in Clipper
5.x. It has many entry forms, reports, user define reporting tool. The
system had more than 1,000 Installations.
Develop Modvat billing system for manufacturer or trader. The systems
have Purchase, Sales & goods return module. They all are cross referenced
each other. We had develop excise value register, summary, excise stock
register with tracking, cross reference register & Carry forward History
to Next accounting year & many more.
EDUCATION
Bachelor in Commerce (Major : Accounting) (1991-1993), Gujarat
University, India
Contact this candidate