Data Analyst

ALEKYA POPURI

Email: ****@******************.***

Contact No: 469-***-****

SUMMARY

Around 8 years of data domain experience driving Business impact through data-driven insights with Data Analysis, Data Modelling, Reporting, Data Migration, and Business Intelligence domain.

Expertise in data analysis using Databricks and data engineering effectiveness through making recommendations based on data findings. Highly skilled in Data Validation, Data Cleansing, and Data Verification

Proficient in using Pandas, NumPy, Seaborn, SciPy, Matplotlib, and Scikit-learn in Python. Expertise in Python and its respective libraries. Hands-on experience in Power BI and Tableau for creating dashboards for end client users.

Expertise in Database projects and applications working with Microsoft SQL Server and writing SQL statements.

Proficient in developing advanced SQL queries, queries performance tuning, and data reports generation.

Good understanding of Azure Cloud Services (PaaS, SaaS, & IaaS), SQL Azure, Data Factory, Application Insights, and Azure Monitoring, Good experience in working with large data sets of structured and unstructured data.

Hands-on with Data Warehouse, Integration, Reporting, Analysis Services (SSIS, SSRS, SSAS), and Power BI.

Proficient in prominent Business Intelligence tools like Tableau and Power BI for data visualizations that obtain deep insights into large datasets.

Excellent team player with demonstrated experience of working collaboratively with all levels of staff to ensure successful implementation of assignments.

Meticulous and logical data and Business professional with proven ability to communicate with both technical professionals and end-users to identify and translate into business systems requirements for product delivery using Agile methodology.

TECHNICAL SKILLS

Programming Languages: Python (Numpy, Pandas, Matplotlib, Sklearn, Seaborn), R (sorting, dplyr, plots), SQL, HTML

Databases: MySQL, Microsoft SQL Server, Oracle, PostgreSQL

Data Visualization/Reporting: Tableau, Microsoft Power BI, Microsoft Excel (Pivot Tables, Pivot Charts, V lookups), SAS

Tools: JIRA, Confluence, MS Office, Git, Jupyter Reports, Trello, Lucid Chart, Balsamiq, Microsoft Project Big Data/Cloud: MS Azure and Amazon Web Services (IAM, S3, Lambda, DynamoDB, RedShift), Databricks Methodologies: Agile/Scrum/ Kanban methodology, SDLC, Waterfall methodology

PROFESSIONAL EXPERIENCE

Data Analyst New York, US

National Grid USA, Boston, MA Aug 2020- Present

Environment: Python3.7, SQL, Power BI, Tableau, Databricks, Postman, ETL, Data Visualization

Understanding and analyzing the real estate data for buying and selling of the property. Written Python program for pulling the data from the database or feed file and mapping the real estate data in a mapper document. The Mapping specification helps to identify the source, destination, transformations, mandatory/non-mandatory fields

Performed data analysis on large relational datasets using optimized diverse SQL queries, such as DML and DDL statements including various joins, group functions, string functions, and ranking functions.

Used Databricks to analyze the real estate to create the mapper for MLS, resulting in 79% of data accuracy.

Summarize, aggregate, and share data in easy to consume formats for internal or external audiences, to aid data quality improvements, product and process improvements, and measurement of data quality goals.

Data collection and extraction from multiple sources, performed data cleansing, filtration, and calculation in Microsoft Excel, formulated data analysis of 1M+ rows of datasets.

Involved in development of deliverables and roadmaps to advance the migration of on-premises Traditional Database systems into Snowflake cloud Datawarehouse in Azure cloud environment.

Performed Functional and test analysis for real estate data. Build the high-level prod DQ metrics dashboard in Tableau for checking the consistency and accuracy of data based on a few metrics.

Served as a subject matter expert and escalation point on data quality issues reported by frontline customer teams

Involved in requirement gathering, technical design, development, and testing.

Involved in analyzing the new business requirements requested by the client, developing, and integrating into an application. Gather client requirements using JIRA and solely responsible to complete the same in the given time.

Expertise in the oral and visual communication of data and business insights to technical and non technical users.

Responsible for ETL (Extract, Transform, and Load) processes to bring data from multiple sources into a single warehouse environment.

Created the analytics dashboard showing buy/sell statistics meant for compass leadership using Power BI analytics and Tableau.

Data Analyst Hyderabad, India

Accenture Solutions Private, India Feb 2018 – July 2019

Environment: Python3.7, SQL, Web and Google Analytics

Collaborated with engineers, system analysts, and programmers regarding project capabilities and limitations to deliver optimal functionality.

Provided code maintenance and system upgrades to maximize performance.

Created Multiple Machine learning algorithms like KNN, Decision Tree, Random Forest, Logistic Regression for BMW client.

I have Predicted the customer Churn for 7 different countries (USA, Canada, Australia, Belgium, Italy,Switzerland, Netherlands) of BMW and achieved 80% accuracy.

Automated Power BI queries for creating different financial reports which compare orders/sales dynamically by period, quarterly and yearly.

I was part of product analytics, Behavioral analytics, Predictive analytics projects.

Automated the basic data cleansing steps using python scripts.

Performed EDA for Customer Based Military Models and developed Models for sentiment Analysis.

Provided Insights on Financial Data and automated Power Bi Reports on Financial Data for Future use.

Coordinated statistical data analysis, design and information flow.

Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

Automated Power BI reports for financials, network equipment, customer satisfaction across the teams in united states region.

Analyzing and forecasting the company budgets for future planning.

Participated in requirements meetings and data mapping sessions to understand business needs.

Data Analyst Indore, India

WebCraft IT Aug 2014 - Dec 2017

Environment: Python3.7, My SQL Server, Power BI, Jupyter, Excel, Jira

●Achieved ownership of a project after creating and optimizing Jupyter reports with Python & SQL queries to reduce the execution time by 60%. Created database schema with final dataset of more than 43 tables using SQL.

●Interacted with stakeholders, elicited requirements, analyzed data, reported results and provided 79% accuracy

●Built and executed backup recovery procedures for metrics reports resulting in 56% of accuracies

●Gathered and transformed various records coming from multiple sources and developed SQL queries to store desired parameters in the database Analyzed data operations using SQL, Microsoft Excel

●Key participant in all phases of the SDLC right from requirements gathering to translate strategy in operational plan

●Created tables and relationship between them, implemented CRUD operations using Git framework for specified data model. Performed A/B testing for code change requests thereby reducing the defect rate by 40%.

●Communicated with the stakeholders, conducted users’ interviews to and create an empathy map and personas.

●Analyzed data and prepared reports proactively for meetings and increased an efficiency of the workflow by 25%.

●Executed SCRUM (agile) master responsibilities utilizing JIRA for grooming user stories, backlog management.

●Redesigned fulfillment processes and protocols, saving company a minimum of $1.5 million, implemented a CRM process using MS Dynamics that reduced refunds by 32% resulting in a 10% decrease in the bounce rate.

●Developed crucial Functional Design Documents, detailed use case specifications, presentations and User Stories using JIRA, Confluence, Trello. While, created mockup design and wireframes by using balsamic software.

●Built metrics and business cases to improve customer experience by creating 10+ prototypes models.

●Researched and resolved issues regarding integrity of data flow into databases.

●Developed tables, views and materialized views using SQL.

●Compiled, evaluated and reviewed engineered data for internal system.

●Designed and developed schema data models.

●Created application interface for scrum masters to input the network data on daily basis using power apps.

EDUCATION

Jawaharlal Nehru Technological University, India

Bachelor of Technology

Contact this candidate