Law

Hi,

 

Please go through the requirement and let me know your interest.

 

SQL Server Developer

Location: Seattle, WA (Need Local)

Duration: 6 Months+

 

Phone, followed by a face to face

 

·         Responsible for gathering and analysis of business requirements.

·         Worked with design architect and helped in writing functional and technical specifications for project.

·         Did extensive research on BI connector and BizTalk connector for SAP and did a proof of concept to test the performance of 2 different connectors to pull data from SAP.

·         Created an ETL process which moves HR data from SAP systems to Feedstore (SQL Database) using Biz Talk connector.

·         Improved the performance of SLA by designing a parallel processing system, where SSIS Packages will be executed in parallel with the help of metadata.

·         Closely worked with SAP-ABAP team to discuss on communication methods from SAP to SQL Server for design.

·         Created logical and physical data models using Erwin for database design.

·         Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.

·         Involved in creating database objects like tables, stored procedures, Functions, Views, and Triggers.

·         Created technical documentation and Operational guides as required.

·         Created a centralized logging mechanism (aka Sawmill) for the project to track the operation status and log errors using SQL Service Broker. Now 10 projects were using this mechanism to track the SSIS tasks execution and log errors to SQL tables.

·         Performance tuning and testing on stored procedures, indexes, and triggers.

·         Environment/Tools: SQL Server 2008/2005 Management Studio, SQL Server Integration Services, T-SQL, Team Foundation Server, Visual Studio 2008.

 

 

 

Thanks & Regards

 

Dev Chauhan

International Technical Solutions (ITS)

D:- 206-274-4684

F:- 206-319-4579

dev.chauhan@i-tecsol.com

Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at support@i-tecsol.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience.

 

--
You received this message because you are subscribed to the Google Groups "Frontier Knowledge Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to frontier-knowledge-group+unsubscribe@googlegroups.com.
To post to this group, send email to frontier-knowledge-group@googlegroups.com.
Visit this group at http://groups.google.com/group/frontier-knowledge-group?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.