SQL BI Developer Resume Samples

Description :

1. Involving in requirement gathering, analysis, implementation, development, and production.
2. Creating dynamic queries to perform ETL operations by looping through multiple database servers and tables.
3. Importing and extracting data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
4. Designing and developing the various analytical reports from multiple data sources by blending data on a single worksheet in tableau desktop.
5. Troubleshooting SSIS packages and migration procedures and documenting the complex SSIS packages and migration procedures.
6. SQL server database modeling, design and development with complex sql scripts, stored procedure, views, defined functions, triggers.
7. Designing and developing the mappings to load the data from flat file to SQL server tables for reporting purposes.
8. Working on business intelligence standardization to create database layers with user friendly views in teradata that can be used for development of various tableau reports/ dashboards.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Interacting with business users to gather business requirements and translate them into technical specifications and table design documents.
2. Creating and developing the databases and database objects such as tables, indexes, views, stored procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2014.
3. Creating clustered and non-clustered indexes on the columns recommended by the query optimizer to improve the performance of the slow running queries and stored procedures.
4. Implementing the error handling in stored procedures using try-catch blocks.
5. Implementing slowly changing dimensions (SCD) type-II for large datasets using merge statements in stored procedures to maintain historical data in the data warehouse.
6. Maintaining transactions(begin a transaction, commit transaction and rollback transaction) with error handling in stored procedures.
7. Working with data migration from Oracle to SQL server 2014 and migrated PL/SQL code to SSIS packages.
8. Re-created existing dimensions and fact tables using star schema in SQL server 2014.

Experience

7-10 Years

Level

Management

Education

MS

Description :

1. Involved in planning, defining and designing data, based on business requirements and provided documentation.
2. Designed data mapping documents, DDL scripts, data dictionary and metadata of the models and maintained them.
3. Developed SQL scripts, indexes, complex queries for data analysis and extraction.
4. Writing T-SQL script, dynamic SQL, complex store procurers, function, triggers.
5. Created functions, stored procedures, database triggers, user-defined function.
6. Used SSIS and t-SQL stored procedures to transfer data from source to staging area and finally load into the data warehouse.
7. Created SSIS packages to extract data from OLTP and transformed into OLAP systems and scheduled jobs to call the packages and stored procedures.
8. Created alerts for successful or unsuccessful completion of scheduled jobs.

Experience

10+ Years

Level

Consultant

Education

BS

Description :

1. Collaborated with stakeholders to gather and analyze business requirements for ETL processes and data warehousing needs.
2. Developed and managed SSIS packages for data extraction, transformation, and loading from multiple sources into SQL Server.
3. Conducted thorough SQL programming to create and optimize stored procedures, functions, and triggers to enhance data manipulation.
4. Documented technical specifications and maintained comprehensive documentation for all ETL processes and data models.
5. Participated in the complete Software Development Life Cycle (SDLC), ensuring alignment of technical solutions with business objectives.
6. Performed data quality checks and validations to ensure accuracy and integrity of data within the data warehouse.
7. Provided support and troubleshooting for existing SQL Server applications, ensuring high availability and performance.

Experience

0-2 Years

Level

Entry Level

Education

B.S. CS

Description :

1. Designed and implemented complex database objects, including Tables, Views, and User Defined Functions, to support business applications.
2. Developed ETL processes using SSIS, efficiently loading data from various sources while ensuring data integrity and accuracy.
3. Created and optimized stored procedures for data retrieval and manipulation, significantly improving query performance.
4. Utilized SQL Profiler and execution plans for query optimization, reducing execution time for critical reports by 25%.
5. Managed data migration projects, ensuring seamless integration of new systems with existing databases.
6. Collaborated with cross-functional teams to gather requirements and translate them into technical specifications for BI solutions.
7. Conducted training sessions for end-users on utilizing BI tools and interpreting data reports for informed decision-making.

Experience

7-10 Years

Level

Senior

Education

MSIS

Description :

1. Monitor and troubleshoot performance issues in SQL databases.
2. Implement data security measures to protect sensitive information.
3. Created efficient SQL stored procedures and functions adhering to best practices for data integrity and performance.
4. Conduct data analysis to identify trends and insights for decision-making.
5. Documented database architecture and processes, maintaining up-to-date specifications for system maintenance.
6. Executed complex T-SQL queries for data validation and testing, ensuring accuracy in reporting.
7. Provided mentorship to junior developers, sharing best practices in SSIS and SSRS development.

Experience

5-7 Years

Level

Executive

Education

B.S. in CS

Description :

1. Administered a high-availability SQL Server environment, optimizing performance for financial and CRM applications across multiple locations.
2. Engineered automated maintenance tasks, improving database reliability and performance through regular backups and integrity checks.
3. Developed and managed complex schema objects, ensuring alignment with user specifications and business requirements.
4. Utilize SQL Server Reporting Services (SSRS) for report generation.
5. Created and deployed SSIS packages for seamless data integration from diverse sources, enhancing application data loading processes.
6. Collaborated in the design of reports based on stored procedures, ensuring data delivery meets stakeholder needs.
7. Established report subscriptions, automating regular data distribution and enhancing user accessibility to critical information.

Experience

7-10 Years

Level

Executive

Education

B.Sc. CS

Description :

1. Created reports based on the format specified in the design document Documentation of all the processes involved in maintaining the database for future reference Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
2. Involved in the development and modification of existing Financial Reports and Marketing Reports, which include Corporate Consolidation Reports, Financial Reports and Planning Reports for the management.
3. Created a number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS Created reports using SQL Server reporting services SSRS, which is then exported as PDF.
4. Reports variables are passed from ASP.NET web pages.
5. Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and superuser reports using SSRS Created reports using SQL Server reporting services (SSRS), which is then exported as PDF.
6. Reports variables are passed from ASP.NET web pages.
7. Involved in creating Dataset in the MS reporting services (SSRS) for calling the stored procedures and passed the parameters to the dataset.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Developed and implemented SSIS packages for seamless data integration from various sources including Excel and SQL Server.
2. Created indexed views and optimized indexes to enhance query performance significantly.
3. Assist in the development of data governance policies and procedures.
4. Applied performance optimization techniques like normalization and indexing to improve batch process efficiency.
5. Designed and built a comprehensive data warehouse to facilitate advanced analytics and reporting.
6. Utilized Script Tasks for file management and variable storage to enhance ETL workflows.
7. Participated in the creation of a robust SSIS model for ETL processes, ensuring data accuracy and integrity.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Participate in data governance initiatives to ensure compliance.
2. Translated functional specifications into technical designs for robust BI solutions.
3. Identified key facts and dimensions for OLAP databases, enhancing data visibility.
4. Created measures and dimensional hierarchies to support complex analytics.
5. Develop and maintain technical documentation for BI solutions.
6. Designed interactive dashboards and reports with drill-down capabilities for end-users.
7. Automated data loading processes from various formats into SQL Server, improving data accessibility.

Experience

7-10 Years

Level

Senior

Education

MSCS

Description :

1. Ensure data quality and integrity through validation and testing.
2. Designed and modeled complex databases, enhancing data integrity and performance.
3. Developed stored procedures, user-defined functions, and triggers using T-SQL for efficient data processing.
4. Created and maintained SSIS packages for ETL processes, transforming data from various sources into a staging database.
5. Utilized control flow and data flow tasks in SSIS to streamline data transformations and integrations.
6. Scheduled and managed ETL jobs using SQL Server Agent, ensuring timely data availability.
7. Prepared comprehensive technical documentation, including High-Level Design and Business Analysis reports.

Experience

10+ Years

Level

Management

Education

M.S. CS

Description :

1. Designed and optimized ETL workflows using SSIS, improving data integration efficiency.
2. Created complex T-SQL queries to analyze and report on business metrics, facilitating data-driven decisions.
3. Managed SQL database security, ensuring compliance with best practices for user access and data protection.
4. Perform data modeling to support BI initiatives and reporting needs.
5. Developed and maintained OLAP cubes in SSAS, enhancing data analysis capabilities.
6. Generated detailed reports in SSRS, utilizing advanced features like dynamic parameters and drill-through actions.
7. Conducted data profiling and validation to ensure accuracy and integrity across various data sources.

Experience

5-7 Years

Level

Executive

Education

B.Sc. CS

Description :

1. Collaborated with users and stakeholders to gather requirements for BI solutions, ensuring alignment with business objectives.
2. Developed and maintained SSRS reports, utilizing T-SQL to create data-driven insights for management.
3. Designed and optimized stored procedures, triggers, and functions to enhance application performance.
4. Collaborate with data engineers to ensure data availability.
5. Created OLAP reports and dashboards using SSRS, enabling real-time data analysis for strategic decision-making.
6. Deployed and managed SSRS reports on Microsoft SharePoint, facilitating easy access for users.
7. Conducted training sessions for team members on BI tools and best practices, fostering a culture of data-driven decision-making.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS

Description :

1. Gathered business requirements to inform the planning and implementation of data warehousing solutions for enhanced reporting.
2. Ensure timely delivery of BI projects within budget constraints.
3. Developed logical and physical database architectures using Erwin, ensuring optimal design for data storage.
4. Created stored procedures for auditing and triggers for maintaining data consistency across databases.
5. Enhanced query performance by 35% through effective tuning and optimization of indexes using Performance Monitor and Profiler.
6. Evaluated data structures across source and destination databases to ensure data integrity.
7. Engineered complex mappings with SSIS to facilitate data transformation and loading from Oracle to SQL Server.

Experience

2-5 Years

Level

Junior

Education

B.Sc. CS