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.

COMPUTER 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

EXPERIENCE:

Confidential, SaddleRiver, NJ

Responsibilities:

• Expert in data Extraction, Transforming and Loading (ETL) and Script Task using SQL Server Integration Services (SSIS).
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Analyze client data for quality before and after processing, checking data cleanliness and ensuring the ability to use data in existing processes.
• Provide ETL capability between Excel and MS SQL Server: includes ensuring data imported/exported is appropriately formatted and ready for usage.
• Assist in developing and maintaining documentation on all data and metadata and supports clarification and usability communication.
• Write ad - hoc query batches and stored procedures to assist in analyzing, cleaning, checking and processing data to ensure the maximum possible integrity and quality.
• Able to build and understand /Debug the C# Code.
• Maintain a professional attitude.
• Maintain confidentiality at all times.
• Should maintain clear communication with the team.

Confidential, Reston, VA

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, Erie, PA

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, O'Fallon, MO

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, Denver, CO

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.