Tek07716

SQL DEVELOPER - 5 yrs


BTech

Highlights

  • Over 4.3 years of experience in Microsoft Business Intelligence (SSIS, SSRS) Development and SQL Database Development using SQL Server 2008R2/2012/2015/2019.

  • Understanding Business Specification document/Source map document for creating Packages and Reports.

  • Experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).

  • Excellent in High level Design of ETL, DTS package for Integrating data from heterogeneous sources (Excel, CSV, flat file, Text format Data)

  • Proficient in implementing all transformations available on SSIS Toolbox.

  • Expertise in creating Sub-Queries and Joins for complex queries involving multiple tables, Error handling and Exception Handlers.

  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

  • Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.

  • Expertise in designing reports like Cascading Parameters, Drill-down Reports, Drill-Through Reports, Parameterized Reports and Sub Reports using SQL Server Reporting Services (SSRS).

  • Expert in Creating and Deploying SSRS Reports and report models on the Report Manager for user accessibility.

  • Having knowledge on Data Warehousing concepts and BI concepts.

  • Experience in Creating Tables, Views, Triggers, Stored Procedures and other T- SQL statements for various applications.

  • Ability to work independently and as a team with a sense of responsibility, dedication, commitment and with an urge of learning new technologies.

  • Proficient in calling SSIS packages using PowerShell script.


Skills
Primary Skills
  • SSRS

Secondary Skills
  • SQL
Other Skills
  • Databases    SQL Server 
  • ETL Tool    SQL Server Integration Services (SSIS)
  • Reporting Tool    SQL Server Reporting Services (SSRS)
  • Languages    SQL, T-SQL
Projects

Project 1. Long Duration Targeted Improvements (LDTI) - IT Industry (43 months)

    Client Description:



                        MetLife is a Life Insurance Company. The Company is extended in worldwide, The Business Extended nearly 50 Country’s in the world. Mainly the company deals with life insurances. In those different types of modules like Auto, Home, Dental, Life, Disability Vision, Accident Health. They have different type’s policies on different products. They are maintained all the customers’ data to build the data warehouse and generating repots for decision making.



    Project Description:



    This project (LDTI) describes about the FASB issued Accounting Standards update 2018-12, Targeted improvements to the Accounting for Long Duration Contracts (LDTI) which changes the accounting and disclosures for products subjects to it. LDTI revises key elements of the measurement models and disclosure requirements for long duration contracts. The Accounting implementation Management program has been created to manage the implementation of the LDTI and to deliver financial statements by the dates required to it.



    Contribution



    Roles & Responsibilities




    • Developed ETL packages according to the Business requirements.

    • Extensively working data Extraction, Transformation and Loading from source to target system using SQL server Integration Services.

    • Implemented several transformations like Lookup, Derived Column, Union All and Data Conversion.

    • Created Configurations, Checkpoints and Breakpoints.

    • Created Event Handlers and logging for tracking errors and maintaining logs and recording scripts execution status.

    • Developed Power shell scripts such a way for Packages to run in all environments like Development, QA and Production.

    • End to End testing of the packages in development environment before proceeding to Higher environments 

    • Prepared Unit test cases for the Packages.

    • Document and maintain all documents in share point repository.

    • Design, development and Testing of the forms of the module.


Project 2. Analysis of Earnings (AOE) - IT Industry (7 months)

    Description:



          The solvency II quarterly Analysis of Earnings is required to explain the movements in the SII (solvency position) between two different quarters. This is not a regulatory requirement however is a key tool to improve the understanding of the deviation between actual and expected experience. Calculating the Risk margin Value. AOE uses 3 sets of primary data that is Actuarial, Finance and Investment to support AOE calculation.



    Contribution



    Roles & Responsibilities




    • Developed ETL packages according to the Business requirements.

    • Extensively working data Extraction, Transformation and Loading from source to target system using SQL server Integration Services.

    • Implemented several transformations like Lookup, SCD, Derived Column, Union All and Data Conversion.

    • Created Configurations, Checkpoints and Breakpoints.

    • Created Event Handlers and logging for tracking errors and maintaining logs and recording scripts execution status.

    • Migrated Packages from Lowe environment like BIDS-2008 to Higher environment like SSDT-2015

    • Prepared Unit test cases for the Packages.

    • Developed Power shell scripts such a way for Packages to run in all environments like Development, QA and Production

    • Document and maintain all documents in share point repository

    • Design, development and Testing of the forms of the module.

       


Awards
N/A

Similar Talent

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View