We provide IT Staff Augmentation Services!

Sql Etl Developer Resume

5.00/5 (Submit Your Rating)

AZ

SUMMARY:

  • AMicrosoft Certified Professional with around 8 years of experience in design, development & analysis of SQL Server 2012 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS.
  • Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server .
  • Experience in Designing and Implementation of Relational Database Model for business requirements using Normalization forms.
  • Good at creating Tables and Views as per teh business and design requirements using T-SQL.
  • Extensive experience in developing Stored Procedures, Functions (Arithmetic, String and Date Time) using T-SQL.
  • Implemented Triggers at different levels of Database Objects to apply Security Constraints.
  • Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings.
  • Experience in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS).
  • Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column for unstructured and redundant data.
  • Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
  • Generated VB and C# scripts used for Script task. Script task is primarily to control teh flow of SSIS package.
  • Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
  • Experience in HIPAA EDI transactions 837 (Institutional/Professional).
  • Working knowledge of ANSI X12 EDI transactions.
  • Experience in generating Ad-Hoc, Drill down, Drill Through reports using Local and Global Variables, Expressions and Filters in SSRS.
  • Expert in creating Parameterized Reports, Matrix Reports, and Custom generated reports, Charts, Sub Reports as per Business User requirements.
  • Experience with EDI files for 277 Claim status and inquiry for business rule validation.
  • Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated teh metrics dat were revealed in teh functional analysis.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS Packages.
  • Performed code review with other developers and suggested for improvements and alternate strategies.
  • Verified data integrity and accuracy by analyzing, monitoring and process documenting.
  • A multi-tasking analytical thinker with teh ability to work on fast paced work Environment.
  • Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies dat improve teh business.

PROFESSIONAL EXPERIENCE:

Confidential, AZ

SQL ETL Developer

Responsibilities:

  • Interacted with users, team lead, DBAs and teh technical manager to fully understand teh requirements of teh system.
  • Gatheird business requirements and creating mapping documents.
  • Created integrated data marts through sourcing and managing data from multiple sources including ERP, salesforce.com and other external applications.
  • Worked with teh CRM team to load data from one source to another.
  • Created mapping documents for teh ETL process.
  • Designing and developing Databases, tables, indexes, stored procedures and views using SQL Server 2012.
  • Created various stored procedures and functions to support teh data load
  • Design/Build Extract Transform Load (ETL) procedures in SQL Server Integration Services (SSIS) using packages to import/export data to/from data warehouse.
  • Various transformations like Derived Column, Conditional Spilt were used for cleansing and massaging of teh data.
  • Used Script Component transformation for specific conversion.
  • Created Incremental load packages and direct load packages according to teh business requirements.
  • Working on re-design, re-code and deploy new data extractions using SQL Server Integration Services.
  • Writing queries which involve using multiple tables using joins.
  • Testing of flat files which were used as a source for Staging Mappings
  • Code review of mappings from Source to staging and their from staging to Warehouse
  • Defect fixing on various functional levels.
  • Unit test plans were created and maintained.
  • Scheduled SSIS jobs.
  • Deployed code in QA, UAT and Production.
  • Provided support to teh organization around both new and legacy reporting requirements.

Environment: MS SQL Server Management Studio 2012, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Team Foundation Server, Salesforce.com, Netsuite.

Confidential, TX

SQL ETL Developer

Responsibilities:

  • Actively participated in interaction with users, team lead, DBAs and teh technical manager to fully understand teh requirements of teh system.
  • Gatheird business requirements and created mapping documents.
  • Wrote several SQL Scripts such as finding tables dat have Identity Columns, finding tables dat do not have a primary key.
  • Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and stored procedures
  • Optimized teh database by creating various clustered, non-clustered indexes and indexed views.
  • Creating and Modifying T-SQL Stored Procedures/Triggers for validating teh integrity.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Deployed teh created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Analysis of queries of existing Data Mart based reports.
  • Used various SSIS tasks such as Conditional Split, Derived Column which were used for Data scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, data flow task, Merge Joins, Sort transformation.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Contributed tools and methodology to teh Data Warehouse (DWH).
  • Development of source to staging and staging to EDW (Enterprise Data Warehouse) ETL mappings using SQL Server Integration Services (SSIS).
  • Created and maintained unit test plans.
  • Scheduled SSIS jobs.
  • Deployed code in QA, UAT and Production.
  • Worked with OLAP and Reporting Services.
  • Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated teh metrics dat were revealed in teh functional analysis
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Created Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
  • Problem identification, troubleshooting, resolution, and index tuning databases.
  • Diagnosing and tuning teh server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
  • Performed DBCC checks and fixing data corruption in Application databases.
  • Scheduled Backups and performed Restore operations for system test data.
  • Created and maintained technical documents.

Environment: MS SQL Server Management Studio 2012, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Team Foundation Server

Confidential, OR

SQL Server BI Developer

Responsibilities:

  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Worked with Client/Business Analysts to define data requirements for reporting warehouse.
  • Designing and building load procedures, using SQL Server.
  • Design/Build Extract Transform Load (ETL) procedures in SQL Server Integration Services (SSIS) using packages to import/export data to/from data warehouse.
  • Involved in re-design, re-code and deploy new data extractions using SQL Server Integration Services and designed and produced documentation of data transformations for all extractions.
  • Designing and developing Databases, tables, indexes, stored procedures, views, triggers and user- defined functions using SQL Server 2008.
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
  • Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • VB.Net and other .NET languages C# used for Script task. Script task is primarily to control teh flow of SSIS packages.
  • Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Involved in design, programming, deploy and unit testing of requested reports.
  • Used SQL Profiler and Query Analyzer to optimize SSIS packages and stored procedures.
  • Created SSIS packages for migrating data from various sources like SQL, Oracle, Excel and flat files.
  • Scheduled SSIS package jobs using SQL Agent.
  • Involved in sending mail alerts for teh scheduled jobs.
  • Optimized teh slow execution of queries and stored procedures.
  • Helped in design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Maintained database documentation, incusing data standards, procedures, definitions fir teh data dictionary and logical and physical models of teh databases.

Environment: MS SQL Server Management Studio 2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Team Foundation Server, Visual Studio 2010.

Confidential, PA

SQL Server Report Developer

Responsibilities:

  • Created tables, views, stored procedure as per design needs.
  • Maintained data integrity by performing validation checks.
  • Optimized queries tuned and monitored server performance.
  • Involved in Fine-tuning of database objects and server to ensure efficient data retrieval.
  • Monitored performance and optimize SQL queries for maximum efficiency.
  • Developed, monitored and deployed SSIS packages.
  • Performing query plans and making sure each and every query is using appropriate useful Indexes.
  • Creating and Modifying T-SQL Stored Procedures/Triggers for validating teh integrity.
  • Deployed teh created SSIS packages in Development and Testing environments.
  • Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc.
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
  • Experience in working with Team Foundation Server (TFS).
  • Responsible for creating teh reports basing on teh requirements using SSRS 2008.
  • Identified teh database tables for defining teh queries for teh reports.
  • Gatheird business requirements, definition and design of teh data sourcing and data flows, data quality analysis, and working in conjunction with teh data warehouse architect on teh development of logical data models.
  • Defined teh report layout in SSRS.
  • Identified and defined teh Datasets for teh report generation.
  • Wrote teh queries for teh drill down reports, parameterized reports.
  • Identified and added teh report parameters.
  • Formatted teh reports using teh Global variables and expressions.
  • Deployed teh generated reports on to teh server.
  • Actively supported business users for change requests.
  • Performed code review with other developers and suggested for improvements and alternate strategies.
  • Administered and enhanced SQL Server Integration Services (SSIS) data loads.
  • Involved in creating cubes for teh Enterprise Data Warehouse (EDW).

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential, KY

SQL Server BI Developer

Responsibilities:

  • Created tables, views, stored procedure as per design needs.
  • Maintained data integrity by performing validation checks.
  • Optimized queries tuned and monitored server performance.
  • Monitored performance and optimize SQL queries for maximum efficiency.
  • Imported data from various sources into a staging area, merges teh data into teh OLTP data model, and presents it to all levels of teh over-600 users.
  • Developed, monitored and deployed SSIS packages.
  • Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
  • Involved in backend testing using SQL queries and verified teh EDI data transactions in teh database.
  • Responsible for creating teh reports basing on teh requirements using SSRS 2008.
  • Identified teh database tables for defining teh queries for teh reports.
  • Gatheird business requirements, definition and design of teh data sourcing and data flows, data quality analysis, working in conjunction with teh data warehouse architect on teh development of logical data models.
  • Defined teh report layout.
  • Identified and defined teh Datasets for teh report generation.
  • Wrote teh queries for teh drill down reports.
  • Created test data (EDI Files) for 837 with ICD 10 codes for business rule validation.
  • Identified and added teh report parameters.
  • Formatted teh reports using teh Global variables and expressions.
  • Deployed teh generated reports on to teh server.
  • Assisted in migrating denormalized report DB into a Star Schema design.
  • Created test data for EDI files for 277 Claim status and inquiry for business rule validation.
  • Actively supported business users for change requests.
  • Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential

SQL Server Developer

Responsibilities:

  • Active participation in teh business requirement meetings with teh client
  • Maintained client relationship by communicating teh daily status and weekly status of teh project.
  • Designed and implemented teh Logical and Physical model of teh database.
  • Developed complex T-SQL code for teh application.
  • Written Complex and Extended T-SQL Stored Procedures for application developers and some User Defined Functions.
  • Tested to optimize teh Stored Procedures and Triggers to be used in production.
  • Planned, defined and designed data flow processes for data migration to teh Data Warehouse using DTS.
  • Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
  • Installed and maintained MS SQL Server 2005.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
  • Managed and monitored teh use of disk space.
  • Planned Backup strategy based on projects requirements.
  • Maintained teh consistency of teh client’s Database using DBCC.

Environment: MS SQL Server Management Studio 2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, Microsoft Visual source Safe.

We'd love your feedback!