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