Sql Server Software Engineer

Parameshwaran G Mobile: +91-991*******,892-***-****

Mail Id: **************@*****.***

Objective

A position in the IT industry with major responsibilities that will effectively utilize my Database skills and dataware house skills .I am looking for the challenging carrer where there is a scope for demonstration and thrive ideas on imagination and my bottom line rises with the organization.

Certificates

Microsoft Certified Technology Specialist SQL Server 2008 R2, Business Intelligence Development and Maintenance.

Professional summary

Have experience in Software Development, maintenance of Databases on Windows Environments.

Having Sound skills in implementing the Developments on SQL Server 2008 R2 and MS BI Tools.

Expertise in Data warehouse Architecture, Star Schema, Snow flex schema, Facts and Dimensions, Transformations.

Expertise in SQL (Tables, Views, Indexes, sub queries, joins, Constraints, UNION Operators, Aggregate Functions, SQL Performance Tuning, Report Generation), T-SQL (Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes, Sub queries, Joins, SQL Functions).

Relational database development and design knowledge.

Experience in Performance Tuning, Query Optimization.

Installing and maintaining Microsoft SQL server 2008 R2.

Proficiency in using Microsoft BI Tools (SSIS, SSRS, SSAS).

Expert level skill in Extraction, Transformation and Loading (ETL) in SQL Server Integration Service.

Expertise in Developing SSIS packages, good exposure of usage various tasks, transformations, error handling, Event handlers, configuring packages and deployment of packages. Knowledge of DTS.

Advanced reporting skills using SQL Server Reporting Services (SSRS).

Excellent skills in creating reports using SQL Server Reporting Service 2005/ 2008.

Ensure high availability of applications by using Log Shipping, Database Mirroring.

Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)

Experience with data warehousing concepts, designs, and project implementations.

Experience in populating DWH using Snowflake and Star Schema models.

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

Aware of disaster recovery,crontab,change management

Strong Problem analyzing skills to provide quick solutions.

Having Basics Knowledge on ASP.NET, ADO.NET, Controls using C# Programming Language

Professional experience

Has 1.5 year of Experience in IT and Software Application Development.

Working as a Jr Software Engineer in Wider Horizons Software Solutions PVT LTD

Training Programs Attended/ Achievements

Has been the MEMBER IN E-SPART the national level training symposium.

Undergone training conducted by Mafoi academy and smart solutions on personality development.

Trained on SQl sever 2008R2 and BI Tools(SSIS,SSRS,SSAS) in Wider Horizons.

Technology

Skill Proficiency

Databases SQL SERVER 2005,SQL SERVER 2008 R2, SYBASE ASE,Oracle 11g

Services

(MS BI) SQL SERVER Integration Services.

(ETL, Dataflow tasks, Control flow tasks, Deploying projects)

SQL SERVER Reporting Services.

(Creating Reports, Deploying reports)

SQL SERVER Analysis services

(Dimensional Data Modeling, Cube development)

Languages SQL,T-SQl, UNIX Shell Script, C,C++,.NET,HTML,XML,MS OFFICE 2007

Operating System Win2000 /WinXP /Win7/Unix

Tools and Technologies SQL server management studio, visual studio 2008, BIDS, Control-M, Autosys, Remedy ticketing.

Area of Expertise

Database Design,Stored Procedure, Triggers, Functions,Views,Backup & Restore Database.

Index Concepts,Performance Tuning.

SSIS, SSRS,SSAS, Mail Configure, Scheduling Jobs.

Qualification

Bachelor of Engineering in Computer Science at Er.Perumal Manimekalai College of Engineering,Hosur, Anna University, with 77.2%.

+2 – St.Paul’s Hr Sec School, Salem, With 68.08%.

10th – Govt Hr Sec School, Salem, with 70.6%.

Projects Handled:

Project Name : Check Out My Trip

Description:

In the current advent of mechanical life, spending few days completely with the family away from work environment is more important to rejuvenate energy. Planning holidays is tough job as it includes flight reservation, accommodation reservation, and local transit reservation etc. It can be very useful and time saving if there is a web site which does these entire things for us. The current application is aimed at designing and organizing different tours, booking of flights for the same, hotel booking and booking of local transportation like cabs. Entire process can be done, tracked online using this application.

Role : Database Developer & DBA

Responsibilities:

Developed store procedure, queries, dynamic queries, function, view.

Developed SQL Server Jobs for data loads.

Generate auto mail by using scheduler.

Writing Complex Stored Procedures and Debugging them.

Tuning Queries & Stored Procedures for Performance.

Created packages SSIS for sorting billing amounts based on Reservation.

Created SSRS Report for Reservations using Chart, Gauge, image.

Environment : SQL SERVER 2008 R2,SSIS,SSRS

Project Name: Insurance on Internet

Category: Application Development, Enterprise.

Description:

Web registration and profile management all policy holders (customers). Automated e-mail based confirmation.

Information Catalog and search facility for all available policies.

Insurance Premium calculator to provide details as the amount of premium, annually, quarterly etc.

Catalog and contact information about agents of your regions.

Agents can set alerts mails for the premiums due or news or important notices. All such formats should be available in advance.

Add on new Policy, news, notice

Basic and advance admin facilities like add/update Agents,backup/recovery of data, generating various reports etc.

Role : Database Developer & DBA

Responsibilities:

Developed SQL Server Jobs for data loads

Writing Complex Stored Procedures

Debugging stored procedures

Tuning Queries & Stored Procedures for Performance

Created packages SSIS for sorting billing amounts based on banks

Created SSRS Report for companies using Chart, Gauge, image.

ENVIRONMENT:Microsoft SQL Server-2008 R2,SSIS,SSRS

Strengths

Quick learner, Hard working nature, adaptive, dedication about work, confident

Favorite Pursuits

Reading Books & Newspapers, Playing Cricket ,Solving Puzzles.

Contact Details

Present : B-21, TNHB Colony, Therpettai, Hosur-635109.

Permanent: s/o S.Gopal, Kollapatty pudur,Karrupur(PO), Omalur,Salem-636012.

Known Languages

English,Tamil

Declaration:

I hereby declare that the above statements are true to best of my knowledge.

Place: Signature

Date: (G.Parameshwaran)

Contact this candidate