Kallempudi Jhansi Lakshmi

+1-336-***-**** • ad084b@r.postjobfree.com

Summary

With over 7 years of work experience, I am a data analyst having 2 years of experience with expertise and knowledge on transforming datasets into actionable items. Skilled in data extraction, cleaning, analysis, and visualization using programming languages and data analysis tools to highlight valuable information for decision-making. Adept at communicating findings to both technical and non-technical stakeholders.

Education

Masters in Computer Science

University of North Carolina Greensboro; Current GPA 3.25 December 2021

Masters in Technology Management, Supply Chain Management

University of Bridgeport; GPA 3.606 December 2017

Technical Acumen:

Big Data Tools

Hive, Hadoop HDFS, Apache Spark, Sqoop, Cloudera

Databases

Oracle, SQL Server

Development Methodologies

Agile Scrum, Waterfall

Languages

SQL, Python, Shell, PySpark

Reporting Tools

MS Office Excel, Tableau

Operating Systems

Windows, Linux, Unix

Professional Experience

Data Analyst 2021 – 2023

VtechInfo Inc, OH – State of Ohio - Medicaid

•Analyze the raw data from source systems and provide detailed documentation.

•Discuss with the Leads on the Business requirements to create data pipelines, profile the data and develop the solution using HIVE/Impala.

• Perform impact analysis on ETL jobs for requirements and enhancements.

•Create and update design documents, provide detailed description about workflows after every production release.

•Based on user needs, designed, built, tested, and maintained Tableau reports.

•Using Tableau, parameter-based reports, drill-down reports, and visualizations were created.

•To engage end users in the requirement gathering process, Tableau Guided Analytics was used to create Tableau Dashboards as a proof of concept (POC).

•Employed Tableau's conventional charts as well as extra tools like parameters, LODs, cross tables, bar charts, pie charts, donut charts, maps, line charts, scatter plots and filters, action drill-down filters, hierarchies, calculated fields, groups, and sets.

•Enhance and create adhoc SQL queries to load historical and incremental data.

•Create re-usable UNIX shell scripts for file archival, file validations and Hadoop workflow looping.

•Create re-usable framework for Audit Balance Control to capture Reconciliation, mapping parameters and variables, serves as single point of reference for workflows.

•Created HIVE tables and Impala views creation scripts for Dimension tables.

•Acquisitioned data from sources like csv and excel spreadsheets to manipulate the data using Python.

•Accomplished the data cleaning using functions like drop_duplicates, dropna, and fillna with knowledge on data preparation for modelling.

•Participate in meetings to continuously upgrade the Functional and technical expertise.

•Performance tuning of the long running ETL/ELT jobs by query tuning, creating partitions and adjusting the spark configuration parameters and other standard approaches.

•Continuously monitor the production data loads, fix the issues, and update the tracker document with the issues, in addition to identifying the performance issues.

•Mockup data to perform unit testing and capture result sets against the jobs developed in lower environment.

•Work with the change request teams to migrate the data from the lower environments.

Project Engineer 2012–2015

Wipro Technologies Limited Chennai, TN

Recognize the data's sources, models, and intended applications.

Create measurements and standards for data quality based on organizational needs.

Create and implement data validation tests to find discrepancies and anomalies.

Use data quality tools or automated testing frameworks (Python and shell scripting) to implement data quality tests.

Examine test findings and produce reports on data quality.

Examine design briefs and mockups to comprehend the desired UI behavior.

Manually test the buttons, menus, forms, and navigational elements of graphical user interfaces.

Check to see if the application's visual components adhere to the design and branding standards.

Test various browsers, devices, and screen resolutions to make sure they are compatible and responsive.

Record and report any UI-related bugs along with thorough instructions to reproduce the reported bugs.

Work together with developers and designers to address UI-related problems.

Engaged in usability testing to obtain user input.

Relevant Projects

Big Data Analytics,

Data Analysis, Categorization May 2020

•Researched, analyzed the given dataset to predict the target category taking other attributes into account.

Awards

Academic Merit Award from University of Bridgeport 2016-2017

Skills

Soft Skills: Communication, Analytical Skill, Problem Solving, Presentation and Interpersonal

Language: English fluent and professional level.

Contact this candidate