Ramashankar V

About Ramashankar V

Data Analyst Manager | Power BI Developer | SQL 13+ Years of Experience | IT, Banking & Education Sectors | BI & Data Visualization ExpertI am an experienced and results-driven MIS Manager with over 13 years of expertise in the IT, Banking, and Education industries. My core strength lies in transforming raw data into actionable insights through advanced Business Intelligence solutions using Microsoft Power BI, SQL & Advance Excel.My career is defined by designing, developing, and deploying data-driven dashboards and reports that support key business decisions. I specialize in end-to-end BI project management—from data extraction and transformation (ETL), SQL querying, and DAX modeling, to visualization and publishing interactive dashboards.Throughout my career, I\'ve successfully led and managed large-scale reporting and analytics functions across 52+ centers PAN India. I\'ve worked closely with top-level management (CEO, COO, VP, AVP) to deliver real-time KPIs, performance metrics, sales vs. targets, incentive tracking, and custom business reports that directly support strategic planning.Core Competencies: Power BI Dashboard Development Data Modeling (Star & Snowflake Schema) ETL/Power Query/Data Cleansing SQL Server & DAX Calculations Advanced Excel, Pivot Tables, VBA Macros Sales, Marketing & Operational Analytics MIS Automation & Report Scheduling Stakeholder Collaboration & Team LeadershipAchievements: Reduced manual reporting by 50% through Power BI automation Boosted regional sales by 27% through sales performance dashboards Delivered real-time insights for 20+ data sources, including Excel, SQL Server, SharePoint & Outlook Enhanced territory profitability by 24% via strategic data modelingI’m passionate about leveraging data to uncover trends, drive performance, and support smarter business decisions. Feel free to connect if you\'re looking for a data-driven leader who can translate your business needs into impactful BI solutions.You can reach me at 93••••••93 & i••••••••@gmail.com

Experience

1. Data Analysis Manager

   Frankfinn Aviation Services Pvt. Limited

   Oct 2023 — Present · Gurugram, IN

   Led the end-to-end creation, automation, and management of PAN India MIS reports using advanced Excel, VBA Macros, MS Access, SQL, Power Query, and Power BI. Collaborated with senior leadership including Call Center, Sales, and Marketing Heads to define targets for walk-ins, admissions, leads, and revenue across 52+ centers.Managed lead distribution from multiple digital platforms (e.g, Google, Instagram, Just Dial) to tele-counselors, tracked follow-up status, and developed performance reports including Appointment vs Walk-ins, Team Leader productivity, and counselor efficiency. Delivered detailed Center-wise, Course-wise, and Time-based (FTD/MTD/QTR/YTD) reports on admissions, MIB, and conversion rates, and supported VP Sales in monthly performance reviews.Handled the preparation and dissemination of incentive schemes and calculations for Center Sales Managers (CSMs), coordinated with accounts for payouts, and ensured timely reporting to top executives including the CEO and VP. Standardized reporting processes, migrated data across platforms, and implemented new reporting structures in Power BI and SQL-based systems to enhance data visibility and decision-making.

Education

• Babasaheb Bhimrao Ambedkar Bihar University (BRABU), Muzaffarpur

  Bachelor of Science - BS, Mathematics

• Karnataka State Open University

  Master of Computer Applications - MCA, Computer Science