close
  • Dashboard
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Customer Service
      • Education
      • Sales
      • Manager
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Microsoft Word
      • Professional
      • Modern
      • Traditional
      • Creative
      • View All
    • Resume Services
    • Resume Formats
      • Resume Formats
      • Chronological
      • Functional
      • Combination
    • Resume Review
    • How to Write a Resume
      • How to Write a Resume
      • Summary
      • Experience
      • Education
      • Skills
        • Skills
        • Hard Skills
        • Soft Skills
    • Resume Objectives
  • CV
    • CV
    • CV Examples
    • CV Formats
    • CV Templates
    • How to Write a CV
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Customer Service
      • Marketing
      • Sales
      • Education
      • Accounting
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Questions
  • Resources
  • About
    • About
    • Reviews
  • Contact
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • SQL/BI Developer
Please provide a type of job or location to search!
SEARCH

SQL/BI Developer Resume Example

Love this resume?Build Your Own Now
SQL/BI DEVELOPER
EXPERIENCE SUMMARY
  • More than three years of Progressive work experience in IT, specifically designing and developing BI solutions, Data Visualizations, SQL, ETL Packages and as a Business Analyst
  • Proven experience developing Tableau and Power BI dashboards, scorecards and BI solutions that provided visibility for the senior leadership and the business in achieving better service quality, workforce management and business process optimizations
  • Proficient in constructing Tables, Normalization/ De normalization Techniques on database Tables, creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving several tables and Triggers
  • Experience SQL Server Installation, Configuration, Creating Logins and Database Users
  • Experience in creating and managing fragmentation of Indexes to achieve better query performance, performance tuning and Query Optimization.
  • Working Knowledge of Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS)
  • Good understanding of (SDLC) software development life cycle processes and principles
  • Excellent work ethic with the ability to learn new skills fast and able to adapt to change fast. Self motivated, able to handle multiple priorities and excellent time management skills
  • Excellent communication and facilitation skills with the ability to gain consensus across multiple teams and proven team players
  • Hands on experience with SQL Server Management Studio (SSMS)
  • Great knowledge of Data marts, Data warehousing, Operational Data Store (ODS), Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling
  • Hands on Experience on SSIS package development, deployment and scheduling
  • Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SQL Server Reporting Service
  • Experienced working on AgileProjects with Multiple Sprints cycles and Scrum meetings
Skills
  • Ability to Multi-Task
  • Attention to Detail
  • Proactive and Results Oriented
  • T-SQL coding
  • C# Programming Language
  • Microsoft Excel, Microsoft PowerPoint, Microsoft Word
  • SSRS, SSIS
  • Tableau, Power BI
  • Relational Database Management System
  • ETL
  • SSIS/SSRS Deploying
  • Interpersonal and communication skills
  • Troubleshooting and Performance tuning
EXPERIENCE
SQL/BI DeveloperNeogenomics Laboratories - Fort Myers , FL09/2018 - Current
  • Troubleshooting and resolving complex production performance issues.
  • Performance tuning of long running queries and code reviewing
  • Creating and managing stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies
  • Restoring and recovering corrupted databases
  • Configure and manage Database links for data sources
  • Performing database refresh from Production to Staging Servers on regular and on-demand basis
  • Performing standard DB Security administrations (creating logins, users, roles, and assigning Permanent and also temporary permission to them)
  • Reviewing SQL codes in SSIS packages and providing recommendations for better query performance
  • Restoring and recovering corrupted databases
  • Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis

Environment: Windows server 2012/R2, 2008/R2, 2003R2, SQL server 2016/2014/2012/2008R2, SSRS, SSIS, T-SQL, Visual studio, PowerBI, PostgreSQ, SQL Azure

Database Developer InternInternet Brands, Inc. - New York , NY06/2018 - 08/2018
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
  • Provided data support to SEIU local unions, campaigns and programs
  • Utilized Tableau software to create visualizations of the annual reports composed of data from different regions
  • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process
  • Planned and implemented security measures to safeguard vital business data.
  • Generated Tableau Dashboards with Quick filters and Parameters to handle views more efficiently.
  • Worked with Managers to prepare requirements gathering and quality documents.

Work Environment: SSIS 2012/2014/2016, SQL Server 2014/2016, T-SQL, XML, Microsoft Project, SSRS, Microsoft Excel, ServiceNow, Tableau.

BI/Database Developer InternRiverside Downtown Partnership (RDP) - City , STATE01/2018 - 06/2018
  • Facilitated Meetings with the Board of Directors and Business owners to plan events and to further the mission of RDP
  • Implemented BI solution framework for end-to-end business intelligence projects.
  • Monitored social media and online sources for industry trends.
  • Loaded data from MSSQL Database tables, Excel, MySQL and Access databases into SQL Server 2014/2016 staging DB's using SSIS Import/Export and SSIS (ETL) packages.
  • Wrote and optimized SQL statements to assist business intelligence practices.
  • Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
  • Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses.
  • Created Indexes, Constraints and Rules on database objects.
  • Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch. Developed Triggers on Views to populate base tables.

Environment: MS SQL Serve 2012/2014/2016, T-SQL, Query Analyzer, SQL Profiler, SSRS,SSIS, Windows Server 2012, MS Visio, MS BI

DBA/SQL Developer InternDistrict Office - City , STATE10/2017 - 01/2018
  • Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions.
  • Performed performance testing on stored procedures, indexes, and triggers.
  • Developed Reports for constituent events and for different purposes using SSRS and Report Builder
  • Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User Defined Data Types and Functions
  • Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules
  • Developed Database Backup Scripts and automated this process/tasks using SQL Server Agent Service
  • Composed correspondence and assisted with administrative tasks

Environment: MS SQL Server 2012/2014/2016, T-SQL, Query Analyzer, SQL Profiler, Windows Server 2012, MS Visio, MS BI,SSRS, SSIS, Visual studio, PowerBI

Education
Bachelor of Arts: Political ScienceUniversity of California, Riverside - City, State06/2019
Certifications and Trainings
  • Certified Network Security Specialist, International Cybersecurity Specialist (ICSI)
  • SQL Server Database, BI And Data Analytics Development Training
  • Tableau Training
  • Power BI Training
  • Agile Project Training
Languages
  • English
  • Amharic
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

88Good
Resume Strength
  • Formatting
  • Word choice
  • Strong summary
  • Typos

Resume Overview

School Attended

  • University of California, Riverside

Job Titles Held:

  • SQL/BI Developer
  • Database Developer Intern
  • BI/Database Developer Intern
  • DBA/SQL Developer Intern

Degrees

  • Bachelor of Arts : Political Science

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Lead-Power-BI-Data-Analyst-/-SQL-Developer-resume-sample

Lead Power BI Data Analyst / SQL Developer

Emd Millipore

Urbana , IL

Lead-Power-BI-Data-Analyst-/-SQL-Developer-resume-sample

Lead Power BI Data Analyst / SQL Developer

Emd Millipore

Temecula , CA

SQL-BI-Developer-resume-sample

SQL BI Developer

Gep

New York , NY

  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Work Here
  • Contact Us
  • FAQs
  • Accessibility
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2022, Bold Limited. All rights reserved.