Over Five years of IT Industry experience as a SQL/MSBI Developer and Analyst. * Worked on Azure infrastructure setup and used Azure develop analytical solutions * Experience in design, development, implementation and administration of database systems using SQL Server 2005/2008r2/2012/2016/2017 Azure Sql Db for both OLTP & Data Warehousing Systems applications. * Azure Sql datwarehouse creating tables and loading data * Created SQl server Managed Instance on cloud and deployed SSIS packages * Very good knowledge and real time working experience in: * Logical & Physical Data modelling (Relational) * Strong hold in Database and Data warehousing concepts, Multidimensional Analysis. * Expert in Physical database design techniques like Normalization and De-Normalization. * Used different kinds of database Constraints (Primary Keys, Foreign Keys, Defaults, Check, and Unique). * Highly proficient in T-SQL for developing complex stored procedures, triggers, tables, views, user defined function, SQL Joins, Relational Database models and Data Integrity. * Extensive experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Reporting Services (SSRS). Power BI and, Analysis Services (SSAS) (Multidimensional Tabular). * Created dashboards using PowerBI desktop * Created Gateways between on premise and cloud . * Created live reports using multiple data sources * Created cortana integration using office 365 * Used DAX query and created measure as needed * Experienced in creating complex SSIS packages, using various transformation package parameters and variables. Import export wizard and bulk insert. * Expert in creating configuration files, error handling, logging, deploying, and execution of SSIS packages in various environments like development, testing and production. * Developed Cubes using different types of storage modes like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP) and Hybrid OLAP (HOLAP). * Experienced in creating reports using SQL Server Reporting Services, sourcing OLAP cubes and data warehouse, data marts, as well as transactional systems. * Strong expertise in Data modelling using ER-Win 9/8, MS-Visio, with good understanding of Relational Database Management System (RDBMS) * Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, Drill through, Charts, and Sub Reports features using Business Intelligence Development Studio (BIDS) and SQL Server Data Tools. * Knowledge in working with all Collections in reports like Fields, User, Parameters, Variables and Report Items. Azure Infrastructure set up * Design and Implement Database Schema, import data and build stored procedures on SQL Azure. * Conversant with all phases of Software Development Life Cycle (SDLC) especially agile, scrum, involving business process analysis, requirement gathering and analysis, detailed design, development testing, and post implementation support. * Organized professional with excellent oral and written communication skills, excellent presentation, interpersonal skills, problem solving skills, ability to work in a fast-paced environment, fast learner with ability to take new roles in minimum time and little training. * Creating and Managing Virtual Machines in Windows Azure and setting up communication with the help of Endpoints and also VM. Possesses strong ability to fully design, configure, and troubleshoot multi-layer networks in various environments. * Worked on Cloud Administration tasks such as creating Affinity Group, Storage Accounts, Cloud Services, VPN, DNS server and VPN connectivity. * Extensive knowledge of cloud networking topologies and diagnostics. * Experience with load balancing, high availability, disaster recovery, and storage architecture. * Extended working knowledge in cloud service, IaaS, worker role, queue, and azure blob * and table storages. Configured NSGs for two tier and three tier applications. * Experience in integrating on premises servers to Azure. * Configured Vnets and subnets as per the project requirement. Configure Azure blob storage and Azure file servers. Configured private and public facing Azure load balancers etc. * Extensive experience implementing software throughout the SDLC process, deep hands-on experience of networking, migration and implementation in Azure. Analytics using Azure * Extensive experience implementing software throughout the SDLC process, deep hands-on experience of networking, migration and implementation in Azure. * Created Azure Datawareshouse * Loaded data using Datafactories from storage and on premise using integration runtime and Selfhosted integration runtime * The SSIS packages are moved to Azure IR (integration runtime) deployed on Azure Managed Instance FUNCTIONAL AREAS Retail, Investment Banking Health Insurance/Pharmacy and IT Consulting. ROLES AND RESPONSIBILITIES T-SQL, SQL/BI (SSIS/SSAS/SSRS/PowerBI /Tsql) Developer, Azure Admin, Azure Dataplatform PLATFORMS Windows NT/2002/2007/2012, LINUX, UNIX

Highlights:

• Microsoft Windows
• Servers
• Stored Procedures
• Structured Query Language
• Database
• Microsoft Excel
• Microsoft SQL Server
• Microsoft Windows XP
• OLAP
• Oltp (Online Transaction)