US CONSULTING - CONTRACT Sr. SQL Server Developer Available Immediately

Hi

Greetings from Zuven Technologies Inc

 

We have excellent below resource available for your direct client projects nationwide. If you come across any requirements in the area please do mail me at paul@zuventech.com  or can reach me at 469 854 2198

                        “Sr. SQL Server Developer Available Immediately”

 

Consultant Name	ABY
Skill	Sr. SQL Server Developer
Availability	Immediate
Total Exp	7+ Years
Relocation	Open
Current Location	FL
	About 7+ years of experience in Development, Client Analysis, Database Design and Presentation using SQL Server 7.0/2000/2005/2008/2008 R2involving all stages of Software Development Life Cycle(SDLC) ·         Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2008/2005/2000. ·         Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS). Experience in database performance tuning and query optimization, data integrity and statistics and stored procedures using SQL Profiler and Index Tuning Wizard. Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Database Normalization, Tables, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors. Experienced in transforming complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS. ·         Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML. ·         Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications. Expert skills in advanced SQL database queries, building views/procedures against SQL Server 2005/2008 BI stack. ·         Extensively worked on SSIS packages/object to extract data from various data sources, transform it and load the data into destination like, OLAP server for further analysis. ·         Extensive experience with SQL Server Reporting Services (SSRS) reports in parameter report, drill down reports, tabular, matrix, sub reports, subtotals of reports . ·         Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2005/2008. Extensively worked in sorting the data, defining subtotals for the reports. Excellent Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS). Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers. Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data     Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MSAnalysis Services ·         Created and Configured OLAPCubes (Star Schema and Snow flex Schema) using SSAS. ·         Involved in designing and implementing application using .net framework 3.5 to call the reports from presentation layer. ·         Major strengths are familiarity with multiple software systems, ability to learn quickly new technologies, adapt to new environments, self-motivated, team player, focused   adaptive and quick learner with excellent interpersonal, technical and communication skills. ·         Strong knowledge of MDX query language ·         Experience with healthcare HIPAA EDI transaction sets. ·         General healthcare/Revenue Cycle experience. ·         Integration – Experience with SQL Server Integration Services (SSIS) and Data Transformation Services (DTS)i9. ·         Traditional or Agile (Scrum) SDLC knowledge. ·          Experience with one or more BI dashboard tools. ·          Experience in deploying BI over the Internet.     TECHNICAL SKILLS:   RDBMS/ Database              SQL Server 2000/2005/2008 R2, MS-Access XP/2007, Sybase. ORACLE 10g/9i, PL/SQL Reporting tools                    Crystal Reporting 10.0, SQL Server (SSIS, SSAS, SSRS)           Data Modeling                     Microsoft Vision 2000, Erwin 4.0/3.5 Languages                             T-SQL, PL/SQL C#.NET, ASP.NET, XML, VB.NET, Visual Basic 6.0 GUI                                          Visual Studio.Net, Visual Studio 6.0/2005 SQL Tools IDERA Performance Monitor, SSMS, SQL Profiler, DTS, Database Tuning Advisor DTA, IDERA SQL Backup. Web Design Tools                Dream Weaver CS3, FrontPage 2002, Outlook Express, Adobe Flash Scripting Languages             Shell scripting, Perl Scripting, Java Scripting Operating Systems               MS-DOS, Windows 2000/XP/NT/Vista, UNIX