Sql Server Data

Anil Chapala

Email: ****.*******@*****.*** Phone:

*** -***-****

Summary:

. About 8 years of experience in MS-SQL SERVER Database Installations,

Configurations, Development, Implementation, Maintenance and Support.

. Over 7 Years precise expertise in Application Development, Data Modeling,

Data Migration, Data Up gradations, Data Conversion and Interface.

. Over 3 years experience in Microsoft Analysis, Reporting and Integration

Services - SSAS, SSRS and SSIS(ETL).

. Very Experienced in developing Stored Procedures, user defined Functions,

Triggers, Views, SSIS Packages and SQL Server Reports.

. Very good experience in Data warehousing for Enterprise level - OLAP,

OLTP, Data Marts.

. Created Dimensional Cubes using MDX scripts in SSAS for Data warehouse

and Data mart solutions.

. Experience in creating objects and coding in ASP.NET, VB.NET and C#.NET

and establishing the Data Layer and Connectivity using ADO.NET and Grid

Controls.

. Have very good experience in using Configuration Tools - Surface Area

Configuration Manager, Report Services Configuration, IIS and Performance

Tools - SQL Server Agent, SQL Server Profiler and Tuning Advisor.

. Experienced in Business Data analysis, Design, Modeling and

Implementation on major RDBMS (SQL Server 2000/2005). Worked extensively

with Stored Procedures, Triggers and Indexes.

. Extensive experience through all the phases of Full life cycle

Development including requirements gathering, technical specifications,

analysis, design, implementation, testing, and operations of large-scale

enterprise wide applications.

. Involved in exhaustive Performance Tuning, Monitoring and Optimization of

T-SQL complex scripts, queries in both Development and Production

environment for SQL server database.

. Expert in Developing and Supporting both Production and Development

Systems.

. Successful track record of maintaining Financial, Investment Banking,

Insurance, Manufacturing, Sales and Supply-Chain databases for corporate

sectors.

. Experienced in E-R modeling and Relational & Object Relational Database

concepts, coding and excellent database normalization skills.

. Strong in Writing User Manuals, Documentation, Proposals and in preparing

Technical Specifications for the projects/Products.

. Ability to work directly with clients in order to conceptualize their

requirements into workable process designs. Ability to work in a

multicultural environment with excellent communication and interpersonal

skills, Exceptional ability to quickly master new Technologies

. Very Good Exposure to the entire Software Development Life Cycle (SDLC).

Education:

. B Tech in Electrical & Electronics Engineering from JNTU - India

. Certified Computer Systems Administrator (CSA) in HP-UXv11

Technical Skills

Languages T-SQL, PL/SQL, C#, C, C++, UNIX shell scripts, XML, HTML

Databases MS SQL Server 2005/2000, Oracle 8i/9i and 10g, DB2, MS Access

ETL Tools SSIS, Oracle Warehouse Builder-10g, Informatica Power Center

5.x/6.x/7.x/8.1 (Source Analyzer, Mapping Designer,

Workflow Monitor, Workflow Manager)

Reporting Tools SSRS, Business Objects XI R2

Others TOAD, PL/SQL Developer, SQL-Navigator, Test Director, Win

Runner

Database Skills Stored Procedures, Database Triggers and packages

Data Modeling Tools Physical and Logical Data Modeling using ERWIN

Operating Systems Windows NT, Windows 2000, XP, UNIX

.NET Framework MS VISUAL STUDIO 2005, C#.NET, ASP.NET, ADO.NET

ERP SAP R/3 Architecture 4.7ee and 4.6ce

Experience:

Direct Energy, Pittsburgh, PA

Mar 2010 to Till Date Senior SQL Server Developer / DW

Responsibilities:

. Using the Data Mapping Document - Created all the Data Objects and

coded all the required Stored Procedures for Raw, Stage, DW and Data

Mart Environments respectively for the Contracts, Transaction

Management, Usage, Billing, and Pricing Cubes.

. Designed the test cases for validating the Data in the Data Marts and

in the Data Warehouse.

. Maintained the Data Integrity and Data Validity throughout the Process

of building the DW.

. Using TFS Server and Visual Studio 2008- Schema Comparisons and

Database Comparisons -synchronized all the DEV, SIT and PROD

Environments.

. Created the Dash Boards in Excel and in PPM.

Environment: MS SQL Server 2005, MS SQL Server BIDS, MS Visual Studio 2008,

MS Visual Studio 2005, Windows XP, Team Foundation Server, Performance

Point Monitoring Server.

McKesson Health Care Corporation, Cranberry, PA

Sept 2009 to Feb 2010

Senior SQL Server Developer

Responsibilities:

. Worked on the Large SQL Server 2005/2000 Databases for McKesson

Automation Products, Manual Products, Pharmacy, AcuDose Cabinet and

Nursing Departments.

. Created and Modified T-SQL Complex Views for the Pharmacy Team in

Connect-Rx which utilizes these views to generate Pharmacy Reports by

utilizing T-SQL Joins, Unions, Union All and Pivot functions.

. Migrated the T-SQL Complex Views and redesigned and redeveloped the

Views in ADS/HBI System.

. Wrote complex ad-hoc queries to retrieve the Data using necessary

Joins, Unions and Aggregate functions according to the Client's

requirements and analyzed the Data in the spreadsheets.

. Installed and Configured SQL Server 2005 Report Server, Report

Manager, IIS and Report Builder in SSRS from scratch.

. Developed and Designed SSRS Reports for McKesson Automation Products

and Manual Products.

. Generated Reports for Drill down, Drill through and Sub-Reports for

Med Carousel, AcuDose-Rx, and Robot-Rx and for Narcotics - Scheduled

and deployed them in SSRS Report Manager.

. Migrated and Redeveloped and Redesigned 50+ Reports from HBI/ADS

System into SQL Server Reporting Services 2005.

. Created and Modified Complex T-SQL Stored Procedures when and where

necessary for ADS Application and for SSRS Reports.

. Responsible for taking full Backups of the Datacenters, Migrating them

to other Network Servers and Restoring them in Network Servers.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server BIDS, MS

Visual Studio 2005, Windows XP, Windows 2003 Server, Connect-RX and HBI.

ARI Investments, Jenkintown, PA Feb 2009 to

Aug 2009

Senior SQL Server Developer / C#.NET, ASP.NET

Responsibilities:

. Designed, Planned and Installed Instances and Databases in SQL Server

2005 for huge Email Campaigning from scratch.

. Extensively written several T-SQL Stored Procedures which scrubs the

email accounts and checks if there are any special characters in the

email accounts and syntax validate.

. Set up the SQLMail by using the SMTP Mail Server account and Coded T-

SQL Stored Procedures that send out html or text type emails using

SQLMail on regular intervals.

. Coded T-SQL Stored Procedures that send out html or text type emails

using T-SQL on regular intervals by using the Native XML Web Services

and xp_cmdshell being enabled.

. Used Regular Expressions for validating the Email Addresses and the

SSN's for the Customers in the T-SQL Stored Procedures.

. Written T-SQL stored procedures for data migration from legacy systems

to SQL Server and automated them by using SQL jobs that run on regular

intervals of time.

. Upgraded and Migrated the Production Databases(which includes Tables,

Views, Stored Procedures, Triggers, User Logins etc) and the

Development Databases from SQL Server 2005 to SQL Server 2008

. Wrote complex ad-hoc queries to retrieve the Data using necessary

Joins and Aggregate functions according to the Client's requirements

and analyzed the Data in the spreadsheets.

. Fine tuned complex ad-hoc batch queries and optimized the performance.

. Developed and designed a small application level User interface (GUI)

Web Page using ASP.NET Pages,HTML Contols,Web Controls (Included

Regular Expressions Validator Control)

and C#.NET as Code Behind Page.

. XML is utilized as code behind page for generating Vendor Reports and

ad-hoc reports.

. Established the data connectivity using Grid Controls in ASP.NET and

exposed the Data to end users in the required formats on Web Page.

. Created Data Sources, Data Source Views, Dimensional Hierarchies and

Key Performance Indicators(KPI's) in the OLAP Cubes using the SQL

Server Analysis Services(SSAS)

. Created Data Views to retrieve subset of rows from a Data Table and

sort the Data.

. Developed MDX scripts for generating Dimensional Cubes and implemented

Type I, Type II changes in slowly changing dimensional tables.

. Created KPI's(Key Performance Indicators) in PPS(Performance Point

Server) based on SSAS KPI's.

. Used MDX Expressions to create individual Performance Point Server

KPI's.

. Worked Extensively with SSIS Packages - Upgraded and Migrated some of

the DTS packages written in SQL Server 2000 to SSIS Packages in SQL

Server 2005

. Performance tuning of T-SQL queries and stored procedures using T-SQL

Profiler, Estimated Query Plan and Index Tuning Wizard.

. Designed, Developed and Deployed SSIS Packages that scrubs (filters)

the given email accounts and gives the valid email accounts in an

Excel sheet and CSV file on Demand.

. Installed and configured SQL Server Report Server, Report Manager, IIS

and Report Builder in SSRS.

. Designed, Planned, Installed and set up Distributor, Publisher and

Subscriber for Transactional Replication from scratch for getting the

live data reports.

. Created and Configured Clustered Environment from scratch in SQL

Server 2008 on Production Environment for High Availability.

. Complete User Management - Creating logins, users on OS level and DB

level and giving permissions to the stored procedures on Application

level.

. SQL Server Agent Jobs - Wrote full Backup Jobs and scheduled the Jobs

that run on regular off-peak business intervals for the Production

databases.

. Wrote Full text Index and analyzed Database performance with Tuning

Advisor and Optimized Indexes to improve queries

. Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and

networking).

. Developed and generated 80+ customized Reports, ad-hoc Reports and on

demand Reports using SSRS and published them in PDF, Excel and CSV

formats for Daily business needs.

. Generated Drilled Down Reports, Deployed the Reports and scheduled the

Reports in SSRS to run on predetermined time.

. Developed and generated ad-hoc Reports, chart Reports and pie Reports

using Report Builder

. Developed and generated customized Reports, ad-hoc Reports and on

demand Reports using SSRS and published them in PDF, Excel and CSV

formats for Daily business needs

. Deployed the Reports and scheduled the Reports in SSRS to run on

predetermined time

. Installed the mySQL driver and established the connection between

mySQL Database (php list)

to the development server for huge email campaigning.

Environment: MS SQL Server 2008/2005, MS SQL Server 2000, MS SQL Server

BIDS, MS Visual Studio 2005,Windows XP, Windows 2003 Server, Copia

Server,XML Environment,Siebel 7.7

Ernst & Young, Cleveland OH Apr

2008 to Jan 2009

Senior SQL Server Developer / DBA

Responsibilities:

. Responsible for maintaining 8 Individual Projects, 24+ Instances and

200+ Databases (4TB).

. Designed, Developed and Deployed SSIS Packages for Data Migration from

Oracle to SQL Server 2005.

. Developed and Maintained SSIS Packages from scratch -Deployed SSIS

Packages on a regular basis, and Migrated DTS Packages in SQL Server

2000 to SSIS Packages in SQL Server 2005.

. Established the data layer connection between legacy systems, DB2,

People soft Environment (Oracle is the Source DB) to the Destination-

QA and Staging Servers having SQL Server 2005 by using Connection

Manager in SSIS Packages

. Deployed the DP Projects (dbpro) on my local machine using the Team

Foundation Server (TFS) and check in and check out of the SSIS

Packages and Reports.

. Have written T-SQL Stored Procedures to extract Large Amount of Data

from One Server Instance to another Server Instance using Dynamic SQL.

. Involved in Coding and Debugging and Enhancement of Complex Batch T-

SQL Procedures and Functions.

. Responsible for the monthly Load Process of the Production Data of

Reuters, Muller and IDC Data from FTP Servers.

. Running the T-SQL Scripts against the Databases on the QA Servers or

the Staging Servers, Used SQL Profiler for tracing and debugging of

the SQL scripts.

. Efficiently used Sub Queries, Joins and Cursors whenever they are

required for increasing the Accuracy and Performance of the Queries in

a T-SQL Stored Procedures.

. Worked on SQL Server Business Intelligence Development Studio -

Designed, Developed, Deployed and Maintained SSIS Packages and

Generating the Reports.

. Designed and Developed Dimensional model OLAP Cubes using SSAS from

scratch.

. Created Data Sources, Data Source Views, Dimensional Hierarchies and

Key Performance Indicators(KPI's) in the OLAP Cubes using the SQL

Server Analysis Services(SSAS)

. Used MDX scripts for querying the Data from OLAP Cubes for generating

the SSRS Reports on top of the SSAS Cubes Created and Modified Indexes

for the Database Performance.

. Upgraded and Migrated the (GAAIT Application) and (APT Application)

Development Databases which includes (Tables, Views, Stored

procedures, Logins, Triggers etc) from SQL Server 2000 to SQL Server

2005.

. Installed and Configured Oracle 9i Instance along with SQL Server 2005

on Production Environment.

. Scheduled the SQL Server Agent Jobs and enabled and disabled the

Linked Server Connections.

. Involved in the Day-To-Day DBA Activities - Taking Full Database

Backups of the Databases in QA and Staging Servers.

. Restoring the Databases using the Production Backup files in DEV, QA

or Staging Servers.

. Creating the Logins, userid's and Passwords for the Users on Database

level and Mapping them to the respective Database.

. Granting or Revoking Database Access Permissions for Logins as per the

requirement.

. Giving Access to the Domain Account Users on the Operating System

Level for Remote Desktop Connections.

. Running the Scripts against the Databases on the QA Servers or the

Staging Servers.

. Regularly Contributing the DBA Activities on the Build Deployment

(Weekly or Monthly) as per the requirement.

. Designed and Installed snapshot Replication and peer-to-peer

Transactional Replication (Distributor, Publisher and Subscriber).

. Have done On Call Support for the Production Environment if there are

any Database issues.

. Copied shared Items from one server to another server -both using

ProClarity 6.2 Analytics Server.

. Configured and Maintained the SQL Server Log shipping from Scratch in

the Staging Environment.

. Used SQL*Plus to query the HR Source (People soft Environment -Oracle

is the DB Source)

. Designed, Created, Deployed and Maintained custom selection of 80+ SQL

Server Tabular Reports from scratch by using SSRS.

. Scheduled the Reports by using Reporting Services (SSRS) to be

generated on predetermined time..

. Generated a tree view application to view the recent reports generated

and a scheduler to schedule a selected report to be run on a

particular date.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server BIDS, MS

Visual Studio 2005, MS Visual Studio TFS, Windows XP, Windows 2003 Server,

IBM Web Sphere 6.1, IBM Lotus Notes 6.5, Java, SameTime 7.5,ASP.NET, XML

Environment,Performance Point Server, Share Point, ProClarity

BNY (Bank of New York) Mellon, Pittsburgh PA

October 2007 to Mar 2008

SQL Server Developer

Responsibilities:

. Developed 160+ T-SQL Stored Procedures to handle large amount of Data

manipulation for Investment Banking financial factors like Market

Capitalization, Dollar Trading Volume etc. per each Security(per

Stock) per each day traded with NYSE for Russell 1000, S&P 500,Wilshire 5000 and Benchmarks Companies and to load the Historical

Data into the Long Tables for Research Analysis.

. Designed and Maintained SSIS Packages for Importing and Exporting Data

Migration and Conversion from Legacy Systems to SQL Server 2005

. Involved in Development and Debugging and Enhancement of Complex Batch

T- SQL Procedures and Functions.

. Worked on SQL Server Management Studio for Database Creation,

Operations and Maintenance.

. Created several Complex Views according to the Client Requirements

whenever needed.

. Extensively used Inner Joins, Outer Joins and Self Joins in Stored

process.

. Very efficiently used Sub Queries and Cursors whenever they are

required for increasing the Accuracy and Performance of the Queries in

a Stored Process.

. Worked extensively on Documenting the Design Specifications

. Worked in Importing and Cleansing of Data from various sources like

DB2, Oracle, and Flat Files onto SQL Server 2005 with high volume

data.

. Extensively used MDX Scripts and exported data to OLAP services for

generating Reports using SSIS Packages.

. Exported data to OLAP services for generating Reports using SSIS

Packages.

. Involved as a key team member for Requirement Analysis during the

design phase and interaction with the client.

. Extensively Involved in Preparing Detailed Technical Documents from

the Functional Specifications.

. Source Code Management and Version Control using Team Foundation

Server (TFS)

. Reviewed the logical and physical database design and Technical

Specifications.

. Involved in day-to-day Database Maintenance Operations - Loading the

Historical data into the Long Tables Daily, Weekly and Monthly and

Maintaining the backup-restore jobs schedules, code promotions and

server maintenance in a real time production and Stage environment.

. Involved in Query Optimizations and Performance Tuning for the Stored

Procedures.

. Designed and Developed Pivot Tables on Excel Sheets to refresh the

data on timely basis.

. Established the Connection between Excel and Database to pull the data

from Tables on to Excel Sheets from the Database to consolidate the

data for Validation.

. Developed and implemented Replication architecture to replicate data

across multiple sites.

. Developed Custom Selection of reports ordering using SQL Server

Reporting Services.

. Generated various reporting service RDL'S using reporting services for

Asset Allocation and Account Aggregation reports.

. Source Code management through

. Used Reporting Services to schedule various reports to be generated on

predetermined time.

. Created a tree view application to view the recent reports generated

and a scheduler to schedule a selected report to be run on a

particular date.

Environment: MS SQL Server 2005, SQL Server BIDS, SAS 9.1.3, SAS EG 4.1,

SAS Management Console 9.1, SAS Information Map Studio 3.1, Windows XP

AETNA HealthCare, Middletown, CT Aug 2006 to

September 2007

SQL Server Developer

Responsibilities:

. Worked on SQL Server Management Studio for database creation,

operations and maintenance.

. Involved in development and debugging of complex batch T- SQL

Procedures and functions.

. Designed DTS Packages for importing and exporting data migration and

conversion.

. Exported data to OLAP services for generating Reports using SSIS.

. Developed and implemented Replication architecture to replicate data

across multiple sites.

. Developed Custom Selection of reports ordering using SQL Server

Reporting Services.

. Generated various reporting service RDL'S using reporting services for

Asset Allocation and Account Aggregation reports.

. Developed several stored procedures to handle large amount of data

manipulation.

. Used Reporting Services to schedule various reports to be generated on

predetermined time.

. Created a tree view application to view the recent reports generated

and a scheduler to schedule a selected report to be run on a

particular date.

. Source Code Management and Version Control using Visual Source Safe

. Tuning the Performance of Database (SQL Profiler), Query Optimization

and Application tuning, Determining and Tuning the I/O and Memory

Utilization, Replication Environment Configuration.

. Provided Tier1 Application support with 24/7 production support.

. Implemented replication methods for high data availability at all

sites.

. Involved in implementing add-in services (e.g. Reporting, Integration,

Broker, Analysis, Notification)

. Performed performance analysis, troubleshooting, and tuning for

databases at client site.

. Worked in importing and cleansing of data from various sources like

DB2, Oracle, flat files onto SQL Server 2000 with high volume data.

. Involved in day-today database maintenance operations. Maintaining the

backup-restore jobs schedules, code promotions and server maintenance

in a real time production and Stage environment.

. Involved in day-today database maintenance operations.

. Maintaining the backup-restore jobs schedules, code promotions and

server maintenance in a real time production and Stage environment.

. Involved in Query Optimizations and performance tuning for the stored

procedures.

Environment: MS SQL Server 2000/2005, SQL Server Reporting Services

2000/2005, DB2, Oracle 9i, Cold Fusion, QTP & win runner, Erwin 4.0,

Informatica 6 Power center.

Georgia Pacific, Atlanta, GA Dec 2005 to

Aug 2006

SQL Server Developer

Responsibilities:

. Converted Logical Database Diagram into Physical Schema using the

balanced Normalization in 2nd and 3rd Normal Form for highest

performance.

. Maintained database and Backup/recovery. Defined Database Maintenance

Plan, which was scheduled as job, which ran automatically.

. Wrote Stored Procedures to handle complex calculations and wrote logic

to maintain the history of entities which was also passed on to the

application via Stored Procedures.

. Explored the use of User Defined Functions to encapsulate commonly

used logic in the stored proc and maximized the readability of such

Stored Procedures.

. Performance tuning of T-SQL queries and stored procedures using T-SQL

Profiler, Estimated Query Plan and Index Tuning Wizard.

. Used Visual Source Safe as a tool for repository of codes and version

control, also maintained test scripts and documentation following the

standards of HRMS.

. Transferred data from flat files, Excel spreadsheets and heterogeneous

data to and from T-SQL Server using DTS and also used BCP and Bulk

Insert.

. Created and managed users, roles and groups and handled database

security.

. Added replication definition and its function on Reporting Server and

monitored replication.

. Managed test data and their updates between development and production

databases and migrated stored procedures and database objects.

. Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and

networking).

. Extensively used XML documents to pass multiple parameters for Stored

Procedures to read and write database table. Designed XML documents

and generated XML documents from tables.

. Handled development and production support, document reviews, test

plan, integration of the system.

. Documented all processes and Data Flow involved in the database for

future reference.

Environment: MS SQL Server 2000 Enterprise Edition, Windows 2000, MS Access

2000 and MS Excel.

Regions Financial Corporation, Birmingham, AL Jun

2004 to Dec 2005

SQL Developer

Responsibilities:

. Involved in Data warehouse set up for Financial Applications data.

. Analysis of the user requirement, design, develops and implementation

of Data warehouse system.

. Involved in Dimensional modeling of the Data warehouse and used Erwin

to design the business process, grain, dimensions and measured facts.

. Using ER diagram and MS-Visio to design the basic database diagram

. Using front-end applications (Visual Basic 6.0) to access the database

. Creating database objects like triggers to enforce data integrity

. Involved in database analysis and design and business logic modules.

. Involved in performance tuning and maintenance of application.

. Assisted in the development of database objects like table, stored

procedures and database scripting.

. The data migration was done between the SQL Server and MS Access at

each client machine.

. Worked Extensively with Excel to import, export and transform the data

between the linked servers.

. Involved in Database Migration and Upgradation from SQL Server2000 to

SQL Server 2005.

. Wrote T-SQL stored procedures and triggers to carry out various tasks.

Environment: MS SQL Server 2000, MS SQL Server 2000, DB2, Oracle 7.0/8.0,

Erwin 4.0, Windows NT/2000/2003.

National Health Service (NHS), London, UK June 2003 to May

2004

DW Consultant

Responsibilities:

. Wrote several ETL functions in PL/SQL for aggregation and summation

purpose.

. Scripts were run through UNIX shell programs in Batch scheduling.

. Created Aggregator, expression, filter, joiner, look up, rank,

sequence generator, source qualifier, were implemented to load the

data from source to ODS to DDS.

. Finding the Production problem issues and solving the problems as per

user requirements.

. Preparing System change requests (SCR) for raising the new problems in

Warehouse.

. Solved the Data issues for performance measurement and accounting

applications.

. Created Data validation scripts to verify the loading process form

Source to ODS to DDS.

. Created stored procedures, Functions and Schema objects for Retail

Data warehouse.

. Evaluated existing business rules and System Design.

. Installation and configuration of BO and webi.

. Installed BCA on distributed environment.

. Implementing Rapid Deployment Templates (RDT's) for Oracle

Applications

. Design and develop Business Objects 5.0 universes for an enterprise

data warehouse.

. Customized the RDT's (universes) for all financial modules.

. Worked on linked universes (component approach - GL/AP, GL/AR, AP/PO.

. Developed complex reports like Budget vs. Actual report and Balance

sheet reports.

. Perform architecture planning and implementation for the Business

Objects 5.0 environment.

. Scheduled reports with BCA (Broad Cast Agent).

. Plan, coordinate and execute Business Objects 5.0 deployment for End

users.

. Train user community in basic and advanced Business Objects reporting

skills.

. Provide ongoing administration for the Business Objects 5.0

environment.

. Developed Budget reports for different level of users.

. Developed Budget vs. Actual reports for different periods in Oracle

reports.

. Created power users for different departments and assigned as

Designers and Supervisors.

. Defined several categories for different set of reports.

. Implemented report bursting by using BCA.

Environment: Oracle 8.0 Informatica 5.0, Erwin, PL/SQL, Oracle

Applications, Business Objects 5.0, Web Intelligence 2.5, SQL*Plus,

SQL*Loader, UNIX Shell Scripts

Lloyds TSB - Insurance, London, UK April 2002 to June

2003

DW Consultant

Responsibilities:

. Producing various reports as per the requests of the other departments

. Identifying the groups that the different customers fell into using

the appropriate conditions and requirements

. Installed Informatica on Sun Solaris (Unix)

. Administered and monitored Business Objects repository and Web

Intelligence.

. Sharing Business Objects reports with Web Intelligence and Document

Agent Server

. Created Business Objects and Repository in Oracle using Supervisor and

managed it.

. Writing inserts and updates queries, which will add new customers to

the marketing, table and expire the old ones automatically every week.

. Tuning SQL queries in order to increase the performance related issues

of the existing database packages & functions.

Environment: Business Objects 5.1, Designer/Supervisor, Document Agent

Server, BCA, Web Intelligence, Oracle 8.0, Informatica, Sybase, UNIX/ Win

NT.

Plant Organics Limited, India April 2001 to May

2002

SQL Developer

Responsibilities:

. T-SQL was extensively utilized for coding and writing complex database

triggers, stored procedures and packages.

. Developed SQL Applications for extracting the data from the tables.

Involved in analysis, coding, testing and implementation of T-SQL on

WINDOWS environment.

. Wrote complex queries and procedures in T-SQL.

. Created indexes on tables for fast retrieval of data.

. Extensive testing was done on the programs for achieving accuracy,

timely processing of data.

. Involved in the development of backend procedures by using T-SQL for

ledger posting and for reversing the journal ledgers.

Environment: Windows NT/2000, MS SQL Server 2000, MS-Access.

Contact this candidate