POGU RAAMCHARAAUN

I am a dedicated Data Analyst who enjoys working with data to find meaningful insights. With experience in education, automobile, and corporate environments, I help organizations make better decisions through accurate reporting and analysis. I believe in continuous learning, teamwork, and delivering reliable results.

Having 10+ Years of experience in Data Analysis utilizing Looker Studio and Microsoft Power BI and SQL SERVER and Excel.
• Extracting the data from various data sources into BI and worked on all type of transformations that are available in Query Editor and to generate Reports and Dashboards.
• Expertise in extracting the data from various data sources by using various types of connection modes like Import, Direct Query and Live Connection modes.
• Good experience on building the relationships between datasets like One to One, Many to One, One to Many, Many to Many
• Worked on DAX (Data Analysis Expression) Programming Language.
• Good knowledge on creating Calculated Columns and Measures by using DAX Functions like Logical, Date and Filter, Text, Aggregate, Time Intelligence and Information functions
• Implemented YTD, QTD, MTD and Date operations by Using Date functions in DAX. These functions are useful to analyses business trends.
• Used standard visualizations like Slicer, Card, stacked column chart, clustered column chart, Line and stacked column chart, Line and clustered column chart, map, Pie-Charts, Bar Graphs, Drill downs, Drill through, Navigation Reports etc... Using BI.
• Implemented On-premises Data gateways which act as a bridge to provide quick and secure data transfer between On-premises data to several Microsoft Cloud Services.
• Developing reports and dashboard with BI to understand the business trend quickly.
• Responsible for Scheduling reports for weekly, daily data refresh on different BI reports
• Hands on experience and knowledge in end-to-end Data Integration implementation which includes gathering Client Requirements, Analysis, Design, Testing.
• Experience in writing SQL queries by using constraints, joins and Sub-Queries as well as indexes and views, store procedures and Functions in SQL server
• Temporary Table, string Functions and date Functions in SQL server.

 B. Tech in Mechanical Engineering from JNTU University 1997-2001.