Hi, Hope you are doing fine.. Please let me know if you have any SQL BI developer/ reports developer openings with your direct clients .. Feel free to send me the JD at [email protected] or reach me at 630 355 1861
here is the summary for your reference Consultant Name *S G * Skill *Sr Sql Server BI ( SSIS,SSRS,SSAS) Developer* Availability Immediate Total Exp 7+ Years Relocation Open Current Location *MD* Ø *7+ years* of experience in *design, development & analysis* of *SQL Server 2005/2008* and *SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS*. Ø Experience with *Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008*. Ø Development and Administration experience on *Database Design* and * Implementation* of *OLTP* and *OLAP* environment using SQL server 2005. Ø Good at creating *Tables* and *Views* as per the business and design requirements using *T-SQL*. Ø Extensive experience in developing *Stored Procedures, Functions* using * T-SQL*. Ø Good at improving *Performance* using *Table Indexes*, *Indexed Views*by implementing *Schema Bindings*. Ø Well experience in data Extraction, Transforming and Loading (*ETL*) using various tools such as SQL Server Integration* *Services (*SSIS 2005/2008*). Ø Experience at Transforming and Validating data using *SSIS Transformations* like *Conditional Split, Lookup, Merge Join* and *Sort*and *Derived Colum*n for unstructured and redundant data. Ø Worked with *Flat file, Excel file*, SQL server *OLEDB destinations *for Loading data. Ø Experience with *incremental loads in SSIS. * Ø Generated *VB and C#* scripts used for Script task. Script task is primarily to control the flow of SSIS package. Ø Experience in working with *Slowly Changing Dimensions.* Ø Experience in generating *Ad-Hoc, Drill down, Drill Through reports*using *Local* and *Global Variables, Expressions* and Filters in *SSRS*. Ø Expert in creating *Parameterized Reports, Matrix Reports*, and *Custom generated reports*, *Charts, Sub Reports *as per Business User requirements. Ø Experienced in* installing and configuring Reporting services *and assigning* permissions *to different levels of users in* SSRS.* Ø Proficiency in creating different types of reports such as* Cross-Tab, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports, ad-hoc reports and formatting them.* Ø Experienced in writing* VB scripts *for* user defined functions and *report manager scheduling in* SSRS.* Ø Knowledge of OLAP *cubes* using* SSAS (SQL Server Analysis Services) .* Ø Good knowledge of Defining, Developing and Deploying *Start Schema, Snow flake Schema* and *Dimensional Data modeling *using MS SQL Server 2005 Analysis Services (*SSAS*) on *EDW*. Ø Knowledge in Identifying *Facts* and *Dimensions* for *Cubes* with *MDX queries* in *SSAS 2005/2008.* Ø A multi tasking analytical thinker with the ability to work on fast paced work Environment. Ø *Strong communication skills* and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business. * * *Technical Skills * *Relational Databases * SQL Server 2008/2005/2000, Oracle 10g/9i/8.0, MS Access, DB2,MS Excel, DB2, Teradata, Sybase. *Tools and Packages* SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, Microsoft Visual Source Safe, Crystal Reports9.0, Visual Studio .Net. *Languages* T-SQL, PL/SQL, V.B6.0, C, C#, ASP.Net, VB.Net. *Operating Systems * Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS *Database Design Tools* * * MS Visio, Erwin *Web Technologies* HTML, XML, XSL, , IIS(4.0/5.0/6/0) *Application Packages* MS Office, MS Outlook (Microsoft Office Suite) *BI Tools* SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS),DataStage(7.5/8.1),Crystal Reports * * ** Thanks and Regards, Shubha Venkatesan Technical recruiter Frontier Technologies LLC Email: [email protected] Under Bill s.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 remove link for removal from our mailing list. To be removed from our mailing list reply to [email protected] with "remove" in the subject heading and your email address in the body. Include complete address and/or domain/aliases to be removed. We sincerely regret any inconvenience . -- You received this message because you are subscribed to the Google Groups "SureIT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sureITlife?hl=en.
