Sql Server Data
Resume:
[pic]
Email:
**********.***@*****.***
NAVYA KANDIMALLA
Cell: 214-***-****
. Has been working as MS SQL Application/Data Warehouse developer with
experience in development, analysis, administration, database
migrations, reporting analysis and data base maintenance.
. Expertise in the implementation of MS SQL Server 2000 infrastructure &
MS SQL Server 2005/2008 Infrastructure.
. Expert in Data Extraction, Transforming and Loading (ETL) using
various tools such as Data Transformation Service (DTS), SSIS, SSRS,
Bulk Insert,BCP, Mirroring and Replication.
. Expertise in using SQL reporting tools with SQL Server 2000, SQL
Server 2005 and SQL Server 2008.
. Performed analysis as per business requirements using SSAS.
. Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema
Designs for data warehouse purposes.
. Very strong Transact-SQL Development Skills which includes creating
Complex Business Stored Procedures, Tables, CTE's, Cursors, Views,
Indexes, Triggers and Functions.
. Experienced working on XML for web applications.
. Experienced working with MS SQL Server 2005 Service Broker for
Database applications.
. Configured various Publishers and Subscribers for Snapshot and Merge
replications.
. Experienced in the migration and implementation from other databases
to MS SQL Server.
. Expertise in establishing and managing of all standards, processes,
artifacts, relative to the practice of Configuration Management.
. Experienced in working on logical and physical data modeling.
. Expertise in developing and maintaining of processes and associated
SQL scripts/tools for automated build, testing and deployment of the
products to various developments.
. Experienced in Using BO for Universe Designing and reporting.
. Expertise in support tasks involves developer support as well as
troubleshooting DB failures
. Good knowledge of configuration management concepts, release
management, changes management concepts, Industry standards and best
practices.
. Migrating and Tuning SQL scripts, indexes, stored procedures and views
Fine tuning and optimization of SQL queries and Stored procedures
using SQL Profiler, Trace and Performance monitor and ensuring indexes
are using updated statistics
. Several years of innovative and resourceful work with strong
administration, analysis, design, development, testing, presentation
and implementation experience using SQL Server Databases, Windows
NT/2000 and Windows XP
2 EDUCATIONAL QUALIFICATION
. Bachelor of Technology in Engineering, Jawaharlal Nehru Technological
University, India.
. Post Graduate in Computer Applications,
1 TECHNICAL SKILLS
|Language |SQL, PL/SQL, My SQL, Transact SQL,JAVA |
|Tools |SQL SERVER 2000/2005/2008, SQL Enterprise Manager,|
| |SQL Profiler, Query Analyzer, ERWIN,Analysis |
| |Manager DTS Import/Export Wizard, SSIS, SQL |
| |Reporting Services (SSRS), BO |
|Applications |Microsoft Office, Excel, Adobe Photoshop, Acrobat |
| |reader /writer |
|OS |Windows NT/95/98/2000/XP |
EXPERIENCE PROFILE
Barnabas Foundation, Tinley Park, IL
Jan 2012 - Till Date
Role: SQL Server Developer
Project : Insurance and Financial Services
Responsibilities:
. Created T-SQL scripts for RDBMS applications.
. Experienced in loading data into relational database using
ETL tool.
. Experienced in Data Extraction, Transforming and Loading
(ETL) using various tools such as Data Transformation Service
(DTS), SSIS, SSRS, Bulk Insert,BCP, Mirroring and
Replication.
. Reviewed many T-SQL issues using management studio for better
performance.
. Developed stored procedures, triggers and functions and added
/ changed tables for data extraction and transformation, and
data loading using TSQL statements.
. Maintenance of security standards, facilitate requirements
and gathering meetings with clients.
. Created Stored Procedures for report processing.
. Experienced working in E-commerce Industry.
. Extensively used Joins and sub-Queries to simplify complex
queries involving multiple tables.
. Optimized SQL queries for improved performance and
availability.
. Experienced working with MS SQL Server 2005 Service Broker
for Database applications.
. Experienced in writing C# code for Implementing ETL
operations.
. Experienced in designing Data warehouse applications.
. Experienced working on XML for web applications.
. Experienced in using BO for Universe designing and reporting.
. Experienced in writing PL/SQL code for Implementing ETL
operations.
. Generated various reports according to business requirements
using Reporting Services.
. Experienced in developing Graphical and Tablix reports using
SSRS.
. Experienced in working on logical and physical data modeling.
. Used Informatica tool for extracting the source data and
loading it into the target after applying the required
transformation.
. Update the SSRS reports with different location and period
hierarchy.
. Development and production support for various databases, DTS
and SSIS packages.
. Managed SSIS and DTS packages quality assurance.
. Monitor the SQL server Agent jobs and fix the jobs on
failure.
. Experienced in writing My SQL code for Data warehousing
applications.
. Schedule and resolve the issues during the BI development of
data warehouse operations.
. Performed database transfers and queries tune-up, integrity
verification, data cleansing, analysis and interpretation.
. Used Performance Monitor and SQL Profiler to optimize queries
and enhance the performance of database servers.
. Experienced working on QA testing.
. Participated in re-design and development of back-end SQL
Server database, wrote queries, triggers and stored
procedures
. Programmed SQL Server 2008 Reporting Services using Microsoft
Visual Studio 2005.
. Used complex expressions to filter and parameterize, and
format the contents of a report.
. Created monthly reports using reporting wizard with Visual
Studio
. Assign Reports to Report Folders in SQL Reporting Services
. Involved in Scheduling backups and maintenance.
. Create backups and restore of the databases.
. Used data conversions to convert different data types
. Transferred data from flat files, Excel spreadsheets and
heterogeneous data to and from SQL Server using SSIS and also
used BCP and Bulk Insert.
. Optimized SQL queries for improved performance and
availability
. Reorganize database structures as needed, automate procedures
at regular intervals.
. Creating and Maintaining all types of Backups and recovery
strategies and set up jobs
. Involved in requirement gathering, analysis, design,
development, change management, deployment and user training
. Designed, analyzed and upgraded databases.
. Written 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
. Scheduling Jobs and Alerting using SQL Server Agent.
. Actively participated in interacting with different
departments regarding their access to the database system and
creating views to facilitate the same.
. 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: SQL Server 2005/2008, Reporting Services, Bo,
Excel, T-SQL, PL/SQL, MS Access, SSIS, SSRS Windows
2000/XP, Visual studio2005
Anheuser-Busch, St Louis, MO
Aug 2011- Dec 2011
Role: Data warehouse/ SQL Server Developer
Responsibilities:
. Created T-SQL scripts for RDBMS applications.
. Experienced in Warehouse Management System in controlling the
movement and storage of materials within a warehouse.
. Experienced in loading data into relational database using
ETL tool.
. Generated various reports according to business requirements
using crystal reports.
. Design and create the tables, store procedures, triggers,
indexes basing on requirements.
. Experienced working on XML for web applications.
. Experienced working with offshore team.
. Experienced in using BO for Universe designing and reporting.
. Reviewed many T-SQL issues using management studio for better
performance.
. Experienced in writing PL/SQL code for Implementing ETL
operations.
. Developed stored procedures, triggers and functions and added
/ changed tables for data extraction and transformation, and
data loading using TSQL statements.
. Used Informatica tool for extracting the source data and
loading it into the target after applying the required
transformation.
. Used Performance Monitor and SQL Profiler to optimize queries
and enhance the performance of database servers.
. Resolve the issues during the BI development of data
warehouse operations.
. Maintenance of security standards, facilitate requirements
and gathering meetings with clients.
. Created Stored Procedures for report processing.
. Experienced working with MS SQL Server 2005 Service Broker
for Database applications.
. Created reports with complex calculation fields.
. Generated reports by using Crystal Reports and Excel
spreadsheets.
. Experienced in developing Graphical and Tablix reports using
SSRS.
. Performed database transfers and queries tune-up, integrity
verification, data cleansing, analysis and interpretation
. Participated in re-design and development of back-end SQL
Server database, wrote queries, triggers and stored
procedures.
. Extensively used Joins and sub-Queries to simplify complex
queries involving multiple tables.
. Optimized SQL queries for improved performance and
availability.
. Used complex expressions to filter and parameterize, and
format the contents of a report.
. Created monthly reports using reporting wizard with Visual
Studio.
. Experienced working on QA testing.
. Performed analysis as per business requirements using SSAS
. Deploy/Design cubes in SSAS environment Snowflake/ and Star
Schema Designs for data warehouse purposes.
. Assign Reports to Report Folders in SQL Reporting Services.
. Optimized long running Stored Procedures & queries for
effective data retrieval.
. Performed and analyzed the calculations for various KPI of
the company.
. Actively participated in interacting with different
departments regarding their access to the database system and
creating views to facilitate the same.
. 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.
. Worked with plan administrators to research and resolve data
issues and troubleshoot system problems/outages.
Environment: SQL Server 2005/2008, Crystal
Reporting Services, BO,Query Analyzer, Excel
NOW FOODS, Chicago, IL
Aug 2010-Apr 2011
Role: ETL Developer/ SQL Server Developer
Responsibilities:
. Created T-SQL scripts for OLTP and ETL application
development on sql server and Teradata.
. Experienced in Data Extraction, Transforming and Loading
(ETL) using various tools such as Data Transformation Service
(DTS), SSIS, SSRS, Bulk Insert,BCP, Mirroring and
Replication.
. Experienced in loading data into relational database using
ETL tool.
. Experienced in Warehouse Management System in controlling the
movement and storage of materials within a warehouse.
. Performed migration of data from teradata Server to SQL
Server.
. Performed migration of data from Oracle to SQL server using
SSIS. In SSIS packages written PL SQL code to bring data to
SQL server destination.
. Generated reports according to business requirements using
crystal reports and reporting services 2005.
. Designed physical and logical modeling of databases for data
warehouse applications.
. Created daily, weekly and monthly SSRS dashboard reports for
sales and profit analysis.
. Update the SSRS reports with different location and period
hierarchy.
. Development and production support for various databases, DTS
and SSIS packages.
. Create and alter various applications including stored
procedures, views using TSQL.
. Managed SSIS and DTS packages quality assurance.
. Experienced working with MS SQL Server 2005 Service Broker
for Database applications.
. Monitor the SQL server Agent jobs and fix the jobs on
failure.
. Design and create the tables, store procedures, triggers,
indexes basing on requirements,
. Reviewed many T-SQL issues using management studio for better
performance.
. Developed stored procedures, triggers and functions and added
/ changed tables for data extraction and transformation, and
data loading using TSQL statements.
. Developing the applications and perform tuning using SQL
profiler and query execution analysis.
. Schedule and resolve the issues during the BI development of
data warehouse operations.
. Participated in re-design and development of back-end SQL
Server database applications.
. Performed database transfers and queries tune-up, integrity
verification, data cleansing, analysis and interpretation
. Maintenance of security standards, facilitate requirements
and gathering meetings with clients.
. Scheduled Jobs and Alerts using SQL Server Agent for SSIS and
DTS packages.
. Using SSIS Performed Migration of databases from SQL 2005 to
SQL2008
. 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.
. Created T-SQL scripts for OLTP and ETL application
development.
. Performed analysis as per business requirements using SSAS
. Deploy/Design cubes in SSAS environment Snowflake/ and Star
Schema Designs for data warehouse purposes.
Environment: SQL Server 2005/2008,Reporting Services, Query
Analyzer, Excel (pivot tables) SSIS, SSRS, JAVA, Teradata, T-
SQL, c#, Visual basic, Business Objects, Visual studio2005,
Windows 2000/XP
SEARS HOLDINGS CORPORATION, IL. SEP 2009-JUNE
2010
Role: SQL Server BI Developer/ SQL Server Developer
Responsibilities:
. Creating and managing schema objects such as tables, views,
indexes, procedures, triggers and maintaining Referential
Integrity for BI and OLTP operations.
. Experienced in Data Extraction, Transforming and Loading
(ETL) using various tools such as Data Transformation Service
(DTS), SSIS, SSRS, Bulk Insert,BCP, Mirroring and
Replication.
. Experienced in loading data into relational database using
ETL tool.
. Experienced In Warehouse Management System in controlling the
movement and storage of materials within a warehouse.
. Performed migration of data from Oracle to SQL server using
SSIS. In SSIS packages written PL SQL code to bring data to
SQL server destination.
. Worked with SSIS to design the packages for ETL Support.
. Experienced working in E-commerce Industry.
. Generated T-SQL scripts for application development.
. Created Stored Procedures and User Defined functions.
. Created Indexes to speed up the queries.
. Design many tables for efficient performance of applications
and data pull.
. Create roles and permissions for the data warehouse
applications.
. Moving and promoting the data from development to production.
. Participated in re-design and development of back-end SQL
Server database, wrote queries, triggers and stored
procedures.
. Programmed SQL Server 2005 Reporting Services using Microsoft
Visual Studio 2005.
. Used complex expressions to filter and parameterize, and
format the contents of a report.
. Performed Migration of databases from SQL 2000 to SQL2005
using SSIS
. Performed database transfers and queries tune-up, integrity
verification, data cleansing, analysis and interpretation
. Scheduling Jobs and Alerting using SQL Server Agent
. Involved in ER diagrams (Physical and Logical using ERWIN)
and mapping the data into database objects.
. Used Performance Monitor and SQL Profiler to optimize queries
and enhance the performance of database servers.
. Performed analysis of cubes using SSAS for store ops data of
SEARS and KMART.
Environment: SQL Server 2000/2005, Query Analyzer, Excel (pivot
tables) SSIS, SSRS, T-SQL, Visual studio2005, Windows 2000/XP
ALLTEL, AR
JUNE 2008 - AUG 2009
Role: Data warehouse/ BI developer
Project: Telecom customer database
Description: Alltel is owner and operator of the nation's
largest wireless telecom network and has more than 11 million
wireless customers a key member of the Marketing Technologies
and development team.
Responsibilities:
. Written T- SQL codes for the project.
. Created Stored Procedures for Batch Processing.
. Experience in controlling the movement and storage of
materials within a warehouse.
. Developed stored procedures, triggers and functions and added
/ changed tables for data extraction and transformation, and
data loading (ETL).
. Develop and modify the SSIS packages for ongoing data
support.
. Added/Changed Tables, columns, triggers using TSQL.
. Worked with Business Objects and SSRS.
. Used Views, Triggers, and Stored Procedures for updating and
cleaning the existing data and also the new data.
. Developed, maintain, and support the enterprise data
warehouse using SSIS and SSRS system throughout the SDLC.
. Deliver SQL server reports to SharePoint to enhance team
collaboration
. Generated reports according to business requirements using
crystal reports and reporting services 2005.
. Experienced working in E-commerce Industry.
. Created monthly reports using reporting wizard with Visual
Studio.
. Assign Reports to Report Folders in SQL Reporting Services
. Involved in Scheduling backups and maintenance.
. Upgrade DTS packages to SSIS.
. Created indexes to improve the performance of the queries
. Create backups and restore of the databases.
. Used data conversions to convert different data types
. Created Views for Extracting Data using TSQL.
. Performed Migration of databases from SQL 2000 to SQL2005
. Extensively used Joins and sub-Queries to simplify complex
queries involving multiple tables. Configured various
Publishers and Subscribers for Snapshot and Merge
replications using TSQL.
. Created Distributed Partitioned Views, Troubleshooting Stored
Procedures, and upgrading existing ones. Transferred data
from flat files, Excel spreadsheets and heterogeneous data to
and from SQL Server using SSIS and also used BCP and Bulk
Insert.
. Transferred data from flat files, Excel spreadsheets and
heterogeneous data to and from SQL Server using SSIS and also
used BCP and Bulk Insert.
Environment: MS SQL 2000/2005,Sharepoint Windows
NT/2000/XP,SSAS,SSIS, SSRS, Crystal reports Visual
studio 2005, ASP 3.0,Business Objects, ORACLE 10g, MS
Excel(Creating reports), SQL Query Analyzer, Enterprise
Manager, MS Access.
Country Insurance & Financial Services, Atlanta, GA Feb
2008- May 2008
Role: SQL Server Developer
Project : Insurance and Financial Services
Description: Country Insurance & Financial Services 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.
. This project collects data from various database sources to analyze
and integrate with existing systems.
. Created database triggers to implement business requirements
. Created complex Stored Procedures and Functions to support the
front-end application.
. Experienced in writing C# code for Implementing ETL operations.
. Optimized SQL queries for improved performance and availability
. Generated reports according to business requirements using crystal
reports and reporting services 2005.
. Running DBCC consistency checks, and fixing data corruption in
application databases.
. Reorganize database structures as needed, automate procedures at
regular intervals.
. Creating and Maintaining all types of Backups and recovery
strategies and set up jobs
. Setting up Profiler Traces, Analyze and replay Profiler Traces for
Performance and long running queries
. Created Packages using DTS
. Optimized long running Stored Procedures & queries for effective
data retrieval.
Environment: SQL Server 2000 (Query Analyzer, Enterprise Manager,
Business Objects, DTS Designer, SQL Profiler, Index Tuning Wizard), MS
SQL Reporting Services, Windows XP, MS Access, MS Word/PowerPoint.
Liberty Mutual Mortgage Inc Nov
2006- Dec 2007
Role: SQL Server Developer /DBA
Project : Mortgage and Human Resource Management System (HRMS)
Description: 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.
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
. Created various delivery channels using Business Objects crystal
reports server.
. 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.
. Written 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.
. Experienced in writing C# code for Implementing ETL operations.
. Successfully implemented database connectivity from front end
. Scheduling Jobs and Alerting using SQL Server Agent.
. Actively participated in interacting with different departments
regarding their access to the database system and creating views to
facilitate the same.
. 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.
. Generated reports according to business requirements using crystal
reports and reporting services.
. 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, crystal Reports, Business
Objects, MS Access, MS Excel, MS Word, PowerPoint and Windows
98/NT/2000
State Bank of Hyderabad, Hyderabad May
2004- Sep 2006
Role: SQL Server Developer
Project: Financial maintenance database
Description: State Bank of Hyderabad provides different financial
services. The scope of the project that I 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:
. 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 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, MS Access,
PPT, Visual Studio.NET, C#.NET.
Contact this candidate