Certified SQL SERVER BI (SSIS, SSAS, SSRS) consultant AVAILABLE IMMEDIATELY
Request: please take a minute and add a...@svksystems.com in your mailing list for current and future requisitions.
Please scroll down to know for other available consultant Technologies.
Consultant Name | Ramesh | ||||||||||||||||
Skill | Certified Sr Sql Server BI ( SSIS, SSAS, SSRS) Developer | ||||||||||||||||
Availability | Immediate | ||||||||||||||||
Total Exp | 7+ Years | ||||||||||||||||
Relocation | Open | ||||||||||||||||
Current Location | MI | ||||||||||||||||
PROFESSIONAL SUMMARY Ø 7 Years of extensive experience in SQL Server Development including writing T-SQL Programming, Physical & Logical Database Design, SQL server 2005 suite of products SSIS, SSRS, SSAS. Ø Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration. Ø Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment. Ø Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries. Ø Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008). Ø Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages. Ø Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes,, Develop Queries and T-SQL Scripts in MS SQL 7.0/2000/2005/2008. Ø Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008. Ø Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation. Ø Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages. Ø Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008. Ø Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk. Ø Expert in extracting and transforming data using DTS Import Export Data, DTS Packages, SSIS and Experience in using BCP for Bulk copy operation and Bulk Insert. Ø Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis. Ø Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations. Ø Expert in performance tuning, query optimization and running database. Ø Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, Indexes, Stored Procedures, Cursors and Triggers Ø Migrated Organization, Orders, Adjustments, Objectives and Callidus data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints. Ø Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues. Intensive experience in monitoring. Ø Experienced in design of logical and physical data modeling using Erwin data modeling tool. Ø Experience in migrating from SQL Server 2000 to SQL Server 2005and from SQL Server 2005 to SQL Server 2008. Ø Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all. Ø Highly motivated, committed and a natural team player with capability to work independently, Strong analytical ability coupled with excellent written and verbal communication skills. Ø Accustomed to working in a fast paced time-frame goal oriented environment and able to deliver under pressure and time constraints. Certifications Microsoft Certified Technology Specialist in Business Intelligence. Microsoft Certified Technology Specialist in SQL Server 2005 TECHNICAL SKILLS
|
AVAILABLE CONSULTANTS - JAVA |.NET |SHAREPOINT | SQL SERVER BI DEV/DBA | COLDFUSION | BO ADMIN / DEV | UI / GUI DEVELOPER |REMEDY |JAVA ADOBE FLEX | COGNOS | BA | WEB DESIGNER |PEGA | ETL INFORMATICA | QA | SAS | ACTUATE DEV|
Thanks & Regards
ANIL KUSHNAPALLI
SVK Systems, Inc
11465,
Direct :205-267-5716 ext 517
Cell : 205 510 7431
Fax : 404-601-9507
|
| |||||
| NOTE: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include the contact information for removal from our mailing list. To be removed from our mailing list please click above SafeUnsubscribe link or reply to Anil Kushnapalli: [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. If you still get these emails, please call us at the numbers given above, my sincere apology. | ||||||
You received this message because you are subscribed to the Google Groups "KNOW.IT" 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/know_it_az?hl=en.
