Having overall 9+ years of experience in designing and implementing solutions for various clients
Excellent analytical, logical and programming skills
Expertise in ERP Implementation Process on Ramco ERP for multiple module like- Purchase/Sales/Finance/HR etc. for multiple clients, Having good knowledge as functional and technical.
Experience in Database Developer in SQL Server 2008/2012/2014 - Database Designing, T-SQL,Tables,Procedures,Triggers,Joins,Complex Queries, Debug in profiler etc.
Currently working as BI Consultant and Development on MSBI(SSIS/SSAS/SSRS) and Power BI (Data Visualization) with multiple data source like Salesforce/Sharepoint List/Excel/SQL/SQL Azure/Web etc.worked on VB6 and Macros (VBA) in excel
SSRS (SQL SERVER 2005/2008/2012 Reporting Services): - Matrix report, Drill Through, Drill down,linked reports, History reports, snapshots subscriptions, Reporting server manager, Creating folder/uploading reports/Managing user access/Auto mailing reports etc.
SSIS (SQL SERVER 2005/2008/2012 Integration Services ETL Tool) :- Using some integration like send mail task , Execute sql task ,execute package task , Datafolw Task with different type of transformations , containers, loops, transactions, checkpoint, deployments etc.
SSAS (SQL SERVER 2005/2008/2012 Analysis Services): I have Worked on OLAP/OLTP Database, Data warehouse and Multi dimensional and tabular data model in SSAS.
Power BI (Data Visualization) : Working on different kinds of charts and publish them on share point hosted web, used multiple data sources using DAX query and Functions.
SQL Server Developer - T-SQL/Tables/Procedures/Index/Triggers/Joins/Locks/Debug/Complex Queries etc
SQL Server Administrator - I have worked as a DBA on Backup/Restores/User Creation/User Rights/Performance issues/Installation/Migration/partition/Indexing/DBCC commands etc.
SQL Azure (Cloud Database) : Configuration, Creating server/Database/Tables/Users/Active Directory/Virtual machine etc.