*CERTIFIED SR SQL SERVER BI ( SSIS,SSRS,SSAS) DEVELOPER **AVAILABLE IMMEDIATELY for your direct client requirements only*
Request: please take a minute and add pa...@quantuminfotech.com in your mailing list for current and future requisitions. *Please scroll down to know for other available consultant Technologies.* Consultant Name *Roshan* Skill *Sr **SQL Server BI ( SSIS,SSRS,SSAS) Developer* Availability Immediate Total Exp 7+ Years Relocation Open Current Location Los Angeles, CA · Over 7 Years of IT Experience in Business Intelligence Technologies and Database with Extensive Knowledge in ETL Process and Reporting Services using SQL server 2008/2005, SSIS and SSRS. · Experience in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert and Merge Join. · Experience in writing complex TSQL Queries involving various tables using Inner and outer joins. · Experience in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries. · Expertise in optimizing the queries by creating Index views, clustered and non-clustered indexed views. · Extensively worked on VMware workstation. Deployed SQL server. · Expertise in various phases of project lifecycles (Design, Analyzing, Implementation and testing). · Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert. · Experience in migration of databases from Oracle and non-oracle sources to SQL databases using 2008 SSIS (SQL Server Integration Services). · Expert in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. · Extensive knowledge in designing reports using cascading parameters, Parameterized reports, report models for Adhoc reports using SQL server Reporting services (SSRS) based on Requirement. · Constructed Cubes based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Snow-Flake Schema, Fact and Dimension Tables. · Experience in the performance tuning using SQL profiler identified slow running queries and optimized the queries to see that it will not affect the server performance. *Technical Summary:* * * MS SQL Server 2000/2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Analysis Services 2005/2008, MS SQL Server Integration Services 2008/2005, MS Access, C++, HTML, VMware, MS Visio 2003, Windows server 2000/2003, Crystal Reports XI/8.5/8.0, Visual Studio 2005/2008, MS VISIO 2000/2003 Remote Desktop, DreamWeaver, Flash, Ms Office, Ms Frontpage *Looking ahead to work with you for better business prospects.* *Regards,* *Pavan Kumar**|** Quantum Infotech Inc **|** *)*248-457-0700 * 136 **|** *7*248-928-0495 **|** **pa...@quantuminfotech.com*|*:www.quantuminfotech.com*|* *Quantum Infotech Inc* *is an ISO 9001-2000 certified, MMDC Certified, 8(A) & GSA-IT Schedule* *Gtalk:** **pavan.recruit...@gmail.com* <pavan.recruit...@gmail.com>* *** [image: LinkedIn] <http://in.linkedin.com/pub/pavan-kumar/46/171/22b> * * *“WE PAY** $1000 FOR A GOOD REFERRAL”* *An *[image: Description: Description: Description: Description: Description: http://t0.gstatic.com/images?q=tbn:ANd9GcTzWHC3crnfdWlRitTOkW4JO_g6sndCgqKJs7hRRCKBTS1sG__j]<http://www.google.com/imgres?q=e-+verify+logo&hl=en&biw=1920&bih=963&gbv=2&tbm=isch&tbnid=_Ftwqmer53oNIM:&imgrefurl=http://thingrayline.blogspot.com/2008/09/e-verify-must-renewed.html&docid=1iI6WX-3nJ4OUM&w=200&h=48&ei=EmMxToPRIcW_gQfvn7ygDQ&zoom=0> * Employer* * * *Quantum does not endorse undesired email. If you do not want to receive our mails, * *please reply with Remove in the subject; I would ensure that you are not troubled further. I apologize for any inconvenience.* *P* *Save a tree! Print this message only if it's absolutely necessary* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to sap-basis@googlegroups.com. To unsubscribe from this group, send email to sap-basis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.