SQL DEVELOPER

HARISHKUMAR CHAUDHARI

E-mail: ************@*****.*** Ph: 732-***-****

SUMMARY OF EXPERIENCE:

• 2+ years of experience as SQL Server Developer in the Analysis, Design, Development, Implementation, Testing, and Maintenance of application systems in Client Server Environments.

• Extensive working experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL server 2008/2005/2000

• 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.

• Well versed with dimensional modeling to design and develop Star/Snowflake schemas using ER-Win data modeling tool.

• Expertise in database activities like Data Modeling, Database Design, Performance Monitoring, Troubleshooting and Documentation.

• Installed, upgrade and configuration of SQL Server 2000 /2005/2008 databases.

• Expertise in writing DDL, DML and DCL commands using T-SQL, PL-SQL, as well as ANSI SQL.

• Experience with SQL Server 2005 and worked extensively on BI Tools (Integration services (SSIS) and Reporting services (SSRS) and Analysis services (SSAS).

• Experts in designing and handling SQL Reports, Sub Reports and Drill down Reports. Proficient in designing report layout, sorting the data, defining subtotals for the reports using SSRS 2008/2005.

• Expertise in Microsoft Reporting Service (SSRS) with Report authoring, Report Management, Report formatting, Report distribution, Report delivery and Report security.

• Experience working with enhanced Data Profile Viewer in SQL Server 2008 Integration service and enhancements in SSRS 2008

• Experience in report, writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.

• Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).

• Experienced in using ETL tools in (SSIS) MS SQL 2005 and DTS in MS SQL 2000

• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools Star Schema, Data Warehouses, OLAP Cubes, Partitioning and Aggregation ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, and ad-hoc Reporting.

• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.

• Empowers users to get more information from one crystal report.

• Crystal report proven best practices from a business intelligence leader.

• Experienced in creating SSIS and DTS packages for ETL purposes

• Proficient in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.

• Used multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data to SQL Server databases using SSIS

• Implemented indexes (clustered & non clustered) on tables and views for optimum performance tuning.

• Extensive knowledge in SQL Server 2008/2005/2000 with Transact SQL

• Proficient knowledge in T-SQL queries DDL / DML, perform most of the SQL Queries.

• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules and SQL Performance Tuning.

• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Command

• Self-starter, Team player, leadership/communication skills, and take initiative approach towards completing tasks.

EDUCATION

• Bachelors of science in Engineering, HNGU University, India

• Master’s of science in Electrical Engineering, UNIVERSITY OF BRIDGEPORT,CT,USA,2010

TECHNICAL SKILLS:

SIMULATING TOOLS Matlab, Multiseem, MASM, Mentor Graphics, PSPICE.

ETL Tools SQL Server Integration Services (SSIS) 2008/2005, DTS, BCP Utility

Development skills Transact SQL (T-SQL), PL/SQL, Stored Procedure, Views, Triggers,

RDBMS MS-SQL Server 2008/2005/2000, Microsoft Access

Database Tools SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), Enterprise Manager, SQL Profiler, Query Analyzer, MS access, Erwin Data modeler,

MS Visio, Red gates tool

Reporting Tools SQL Server Reporting Services (SSRS) 2008/2005, MS Excel, Chart reports

Programming Languages C, C++, .NET Framework, C# ,VB script

Operating Systems Windows 98/2000/XP/Vista/7, Advanced Server Professional, Windows Server 2008/2003, Windows NT, Linux, Unix

WOEK EXPERIENCE:

INFOSYS, BANGALORE, INDIA, JULY2006-DEC 2007

MS SQL Server Developer

Infosys Technologies Limited is a multinational information technology Services Company headquartered in Bangalore, India. It is one of India's largest IT Company. As part of team I worked with multiple clients including Citigroup & JPMCHASE. As part of development team, I involved in developing DTS packages, Stored Procedures & XML.

Responsibilities:

• Created Database Objects in TSQL - Tables, Indexes, Views, and Roles.

• Created Customized Stored Procedures, Triggers, and Cursors.

• Involved in job scheduling using MS SQL server Agent.

• Prepare and set up environment for Disaster recovery.

• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).

• Data conversions from legacy systems to SQL server Using DTS.

• Wrote DTS scripts for data transfer

• Responsibilities also included transferring of customer, personal financial history information from various ODBC driver files to SQL server database files using DTS.

• Performed Data transfer (Import & Export) using BCP.

• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using Execution Plan.

• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

• Designed and created views for security purposes, implemented rules, defaults, and User defined data types.

Designed index, statistics and optimized queries by using execution plan for performance tuning of the database

Environment:

MS SQL Server 2005/2000, Visual studio 2005, MS Access, MS SQL Server Reporting services 2005, MS SQL Server Integration Services 2005.

DIZER CORP - Trainee JAN 2010 –JULY 2010

SQL SERVER/T-SQL/SSIS/SSRS

SQL SERVER 2008/2005

SEMINAR UNDERTAKEN:

Telecommunications consultants India Ltd.(A Govt. of India Enterprise)

• Implementing and Expansion of Gujarat State wide area Network (GSWAN).

• This world’s second largest IP based network using equipment form industries like CISCO, Polycom etc.

PROJECT UNDERTAKEN:

• 5V power supply by using IC 7805(RP) (sem 111)

• Computer based home appliances (sem-1V)

• Microcontroller based seven segment display (sem-V)

INTEREST:

• SQL Server, ,Database System ,RDMS software IT field

EMPLOYEE RESUME PROFILE:

Name : Harishkumar B Chaudhari

Specialized Area : Database Developers

Specialized Skills : SQL Server Developer/T-SQL/SSIS/SSRS

Experience : Tot: 1.5 Yrs USA: 7 month Total:2+ Years

Location : Edison, New Jersey (NJ)

Relocation : Yes

Contact Details : +1-732-***-**** (M),

Rate : Market

Status : EAD – legally Authorize to Work in USA

COURSE WORK

• Database concept,SQL server,RDMS, Microcontroller, programming C language, digital signal processing, network theory

• Knowledge of CRO, test equipments, DC Source, AC Source, Millimeters, Auto transformers, Data loggers, etc

Contact this candidate