Sanjay Vishnu Khot
Technology Lead at Creative Information Technology India- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Renny Sreekumar
I had the pleasure working with Sanjay for three years at Provident Financial Group, collaborating on several BI projects. I was particularly impressed by Sanjay's ability to develop solutions in Azure and PowerBI on tight deadlines. Sanjay will be an asset to any team.
Martin Gibbon
I managed Sanjay for a couple of years at Provident. Sanjay is always quick to learn, but will go the extra mile to really understand a product or area of the business and what they're trying to achieve., so much so, he would lead on technical calls with the customer. Sanjay has excellent MS BI Stack skills and produced complex SSRS reports and also Power BI reports. We also worked together on the Azure projects in which he has active taken up training in his own time. It was a pleasure to work with Sanjay.
Renny Sreekumar
I had the pleasure working with Sanjay for three years at Provident Financial Group, collaborating on several BI projects. I was particularly impressed by Sanjay's ability to develop solutions in Azure and PowerBI on tight deadlines. Sanjay will be an asset to any team.
Martin Gibbon
I managed Sanjay for a couple of years at Provident. Sanjay is always quick to learn, but will go the extra mile to really understand a product or area of the business and what they're trying to achieve., so much so, he would lead on technical calls with the customer. Sanjay has excellent MS BI Stack skills and produced complex SSRS reports and also Power BI reports. We also worked together on the Azure projects in which he has active taken up training in his own time. It was a pleasure to work with Sanjay.
Renny Sreekumar
I had the pleasure working with Sanjay for three years at Provident Financial Group, collaborating on several BI projects. I was particularly impressed by Sanjay's ability to develop solutions in Azure and PowerBI on tight deadlines. Sanjay will be an asset to any team.
Martin Gibbon
I managed Sanjay for a couple of years at Provident. Sanjay is always quick to learn, but will go the extra mile to really understand a product or area of the business and what they're trying to achieve., so much so, he would lead on technical calls with the customer. Sanjay has excellent MS BI Stack skills and produced complex SSRS reports and also Power BI reports. We also worked together on the Azure projects in which he has active taken up training in his own time. It was a pleasure to work with Sanjay.
Renny Sreekumar
I had the pleasure working with Sanjay for three years at Provident Financial Group, collaborating on several BI projects. I was particularly impressed by Sanjay's ability to develop solutions in Azure and PowerBI on tight deadlines. Sanjay will be an asset to any team.
Martin Gibbon
I managed Sanjay for a couple of years at Provident. Sanjay is always quick to learn, but will go the extra mile to really understand a product or area of the business and what they're trying to achieve., so much so, he would lead on technical calls with the customer. Sanjay has excellent MS BI Stack skills and produced complex SSRS reports and also Power BI reports. We also worked together on the Azure projects in which he has active taken up training in his own time. It was a pleasure to work with Sanjay.
Credentials
-
Microsoft Certified: Azure Data Fundamentals
MicrosoftJun, 2021- Nov, 2024 -
Microsoft Certified Solutions Associate (MCSA)
MicrosoftMay, 2015- Nov, 2024 -
Microsoft Certified: Data Analyst Associate
MicrosoftJun, 2021- Nov, 2024 -
Microsoft Certified: Azure Data Engineer Associate
MicrosoftJan, 2022- Nov, 2024
Experience
-
Creative Information Technology, Inc.
-
United States
-
IT Services and IT Consulting
-
200 - 300 Employee
-
Technology Lead
-
Mar 2022 - Present
• Lead the reporting team, dealt with business requirements • Creating a data dictionary as per the client requirements and using that designing and building the dimensions and cubes using SSAS with Star schemas for the reports. • Providing information regarding Power BI licensing and system configuration for the project deployment. • Creating Ad-hoc Power BI reports and implement it in client’s custom web application. • Developing Power BI models, creating Measures and calculating columns using complex DAX expressions, Power Queries and using different types of transformations that are available in Power Bi query editor for financial reporting using multiple data sources like SQL server, Azure, Excel, and many more • Migrated On-premises SSAS to Azure Analysis Services. • Created new database objects like Tables, views, Indexes, stored procedures, user defined functions and triggers on user databases. • Experience with Azure DevOps related to project management. • Code reviewing of the tasks completed by developers. • Attending backlog grooming meetings, Sprint planning meetings and daily Scrum calls and providing Azure BI and Analytics Solution to the business requirements Show less
-
-
-
Provident Financial Group (PFG)
-
United Kingdom
-
Financial Services
-
500 - 600 Employee
-
Business Intelligence Developer
-
Jun 2018 - Dec 2021
• Provided Azure BI and Analytics Solution to the business requirements. • Developed Azure Data Factory V2 Pipeline to ingest data from Source RDBMS to Azure Data Lake. • Troubleshooting errors and issues in the ADF Pipelines and provide solutions and guidance in resolving them. • Had a training from Microsoft on Implementing an Azure Data Solution and Designing an Azure Data Solution. • Created Workspace and content packs for business users to view the developed reports. • Developed multiple dashboards, analytical reports, KPIs and interactive reports bases on business requirements using SSRS and Power BI. • Expertise in developing Power BI models, creating Measures and calculated columns using complex DAX expressions, Power Queries and using different types of transformations that are available in Power Bi query editor for financial reporting using multiple data sources like SQL server, Azure, Excel, etc. • Scheduled automatic refresh of datasets in Power BI service. • Deployed RLS (Row-Level Security) at database and Power BI end also provided report level access and did workspace management. • Involved in designing, developing and deploying reports in MS SQL Server environment using SSIS in Business Intelligence Development Studio (BIDS). • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse. • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. • Creating Complex Stored Procedures, Fact and Dimension tables, User Defined Functions (UDFs) and Views using T-SQL evaluate result for the reports. • Coordinate with offshore teams and communicate requirements to the offshore team. • Review of deliverables from the offshore team. • Interacting with Business Analysts taking clarifications regarding requirements. • Analyzing the requirements and discussed with managers and leads on the functionality. Show less
-
-
-
Mastek
-
United Kingdom
-
IT Services and IT Consulting
-
700 & Above Employee
-
Software Specialist
-
Aug 2017 - Apr 2018
• Created SSIS Reusable Packages to Performs database backups, Check Database Integrity, Rebuild Index, Reorganize Index, Shrink Database and Update Statistics. • End-to-end solution delivery from requirement gathering, Etraction Transformation and Loading (ETL), data visualization and reporting. • Created SQL Jobs to schedule SSIS Packages. • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases. • Creating Complex Stored Procedures, tables, views, indexes, User Defined Functions (UDFs) and Views using T-SQL evaluate result for the reports. • Interacting with Onsite people, taking clarifications regarding applications. • Analyzing the requirements and discussed with managers and leads on the functionality. • Worked on DBCC commands and Dynamic Management Objects. • Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles. Show less
-
-
-
Ticker
-
India
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Software Engineer
-
Nov 2014 - Jul 2017
• Migrated database from SQL server 2005 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition. • Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task. • Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. • Backup and restore by using SQL Server 2005 tools. • Rebuilding / monitoring the indexes at regular intervals for better performance. • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. • Troubleshooting and fine-tuning of databases for its performance and concurrency. • Using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). • Worked on DBCC commands and Dynamic Management Objects. • Set up SQL Server configuration settings for better server management. • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies. • Monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. • Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression. Show less
-
-
-
Empronc Solutions
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Sr. Software Developer
-
Jul 2011 - Oct 2014
• Business and technical analysis, systems design, application software programming. • Restructuring the stored procedure, designing, coding and developing the same using the TSQL. • Worked on Dynamic Management Views in SQL Server 2005/2008 R2. • Monitoring SQL server performance using SQL Profiler to find performance and dead locks. • Solving defects raised by Testing team. • Monitored and modified Performance using execution plans and Index tuning. • To analyze long running slow queries and tune it to optimize application and system performance. • Automated messaging services on server failures, for task completion and success. Show less
-
-
Education
-
2006 - 2008
Mumbai University
B.Sc, Physics -
2009 - 2012
NIIT UNIVERSITY
GNIIT, Information Technology
Community
