Data Analyst Iii
Lake Success, New York, Us
Collected and analyzed data from various business users, using multiple methods to meet project requirements while adhering to legal and court-ordered data standards.Designed and implemented normalized database tables according to RDBMS best practices, ensuring OLTP load efficiency.Led ETL processes with SSIS, DTS, and the Data Import/Export Wizard, managing both initial and incremental data loads. Cleaned and transformed data by removing duplicates and ensuring accuracy across all sources.Developed and maintained database applications in MS SQL Server, including writing stored procedures, triggers, views, tables, and functions to support data processing and load operations.Created automated, ad-hoc SQL reports for daily, weekly, and annual reporting using SSRS.Conducted unit testing on imported data and reports to ensure accuracy and consistency.