Back to Search Results

Lalit R.

MSBI Lead & Developer

Commitment
0/ 5
Competency
0/ 5
Reliability
0/ 5
  • Overall Experience: 14 Years  
  • Amazon Relational Database Service:
  • API Development:
  • Application Lifecycle Management:
  • Application Server:
  • Axapta:
+ More

Lalit R. 

MSBI Lead & Developer

Commitment
0/5
Competency
0/5
Reliability
0/5

Time zones ready to work

  • Eastern Daylight [UTC -4]
  • Eastern European [UTC +2]
  • Central Daylight [UTC -5]
  • Eastern EST [UTC +3]
  • Eastern EST [UTC +3]
  • Dubai [UTC +4]
  • New Delhi [UTC +5]
  • China (West) [UTC +6]
  • Singapore [UTC +7]
  • Hong Kong (East China) [UTC +8]

Willing to travel to client location: May be  

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,
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 etc.). I have worked extensively on all phases of Software Development Life Cycle ensuring high quality, error-free production releases. I have got varied experience in development of applications for different domains such as Health Care, Insurance policy collection system, Mirror Cloud, Shipping and banking domain and have worked prestigious client MetLife Mexico Insurance client, Sandlot and NTSP. I have been leading MSBI development team Since Sept. 2014 and have been in Mexico for 6 Month at Client (Metlife) for requirement gathering. my daily activity to communicate with client regarding new features requirement and existing feature changes and explain to same team for function and technical level. My core responsibilities to create bridge between client and development team to complete work on time.
Show More

Interview Videos

Signup to see videos

Risk-Free Trial, Pay Only If Satisfied.

Portfolios

MOC(Metlife office collection)

Website Link:

Role:

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 privat

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

Skills: SQL

Tools: SVNJIRA

Provider MDS UI

Website Link:

Role:

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 Deployme

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

Skills:

Tools: TFS

EDI 837 Insitution and Professional

Website Link:

Role:

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 informat

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

Skills:

Tools: SVNJIRA

Guruaid

Website Link:

Role:

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 managem

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

Skills: MySQL

Tools: Jira softwareSVN

länsförsäkringar

Website Link:

Role:

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.
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.

Skills:

Tools:

+ More

Employment

software specialist

2014/09 - 2019/05

Skills:

Your Role and Responsibilities:

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 etc.). I have worked extensivel

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 etc.). I have worked extensively on all phases of Software Development Life Cycle ensuring high quality, error-free production releases. I have got varied experience in development of applications for different domains such as Health Care, Insurance policy collection system, Mirror Cloud, Shipping and banking domain and have worked prestigious client MetLife Mexico Insurance client, Sandlot and NTSP.

Show More

senior software engineer

2012/10 - 2014/08

Skills: MySQL

Your Role and Responsibilities:

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 managem

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

software engineer

2012/02 - 2012/09

Skills: SQL

Your Role and Responsibilities:

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

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

software engineer

2011/02 - 2012/02

Skills:

Your Role and Responsibilities:

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 age

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

software support engineer

2010/12 - 2011/02

Skills:

Your Role and Responsibilities:

I worked as software support engineer and worked Sql server and cyrstal report service. Visted on various client location to support shipping import, export and account software.

I worked as software support engineer and worked Sql server and cyrstal report service. Visted on various client location to support shipping import, export and account software.

+ More

Education

2007 - 2008

2007 - 2008

2006 - 2007

2009 - 2010

- 2006

- 2003

- 2001

US work authorization

Are you legally authorized to work in the United States? Yes

Do you or will you require sponsorship for a US employment visa (e.g. H-1B)? Yes

Skills

Amazon Relational Database Service API Development Application Lifecycle Management Application Server Axapta
+ More

Tools

Power BI

Hobbies

I like playing cricket and read books.

Achievements

I have achived two times stellar award in Majesco ltd. I have B1/B2 USA Busin visa.

Certification

completed SQL server and .net certification in 2009 from NIIT institute.

Preferred Languages

English - Fluent