Home

Dhedeepya Panjala - Sr. Business intelligence analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: Hybrid

Visa: H1B

Dhedeepya Panjala Sr. Business intelligence analyst [email protected] Dallas, TX Hybrid H1B PROFESSIONAL SUMMARY Sr. Business intelligence analyst with over 5+ years of expertise in analyzing data sets, converting raw data into measurable information, and resolving related issues. Throughout my career, I have successfully managed both internal and external projects, working with data from Google Sheets to Big-query and utilizing data modeling techniques to create dashboards and visualizations for various business platforms, including Marketing, Sales, Learning, and Business. Worked in helping my company transfer from Tableau to Looker from start to finish. My achievements in previous roles speak for themselves. I created dashboards that were presented by Google at NEXT 19 and NEXT 20, and Slack uses the sales dashboard I developed daily to track performance. At Acxiom, I implemented the Hub and Spoke methodology to efficiently reuse dashboards without manual work and time-consuming processes. Overall, my expertise, experience, and achievements make me an excellent candidate for any business intelligence analyst role. CORE COMPETENCIES / AREAS OF EXPERTISE Data Analytics: Looker | Tableau | Google looker studio | DOMO | Power BI | Google analytics Data and Project Management tools: Github | Sharepoint | Servicenow | Jira | Trello | Drift | Tableau Prep | Click-up | Lucidchart | Crystal reports | Excel reporting | Google Big-query | Snowflake | Confluence Programming languages: SQL | Python | Lookml | HTML | CSS | SVN PROFESSIONAL EXPERIENCE Acxiom Sr Business Intelligence Analyst Jan 2021 - Present Experienced in designing, installing, configuring, deploying, and tuning BI platforms, tools, and analytic servers. Proficient in SQL and relational and multidimensional databases, including schema design. Handle day-to-day data analysis, visualization, and reporting requirements. Collaborate and coordinate with internal teams for various data needs. Created 20+ dashboards, 15+ projects, 40+ views, and 90+ looks using Looker and Tableau. Worked directly with clients, gathering data, providing dashboard sketches using Lucidchart, and creating custom visualizations in Looker. Experienced in complex dashboard report creation, data analytics, and visualization solutions using Looker. Skilled in creating Okta verification for Looker user access and managing tables in Google BigQuery and Snowflake. Developed logical tables, columns, dimensional hierarchies, and level-based measures for sophisticated data analysis. Slack Business Intelligence Analyst June 2020 December 2020 Experienced in data ingestion from multiple sources using Looker and migrating legacy visualizations to Looker Looks and Dashboards. Proficient in SQL, including Stored Procedures, Dynamic SQL, Joins, and aggregation, ensuring efficient implementation of Looker Best Practices. Design and develop Looker-based solutions for both external and internal stakeholders, leveraging SQL and relational and multidimensional database expertise. Responsible for designing, building, and supporting data warehouse components, including ETL processes, databases, reports, and reporting environments. Automate ETL processes with error and reconciliation handling. Proficient in Data Visualization Tools such as Tableau, Looker, and Tableau Server, creating impactful visualizations to facilitate business understanding of datasets. Cerated actions in Experience in creating Derived tables and visualizations for improved data comprehension, along with working with Snowflake and GitHub. Strong troubleshooting abilities to resolve data issues and effectively liaise with the Data Engineering team to improve data usability. Google Data Analyst November 2018 June 2020 Experienced Looker expert specializing in creating comprehensive reports and visualizations to support Marketing activities. Conduct data trend research to generate marketing ideas and analyze competitive market strategies using Google Cloud Platform user participation data. Proficient in maintaining and updating Looker, databases, dashboards, and systems. Developed around 20 dashboards and over 100 looks in Looker for internal and external stakeholders. Provide technical support for existing Looker reports and dashboards in addition to BigQuery. Review Google documentation to ensure accurate reporting solutions. Utilize Looker, Google Sheets, Google Documents, and Google Analytics for reporting on labs and quests related to marketing activities. Expertise in SQL and BigQuery for creating derived tables tailored to project requirements and handling Big Data transformation. Spro Systems Inc. Data Analyst August 2018 November 2018 Regularly test SQL queries to optimize database performance, addressing any issues promptly to prevent customer impact. Proficient in testing and verifying backend database tables using SQL Queries. Contribute to data and requirement analysis using Looker, Google Sheets, and Google Analytics tools for project needs. Skilled in writing LookML SQL queries to create dimensions, views, and measures. Create looks and dashboards using Looker for various clients. Experienced in User Acceptance Testing, Smoke Testing, Regression Testing, and Functional Testing. Demonstrate leadership and teamwork skills, capable of accomplishing tasks independently with strong analytical and problem-solving abilities in business process mapping and analysis. Dominion Enterprises Data Analyst April 2018 June 2018 Experienced in preparing, manipulating, and managing extensive databases for research purposes, presenting results through tables, graphs, fact sheets, and written reports. Proficient in OAuth, Okta/SAML for secure data access and user authentication. Created Crystal Report templates and provided training and assistance to team members in using Crystal Reports. Advanced data analysis and reporting skills using SQL Server Data Tool (SSRS) and Tableau Desktop. Developed various reports in Tableau, including dashboards, charts/graphs, drilldowns, drill-through, sub-reports, and dynamic reports. Designed and developed ad hoc reports for different business teams using Excel, Google Docs, Salesforce, and Freshdesk. EDUCATION University of Mary Hardin Baylor - Belton, Texas Master of Science in Information Systems Aug 2016 Dec 2017 Keywords: business intelligence active directory Texas