Kiran Kumar Ganapuram-l - l linkedin.com/in/kiran-kumar-ganapuram-/
EDUCATION
Master’s in Computer Applications (2010)
Technical Lead & Expert Tableau Developer & Admin
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. Fast learning curve and adaptive to evolving industry
trends. A dedicated professional with drive and skill set to excel in the competency of BI in enhancing
company’s ability to capture profitable markets.
TECHNICAL SKILLS
•
•
•
Reporting Tools: Tableau Desktop & Server,
MicroStrategy BI Suite, Power BI, Excel
ETL Tools: Alteryx, Oracle Data Integrator,
Pentaho Kettle ETL Tool
Data Modeling: ERWIN
•
•
Databases: Microsoft SQL Server 2008R2,
Mysql server 5.5, Oracle 11g/10g/9i
Languages: Python, SQL, PL/SQL, Shell
Scripting, Excel VBA.
EXPERIENCES AND ACHIEVEMENTS
HCL TECHNOLOGIES - Hyderabad, India
11/2018 - Current
Technical Lead
• Excelled in implementing innovative and unique visualization techniques and standards with
reporting solutions in multiple Projects using Tableau.
• Deep understanding of financial, Pharma, Gaming and Retail Businesses.
• Leading a team of 8 personnel focused on implementing best practices and on-time deliveries.
• Translated Requirements gathering from business Stakeholders, performed analysis, prepared
technical specifications, designed data modelling and developed Business Intelligence solutions
where the key insights which helped business in implementing strategic methods.
• Developed and optimized interactive reporting with Tableau desktop and further improved
compliance of metrics with accuracy minimalizing manual errors and supporting data governance.
• Defined ETL workflows and datasets using Alteryx to ensure smooth data transfer from multiple
sources to Data Warehouse and performed sanity checks.
• 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.
• Worked extensively on Tableau Server Administration tasks like Shell scripts for deployments,
Weekly Server Backup, Active Directory Sync, Automated Extract refreshes, Subscriptions and
provided End user training
BIZACUITY SOLUTIONS PVT LTD - Hyderabad
Senior Software Engineer
•
•
•
•
•
•
•
•
•
•
•
•
•
•
01/2012 to 11/2018
Extensively worked on Tableau Reporting and have delivered out of the box creative visualizations
custom tailored as per business needs.
Thorough understanding of businesses like Gaming, Retail and Financial.
Provided internal Training and Mentored team of 5 members, estimated their work hours and
tracked progress in scrum process by Agile methodologies.
Evaluated business requirements from stake holders and prepared technical specifications and
developed BI solutions that surpassed client expectations.
Architected in UI/UX mockups, creating efficient, optimized and eye-catchy Tableau dashboards,
score cards and reports.
The insights have helped customer to analyze workload vs staff ratio in each location and facilitate
employee movement and evaluate employee performance
Profusely worked on Project Releases/Deployments in multiple environments and maintaining
Tableau Servers.
Extensively worked on Performance Tuning for 8 sec rule optimization, Site & Server
Administration, support, debugging server level issues, User & project management, UAT testing
and prepared documenting.
Proficient in designing/building complex and compelling visuals using Filters, Drill-down Reports,
linked reports with Microsoft Power BI Desktop.
Implemented Data Analysis Expression (DAX) functions to various measure calculations to enrich
Power BI dashboards.
Worked extensively on Power BI Gateway in keeping the dashboards/reports upto date with on
premise data sources.
Proven experience in Database Management systems, Data Mining, SQL, PL/SQL procedures for
SQL based reports.
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
INPUTO TECHNOLOGIES - Hyderabad, India
01/2011 to 01/2012
Software Engineer
• Coordinated and collected Requirements of NREGA government project and prepared
specifications document.
• Extensively involved in Star Schema Data Modeling using ERWIN.
• Automated the entire integration process.
• 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.
• The reports helped to analyze the funds spent vs development achieved and to foresee any
upcoming frauds.
CERTIFICATIONS
•
MicroStrategy Certified Project Designer CPD March 2015 to Present.
