Kalyan Malla

Contact Number: +1-814-***-****

Email ID: ad0q3k@r.postjobfree.com

PROFESSIONAL SUMMARY:

•Over 5+ years of professional experience in data analysis, business intelligence, advanced analytics,, measuring and tracking KPI’s, building ETL workflows and building self-serve dashboards

•Extensive experience in leveraging data to deliver actionable insights and deliver results to improve business performance.

•Proficient with various cloud services such as AWS and Google Cloud Platform; Extensively used AWS Athena, Google BigQuery and Snowflake to prepare, pull and analyze data at scale.

•Expertise in building complex and efficient SQL queries by using joins, subqueries etc. on various database systems including Oracle, MySQL and Big data systems such as Hive/Impala

•Hands on experience with Python and associated data analytics libraries in analyzing data and sharing insights with the broader teams via Jupyter notebooks.

•Expertise in reviewing and interpreting BI requirements, analyzing data and developing production level dashboards & reports.

•Built several automated, self-serve dashboards by using Tableau and publishing them onto Tableau Server

•Experience with Looker and Google data studio in building several foundational dashboards.

•Expertise in using tools such as Git/Bitbucket, JIRA/Confluence for code deployment as well as process documentation.

•Expertise in interacting with stakeholders and business groups to identify business requirements and achieve project goals and having strong interpersonal and organizational skills.

•Implementation of data pipelines that support the CI/CD process

•Proven ability to contribute positively to a fast-paced environment with effective communication, sense of ownership, cross functional collaboration, work with key stakeholders to solve their business problems by driving data driven business decisions.

TECHNICAL SKILLS

Analytics / Business Intelligence Tools

SQL, HiveQL, Tableau, Looker, Alteryx, Excel, Google Data Studio

Databases & ETL

Teradata, MySQL, PostgreSQL, BigQuery, Redshift, SQL Server, Oracle, Snowflake

Cloud Services

Google Cloud and AWS

Programming

SQL, Python (Jupyter Notebooks) and R

Version/Issue/Process Control

Git/Bitbucket, GitHub, JIRA/Document

Functional Skills

Business Analytics, Data visualization, ArcGIS, KPI formulation and development, CLI tools.

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Prudential Financial, Remote-TX

March 2022 - Present

Responsibilities:

●Responsible for end-to-end delivery of reports, dashboards and data products including gathering requirements, working closely with data engineers and data governance teams.

●Analytics liaison between business and data engineering teams to drive results and enhanced value through improved delivery of impactful analytic insights, reports and dashboards, data visualizations.

●Collaborated with stakeholders across the organization to identify, define and document standard KPIs and metrics, build and validate reports and dashboards to actively monitor and track business performance.

●Presented key findings in insightful documents and decks to assist top management in planning and strategizing.

●Supervised multiple projects concurrently as a liaison; identified bottlenecks and helped reduce turnaround by 40%

●Identified data quality issues in our data and worked with engineering and product teams to improve data quality.

●Spearheaded data validation on production datasets using advanced SQL queries to improve the data accuracy and reduce query run-time.

●Designed Tableau dashboards containing filters, URL, and highlighting actions on sheets with calculated columns derived from complex expressions including LOD.

●Created several Tableau dashboards to visualize client growth and provide insights for decision making and provided strategic recommendations to other teams in a timely manner.

●Integrated Tableau with different data sources and scraped large volumes of data using data blending, joins and unions.

●Wrote complex SQL queries on Google BigQuery and built ETL pipelines in collaboration with data engineering team for querying millions of records and improved user experience visualizing dashboards.

●Developed proof of concepts by creating dashboards with the most powerful features of Tableau and reviewed the data statistics with product owners.

Senior Data Analyst

MRJ Technologies

Hyderabad, India

Sept 2019 - July 2021

Responsibilities:

•Built data pipeline for Sales Performance Dashboard, an external facing tool that provides sales teams’ yearly evaluation for promotions and solve 100s of data questions using automated troubleshooting dashboard.

•Partnered with cross-functional teams to identify relevant metrics and formulated goal-specific KPIs to measure growth.

•Analyzed datasets for insights which resulted in incremental subscriber growth and reduced payment delinquencies.

•Wrote complex SQL scripts on AWS Athena to retrieve data from multiple sources and formulated business logic to simplify reporting.

•Monitored ETL pipelines effectively while resolving data and environmental issues, ensuring integrity and accuracy.

•Provided analytical frameworks and insights to support strategic decisions.

•Built rigorous tools that define success metrics and track initiative performance on a weekly/monthly basis

•Provided access to data through dashboards and other analytical tools to empower business stakeholders through self-service.

•Automated insights through alerting and anomaly detection

•Provided recommendations supported by thorough research and analysis to increase financial performance across key business areas.

•Presented findings and recommendations to stakeholders and leadership teams.

•Prepared and organized Finance metrics, reporting, and ad-hoc data to support the business needs.

Data Analyst

Sapphire Software Solutions

Hyderabad, India

Jan 2017 - Aug 2019

Responsibilities:

•Involved in extracting data from multiple sources such as SQL Server, DB2, and excel by using SQL in toad analysis, and VBA to meet business requirements.

•Performed data analysis including, data access, data structures, data manipulation, databases, logical database design and translated technical information into clear, readable business requirements documents and/or user stories to be used by technical and non-technical personnel.

•Developed and maintained a tracking system/database in Microsoft Excel (using pivot tables, Vlookups, etc) to identify trends and increase the efficiency of high-level charge analysis and pricing projects.

•Supported debugging, troubleshooting of production issues and pre-processing of uncleaned raw data.

•Performed ad-hoc and back-of-the-envelope analyses in SQL and Excel to provide actionable insights to stakeholders.

•Maintained dimensional models to allow efficient data retrieval and self-service reporting across various user groups.

Contact this candidate