Mithlesh Patel

• Data Engineering: Building and maintaining scalable data pipelines using modern ETL tools and cloud platforms.
• Database Management: Expertise in Snowflake, SQL, and data warehouse design, with an emphasis on performance optimization.
• Data Transformation: Proficient in DBT for data modeling, transformation, and creating a modular, maintainable analytics workflow.
• Business Intelligence (BI): Experienced in Looker, Tableau, and MicroStrategy for creating reports, dashboards, and data visualizations.
• Programming: Strong command of Python for scripting, data manipulation, and using libraries (Pandas, Matplotlib, Seaborn) for data analysis and visualization.
• Problem Solving: Advanced analytics to resolve complex data issues and improve pipeline efficiency.
• Collaboration: Working with cross-functional teams to align data infrastructure with business needs.

Design and develop reports for end users. Make recommendations based on best practices. Extract and integrate data from multiple sources in multiple formats (e.g., database, spreadsheets, text files) for performing modeling, analysis, and reporting.

Managed MicroStrategy Intelligence Server, Web, and Administrator tools, including Metadata Repository, Intelligence Server setup, and project creation via Configuration Wizard.

Developed and optimized MicroStrategy reports by designing schema, attributes, metrics, filters, and custom groups.

Used Project Merge and Object Manager to migrate objects between environments, while troubleshooting and optimizing report objects.

Implemented complex hierarchies and drill maps, ensuring proper database view modeling for accurate reporting.

Collaborated with the database team to align warehouse structures with business reporting needs and managed security roles in MicroStrategy.

Understood business requirements and converted them into technical specifications.

Provided production support, including issue resolution, root cause analysis, capacity planning, and Disaster Recovery execution.

Familiar with Basel-II Risk Management standards and involved in credit risk calculations for daily, weekly, and monthly cycles.

Collaborated with internal teams, stakeholders, and vendors for project execution.

Experienced in creating attributes, facts, metrics, and reports in MicroStrategy, including Grid Reports and Dashboards.

Managed user groups, object migration, project duplication, and set up Distribution Services for email and file subscriptions.