Kiran Kumar Ganapuram

Business Intelligence Professional with 10+ years of result driven experience in Design, Development, Implementation & administration of innovative BI solutions. Practiced troubleshooter with diagnostics procedure expertise and in-depth technical experience. 

• Leading a team of 8 personnel and excelled in implementing innovative and unique visualization techniques and standards with reporting solutions in multiple Projects using Tableau. 
• Deep understanding of financial, Pharma, Online Gaming and Retail Businesses.
• Extensively involved in Star Schema Data Modeling using ERWIN.
• Translated Requirements gathering from business Stakeholders, performed analysis, prepared technical specifications, designed data modelling and developed Business Intelligence solutions with the key data-driven insights that helped business in implementing strategic decisions. 
• Architected in UI/UX mockups, creating efficient, optimized and eye catching Tableau dashboards, score cards and reports.
• The insights have helped to create commercial value to customer and to analyze workload vs staff ratio in each location and facilitate employee movement and evaluate employee performance.
• Graphically enriched insights slashed the time commitment of Business users were spending on previous system by 97% and pioneered interest of other Region Heads in leveraging their similar needs.
• Received Innovation Champion Award for the achievements made.
• Outperformed in delivering analytical decision-making insights to identify 12.4% as repeat customers who are not repaying the loan dues.
• Developed and optimized interactive reporting with Tableau desktop with SQL and multiple data sources and further improved compliance of metrics with accuracy, supporting data governance
• Extensively worked on Performance Tuning, Site & Server Administration, support, debugging server level issues, User & project management, UAT testing and prepared documenting.
• Profusely worked on Project Releases/Deployments in multiple environments and maintaining Tableau Servers.
• Proficient in designing/building complex and compelling visuals using Filters, Drill-down Reports, linked reports with Microsoft Power BI Desktop.
• Proven experience in Data Engineering, Data Mining, SQL, PL/SQL procedures and knowledge with Google Big Queries
• Developed complex mappings using Pentaho Kettle 4.1.0 to transform and load data from various source systems like Postgres, Flat files, SQL Server and loading to Mysql target database.
• Hands on Microstrategy Reporting suite and created various reports and dashboards using Desktop
• Strong experience in excel driven reporting, vba scripting, pivots, charts and vlookup functions
• Excellent Problem-solving and communication skills, Highly Motivated, passion oriented and deep analytical skills