Badges
75 Points
9 Years
User Activity
Over 6 years ago
Answered a question: BI Tool Replacements, What Do You Recommend?
I have been working with Microsoft BI solutions for last 10 years so I will propose to move to Microsoft Stack in ETL and Warehousing and Power BI/Tableau for reports
- Database
- SQL Server Azure - I will prefer Cloud version because of its scalability and in future, if…
Over 6 years ago
Answered a question: BI Tool Replacements, What Do You Recommend?
I have been working with Microsoft BI solutions for last 10 years so I will propose to move to Microsoft Stack in ETL and Warehousing and Power BI/Tableau for reports
- Database
- SQL Server Azure - I will prefer Cloud version because of its scalabilty and in future if…
Over 7 years ago
Contributed a review of Microsoft Power BI: The interactive reports, DirectQuery and integration with the other Microsoft services are valuable features.
Projects
Over 7 years ago
Extraction of historical eMAR (Electronic Medication Administration Records)Requirement of this project was to create an automated process for the Extraction of PDF reports from Meditech HIS. We Designed/Developed a VBScript based on the DLL of Meditech HIS, the script was responsible for navigating through different menus and ultimately downloading…
Reviews
Over 7 years ago
Microsoft Power BI
Answers
About me
• Develop variety of Dashboards in Power BI & Tableau.
• Successfully implemented Row Level Security in Power BI Embedded.
• Experience in Informatica Power Center for developing ETL processes for large-scale data warehouses
• Experience in Database Development in SQL Server,MySQL and ORACLE.
• Experience in SQL Server Integration Services (SSIS) and Data Transformation Services (DTS) for Data migration/Integrationprojects.
• Experience in performance tuning and designing database tables and stored procedures in SQL Server 2000/2005/2008.
• Experience Backup/Restore of Servers, Exchange & Databases using BACKUP EXEC, Veeam & EMC Networker.
• Strong business analysis skills including in In-depth knowledge of Software Development Life Cycle, having thorough understanding of various phases like requirements, analysis/design and development.
• Microsoft Certified IT Professional in Database Development SQL Server 2008.
• Migration of database/data/objects from MySQL to SQL Server.
• Development of reports using SSRS, Excel, Jet Reports, Power Pivot, Tableau, Power BI
• Developed SSAS Cubes of Dynamics NAV
• - Item Cost Breakdown
• - Purchase Cost Breakdown
• - Purchase Invoice
• - Purchase Order
• - Inventory History
• - Sales Invoice
• - Sales Order
• - Warehouse Posted Shipments
• - General Ledger
Please keep in touch for opportunity or required help in SQL Server / Business Intelligence / Data Migration.