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 "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.