Upgrade Post project
AS

amit sharma

pune
available

Last update: 12.07.2021

MSBI CONSULTANT (SSIS SSRSSSAS)POWER BI TABELEU SQL SERVER

Company: aa
Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional)

Keywords

Attachments

Amit G Sharma.doc

Skills

ssis --11 years
ssrs --11 years
ssas --11 years
power bi --4 years
sql server --11 years
tableu --2 years

Project history

  Product Domain:Health Care
     Team Size:3
       Duration:Nov 2015 to till Date
Tools:SSIS 2012, Visual Studio 2015, SSRS 2012, Power BI, SSAS
Database:SQL Server 2016
Project Role:Sr. Database Architect
Responsibility:
  1. Planning and estimation
  2. Requirement understanding
  3. Client interaction
  4. Analysis of client’s current database
  5. Writing various types of queries, stored procedures, creating indexes, normalization, Triggers & UDFs, query optimization & performance tuning
  6. Improving the performance of the database.
  7. Created SSIS package for automate their daily activity process.
  8. Created reports using SSRS.
  9. Development – Using SSIS tools convert received data from client (which is in different format like sql, oracle database, flat files, XMLs) into SQL server database format.
  10. Creating interactive reports for analyzing the patient disease.
  11. Creating Cubes, Dimensions, Measures and OLAP. 
  12. Unit testing.
  13. Release activities on Test and Production Server.
  14. Bug fixing
  15. Conducting scrum meetings
Team management  Product Domain:Health Care
     Team Size:3
       Duration:Nov 2015 to till Date
Tools:SSIS 2012, Visual Studio 2015, SSRS 2012, Power BI, SSAS
Database:SQL Server 2016
Project Role:Sr. Database Architect
Responsibility:
  1. Planning and estimation
  2. Requirement understanding
  3. Client interaction
  4. Analysis of client’s current database
  5. Writing various types of queries, stored procedures, creating indexes, normalization, Triggers & UDFs, query optimization & performance tuning
  6. Improving the performance of the database.
  7. Created SSIS package for automate their daily activity process.
  8. Created reports using SSRS.
  9. Development – Using SSIS tools convert received data from client (which is in different format like sql, oracle database, flat files, XMLs) into SQL server database format.
  10. Creating interactive reports for analyzing the patient disease.
  11. Creating Cubes, Dimensions, Measures and OLAP. 
  12. Unit testing.
  13. Release activities on Test and Production Server.
  14. Bug fixing
  15. Conducting scrum meetings
Team management

Local Availability

Only available in these countries: India

Other

Hi,

I am Amit Sharma, having 13 years of experience, I am BI Architect. Having expertise on SQL SERVER, POWER BI, SSRS ,SSIS,SSAS,MY SQL , TABLEAU, MICROSTRETEGY.
I am Microsoft certified Power BI expert.

I am attaching my profile with this.
for further conversation you can reach out to me on ,
sharmajiamit1680@gmail.com or +91-738-789-0336 or https://www.linkedin.com/in/amit-g-sharma-37474259/.

Thanks and Regards
Amit G. Sharma
Profileimage by amit sharma MSBI CONSULTANT (SSIS SSRSSSAS)POWER BI TABELEU SQL SERVER from pune MSBI CONSULTANT (SSIS SSRSSSAS)POWER BI TABELEU SQL SERVER
Register