Vikram Kale
Nagpur,MH
Summary
Experienced and certified in MicroStrategy, with a strong background in Data Analytics and Business Intelligence. Specializing in MicroStrategy, SQL server, Vertica, and Oracle databases, possessing extensive knowledge of ETL and Data Warehouse concepts.
Overview
7
7
years of professional experience
Work History
Assistant Manager
InfoCepts
01.2024 - Current
- Effectively handled small team of developer to achieve end to end implementation of MicroStrategy business reports.
- Involved in creating BRDs, Module Estimation documents, planner, UAT and handover documents.
- Involved in creating entire schema layer like attributes, fatcs, transformations, relationships required for reports.
- Worked on creating MicroStrategy public objects like metrics, filters, prompts, Intelligent Cubes, Datasets, pixel perfect dashboards for business users.
- Expertise in tuning the performance for MicroStrategy datasets and dashboards.
- Worked on MicroStrategy Transaction service reports for Month Closure and Entry Point Closure process.
- Hands on experience on creating complex dashboards as per business requirements.
- Involved in understanding the data pipeline and stored procedures to load the business data into datawarehouse/datamart.
- Completed implemented an Automation for month closure process by creating script and MicroStrategy System Manager workflow.
MicroStrategy Architect
Trianz Digital Consulting Pvt Ltd
01.2022 - 01.2024
- Worked as a MicroStrategy Architect for Insurance based client to fulfill the business reports.
- Involved in the Business Requirements gathering process and understanding of Technical Design Documents.
- Expertise in creating the Logical Data Model in MicroStrategy.
- Worked on creating schema objects like attributes, facts, relationships, logical tables.
- Worked on creating public object like metrics, filters, intelligent cubes, datasets and dossiers.
- Involved in UAT testing and performance tuning , QA and production migration and post production
support throughout the project.
MicroStrategy Developer
Nice Software Solutions Pvt Ltd
02.2019 - 01.2022
- Involved in end to end analysis of stock market basis profit and loss reports & its complete implementation in MicroStrategy.
- Worked with business to understand the requirement on timely basis and involved in logic building as well as implementation in ETL & MicroStrategy.
- Worked on creating MicroStrategy schema objects and public objects for business reports.
- Worked on analyzing the complexity of existing Crystal reports and achieve the functionality by creating MicroStrategy freeform reports.
- Worked on creation of Update, Delete and Insert transaction services dashboards as per user requirements.
- Extensively worked on using Threshold, Conditions formatting and Visualizations on dashboard.
- Involved in improving the performance tuning of reports, data testing, functionality testing of
dashboards
Software Engineer
Shams Healthcare Solutions Pvt Ltd
02.2018 - 02.2019
- Worked as a SQL developer and SQL Tech Support with collaboration of business professionals across globe to provide full solution. Experienced in Analysis and debugging the existing databases and SQL stored procedures.
Education
Master of Technology - Computer Network and Information Security
SGGSIET
Nanded, Maharashtra07.2017
Bachelor of Engineering - Computer Science and Engineering
SGBAU
Amravati, Maharashtra08.2014
High School Diploma -
Government Polytechnic Amravati
Amravati, India06.2011
Skills
- Certified MicroStrategy Analyst (ANL)
- Certified MicroStrategy Data Scientist (SCI)
- MicroStrategy 10x, 11x
- Power BI
- Informatica PowerCenter 9x
- SQL
- PL/SQL
- Microsoft SQL Server
- Oracle
- Vertica
- Apache Hive
- Windows
- Linux
Timeline
Assistant Manager
InfoCepts
01.2024 - Current
MicroStrategy Architect
Trianz Digital Consulting Pvt Ltd
01.2022 - 01.2024
MicroStrategy Developer
Nice Software Solutions Pvt Ltd
02.2019 - 01.2022
Software Engineer
Shams Healthcare Solutions Pvt Ltd
02.2018 - 02.2019
Master of Technology - Computer Network and Information Security
SGGSIET
Bachelor of Engineering - Computer Science and Engineering
SGBAU
High School Diploma -
Government Polytechnic Amravati
Similar Profiles
Dhawal ModiDhawal Modi
Executive at InfoCeptsExecutive at InfoCepts
ANTARA HUDDARANTARA HUDDAR
Data Engineer at InfoCeptsData Engineer at InfoCepts
Venkata SanaboyanaVenkata Sanaboyana
Data Science Intern at InfoCeptsData Science Intern at InfoCepts