Skills
ssis --11 years
ssrs --11 years
ssas --11 years
power bi --4 years
sql server --11 years
tableu --2 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:
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:
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:
- Planning and estimation
- Requirement understanding
- Client interaction
- Analysis of client’s current database
- Writing various types of queries, stored procedures, creating indexes, normalization, Triggers & UDFs, query optimization & performance tuning
- Improving the performance of the database.
- Created SSIS package for automate their daily activity process.
- Created reports using SSRS.
- 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.
- Creating interactive reports for analyzing the patient disease.
- Creating Cubes, Dimensions, Measures and OLAP.
- Unit testing.
- Release activities on Test and Production Server.
- Bug fixing
- Conducting scrum meetings
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:
- Planning and estimation
- Requirement understanding
- Client interaction
- Analysis of client’s current database
- Writing various types of queries, stored procedures, creating indexes, normalization, Triggers & UDFs, query optimization & performance tuning
- Improving the performance of the database.
- Created SSIS package for automate their daily activity process.
- Created reports using SSRS.
- 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.
- Creating interactive reports for analyzing the patient disease.
- Creating Cubes, Dimensions, Measures and OLAP.
- Unit testing.
- Release activities on Test and Production Server.
- Bug fixing
- Conducting scrum meetings
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
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