Vivan Kumar Email & Phone Number

Chicago, Illinois, Us

Created SSIS packages to perform filtering operations and to import the data on daily basis from the legacy data sources to SQL Server 2016.Creating complex SQL scripts to transform legacy data in staging area using SSIS packages.Configuring SSIS packages for run time parameters and config files.Developed complex Stored Procedures using SQL, Dynamic SQL queries having good performance.Used SSIS for Extracting and Merging of data from different source to single source.Scheduling Jobs to run SSIS Packages in the night feed to DSS for fresh day data.Scripting using SSIS packages for data cleansing, encrypting and decrypting sensitive information.Created SSIS packages to automate different FTP’s files and emailing to different clients.Created SSIS packages using various Transformation to generate underlying data for the report and to export the cleaned data from Excel, CSV, Flat file and MS Access to data warehouse.Generated reports from SQL Server Database and OLAP data warehousing.Deployed Reports to Report Manager and Troubleshooting for any errors during in execution.Scheduled the Reports to run on the daily and weekly basis in Report Manager and email them to the directors and analyst to review in Excel sheet.

Boston, Ma, Us

Designed SSIS packages to extract data from various data sources such as Access Database, Excel spreadsheet and Flat files into SQL Server for further Data Analysis and Reporting by using Multiple transformation provided by SSIS such as Data conversion, Conditional Split, Bulk Insert, Merge and Union all.Transformed data from various data sources using OLE DB connection by creating various SSIS packages.Created packages in SSIS with Error Handling and worked with different methods of logging in SSIS.Involved in creating complex stored procedures and views to generate various Drill through reports, Parameterized reports and linked report using SSRS.Designed and Developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.Scheduled Reports for daily, weekly, monthly reports for executives, Business Analyst and customer representatives for various categories and regions based on business needs using SQL server SSRS.Created complex reports using multiple data providers, user defined objects, charts and synchronized queries.Created subscription for the windows file share and implemented three layers of security for the report, SSRS website and in the intranet web application.Worked on querying data and creating on demand reports using Report Builder in SSRS reports and scheduling the report through standard and data driven subscriptions.Created Indexes, Views, Stored Procedures, User Defined Function, Cursors and Triggers to facilitate efficient data manipulation and data consistency.