| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate BASILE Candidate's Name
EMAIL AVAILABLE
PHONE NUMBER AVAILABLE LINKEDIN LINK AVAILABLEOBJECTIVE
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 EXPERIENCEOMNI AIR INTERNATIONAL September 2018 - Present
SQL Server DeveloperDuties 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.DELTA AIRLINES Inc May 2017 September 2018Junior SQL Server DeveloperDuties 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. 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.
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.
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.MENZIES AVIATION October 2015 May 2017SQL Server DeveloperDuties and Responsibilities: Analyze existing SQL queries for performance improvements. Provide timely scheduled management reporting. Analyze existing SQL queries and suggest new ones for performance improvements. Create scripts and procedures for data migration and offer timely scheduled reporting. Create interactive filters, parameters, and calculations for preparing dashboards and worksheets in Tableau. Create and edit SQL queries within Tableau to build calculated fields. Reviewing and improving existing systems and collaborating with teams to integrate new systems. Performing and documenting data analysis, data validation, and data mapping/design. Creating tools to store data within the organization. Confident working cross-functionally with various departments including business stakeholders and technical personnel to exchange ideas. Worked closely with senior developers to understand and implement data solutions, improving my skills and efficiency. Contributed to a project to improve the company s data infrastructure, resulting in improved data quality.
Creating and maintaining documentation for database design and processes. Troubleshooting and resolving database related issues. Managing database security, user access, and data integrity. Writing and optimizing SQL queries for performance and scalability.
Ensure that the new database code meets company standards for readability, reliability, and performance. Managed a project to overhaul the company s data infrastructure, improving data accessibility and accuracy. Develop case studies to understand new product launch, Seasonal forecasting.
Education Baton Rouge Community College Associate Degree in Aviation 2021 (GPA 4.0) University of Yaound II Soa Cameroon Bachelor s Degree in Business Management 2009 (3.87)SKILLS SQL Server Oracle Power BI Tableau Jira Service Now Scrum MasterCERTIFICATION Certified Scrum Master, International Scrum Institute, May 2020 Certified Cyber Security Analyst, CompTIA, August 2020TRAINING & COURSES ATTENDED SQL Server Database Development
Tableau Training
SSIS Training
References Available upon request |
