Senior MicroStrategy Architect & Cloud Analytics Lead
Resume:
RAJDEEP PAL CHOWDHURY
Enterprise BI Platforms Cloud Analytics (AWS)
*******.************@*****.*** +65 86612951 Singapore 247965 Senior MicroStrategy Architect with over 17 years of experience designing, implementing, and optimizing enterprise analytics platforms across banking, payments, insurance, and retail industries. Deep expertise across the full MicroStrategy stack including Intelligence Server architecture, metadata modeling, VLDB tuning, intelligent cubes, caching strategies, security governance, and high-concurrency reporting environments. Proven experience deploying MicroStrategy solutions in cloud environments including AWS and Google Cloud, integrating with modern data warehouse platforms such as Vertica, Redshift, and Synapse. Known for delivering scalable, high-performance BI platforms, executing MicroStrategy upgrades and migrations, and solving complex performance and scalability challenges in enterprise analytics systems.
• MicroStrategy Platform Architecture MicroStrategy Intelligence Server architecture and clustering
•
Metadata schema design (facts, attributes,
hierarchies, transformations)
• • VLDB settings optimization and query tuning
Intelligent cube design and caching
strategies
• • MicroStrategy upgrades and migrations
Command Manager and System Manager
automation
• • MicroStrategy Enterprise Manager monitoring
Security roles, user governance, and access
control
• Performance tuning for high-concurrency
reporting environments
•
• Data & Analytics Architecture • Enterprise data warehouse design Dimensional modeling (Star Schema, SCD
Type 1/2)
• • Advanced SQL optimization
• ETL architecture and integration BI platform scalability and performance engineering
•
• Cloud & Data Platforms • AWS analytics architecture Redshift, Vertica, and modern cloud data
warehouses
• • S3 data lake integration
• Cloud-based BI deployments • Infrastructure automation and monitoring Jul 2023 - Current
Independent MicroStrategy Architect
(Freelance)
CodeHive Solutions - Singapore
Provide consulting and advisory services for enterprise BI and analytics platforms with focus on MicroStrategy architecture, performance optimization, and cloud-based analytics solutions.
•
Architect and optimize MicroStrategy reporting platforms supporting enterprise analytics workloads.
•
Provide guidance on metadata modeling, schema design, and enterprise semantic layer architecture.
•
Conduct performance tuning for complex reports and dashboards using VLDB optimization and caching
•
PROFESSIONAL SUMMARY
SKILLS
WORK HISTORY
strategies.
Advise organizations on BI platform scalability, data modeling, and data warehouse performance optimization.
•
Support modernization initiatives involving MicroStrategy integration with cloud-based data platforms.
•
Mar 2021 - Jul 2023
Lead Software Engineer / MicroStrategy
Architect
EPAM Systems - Singapore
Architected a cloud-based MicroStrategy analytics
platform supporting SaaS profitability analytics solutions.
•
Designed MicroStrategy metadata and schema objects aligned with Vertica-based enterprise data warehouse architecture.
•
Optimized report performance using VLDB tuning, caching strategies, and query optimization techniques.
•
Integrated MicroStrategy with AWS infrastructure to enable scalable cloud analytics architecture.
•
Participated in enterprise security assessments including penetration testing and infrastructure hardening.
•
Implemented automation and operational workflows using AWS Lambda, EventBridge, CloudWatch, and Python.
•
Configured AWS Application Load Balancer and WAF to protect analytics applications from security threats.
•
May 2018 - Mar 2021
Senior BI Engineer / MicroStrategy Platform
Specialist
Wirecard - Singapore
Managed enterprise MicroStrategy platform deployed in Google Cloud environment.
•
Performed MicroStrategy platform upgrades and
migrations ensuring reporting continuity and performance stability.
•
Designed regression testing framework using MicroStrategy Integrity Manager for upgrade validation.
•
Automated MicroStrategy administration using System Manager and Command Manager.
•
Tuned MicroStrategy Intelligence Server configuration to improve performance for high-concurrency reporting environments.
•
Defined backup and disaster recovery strategies for MicroStrategy servers and metadata repositories.
•
Sep 2011 - May 2018
Manager / MicroStrategy Technical Lead
Cognizant Technology Solutions - Kuala
Lumpur, Malaysia
Led MicroStrategy platform administration, deployment, and performance optimization activities for enterprise clients.
•
Managed installation and configuration of MicroStrategy Intelligence Server, Web Server, and Mobile Server.
•
Developed automated deployment workflows using
System Manager and Command Manager.
•
Implemented best practices documentation for
MicroStrategy governance and platform operations.
•
Led MicroStrategy platform upgrade from version 9.4 to version 10 including impact analysis and regression testing.
•
Supported BI platforms for major financial services clients including Zurich Insurance.
•
Aug 2009 - Aug 2011
BI Analyst (MicroStrategy Specialist)
Bank of America - India
Developed advanced MicroStrategy reports including cross-tab, ad-hoc, free-form SQL, and write-back reports.
•
Performed report performance tuning using VLDB
configuration and query optimization.
•
Conducted MicroStrategy proof-of-concept initiatives for enterprise reporting applications.
•
Supported enterprise reporting systems used by banking business teams.
•
Collaborated with ETL teams to design optimized database views for analytics reporting.
•
Jan 2006 - Jun 2009
BI Analyst / MicroStrategy Developer
Cognizant Technology Solutions - India And
USA
Designed and developed MicroStrategy schema objects including facts, attributes, hierarchies, and transformations.
•
Built dashboards and analytical reports using MicroStrategy Developer and Web.
•
Developed complex reports including free-form SQL, advanced analytics, and write-back reports.
•
Conducted unit and regression testing using MicroStrategy Integrity Manager.
•
Collaborated with ETL teams to design optimized database structures for reporting systems.
•
Worked closely with business stakeholders to translate reporting requirements into scalable BI solutions.
•
2005
Bachelor of Technology: Computer Science
RCC Institute of Information Technology Kolkata
AWS Certified Solutions Architect – Associate
MicroStrategy Certified Architect
MicroStrategy Certified Analytics Architect
MicroStrategy Certified Data Scientist
MicroStrategy Certified System Administrator
MicroStrategy Certified Mobile Architect
Google Cybersecurity Professional Certificate
EDUCATION
CERTIFICATIONS
Contact this candidate