Data Analysis Business Intelligence
Resume:
SUMMARY
Dheeraj Mahanidhi Beerelly
Over 3+ years of industry experience in Data Analysis, with a solid understanding of Data Modeling, Data Warehouse/Data Mart Design, ETL, and Client/Server applications. Proficient in data analysis, data profiling, and data validation, including complex SQL data manipulation and cleansing across various source systems. Skilled in using Excel and MS Access for data dumping, analysis, and reporting, including advanced techniques such as Pivot Tables and VBA macros. Strong background in Business Intelligence (BI), including experience with SAP Business Objects and Webi reports, as well as testing BI reports generated by tools like Cognos and Business Objects. Excellent documentation and project management skills, including preparing project documentation, tracking project status, and creating various artifacts such as data mapping and analysis documents. SKILLS
Language: Python, R, SQL, Bash
ETL Tools: SSIS, Azure Data Factory (ADF)
Packages: Numpy, Pandas, Scikit-learn, TensorFlow, Matplotlib, Seaborn, P lotly,NLTK
Cloud: AWS (EC2, S3, RDS RedShift, EMR), Google Cloud (Big Query, Kubernetes)
Databases: MySQL, PostgreSQL, MS SQL Server, MongoDB, Hive, Presto, AWS RDS, AWS Redshift, AWS Redis, Big Query
Statistical Packages & Data mining Algorithms: SPSS Modeler & Statistics, KNN, Regression Analysis, Time series PROFESSIONAL EXPERIENCE
forecasting, C&R Tree, Decision Tree, K-Means, Neural nets, Cluster analysis and Association rules.
Machine Learning tools & Libraries: Pandas, NumPy, SciPy, Matplotlib, Scikit-learn, Plotly, SpaCy, Dplyr, Ggplot2, Shiny, Mlr, tidyr, plotly
Bigdata Platform: Azure Data Factory (ADF)
Tools: Tableau, Hadoop, Hive, Apache Airflow, Apache Spark, F lask, Apache Kafka, Jupyter Notebook, Excel, Jira, Git, Docker, Kubernetes
Verizon Wireless Systems Sep 2023 to Current
Data Analyst
Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
Created high-level design documents for integrating over 10 fact and dimension tables in AWS Data Lake, which enhanced data integration and reporting accuracy, resulting in a 25% reduction in data processing errors.
Built diverse chart types and interactive visualizations in Tableau, such as Crosstabs, Heat Maps, Pie Charts, Line Charts, Gantt Charts, and Scatter Plots to support various business needs.
Built and managed ETL pipelines to retrieve data from NoSQL databases and load aggregated data into analytical platforms.
Utilized big data tools such as Hadoop, HDFS, Hive, and Spark for data storage and processing, and developed Python scripts with Pandas and Apache Airflow for data validation and cleaning. Coforge Aug 2019 to Nov 2021
Data Analyst
Performed data analysis to enhance user experience and optimize retention, utilizing MySQL to track metrics like retention rate and daily active users.
Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.
Developed and presented interactive dashboards in Tableau, integrating data from MS Excel, AWS S3, AWS RDS, AWS Redshift, JSON, and XML to track KPIs and product performance.
Designed and monitored A/B testing metrics, creating dashboards in Tableau that improved test result analysis efficiency by 30%, and provided actionable recommendations that contributed to a 20% increase in feature adoption.
Conducted statistical analyses, including hypothesis testing, causal inference, and Bayesian analysis, resulting in data-driven recommendations that enhanced decision-making accuracy by 25% and improved campaign effectiveness by 18%. EDUCATION
UNIVERSITY OF DENVER – Colorado USA
Master of Science in Information and Communication Technology
ANURAG UNIVERSITY - Hyderabad, India
Bachelor of Technology in Computer Science and Engineering **************@*****.***
Contact this candidate