We provide IT Staff Augmentation Services!

Sql/ssis/etl/data Wearhouse Developer Resume

PROFESSIONAL SUMMARY:

  • Around 6 of experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle(SDLC) using MS SQL Server 2017/2 /2008 R 2/2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
  • Extensive SQL Development experience in Banking, Insurance, Healthcare, Telecommunication and Transportation industries with a strong understating of data & analytics.
  • Extensive experience in MS SQL Server 2014/2012/2008 R 2/2008/2005/2000, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Developing reports on SSAS & SSRS on SQL Server (2005/2008 R2/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management.
  • Highly proficient in the use of T - SQL for developing stored procedures triggers and various database objects.
  • Proficient in T-SQL programming
  • Well versed in OLTP Data Modeling, Data warehousing concepts.
  • Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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 etc...
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
  • Experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc
  • Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
  • Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014 , calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions
  • Expertise in building data warehouses based on star or snowflake schemas, data marts, and staging areas.
  • Proficient with SQL Reporting Services 2005/2008R2/2012 such as, building tabular report, matrix report, chart report, parametric reports, linked reports using report designer/report builder 3.0.
  • Implemented high availability with Azure Classic and Azure Resource Manager deployment models
  • Expertise in creating complex reports like Drill Down and Sub Reports using SQL Server Reporting Service (SSRS).
  • Experience in executing software lifecycles such as Agile (Scrum), RUP Iterative Model, Incremental Model, Waterfall and Object-oriented Methodologies.
  • Extensively used ASP.NET Data Grid, Data List, Repeater controls and Telerik controls for displaying the data in a clear format
  • Develop solutions and tweak business processes as needed using SQL Stored Procedures, VB. NET, C#, and VBA
  • Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension
  • Extensive knowledge of data warehousing concepts and data integration.

TECHNICAL SKILLS:

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, C, C++ Java, J2EE, ASP.NET,C#.NET,VB.NET,HTML 4.0, DHTML,XML

Databases: SQL Server 2012/2008 R 2/2008/2005/2000, SharePoint, Oracle 9i/8.x, DB2, MS Access

Reporting Tools: SQL Server 2012/2008R2/2005 Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS (SQL Server 2005/2008/2008 R2, 2012,2015 Integration Services),SQL Server 2000 DTS, Import Export Data, Bulk Copy Program (BCP)

MS Office: 2010/2007/2003/2000, MS Project Adobe Professional.

Operating Systems: Windows (updated to 2012), MAC OSX Tiger/Leopard, Unix, Linux (Ubuntu updated to 12.04)

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential

SQL/SSIS/ETL/Data Wearhouse Developer

Responsibilities:

  • Reviewed requirements in meetings with SMEs and product owner.
  • Collaborated with data quality team to resolve issues with data in sources.
  • Designed and implemented complex views on data mart with higher granularity levels.
  • Developed complex SQL scripts and procedures to handle data manipulation requests from different users.
  • Developed data access routines such as stored procedures and views with optimized performance.
  • Created TSQL scripts with conversion functions such as TRY CONVERT, TRY CAST, CAST and CONVERT.
  • Worked with very huge tables and partitioned them to improve I/O operations..
  • Extracted data from OLTP tables to load newly created dimensions and fact tables utilizing SSIS.
  • Created SSIS packages for data validation and cleansing utilizing various transformations.
  • Created efficient ETL strategy for initial and incremental loads utilizing various tasks and transformations in SSIS.
  • Experience in extracting data from heterogeneous systems like csv, Azure Cloud, Excel, XML, text files etc. for performing business operations and applying rules.
  • Extensive experience in designing the Data models for OLTP & OLAP database system
  • Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
  • Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling using tools like Toad Modeler
  • Created Logical & Physical Data Modes using Entity Relationship Diagrams
  • Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design
  • Used various transformations such as Lookups, Multicasts, Pivots, Derived Columns, Merge joins, Conditional splits etc. when data transformations process was done.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS
  • Created ETL packages to validate, extract, transform and load data from various data warehouses to databases/data marts.
  • Configured checkpoints to restart the package from point of failure in SSIS.
  • Analyzed issues with SSIS packages utilizing loggings, data viewers and break points.
  • Maintained different versions of SSIS packages and SQL scripts on TFS.
  • Actively participated in team meetings and inter - departmental workshops to discuss best practices/processes to improve
  • Expert knowledge in SDLC (Software Development Life Cycle) and good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.

Environment: MS-SQL Server 2012/2014/2016, MS-SQL Server Integration Services, Toad Modeler, OBIEE, Azure Data Wearhouse- SQL, BIML Tool, Team Foundation Server (2012), Team Foundation Server (2013)

Confidential, Boston, MA

SQL BI Developer

Responsibilities:

  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
  • Wrote complex T-SQL quires per business requirements.
  • Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and Views to support efficient data storage and manipulation.
  • Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server.
  • Used various transformations such as Lookups, Multicasts, Pivots, Derived Columns, Merge joins, Conditional splits etc. when data transformations process was done.
  • Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
  • Migrated SSIS packages from SQL 2008R2 to SQL 2012.
  • Played the dual role of Analyst and Developer gathering requirements from VP, analyzing the data and developing SSIS packages and SSRS reports.
  • Developed several Linked, Cache and Ad hoc SSRS reports for Underwriting and Sales departments.
  • Documented and uploaded the design and development of several SSIS packages and SSRS reports in the share point.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
  • Developed SQL Queries and Procedures for storage and retrieval of data using ADO.NET and LINQ to SQL Developed Web Services for user authentication and file transfer
  • Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes
  • Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses
  • All versions of SQL Azure running on Microsoft Azure
  • Shared reports in Power BI service to entire Organization in Office 365.
  • Created several visualizations and featured dashboards using Power BI for Underwriting Team for Fully funded group reports.

Environment: MS-SQL Server 2012/2014, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, VB.NET,ASP.NET,MS-SQL Server Analysis Services, OBIEE,Azure,T- SQL, MDX, Source Safe, Team Foundation Server (2012), Team Foundation Server (2013)

Confidential, Milpitas, CA

SQL BI Developer

Responsibilities:

  • Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for Izenda reports, Tableau reports and SSRS reports. Implemented different types of constraints on tables for consistency.
  • Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server to create final Roster report.
  • Created different SQL jobs and maintained those jobs in the production.
  • Involved in performance tuning using indexing (Cluster Index, Nanocluster index) tables. .
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment
  • Created ETL packages to validate, extract, transform and load data from various data warehouses to databases/data marts.
  • Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes
  • With the help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps etc., that will helpful easily to understand the data.
  • Used various sources to pull data into Power BI such as Sql Server, SAP BW, SQL Azure etc.
  • Created org Hierarchy for the process of authorization and authentication for accessing Tableau reports by end user.
  • Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
  • Developed SQL Queries and Procedures for storage and retrieval of data using ADO.NET and LINQ to SQL Developed Web Services for user authentication and file transfer
  • Experience with Microsoft Azure cloud for multiple clients and customers of General Blue Corporation.
  • Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses

Environment: MS-SQL Server 2012/2008R2/2012/2014, informatica, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, VB.NET,ASP.NET,MS-SQL Server Analysis Services, Azure,T- SQL, MDX, Source Safe, Team Foundation Server (2012), OBIEE, Team Foundation Server (2013)

Confidential, St. Louis, MO

Sr. SQL BI Developer

Responsibilities:

  • Designed relational data base in SQL server for Line Management section. Applied data integrity rules, defined relationships between foreign and primary keys in the tables.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
  • Created stored procedures, Cursors, Joins in T-SQL.
  • Used T-SQL in SQL Server 2012 to develop Stored Procedures, Triggers, Clustered & Non-clustered Indexes, Views, Indexed Views, and User-Defined Functions (UDFs).
  • Generated Reports using Global Variables, report expressions (including simple VB codes) and Functions. Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2008.
  • Created several SSIS packages for extracting data from data bases like SQL, DB2 and load those data into tables in SQL server for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Designed and implemented SSAS Tabular Cube & Multidimensional Cubes as the reporting layer and used DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes
  • Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
  • Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base. Use SQL profiler to identify long running queries.

Environment: MS-SQL Server 2012/2008R2/2012, MS-SQL Server Reporting Services, MS-SQL Server Integration Services, Windows Server 2012, VB.NET,ASP.NET,MS-SQL Server Analysis Services, T- SQL, MDX, Source Safe, Team Foundation Server (2012)

Confidential

Sr. SQL BI Developer

Responsibilities:

  • Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
  • Worked on other packages of the SQL server 2008 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
  • Performed ETL using SSIS by extracting data from various data sources such as MS Access, Excel, Flat files, CVS files and network locations
  • Designed and developed Star and Snow Flake Schema as a data analyst.
  • Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
  • Performed tune to optimize SQL queries using SQL profiler and query analyzer.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2008/2008R2 Reporting Services.

Environment: SSIS, SSRS, SSAS, MS SQL Server 2008 R2, OLAP, ERWIN, Front Office 8.3 / 10.2 / 10.3, Windows 2008, MS Office 2010, TFS 2010

Confidential

SQL BI Developer

Responsibilities:

  • Involved in Migration of SSRS 2005 to SSRS 2008
  • Provided business intelligence support for the applications and systems.
  • Design complex reports like dynamically driven cascade parameterized reports, reports with sub reports, drill through reports using SQL reporting services 2005/2008. Created scorecards, KPIs and dashboards, analytical charts and reports using SharePoint.
  • Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Experience in migrating Visual source safe (VSS) repository to Team foundation server (TFS)
  • Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical reports from SQL/OLAP data sources using SQL Server 2005/2008 Reporting Services.
  • Installed reporting services in production server and deployed reports from development machine to production machines.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. Implemented different types of constraints on tables for consistency.
  • Created SSIS packages for extracting data from data bases like SQL, Oracle and load those data into tables in SQL server.
  • Created SSIS packages to synchronize SQL databases and Analysis Service cubes.

Environment: MS-SQL Server 2005/2008, SharePoint, MS-SSRS, MS-SSIS, MS-SSAS, T- SQL, MDX, Source Safe, TFS, SharePoint, Windows XP Professional, MS Access, MS Excel, Visio, Oracle Server.

Hire Now