Sql Server Developer

OLUSEGUN ALLI

SQL DEVELOPER

PHONE: 573-***-****

PROFESSIONAL SUMMARY:

Over eight years of experience in Database Development, Administration, Design, Analysis and Test.

Hands-on experience using Erwin and MS Visio for Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.

Microsoft SQL Server 2005, 2008 R2, and 2012, 2014 server’s side development including (SSIS, SSRS, SSMS)

Implemented SSIS, SSRS, SSAS for data warehouse & data mart solutions

Knowledge of Relational Database Management systems.

Data migration across different databases like DB2, MS SQL Server, MS access & flat files using SSIS packages.

Expert in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions and Views

A solid understanding of Relational Databases

Experience in creating complex T-SQL (Transact SQL) Stored Procedures and Triggers

Skills in Maintaining and enhancing the existing data warehouse, exports, and reports

Perform quality checks on reports and exports to ensure exceptional quality

Provide business users the data required for metrics and analysis

Visual Studio 2010,2013 data tool developed new SSIS/SSRS packages to meet business needs

Hands on experience in Troubleshooting database issues.

Experience in other Databases like MS Access, and DB2, SAS, SASGRID1

Experience in BIA business impact analysis identifies the critical business processes.

Hands on planning SPOF analysis (define goals of analysis, plan, and execute, analyze, produce result).

Test a program that access and manipulate.

Experience in Creating and maintaining documentation for all projects

Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.

Good interpersonal, Analytical and Communication skills

AREAS OF EXPERTISE

SQL Development

Database Management

T-SQL Programming

SSIS

MongoDB

Microsoft SQL Server

Data Analysis & Reporting

Agile Methodologies

SSRS

Data Entry & Transfer

Process Automation

Data Mapping & Integrity

SAAS

EDUCATION & CERTIFICATION:

Bachelor of Science in Management Information Systems 2010

Southern Illinois University, Carbondale, IL

Associate of Applied Science in Computer Information Systems 2001

John A Logan College, Carterville, IL

Licenses & Certifications

Certified SQL Developer, W3 Schools

PROFESSIONAL EXPERIENCE

BAY CITY PHARMACY, HOUSTON TX FEB 2018 – MAY 2023

SQL DEVELOPER

RESPONSIBILITIES:

●Write SQL scripts that include queries for databases with a complex authentication process

●Created complex Stored Procedures, Triggers, User Defined Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

●Maintain the integrity of the environment through regular updates and monitoring

●Used joins and sub-queries to simplify complex queries involving multiple tables

●Improves quality processes to increase efficiency and effectiveness

●Developed Star schema using SSAS cubes.

●Worked with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

●Participate in disaster recovery protocols, including the development and execution of plans to minimize the loss in the event of attacks or breaches

●Developed Query for generating drill down & drill through reports in SSRS.

●Worked on SSIS script task, look up transformation & data flow task using T-SQL & visual Basic (VB) scripts.

●Worked on SSIS packages & utilizing complex transforms, a wide variety of data sources including SQL Server, delimited & fixed width text files, XML, Services, DB2.

●Work with management, project managers, software engineers, application developers and end users to develop solutions to organizational needs

●Set security clearance parameters for authorized user access

●Drive stability, reliability, and performance by optimizing in-application SQL statement and design user-focused databases

●Gather requirements from business analysts, develop physical data models using Erwin and create DDL scripts to design database schema and database objects

●Researching and experimenting with emerging data technologies and industry trends with a view to bringing business value through early adoption

●Created and maintained technical documentation process flow

●Troubleshoot technical issues and identified modifications needed to meet changing requirements

●Developed and redesigned a NoSQL RDMS using MongoDB with 200k entry

FIRST DIRECT CAPITAL HOUSTON, TEXAS JUNE 2015 – JAN 2018

SQL DEVELOPER

RESPONSIBILITIES:

●Developed in-depth reporting deliverables to record analytical findings and provided actionable feedback for performance improvement

●Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

●Designed and executed T-SQL queries for comprehensive reporting

●Provided valuable insights to business stakeholders and end-users by expertly crafting SQL queries to extract data from multiple tables and generate CSV formatted reports

●Performed SQL, PL/SQL and application tuning using multiple tools, including EXPLAIN PLAN, SQL*TRACE, TK Prof, and Auto Trace

●Implemented data mart, facts, dimensions, star schema and OLAP cubes using SQL Server Analysis Service.

●Wrote various SQL queries to obtain data from multiple tables to spool into CSV format and provide extracts to all company businesses and users

●Utilized dialogue-mapping procedure to gather all necessary requirements gaining 95% overall customer and client’s satisfaction

●Work closely with the development team to provide support for database objects and performing code review

●Design, develop and maintain SQL applications/ETL, databases, reports, and programs.

●Provide training to end-users in the use of new system functionality or modification of existing functions

Contact this candidate