Luv Trivedi

412-***-****

qvqiyx@r.postjobfree.com

SUMMARY:

• Over 1 1/2 years of IT experience with a strong background in T-SQL, ETL & Reporting experience using SQL Server SSIS/SSRS in a high transaction and multi server production environment.

• Proficient in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2005/2000.

• Expert in Extraction, Transforming and Loading (ETL) using SSIS creating mappings/workflows to extract data from SQL Server, Excel file and Flat File sources and load into various Business Entities.

• Excellent backend skills in creating SQL objects like Tables, complex Stored Procedures, Views, Indexes, effective Functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.

• Excellent SQL Server Administration skills including backup/recovery, database maintenance, user authorizations, database creation, Tables, indexes.

• Expert in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like Drill Down, Drill Through, Parameterized, Matrix, and Chart Report.

• Expertise in deploying SSIS Package, SSRS Reports.

WORK EXPERIENCE:

Peach Computers Ltd, Gujarat, India 06/2006 – 10/2007

SQL Server Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).

• Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches.

• To achieve business requirements, used for-Each Loop Container, Sequence Container, VB Script task, Expressions, Execute SQL task, Variables, Send Mail Task.

• Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.

• Provided Dynamic Configuration, Custom Package Logging, Error Handling, and Notification to SSIS template package.

• Created Drill Down, Drill Through, Parameterized Reports, Chart Reports, and Gauge Reports from Tables using T-SQL based on business requirement.

PROJECTS:

Query Analyzer (OLAP Query Process- Database System Class) :

Developed Query Processor Engine which can execute Multi-dimensional Queries. These Multi-dimensional queries are collection of group by statement and such that condition.

Smart Hotel Attendance

Designed a software for a Hotel and developed an Interface Unit for every room of the hotel through which

Customer can place an order as well as play games at the same time.

EDUCATION:

STEVENS INSTITUTE OF TECHNOLOGY, HOBOKEN, NJ GPA : 3.0/4.0

Master of Science in Computer Science, May-2010

S.P.COLLEGE OF ENGINEERING, GUJARAT, INDIA GPA : 3.49/4.0

Bachelor in Information Technology, May-2006

COURSE WORK:

Database Management System, Discrete Mathematics, Data Structure, Software Engineering, Data Mining,

Operating System Concepts, Computer Networking, Project Management, Parallel Processing.

TECHNICAL SKILL:

Database Tools SQL Enterprises Manager, SQL Profiler

ETL Tools SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert.

Programming Language T-SQL, Visual Basic

Web Tools IIS 5.0, MS-Outlook Express.

Reporting Tools SQL Server Reporting Services (SSRS)

Databases SQL Server 2008/2005/2000

Operating Systems Windows 7/Vista/XP

REFERENCE:

Available upon request.

Contact this candidate