SQL
Balaji G
Data Analyst
Hyderabad
Summary
Detail-focused Data Analyst with 4.5 years of knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
3
3
Languages
Work History
Data Analyst
HCL Tech
Hyderabad
11.2021 - Current
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Proficient in writing complex SQL queries, stored procedures, and functions. Experienced in database design, optimization, and performance tuning.
- Developing and maintaining data visualization solutions using Power BI or other BI tools.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Conducting data analysis and presenting insights to stakeholders.
- Created optimal technical solutions to user needs with in-depth system analysis.
- Creating ad-hoc and standardized reports using SQL and/or Power BI.
- Collaborating with cross-functional teams to define key performance indicators (KPIs).
- Analyzed business requirements and created functional requirements specifications to build and deploy solutions.
- Developed and enhanced reports connecting to single or multiple data sources to improve performance.
- Monitored and troubleshot data source systems for data flaws and errors and upstream data issues.
- Skilled in creating interactive dashboards, reports, and visualizations using Power BI. Proficient in data modeling, DAX formulas, and data transformation.
Software Engineer
Servtek PVT LTD
Bangalore
09.2018 - 10.2021
- Analyzed existing SQL queries to identify opportunities for improvements.
- Created optimal technical solutions to user needs with in-depth system analysis.
- Analyzed business reports for prompt communication, follow-up and ongoing support.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
- Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.
- Developed applications and designed processes for transformation and data management from company-wide databases.
- Debugged systems and fixed program malfunctions quickly.
- Creating ad-hoc and standardized reports using SQL and/or Power BI.
- Providing data-driven recommendations and insights to drive business decisions.
Education
B.TECH - Computer Science And Engineering
Sreyas Institute Of Engineering And Technology
Hyderabad,Telangana 06.2011 - 08.2015
Skills
Data analysis
Data formatting
SQL development
T-SQL coding
Business Intelligence
Data visualizations
Power Bi
SSIS
SQL Server Integration
Data Modelling in Query Editor
Table relationships and Data Analysis Expression(DAX)
Software
POWER Bi
SSIS
ETL
Timeline
Data Analyst
HCL Tech
11.2021 - Current
Software Engineer
Servtek PVT LTD
09.2018 - 10.2021
B.TECH - Computer Science And Engineering
Sreyas Institute Of Engineering And Technology
06.2011 - 08.2015