Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rajkumar Konda

Toronto,CA

Summary

Driven and curious data analyst with 8 plus years of experience working with data analysis, design, and delivery experience. Identify, analyze, and interpret trends or patterns in complex data sets, SQL, Tableau, and several more. With a passion for creative innovation and solving complex problems, I am eager to further implement my skills and improve my data analysis experience with a detail-driven data team.

Overview

11
11
years of professional experience

Work History

Data Analyst

Pharmasave
09.2020 - Current
  • Design and implement statistical / predictive models and algorithms utilizing diverse sources of data
  • Utilize analytical applications to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings providing value to business
  • Performed in depth analysis of data from different data source & prepared weekly, biweekly, monthly detailed reports using MS Excel advanced features like Pivot table, Vlookup, Name Manager etc
  • And complex SQL queries
  • Create various technical artifacts such as business process diagrams/narratives, Functional and Technical Document, Report development document, Data Dictionary, Business Rules Document, and Wireframes
  • Record and modify customer information within the database
  • Keeping the track record of all the work using SQL and MS Excel
  • Creating Pivots, charts and presenting them to the management on daily, weekly and monthly basis
  • Reformatted the data and inserted the reformatted data into staging table, performed data cleansing and data type conversions and then loaded into destination table
  • Involved in implementation of data privacy solutions
  • Collaborate with key stakeholders and teams to stay updated on new products and services
  • Offer support and solutions to customers in accordance with the company's customer service policies
  • Created database tables with various constraints including primary key, foreign key, etc
  • Participates in the development and execution of analytics roadmap strategies, business cases, cost-benefit analysis and benefits realization deliverables
  • Create various technical artifacts such as business process diagrams/narratives, Functional and Technical Document, Report development document, Data Dictionary, Business Rules Document, and Wireframes

Data Analyst

Walmart
02.2016 - 08.2020
  • Electronic Shelf Labels (ESL) are the labels in the Walmart supermarket that makes the price adjustments automatically
  • Data is extracted from50 locations on daily basis to implement this
  • Design, evaluate, recommend and approve the changes of forms and reports
  • Identify and define client requirements for the purpose of building a suitable solution to meet the business needs
  • Collecting and interpreting data - building Complex SQL Queries to join the different source tables based on the Entity relationship diagram, getting the desired results for analysis
  • Designing and implementing data models that enable efficient querying and analysis of data using Power BI
  • Extensive knowledge in various reporting objects like facts, attributes, hierarchies, filters, prompts, calculated fields, sets, groups, parameters etc
  • In Tableau
  • Helping to develop oversight and governance strategies of report generation and standardization
  • Used JIRA to assign, track, report and audit the issues in the application
  • Used confluence to upload the technical specification document for the functionality developed in the application
  • Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs
  • Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by32%
  • Developed and owned reporting for a nationwide retention program with SQL, and Excel, saving ~90 hours of monthly labor

Data Analyst

Zen3 Solutions | A Tech Mahindra Company
10.2013 - 01.2016
  • Assisted the business in judging the possibility of entering an agreement, undertaking a project, purchasing or advertising assets or planning growth etc
  • Help the business take sound decision
  • Maintained the research database, renew and improve it from time to time and make sure safe storage of data
  • Arranged analysis reports and be accountable to answer any queries, complaints or proposal
  • Ensure deliverables are prepared to satisfy the project requirements cost and schedule
  • Assisted the association in performing data compiling, mining and psychoanalysis required to assess the given data
  • Carry out analysis of the given data and draw correct inferences, in keeping the objectives of the analysis
  • Calculate the specified problem, state of affairs and crisis; examine for solutions using data analysis practices and arrange analysis reports
  • Understanding Functional requirement document
  • Worked on different tasks on UHRS in Relevance to3 point judgment
  • Given training to the staff members on the relevance project and new systems implemented
  • Gather data necessary to accomplish analysis from a number of sources, accumulate it together in prearranged format and enter the data in several data analysis tool
  • Involvement in Test Design includes Test Cases preparation and Test data

Education

Post-Graduation diploma - Management Studies

London School

Skills

  • Power BI
  • Trend Data Analysis & Reporting
  • Tableau
  • Data Warehousing
  • Data Visualization
  • Microsoft Excel
  • GitHub & bitbucket
  • SQL
  • Data Validation
  • Python
  • Data Exploration
  • Data Preparation Jira and Confluence Agile (Scrum) Competencies
  • Data Manipulation
  • Data visualization and presentations
  • Data analysis
  • Python programming
  • Excel functions
  • Analytical problem solving
  • Statistical analysis
  • Tableau software
  • Database programming and SQL
  • ETL processes

Timeline

Data Analyst

Pharmasave
09.2020 - Current

Data Analyst

Walmart
02.2016 - 08.2020

Data Analyst

Zen3 Solutions | A Tech Mahindra Company
10.2013 - 01.2016

Post-Graduation diploma - Management Studies

London School

Similar Profiles

CREATE PROFILE
Rajkumar Konda