Microsoft Certified
PROFESSIONAL EXPERIENCE:
ALLTEL, AR
March 2007 – May2008
SQL DBA with QA
Alltel is owner and operator of the nation's largest wireless network and has
more than 11 million wireless customers a key member of the Marketing
Technologies and development team which provides Information technology support
for Countrywide Marketing by designing, coding and maintaining automation
processes. Project involved in the SQL server development activities and some
administrative activities for the project designed for their HR department for
payroll and enrollment provided by the company.
Responsibilities:
• Added/Changed Tables, columns, triggers
• Created and Used Views, Triggers, and Stored Procedures for updating and
cleaning the existing data and also the new data.
• Conducted database management, performance measurement and performance tuning
for new databases and existing databases by using SQL Profiler, SQL Analyzer, and
SQL Enterprise Manager
• Demonstrated ability to interact with developers and product analysts
regarding testing status and maintain detailed QA documentation.
• Experienced in Manual and Automation Testing
• Performed backup and restore operations
• Performed migration of existing Crystal Reports to SSRS
• Created indexes to improve the performance of the queries.
• Solved various T-SQL issues using SQL Management Studio and SQL DM while
extracting data from SQL Server database.
• Monitored strategies, processes and procedures to ensure the data integrity,
optimized and reduced data redundancy, maintained the required level of security
for all production and test databases
• Maintained databases, performed software installations and upgrades, monitored
database performance.
• Performed Physical and Logical data modeling using ERWIN.
• Performed data mining operations for several business functions, for decision
support and for focusing business activities.
• Performed day to day operational reporting.
• Performed mirroring tasks for disaster recovery plan.
• Configured various data sources and data sets, created tabular reports,
summarized data, and applied basic formatting using SSRS.
• Used Crystal reporting tool to retrieve data from a database and display it
using any of the bound controls.
• Performed Migration of databases from SQL 2000 to SQL2005 using SSIS.
• Upgraded DTS packages to SQL Server Integration Services (SSIS).
• Performed analysis as per business requirements using SSAS.
• Developed stored procedures, triggers and functions and added / changed tables
for data extraction and transformation, and data loading (ETL).
• Extensively used Joins and sub-Queries to simplify complex queries involving
multiple tables.
• Configured various Publishers and Subscribers for Snapshot and Merge
replications.
• Configured SQL mail agent for sending automatic emails when a SSIS process is
failed or succeed
Environment: MS SQL 2000/2005, Windows NT/2000/XP, SSIS, DTS, SSRS, Crystal
Reports, Visual studio 2005, c#, ASP 3.0 MS Excel(Creating reports), SQL Query
Analyzer, Enterprise Manager, MS Access.
INSTINET, INC. NY
July 2006-February 2007
SQL DBA
Instinet is one of the largest electronic trading companies. This project is an
electronic communications network (ECN) maintenance database system that provides
the total solution for the entire network operation, maintenance and inventory.
The system scope covers the areas namely projects, maintenance, performance,
downtime, Quality, inventory and Persona.
Responsibilities:
• Created and managed schema objects such as tables, views, indexes, procedures,
triggers and maintaining Referential Integrity.
• Maintained databases, performed software installations and upgrades, monitored
database performance.
• Managed database quality assurance including database consistency check
• Created Indexes to speed up the queries.
• Worked on Crystal to directly pull data from multiple database platforms for
reporting.
• Participated in re-design and development of back-end SQL Server database
• Reduced systems downtime risk through automatic offsite backup and recovery
over network.
• Designed and constructed DTS packages
• Provided 24X7 production support.
• Reviewed many T-SQL issues using management studio for better performance.
• Applied Transaction logs on different server sequentially on a scheduled basis
in Log Shipping Operations
• Programmed SQL Server 2005 Reporting Services (SSRS) using Microsoft Visual
Studio 2005.
• Created new fields in reporting based on data set fields.
• Performed database transfers and queries tune-up, integrity verification, data
cleansing, analysis and interpretation
• Built OLAP cubes and data mining models using data from the Teradata Database
in a MOLAP
• Facilitated requirements gathering meetings with clients
• Scheduled Jobs and Alerts using SQL Server Agent
• Evaluated database performance and performed maintenance duties such as
tuning, backup, restoration and disaster recovery.
• Responsible for Log shipping Operations.
• Involved in ER diagrams (Physical and Logical using ERWIN) and mapping the
data into database objects.
• Using SSIS Performed Migration of databases from SQL 2000 to SQL2005
• Moved the static data from various heterogeneous sources like Oracle, MS
Access, and MS Excel and text files to SQL Server 2005 database using BCP and
dynamic DTS/SSIS packages
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the
performance of database servers.
Environment: SQL Server 2000/2005, Query Analyzer, Excel (pivot tables) SSIS,
SSRS, Teradata, T-SQL, c#, Visual basic, Visual studio2005, Windows 2000/XP
Country Insurance & Financial Services, Atlanta, GA
February 2005– June 2006
SQL Developer/DBA
Country Insurance & Financial Services is currently serve clients in 14
different states. Cotton States is a branch of Country Insurance & Financial
Services. It helps families, individuals and businesses protect their possessions
and achieve financial security. It offers a full range of insurance and financial
products and services from auto, home and life insurance to estate planning
services, investment management and annuities
Responsibilities:
• Participated in developing logical model and implementing requirements on SQL
Server 2000
• Created Stored Procedures and User Defined functions.
• Generated T-SQL scripts for application development.
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as tables, views, indexes, procedures
and triggers.
• This project collects data from various database sources to analyze and
integrate with existing systems.
• Created backup and restore operations.
• Created database triggers to implement business requirements
• Created complex Stored Procedures and Functions to support the front-end
application
• Optimized SQL queries for improved performance and availability
• Had primary responsibility of ensuring that all databases are available.
• Monitored strategies, processes and procedures to ensure the data integrity,
optimized and reduced data redundancy, maintained the required level of security
for all production and test databases
• Ensured data recovery, maintenance, data integrity and space requirements for
physical Database
• Ran DBCC consistency checks and fixing data corruption in application
databases.
• Reorganize database structures as needed, automate procedures at regular
intervals.
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and
long running queries
• Optimized long running Stored Procedures & queries for effective data
retrieval.
Environment: SQL Server 2000 (Query Analyzer, Enterprise Manager, DTS Designer,
SQL Profiler, Index Tuning Wizard), MS SQL Reporting Services, Windows XP, MS
Access, MS Word.
Liberty Mutual Minneapolis, MN
November 2003 - December 2004
SQL Server Developer
HRMS is an integrated Human Resource Management System, part of an ERP
(Enterprise Resource Planning) that is designed to handle the human resource
activities for the organization. It provides information about employee data
which starts when applicants apply for job in the institution. HRMS also provides
information about employee data, new hire, applicants, promotion, demotion, leave
or absence, payroll data. The change of certain business rules required
development of new modules to the system. With an employee/applicant ID the
status of activities can be tracked with this application. This system was also
used by the managers to view resumes, select candidate for interviews and also do
the actual hiring.
Responsibilities:
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query
Analyzer to Administer SQL Server
• Involved in requirement gathering, analysis, design, development, change
management, deployment and user training
• Transformed data from various data sources using OLE DB connection by creating
various DTS packages.
• Developed stored procedures, triggers, views, adding/changing tables for data
load and transformation, and data extraction.
• Designed, analyzed and upgraded databases.
• Wrote SQL queries to retrieve specific information from the database to make
sure that the data entered has been up-loaded correctly in to the database.
• Successfully implemented database connectivity from front end
• Created Backups and restore of data periodically
• Scheduled Jobs and Alerts using SQL Server Agent.
• Actively participated in interacting with different departments regarding
their access to the database system and created views to facilitate the same.
• Performed monthly database maintenance for selected clients.
• Worked with plan administrators to research and resolve data issues and
troubleshoot system problems/outages.
• Created and maintained Users, Security Permissions and Migration of the
database objects from one server to another server.
• Created alerts, notifications and emails for system errors, insufficient
resource, fatal database errors and hardware errors. Used BCP command and TSQL
command to bulk copy the data from Text files to SQL Server and vice versa.
Environment: MS SQL Server 2000, ASP, MS Access, MS Excel, MS Word and Windows
98/NT/2000
State Bank of Hyderabad, Hyderabad
May 2002- September 2003
SQL Server Developer
State Bank of Hyderabad provides different financial services. The scope of the
project worked on was to facilitate in the maintenance and development of the
application, which supported personal banking on wealth management, asset
management dealing with different types of accounts and services.
Responsibilities:
• Installed and configured SQL Server2000.
• Designed and developed the databases
• Actively participated in logical design of database design to meet new product
requirement using ERWIN.
• Wrote and modified stored procedures to implement the complex business needs
for generating new customer number, account no, increasing, decreasing and
setting credit limit as per business policies, updating user profiles,
transaction processing, generating messages with code encryption
• Configured the DTS packages to run in periodic intervals.
• Writing stored procedures and triggers extensively and working very closely
with developers, business analyst and end users to generate various audit reports
and troubleshoot their query problems and connectivity problems.
• Facilitated simplified access of database for end users using denormalized
views and created triggers on them to maintain to database integrity
• Created tables, views, triggers, stored procedures and indexes.
• Created integrity rules and defaults.
• Created Cursors to facilitate the users (credit officers) to scroll through
the Queues to perform manual operations on the payment
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Used SQL Profiler to trace the slow running queries and optimized query
execution with the use of Index Tuning Wizard and Rebuild indexes if necessary
Environment: SQL server 2000, Windows NT, Crystal Reports, Visual Studio.NET,
C#.NET.
|
