We provide IT Staff Augmentation Services!

Etl/ssis Developer Resume

Charlotte, NC

SUMMARY

Over 7 years of experience in the IT industry as BI Engineer which includes requirement gathering, analysis, and implementation of database, warehouse and Business Intelligence solutions utilizing Microsoft SQL Server.

TECHNICAL SKILLS

  • Database: MS - SQL Server 2012/2008/Azure SQL, MS Access
  • T-SQL Programming, Dynamic SQL
  • Data Modeling: Erwin, MS Visio
  • Integration Services (SSIS)
  • Analysis Services (SSAS, OLAP Cubes)
  • Reporting Services (SSRS, Report Builder)
  • Business Intelligence: Tableau
  • SDLC: Agile, Scrum, Waterfall, and Spiral
  • Programming Language: Java, C#
  • Development Tools: BIDS, SSDT, SSMS
  • Source Control: Team Foundation Server (TFS)
  • SharePoint 2013/2010

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL/SSIS Developer

Technical Environment: MS SQL Server 2014, SSDT, T-SQL, SSIS, C#, TFS, Redgate

Responsibilities:

  • Worked in multiple web application projects, maintained the back-end server systems and conducted performance tuning.
  • Modified business logic of the web applications using C#.
  • Created database objects such as tables, stored procedures, and user-defined functions on SQL Server Management Studio.
  • Maintained back-end database which participated in web application system.
  • Performed performance tuning session for database table and column data type, altered column to proper data types and constraints for tables to ensure the database integrity and consistency.
  • Modified structure of the user defined stored procedure by applying multiple variables and dynamic SQL.
  • Created set operation to replace cursors, and used DBCC command and Dynamic Management View to analyze index fragmentation.
  • Re-organized and re-built indexes to improve index usage.
  • Built Execute SQL Tasks on SQL Server Integration Services (SSIS) Event Handler to log runtime information and error messages to the audit table.
  • Researched the constraints and relations between database tables in the back-end server.
  • Re-built data modeling and updated ETL packages and data loading stored procedures.
  • Checked column dependencies and created stored procedure to conduct data cleansing for front-end inputs.
  • Implemented slowly changing transformations with SSIS to maintain historical data in the data mart.
  • Implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.
  • Automated the ETL process with SSIS package execution schedules utilizing jobs.
  • Migrated SSIS packages from development to production environments with package configurations.
  • Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transforming and finally loading into the staging database.
  • Deployed and configured SSIS packages to the production server with parameters in the SSISDB catalog.

Confidential, Seattle, WA

SQL BI Developer

Technical Environment: MS SQL Server 2012/2016, SSDT, T-SQL, SSIS, SSRS, Tableau, ER-Win, SQL Profiler, TFS

Responsibilities:

  • Interacted with business users and stakeholders to draft/outline the business requirements.
  • Attended JRD/JAD and collaborated scrum meetings for the implementation of different projects for functional support.
  • Created SSIS packages for data scrubbing, aggregating, and cleansing with multiple tasks/transformations.
  • Designed and developed SSIS packages to extract data from multiple data sources; loaded data into destination tables.
  • Improved the performance of SSIS packages with non-blocking transformations and multiple properties.
  • Managed the execution and security of SSIS packages on the Integration Services Server.
  • Developed reports in SSRS such as drill down, parameterized and cascading parameterized as demanded by business users.
  • Performed detailed analysis of slow running reports to identify the bottleneck and proposed appropriate solution.
  • Scheduled caching, snapshots and subscriptions utilizing shared schedules in SSRS.
  • Designed and developed multitude reports in Tableau Desktop such as bar charts, stacked bars, symbol maps, heat maps, text tables per business requirements.
  • Created bins, groups, sorts, and sets to create focused and effective visualizations utilizing Tableau.
  • Created calculated fields, mapping and hierarchies using Tableau.
  • Utilized data blending and cross database joins on Tableau Desktop to fetch data from multiple data sources to create side-by-side comparison reports.
  • Connected to data sources utilizing live and extract mode depending upon the type of source and data that best suites the business needs.
  • Utilized TFS (Team Foundation Server) to maintain multiple versions of documents, scripts and reports on the server.

Confidential, CA

SQL BI Developer

Technical Environment: SQL Server 2016/2012, SSIS, SSMS, SSDT, T-SQL, Erwin, TFS, Tableau, SQL Profiler, Azure

Responsibilities:

  • Collaborated in JRD session with project manager and business analyst to analyze the project-goals and prepare BRD documents.
  • Created stored procedures, triggers, user-defined functions, and views for newly added data records.
  • Utilized temporary tables, table variables, and CTEs in writing complex queries and storing data.
  • Utilized explicit transactions to maintain ACID properties for queries and procedures.
  • Implementing join, set operator, and apply operator to combine data from multiple data sets.
  • Implemented temp table, table variable, dynamic SQL script for complex business logic under TSQL environment.
  • Involved in implementing error handling in SQL scripts utilizing try catch and transactions.
  • Created used defined stored procedure and functions based on business demand for operation and calculation.
  • Analyzed dimensional model architecture identifying required modification on dimension and fact tables to improve report rendering performance.
  • Developed packages in SSIS to aggregate and prepare data for report purpose and resolved issues during runtime.
  • Created SSIS packages with SSIS and custom loggings to log runtime events and help in debugging.
  • Validated data loads to destination with SQL scripts and SSIS packages
  • Configured SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, and measures groups.
  • Developed various style SSRS report with drill down, drill through, and parameter to enhance user experience.
  • Deployed SSRS report and dashboard into SSRS report manager for report sharing with both data driven and standard subscription.
  • Delivered SSRS reports to multiple file formats such as PDF, word, and Excel format based on business demand.
  • Created report snapshots and caches to improve performance of SSRS reports
  • Configured resources on Microsoft Azure platform to developing IaaS, PaaS cloud platform for data processing.
  • Migrated databases from local database engine onto Microsoft Azure SQL database for proof of concept.
  • Implemented Team Foundation Server TFS as Version Management for Microsoft Technologies.

Confidential, Charlotte, NC

Business Intelligence Engineer

Technical Environment: Microsoft SQL Server 2012, Teradata SQL Assistance, Toad for Data Analyst, SQL Profiler, SSIS, Tableau, SAS, SharePoint, Microsoft visual Studio 2010

Responsibilities:

  • Communicated with Business partners of the Enterprise Independent Testing team and the Compliance tests stakeholders to confirm the Business Requirements.
  • Documented business requirements from JRD sessions with users and subject matter experts
  • Reviewed business requirements with development teams (front end and database) to define functional requirements
  • Created and provide Data population based on the Data collection plan and to Test Owners.
  • Developed standardization process of data in destination based on source data analysis
  • Analyzed requested changes in the data models and reviewed with dev team for practicality of it
  • Loaded data to Excel files utilizing SSIS packages to analyze trends in data using Excel functions
  • Created stored procedures and SQL scripts with system functions and views to analyze meta data of database
  • Created and edit the Script Task in the SSIS package using variables to improve automation task schedule.
  • Wrote MDX expressions for cube calculations and KPIs, and then created OLAP Cubes, dimension for analysis to meet the business requirements using SSAS.
  • Interacted with Tech leads, BAs, QAs and other developers discussing product execution performance through JAD meetings and Daily Scrum meetings and provide improvement plan to Compliance managers.
  • Tested SSIS packages and fix SQL code issues from test execution using SQL Server Data Tools.
  • Developed Tableau dashboards with multiple visualizations such as slicers, bar charts, tables, matrices, tiles, maps.
  • Implemented action filters, parameters and calculated sets for preparing Tableau dashboards and worksheets.
  • Utilized excel sheet, flat files, SQL Server, Oracle, and Tableau extract source for designing reports in Tableau desktop.
  • Created drill down, drill through, cascaded, sub, and parameterized reports in SSRS.
  • Involved in creating complex formulas and calculations within SSRS to meet the needs of complex business logic.
  • Provided 24/7 technical support for Tableau production issue and performance concern.

Confidential, CA

SSIS/Report Analyst

Technical Environment: MS SQL Server 2008/R2, TSQL, TFS, SSIS, SSAS, SSRS, Tableau, SharePoint 2010, Erwin, DTA, SQL Profiler

Responsibilities:

  • Gathered business requirements as endeavor that planning and the implementation phase of a 3E (Law Suit product).
  • Designed functional and technical documents, report templates and reporting standards for the report developers.
  • Reviewed reports and recognized gaps in data; identified source for missing data.
  • Interacted with Tech leads, BAs, QAs and other developers discussing accounts/policies mapping methods through JAD meetings and Daily Scrum meetings.
  • Conducted JRD sessions with different Auditors, Business Users to capture and document the BRD.
  • Analyzed tables, views, stored procedures and indexes in support of various databases and ETL applications.
  • Implemented error handling technics such as try-catch, raise error, @@error techniques.
  • Embedded DML triggers on tables for implementing business-specific rules and advanced constraints.
  • Scripted multiple database maintenance tasks in SQL Server for reducing manual processes and related overheads.
  • Created column store indexes on various tables in the OLTP database to enhance SQL query read operation.
  • Enforced referential, user defined and entity integrity by creating Triggers, Foreign Keys and Unique keys on tables.
  • Profiled source data (SQL database tables and flat files) with different methods in SSIS package
  • Developed source to target data mappings for the multiple ETL solutions including data type and transformation logics.
  • Designed multi-package SSIS solution to load historical data into enterprise OLAP database.
  • Profiled source data (SQL database tables and flat files) with different methods for SSRS report.
  • Analyzed and implemented strategies for improving the performance of existing reports and further leveraging old SSRS reports in recent reports as click through or sub reports.
  • Generated Tableau Dashboard in Tableau Desktop with actions and parameters to enhance user experience.
  • Created Tableau Dashboard with Action and parameter for user interaction.
  • Developed Tableau Data extract with multiple complex tableau calculation and LOD Expression.

Confidential, Fort Lee, NJ

Database Developer

Technical Environment: MS SQL Server 2008, BIDS, SSIS, SSAS, SSRS, Tableau, TSQL, Erwin, TFS

Responsibilities:

  • Actively involved in gathering system specification requirements for the project through JRD sessions from business users and Subject Matter Experts(SMEs)
  • Involved in creation of functional requirement specifications (FRD) and supporting documents for business systems, experience in database design process and data modeling process.
  • Created workflows, process diagram and gap analysis to derive requirements for existing systems enhancements.
  • Created an estimate of the analysis project time based on specified business requirements as been followed up.
  • Coordinated with Business analyst for data cleaning and variables selection to ensure records in database meaningful and analyzable.
  • Developed Dynamic SQL script with join and filtering logic pulling data from data mart for analysis purpose based on business requirement.
  • Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Analyzed and modified database objects such as stored procedures, user defined functions, triggers and indexes utilizing T-SQL.
  • Analyzed Triggers to update master tables to authenticate the transactions depending on business logics.
  • Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
  • Optimized procedures and functions utilized by ETL Packages to reduce ETL Process time.
  • Implemented Master/Child Packages so that Master Package should be scheduled which will in turn initiate the execution of other packages.
  • Designed ad-hoc SSRS reports in the test environment for data validation utilizing SSRS.
  • Implemented formatting for reports by applying parameters, and assigned parameter defaults and data types in SSRS.
  • Created filled map for user interactive report in Tableau desktop.
  • Configured Tooltip in Tableau report to make report clearer by including calculation formula.
  • Created reports on data validation and sent them to the concerned users.

Confidential

SQL Server Developer

Technical Environment: MS SQL Server 2008, TSQL, BIDS, Erwin, SSRS, SSIS

Responsibilities:

  • Actively involved in gathering system specification requirements for the project.
  • Implemented temp objects such as CTEs and Table variables wherever necessary to improve the performance and for simpler code design.
  • Assisted DBA in writing T-SQL scripts to ensure the Database Integrity and fine tune the Databases and Consistency.
  • Created new database objects such as Procedures, Functions, Indexes and Views using T-SQL.
  • Implemented System String Functions such as CHARINDEX, PATINDEX for retrieving the part of the string from a table filed.
  • Implemented Dynamic SQL for user customizable queries to be answered by the SQL Server.
  • Implemented SSIS Packages to perform ETL Operations from multiple data sources including excel and text files.
  • Analyzed/ debugged the issues on production environment for SSIS packages and provide solutions by adding new tasks and/or transformations.
  • Incorporated Error Redirection during ETL Load in SSIS Packages.
  • Optimized reports by optimizing the embedded T SQL queries or using optimized stored procedures in Data Sets.

Data Analyst

Technical Environment: MS SQL Server 2008, SSIS, SQL Profiler, TSQL, BIDS, Erwin

Responsibilities:

  • Updated the documents with all the changes that take place throughout the development phase of the database and maintained a version of old documents.
  • Helped Front End development team by creating views, stored procedures and UDF’s which are used in presenting the data or modifying the data on web pages.
  • Fine-tuned slowly running queries by utilizing Execution plans and SQL Profiler.
  • Wrote complex queries which uses multiple JOINs, Sub queries and Sep Operators.
  • Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from various heterogeneous sources such as SQL Server, Oracle, Excel, CSV etc.
  • Created ad-hoc reports, and complex Enterprise reports (drill down, and drill through reports, parameterized reports, and cascading report)
  • Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications.

Hire Now