Tek07717

SQL DEVELOPER - 5 + Year


BTech

Highlights

  • Having 5+ Years of Experience in the area of Microsoft Business Intelligence and good knowledge in Data Warehousing application and used Microsoft SQL Server 2008 R2/2012/2016.

  • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables and giving relations, on database Tables.

  • Experience in Designing Database Objects like Tables, Constraints, Views, Joins etc.

  • Experience in writing, optimizing Stored Procedures, User Defined Functions, Common Table Expressions (CTE), Cursors, Temporary Tables and Table variables, indexes, Sub Queries etc.

  • Working experience in SQL Server for creating Stored Procedure.

  • Experience in administration task like Shrink, Backups & Restores SQL Server databases.

  • Experience in database Migration from one server database to another server database.

  • Expertise in Data Extraction, Transformation and Loading from SQL Server, Excel and flat files using SSIS.

  • Implemented Checkpoints and Breakpoints at package level.

  • Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task in Designing packages

  • Extensively used Data Conversion, Aggregate, Row Count, Lookup, Fuzzy Lookup, Merge Join, Merge, Union all, Multicast, Conditional split, Derived column, Sort, Transformations to load data into Data Warehouse.

  • Skilled in implementing initial data loading by Bulk Insert Task, Fast Load, as well as incremental data loading by techniques such as Slowly Changing Dimensions (SCD).

  • Involved in performance tuning at SQL Server and Integration Services.

  • Possess experience in translating new ideas into client’s solutions including opportunity identification, providing high availability solutions, delivery, support, documentation.

  • Ability to work as a good team member and as an individual team player.


Skills
Primary Skills
  • SQL

Secondary Skills
  • SSRS
Other Skills
  • Language              : SQL, T-SQL
  • Database              : MS SQL Server 
  • ETL                  : Integration Services (SSIS)
  • Reporting                         : BIRT,PowerBI
Projects

Project 1. Santander - IT Industry (25 months)

    DESCRIPTION:

    Santander UK is one of the leading personal financial services companies in the United Kingdom, and one of the largest providers of mortgages and savings in the United Kingdom. The bank has 20,000 employees, 14 million active customers, 64 corporate business centers.

    Here our role will be directly working with the clients on banking data. We Build SQL Scripts and BIRT reports based on the provided requirements by extracting excel formulas.

    Roles & Responsibilities:




    • Will coordinate with clients over calls for gathering requirements and will receive requirement document.

    • Once received the requirement will start extracting formulas from excel and implementing SQL code in multiple scenarios to match the provided values.

    • Development with testing of SQL code completed will be sending the same for review of data to client. Will continuously working with client over the call un till the requirement is fulfilled.

    • Will also involve in giving solutions on their POC requirements.

    • Once SQL code is feezed after their review by checking data. Will start working on reporting using BIRT Tool

    • Will design the reports based on provided deign document with necessary aggregations and which is used for banking purposes like Bank statements, Cheques etc.

    • Once development of reports completed will send for review until signoff as we work on continuous updates amendments.

    • Daily will be updating the status in tracker and attending in status calls.



    Environment: MS SQL Server, BIRT TOOL(Reporting), MS Excel.

         


Project 2. NL Greenfield Data Migration - IT Industry (19 months)

    Description: -

                 Manpower Group has been a world leader in innovative labor market solutions since 1948. We create and deliver high-impact solutions. In doing so, we help organizations achieve their business goals and improve their competitive position. Under the umbrella of Manpower Group, each brand has its own talent specialization. Because we enter a conversation from The Human Age, we have a range of visionary and operational answers and we know how to connect our specializations in a smart way. Our total proposition offers an answer to every HR-related issue.

    ROLES AND RESPONSIBILITIES:




    • Involved in database design, creating tables, writing stored procedures.

    • Migrating data from sales force environment to SQL Server.

    • Created complex Stored Procedures, sub queries, functions and other SQL joins and statements for applications by using T-SQL. 

    • Extensively used various SSIS control flow tasks like Loop Containers, Script, Bulk insert task, File system task, Data flow task, etc. and different data flow tasks like Conditional split, Derived Column, merge join, Multicast, Union all, data conversion etc. 

    • Implemented Event Handlers and Error Handling in SSIS packages and notified process results.

    • Deploying and Configurations in SSIS packages and mode of deployment is SQL Server.



    Environment:

     SQL Server 2014/2016, SQL, T-SQL, SSIS.


Project 3. Health Insurance - Medical Industry (16 months)

    Description:  

    Standard life is health insurance policy-based UK Company and Discovery is South Africa based company. Standard life is health insurance and they have policy system and claim system applications. Then after Discovery has bought some of share from Standard life and started their own business in UK and created their own platform with new application and named as Pruhealth. In Pruhealth they didn’t use any standard life application. They keep everything new and they build application. After that Discovery has bought all the shares from Standard life and acquired all the business and renamed Pruhealth as Vitality.

    Roles & Responsibilities:




    • Designed and developed SQL Server Integration Services (SSIS) Packages to import and export data from MS Excel, SQL Server and Flat files.

    • Involved in complete SQL Server Integration Services (SSIS) life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

    • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

    • Involved in ETL architecture enhancements to increase the performance using query optimizer.

    • Implemented Event Handlers and Error Handling in SSIS packages.

    • Created SSIS packages for Data Conversion using data conversion transformation.

    • Coordinated with front-end for implementing logic in stored procedures and functions.

    • Experienced in writing complex SQL Queries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.

    • Involved in upgrading from SQL Server 2008R2 to SQL Server 2012.

    • Advised optimization of queries by looking at Execution Plan for better tuning of the database



    Environment: 

                  Microsoft SQL Server 2008R2/2012/2016, SQL, T-SQL, SSIS.


Similar Talent