Home

divya - data analyst

[email protected]

Location: San Antonio, Texas, USA

Relocation:

Visa: h1b

Divya Dhammannagari 804/859/4635 PROFESSIONAL SUMMARY: Having 11+ years of experience as Data Analysis and Data collection with experience in Report development & Report testing, possessing good knowledge and experience with DWH concepts. Extensive experience with different capacities on the various software development life cycles (SDLC) of the projects ranging from client requirements, design, development, testing, support and maintenance. 8+ years of extensive Experience in Tableau (Desktop, Server, Reader, mobile, Online, Public) and as a Developer and Analyst. Streamlined data workflows between Airtable and other tools, improving efficiency and data quality 2+ years of Experience worked as MS SQL SERVER DEVELOPER. 5+ years of experience in Alteryx Platform, and involved in data preparation, data blending, and the creation of data models, data sets using Alteryx. Experienced data analyst with a strong background in aligning IT systems with organizational business processes. Proficient in data analysis, milestone tracking, and status reporting. Passionate about unravelling insights from complex IP networks. Proficient in Installing, Configuring and Administration of Tableau Server and Server performance tuning for optimization. Developed interactive dashboards using Tableau for the supply chain reporting & analytics team to monitor operational KPI s. Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating workflows to extract data from SQL Server and Flat File sources and load into various Business Entities. Using Tableau, I support production projects involving Reporting and Dashboard Solutions Development, Data Extraction Performance Tuning. Having experience in working with datasets ranging across various Retail, Finance, Banking, Manufacturing and Service based industries. Created Python scripts for data extraction, transformation, and loading (ETL) process from multiple sources. Worked in Agile Environment with JIRA, Rally. Having experience in data analytics, designing reports with visualization solutions using Tableau Desktop and publishing on to the Tableau Server. Built multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, Dual-axes charts, Geo-maps, Histograms, Bubble and Heat Maps. Apply supply chain expertise to develop and maintain accurate demand forecasts, segment customers/products, optimize replenishment strategies, and manage purchase orders effectively. We are identifying and analysing investment risks using data analytics. Using data insights to inform and develop investment strategies. Designed and maintained data models in Air table, streamlining information organization and improving data accessibility Managed data using Airtable, creating and maintaining bases for various projects and departments. We collaborate with cross-functional teams including supply chain, IT, and business stakeholders to understand requirements, provide analytical insights, and drive data-driven decision-making. Integrated data from Airtable into Tableau for comprehensive analysis and reporting Having experience in creating visualizations of non-geographic data using advanced geographic mapping techniques, use of custom images and geo coding to build. Expert in Python and its libraries like Pandas, NumPy, Matplotlib, Seaborn, Networks, and Scikit-Learn. Having experience in developing story telling dashboards in Tableau desktop and published them on to Tableau server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information. Capable of monitoring project milestones and ensuring timely progress. Utilized Airtable for data warehousing and grid computing, managing applications and information efficiently Skilled in dissecting intricate IP networks that deliver voice and other data elements. Developing applications using Python to extract and analyse data from various systems. Having experience using with Alteryx tool for more complicated data in tableau. Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-Down menu option and parameterized using Tableau Desktop. Having experience in working with data modelers to translate business requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models. Having experience in Snowflake DWH, AWS S3, AWS Redshift, AWS Lambda, AWS CloudWatch. Having experience in designing customized interactive dashboards in Tableau using Marks, action, filters, parameter, security concepts, calculations and relationships. Having experience in identifying, analysing and interpreting trends and patterns in complex data sets. Developed customized views and reports in Airtable to facilitate data access and collaboration We Ensures accurate accounting and reporting of investment activities. We analyses investment data to derive insights and support decision-making. Implemented AWS security best practices including IAM policies, security groups and encryption. Having experience in creating Level of Detail (LOD) expressions, calculated fields, mapping and hierarchies. Used TabPy to connect the data to Tableau to create dashboards. Created custom views (grid, calendar, gallery) in Airtable to visualize trends and patterns Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and statistic datasets. Analysed complex IP networks to optimize performance and ensure seamless voice and data communication. Collaborated with network engineers to troubleshoot connectivity issues and enhance network reliability. Collaborated with cross-functional teams, using Airtable to track project milestones and manage workflows Tracked project milestones and reported progress to stakeholders Implement and manage data warehousing solutions on AWS, including Amazon Redshift, amazon RDS, and Amazon S3. Having experience in blending data from multiple databases into one report by selecting primary keys from each database for data validation. Automate data workflows and scheduling using AWS Glue, Lambda functions, and Airflow. Experience in working under Agile (Scrum) and waterfall models of software development life cycle. Ability to meet deadlines and handle multiple tasks, team player, motivated, able to grasp things quickly with analytics and problem-solving skills. Proficient with Excel in using V-lookups and other advanced functions. Proficient in the use of TSQL for developing (DDL/DML) query writing, and SQL joins. Proficient in creating concise and informative status reports. Ensured data accuracy by meticulously entering and validating information in Airtable EDUCATIONAL QUALIFICTION: Bachelor of Engineering (B.Tech, Computer Science) from Lord s College of Engineering in 2011 with 75%, JNTU, Hyderabad INDIA. TECHNICAL SKILLS: BI/Reporting Tools: Desktop, Tableau Server ,Tableau Public, Tableau Online, Tableau Reader and Tableau Mobile,QlikView, Power BI,Alteryx,Snowflake. ETL Tools: Microsoft BI,Informatica. Databases: SQL, Oracle,Unix,Excel, MySQL,Oracle DB,Copiolt. Scripting Language: Python, Java,Git/GitHub. Programming Language: Core Java,C#.net,Asp.net,JSON. Defect management tool: HP Quality Center/ALM, MS SQL Server, Oracle, Jira. CERTIFICATIONS: Certified Tableau Desktop Specialist. PROFESSIONAL EXPERIENCE: Marvell Semiconductors Santa Clara Jan 2023 Jun 2024 Role: Sr.Data Analyst/Supply Chain Business Analyst Project: MO2S Environment : Tableau (Desktop/Server), Tableau prep, MS SQL Server, Alteryx 11.0&11.3, Python, AWS Redshift/S3, AWS Lambda, snowflake, Microsoft Office Suite (Word, Excel, PowerPoint). Roles and Responsibilities: Experienced in gathering business requirements, collecting data from different data sources, generating metrics, building reports, providing data insights and documenting the process. Performing as a supply chain Business Analyst in the semiconductor industry focusing on process improvement, analysing and integrated Supply chain, Marketing, Finance and sales teams in the project. Performed the entire project life cycle from Analysis, Development, Testing, Production and end user support, worked closely with business users and Platform Team while gathering requirements. Created and managed Airtable bases to collect and organize data from various sources Worked with Excel and CSV files, created extract files and live data and performed data preparation. Worked on Modifying basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets. Designed and developed visually compelling reports and interactive dashboards using Tableau Desktop. Loading structured and semi structured data into snowflake and Triaging, cleansing, validating the data in Snowflake using different features of snowflake. Gathering all the required metadata of the objects and classifying the objects according to the complexity. Designing Warehouses, DBs, Schemas and Tables in Snowflake. Tracked data reports and created dashboards for analysing Creating different user roles and assigning them to downstream users and securely sharing the data with them. Developing Python scripts to ELT data from Oracle/AWS S3/APIs into Snowflake, creating AWS lambda functions to run the python scripts and scheduling the lambda functions using AWS CloudWatch. Having experience in creating detail level summary dashboards with usage of trend lines, statistics, groups, hierarchies, sets and KPIs. Defined best practices for creating Tableau Dashboards by matching requirements to the charts to be chosen, color patterns as per user s needs, standardizing dashboard s size, look and feel. Common Securitization Solutions Feb 2018 Aug2022 Role: Data Analyst( Tableau Developer ) Project: CSS Environment: Tableau Desktop 2018.2, ,Alteryx 11.0&11.3,Tableau Server 2018.2,MS Excel, SQL Server 2016,JIRA, SSIS,SSRS. Responsibilities: Responsible for identifying and translating business requirements for the Enterprise Data Warehouse into logical and physical data models working closing with DB Architect. Interacted with Business Analysts and Data Modelers for defined mapping and design documents for various sources and targets. Worked with Excel and CSV files, created extract files and live data and performed data preparation. Identified the key facts and dimensions necessary to support the business requirements Having experience in translating business requirements into visualizations and design documents. Worked on Creating calculations and parameters to change data dynamically. Created SSIS packages to reduce the performance issues in the Tableau Dashboard. Used various types of aggregations like Sum, Average, Count, Count (distinct), Median, Minimum, Maximum, Percentile and Std. Deviation, etc. to build strong informative dashboards. Having experience in creating detail level summary dashboards with usage of trend lines, statistics, groups, hierarchies, sets and KPIs. Developed automated processes to synchronize data between Airtable and Tableau, ensuring data accuracy and real-time updates Designed automated workflows to sync Airtable data with Tableau for real-time reporting Worked extensively on developing metrics, attributes, filters, reports, scorecards, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data. Heavily Used combined axis and dual axis charts with multiple measures. Developed Tableau workbooks to perform year over year, YTD, QTD and MTD type of analysis. Worked on creating visualizations using custom hierarchies, groups and merged data from multiple sources using the data blending technique with in the tableau workbook. Created different visualizations using cross tables, Bar charts, Pie charts, Maps, line charts, scatter plots using Tableau Desktop. Worked extensively on joining geographic data from various data sources and formatting that data in Tableau. Defined best practices for creating Tableau Dashboards by matching requirements to the charts to be chosen, color patterns as per user s needs, standardizing dashboard s size, look and feel. Created location hierarchies, building and presented a basic map view and applied key mapping features to the dashboards. Worked on Modifying basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets. Designed and developed visually compelling reports and interactive dashboards using Tableau Desktop. Worked on Created Maps to provide the count of providers in different geographic locations. Heavily handled Tableau admin activities granting access, managing extracts and Installations. Performed Data analysis and enhance quality assurance checks. Involved in scheduling data refresh on Tableau Server for weekly and monthly basis to ensure that the views and dashboards were displaying the updated data correctly. Involved in code review, unit, system and regression testing. Documentation of all the dashboards describing the purpose of the dashboard, all the elements used in the dashboard and any additional notes related to the dashboard. Performed A/B testing on several campaigns. Brought new KPI s to measure the web content- Bounce Rate. MTD analysis on campaign performance and keyword search. Pentagon Federal Credit Union Oct 2015-Jan 2018 Role: Tableau Developer (Data Analyst) Project: PFCU Environment: Tableau (Desktop/Server 10.5, MS SQL Server, MySQL, SAS, SharePoint, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Python, NumPy, Alteryx,Pandas, Matplot lib, TabPy. Collecting and analysing behavioural data, Performed the entire project life cycle from Analysis, Development, Testing, Production and end user support, worked closely with business users and Platform Team while gathering requirements. Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other Local and Global filters according to the end user requirement. Experienced in gathering business requirements, collecting data from different data sources, generating metrics, building reports, providing data insights and documenting the process. Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions. Design and develop Tableau visualization solutions. Responsible for identifying and translating business requirements for the Enterprise Data Warehouse into logical and physical data models working closing with DB Architect. Interacted with Business Analysts and Data Modelers for defined mapping and design documents for various sources and targets. Defined best practices for creating Tableau Dashboards by matching requirements to the charts to be chosen, color patterns. By using matplot lib package created histograms, scatterplots, bar charts and correlation matrix to present data insights for ad-hoc requests. Used Numpy and Scikit learn, for arithmetic calculations to show the inventory of hardware asset management. Used TabPy to include python scripts to connect to tableau. HeartToHeart Network LLC Jan 13-Aug 15 Role : MS SQL Server Developer Environment: MS SQL Server, Microsoft Office Suite (Word, Excel, PowerPoint),MS Visual studio,Windows XP Professional,ProClarity,SSIS,SSRS,SSAS. Roles and Responsibilities: Worked on Full Cycle development SDLC involving in all stages of development. Created SSIS Packages and SSRS Reports for comcast Accrual and Payment process. Created Database Objects Schemas,Tables,Indexas,Views,User defined function,Cursors,Triggers,Stored Procedure,Constraints and Rules. Extensively used Joins,CTEs,Table Variables,Global and Local Temp tables. Involoved in day-to-day maintaince of database objects,SSIS Packages and SSRS Reports. Worked with Scheduling and publishing of reports in SQL Server reporting services and integration with Microsoft office tools like automatically emailing reports in various formats such as Excel,PDF etc. Worked with Business analyst and the business users to understand the user requirements, layout, look and feel of the application to be developed. Worked with T-SQL,DBCC,DCL,DDL,DML scripts and established relationships between tables using Constraints. Keywords: csharp business intelligence sthree database active directory rlang information technology hewlett packard microsoft Delaware