Business Intelligence Developer Resume Profile
2.00/5 (Submit Your Rating)
Professional Summary
- Extensive experience in BI Solutions Cubes, ETL Reporting using SSIS, SSAS and SSRS, and SharePoint utilizing latest features and versions 2014,2012/2010/2008 .
- Extensive Experience in Installation, Configuration, Managing, Monitoring and Troubleshooting, Performance Tuning, Backups, and Replication of SQL Server 2014/2012/2010/2008/2005 on different Windows Environments.
- Excellent T-SQL programming skills in writing complex queries for Database objects such as Tables, Views, Stored Procedures Triggers and User-Defined Functions.
- Experience in Leadership/Manager/Mentor positions. Worked closely with Business Leaders t understand requirements and optimize solutions.
Technical Skills
- SQL Server 2014/2012/2010/2008R2 14 Years
- DBA: Backup/Recovery/Maintenance 14 Years
- Database Tuning Advisor, SQL Profiler, Query Analyzer 14 Years
- SQL Server Management Studi SSMS 14 Years
- Replication 12 Years
- ETL Tools:
- SSIS 2014, 2012 6 Years
- Integration with data from PostgreSQL, MySQL, Oracle, Web scraping, FTP data dumps
- Reporting:
- SSRS 2014, 2012 6 Years
- SharePoint Designer 2013 2 Years
- Excel BI Tools: PowerPivot, PowerView, PowerMap 1-2 Years
- ASP.NET C 2 Years
- Crystal Reports 2008 10 Years
- Data Warehouse:
- SSAS Cube 2014, 2012 5 Years
- Develop, Architect, and help lead in direction of Data Warehouse 10 Years
- Developer:
- Highjump Certified Developer / Architect / Administrator 8 Years
- Saleslogix 7.2 Certified Developer / Architect / Administrator 2 Years
Work History
Confidential
Senior Business Intelligence Developer
- Sole BI Support for the new Wireless Division of the company. Worked with various departments NOC, Marketing, Sales, Call Center t determine data and reporting needs.
- Create SSIS packages t load data from various sources ont the Data Warehouse
- Analyze, design, create, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS, Powermap, Powerview, and Sharepoint.
- Implemented data warehouse design principles and best practices for maintaining dimension and fact tables.
- Was laid off. Wireless Division was not ready for BI support and company had a mass lay off due t over-spending.
Confidential
Senior Business Intelligence Developer
- Created SSIS packages t load data from various sources int the Data Warehouse.
- Design, develop, unit test, document, and implement reporting applications and dashboards using SSRS, ASP.NET, Sharepoint, Crystal Reports.
- Created/maintained cubes using SSAS.
- Implemented data warehouse design principles and best practices.
- Highjump Developer/Administrator
Confidential
Senior SQL DBA
- SQL Server DBA optimization, backups, database tuning, replication, SQL programming, SQL development
- Create and maintain SSIS packages for importation and data manipulation of nationwide county MLS data.
- Create and document processes for other DBA's t use within the department.
Confidential
Software Architect/SQL DBA SQL Server DBA database design, performance tuning, backups, replication
- Logistics case studies for local companies on current process flows t improve efficiencies and reduce overhead costs. Implementation, change order development, maintenance and architect of Highjump Warehouse Management systems.
- Designed and developed in Saleslogix CRM , new process flows and test plans.
Confidential
Highjump Developer/SQL Server DBA/Architect
- Manage the Logistics IT department and Corporate Reporting Department
- SQL Server DBA optimization, backups, database tuning, replication, SQL programming, upgrades .
- Assisted in operational system planning enhancements for 100 annual growth.
- Designed and Maintained Data Warehouse system. Created Reports using Crystal Reports, Highjump Webwise, ASP, PHP, Oracle Reports.
- Installed, maintained, developed, designed and upgraded Highjump WMS System.
- Trained/Mentored staff in report creation, Highjump architect and database maintenance.
- Integrated Kewill, Cubiscan, Accusort, Oracle Financials with Highjump.
- Spoke/Attended HighJump Software user conferences