Nagababu

PROFESSIONAL SUMMARY

· Microsoft certified IT Professional with around 12+ years of experience in Analysis, Architecture, Design, Development, Administration, Testing, and user training of software applications using MS SQL Server and MSBI in web-based Intranet, Desktop, and client/server applications.

· Experience working with Microsoft cloud’s bigdata ADL (Azure Data Lake) and ADS (Azure Data Storage) and ADF (Azure Data Factory).

· Experience working with latest Microsoft Azure Synapse notebooks and Synapse pipelines.

· Expertise in SQL Server Installation, Configuration, Administration, Development and Migration.

· Extensive experience in developing Stored procedures, Functions, Triggers and Views using T-SQL.

· Experience creating Power BI dashboards in Power BI Service, creating visualizations and reports in Power BI Desktop, creating personal Gateways, Content Packs, Publishing and Scheduling.

· Expertise in writing complex SSAS DAX functions to create computed columns/tables in Power BI.

· Experience in providing security to the power BI reports using Role based and Row based security.

· Experience working with Microsoft business intelligence tools SSIS and SSRS.

· Strong experience in developing, debugging, and deploying SSIS packages and SSRS reports.

· Well versed with SSRS components Report Manager, Report Designer and Report Builder.

· Have experience in developing and designing various SSRS reports Linked, Ad-hoc, Parameterized, snapshot, Drillthrough, Drilldown and Subreports. 

· Experience in Data Extraction, Transformations and Loading data (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP).

· Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.

· Experience in Performance Tuning of SSIS packages by using Row Transformations, Block 

and Unblock Transformations.

· Experience working with Star and Snowflake schema SSAS models and creating dimensions, facts, cubes and measures.

· Experience working with Power Pivot to create reports for the end users and for data validation.

· Expertise on developing Spark SQL scripts and Python scripts to work with the data in ADLS cloud.

· Expertise in creating SQL Jobs, Alerts, SQL Mail Agent, and scheduling SSIS Packages.

· Hands on experience with tools Microsoft Visio, TFS, Jira, TortoiseHG, Service Now and Octopus.

· Experienced in various operations Export/Import, Attach/Detach, scripting out the database objects, table restorations, and index reorganize/rebuild etc. 

· Experienced in installing and maintaining Active/Active and Active/Passive SQL Server clusters.

· Experienced in high availability features log shipping, replication, mirroring and Always ON.

· Experienced in configuring different replications – Transactional, Snapshot and Merge.

· Experienced in working with SSMS, BIDS, SSDT, scheduling jobs with SQL Server Agent.

· Proficient in optimization and performance tuning using SQL Profiler and Execution plans. 

· Experience in installing service packs and hot fixes on SQL Server releases.

· Experienced in creating, managing, and migrating securities (Logins, Roles, and Users). 

· Experienced in administrative tasks like Backup/Restore, migration of databases.

· Experience in monitoring and troubleshooting MS SQL server.

· Experienced in creating Linked servers for distributed queries and transactions.

· Experience working with USQL (Unified SQL), a new Microsoft programming language to deal with bigdata that resides in Microsoft cloud Azure.

· Experience in migrating SQL Server databases from one version to another version.

· Have good experience in creating data models in Sybase Power Designer.