Anil Acharya

ABOUT ME

10 years of experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.
• Extensive experience in Fortification in SQL Server.
• Experience in BI Development and Deployment of SSIS packages from various data sources and targets.
• Designing and Deployment of Reports for the End-User requests using SSRS.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler.
• Experience in solving Real Time issues with Index, Query Tuning, Error and Event Handling.
• Expertise in SQL Server Storage Structures and Security Architecture for databases.
• Experienced in programming tasks-Stored Procedures, Cursors using SQL Server 2012/2014 with T-SQL.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Extensive experience in Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations.
• Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.
• Involved in migration of SSIS Packages 2012 SP1 CU5 and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in generating reports using SQL Server Reporting Services.
• Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections.
• Expertise in Data Modelling for Moderate to Large Data Systems.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions and Distributed Transactions.

SKILLS