Dheeraj Pallela

• Collaborated with a renowned Japanese automobile manufacturer.
• Managed VehicleLinq project targeting financial insights related to used and new vehicles.
• Migrated existing Hyperion Interactive reports to Tableau.
• Analyzed current OBIEE and IR reports for improvements.
• Integrated various data sources including Snowflake, DB2 and Oracle.
• Utilized updated Snowflake queries to construct custom SQL.
• Led requirement gathering and conducted thorough data analysis.
• Created dynamic dashboards to facilitate data visualization.
• Performed dashboard enhancements.
• Developed Drill through functionality enhancing dashboard interactivity.
• Developed data models in Tableau according to specifications.
• Addressed various software defects.
• Developed and utilized varied filters including Relative Date, Date Range, and Context filters.
• Specialized in various visualizations including Tree maps, Heat maps, Bar charts, Line graphs, and Histograms.
• Developed dashboards and reports leveraging Tableau Desktop, Tableau Server, and Snowflake.
• Optimized database query performance within Tableau Server and Desktop environments.
• Delivered technical assistance for enhancing dashboards and reports functionality.
• Reviewed codebase to identify and resolve errors.
• Utilized Agile methodologies to accelerate development lifecycle from prototyping to testing and final implementation.

Project 1:

• Developed project for aggregating insights from chat history.
• Developed dashboards for efficient data management.
• Utilized Tableau Web Data Connector for integration with various APIs.
• Optimized integration of MongoDB data using BI Connector.
• Facilitated collection of project requirements to identify needed resources.
• Implemented Date Range Filters for retrieving the chat history on a particular date
• Deployed dashboards onto Tableau Server.
• Created advanced filters enhancing store-based lookup efficiency.
• Conducted unit tests on data.
• Implemented drill-through functionality enhancing dashboard interactivity.
• Operated within Agile development frameworks and maintained effective communications.

Project 2:

• Lake Asset is a domain which provides required data for all other domains
• It pulls data from different sources like REST API's, Database, Active Directory, shared folder etc
• And push it to Big Query and then to CloudSQL
• Dataflow is a Maven based application that is responsible to push data from one source to another mostly it is from Big Query to CloudSQL
• Developed and Designed Dataflow jobs as per requirements
• Monitoring the Dataflow jobs on daily basis
• Developed and designed sheets and dashboards for gathering the count of records for all the necessary tables in a particular Database
• Published the dashboards to Tableau Server
• Integrated the Count Metrics Dashboard with slack for daily updates of data that loaded into particular table
• Worked on bug fixing and enhancements
• Executed test case development for software testing.
• Collaborated in Agile development environments while ensuring seamless communication.
• Environments: Google Cloud Platform, Java, Apache Beam, Dataflow, Concourse, Tableau and MYSQL