We provide IT Staff Augmentation Services!

Sr Sql Bi Developer/etl Resume

4.00/5 (Submit Your Rating)

PortlanD

SUMMARY

  • Over 8+ years of extensive experience working with BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008 R 2/2012/2015.
  • Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
  • Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
  • Performance Tuning in SQL Server - Using SQL Profiler, DTA (Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk Loading Data(BCP),Indexed Views & Schema Binding, STATS, Clustered/Non Clustered Indexes.
  • Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
  • Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
  • Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
  • Experience in generating reports for OLTP and OLAP databases.
  • Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
  • Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
  • Hands on experience working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), Power view.
  • Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT.
  • Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R 2/2012/2015.
  • Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
  • Worked in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version ( 2005/2008/2012 ) and troubleshoot migration issues.
  • Experience in designed Data Conversions from wide variety of source system using SSIS.
  • Experience working with different SSIS Configuration options and Deployment Methods for different environments use.
  • Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
  • Experience working with Data Cleansing technique in ETL process.
  • Hands on experience working with different types Dirty Data from different sources.
  • Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
  • Excellent Hands on Logging, Error handling using Event Handlers pre and post for SSIS Packages.
  • Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/2012 Analysis Services (SSAS).
  • Excellent hands on experience in creating groups and measures, KPIs.
  • TFS, Tortoise Subversion, VSO (online visual Studio)/Visual Studio Team Services
  • Good Knowledge in front end applications like C# .NET, ASP.NET.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R2, 2005 & 2000/7.0, MS-Access 2000, Oracle 11g/10/9i, DB2

Database Tools: SSMS, BIDS/Visual Studio, TOAD

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX, COBOL

RDBMS: SQL Server 2000/2005/2008 R2/2012, Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite, Quality Control(QC)

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC.

PROFESSIONAL EXPERIENCE

Confidential, Portland

Sr SQL BI Developer/ETL

Responsibilities:

  • Developed complex stored procedures, indexes, triggers, functions and views for different applications using SQL.
  • Expressions (DAX) and using Power Pivot for analysis included functions in MDX queries and metadata and prepared and deployed dashboards and reports using SSRS and Tableau.
  • Experience on working with SQL Joins, Common Table Expressions (CTE), Sub queries.
  • Used Triggers to generate customized error messages.
  • Writing complex SQL queries for data extraction from the source, based on the client requirements.
  • Experience in performance tuning of SQL queries and stored procedures by creating Indexes on the columns, which enhances the performance of the code.
  • Experience in developing different types of reports such as parameterized, drill down and drill through using SQL Server Reporting Services (SSRS).
  • Experience with report deployment, scheduling and uploading files to report server catalog from report manager.
  • Validated reports to ensure quality of data and Interacted with business analysts to review reports and btain continuous feedback.
  • Developed SSIS packages to import the data from CSV Files, Text files and Excel spreadsheets.
  • Hands on experience in using different transformations like Script task, Fuzzy Lookup, Derived column, Conditional split and Multicast transformation using SSIS.
  • Created SSIS packages to load data into Data Warehouse using Various SSIS tasks which includes execute SQL task, bulk insert task, data flow task, file system task.
  • Working on C# Scripting to create packages in SSIS based on Client requirements.
  • Working on resolving bug fixes in queries, reports and packages which leads to report failure and incorrect data.
  • Strong experience in transforming business requirements into functional requirements for Tableau and Qlikview reports design, development and deployment.
  • Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
  • Extensively worked on Amazon reports conversions from Oracle source to SQL.
  • Responsible for performing UAT on the reports after checking in the code into Team Foundation Server (TFS)/ Visual Studio Team Services and deploying the reports to production environment.
  • Provide technical support and insight to the improve user experience and solve production issues.

Environment: s: MS SQL Server 2015/2012, SQL Server Analysis Services, Report Builder 3.0, SQL Developer, Tableau, Qlikview, impromptu reports, online visual studio

Confidential, New York

SQL BI Developer/ETL

Responsibilities:

  • Analyzed the Reports, Tables and ETL process, Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
  • Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
  • Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
  • Configured Server for sending automatic mails to the respective people when a SSIS package fails.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • My role is involved with designing, generating, publishing and maintaining visualized reports using Tableau, designing database structure and migrating data for Tableau reports.
  • Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
  • Extensively worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
  • Effectively visualized data (dashboards, reports, etc.) in QlikView, Qlik Sense and MicroStrategy for different business users and requirement.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
  • Generated reports that can handle dynamic grouping and dynamic sorting.
  • Created drill down, drill through, sub reports and many more complex reports.
  • Permitted access to the reports based on designation of the viewer like store manager or district manager or associate extra.
  • Experience in using SSRS gateway service calls to and from SSRS reports.
  • Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway
  • Involved in creating report models and applying row level security filters for report model.
  • Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
  • Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Used Pivot table to provide structure to Reports in proper manner like months etc.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports.
  • Deployment of the developed reports on to the server for the end users.
  • Deployed the developed reports and upgraded the system.
  • Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
  • Created reports by retrieving the data from cube using MDX reports.
  • Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
  • Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
  • Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key in order to streamline the process of replication.
  • Test data entry into Facets application in the test environment for creating groups, subscribers and family members. .

Environment: s: Windows server 2000/2003, MS SQL Server 2012/2008 R2, SQL Server Analysis Services,Tableau, Qlikview, Report Builder 3.0, DTS, VMware, ASP.Net, C#, MVC, SQL Server Reporting Services and SQL Server Integration Services, Performance Point Dashboard Designer, MS SharePoint Server 2010.

Confidential, Minneapolis, MN

SQL BI Developer/SSIS/SSRS/SSAS/ETL

Responsibilities:

  • Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
  • Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to Parallel data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Created SQL server jobs to execute SSIS packages according to the load type of the data.
  • Involved in writing stored procedures to create table structures in stage and pulling data from metadata.
  • Involved in creating marts and developing mart views used for the report building.
  • Created SSIS packages templates to clean and load data to parallel data warehouse, including error handling and metadata management.
  • Designed and deployed reports with Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
  • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
  • Deployed different SSIS packages on test and production servers.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
  • Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
  • Created the SQL server users and file server users with required permissions by including them in the scripts.
  • Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.
  • Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and C# scripts.
  • Created Master SSIS templates for Dimensions and Facts.
  • Used various control flow tasks such as FTP, bulk insert task, transfer job task and different data flow tasks.
  • Configured Server for sending mails when a SSIS process fails.
  • Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
  • Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc
  • Experience in using SSRS gateway service calls to and from SSRS reports.
  • Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.

Environment: SQL Server 2012, SSIS (2012), SSRS (2012),SSAS, T-SQL, SSMS, Maestro Jobs, Visual Studio 2010/2013, MS Excel 2010, Power Designer.

Confidential - Plano,TX

SQL Server Developer |SSIS|SSRS Developer

Responsibilities:

  • Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
  • Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Created different Parameterized Reports (SSRS 2000/20 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
  • Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
  • Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
  • Designed and deployed reports with Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
  • Generated parameterized queries in SSRS 2008 R2/2012 using data from SSAS Cubes and various heterogeneous data source
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
  • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
  • Deployed different SSIS packages on test and production servers.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
  • Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
  • Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
  • Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2/2012.
  • Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Create ad-hoc SQL queries for customer reports, executive management reports
  • Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server

Environment: SQL Server 2012, SSIS (2012), SSRS (2012), Maestro Jobs, Visual Studio 2010/2013, MS Excel 2010, Power Designer.

Confidential - Charlotte,NC

SSIS/SSRS Developer

Responsibilities:

  • Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
  • Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2008/2005 using Oracle 11g as the data source.
  • Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex).
  • Experience in using SSRS gateway service calls to and from SSRS reports.
  • Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.
  • Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS 2008 R2.
  • Comfortable mentoring others in my team for complex SSRS reports.
  • Data Transformation Activities using DTS Import/ Export for transferring data between different databases like Oracle.
  • Design new DTS packages as per needs, Resolve the problems.
  • Migrated data from different environments to SQL Server 2008 R2 via SSIS and also applied conversion and transformation procedures according to business requirements.

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008 R2, SSIS 2008 R2, MS Visual Studio 2008, Oracle SQL Developer (3.0.04)

Confidential - Cleburne,TX

SQL Server Developer |SSRS|SSIS | T-SQL

Responsibilities:

  • Used Workforce Central Management 6.1 version tied the SQL Database to the workforce management by using SSMS and verified the created 120 SSRS reports from user perspective to make sure right amount of data is processed.
  • Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
  • Worked on RDL‘s of the reports and promoted those RDL’S to WFC portal.
  • Troubleshoot SSIS Packages and convert to SSRS Reports.
  • Responsible for Debugging reports using Stored Procedures.
  • Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using RDL.
  • Promoted RDLs to Reporting Service Server.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Evaluate current reporting infrastructure to find bottlenecks and recommend improvements.
  • Responsible for creating/migrating undocumented crystal/SSRS reports.
  • Created and modified efficient Stored Procedure and functions which implement necessary business logic to support the front end application to facilitate pulling data.
  • Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer.
  • Create new SSIS Packages to export flat file for customer.
  • Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created package to transfer data between OLTP and OLAP databases.
  • Assisted front-end C#.NET and ASP.NET developers using Visual Studio 2008 (C#, ASP.NET).

Environment: SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports XI, Visual Studio, T-SQL, C#.NET, ASP.NET

Confidential - Waltham, MA

SQL Server Developer |SSIS|SSAS| T-SQL

Responsibilities:

  • Primary role was SQL Server Developer with SSIS and SSAS.
  • Created and executed SSIS (.dtsx) packages to extract data from the various data sources such as flat file, excel and from other database such as Oracle and by different data loading operations for many applications which is main purpose of ETL development using SSIS 2005/2008.
  • Wrote DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
  • Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Enhancing and deploying the SSIS Packages from development server to production server
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Developed cubes by defining data sources and data source views and using SQL server analysis services (SSAS).
  • Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
  • Involved in defining Referenced Relationships with the measure groups and fact tables.
  • Defined Granularity within a measure group and drill through actions.
  • Implemented the calculations to aggregate physical measures.
  • Using MDX created calculated members for customized calculated measures.
  • Analyzing the Performanceofa cube by partitioning it and creating Perspective Cubes.
  • Wrote MDX queries and expressions for use in Front End BI Applications.
  • Created KPI Objects in line with Requirement Docs and Optimized cubes for better query performance.
  • Created reports from cubes by writing MDX queries.
  • Writing various Stored Procedures, Triggers, Functions, and Views based on the functionality requirements for various teams and also to load data from the OLTP database.
  • Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2000/2005/2008 , BIDS 2005/2008, SSAS 2005/2008, SSIS 2005/2008, DTS, MDX, VB, MS Access, Visual Studio, T-SQL, Windows XP

Confidential - Fort Worth, TX

SQL Server Developer |SSIS|SSRS| T-SQL

Responsibilities:

  • Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
  • Modified current database by adding tables, altering referential integrity and relationships to support the control system.
  • Created user defined data types and added them to model database for future purpose.
  • Created and debugged complex stored procedures and functions for better performance and flexibility.
  • Optimized SQL queries for efficiency and assisted the front end developers with their queries and procedures.
  • Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
  • Created clustered /non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
  • Used Triggers to generate customized error messages.
  • Design new SSIS packages as per needs, Resolve the problems.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
  • Designed and implemented reports with different layouts using SSRS 2005.
  • Design and Implementation of Data Mart for reporting purposes.
  • Responsible for installing Business Objects Enterprise management system on production systems and setting up external and internal user’s access and security settings to published reports.

Environment: SQL Server 2005, SSIS (2005), SSRS (2005), Crystal Reports XI, Business Objects, Erwin, Windows Server 2003, Visual Studio

Confidential

Junior SQL Server Developer| Report Writer/Developer | T-SQL

Responsibilities:

  • Created SQL server Reports using SSRS 2000 while identifying the data source and defining them to build the DSV’s.
  • Created Queries for generating drill down, critical drill- through reports in SSRS 2000.
  • Designed and implemented stylish report layouts.
  • Generated Reports using global variables, expressions and functions for the reports.
  • Identified and worked with parameters for parameterized reports in SSRS 2000.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Developed complex SPs, triggers, cursors, tables, indexes, constraints, views and other SQL joins for applications.
  • Responsible for deploying the generated reports.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
Environment: SQL Server 2005, SQL Server Reporting Services 2005(SSRS), T-SQL

We'd love your feedback!