Anil B. Email & Phone Number

Over 8 years of IT experience in various sectors, including Healthcare, Banking, Financial and Retail as aSQL Serve BI Developer that includes Database Design and Development of MS SQL Server2014/2012/2008/2005/2000. Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agilemethodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problemmanagement and escalation procedures Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation ofClient-Server & Business Intelligence (SSIS, SSAS, SSRS) applications. Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and PowerBI SDLC from prototyping to deployment. Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF),Database triggers. Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous andHeterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, and XML). Upgrade DTS packages to SQL Server Integration Services (SSIS). Expertise in Data Transformation Services (DTS) in SQL Server 2000. Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects betweeninstances of SQL Server. Expertise in Power BI Desktop, Power BI Pro, Power BI Mobile. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and UnblockTransformations. Experienced in managing and automating Control flow, Data flow, Events and Logging programmaticallyusing Microsoft .NET framework for SSIS packages. Experience in providing Logging, Error handling by using Event Handler & Custom Logging for SSISPackages. Experienced with deployments, Maintenance and troubleshooting applications on Microsoft CloudInfrastructure Azure. Experienced in SQL Server Analysis Services OLAP Cubes and Data Mining.

• 

  Jawaharlal Nehru Technological University

  Information Technology