Hey, Hope you are doing great!!
This is Prahlad from Compunnel software Group. I have an Excellent work opportunity for you to work with. If you are interested and available for below job Requirement, please respond me ASAP with your updated resume. Client: A&E television Location: NYC Duration: Long Term Contract Interview: Phone and f2f Requirement Description: · 8-10 years of IT experience in Data Design and Development on *Microsoft SQL Server 2008 R2/2008/2005*, using T-*SQL*, Performance Tuning, Troubleshooting, *SSIS/DTS* Package Configuration, *SSRS, SSAS *and Data-warehousing. · Experience in using Business Intelligence tools (*SSIS, SSRS, SSRS*) in MS *SQL* Server 2008 R2. · Very good experience in Creating, deploying *SSIS* Packages and migrating DTS Packages from 2000 to 2005/2008. · Migration of SSRS reports from *SQL* 2005 to *SQL* 2008. · Excellent Knowledge in creating databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User Defined data types, Cursors, Triggers and Indexes using T-*SQL*. · Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage. · Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization. · Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting *SQL Server* *2008R2/2008/2005.* · Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using *SSRS* in *Business intelligence development studio (BIDS).* · Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using *SSRS.* · Good understanding of (*SDLC*) software development life cycle process and Agile and Waterfall methodologies. · Excellent knowledge of *Scrum* methodologies and principles in *Agile* and *Waterfall* environments. · Working experienced in Dimensional Modeling and ETL design; designing of STAR, SNOW FLAKE Schemas. · Experienced in using *ETL* tools in (*SSIS*) MS *SQL* 2008R2,MS *SQL* 2008 and in MS *SQL* 2005 · Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, *Oracle* to MS *SQL* Server by using *BCP utility*, DTS and *SSIS* services. · Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS. · Supported team in resolving *SQL* *Reporting* services*(SSRS)* and T-*SQL* related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Form, OLAP and Sub reports, and formatting them. · Experienced in managing Alerts, Operators and Jobs through *SQL* Server Agent. · Excellent *T-SQL* development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions. · Supported team in resolving *SQL* *Reporting* services and *T-SQL *related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Form, OLAP and Sub reports, and formatting them. · Experience in writing complex *SQL* queries involving multiple table’s inner and outer joins, stored procedures. · Proven ability in *Performance Tuning, Query Optimization*. · Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development ---------------------------------- *Thanks & Regards,* *Prahlad Kumar Gupta* *Compunnel Software Group, Inc.* 103 Morgan Lane, Suite 102, Plainsboro, NJ- 08536 *T: (609) 606-9010, Extn: 1328* *E: pgu...@compunnel.com <pgu...@compunnel.com> * -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
