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
|
|
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
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:
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
Similar Resumes
