Data Analyst Senior
Resume:
PROFESSIONAL SUMMARY:
PRANAVI YERRAM
****************@*****.***
Senior Data Analyst
Possessing over 9+ years of experience, As Senior Data Analyst with expertise in SQL, data analytics, and business intelligence.
Developed complex SQL queries on SQL Server to optimize data retrieval processes for business intelligence analysis.
Utilized SSRS to design and implement dynamic reports that supported decision-making across various business functions.
Managed large datasets using SSIS, creating robust data workflows that streamlined ETL processes and data integration.
Implemented data cleansing procedures using SQL to ensure accuracy and reliability of data in reports and analyses.
Created comprehensive business documentation that outlined processes and results, improving transparency and project tracking.
Developed interactive dashboards using Power BI to visualize data trends and provide actionable insights to stakeholders.
Applied predictive modeling techniques using R to forecast business trends and drive strategic decisions.
Leveraged Python for data manipulation and analysis, enhancing data processing efficiency and analytical depth.
Utilized TensorFlow and PyTorch within Jupyter Notebooks to build and train advanced machine learning models.
Conducted data mining activities with Python, enhancing data quality and extracting valuable insights from large datasets.
Employed MATLAB for complex numerical computations, supporting data analysis projects with sophisticated mathematical models.
Used Microsoft Azure to deploy cloud-based data storage and processing solutions, enhancing scalability and security.
Implemented Azure ML to streamline the development and deployment of machine learning projects.
Developed and managed data catalogues and data lineage systems to improve data governance and traceability.
Utilized Agile methodologies to manage data projects, ensuring timely delivery and responsiveness to stakeholder needs.
Created detailed data models using SQL and Excel to support the development of database schemas and data warehousing solutions.
Utilized JIRA for project management and tracking, ensuring that all data analysis tasks were completed on schedule.
Employed SharePoint for document management and collaboration, facilitating better teamwork and information sharing.
Leveraged Confluence to maintain project documentation, enhancing team access to information and project continuity.
Designed and implemented predictive analysis solutions using Excel and R to support business forecasting activities.
Managed FTP operations to handle data transfers securely between systems, ensuring data integrity and compliance.
Applied data visualization techniques using ggplot2 to create compelling visual stories from complex data sets.
Utilized Lucidchart and Microsoft Visio for process mapping, helping stakeholders visualize and understand business processes.
Performed data profiling and analysis using Informatica, ensuring data quality and suitability for business needs.
Integrated data from various sources using AWS S3 and Azure Blob, optimizing data storage and accessibility for analytics.
TECHNICAL SKILLS:
SQL/Data Manipulation : SQL Server, SSRS, SSIS
Business Analysis : Microsoft Visio, Lucidchart, JIRA, AGILE, BPMN, UML
Data Visualization : Power BI, Tableau, Plotly, ggplot2
Machine Learning/AI : Python (NumPy, pandas), TensorFlow, PyTorch, Azure ML
Data Management : FTP, Data Catalogue, Data Lineage, Azure Blob, AWS S3
Programming/Scripting : R, Python, MATLAB
Cloud Technologies : Microsoft Azure, AWS Glue, Azure Databricks
Project Management : Agile, Scrum, Microsoft SharePoint
Documentation/Reporting : Excel, PowerPoint, Insights
PROFESSIONAL EXPERIENCE:
Client: Medtronic, Minneapolis, MN Jul 2023 to till date
Role: Senior Data analyst Roles & Responsibilities:
Developed advanced data models using SQL to streamline complex data analysis projects, enhancing data-driven decision-making.
Employed R language to create predictive models, enabling proactive business strategies and operational improvements in the health domain.
Leveraged Plotly for creating interactive data visualizations, which provided with clear insights into operational performance metrics.
Utilized Microsoft Azure Cognitive Services to implement AI solutions, enhancing automation and predictive capabilities in data processing.
Managed large datasets with Azure Blob Storage, optimizing data accessibility and scalability for ongoing and future analytics projects.
Enhanced data analysis presentations by using PowerPoint, delivering clear and impactful insights to stakeholders.
Conducted sophisticated data analyses using ggplot2 in R, producing detailed visual representations that supported strategic planning.
Streamlined data collection and management processes using automation tools in Python, improving efficiency and accuracy in data handling.
Integrated and analyzed data using Databricks, facilitating efficient and scalable data processing for analytics needs.
Designed and managed a data catalogue, improving data governance and accessibility for various internal teams.
Implemented data lineage solutions to track data usage and its impact, increasing transparency and accountability in data handling.
Utilized Excel extensively to manipulate and analyze data sets, providing a flexible tool for ad-hoc analysis and reporting.
Applied insights generated from data analysis to improve business processes and healthcare solutions.
Developed automation scripts in Python, which streamlined routine data processing tasks, reducing manual effort and increasing productivity.
Employed Azure Data Lake for centralized data storage, ensuring secure and efficient data management across the organization.
Conducted data modeling with advanced analytics techniques to support research and development initiatives.
Created data visualizations using Azure Cognitive Services, presenting complex data in an accessible and understandable format.
Managed project timelines and deliverables using SharePoint, ensuring that all data initiatives aligned with strategic goals.
Analyzed and interpreted large datasets to uncover patterns and trends that informed strategic decisions.
Developed and maintained robust data reporting systems using SQL and Power BI, enabling ongoing monitoring and analysis of key business metrics.
Enhanced stakeholder engagement by providing tailored data reports and dashboards, facilitating data-driven decision-making across departments.
Utilized advanced analytics to predict healthcare trends, contributing to leadership in the health domain.
Coordinated with IT and data governance teams to ensure compliance with data security and privacy regulations.
Provided training and support to staff on new data tools and practices, enhancing the company’s overall data
literacy.
Reviewed and optimized data workflows and processes periodically, ensuring they remained efficient and aligned with business objectives.
Environment: SQL, R, Plotly, Microsoft Azure Cognitive Services, Azure Blob Storage, PowerPoint, ggplot2, Python, Databricks, Excel, Azure Data Lake, SharePoint, Power BI.
Client: HCSC, Chicago, IL Sep 2021 to Jun 2023
Role: Sr. Data Analyst
Roles & Responsibilities:
Developed detailed business analyses to identify system enhancements, employing SQL, JIRA, and Microsoft Excel.
Developed interactive dashboards and data visualizations using Tableau to provide key business insights and support data-driven decision-making for cross-functional teams.
Built and maintained Tableau reports for multiple departments, enhancing operational efficiency by presenting real-time metrics and KPIs in easily digestible formats.
Created custom data models and calculations in Tableau using calculated fields, table calculations, and level of detail (LOD) expressions to meet specific business requirements.
Streamlined data reporting processes by automating Tableau workbooks, significantly reducing manual report generation time by over 50%.
Integrated Tableau with various data sources (e.g., SQL databases, Excel, Google Analytics, Salesforce) to ensure real-time data updates and consistent reporting accuracy.
Optimized Tableau workbooks for performance by applying best practices, such as minimizing data extracts, reducing complex calculations, and indexing large data sets.
Ability to apply the spark DataFrame API to complete Data manipulation within spark session
Good understanding of Spark Architecture including spark core, spark SQL, DataFrame, Spark streaming, Driver Node, Worker Node, Stages, Executors and Tasks, Deployment modes, the Execution hierarchy, fault tolerance, and collection
Coordinated project teams using Microsoft Teams, ensuring alignment on project goals and timelines.
Managed project documentation within Confluence, enhancing team access and knowledge sharing.
Designed and maintained workflow diagrams with Lucidchart, streamlining healthcare processes and operations.
Utilized SQL for complex data querying, supporting advanced data analysis and decision-making processes.
Implemented performance tracking and project management using JIRA, enhancing team efficiency and productivity.
Created dynamic Power BI reports to visualize healthcare data, aiding in operational and strategic decisions.
Facilitated agile and scrum meetings to ensure projects are delivered on time and within specifications.
Designed system architectures and process flows using Microsoft Visio, ensuring clarity and operational efficiency.
Managed SharePoint for document storage and version control, enhancing organizational and access capabilities.
Developed analytical reports using Microsoft Excel, providing insights into healthcare trends and metrics.
Optimized business processes using agile methodologies, ensuring continuous improvement and efficiency.
Coordinated technical documentation updates, maintaining accuracy and relevance in a fast-paced healthcare environment.
Liaised between IT and business teams to ensure seamless system integration and functionality.
Prioritized project tasks based on strategic business impact and technical requirements, using Microsoft Excel.
Analyzed user requirements to develop comprehensive functional specifications for new software features.
Conducted root cause analyses during testing phases, utilizing technical specifications to guide corrections.
Led continuous improvement initiatives to refine data analysis and project management techniques.
Environment: JIRA, SQL, Confluence, Lucidchart, Microsoft Visio, BPMN, Excel, Microsoft Teams, SharePoint, Power BI, PowerPoint, and Agile/Scrum methodologies.
Client: Gray Matter Analytics, Chicago, IL Nov 2019 to Aug 2021 Role: Data mining specialist
Roles & Responsibilities:
Implemented complex data mining algorithms using Python, enhancing the ability to uncover valuable insights from large datasets.
Developed machine learning models with TensorFlow to predict customer behaviors, improving targeted marketing strategies and customer engagement.
Utilized PyTorch for deep learning projects that analyzed unstructured data, providing breakthrough insights in predictive analytics.
Created detailed data visualizations using Jupyter Notebooks, which facilitated the understanding and communication of analytical results to non-technical stakeholders.
Leveraged Microsoft Azure for deploying scalable and secure cloud-based analytics solutions, enhancing data processing capabilities.
Employed Azure ML to streamline the creation and deployment of machine learning models, reducing development time and improving model accuracy.
Conducted advanced numerical analyses with MATLAB, supporting complex data modeling and simulation projects that informed business decisions.
Enhanced reporting capabilities by developing comprehensive dashboards in Power BI, providing real-time business intelligence across the organization.
Utilized SQL for data querying and manipulation, ensuring accurate data retrieval that supported critical analytics initiatives.
Developed and maintained data documentation using Excel, ensuring consistency and reliability in data handling and reporting.
Applied agile methodologies using Scrum techniques to manage data projects, enhancing team productivity and project deliverability.
Implemented data governance practices using data catalogues to ensure data integrity and compliance with data protection regulations.
Streamlined ETL processes using Python scripts, automating data extraction, transformation, and loading to improve efficiency.
Managed data storage solutions with Microsoft Azure, optimizing data accessibility and security for enterprise- wide analytics applications.
Facilitated knowledge transfer sessions on the use of data analytics tools, empowering employees to leverage business intelligence software effectively.
Coordinated with IT and business units to integrate new analytical tools and techniques, ensuring alignment with overall business strategies.
Monitored analytics systems and platforms for performance issues, proactively addressing potential disruptions in data services.
Conducted regular data quality checks using data profiling tools, ensuring the accuracy and usability of the data in analytics processes.
Collaborated with project teams to define data requirements for new analytics initiatives, ensuring that solutions met business needs.
Led data analytics projects from conception to completion, ensuring that all project milestones were met and outcomes aligned with strategic objectives.
Environment: Python, TensorFlow, PyTorch, Jupyter Notebooks, Microsoft Azure, Azure ML, MATLAB, Power BI, SQL, Excel, Scrum, Data Catalogues.
Client: ilink Digital, Pune, India Jun 2017 to Aug 2019
Role: Business Analyst Roles& Responsibilities:
Analyzed business requirements using SQL, providing critical data insights that informed enhancements in service delivery.
Developed detailed technical specifications and enhancement documentation using Microsoft Excel and PowerPoint, improving project clarity and stakeholder communication.
Managed use case development with Lucidchart, enhancing system design and functionality through precise requirement visualization.
Utilized JIRA for project management, ensuring all business analysis tasks were tracked and completed within established timelines.
Facilitated process mapping sessions using Microsoft Visio, creating clear and actionable diagrams that supported business process reengineering.
Implemented Agile methodologies to improve project flexibility and responsiveness to changing business needs.
Conducted validation tests to ensure that system developments met business requirements and functioned as intended.
Collaborated with customers to refine business specifications, ensuring solutions were effectively tailored to user needs.
Employed UML to model system interactions and data flows, providing a clear framework for system development and integration.
Created and maintained project documentation in Confluence, ensuring all team members had access to up- to-date information.
Engaged in continuous improvement initiatives by identifying bottlenecks and proposing practical solutions based on business analysis.
Provided comprehensive business analysis training to new team members, enhancing their understanding of project goals and methodologies.
Coordinated with IT developers to ensure technical solutions accurately addressed business problems and enhanced functionality.
Monitored project progress using SharePoint, facilitating effective collaboration and document sharing among project stakeholders.
Prepared and delivered presentations to senior management, showcasing project progress and the impacts of business analysis efforts.
Developed and implemented user acceptance testing protocols with stakeholders, ensuring systems met all operational requirements before going live.
Negotiated with external vendors to secure software and services that supported business analysis and project needs.
Advocated for the adoption of BPMN standards in process documentation, standardizing practices and enhancing process efficiency.
Environment: SQL, Microsoft Excel, PowerPoint, Lucidchart, JIRA, Microsoft Visio, UML, Confluence, SharePoint, BPMN.
Client: Cygnet infotech, Ahmedabad, India Nov 2015 to May 2017
Role: SQL Developer Roles & Responsibilities:
Developed and optimized SQL queries and stored procedures for data manipulation, significantly improving database performance and user satisfaction.
Implemented SSRS to create dynamic and interactive reports, facilitating better data-driven decision-making across departments.
Managed data transformations and integrations using SSIS, streamlining data workflows and improving data quality and accessibility.
Conducted regular data cleansing operations, ensuring high data integrity and reliability for reporting and analytics purposes.
Developed extensive documentation for all data operations, establishing a reliable reference for audits and future developments.
Utilized SQL Server Management Studio (SSMS) for database management, enhancing security and performance tuning.
Created normalized data structures to optimize database storage and improve query performance, adhering to best practices in database design.
Collaborated with cross-functional teams to understand data needs and deliver SQL solutions that supported various business applications.
Performed DML operations within stored procedures to handle data effectively, ensuring data consistency and accuracy.
Designed and maintained data aggregations, supporting critical business reporting and analysis needs with efficiently structured data.
Engaged in FTP operations for secure data transfer between systems, enhancing data exchange security and reliability.
Participated in team meetings to discuss project progress and challenges, contributing to a collaborative work environment.
Conducted data analysis and reporting using Power BI, providing stakeholders with insights into business performance and trends.
Facilitated database migrations and upgrades, ensuring modern infrastructure supported business growth and technology advancements.
Maintained a clear audit trail for all data operations, ensuring compliance with internal and external data management standards.
Environment: SQL, SSRS, SSIS, SQL Server Management Studio (SSMS), Power BI, FTP.
Education:
Bachelor of Technology (B.Tech) in Information Technology from JNTUH, Hyderabad, Telangana, India. - 2015
Contact this candidate