Sql Server Business Intelligence

Location:

Philadelphia, PA

Posted:

June 27, 2024

Contact this candidate

Resume:

BASILE MOISE E. BANGA

************@*****.***

240-***-****

www.linkedin.com/in/basile-moise-banga-93173a167

OBJECTIVE

Seeking a SQL Server Database Developer and or Tableau Developer position to work with an organization which will utilize my competencies to achieve company goals and objectives and to enhance my overall continued growth and development as an individual. I am an enthusiastic and detail-oriented SQL and Tableau developer with over 8 years of experience in designing, implementing, and optimizing database solutions and data visualization projects. Adept at translating business requirements into technical solutions that improve efficiency, insights, and decision-making processes. Seeking to leverage advanced SQL skills and Tableau expertise to drive data-driven strategies and innovation.

EXPERIENCE SUMMARY

5+ years of Database Development experience on MS SQL Server 2005/2008R2/2012/2014/2016/2017/2019 in OLTP environments on SSMS tool.

Experience installing MS SQL Server 2008R2/2012/2014/2016/2017/2019; updating with hot fix and service packs.

Experience with SQL Server 2008/2010/2012/2014/2016/2017/2019 and Business Intelligence development using SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS) and SQL Server Integration Service (SSIS).

Expertise in creating Business Intelligence Reports using SQL Server Reporting Services (SSRS), Power B.I, Qlik View, PowerPivot, Excel, Report Designer, SharePoint, Tableau.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert. Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow tasks and data flow transformation.

Experience in creating deployment utility to deploy SSIS packages over Production, UAT, QA and Local System.

Implemented In-placed and Side by Side Migration of MS SQL Server 2005 to 2008R2 and 2008R2 to 2012.

Experience in developing T-SQL (DDL, DML, and DCL) statements.

Great working knowledge of software development life cycle, (Agile), data life cycle, database design, RDBMS, Data Warehousing, and data modeling concepts.

Worked with a team of business analysts, data architects, application developers, ETL developers and QA testers.

Translating data access, transformation, and movement requirements into functional requirements and mapping designs.

Extract data from various sources, including databases, flat files, and APIs, ensuring that the data is accurately pulled from source systems.

Load the transformed data into a target database, data warehouse, or data mart, ensuring it is correctly and efficiently inserted, updated, or merged.

Identify, diagnose, and rectify any issues in the ETL process, such as data inconsistencies, transformation errors, or load failures.

WORK EXPERIENCE

OMNI AIR INTERNATIONAL September 2018 - Present

SQL Server Developer

Duties and Responsibilities:

Senior level experience using SQL Server, designing backend processes and database objects such as stored procedures, functions, views, tables, triggers, indexes, CTE's, etc.

Create SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server.

Implement and test software/server upgrades as needed to gain better functionality.

Hands on Tableau desktop 8/9/10.1 and 10.3, Tableau server and Tableau Reader.

Experience in creating visualizations using Bars, Lines and Pies, Maps, Scatter plots, Histograms.

Work heavily on joints and implementing SQL Server Indexing and Query Optimization using Indexes.

Create objects like tables and views and develop SSIS packages to load data.

Collaborate with cross-functional teams to gather requirements and deliver data solutions, improving team efficiency by 25%.

Lead the creation and maintenance of complex database schemas using SQL best practices. Develop robust database structures to store, retrieve, and manage large datasets efficiently.

Develop dynamic SQL scripts to generate SQL commands on the fly, accommodating varying query parameters and adapting to different database schemas dynamically.

Create and manage user-defined functions to encapsulate common logic, enhancing code reusability and reducing redundancy across the database.

Design and execute ETL (Extract, Transform, Load) processes using SQL and additional scripting tools to integrate data from multiple sources, ensuring accuracy and timeliness of data feeds.

Develop and maintain SQL queries and scripts for generating periodic reports. Collaborate with business analysts to provide data that supports visualizations for business reviews and stakeholder presentations.

work closely with developers, analysts, and IT staff to ensure database integrity and security. Document all processes and schemas for future reference and compliance audits.

Implement LOD expressions to perform complex aggregations at multiple levels, enhancing the granularity and accuracy of data analysis without compromising performance.

Utilize Tableau’s mapping capabilities to integrate geographic data into visualizations, providing spatial insights and trends that are critical for regional analysis and decision-making.

Use SQL queries to extract and manipulate data from databases, ensuring that the visualizations in Tableau are powered by real-time and relevant data.

Employ Tableau’s data blending and joining capabilities to merge data from multiple sources, ensuring comprehensive and cohesive analytics results.

Develops design specifications for ETL jobs using Postgres DB

Using Redshift Design to implement and support ETL programs.

Creates integration testing strategy for ETL jobs/participates in integration testing in development/test environments.

Experience in writing complex SQL in relational databases especially SSMS and Postgres DB

Experience in ETL & query performance tuning using Redshift DB

Knowledge of Scripting using any scripting language

DELTA AIRLINES Inc May 2017 – September 2018

Junior SQL Server Developer

Duties and Responsibilities:

Junior level experience using SQL Server to work on software development Life Cycle SDLC, data modeling, business analysis, and data warehouse.

Design databases and ensure their stability, reliability, and performance.

Ensure data quality and integrity in databases.

Experience in database design using Normalization Forms, Entity Relationship Design ERD model and application-oriented design.

Proficient in design of logical and physical data modeling using MySQL data modeling tool.

Expert in creating Database Object Schemas

Maintained positive communication and working relationships with all business levels.

Troubleshoot and solve SQL database issues.

Develop and design standard reports, cross-tab reports.

Well experienced with creating Worksheets and Dashboard.

Monitoring the status of extract schedules on QA sites.

Adding and Creating dimensions, measures, and calculations.

Coordinating with Tableau Admin Team for Production Deployment.

Providing knowledge transfer and support to Interactors and Viewers.

Providing Tier 1 support for Tableau issues reported by departmental or group personnel.