We provide IT Staff Augmentation Services!

Data Modeler Resume

SUMMARY

  • Over 11.4 year’s diverse experience, implementing Business Intelligence and Enterprise Information Management solutions across multiple industry sectors mainly Health Insurance, Specialty Insurance, Information Technology and Retail.
  • Experienced IT Technical Lead and a Data Architect with excellent leadership skills and a highly analytical focus.
  • Strong development experience in Data warehouse, Data Architecture, Data integration and reports development using Microsoft BI technologies.
  • As a Data Architect, owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for Parallel Data warehouse (PDW).
  • Gathered business requirements, worked closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
  • Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
  • Created the mapping, extracting and translation documents from multiple sources like Oracle, Teradata, cubes to PDW and SQL Server 2012 for the engineering data.
  • Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms, Oracle to PDW databases, flat files to PDW.
  • Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
  • Expert in Microsoft BI stack like SSIS, SSRS and MS SQL Server 2015 and Parallel Data warehouse (PDW).
  • Experience in generating Data visualization and BI reporting solutions in Power BI
  • Good hands on experience with Azure SQL Data Warehouse and MPP to run high - performance analytics.
  • Experience in Data Migration from on-premises SQL Server to Azure SQL Database using Azure Data Factory and Polybase for data migration from on-premises PDW to Azure SQL DWH.
  • TSQL - Advanced SQL Programing, Stored Procedures, Functions, Tables, Views, Index, Backup/ Restore, Maintenance.
  • Database administration and Support - MS SQL Server 2008R2 / 2012 / 2015.
  • Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules, XML file generation and data quality.
  • Worked on all activities related to the development, implementation and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
  • Worked in Agile environment using SCRUM.

TECHNICAL SKILLS

  • Data Modeling Tools - CA Erwin
  • Business Intelligence Development Studio - DTS - SSIS 2008 & 2012 - SSRS 2008 & 2012
  • T-SQL - SQL Server 2000, 2005, 2008R2, 2012 & 2015
  • Data Warehouse Development - PDW 2015
  • Microsoft Azure SQL Data Warehouse - Azure SQL Database, Azure SQL DWH- MPP
  • Search Engine - Elasticsearch
  • MI - BI - Data Warehousing - ETL - Financial Services - Reporting
  • Data Visualization - Power BI
  • Visual Studio 2008, 2012 & 2015 - C# - ASP.Net
  • Data Migration/ Deployment - TFS - Subversion (SVN) - GitHub - CI/CD – Jenkins
  • Agile Methodology - Rally
  • Windows 2008 Server - Windows 2012 Server - Windows XP - Windows 7 - Windows 8 - Windows 10

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler

Responsibilities:

  • Design and develop SQL Server Databases, SQL Data Warehouses and Multidimensional Databases with Star schema and responsible to implement effective database solutions and models to store and retrieve data related to property and casualty insurance and reinsurance data
  • Develop strategies for data acquisitions, archive recovery, and implementation of a database with MSSQL server.
  • Design logical and physical data models using best practices to ensure high data quality and reduced redundancy with data modeling tools - SAP PowerDesigner and CA ERwin.
  • Design Use Case, Technical Design Documents (TDD), Mapping documents, DLD, Interface diagrams /models and Activity /Sequence /Deployment diagrams for the interfaces.
  • Design data warehouse and development of the ETL solution packages with SSIS and Informatica as preferred ETL tool to ensure the optimized flow of data and adhere to the existing Organization ETL Framework.
  • Design Data analysis by writing TSQL complex queries and stored procedures and understanding business requirements from SMEs and Business Analysts. Liaising with business users for data extraction. Preparing source to target document
  • Implement several DAX functions for various fact calculations for efficient data visualization in Power BI
  • Monitor the system performance by performing regular tests using SQL Profiler, troubleshooting and integrating new features. Identify risks, communicate status to all stakeholders
  • Manage the migration of data from on premises SQL server legacy systems to SQL Data Warehouse and various Data associate problems such as system configuration and integration on multiple platforms.
  • Manage Bulk insert of large volume of data with BCP utility and Bulk Insert Copy into SQL Data warehouse
  • Administer mapping of all data sources and movement and analyze it to ensure appropriate quality of all data.
  • Co-ordinate Application Development team to implement data strategies, build data flows and develop conceptual data models.
  • Co-ordinate with Data Governance team to ensure that data policies are aligned throughout the organization and develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
  • Analyze data-related system integration challenges and propose appropriate solutions.
  • Analyze data using statistical techniques and provide ongoing reports using Power BI Data Visualization tool.

Technologies: SQL Server 2017, SSIS, TFS, Erwin, Informatica

Confidential

Data Architect Analyst, Technical Lead

Responsibilities:

  • Ensured the Engineering team developed and delivered high-quality working Features to customers.
  • Actively participated in all the leadership meetings to report on the development and delivery progress of the team.
  • Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy with data modeling tool ERwin.
  • Work directly with the Data Governance team to ensure that data policies are aligned throughout the organization and develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
  • Data analysis and understanding business requirements from SMEs (BA’s). Liaising with business users for data extraction. Preparing source to target document.
  • Worked with Solution Architect on dimensional modelling and making recommendations on design. Also worked with SMEs to understand business requirements.
  • Build of data warehouse and development of the ETL solution using SSIS as the preferred ETL tool, and adhere to the existing corporate ETL Framework. Bulk insert of large volume of data with DWLoader.
  • Created ETL packages to migrate data from various legacy sources to target applications.
  • Created daily load packages mainly with transformations like Lookup, Derived Column, Data Conversion and tasks like ForEach, ForLoop, Execute SQL Task, Execute Package Task.
  • Worked on deployment of SSIS packages into application server.
  • Handled Data migration from on-premises SQL Server to Azure Sql Database through Azure Data factory and used Polybase for migrating huge tables from PDW to Azure SQL DWH.
  • Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments.
  • Authored and Optimized stored procedures, queries and views by looking at Execution Plan for better tuning of the database.
  • Embedded Power BI reports into the Data load process for generating the statistics on ETL loads that helped to evaluate performance.
  • Migrated existing self-service reports and adhoc reports to Power BI.
  • Manage release cycles to different environments i.e. TEST, UAT, PROD change requests and defect resolutions. Also assisted Quality Engineers with data reconciliation.
  • Expertise in working with TFS, SVN and GitHub.
  • Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks that increased Program delivery.
  • Expertise in implementing Agile methodology using Rally tool..

Technologies: PDW 2015, SQL Server 2012, SSIS, SSRS, DWLoader, TFS, Erwin, Azure SQL DW, Azure SQL Server, Azure Data Factory, Azure PowerShell cmdlts.

Confidential

Senior Software Engineer

Responsibilities:

  • Interacted with business users, clients and used existing documents for collecting and analyzing new business requirements.
  • Responsible for converting the Reinsurance data from Data Warehouse into PIJ screens.
  • Developed stored procedures, user defined functions and views using T-SQL.
  • Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Develop and ensure adherence to locally defined standards for all developed components Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Develop and ensure adherence to locally defined standards for all developed components Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Develop and ensure adherence to locally defined standards for all developed components Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities.
  • Develop and ensure adherence to locally defined standards for all developed components
  • Optimized queries and views by looking at Execution Plan for better tuning of the database.
  • Worked on different kinds of Transformations in SSIS as per the client’s Requirement.
  • Created ETL packages to migrate data from various legacy sources to target applications.
  • Worked on deployment of SSIS packages into application server.
  • Experience on Data Loading into DWH and DM tables using BIReady.
  • Having good experience on working with CSC Point INJ application
  • Worked on BCP commands to import and export the data using command line
  • Reconciliation of Financial and Non-Financial converted data into the new claims system.
  • Documented steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production.
  • Worked on the validation management utility, which validated the data across multiple stages like SLS, BLS, DM and TLS.
  • Good Working experience with VSTS.

Technologies: BI Ready tool, SQL Server 2008 R2, SSRS, SSIS

Confidential

Senior Software Engineer

Responsibilities:

  • Responsible for converting the Reinsurance data from PIJ screens to EDW
  • Developed stored procedures, user defined functions and views using T-SQL.
  • Generated Financial and Non-Financial ITD/MTD reports on the Reporting Mart.
  • Automated the back-feed workflow using SSIS packages which involved different kinds of Transformations.
  • Worked on deployment of SSIS packages into application server.
  • Experience on Data Loading into DWH and RDM tables using BIReady.
  • Used SQL Server profiler to debug the Point INJ application issues. This UI is used for managing the Management/administration
  • Created reports based on the Validation query results using SSRS.
  • Created tasks and bugs using VSTS to track the issues/resolutions and actively involved in resolving bugs raised by the QA/BA teams.

Technologies: BI Ready tool, SQL Server 2008 R2, SSRS, SSIS, Query Analyzer, DTS.

Hire Now