Durgadevi J.

Durgadevi J.

SQL Server/BI Developer

New Delhi , India

Experience: 5 Years

Durgadevi

New Delhi , India

SQL Server/BI Developer

13200 USD / Year

  • Immediate: Available

5 Years

Now you can Instantly Chat with Durgadevi!

About Me

Having 5+ Years of Professional experience in IT industry, Involved in MSBI projects with extensive usage of TSQL, MSSQL, ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Repor... & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Report Service (SSRS).

  • Having Good experience in writing SQL queries, Stored Procedures, Triggers, Views, Constraints, Functions, Indexes, Schedulers and Performance Tuning.
  • Having much experience in DB activities like Data Manipulation, Data Querying, ;.’
  • Data Transaction, Data Definition, Data Pivoting, Data Validations, Data control and Consistency.
  • Worked on Schema, Tables, Cursors, Deadlocks, Common Table Expression, sequences and SQL Server Profiler.
  • Proven proficiency in Granting resources, privileges, T-SQL queries, Ranking functions, Derived tables and Table Partitions.
  • Hands on Experience in dynamic SQL, Exception Handling, Maintaining the Log and Audit information in the SQL tables.
  • Hands of experience in creation of work flows with Tasks, SQL Job Agent and various Transformations and Scheduling jobs using TSQL and the Reports Weekly and Monthly basis as per the Client Requirements.
  • Having much experience in DB activities like Data Manipulation, Data Querying, Data Transaction, Data Definition, Data Pivoting, Data Validations, Data control and Consistency using TSQL.
  • Worked extensively on Data Extraction, Transforming and Loading the data by using SSIS.
  • Proven proficiency in Data Transformations to load data into Data Warehouse, Data Analysis using MDX Queries and Maintaining the Log and Audit information in the SQL tables.
  • Have worked in multiple projects as BI Developer in Designing ETL Packages and Reports in development and implementation stages of the Projects.
  • Hands of  experience  in  creation  of  work  flows  with  Tasks, Containers and various Transformations and Scheduling jobs using TSQL and  the Reports Weekly and Monthly basis as per the Client Requirements.
  • Proficiency in using Visual studio Data Tools (SSIS, SSRS, SSAS), SQL Server 2012 and SQL Server 2014.
  • work ethics and interpersonal skills that help in communicating with the fellow team members, Managers, Developers and Users. Ability to handle multiple tasks and work independently as well as in a team.
  • Having motivated, hardworking, able to meet tight deadlines, thorough in project completion and possess excellent communication and analytical skills.
  • Good interpersonal and communication skills, commitment, result oriented, and zeal to learn new technologies and   undertake challenging tasks.
  • Expertise in Financial Domain areas that include Mutual Funds and Insurance.
  • Expensive experience in meeting demanding deadlines and delivering critical solutions on various levels of Client expectation.
  • Excellent Technical and Analytical skills with clear understanding of design goals of ER Modelling for OLTP and dimension modelling for OLAP.
  • Advanced knowledge on Relation database, Logical and Physical Data Modelling Using Normalization Techniques.

Show More

Positions

Portfolio Projects

Flow Serve

Company

Flow Serve

Role

Backend Developer

Description

FLOWSERVE is a pipe manufacturing company which maintains different plants in different areas. This system maintains SAP tool to integrate all process from designing, manufacturing and delivering process of the supplies. The ERP tool is maintained the total process in all those area’s and the employee details also.
 

Show More Show Less

Skills

SQL

Quantum mutual funds

Company

Quantum mutual funds

Description

Mutual fund is a professionally-managed investment scheme, usually run by an asset management company that brings together a group of people and invests their money in stocks, bonds and other securities. the mutual funds are registered with SEBI. They function within the provisions of strict regulation created to protect the interests of the investor.The biggest advantage of investing through a mutual fund is that it gives small investors access to professionally-managed, diversified portfolios of equities, bonds and other securities, which would be quite difficult to create with a small amount of capital.Quantum is one of the Mutual fund Company which allows investors to invest amount in Mutual funds. In this they provide different sections for investors to invest amount in different ways. Not only insertion, they provide Transfer investments from one fund to another fund. They provide services like whenever user wants to withdraw amount that will be redeemed with in the allocated working days.
 

Show More Show Less

Sonaco Analytics

Company

Sonaco Analytics

Description

  Sonoco is one of the major leaders in paper selling products in Canada and USA.   This system allows the management to extract their financial figures and to draw strategic decisions to improve the business.
 

Show More Show Less
Share: