Data Analyst Business Intelligence
Resume:
Summary
Raghunatha is a seasoned Data Analyst with over 15+ years of extensive experience in business data warehousing, architecture, data modeling, design, and development. Specializing in the implementation of Business Intelligence architectures, Raghunatha has proven expertise in utilizing BI tools like MicroStrategy, Tableau, and ETL with Alteryx and Snowflake. His broad experience encompasses roles as a BI Administrator, Architect, Developer, and Consultant, demonstrating a strong track record in leading projects from concept to delivery.
Key Responsibilities:
Data Analysis and Interpretation:
Analyze complex data sets to identify trends, patterns, and insights.
Interpret data to provide actionable recommendations for business improvement.
Reporting and Visualization:
Develop and maintain dashboards, reports, and visualizations using BI tools (e.g.,
MicroStrategy, Tableau, Power BI).
Present findings to stakeholders in a clear and effective manner.
Collaboration with Stakeholders:
Work closely with cross-functional teams (e.g., marketing, finance, operations) to
understand their data needs.
Gather requirements and translate them into technical specifications.
Performance Monitoring:
Monitor key performance indicators (KPIs) and business metrics to track performance.
Identify areas for improvement and suggest actionable solutions.
Data Governance:
Ensure compliance with data governance policies and best practices.
Promote a culture of data-driven decision-making across the organization.
Continuous Improvement:
Stay updated on industry trends, tools, and technologies related to BI and data analytics.
Recommend and implement process improvements for efficiency and effectiveness.
Ad-hoc Analysis:
Conduct ad-hoc analysis to answer specific business questions or support strategic initiatives.
Professional Experience:
VISIONET SYSTEMS PVT LTD
Client : KNITWELL Group USA DEC 2024 – June 2025
BI Architect (MicroStrategy Architect/Development)
Project: BOBJ to MSTR report Conversion
Meetings with the BOBJ team to review the existing environment and identify key reporting requirements.
Analyze and document report logic, visualizations, and performance bottlenecks.
Discuss and document any limitations or required workarounds that might exist when transitioning to MicroStrategy.
Review and analyze the SQL queries embedded in the BOBJ reports. Identify any advanced SQL techniques, custom logic, or aggregations used in the reports that will need to be replicated in MicroStrategy.
Rebuilt SAP BOBJ dashboards within the MicroStrategy platform as documents and dashboards.
Developed and maintain data pipelines using Snowflake.
Collaborate with business stakeholders to understand data needs and translate business requirements into technical solutions.
Perform root cause analysis of data issues, ensure effective resolution, and maintain high data quality standards
Work closely with cross-functional teams to integrate data solutions.
Maintain clear documentation for data processes, data models, and pipelines.
Environment: MicroStrategy 11.3.0, Snowflake, SAP HANA, SAP BOBJ
Idexcel Technologies Pvt Ltd - Bangalore Nov 2021 – Sept 2024
Sr.BI Technical Lead(Tableau, PostGres, Redshift)
Projects:
1.LOS(Loan Origination System),
2.ABL (Asset Based Lending),
3.Banking Portfolio Analytics
Idexcel is a Professional Services and Technology Solutions provider specializing in Cloud Services, Cloud Native Services, Data Platforms and Intelligence, Automation & AI. Idexcel has been implemented the CYNC application Product which uses the financial institutes to maintain their Borrowers, Relationship Managers, Loans, Spreads, Collateral, Covenants, Ticklers.
CYNC LOS is the Idexcel Product which is using by many Financial Institutes, as Banks are our customers we keep adding new functionalities and New reports under Analytics Tab, Reports and Dashboards. For ex: Loans Current QTR and Next QTR, Open Loans Pipeline, Future Closing..etc
Responsibilities:
Worked on Tableau development for nearly 3 years across three different projects.
Designed and implemented numerous reports and dashboards tailored to project requirements.
Published Tableau dashboards and reports to the Tableau Server for enterprise access.
Conducted multiple demo sessions for end-users, primarily from banking clients.
Actively gathered feedback from users and modified dashboards/reports accordingly to meet evolving needs.
Environment: Tableau Desktop 2024.1, Tableau Server 2024.1, Post Gres, Redshift, AWS, React JS
JP Morgan Chase Pvt Ltd - Bangalore
Sr BI Developer (Tableau / Alteryx/ Development ) Aug 2018 – Oct 2021
Project: CARI - Customer Analysis Reporting Infrastructure
Industry : Banking and Financial (Home Lending )
BI Responsibilities:
Understand business requirements and translate them into Alteryx/Tableau solutions.
Work closely with end-users to gather and document reporting needs.
Validate data accuracy and ensure alignment with business goals.
Troubleshoot and resolve issues related to reports and dashboards.
Address user questions and issues related to Alteryx/Tableau.
Communicate with Tableau vendors for issue resolution.
Create ad-hoc reports and perform data exploration.
Analyze the Business requirement document to understand the Business requirement.
compare current month vs. prior month, current quarter vs. prior quarter & prior year quarter, current Year vs. prior year
Coordinated with the offshore team and mentor on the requirements.
Developed the report objects and create the reports.
Dashboards are developed based on the developed reports and additional components as per the requirement.
Worked on Automation of dashboard Data load.
Environment: Tableau 2021.2.7, Alteryx, Big Data, Impala
Society General - Bangalore
MSTR Sr.BI Developer/Development Sept 2017 - Aug 2018
Project:
Involved in Data Architecture needed for reporting and Performed Data Blending.
Building Executive Summary, Consolidated Dashboards for Investment Securities Users.
Building complex metrics at report level which are needed for Investment Securities reports.
Building Advanced filters for Data accuracy.
Coordinated with the offshore and onshore Business users to get the requirements.
Analyze the Business requirement document to understand the Business requirements
Created the Design specification document for the developing the reports.
Worked on report objects to build the required attributes for user specified reports
Schedule the reports as per the data availability.
Provided user training to the Portal where all reports are placed together. Working in MULTISOURCING Projects while creating new Grid Reports based on the requirement and developing the documents (multi-layout and with different group fields) which are made available in PDF, Excel, etc.
Being part of Agile Methodology; active involvement in the other work streams (Traded Products, BSR, Retail,
Environment: Microstrategy 10.1 / 10.4, Tableau, Informatica & Oracle, Teradata, and Netezza.
Infocepts Pvt Ltd Bangalore
EURETCO - Netherlands
Technical Specialist, Module Lead – MSTR Admin/Architect Oct 2016 – July 2017
Project: Migration of Qlick Dashboards to Microstrategy Documents.
•Interacting with business users for requirement gathering, analyzing the business requirements, and translating them into functional and technical specifications.
•Conducted daily status calls and guided both onsite and offshore development teams, ensuring solutions were delivered within service level agreements.
•Implemented innovative BI strategies that effectively aligned with corporate objectives, improving overall data utilization across the organization.
•Created Semantic layer with required Schema Objects as per the analysis and built new Grid Reports based on the requirement. Worked with Business Directors / Partners and understand the business for which the reports were built as per the business needs.
•Monitored system performance and availability to ensure optimal operation.
•Managed user accounts, roles, and permissions for security compliance.
•Oversaw data source connections, resolving issues and ensuring reliability.
•Administered scheduled reports and dashboards, troubleshooting as necessary.
•Conducted performance tuning to optimize query efficiency and report generation.
•Implemented regular data backup and recovery procedures.
•Coordinated software updates and patches to maintain system integrity.
•Provided user support and training to enhance user experience.
•Maintained comprehensive documentation of processes and configurations.
•Collaborated with IT teams to troubleshoot and resolve cross-system issues.
•Part of daily status calls and mentoring the offshore team. Worked in Agile Methodology and provided solutions within SLAs.
•Worked on administrative tasks such as project migration, distribution service tasks, security and was involved in the upgrade from 9.0.2 to 9.2.1.
•Built and optimized intelligent cubes for the Visual Insights Tool in MSTR 9.2.1 by configuring working memory set, working memory and VLDB properties.
•Built VI analysis document using all the available visualizations like Graph matrix, Heat map and Bubble Graphs.
•Installed Google maps widget on VI, and developed visualizations.
•Worked closely with MSTR Tech Support to fix issues and bugs with visual insights (On Flash rendering issues and Cube Issues).
Environment: MSTR desktop 10.4, MSTR Admin, Architect, MS SQL Server
Roles
Data Analyst
Tableau Developer
Alteryx Developer
Snowflake Developer
Technologies
BI: MicroStrategy, Tableau, Power BI
ETL: Alteryx, Snowflake
DB: MS SQL Server, DB2, Teradata, Redshift, Snowflake with DBT
Languages: SQL, PL/SQL
Industries
BFS
Retail
Entertainment
Healthcare
Education
Master of computer Applications from PUNE University -MCA
Certifications
MicroStrategy Certified Project Designer
MicroStrategy Certified Report Designer
Tableau Desktop Specialist
Alteryx Core Certified
AWS Certified Cloud Practitioner
Oracle certified Associate
SDLC
Agile Methodology
Waterfall
Personal Skills
Analytical, Leadership
People skills, Proactive
Well Communicative
Contact this candidate