Etl Bi Developer (ssis/ Ssms) Resume
Rolling Meadows, IL
PROFESSIONAL SUMMARY:
- 8+ years of overall experience in the field of SQL server Database (MS SQL) and Business Intelligence applications as an ETL Developer with expertise in SQL Server Integration (SSIS), Analysis Services(SSAS) and Reporting Services(SSRS).
- Experience in Creating Database objects - tables, views, functions and developing procedures for implementing application functionality at the database side.
- Efficient in creating joins and sub-queries for complex queries involving multiple tables.
- Create reusable DDL, DML SQL queries that can be used for different input data to validate against the User Interface.
- Proficient in writing queries and stored procedures in SQL Server.
- Knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys
- Hands on experience in administration tasks such as disaster recovery with Backup and Restore Strategies, Data Loading, Batch Jobs, Data Unloading, Upgrades, Creating Databases, Files, File groups, Transaction logs, Clustering, Replication, Data Mirroring, Linked Servers, SQL Profiler, Log Shipping and Re-Indexing.
- Experience in using profilers, Index Tuning Wizard and performance tuning to monitor SQL Server.
- Knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
- Practical experience of operating Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.
- Experience in Software Development Life Cycle (SDLC) methodologies.
- Used SQL Server , MS SQL data source connections to integrate with Microsoft visual studios to create daily refreshed, fully-automated, end-to-end dashboards to optimize user experience.
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Charts and Sub Reports.
- Good knowledge in transformation of data between databases using Bulk Insert Tasks, Data Pump Tasks and experience in design, data conversion, data mapping and data load.
- Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
- Extensive experience in Database Design, Data Modeling, T-SQL Development, Developing and Implementing ETL Packages using SSIS and Complex Reports using SSRS.
- Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
- Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative with a desire to learn client's business requirements.
- Flexible and versatile to adapt to any new environment and work on any project.
- Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions and training end users.
TECHNICAL SKILLS:
Databases: SQL Server 2016/2014/2012/2008 R2, 2005 & 2000/7.0, MS-Access 2000, Oracle 11g/10/9i,DB2
Database Tools: SSMS, BIDS/Visual Studio, WebFocus, 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
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)
Relational DBMS, Client: Server Architecture, OLAP, OLTP
Methodologies: Agile, Waterfall, Scrum, SDLC
PROFESSIONAL EXPERIENCE:
Confidential, Rolling Meadows, IL
ETL BI Developer (SSIS/ SSMS)
Responsibilities:
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Developed C# Shell scripts to automate the processes. Developed Shared Containers and re-used in multiple jobs.
- Extracting the data from different sources ( CSV files, Excel files, MS SQL, XML , pipe de-limited text files ) and stored the data into the intermediate Staging database using the SSIS ETL tool.
- Followed standard Template’s for Source file to Target Table, Source Table to Target File and Source Table to Target table.
- Explicitly used Pivot Transformation , Fuzzy lookup , Derived Columns , Term extraction , Condition split , aggregate , lookup , Execute SQL Task , Merge join etc. for creating SSIS packages.
- Involved in performance tuning by creating the indexes in the database level & modified ETL jobs to run in parallel wherever required.
- Developed SCD's by using transformer stage, change capture stage, remove duplicate stage to populate the data into Data warehouse.
- Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
- Implementing various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
- Performed Source and Target System Analysis to Analyze the Source and Target data elements to develop the Jobs.
- Worked on Azure cloud database and SQL server databases for the migration of data from one database to other using SSIS.
- Create sample test data in Azure database to unit test the package developed and copy data to various file formats and drop it in Development server and vice-versa.
- Established Ado.Net connections for Azure database to enhance the performance of data transfer.
- Implemented Simple Mail Transfer protocol (SMTP) connection task if there is any failure in execution of packages and jobs.
- Optimized the existing applications at the mapping level, database (source and target) level for a better performance.
- Extensively used the Share point site and documented the specifications on regular basis for every change required and implemented.
- Created detailed solution design and requirements documentation with logic to help better understanding of the system.
- Deploy multiple packages using single C# deployment script using Power shell.
- Ability to clearly communicate technical information to Technical, non-technical colleagues and clients.
- Highly analytical and solid programming skills besides competent in handling critical situations.
- Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.
Environment: Visual Studio 2015, SQL Server 2016, Microsoft Visio, SSMS 2017, Team Foundation Server
Confidential, San Antonio, TX
BI/(SSIS/ETL/Power BI) Developer
Responsibilities:
- Involved in Designing, Developing and Testing of the ETL Strategy to populate the data from various source systems feeds using SSIS .
- Designed and architected OLAP cubes to support business analyst reporting and forecasting processes.
- Used Text Files/ SQL Server Logging for all SSIS packages.
- Created reports using Crystal Reports for generating analysis reports based on the key variable stored in database.
- Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
- Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
- Developed backend process using UNIX shell scripts for data migration and batch processing.
- Scheduled complex crone jobs on UNIX using crontab format.
- Participated in designing and development of software using agile development practices.
- Extracted Data from various Heterogeneous Databases such as Oracle and Access, DB2, flat files to SQL server using SSIS .
- Optimizing existing queries and fixing query performance issues.
- Generated Script files of the databases whenever changes are made to stored procedures or views.
- Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
- Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
- Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension tables, Physical and logical data Modeling.
- Designed and implemented parameterized and cascading parameterized reports using SSRS .
- Generated periodic reports based on the statistical analysis of the data from various time frame utilizing SSRS .
- Design, deployment, and maintenance of various SSRS Reports like Parameterized and cascading parameterized reports
- Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services . - Add only in SSAS requirement and experience in working creating Multidimensional cubes and Tabular Models using SSAS .
- Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
- Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.
- Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
- Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365.
Environment : SQL Server 2014, T-SQL , SSRS (2012/ 2014), SSAS (2012/ 2014), SSIS (2012/ 2014), Visual Studio 2012, Power BI.
Confidential, Houston, TX
SQL BI/ETL/SSIS Developer
Responsibilities:
- Created complex SQL queries, stored procedures, Indexes, functions and views to support efficient data storage and manipulation.
- Designed Packages, Procedures, Functions and Triggers. Handle database performance and DB tuning.
- Extracting, Transforming and Loading (ETL) process by pulling large volume of data from various data sources using SSIS .
- Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
- Diagnosing and tuning the query performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.
- Contributed in production release by preparing move up forms, preparing execution scripts, code check in and check out using Team Foundation Server, code deployments and Production environments.
- Data migration from SQL server to Oracle using SSIS packages.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Improved scheduled daily job performance by optimizing SQL queries. Replaced cursor and loops with joins to improve data processing time.
- Responsible to troubleshoot production issues, suggested quick work around and fixed the critical production issues.
- High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
- Designed, developed and deployed Tabular and Matrix type list, linked and Sub-Reports with Charts and Document maps using SSRS .
- Contributed from design to implementation and maintenance phase of the application in AGILE environment/methodology.
- Developed, implemented, and executed a quality assurance program and quality control standards for all ETL ( SSIS ) activities. Performed regular data consistency, quality and reliability checks.
- Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
- Excellent analytical, interpersonal and communication skills & desire to excel, fast learner, hardworking and versatile team player.
Environment: MS SQL Server 2012, Visual Studio2012, SQL Server Analysis Services ( SSAS ), SQL Server Integration Services ( SSIS ), SQL Server Reporting Services ( SSRS ), Windows Server 2008, MS - Visio
Confidential, Illinois, Chicago
SQL Server Developer/SSIS/ETL Developer
Responsibilities:
- Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
- Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
- Responsible for writing T-SQL code for creating cursor and handling the data validations.
- Developed complex T-SQL code for the application.
- Rebuilding the indexes at regular intervals for better performance.
- Developed Triggers to raise events on executing insert, delete and update stored procedures.
- Materialized views, dimensions and stored outlines for optimal performance.
- Actively involved in Normalization & De-normalization of database.
- Worked on other packages of the SQL server 2012 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
- Developed SSIS Packages for Snapshot, Incremental, Historical Changes (SCD Type 2) Data Loads.
- Experience in query optimization & performance tuning using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
- Designed and developed Star and Snow Flake Schema. Reviewed Cube with End user and changing the cube according to their requirements.
- Involved in extracting the data using SSIS from OLTP to OLAP. Provided back-end support for performance testing and functional testing using use case testing methodologies.
Environment: SQL Server 2008/2012, SSIS (2008/2012), SSRS (2012), XML, VB.Net, Oracle 10/11 PL/SQL, Visual Studio 2008, QlikView 11.
Confidential, Overland Park, KS
SQL Developer/SSIS/SSRS/ETL
Responsibilities:
- Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS.
- Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.
- Created Views to replace old tables and created new tables with triggers to support new business needs.
- Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
- Created users and roles for login authentication and validating permissions.
- Designed and Created databases, tables, views, stored procedures and triggers.
- Created groups, roles, users and assigning access privileges to users.
- Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
- Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
- Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
- Tuning front-end applications like Visual Basic, which query the SQL Server databases.
- Involved in Debugging Issues as a part of Production Support.
Environment: SQL Server 2008, T-SQL, UNIX, .NET, VB Script, ASP, Microsoft Excel, FrontPage 2000.
Confidential, Fort Worth, TX
SQL/ BI Developer/SSRS/SSIS
Responsibilities:
- Rebuilt the indexes at regular intervals for better performance.
- Moved files between the File Groups and partitioned the tables to improve the performance.
- Monitoring SQL server performance using Profiler.
- Extracted the meter data from different format files XML, Flat and CSV, and loaded data into SQL DB and created the stored procedures for faster execution of the queries and which helped in SSRS to create parameterized reports.
- Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source (Oracle), Excel Spread sheet and loaded the data into target data destination by using various transformations in SQL Server Integration Services (SSIS).
- Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service .
- Created multiple reports ( SSRS ) in Drill mode using tables , financial income tables , crosses tabs and charts.
- Configured and monitored database application.
- Involved in creating tables, indexes, views and constrains.
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures & Triggers.
- Extracted, Transformed, and Loaded (ETL) sales data from Excel, Oracle to MS SQL Server by using SSIS services and integrated data for high quality analysis.
- Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008 R2 Analysis Services ( SSAS ) and Reporting service ( SSRS ).
Environment : MS SQL SERVER 2008 R2, SSRS AND WINDOWS SERVER 2008 R
Confidential
SQL/ SSAS/ SSIS Developer
Responsibilities:
- Created ETL to load transactional data to Data Warehouse and built Analysis Services Database to provide summarized data to Client’s dashboard.
- Imported data into Performance point server from SQL database through csv files.
- Partitioned and designed various storage modes to increase the performance of cubes using SSAS.
- Created dimensions in the performance point server.
- Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
- Created UTP document, performed unit test processing and MDX queries to retrieve data from cubes using SSIS.
- Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
- Scheduled SSIS packages for running monthly and weekly feeds from various departments and multiple servers and resources to Development Servers.
- Monitored SQL Error Logs/Schedule Tasks/database activity/ eliminate Blocking & deadlocks/user counts and connections/locks etc.
Environment: SQL Server 2008,T-SQL, DB Artisan, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, Oracle 9i
Confidential
SSIS / SQL Server Developer
Responsibilities:
- Installation and configuration of SQL Server.
- Created Database objects -Tables, Views, Functions, Triggers and developed procedures for implementing application functionality at the database side for performance improvement.
- Index creation for database performance improvement.
- Involved in database Backup and Restore.
- Created DTS package to get data from different sources, consolidate and merge into one single source.
- Created and executed SSIS packages to populate data from the various data sources. Created SSIS packages using SSIS designer for export heterogeneous data from OLEDB Source to SQL Server.
- Experience in creating multiple reports ( SSRS ) in Drill mode using tables, crosstabs, and charts. Design, deployment and maintenance of various SSRS in SQL Server. Designed and implemented parameterized and cascading parameterized reports using SSRS .
- Created complex variables, multiple breaks and sorts in the reports.
Environment: SQL Server 2008, Access 2000, MS Project