Data Analyst Resume

PROFESSIONAL SUMMARY

Experience in extracting, transforming and loading of data from various sources like excel and flat files.
Strong communication and interpersonal skills
Strong team player but can also work independently
In - depth knowledge of T-SQL including complex SQL queries.
Good expertise in complex query design, stored procedures, views and functions
Develop queries to retrieve and analyze data from multiple tables in the database, find tables using database diagram in SQL server, establish relationship in multiple tables using primary key and foreign keys.
Using all kinds of SQL server constraints like primary key, foreign keys, defaults, check constraints and unique identifier.
SQL Server Tools: SQL Server Management Studio, SSIS, SSRS, SQL Server Optimization wizard
Designed different types of reports; Tabular, Matrix, charts, Maps, Graphs, Gauges, Dashboards using SSRS and including different functionality like Drilldown, Drill through, conditional Formatting, parameters and sub-report based on client requirements
Ability to learn new technology in a short span of time integrating well in any environment and working well under pressure.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

Developed custom SQL scripts and complex queries for data analysis and extraction
Used temporary tables, table variables in stored procedures to simplify complex queries
Involved in modifying report content and exporting reports in multiple formats based on the business requirements.
Created multiple parameterized stored procedures that are used by the reports to get the data.
Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
Provide user specific ad hoc reporting as requested
Worked on healthcare standards such as HIPAA, ICD-9, 10.
Working knowledge of healthcare Technology standards and ISO standards

Confidential

Data Analyst/BI Developer

Responsibilities:

Develops Stored Procedures, tables, functions, and views using T-SQL
Responsible for creating, migrating, and maintaining database objects including tables, stored procedures, indexes, logins, views, triggers, and SQL Server Integration Services packages
Uses BI tools, SSIS, SSRS, T-SQL, Tableau
Creates SSIS packages following ETL good practices to clean, transform, and load data from different sources including Access, Excel, CSV, text files, and other databases
Develops business reports using SQL Server Reporting Services (SSRS) and uploads them to the Report Manager
Used merge joins in SSIS to combine data from different sources for loading into tables
Carried out data validation in SSIS using various transformations like conditional split, data conversion, derived column, merge, merge join, multicast, row count, union all, sort, lookup; tasks like execute SQL task, file system task, send email task and containers like sequence and for each loop containers.
Monitors database performance, disk space usage, scheduled jobs, and error logs
Works with customers to understand requirements then design database systems to implement effective solutions

Confidential

Data Analyst/BI Developer

Responsibilities:

Designed efficient ETL processes using Microsoft SQL server stored procedures and sever integration services that imports information from loan officer and new homeowners.
Created SSIS package to load files into staging tables where data cleansing, validation and transformation are done based on requirements.
Carried out data validation to filter good records from bad ones based on conditions like filtering records with nulls, bad SSN, incomplete phone numbers and zip codes, etc.
Sent bad records to loan officers for rectification by configuring the script task and send mail task to send the bad files back to loan officers.
Developed tables, stored procedures, functions and other database objects as needed
Designed, developed, and deployed complex SSRS report.
Extensively used joins and sub queries for complex queries involving multiple tables from different databases.
Performed operations to optimize and trouble shoot packages, queries, stored procedures, indexes and reports.
Created different types of reports using maps, charts, dashboards, gauges, funnel and included functionality like drill through, drill down, sub reports and conditional formatting.
Analyzed meaningful use report requirements and developed the reports using visual studio.
Provided after hours and weekend support to database customers as required
Collaboratively developed and communicated project plans, work assignments, target dates and other aspects of assigned projects
Ensured that projects follow prescribed development life cycle and meet quality standards
Conducted and participated in meetings with organizational stakeholders to identify and build solutions to address increased data, transformation, storage and consumption needs

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship