Resume

Sign in

Sql Server .Net

Location:
Plano, Texas, United States
Salary:
100000 to 110000
Posted:
January 20, 2017

Contact this candidate

Name: Sivakami Senthil

Cell Phone #: 510-***-****

Email ID: acydzo@r.postjobfree.com

SUMMARY:

8+ years of extensive experience in the Design, Modelling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2.Multi- tasking, Adaptable, Self-motivated, Quick learner, organized team player with strong problem solving and analytical skills looking for new opportunity and organisational challenge.

EDUCATION &CERTIFICATION:

Microsoft Certified Technology Specialist (MCTS) in .NET Framework2.0 Web App

Master of Science in Applied Electronics, Regional Engineering College, India

Bachelor of Science in Industrial Electronics – SRC, India

TECHNICAL SKILLS:

SQL Server Tools : Enterprise Manager, Profiler, Query Analyzer, SSRS, SSIS, SSAS,

Query Editor.

RDBMS : MS SQL Server2005/2008, MS Access

Programming Languages : C, C#, Java, SQL, T-SQL, PL-SQL, ASP .Net, ADO .Net and XML

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

Services (SSIS)

Internet Technologies : XML. HTML

Productivity Applications : MS Word, Excel, Access

Reporting Tools : Crystal Reports 9.0,10, 11, SSRS

Operating Systems : Win 2003 and XP and 2000 and NT, MS DOS

PROFESSIONAL EXPERIENCE:

Organization: O’Neil Digital Solutions LLC, Plano/Los Angeles (June 2010 to Till Date)

Role: Database Software Engineer

My current company is a printing company mainly involved in printing healthcare Insurance ID cards, EOB letters and EOC books for different clients.

Description: I am responsible for the systems study, analysis, understanding systems design and database design. My role involves understanding customer requirements, conceptualizing, designing and implementing inputs using SQL. This involves dealing with as high as 9 Million data volume. Developed BCP program to efficiently import the data’s into SQL database within a short amount of time.Developed complex stored procedures to create various reports. This project was recognised by Client CVS Caremark for its attention to detail.

ENVIRONMENT: NET Framework, C#, Visual Studio.NET, MS SQL Server 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access2007 & 2010.

Key Clients:

CVS Caremark, SXC and Rx America.

Key Responsibilities:

Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases. Performance tuning to optimize SQL queries using query analyser.

Designed VB forms using the forms and crystal reports were made for business reporting purpose. Involved in performance tuning of the database and T-SQL queries using Explain Plan.

Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.

Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

Environment: .NET Framework, VB.NET, ASP.NET, ADO.NET, WEB Service, C#, PL/SQL, Web Forms, MS SQL Server 2005,2008, SSRS Reports, SQL server Management Studio and Windows 2000.

Organization: Cornet Technology Inc, India (Mar 2002 –Jan 2005)

Role: Software Programmer

Key Project: Time Tracking System

Description: Developed an ASP.NET time tracking system for employees to login and put the hours they worked on each project. Project Managers have ability to login and view all the log entries of the project members working under them. Besides this the managers can also view details about their employees related to the number of holidays, sick leave, etc taken in between the project. In the same way administrators can keep a check on managers. It has logical 3-tier architecture. Security accomplished by form based authentication.

Key Responsibilities:

As a developer, involved in design and developing Web Forms using ASP.NET and C#.

Implemented authentication and authorization using Global. Sax and web.config files and Cookies.

Business logic in C# for role-based security achieved so that administrators, managers, users can only view the pages they are allowed to.

Validation controls were implemented in ASP.NET for validating various entries.

Used List controls like repeater controls, data list controls and data grid controls for displaying the data. Used ADO.NET Object to connect to SQL Server 2000 database.

Created Stored Procedures and Triggers to update and Insert data using ADO.NET objects.

ENVIRONMENT: Microsoft Visual Studio.NET, C#, ASP.NET, ADO.NET, IIS, MS SQL Server

2000, TSQL, Crystals Reports.

REFERENCE:

Available on request



Contact this candidate