Sql Server Developer
Resume:
Title:Senior Programmer
*******@******.***
Document
Source below
NAME: Veeram reddy
ADDRESS:
CITY:
STATE/PROVINCE: VA
ZIP/POSTAL CODE:
COUNTRY: USA
EMAIL: *******@******.***
PHONE:
CANDIDATE ID: 209947
CITIZENSHIP: Permit
EDUCATION:
EXPERIENCE:
WILL RELOCATE: Open
RELOCATION INFO:
JOB WANTED: Any
RATE NEEDED:
HOMEPAGE:
HOTSKILLS:
ESUME
Veeram J Reddy
Contact #: 617-***-****
(Mobile)
Summary:
Around Six years of extensive experience in database administration, analysis,
design, development, data conversion, Data Warehouse/Data Mart design
development and implementation of several client/server applications using MS
SQL Server 6.5/7.0/2000, Oracle 7.3/8.05, PL /SQL, Visual Basic 6.0, Java 1.2,
ASP, SQL Trace, PC Anywhere 9.0, ARCserve IT for Window NT 6.61, Log Explorer,
ODBC, ER
/Studio 3.5/4.0, ERwin 3.5/4.0, BPwin 3.5/4.0, Cognos BI, Informatica
PowerMart 5.0 / PowerCenter 1.5/1.7 (ETL Tool), Visual SourceSafe 6.0, DB
Artisan 5.0/5.1, Windows NT Server, Microsoft Internet Information Server (IIS)
4.0, Exchange Server 5.0, Microsoft Site Server 3.0/4.0 Commerce Edition,
Microsoft Transaction Server (MTS) 2.0 on Windows platforms, MS SQL Server 7.0
OLAP Services(OLAP, MOLAP, ROLAP etc).
As a SQL Server DBA involved in installation, Upgrade, setting up of database
management Systems, configuration, monitoring, tuning, backup and recovery,
security and troubleshooting of SQL Server 6.5/7.0/2000 and also worked on DTS,
BCP utilities. Also worked on MS Windows NT 4.0/3.51, MS Windows 95/98/2000, MS
Visual FoxPro 6.0, MS Word 97, MS Excel 97, MS Access 97, Visual Basic6.0 and
FileMaker Pro 4.1/5.0. Extensive experience on IBM AS/400 (DB2/400, ILE
RPG/400, RPG/400, CL/400, SQL/400, COBOL/400) applications.
Skills
Databases MS-SQL Server 6.5/7.0/2000 Enterprise Edition, Oracle 7/8, IBM
DB2/400, FileMaker Pro 4.1/5.0 (Claris), MS ODBC 32 for Win NT/95, MS Access
97, Sybase SQL Anywhere 7
DBA Database administration for MS SQL Server 7.0/6.5/2000, Oracle 7/8.
Languages SQL, Transact SQL, PL/SQL, COBOL, ILE RPG/400, RPG/400, CL/400,
COBOL/400, SQL/400,COBOL-85, Java 1.2, ASP.
Hardware DEC Alpha 2000, Pentium machines and IBM AS/400.
OS MS Windows NT 4.0/3.51, MS Windows 2000/98/95, MS DOS, OS/400(V3 R7), Unix.
Other S/W MS Site Server 3.0 Commerce Edition, MS Exchange Server 5.0, MS Visual
FoxPro 6.0, MS Word 97, MS Excel 97, MS Access 7.0/97, TCP/IP, LAN, WAN, SQL
Loader.
GUI/Tools Visual Basic 6.0,Developer 2000,Embarcadero ER/Studio (ver 4.0) Data
modeling Tool,
ERwin 3.5, DBArtisan 5.1, Cognos BI (Cognos Impromptu 5.2/6.0, Cognos Scheduler
6.0, CognosScript Editor 6.1, Port Folio 6.6, Power Prompts developer studio
1.0, Access Manager 6.0, Cognos Common Logon Server, Architect 6.0), Rapid SQL
5.5, MS SQL Server 7.0 OLAP Services (OLAP, MOLAP, ROLAP etc), Seagate Crystal
Reports 6.0(Seagate Info & Seagate Analysis), Visual SourceSafe 6.0, Visual
InterDev, Citrix Server, SQL Trace, PC Anywhere 9.0, ARCserve IT for Window NT
6.61, Log Explorer, Pro Vision Network Monitor, ADO
ETL Tools Informatica PowerMart 5.0 / PowerCenter 5.0
Methodologies STARSCHEMA, SNOWFLAKE
Servers Netscape Enterprise Server 3.6, Windows NT Server, Microsoft
Internet Information Server (IIS) 4.0, Exchange Server 5.0, Microsoft Site
Server 3.0/4.0, Microsoft Transaction Server (MTS) 2.0
Education Bachelor of Technology,
SV University, India
EXPERIENCE
A. Chartwell Diversified Services, Inc
., MA
MS SQL Server DBA & Developer
March01 to Till Date
Overview: Chartwell Diversified Services, Inc. is a privately held company
providing home infusion services, clinical respiratory services, home medical
equipment, home health services, and specialty pharmacy services in the United
States.
Responsibilities: Worked as a Database Administrator on MS SQL Server
6.5/7.0/2000 as Production support Database Administrator for maintaining more
than 10 Servers in 24* 7 Environment.
Upgrade the data from SQL Server 6.5 to 7.0.
Prepared in Collections of all attributes at each and every stage, designed the
Database with all the Master and Transactions tables and prepared the
High-Level project and low-level project plan for Business to Business and
Business to Customer.
Extensively wrote scripts for the Database to create indexes, Triggers and
Stored Procedures to improve performance of the applications developed in VB,
ASP and C++. Monitored, captured and analyzed the SQL Server activities,
monitored queries, Stored Procedure, Locks, Transactions and Log changes by
using SQL Server profiler and memory tuning.
Extensively involved in configuring and setup Replication Process
(Transactional, Snapshot and Merge Replication) between the Production Servers.
Setup and configured the PRO VISION Network Monitor to monitor all the
Production and development Server to make sure that all the Production Servers
should be up all the time.
Conversion of data from MS Access to MS SQL Server 7.0 by using DTS.
Backup & recovery - established standards and schedules for backups to DLT tapes
by using ARCServeIT backup agent.
Setup the SQL Mail in SQL Server 7 to allow SQL Server to send and receive
e-mail by establishing a client connection with a mail server and Setup and
configure MS Cluster Services.
B. Craston Printworks Co
., RI
Migration of data from Sybase SQLAnywhere 5.5 to MS SQL Server 7.0
Environment: MS SQL Server 6.5/7.0/2000, Visual Basic 6.0, ASP, C++, Internet
Information Server 3.0/4.0, PC Anywhere 9.0, ARCserve IT for Window NT,
Exchange Server, Log Explorer, Pro Vision Network Monitor, Microsoft Site
Server 3.0, Windows NT/4.0 Server, Windows NT Enterprise Edition 4.0. Windows
2000 professional, Windows 2000 Server, Embarcadero ER/Studio ver 4.0
datamodelling tool, Cognos BI (Cognos Impromptu 5.2/6.0), DBArtisan 5.1, Rapid
SQL 5.5, MS Access 97, MS Excel, Transact SQL.
New Deal Inc and GreenPC Inc, Boston, MA
SQL Server DBA, Designing & Developer
July2000
to Feb01
a. Design of www.GreenPC.com (Asset Mgmt System (B2B) & E-Commerce (B2C))
b. Redesign of www.NewDealInc.com (Intranet & Website)
Overview: GreenPC Inc (Subsidiary of New Deal Inc) is in the business of
refurbishing used computers and selling them in the open market through various
channels. GreenPC picks up used computers from the customers that have been
using them over a period of time. This material is picked from the customer,
brought to a production plant and is refurbished. Some of the materials that
have been brought in from the customer are disposed as scrap (in a lawful
manner) while the good refurbished material is finally sold in the open
market. Regardless the systems are sold or scrapped; the customer is shown a
report of the total materials that were taken into the GreenPC plants.
Responsibilities:
Installation of MS SQL Server 7.0/2000 Enterprise Edition and Installation of
ER/Studio datamodelling tool for Logical and Physical database design.
Analyzed the Business requirements (process) of Asset Management Application
(B2B) and GreenPC e-commerce application (B2C). Collections of all attribute at
each and every stage and design the database with all the master and
transaction tables. Prepared the High-level Project Plan and Low-level Project
Plan for B2B & B2C Process.
Prepared the total documentation of all databases (incl tables, attributes,
relationships, and constraints in logical and physical database design by using
ER/Studio datamodeling tool).
Conversion of data from MS Access to MS SQL Server 7.0 by using DTS. Backup &
recovery - established standards and schedules for backups to DLT tapes by
using ARCServeIT backup agent. Generate a SQL Script for preparation of
database tables at the plants. Setup the SQL Mail in SQL Server 7 to allow SQL
Server to send and receive e-mail by establishing a client connection with a
mail server.
Setup the replication process (Transactional and Snapshot) and Setup and
configure MS Cluster Services. Stored procedures including cursors and views to
drilldown the data from database and interface the tables with the admin tool.
Environment: MS SQL Server 7.0/2000 enterprise edition, Embarcadero ER/Studio
ver 4.0 Datamodelling tool, DBArtisan 5.1, Rapid SQL 5.5, MS Access 97, MS
Excel, Transact SQL, Windows NT 4.0, Windows 2000 Professional, Site Server 3.0
Commerce Edition, ARCserve IT for Window NT 6.61, Exchange Server, PCAnywhere
9.0.
Momentix.com Inc, Boston, MA
MS SQL Server DBA & Developer
April2000
to June2000ITEC
(ITEC: Information Technology Expositions & Conferences) Project
Responsibilities:
I was primarily involved in the migration of data from file maker pro
4.1(Claris) to Tab Separated Text format and then to the SQL Server 7.0 by
using DTS wizards and packages and created the Stored Procedures to delete
(data cleansing) the funky data (bad characters) after import the data to SQL
Server 7.0.
Installed Windows NT Server 4.0 Enterprise Edition, MS SQL Server 6.5/7.0
Enterprise Edition, Microsoft Transaction Server 2.0, Internet Information
Server 4.0. Setup and Maintained the replication servers and developed a Claims
System using Visual Basic 6.0/ Java (JDK 1.1) with MS SQL Server 7.0 as
backend. Implemented Database reorg procedures to de-fragment the database and
to maintain data integrity. Implemented Backup and Recovery strategies and
database level exports. Tested the new applications (developed in Visual Basic)
& trained the users for the new system and Prime responsibilities for all DBA
activities for SQL Server 7.0 Databases - Logical/ physical design of
databases, defining of roles, profiles etc., backups, performance issues,
connectivity to database, creation of database links, upgrade strategies,
capacity planning & tuning. Wrote test plans for MS SQL Server 6.5 to MS SQL
Server 7.0 migration. Generated necessary test-data and populated tables.
Environment: MS SQL Server 7.0, FileMaker Pro 4.1 & 5.0(Claris), MS Access 97,
MS Excel, MS Visual FoxPro 6.0, Transact SQL and ER/Studio Datamodeling Tool,
MS SQL Server 7.0 OLAP services etc, Visual Basic 6.0, JDK 1.1, ASP, HTML,
Internet Information Server (IIS) 4.0, Exchange Server, Microsoft Transaction
Server (MTS) 2.0, Windows NT/4.0.
Qwest Communications International Inc, Denver, CO
SQL Server DBA, Developer and Data Warehouse Analyst
Aug99
To March00Redesign Of WWW.QWEST.COM
Responsibilities:
I was primarily involved in the creation of the SQL database that would hold all
the content using SQL Server 7.0. This involved designing a schema of reference
and data tables that would adequately handle all the necessary information and
developing stored procedures and view to interface the tables with the admin
tools. An OLAP cube was also created to monitor the progress of the site
creation (in terms of number of web pages created) during the development
phase. And also I ported the data from MS Access 97 to MS SQL Server 7.0 by
using DTS wizard and have done normalization of the tables. Creation of
databases and transaction logs.
Installed Windows NT Server 4.0 Enterprise Edition, MS SQL Server 6.5/7.0
Enterprise Edition, Microsoft Transaction Server 2.0, Internet Information
Server 4.0. Upgrade the data from SQL Server 6.5 to 7.0.
Scheduling events using Windows NT and SQL Server to perform tasks such as
backups and replication.
Upgrade the data from SQL Server 6.5 to 7.0.
Extensively involved in configuring and setup Replication Process
(Transactional, Snapshot and Merge Replication) between the Production Servers.
Setup and configured the PRO VISION Network Monitor to monitor all the
Production and development Server to make sure that all the Production Severs
should be up all the time
Backup & recovery - established standards and schedules for backups to DLT tapes
by using ARCServeIT backup agent and Setup the SQL Mail in SQL Server 7 to
allows SQL Server to send and receive e-mail by establishing a client
connection with a mail server.
As a data analyst involved in design, development and maintenance of Data
Warehouse. Created dimensions and facts in physical data model using ERwin
tool. Design and developing Multi Dimensional Cubes using MS OLAP.
Design star and outrigger data model in this application. Data loading programs
written from Source systems into Operational data storage. Data extracted from
marketing data mart into EXCEL spread sheets for analysis.
Supported the process steps under development, test and production environment
Environment: MS SQL Server 6.5/7.0 Enterprise Edition, Transact SQL, MS Access
97 and MS SQL Server 7.0 OLAP services, Visual Basic 6.0, ARCserve IT for
Window NT 6.61, ERwin 3.5 Datamodelling tool, BPwin 3.5, Cognos BI (Cognos
Impromptu 5.2/6.0), ASP, HTML, Internet Information Server (IIS) 4.0, Exchange
Server, Microsoft Transaction Server (MTS) 2.0, Windows NT/4.0.
Caliber Systems Inc, USA
Oracle DBA and Analyst
Oct98
to July99
Robert Bosch (India) Ltd
., India
Responsibilities as an Oracle
DBA:
Oracle server configuration and modification of the initialization parameters in
init.ora files. Controlling checkpoints and log switches. Suitably creating and
modifying the control files. Managing starts up and shut down processes.
Managing the table spaces i.e. creating and dropping the table spaces. Altering
the structures and storage parameters. Coalescing the table spaces for space
availability. Managing the data files by resizing and adding whenever space is
required. Renaming the data files. Managing the schema objects like tables,
indexes, views, synonyms, clusters, etc., Managing the Rollback Segment table
space by creating, dropping and taking them off line or on line and Writing the
stored procedures, functions and packages and database triggers. Database
concurrency through different types of Locks.
Database Security: Establishing the system, user, and data table space policies.
Creating and dropping the users, roles and profiles. Granting and revoking the
privileges, roles and managing the resources with the profiles.
Evolved the backup strategies and tested them for recoveries. Cold or Offline
back up, Hot or online backup of the database in archive logs mode and Recovery
of the Database through the Imports, and restoring the from the backups either
hot or cold.
Collected the database statistics of the users, tables, indexes etc for
rebuilding the same and Collected the system statistics for the Table spaces,
Rollback segments, Redo log buffers, caches, and input/output.
Environment: Oracle 7.x, Developer 2000, SQL Forms 4.5, SQL Plus, SQL Loader, MS
Windows NT, Import/Export, Oracle Reports 2.5, Designer2000, PL/SQL.
Pentafour Energy and Fuel System Ltd
., India
SQL Server DBA & Developer
June97
to Sep98
Responsible for:
Payroll, Marketing & Material management Systems
Worked on maintenance of a Payroll, Marketing and Material Management Systems.
Responsible for leading the team of five members, managing data processing
activities and system development.
Modules of master maintenance, bill of materials, material requirement planning,
purchase order, receiving report, internal transactions and reports.
System analysis and design, coding, testing and implementation.
Coding of programs for Marketing Information System. Modules of order dispatch
and report namely orders, pending orders, dispatch details, invoices,
outstanding statements, target Vs actual sales and sales journals.
Coding of programs for payroll and personnel information system
Coding of programs for Material Management System
Environment: MS SQL Server 6.5,T-SQL, Visual Basic, and Windows NT.
TATA-IBM
(Banking Information System)
AS/400 Developer
April96
to April97
Description:
Modules: Front Office, Loan Accounts.
Front Office: This Module consists of various Accounts like Individual Accounts,
Time deposits, and Recurring deposits.
Individual Accounts: This consists of debit and credit of various accounts by
cash and transfer.
Time deposits: Time deposit is the deposit for the fixed time as opted by the
customer.
Recurring deposit: Where the deposits are accepted in fixed installments for a
fixed period.
Loan Accounts: This module consists of various accounts information like
Current Account over draft, Term loans.
Current Account over draft: Where a limit is fixed and drawings are allowed to
the extent of this limit.
Term loans: Where installments (monthly, quarterly or yearly) are fixed for
repayments of loans, Periodical interests apply on the out standings will be
carried out.
Environment: RPG/400,CL/400, DB2/400, IBM AS/400(OS/400).
Contact this candidate