Beena Shaik

214-***-****

acofoz@r.postjobfree.com

Tools/Methods relevant Experience

Management Studio Beena is an accomplished Microsoft Certified

SQL Profiler SQL Server DBA with 9 years of experience in

Enterprise Manager Design, Development & Supporting MS SQL

Query Analyzer Server's 2008, 2005 and 2000 in Production, QA

DTS/SSIS, SSAS, SSRS and Development Environments.

MS SQL Server

2008/2005/2000/7.0 Oracle, SKILLS INVENTORY

MS Access Excellent skills in creating Database Objects

T-SQL, C, C++, C# like Tables, Views, Triggers, Stored

ASP.NET, Visual Basic Procedures, User Defined Functions and writing

Windows Server 200 complex T-SQL queries.

Windows XP/2000/95/NT Good experience in Deploying SSIS packages in

Cognos 8, MS SQL Server 2005 and MS SQL Server 2008.

MS Word, Excel, Power Point Excellent experience in In-Place and

Side-by-side upgrades from SQL Server 2000 to

SQL Server 2005.

Excellent experience in installation and

configuration of MS SQL Server 2008, 2005 &

clients 2000 versions.

Hartford Hospitals Excellent experience in maintaining,

Blue Cross Blue Shield supporting, monitoring production and test

Sentara environments.

Dollar Tree Inc. Expertise in planning and implementing MS SQL

Ameri Group server security and database permissions.

AT&T Excellent working experience in Management

Anheuser-Busch Companies, Studio, Enterprise Manager and Query Analyzer.

Inc. Experience working with large databases and

BUSINESS ADVANTAGE Inc. experience in supporting multiple production

COMPLIANCE 11, Inc. database servers.

Great West HealthCare Sound knowledge on database driven application

Space Computers & Dev using Visual Basic, ASP in .NET framework.

Center Intensive experience in monitoring and tuning

SQL Server and database performance using SQL

Profiler, Index Tuning Wizard and Performance

Monitor.

EDUCATION Experience in Database Backup, Recovery and

Bachelor of Technology Disaster Recovery procedures.

(Electronics & Hands on experience in migrating DTS packages

Communications) India to SSIS packages.

Experience in supporting very large Databases

(Terabytes).

Experience in Data Modeling (Logical and

CERTIFICATION Physical Design) of Databases, Normalization

Microsoft Certification in and building Referential Integrity Constraints.

Implementation and

Maintenance SQL Server 2005 Experience in transforming data from one server

to other servers using tools like Bulk Copy

Program (BCP) and Data Transformation Services

(DTS) and SSIS.

Experience in SQL Server Reporting Services

(SSRS).

Hands on experience in maintenance of

Databases, creating roles and managing user

permissions, and resolving deadlocks.

Experience in investigating and applying

necessary SQL Server database service packs and

patches.

CHRONOLOGICAL SUMMARY OF EXPERIENCE

Senior SQL Server DBA

Hartford Hospitals, Hartford, CT

April 2013 - Present

Hartford Hospital is the major teaching hospital affiliated with the

University Of Connecticut Medical School, serving the New England region

including large employer groups, small business and individuals.

. Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and

clustered environments and applied service pack.

. Involved in designing and creating Databases, Tables, Views, Stored

Procedures and Triggers.

. Hands on experience with developing reports using SSRS.

. Interacted with Developers in troubleshooting application and Report

Developing.

. Involved in writing the Scripts Using Automate.

. Involved in installing SQL Server 2005 on Development, Production and

WTC (Testing) machines.

. Deployed SSIS packages to MSDB database and file system using manifest

file and the wizard utility in SQL Server 2008.

. Migrated data from Aria V7 to Aria V11.

. Developed a data cleansing and validating process.

. Developed message specification rules for HL7 interfaces and

transformation of batch flat file CSV-XML(CDA) interfaces to HL7 (e.g.

MDM) and parsing. Verify any XML "in-scope" document rendering process

for all systems.

. Design tactical solution for a conceptual & logical interoperable

Enterprise SQL Server database repository that is based on the Aria

Med Onc v11 application's data base structure.

. Monitoring and scheduled jobs on production and staging environment.

. Involved in troubleshooting all the performance issues for different

database applications.

Senior SQL Server DBA

Blue Cross Blue Shield, Chicago, IL

October 2012 - March 2013

Blue Cross and Blue Shield companies offer a variety of insurance products

to all segments of the population, including large employer groups, small

business and individuals. The Blues currently serve 85% of Fortune 100

companies and 76% of Fortune 500 companies.

. Installed SQL server 2008, 2005 and SQL Server 2000 and applied

service pack.

. Installed HP OVPI on different servers.

. Extensive experienced with HP OVPI (Open View Performance Insight) in

an HP OVPA environment.

. Management, monitoring, and implementation of a mutli-terrabyte HP

OVPI database structure (multiple satellites, central, and archive

servers).

. Building of complex HP OVPI reports.

. Customization of HP OVPI report packs.

. Building of complex HP OVPI reports.

. Integration of non-HP data into OVPI and the report packs (i.e. Remedy

CMDB).

. Performance tuning of SQL queries and stored procedures using SQL

Profiler and Index Tuning Wizard.

. Transformed and manipulated the data by using SSIS transformations and

tasks.

. Responsible in Monitoring and Troubleshooting SQL Server Performance

issues.

. Involved in daily maintenance of SQL servers.

. Fixing Performance issues by Indexing, Query Optimization etc.

. Used database consistency checks using DBCC utilities.

. Scheduled Jobs and Alerting using SQL Server Agent.

. Involved in troubleshooting all the performance issues for different

database applications.

. Automated monitoring all the daily failed jobs in all the servers

using system database, DTS and SQL Mail.

. Monitoring and scheduled jobs on production and staging environment.

. Deployed SSIS packages to MSDB database and file system using manifest

file and the wizard utility in SQL Server 2008.

. Performed data conversion from flat file into a normalized database

structure.

. Created DTS package to export and import data from SQL Server to text

files.

. Developed scripts for batch processing.

. Migrated data from Access 2003 to SQL server 2005.

. Created the DTS (SSIS) packages and scheduled them.

. Responsible for writing SQL Transactions, Creation and Enhancement of

Stored Procedures.

. Expert in Reporting Services.

. Generated reports using MS Reporting services.

Environment: MS SQL Server 2008/2005, MS Access 2003, SSIS, DTS.

Senior SQL Server DBA

Sentara, Virginia Beach, VA October

2011 - September 2012

Sentara Healthcare is an acknowledged leader in patient safety and quality

innovation. Founded in 1888 as the Retreat for the Sick in Norfolk,

Virginia, Sentara has ranked for more than a decade among the nation's top

integrated healthcare systems by Modern Healthcare magazine and is the #1

most integrated health care systems for the last two years.

. Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and

clustered environments and applied service pack.

. Involved in designing and creating Databases, Tables, Views, Stored

Procedures and Triggers.

. Hands on experience with developing reports using SSRS.

. Interacted with Developers in troubleshooting application and Report

Developing.

. Involved in writing the Scripts Using Automate.

. Involved in installing SQL Server 2005 on Development, Production and

WTC (Testing) machines.

. Hands on experience with VBA.

. Deployed SSIS packages to MSDB database and file system using manifest

file and the wizard utility in SQL Server 2008.

. Created and deployed SSIS packages and scheduled jobs on daily, weekly

and monthly basis.

. Interacted with concern application team in fixing the problems when

ever needed.

. Created logins and users with specific roles and permissions as per

security rules.

. Created daily database backup and recovery procedures for Development,

WTC (TESTING) and Production environments.

. Used ETL tools to maintain the quality of data and also to improve the

metadata capabilities.

. Monitoring all activities of the server including monitoring the daily

SQL jobs, SQL Server error logs and Windows error logs.

. Involved in setting up database mirroring for production server

. Configured replication methods like snapshot, transactional and merge

replications.

. Imported data from text files and excel spread sheets into SQL Server

2005 database using SSIS.

. Used the Execution Plan to improve the optimization of the T-SQL code.

. Resolving performance related issues to Blocking, Deadlocks and long

running queries

. Optimized Stored Procedures and long running queries using query-

optimization techniques.

. Provided 24 x 7 Production support for the database using VM Ware and

application issues.

Environment: Windows 2003 Server, MS SQL Server 2008/2005, MS SQL Server

2000, BIDS, SSIS, DTS.

Senior SQL Server DBA

Dollar Tree Inc., Chesapeake, VA June 2011

- October 2011

Dollar Tree is a national company with thousands of stores conveniently

located in shopping centers and malls in all 48 contiguous states.

. Installed SQL server 2008, 2005 and SQL Server 2000 and applied

service pack.

. Performance tuning of SQL queries and stored procedures using SQL

Profiler and Index Tuning Wizard.

. Transformed and manipulated the data by using SSIS transformations and

tasks.

. Responsible in Monitoring and Troubleshooting SQL Server Performance

issues.

. Involved in daily maintenance of SQL servers.

. Fixing Performance issues by Indexing, Query Optimization etc.

. Used database consistency checks using DBCC utilities.

. Scheduled Jobs and Alerting using SQL Server Agent.

. Involved in troubleshooting all the performance issues for different

database applications.

. Automated monitoring all the daily failed jobs in all the servers

using system database, DTS and SQL Mail.

. Monitoring and scheduled jobs on production and staging environment.

. Deployed SSIS packages to MSDB database and file system using manifest

file and the wizard utility in SQL Server 2008.

. Performed data conversion from flat file into a normalized database

structure.

. Created DTS package to export and import data from SQL Server to text

files.

. Developed scripts for batch processing.

. Migrated data from Access 2003 to SQL server 2005.

. Created the DTS (SSIS) packages and scheduled them.

. Responsible for writing SQL Transactions, Creation and Enhancement of

Stored Procedures.

. Expert in Reporting Services.

. Generated reports using MS Reporting services.

Environment: SQL Server 2008/2005/2000, SSIS, SSRS, Data Ware Housing,

Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access

2003.

Senior SQL Server DBA

Ameri Group, Virginia Beach, VA

December 2010 - May 2011

Ameri Group health care system has problems. People are having trouble

getting the care they need to live full and independent lives. States are

trying to do more with less.

. Installed SQL server 2008, 2005 and SQL Server 2000 and applied

service pack.

. Interacted with application team at the time database migration from

SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server

2008.

. Deployed SSIS packages to MSDB database and file system using manifest

file and the wizard utility in SQL Server 2005, 2008.

. Involved in Deployment and Administration on SSIS packages with

Business Intelligence development studio and updated in Visual studio

2008.

. Developed, monitored and deployed SSIS packages.

. Involve in Migrating the data from MS Access to SQL server.

. Involved in claims department to load all claims and fix the problems

24*7.

. Interacted with Developers in troubleshooting application and database

issues mostly related to claims.

. Monitoring all activities of the server including monitoring the daily

SQL jobs, SQL Server error logs and Windows error logs.

. Performance tuning of SQL queries and stored procedures using SQL

Profiler and Index Tuning Wizard.

. Transformed and manipulated the data by using SSIS transformations and

tasks.

. Responsible in Monitoring and Troubleshooting SQL Server Performance

issues.

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

security.

. Created Triggers to enforce data and referential integrity.

. Created various Weekly and Monthly reports showing detailed

information.

. Used ETL tool to communicate with the many different relational

databases and read the various file formats used throughout in the

organization.

. Created SQL scripts for tuning and scheduling.

. Performed data conversion from flat file into a normalized database

structure.

. Created DTS package to export and import data from SQL Server to text

files.

. Developed scripts for batch processing.

. Developer scripts using VBA to create scripts for silent installation

of SQL Server 2005,2008.

. Migrated data from Access 2003 to SQL server 2005.

Environment: SQL Server 2008/2005/2000, SSIS, SSRS, Data Ware Housing,

Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access

2003.

SQL Server DBA

AT&T, Middletown, NJ

April 2010 - November 2010

AT&T is the largest provider of fixed telephony in the United States, and

also provides broadband and subscription television services. AT&T is the

second largest provider of mobile telephony service in the United States.

. Involved in designing and creating Databases, Tables, Views, Stored

Procedures and Triggers.

. Interacted with application team at the time database migration from

SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server

2008.

. Hands on experience using SDLC.

. Used SQL Server Profiler to trace the slow running queries and tried

to Optimize SQL queries for improved performance and availability.

. Used ETL tool to communicate with the many different relational

databases and read the various file formats used throughout in the

organization.

. Created SQL scripts for tuning and scheduling.

. Performed data conversion from flat file into a normalized database

structure.

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

security.

. Created Triggers to enforce data and referential integrity.

. Logical and Physical design of database for projects on basis of user

requirements using ERWIN.

. Created various Weekly and Monthly reports showing detailed

information.

. Responsible for creating the reports basing on the requirements using

SSRS 2005.

. Used ETL tools to maintain the quality of data and also to improve the

metadata capabilities.

. Created various Database Objects - Tables, Indexes, Views, and Roles.

. Performance tuning of SQL queries and stored procedures using SQL

Profiler and Index Tuning Wizard.

. Converting existing DTS Packages to Integration Service (SSIS)

Packages using DTS Xchanger tool.

. Troubleshooting various issues encountered while converting existing

DTS Packages to SSIS Packages.

. Created and deployed SSIS packages and scheduled jobs on daily, weekly

and monthly basis.

. Documented all the steps and procedures for future references.

. Interacted with concern application team in fixing the problems when

ever needed.

. Created logins and users with specific roles and permissions as per

security rules.

. Created daily database backup and recovery procedures for Development,

Testing and Production environments.

. Deploying database objects from development/testing environment to

production environment.

. Involved in setting up database mirroring for production server

. Configured replication methods like snapshot, transactional and merge

replications.

Environment: Windows 2003 Server, MS SQL Server 2008/2005/2000, ERWIN,

SSRS, SSIS, BIDS, SSIS, DTS.

SQL Server DBA

Anheuser-Busch Companies, Inc. St. Louis, MO

September 2009 - March 2010

Anheuser-Busch operates largest breweries in the United States. The company

brews the world's largest-selling beers, Budweiser and Bud Light. Anheuser-

Busch is a major manufacturer of aluminum cans and has been a leading

aluminum recycler for more than 30 years.

. Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and

clustered environments and applied service pack.

. Involved in designing and creating Databases, Tables, Views, Stored

Procedures and Triggers.

. Interacted with application team at the time database migration from

SQL Server 2000 to SQL Server 2005.

. Interacted with Developers in troubleshooting application and database

issues.

. Highly used T-SQL for developing complex Stored Procedures and

Triggers.

. Involved in installing SQL Server 2005 on Development, Production and

WTC (Testing) machines.

. Converting existing DTS Packages to Integration Service (SSIS)

Packages using DTS Xchanger tool.

. Troubleshooting various issues encountered while converting existing

DTS Packages to SSIS Packages.

. Deployed SSIS packages to MSDB database and file system using manifest

file and the wizard utility in SQL Server 2008.

. Created and deployed SSIS packages and scheduled jobs on daily, weekly

and monthly basis.

. Interacted with concern application team in fixing the problems when

ever needed.

. Created logins and users with specific roles and permissions as per

security rules.

. Created daily database backup and recovery procedures for Development,

WTC (TESTING) and Production environments.

. Used ETL tools to maintain the quality of data and also to improve the

metadata capabilities.

. Monitoring all activities of the server including monitoring the daily

SQL jobs, SQL Server error logs and Windows error logs.

. Involved in setting up database mirroring for production server

. Configured replication methods like snapshot, transactional and merge

replications.

. Monitoring and scheduled jobs on production and staging environment.

. Imported data from text files and excel spread sheets into SQL Server

2005 database using SSIS.

. Used the Execution Plan to improve the optimization of the T-SQL code.

. Resolving performance related issues to Blocking, Deadlocks and long

running queries

. Optimized Stored Procedures and long running queries using query-

optimization techniques.

. Provided 24 x 7 Production support for the database using VM Ware and

application issues.

Environment: Windows 2003 Server, MS SQL Server 2005, MS SQL Server 2000,

BIDS, SSIS, DTS.

SQL Server DBA

BUSINESS ADVANTAGE Inc. Memphis, TN

January 2008 - August 2009

. Actively participated in interaction with users, team lead, DBA's and

technical manager to fully understand the requirements of the system.

. Used Joins, correlated and non correlated sub-queries for complex

business queries involving multiple tables from different databases.

. Implemented Functions, views, triggers and stored procedures and

enforced business rules via checks and constraints.

. Created indexes on selective columns to speed up queries and analyses

in SQL Server Management Studio.

. Use the SQL Analyzer and Profiler for studying the SQL statements and

procedures.

. Use the SSAS to discover relationships and dependencies, finds

causation, and predicts likely outcomes based upon trends and

patterns.

. Used T-SQL for programming for stored procedures and queries.

. Manually copied and pasted the Active X script from DTS to SSIS.

. Used SSAS Cube to analyze data of related measures and dimensions.

. Used SQL Server Profiler to trace the slow running queries and tried

to Optimize SQL queries for improved performance and availability.

. Logical and Physical design of database for projects on basis of user

requirements using ERWIN.

. Generated reports using SSRS, Excel (Pivot) that could be used to send

information to diverse group of users, clients, and managers.

. Responsible for creating the reports basing on the requirements using

SSRS 2005.

. Used ETL tools to maintain the quality of data and also to improve the

metadata capabilities.

. Created various Database Objects - Tables, Indexes, Views, and Roles.

. Performance tuning of SQL queries and stored procedures using SQL

Profiler and Index Tuning Wizard.

. Performed Full and Differential backup with bulk-logged recovery

models.

. Developed SSIS Templates which can be used to develop SSIS Packages

such a way that they can be dynamically deployed into Dev, Test and

Production Environments.

. Involved in extracting the data using SSIS from OLTP to OLAP.

. Executing data validation stored procedures in SSIS packages in

Business Intelligence Development Studio (BIDS).

. Migrated data from MS Access to SQL Server.

Environment: SQL Server 2008/2005, SSIS, SSRS, Data Ware Housing, Visual

studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

SQL Server DBA

COMPLIANCE 11, Inc. Chicago, IL

December 2006 - December 2007

Compliance11 was founded to meet the needs of corporate and financial

compliance professionals. The Company is a leading supplier of software as

a service for the compliance industry. Compliance11's Supervisor Suite of

financial compliance products enables companies to automate and effectively

manage four critical regulatory compliance areas. The Major concept of this

project is to provide the Business support to the Client.

. Managed and maintained the entire release of the project.

. Involved in requirement gathering, analysis and design.

. Imported data into SQL Server 2005.

. Created databases, tables.

. Created the SSIS packages and scheduled them.

. Responsible for Design and Normalization of the database tables.

. Extensively used T-SQL queries to filter data.

. Wrote Triggers and Stored Procedures to capture updated and deleted

data from OLAP systems.

. Gathered user requirements.

. Used ETL tools to maintain the quality of data and also to improve the

metadata capabilities.

. Solid understanding of data warehousing, OLTP and OLAP concepts.

Performed data extracts.

. Development and implementation of experience in development and

implementation of Data Warehousing Applications using Cognos.

. Create alerts system in case of SQL server job failure.

. Performed database management, performance monitoring and tuning.

. Implemented database mirroring.

. Created SSIS packages to transfer the data and assigned the packages

to jobs and scheduled the jobs.

. Hardware and software troubleshooting/ upgrades.

. Setup Operations Reports using SQL Server Reporting Service (SSRS).

. Created reports and sub reports using report builder and wizard.

. Successfully completed QA.

Environment: SQL Server 2005, SSIS, SSRS, MS Visio 2007, Data Ware housing,

Enterprise Edition, XML, Web Services, JavaScript, MS Access 2003.

SQL Server DBA

Great West HealthCare, NY January 2006 -

October 2006

Great West Life and Annuity Insurance, a wholly owned subsidiary of Great

West Life co Inc., provides a wide range of healthcare, life, disability

insurance, annuities and retirement savings. This project deals with

maintaining member's information, Improving Secure Service on the Web site

and providing online access services around-the-clock to Great West

members.

. Gathered user requirements.

. Analyzed and designed of software and database solutions.

. Updated functional specification and technical design documents.

. Designed database objects, normalize data base objects using OLTP

. Developed stored procedures, functions and triggers.

. Developed scripts to move data from the flat files into the tables.

. Created DTS package to export and import data from SQL Server to text

files.

. Developed scripts for batch processing.

. Used ETL implementations to store an audit trail on positive and

negative process runs.

. Responsible for Query optimization and Performance tuning, tuned SQL

queries using Show Plans and Execution Plans.

. Used HIPAA Rule for personal health information held by covered

entities and gives patients an array of rights with respect to that

information.

. Created reports as per the requirement needs using Crystal reports.

. Created views as per design needs.

. Supported the front-end application developers with their queries.

. Responsible for tuning procedure and database objects.

Environment: MS SQL Server 2000, MS Access, SQL Query Analyzer, Enterprise

Manage, DTS, SQL Developer, Visual Basic 6.0, Crystal Reports 8.5

SQL Server DBA

Space Computers & Development Center, India May

2004 - December 2005

Space Computers & Communication Center is an IT Training and Software

Development Centre established in1997 develops software products for the

clients and provides training in various certificate courses.

. Coordinating and synchronize with Management by working as a dev/admin

on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, scripts,

stored procedures and views).

. Worked as a developer in creating Stored Procedures, DTS packages,

triggers, cursors, tables, views and other SQL joins and statements

for applications.

. Developed T-SQL code for the application.

. Design and implementation of stored procedures and triggers for

automating tasks.

. Managing the security of the servers (Logins and users).

. Managing the changes and managing the service pack installation as

well as managing the server wide changes.

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000

Server, Import & Export Data.

[pic]

Contact this candidate