We provide IT Staff Augmentation Services!

Msbi/etl Developer Resume

Nashville, TN

SUMMARY:

  • Around 8+ years of industry experience in data warehousing as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server, SSIS/SSRS/SSAS for both OLTP and OLAP.
  • Experience in Developing SSIS packages for Data Migration between different heterogeneous sources using different versions of SQL Server SSIS.
  • Experience in generating reports for OLTP and OLAP databases.
  • Proficient in a wide range of Microsoft Business Intelligence (BI)
  • Experience across entire Microsoft BI suit of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.
  • Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.
  • Experienced in developing, implementation, documenting, monitoring and maintain the data warehouse extracts, transformations and ETL process in various Fields of data.
  • Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.
  • Expert in Data modeling experience by using Star Schema modeling, Data and Gap Analysis
  • Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
  • Expert in transforming complex business logic into Database design and implemented by creating Stored Procedures, Views, and T-SQL Scripting.
  • Experienced with all phases of software development life cycle (SDLC) and Agile methodologies.
  • Worked on small and large-scale projects. Believe in teamwork. Have delivered as a team member and as an independent consultant.
  • Developed complex calculated measures using Data Analysis Expression language (DAX) to satisfy business needs.
  • Developed complex SQL queries, common table expressions (CTEs), Temporary table to support Power BI.
  • Created Workspace and content packs for business users to view the developed reports.
  • Worked on all types of transformations that are available in Power bi query editor.
  • Strong Experience in creating and deploying parameterized reports using power BI.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica

Reporting Tools: Power BI, SQL Server Reporting Services (2012/2008R 2/2008/2005/2000/7.0 ), MS Access, MS Excel

Database: MS SQL Server 2016/2014/2012/2008/2005/2000, MS Access, Oracle 11g/10g/9i

Languages: T-SQL, PL-SQL

Operating Systems: Windows (95/98/2000/2003 ), Windows 2007 Server, Windows XP, Windows Vista, 8.1, 10, Mac 10.X

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Project), Data Modeling, OLAP & OLTP, ERWIN, power BI

PROJECT EXPERIENCE:

Confidential, Nashville, TN

MSBI/ETL developer

Roles & Responsibilities:

  • Collaborating with business partners to understand their business needs, designing and implementing potential technical solutions using BI Tools.
  • Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
  • Served as a good Team Player for the Business Intelligence team.
  • Quickly jumped on to the requirements and delivered work times within the stipulated time
  • Plans, leads, designs, coordinates, analyzes and directs BI project(s).
  • Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2014 environment.
  • Responsible for modeling and implementing a Data Mart to server the data needs of biologists.
  • Responsible for writing queries in T-SQL, implementing views and stored procedures to support the various BI report requirements.
  • Responsible for implementing Cubes (tabular) using SSAS, implementing Power BI reports with cubes as data source for live connection.
  • Troubleshoot several stored procedures and Queries and fine-tune them to improve the performance.
  • Established Joins and created Clustered/Non-clustered Indexes wherever necessary and implemented triggers and views for simplifying major tasks.
  • Created Power BI dashboards data source as API’s and RSS feed.
  • Developed SQL quires using stored procedures, common table expression (CTE’s), temporary table to support Power BI and SSRS reports.
  • Developed complex calculated measures using Data Analysis Expression language (DAX).
  • Deployed and maintained reports on power bi report server and managed access of reports and data for individual users using Roles.
  • Created Workspace and content packs for business users to view the developed reports on Power BI service.

Environment: Power BI (On-Premises, cloud), Microsoft SQL Server, SSIS, T-SQL, Visual Studio, Windows 2007/2010, EXCEL, TFS.

Confidential, Nashville, TN

MSBI/ETL Developer

Responsibilities:

  • Developed T-SQL queries, scripts and stored procedures used for extracting, validating, transforming and loading data provided by clients.
  • Respond to ad-hoc requests from Business Analyst and Project Managers by providing accurate data/reports in a timely manner.
  • Designed ETL packages to load the data from staging server to Data marts on Data warehouse.
  • Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
  • Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Loaded the data into destination tables: both full and incremental load, by performing different kinds of transformations like row count, Look-up, derived column, merge, script task using SSIS packages and performed with truncating, modifying and creating tables in data base as per requirements.
  • Worked extensively creating and maintaining DAX calculations, DAX queries and MDX queries.
  • Provided Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
  • Created and deployed parameterized reports using Power BI.
  • Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts deployed.
  • Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
  • Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP.
  • Deployed SSIS packages with minimal changes using XML configuration file.
  • Created SSRS reports using complex SQL Queries/Stored Process which have sub-reports, Drill-Down reports and charts.
  • Created data sources, connection strings and defined the datasets for generating the report.
  • Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules as per the Client requirements.
  • Created the test data to test the performance and functionality of the SSRS Reports.
  • Created subscriptions to provide a daily basis reports.
  • Managed and troubleshoot report server related issues.
  • Created database objects like Procedures, Functions, Triggers, Indexes, DML and DDL changes.
  • Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
  • Created copy-only backups from production environment and Applied to Test/Dev. environments to test functionality on the latest data.

Environment: Microsoft SQL Server 2016/2014 R2, SSIS, SSRS, T-SQL, Visual Studio, Windows 2008, MS ACCESS, EXCEL, TFS, power BI.

Confidential, Atlanta, GA

MSBI/ETL Developer

Responsibilities:

  • Creation, Development and Maintenance of SSIS Packages and SSRS Reports.
  • Responsible for designing and managing project specific ETL codes using SSIS and SQL Server 2012/2014 fetching data across various source systems into Client specific Enterprise Data Warehouse.
  • Developed BI applications reporting tool SQL Server reporting services (SSRS) and SQL Server integration services (SSIS).
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle DB etc.)
  • Loaded the data into destination tables: both full and incremental load, by performing different kinds of transformations like row count, Look-up, derived column, merge, script task using SSIS packages and performed with truncating, modifying and creating tables in data base as per requirements.
  • Created and deploying parameterized reports using power BI.
  • Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts deployed.
  • Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
  • Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
  • Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP and Used SQL Profiler to optimize Stored Procedures.
  • Loaded fact and dimension tables as part of modified data warehouse solution.
  • Deployed SSIS packages with minimal changes using XML configuration file.
  • Worked extensively with SSIS to import, export and transform the data from xml and text files.
  • Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into normalized data structure.
  • Created new SSIS Package to extract date from legacy to SQL SERVER objects using BIDS and Visual studio 2012.
  • Written with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012/2014.
  • Used DDL and DML for writing triggers, stored procedures to check the Pre-ETL conditions and reconciliation of data.
  • Process SSAS cubes to store data to OLAP databases
  • Created SSRS Reports: involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, involved in Dashboard reporting, Share Point with Power View tool, TFS etc.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012.
  • Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Microsoft SQL Server 2014/2012, Oracle, SSMS, SSIS, SSRS, SSAS, Visual Studio, SQL SERVER AGENT, T-SQL, MS-OFFICE, Power BI.

Confidential, Lakeland, FL

MSBI/ETL Developer

Responsibilities:

  • Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, dashboards, and scorecards.
  • Involved in the dimensional modeling.
  • Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
  • Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
  • Improved the performance of the slow running queries.
  • Wrote store procedures to generate account statements for different types of accounts.
  • Created appropriate Triggers to assist efficient data manipulation and data consistency
  • Migrated DTS Packages of SQL Server 2008 to SQL Server 2012 as per business requirement
  • Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
  • Generated several drill down and drill through reports using SSRS.
  • Involved in designing, developing, debugging and testing of reports in SQL Server 2012.
  • Built ad-hoc reports using SQL Server Reporting Services (SSRS).
  • Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services ( SSIS )
  • Extensively used transformations, control flow tasks, containers and event handlers.
  • Used checkpoints to implement the restart ability of the packages in SSIS
  • Implemented custom logging in SSIS using event handlers and execute SQL task.
  • Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
  • Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio( MSVS )
  • Created dynamic Package Configuration of type SQL Server table.
  • Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like MS access and Microsoft Visio
  • Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
  • Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan

Environment: ETL TOOL (SQL Server 2012 Integration Services), SQL Server2012 Reporting Services and SQL Server 2012.

Confidential, Englewood, CO

MSBI/ETL Developer

Responsibilities:

  • Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
  • Migration of DTS packages to SSIS packages
  • Tuned Stored Procedures and Queries for optimal Database performance.
  • Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
  • Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with Star Schema.
  • Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
  • Created roles using SSAS to restrict cube properties.
  • Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
  • Developed web pages for embedding deployed SSRS reports using ASP.NET.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, Windows 2008 Advance Server, MS Excel, and MS Office.

Confidential

MSBI/ETL Developer

Responsibilities:

  • Expert in creating database objects such as tables, procedures, triggers, constraints, indexes and views.
  • Used SQL profiler to view indexes performance to mostly eliminate table scan.
  • Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval
  • Created various DTS packages for data transfer and migration.
  • Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
  • Creation/ Maintenance of Indexes for fast and efficient reporting process.
  • Created reports using stored procedure that involved in scheduling, creating snapshots and subscriptions for the reports (SSRS).
  • Designed and developed matrix and tabular reports with drill down, drill through using SSRS.
  • Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
  • Responsible for testing to optimize the procedures and triggers to be used in production.
  • Involved in project planning also schedule for database module with project managers.
  • Wrote T-SQL statements using DML and DDL for retrieval of the data.
  • Created stored procedures, triggers in SQL Server.
  • Created database objects like tables, views, indexes etc.
  • Created and modified stored-procedures, triggers, T-SQL.
  • Extract data from database and export to Excel files for Data Analyst to analyze the data.
  • Scheduled Packages using SQL Server Agent Jobs to execute at specified time on weekly and monthly basis.

Environment: MS SQL Server 2005/2000, MS power point, MS Access, MS Excel, Windows 97/2000/XP.

Hire Now