Summary
Overview
Work History
Education
Skills
Timeline
Generic

Mahendra Talluri

Lewis Center,OH

Summary

I am a detail-oriented and analytical Data Analyst with 8 years of experience in interpreting complex datasets, generating actionable insights, and driving business decisions.Skilled in statistical analysis, data visualization, and data cleaning using tools like SQL, Python, R, Excel, and Tableau. Proven ability to collaborate with cross-functional teams to solve business challenges and optimize performance. Passionate about leveraging data to inform strategic decision-making and improve operational efficiency.

Overview

8
8
years of professional experience

Work History

Data Analyst

NiSource
Columbus, Ohio
03.2024 - Current
  • Elicited objectives using interviews, document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, and workflow analysis
  • Translated stakeholder goals (client and internal) into various documentation deliverables such as use cases, user stories, persona development, workflow/process diagrams, data flow/data model diagrams, functional documents, business requirements document
  • Designed data models, Built Queries for forecasting, generate reports, charts and created dashboards from multiple data sources using applications like Tableau, Power BI, Google Analytics
  • Designed, developed and established KPIs and success metrics for new systems and processes to track and measure
  • Analyzed the data on Teradata and build Tableau dashboards for the IM’s according to the requirement to make a track of Opportunities and parallelly cross check these on Salesforce along with Teradata, AWS Redshift, Snowflake data sources
  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments
  • Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction
  • Analyzed the data on Redshift, and built Tableau dashboards for Confidential Tradeshows as well built Spend Tracker dashboards to forecast
  • Worked Closely with the Risk Management, Finance Team regarding Requirements Gathering and provided the layouts of the dashboards to reconfirm
  • Lead QA and UAT to ensure the solution performs as designed and participate in client training to promote solution adaption
  • Used various sources to pull data into Power BI such as SQL Server
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Wrote calculated columns, measures queries in Power BI desktop for data analysis techniques
  • Explored data in a variety of ways and across multiple visualizations using Power BI
  • Created SQL stored procedures, triggers, cursors, tables and views, and other SQL joins and statements for applications
  • Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Spectra and Redshift & Snowflake
  • Created data blending in case of merging two different datasets using Tableau
  • Experience in Identifying Business problem and working for the analytic solutions to the given data problem
  • Experience in data cleansing for initial validations
  • Develop alerts and timed reports
  • Develop and manage Splunk applications
  • Manage existing application and create new applications (visual and non-visual)
  • Manage SPLUNK user accounts (create, delete, modify, etc.)
  • Created Dax Queries to generated computed columns in Power BI
  • Create data retention policies and perform index administration, maintenance and optimization
  • Collaborated in the development of End-to-End Validation of ALM
  • Test Plan, Testlab, Test Runs
  • Reviewing Validation deliverables such as Validation Plan, URS, TM, IQ, PQ, UAT, Vendor Reports, Computer System Risk Assessment, Periodic Review Report and Validation Summary Reports for Data Integrity compliance
  • Experience in creating the source to target mapping documents
  • Experience with Enterprise, Data Governance, and validate completeness of data lineage between the source through target systems
  • Extensively used APIs in data validations, used Postman for API related validations
  • Experience in Data profiling between the multiple source systems like, profiling the data, and Data Quality validations to find root causes of data related issues
  • Experience in exploratory data analysis
  • Experience with Data warehouse
  • Experience in working multiple data formats like Text
  • Created Database objects - tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement
  • Developed/Coded in Oracle Forms/Reports
  • Maintained PL/SQL Packages, Stored Procedures and Database Triggers
  • Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data using Java API scripting
  • Embedded Tableau reports/dashboards on to the external web pages
  • Extensively worked on data exploration, data cleaning methods
  • Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
  • Utilized advance features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once
  • Data collection and leveraging on data manipulation teams for required data
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting
  • Dashboard Visualization through Tableau BI application
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
  • Created Many TDE (Tableau Data Extract) for various Projects and Scheduled Refreshed on Tableau Server as per the Business needs
  • Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data
  • Hands-on development assisting users in creating and modifying worksheets
  • Gathered business requirements from the business users and documented the specifications
  • Implemented Star Schema to fit reporting, query and business analysis requirements
  • Created Derived metrics, Compound Metrics and Filters, Filter in a metric- for very complex reports
  • Involved in creating new Facts, Attributes and Attribute form expressions, Hierarchies as needed in the project
  • Created the design document, personalized the reports as per user requirements that included customizing and formatting
  • Created Intelligent cubes to reduce the database load and decrease the report execution by using the Cube Services
  • Developed Dashboards in various formats; tables, gauges and dials, for business analysis
  • Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets both in flash and Interactive modes
  • Performed Tableau administration tasks like creation of users, groups, projects, workbooks and permission sets for Tableau server logons and security checks
  • Assisted with best practices during implementation and integration of Tableau Platform
  • Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics
  • Provided various management levels with reports, analysis time series graphs and Bar Graphs using Micro Strategy Web
  • Involved in moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window
  • Involved in Administration tasks like creating users, assigning privileges, caching, specifying Query Governing Thresholds, and Report optimization
  • SQL, Python, Agile, AWS, Tableau, Jira, Teradata, SAS, Data Modelling, ETL Tools

Data Analyst

Capital One
McLean, Vir
11.2022 - 01.2024
  • Implemented Data Exploration to analyze patterns and to select features using Python SciPy.
  • Built Factor Analysis and Cluster Analysis models using Python SciPy to classify customers into different target groups.
  • Designed an A/B experiment for testing the business performance of the new recommendation system.
  • Supported MapReduce Programs running on the cluster.
  • Evaluated business requirements and prepared detailed specifications that follow project guidelines required to develop written programs.
  • Participated in Data Acquisition with Data Engineer team to extract historical and real-time data by using Hadoop MapReduce and HDFS.
  • Communicated and presented default customers profiles along with reports using Python and Tableau, analytical results and strategic implications to senior management for strategic decision making Developed scripts in Python to automate the customer query addressable system using python which decreased the time for solving the query of the customer by 45% * Collaborated with other functional teams across the Risk and Non-Risk groups to use standard methodologies and ensure a positive customer experience throughout the customer journey.
  • Developed multiple MapReduce jobs in java for data cleaning and pre-processing
  • Extracted data from Twitter using Java and Twitter API. Parsed JSON-formatted Twitter data and uploaded it to the database.
  • Developed Hive queries for analysis, and exported the result set from Hive to MySQL using Sqoop after processing the data.
  • Created HBase tables to store various data formats of data coming from different portfolios.
  • Utilize SQL, Excel and several Marketing/Web Analytics tools (Google Analytics, Bing Ads, AdWords, AdSense, Criteo, Smartly, SurveyMonkey, and Mailchimp) in order to complete business & marketing analysis and assessment.
  • Used Git 2.x for version control with Data Engineer team and Data Scientists colleagues.
  • Used Agile methodology and SCRUM process for project developing.
  • KT with the client to understand their various Data Management systems and understanding the data.
  • Creating meta-data and data dictionary for the future data use/ data refresh of the same client.

Data Analyst

R Squared Global
Hyderabad, India
06.2019 - 01.2021
  • Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Utilized advance features of Tableau software like to link data from di erent connections together on one dashboard and to lter data in multiple views at once
  • Data collection and leveraging on data manipulation teams for required data.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting
  • Dashboard Visualization through Tableau BI application. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
  • Created Many TDE (Tableau Data Extract) for various Projects and Scheduled Refreshed on Tableau Server as per the Business needs
  • Effectively used data blending, lters, quick lters, data source lters, global lters, context lters, actions, Hierarchies feature in tableau
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Data Analyst

Tricc Professional
Visakhaatnam, India
05.2017 - 05.2019
  • Gathered business requirements from the business users and documented the specifications.
  • Implemented Star Schema to reporting, query and business analysis requirements.
  • Created Derived metrics, Compound Metrics and Filters, Filter in a metric- for very complex reports.
  • Involved in creating new Facts, Attributes and Attribute form expressions, Hierarchies as needed in the project
  • Created the design document, personalized the reports as per user requirements that included customizing and formatting
  • Created Intelligent cubes to reduce the database load and decrease the report execution by using the Cube Services.
  • Developed Dashboards in various formats; tables, gauges and dials, for business analysis.
  • Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets both in ash and Interactive modes.
  • Performed Tableau administration tasks like creation of users, groups, projects, workbooks and permission sets for Tableau server logons and security checks.
  • Assisted with best practices during implementation and integration of Tableau Platform.
  • Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re- used to build any number of metrics.
  • Provided various management levels with reports, analysis time series graphs and Bar Graphs using Micro Strategy Web.

Education

Master of Science - Management Information Systems

Cleveland State University
Cleveland, OH
08-2022

Master of Science - Computer Science

Andhra University
India
04-2017

Skills

  • SQL
  • Python
  • Agile
  • AWS
  • Tableau
  • Jira
  • Teradata
  • SAS
  • Data Modelling
  • ETL Tools
  • Machine learning
  • Data visualization
  • Visualization software

Timeline

Data Analyst

NiSource
03.2024 - Current

Data Analyst

Capital One
11.2022 - 01.2024

Data Analyst

R Squared Global
06.2019 - 01.2021

Data Analyst

Tricc Professional
05.2017 - 05.2019

Master of Science - Management Information Systems

Cleveland State University

Master of Science - Computer Science

Andhra University

Similar Profiles

  • Kurt Sangster

    Kurt SangsterKurt Sangster

    Director Major Projects at NiSourceDirector Major Projects at NiSource

    View Profile
  • Alyssa LeNoir

    Alyssa LeNoirAlyssa LeNoir

    IVR Product Owner at NisourceIVR Product Owner at Nisource

    View Profile
  • Shane Wilson

    Shane WilsonShane Wilson

    Field Technician at NiSourceField Technician at NiSource

    View Profile
Mahendra Talluri