Data Analyst Power Bi

VAKUL SAI BIKUMALLA

***********@*****.***

Frisco,TX +1-978-***-**** https://www.linkedin.com/in/vakul-bikku-91aa32295/

Professional Summary

●Efficient data analyst with around 5 years of expertise in deciphering and evaluating intricate data to inform business decisions. Demonstrated proficiency with cutting-edge tools including Python, SQL, Excel, and Power BI for data analysis, visualization, and reporting.

●Proven ability to collaborate with cross-functional teams to collect data requirements and provide insights that may be put to use. Competent in data transformation, data cleansing, and data validation to guarantee reporting accuracy and consistency.

●Adept at extracting, modifying, and processing data from a variety of databases and sources. Practical experience processing and storing data on cloud systems such as AWS and Azure.

●Proficiency in trend analysis and predictive model construction for company performance forecasting. Provided information that enhanced decision-making, leading to more revenue and operational efficiency.

●Strong aptitude for creating, designing, and maintaining dashboards for KPI measurement and performance tracking. Familiarity with contract-based data analysis positions at organizations such as Invesco India Pvt. Ltd., Pegasus, and SMD Technosol.

●Demonstrated aptitude for visualizing data trends and patterns to aid in corporate intelligence and strategic planning. Adept at using data visualization tools such as Tableau and Power BI to efficiently and concisely convey complicated data insights.

●Demonstrated capacity to adjust to a variety of company needs while working in both on-site and hybrid locations. Knowledgeable about Visio, product planning, and working with stakeholders to provide data-driven solutions. Adept at communicating analytical results to both technical and non-technical audiences through documentation and presentation.

●Acknowledged for having excellent problem-solving abilities and the capacity to convert data findings into workable company plans. carried out several data projects with success, promoting process optimization and corporate expansion. Enthusiastic about using analytics and data science to facilitate data-driven decision-making and operational enhancements.

Professional Experience

SMD TECHNOSOL, FRISCO, TX

Data Analyst

JULY 2022- Present

●Made data-driven decisions for a significant financial customer by analyzing big financial datasets to find trends and patterns. 40% less time was spent on manual data processing to the development of automated reporting solutions utilizing Python and SQL. Created and maintained Power BI interactive dashboards that let stakeholders see real-time financial performance data.

●In order to comprehend business requirements and produce precise, timely reports, worked mostly with cross-functional teams. Used methods for data transformation and cleaning to guarantee data consistency and accuracy prior to analysis. Predictive analytics models were put into practice to forecast financial performance and assist clients in making proactive business decisions.

●Ensured smooth integration and consistency by extracting, manipulating, and analyzing data from many databases using SQL. Produced and gave senior management ad hoc analysis reports that included information on cost optimization and revenue trends. Used thorough data validation and quality checks to find and fix data inconsistencies.

●Created a consolidated data store on Azure Data Lake, improving data accessibility and dependability. ETL pipelines were used to increase the efficiency of data processing by streamlining the input of data from various sources. Ensured proper reporting and analysis by performing root cause analysis on data anomalies and discrepancies.

●Helped with compliance reporting and financial risk analysis, making sure that

everything was in line with industry rules and guidelines. By using automated data validation scripts, reporting mistakes were decreased and reporting accuracy rose by 30%. Developed a data-driven culture within the company by teaching team members SQL query optimization and data visualization tools. Used sophisticated statistical techniques to examine investment performance and find areas where a portfolio may be optimized.

●Identified and monitored key performance indicators (KPIs), offering valuable information on cost control and income development. Provided data insights that resulted in cost-cutting measures, saving the client a substantial sum on operating costs. Presented data results and analytical insights while actively participating in client meetings and presentations. Kept thorough records of the data analysis procedures, guaranteeing project continuity and knowledge transfer.

PEGASUS FARMACO, HYDERABAD, TS

Data Analyst

MAY 2020- MAY 2021

●Produced valuable insights through the analysis of patient and healthcare data, assisting a significant healthcare customer in making strategic decisions.

●Created Python and SQL-based automated ETL pipelines that allowed for the smooth integration of data from several healthcare systems.

●Using Power BI, produced interactive dashboards and visual reports to track financial indicators, resource usage, and patient outcomes.

●To find patterns and irregularities in healthcare data, statistical analysis and data preprocessing were conducted using Python (Pandas, NumPy).

●To guarantee data correctness, consistency, and adherence to healthcare laws (such as HIPAA), data validation and quality checks were put into place.

●Root cause analysis of data discrepancies was carried out, which greatly increased data dependability and cut mistakes by 25%.

●Worked together with stakeholders and healthcare professionals to comprehend reporting requirements and provide tailored data solutions.

●Improved capacity planning by using predictive analytics to predict patient admissions and resource needs.

●Streamlined data processing and reporting by using Excel for ad hoc analysis and data manipulation.

●Consolidated information from several sources, including electronic health records (EHRs), guaranteeing thorough reporting and analysis.

●In order to improve data accessibility and organization for healthcare analytics, helped create data models and schemas.

●Sensitive patient data was protected by implementing data privacy and security procedures in accordance with healthcare standards.

INVESCO INDIA,HYDERABAD,TS

Data Analyst

JUNE 2019- APRIL 2020

●Decision-making procedures were supported by the analysis and processing of substantial amounts of financial transaction data to find trends, patterns, and disparities.

●Created automated data pipelines with Python and SQL that allowed for effective data translation and extraction from a variety of banking systems.

●Using Power BI, developed interactive dashboards and visualizations to monitor key performance indicators (KPIs) pertaining to account activity and customer transactions.

●Excel and Python (Pandas) data cleaning and validation procedures improved data consistency and correctness.

●Created thorough weekly and quarterly reports to help senior management keep an eye on customer insights and financial performance.

●Ad hoc analysis was carried out to assist with strategic planning, and data findings were communicated to stakeholders using understandable visual aids.

●Worked together with cross-functional teams to collect data requirements and provide specialized analytical solutions that were suited to the business requirements of business user.

●Used advanced Excel features (such as pivot tables, VLOOKUP, and macros) to automate repetitive activities and expedite data processing.

●Identified possible hazards and opportunities through trend analysis and performance monitoring, giving stakeholders useful information.

Education

1.GOVERNORS STATE UNIVERSITY, UNIVERSITY PARK, IL

Masters of Science in Computer Science YEAR: December,2022

GPA: 3.65/4

Relevant Coursework: Data Analysis, Machine Learning, Database Management, Data Visualization, Cloud Computing, Algorithms, and Software Development.

2.SR INTERNATIONAL INSTITUTE OF TECHNOLOGY, HYDERABAD, TS

Bachelor’s of Technology in Electronics and Communication Engineering

CGPA: 8.50/10 YEAR: May, 2019

Relevant Coursework: Digital Signal Processing, Microprocessors, Communication Systems, Embedded Systems, Control Systems, and Circuit Analysis.

Technical Skills

●Programming Languages: Python (3.11), SQL (ANSI SQL, T-SQL, PL/SQL)

●Data Visualization: Power BI (2023), Tableau (2023.1), Matplotlib (3.7.1)

●Data Processing: Pandas (1.5.3), NumPy (1.24.3), Excel (Office 365)

●Database Management: SQL Server (2019), MySQL (8.0.33), PostgreSQL (14.8)

●Cloud Platforms: AWS (EC2, S3, Redshift), Azure (Data Lake Gen2, Data Factory)

●Data Warehousing: Azure Data Lake (Gen2), AWS Redshift (2023), Google BigQuery

●ETL Tools: Apache Airflow (2.6.0), Azure Data Factory (v2), Talend (7.3)

●Reporting Tools: Power BI (2023), Excel (Office 365), SSRS (2019)

●Machine Learning: Scikit-learn (1.3.0), TensorFlow (2.13.0), PyTorch (2.0.1)

●Big Data Technologies: Apache Spark (3.4.0), Hadoop (3.3.6), Hive (3.1.3), Kafka(3.5.0)

●Data Modeling: ER Diagrams, Star Schema, Snowflake Schema

●Scripting and Automation: Bash (5.2), Python Scripts (3.11)

●Version Control: Git (2.41), GitHub

●Data Storage: AWS S3, Azure Blob Storage

●Data Pipelines: Apache NiFi (1.22.0), AWS Glue (3.0)

●API Integration: RESTful APIs (v2), FastAPI (0.100.0)

●Data Formats: JSON, CSV, Parquet, Avro

●Visualization Libraries: Seaborn (0.12.2), Plotly (5.15.0), D3.js (7.8.4)

Contact this candidate