About
Aswanth Saranu is an experienced Business Intelligence Developer with over 9 years in the field, specializing in Looker, Tableau, OBIEE, Jaspersoft, and SQL. He has a proven track record in creating dynamic dashboards, optimizing data visualizations, and implementing security measures across platforms like Big Query and GCP. His recent roles include developing advanced LookML models, training teams, and enhancing data processing efficiency. With expertise in a wide array of BI tools and languages, Aswanth excels in delivering insightful reports, streamlining data workflows, and contributing to business growth through actionable data insights.
Aswanth Saranu is a highly skilled Business Intelligence Developer with over nine years of experience in data visualization, analytics, and business intelligence solutions, specializing in Looker, Tableau, OBIEE, Jaspersoft, SQL, and PL/SQL. Throughout his career, he has demonstrated expertise in designing and developing dashboards, reports, and data models to support business decision-making. As a Senior Looker Developer at Univision, he has played a key role in developing Growth Executive dashboards for the finance team using LookML models, cross-filter dashboards, and liquid variables for dynamic reporting. His proficiency extends to working with BigQuery to create a semantic layer over the info layer, implementing row-level and column-level security for data access. Prior to this, he worked as a Data Solution Engineer III at American Family Insurance, where he maintained and debugged LookML code, built user-friendly Explores, and implemented advanced visualizations, table calculations, and Looker expressions. His experience includes working with PDTs, table filters, and custom formatting to develop complex reports incorporating advanced conditional filters, KPIs, and interactive visual elements. At Flysoft, where he contributed to projects for clients such as the Crime Center, UBS, and Fox Studios, he gained extensive experience in Looker, Tableau, Jaspersoft, MySQL, AWS, and JIRA, leveraging these tools to create predictive analytics reports, interactive dashboards, and optimized data retrieval processes. His work at UBS involved migrating Tableau dashboards to Looker, embedding Jaspersoft reports into applications, and enhancing Jasper report generation processes to improve performance by 65%. His expertise in SQL and PL/SQL allowed him to manipulate large datasets, develop stored procedures, and implement data modeling solutions for operational and financial reporting. During his tenure at Fox Studios, he architected and optimized Tableau environments, implemented bulk data operations for warehouse modeling, and utilized PL/SQL features such as Ref Cursors, collections, and dynamic SQL to enhance database performance. Additionally, he served as a Tableau Developer at 3M, where he led a reporting development team, migrated over 150 transactional and financial reports from legacy Crystal/Jasper reports to Tableau, and implemented authentication and scheduling features to streamline reporting workflows. His ability to integrate various BI tools, optimize reporting structures, and develop interactive dashboards has significantly improved business operations and decision-making processes across different industries. With a Master’s degree in Computer Information Systems from the University of Central Missouri and a Bachelor’s degree in Engineering from Jawaharlal Nehru Technological University, India, he possesses a strong academic foundation that complements his extensive hands-on experience. His technical expertise spans multiple BI platforms, databases, and programming languages, including Oracle, PostgreSQL, MySQL, Java, and Python, which he leverages to create sophisticated data solutions. His commitment to continuous learning, problem-solving skills, and ability to collaborate with cross-functional teams make him an asset in the field of business intelligence and analytics.
Skills & Expertise
AWS
Predictive Analytics
Tableau
GCP
Power BI
OBIEE
Crystal Reports
SQL
PL/SQL
Python
Java
Oracle
Microsoft Excel
Data visualization and forecasting
MySQL
Business Intelligence
Data modeling
PostgreSQL
Snowflake
Jaspersoft
Looker
Big Query
Problem-Solving
Problem-Solving
T-SQL
Oracle 11g/12c
Looker 6.4
Oracle procedure Builder
Informatica Power Center 8.6.1
Analytics Solutions
LookML
BigQuery
Data Access Security
Data Retrieval Optimization
Reporting Workflows
Crystal
MySQL
Oracle
Informatica
Research Interests
Data Visualization
GCP
Information Systems
Modelling scripts
Business Intelligence
BigQuery
LookML
Data Retrieval Optimization
Warehouse Modeling
Business Decision Support
Interactive Dashboards
Connect With Me
Experience
SR Looker Developer
- • Conducted training sections to the several teams including business users on development and usage of looker/Looker studio. • Created Growth Executive dashboards for Finance team using Lookml Model, cross filter dashboards and liquid variables/templated filters for dynamic reporting using looker / looker studio. • Worked with 25 LookML Modelling scripts, looks (reports), and liquid variables/templated filters for dynamic reporting. • Created explores in looker to query data and done modeling in LookML. • Worked on Big query to create semantic layer over info layer to support the looker and looker studio Dashboards. • Implemented the Row level column level securities to the BQ tables and view to create security for data. • Loaded data from Greenplum to GCP Bass Project using antiunity and GCP services like cloud functions, cloud storage, pubsub, Big query.
Education
University of Central Missouri (UCM)
Jawaharlal Nehru Technological University, Anantapur
dd