• Data Analyst with Around 4 years of experience possesses a strong foundation in Data analysis, Statistical Techniques, Data Modeling, Evaluating Data Sources, and understanding of Data Warehouse/Data Mart Design, Data visualization and Client/Server applications.• Good knowledge of Software Development Life Cycle (SDLC) and various methodologies such as Agile and Waterfall.• Demonstrated expertise in relational databases, with a proven track record of creating complex queries and performing optimizations using SQL.• Good Knowledge of IDEs like Visual Studio Code, and PyCharm.• Expertise in writing SQL Queries, Dynamic Queries, sub-Queries and joins for generating Stored Procedures, Triggers, User-defined Functions, Views and importing Data from excel.• Skilled in extracting, cleaning, and transforming large datasets from various sources using SQL, Excel, and Python to ensure data accuracy and integrity.• Proficient in data visualization tools such as Tableau or Power BI to create compelling visualizations, dashboards, and reports.• Proficient in analyzing complex datasets, identifying patterns, and extracting actionable insights to support business decision-making.• Understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture, and Designing.• Capable of Text Analytics, generating data visualizations using Python, and creating dashboards using tools such as Tableau, Power BI, and MS Excel.• Collaborates effectively with cross-functional teams to understand business requirements and translate them into data analysis tasks.• Strong attention to detail, ability to manage multiple projects and meet deadlines, while maintaining data integrity and quality standards.• Proficiency in SQL Server development, System Analysis, Design, and Development Support of MS SQL Server.• Highly skilled in Tableau Desktop for data visualization, utilizing various chart types such as Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Page Trails, Heat Map, and Density Chart.
-
Business Data AnalystCigna HealthcareIrving, Tx, Us -
Data AnalystCigna Healthcare Feb 2024 - PresentUnited States• Create and maintain data dashboards and reports using Excel and SQL.• Performed quality assurance checks to ensure data integrity and accuracy. Supporting senior analysts in ad-hoc analysis and project work.• Wrote several complex SQL queries to extensively test the ETL process. Performing data analysis and maintenance on information stored in MySQL database.• Working on developing Python script for the whole data science project life cycle including data acquisition, data cleaning, data exploration, and data modeling.• Collaborate with stakeholders to gather requirements and define project objectives.• Working with NumPy, Pandas, Matplotlib, Seaborn, ggplot, Scikit-Learn libraries for developing various algorithms.• Designing and deploying dashboards with Tableau and providing complex reports to the team and stakeholders.• Successfully extracting data from multiple sources including flat files, MS Excel, and MS Access, employing data transformation techniques to ensure data accuracy and consistency, facilitating efficient data processing and analysis.• Write extract, transform, and load (ETL) code to automate routine data collection and reporting processes using a variety of large-scale distributed data systems. Designs and develops BI solutions using Snowflake as the backend data repository.• Builds and maintains dashboards, reports, and visualizations using BI tools (e.g., Tableau, PowerBI) connected to Snowflake.• Collecting and iteratively refining specifications from management to augment current pivot table reporting with high-quality dashboard visualizations in Excel.• Extensively used ERWIN and PowerDesigner to design Logical and Physical Data Models, and to forward and reverse engineering data models and publishing data models to acrobat PDF files.• Using Denodo, Cloudera Hadoop, Alteryx, and Power Automate for effective analysis of data that is being used in visuals and to also test the joins and data against backend/database.
-
Data AnalystJpmorganchase Feb 2023 - Dec 2023United States• Implemented navigation buttons, used parameters to change the axis and swap the sheets for better dashboarding.• Participate in meetings and discussions to understand business problems and provide data-driven insights.• Worked on database design and query optimization, as well as providing several periodic and custom reports, resulting in a 30% decrease in query execution time and improving database efficiency.• Conduct ad-hoc data analysis requests and provide timely deliverables. Prioritize and manage multiple analytical tasks to meet project deadlines. Involved in complete Agile Requirement Analysis, Development, System, and Integration Testing.• Led a team of data analysts to develop and maintain complex financial models that forecast business performance and identify growth opportunities.• Designing and implementing data dashboards using Tableau and Power BI, enhancing the ability of executives to make data-driven decisions.• Conducting deep-dive analyses into customer behavior and transaction data, uncovering trends that informed marketing strategies and product development.• Automated reporting processes, reducing time spent on routine data tasks by 30%.• Assisted in the collection, processing, and analysis of large datasets to support banking operations.• Contribute to the development of data-driven strategies by providing insights and recommendations.• Collaborate with team members to identify opportunities for leveraging data to drive business growth.• Developed data wrangling through data gathering and querying process over SQL and implemented data cleaning process with R and Python.• Extracted data from Google Analytics and generated SEM reports to support effective campaigns.• Developed sales reports using the on-premises data on Microsoft Excel and Power BI.• Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data. -
Data AnalystAccenture Jan 2021 - Jul 2022India• Worked closely with QA and Developers to clarify/understand the functionality, resolve issues, and provide feedback.• Worked on ETL projects and reengineered the pipeline to extract data from Qualtrics server and store it in the AWS database.• Created impactful dashboards using Tableau for competitive pricing and sales analysis by analyzing the historical data and identifying KPIs which had a positive impact on sales and to help in decision making for the future marketing campaign.• Work extensively with advanced analytical action utilizing various filters, sets, groups, LOD, parameters, hierarchy, calculated fields, table calculations on Tableau reports and workbooks.• Handling large sets of data using Python and Tableau. Methodically writing complex queries for joining, filtering, and analyzing data using SQL Server. Create data stories and visualizations using Tableau and Power BI.• Automate different workflows, which are initiated manually with Python scripts and Unix Shell Scripting.• Optimized SQL query to render the dashboards faster, writing complex queries with subqueries joins to pull data from multiple tables pulling billions of records in lesser time than it used to.• Effectively used data blending, filters, actions, and hierarchies features for preparing dashboards.• Manipulated tableau parameter controls, hierarchies, and filters to achieve LOD expressions and geospatial design configurations leveraging multiple data joins for comprehensive analysis.• Perform data analysis and reporting tasks, utilizing SQL, Python, and Excel for data manipulation and analysis.• Migrating data to/from staging table in SQL from multiple data sources including Excel, CSV flat files, and other SQL servers.• Designed and developed data pipelines and ETL processes to extract, transform, and load data into cloud - based data warehousing solutions such as Amazon Redshift and Google Big Query.
Vamshi Yamjala Education Details
-
Business Analytics -
Loyola Degree And Pg CollegeCommerce (Honours)
Frequently Asked Questions about Vamshi Yamjala
What company does Vamshi Yamjala work for?
Vamshi Yamjala works for Cigna Healthcare
What is Vamshi Yamjala's role at the current company?
Vamshi Yamjala's current role is Business Data Analyst.
What schools did Vamshi Yamjala attend?
Vamshi Yamjala attended Texas A&m University-Commerce, Loyola Degree And Pg College.
Not the Vamshi Yamjala you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial