Business Systems Analyst Resume Iselin, NJ - Hire IT People

OBJECTIVE

Seeking full - time employment with a major corporation in order to utilize my specialized skills in business intelligence along with data analytics.

TECHNICAL SKILLS

Database/Design: MySQL, SQL Server, HTML, XML, JavaScript, CSS

ETL Tools: SQL Server Integration Services (SSIS), DTS, BCP

Reporting Tools: SQL Server Reporting services (SSRS), Crystal Reports 9.0/8.0

OLAP Tools: SQL Server DTA Analysis Services (SSAS)

Tools: SAS E-Miner/Base/Guide, MS Project, MS Excel, Tableau, R Language

Programming Language: C, J2SE, J2EE

PROFESSIONAL EXPERIENCE

Confidential, Iselin, NJ

Business Systems Analyst

Responsibilities:

Requirements Gathering both functional and non-functional by interviewing and conducting JAD sessions
Designed and developed use cases, user stories and business analysis process models using MS Visio.
Assisted with the data modelling and data reporting, extracted complex data from SQL database
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server
Developing reports using SSAS & SSRS on SQL Server, good Experience of SSAS, OLAP cube Architecture.
Knowledge of VLOOKUP, INDEX, MATCH and Pivot Tables for data transformation using MS Excel
Understanding of Business Objects, Data Modelling and created dashboard using Tableau

Confidential, Old Bridge, NJ

Business Analyst

Responsibilities:

Managed agile project development activities maintained SRS, BRD, FRD, Use Cases, UML Diagrams, etc.
Activity Sequencing, Scheduling and work breakdown structure(WBS) using MS Project
Documented Requirements in order to create Use Stories, ER Diagrams, and Data normalization
Created monthly reports using SQL, SQL data query and extraction, Created dashboard using reporting tools
Created test cases, test plans and performed User acceptance testing (UAT).
Contributed to servlet based application development and updated existing applications using MVC model.
Helped design form validation programs using HTML and JavaScript. Designed new pages with CSS

Confidential

Web Developer

Responsibilities: