Business Intelligence Analyst Resume

AREAS OF EXPERTISE:

TECHNICAL SKILLS:

Languages: SQL, Visual Basic. HTML

Software: SSMS/SQL Server, Visual Studio, and SQL Server Data Tools, BIDS, TFS

BI: SSRS (SQL Server Reporting Services), SSIS, SSAS, Excel Reports

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Analyst

Responsibilities:

Created and edited many SSRS reports. Worked with the report requestors in order to understand their requirements then edited or created new reports based on requirements
Created reports, KPIs and indicators (using SSRS and Excel) based on company objectives and priorities
Worked with users in order to explain report results, query details and to validate report details
Troubleshoot SSIS packages, created new packages for new data sources, and edited existing packages
Troubleshoot database query issues and problems (including performance troubleshooting)
Created views, stored procedures, SQL scripts, tables in SQL Server 2008 and 2016
Assisted in upgrading from SQL Server 2008 to SQL Server 2016 by performing tests and validations. Moreover, troubleshooting and query problem detection
Troubleshooting with cube designs and data marts, assisted with data mart and cube design
Provided DBA support: query tuning and SQL Server performance optimization, SQL Server upgrade project (testing reports, troubleshooting slow (regressed) queries and investigating error messages)
Provided application support for reporting applications
Provided application support for C# and VB for ETL applications written in VB and/or C#
Provided technical documentation

Confidential

Business Intelligence Analyst/Data Quality Associate

Responsibilities:

Assisted in creation of SSAS cubes and data warehouse design
Tested complex SSIS packages involved in complex ETL operations from many different sources (XML, flat file, Excel file, raw file, web services, etc.)
Coded SQL objects based on technical documentation and algorithm
Created complex queries for reports
Performed many types of automated and manual tests: Stress Testing, Unit Testing, Integration Testing, Functional Testing, Compatibility Testing

Confidential

Data Management Analyst and Database Analyst

Responsibilities:

Managed and configured hospital’s EHR and Performance Management databases through Access. Automated tasks using Visual Basic for Access and through Stored Procedures (SPs) and SQL Triggers
Participated in collection of survey data, directly from the patients of hospital just prior to their discharge or sometimes after discharge.
Involved in data quality enforcement (by constraints), data quality checks and testing.