$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Krishna Mudragada
,
, United Kingdom
Experience
Other titles
Skills
I'm offering
Markets
United Kingdom
Language
English
Fluently
My experience
2020 - ?
freelance
Azure Lead Consultant
Microsoft.
Projects:
Migration of On-Premise data/code/reports to Azure Cloud infrastructure. Support the team with the Azure technologies and advanced PowerBI Dashboards using PowerBI apis. Ensure high customer satisfaction by solving technically challenging problems efficiently. Working for Microsoft for the implementation of Azure/Chatbot solutions through iSmartBot agency.
Details/Responsibilities:
• Migrate local GIT repository to Azure Repos and automating the entire development cycle using Azure DevOps CI/CD pipelines.
• Architect company data/cloud solutions by mapping customer/business problems to end-to-end technology solutions.
• Designing and implementing the migration process to the new Azure toolset - Azure DevOps, Azure Data Factory v2, Azure SQL DB, etc.
• Develop and maintain SSIS ETL packages to move data from sources systems to central data warehouse.
• Data migration to Azure SQL DB using Azure data factory v2 pipelines.
• Developed the powerful PowerBI dashboards for the business with backend Azure SQL Server DB. Engage in discussions with senior level technology managers/decision makers related to business transformations/value, and information technology solutions.
• Lead/Design/implement core Chabot framework code for this product using Azure Bot Service, Microsoft Cognitive service APIs and make the product readily available. Responsible for designing and implementing new features for the core Chabot solution to increase the product capabilities and also as per new customer's requirements - integrating Chabot with the dynamics CRM knowledge base articles, integrating with the SharePoint lists, speech/vision APIs.
Migration of On-Premise data/code/reports to Azure Cloud infrastructure. Support the team with the Azure technologies and advanced PowerBI Dashboards using PowerBI apis. Ensure high customer satisfaction by solving technically challenging problems efficiently. Working for Microsoft for the implementation of Azure/Chatbot solutions through iSmartBot agency.
Details/Responsibilities:
• Migrate local GIT repository to Azure Repos and automating the entire development cycle using Azure DevOps CI/CD pipelines.
• Architect company data/cloud solutions by mapping customer/business problems to end-to-end technology solutions.
• Designing and implementing the migration process to the new Azure toolset - Azure DevOps, Azure Data Factory v2, Azure SQL DB, etc.
• Develop and maintain SSIS ETL packages to move data from sources systems to central data warehouse.
• Data migration to Azure SQL DB using Azure data factory v2 pipelines.
• Developed the powerful PowerBI dashboards for the business with backend Azure SQL Server DB. Engage in discussions with senior level technology managers/decision makers related to business transformations/value, and information technology solutions.
• Lead/Design/implement core Chabot framework code for this product using Azure Bot Service, Microsoft Cognitive service APIs and make the product readily available. Responsible for designing and implementing new features for the core Chabot solution to increase the product capabilities and also as per new customer's requirements - integrating Chabot with the dynamics CRM knowledge base articles, integrating with the SharePoint lists, speech/vision APIs.
Service, CI / CD, Backend, Framework, Dynamics CRM, Server, Chatbot, Development, Infrastructure, Support, Implementation, Azure SQL, Ssis, Design, Technology, Cloud, Data Warehouse, ETL, SharePoint, DevOps, Azure, SQL Server, CRM, Backend, Git, Sql
2018 - 2019
freelance
Senior Data Consultant
WorldPay.
Projects:
Lead / Build a single view of customer contacts for WorldPay customers, Integration project with WorldPay collections data, Card Payments transactional behavior project and Chat Bot.
Details/Responsibilities:
● Lead a project to design, implement and build a single view of customer contacts SQL Server data warehouse for WorldPay customers.
● Architect solutions by mapping customer/business problems to end-to-end technology solutions.
● Worked in the financial module - third party application where I have designed/built an integration bridge between WorldPay systems and third party systems. Designed and developed number of SSIS packages to integrate the systems.
● Worked on customer payment card transactions behavioral projects using Azure Stream Analytics and Machine Learning based Anomaly Detections.
● Implemented an Azure Chabot for the team.
● Migration of the data from the source systems to the Azure Data Lake Store/Azure SQL DB using Azure Data Factory v2 pipelines.
● Built the PowerBI dashboards for customer payment transactions to analyze the customer behavior by age, location and other important parameters as per business manager's requirements.
● Build, test and deploy codebase using Azure DevOps automated pipelines for CI/CD.
Lead / Build a single view of customer contacts for WorldPay customers, Integration project with WorldPay collections data, Card Payments transactional behavior project and Chat Bot.
Details/Responsibilities:
● Lead a project to design, implement and build a single view of customer contacts SQL Server data warehouse for WorldPay customers.
● Architect solutions by mapping customer/business problems to end-to-end technology solutions.
● Worked in the financial module - third party application where I have designed/built an integration bridge between WorldPay systems and third party systems. Designed and developed number of SSIS packages to integrate the systems.
● Worked on customer payment card transactions behavioral projects using Azure Stream Analytics and Machine Learning based Anomaly Detections.
● Implemented an Azure Chabot for the team.
● Migration of the data from the source systems to the Azure Data Lake Store/Azure SQL DB using Azure Data Factory v2 pipelines.
● Built the PowerBI dashboards for customer payment transactions to analyze the customer behavior by age, location and other important parameters as per business manager's requirements.
● Build, test and deploy codebase using Azure DevOps automated pipelines for CI/CD.
Design, Sql, Machine learning, SQL Server, Azure, DevOps, Data Warehouse, Integration, Analytics, Test, Technology, Ssis, Azure SQL, Server, Manager, CI / CD
2017 - 2019
freelance
Senior Azure Data Consultant
Azure Data Lake Store.
Azure Stream Analytics (Event Hub), Machine Learning based Anomaly Detection, U-SQL, Azure Data Factory, Power BI, DAX, SSIS Integration Services, T-SQL, XMLs, VB.NET/C#, MS Visio
Capita, Cippenham, UK Senior Azure Data Consultant
Jun 2019 - Dec 2019
Projects:
Build an Artificial Intelligence Chabot for Workspace agility team and build dashboards for Chatbot analysis and Device provisioning team, Design and implement the entire application lifecycle - build, test and deploy using Azure DevOps automated pipelines for CI/CD, Maintain devices data central data warehouse. Provide Azure Cloud technical support to Workspace agility customers in Capita.
Details/Responsibilities:
● Design and implement advanced artificial intelligence Chabot for Dynamics 365 portal for workspace agility team using Azure Bot Service and Cognitive Services APIs.
● Develop code to integrate Chabot with the Dynamics CRM knowledge articles, Office 365 appointment booking system, LUIS APIs, SharePoint Lists. Deploy this solution for a number of internal clients.
● Storing all the Chabot conversations data into the Azure Data Lake/Cosmos DB.
● Designed and developed SSIS ETL packages to maintain workspace agility devices central data warehouse for reporting.
● Built a number of PowerBI dashboards/reports as per the business requirements to analyze Devices/Applications provisioning by the customer.
● Build Dashboards/PowerBI reports to analyze the customer's behavior with the Chabot.
● Azure DevOps to automate the development cycle - built the automated pipelines for CI/CD.
● Design and develop Microsoft flows to trigger dataset refresh for SharePoint Lists and generate dynamic real time PowerBI reports/dashboards.
● Azure technical support to the workspace agility customers.
● Engage in discussions with senior level technology managers/decision makers related to business transformations/value, and information technology solutions.
Technologies/Tools used: SQL Server 2016, Visual Studio 2017, Azure DevOps, MS Dynamics 365, SharePoint, Azure SQL DB, Azure Data Lake Store, Azure Stream Analytics (Event Hub), Machine Learning based Anomaly Detection, U-SQL, Azure Data Factory, SharePoint, Power BI, DAX, SSIS Integration Services, T-SQL, XMLs, VB.NET/C#, MS Visio
Capita, Cippenham, UK Senior Azure Data Consultant
Jun 2019 - Dec 2019
Projects:
Build an Artificial Intelligence Chabot for Workspace agility team and build dashboards for Chatbot analysis and Device provisioning team, Design and implement the entire application lifecycle - build, test and deploy using Azure DevOps automated pipelines for CI/CD, Maintain devices data central data warehouse. Provide Azure Cloud technical support to Workspace agility customers in Capita.
Details/Responsibilities:
● Design and implement advanced artificial intelligence Chabot for Dynamics 365 portal for workspace agility team using Azure Bot Service and Cognitive Services APIs.
● Develop code to integrate Chabot with the Dynamics CRM knowledge articles, Office 365 appointment booking system, LUIS APIs, SharePoint Lists. Deploy this solution for a number of internal clients.
● Storing all the Chabot conversations data into the Azure Data Lake/Cosmos DB.
● Designed and developed SSIS ETL packages to maintain workspace agility devices central data warehouse for reporting.
● Built a number of PowerBI dashboards/reports as per the business requirements to analyze Devices/Applications provisioning by the customer.
● Build Dashboards/PowerBI reports to analyze the customer's behavior with the Chabot.
● Azure DevOps to automate the development cycle - built the automated pipelines for CI/CD.
● Design and develop Microsoft flows to trigger dataset refresh for SharePoint Lists and generate dynamic real time PowerBI reports/dashboards.
● Azure technical support to the workspace agility customers.
● Engage in discussions with senior level technology managers/decision makers related to business transformations/value, and information technology solutions.
Technologies/Tools used: SQL Server 2016, Visual Studio 2017, Azure DevOps, MS Dynamics 365, SharePoint, Azure SQL DB, Azure Data Lake Store, Azure Stream Analytics (Event Hub), Machine Learning based Anomaly Detection, U-SQL, Azure Data Factory, SharePoint, Power BI, DAX, SSIS Integration Services, T-SQL, XMLs, VB.NET/C#, MS Visio
Office, Analytics, Dynamics 365, Test, Technology, Service, Ssis, Net, Azure SQL, Support, Development, T-SQL, Chatbot, BEE, Server, Power, Dynamics CRM, Booking, Vb, Sql server 2016, Portal, CI / CD, SharePoint, Sql, .Net, Machine learning, CRM, SQL Server, Office 365, Azure, Power BI, DevOps, Artificial Intelligence, Design, ETL, Data Warehouse, C, Cloud, Vb.net, Event, Visio, Visual Studio, Integration
2013 - 2018
job
Azure Data Specialist / Lead
Azure Service Bus, Azure Data Lake Store, Azure Stream Analytics.
Technologies/Tools used: SQL Server 2016, Visual Studio 2017, Azure DevOps, Azure SQL DB, Azure Service Bus, Azure Data Lake Store, Azure Stream Analytics (Event Hub), Machine Learning based Anomaly Detection, U-SQL, Azure Data Factory v2, SharePoint, Power BI, DAX, SSIS Integration Services, T-SQL, XMLs, VB.NET/C#, MS Visio, Aqua Studio, GitHub, JIRA
Microsoft, Reading, UK Azure Data Specialist / Lead
Aug' 2013 - Sept' 2018
Projects:
Marketing Automation, Single View of Customer, Analysis of Large Digital Web Data Sets, Social Data Analysis, Reporting Strategy, Targeted Digital Marketing solution, Content Management System for email campaigns, Data Mining and Statistical Machine Learning solutions for Customer Behavior / Segmentation, Lead Scoring, Planning and Forecasting.
Details: The CRMG (Customer Relationship Management Group) in Microsoft,UKisina unique position, having responsibility to look over the consumer, commercial and parts of Microsoft's UK advertising business across all Business Groups and products. This provides not only a wealth of data but a unique opportunity to drive insights into Microsoft business that enable more customer centric behaviors which in turn will simplify and amplify Microsoft's brands.
Technologies/Tools used: SQL Server 2016, Visual Studio 2017, Azure Data Lake Store and Analytics, U-SQL, Azure Data Factory, Machine Learning, Graph Databases, R, Data Mining, SSAS Multidimensional Models/CUBES, Tabular Models, SharePoint, Power BI, Power View 2013, DAX, PowerPivot, PowerMap, SSIS Integration Services, SSRS Reporting Services, T-SQL, VB.NET/C#, MS Visio, VSTS, Team Foundation Server (TFS), SQL Compare
Responsibilities:
● Implemented Data and BI Strategy for Microsoft UK CRM Marketing group.
● Architect solutions by mapping customer/business problems to end-to-end technology solutions.
● Engage in discussions with senior level technology managers/decision makers related to business transformations/value, and information technology solutions.
● Data Specialist/Lead to plan, design, develop and maintain UK CMO Marketing data platform.
● Point of contact for any data related and analytics related work items/issues for our team of 65.
● Liaise with the businesses and various teams and develop an in-depth understanding of their reporting requirements and business KPIs.
● Data analysis of the Microsoft Events/Campaign data. Applying business intelligence to the data and thereby producing valuable MI reports for the business to measure the success of the campaign.
● Developed more than 100 complicated SSIS ETL packages to load data from wide variety of Microsoft internal and external source systems (650+ sources) to central data warehouse involving advanced VB/C# code in the SSIS Script components. Sources include Microsoft sales data, customer data, partner's data, events data systems, DnB organizations, Azure, Office 365 and other products consumption data systems, contractibility/privacy systems, digital web data, etc.
● Designed and implemented Azure Data Lake for Microsoft UK CMO group to simplify the processing of our internal big data files (Digital Data feeds, Social feeds, LinkedIn feeds, Azure consumption feeds, Office 365 consumption feeds and a lot of other data feeds linked to our customers/partners).
● Analyzing and merging the above big data feeds with customer/partner profiles, organization profiles and other internal/external data sources using Azure Data Lake Analytics (U-SQL) to develop Single View of Customer and get more insights about our customers/partners thereby growing existing relationships & retaining high valued customers and acquiring new customers.
● Developed Audience Segmentation/Clustering models using Azure Machine Learning algorithms to perform targeted marketing (Email/Phone/Direct Mail campaigns), sales lead scoring and forecasting.
● Design and Document the new architecture and development process to convert Database and data warehouse models into Azure Cloud Platforms.
● Developed number of complicated U-SQL scripts with the power of C# functions to transform/process PetaBytes of data logs (unstructured/structured data files) and extract meaningful and valuable insights.
● Develop a number of machine-learning experiments/solutions for some of our UK CMO business requirements (audience segmentation, sales lead scoring, Propensity models and demand forecasting) in the cloud based Azure Machine Learning (AML) studio.
● Implemented Azure Cosmos DB Gremlin Graph database for the Microsoft UK business managers, their customers and their Microsoft products and services.
● Designed, documented and implemented the entire architecture for Power BI model for our team.
● Migrated ad hoc and self-service reports to PowerBI.
● Developed a number of complex Power BI reports/Dashboards for the different business group heads (Finance/Sales/Marketing) from various data sources - SQL Server, Data Lake Store, Excel, Tabular Models, Cubes, etc.
● Inventory management reporting for Xbox consoles for XBOX teams using PowerBI dashboards.
● Developed calculated columns and measures using DAX in Power BI as per business reporting/dashboard requirements.
● As per business requirements integrated custom visuals in Power BI - Tornado, Bullet Chart, Horizontal bar chart, etc.
● Implemented security model for Power BI - access of reports/dashboards and data for individual users using Roles and Row-Level security.
● Implemented On-Premises Gateway bridges for the secure data transfer between on-premises data and the Power BI. Deployed Power BI reports to embed them in web/third party applications using Power BI Embedded.
● Migration of On-Premise SQL server to Azure Cloud platforms. Loading data from On-Premise SQL databases/flat files to Azure Data Lake store using Azure Data Factory.
● Developed U-SQL constructs for interacting multiple source streams within Azure Data Lake.
● Integration of external platforms with our data warehouse to support Marketing Automation.
● Integrate content management system for email campaigns with the Single View of Customer.
● Implemented RM (Relational Marketing) Programs for DPE (Developer Platform Evangelist), SMB (Small Medium Business) data, Enterprise data using MIS database.
● Performance tuning of SSIS packages to load data efficiently with high speed.
● Designed and implemented CUBES. Developed complex MDX calculations as per the business reports requirements and thereby developed PowerBI reports.
● Design and development of Tabular Models, deploying to SharePoint and building powerful and business critical MI reports/Dashboards using Power View.
● Web Digital data analysis - Extract digital data from the Azure Cosmos DB using U-SQL and perform analysis on customer behavior.
● Architected and Implemented Data Mining and Statistical Machine Learning Solutions to various business problems such as targeted marketing, sales lead scoring, and demand forecasting.
● Source Data profiling for the data analysis, data cleansing, data de-duplication and reconciliation to maintain high data quality in the warehouse.
● Designed and implemented Artificial Intelligence (AI) Chatbot app (24x7 virtual assistant) for the UK CMO team with Azure Chatbot service by adding Natural Language Processing (NLP) using Microsoft Cognitive Services' LUIS (Language Understanding Intelligent Service). This Chabot serves all the Business Group heads, Campaign managers, Event Managers and other audience in the team with the most frequently asked questions about Microsoft UK marketing activities and about campaigns and it is growing with more capabilities.
● Demonstrate our tools to our customers/partners for the awareness of Microsoft Products/Tools. I have done a number of presentations on tools from our Business Intelligence Suite and Cortana Intelligence Suite to our customers/partners.
Microsoft, Reading, UK Azure Data Specialist / Lead
Aug' 2013 - Sept' 2018
Projects:
Marketing Automation, Single View of Customer, Analysis of Large Digital Web Data Sets, Social Data Analysis, Reporting Strategy, Targeted Digital Marketing solution, Content Management System for email campaigns, Data Mining and Statistical Machine Learning solutions for Customer Behavior / Segmentation, Lead Scoring, Planning and Forecasting.
Details: The CRMG (Customer Relationship Management Group) in Microsoft,UKisina unique position, having responsibility to look over the consumer, commercial and parts of Microsoft's UK advertising business across all Business Groups and products. This provides not only a wealth of data but a unique opportunity to drive insights into Microsoft business that enable more customer centric behaviors which in turn will simplify and amplify Microsoft's brands.
Technologies/Tools used: SQL Server 2016, Visual Studio 2017, Azure Data Lake Store and Analytics, U-SQL, Azure Data Factory, Machine Learning, Graph Databases, R, Data Mining, SSAS Multidimensional Models/CUBES, Tabular Models, SharePoint, Power BI, Power View 2013, DAX, PowerPivot, PowerMap, SSIS Integration Services, SSRS Reporting Services, T-SQL, VB.NET/C#, MS Visio, VSTS, Team Foundation Server (TFS), SQL Compare
Responsibilities:
● Implemented Data and BI Strategy for Microsoft UK CRM Marketing group.
● Architect solutions by mapping customer/business problems to end-to-end technology solutions.
● Engage in discussions with senior level technology managers/decision makers related to business transformations/value, and information technology solutions.
● Data Specialist/Lead to plan, design, develop and maintain UK CMO Marketing data platform.
● Point of contact for any data related and analytics related work items/issues for our team of 65.
● Liaise with the businesses and various teams and develop an in-depth understanding of their reporting requirements and business KPIs.
● Data analysis of the Microsoft Events/Campaign data. Applying business intelligence to the data and thereby producing valuable MI reports for the business to measure the success of the campaign.
● Developed more than 100 complicated SSIS ETL packages to load data from wide variety of Microsoft internal and external source systems (650+ sources) to central data warehouse involving advanced VB/C# code in the SSIS Script components. Sources include Microsoft sales data, customer data, partner's data, events data systems, DnB organizations, Azure, Office 365 and other products consumption data systems, contractibility/privacy systems, digital web data, etc.
● Designed and implemented Azure Data Lake for Microsoft UK CMO group to simplify the processing of our internal big data files (Digital Data feeds, Social feeds, LinkedIn feeds, Azure consumption feeds, Office 365 consumption feeds and a lot of other data feeds linked to our customers/partners).
● Analyzing and merging the above big data feeds with customer/partner profiles, organization profiles and other internal/external data sources using Azure Data Lake Analytics (U-SQL) to develop Single View of Customer and get more insights about our customers/partners thereby growing existing relationships & retaining high valued customers and acquiring new customers.
● Developed Audience Segmentation/Clustering models using Azure Machine Learning algorithms to perform targeted marketing (Email/Phone/Direct Mail campaigns), sales lead scoring and forecasting.
● Design and Document the new architecture and development process to convert Database and data warehouse models into Azure Cloud Platforms.
● Developed number of complicated U-SQL scripts with the power of C# functions to transform/process PetaBytes of data logs (unstructured/structured data files) and extract meaningful and valuable insights.
● Develop a number of machine-learning experiments/solutions for some of our UK CMO business requirements (audience segmentation, sales lead scoring, Propensity models and demand forecasting) in the cloud based Azure Machine Learning (AML) studio.
● Implemented Azure Cosmos DB Gremlin Graph database for the Microsoft UK business managers, their customers and their Microsoft products and services.
● Designed, documented and implemented the entire architecture for Power BI model for our team.
● Migrated ad hoc and self-service reports to PowerBI.
● Developed a number of complex Power BI reports/Dashboards for the different business group heads (Finance/Sales/Marketing) from various data sources - SQL Server, Data Lake Store, Excel, Tabular Models, Cubes, etc.
● Inventory management reporting for Xbox consoles for XBOX teams using PowerBI dashboards.
● Developed calculated columns and measures using DAX in Power BI as per business reporting/dashboard requirements.
● As per business requirements integrated custom visuals in Power BI - Tornado, Bullet Chart, Horizontal bar chart, etc.
● Implemented security model for Power BI - access of reports/dashboards and data for individual users using Roles and Row-Level security.
● Implemented On-Premises Gateway bridges for the secure data transfer between on-premises data and the Power BI. Deployed Power BI reports to embed them in web/third party applications using Power BI Embedded.
● Migration of On-Premise SQL server to Azure Cloud platforms. Loading data from On-Premise SQL databases/flat files to Azure Data Lake store using Azure Data Factory.
● Developed U-SQL constructs for interacting multiple source streams within Azure Data Lake.
● Integration of external platforms with our data warehouse to support Marketing Automation.
● Integrate content management system for email campaigns with the Single View of Customer.
● Implemented RM (Relational Marketing) Programs for DPE (Developer Platform Evangelist), SMB (Small Medium Business) data, Enterprise data using MIS database.
● Performance tuning of SSIS packages to load data efficiently with high speed.
● Designed and implemented CUBES. Developed complex MDX calculations as per the business reports requirements and thereby developed PowerBI reports.
● Design and development of Tabular Models, deploying to SharePoint and building powerful and business critical MI reports/Dashboards using Power View.
● Web Digital data analysis - Extract digital data from the Azure Cosmos DB using U-SQL and perform analysis on customer behavior.
● Architected and Implemented Data Mining and Statistical Machine Learning Solutions to various business problems such as targeted marketing, sales lead scoring, and demand forecasting.
● Source Data profiling for the data analysis, data cleansing, data de-duplication and reconciliation to maintain high data quality in the warehouse.
● Designed and implemented Artificial Intelligence (AI) Chatbot app (24x7 virtual assistant) for the UK CMO team with Azure Chatbot service by adding Natural Language Processing (NLP) using Microsoft Cognitive Services' LUIS (Language Understanding Intelligent Service). This Chabot serves all the Business Group heads, Campaign managers, Event Managers and other audience in the team with the most frequently asked questions about Microsoft UK marketing activities and about campaigns and it is growing with more capabilities.
● Demonstrate our tools to our customers/partners for the awareness of Microsoft Products/Tools. I have done a number of presentations on tools from our Business Intelligence Suite and Cortana Intelligence Suite to our customers/partners.
SSRS, Powerpivot, SSAS, Management Reporting, Support, NLP, Developer, TFS, Azure SQL, It, Net, Inventory management, Natural, Embedded, Ssis, Data quality, Security, Architecture, Content, Service, Technology, Algorithms, Enterprise, VSTS, Social, Smb, Processing, Sql server 2016, Tuning, MDX, Vb, Team Foundation Server, Calculations, Github, Power, Campaign, App, Server, BEE, Web, Chatbot, Office, Ai, Development, SQL Server, SharePoint, Artificial Intelligence, DevOps, Big Data, Power BI, Data mining, Azure, Forecasting, Office 365, Jira, Content Management, CRM, Machine learning, Business Intelligence, Advertising, .Net, Data Analysis, Excel, Sql, Design, Marketing, Vb.net, Analytics, Sales, T-SQL, Integration, Visual Studio, Management, Finance, Visio, Event, Linkedin, Digital Marketing, SoMe, Cloud, C, Data Warehouse, Database, Marketing Automation, Automation, R, ETL
2011 - 2013
job
Data Specialist / MS BI Lead
Royal Bank of Scotland (RBS).
Joined the RBS Business Services team for the Analysis, Design, Architecture and the Development of Data warehouse solution.
Designed and developed data warehouse at the group level - maintaining RBS Group data like Employees data, Locations data, RISK data, Incidents, Fraud and number of other data marts which is spread across various internal and external source systems and flat files.
Designed, Developed and Maintained unified single source data warehouse with a high quality and integrated data for the high value consistent MI reports. Also, this unified data is being used by a number of web applications which the frontend team develops for various business departments within RBS. It also requires migration of data from third party Oracle systems into the central database tables.
Technologies/Tools used: SQL server 2008/R2/2012, SQL Server BIDS (SSIS, SSRS, and SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#, Visual Studio 2008/2010, MS Visio 2010, SQL Compare, ArchiMate, Erwin, SQL Server Management studio, Team Foundation Server (TFS) 2010, Red Gate SQL Source Control, Oracle 9i/ 10g, Autosys
Designed and developed data warehouse at the group level - maintaining RBS Group data like Employees data, Locations data, RISK data, Incidents, Fraud and number of other data marts which is spread across various internal and external source systems and flat files.
Designed, Developed and Maintained unified single source data warehouse with a high quality and integrated data for the high value consistent MI reports. Also, this unified data is being used by a number of web applications which the frontend team develops for various business departments within RBS. It also requires migration of data from third party Oracle systems into the central database tables.
Technologies/Tools used: SQL server 2008/R2/2012, SQL Server BIDS (SSIS, SSRS, and SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#, Visual Studio 2008/2010, MS Visio 2010, SQL Compare, ArchiMate, Erwin, SQL Server Management studio, Team Foundation Server (TFS) 2010, Red Gate SQL Source Control, Oracle 9i/ 10g, Autosys
Ssis, MS Visio 2010, Agent, Sql server 2008, Server Management, Vb, Team Foundation Server, Server, BEE, Web, Development, SSAS, TFS, It, Net, SSRS, Design, Architecture, T-SQL, Visual Studio, Management, Visio, Vb.net, C, Data Warehouse, Database, Oracle, SQL Server, Frontend, .Net, Sql
2011 - 2011
freelance
MS SSIS/SSRS/SSAS Senior Consultant
O2 Telefonica.
Joined the O2 Business Intelligence team for the Design and Development of Data warehouse solution for various data marts like PoS data, O2 Mobile Insurance, O2 mobile analytics, Mobile Tariffs, Inventory management reporting, Customers data, etc. to provide critical MI reports to the business to achieve its strategic goals.
Technologies/Tools: SQL server 2008, SQL Server BIDS (SSIS, SSRS, and SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#, MS Visio, Subversion, SSMS, Visual Studio.
Technologies/Tools: SQL server 2008, SQL Server BIDS (SSIS, SSRS, and SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#, MS Visio, Subversion, SSMS, Visual Studio.
Analytics, Agent, Sql server 2008, Vb, Server, Development, Inventory management, Insurance, SSAS, Management Reporting, Pos, Net, SSRS, Ssis, Design, T-SQL, Visual Studio, Management, Visio, Vb.net, Subversion, C, Data Warehouse, SQL Server, Business Intelligence, .Net, Sql
2009 - 2010
freelance
Microsoft BI Consultant
IGIndex.
Developed data warehouse business intelligence solution to maintain all the customer information across all over the world and all their bets/transactions maintaining their historical information for critical MI reports for the business / analysts.
Technologies/Tools: SQL server 2008, SQL Server BIDS (SSIS, SSRS, and SSAS), SQL Server Agent,
T-SQL, VB.NET/C#, MS Visio, JIRA, SSMS, Visual Studio.
Technologies/Tools: SQL server 2008, SQL Server BIDS (SSIS, SSRS, and SSAS), SQL Server Agent,
T-SQL, VB.NET/C#, MS Visio, JIRA, SSMS, Visual Studio.
T-SQL, Agent, Sql server 2008, Vb, Server, BEE, SSAS, Net, SSRS, Ssis, Sql, Visual Studio, Visio, Vb.net, C, Data Warehouse, Jira, SQL Server, Business Intelligence, .Net
2007 - 2009
job
MS BI Senior Developer
Telstra Ltd.
Big Pond Mobile web platform serves the mobile content like ringtones, games, applications, wallpapers, music to the mobile users. They have huge mobile content. Users can view and can download the content on their mobile phones. This project involves loading of all the transactional data provided in the flat files and other systems to the SQL Server Data warehouse and to generate the MI reports using SSRS for different SSAS Cubes.
Technologies/Tools used: SQL server 2005, SQL Server BIDS (SSIS, SSRS and SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#, Visio.
Technologies/Tools used: SQL server 2005, SQL Server BIDS (SSIS, SSRS and SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#, Visio.
Net, SQL Server 2005, Agent, Vb, Server, BEE, Senior Developer, Web, Music, SSAS, Developer, Sql, SSRS, Ssis, Content, T-SQL, Visio, Vb.net, C, Data Warehouse, SQL Server, .Net
2006 - 2007
job
MS SSIS Developer
Orange.
Orange App shop products developed by Surfkitchen provide the mobile content - ringtones, wallpapers, videos, games, applications to their customers through their mobile phones. This project involves design, develop and maintain Data Warehouse loading all mobile manufacturers data, customers mobile content transactions/refund transactions, mobile traffic user agent data to deliver high quality KPIs and management reporting solution to assist business to achieve its strategic goals.
Technologies/Tools used: SQL server 2005, SQL Server BIDS (SSIS, SSRS, SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#
Technologies/Tools used: SQL server 2005, SQL Server BIDS (SSIS, SSRS, SSAS), Import/Export tools, SQL Server Agent, T-SQL, VB.NET/C#
Ssis, SQL Server 2005, Agent, Vb, App, Server, SSAS, Management Reporting, Developer, Net, SSRS, Design, Content, T-SQL, Management, Vb.net, C, Data Warehouse, SQL Server, .Net, Sql
2005 - 2006
job
Senior Software Engineer
Samsung Electronics.
Samsung is one of the leading mobile handset manufacturers in the world. They sell mobile with different names in a different part of the world. All their device details, sales details and other information is spread across different systems SAP systems, Oracle systems and Microsoft SQL server systems. This project is to consolidate data into SQL server and thereby creating ad-hoc and canned reports as per the business requirements for the analytical reporting, planning, forecasting and trend analysis. Data migration from SQL Server 2000 to SQL Server 2005.
Skills/Tools used: SQL Server 2000 ,Query Analyzer, DTS Designer, MS SQL Reporting Services, SQL Profiler, Index Tuning Wizard, MS Excel, MS Access, MS Visio.
Skills/Tools used: SQL Server 2000 ,Query Analyzer, DTS Designer, MS SQL Reporting Services, SQL Profiler, Index Tuning Wizard, MS Excel, MS Access, MS Visio.
Sql, Excel, SQL Server, Oracle, Forecasting, SAP, Microsoft SQL, Microsoft SQL Server, Visio, Sales, Access, Software, Server, Tuning, SQL Server 2005
Krishna's reviews
Krishna has not received any reviews on Worksome.
Contact Krishna Mudragada
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Krishna directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark