Sql Server Data

Rohit Singh

**** ************ ****., ***-****, **206, Dallas, TX +1-(469) 803- 8412 *************@*****.***

Summary

Experience Business Analyst with profound knowledge of Software development Life Cycle (SDLC), database design, Data Modeling,Data Warehousing and with an in-depth grasp of SQL reporting and analytics.

Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, SSIS Packages, Data Mining Models, Deploying and Processing SSAS objects, MDX queries and designing complex reports using SSRS

Great problem solving and analytical skills, demonstrated leadership abilities with great communication skills.

Technical Skills

Database: MS SQL Server 2008/2012/2014, My SQL

BI Tools: SSIS, SSRS, SSAS, MDX functions and queries

Languages: HTML, R, PHP, Core Java, C

Software Tools: MS Visual Studio, Advanced Excel, MS Office Suite (Word, Excel, Power point)

Troubleshooting: TCP/IP and BGP protocol

Other: Job scheduling, Requirement Analysis, Gap Analysis, Kano Analysis, Cross Functional Role, FTP.

Education

Southern Methodist University Dallas, Texas

8/14 – 5/16 Master’s in Information Engineering and Management

Rajiv Gandhi Technical University

7/09 –6/13 Bachelor of Engineering – Electronics & Communication Engineering

Professional Experience

Docusoft India Pvt Ltd

7/13 – 7/14 Business Analyst

Environment SQL Server 2012/2014, SSIS, SSRS, SSAS, Requirement Gathering, Advanced Excel, FTP

Designed and implemented the ETL packages for data extraction, cleansing and transformations using SSIS.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Developed various operational Drill-through and Drill-down reports using SSRS.

Created views and bulk insert scripts using T-SQL to facilitate reporting requirements

Responsible for gathering and documenting business, functional and technical specifications data flow using MS Visio.

Integrated data quality plans as a part of ETL processes and scheduled jobs using SQL Server agent.

Functioned as a liaison between clients and development teams to analyze opportunities for business process improvements relating to the Commissions Administration and Reporting Systems.

Translate business requirements into functional requirements for development and QA teams.

Identified, tracked, reported and resolved applications issues in a timely manner.

Lead the team and performed business analysis and technical risk evaluation of proposed designs/solutions using CRM application & presented the proposed solutions to the client.

Prepared detailed statistical report in MS Excel using V-look ups to track progress of sales growth.

Academic Projects

Social Networking

Created User’s database using SQL Server 2014 and performing T-SQL queries.

Created ad hoc reports using SSRS.

Grad Nation

Performed Data Mining to examine the reason for low graduation rate in U.S using R language.

Created forecasted reports with predictive modeling.

Performed all the data analysis using SSAS.

Contact this candidate