K C Krishna Email & Phone Number

Bolingbrook, Illinois, United States

• Analyzed large amounts of Warranty claim data (~100,000 claims) to identify trends and find patterns, signals and hidden stories within data.• Optimized critical warranty and extended service contract businesses reducing warranty costs by ~10%. • Utilized Tableau and Adobe Analytics extensively to track and evaluate campaign metrics.• Gather insights and inform campaign strategies to the Business Teams.• Provided insights and recommendations based on data analysis to improve digital marketing strategies and website effectiveness.• Conducted A/B testing and analyzed data to optimize website performance and user experience.• Designed and customized dashboard layouts, charts, and graphs to meet specific business requirements and user needs.• Implemented and managed web analytics tracking solutions using Google Tag Manager (GTM) to collect and analyze user interaction data across digital properties.• Developed data pipelines and ETL processes to ingest, clean, and transform data from various sources into Big Query.• Analyzed the claim comments data and proposed use cases for Natural Language Processing to improving warranty business area.• Analyzed claim data and came up with claim scoring, dealer scoring to optimize the business rules and reduce warranty costs.• Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.• Leveraged text, charts and graphs to communicate findings in understandable format.• Interpreted business questions and collaborated with engineering teams to identify data sources.• Created and automated data visualizations to present insights and tell compelling stories.• Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.• Optimized data access and storage to improve performance of analytics systems.

Hyderabad, Telangana, India

• Examined data from web traffic, mobile app usage, marketing campaigns, and other sources to provide insights into RW's business performance and customer behaviour.• Created cross-channel dashboards in Tableau for 150+ non-profit clients; boosted donations by 80% within the first month.• Identified opportunities for improvement through analysis of key metrics and KPIs related to user acquisition, retention, and monetization by supervising 10+ cross-functional teams.• Developed workflow for data transitions by educating 40+ HNIs on data flows in DOMO and Big Query.• Created and implemented a data warehouse for storing, processing, and analysing large amounts of structured and unstructured data from weblogs, transactional systems, and 40+ other sources.• Designed an Extract-Transform-Load process to load 200TB of data into a data warehouse using SQL Server Integration Services (SSIS).• Optimized ETL processes using Pig Scripting Language (Pig Latin), which improved reporting speed by 70% in the first year of implementation.• Generated Data Dictionaries, reports, LDMs, PDMs • Worked on Data-Integration, Data Mapping, Data Profiling, and Data Warehouse access using SQL, ETL process. • Analyzing the existing mapping logic to determine reusability of the code.• Working with Teradata in a multi megabytes environment.• Performing Source System Analysis (SSA) to identify the source data that needs to be moved into the target tables.

Hyderabad, Telangana, India

• Produced monthly reports using advanced Excel spreadsheet functions.• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.• Managed campaigns on media platforms such as Meta, TikTok, and Pinterest, optimizing performance and ensuring alignment with client objectives.• Utilized Google Sheets for data management, analysis, and reporting, facilitating efficient collaboration and decision-making processes.• Created custom templates and reports in Google Sheets to standardize data collection and reporting processes across teams.• Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.• Participated in requirements meetings to understand business needs.• Analyzed transactions to build logical business intelligence model for real-time reporting needs.• Collaborated with business-unit leaders to identify and prioritize problems.• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.• Working with reverse engineer Data Model from Database instance and Scripts.• Working in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.• Providing data structures optimized for information entry and retrieval.• Integrating disparate data models into coherent enterprise data models.• Creating Mapping Parameters, Session parameters, Mapping Variables and Session Variables.• Involved in preparing Logical Data Models/Physical Data Models.• Identifying source systems, their connectivity, related tables and fields and ensure data suitably for mapping.