We provide IT Staff Augmentation Services!

Business Intelligence Specialist Resume

Denver, CO

SUMMARY:

  • Energetic, creative and passionate for SQL based database work with excellent communication skills to continuously strive for higher achievement in life by hard work and acquired skills seeking for a SQL developer position within the company

TECHNICAL SKILLS:

Software: - Microsoft BI stack, TSQL, SQL, SSIS, SSAS, SSRS, SharePoint, Crystal Reports, Oracle, MS Visual Studio, Power bi, MS Visio, Microsoft Office (Excel, Word, Power Point, etc.)

Programming: Microsoft BI stack, TSQL, SQL, SSIS, SSAS, SSRS, Crystal Reports and Exposure to the Python, R

Communication: - Ability to write and communicate effectively to employees of all levels and backgrounds.

Personal: - A strong work ethic with great leadership skills and a team player with an optimistic attitude.

Database consistency and optimization with engine tuning adviser

PROFESSIONAL INTEREST:

Confidential, Denver, Co

Business Intelligence Specialist

  • Develop complex stored procedures, UDFs, and created materialized views as well as modified existing
  • Extract data in various formats and load to SQL Server
  • Deploy and schedule SSIS packages for auto run
  • Develop parameterized via SSRS.
  • Create report models and support Ad hoc reports
  • Created and maintained SSRS reports using OLTP data, OLAP multidimensional data, and SSAS Cubes
  • Develop SSAS Cubes and provided access to end users
  • Vigorously involved in client meetings in requirement gathering and development updates
  • Scheduled reports and exported in various format for decision makers.

Confidential, Baltimore, MD

SQL/BI Developer

  • Develop complex stored procedures, UDFs, and created materialized views as well as modified existing
  • Extract data in various formats and load to SQL Server
  • Deploy and schedule SSIS packages for auto run
  • Develop parameterized via SSRS.
  • Create report models and support Ad hoc reports
  • Created and maintained SSRS reports using OLTP data, OLAP multidimensional data, and SSAS Cubes
  • Develop SSAS Cubes and provided access to end users
  • Vigorously involved in client meetings in requirement gathering and development updates
  • Scheduled reports and exported in various format for decision makers.

Confidential

SSIS/SSRS/SSAS Developer

  • Implement function, stored procedures and triggers
  • Develop/deploy SSIS packages
  • Identify and resolve issues related to SSIS package configuration and deployment
  • Maintain data integrity
  • Perform data conversions from various file formats into SQL based database
  • Load data to the interface tables from multiple data sources
  • Migrate SSIS packages
  • Report and dataset manipulation
  • Design/deploy SSRS report services
  • Develop interactive and static reports with Matrix, Table, Charts, Graphs and Dashboard
  • Generate snapshot, drill down, and parameterized reports using SSRS
  • Prepare Ad-hoc reports for publishing through report manager
  • Schedule scheduled reports daily, weekly and monthly basis
  • Create simple and complex SSAS cubes with multiple fact measures groups for OLAP reporting needs
  • Prepare documentation for the development and training activities

Hire Now