Sql - Bi Report Developer Resume
4.00/5 (Submit Your Rating)
Doral, FL
SUMMARY:
- Looking to secure a Senior Business Intelligence (BI) Analyst position that will enable the use of my exceptional problem - solving, analytical and technical skills.
- Gather requirements from business and deliver information to staff in concise manner
- Skilled at communicating with teams when gathering requirements
- Perform as a self-motivated solutions provider
- Able to do plan own business analysis
- Experience using and delivering reports in Power BI and Excel
- Able to effectively present findings about business performance to executive teams (discuss data on reports, significant metrics and statistics with the business)
- Experienced in making presentations (7 years of previous sales experience)
- Over 7 years of experience at creating and modifying reports with SQL Server Reporting Services
- Design, develop, analyze and debug reports and SQL applications primarily using MS stack
- Experience with Access and MySQL Databases
- Strong T-SQL querying and scripting ability
- Ability to manage and navigate SQL Server Databases
- Learn latest BI technologies and adapt to those currently being utilized by organization
- Create and Alter Stored Procedures, Functions, Triggers and Views
- Able to Optimize queries to reduce database overhead - examine query execution plans
- Use of Data Visualization techniques - Charts, Graphs and Dashboards
- Emphasize deep data analysis and data validation
- Deploying, Configuring, Managing and Maintaining reports in Report Portal
- Creating Subscriptions, data driven subscriptions, deploying and configuring security of reports
- Development with MS Visual Studio - SS Data Tools SSAS, SSIS, SSRS
- Use of complex expressions in reports / code and .Net assembly calls
- Experience with Database development - for OLAP and OLTP; designing cubes with SSAS and Tabular models; SSIS packages; converting reports from Crystal reports to SSRS / Power BI
- Team Player - Assist members, learn from others, offer any support to advance team objectives and grow with the organization
PROFESSIONAL EXPERIENCE:
Confidential, Doral, FL
SQL - BI Report Developer
- Report Development - created SSRS reports - using SQL Server relational or Analysis Service Databases as data source
- Created and Modified Power BI reports
- Created and Modified SSAS Tabular Models
- Converted Reports from Crystal Reports and Web Intelligence platforms.
Confidential, Doral, FL
SQL Developer
- Report Development - created SSRS reports - using SQL Server relational or Analysis Service Databases as data source
- Scripted T-SQL for use in OLAP and OLTP development
- Created and Altered Stored Procedures, Functions, Triggers and Views. T-SQL Windows functions
- (correlated sub-queries, window functions, pivot) and many other advanced query methods)
- Created Tabular, Reports, Sub-Reports, Drill Down, Drill Through, Graph, Charts, Dashboards
- Reports developed for Accounting, Compliance, Sales, Credit and specialized various product departments.
- Delivered reports through SSRS report manger web tool or automated email, Excel or Power BI
- Designed SSIS packages and SSAS Cubes
- Advising management on data and varying business trends and discussing the meaning of this data and possible applications based on it
Confidential, Doral, FL
Report Developer
- Report Development - created SSRS reports - included dynamic pivot tables, executive dashboards, sub-reports, charts, graphs, tables that included user’s input (parameters), aggregated totals, various calculated fields and other coded expressions.
- Scripting SQL Queries in Server Management Studio and in SSRS datasets
- Data included in reports varied from wireless, international long-distance, international originating to U.S. call accounts, and various other telecommunication products as well as business performance, budget analysis, employee performance and strategy testing reports
Confidential, Miami, Fl
Sales and Distribution of Telecom products
- Sales - Wholesale throughout Dade county area
- Acquired responsibility and self management
- Sales and business experience