Business Intelligence Developer Resume

SUMMARY

Dedicated business intelligence analyst with over five years of experience in the corporate sector.
Proven track record of improving the efficiency and productivity of corporations thought hypothesis testing estimation regression analysis forecasting and the use of other skills and knowledge.
Vast knowledge of tableau, SQL, Power Pivot, PowerBI with other web applications and technical knowledge

TECHNICAL SKILLS

Well versed with database design and T - SQL query language as related to enterprise software configuration and debugging
Working knowledge of Reporting and dashboard designing skills using SSRS
Utilizes advanced T-SQL skills for creating Table, Views and Stored procedures
Working Knowledge of Network communication protocols such as FTP using FileZilla
Good understanding of database architecture using database diagrams object
Exports data from database into third party software such as MS Excel and SSRS for advanced analytics.
Advanced reporting knowledge using Pivot table and charts in MS Excel
Capable of exporting and importing data from various data sources and destinations such as MS Excel, Flat files (csv and txt formats) and ole DB using SSIS
Proficient in using MS Windows, PowerBI, Power Pivot Tableau, ER Assistant tools
Possess outstanding presentation, communication and interpersonal skill

PROFESSIONAL EXPERIENCE

Confidential

BI Analyst

Served as a liaison between clients and developers during project implementation
Access clients servers remotely to troubleshoot problems with their database
Utilizes T-SQL to write queries used for report designing
Create store procedures and view for designing ad-hoc report for clients
Designed ad-hoc reports using PowerPivot using several data sources
Used complex T-SQL to query reports, built stored procedures and views with SQL Server
Create and developed database objects such as tables, Indexes, views, stored procedure, and T- SQL code with proper grants to all the users and roles using SSMS 2012
Developed DML Scripts to insert, update and delete data in MSSQL database tables with SQL Server management studio.
Involved in trouble shooting and performance improvement of SSRS Report
Create and perform queries on temporary tables
Populated data into separate columns using XML queries

Confidential

Business Intelligence Developer

Provide BI user training on tool usage and reporting.
Create new reporting techniques, data collection sources and constraints of developing business.
Taking care of legacy system, develop new solutions for new and legacy system for business development.
Designing of dashboards, score cards by collecting data through SSIS,SCRIBE and worked on creating Cubes & Reports.
Creating new integrations between Microsoft CRM & Dynamics GP along with other databases.
Manage databases and database servers in the absence of database administrator.
Taking care of the internal Help Desk system and provide solution on time.

Confidential

Software Developer & Business Intelligence Developer

Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
Analyze & translate functional specifications & change requests into technical specifications.
Translate business needs into end user applications and provide user training to use the tools.
Database modeling, ETL and creation of analytical processes.
Creating jobs for special requirements for the company.
Experience working on large Analysis Services databases.
Developed dashboards, chart box and other reporting solution by using SSRS.
Documentation of processes, assisting and providing training to other team members.