We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

Phoenix, AZ

SUMMARY

  • Over 8 years of professional experience in SQL Server database development, Banking(Financials/ Mortgages), Medical Healthcare and Retail sectors as a SQL server Developer that includes Database Design and Development
  • Hands on experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, and data integrity.
  • 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.
  • ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
  • Good Knowledge of SQL Server 2012/2008R2/2008.
  • Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases.
  • Developed complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, and for Loop Sequence Container.
  • Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
  • Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.
  • Experience in MS SQL Server configuration, performance tuning, query optimization, back-up and recovery, running Database.
  • Knowledge in scripting T-SQL queries, complex stored procedures, User Defined Functions (UDF), Database triggers.
  • Experienced in developing database scripts (DML/ DDL), stored procedures, views and other database objects necessary to accomplish project objectives.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Good Knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
  • Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
  • Ability in Creating Drill down and Drill through reports with Drop down menu in SSRS.
  • Working Experience on Database development for both OLTP (Batch Processing, Online Processing) &OLAP Systems (SSRS, SSIS, and SSAS) using SQL Server 2012/2008R 2/2008/2005.
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Developing tools using Access, VBA, and Excel environment.
  • Tableau Experience in Enterprise Environment and Tableau Administration.
  • Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
  • Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
  • Good at creating Dashboard Reports to support end users using SSAS.
  • Experience throughout developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
  • Proficient in building Star schema and Snow Flake schema depending on business requirements.
  • Working Experience on Multidimensional Expressions (MDX).
  • Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
  • Strong in Writing User Manuals, Documentation, Proposals and also Good team player.

TECHNICAL SKILLS

Languages: C, T-SQL, PL/SQL, JavaScript, C#.

RDBMS: SQL Server 2012/2008R 2/2008/2005/2000 , 7.0, MS-Access.

Front End: MS Visual Basics 6.0.

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting.

Version Control: Visual Source Safe, Clear Case.

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services.

Data Modeling: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007

Operating System: Windows 2012, Windows Server 2008, Windows 95/98/2000 XP/Vista/7/8, Unix.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

SQL BI Developer

Responsibilities:

  • Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
  • Designing and developing new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages by using Visual Studio 2015.
  • Set up ETL Jobs to run on a daily basis in SQL Server Agent using SQL Server 2014.
  • Created many complex Stored Procedures/Functions and used them in SSRS Reports directly to generate reports on the fly.
  • Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
  • Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.
  • Knowledge in design and development of Tableau visualization Solutions.
  • Development and assisting users in creating and modifying worksheets and data visualization dashboards by using Tableau 10.1
  • Created drill down and drill up in worksheets in Tableau Dashboard.
  • Developing Dashboards and preparing ad-hoc Reporting.
  • Developed complex SQL queries for creating BI layer on DW for tableau reporting

Environment: Windows 7, Tableau 10.1/ 9.1, MS SQL Server 2014/2012, SSIS, SSRS, T-SQL, SharePoint Portal Server 2010, ETL, MS Office 2010/2013, Visual Studio 2015

Confidential, Rancho Cordova, CA

SQL BI Developer

Responsibilities:

  • Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently by using SSRS.
  • Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
  • Worked on EDI 835, 837 Inbound and Outbound.
  • Developing and maintain EDI training manual and system documentation.
  • Working on experience with permissions, Security, User/User group setup.
  • Creating Extracts and scheduling them to increase performance of the dashboards.
  • Monitoring User activity, server performance and user licensing.
  • Designing and development of Metadata Driven SSIS packages for Data Warehouse for Data moving and Summarization in a Reporting Data Mart.
  • Developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
  • Designing and developing new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages
  • Developing highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, and For Loop Sequence Container.
  • Creating Database Objects like Tables, Views, Stored Procedures.
  • Set up ETL Jobs using SSIS to run on a daily basis in SQL Server Agent.

Confidential, Phoenix, AZ

Sr. SQL Server SSIS/ Report Developer

Responsibilities:

  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Worked on security configuration, setup of Sites, Workbooks, Views and Data sources in SSRS.
  • Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
  • Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
  • Hands on experience with permissions, Security, User/User group setup.
  • Creating Extracts and scheduling them to increase performance of the dashboards.
  • Developed Word forms using VBA to conduct various surveys in order to optimize monthly report based on team usage.
  • Monitoring User activity, server performance and user licensing.
  • Designing and development of Metadata Driven SSIS packages for Data Warehouse for Data moving and Summarization in a Reporting Data Mart.
  • Designing and Development of ETL Process(SSIS) for integrating data from sources like Excel, CSV, Flat Files, Web Services, XML Source and SQL Server.
  • Designing and developed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages
  • Created Database Objects like Tables, Views, Stored Procedures.
  • Set up ETL Jobs to run on a daily basis in SQL Server Agent.
  • Responsible for testing of SQL Code, SSIS Packages using MS SQL Integration Services 2008.
  • Responsible for Scheduling and maintaining reporting and SSIS data load Jobs.

Environment: Windows 7, Tableau 8.0/ 8.1, MS SQL Server 2012,2008R2, SSIS, SSRS, T-SQL, SharePoint Portal Server 2010, ETL, MS Office 2010/2013.

Confidential

SQL SSIS/SSRS/SSAS/Support Role

Responsibilities:

  • Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008/2008R2/2012 and Worked with users in training and support and also have experience in incremental data loading.
  • Managed up gradation of DTS packages to SSIS packages
  • Responsible for developing, monitoring and deploying SSIS 2012/2008R2/2008 packages.
  • Created many complex Stored Procedures/Functions and used them in SSRS Reports directly to generate reports on the fly.
  • Designed and created MDX queries to retrieve data from cubes using SSIS.
  • Substantial knowledge throughout Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2012/2008R2/2008.
  • Worked on Active Batch V8. And also SAP CPS and Cognos.
  • Created various Weekly and Monthly reports showing detailed information in SSRS.
  • Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language (RDL).
  • Used DMX to create data-mining models.
  • Most of my work with Issue Support Role. And also worked on BMC Remedies.
  • Involved in the creation of Data Mart by taking into various business process by identifying different dimensions and facts.
  • Used Active Directory for Identity management designed to provide strong authentication and authorization for internal and external websites.
  • Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
  • Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.

Environment: MS SQL Server 2012/2008R2/2008, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2012,Active Batch, Auto ETL Windows Server 2012, MS Office 2010. SQL Server Management Studio

Confidential, PA

SQL Server/SSAS/SSIS/SSRS Developer

Responsibilities:

  • Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
  • Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Installed and configured MySQL on Linux and Windows environments.
  • Created Queries in T-SQL, Stored Procedures, Clusters and Views to store the data of clients, advisors. Worked with multivalve parameters for parameterized reports in SSRS.
  • Developed VBA scripts for periodic P&L (Daily, Weekly) reports using Excel, Access (Reports, Forms).
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
  • Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Tabular model by retrieving data and aggregates directly from a relational database system, using Direct Query mode.
  • Used IBM Data stage Designer to develop jobs for extracting, cleaning, transforming and loading data into data marts/data warehouse.
  • Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
  • Conducted the Error handling in SSIS (ETL) using the Event Handlers.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2008R2/2008, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2012, .NET(C#, VB), Windows Server 2012, MS Office 2010. SQL Server Management Studio, MS Excel, ERWIN

Confidential, Montgomery, AL

SQL BI Developer

Responsibilities:

  • Using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environment and extracted the data using SSIS from OLTP to OLAP.
  • Developed PL/SQL triggers, procedures, functions and packages for the various interfaces.
  • Generated Adhoc Tableau reports on demand for providers.
  • Generated Tableau reports with Trend lines.
  • Experience in Handling premium billing, commissions, capitation, and reporting by using Facets.
  • Implemented data warehouse design principles and best practices for maintaining dimension and fact tables.
  • Generated Parameterized Reports and cascaded Parameterized Reports.
  • Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
  • Worked on up gradation of Database from SQL Server 2008R2 to 2012.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
  • Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, T-SQL, SSRS, SSIS, SSRS, SSAS, Visual Studio 2005

Hire Now