SQL BI Developer Resume Samples

Description :

1. Involved in gathering, analyzing and documenting business requirements and preparing technical documents for ETL, SSIS, Data Warehouse, SQL BI Development Worked with Business to document BRDs, Writing Functional Specifications.
2. Extensive work in SQL programming, SQLPlus, Database Triggers, Packages, Cursors, Stored Procedures, Functions and management of Schema objects.
3. Proficiency in Data Definition and Data Manipulation languages.
4. Responsible for application analysis, design, coding, testing and documenting of new interactive web applications as well as maintaining, supporting and upgrading existing web applications.
5. Developed user requirements, functional requirements and technical specifications, process flow diagrams Understand and document business requirements, prioritize the project timelines and demonstrate business requirements to the technical systems team for the development of automated reporting solutions using cutting edge technologies.
6. Involved in the complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
7. Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server, and Flat files.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor Of Science

Description :

1. Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors, and Triggers.
2. Created desired stored procedures for loading the data from different sources according to the mapping rules and design specifications.
3. Designed SSIS Packages drawing data from various data sources such as Flat/Raw File, Excel, CSV, Access, OLEDB, XML, CDC, ADO.NET, etc., and shown familiarity in using transformations like Aggregate, Conditional Split, Derived Column, Merge, Merge Join, Union all, Multicast, Row Count, Lookup, Sort, Audit, Fuzzy Look Up, etc.
4. Experienced in SSIS error handing using event handlers, breakpoints, SSIS loggings, package configurations.
5. Responsibly managed data and metadata in Business Intelligence (BI) solutions latest upgrades of Microsoft SQL Server 2012, 2014 and SSDT 2013.
6. Actively involved in query optimization using SQL Profiler by modifying the slow running queries from the SQL Profiler Trace.
7. Involved in optimizing the stored procedures for a faster population of the reports in the Report Server.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Science

Description :

1. Involved in Database design by creating database objects like tables, views, stored procedures and Optimized the performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs and System stored procedures Assisted with the design and implementation of workflow applications to update and insert data.
2. Coordinate with business users in gathering business requirements and translating them to technical specifications.
3. Created SSIS packages to move the data from Oracle to SQL Server staging Database and from Oracle to Flat files.
4. Involved in creating SQL stored procedures, Functions, Views, Indexes in Microsoft SQL Server using appropriate business rules, standards for better performance.
5. Created packages by using multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Database.
6. Documented and maintained database system specifications, diagrams, and connectivity charts.
7. Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
8. Train and manage developers, advising other groups in the organization on SSIS development, SSRS reports and data warehouse development, and documenting the best practices.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Managed high-availability SQL Server environment supporting financial, business intelligence and CRM systems with load-balancing across multiple data centers.
2. Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
3. Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
4. Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
5. Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
6. Participated in creating reports that deliver data based on stored procedures.
7. Created Report Email Subscription using Data-Driven and Time-Driven Report Subscriptions.

Experience

7-10 Years

Level

Executive

Education

Bachelor Of Science

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. Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server [] and Flat files Create joins and sub-queries for complex queries involving multiple tables.
2. Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
3. Created indexed views, and appropriate indexes to reduce the running time for complex queries.
4. Involved in the installation and configuration of SQL Server 2005, SQL Server 2008 and SQL Server 2012 with the latest Service Packs.
5. Enhancing performance using optimization techniques-normalization(2nf), indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.
6. Created Linked Servers to connect OLE DB data sources and providers Participated in designing a data warehouse to store all information from OLTP to Staging and Staging to Enterprise Data warehouse to do better analysis.
7. Used basic Script Task for renaming the file names, storing Row Count Values into User Variables.
8. Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Science

Description :

1. Participated in end-user meetings to gather Analytic/Reporting requirements of various business users.
2. Analyzed the business requirements and translated the functional specifications into technical specifications.
3. Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
4. Developed various Measures and defined dimensional hierarchies.
5. Migrated data from Heterogeneous data sources (Excel, Flat file, CSV file) to a centralized SQL Server database using SQL server integration services (SSIS) to overcome transformation constraints.
6. Developed Dashboards with different subject matter views (drill-down/dynamic, Pivot Table, Chart). Created packages to transfer data between OLTP and OLAP database using Lookups, Derived Columns, Condition Split, Execute SQL Task, Data Flow task, Execute package task, etc.
7. Developed SSIS packages to load the data into the tables from Text files, Excel files, and CSV files.

Experience

7-10 Years

Level

Senior

Education

Bachelor Of Science

Description :

1. Worked with the development team and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications.
2. Involved in Database design & Data modeling various databases.
3. Developed all the required stored procedures, user-defined functions, triggers using T-SQL.
4. Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
5. Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
6. Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
7. Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
8. Prepared technical documents like High-Level Design Involved in Business Analysis & Requirement collection.

Experience

10+ Years

Level

Management

Education

Bachelor Of Science

Description :

1. Developed and maintained web forms using ASP.Net Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
2. Managed SQL database user accounts, user logins, permissions, database and server roles Promoted database objects from test/develop to production.
3. Coordinated and communicated production schedules within the development team.
4. Developed procedures and triggers involving extensive use of T-SQL to implement business rules Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL 
5. Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks, and transformations provided by SSIS.
6. Validated change requests and made appropriate recommendations.
7. Developed dashboard reports using Power BI Desktop Created and Modified T-SQL stored procedures/triggers for validating the integrity of the data.
8. Involved in Analyzing, designing, building &, testing OLAP cubes with SSAS and in adding calculations using MDX.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Actively participated and interacted with users, team lead, DBAs, and technical managers to fully understand the requirements of the system.
   
2. Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, stored procedures and views).
3. Created Stored Procedures, Triggers, and User-Defined Functions to support the front-end application.
4. Extracted data from many operational systems, including flat files, spreadsheets and RDBMSs like SQL Server and Oracle 8i.
5. Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
6. Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
7. Deployed the SSRS reports in the Microsoft office share point portal server MOSS 2007.

Experience

2-5 Years

Level

Junior

Education

Bachelor Of Science

Description :

1. Gathered business requirements as an endeavor that will facilitate the planning and implementation phase of a data warehouse for reporting.
   
2. Conducted JAD sessions with different Auditors, Business Users to capture and document the BRD and transform the relevant /approved BRD into SRS and FRS.
3. Developed and created logical and physical database architecture using Erwin.
4. Created stored procedures for auditing purposes as well as triggers for data consistency checks.
5. Dramatically increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
6. Examined and evaluated the data structures in the source and destination databases/staging Tables.
7. Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle into the SQL 2008R2/2012 Server target staging database.

Experience

2-5 Years

Level

Junior

Education

Masters Of Information Systems