Summary
Overview
Work History
Education
Skills
Timeline
Generic

RAMASWAMY GUMMADI

Frisco,TX

Summary

Performeddata analysis anddata profiling using complex SQL on various sources systems including. Experience in development of Process Flow Diagram,Use Case Diagram, Activity Diagram, and Database schema generation using UML tools like Visio and Oracle SQL developer Experienceintesting andwriting SQLandPL/SQL statements - Stored Procedures, Functions, Triggers,andpackages. Strong understanding of database concepts and SQL programming, enabling efficient data retrieval and manipulation for reporting purposes. Experience in writing complex SQL queries to perform data completeness, correctness, data transformation and data quality verification for source to target mapping. Good knowledge in analysis and reporting using various Business Intelligence tools such as Cognos, Power Bi, Tableau and BusinessObjects. Created scheduled data refresh and automated data refresh workflows within Power BI to ensure up-to-date and accurate reporting Formed various measures and calculated fields in Power BI and Tableau to answer business questions. Experience working on Microsoft Office, Word, PowerPoint, MS Excel. Adept at developing technical/quantitative solutions, as well as locating business intelligence insights to pinpoint trend identification and drive process re-engineering. Extensive experience in complete Software Development Life Cycle (SDLC) from analyzing, gathering and documenting business requirements, initiating design and development sessions with technical teams to documenting and implementing test strategies and test plans, user training, overseeing production deployment and managing resolutions to production issues.

Overview

3
3
years of professional experience

Work History

DATA ANALYST

R
01.2019 - 01.2022
  • Wrote and executed complex SQLqueries for accessing,analyzing,andmanipulating the schedule data
  • Provided SQL queries to extract data from Legacy Systems, focusing on alerted accounts and customer information for integration into the Portfolio Analyzer system
  • Created SQL queries to extract data from multiple sources for reporting purposes
  • Performed feature engineering onhigh dimensional datasetsin order toimprove accuracy of predictive models
  • Monitor project progress and identify potential risks or deviations from the plan
  • Quality Assurance: Ensure that delivered solutions meet the specified requirements and are of high quality
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata Strong understanding of database concepts and SQL programming, enabling efficient data retrieval and manipulation for reporting purposes
  • Power BI: -Conducted data exploration and performed advanced analytics using Power BI, including data slicing, drill- down, and cross- filtering to uncover trends, patterns, and correlations
  • Collaborated with stakeholders to gather requirements and translate business needs into actionable insights through Power BI reports and dashboards Created dashboards with
  • Tableau and Power BI for data visualization
  • Leveraged data analytics tools such as Tableau or Power BI to evaluate customer behavior patterns
  • Established key metrics and tracked progress against goals on an ongoing basis using Tableau and Power BI toolsets
  • Utilized advanced analytics tools such as Tableau and Power BI to analyze data points and generate actionable insights
  • Created dashboards using data visualization tools such as Tableau or Power BI for tracking organizational risk metrics over time
  • Tableau: -Developed data visualization solutions for complex business problems utilizing Tableau, Python Established automated reporting protocols to ensure timely delivery of insights to stakeholders
  • Utilized machine learning algorithms to optimize data visualization processes, Defined data and reported specifications to business stakeholders
  • Utilized data analytics tools such as Tableau to analyze customer behavior patterns and develop strategies accordingly
  • Developed dashboards and visualizations with Tableau to present complex analyses in an easy-to-understand format
  • Created reports and dashboards using Tableau to visualize complex datasets
  • Utilized advanced analytics tools such as Excel, Tableau and SQL to analyze large datasets
  • Leveraged analytics tools such as Salesforce and Tableau to monitor performance metrics and optimize sales processes
  • Utilized advanced analytics tools such as Tableau and Microsoft Power BI for reporting purposes
  • Utilized various tools such as Visio
  • Excel, Access, Power BI and Tableau for data visualization. Python: -Automated manual tasks by developing scripts utilizing Python libraries like Pandas and NumPy
  • Created automated solutions using Ansible playbooks, shell scripting and Python programming language
  • Utilized SQL and Python scripting to extract, transform, and load data into databases
  • Developed distributed systems that leverage microservices architecture with NodeJS and Python technologies
  • Built automated scripts using Python or Bash shell scripting language for daily tasks
  • Developed scripts in Python to automate data processing tasks
  • Utilized Python programming language for data analysis, manipulation and visualization of complex datasets
  • Implemented unit tests for Python applications using the unit test library
  • Snowflake: - Demonstrated ability to manage multiple tasks while remaining adaptable and flexible
  • Responded quickly to meet customer needs and resolve problems
  • Committed to delivering excellent customer service while working in a fast- paced environment
  • Participated in ongoing training to enhance own job skills and knowledge
  • Provided efficient and courteous service to customers at all times
  • Met deadlines while maintaining high-quality deliverables
  • Skilled in using various software applications and programs including Microsoft Office and Adobe Creative Suite
  • Identified ways to improve efficiency in operations and implemented process changes
  • Managed and coordinated multiple projects while ensuring timely completion
  • Troubleshot minor problems and reported larger technical issues
  • Experienced with social media and communications platforms
  • Performed general maintenance and repair
  • Collaborated with departmental leaders to establish organizational goals, strategic plans and objectives
  • Developed departmental objectives, budgets, policies, procedures, and strategies
  • Sought continuing education opportunities to stay current with industry trends.

Education

MASTERS - INPRODUCTMANAGEMENT/ INFORMATION TECHNOLOGY MANAGEMENT

Campbellsville University

Skills

  • SQL
  • DataVisualization
  • Software development life(SDLC)
  • Business Intelligence (BI)
  • Python
  • Microsoft Access
  • Microsoft SQL Server
  • Snowflake
  • Business Objects XI
  • MS Excel
  • Tableau
  • Business Analysis
  • Agile project management
  • Power BI
  • Data Analytics
  • MSoffice
  • MS Word
  • Powerpoint

Timeline

DATA ANALYST

R
01.2019 - 01.2022

MASTERS - INPRODUCTMANAGEMENT/ INFORMATION TECHNOLOGY MANAGEMENT

Campbellsville University

Similar Profiles

CREATE PROFILE
RAMASWAMY GUMMADI