We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Dallas, TX

SUMMARY

  • Around 7+ years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
  • Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
  • Strong working experience on SQL 2000/2005/2008 R2/2012/2014 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Experienced in SQL Server 2005/2008/2012/2014 RDBMS database development including T - SQL programming.
  • Experience in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
  • Experience in developing reports on SSRS on SQL Server (2005/2008/2008 R2/2012/2014). Sound Experience and understanding of SSIS & DWH Architecture.
  • Experience in ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
  • Good working experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
  • Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012/2014 and Transformation.
  • Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schemas.
  • Experience in creating Gauge Reports with KPI’s, Report Model and Report Builder 1.0, 2.0.
  • Thorough understanding of Kimball’s’ theory, KPIs and Perspectives, SQL 2008/2012 Architecture.
  • Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Experience working on Data modeling, creating star and snowflake schemas in SSAS.
  • Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
  • Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
  • Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R 2/2005/2000/2012/2014.
  • Excellent communication and analytical skills, understands business requirements in various domains.
  • On-call duty with teammates 1-2 weeks per month and active involvement in Go-live activities.

TECHNICAL SKILLS

Databases: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g/10g/9i Microsoft Access, SharePoint 2010/2007, Oracle SQL Server 9i/10g/11g.

Programming Languages: T-SQL, PL/SQL, HTML, DHTML, XML, VB.NET, C#.Net.

IDE Tools: Visual Studio .Net 2010/2008/2005

Framework: Microsoft .Net Framework 4.0/3.5/3.0

Data Modeling: Erwin, MS Visio 2010.2007/2005.

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Informatica

Reporting Tools: SQL Server Reporting Services (SSRS) 2008R2\2008\2005, Crystal Reports, Business Objects.

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export(DTS),performance point server 2007.

Configuration Management Tools: JIRA, Team Foundation Server (TFS) 2010/2008/2005 .

Operating System: Windows Server 2003, Windows 2000 Advanced Server/Professional, Windows NT, Windows XP Professional /Standard

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

SQL BI Developer

Responsibilities:

  • Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers.
  • Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
  • Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.
  • Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2.
  • Setup and monitored jobs for loading and processing SSAS Cubes.
  • Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
  • Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
  • Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2014/2012/2008 R2.
  • Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.
  • Created SSRS dashboards using charts, gauges, indicators and data bars.
  • Deployed SSRS reports in native and SharePoint mode.
  • Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
  • Developed MDX queries for SSRS reports from SSAS Cubes.
  • Developed powerview reports using Tabular Models in SQL Server Data Tools.
  • Created standard and data driven subscriptions for weekly, monthly and daily reports.
  • Extensive used Team Foundation Server to implement version control for MSBI (SSIS/SSRS/SSAS) projects.
  • Training business users on using Excel 2013/2010 to create ad-hoc pivot tables and charts from SSAS cubes and using Performance Point Services (UI).
  • Participated in code-review sessions on existing SSRS report’s performance and Dataset query tuning.
  • Worked with business analysts on creating new SSRS reports with requirements like data source, parameters, formatting, printing and subscriptions.
  • Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.

Environment: SQL Server 2014/2012/2008 R2/2008, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tabular, Excel 2013,XL-Cubed, Power view, Power pivot, Performance Point, MDX, Report Builder 3.0, DTS, C#, VB.NET, Erwin 4.0,XML, SVN, Rally, Windows Server 2008,.NET 3.5.

Confidential, Overland Park, KS

SQL BI Developer (SSRS, SSIS SSAS)

Responsibilities:

  • Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
  • Involved in migration of SQL Server 2005 to 2008/2012.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
  • Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Involved in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Created several SSIS packages for performing ETL operations to transform data from NDS to DDS systems.
  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.
  • Processing the cubes and dimensions on a daily basis using the SSIS tasks.
  • Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
  • Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP.
  • Developed the ETL mappings in PL/SQL via packages, stored procedures, functions, views and triggers.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
  • Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
  • Created Analytical reports by PROCLARITY tool.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Environment: SQL Server 2005/2008R2/2012, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#, Agile, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, MS Visio.

Confidential, Charlotte, NC

SQL Server Developer (SSIS, SSRS)

Responsibilities:

  • Being a member of BI Team, involved in gathering requirements from Business users and Perform technical design Development and Testing.
  • Involved in design and creation of data mappings from sources like Flat files, Excel files, OLEDB and ODBC data sources which contains bulk data.
  • Developed ETL packages to extract, transform and load into Data ware house using of SQL Server Integration Services (SSIS).
  • Constructed an API to access OLAP and information in the database.
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Involved in migration from SQL Server 2005 to SQL Server 2008.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Worked on Business Objects in order to access reports and to export data.
  • Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Provides technical documentation of the system
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: SQL server 2000/2005/2008 /2008R2/2014, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i,Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, T-SQL, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2008, MS Access, Crystal Reports.

Confidential, Evansville, IL

SQL Server Developer/DBA

Responsibilities:

  • Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
  • Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
  • Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
  • Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different sources into company's format.
  • Created Packages using Complex Store Procedures and T-SQL queries.
  • Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types.
  • Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
  • Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
  • Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
  • Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
  • Configured, Installed, and Administered Reporting Services 2005/2008.
  • Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports.
  • Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
  • Developed reports using complex T-SQL queries, User Defined Functions, stored procedures and Views.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
  • Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
  • Deployed reports across Test, Development and Production Environments. Involved in Trouble Shooting Complex Reports.
  • Created Large Number of Report Models for users to create their own reports.
  • Involved in code reviews, change control and auditing procedures.

Environment: T-SQL, SQL Server 2012/2008R2/2008/2005, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.Net 2003, Erwin Data Modeler.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Re-engineered the existing Lifeline V1.4 to n-tier arch.
  • Gathered the requirements and enhanced the features.
  • Responsible for T/SQL coding and Visual Basic development.
  • Involved in controlling and co-coordinating the installations (security patches, Service packs) and system performance before pre-deployment.
  • Wrote the queries for the drill down reports.
  • Identified and added the report parameters.
  • Developed stores procedures, views and functions.
  • Involved in up gradation of SQL Server 7.0 to SQL Server2000.
  • Responsible for team management, internal training, and upgrading skill sets of the team.
  • Maintained the configuration management system.
  • Involved in development and implementation of the application using Visual Basic ADO-DB Record Set and OLEDB provider for SQL Server.
  • Developed DTS packages to import data from various sources into the system.

Environment: SQL Server 2000, VB 6.0, Visual Source Safe 6 and Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

  • Designed and created SQL Database, tables, indexes, and views based on user requirements.
  • Created User Defined Functions, cursors, and Triggers.
  • Created & used stored procedures for database transactions in SQL Server.
  • Created tables, views, clustered & non-clustered index, user defined data types and functions.
  • Developed stored procedures and views for managing efficient data retrieval.
  • Wrote various Stored procedures for the purpose of application development
  • Developed backup & restore scripts for SQL Server as needed.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Used multiple join statements to retrieve data from multiple tables.
  • Worked in the team for gathering and analyzing the needs of end user requirements.
  • Worked in enhancing the bug/issue tracking system used by the entire team, to produce flexible reporting with respect to the life cycle of an issue.

Environment: MS SQL Server 2000/2005 Enterprise Edition, MS Access, MS Excel, DTS, SQL Profiler, PL/SQL.

Hire Now