Lalit R.

Lalit R.

MSBI Lead & Developer

Badlapur , India

Experience: 10 Years

Lalit

Badlapur , India

MSBI Lead & Developer

32775.2 USD / Year

  • Notice Period: Days

10 Years

Now you can Instantly Chat with Lalit!

About Me

I am a highly organized and accurate professional with over 9.5 years experience in leading development and design of SSIS packages, SSRS report using MSBI technologies, MDS and SQL scripts (procedure, function, Cursor trigger, views, optimizations e...

Show More

Portfolio Projects

Description

I am working as a Software Specialist for client Metlife insurance Mexico in Majesco LTD.

MetLife is life insurance company, offering life insurance and retirement savings products, medical expense insurance, and investment products to groups and individuals in the private market.

We are providing to MetLife, policy bill collection system which will help to reduce to time of execution of payment system and will analyses bank and its available time. And it will also help to improve efficiency and effectiveness of payment of policy.

Show More Show Less

Description

I was responsible for data migration process of MDS entities into Provider Management tool for NTSP client. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Task:-

  • Provides solution for Creating Deployment sql Scripts for application/unit deployment.
  • Plan, design and implement database code objects, such as Creation of Tables, Constraints, Adding Indexes on required attributes ,Stored Procedures, User Defined Functions (UDFs),complex query, query tuning.
  • Provides solution for Performing necessary query optimization on the Queries.

Show More Show Less

Description

SANDLOT was US based IT company which worked on helth care domain. they haveEDI 837 Insitution and Professional project.

TheEDI 837transaction set is the format established to meet HIPAA requirements for the electronic submission of healthcare claim information.

The claim information included amounts to the following, for a single care encounter between patient and provider:

  • A description of the patient
  • The patient’s condition for which treatment was provided
  • The services provided
  • The cost of the treatment

This information in the form of EDI Format was required to be migrated into the database.

Show More Show Less

Description

I worked as a Senior Software Engineer for Guruaid technical Solution project which mission is to make hardware and software purchase easy and less confusing. I was Responsible for design and development of SSRS report, SSIS ETL and SQL Scripts like “data warehouse create and manage for management requires reports for analysis business”. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Show More Show Less

Description

I am working as a Senior cosultant for client länsförsäkringar for Insurance domain in Majesco LTD. Länsförsäkringar, or literally County Insurance, is a Swedish group of customer owned insurance companies.

Show More Show Less

Description

I am working as a Software Specialist for client Metlife insurance Mexico and my previous project was Sandlot and NTSP for Health care domain in Majesco LTD. MetLife is life insurance company, offering life insurance and retirement savings products, medical expense insurance, and investment products to groups and individuals in the private market. We are providing to MetLife, policy bill collection system which will help to reduce to time of execution of payment system and will analyses bank and its available time. And it will also help to improve efficiency and effectiveness of payment of policy. I am responsible for communicate with customer to get proper requirements and understand to current issues in system and handling development team which involved data movement from transaction database to EDW database for reporting and analysis purpose using SSIS. The EDI 837 transaction set is the format established to meet HIPAA requirements for the electronic submission of healthcare claim information. The claim information included amounts to the following, for a single care encounter between patient and provider: A description of the patient The patients condition for which treatment was provided The services provided The cost of the treatment This information in the form of EDI Format was required to be migrated into the database. I was responsible for data migration process of MDS entities into Provider Management tool for NTSP client. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Show More Show Less

Description

I am working as a Software Specialist for client Metlife insurance Mexico and my previous project was Sandlot and NTSP for Health care domain in Majesco LTD. MetLife is life insurance company, offering life insurance and retirement savings products, medical expense insurance, and investment products to groups and individuals in the private market. We are providing to MetLife, policy bill collection system which will help to reduce to time of execution of payment system and will analyses bank and its available time. And it will also help to improve efficiency and effectiveness of payment of policy. I am responsible for communicate with customer to get proper requirements and understand to current issues in system and handling development team which involved data movement from transaction database to EDW database for reporting and analysis purpose using SSIS. The EDI 837 transaction set is the format established to meet HIPAA requirements for the electronic submission of healthcare claim information. The claim information included amounts to the following, for a single care encounter between patient and provider: A description of the patient The patients condition for which treatment was provided The services provided The cost of the treatment This information in the form of EDI Format was required to be migrated into the database. I was responsible for data migration process of MDS entities into Provider Management tool for NTSP client. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Show More Show Less

Description

I am working as a Software Specialist for client Metlife insurance Mexico and my previous project was Sandlot and NTSP for Health care domain in Majesco LTD. MetLife is life insurance company, offering life insurance and retirement savings products, medical expense insurance, and investment products to groups and individuals in the private market. We are providing to MetLife, policy bill collection system which will help to reduce to time of execution of payment system and will analyses bank and its available time. And it will also help to improve efficiency and effectiveness of payment of policy. I am responsible for communicate with customer to get proper requirements and understand to current issues in system and handling development team which involved data movement from transaction database to EDW database for reporting and analysis purpose using SSIS. The EDI 837 transaction set is the format established to meet HIPAA requirements for the electronic submission of healthcare claim information. The claim information included amounts to the following, for a single care encounter between patient and provider: A description of the patient The patients condition for which treatment was provided The services provided The cost of the treatment This information in the form of EDI Format was required to be migrated into the database. I was responsible for data migration process of MDS entities into Provider Management tool for NTSP client. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Show More Show Less

Description

I am working as a Software Specialist for client Metlife insurance Mexico and my previous project was Sandlot and NTSP for Health care domain in Majesco LTD. MetLife is life insurance company, offering life insurance and retirement savings products, medical expense insurance, and investment products to groups and individuals in the private market. We are providing to MetLife, policy bill collection system which will help to reduce to time of execution of payment system and will analyses bank and its available time. And it will also help to improve efficiency and effectiveness of payment of policy. I am responsible for communicate with customer to get proper requirements and understand to current issues in system and handling development team which involved data movement from transaction database to EDW database for reporting and analysis purpose using SSIS. The EDI 837 transaction set is the format established to meet HIPAA requirements for the electronic submission of healthcare claim information. The claim information included amounts to the following, for a single care encounter between patient and provider: A description of the patient The patients condition for which treatment was provided The services provided The cost of the treatment This information in the form of EDI Format was required to be migrated into the database. I was responsible for data migration process of MDS entities into Provider Management tool for NTSP client. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Show More Show Less

Description

I worked as a Senior Software Engineer for Guruaid technical Solution project which mission is to make hardware and software purchase easy and less confusing. I was Responsible for design and development of SSRS report, SSIS ETL and SQL Scripts like data warehouse create and manage for management requires reports for analysis business. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Show More Show Less

Description

I worked as a Software Developer for EDS One Window project it was government bank domain project which provide banking on village areas in India. I was Responsible for design and development of SSRS report, SSIS ETL and SQL Scripts. I also provided optimized solution for ETL data loading process and sql script execution time and below other activity.

Show More Show Less

Description

I worked as a Software Developer for Mirror Cloud Project. Mirror Cloud is an add-on technology to the Smart Style Computing platform, which Provides business continuity and data restoration for existing physical or virtual Windows servers. Mirror Cloud is a lightweight software agent, which Mirrors the contents of the Windows machine to a Smart Style environment on a near Real-time basis.

Show More Show Less