SUMMARY

• 7+ years of experience in Database design and development of applications using SQL Server 2000/2005/2008, Integration Services (SSIS), Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX queries, OLAP Cubes and Star schema.
• Expertise in designing and optimizing the various T-SQL database objects like tables, views, stored procedures, user defined functions, cursors, indexes and triggers using Management Studio and SQL Profiler.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Expert in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design.
• Experts in designing and handlingSQL Reports, Sub Reports and Drill down Reports. Crosstab report Proficient in designing report layout, sorting the data, defining subtotals for the reports usingSSRS2008/2005.
• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like Deadlocks and Long running queries.
• Expertise inMicrosoft Reporting Service (SSRS)withReport authoring,Report Management, Reportformatting, Report distribution, Reportdelivery andReport security.
• Excellent understanding of full Software Development Life Cycle (SDLC)
• Good experience in Designing Aggregations and pre-calculating the same in SSAS
• Expertise in design and create multidimensional functions, multidimensional cube using SSAS
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Worked on administration tasks such Backup and Recovery, user and application table management, upgrades, user authorizations, Database creation, tables, and indexes.
• Hands on experience in web designing using HTML, CSS and JavaScript to display reports on the server.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
• Excellent communication / analytical skills

• Operating System: Windows 95,98,NT,XP,Vista,7,MS-DOS
• Databases: Microsoft SQL Server 2000, 2005, 2008 R2 ,MS Access
• Application Tools: Microsoft SQL Server Management Studio, Query Analyzer, Export and Import, DTS, Microsoft SQL Server Integration Services (SSIS) ,.ProClarity Analytics Server, ProClarity software Development KIT(SDK), ProClarity Web Standard, VB Macros, Visual Studio 2008/2010, Team Foundation Server 2008/2010
• Languages: T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML, C, C++
• Modeling Tools: Microsoft Visio 2003/2007/2010, Toad
• Reporting Tools: Crystal Reports 8/10, SQL Server Reporting Services ( SSRS )
• Design Pattern: Agile Scrum , Waterfall design,
• Other Tools: Windows MS-Office

EDUCATION:-

• Bachelors of Engineering in Computer, Gujarat, India.

PROFESSIONAL EXPERIENCE:-

Confidential 
Windsor, CT November 11 - Present
Sr. SQL Developer

The company is a insurance company. The project is to create policy database that will eliminate the data redundancy and provide one common place to view, retrieve and update insurance policy information.

Resposibilities :

• Designed and created a database that match the business requirements.
• Created a SSIS package and also windows services to monitor FTP.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complexStored Procedures,Triggers,Tables,Viewsand SQL Joins and other statements to maintainedreferential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Improved the performance of the SQL server queries usingquery plan, covering index,indexed viewsand by rebuilding and reorganizing the indexes.
• Worked with SQL server profiler to generate traces.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.
• Used SQL server business Intelligence Development Studio to designs SSISpackages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
  Creating and ModifyingT-SQLstored procedures/triggers for validating the integrity of the data.
• DesignedETL packagesdealing with different data sources (SQL Server and XMLsetc) and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).

Environment: T-SQL, Query Analyzer, SQL Profiler, Windows XP, SQL Server 2008 Enterprise Edition, Windows 2003 advance server, SQL Server Integration services (SSIS) ,SQL Server Management Studio (SSMS), MS Access, Visual Studio 2008.

Confidential 
Naugatuck, CT March 10 - November 11 
Sr. SQL Developer

The project scope includes developing Reporting Solutions using .Net (Used mainly to maintain the Business tables), SQL Server BI technologies (SSIS/SSRS/SSRS) and DU Management and BLT Process.

Responsibilities:

• Knowledge in designing and developing Data Warehouses, Data marts and Business
• Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes using MDX.
• Linked database to Excel Spreadsheets of BLT Decks mainly for Personal Care, Perishable and Non-Perishable Items.
• Linked Database Tables to get the reports, routinely, in the excel sheets, required by the managers for analysis
• Design tables using file streaming for image and different schema tables for better performance, backup and recovery.
• Designed and createdReport templates,bar graphsandpie chartsfor analyzing data.
• DevelopedDrill down Tabular, Matrix and List Reportsof the project given by Tech Lead/Manager usingSSRS.
• Design and developSSISpackages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Configure SQLMail for alert messages for notification.
• Created SSIS packages to transfer Access tables into SQL
• Deploying andscheduling ReportsusingSSRSto generate alldaily, weekly, monthlyand quarterly Reports including current status.
• Created complexStored Procedures,Triggers,Cursors,Tables,Viewsand SQL Joins and other statements for various applications, maintainedreferential integrity and implemented complex business logic.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Analyzed and developed stored procedures, complex queriesusing complex joins, co-related, sub-queries for the application.
• Creating and runningSSISPackagesfor Import and Export of Heterogeneous Data.
• Designand developSSISpackages, store procedures, configuration files, tables, views and functions; implement best practices to maintain optimal performance.
• Design and built a cube using SSAS
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Created databases and schema objects includingtables,indexes and applied constraints,connected various applications to thedatabase and written functions, stored procedures and triggers.
• Setup ETL procedure using linked server for Oracle database.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
  Performance tuning on stored procedures.
  

Environment: T-SQL, Query, Windows XP, SQL Server 2005/2008 R2 Enterprise Edition, Windows 2003 advance server, SQL Server Integration services (SSIS) ,SQL Server Management Studio (SSMS), Data modeling ,SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Access, VB Macros, Visual Studio 2008/2010, Waterfall development, Team foundation Server 2008/2010

Confidential 
Iselin,NJ April 09- March 10
Sr. SQL Developer

Work for Bank of America, NJ as as a SQL developer. The purpose of the project was to design and implement new data mart for the investment service. Data is extracted from various operational system to provide a single source of integrated and historical data for the purpose of end-user analysis, reporting and to improve client service.

Responsibilities:

• Installed the patches and service packs for the SQL server 2008/2005.
• CreatedSSISPackagesto import and export data fromExcel Spreadsheets, Text file, MS Access and CSV files.
• Developed some codes to work on Visual Studio 2008 and Team foundation server also used the same code in SSRS to generate Reports.
• CreatedSSISPackages for bothOLTP and OLAPdatabase.
• Created and scheduled the packages using SQL Server DTS packages.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• DesignedDTS/SSISpackagesto exportandimport data from SQL ServertoMS Access, Oracle10g, text filesandExcel files.
• Migrated simpleDTS packages toSSISpackages usingDTS Migration tool.
• Automated consistency check of the database (DBCC) for SQL Server.
• Performed successful migration from database SQL server 2005 to 2008.
• Have designed, developed and implemented database securityin SQL server 2008 successfully.
• Monitored and scheduled existing/new jobs on production environment.
• UsedSQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Extensively usedImport/Export wizardto convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data typeand Vice versa.
• Used Reporting Services (SSRS) to generate Reports in PDF, Excel, and CSV format.
• Created a report model on SSAS cubes
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Provided technical architecture and database engineering support to move databases from development to test and production for multiple applications.
• Developed and maintained Enterprise database management Architecture for SQL server 2005.
• Monitored MS SQL Server performance using performance monitor and profiler.
• Created login accounts and database user accounts and managed database security using groups and roles.
• Created Logical and physical Data models for SQL server 2005.
• Improved the performance of the SQL server queries usingquery plan, covering index,indexed viewsand by rebuilding and reorganizing the indexes.
• Developed, deployed and monitoredSSISPackages including upgrading DTS toSSIS.
• Used most of the controls and features inSSIS/DTSfor transforming data from different sources.
• Involved in building an extensiveOLAPdatawarehouse onSQLAnalysis services (Cubes, stars schema)
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Developed C# CLR using windows base authentication and custom authorization, for use validation for Scanner.
• Used MS SQL Server reporting services (SSRS) to use daily report basis with client-server application.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Environment: T-SQL, Query Analyzer, SQL Profiler, Windows XP, SQL Navigator, SQL Server 2005/2008 Enterprise Edition, Windows 2003 advance server, SQL Server Integration services (SSIS) ,SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Access, VB Macros, Visual Studio 2008, Team foundation Server 2008

Confidential 
Bronx, NY July 07 –April 09 
SQL Developer

This web-based application allows authorized users, both inside and outside the organization, manages claims and assignments, and recommends next steps. Monitors claims that need immediate attention as well as new claims, assignments and rejected claims. Keeps track of all assigned claims until the files are closed. Notify partners via email of new assignments, reduce their response time through automatic new-claim, next-action alerts and involved in developing SSIS packages, Stored Procedures.

Responsibilities

• Installed SQL server 2008 on windows 2003 advanced servers, applied service packs and security fixes.
• Imported Data from text files and excel spread sheet into SQL Server 2008 database using SSIS package.
• Worked with OLTP to provide services and streaming informational display within the video conferences.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Have done migration of database SQL server 2005 to 2008 successfully.
• Developing triggers, stored procedures and enforcing business rules via checks and constraints
• Performance tuning and optimization of procedures and queries.
• Configured product meta-data tables to support client data reporting needs.
• Performance: Analyzed database performance with SQL Profiler andOptimized indexes to significantly improve queries.
• Written complex SQL statements using joins,sub queriesandcorrelated sub queries.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• CreatedSQL reports,data extractionanddata loading scriptsfordifferent databases and schemas.
• Performed Exports and imports from MS access to SQL server Database according to requirements.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, usingSQL Server Reporting Services (SSRS).
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option usingSSRS.
• Data transfers between various servers usingBCPandSSIS.
• Designed and developed theER Diagramsfor the logicalDatabase Model in Erwin data modeler.
• Assisted inproduction OLAPcubes, wrote queries to produce reports usingSQL Server 2005/2008and Reporting service (SSRS).
• Writing queries to generate reports for analysis of data using SQLServer Reporting Services, Report Builder.
• Designed and createdReport templates,bar graphsandpie chartsfor analyzing data.
• Based on the requirements designing and implementing a variety ofSSRSreportssuch asParameterized,Drilldown,Dynamic sorting, Defining data source, Ad hocandSub-reportsusingGlobal Variables, Expressionsand Functions inReport DesignerandReport Builder.

Environment: Windows 2003 Advanced Server, MS SQL Server 2008/2005, SQL Server Integration services(SSIS), SQL Server Management Studio (SSMS),SQL Server Reporting Services , MS Access 

Confidential 
New Britain, CT Oct 05- June 07
SQL Developer

Acstar Insurance Company is categorized under Bonds-Surety and Fidelity. The motive of the project was to create one unified customer database that will eliminate the data redundancy and provide one common place to view, retrieve and update customer information.

Responsibility:-

• Upgrading and installation, creating and managing databases, integrating SQL Server and Windows 2003/2000 Security, continuously developing and troubleshooting.
• Responsible for MS SQL Server 2005 configuration, tuning, and providing 24x7 dedicated support to all Production, development and clustered servers.
• Designed database and implemented multiple systems using MS SQL Server 2005/2000
• Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2000 Server.
• Responsible for writing & Editing Stored Procedures, Triggers, Views, Tables & T-SQL Scripts.
• Developed, deployed and monitoredSSISPackagesincluding upgrading DTS toSSIS.
• Migrated SQL server 2000 DTS packages to SQL Server 2005SSISpackages usingSQL Server 2005 Upgrade Advisor.
• Worked on other packages of the SQL server2005 EditionSSRS(SQL Server Reporting Services).
• Created databases and schema objects includingtables,indexes and applied constraints,connected various applications to thedatabase and written functions, stored procedures and triggers.
• Performedoptimization of query,triggers, and stored procedures, their testing focusing onstability andexecution planwhich has resulted increase in performance of numerous modules.
• SchedulingJobsandAlertingusing SQL Server Agent.
• Created datasets for reports usingT-SQLand stored procedures
• Responsible forQuery optimization and Performance tuning.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created packages and scheduled it to get data fromOLTP, Created Stepped and Block reports usingSSRS.
• Worked on DTS Package, DTS Import/Export for transferring data between SQL Server 2000 to 2005, Involved in upgrading DTS packages to SSIS packages.
• Defined attribute properties in a Parent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• DesignedETL packagesdealing with different data sources (SQL Server, Flat Files, and XMLsetc) and loaded the data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS).

Environment: MS SQL Server 2005/2000, T-SQL, DTS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Confidential 
Mumbai, India June 04-Sept 05 
SQL Developer 

Project Summary:- Call tech is India’s well-known Private Telecommunication company having wide range of customer chain providing cellular facilities in more than 15 states in India. The Project was built to facilitate the data warehousing of various business departments like sales, inventory management, budgeting, Production and Forecasting.

Responsibility:-

• Created new database objects likeProcedures, Functions, Packages, Triggers, Indexes and ViewsusingT-SQLin Development and Production environment for SQL Server 2000.
• Created Visual Basic applications to update Production databases.
• Created Triggers and Stored Procedures for back-end validations.
• Performance monitoring of Servers and Tuning SQL Code.
• Loading data into the database from comma separated flat files.
• Establishing connectivity between Application software and the database.
• Writing Windows Batch Programs to automate operations.
• Testing of applications for performance, data integrity and validation issues.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Migration: copied production SQL Server 7.0 databases to test server running Windows 2000 Advanced Server and SQL Server 2000.
• Develop and maintain in-house utilities to automate problem determination, change
• implementation and monitoring activities.
• Writingcomplex Stored Proceduresto meet the business requirements.
• Creating tables,relationships,triggersandindexesfor enforcing business rules.
• UsingSQL Profilerto estimate the Slow Running queries andperformance tuningpurpose.
• Created and maintained various databases for production, development and testing usingSQL Server 2000.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Created packages, procedures, functions, and triggers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Imported data from text files and excel spread sheets intoSQL Server 2000 database using DTS package.
• Created reports from database onto excel spread sheet using DTS.
• Worked on Migration techniques across differentdatabases and servers.
• Created Users and Roles, and managed security and permission of database.
• Involved in managing Jobs and Error logs.
• Involved in analyzing SQL Server Storage Structure, Index and Security Architecture.
• Setup the SQL Mail in SQL Server 7 to allow SQL Server to send and receive E-mail by establishing a client connection with a mail server.
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.

Environment: MS SQL Server 7/6.5, MS SQL Server 2000, Windows NT, DTS