Manish Jain

Power BI

• Designed and deployed Power BI Interactive Dashboards with KPIs for Travel Domain of all categories Air, Hotel Car and Rail such as Overview, Saving, Supplier, Expense and Compliance.
• Developed complex DAX measure such as time intelligence , ranking
• Created enterprise-level data models with fact/dimension design, improving performance and reusability.
• ETL Process using Power Query integrated multiple sources (SQL Server, Data Lake, Excel, APIs).
• Implemented Row-Level Security (RLS) and governance policies to ensure secure data access across clients.
• Published and maintained reports on Power BI Service with scheduled refresh, dataflow, and on-premise gateways.

Tableau

• Designed and deployed 30+ Tableau dashboards with KPIs for Travel Domain of all categories Air, Hotel Car and Rail such as Overview, Saving, Supplier, Expense and Compliance.
• Worked with stakeholders to gather requirements and transform them into BI solutions.
• Implemented row-level security and governance in Tableau Server.
• Optimized queries and data extracts, reducing dashboard load time by 40% .
• Collaborated with data engineering team to integrate Tableau with AWS Redshift .

Birst

• Design Customized interactive Dashboards for Travel collections such as Overview, Saving, Supplier and Expense for Air, Hotel,Car and Rail.
• Perform Data Blending for include client external data with travel data such as expense, Budget, Purpose of trip and reason code description for travel.
• Building travel Compliance dashboard for client to monitor and improve the savings.
• Building/ Maintaining backend infrastructure of the Tool such as connecting data from multiple sources, data modelling, data warehouse, ETL and BQL Query.
• Mentored junior developers through regular 1-on-1 meetings, providing guidance on best practices, coding standards, and career growth opportunities.

Tableau

• Worked across travel management to build out the reporting infrastructure in Tableau.
• Interaction with business to collect and understand Requirements.
• Connect Tableau with Various data sources mainly Data lake or Sandbox using ODBC and SQL server to build reports as per requirements.
• Develop dashboards and visualizations that empower decision makers.
• Data Blending: Responsible to prepare data model in HIVE (sandbox or data lake) and connect with tableau to blend data with existing data model.

VBA Automation Expert (15+ years of experience)

• Designed and implemented Excel VBA macros to automate repetitive business processes, reducing manual effort by up to 70% and minimizing human errors.
• Working as a VBA developer automating reports in MS-excel, Ms-Access using VBA and Excel Power Query.
• Database Management - SQL| Ms-Access
• Responsible to create/Maintain databases in SQL Server and Ms access Including writing complex queries, Data Analysis and ETL and connect with data visualization tool to generate reports.
• Building dashboards in excel using power query, Power Pivot and DAX.

• Worked as a VBA developer automating Project in Various application such as Excel,Ms- Access, IE, ERP Application.
• Developed dynamic dashboards and reporting solutions using VBA, enabling real-time data analysis and decision-making for stakeholders.
• Automated data extraction, transformation, and consolidation from multiple sources (Excel, CSV, Access, SQL databases, ERP systems).

• Automate various Excel Reports using VBA
• Designed and developed relational database solutions in MS Access , including tables, queries, forms, and reports to streamline business operations.
• Created complex queries (SQL, parameterized, pass-through queries) for advanced data analysis and reporting.
• Designed MIS and business intelligence reports using Access queries and reports, improving decision-making efficiency.
• Optimized database performance through indexing, query optimization, and database normalization .
• Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.

• Worked as a Reporting Analyst publishing daily , monthly weekly reports in excel and also responsible to automate reports of various processes.
• Worked in SQl sever for data scrubbing in order to create dashboards for the clients.