Home

Sri Navya - Data Analyst

[email protected]

Location: Machias, Maine, USA

Relocation: Yes

Visa: H1B

Sri Navya Data Analyst Contact: +1 (331) 666-5692 Email: [email protected] Linkedin: https://www.linkedin.com/in/navyaguduru/ Professional Summary: Dynamic and results-oriented Data Analyst with a solid foundation in data management, visualization, predictive analytics, and business intelligence. Proficient in leveraging Microsoft Power BI, SQL, Python, and machine learning techniques to extract actionable insights from complex datasets. Skilled in developing comprehensive analytical solutions that drive informed decision-making and optimize business processes. Proven ability to collaborate effectively across interdisciplinary teams to identify opportunities for process improvement and implement data-driven strategies. With a keen eye for detail and a commitment to continuous learning, dedicated to delivering high-quality analyses that contribute to organizational success. Experienced in creating interactive dashboards in Power BI to visualize key performance indicators and communicate complex findings effectively to stakeholders. Strong track record in telecom, financial, insurance, healthcare, and banking domains. Proven ability to create interactive dashboards, optimize complex queries, and provide actionable insights. Skilled in data analysis, data visualization, data manipulation, statistical analysis, predictive analytics, machine learning, data mining, data modeling, dashboard development, Power BI, SQL, Python, Excel, data warehousing, ETL processes, data cleansing, regression analysis, classification, clustering, time series analysis, hypothesis testing, feature engineering, natural language processing (NLP), deep learning, web scraping, API integration, version control (e.g., Git), database management systems (DBMS), cloud platforms (e.g., AWS, Azure, Google Cloud), agile methodologies. Proficient in logical and physical data modeling, FACT and dimensional tables, and database design using data modeling tools like Erwin, MS Access, and Microsoft Visio. Possesses the ability to work independently or as part of a team, effectively accomplishing critical business objectives and making decisions under pressure. Proficient in working with cloud-based ETL and data integration services like Azure Data Factory (ADF) for creating data workflows. Developed and scheduled workflows (pipelines) in a code-free manner using Azure Data Factory (ADF). Hands-on experience with DAX, M, T-SQL, SharePoint, Microsoft Forms, Power Apps, Alteryx, Excel, PowerPoint. Technical expertise extends to various statistical analysis methods, including regression analysis, classification, clustering, and time series analysis. Tools/Utilities: Power BI, SQL, Python, Excel, Jupyter Notebooks, Azure, MySQL, MongoDB, Alteryx, Power BI Report Builder, Microsoft Report Builder, SQL Server Management Studio (SSMS), SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Visual Studio, Data Modeling, Snowflake, SharePoint, Oracle, Microsoft Access Educational Details: Master of Science (Technology Management), Lindsey Wilson College, USA, Jan 2022 - Aug 2023 Bachelor of Science, Osmania University, Hyderabad, India, Jun 2013 - Mar 2016 Professional Experience: Data Analyst, Publix Lakeland, FL USA - Jan 2023 to Present Publix Super Markets, Inc., commonly known as Publix, is an employee-owned American supermarket chain headquartered in Lakeland, Florida. Led data analysis projects to identify opportunities for process improvement and optimize business operations. Developed and implemented advanced analytical models using Python and SQL to extract actionable insights from large datasets. Created interactive dashboards in Power BI to visualize key performance indicators and communicate findings to stakeholders. Conducted statistical analysis, including regression analysis, classification, and clustering, to uncover trends and patterns in data. Collaborated with cross-functional teams to translate business requirements into analytical solutions and drive decision-making processes. Administered Power BI roles, VM creation, Gateway setup, and scheduling refreshes. Designed and developed SSRS reports and Power BI dashboards. Migrated SSRS reports to Power BI Paginated reports. Created complex stored procedures, triggers, and indexes. Utilized Alteryx for ETL operations. Extracted and transformed data from various sources. Gathered, imported data, and created insights from Alteryx, Excel, SAP, SQL Server, One data, Data Verse, SharePoint, OneDrive, etc. Conducted data mining to perform strategic data analysis and research, identifying opportunities to improve productivity through sophisticated statistical modeling. Utilized Azure Data Factory (ADF) for cloud-based ETL and data integration services. Developed and scheduled workflows in a code-free manner using Azure Data Factory (ADF). Migrated existing self-service reports and ad hoc reports to Power BI. Performed cohort analysis on customer segments. Used Power Query to acquire data and Power BI desktop for designing rich visuals. Scheduled jobs and alerts using SQL Server Agent in Power BI. Performed different types of loads: incremental load, optimized load, and binary load. Created SSIS packages using various transformations to generate underlying data for reports. Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables. Actively participated in unit testing of data and collaborated with QA teams to resolve defects. Data Analyst, Karvy, India - May 2017 to Oct 2021 Karvy is a financial services company in India involved in equity, commodities trading, depository and wealth management services, and distribution of other financial products. It has its headquarters in Hyderabad. Led a team of analysts in developing predictive models and machine learning algorithms to optimize pricing strategies, resulting in a significant increase in revenue. Implemented data governance policies and procedures to ensure data accuracy and compliance with regulatory requirements. Developed interactive dashboards in Power BI to visualize key performance indicators and facilitate data-driven decision-making processes for senior management. Administered Power BI roles, created VMs, Failover VM, set up Gateway clusters, created workspaces, and managed tenant settings. Designed and developed SSRS reports, Power BI dashboards, paginated reports, and created tables, views, and functions in Snowflake, SQL Server Management. Migrated existing SSRS reports to Power BI Paginated reports. Migrated existing Qlik View reports to Power BI dashboards. Created complex stored procedures, triggers, functions, indexes, tables, views, and SQL joins for applications. Designed SSIS packages to transfer data from flat files, Access databases, and Excel documents to the staging area in SQL Server. Used Power BI Power Pivot to develop data analysis prototypes and used Power View and Power Map to visualize reports. Used Microsoft Power BI Power Query to extract data from external sources and modify data to the required format in Excel. Migrated data from Snowflake to SQL Server and Oracle to SQL Server. Developed and supported intranet-based applications for corporate-wide use, extensively used T-SQL (DDL, DML), C#, and ASP.NET for web services. Generated drill-down, drill-through, matrix reports, and parameterized reports using MSBI (SSRS). Developed complex calculated members and named sets using MDX expressions for specific OLAP reporting requirements. Created SSIS packages using various transformations to generate underlying data for reports. Actively participated in user interactions, team meetings, and technical discussions to fully understand system requirements. Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables. Keywords: csharp quality analyst business intelligence active directory information technology microsoft Florida