Data Analyst Quality Assurance

VISHNU VARDHAN KONDA

DATA ANALYST

+1-940-***-**** ******************@*****.*** https://www.linkedin.com/in/vishnuvardhank0987/

Summary

Highly skilled Senior Data Analyst with over 5 years of experience in data modeling, ETL processes, and data visualization across finance, healthcare, and technology industries. Proven ability in validation, statistical methods, and strategic analysis to optimize data processes, automate reporting, and design effective dashboards that generate actionable insights, driving business performance. Adept at handling diverse datasets and managing data lakes to support analytical needs. Skilled in developing recommendations and implementing quality assurance for project execution in fast-paced environments. Strong oral and written communication skills, adept at providing feedback and aligning projects with business objectives. Detail-oriented with strong time management skills, able to balance multiple priorities effectively. Collaborative approach with a focus on customer engagement, critical thinking, and analytical support. Visionary in leveraging a comprehensive tech stack for scalable, secure solutions, and AI-driven analytics. Continuously learning and leveraging best practices to deliver impactful data-driven solutions.

Skills

Data Analytics & Statistics: Statistical Analysis, Regression Analysis, A/B Testing, Trend Analysis, Success Metrics, Key Performance Indicators (KPIs)

Strategic & Validation: Data validation processes, strategic analysis for process improvement, and project management tools for efficient execution.

Data Science & Big Data: Hadoop, PySpark, Databricks, S3, Redshift, Data Lake Management, Machine Learning, Predictive Modeling, AI Integration, Streaming Data Processing, Analysis of Large Data Sets

Project Management & Quality Assurance: End-to-end project management from roadmap development to implementation, ensuring quality assurance, managing status updates, and meeting performance metrics. Adept at coordinating research efforts and managing complex projects.

Data Visualization Tools: Tableau, Power BI, Microsoft Excel, Advanced Dashboard Design, Data Visualization Best Practices, Pivot Tables

Collaboration & Communication: Strong verbal and written communication skills, effective collaboration across cross-functional teams, and ability to translate complex data insights into actionable business recommendations. Skilled in customer engagement, providing constructive feedback, and facilitating business reviews.

Technical Proficiency: SQL, Python, R, SPSS, SAS, API Integration, Microsoft Access, Oracle, SQL Server, DB2, Teradata, AWS S3, Redshift, scalable cloud solutions, and software infrastructure.

Problem-solving & Analytical Support: Analytical thinking, root cause analysis, solving complex data challenges, and developing innovative solutions. Strong computer science principles applied to data processes.

Ad Hoc Analysis: Expertise in conducting ad hoc analysis to address immediate business needs and provide quick, data-driven insights.

Market & Enterprise Analytics: Experience in analyzing market trends and providing insights to support enterprise-level decision-making.

Attention to Detail: Highly detail-oriented, ensuring accuracy and thoroughness in data analysis, documentation, and reporting processes.

CCPA Compliance: Knowledge of data privacy regulations, ensuring compliance with CCPA and other data protection standards.

Continuous Improvement: Focused on process optimization and implementing continuous improvement initiatives to enhance data quality and operational efficiency.

Business Case Development: Skilled in developing business cases and presenting findings to stakeholders, supporting data-driven decision-making and strategic alignment.

Work Experience

Frost Bank Texas, USA

Senior Data Analyst Oct 2022 - Present

Frost Bank offers comprehensive banking and financial services with a strong emphasis on customer care.

•Gathered requirements and analyzed data by interacting with business users to understand reporting needs, enhancing BI capabilities for the user community

•Designed logical and physical data models, transforming them into physical implementations and normalizing data to the word Normal form, improving data integrity

•Created Entity/Relationship Diagrams, grouped and created tables, validated data, and identified primary keys for lookup tables, ensuring accurate data relationships

•Modeled data using Star Schema methodologies to build and design logical data models into Dimensional Models, enhancing data organization

•Documented source to target mappings for data integration and web services, facilitating clear data flow and integration

•Collaborated with the MDM team on various business operations, enhancing data management processes

•Developed data models for Claims, Members, and Providers for different claim types and Health Partner Incentive programs, improving data accuracy and reporting

•Formulated ER diagrams of Property and Casualty data and data flow diagrams to interact with database developers, streamlining data processes

•Utilized Erwin's forward/reverse engineering tools and target database schema conversion process, enhancing database design efficiency

•Designed data marts in dimensional data modeling using star and snowflake schema, improving data accessibility and analysis

•Redefined attributes and relationships in the reverse-engineered model and cleansed unwanted tables/columns, enhancing data quality

•Collaborated with ETL/Informatica teams to source data and perform data analysis, identifying gaps and improving data accuracy

•Developed ETL routines using SSIS packages, planning effective package development and designing control flow, enhancing data processing efficiency

•Presented dashboards to business users and cross-functional teams, defining KPIs and identifying data sources, improving decision-making

•Examined KPIs for Property and Casualty such as Loss Ratio and Operating Expense Ratio, providing insights for performance improvement

•Implemented and updated data governance procedures, standards, training documents, and presentations, enhancing data management practices

•Acquired knowledge of big data technologies like Hadoop, Spark, Hive, Pig, and Tableau frameworks, expanding data analysis capabilities

•Collaborated with AWS for application deployment, enhancing system reliability with high availability and auto-scaling solutions

•Published workbooks and data sources to the Tableau server for review, enabling users to slice and dice data for deeper insights

•Integrated Power BI with Microsoft tools like Azure, Excel, SharePoint, Teams, Power Automate, and Power Apps, enhancing data analysis and collaboration

•Designed Power BI and Tableau dashboards to present KPIs like Loss Ratio and Operating Expense Ratio, improving executive decision-making and contributing to a 10% improvement in financial reporting accuracy.

•Partnered with cross-functional teams to present data-driven insights through detailed reports and visualizations, leading to a 10% increase in user adoption of BI tools.

Baylor Scott & White Health Company Texas, USA

Data Analyst Nov 2022 - Sep 2022

Baylor Scott + White Health is a major healthcare system in Texas, providing a broad spectrum of medical services across various facilities.

•Designed, developed, and delivered/implemented data solutions to include architecture design, prototyping of concepts to proof of concept, development of standards, design, and development of test plans, code and module design, development and testing, and data solution debugging.

•Led the design and development of data models and ETL processes, which improved data accuracy and reduced ETL processing time by 100%.

•Completed a comprehensive study of in-house data warehouse requirements, leading to more accurate data analysis and reporting

•Performed logical and physical data modeling, enhancing the accuracy and efficiency of data storage and retrieval

•Normalized databases and developed multi-dimensional STAR schema, optimizing data storage and reducing retrieval time by 100%

•Identified facts and dimensions for dimensional models, resulting in efficient multi-dimensional STAR schema.

•Worked with data compliance teams and data governance team to maintain data models, Metadata, and Data Dictionaries: defined Dimensional Data Modelling to deliver Multi-Dimensional STAR schema.

•Participated in technical meetings and rapid audits, contributing to improved system requirements and business process analysis

•Gathered product information and shopping history data, providing insights for sales planning and strategy development

•Created comprehensive dashboards and visualizations in Power BI to support business intelligence and decision-making processes.

•Developed Power BI dashboards that integrated data from Azure services, enabling comprehensive, real-time reporting for key stakeholders

•Generated periodic reports based on the statistical analysis of the data from various times and divisions using SQL Server Reporting Services (SSRS).

•Designed data stage ETL jobs for extracting data from heterogeneous source systems, transforming, and finally loading it into the Data Marts.

•Provided a rich set of visualizations and tools in Power BI, turning raw data into meaningful insights for data-driven decision-making.

Visa Bengaluru, India

Data Analyst Aug 2020 - Jul 2021

Visa is a global leader in digital payments, facilitating secure and seamless transactions worldwide. Contributed to requirements gathering, system design, and data integration, and developed solutions for automating data processes and generating comprehensive reports.

•Conducted JAD sessions, wrote meeting minutes, and documented requirements, improving stakeholder clarity and alignment.

•Automated data extraction and reporting processes using Python, reducing manual effort by 90% and increasing report accuracy by ix%.

•Designed and built data marts using STAR schema, streamlining data retrieval and reporting for business users, improving analysis speed by 100%.

•Integrated data from multiple databases into Power BI, improving data visibility across departments and supporting better decision-making.

•Designed Context Flow Diagrams, Structure Charts, and ER diagrams, facilitating better understanding and communication of system architecture

•Collected requirements from business users and analyzed them to design and build Data marts using Star Schema, which streamlined data retrieval and reporting

•Conducted extensive system study, design, development, and testing in the Oracle environment, ensuring solutions met customer requirements effectively

•Served as a member of a development team, providing business data requirements analysis services, which resulted in accurate logical and physical data models using Erwin v.0 and Power Designer

•Created tables, views, procedures, and SQL scripts, enhancing database functionality and performance

•Used Python to extract weekly bed availability information from XML files using underscore JS, improving data accessibility and reporting accuracy

•Automated various data extraction, transformation, and loading tasks with Python, reducing manual effort and increasing efficiency

•Created DataStage Server jobs to load data from sequential files, flat files, and MS Access, ensuring data integrity and consistency

•Architected Workflows, Activity Hierarchy + Process Flows: designed EDW / CDW components, which improved data processing and management

•Integrated data from multiple databases and systems into Power BI for comprehensive analysis, enhancing data visualization and insights

•Prepared reports, extracts, and integrated existing data in Power BI to support analysis, visualizations, and statistical models, improving decision-making capabilities

•Worked with Azure Data Factory (ADF) to compose and orchestrate Azure data services, integrating data from multiple databases and systems into Power BI for comprehensive analysis, which enhanced data processing and reporting.

Godrej Groups Bengaluru, India

Program Data Analyst Jan 2019 - Jul 2020

Godrej Group is a diversified Indian conglomerate interested in consumer goods, real estate, appliances, and agriculture. Involved in gathering requirements, automating data processing, and generating reports for data analysis and business insights.

•Gathered requirements from business analysts and operational analysts and identified the data sources required for the reports needed to the customers.

•Automated complex data processes using Python, resulting in a 30% reduction in processing time for data analysis tasks.

•Developed SQL scripts for large data pulls, leveraging Teradata advanced techniques like rank and row numbers, improving data analysis efficiency.

•Created and optimized PivotTables and Excel-based reports to present data trends, increasing clarity in management reports and aiding decision-making

•Developed programs with manipulate arrays using libraries like Numpy and Python.

•Performed performance tuning and optimization to increase script efficiency by creating indexes, adding constraints, and optimizing queries

•Generated reports using Proc Tab, Proc Report, Data Null, Proc SQL, and Macros. Utilized OLAP functions like sum and count to enhance data analysis

•Communicated with business users and analysts on business requirements. Gathered and documented technical and business Metadata about the data.

•Created summary reports and tabular reports based on business requirements (could imply that Power BI was used if applicable)

•Worked with various Business users to gather reporting requirements (could involve translating those requirements into Power BI dashboards or reports).

•Wrote Korn shell scripts to automate jobs and connected Teradata to MS Excel using ODBC for automated reporting

•Documented scripts, specifications, other processes, and preparation of Technical Design Documents.

Education

University of North Texas

Master, Information Science

Certifications

Microsoft Certified: Data Analyst Associate.

Microsoft Power BI Data analyst.

Contact this candidate