Data Analytics Power Bi

Yoga Lasyaa Daddala

Fairfax, VA ***** 571-***-**** ad5u7l@r.postjobfree.com

SUMMARY

Accomplished data professional with 5 years of experience in data analysis, development, engineering, and visualization, specializing in transforming raw data into actionable insights using Power BI, Tableau, SQL, MS Access, and VBA.

Spearheaded organizational success by implementing robust BI strategies aligned with business goals, enhancing decision-making processes.

Expert in designing and developing dynamic, visually compelling dashboards and data analytics solutions, enabling informed decision-making.

Proficient in ETL process implementation and optimization, ensuring seamless data flow, integrity, and performance. Skilled in leveraging cutting-edge BI technologies to streamline data engineering workflows.

Experienced in developing and maintaining MS Access databases and creating custom VBA solutions to automate tasks and improve efficiency.

Effective communicator and collaborator, adept at bridging the gap between technical expertise and business needs. Proven track record of engaging stakeholders and aligning BI solutions with organizational objectives.

CORE COMPETENCIES

Data Analytics • Data Storytelling • Data Engineering • ETL Development • Data Warehousing • Data

Integration • Data Quality Assurance • Data Governance • Data Analysis • Business Intelligence (BI) Tools:

Power BI, Tableau • Data Visualization • IAM • Report Writing • Cloud Platforms: AWS, Azure • Programming:

Python, SQL • Dashboards • Big Data Technologies• Hadoop• Spark • Agile Methodologies • CI/CD

EDUCATION

MASTER’S FAIRFAX, VA EXPECTED MAY 2024

GEORGE MASON UNIVERSITY Master’s in Data Analytics

UNDERGRADUATION CHENNAI, INDIA 2018-2022

SAVEETHA SCHOOL OF ENGINEERING BIOMEDICAL ENGINEERING

SKILLS

Languages R SQL Python MS Access MS Excel Powershell

Databases MySQL NO SQL MongoDB Hadoop

Operating Systems Windows MacOS Linux RedHat Centos

Cloud Computing Amazon Web Services (AWS) Microsoft Azure IAM Orcale Google Chrome IBM Cloud

Tools Tableau MS Office Analytical Solver RStudio Jupyter Notebook Power BI MS office

EXPERIENCE

Software Engineer (MS Access/SQL Developer) 22nd Century Technologies, Inc. Virginia JAN 2024-PRESENT

Worked on a data migration project for the DCFS (Department of Children and Family Services, involving the conversion of data from Microsoft Access databases to SQL Server databases.

Implemented and understood the structure and relationships of existing Access databases to plan and execute the migration process effectively.

Developed MS Access/Excel VBA programs, VB scripting to perform tasks automatically.

Conducted thorough testing, including unit testing, integration testing, and user acceptance testing, to ensure software quality and functionality and also backup and restoring the data.

Developed scripts and queries using SQL to extract, transform, and load data from Access databases into SQL Server databases.

While conversion, MS Access understood the VBA code techniques and made changes to the code based on requirements.

Experience with integrating data from JIRA.

Performed data cleansing and validation to ensure accurate and consistent data transfer.

Collaborated with project stakeholders and subject matter experts to understand data requirements and business rules.

Documented migration procedures, data mappings, and any issues encountered during the process.

Conducted thorough testing, including data reconciliation and validation, to ensure successful migration.

Understood the internal data, public data, marketplace, customers, vendors and competitors to help aid in the site and product roadmap.

Analyzing writing code, testing, and has done technical documentation like impact analysis, test cases, Supports End User Computing. etc.

Understanding an Agile / Scrum environment and a solid understanding of the full software lifecycle, including functional requirements.

Experience in using software tools like Visual Studio, SharePoint, TEAMS, or similar systems.

Depending on the project and client need, worked in a diverse set of focus areas and roles, including requirements management for projects, change management, process improvement, communications management, and/or project/product management.

Junior Data Analyst Persistent Systems, Pune, Maharashtra NOV 2019-NOV2022

Conducted in-depth performance analysis of existing SQL queries to identify areas for optimization and improvement.

Understood indexing strategies and query rewriting techniques to enhance SQL query execution speed, resulting in a 30% reduction in response time.

Participated in regular code review sessions, providing constructive feedback on SQL code quality and adherence to best practices.

Wrote and maintained stored procedures, views, functions, and other database objects to support various applications.

Provided database performance-tuning expertise for SQL Server databases.

Managed MS SQL Server database environments that supported transactional data as the backend.

Demonstrated a strong background in data modeling, data management, data manipulation, and code management and version control.

Engaged in database schema design discussions, contributing insights to improve overall database efficiency and scalability.

Had a dynamic team planning and executed a significant Momentum upgrade, including business analysis, design, testing, and training.

Developed and distributed the product reporting requests.

Performing SQL queries, data mining, report creation, effectiveness tracking and data project consulting.

Designed and implemented SQL Server database schemas to accommodate ensuring data integrity and normalization.

Created edited new and existing macros to work with a large amount of data.

Used Tableau to build dashboards, Python and R to create models, and SQL and Excel to explore data.

Created technical documentation and collaborated with stakeholders to ensure end products satisfied their goals and could be maintained long-term.

Developed analytics products, dashboards, and models that drove value and insight into client business.

Built data pipelines using Python and SQL, leading to aggregated tables.

Managed data pipelines integrated with an enterprise data lake.

Designed, built, tested, and optimized queries and data cleanups.

Performed Tableau server administration, including core optimization, site management, and troubleshooting.

Supported the creation of ad hoc and standard operational reports.

Recommended Tableau platform capabilities and features to create advanced visualizations and implement reporting capabilities.

Collaborated with functional teams to understand data, perform analysis, and identify process improvement opportunities.

Updated dashboard user guides and technical design documents.

Conducted regular dashboard, code, and architecture maintenance.

Developed data-driven reporting solutions using Microsoft Power BI and other supporting design tools to measure outcomes, business performance KPIs, and perform trend analysis.

Designed and developed Power BI solutions.

Provided technical support in delivering solutions and services and offered tool functionality advice to report users.

Handled incidents, problems, requests, and changes for applications developed in Power BI and other solutions.

Worked concurrently across multiple technologies like Power BI, SSRS based on specific needs.

Troubleshooting code, queries, and stored procedures and Migrated Databases from on-prem to cloud (AWS, Azure Cloud)

Managed data systems and reporting frameworks to guarantee data integrity and precision Coordinated with external vendors and partners as needed to ensure successful project outcomes.

Created automation programs and visualizations in Power BI, Tableau, Python.

Provided Operations Support by obtaining facts, analyzing problems designing solutions, developing testing methods, conducting, and documenting tests, providing operating information to customers.

Creating and maintaining Power BI dashboards and reports to provide insightful, actionable data.

Working closely with stakeholders to convert business needs into technical solutions, ensuring the optimization and maintenance of existing Power BI assets.

UNIQ TECHNOLOGIES TRAINEE BANGLORE, INDIA OCT 2018 - OCT 2019

Conducted exploratory data analysis, identified, and resolved 20 critical data anomalies, improving overall data quality.

Implemented predictive modeling techniques, resulting in a 12% increase in accuracy for forecasting future trends.

Utilized statistical methods to derive meaningful insights from large datasets.

Created and maintained dashboards for real-time monitoring of key metrics.

Collaborated with cross-functional teams to align data analysis with business objectives.

Supported the database services in the design, delivery, and operation of database solutions.

Identified and understood requirements of the clients with respect to existing system and Data models.

Enhance data models and design the database architecture as per the given requirement.

Ensuring good performance of the database system across various platforms and terminals. Gathering requirements (business, functional and technical) using collaborative, face-to-face workshops with the customers, stakeholders, and the development team.

Performed business process reviews by reviewing current to-be processes and mapping them to future state ("to be") processes.

Participated in and led client stakeholder meetings, Drive adoption of the designed processes and solution use with stakeholders.

Developed and updated system designs and training documentation.

Supported testing activities including developing test cases and executing testing.

Proactively bringing up issues and problems to the attention of the team, generating, proposing, and implementing innovative solutions to solve them.

Employed statistical techniques to scrutinize data and produce actionable business insights.

Share conclusions and suggestions with interested parties via presentations, dashboards, or reports.

Assisted technical staff with data-driven projects and provided support to existing and on-going projects.

Design and applying analytical methods to extract insight from existing datasets.

Researching industry-leading practices to provide analyses and insights.

Analyzing events and tracking data to find trends and takeaways.

Collaborated with cross-functional teams to understand business objectives and provide data-driven recommendations.

Conducted research and market analysis to support strategic planning and decision-making.

Assisting in the development of business processes and workflow improvements

Creating engaging, descriptive, and intuitive reports

ACHIEVEMENTS AND PUBLICATIONS

Led analytical research identifying synthetic opioid (fentanyl) precursor chemical manufacturers and complicit government officials. Extracted publicly available information from chemical product listings, foreign company websites, corporate registry databases, government agency websites, technical trade publications, press articles, and similar sources. Structured, integrated, and normalized data ahead of performing cluster, network, geographic information, statistical, web domain, image, and optical character recognition analyses. Resultant evidence linked Chinese Communist Party (CCP) officials to PRC chemical manufacturers actively producing fentanyl precursor chemicals. Data analyses and findings proved critical to the U.S. House of Representatives bipartisan ‘House Select Committee on the Strategic Competition Between the United States and the Chinese Communist Party’ investigation into the complicity of the Chinese chemical industry and the CCP in the U.S. fentanyl epidemic. Data visualizations and findings were published in the Select Committee’s fentanyl investigation report, shown during formal evidentiary hearing, and incorporated into subsequent U.S. legislation.

Optimal Approach to the Pancreatic cancer Prediction Based On Artificial Neural Network Compared With Decision Tree Algorithm For Improved Accuracy

https://www.eurchembull.com/issue-content/optimal-approach-to-the-pancreatic-cancer-prediction-based-on-artificial-neural-network-compared-with-decision-tree-algorithm-for-improved-accuracy-2081

Contact this candidate