Tools & Technology hands on
• Platform : Windows server and Linux, Azure.
• RDBMS : SQL Server 2005/2008/2012/2014/2016,TSQL.
• Open source DB : MySQL & Postgres.
• NoSQL Database : MongoDB, Robomongo.
• Business Intelligence : MSBI, LogiXML, PowerBI, MDX.
• Programming Language : Asp, VB, JavaScript, Python.
• Business Tools : MS Excel, Visio, Powerpoint,
• 3rd Party Tools : SSMS, Perfmon, Profiler, Toad, SQL Check, Query-Tress
Professional Profile
- 8 years of experience in data profession as Database Developer, DBA and Data Analyst on Development, Staging & Production Environments.
- Working with SDLC & AGILE process methodology with supporting of Data-Flow, Process Models, E-R Diagrams.
- Serving & Supporting to Developer for Database Objects like T-SQL, Stored Procedures, Views, User Defined Functions, Triggers & Cursor.
- Involving in Environment-Setup & Issue resolution of SQL Server Installation, Configuration and Updates of SQL Server.
- Experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
- Involving in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler & PerfMon.
- Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
- Experience in Automation Jobs Configuration and Monitoring and troubleshooting.
- Involved various data migrations, transfers activities using various utilities.
- Worked as BI Development and Deployment using MSBI. Designing & Deploying ETL Package for Data Collection and Distribution.
- Designing and Deployment of Reports, Matrix, Charts for the End-User requests using Web Interface & SSRS.
- Deale with OLAP Environment setup; Designing of Dimension, Facts and deployment of CUBEs.
- Experienced in Power-BI, Pivot Reports , What-If Analysis using Excel, Drill Through Dashboards using OLAP and OLTP Connections. Experienced in finding Gaps by Analyzing of Data and Business Flow.
- Strong Communication & Management skills with Excellent Role playing capabilities.