Amit Patra Email and Phone Number
☑ Business Intelligence Architect with 10+ years of experience in fields of Business Intelligence, Data Warehousing(DWH), ETL, Analytics Tools (MicroStrategy & PowerBI), Data Visualization, with working experience on Azure services and in-house Automation.☑ Focused on building Problem Solving Solutions for Businesses using various Automation techniques, Data Analytics, Visualizations, Azure services, Microsoft Azure & Power Platform.☑ Deep understanding and implementation of various Project phases including Problem identification/definition, Effort estimation, Problem diagnosis, Developing solution, Design and Deployment.☑ Creation of detailed Requirement Specification Documents from Business Requirements and Problems. Interacting with Global and local Stakeholders, Users, and Clients to take continuous feedback and understanding their pain points and requirements.☑ Vast experience in working with MicroStrategy as Report Developer, Designer & Platform Administrator. Worked with MicroStrategy Command Manager, Object Manager, Integrity Manager, System Manager, License Manager, Enterprise Manager, Platform Analytics, Performance tuning of MicroStrategy Reports, Intelligent Cubes, Application Platform, Data modelling & Schema design, Distribution Services. Creation of Intelligent cubes and freeform SQL. Development of Dynamic Dashboards and Statistical reports in MicroStrategy.☑ Experience in designing professional, Reports & Dashboards in Power BI using compelling visualizations with DAX queries that helps Businesses in getting the right insights from their data to take management decisions. Good exposure and working experience in DAX, Power Query, Gateway, connecting multiple Data sources, Dataflow and Data modelling using Power BI (Developer).☑ Having hands-on knowledge and working experience in Cloud computing solutions in Microsoft Azure services☑ Clients Worked with : MicroStrategy, Sainsbury's, AMEX, Nielsen, The Adecco Group, SUEZ(Veolia). Worked across various horizontals & verticals in IT industry - Banking, Retail, Staffing, Hi-Tech, Analytics & Insights. Microsoft Certified Trainer.☑ Good Analytical, Quantitative, Logical and Problem-solving skills to deliver meaningful and practical solutions to Business problems. Adaptable and flexible, Possess Digital Marketing knowledge as additional skills.☑ Good communication skills both written and verbal, and story telling technical concepts to non-technical Audiences and Users. Ability to lead and manage Team size of 4-8 members.
Tech Mahindra
View- Website:
- techmahindra.com
- Employees:
- 109765
-
Business Intelligence ArchitectTech Mahindra Jan 2022 - PresentBhubaneswar, Orissa, India
-
Business Intelligence AnalystTata Consultancy Services Apr 2016 - Jan 2022India➡️ As a BI Analyst, I am more focused on Data Analysis, Cleansing & Transformation, Modeling, Visualization using BI Analytics tools like Power BI & MicroStrategy. Also I am more emphasizing on building Problem solving solutions using Automation, Microsoft Power Platform and Azure Cloud. This also leads to predictive analysis using learning models of Machine Learning & AI.➡️ Clients worked with ➜ The Nielsen Corporation, The Adecco Group➡️ My primary roles and activities included :➜ Platform/Application Administration and Support to existing Projects on Azure Cloud environment.➜ Migration of packages from from lower to higher environments using Object Manager.➜ MicroStrategy(MSTR) installation and configuration for v 11.x (2019), Upgradation of MSTR from v10.x to 11.x and migration from On-Premise to Azure cloud.➜ Creation and Management of MSTR Security Roles, User Groups, Users creation, Security filters and management.➜ Automation of repetitive tasks like Users/Project/Security/Cubes management using Command Manager and System Manager workflows. Server level automation to send critical alerts to BI Support Team and Stakeholders.➜ Performance tuning of MSTR Reports and Intelligent Cubes by SQL analysis, Cube Advisor and Project/Server Configuration.➜ Data Sourcing, Transformation, Modeling, Creating Reports & Dashboards in Power BI.➜ Development and enhancement of MSTR Reports, Dashboards and Visual Insights.➜ Development of MSTR schema objects : Facts, Attributes, Logical Tables, public objects : Metrics, Filters, Prompts.➜ License Administration, Management and Auditing using License Manager.➜ Development of new Power BI Reports : ad-hoc reports, redesigning existing reports on MicroStrategy.➜ Validate report SQL and implement Business Intelligence (BI) best practices to ensure an optimal end-user experience.➜ Testing the integrity of Reports and Documents across environments using Integrity Manager. -
Business Intelligence DeveloperTata Consultancy Services Jul 2013 - Mar 2016India➡️As a Business Intelligence Developer, I was involved crating the reports and Dashboards for Clients and End Users so that they can get right insights for their data and take the right decisions at right time with MicroStrategy tool. My primary activities included Gathering requirements from Clients, understanding their pain points, Data modeling, Creation of Schema Objects, Public & Application Objects, Reports & Dashboards.➡️ Clients worked with ➜ MicroStrategy Inc., Sainsbury's - Supermarket company, AMEX (American Express).➡️ My primary roles and activities included :➜ Design and develop dimensional data models, schema objects, data relationships, public objects, reports, dashboards, to support on going and new reporting initiatives through data analysis and requirements gathering.➜ Development of attributes, facts, dimensions, transformations, filters, prompts, grids and Dashboards in MicroStrategy➜ Understanding ETL, data transformations, and data cleansing. ➜ Developing and maintaining MSTR reports & architecture.➜ Perform testing : Unit, Integration, Performance and Regression testing.➜ Daily health monitoring of MSTR Platform including Intelligence Servers, Web Servers, Narrowcast Servers, front end Web and resolving in case of any issues.➜ Monitoring of MSTR jobs on Control-M and resolving those immediately for any failures. Collaborating with other dependent Application jobs as the MSTR jobs were the last in Presentation layer.➜ Creation and Migration of MSTR Packages for deploying them into Production environment.➜ Performance tuning of existing Reports and Platform at Report level and Project/Server level.➜ Understanding the design of Cognos Reports and doing reverse engineering for MSTR reports with Cognos Team.➜ Preparing Objects mapping, Calculations, and Design document for MSTR Objects➜ Connect regularly with Clients and business stakeholders regarding their outstanding reporting requests and new requirements.
-
Project TraineeTata Consultancy Services Mar 2013 - Jun 2013Training on Informatica and Business communication skills.
Amit Patra Education Details
-
Computer Science -
10Th Ssc
Frequently Asked Questions about Amit Patra
What company does Amit Patra work for?
Amit Patra works for Tech Mahindra
What is Amit Patra's role at the current company?
Amit Patra's current role is Azure Data Engineer || MicroStrategy || Power BI || Data Analyst || Microsoft Azure || 3x Microsoft Certified.
What schools did Amit Patra attend?
Amit Patra attended Biju Patnaik University Of Technology, Odisha, Central Board Of Secondary Education, Central Board Of Secondary Education.
Who are Amit Patra's colleagues?
Amit Patra's colleagues are Aparna C, Kushal G., Sai Satya Prakash Upadhyayula, Gajanan Pande, Suresh Gajendiran, Manoj Tamarana, Srinivasarao Vasamsetti.
Not the Amit Patra you were looking for?
-
Amit Patra
Kolkata -
Amit Patra
Mumbai -
3rediffmail.com, dhflpramerica.com, pramericalife.in -
Amit Patra
Bhubaneswar -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial