We provide IT Staff Augmentation Services!

Etl/msbi Developer Resume

Chicago, IL

SUMMARY

  • A results driven software professional with 8+ years of progressively responsible experience in Database Design, Development, Data Modeling, Implementation of business applications with RDBMS, Data Warehouse/Data marts, ETL, and client/server environment in various domains, on MS SQL Server 2005/2008/2008 R2/2012/2014,2017 SSIS/SSRS/SSAS for both OLTP and OLAP Systems.
  • Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • Hands on experience in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server 2008 R 2/2012/2014/2016 ,2017.
  • Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
  • Developed Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Skillful in ETL-Extraction Transformation Loading, from heterogeneous sources (Excel, flat file, .CSV file, Oracle,) by using multiple transformations provided by SSIS. Such as Data Conversion, Conditional Split, Lookup, Derived Column, Sort, merge and union all.
  • Experience in some basic development coding with C# while working with SSIS Script Component.
  • Experience managing Big Data platform deployed in Azure Cloud
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
  • Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer
  • Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Good Knowledge in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
  • Expert in developing and modifying multi-dimensional cubes using MS SQL Server 2014/2017 Analysis Services (SSAS).
  • Experience in SQL server administrative skills including backups, disaster recovery, database maintenance, user roles, authentication and authorizations and database creation.
  • Good knowledge on Data warehousing, Operations Data Store concepts and OLAP-Online Analytical Processing technologies.
  • Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
  • Good knowledge in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting and Database Objects authorization.
  • Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
  • Exposure in using Team Foundation Server (TFS) and Git as a source control, source repository and project tracking solution.
  • Having good knowledge in R and Python.
  • Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills, good team player and ability to acquaint to fast changing skills.

TECHNICAL SKILLS

Operating Systems: Windows 2012, 2008, 2003, 2000, XP, Linux, Unix.

Databases: MS SQL Server 2016/2014/2012/2008 R2/2005, Sybase, Oracle, MYSQL, Postgres.

ETL and Reporting tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS), Tableau, Power BI.

Database Tools: SQL Server Management Studio, BIDS, SSDT(SQL Server Data tools), SQL profiler, SQL Query Analyzer, Index Analyzer, DTS

Data Modeling Tools: Erwin, Red gate, SQL Lite speed, Fog lite, Redshift, Backup Utility, Visio, Veritas NetBackup

Programming Languages: T-SQL,C#, Python

Web Technologies: HTML, CSS, XML, AJAX, DHTML

Version Control: TFS, Git, SVN

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

ETL/MSBI Developer

Responsibilities:

  • Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
  • Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2017.
  • Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
  • Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.
  • Used SSIS and T-SQL stored procedures to transfer data from OLAP and OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
  • Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
  • Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads
  • Migrated all the packages to Test Environment and finally deployed from Test Environment.
  • Designed reports using SQL Server Reporting Services (SSRS).
  • Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
  • Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2017.
  • Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Generating reports though power BI application.
  • Integrated Custom Visuals based on business requirements using Power BI desktop.
  • Using Azure data warehouse for storing the data.
  • Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
  • Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.
  • Worked on TFS for performing tasks.
  • Used GitHub for code repository.

Environment: SQL Server 2014/2016,2017, Windows 2008/2010, MS Access 2000/2003, T-SQL, SQL Server Integration Services(SSIS), SSRS, Crystal Reports, Power BI, Intelligence Server, Azure, Power BI, XML,T-SQL, DAX, MS Access 2010, MS Word, MS Excel, Share point, DTS, GITHUB, C#,Microsoft Visio, Crystal Reports, point, Team Foundation Server, FTP & SFTP server.

Confidential, Deerfield, IL

SQL Server /SSIS/SSRS Developer

Responsibilities:

  • Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
  • Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
  • Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, complex filters and database links.
  • Optimized the performance of queries in SQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
  • Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2008R2.
  • Performed data cleansing by creating tables to eliminate the dirty data and implemented Error Logging using SSIS.
  • Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
  • C# language is used for Script task. Script task is primarily to control the flow of SSIS package.
  • Deploy SSRS report in SharePoint for web-based access for multiple end users.
  • Strong background in Data Warehousing principles and methodologies.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
  • Created customized reports using various chart types like, Text Tables, Bar, Pie, Maps, Line Charts, Pivot Tables, slicers, Do-nut, KPI graph, Filled map Combination Charts in Excel .
  • Worked in Tableau environment to create dashboards like daily, weekly, monthly reports using Tableau desktop and publish them to server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
  • Expansive experience in preparing dashboards using calculated fields, parameters, calculations.
  • Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
  • Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
  • Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),, Visual Studio 2010, MS Excel, Windows XP.,T-SQL, Excel, C#, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SQL Server Profiler 2008, SVN version controlling, Power Pivot and Power View, Tableau.

Confidential, MO

SQL Server/SSIS Developer

Responsibilities:

  • Worked with business stakeholders, application developers, and productions teams and across functional units to identify business needs and discuss solution options
  • Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
  • Created/Updated database objects like tables, views, stored procedures, function, packages.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
  • Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
  • Created Linked servers to connect OLE DB data sources and providers.
  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Foreach Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more.
  • Performed ETL mappings using MS SQL Server Integration Services.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
  • Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job.
  • Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS)
  • Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
  • Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
  • Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
  • Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
  • Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.

Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Windows Server 2008, T-SQL, SQL Profiler, SQL Server Agent, MS Visio, MS Excel, Visual Studio 2010, T-SQL.

Confidential, Detroit, MI

SQL Server Developer

Responsibilities:

  • Gathered user requirements and analyzed and designed software solution and database.
  • Updated functional specification and technical design documents.
  • Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL Server 2008/2008R2.
  • Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
  • Involved in package migration from DTS packages to SSIS packages, running the Microsoft upgrade advisor tool.
  • Implemented the calculations to aggregate physical measures using management studio.
  • Identified and defined the scoped assignments using script commands.
  • Generated reports using SSRS as per business requirements.
  • Designed, Developed and Deployed reports in MS SQL Server 2008/2008R2 environment using SSRS-2008.
  • Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
  • Defined Referenced relationships with the measure groups and fact tables.
  • Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
  • Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
  • Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2008/2008R2, SSIS, SSRS, SSAS, Visual studio 2008, TFS, Crystal Reports, DTST-SQL, Window Server 2003, Erwin 4.0.

Hire Now