We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Birmingham, AL

PROFESSIONAL SUMMARY:

  • SQL Server BI Developer having around 8 Years of experience, well versed in all phases of Analysis, DesignDevelopment, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BIsuite (Development, UAT and Production Environment).
  • Extensively worked on data modeling, Normalization and De - Normalization techniques for both OLTP and OLAP.
  • Excellent knowledge in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key and Unique) Indexes and Batch Scripts using various DDL and DML commands.
  • Very good knowledge in designing database objects like Tables, Views, Constraints, Indexes and defaults.
  • Experience in designing Database Models using MS Visio and ER-Win for both Relational and dimensional modeling
  • Implemented SQL Server Indexing, Index tuning using Index Tuning Wizard and Tuning Advisor
  • Excellent knowledge in performance tuning and query optimization Using SQL Profiler, Execution Plan,
  • Performance Monitor.
  • Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
  • Experience DBA Activities in Development/Test environments including Backups, Restores, Data refreshes, Security and User management, Performance Tuning.
  • Developed SSIS Packages to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
  • Created several Staging Databases.
  • Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities
  • Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Expertise skills in calculating measures and dimension members in SQL Server Analysis Services using Multi Dimensional Expression (MDX), mathematical formulas, and user-defined functions.
  • Involved in adding KPI’s, Calculated Aggregates, Actions and Partitions.
  • Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS across various environments
  • Expert in designing Enterprise reports using SQL Server Reporting Services, use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
  • Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
  • Ability to export reports and query results to MS Excel, PDF, HTML, etc.
  • Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
  • Creating and Managing users, roles and assigning necessary permissions.
  • Involvement in Backing up databases and refreshing Data across environments.
  • Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Analysis Services, SQL Server Reporting Services etc.
  • Excellent skills in preparing Project documentation and Use Cases, using MS Office and MS Visio.
  • Ability to manage and deliver results on multiple tasks by effectively managing time and priority constraints.
  • Excellent communication and interpersonal skills in handling multiple tasks, able take initiative to handle responsibilities independently as well as a member of team.

TECHNICAL SKILLS:

RDBM/Databases: MS SQL Server 2005/2008 /2008R2/2012, Teradata V2R5/R6, Mysql

Languages: T-SQL, Dynamic SQL, HTML, XML, C, C++ and MDX.

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, MS- Access.

Data Design Tools: ER/Studio, ERWIN, MS Visio.

BI Tools: SQL Server Reporting Services (SSRS 2005/2008/2012), SQL Server Integration Services (SSIS 2005/2008/2012), SQL Server Analytical Services (SSAS 2005/2008), Visual Studio, BIDS.

Tools/Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, Visual Studio Team Foundation Server (TFS), Visual Source Safe (VSS).

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, ProClarity

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

SQL BI Developer

RESPONSIBILITIES:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server and Flat files.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for each loop Containers and Merge join, etc.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created SSIS packages for Data Conversion using data conversion transformation.
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAScubes.
  • Involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server that maintained data.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Optimized queries by looking at Execution Plan for better tuning of the database.
  • Used the Ralph Kimball methodology, star schemas with conformed dimensions and fact tables.
  • Worked with Star/Snowflake Schema modeling to develop ROLAP/MOLAP/HOLAP cubes using the respective fact and dimension tables, performed the processing and deployed the cubes to SQL server analysis services database.

Environment:MS SQL Server 2005/2008/2008R2/2012, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Business Intelligence Development Studio, MDX, T-SQL, MS AccessMicrosoft SharePoint, MS Project, Windows 2K platform.

Confidential, Hopkins, MN

MS SQL/SSIS/SSRS Developer

RESPONSIBILITIES:

  • Responsible for building and supporting Patient Access applications Patient Registration, Payer Contracting, and Insurance Verification.
  • Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
  • Created different types of User-defined functions and Stored procedures using T-SQL.
  • Used Shared Connection managers and new functions like Reverse(), Left(), replace() functions in SSIS.
  • Implemented error handling in SQL Server 2012 using the THROW function.
  • ETL, data profiling, data quality and clean ups for SSIS packages.
  • Designed Logical and Physical Data Model with Erwin tools.
  • Created SSIS packages to populate data from various data sources.
  • Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
  • Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
  • Developed SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Deployed reports, created report schedules and subscriptions.
  • Managing and securing reports using SSRS.
  • Built ad-hoc reports using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server2008 R2/2012, Team Foundation Server (TFS), Microsoft SharePoint Server (MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Teradata,T- SQL.

Confidential, Northbrook, IL

MS SQL BI Developer

RESPONSIBILITIES:

  • Responsible for gathering Business Requirements and System Specification from users.
  • Involved in Creation of Facts, Dimensions using STAR and SNOW FLAKE Schema.
  • Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
  • Created several SQL Server Analysis Projects using MS SSAS.
  • Created non-clustered Indexes to get the high level performance.
  • Loading data from various sources like flat files, to SQL Server database Using SSIS Package.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Designed SSIS packages for synchronizing the data between two different servers.
  • Experience in creating SSIS packages using different type’s task and with Error Handling.
  • Written SQL queries, MDX queries and developed reports like cascade parameterized reports, reports with sub reports, drill through reports using SQL reporting services.
  • Create scorecards, KPIs and dashboards, analytical charts and reports.
  • Use different features like grouping, sorting, and reports parameters to build sophisticated reports.
  • Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical reports from SQL/OLAP data sources using SQL Server Reporting Services.
  • Involved in the implementation of share point.
  • Reviewed and developed data models and database designs with development teams.
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Responsible for generating different types of daily and weekly Reports based on requirements using SQL Server Business Intelligence Tool.

Environment: SQL Server 2008/2008R2/2012, Query Analyzer, SSIS, MDX, T-SQL, Excel, Microsoft SQL Reporting Services (SSRS), Windows 2000/XP, SSAS, SharePoint services, ERwin.

Confidential, Bentonville, AR

SQL/SSIS/SSRS DEVELOPER

RESPONSIBILITIES:

  • Wrote complex SQL queries to populate data from different tables and which can be used for reports.
  • Developed ETL Packages using SQL Server Integration Services to populate data from different sources, for example flat files/SQL/Oracle Server to the Staging Database and then into the Data Warehouse.
  • The packages created included a variety of transformations, for example, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
  • Tested Packages and fixed bugs using SQL Business Intelligence Development Studio.
  • Created SSIS Packages with Error Handling, logging and SSIS Configurations.
  • Created SSIS packages which are Meta Data Driven and which has Parent child relationships.
  • Deployed and scheduled SSIS Packages in the test environment and Pre-Prod environment to mimic the prod functioning.
  • Created drill down reports, drill through reports, cascade parameter reports, parameterized reports and several other types of reports using SQL Server Reporting Services.
  • Created subscription for reports.
  • Deployed the generated reports on to the server.
  • Script SQL statements to extract data from the SQL Server for data cleanup.
  • Monitored the table-spaces for the production databases on daily basis and increasing the sizes if required.
  • Written T- SQL queries for data retrieval.
  • Fine-tuned SQL queries using hints for maximum efficiency and performance.

Environment: MS SQL Server 2005/2008/2008R2, T-SQL, MS Access, Windows 97/2000/XP, ER-Win v4.0, Visual Source Safe (VSS), SQL Query Analyzer, Profiler, Data modeling, ETL, DTS packages.

Confidential

MS SQL/SSIS/SSRS Developer

RESPONSIBILITIES:

  • Developed Business Process Flows and created ER diagram using ERwin for social media management software for the development team to understand the system.
  • Designed a relational database using Erwin data modeling tool.
  • Created logical and physical data models.
  • Defined the relationships between primary and foreign keys in tables.
  • Generated the data base script using Erwin.
  • Integrated Database maintenance jobs to perform full, differential & transaction log backups and scheduled them with the SQL Server agent job scheduler.
  • Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
  • Created rollback and committed transactions in SQL queries, used collections, inserted various kinds of constraints and indexes to enhance the queries.
  • Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base.
  • Use SQL profiler to identify long running queries.
  • Write complex SQL queries and create stored procedures for retrieval of the data and analysis of the data. Created complex Triggers, Functions, Indexes, Tables, Views, SQL Joins and T-SQL code to implement business rules.
  • Identified key dimensions and key measures. Built dimensional model and assign hierarchy, attribute relationship to the various dimensions and measures defined using SSAS.

Environment: MS-SQL Server 2005/2008, MS-SQL Server Reporting Services, MS-SQL Server Integration Services,

Hire Now