NAVATHA

SQL DEVELOPER

Phone: 469-***-****

Email ID: ac2doq@r.postjobfree.com

PROFESSIONAL SUMMARY

2+ years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2012/2008

Strong experience in Business Intelligence (BI) using Visual Studio 2012/2008

Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2012/2008 databases and scheduled them according to requirements.

Extracted, Transformed, Loaded data in Data warehousing using SSIS packages and migrating DTS packages from SQL Server 2000 to SSIS packages.

Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.

Experience in working with Reporting tools by Creating, designing and deploying Tabular, Matrix, Chart, Drill-down and Ad-Hoc reports on MS SQL Server Reporting service (SSRS).

Developed ETL programs using Informatica to implement the business requirements.

Rendered reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule.

Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.

Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks.

Rebuild online index and worked with Dynamic Management Views (DMV) for improving query performance.

Created recursive queries using Common Table Expression (CTE).Experience in Change Data Capture (CDC),Change Tracking (CT) in SQL server 2008.

Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.

Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.

Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views.

Good in Creating and Maintaining Documents for Future Use

PROFESSIONAL EXPERIENCE

SQL Server Developer/ETL Developer

State Bank of Hyderabad June 2013 to May 2015

Hyderabad, Andhra Pradesh

Responsibilities :

Involved in writing complex SSIS Packages to Load Data into both OLTP and OLAP systems.

Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations like Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks using SSIS/ DTS packages.

Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters, and Cascading Parameters.

Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then we use conditional split to select that new records before inserting into the database.

Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation and Detection and resolving of blocking and deadlocks using Profiler.

Designed the system architecture that is used to structure, plan, and control the process of developing an information system.

Used Recompile and with option query hints to avoid parameter sniffing problems.

Involved in tuning long running reports and handling tickets assigned out of production.

Environment: MS SQL Server 2008 R2, MS Access 2003, Import & Export Data, Enterprise Manager, SSRS, SSIS, TFS, Power view.

JR.SQL Server Developer

MASTEC Inc Jan 2011 to May 2012

Hyderabad, Andhra Pradesh

Responsibilities :

Created complex Stored Procedures and Functions to support the front-end application.

Wrote database triggers in T-SQL to check the referential integrity of the database.

Involved in performance tuning of the database and T-SQL queries using Explain Plan.

Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).

Developed SQL Server Stored Procedures, Tuned SQL Queries .

Formatted the reports using Global variables, Expressions and Functions using SSRS 2005.

Created joins and sub-queries for complex queries involving multiple tables.

Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written T-SQL procedures for transactions, created indexes for performance tuning.

Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Created and maintained Databases and created logins and assigned roles and granted permissions to users and groups and created SSIS packages to deploy packages between development, testing and production.

Involved in Query Optimization using Index implementation and Index Tuning Wizard SQL Server2012

Environment: SQL Server 2008/2012 MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio, DTS

Bachelor’s in Information Technology, JNT University-India. 2006- 2010

Master’s in Technology Management, Texas A & M University-Commerce 2015-2016

Contact this candidate