BI Analyst Resume Rockville, Maryland - Hire IT People

SUMMARY

Over 5 years of experience in using computer applications, to include, Excel Spreadsheet 2010, MS Word, MS Access, Crystal Reports, & Power Point.
Excellent verbal and written communication skills.
Proficient analytical skills.
Excellent problem solving skills and interpersonal skills.
Profound knowledge of relational data modeling.Knowledge of Master Data Management, & Tableau.
Experience with different scripting languages (T - SQL, PL/SQL)
Proficient with Microsoft SQL Server, and other major RDBMS.

TECHNICAL SKILLS

O/S: WINDOWS SERVER 2012, WINDOWS XP, WINDOWS 7, PowerShell, & UNIX

DATABASES: MYSQL, MSSQL SERVER, PL/SQL SCRIPTING (ORACLE), TSQL SCRIPTING (MSSQL)

BUSINESS INTELLIGENCE TOOLS: MS EXCEL, SQL SERVER ANALYSIS SERVICES.

REPORTING SERVICES TOOLS: MICROSOFT CRYSTAL REPORTS, SQL SERVER REPORTING SERVICES.

PROGRAMMING LANGUAGES: JAVA, C#, VISUAL BASIC.

DATA MODELING TOOLS: ERWIN, SSMS

OTHER APPLICATIONS: SHAREPOINT, MS VISIO.

Network: TCP/IP, DNS & Proxy Server

PROFESSIONAL EXPERIENCE

Confidential, Gaithersburg, MD

SQL Data Analyst

Responsibilities:

Set good rapport with coworkers and scientists working in labs.
Gathered requirements from scientist and managers of the labs.
Performed Requirement Analysis: Functional and non Functional requirements in Agile Software development Environment.
Performed User Acceptance, and Stress.
Created Test Cases and Test plans.
Created invites to schedule appointment for PC configuration.
Cleansed data related to medical instruments and data by discovering anomalies.
Performed ETL using SSIS to transfer excel and csv files to SQL Server.
Created Registry on the lab computers.
Created repository for backup of the data from the instruments.
Transferred data from lab computers to server.
Worked with vendors to resolve software or instrument issues and to gather information regarding the software upgrades.
Reconciled the SharePoint file with Excel spreadsheet.

Environment: Windows Server 2012, SQLServer 2012, Excel, SharePoint, Windows XP, Windows 7

Confidential, Rockville, Maryland

BI Analyst

Responsibilities:

Worked on data modeling using Entity- Relationship model (ER model):
Normalized the students' data for SQL Server database.
Documented Conceptual, Physical and Logical data Models.Designed Fact Table and Dimension data models:Star and Snowflake schemas.
Performed ETL processing using SSIS to transfer excel spreadsheets and CSV files into SQL Server.
Created Slow Changing Dimensions for students records.
Created Clustered and Non Clustered indexes to eliminate full table scans in order to improve performance.
Created reports using SSRS and Excel.
Defragmented indexes to improve the performance.
Developed stored procedure for data conversion.
Used Analytical functions like RANK, DENSE RANK, NTILE, PERCENT RANK.
Created Sequence for automatic creation of unique keys.
Created Views using inner left & right joins in TSQL.
Designed advanced SQL queries, stored procedures, triggers in TSQL.
Added users to the roles and granted permissions.

Environment: Windows server 2008, Windows XP, Windows 7, SQLServer 2012, SQL Server 2008, Unix, PowerShell.