Technically-advanced information technology specialist successful in SQL database development.
6+ years of IT experience in Database Development on MS SQL Server 2000/2005/2008 and 2008R2 in Production, Testing and Development Environments.
Experience in working with Data Transformation Services (DTS) & SQLServer Integration services (SSIS) packages
Expert in utilizing ETL tools, including SQL integration Services (SSIS), Data Transformation Services (DTS), Export/Import wizard Worked with different types of control flow tasks and Data flow tasks performing Data Enrichment and Data Management.
Created SSIS packages for Data Movement, Managing historical data from various heterogeneous data sources (i.e. Excel, Access, flat file, OLEDB).
Created Different types of SSIS packages incorporating different types of Stored Procedures in the package.
Expert in handling parameterized Reports using SQL server Reporting Services 2005,2008/R2
Proficient knowledge on SQL Server Analysis Services. Proficient in creating complex reports (AdHoc Reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical reports etc)
Proficient experience in restoring database using full, differential, and log backups.
Experience with analyze, upgrade and support SQL Server 2000 databases.
Hands on Experience in Extracting and transforming Data with SQL Server 2005 using ETL tools.
Experience in Extracting, Transforming, Loading (ETL) data using SSIS, DTS Import/Export utility, BCP and DTS Packages
Experience in designing and Building the dimensions and cubes with star schema using SSAS
Extensive experience with SQL scripts, stored procedures, triggers, functions, SQL Performance tuning and transactions analysis, thorough an in depth understanding of indices and statistics.
Excellent report creation skills using Microsoft Reporting Services. Solid experience in Integration services, Analysis Services, data-flow, DTS package design and construction.
Excellent analytical , Interpersonal and Communication skills, fast learner, hardworking and versatile team player.
Companies Worked For:
Job Titles Held: