$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
MIcroSoft Stack Developer with Experiecne in PowerBI, Power Apps, Power Automate, SSIS and Dynamics 365
Chaitanya Kanagala
,
London, United Kingdom
Experience
Skills
I'm offering
I am Chaitanya from India. I am on Work Permit Visa and looking out for freelance Jobs in the area of Microsoft STack( Power BI, Power Apps, Power Automate, SSIS and Dynamics 365.)
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2016 - 2016
job
MicroStrategy Developer
IMS HEALTH.
DESCRIPTION:
The project provides BI solutions to the pharmaceutical company regarding the sales and marketing of its products in and around united states. MicroStrategy and Power BI. Reporting tools were used to meet the reporting needs. MicroStrategy Mobile Dashboard Development where in the Schema is designed with Background database as SQL Server. Being a MicroStrategy Developer, I work on Architect Position to create schema objects as well as datasets.
ROLES & RESPONSIBILITIES:
✓ Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
✓ Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
✓ Created filters, parameters and calculated sets, Measures, Tables for preparing dashboards and worksheets in Power BI.
✓ Restricted data for users using Row level security and User filters.
✓ Developed Power BI visualizations and dashboards using Power BI Desktop.
✓ Developed Power BI workbooks from multiple data sources using Data Blending.
✓ Provided 24/7-production support for Power BI users.
✓ Understand Requirement, Analyzing Systems and Source Databases.
✓ Designed, developed, and implemented Power BI Business Intelligence Dashboards.
✓ Created custom columns/measures.
✓ Made transformations like string manipulations, numerical calculations, splitting/merging of columns based on requirements.
✓ Representing data using the visualizations such using Charts, Bar graphs, Donut charts, Line graphs, Cards, Text fields etc.
✓ Created multiple measures using DAX functions.
✓ Made several transformations like adding conditional columns, custom columns, and columns from examples in Query Editor.
✓ Responsible for dashboard design, look and feel and development.
✓ Use parameters and input controls to give users control over certain values.
✓ Combine data sources by joining multiple tables and using data blending.
✓ Worked on building the Mobile Canvas App to provide easy access and analyze the data for the Sales team. Along with integrated with Dynamics 365 CRM to provide dashboards and reports.
The project provides BI solutions to the pharmaceutical company regarding the sales and marketing of its products in and around united states. MicroStrategy and Power BI. Reporting tools were used to meet the reporting needs. MicroStrategy Mobile Dashboard Development where in the Schema is designed with Background database as SQL Server. Being a MicroStrategy Developer, I work on Architect Position to create schema objects as well as datasets.
ROLES & RESPONSIBILITIES:
✓ Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
✓ Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
✓ Created filters, parameters and calculated sets, Measures, Tables for preparing dashboards and worksheets in Power BI.
✓ Restricted data for users using Row level security and User filters.
✓ Developed Power BI visualizations and dashboards using Power BI Desktop.
✓ Developed Power BI workbooks from multiple data sources using Data Blending.
✓ Provided 24/7-production support for Power BI users.
✓ Understand Requirement, Analyzing Systems and Source Databases.
✓ Designed, developed, and implemented Power BI Business Intelligence Dashboards.
✓ Created custom columns/measures.
✓ Made transformations like string manipulations, numerical calculations, splitting/merging of columns based on requirements.
✓ Representing data using the visualizations such using Charts, Bar graphs, Donut charts, Line graphs, Cards, Text fields etc.
✓ Created multiple measures using DAX functions.
✓ Made several transformations like adding conditional columns, custom columns, and columns from examples in Query Editor.
✓ Responsible for dashboard design, look and feel and development.
✓ Use parameters and input controls to give users control over certain values.
✓ Combine data sources by joining multiple tables and using data blending.
✓ Worked on building the Mobile Canvas App to provide easy access and analyze the data for the Sales team. Along with integrated with Dynamics 365 CRM to provide dashboards and reports.
Security, Production, Calculations, App, Power, Canvas, BEE, Server, Development, Support, Developer, Pharmaceutical, Marketing, Service, Dynamics 365, Sales, Database, Power BI, SQL Server, CRM, Business Intelligence, Sql, Design
2014 - 2015
job
admin support
BBC, NOKIA.
for the smooth running of the projects. Providing production support as well as providing required access for the users using user management along with using different MicroStrategy tools like object manager, command manager, integrity manager to maintain the integrity of the data. Along with, smooth running of the servers and connectivity of the servers to the end users so that they cannot face any glitches in accessing the data through reports, dashboards.
ROLES & RESPONSIBILITIES:
✓ Extensive interaction with the Database experts to understand the Source System and efficient translation of technical data to Business terms through self-developed design templates.
✓ Gathered the Reporting requirements from business user and created BRD (Business Requirement documents) for SDLC process.
✓ Created and established KPI's based on BRD and logical data model.
✓ Created user groups, roles, privileges using MicroStrategy Command Manager.
✓ Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
✓ Implemented drill functionality on the reports using Drill Maps.
✓ Implemented the migration process suing object manager by creating packages.
✓ Worked on integrity manager testing to automate the process of verifying the project components from time to time.
✓ Created a completely new environment by setting up I server, web server along with configuring Enterprise manager statistical data.
✓ Worked on setting up mobile configuration to provide access to end users on iPad as well as iPhone.
✓ Automating the Admin Activities like User Management, Security, Project Management and DB management through the command manager scripts
✓ Preparing the documentation on standards and best Practices pertaining to administration, Deployment, and support MicroStrategy and upload them on the confluence.
✓ Gathered New requirements for MicroStrategy Projects including the Database requirements and established new project requirements across Development, Test and UAT Environments.
✓ License administration across all Environments using the License Manager (MSTR Tool)
✓ Worked on connection set up to the big data Hadoop cluster through the Kerberos Environment.
✓ Implement MicroStrategy Intelligent Cube creation, management, and automation.
✓ Support development teams for package, object, and code migrations across environments.
ROLES & RESPONSIBILITIES:
✓ Extensive interaction with the Database experts to understand the Source System and efficient translation of technical data to Business terms through self-developed design templates.
✓ Gathered the Reporting requirements from business user and created BRD (Business Requirement documents) for SDLC process.
✓ Created and established KPI's based on BRD and logical data model.
✓ Created user groups, roles, privileges using MicroStrategy Command Manager.
✓ Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
✓ Implemented drill functionality on the reports using Drill Maps.
✓ Implemented the migration process suing object manager by creating packages.
✓ Worked on integrity manager testing to automate the process of verifying the project components from time to time.
✓ Created a completely new environment by setting up I server, web server along with configuring Enterprise manager statistical data.
✓ Worked on setting up mobile configuration to provide access to end users on iPad as well as iPhone.
✓ Automating the Admin Activities like User Management, Security, Project Management and DB management through the command manager scripts
✓ Preparing the documentation on standards and best Practices pertaining to administration, Deployment, and support MicroStrategy and upload them on the confluence.
✓ Gathered New requirements for MicroStrategy Projects including the Database requirements and established new project requirements across Development, Test and UAT Environments.
✓ License administration across all Environments using the License Manager (MSTR Tool)
✓ Worked on connection set up to the big data Hadoop cluster through the Kerberos Environment.
✓ Implement MicroStrategy Intelligent Cube creation, management, and automation.
✓ Support development teams for package, object, and code migrations across environments.
Confluence, UP, Manager, Enterprise, Production, Server, Web, Development, KPI, Testing, Support, Design, Test, Security, Management, Hadoop, Database, Automation, Deployment, Big Data, Administration, Project Management
2010 - 2014
job
Run Integrity Manager
OPEN EMR.
FEB 2010 - AUG 2014
CLIENT: SAI SOFTEK SERVICES DESCRIPTION:
The project is an open source application which deals with medical billing system in United States, where patients, doctors and insurance companies are involved. It involves the financial information regarding the payment of medical bills to the doctors and hospitals by different types of insurance companies. The project deals with complete information of patient demographics and the treatment history along with the amount of bill paid by the insurance company.
ROLES & RESPONSIBILITIES:
✓ Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
✓ Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
✓ Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
✓ Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
✓ Configure, manage clustering of Multiple Intelligence server nodes and web server nodes to implement automatic failover, load balancing and boost the performance and scalability.
✓ Create and manage MicroStrategy application objects, schema objects and configuration objects.
✓ As per business requirement, designed developed and maintained MicroStrategy based reports.
✓ Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
✓ Having good Experience working with MS Excel, Office while integrating with MicroStrategy.
✓ Designed Various dashboards and reports and visualizations which provide the practical ability for the business user to design and refine their own reports without programming.
✓ Created the security roles, security filters and assigned them to the groups and users to meet their requirement.
✓ Upgraded the MicroStrategy from v 9.3.1 to v9.4.1 along with the project metadata.
✓ Worked extensively on building the metrics, compound metrics, consolidations, custom groups, Templates and OLAP reports.
✓ Prepared the test cases and tested the MicroStrategy Application as well as Reports and dashboard Performance after upgrading the Operating system.
CLIENT: SAI SOFTEK SERVICES DESCRIPTION:
The project is an open source application which deals with medical billing system in United States, where patients, doctors and insurance companies are involved. It involves the financial information regarding the payment of medical bills to the doctors and hospitals by different types of insurance companies. The project deals with complete information of patient demographics and the treatment history along with the amount of bill paid by the insurance company.
ROLES & RESPONSIBILITIES:
✓ Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
✓ Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
✓ Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
✓ Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
✓ Configure, manage clustering of Multiple Intelligence server nodes and web server nodes to implement automatic failover, load balancing and boost the performance and scalability.
✓ Create and manage MicroStrategy application objects, schema objects and configuration objects.
✓ As per business requirement, designed developed and maintained MicroStrategy based reports.
✓ Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
✓ Having good Experience working with MS Excel, Office while integrating with MicroStrategy.
✓ Designed Various dashboards and reports and visualizations which provide the practical ability for the business user to design and refine their own reports without programming.
✓ Created the security roles, security filters and assigned them to the groups and users to meet their requirement.
✓ Upgraded the MicroStrategy from v 9.3.1 to v9.4.1 along with the project metadata.
✓ Worked extensively on building the metrics, compound metrics, consolidations, custom groups, Templates and OLAP reports.
✓ Prepared the test cases and tested the MicroStrategy Application as well as Reports and dashboard Performance after upgrading the Operating system.
Insurance, Manager, Tuning, OLAP, Scalability, Server, Web, Mentorship, Software, Office, Testing, Load balancing, Design, Test cases, Implementation, It, Open source, Test, Security, Controlling, Management, Sql, Excel
My education
Victoria University of Technology
MSc, Micro Electronics Engineering
MSc, Micro Electronics Engineering
Nagarjuna University
Bachelors, Electronics & Instrumentation Engineering
Bachelors, Electronics & Instrumentation Engineering
Chaitanya's reviews
Chaitanya has not received any reviews on Worksome.
Contact Chaitanya Kanagala
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Chaitanya 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