Developed complex programs in VB Script, which connects to SFTP server to get the initial data which is in CSV Format, with best execution plan.
Involved in migration from SQL Server 2005/2008 to 2012
Used Data Flow task, execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
Created SSIS Packages to import the data from different databases, XML, text files, Excel files.
Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008.
Created packages to convert flat file to XML file.
UNIX commands, development, and execution of UNIX shell scripts, database stored procedures, and work with relational database and tables are needed
Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.
Developed Report Models for building Adhoc reports using Crystal Reports.
Developed optimal stored procedures and queries to create data sets for reports.
Expert in creating Star schema cubes using SSAS.
Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.