About
Highly accomplished Senior BI Analyst with 7 years of experience, specializing in designing and delivering high-impact BI solutions across FinTech, retail, and consumer product sectors. A Subject Matter Expert in Domo, Tableau, BigQuery SQL, and ETL automation, Kousik has a proven track record of optimizing data infrastructure, reducing query costs by 70%, and enhancing ETL runtimes by over 50%. Adept at collaborating with CXOs and product teams to define KPIs, modernize BI stacks, and drive measurable cost savings, Kousik is poised to lead advanced BI & Analytics initiatives in dynamic, data-driven environments.
Work
Hyderabad, Telangana, India
→
Summary
Led the design and management of enterprise BI dashboards, delivering critical financial analytics and optimizing data infrastructure for a key FinTech client.
Highlights
Designed and managed comprehensive enterprise dashboards for loan lifecycle, disbursement, and repayment analytics, leveraging Domo and Tableau to drive data-driven insights.
Spearheaded the migration of over 100 complex Domo ETL cards to GCP pipelines and Tableau dashboards, reducing license costs and improving load times by 40%.
Optimized BigQuery performance by refactoring views, implementing incremental logic, and SQL tuning, resulting in a 70% reduction in query costs.
Deployed Python automation scripts on AWS EC2, streamlining reporting workflows and saving over 50 hours of manual effort per month.
Designed and implemented KPI frameworks that improved decision cycle time by 30% across FinTech and retail clients, fostering data-driven decision-making for key stakeholders and enabling adoption by 200+ active users.
Hyderabad, Telangana, India
→
Summary
Delivered scalable ETL workflows and automated reporting solutions, optimizing data processes and enhancing reporting capabilities for diverse client projects.
Highlights
Developed and implemented scalable ETL workflows and automated reporting solutions utilizing Oracle, SQL Server, and Mobile Metrics, enhancing data processing efficiency.
Designed and built comprehensive dashboards and validation reports, optimizing report runtimes by over 60% and improving data accuracy.
Reduced ETL execution times by over 50% through strategic data partitioning and job parallelization, significantly improving data pipeline efficiency.
Implemented robust job orchestration with Control-M and advanced caching/temp table strategies to enhance data delivery speed and reliability.
Constructed universes in SAP BO IDT, managing semantic layer development and scheduling to ensure consistent data definitions and reporting integrity.
Hyderabad, Telangana, India
→
Summary
Built foundational ETL workflows and integrated reporting tools, contributing significantly to the initial setup and operationalization of BI systems.
Highlights
Developed and implemented foundational ETL workflows and integrated various reporting tools, contributing to the initial setup of robust BI systems.
Provided critical support for client projects, ensuring seamless operations and successful transitions following the company's acquisition by Accion Labs.
Assisted in the design and deployment of initial BI solutions, laying the groundwork for future data analytics capabilities.
Awards
Employee of the Quarter
Awarded By
Trantor
Awarded for exceptional performance and dedication during the first quarter of 2024.
Marvel Award
Awarded By
Accion Labs
Recognized for outstanding contributions and performance within the organization.
Skills
BI & Visualization
Domo, Tableau, Power BI, SAP BO, Mobile Metrics.
Databases & SQL
BigQuery, Oracle, SQL Server, MySQL.
Cloud & Pipelines
GCP (BigQuery, Cloud Storage, Dataform/Composer), AWS (EC2), Snowflake, Control-M, Custom SQL Pipelines.
Programming & Automation
SQL, Python (pandas, numpy), Shell Scripting, VBA.
Collaboration Tools
Git, Bitbucket, JIRA.
Methods
KPI Design, Stakeholder Management, Agile/Scrum, UAT, Production Support.