Post Job Free
Sign in

Data Analyst Power Bi

Location:
Santa Ana, CA
Posted:
January 21, 2025

Contact this candidate

Resume:

VENKATA RAHUL MURARISETTY

USA +1-616-***-**** *********@*****.*** www.linkedin.com/in/rahul2707 SUMMARY

• 3+ years of experience in data analyst, ETL development, and actionable insights delivery across finance, healthcare, and marketing industries.

• Expert in large-scale data processing, ETL workflows, and cloud platforms (AWS, Azure, Google Cloud) with big data tools (Hadoop, Spark).

• Developed dashboards and reports using Tableau, Power BI, Cognos, and QlikView, driving real-time, data-driven decisions.

• Automated ETL processes with Apache Nifi, Talend, and Airflow, reducing manual tasks by 30% and boosting pipeline efficiency.

• Integrated financial data into Snowflake, AWS Redshift, and BigQuery, optimizing data flow and storage.

• Built and deployed predictive models using Python, R, PyTorch, and scikit-learn, improving forecasting and resource planning.

• Proficient in data wrangling and cleaning with Python (Pandas, NumPy), R, and SQL for high-quality datasets.

• Designed Star and Snowflake schema data models in SQL Server, PostgreSQL, and MySQL for efficient data retrieval.

• Collaborated in Agile teams to deliver projects in sprints, ensuring alignment with business goals.

• Enhanced datasets with external market data via RESTful APIs and web scraping (Python requests, BeautifulSoup).

• Managed cloud-based workflows with Azure Data Factory, AWS Glue, and Google Cloud Functions.

• Performed statistical analysis and A/B testing using SAS, Python, and R to optimize trial and campaign performance.

• Ensured GDPR and HIPAA compliance by implementing data encryption, validation, and masking.

• Built real-time data pipelines using Apache Kafka, Spark Streaming, and AWS Lambda, reducing processing latency.

• Enhanced dashboard interactivity with JavaScript and jQuery, improving user experience and visual dynamics. Data Analyst – BlackRock USA May 2024 – PRESENT

• Built and maintained ETL pipelines using Informatica, Apache Nifi, Talend, SSIS, and AWS Glue, integrating financial datasets into Snowflake, AWS Redshift, and Google BigQuery.

• Designed interactive dashboards and reports using Power BI, Tableau, Cognos, and QlikView for portfolio performance, risk exposure, and investment insights.

• Conducted data cleaning, wrangling, and transformation using Python (Pandas, NumPy), R, and PySpark, ensuring high-quality datasets for analysis.

• Modeled data using Star Schema and Snowflake Schema in SQL Server, PostgreSQL, and MySQL for efficient querying and analysis.

• Developed and deployed predictive models using Python, R, PyTorch, and conducted A/B testing to forecast market trends and optimize strategies.

• Automated workflows with Apache Airflow, Zapier, and Google Scripts, improving pipeline efficiency by reducing manual intervention.

• Created and integrated RESTful APIs using Python (requests, BeautifulSoup) to enrich datasets with external market data.

• Wrote complex SQL queries, stored procedures, and functions for data extraction, transformation, and loading (ETL) processes.

• Leveraged Azure Cloud Services such as Azure Data Factory, Azure Synapse Analytics, and Azure Blob Storage for scalable financial data processing.

• Processed large-scale datasets with Hadoop, Apache Spark, and PySpark, ensuring efficient handling of structured and unstructured data.

• Created advanced visualizations using SSRS, Domo, and Excel PowerPivot, presenting financial metrics for executive decision-making.

• Ensured data security and compliance with GDPR and HIPAA standards through data validation, masking, and encryption.

• Managed code repositories with Git, GitHub, and Bitbucket, adhering to Agile methodologies for seamless team collaboration.

• Streamlined operations using automation tools like Microsoft Power Automate and Azure CLI, reducing data processing latency.

• Enhanced dashboard interactivity and responsiveness using JavaScript and jQuery, providing dynamic user experiences. Data Analyst- Syneos Health NC, USA Aug 2023 – April 2024

• Operated in an Agile environment, collaborating across clinical, marketing, and operational teams to refine patient recruitment strategies and align deliverables with sprint goals.

• Queried and processed complex clinical trial data using SQL, Snowflake, and AWS Redshift, enabling recruitment teams to identify high-performing demographics. Automated manual processes with Google App Script, enhancing data accuracy and reducing processing time by 30%.

• Cleaned and transformed clinical datasets using Pandas, NumPy, and advanced data wrangling techniques, improving dataset readiness by 40%.

• Built forecasting models and predictive analytics pipelines to optimize recruitment timelines, improving accuracy by 30% and reducing delays.

• Created interactive visualizations using Tableau and Power BI, tracking trial performance metrics and demographic insights.

• Conducted statistical analysis and hypothesis testing using SAS, identifying critical factors for patient enrollment success.

• Built and optimized data engineering solutions using Azure Data Factory and Databricks, enabling seamless integration and processing of clinical datasets. Automated workflows with Apache Airflow and utilized REST APIs for seamless data integration across platforms.

• Leveraged Google Analytics and Adobe Analytics to monitor patient-focused marketing efforts and drive campaign optimizations.

• Ensured compliance with GDPR and HIPAA by implementing secure data handling practices, reducing data privacy risks by 25%.

• Utilized Jupyter Notebook, RStudio, and Shiny to develop reproducible workflows, improving collaboration during Agile iterations.

• Presented sprint-based results through dynamic dashboards and presentations using Microsoft PowerPoint and interactive charts, ensuring alignment with recruitment KPIs.

Data Analyst - Accenture Hyderabad, INDIA Aug 2020 - July 2022

• Delivered marketing insights in sprints using Agile methodology, collaborating with stakeholders to prioritize KPIs and adjust campaign strategies in iterative cycles.

• Built and optimized predictive models using TensorFlow and scikit-learn, achieving 85% accuracy in forecasting campaign performance.

• Automated ETL workflows with Informatica, Talend, Apache Nifi, and Azure Data Factory, reducing manual integration tasks by 40%.

• Designed and deployed real-time interactive dashboards in Tableau, Power BI, QlikView, and Cognos, enabling data-driven decision-making for multi-channel campaigns.

• Conducted A/B testing, statistical modeling, and trend analysis to identify campaign effectiveness, achieving a 12% increase in conversion rates.

• Processed and analyzed data from regional campaigns using Google BigQuery, driving a 20% improvement in customer engagement through geospatial analysis. Enhanced user experience on dashboards by implementing JavaScript and jQuery for dynamic and responsive designs002E

• Managed marketing datasets stored in CSV, JSON, and Parquet, ensuring seamless integration into business intelligence tools.

• Automated workflows with Apache Airflow, enhancing the delivery of marketing analytics for campaign optimizations during sprint cycles.

• Conducted statistical analysis and hypothesis testing to support audience segmentation strategies, improving ROI by 15%.

• Implemented GDPR-compliant data security practices and performed regular data validation for sensitive datasets.

• Presented marketing insights to leadership using Shiny dashboards and Microsoft Office, aligning analytics with strategic objectives during Agile sprint reviews.

• Used Git and GitHub for version control, enabling efficient collaboration across teams during iterative development phases. EDUCATION

Master of Science Applied Computer Science Grand Valley State University, Michigan, USA

(Aug 2022- Apr 2024) GPA: 3.6/4.0

Bachelor of Technology in Electronics and Communication Engineering Kalasalingam Academy Of Research And Education, Tamilnadu, India (Aug 2018- May 2022) GPA: 3.05/4.0

SKILLS

Programming &

Analytics

Python, R, SAS, STATA, VBA, MATLAB, SQL, Java, Julia, JavaScript, Pandas, NumPy, TensorFlow, scikit-learn, PyTorch, PySpark, NLP, Predictive Modeling, A/B Testing, Statistical Analysis, Forecasting Data Visualization

Power BI, Tableau, Cognos, QlikView, SSRS, Domo, Excel PowerPivot, Interactive Dashboards, Charts, Graphs, Tables, Real-time Reporting, Dynamic Visualization

Data Management

Data Cleaning, Data Wrangling, Data Transformation, Data Integration, Data Warehousing, Star Schema, Snowflake Schema, Performance Evaluation, Data Trend Analysis, Data Validation APIs and Web Scraping RESTful APIs, Python (requests, BeautifulSoup), Web Scraping, Data Enrichment with External Sources Databases SQL Server, MySQL, PostgreSQL, Snowflake, AWS Redshift Big Data & Cloud

Hadoop, Apache Spark, PyTorch, PySpark, AWS (S3, Redshift, Athena, Lambda, CloudWatch, DynamoDB, Glue), Azure (Azure Data Factory, Blob Storage, Synapse Analytics, Databricks), BigQuery, Cloud Storage, Compute Engine ETL Tools ETL Pipelines, Informatica, Apache Nifi, Talend, SSIS, Airbyte, Azure Data Factory, AWS Glue, Airflow Web Technologies HTML, CSS, jQuery

Mathematical Skills Linear Algebra, Calculus

Forecasting & Analytics Predictive Modeling, A/B Testing, Hypothesis Testing, Statistical Analysis, Data Trends, Forecasting Automation & Workflow Apache Airflow, Zapier, Google Scripts, Microsoft Power Automate Google Analytics Google Analytics, Adobe Analytics Data Security GDPR Compliance, HIPAA Compliance, Data Masking, Data Encryption Tools/IDE Jupyter Notebook, PyCharm, RStudio, Anaconda, Shiny, Unix, Microsoft Office, Spring Boot File Formats CSV, JSON, XML, Parquet, Avro, ORC

Version Control &

Collaboration

Git, GitHub, Bitbucket

Operating Systems Windows, Linux, macOS

Business Intelligence

Tools

Tableau, Power BI, Cognos, QlikView, Domo

Software Tools SAS, Unix, Anaconda, Shiny

Soft Skills Problem Solving, Troubleshooting, Collaboration, Communication, Multitasking, Project Management, Adaptability, Commitment CERTIFICATIONS:

• SAP Certified Development Associate: ABAP with SAP NetWeaver 7.50

• CISCO: Data Analytics Essentials

• IBM Data Analyst Professional Certificate, Coursera



Contact this candidate