Service Engineer Resume Redmond, WA - Hire IT People

SUMMARY

Experience developing monitoring tools via T - SQL,Power shell, C# and MS-DOS commands.
Highly driven and results oriented.
Proficient in T-SQL (creation of tables, procedures, functions and other Database Objects), SSRS and SSIS.
Maintenance of Production Databases.
Query tuning, Replication, Database backups and Restore, Log shipping, DB Mirroring.
Implementation of high availability feature like Clustering, Cloning and Geo Load Balancers.
SQL Server 2005 and 2008 installation; Creation and maintenance SSIS Packages, SSRS Reports.
Power Shell Scripting, C#, VB.NET, ASP.NET, Java Script, .BAT commands
FxCorp, nUnit testing.Source Control usage - PVCS, VSS.
Build and Deployment of packages.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Service Engineer

Responsibilities:

Development of customized SSRS Reports based on the business requirement using BIDS 2008, maintenance of those reports and Databases hosted on MSIT Platform for ASM BI Space.
Creation of Databases and designing of the table structures based on the requirement
Using T-SQL to write up Stored Proc/Functions/Views. Using new feature of in T-SQL and SSRS for SQL Server 2008
Using SSIS, Distributed Queries and BULK INSERT/BCP command to fetch data from different source.
Performance tuning of the queries as required, using Indexing, BPA, studying of Execution plans.
Building up customized application using SQL - SERVER SMO.
Building of Event Viewer,SSRS/IIS Log Monitoring Tool using Powershell scripting.
Installation of SQL Server, SSIS, SSAS and Reporting Service and Integration of reporting service with SharePoint.
Developing monitoring tools via Power shell and SQL Server inbuilt features
SharePoint 2010 /Performance Point Server/ProClarity Administration
Implementing High Availability solutions like Clustering, Mirroring, Log Shipping and Replication.
Experience on Windows 2008 R2 and SQL Server 2008 R2

Confidential, Redmond, WA

Database Engineer

Responsibilities:

Maintenance of critical production databases for Cashback.
Developing monitoring tools via Power shell, C# and T-SQL
Building up of Reports (KPI/Performance) and reporting framework using BIDS, SSRS and Dundas Charting Framework.
Installation of SQL Server, SSIS, Reporting Service.
Implementing High Availability Solution like Transactional Replication, Mirroring and Log Shipping
Implementation of High Availability clustering solutions.
In depth knowledge on Windows 2008 and SQL Server 2008 R2

Confidential

Developer

Responsibilities:

Migration from legacy technologies (4GL, UNIX, Informix) to Microsoft technologies.
.NET 2.0, C# and SQL Server 2005, NUNIT, FXCorp.
Involved in architecture development for the application.
Handling of critical module.
Migration of existing Reports to SSRS.
Unit testing and actively involved in System Integration Testing.

Confidential

Developer

Responsibilities:

Web application used by Nokia business users and Nokia Distribution panel to maintain their stocks distribution across India and Indonesia.
.NET 1.5, VB.NET, JavaScript, SQL Server 2000, FXCorp, NUNIT.
Involved in development, testing and Support for the application.

Confidential

Developer

Responsibilities:

This was a web application which dynamically generates queries and reports
.NET 1.5, C#, JavaScript, and SQL Server 2000.
Involved in development, unit testing and system integrated testing of the application