Muthukannan Ganesan

• Responsible for design strategy, development and deployment architecture of Power BI reporting platform
• Responsible for design and implementation of Semantic layer in SSAS (for Self-Service BI) and migration of 3500 reports and dashboards from SAP BO to Power BI
• Oversaw development of data models and reports
• Drafted Governance for Power BI Adoption
• Implemented enterprise reporting platform. Power BI(On-Premise) environment with whopping 100+ application databases
• Completed 1200+ reports migration
• Reports integration with more than 10+ surrounding systems
• Monitored and tested application performance to identify potential bottlenecks, develop solutions and collaborate with developers on solution implementation
• Identified issues, analyzed information and provided solutions to problems
• Developed and maintained courteous and effective working relationships

● Responsible for deriving the solution design of deployment topology of enterprise reporting platform in ENBD.

● Successfully implemented Enterprise MSBI reporting platform (Power BI Report Server)

● Proficient in Microsoft BI stack implementation in On-premise and Azure cloud platform.

● Involved in end-to-end solutioning and implementation of robust security principles in the Big Data & Analytics platform

● Involved in various niche solutions particularly in the area of Advanced Analytics, Real time dashboards and machine learning.

● Designed and developed BI solutions using Power BI and required Tabular and Dimensional Data Models in SSAS & calculated views in SAP HANA

● Designed and developed CIO dashboard and platform audit dashboards.

● Performance tuning of reports (SSAS, HIVE and SAP HANA) and bench marking of reports.

● Designed Data level security solutions (Row-level security/Analytical Privilege) in Big Data, SAP HANA for analytical and paginated reports.

● Hands-on experience in managing SAP HANA deployments and platform

● Implemented all non-negotiable Security controls mandated by central Bank for the reporting platform and ensured DLP is enabled for all paginated reports

● Integrated logs with ELK stack and monitored logs with Kibana and configured alerts for Cyber Security, thus achieved PCI-DSS complaint for platform.

● Involved in enabling CPR (Consumer Protection Regulation) security controls mandated by Central Bank

● Custodian of enterprise reporting and analytics platform and responsible for below:

• Report governance, report rationalization for Cognos to MSBI migration & release management
• Automated reports deployment - integration with GitHub and deployment pipelining through Jenkins for CI/CD
• IAM integration of BI and HANA for automating access requests
• Resilience testing for entire platform
• Custom portal solution integration with MSBI reporting platform.
• Implemented Dynamic Data Masking & Always-On Availability for SQL database
• Configured Poly-base feature and integrated with Hadoop to enable querying within SSMS.
• Automated SSAS model deployment between PR & DR servers using RoboCopy script
• Configuration of new data sources, quarterly upgrade of BI and analytics Platform.
• R&D with Power BI for future reporting or analytics projects
• Set guidelines for report development for team

• Designed, developed and implemented MIS reporting solution in span of 3 months
• Successfully build MIS solution, ADF reporting solution as product by leading BI team of 10+ BI engineers.
• Designed intranet portal solution with minimal customization to be able to implemented in 3 different banking institutions.(Bharath Mahila Bank, Shivalik bank, Bhandhan Bank
• Responsible for performance tweaking of reports and automating ETL process
• Individually managed BCP process of entire BI platform.
• Implemented all coding standards and required security controls and received top rating for performance
• Own top performing team award two years in row.

• Developed SSRS reports and managed execution of ETL (SSIS) Packages and integrated with SharePoint Portal
• SQL Query optimization and performance tuning
• Single Point Of Contact (SPOC) for project
• Review meetings with client.
• Customized and implemented SharePoint (Back Office) Intranet Portal
• Configured CDN (Content Delivery network) and hosted website and in cloud server
• Created maintenance plans for Content and website databases.
• Involved in Feasibility Study and implemented 3-Tier Topology for migration.
• Deployed and managed execution of SSAS Cubes and SSIS packages.
• Troubleshooting of network, DNS, configuring NLB.
• Implemented AD migration to existing SharePoint portal configuring SSPs.
• Involved in analysis and completed SPRAP (Risk Assessment Program) for Portal
• Developed and deployed Dashboard reports and KPIs using ProClarity and PPS 2007 into SharePoint portal
• Designed and developed database for website.
• Migrated SQL database to latest version
• Configured and maintained internal Team Site and Team Foundation Server for source control
• Data Analysis in SCCM and developed SSRS reports from Heart database, Custom-built KPI’s for monitoring software usage.
• Developed SharePoint designer Workflows and used Excel Services for various reports in graphical representation.
• Developed cubes and deployed dashboards using Performance Point Server into SharePoint site