Data Analyst Sql Server

Aghastya Reddy Ganta

*************@*****.*** 901-***-**** TX

SUMMARY

IT professional with over 3 years of experience in Data Analysis, ETL Development, Data Modeling, and Project Management. Skilled in all phases of the Software Development Life Cycle, including requirements gathering, designing, and documentation. Proficient in both Agile and Waterfall methodologies. Strong expertise in Business and Data Analysis, Data Profiling, Data Migration, and Data Integration. Experienced in developing Statistical Machine Learning Models, Text Analytics, and Data Mining solutions using Python, R, and Tableau. Proficient in ETL processes with tools like SQL Loader and Informatica, and experienc ed in multiple databases such as MySQL, Oracle, and MS SQL Server. Expert in creating complex SSRS reports, stored procedures, triggers, views, and performance tuning in SQL Server. EXPERIENCE

HCL TECH, USA Sep 2023 – Present

Data Analyst

● Involved in every phase of the SDLC process starting from Inception to Transition.

● Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.

● Created Data mapping, and logical data modeling coordinated with data architects, created class diagrams and ER diagrams, and used SQL queries to filter data within the Oracle database.

● Involved in the below phases of Analytics using R, Python, and Jupiter Notebook.

● Wrote PL/SQL statements and stored procedures in Oracle for extracting as well as writing data.

● Used SSIS for data population from different sources and created SSIS packages for data conversions and loaded data from flat files and vice versa.

● Built multifunction readmission reports using Python pandas and Django framework.

● Worked on MongoDB database concepts such as locking, transactions, indexes, Sharing, replication, schema design, etc. Performed analysis on implementing Spark using Scala and wrote Spark sample programs using PySpark.

● Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh. Worked extensively with advanced analysis using Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, and sets to create detailed summary reports and Dashboard using KPIs. Meta systems, India June 2019 – Dec 2021

Data Analyst

● Led project initiatives utilizing the Waterfall methodology during the initial 50% of the project lifecycle, ensuring robust planning

● Worked with internal architects and, assisted in the development of current and target state enterprise data architectures.

● Defined the key identifiers for each mapping/interface.

● Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.

● Extensively used SQL for accessing and manipulating database systems.

● Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

● Created ad-hoc reports using SQL Server Reporting Services (SSRS).

● Used Erwin and Visio design to create Data Models for various kinds of databases as per the requirement.

● Used different Python libraries for data analysis and visualization of decision-making.

● Created and managed scheme objects such as tables, views, clusters, Indexes, Procedures, and triggers and maintained Referential Integrity.

SKILLS

Languages: SQL, R, Python, C++, Matlab

Web Technologies: HTML5, CSS3, Javascript

Cloud Technologies: AWS Dynamo DB, AWS S3, AWS RDS, AWS VPC Databases: SQL Server, MySQL, Teradata

Reporting Tools: Tableau, Power BI, SSRS

ETL Tools: SSIS, SSAS, Informatica

Tools: MS Office, PowerPoint, MS Visio, GitHub, TFS, Pivot Tables Python Libraries: Scikit, pandas, NumPy, NLTK, SciPy, matplotlib Methodologies: SDLC, Agile, Scrum, Waterfall, RUP

Operating Systems: Windows, Unix, Linux

EDUCATION

Masters in Business Analytics Texas A&M University-commerce, TX Bachelor in Business Administration Amity University, India

Contact this candidate