Amit Kumar

About Amit Kumar

Expertise in MS SQL Server 2008/2012/2014 suite of products like SSIS, SSAS, and SSRS.• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2008 and MS SQL Server 2012 respectively• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).• Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008/2012 (SSRS).• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2012.• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2008/2012, MS Access databases and strong knowledge of SDLC principles.• In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.• Expert in database creation, maintenance, monitoring, backups and recoveries.• Specialized in analyzing, coding, implementing and creating complex query reports using Oracle 8i/ 9i/ 10g, SQL Server Sybase and DB2.• Excellent interpersonal communication, problem solving, documentation & business analytical skills.

Experience

1. Sr Ms Bi, Sql Server Development

   Prudential Financial

   Feb 2016 — Present

   MS SQL Server Developer/ BI DeveloperPrudential Financial Company serves individual and institutional customers worldwide. The project involved designing a new database schema, migrating data from SQL Server 2008 to SQL Server 2012, performing analysis and then generating various types of reports.Hardware/Software: MS SQL Server 2008/2012, SSRS, SSIS, SSAS, Power BI, Oracle 9i, T-SQL.Responsibilities:• Transformed data from MS SQL Server 2008 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.• Used the Execute DTS package task to execute DTS packages.• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.• Extracted data using SSIS packages (ETL) from different server locations and data sources.• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.• Created MDX queries to extract data from the Data Mart.• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T_SQL code and SQL joins for applications.• Generated Dynamic reports from Cubes (SSAS) using SSRS.• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.• Used HTML code to make Report manager more functional & customizable.• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Education

• Indian Institute of Technology, Delhi

  Computer Science