Senior SQL BI Developer Resume Samples

A Senior SQL Bi Developer works as a part of the development team and targets at improving business performance and developing network architecture. Common job duties seen on the Senior SQL BI Developer Resume include – building analytics environments, understanding business requirements; completing business intelligence projects; improving process flow in the company by executing new data models; writing complex stored procedures; automating the process by creating jobs and error reporting; creating various SSRS reports, and developing expertise in ETL from various heterogeneous sources.

Those seeking this job role should mention the resume the following skills and abilities – experience in BI solutions; experience in developing BI solutions; good hands-on experience with C#, .NET, VB.Net; strong knowledge of data warehousing concepts; and a good understanding of normalization and de-normalization. A degree in IT or computer science is mandatory for this role.

Senior SQL BI Developer Resume example

Senior Sql Bi Developer Resume

Headline : Over 8 years of IT Experience MS SQL Server Developer, involved in Design, Development Support of MSSQL Server  various business domains like Pharmaceuticals, Constructions, financial services Health Care. Excellent working skills MS SQL Server business intelligence tools SSIS, SSRS ,SSAS.

Skills : SQL Server and Databases.

Description :

    1. Actively participated in interacting with users, team lead, DBA's and technical manager.
    2. Expediter in HP Vertica Health Checks and Advanced Performance Tuning with the best implementation practices for improved performance in High-Volume reporting and Real time Analytics.
    3. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
    4. Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005).
    5. Involved in migration and Conversion of Reports from legacy systems to new systems.
    6. Created various complex reports manage those using SQL Server.
    7. Reported Services Involved in migration and Conversion of Reports from legacy systems to new systems.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors


Sr.Senior Sql Bi Developer Resume

Headline : 8 years of experience in SQL Server database development administration, extensively worked OLTP, OLAP, Client-Server & Enterprise Data warehouse Environments. Hands-on experience Upgrade/Migration of MS SQL Server 2005 to 2008, 2000 to 2005 using any suitable approach. Expertise Business Intelligence Tools (SSIS, SSRS AND SSAS).

Skills : intelligence tools SSIS, SSRS ,SSAS.

Description :

    1. Involved in development implementation of SSIS and SSRS application solutions various business units across  organization.
    2. Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
    3. Directly responsible for Extraction, Transformation Loading data from Multiple Sources  Data Warehouse.
    4. Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, For Each Loop, Script Components, error handling.
    5. Created Tabular reports, Matrix reports, List & Chart reports.
    6. Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
    7. Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors


Jr.Senior Sql Bi Developer Resume

Summary : Hands-on experience Upgrade/Migration of MS SQL Server 2005 to 2008, 2000 to 2005 using suitable approach. ExpertiseBusiness Intelligence Tools (SSIS, SSRS AND SSAS) Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins Sub queries with T-SQL.

Skills : Triggers, Views, Cursors, Joins Sub queries.

Description :

    1. Formulated documented ETL process design based on business requirements system specifications including source target mappings, data dictionaries  transformations.
    2. Directly responsible for Extraction, Transformation  Loading of data from Multiple Sources  Data Warehouse.
    3. Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, For Each Loop, Script Components, error handling.
    4. Used various SSIS tasks such as Conditional Split.
    5. Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
    6. Involved in Dimensional modeling to Design and develop STAR Schema, Using ER-win to design Fact and Dimension Tables.
    7. Created SSIS Packages to move data from flat files into SQL server database using SSIS for Each loop task to move all files into SQL Server Database Generated different reports using MS SQL Reporting Services.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Asst.Senior Sql Bi Developer Resume

Summary : Over 7+ Years of working experience SQL Server BI Stack (SSRS, SSIS, SSAS) in various domains Involved business to develop Entity Relationship/data models, requirements document, and ETL specifications. Advance knowledge RDBMS concepts, conceptual/logical/physical data models & Dimensional/Star/Snow Flake schemas.

Skills : RDBMS concepts, conceptual/logical.

Description :

    1. Provided services like banking, insurance, mortgage, student loans and credit cards.
    2. Designed ETL architecture for daily incremental loads to data warehouse from source system.
    3. Worked with Changed Data Capture (CDC) tasks to achieve incremental loads.
    4. Worked on creating logical dimensional modeling for various subject areas.
    5. Used MS Report Designer to provide Report Data pane to organize data used in reports.
    6. Enterprise Data ware House environment to Parallel Data Ware House Environment with reporting tool SSRS.
    7. Responsibilities: Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Engineering In Engineering

Associate. Senior Sql Bi Developer Resume

Headline : Over 7+ Years of working experience SQL Server BI Stack (SSRS, SSIS, SSAS) in various domains Involved business to develop Entity Relationship/data models, requirements document, and ETL specifications. Advance knowledge RDBMS concepts, conceptual/logical/physical data models & Dimensional/Star/Snow Flake schemas.

Skills : RDBMS concepts, conceptual/logical/physical data models.

Description :

    1. Provided mechanism for retail Sales Organization  track revenue per order achieved general, specialized sales queues at a rep/sales representative within  date range given sales management team the ability to quickly analyze the existing sales data.
    2. Set standardized reports along with method extracted and displayed data to fulfill the needs of the business owners.
    3. Created and modified stored procedures, functions, views and indexes to provide best performance.
    4. Used XML with in Stored Procedures different complexes queries in SQL Server environment.
    5. Created managed schema objects such tables, views, stored procedures, triggers maintained Referential Integrity.
    6. Troubleshot included indexes, stored procedures, triggers table structures for application behavior manipulation.
    7. Analyzed source data coming from different sources working with business users developers develop Model.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Senior Sql Bi Developer III Resume

Objective : Over all 8 years of experience Database Design, Programming, Development Implementation client-Server Applications & Database systems using MSSQL.Experienced in Installing, Upgrading Configuring Microsoft SQL Server and Databases. Proficient in SQL Server T-SQL (DDL and DML) in constructing Tables, Normalization techniques database Tables.

Skills : Installing, Upgrading Configuring Microsoft SQL.

Description :

    1. Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005).
    2. Involved in migration and Conversion of Reports from legacy systems to new systems.
    3. Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
    4. Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Dashboard, Drill through and Drill down reports.
    5. Built packages and handled slowly changing dimensions to maintain the historic data.
    6. Involved in migration and Conversion of Reports from legacy systems to new systems.
    7. Used MS Report Designer to provide Report Data pane to organize data used in reports.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Junior
Education
Education
B.sc In Electronics And Computer Science

Senior Sql Bi Developer II Resume

Summary : 7 years of experience SQL Server database development administration, extensively worked OLTP, OLAP, Client-Server & Enterprise Data warehouse Environments. Hands experience Upgrade/Migration MS SQL Server 2005 to 2008, 2000 to 2005 using any suitable approach. Expertise on Business Intelligence Tools (SSIS, SSRS AND SSAS) Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.

Skills : Expert Database Design, Data modeling, Development.

Description :

    1. Roles Responsibilities: Involved development implementation of SSIS and SSRS application solutions  various business units across organization.
    2. Formulated documented ETL process design based on business requirements and system specifications including source target mappings, data dictionaries and transformations.
    3. Directly responsible for Extraction, Transformation  Loading data from Multiple Sources  Data Warehouse.
    4. Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, For Each Loop, Script Components, error handling.
    5. Developed ETL process using SSIS with Various Control Flow, Data Flow task Store Procedures for Work Order Validation process.
    6. Used Lookup transform to create SSIS package for inserting  new entry from excel master defective parts source spreadsheet SQL Server table update old data.
    7. Set standardized reports along with method extracted and displayed data to fulfill the needs of the business owners.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Senior Sql Bi Developer v Resume

Headline : Dedicated technology centric Senior SQL BI Developer with over Eight years experience implementation Database systems in Retail, Banking, Health care and Finance Sectors. Experience in migration data reports using SQL server  and Visual studio  Expert Database Design, Data modeling, Development, Implementation, ETL and Reporting SQL Server  with expertise on data normalization understanding software/application/system development lifecycle.

Skills : Data modeling, Development.

Description :

    1. Worked around with daily to daily basis of Home Equities given to customers across the country through over its all branches implement core banking solutions.
    2. Responsibilities: Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
    3. Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2 and Text files and Excel files and MS word 2007 files) to SQL Server.
    4. Developed ETL process using SSIS with Various Control Flow, Data Flow task Store Procedures for Work Order Validation process.
    5. Used Lookup transform to create SSIS package for inserting  new entry from excel master defective parts source spreadsheet SQL Server table update old data.
    6. Responsible for deployment reports reporting server scheduled subscription for  windows file share.
    7. Troubleshot included indexes, stored procedures, triggers table structures for application behavior manipulation.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Lead Senior Sql Bi Developer Resume

Headline : 8 years experience SQL Server database development administration, extensively worked in OLTP, OLAP, Client-Server & Enterprise Data warehouse Environments. Hands-on experience in Upgrade/Migration of MS SQL Server 2005 to 2008, 2000 to 2005 using any suitable approach. Expertise on Business Intelligence Tools (SSIS, SSRS AND SSAS).

Skills : Client-Server & Enterprise Data warehouse Environments.

Description :

     

    1. Formulated documented ETL process design based on business requirements system specifications including source target mappings, data dictionaries  transformations.
    2. Directly responsible for Extraction, Transformation  Loading of data from Multiple Sources to Data Warehouse.
    3. Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, For Each Loop, Script Components, error handling.
    4. Created various complex reports , manage those using SQL Server Reporting Services (SSRS 2008/2005).
    5. Used MS Report Designer to provide Report Data pane to organize data used in reports.
    6. Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database to SQL Server.
    7. Set standardized reports along with method extracted and displayed data to fulfill the needs of the business owners.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Senior Sql Bi Developer Resume

Headline : Highly qualified Senior Sql Bi Developer with experience industry. Enjoy creative problem solving getting exposure on multiple projects, would excel collaborative environment on which your company prides itself.

Skills : Extensively worked in OLTP, OLAP, 

Description :

    1. Altogether, Best Buy employs more than 140,000 people earns annual revenues of more than $40 billion.
    2. Field Operation Reporting Tool (FORT) This top reporting analytics Project which had developed using .net and CSS.
    3. Migrated from Enterprise Data ware House environment to Parallel Data Ware House Environment with the reporting tool SSRS.
    4. Analyzed business requirements and understanding the functional workflow of information from source systems to destination systems.
    5. Managed index statistics, Tables, Views, cursors  optimizing queries  using execution plan for tuning the database.
    6. Formulated documented ETL process design based on business requirements and system specifications including source target mappings, data dictionaries and transformations.
    7. Created and modified stored procedures, functions, views and indexes to provide best performance.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor In Computer Engineering