SUMMARY:

• 7 years of experience in Information Technology with expertise in SQL Database Design, Development, Implementation and Maintenance.
• Strong experience in Creating Tables, Views, Indexes, Stored Procedures, Functions, Triggers, and Cursors.
• Expertise in writing T - SQL (DML and DDL) Queries.
• Expert in Extracting, Transforming and Loading data using DTS Import/Export Wizard, DTS Packages, Bulk Insert and SSIS services.
• Experience in creating Sub Reports, Tabular Reports, Matrix Reports, Drill down Reports and Charts, using SQL Server Reporting Services (SSRS).
• Experience in Automating the Database Maintenance tasks by creating Jobs and Alerts.
• Experience in migration of Data from Excel, Flat file, MS Access to MS SQL Server by using DTS, SSIS Service.
• Strong experience in developing Crystal Reports. Developed Standard Reports, Sub Reports, Cross Tab Reports, Drill down Reports, Used various Charts and graphs like Bar Chart, Line graphs, Pie Charts.
• Worked on Crystal Reports making use of formulas, parameters, field expressions, special fields, mapping to data sources, performing linking and extracted data from Xml Data Sources.
• Experience in Documenting Existing Process, Creating and Analyzing Business Requirements, Functional and Technical Documents.
• Good experience in Performance Tuning and Query Optimization.
• Knowledge in SQL Profiler, database backup and recovery.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0, HTML, XML, JavaScript

Databases: SQL Server 2005/2000, Oracle 9i/8.x, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS)

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services)

Other Software: MS Office- 2007/2003/2000, Adobe Professional

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL plus, TOAD

Methodologies: Logical and Physical Database Design, UML

PROFESSIONAL EXPERIENCE:

Confidential, Saddle River, NJ

Sr. SQL Developer

Responsibilities:

• Worked on data Extraction, Transforming and Loading (ETL) and Script Task using SQL Server Integration Services (SSIS).
• Worked on enhancing and deploying the SSIS Packages from development server to production server.
• Analyzed client data for quality before and after processing, checking data cleanliness and ensuring the ability to use data in existing processes.
• Provided ETL capability between Excel and MS SQL Server: includes ensuring data imported/exported is appropriately formatted and ready for usage.
• Assisted in developing and maintaining documentation on all data and metadata and supports clarification and usability communication.
• Wrote ad-hoc query batches and stored procedures to assist in analyzing, cleaning, checking and processing data to ensure the maximum possible integrity and quality.
• Developed/ Debugged the C# Code.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Performed Query optimization & Performance Tuning.

Environment: SQL Server 2005, SQL Server 2008, T-SQL, SSIS, SSRS, DTS, VB.Net, MS Excel, C#

SQL Developer

Responsibilities:

• Responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Performed Sorting, formatting, and Grouping to custom reports in (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Published Reports to the report server virtual directory.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Involved in Migration of Packages from DTS to SSIS by using advanced features in SSIS (Aggregate, Sort)
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Identified and resolved the query performance using SQL Profiler.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Fully utilized the Software Development Life Cycle processes including requirements gathering, design, implementation, quality and deployment.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.

Environment: SQL Server 2005, SQL Server 2000, T-SQL, SSIS, SSRS, DTS, SQL Profiler, VB.Net, MS Excel, C#

Confidential

SQL Developer

Responsibilities:

• Involved in gathering requirements, systems design for the new applications, coordinate the enhancements to the applications and deliver them in time
• Created tables, relationships, triggers and indexes for enforcing Business Rule
• Created Reports using SQL Server Reporting Services (SSRS) 2005
• Created Single Value Parameters, Multi-value Parameters to control data in the report
• Automated the database maintenance tasks by creating Jobs and Alerts.
• Bulk Insert was used in SSIS Packages to extract data and load the data to tables.
• Developed SSIS Packages to send mails and information to Finance and gatekeeper applications
• Migrated DTS packages to SQL Server integration services (SSIS).
• Extensively used Joins and Sub-Queries to simplify Complex Queries involving multiple tables.
• Wrote Complex SQL queries and optimizing SQL Queries
• Set up database backup and recovery strategies against data loss.
• Managed indexes and Optimizing Queries by using Execution Plan for performance tuning the database
• Developed the end-user documentation and performed periodic updates of the design documents.

Environment: SQL Server 2005, SQL Server 2000, DTS, SSIS, SSRS, T-SQL, MS Excel, VB.Net, Windows NT/XP.

Confidential

SQL Developer/Crystal Reports Developer

Responsibilities:

• Understood and articulated requirements from user interviews and then convert them into Business Process documents to develop and maintain applications. worked on Database Connections, SQL joins, Materialized Views, Indexes, Aggregate Conditions and Written Stored procedures and Functions for processing business logic in the database
• Extensively used DTS Packages for bulk data upload.
• Imported and Exported Excel records to SQL Server Database
• Implemented Constraints on tables
• Designed and developed Standard Reports, Sub Reports, Cross Tab Reports and Charts using Crystal Reports.
• Used Crystal Repository for reusability of objects
• Exported Crystal reports into various formats like PDF, HTML, Excel and Word for end users.
• Used prompts to generate Parameterized Reports allowing the user to limit the reports to particular cases
• Tuned SQL to reduce the runtime and increase performance & efficiency
• Involved in setting up Test data, Validating test results and Coordinating to change requests.
• Involved in creating Technical Specification Document (TSD), and User Documentation for interpretation of the reports

Environment: SQL Server 2000, DTS, SQL Profiler, Index Tuning Wizard, MS Access, MS Excel, Crystal Reports 10.

Confidential

SQL Developer /Crystal Reports Developer

Responsibilities:

• Actively involved in gathering of User Requirements and System Specification.
• Created Tables, Views, Cursors, Indexes, Established relationship among tables.
• Developed complex SQL Queries and Stored Procedures.
• Involved in Data migration (DTS Import & Export Wizard) from Text to SQL Server
• Extensively involved in reviewing the DTS Packages. worked actively on Designing and Developing Databases
• Created and modified Procedures, Packages, Functions, and Triggers
• Actively involved in Normalization and De-normalization of database
• Creation of different kinds of Crystal reports such as: Sub reports, Cross Tab reports, Charts.
• Added Sorting, Grouping and Running Total to Crystal Reports
• Created nested and conditional groups and formatting features in reports.
• Worked on Optimization and Tuning of SQL Queries and Indexes.

Environment: SQL Server 2000, DTS, T-SQL, SQL Profiler, MS Excel, Crystal Reports 9.0.

Confidential

SQL Developer

Responsibilities:

• Installed and configured MS SQL Server 2000 on Windows NT machines.
• Developed Stored Procedures, Triggers and Functions based on Project Requirements.
• Worked on T-SQL utilities to generate table insert and update statements.
• Created Indexes to speed up the queries.
• Used Data Transformation Services (DTS) to populate data from various data sources
• Wrote DDL scripts for generating Tables, Views and Functions.
• Database objects were created and maintained with proper Storage Parameters after considering estimated object size and growth factors.
• Involved in design of Logical model and Physical model of Databases
• Established Backup and Recovery process to protect database from data loss
• Made sure that standards and best practices in database development were followed and maintained.

Environment: SQL Server 2000(Enterprise Manager, Query Analyzer), DTS, T-SQL, SQL Loader, MS Excel/Access.